|
|
SQL Administration / CNAE Code
DTW Administration / Setup / Business Partners / BPFiscalRegistryID
API OCNA / BP Fiscal Registry ID
OCNA - CNAE Code Table
BP Fiscal Registry ID BPFiscalRegistryID Object· Table: OCNA
OCNA 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 |
|---|---|---|---|---|---|---|---|---|
| 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
BP Fiscal Registry ID 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
BPFiscalRegistryID
Method
Property
CNAECode
DTW DB
Description
DTW DB
Numerator
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates