|
|
API AST1
AST1 - Sales Tax Codes - Rows Table
Tax Formula Master Table OFML SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Codes OSTC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | STCCode KEY UNIQUE | STC Code | nVarChar | 8 | OSTC Sales Tax Codes | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line_ID | Row Number | Int | 11 | 0 | ||||
| STACode | STA Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| STAType | STA Type | Int | 11 | OSTA Sales Tax Authorities | ||||
| TaxOnTCode | STA Tax on Tax Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| TaxOnTType | STA Tax On Tax Type | Int | 11 | OSTA Sales Tax Authorities | ||||
| EfctivRate | Effective Rate | Num | 20 | |||||
| FmlId | Tax Formula ID | Int | 11 | OFML Tax Formula Master Table | ||||
| CstCodeIn | CST Code Incoming | nVarChar | 20 | |||||
| CstSuffix | CST Suffix for ICMS | nVarChar | 2 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
AST1.STCCode AS 'STC Code',
AST1.Line_ID AS 'Row Number',
AST1.STACode AS 'STA Code',
AST1.STAType AS 'STA Type',
AST1.TaxOnTCode AS 'STA Tax on Tax Code',
AST1.TaxOnTType AS 'STA Tax On Tax Type',
AST1.EfctivRate AS 'Effective Rate',
AST1.FmlId AS 'Tax Formula ID',
AST1.CstCodeIn AS 'CST Code Incoming',
AST1.CstSuffix AS 'CST Suffix for ICMS',
AST1.LogInstanc AS 'Log Instance'
FROM AST1 AS AST1
Related information
Tax Formula Master Table OFML SQL Table
Sales Tax Authorities OSTA 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
