biuan SAP® BUSINESS ONE SDK
API TPW2
TPW2 - Payable Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbsolute Entry NoInt
11OTPW
Tax Payment Wizard
PRIMARYYes
LineNumberLine NumberInt
11
TaxCategryTax CategoryInt
11
TaxTypeTax TypeInt
11
PyblAmntPayable AmountNum
20
PyblAmntFCPayable Amount FCNum
20
PyblAmntSCPayable Amount SCNum
20
PLAAmntP.L.A. AmountNum
20
PLAAmntFCP.L.A. Amount (FC)Num
20
PLAAmntSCP.L.A. Amount (SC)Num
20

Table relationship map

SELECT statement

SELECT TPW2.AbsEntry AS 'Absolute Entry No', TPW2.LineNumber AS 'Line Number', TPW2.TaxCategry AS 'Tax Category', TPW2.TaxType AS 'Tax Type', TPW2.PyblAmnt AS 'Payable Amount', TPW2.PyblAmntFC AS 'Payable Amount FC', TPW2.PyblAmntSC AS 'Payable Amount SC', TPW2.PLAAmnt AS 'P.L.A. Amount', TPW2.PLAAmntFC AS 'P.L.A. Amount (FC)', TPW2.PLAAmntSC AS 'P.L.A. Amount (SC)' FROM TPW2 AS TPW2

Related information


TPW2 SQL Table

Tax Payment Wizard OTPW SQL Table



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