|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Folio Numbering - Series
Table Name: OFNS
Table Description: Folio Numbering - Series
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Series | Series ID | Int | 11 | - | Â | Â | Â |
| Name | Name | nVarChar | 100 | - | Â | Â | Â |
| PTICode | POI Code | nVarChar | 5 | OPTI | Â | Â | Â |
| FirstNum | First Number | Int | 11 | - | Â | Â | Â |
| NextNum | Next Number | Int | 11 | - | Â | Â | Â |
| LastNum | Last Number | Int | 11 | - | Â | Â | Â |
| Letter | Letter | VarChar | 1 | - | Â | A | A |
| Â | Â | Â | Â | Â | Â | B | B |
| Â | Â | Â | Â | Â | Â | C | C |
| Â | Â | Â | Â | Â | Â | E | E |
| Â | Â | Â | Â | Â | Â | M | M |
| Â | Â | Â | Â | Â | Â | R | R |
| Â | Â | Â | Â | Â | Â | T | T |
| Â | Â | Â | Â | Â | Â | X | X |
| Â | Â | Â | Â | Â | Â | - | - |
| CAI | CAI | nVarChar | 14 | - | Â | Â | Â |
| CAIDueDate | CAI Due Date | Date | 8 | - | Â | Â | Â |
| Remarks | Remarks | nVarChar | 100 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | Series |
| NAME | Yes | Name |