biuan SAP® BUSINESS ONE SDK
API PDF8
PDF8 - Payment Draft - TDS Entries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OPDF
Payment Draft
PRIMARYYes
LineNumRow NumberInt
11
InvType KEYInvoice CategorynVarChar
-1) All Transactions
204) A/P Down Payment
18) A/P Invoice
19) A/P Credit Memo
10000079) TDS Adjustment
20
-1INVOICENo
DocEntryInvoice Internal IDInt
11
DocLineInvoice Row NumberInt
11
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT PDF8.DocNum AS 'Document Number', PDF8.LineNum AS 'Row Number', PDF8.InvType AS 'Invoice Category', PDF8.DocEntry AS 'Invoice Internal ID', PDF8.DocLine AS 'Invoice Row Number', PDF8.ObjectType AS 'Object Type', PDF8.LogInstanc AS 'Log Instance' FROM PDF8 AS PDF8

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates