biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment Draft - Tax Amount per Document
API PDF7
PDF7 - Payment Draft - Tax Amount per Document Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPDF
Payment Draft		PRIMARYYes
LineSeqRow SequenceInt
11
InvoiceSeqInvoice Sequence NumberInt
11
ValueDateDue DateDate
8
Inv4SeqINV4 Sequence NumberInt
11
TaxSumTax AmountNum
20
TaxSumFrgnTax Amount (FC)Num
20
TaxSumSysTax Amount (SC)Num
20
BaseSumBase AmountNum
20
BaseSumFrgBase Amount (FC)Num
20
BaseSumSysBase Amount (SC)Num
20
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History		24
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT PDF7.DocNum AS 'Document Number', PDF7.LineSeq AS 'Row Sequence', PDF7.InvoiceSeq AS 'Invoice Sequence Number', PDF7.ValueDate AS 'Due Date', PDF7.Inv4Seq AS 'INV4 Sequence Number', PDF7.TaxSum AS 'Tax Amount', PDF7.TaxSumFrgn AS 'Tax Amount (FC)', PDF7.TaxSumSys AS 'Tax Amount (SC)', PDF7.BaseSum AS 'Base Amount', PDF7.BaseSumFrg AS 'Base Amount (FC)', PDF7.BaseSumSys AS 'Base Amount (SC)', PDF7.ObjectType AS 'Object Type', PDF7.LogInstanc AS 'Log Instance' FROM PDF7 AS PDF7

Related information


Payment Draft OPDF SQL Table

Object Settings - History ADP1 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