biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / WTax Certificates - Docs in WT Groups
API WTC2
WTC2 - WTax Certificates - Docs in WT Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
BaseLineIdBase Line NumberInt
11
LineIdLine NumberInt
11
DocEntryInternal NumberInt
11
DocObjTypeDoc. Object TypenVarChar
20
VatAmntVAT AmountNum
20
DocTotDoc. Total AmountNum
20
WTBaseAmntWTax Base AmountNum
20
WTAccAmntAccumulated AmountNum
20
WTPercpAmWTax Perception AmountNum
20
WTPercentWTax RateNum
20

SELECT statement

SELECT WTC2.AbsEntry AS 'Internal Number', WTC2.BaseLineId AS 'Base Line Number', WTC2.LineId AS 'Line Number', WTC2.DocEntry AS 'Internal Number', WTC2.DocObjType AS 'Doc. Object Type', WTC2.VatAmnt AS 'VAT Amount', WTC2.DocTot AS 'Doc. Total Amount', WTC2.WTBaseAmnt AS 'WTax Base Amount', WTC2.WTAccAmnt AS 'Accumulated Amount', WTC2.WTPercpAm AS 'WTax Perception Amount', WTC2.WTPercent AS 'WTax Rate' FROM WTC2 AS WTC2

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