biuan SAP® BUSINESS ONE SDK
SQL A/R Invoice - Drawn Dpm
DTW A/R Invoice - Drawn Dpm
API Documents / Down Payments To Draw
INV9 - A/R Invoice - Drawn Dpm Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OINV
A/R Invoice		PRIMARYYes
LineNumRow NumberInt
11
BaseAbsBase Document Internal IDInt
11ODPI
A/R Down Payment
BaseLineBase Document RowInt
11
TargetBaseTarget or Base DocumentVarChar
B) Base
T) Target
1
T
ObjTypeBase Object TypenVarChar
203) A/R Down Payment
20
203
DrawnSumNet LCNum
20
DrawnSumFcNet FCNum
20
DrawnSumScNet SCNum
20
LogInstancLog InstanceInt
11
0
ObjCodeObject TypenVarChar
20ADP1
Object Settings - History		13
ApplDrawnApplied Net LCNum
20
ApplDrawnFApplied Net FCNum
20
ApplDrawnSApplied Net SCNum
20
BaseDocNumBase Document NumberInt
11
BsDocDateBase Posting DateDate
8
BsDueDateBase Due DateDate
8
BsCardNameBase BP NamenVarChar
100
BsCommentsBase RemarksnVarChar
127
PostedBase Document PostedVarChar
Y) Yes
N) No
1
Y
VatTax LCNum
20
VatFcTax FCNum
20
VatScTax SCNum
20
GrossGross LCNum
20
GrossFcGross FCNum
20
GrossScGross SCNum
20
IsGrossIs Gross LineVarChar
N) Net Line
Y) Gross Line
1
N

Table relationship map

SELECT statement

SELECT INV9.DocEntry AS 'Document Internal ID', INV9.LineNum AS 'Row Number', INV9.BaseAbs AS 'Base Document Internal ID', INV9.BaseLine AS 'Base Document Row', INV9.TargetBase AS 'Target or Base Document', INV9.ObjType AS 'Base Object Type', INV9.DrawnSum AS 'Net LC', INV9.DrawnSumFc AS 'Net FC', INV9.DrawnSumSc AS 'Net SC', INV9.LogInstanc AS 'Log Instance', INV9.ObjCode AS 'Object Type', INV9.ApplDrawn AS 'Applied Net LC', INV9.ApplDrawnF AS 'Applied Net FC', INV9.ApplDrawnS AS 'Applied Net SC', INV9.BaseDocNum AS 'Base Document Number', INV9.BsDocDate AS 'Base Posting Date', INV9.BsDueDate AS 'Base Due Date', INV9.BsCardName AS 'Base BP Name', INV9.BsComments AS 'Base Remarks', INV9.Posted AS 'Base Document Posted', INV9.Vat AS 'Tax LC', INV9.VatFc AS 'Tax FC', INV9.VatSc AS 'Tax SC', INV9.Gross AS 'Gross LC', INV9.GrossFc AS 'Gross FC', INV9.GrossSc AS 'Gross SC', INV9.IsGross AS 'Is Gross Line' FROM INV9 AS INV9

Related information


Down Payments To Draw DownPaymentsToDraw Object· Table: INV9
Represents down payments drawn into A/R or A/P invoices. The Documents.DownPaymentAmount property is updated with the total amount to draw. Source tables: INV9,  PCH9, RIN9, RPC9, DRF9
   Parent: Documents Documents Object· Table: OIGE OIGN
A/R Down Payment ODPI SQL Table

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