|
|
SAP Business One SDK 10.0 - Database Tables Reference |
PEPPOL BIS Code Lists
Table Name: OUNCL
Table Description: PEPPOL BIS Code Lists
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| Codelist | Code List | Int | 11 | - | Â | 1 | Order Type Code |
| Â | Â | Â | Â | Â | Â | 2 | Delivery Type Code |
| Â | Â | Â | Â | Â | Â | 3 | Invoice Type Code |
| Â | Â | Â | Â | Â | Â | 4 | Credit Note Type Code |
| Â | Â | Â | Â | Â | Â | 5 | Standard Item Type Identification Code |
| Â | Â | Â | Â | Â | Â | 6 | Item Commodity Classification Code |
| Code | Code | nVarChar | 20 | - | Â | Â | Â |
| Descrip | Description | nVarChar | 254 | - | Â | Â | Â |
| SchemaCode | Schema Code | nVarChar | 20 | - | Â | Â | Â |
| SchemaDesc | Schema Description | nVarChar | 254 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| IsDefault | Is Default | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Code | Yes | Codelist |
| Â | Â | Code |
| Â | Â | SchemaCode |
| IsDefault | No | IsDefault |