|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Documents Numbering - Series
Table Name: NNM1
Table Description: Documents Numbering - Series
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ObjectCode | Document | nVarChar | 20 | ONNM | Â | Â | Â |
| Series | Series | Int | 11 | - | 0 | Â | Â |
| SeriesName | Series Name | nVarChar | 8 | - | Â | Â | Â |
| InitialNum | Initial Number | Int | 11 | - | 0 | Â | Â |
| NextNumber | Next Number for Use | Int | 11 | - | 0 | Â | Â |
| LastNum | Last Number Allowed | Int | 11 | - | Â | Â | Â |
| BeginStr | Prefix String | nVarChar | 20 | - | Â | Â | Â |
| EndStr | Suffix String | nVarChar | 20 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 50 | - | Â | Â | Â |
| GroupCode | Group | Int | 6 | - | 1 | 1 | Series Group 1 |
| Â | Â | Â | Â | Â | Â | 2 | Series Group 2 |
| Â | Â | Â | Â | Â | Â | 3 | Series Group 3 |
| Â | Â | Â | Â | Â | Â | 4 | Series Group 4 |
| Â | Â | Â | Â | Â | Â | 5 | Series Group 5 |
| Â | Â | Â | Â | Â | Â | 6 | Series Group 6 |
| Â | Â | Â | Â | Â | Â | 7 | Series Group 7 |
| Â | Â | Â | Â | Â | Â | 8 | Series Group 8 |
| Â | Â | Â | Â | Â | Â | 9 | Series Group 9 |
| Â | Â | Â | Â | Â | Â | 10 | Series Group 10 |
| Â | Â | Â | Â | Â | Â | 11 | Series Group 11 |
| Â | Â | Â | Â | Â | Â | 12 | Series Group 12 |
| Â | Â | Â | Â | Â | Â | 13 | Series Group 13 |
| Â | Â | Â | Â | Â | Â | 14 | Series Group 14 |
| Â | Â | Â | Â | Â | Â | 15 | Series Group 15 |
| Â | Â | Â | Â | Â | Â | 16 | Series Group 16 |
| Â | Â | Â | Â | Â | Â | 17 | Series Group 17 |
| Â | Â | Â | Â | Â | Â | 18 | Series Group 18 |
| Â | Â | Â | Â | Â | Â | 19 | Series Group 19 |
| Â | Â | Â | Â | Â | Â | 20 | Series Group 20 |
| Â | Â | Â | Â | Â | Â | 21 | Series Group 21 |
| Â | Â | Â | Â | Â | Â | 22 | Series Group 22 |
| Â | Â | Â | Â | Â | Â | 23 | Series Group 23 |
| Â | Â | Â | Â | Â | Â | 24 | Series Group 24 |
| Â | Â | Â | Â | Â | Â | 25 | Series Group 25 |
| Â | Â | Â | Â | Â | Â | 26 | Series Group 26 |
| Â | Â | Â | Â | Â | Â | 27 | Series Group 27 |
| Â | Â | Â | Â | Â | Â | 28 | Series Group 28 |
| Â | Â | Â | Â | Â | Â | 29 | Series Group 29 |
| Â | Â | Â | Â | Â | Â | 30 | Series Group 30 |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| YearTransf | Year-End Closing | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Indicator | Period Indicator | nVarChar | 10 | OPID | ' ' | Â | Â |
| Template | Template | nVarChar | 20 | - | Â | Â | Â |
| NumSize | Numeric Size | Int | 11 | - | Â | Â | Â |
| FolioPref | Folio Prefix String | nVarChar | 4 | - | Â | Â | Â |
| NextFolio | Next Folio Number | Int | 11 | - | Â | Â | Â |
| DocSubType | Document Sub-Type | nVarChar | 2 | - | -- | Â | Â |
| DefESeries | Default Electronic Series | Int | 6 | - | 0 | Â | Â |
| IsDigSerie | Is Digital Series | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SeriesType | Series Type | VarChar | 1 | - | D | D | Document |
| Â | Â | Â | Â | Â | Â | B | Business Partner |
| Â | Â | Â | Â | Â | Â | I | Item |
| Â | Â | Â | Â | Â | Â | R | Resource |
| Â | Â | Â | Â | Â | Â | W | Witholding Certificates |
| IsManual | Is Manual Series | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BPLId | Assigned Branch | Int | 11 | OBPL | Â | Â | Â |
| IsForCncl | Is Series for Cancelation | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AtDocType | AT Document Type | nVarChar | 10 | - | Â | Â | Â |
| IsElAuth | Elec. Authorization Code | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CoAccount | Cost Account Only | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| GenPassprt | Do Generate SAP Passport | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| logInstanc | Log Instance - History | Int | 11 | - | Â | Â | Â |
| PInvType | Abs Type of Positive Value Invoice | Int | 11 | OEIT | Â | Â | Â |
| NInvType | Abs Type of Negative Value Invoice | Int | 11 | OEIT | Â | Â | Â |
| AssignedID | Assigned ID | nVarChar | 70 | - | Â | Â | Â |
| Action | Action | VarChar | 1 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | R | Report |
| Â | Â | Â | Â | Â | Â | C | Cancel |
| Â | Â | Â | Â | Â | Â | F | Finalize |
| Status | Status | VarChar | 1 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | R | Reported |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | F | Finalized |
| Phase | Phase | VarChar | 1 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | T | To Be Processed |
| Â | Â | Â | Â | Â | Â | I | In Process |
| Â | Â | Â | Â | Â | Â | O | OK |
| Â | Â | Â | Â | Â | Â | E | Error |
| Key | Unique | Field |
| PRIMARY | Yes | Series |
| SER_NAME | Yes | ObjectCode |
| Â | Â | DocSubType |
| Â | Â | SeriesName |
| Â | Â | SeriesType |