biuan SAP® BUSINESS ONE SDK
API IEI9
IEI9 - IEI - Drawn Dpm Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OIEI
Incoming Excise Invoice
PRIMARYYes
LineNumRow NumberInt
11
BaseAbsBase Document Internal IDInt
11
BaseLineBase Document RowInt
11
TargetBaseTarget or Base DocumentVarChar
B) Base
T) Target
1
T
ObjTypeBase Object TypenVarChar
20
203
DrawnSumNet LCNum
20
DrawnSumFcNet FCNum
20
DrawnSumScNet SCNum
20
LogInstancLog InstanceInt
11
0
ObjCodeObject TypenVarChar
20ADP1
Object Settings - History
140000010
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 IEI9.DocEntry AS 'Document Internal ID', IEI9.LineNum AS 'Row Number', IEI9.BaseAbs AS 'Base Document Internal ID', IEI9.BaseLine AS 'Base Document Row', IEI9.TargetBase AS 'Target or Base Document', IEI9.ObjType AS 'Base Object Type', IEI9.DrawnSum AS 'Net LC', IEI9.DrawnSumFc AS 'Net FC', IEI9.DrawnSumSc AS 'Net SC', IEI9.LogInstanc AS 'Log Instance', IEI9.ObjCode AS 'Object Type', IEI9.ApplDrawn AS 'Applied Net LC', IEI9.ApplDrawnF AS 'Applied Net FC', IEI9.ApplDrawnS AS 'Applied Net SC', IEI9.BaseDocNum AS 'Base Document Number', IEI9.BsDocDate AS 'Base Posting Date', IEI9.BsDueDate AS 'Base Due Date', IEI9.BsCardName AS 'Base BP Name', IEI9.BsComments AS 'Base Remarks', IEI9.Posted AS 'Base Document Posted', IEI9.Vat AS 'Tax LC', IEI9.VatFc AS 'Tax FC', IEI9.VatSc AS 'Tax SC', IEI9.Gross AS 'Gross LC', IEI9.GrossFc AS 'Gross FC', IEI9.GrossSc AS 'Gross SC', IEI9.IsGross AS 'Is Gross Line' FROM IEI9 AS IEI9

Related information


Incoming Excise Invoice OIEI 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