|
|
API CSI11
CSI11 - A/R Corr. Inv. - Drawn Dpm Det Table
A/R Correction Invoice OCSI SQL Table
Object Settings - History ADP1 SQL Table
Sales Tax Codes OSTC SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OCSI A/R Correction Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| LineSeq | Sequence Number | Int | 11 | |||||
| BaseAbs | Base Document Internal ID | Int | 11 | |||||
| BaseType | Base Object Type | Int | -1) | 11 | -1 | |||
| VatGroup | VAT Group Code | nVarChar | 8 | OVTG Tax Definition | ||||
| VatPrcnt | VAT Percent | Num | 20 | |||||
| LineTotal | Net LC | Num | 20 | |||||
| TotalFrgn | Net FC | Num | 20 | |||||
| TotalSumSy | Net SC | Num | 20 | |||||
| VatSum | Tax LC | Num | 20 | |||||
| VatSumFrgn | Tax FC | Num | 20 | |||||
| VatSumSys | Tax SC | Num | 20 | |||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 165 | |||
| LogInstanc | Log Instance | Int | 11 | |||||
| IsAcq | Liable for Acquisition Tax | VarChar | N) No Y) Yes | 1 | N | |||
| IsAllDrawn | Remaining Amount Drawn | VarChar | Y) Yes N) No | 1 | N | |||
| IsGross | Is Gross Line | VarChar | N) Net Line Y) Gross Line | 1 | N | |||
| Gross | Gross LC | Num | 20 | |||||
| GrossFc | Gross FC | Num | 20 | |||||
| GrossSc | Gross SC | Num | 20 | |||||
| ApplNet | Applied Net LC | Num | 20 | |||||
| ApplNetFc | Applied Net FC | Num | 20 | |||||
| ApplNetSc | Applied Net SC | Num | 20 | |||||
| ApplVat | Applied Tax LC | Num | 20 | |||||
| ApplVatFc | Applied Tax FC | Num | 20 | |||||
| ApplVatSc | Applied Tax SC | Num | 20 | |||||
| BaseNet | Base Net LC | Num | 20 | |||||
| BaseNetFc | Base Net FC | Num | 20 | |||||
| BaseNetSc | Base Net SC | Num | 20 | |||||
| BaseVat | Base Tax LC | Num | 20 | |||||
| BaseVatFc | Base Tax FC | Num | 20 | |||||
| BaseVatSc | Base Tax SC | Num | 20 | |||||
| BaseGross | Base Gross LC | Num | 20 | |||||
| BaseGrossF | Base Gross FC | Num | 20 | |||||
| BaseGrossS | Base Gross SC | Num | 20 | |||||
| LineType | Line Type | VarChar | D) Document Row R) Currency Rounding H) Down Payment Document Rounding | 1 | D | |||
| DctSum | Deductible Sum LC | Num | 20 | |||||
| DctSumFc | Deductible Sum FC | Num | 20 | |||||
| DctSumSc | Deductible Sum SC | Num | 20 | |||||
| EqSum | Equalization Sum LC | Num | 20 | |||||
| EqSumFc | Equalization Sum FC | Num | 20 | |||||
| EqSumSc | Equalization Sum SC | Num | 20 | |||||
| ApplDct | Applied Deductible Sum LC | Num | 20 | |||||
| ApplDctFc | Applied Deductible Sum FC | Num | 20 | |||||
| ApplDctSc | Applied Deductible Sum SC | Num | 20 | |||||
| ApplEq | Applied Equalization Sum LC | Num | 20 | |||||
| ApplEqFc | Applied Equalization Sum FC | Num | 20 | |||||
| ApplEqSc | Applied Equalization Sum SC | Num | 20 | |||||
| BaseDct | Base Deductible Sum LC | Num | 20 | |||||
| BaseDctFc | Base Deductible Sum FC | Num | 20 | |||||
| BaseDctSc | Base Deductible Sum SC | Num | 20 | |||||
| BaseEq | Base Equalization Sum LC | Num | 20 | |||||
| BaseEqFc | Base Equalization Sum FC | Num | 20 | |||||
| BaseEqSc | Base Equalization Sum SC | Num | 20 | |||||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| ApplGross | Applied Gross LC | Num | 20 | |||||
| ApplGrossF | Applied Gross FC | Num | 20 | |||||
| ApplGrossS | Applied Gross SC | Num | 20 | |||||
| TaxAdjust | Manual Tax Adjustment | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
CSI11.DocEntry AS 'Document Internal ID',
CSI11.LineNum AS 'Row Number',
CSI11.LineSeq AS 'Sequence Number',
CSI11.BaseAbs AS 'Base Document Internal ID',
CSI11.BaseType AS 'Base Object Type',
CSI11.VatGroup AS 'VAT Group Code',
CSI11.VatPrcnt AS 'VAT Percent',
CSI11.LineTotal AS 'Net LC',
CSI11.TotalFrgn AS 'Net FC',
CSI11.TotalSumSy AS 'Net SC',
CSI11.VatSum AS 'Tax LC',
CSI11.VatSumFrgn AS 'Tax FC',
CSI11.VatSumSys AS 'Tax SC',
CSI11.ObjType AS 'Object Type',
CSI11.LogInstanc AS 'Log Instance',
CSI11.IsAcq AS 'Liable for Acquisition Tax',
CSI11.IsAllDrawn AS 'Remaining Amount Drawn',
CSI11.IsGross AS 'Is Gross Line',
CSI11.Gross AS 'Gross LC',
CSI11.GrossFc AS 'Gross FC',
CSI11.GrossSc AS 'Gross SC',
CSI11.ApplNet AS 'Applied Net LC',
CSI11.ApplNetFc AS 'Applied Net FC',
CSI11.ApplNetSc AS 'Applied Net SC',
CSI11.ApplVat AS 'Applied Tax LC',
CSI11.ApplVatFc AS 'Applied Tax FC',
CSI11.ApplVatSc AS 'Applied Tax SC',
CSI11.BaseNet AS 'Base Net LC',
CSI11.BaseNetFc AS 'Base Net FC',
CSI11.BaseNetSc AS 'Base Net SC',
CSI11.BaseVat AS 'Base Tax LC',
CSI11.BaseVatFc AS 'Base Tax FC',
CSI11.BaseVatSc AS 'Base Tax SC',
CSI11.BaseGross AS 'Base Gross LC',
CSI11.BaseGrossF AS 'Base Gross FC',
CSI11.BaseGrossS AS 'Base Gross SC',
CSI11.LineType AS 'Line Type',
CSI11.DctSum AS 'Deductible Sum LC',
CSI11.DctSumFc AS 'Deductible Sum FC',
CSI11.DctSumSc AS 'Deductible Sum SC',
CSI11.EqSum AS 'Equalization Sum LC',
CSI11.EqSumFc AS 'Equalization Sum FC',
CSI11.EqSumSc AS 'Equalization Sum SC',
CSI11.ApplDct AS 'Applied Deductible Sum LC',
CSI11.ApplDctFc AS 'Applied Deductible Sum FC',
CSI11.ApplDctSc AS 'Applied Deductible Sum SC',
CSI11.ApplEq AS 'Applied Equalization Sum LC',
CSI11.ApplEqFc AS 'Applied Equalization Sum FC',
CSI11.ApplEqSc AS 'Applied Equalization Sum SC',
CSI11.BaseDct AS 'Base Deductible Sum LC',
CSI11.BaseDctFc AS 'Base Deductible Sum FC',
CSI11.BaseDctSc AS 'Base Deductible Sum SC',
CSI11.BaseEq AS 'Base Equalization Sum LC',
CSI11.BaseEqFc AS 'Base Equalization Sum FC',
CSI11.BaseEqSc AS 'Base Equalization Sum SC',
CSI11.TaxCode AS 'Tax Code',
CSI11.ApplGross AS 'Applied Gross LC',
CSI11.ApplGrossF AS 'Applied Gross FC',
CSI11.ApplGrossS AS 'Applied Gross SC',
CSI11.TaxAdjust AS 'Manual Tax Adjustment'
FROM CSI11 AS CSI11
Related information
A/R Correction Invoice OCSI SQL Table
Object Settings - History ADP1 SQL Table
Sales Tax Codes OSTC SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
