|
|
SAP Business One SDK 10.0 - Database Tables Reference |
UoM Master Data
Table Name: OUOM
Table Description: UoM Master Data
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| UomEntry | UoM Abs. Entry | Int | 11 | - | Â | Â | Â |
| UomCode | UoM Code | nVarChar | 20 | - | Â | Â | Â |
| UomName | UoM Name | nVarChar | 100 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| LogInstanc | Log Instance | Int | 6 | - | 0 | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| Length1 | Length 1 | Num | 19.6 | - | Â | Â | Â |
| Len1Unit | Unit of Length 1 | Int | 6 | - | Â | Â | Â |
| length2 | Length 2 | Num | 19.6 | - | Â | Â | Â |
| Len2Unit | Unit of Length 2 | Int | 6 | - | Â | Â | Â |
| Width1 | Width 1 | Num | 19.6 | - | Â | Â | Â |
| Wdth1Unit | Unit of Width 1 | Int | 6 | - | Â | Â | Â |
| Width2 | Width 2 | Num | 19.6 | - | Â | Â | Â |
| Wdth2Unit | Unit of Width 2 | Int | 6 | - | Â | Â | Â |
| Height1 | Height 1 | Num | 19.6 | - | Â | Â | Â |
| Hght1Unit | Unit of Height 1 | Int | 6 | - | Â | Â | Â |
| Height2 | Height 2 | Num | 19.6 | - | Â | Â | Â |
| Hght2Unit | Unit of Height 2 | Int | 6 | - | Â | Â | Â |
| Volume | Volume | Num | 19.6 | - | Â | Â | Â |
| VolUnit | Volume UoM | Int | 6 | - | Â | Â | Â |
| Weight1 | Weight 1 | Num | 19.6 | - | Â | Â | Â |
| WghtUnit | Weight UoM | Int | 6 | - | Â | Â | Â |
| Weight2 | Weight 2 | Num | 19.6 | - | Â | Â | Â |
| Wght2Unit | Unit of Weight 2 | Int | 6 | - | Â | Â | Â |
| IntSymbol | International Symbol | nVarChar | 20 | - | Â | Â | Â |
| EwbUnit | EWB Unit | Int | 11 | OEUT | Â | Â | Â |
| PPWeight1 | Plastic Packaging Weight 1 | Num | 19.6 | - | Â | Â | Â |
| PPWe1Unit | Plastic Packaging Weight 1 Unit | Int | 6 | - | Â | Â | Â |
| PPWeight2 | Plastic Packaging Weight 2 | Num | 19.6 | - | Â | Â | Â |
| PPWe2Unit | Plastic Packaging Weight 2 Unit | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | UomEntry |
| CODE | Yes | UomCode |
| NAME | No | UomName |