|
|
DTW Administration / Setup / Financials / Tax / Sales Tax Codes
API OSTC / Sales Tax Codes
OSTC - Sales Tax Codes Table
Sales Tax Codes SalesTaxCodes Object· Table: OSTC
OSTC SQL Table
CFOP for Nota Fiscal OCFP SQL Table
Tax Type Combination OTFC 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 | |||||
| Freight | Freight | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| ValidForAR | Valid for A/R | VarChar | Y) Yes N) No | 1 | Y | |||
| ValidForAP | Valid for A/P | VarChar | Y) Yes N) No | 1 | Y | |||
| TfcId | Formula Combination ID | Int | 11 | OTFC Tax Type Combination | ||||
| Lock | Lock Flag | VarChar | Y) Yes N) No | 1 | N | |||
| TaxIcms | Taxation For ICMS | nVarChar | 2 | |||||
| IsItmLevel | Is Single Item Level Tax | VarChar | Y) Yes N) No | 1 | N | |||
| CfopIn | CFOP Incoming Code | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CfopOut | CFOP Outgoing Code | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| FADebit | FA Debit | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OSTC.Code AS 'Code',
OSTC.Name AS 'Name',
OSTC.Rate AS 'Rate',
OSTC.Freight AS 'Freight',
OSTC.UserSign AS 'User Signature',
OSTC.ValidForAR AS 'Valid for A/R',
OSTC.ValidForAP AS 'Valid for A/P',
OSTC.TfcId AS 'Formula Combination ID',
OSTC.Lock AS 'Lock Flag',
OSTC.TaxIcms AS 'Taxation For ICMS',
OSTC.IsItmLevel AS 'Is Single Item Level Tax',
OSTC.CfopIn AS 'CFOP Incoming Code',
OSTC.CfopOut AS 'CFOP Outgoing Code',
OSTC.LogInstanc AS 'Log Instance',
OSTC.UserSign2 AS 'Updating User',
OSTC.UpdateDate AS 'Update Date',
OSTC.FADebit AS 'FA Debit'
FROM OSTC AS OSTC
Related information
Sales Tax Codes SalesTaxCodes Object· Table: OSTC
SalesTaxCodes is a business object that represents the inclusive sales tax codes. Each sales tax code consists of one or more sales taxes as defined in SalesTaxAuthorities object.
This object enables you to:
Add a sales tax code.
Retrieve...
OSTC SQL Table
CFOP for Nota Fiscal OCFP SQL Table
Tax Type Combination OTFC SQL Table
Users OUSR SQL Table
SalesTaxCodes
Method
Object
SalesTaxCodes_Lines STC1
Property
Code
DTW DB
Freight
DTW DB
IsItemLevel
DTW DB
Name
DTW DB
Rate
DB
ValidForAP
DTW DB
ValidForAR
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
