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

SQL Marketing Documents and Receipts / A/R Invoice - Row Structure - History

API ADO10

ADO10 - A/R Invoice - Row Structure - History Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Document Internal ID	Int		11	ADOC Invoice - History		PRIMARY	Yes
LineSeq	Row Sequence	Int		11
AftLineNum	After Row Number	Int		11
OrderNum	Order Number	Int		11
LineType	Row Type	VarChar	T) Text S) Subtotal	1
LineText	Row Text	Text		16
LogInstanc	Log Instance	Int		11		0
ObjType	Object Type	nVarChar		20	ADP1 Object Settings - History	23

Table relationship map

SELECT statement

SELECT
   ADO10.DocEntry AS 'Document Internal ID', 
   ADO10.LineSeq AS 'Row Sequence', 
   ADO10.AftLineNum AS 'After Row Number', 
   ADO10.OrderNum AS 'Order Number', 
   ADO10.LineType AS 'Row Type', 
   ADO10.LineText AS 'Row Text', 
   ADO10.LogInstanc AS 'Log Instance', 
   ADO10.ObjType AS 'Object Type'
FROM ADO10 AS ADO10

Related information

ADOC 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