|
|
SQL Finance / Cash Discount - Rows
API Discount Lines / Discount Line
CDC1 - Cash Discount - Rows Table
Discount Line DiscountLine Object· Table: CDC1
Parent: Discount Lines DiscountLines Collection
Cash Discount OCDC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CdcCode KEY UNIQUE | Code | nVarChar | 20 | OCDC Cash Discount | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row No. | Int | 11 | |||||
| NumOfDays | Days | Int | 6 | |||||
| Discount | Discount % | Num | 20 | |||||
| Day | Day | Int | 6 | |||||
| Month | Month | Int | 6 |
SELECT statement
SELECT
CDC1.CdcCode AS 'Code',
CDC1.LineId AS 'Row No.',
CDC1.NumOfDays AS 'Days',
CDC1.Discount AS 'Discount %',
CDC1.Day AS 'Day',
CDC1.Month AS 'Month'
FROM CDC1 AS CDC1
Related information
Discount Line DiscountLine Object· Table: CDC1
Defines a single criteria for applying a cash discount, as well as the discount percentage.
Source table: CDC1
Mandatory properties:
Day, Month (if discount is based on the current date)
NumOfDays (if discount is based on payment within a...
Parent: Discount Lines DiscountLines CollectionCash Discount OCDC SQL Table
DiscountLines
Object
DiscountLine
Method
Property
Day
DB
Discount
DB
DiscountCode
DB
LineId
DB
Month
DB
NumOfDays
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
