biuan SAP® BUSINESS ONE SDK
SQL Administration / Approval Templates - Terms / Approval Templates - Terms
DTW Administration / Setup / Financials / Branches / Approval Templates - Terms
API Approval Template Terms / Approval Template Term
WTM4 - Approval Templates - Terms Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WtmCode KEY UNIQUECodeInt
11OWTM
Approval Templates		PRIMARYYes
CondIdCondition No.Int
1) Deviation from Credit Limit
2) Deviation from Commitment
3) Gross Profit %
4) Discount %
5) Deviation from Budget
7) Quantity
8) Item Code
9) Total
6) Total Document
10) Counted Quantity
11) Variance
12) Variance %
0
11
0
opCodeRatioInt
1) Greater Than
2) Greater or Equal
3) Less Than
4) Less or Equal
5) Equal
6) Does not Equal
7) In Range
8) Not in Range
0
6
0
opValueValuenVarChar
90

SELECT statement

SELECT WTM4.WtmCode AS 'Code', WTM4.CondId AS 'Condition No.', WTM4.opCode AS 'Ratio', WTM4.opValue AS 'Value' FROM WTM4 AS WTM4

Related information


Approval Template Term ApprovalTemplateTerm Object· Table: WTM4
ApprovalTemplateTerm is a data structure related to the ApprovalTemplatesService. Source table: WTM4.
   Parent: Approval Template Terms ApprovalTemplateTerms Collection· Table: WTM4

Approval Template Terms ApprovalTemplateTerms Collection· Table: WTM4
ApprovalTemplateTerms is a Data Collection of ApprovalTemplateTerm data structures. Source table: WTM4.
   Parent: Approval Template ApprovalTemplate Object· Table: OWTM
Approval Templates OWTM 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