|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Excise Register Numbering
Table Name: OERN
Table Description: Excise Register Numbering
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| NumTypeID | ID for numbering type | Int | 11 | - | Â | Â | Â |
| NumTypeNam | Name for numbering type | nVarChar | 30 | - | Â | Â | Â |
| FirstNum | First number | Int | 11 | - | 1 | Â | Â |
| NextNum | Next Number | Int | 11 | - | 1 | Â | Â |
| LastNum | Last Number | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| ResetDate | Date of last reset | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | NumTypeID |