|
|
API OEI4
OEI4 - Outgoing Excise Invoice - Tax Amount per Document Table
G/L Accounts OACT SQL Table
Outgoing Excise Invoice OOEI SQL Table
Freight Setup OEXD SQL Table
Object Settings - History ADP1 SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
Sales Tax Codes OSTC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY | Document Internal ID | Int | 11 | OOEI Outgoing Excise Invoice | SCONDARY | No |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | -1 | ||||
| GroupNum | Group Number | Int | 11 | -1 | ||||
| ExpnsCode | Expense Code | Int | 11 | OEXD Freight Setup | -1 | |||
| RelateType | Relation Type | Int | 1) Row 2) Row Expenses 3) Document Expenses 13) Distributed Freights | 11 | 1 | |||
| StcCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| StaCode | Authority Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| staType | Authority Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| TaxRate | Tax Rate | Num | 20 | |||||
| TaxAcct | Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TaxSum | Tax Amount | Num | 20 | |||||
| TaxSumFrgn | Tax Amount (FC) | Num | 20 | |||||
| TaxSumSys | Tax Amount (SC) | Num | 20 | |||||
| BaseSum | Base Amount | Num | 20 | |||||
| BaseSumFrg | Base Amount (FC) | Num | 20 | |||||
| BaseSumSys | Base Amount (SC) | Num | 20 | |||||
| ObjectType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 140000009 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| TaxStatus | Tax Status | VarChar | Y) Normal Tax N) No Tax U) Use Tax | 1 | Y | |||
| VatApplied | Applied Tax | Num | 20 | |||||
| VatAppldFC | Applied Tax (FC) | Num | 20 | |||||
| VatAppldSC | Applied Tax (SC) | Num | 20 | |||||
| LineSeq | Row Sequence | Int | 11 | |||||
| DeferrAcct | Deferred Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BaseType | Base Document Type | Int | 11 | -1 | ||||
| BaseAbs | Base Document Internal No. | Int | 11 | -1 | ||||
| BaseSeq | Base Doc. Row Sequence | Int | 11 | |||||
| DeductTax | Deductible Tax Amount | Num | 20 | |||||
| DdctTaxFrg | Deductible Tax Amount (FC) | Num | 20 | |||||
| DdctTaxSys | Deductible Tax Amount (SC) | Num | 20 | |||||
| BaseAppld | Applied Base Amount | Num | 20 | |||||
| BaseApldFC | Applied Base Amount (FC) | Num | 20 | |||||
| BaseApldSC | Applied Base Amount (SC) | Num | 20 | |||||
| NonDdctPrc | Non Deductible % | Num | 20 | |||||
| NonDdctAct | Non Deductible Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TaxInPrice | Tax Included in Price? | VarChar | Y) Yes N) No | 1 | N | |||
| Exempt | Exempt? | VarChar | Y) Yes N) No | 1 | N | |||
| TaxExpAct | Expense Account for Tax | nVarChar | 15 | OACT G/L Accounts | ||||
| OnHoldTax | On Hold Tax Amount | Num | 20 | |||||
| OnHoldTaxF | On Hold Tax Amount (FC) | Num | 20 | |||||
| OnHoldTaxS | On Hold Tax Amount (SC) | Num | 20 | |||||
| InGrossRev | Included in Gross Revenue | VarChar | Y) Yes N) No | 1 | N | |||
| TaxSumOrg | Tax Amount Original | Num | 20 | |||||
| TaxSumOrgF | Tax Amount Original (FC) | Num | 20 | |||||
| TaxSumOrgS | Tax Amount Original (SC) | Num | 20 | |||||
| OpenTax | Open Service Tax | Num | 20 | |||||
| OpenTaxFC | Open Service Tax (FC) | Num | 20 | |||||
| OpenTaxSC | Open Service Tax (SC) | Num | 20 | |||||
| Unencumbrd | Unencumbered | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OEI4.DocEntry AS 'Document Internal ID',
OEI4.LineNum AS 'Row Number',
OEI4.GroupNum AS 'Group Number',
OEI4.ExpnsCode AS 'Expense Code',
OEI4.RelateType AS 'Relation Type',
OEI4.StcCode AS 'Tax Code',
OEI4.StaCode AS 'Authority Code',
OEI4.staType AS 'Authority Type',
OEI4.TaxRate AS 'Tax Rate',
OEI4.TaxAcct AS 'Tax Account',
OEI4.TaxSum AS 'Tax Amount',
OEI4.TaxSumFrgn AS 'Tax Amount (FC)',
OEI4.TaxSumSys AS 'Tax Amount (SC)',
OEI4.BaseSum AS 'Base Amount',
OEI4.BaseSumFrg AS 'Base Amount (FC)',
OEI4.BaseSumSys AS 'Base Amount (SC)',
OEI4.ObjectType AS 'Object Type',
OEI4.LogInstanc AS 'Log Instance',
OEI4.TaxStatus AS 'Tax Status',
OEI4.VatApplied AS 'Applied Tax',
OEI4.VatAppldFC AS 'Applied Tax (FC)',
OEI4.VatAppldSC AS 'Applied Tax (SC)',
OEI4.LineSeq AS 'Row Sequence',
OEI4.DeferrAcct AS 'Deferred Tax Account',
OEI4.BaseType AS 'Base Document Type',
OEI4.BaseAbs AS 'Base Document Internal No.',
OEI4.BaseSeq AS 'Base Doc. Row Sequence',
OEI4.DeductTax AS 'Deductible Tax Amount',
OEI4.DdctTaxFrg AS 'Deductible Tax Amount (FC)',
OEI4.DdctTaxSys AS 'Deductible Tax Amount (SC)',
OEI4.BaseAppld AS 'Applied Base Amount',
OEI4.BaseApldFC AS 'Applied Base Amount (FC)',
OEI4.BaseApldSC AS 'Applied Base Amount (SC)',
OEI4.NonDdctPrc AS 'Non Deductible %',
OEI4.NonDdctAct AS 'Non Deductible Account',
OEI4.TaxInPrice AS 'Tax Included in Price?',
OEI4.Exempt AS 'Exempt?',
OEI4.TaxExpAct AS 'Expense Account for Tax',
OEI4.OnHoldTax AS 'On Hold Tax Amount',
OEI4.OnHoldTaxF AS 'On Hold Tax Amount (FC)',
OEI4.OnHoldTaxS AS 'On Hold Tax Amount (SC)',
OEI4.InGrossRev AS 'Included in Gross Revenue',
OEI4.TaxSumOrg AS 'Tax Amount Original',
OEI4.TaxSumOrgF AS 'Tax Amount Original (FC)',
OEI4.TaxSumOrgS AS 'Tax Amount Original (SC)',
OEI4.OpenTax AS 'Open Service Tax',
OEI4.OpenTaxFC AS 'Open Service Tax (FC)',
OEI4.OpenTaxSC AS 'Open Service Tax (SC)',
OEI4.Unencumbrd AS 'Unencumbered'
FROM OEI4 AS OEI4
Related information
G/L Accounts OACT SQL Table
Outgoing Excise Invoice OOEI SQL Table
Freight Setup OEXD SQL Table
Object Settings - History ADP1 SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
Sales Tax Codes OSTC SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
