biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Sales Tax Authorities
API OSTA / Sales Tax Authorities
OSTA - Sales Tax Authorities Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
8
PRIMARYYes
NameNamenVarChar
100
RateRateNum
20
SalesTaxSales Tax AccountnVarChar
15OACT
G/L Accounts
UseTaxUse Tax AccountnVarChar
15OACT
G/L Accounts
TypeTypeInt
11OSTT
Sales Tax Authorities Type
UserSignUser SignatureInt
6OUSR
Users
PurchTaxPurchasing Tax AccountnVarChar
15OACT
G/L Accounts
deferrAcctDeferred Tax AccountnVarChar
15OACT
G/L Accounts
NonDdctPrcNon Deductible %Num
20
NonDdctActNon Deductible AccountnVarChar
15OACT
G/L Accounts
TaxInPriceIncluded in PriceVarChar
Y) Yes
N) No
1
N
ExemptExemptVarChar
Y) Yes
N) No
1
N
APExpActPurchasing Tax Expense AccountnVarChar
15OACT
G/L Accounts
ARExpActSales Tax Expense AccountnVarChar
15OACT
G/L Accounts
CredBalaCredit Balance: Raw MaterialNum
20
CredFGCredit for Finished GoodsNum
20
CredCGCredit for Capital GoodsNum
20
InGrossRevIncluded in Gross RevenueVarChar
Y) Yes
N) No
1
N
EfctDateEffective FromDate
8
SvcTaxCrCredit for Service TaxNum
20
MinAmountMin. Taxable AmountNum
20
MaxAmountMax. Taxable AmountNum
20
FlatAmountFlat Tax AmountNum
20
TextCodeText CodeInt
6
UnencumTaxUnencumbered TaxVarChar
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



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