|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Document Numbering
Table Name: ONNM
Table Description: Document Numbering
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ObjectCode | Document | nVarChar | 20 | - | Â | Â | Â |
| AutoKey | Automatic Key | Int | 11 | - | 0 | Â | Â |
| DfltSeries | Default Series | Int | 11 | - | 0 | Â | Â |
| UpdCounter | Update Counter | Int | 11 | - | 0 | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| DocSubType | Document Sub-Type | nVarChar | 2 | - | -- | -- | Â |
| Â | Â | Â | Â | Â | Â | IE | Invoice Exempt |
| Â | Â | Â | Â | Â | Â | DN | Debit Memo |
| Â | Â | Â | Â | Â | Â | IB | Bill |
| Â | Â | Â | Â | Â | Â | EB | Exempt Bill |
| Â | Â | Â | Â | Â | Â | RI | Reserve Invoice |
| Â | Â | Â | Â | Â | Â | IR | Invoice & Receipt |
| Â | Â | Â | Â | Â | Â | DM | A/P Debit Memo |
| Â | Â | Â | Â | Â | Â | IX | Export Invoice |
| Â | Â | Â | Â | Â | Â | RP | A/P Reserve Invoice |
| Â | Â | Â | Â | Â | Â | OV | Outgoing VAT - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OG | Outgoing Gross Income - Withholding Tax |
| Â | Â | Â | Â | Â | Â | ON | Outgoing Income - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OS | Outgoing Social Security - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OI | Outgoing Industry Specific - Withholding Tax |
| Â | Â | Â | Â | Â | Â | OD | Outgoing District Specific - Withholding Tax |
| Â | Â | Â | Â | Â | Â | IC | Incoming WTax Certificate |
| Â | Â | Â | Â | Â | Â | GA | GST Tax Invoice |
| Â | Â | Â | Â | Â | Â | GD | GST Debit Memo |
| Â | Â | Â | Â | Â | Â | RV | Refund Voucher |
| DocAlias | Alternative Document Name | nVarChar | 20 | - | Â | Â | Â |
| PeriodTyp | Seq. Period Type of Supply Code | VarChar | 1 | - | Â | Â | Â |
| logInstanc | Log Instance - History | Int | 11 | - | Â | Â | Â |
| DigManuSer | Digital Manual Series | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | ObjectCode |
| Â | Â | DocSubType |