|
|
DTW Administration / Setup / General / User Default Groups
API OCFP / / Nota Fiscal CFOP
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ID KEY UNIQUE | CFOP ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | CFOP Code | nVarChar | 6 | CFOP_CODE | Yes | |||
| Descrip | Description | Text | 16 | |||||
| App | Application | Text | 16 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) OBServer A) Auto Incr. D) Data Doc. P) Partner Implementation | 1 | N | |||
| UserSign | User Signature | nVarChar | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
OCFP.ID AS 'CFOP ID',
OCFP.Code AS 'CFOP Code',
OCFP.Descrip AS 'Description',
OCFP.App AS 'Application',
OCFP.Locked AS 'Locked',
OCFP.DataSource AS 'Data Source',
OCFP.UserSign AS 'User Signature',
OCFP.LogInstanc AS 'Log Instance',
OCFP.UserSign2 AS 'Updating User',
OCFP.UpdateDate AS 'Update Date'
FROM OCFP AS OCFP
Related information
Nota Fiscal CFOP NotaFiscalCFOP Object· Table: OCFP
Represents CFOP codes for Nota Fiscal documents.
CFOP codes describes the business transaction from the tax authorities' point of view.
Source table: OCFP
OCFP SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates