ONFT - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

CST Code for Nota Fiscal / Nota Fiscal Tax Category (Brazil)

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

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

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

OGPC SQL Table

biuan SAP® BUSINESS ONE

Object
NotaFiscalCST

Property
TaxCategory

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

Code

UserFields

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