biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Gds Rcpt - Drawn Dpm Applied
API IGN15
IGN15 - Gds Rcpt - Drawn Dpm Applied Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OIGN
Goods Receipt		PRIMARYYes
LineNumRow NumberInt
11
ObjTypeobject typenVarChar
20ADP1
Object Settings - History		59
LogInstancLog InstanceInt
11
0
VatGroupVAT Group CodenVarChar
8OVTG
Tax Definition
StaCodeTax Authority CodenVarChar
8
StaTypeTax Authority TypeInt
11
StaIndexTax Authority Seq IndexInt
11
BaseNetNet LCNum
20
BaseNetFcNet FCNum
20
BaseNetScNet SCNum
20
VatSumTax LCNum
20
VatSumFcTax FCNum
20
VatSumScTax SCNum
20
DctSumDeductible Sum LCNum
20
DctSumFcDeductible Sum FCNum
20
DctSumScDeductible Sum SCNum
20
EqSumEqualization Sum LCNum
20
EqSumFcEqualization Sum FCNum
20
EqSumScEqualization Sum SCNum
20
ApplNetApplied Net LCNum
20
ApplNetFcApplied Net FCNum
20
ApplNetScApplied Net SCNum
20
ApplVatApplied Tax LCNum
20
ApplVatFcApplied Tax FCNum
20
ApplVatScApplied Tax SCNum
20
ApplDctApplied Deductible Sum LCNum
20
ApplDctFcApplied Deductible Sum FCNum
20
ApplDctScApplied Deductible Sum SCNum
20
ApplEqApplied Equalization Sum LCNum
20
ApplEqFcApplied Equalization Sum FCNum
20
ApplEqScApplied Equalization Sum SCNum
20
PaidNetPaid Net LCNum
20
PaidNetFcPaid Net FCNum
20
PaidNetScPaid Net SCNum
20
PaidVatPaid Tax LCNum
20
PaidVatFcPaid Tax FCNum
20
PaidVatScPaid Tax SCNum
20
PaidDctPaid Deductible Sum LCNum
20
PaidDctFcPaid Deductible Sum FCNum
20
PaidDctScPaid Deductible Sum SCNum
20
PaidEqPaid Equalization Sum LCNum
20
PaidEqFcPaid Equalization Sum FCNum
20
PaidEqScPaid Equalization Sum SCNum
20
DpApplNetDpm Appl Net LCNum
20
DpApplNetFDpm Appl Net FCNum
20
DpApplNetSDpm Appl Net SCNum
20
DpApplVatDpm Appl Tax LCNum
20
DpApplVatFDpm Appl Tax FCNum
20
DpApplVatSDpm Appl Tax SCNum
20
DpApplDctDpm Appl Deductible Sum LCNum
20
DpApplDctFDpm Appl Deductible Sum FCNum
20
DpApplDctSDpm Appl Deductible Sum SCNum
20
DpApplEqDpm Appl Equalization Sum LCNum
20
DpApplEqFcDpm Appl Equalization Sum FCNum
20
DpApplEqScDpm Appl Equalization Sum SCNum
20
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
LineTypeRow TypeVarChar
D) Document
R) Exchange Rate Rounding
H) Document Header Rounding
1
D
BaseGrsGross LCNum
20
BaseGrsFcGross FCNum
20
BaseGrsScGross SCNum
20
ApplGrsApplied Gross LCNum
20
ApplGrsFcApplied Gross FCNum
20
ApplGrsScApplied Gross SCNum
20
PaidGrsPaid Gross LCNum
20
PaidGrsFcPaid Gross FCNum
20
PaidGrsScPaid Gross SCNum
20
DpApplGrsDpm Appl Gross LCNum
20
DpApplGrsFDpm Appl Gross FCNum
20
DpApplGrsSDpm Appl Gross SCNum
20

Table relationship map

SELECT statement

SELECT IGN15.DocEntry AS 'Document Internal ID', IGN15.LineNum AS 'Row Number', IGN15.ObjType AS 'object type', IGN15.LogInstanc AS 'Log Instance', IGN15.VatGroup AS 'VAT Group Code', IGN15.StaCode AS 'Tax Authority Code', IGN15.StaType AS 'Tax Authority Type', IGN15.StaIndex AS 'Tax Authority Seq Index', IGN15.BaseNet AS 'Net LC', IGN15.BaseNetFc AS 'Net FC', IGN15.BaseNetSc AS 'Net SC', IGN15.VatSum AS 'Tax LC', IGN15.VatSumFc AS 'Tax FC', IGN15.VatSumSc AS 'Tax SC', IGN15.DctSum AS 'Deductible Sum LC', IGN15.DctSumFc AS 'Deductible Sum FC', IGN15.DctSumSc AS 'Deductible Sum SC', IGN15.EqSum AS 'Equalization Sum LC', IGN15.EqSumFc AS 'Equalization Sum FC', IGN15.EqSumSc AS 'Equalization Sum SC', IGN15.ApplNet AS 'Applied Net LC', IGN15.ApplNetFc AS 'Applied Net FC', IGN15.ApplNetSc AS 'Applied Net SC', IGN15.ApplVat AS 'Applied Tax LC', IGN15.ApplVatFc AS 'Applied Tax FC', IGN15.ApplVatSc AS 'Applied Tax SC', IGN15.ApplDct AS 'Applied Deductible Sum LC', IGN15.ApplDctFc AS 'Applied Deductible Sum FC', IGN15.ApplDctSc AS 'Applied Deductible Sum SC', IGN15.ApplEq AS 'Applied Equalization Sum LC', IGN15.ApplEqFc AS 'Applied Equalization Sum FC', IGN15.ApplEqSc AS 'Applied Equalization Sum SC', IGN15.PaidNet AS 'Paid Net LC', IGN15.PaidNetFc AS 'Paid Net FC', IGN15.PaidNetSc AS 'Paid Net SC', IGN15.PaidVat AS 'Paid Tax LC', IGN15.PaidVatFc AS 'Paid Tax FC', IGN15.PaidVatSc AS 'Paid Tax SC', IGN15.PaidDct AS 'Paid Deductible Sum LC', IGN15.PaidDctFc AS 'Paid Deductible Sum FC', IGN15.PaidDctSc AS 'Paid Deductible Sum SC', IGN15.PaidEq AS 'Paid Equalization Sum LC', IGN15.PaidEqFc AS 'Paid Equalization Sum FC', IGN15.PaidEqSc AS 'Paid Equalization Sum SC', IGN15.DpApplNet AS 'Dpm Appl Net LC', IGN15.DpApplNetF AS 'Dpm Appl Net FC', IGN15.DpApplNetS AS 'Dpm Appl Net SC', IGN15.DpApplVat AS 'Dpm Appl Tax LC', IGN15.DpApplVatF AS 'Dpm Appl Tax FC', IGN15.DpApplVatS AS 'Dpm Appl Tax SC', IGN15.DpApplDct AS 'Dpm Appl Deductible Sum LC', IGN15.DpApplDctF AS 'Dpm Appl Deductible Sum FC', IGN15.DpApplDctS AS 'Dpm Appl Deductible Sum SC', IGN15.DpApplEq AS 'Dpm Appl Equalization Sum LC', IGN15.DpApplEqFc AS 'Dpm Appl Equalization Sum FC', IGN15.DpApplEqSc AS 'Dpm Appl Equalization Sum SC', IGN15.TaxCode AS 'Tax Code', IGN15.LineType AS 'Row Type', IGN15.BaseGrs AS 'Gross LC', IGN15.BaseGrsFc AS 'Gross FC', IGN15.BaseGrsSc AS 'Gross SC', IGN15.ApplGrs AS 'Applied Gross LC', IGN15.ApplGrsFc AS 'Applied Gross FC', IGN15.ApplGrsSc AS 'Applied Gross SC', IGN15.PaidGrs AS 'Paid Gross LC', IGN15.PaidGrsFc AS 'Paid Gross FC', IGN15.PaidGrsSc AS 'Paid Gross SC', IGN15.DpApplGrs AS 'Dpm Appl Gross LC', IGN15.DpApplGrsF AS 'Dpm Appl Gross FC', IGN15.DpApplGrsS AS 'Dpm Appl Gross SC' FROM IGN15 AS IGN15

Related information


Goods Receipt OIGN SQL Table

Object Settings - History ADP1 SQL Table

Sales Tax Codes OSTC SQL Table

Tax Definition OVTG 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