biuan SAP® BUSINESS ONE SDK
SQL Finance / Cash Discount / Cash Discount
DTW Cash Discount
API Cash Discounts Service / Cash Discount
OCDC - Cash Discount Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20
PRIMARYYes
TableDescNamenVarChar
100
ByDateBy DateVarChar
Y) Yes
N) No
1
N
FreightFreightVarChar
Y) Yes
N)
1
N
TaxTaxVarChar
Y) Yes
N) No
1
N
VatCrctnVAT CorrectionVarChar
Y) Yes
N) No
1
N
BaseDateBase DateVarChar
P) Posting Date
S) System Date
T) Document Date
C) Closing Date
1
P

SELECT statement

SELECT OCDC.Code AS 'Code', OCDC.TableDesc AS 'Name', OCDC.ByDate AS 'By Date', OCDC.Freight AS 'Freight', OCDC.Tax AS 'Tax', OCDC.VatCrctn AS 'VAT Correction', OCDC.BaseDate AS 'Base Date' FROM OCDC AS OCDC

Related information


Cash Discount CashDiscount Object· Table: OCDC
Defines a cash discount policy. Source table: OCDC Mandatory properties: Code
   Parent: Cash Discounts Service CashDiscountsService Service· Table: OCDC

Cash Discounts Service CashDiscountsService Service· Table: OCDC
The CashDiscountsService service enables you to add, look up and remove cash discount policies. Each policy specifies a set of discounts and the conditions for applying the discount. To view the current cash discounts, select Administration...

OCDC SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates