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

SQL

Administration /

CNAE Code

DTW Administration / Setup / Business Partners / BPFiscalRegistryID

API OCNA / BP Fiscal Registry ID

OCNA - CNAE Code Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
AbsId ^KEY ^UNIQUE	Internal Number	Int	11	PRIMARY	Yes
CNAECode ^KEY ^UNIQUE	Code	nVarChar	9	CODE	Yes
Descrip	Description	Text	16

SELECT statement

SELECT
   OCNA.AbsId AS 'Internal Number', 
   OCNA.CNAECode AS 'Code', 
   OCNA.Descrip AS 'Description'
FROM OCNA AS OCNA

Related information

BPFiscalRegistryID Object· Table: OCNA

BPFiscalRegistryID is a data structure related to the BusinessPartnersService. BPFiscalRegistryID describes the type of the company's business activity (this information is required in some Brazilian legal reports). Moreover, government use...

OCNA SQL Table

biuan SAP® BUSINESS ONE

Object
BPFiscalRegistryID

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

CNAECode

DTW DB

Description

DTW DB

Numerator

DTW DB

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