|
|
DTW Inventory / Price Lists / Special Prices
API NFN4
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 |
|---|---|---|---|---|---|---|---|---|
| SeqCode | Sequence Code | Int | 6 | |||||
| SeqName | Seq Name | nVarChar | 8 | |||||
| Serial | Serial Number | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 | |||||
| DocSubType | Document Sub-Type | nVarChar | 2 | -- | ||||
| Model | Nota Fiscal Model | nVarChar | 6 | ONFM Nota Fiscal Model | ||||
| CardCode | Customer/Vendor Code | nVarChar | 15 | OCRD Business Partner | ||||
| DocEntry | Document Abs. Entry | Int | 11 | |||||
| DocNumber | Document Number | Int | 11 | |||||
| IsReusable | Is Reusable | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
NFN4.ObjectCode AS 'Document',
NFN4.SeqCode AS 'Sequence Code',
NFN4.SeqName AS 'Seq Name',
NFN4.Serial AS 'Serial Number',
NFN4.SeriesStr AS 'Series String',
NFN4.SubStr AS 'Subseries String',
NFN4.DocSubType AS 'Document Sub-Type',
NFN4.Model AS 'Nota Fiscal Model',
NFN4.CardCode AS 'Customer/Vendor Code',
NFN4.DocEntry AS 'Document Abs. Entry',
NFN4.DocNumber AS 'Document Number',
NFN4.IsReusable AS 'Is Reusable'
FROM NFN4 AS NFN4
Related information
Business Partner OCRD SQL Table
Nota Fiscal Model ONFM SQL Table
Nota Fiscal Numbering ONFN SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates