|
|
DTW Administration / System Initialization / Nota Fiscal Tax Category (Brazil)
API Nota Fiscal CST / Tax Category
ONFT - Nota Fiscal Tax Category (Brazil) Table
Tax Category TaxCategory Property· Table: ONFT
Parent: Nota Fiscal CST NotaFiscalCST Object· Table: OTSC
ONFT SQL Table
Government Payment Code OGPC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | Tax Category | nVarChar | 20 | CODE | Yes | |||
| Locked | Locked | VarChar | N) Y) | 1 | N | |||
| GPCId | Government Payment Code | Int | 11 | OGPC Government Payment Code | -1 |
Table relationship map
SELECT statement
SELECT
ONFT.AbsId AS 'Internal Number',
ONFT.Code AS 'Tax Category',
ONFT.Locked AS 'Locked',
ONFT.GPCId AS 'Government Payment Code'
FROM ONFT AS ONFT
Related information
Tax Category TaxCategory Property· Table: ONFT
The tax category for the CST code.
Field name: Category
This field is a foreign key to the ONFT table.
Parent: Nota Fiscal CST NotaFiscalCST Object· Table: OTSC ONFT SQL Table
Government Payment Code OGPC SQL Table
NotaFiscalCST
Property
TaxCategory
Method
Property
Code
DB
Situation
DB
TaxCategory
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
