SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: ITM12
Table Description: UoM in Item
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ItemCode |
Item No. |
nVarChar |
50 |
OITM |
|
|
|
| UomType |
UoM Type |
VarChar |
1 |
- |
P |
P |
Purchasing |
| |
|
|
|
|
|
S |
Sales |
| |
|
|
|
|
|
I |
Inventory |
| UomEntry |
UoM Entry |
Int |
11 |
OUOM |
|
|
|
| BcdEntDft |
Default Bar Code Entry |
Int |
11 |
OBCD |
|
|
|
| PkgCodeDft |
Default Package Code |
Int |
11 |
OPKG |
|
|
|
| Height1 |
Height 1 |
Num |
19.6 |
- |
|
|
|
| Hght1Unit |
Height 1 UoM |
Int |
6 |
- |
|
|
|
| Height2 |
Height 2 |
Num |
19.6 |
- |
|
|
|
| Hght2Unit |
Height 2 UoM |
Int |
6 |
- |
|
|
|
| Width1 |
Width 1 |
Num |
19.6 |
- |
|
|
|
| Wdth1Unit |
Width 1 UoM |
Int |
6 |
- |
|
|
|
| Width2 |
Width 2 |
Num |
19.6 |
- |
|
|
|
| Wdth2Unit |
Width 2 UoM |
Int |
6 |
- |
|
|
|
| Length1 |
Length 1 |
Num |
19.6 |
- |
|
|
|
| Len1Unit |
Length 1 UoM |
Int |
6 |
- |
|
|
|
| Length2 |
Length 2 |
Num |
19.6 |
- |
|
|
|
| Len2Unit |
Length 2 UoM |
Int |
6 |
- |
|
|
|
| Volume |
Volume |
Num |
19.6 |
- |
|
|
|
| VolUnit |
Volume UoM |
Int |
6 |
- |
|
|
|
| Weight1 |
Weight 1 |
Num |
19.6 |
- |
|
|
|
| Wght1Unit |
Weight 1 UoM |
Int |
6 |
- |
|
|
|
| Weight2 |
Weight 2 |
Num |
19.6 |
- |
|
|
|
| Wght2Unit |
Weight 2 UoM |
Int |
6 |
- |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
ItemCode |
| |
|
UomType |
| |
|
UomEntry |
| UOM_ENTRY |
No |
UomEntry |