biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Sales Tax Authorities / Valid Period
API Sales Tax Authorities / Tax Definitions
STA1 - Valid Period Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
StaCode KEY UNIQUETax Parameter CodenVarChar
8OSTA
Sales Tax Authorities
PRIMARYYes
SttTypeTax TypeInt
11OSTT
Sales Tax Authorities Type
EfctDateEffective FromDate
8
RateRateNum
20

Table relationship map

SELECT statement

SELECT STA1.StaCode AS 'Tax Parameter Code', STA1.SttType AS 'Tax Type', STA1.EfctDate AS 'Effective From', STA1.Rate AS 'Rate' FROM STA1 AS STA1

Related information


Tax Definitions TaxDefinitions Object· Table: STA1
A set of tax rates for different time periods for a particular sales tax jurisdiction. Source table: STA1
   Parent: Sales Tax Authorities SalesTaxAuthorities Object· Table: OSTA
Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT 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