|
|
SAP Business One SDK 10.0 - Database Tables Reference |
NF Skipped Numbers
Table Name: NFN5
Table Description: NF Skipped Numbers
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SeqCode | Sequence Code | Int | 6 | - | Â | Â | Â |
| NFeNoFrom | NF-e No. From | Int | 11 | - | 0 | Â | Â |
| NFeNoTo | NF-e No. To | Int | 11 | - | 0 | Â | Â |
| Year | Year | Int | 6 | - | Â | Â | Â |
| Reason | Reason for Number Skipping | nVarChar | 254 | - | Â | Â | Â |
| Reply | Reply from the Authority | nVarChar | 50 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | N | N | New |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | A | Approved |
| Â | Â | Â | Â | Â | Â | E | Error |
| VisOrder | Visual Order | Int | 6 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Creation Time | Int | 11 | - | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | SeqCode |
| Â | Â | VisOrder |