biuan SAP® BUSINESS ONE SDK
SQL Banking / Utilization and Payment
API TPW3
TPW3 - Utilization and Payment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbsolute Entry NoInt
11OTPW
Tax Payment Wizard		PRIMARYYes
LineNumLine NumberInt
11TPW2
Payable Information
CrTaxCtgryCredit Tax CategoryInt
11
CrTaxTypeCredit Tax TypeInt
11
CrUtilizCredit Utilized AmountNum
20
CrUtilizFCCredit Utilized Amount FCNum
20
CrUtilizSCCredit Utilized Amount SCNum
20
PymMethPayment MethodnVarChar
15
PymAmntPayment AmountNum
20
PymAmntFCPayment Amount (FC)Num
20
PymAmntSCPayment Amount (SC)Num
20
MatTypeMaterial TypeInt
0
11
0

Table relationship map

SELECT statement

SELECT TPW3.AbsEntry AS 'Absolute Entry No', TPW3.LineNum AS 'Line Number', TPW3.CrTaxCtgry AS 'Credit Tax Category', TPW3.CrTaxType AS 'Credit Tax Type', TPW3.CrUtiliz AS 'Credit Utilized Amount', TPW3.CrUtilizFC AS 'Credit Utilized Amount FC', TPW3.CrUtilizSC AS 'Credit Utilized Amount SC', TPW3.PymMeth AS 'Payment Method', TPW3.PymAmnt AS 'Payment Amount', TPW3.PymAmntFC AS 'Payment Amount (FC)', TPW3.PymAmntSC AS 'Payment Amount (SC)', TPW3.MatType AS 'Material Type' FROM TPW3 AS TPW3

Related information


Tax Payment Wizard OTPW SQL Table

Payable Information TPW2 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