biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment Drafts - Withholding Tax - Rows
API PDF6
PDF6 - Payment Drafts - Withholding Tax - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPDF
Payment Draft		PRIMARYYes
InvoiceIdInvoice KeyInt
11
WTCodeWTax CodenVarChar
4OWHT
Withholding Tax
PymMeanPayment MeansVarChar
C) Cash
K) Checks
R) Credit Card
T) Bank Transfer
B) Bill of Exchange
1
C
DueDateDue DateDate
8
WTSumWTax AmountNum
20
WTSumFCWTax Amount (SC)Num
20
WTSumSCWTax Amount (FC)Num
20
RateRateNum
20
TaxbleAmntTaxable AmountNum
20
TxblAmntFCTaxable Amount (FC)Num
20
TxblAmntSCTaxable Amount (SC)Num
20
PymAmountPayment AmountNum
20
PymAmounFPayment Amount (FC)Num
20
PymAmounSPayment Amount (SC)Num
20
LineInternal NumberInt
11
LogInstancLog Instance - HistoryInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		24
TdsBAmtTDS Base AmountNum
20
TdsBAmtSCTDS Base Amount (SC)Num
20
TdsBAmtFCTDS Base Amount (FC)Num
20
SurBAmtSurcharge Base AmountNum
20
SurBAmtSCSurcharge Base Amount (SC)Num
20
SurBAmtFCSurcharge Base Amount (FC)Num
20
CessBAmtCess Base AmountNum
20
CessBAmtSCCess Base Amount (SC)Num
20
CessBAmtFCCess Base Amount (FC)Num
20
HscBAmtHSC Base AmountNum
20
HscBAmtSCHSC Base Amount (SC)Num
20
HscBAmtFCHSC Base Amount (FC)Num
20
TdsAmntTDS Tax AmountNum
20
TdsAmntSCTDS Tax Amount (SC)Num
20
TdsAmntFCTDS Tax Amount (FC)Num
20
SurAmntSurcharge Tax AmountNum
20
SurAmntSCSurcharge Tax Amount (SC)Num
20
SurAmntFCSurcharge Tax Amount (FC)Num
20
CessAmntCess Tax AmountNum
20
CessAmntSCCess Tax Amount (SC)Num
20
CessAmntFCCess Tax Amount (FC)Num
20
HscAmntHSC Tax AmountNum
20
HscAmntSCHSC Tax Amount (SC)Num
20
HscAmntFCHSC Tax Amount (FC)Num
20

Table relationship map

SELECT statement

SELECT PDF6.DocNum AS 'Document Number', PDF6.InvoiceId AS 'Invoice Key', PDF6.WTCode AS 'WTax Code', PDF6.PymMean AS 'Payment Means', PDF6.DueDate AS 'Due Date', PDF6.WTSum AS 'WTax Amount', PDF6.WTSumFC AS 'WTax Amount (SC)', PDF6.WTSumSC AS 'WTax Amount (FC)', PDF6.Rate AS 'Rate', PDF6.TaxbleAmnt AS 'Taxable Amount', PDF6.TxblAmntFC AS 'Taxable Amount (FC)', PDF6.TxblAmntSC AS 'Taxable Amount (SC)', PDF6.PymAmount AS 'Payment Amount', PDF6.PymAmounF AS 'Payment Amount (FC)', PDF6.PymAmounS AS 'Payment Amount (SC)', PDF6.Line AS 'Internal Number', PDF6.LogInstanc AS 'Log Instance - History', PDF6.ObjType AS 'Object Type', PDF6.TdsBAmt AS 'TDS Base Amount', PDF6.TdsBAmtSC AS 'TDS Base Amount (SC)', PDF6.TdsBAmtFC AS 'TDS Base Amount (FC)', PDF6.SurBAmt AS 'Surcharge Base Amount', PDF6.SurBAmtSC AS 'Surcharge Base Amount (SC)', PDF6.SurBAmtFC AS 'Surcharge Base Amount (FC)', PDF6.CessBAmt AS 'Cess Base Amount', PDF6.CessBAmtSC AS 'Cess Base Amount (SC)', PDF6.CessBAmtFC AS 'Cess Base Amount (FC)', PDF6.HscBAmt AS 'HSC Base Amount', PDF6.HscBAmtSC AS 'HSC Base Amount (SC)', PDF6.HscBAmtFC AS 'HSC Base Amount (FC)', PDF6.TdsAmnt AS 'TDS Tax Amount', PDF6.TdsAmntSC AS 'TDS Tax Amount (SC)', PDF6.TdsAmntFC AS 'TDS Tax Amount (FC)', PDF6.SurAmnt AS 'Surcharge Tax Amount', PDF6.SurAmntSC AS 'Surcharge Tax Amount (SC)', PDF6.SurAmntFC AS 'Surcharge Tax Amount (FC)', PDF6.CessAmnt AS 'Cess Tax Amount', PDF6.CessAmntSC AS 'Cess Tax Amount (SC)', PDF6.CessAmntFC AS 'Cess Tax Amount (FC)', PDF6.HscAmnt AS 'HSC Tax Amount', PDF6.HscAmntSC AS 'HSC Tax Amount (SC)', PDF6.HscAmntFC AS 'HSC Tax Amount (FC)' FROM PDF6 AS PDF6

Related information


Payment Draft OPDF SQL Table

Object Settings - History ADP1 SQL Table

Withholding Tax OWHT 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