|
|
DTW Purchasing
API ONFN
ONFN - Nota Fiscal Numbering Table
ONFN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ObjectCode KEY UNIQUE | Document | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AutoKey | Automatic Key | Int | 11 | 0 | ||||
| DfltSeq | Default Sequence | Int | 6 | 0 | ||||
| UpdCounter | Update Counter | Int | 6 | 0 | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DocSubType | Document Sub-Type | nVarChar | 2 | -- |
Table relationship map
SELECT statement
SELECT
ONFN.ObjectCode AS 'Document',
ONFN.AutoKey AS 'Automatic Key',
ONFN.DfltSeq AS 'Default Sequence',
ONFN.UpdCounter AS 'Update Counter',
ONFN.UserSign AS 'User Signature',
ONFN.DocSubType AS 'Document Sub-Type'
FROM ONFN AS ONFN
Related information
ONFN 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
