📚 SAP Business One SDK Help

Table Name: OSTA

Table Description: Sales Tax Authorities

Field Description Type Size Related Default Value Constraints
Code Code nVarChar 8 -      
Name Name nVarChar 100 -      
Rate Rate Num 19.6 -      
SalesTax Sales Tax Account nVarChar 15 OACT      
UseTax Use Tax Account nVarChar 15 OACT      
Type Type Int 11 OSTT      
UserSign User Signature Int 6 OUSR      
PurchTax Purchasing Tax Account nVarChar 15 OACT      
deferrAcct Deferred Tax Account nVarChar 15 OACT      
NonDdctPrc Non Deductible % Num 19.6 -      
NonDdctAct Non Deductible Account nVarChar 15 OACT      
TaxInPrice Included in Price VarChar 1 - N Y Yes
            N No
Exempt Exempt VarChar 1 - N Y Yes
            N No
APExpAct Purchasing Tax Expense Account nVarChar 15 OACT      
ARExpAct Sales Tax Expense Account nVarChar 15 OACT      
CredBala Credit Balance: Raw Material Num 19.6 -      
CredFG Credit for Finished Goods Num 19.6 -      
CredCG Credit for Capital Goods Num 19.6 -      
InGrossRev Included in Gross Revenue VarChar 1 - N Y Yes
            N No
EfctDate Effective From Date 8 -      
SvcTaxCr Credit for Service Tax Num 19.6 -      
MinAmount Min. Taxable Amount Num 19.6 -      
MaxAmount Max. Taxable Amount Num 19.6 -      
FlatAmount Flat Tax Amount Num 19.6 -      
TextCode Text Code Int 6 -      
UnencumTax Unencumbered Tax VarChar 1 - N Y Yes
            N No
TaxOnRI Tax On Reserve Invoice VarChar 1 - N Y Yes
            N No
DIOTRptTyp DIOT Report Type VarChar 1 -      
            A 15% or 16% VAT
            B 15% or 16% VAT on Import
            C Exempt on Import
            D 0% VAT
            E Exempt
            F VAT on Returns, Discounts, and Rebates
            G Stimulus for Northern Border Region
            H IEPS Tax
            I Stimulus for Southern Border Region
IsSystem Is System Tax Jurisdiction VarChar 1 - N Y Yes
            N No
RvsCrgPrc Reverse Charge % Num 19.6 -      
InFirstIns Included in First Installment VarChar 1 - N Y Yes
            N No
SaleTaxRCM Sales Tax RCM Account nVarChar 15 OACT      
SaleRCMClr Sales Tax RCM Clearing Account nVarChar 15 OACT      
VatExempt Apply VAT Exemption VarChar 1 - N Y Yes
            N No
VatExmPrc VAT Exemption % Num 19.6 -      
VatExmBase Base VAT % Num 19.6 -      
Key Unique Field
PRIMARY Yes Code
    Type