|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Not a Fiscal Sequence
Table Name: NFN1
Table Description: Not a Fiscal Sequence
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ObjectCode | Document | nVarChar | 20 | ONFN | Â | Â | Â |
| 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 | 6 | - | 1 | 1 | Â |
| Â | Â | Â | Â | Â | Â | 2 | Â |
| Â | Â | Â | Â | Â | Â | 3 | Â |
| Â | Â | Â | Â | Â | Â | 4 | Â |
| Â | Â | Â | Â | Â | Â | 5 | Â |
| Â | Â | Â | Â | Â | Â | 6 | Â |
| Â | Â | Â | Â | Â | Â | 7 | Â |
| Â | Â | Â | Â | Â | Â | 8 | Â |
| Â | Â | Â | Â | Â | Â | 9 | Â |
| Â | Â | Â | Â | Â | Â | 10 | Â |
| Locked | Locked | VarChar | 1 | - | N | Y | Â |
| Â | Â | Â | Â | Â | Â | N | Â |
| YearTransf | Year-End Closing | VarChar | 1 | - | N | Y | Â |
| Â | Â | Â | Â | Â | Â | N | Â |
| Indicator | Period Indicator | nVarChar | 10 | OPID | ' ' | ' ' | Â |
| 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 | 0 | Â | Â |
| Location | Location Code | Int | 11 | OLCT | Â | Â | Â |
| BPLId | Assigned Branch | Int | 11 | OBPL | 0 | Â | Â |
| IsDigital | Digital Series | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnvTypeNFe | Environment Type NF-e | Int | 11 | OBNI | -1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ObjectCode |
| Â | Â | DocSubType |
| Â | Â | SeqCode |
| S_NAME | Yes | ObjectCode |
| Â | Â | DocSubType |
| Â | Â | BPLId |
| Â | Â | SeqName |