biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Documents for Approval - Terms
API WDD2
WDD2 - Documents for Approval - Terms Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WddCode KEY UNIQUEInternal IDInt
11
PRIMARYYes
CondIdCondition No.Int
1) Deviation from Credit Limit
2) Deviation from Commitment
3) Gross Profit %
4) Discount %
5) Deviation from Budget
6) Total Document
11
opCodeRatioInt
1) Greater than
2) Greater or Equal
3) Less than
4) Less or Equal
5) Equal
6) Does not Equal
6
opValueValuenVarChar
40

SELECT statement

SELECT WDD2.WddCode AS 'Internal ID', WDD2.CondId AS 'Condition No.', WDD2.opCode AS 'Ratio', WDD2.opValue AS 'Value' FROM WDD2 AS WDD2

Related information
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