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

SQL Banking / Incoming Payment - TDS Entries

API PMV8

PMV8 - Incoming Payment - TDS Entries Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
DocNum ^KEY ^UNIQUE	Document Number	Int	11	ORCT Incoming Payment		PRIMARY	Yes
LineNum	Row Number	Int	11
InvType ^KEY	Invoice Category	nVarChar	20			INVOICE	No
DocEntry	Invoice Internal ID	Int	11
DocLine	Invoice Row Number	Int	11
ObjectType	Object Type	nVarChar	20	ADP1 Object Settings - History	24
LogInstanc	Log Instance	Int	11		0

Table relationship map

SELECT statement

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

Related information

ORCT 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