|
|
DTW Production / Production Orders
API NFN1
NFN1 - Not a Fiscal Sequence Table
Business Place OBPL SQL Table
Brazil Numeric Indexer OBNI SQL Table
Period Indicator OPID SQL Table
Location OLCT SQL Table
Nota Fiscal Model ONFM SQL Table
Nota Fiscal Numbering ONFN 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 | S_NAME | Yes |
|---|---|---|---|---|---|---|---|---|
| SeqCode | Seq. Code | Int | 6 | 0 | ||||
| SeqName | Seq. Name | nVarChar | 8 | |||||
| InitialNum | Initial Number | Int | 11 | 0 | ||||
| NextNum | Next Number for Use | Int | 11 | 0 | ||||
| LastNum | Last Number Allowed | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 | |||||
| Remark | Remarks | nVarChar | 50 | |||||
| GroupCode | Group | Int | 1) 2) 3) 4) 5) 6) 7) 8) 9) 10) | 6 | 1 | |||
| Locked | Locked | VarChar | Y) N) | 1 | N | |||
| YearTransf | Year-End Closing | VarChar | Y) N) | 1 | N | |||
| Indicator | Period Indicator | nVarChar | ' ') | 10 | OPID Period Indicator | ' ' | ||
| Template | Template | nVarChar | 20 | |||||
| NumSize | Numeric Size | Int | 11 | |||||
| Prefix | Prefix | nVarChar | 8 | |||||
| Suffix | Suffix | nVarChar | 8 | |||||
| DocSubType | Document Sub-Type | nVarChar | 2 | -- | ||||
| Model | Nota Fiscal Model | nVarChar | 6 | ONFM Nota Fiscal Model | 0 | |||
| Location | Location Code | Int | 11 | OLCT Location | ||||
| BPLId | Assigned Branch | Int | 11 | OBPL Business Place | 0 | |||
| IsDigital | Digital Series | VarChar | Y) Yes N) No | 1 | N | |||
| EnvTypeNFe | Environment Type NF-e | Int | 11 | OBNI Brazil Numeric Indexer | -1 |
Table relationship map
SELECT statement
SELECT
NFN1.ObjectCode AS 'Document',
NFN1.SeqCode AS 'Seq. Code',
NFN1.SeqName AS 'Seq. Name',
NFN1.InitialNum AS 'Initial Number',
NFN1.NextNum AS 'Next Number for Use',
NFN1.LastNum AS 'Last Number Allowed',
NFN1.SeriesStr AS 'Series String',
NFN1.SubStr AS 'Subseries String',
NFN1.Remark AS 'Remarks',
NFN1.GroupCode AS 'Group',
NFN1.Locked AS 'Locked',
NFN1.YearTransf AS 'Year-End Closing',
NFN1.Indicator AS 'Period Indicator',
NFN1.Template AS 'Template',
NFN1.NumSize AS 'Numeric Size',
NFN1.Prefix AS 'Prefix',
NFN1.Suffix AS 'Suffix',
NFN1.DocSubType AS 'Document Sub-Type',
NFN1.Model AS 'Nota Fiscal Model',
NFN1.Location AS 'Location Code',
NFN1.BPLId AS 'Assigned Branch',
NFN1.IsDigital AS 'Digital Series',
NFN1.EnvTypeNFe AS 'Environment Type NF-e'
FROM NFN1 AS NFN1
Related information
Business Place OBPL SQL Table
Brazil Numeric Indexer OBNI SQL Table
Period Indicator OPID SQL Table
Location OLCT 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
