|
|
DTW Production / Bill of Materials
API NFN2
NFN2 - NFSeq User Default Table
Nota Fiscal Numbering 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 | ONFN Nota Fiscal Numbering | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| UserSign KEY | User Signature | Int | 6 | OUSR Users | USER | No | ||
| SeqCode | Sequence Code | Int | 6 | |||||
| DocSubType | Document Sub-Type | nVarChar | 2 | -- |
Table relationship map
SELECT statement
SELECT
NFN2.ObjectCode AS 'Document',
NFN2.UserSign AS 'User Signature',
NFN2.SeqCode AS 'Sequence Code',
NFN2.DocSubType AS 'Document Sub-Type'
FROM NFN2 AS NFN2
Related information
Nota Fiscal Numbering 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
