|
|
DTW Administration / Setup / General / Territories
API ACFP
ACFP - CFOP for Nota Fiscal Table
Users OUSR SQL Table
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) OB Server 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 |
SELECT statement
SELECT
ACFP.ID AS 'CFOP ID',
ACFP.Code AS 'CFOP Code',
ACFP.Descrip AS 'Description',
ACFP.App AS 'Application',
ACFP.Locked AS 'Locked',
ACFP.DataSource AS 'Data Source',
ACFP.UserSign AS 'User Signature',
ACFP.LogInstanc AS 'Log Instance',
ACFP.UserSign2 AS 'Updating User',
ACFP.UpdateDate AS 'Update Date'
FROM ACFP AS ACFP
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
