|
|
DTW Administration / Setup / Financials / Tax / Sales Tax Authorities
API OSTA / Sales Tax Authorities
OSTA - Sales Tax Authorities Table
Sales Tax Authorities SalesTaxAuthorities Object· Table: OSTA
OSTA SQL Table
G/L Accounts OACT SQL Table
Sales Tax Authorities Type OSTT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 100 | |||||
| Rate | Rate | Num | 20 | |||||
| SalesTax | Sales Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| UseTax | Use Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Type | Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| PurchTax | Purchasing Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| deferrAcct | Deferred Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| NonDdctPrc | Non Deductible % | Num | 20 | |||||
| NonDdctAct | Non Deductible Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TaxInPrice | Included in Price | VarChar | Y) Yes N) No | 1 | N | |||
| Exempt | Exempt | VarChar | Y) Yes N) No | 1 | N | |||
| APExpAct | Purchasing Tax Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ARExpAct | Sales Tax Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CredBala | Credit Balance: Raw Material | Num | 20 | |||||
| CredFG | Credit for Finished Goods | Num | 20 | |||||
| CredCG | Credit for Capital Goods | Num | 20 | |||||
| InGrossRev | Included in Gross Revenue | VarChar | Y) Yes N) No | 1 | N | |||
| EfctDate | Effective From | Date | 8 | |||||
| SvcTaxCr | Credit for Service Tax | Num | 20 | |||||
| MinAmount | Min. Taxable Amount | Num | 20 | |||||
| MaxAmount | Max. Taxable Amount | Num | 20 | |||||
| FlatAmount | Flat Tax Amount | Num | 20 | |||||
| TextCode | Text Code | Int | 6 | |||||
| UnencumTax | Unencumbered Tax | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OSTA.Code AS 'Code',
OSTA.Name AS 'Name',
OSTA.Rate AS 'Rate',
OSTA.SalesTax AS 'Sales Tax Account',
OSTA.UseTax AS 'Use Tax Account',
OSTA.Type AS 'Type',
OSTA.UserSign AS 'User Signature',
OSTA.PurchTax AS 'Purchasing Tax Account',
OSTA.deferrAcct AS 'Deferred Tax Account',
OSTA.NonDdctPrc AS 'Non Deductible %',
OSTA.NonDdctAct AS 'Non Deductible Account',
OSTA.TaxInPrice AS 'Included in Price',
OSTA.Exempt AS 'Exempt',
OSTA.APExpAct AS 'Purchasing Tax Expense Account',
OSTA.ARExpAct AS 'Sales Tax Expense Account',
OSTA.CredBala AS 'Credit Balance: Raw Material',
OSTA.CredFG AS 'Credit for Finished Goods',
OSTA.CredCG AS 'Credit for Capital Goods',
OSTA.InGrossRev AS 'Included in Gross Revenue',
OSTA.EfctDate AS 'Effective From',
OSTA.SvcTaxCr AS 'Credit for Service Tax',
OSTA.MinAmount AS 'Min. Taxable Amount',
OSTA.MaxAmount AS 'Max. Taxable Amount',
OSTA.FlatAmount AS 'Flat Tax Amount',
OSTA.TextCode AS 'Text Code',
OSTA.UnencumTax AS 'Unencumbered Tax'
FROM OSTA AS OSTA
Related information
Sales Tax Authorities SalesTaxAuthorities Object· Table: OSTA
SalesTaxAuthorities is a business object that represents the sales tax jurisdictions data for US and Canada localizations, or sales tax types for Latin America localization.
In US and Canada localizations, the sales tax jurisdictions can be...
OSTA SQL Table
G/L Accounts OACT SQL Table
Sales Tax Authorities Type OSTT SQL Table
Users OUSR SQL Table
SalesTaxAuthorities
Method
Object
TaxDefinitions STA1
Property
AOrPTaxAccount
DTW DB
AOrRTaxAccount
DTW DB
Code
DTW DB
DeferredTaxAccount
DTW DB
FlatTaxAmount
DTW DB
MaxTaxableAmount
DTW DB
MinTaxableAmount
DTW DB
Name
DTW DB
NonDeductibleAccount
DTW DB
NonDeductiblePrecent
DTW DB
Rate
DTW DB
Type
DTW DB
UseTaxAccount
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
