biuan SAP® BUSINESS ONE SDK
API CPI11
CPI11 - A/P Corr. Inv - Drawn Dpm Det. Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OCPI
A/P Correction Invoice
PRIMARYYes
LineNumRow NumberInt
11
LineSeqSequence NumberInt
11
BaseAbsBase Document Internal IDInt
11
BaseTypeBase Object TypeInt
-1)
11
-1
VatGroupVAT Group CodenVarChar
8OVTG
Tax Definition
VatPrcntVAT PercentNum
20
LineTotalNet LCNum
20
TotalFrgnNet FCNum
20
TotalSumSyNet SCNum
20
VatSumTax LCNum
20
VatSumFrgnTax FCNum
20
VatSumSysTax SCNum
20
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
163
LogInstancLog InstanceInt
11
IsAcqAcquisition Tax LiableVarChar
N) No
Y) Yes
1
N
IsAllDrawnRemaining Amount DrawnVarChar
Y) Yes
N) No
1
N
IsGrossIs Gross LineVarChar
N) Net Line
Y) Gross Line
1
N
GrossGross LCNum
20
GrossFcGross FCNum
20
GrossScGross 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
BaseNetBase Net LCNum
20
BaseNetFcBase Net FCNum
20
BaseNetScBase Net SCNum
20
BaseVatBase Tax LCNum
20
BaseVatFcBase Tax FCNum
20
BaseVatScBase Tax SCNum
20
BaseGrossBase Gross LCNum
20
BaseGrossFBase Gross FCNum
20
BaseGrossSBase Gross SCNum
20
LineTypeLine TypeVarChar
D) Document Row
R) Currency Rounding
H) Down Payment Document Rounding
1
D
DctSumDeductible Sum LCNum
20
DctSumFcDeductible Sum FCNum
20
DctSumScDeductible Sum SCNum
20
EqSumEqualization Sum LCNum
20
EqSumFcEqualization Sum FCNum
20
EqSumScEqualization Sum 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
BaseDctBase Deductible Sum LCNum
20
BaseDctFcBase Deductible Sum FCNum
20
BaseDctScBase Deductible Sum SCNum
20
BaseEqBase Equalization Sum LCNum
20
BaseEqFcBase Equalization Sum FCNum
20
BaseEqScBase Equalization Sum SCNum
20
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
ApplGrossApplied Gross LCNum
20
ApplGrossFApplied Gross FCNum
20
ApplGrossSApplied Gross SCNum
20
TaxAdjustManual Tax AdjustmentVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT CPI11.DocEntry AS 'Document Internal ID', CPI11.LineNum AS 'Row Number', CPI11.LineSeq AS 'Sequence Number', CPI11.BaseAbs AS 'Base Document Internal ID', CPI11.BaseType AS 'Base Object Type', CPI11.VatGroup AS 'VAT Group Code', CPI11.VatPrcnt AS 'VAT Percent', CPI11.LineTotal AS 'Net LC', CPI11.TotalFrgn AS 'Net FC', CPI11.TotalSumSy AS 'Net SC', CPI11.VatSum AS 'Tax LC', CPI11.VatSumFrgn AS 'Tax FC', CPI11.VatSumSys AS 'Tax SC', CPI11.ObjType AS 'Object Type', CPI11.LogInstanc AS 'Log Instance', CPI11.IsAcq AS 'Acquisition Tax Liable', CPI11.IsAllDrawn AS 'Remaining Amount Drawn', CPI11.IsGross AS 'Is Gross Line', CPI11.Gross AS 'Gross LC', CPI11.GrossFc AS 'Gross FC', CPI11.GrossSc AS 'Gross SC', CPI11.ApplNet AS 'Applied Net LC', CPI11.ApplNetFc AS 'Applied Net FC', CPI11.ApplNetSc AS 'Applied Net SC', CPI11.ApplVat AS 'Applied Tax LC', CPI11.ApplVatFc AS 'Applied Tax FC', CPI11.ApplVatSc AS 'Applied Tax SC', CPI11.BaseNet AS 'Base Net LC', CPI11.BaseNetFc AS 'Base Net FC', CPI11.BaseNetSc AS 'Base Net SC', CPI11.BaseVat AS 'Base Tax LC', CPI11.BaseVatFc AS 'Base Tax FC', CPI11.BaseVatSc AS 'Base Tax SC', CPI11.BaseGross AS 'Base Gross LC', CPI11.BaseGrossF AS 'Base Gross FC', CPI11.BaseGrossS AS 'Base Gross SC', CPI11.LineType AS 'Line Type', CPI11.DctSum AS 'Deductible Sum LC', CPI11.DctSumFc AS 'Deductible Sum FC', CPI11.DctSumSc AS 'Deductible Sum SC', CPI11.EqSum AS 'Equalization Sum LC', CPI11.EqSumFc AS 'Equalization Sum FC', CPI11.EqSumSc AS 'Equalization Sum SC', CPI11.ApplDct AS 'Applied Deductible Sum LC', CPI11.ApplDctFc AS 'Applied Deductible Sum FC', CPI11.ApplDctSc AS 'Applied Deductible Sum SC', CPI11.ApplEq AS 'Applied Equalization Sum LC', CPI11.ApplEqFc AS 'Applied Equalization Sum FC', CPI11.ApplEqSc AS 'Applied Equalization Sum SC', CPI11.BaseDct AS 'Base Deductible Sum LC', CPI11.BaseDctFc AS 'Base Deductible Sum FC', CPI11.BaseDctSc AS 'Base Deductible Sum SC', CPI11.BaseEq AS 'Base Equalization Sum LC', CPI11.BaseEqFc AS 'Base Equalization Sum FC', CPI11.BaseEqSc AS 'Base Equalization Sum SC', CPI11.TaxCode AS 'Tax Code', CPI11.ApplGross AS 'Applied Gross LC', CPI11.ApplGrossF AS 'Applied Gross FC', CPI11.ApplGrossS AS 'Applied Gross SC', CPI11.TaxAdjust AS 'Manual Tax Adjustment' FROM CPI11 AS CPI11

Related information


A/P Correction Invoice OCPI 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates