|
|
API WTQ4
WTQ4 - Inventory Transfer Request - Tax Amount per Document Table
G/L Accounts OACT SQL Table
Inventory Transfer Request OWTQ 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 | Internal Document ID | Int | 11 | OWTQ Inventory Transfer Request | SCONDARY | No |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | -1 | ||||
| GroupNum | Group No. | Int | 11 | -1 | ||||
| ExpnsCode | Expense Code | Int | 11 | OEXD Freight Setup | -1 | |||
| RelateType | Relation Type | Int | 1) Row 2) Row Freight Charges 3) Document Expenses 13) Distributed Freights | 11 | 1 | |||
| StcCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| StaCode | Tax Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| staType | Authority Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| TaxRate | Authority Type | Num | 20 | OSTT Sales Tax Authorities Type | ||||
| TaxAcct | Authority Code | nVarChar | 15 | |||||
| TaxSum | Tax % | Num | 20 | OACT G/L Accounts | ||||
| TaxSumFrgn | Tax Account | Num | 20 | |||||
| TaxSumSys | Tax Amount | Num | 20 | |||||
| BaseSum | Tax Amount (FC) | Num | 20 | |||||
| BaseSumFrg | Base Amount | Num | 20 | |||||
| BaseSumSys | Base Amount (FC) | Num | 20 | |||||
| ObjectType | Base Amount (SC) | nVarChar | 20 | |||||
| LogInstanc | Tax Amount (SC) | Int | 11 | ADP1 Object Settings - History | 0 | |||
| TaxStatus | Base Amount | VarChar | Y) Regular Tax N) No Tax U) Use Tax | 1 | Y | |||
| VatApplied | VAT Applied | Num | 20 | |||||
| VatAppldFC | Applied Tax (FC) | Num | 20 | |||||
| VatAppldSC | Applied Tax (SC) | Num | 20 | |||||
| LineSeq | Line Sequence | Int | 11 | |||||
| DeferrAcct | Deferred Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BaseType | Base Document Type | Int | 11 | -1 | ||||
| BaseAbs | Base Doc Abs Entry | Int | 11 | -1 | ||||
| BaseSeq | Base Doc. Line 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
WTQ4.DocEntry AS 'Internal Document ID',
WTQ4.LineNum AS 'Row Number',
WTQ4.GroupNum AS 'Group No.',
WTQ4.ExpnsCode AS 'Expense Code',
WTQ4.RelateType AS 'Relation Type',
WTQ4.StcCode AS 'Tax Code',
WTQ4.StaCode AS 'Tax Code',
WTQ4.staType AS 'Authority Type',
WTQ4.TaxRate AS 'Authority Type',
WTQ4.TaxAcct AS 'Authority Code',
WTQ4.TaxSum AS 'Tax %',
WTQ4.TaxSumFrgn AS 'Tax Account',
WTQ4.TaxSumSys AS 'Tax Amount',
WTQ4.BaseSum AS 'Tax Amount (FC)',
WTQ4.BaseSumFrg AS 'Base Amount',
WTQ4.BaseSumSys AS 'Base Amount (FC)',
WTQ4.ObjectType AS 'Base Amount (SC)',
WTQ4.LogInstanc AS 'Tax Amount (SC)',
WTQ4.TaxStatus AS 'Base Amount',
WTQ4.VatApplied AS 'VAT Applied',
WTQ4.VatAppldFC AS 'Applied Tax (FC)',
WTQ4.VatAppldSC AS 'Applied Tax (SC)',
WTQ4.LineSeq AS 'Line Sequence',
WTQ4.DeferrAcct AS 'Deferred Tax Account',
WTQ4.BaseType AS 'Base Document Type',
WTQ4.BaseAbs AS 'Base Doc Abs Entry',
WTQ4.BaseSeq AS 'Base Doc. Line Sequence',
WTQ4.DeductTax AS 'Deductible Tax Amount',
WTQ4.DdctTaxFrg AS 'Deductible Tax Amount (FC)',
WTQ4.DdctTaxSys AS 'Deductible Tax Amount (SC)',
WTQ4.BaseAppld AS 'Applied Base Amount',
WTQ4.BaseApldFC AS 'Applied Base Amount (FC)',
WTQ4.BaseApldSC AS 'Applied Base Amount (SC)',
WTQ4.NonDdctPrc AS 'Non Deductible %',
WTQ4.NonDdctAct AS 'Non Deductible Account',
WTQ4.TaxInPrice AS 'Tax Included in Price?',
WTQ4.Exempt AS 'Exempt?',
WTQ4.TaxExpAct AS 'Expense Account for Tax',
WTQ4.OnHoldTax AS 'On Hold Tax Amount',
WTQ4.OnHoldTaxF AS 'On Hold Tax Amount (FC)',
WTQ4.OnHoldTaxS AS 'On Hold Tax Amount (SC)',
WTQ4.InGrossRev AS 'Included in Gross Revenue',
WTQ4.TaxSumOrg AS 'Tax Amount Original',
WTQ4.TaxSumOrgF AS 'Tax Amount Original (FC)',
WTQ4.TaxSumOrgS AS 'Tax Amount Original (SC)',
WTQ4.OpenTax AS 'Open Service Tax',
WTQ4.OpenTaxFC AS 'Open Service Tax (FC)',
WTQ4.OpenTaxSC AS 'Open Service Tax (SC)',
WTQ4.Unencumbrd AS 'Unencumbered'
FROM WTQ4 AS WTQ4
Related information
G/L Accounts OACT SQL Table
Inventory Transfer Request OWTQ 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
