biuan SAP® BUSINESS ONE SDK
DTW A/R Invoice - Row Structure
API Documents / Document Special Lines
INV10 - A/R Invoice - Row Structure Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OINV
A/R Invoice
SECONDERYYes
LineSeqRow SequenceInt
11
AftLineNumAfter Row NumberInt
11
OrderNumOrder NumberInt
11
LineTypeRow TypeVarChar
T) Text
S) Subtotal
1
LineTextRow TextText
16
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
13

Table relationship map

SELECT statement

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

Related information


Document Special Lines Document_SpecialLines Object· Table: INV10
This object represents text and subtotal lines in marketing documents. Source table: INV10 and IN10V (a virtual table for storing calculated values).
   Parent: Documents Documents Object· Table: OIGE OIGN
A/R Invoice OINV 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