biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Nota Fiscal Tax Category (Brazil)
API Nota Fiscal CST / Tax Category
ONFT - Nota Fiscal Tax Category (Brazil) Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUETax CategorynVarChar
20
CODEYes
LockedLockedVarChar
N)
Y)
1
N
GPCIdGovernment Payment CodeInt
11OGPC
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates