PDF8 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Banking / Payment Draft - TDS Entries

API PDF8

PDF8 - Payment Draft - TDS Entries Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
DocNum ^KEY ^UNIQUE	Document Number	Int		11	OPDF Payment Draft		PRIMARY	Yes
LineNum	Row Number	Int		11
InvType ^KEY	Invoice Category	nVarChar	-1) All Transactions 204) A/P Down Payment 18) A/P Invoice 19) A/P Credit Memo 10000079) TDS Adjustment	20		-1	INVOICE	No
DocEntry	Invoice Internal ID	Int		11
DocLine	Invoice Row Number	Int		11
ObjectType	Object Type	nVarChar		20	ADP1 Object Settings - History
LogInstanc	Log Instance	Int		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

OPDF SQL Table

ADP1 SQL Table

biuan SAP® BUSINESS ONE

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