biuan SAP® BUSINESS ONE SDK
API WTC1
WTC1 - WTax Certificates - WT Groups in Certificates Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
LineIdRow NumberInt
11
WtAbsEntryInternal NumberInt
11
WTPercentWTax RateNum
20
SumVatAmntSum of VAT AmountNum
20
SumDocTotSum of Doc. Total AmountNum
20
SumBaseAmnSum of Base AmountNum
20
SumAccumAmSum of Accumulated AmountNum
20
SumPercpAmSum of Perception AmountNum
20

SELECT statement

SELECT WTC1.AbsEntry AS 'Internal Number', WTC1.LineId AS 'Row Number', WTC1.WtAbsEntry AS 'Internal Number', WTC1.WTPercent AS 'WTax Rate', WTC1.SumVatAmnt AS 'Sum of VAT Amount', WTC1.SumDocTot AS 'Sum of Doc. Total Amount', WTC1.SumBaseAmn AS 'Sum of Base Amount', WTC1.SumAccumAm AS 'Sum of Accumulated Amount', WTC1.SumPercpAm AS 'Sum of Perception Amount' FROM WTC1 AS WTC1

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