|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Item - UoM Prices
Table Name: ITM9
Table Description: Item - UoM Prices
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| PriceList | Price List No. | Int | 6 | OPLN | Â | Â | Â |
| UomEntry | UoM Entry | Int | 11 | OUOM | Â | Â | Â |
| Factor | Reduced By % | Num | 19.6 | - | Â | Â | Â |
| Price | UoM Price | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency for UoM Price | nVarChar | 3 | OCRN | Â | Â | Â |
| AutoUpdate | Automatic Update | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AddPrice1 | Additional Price (1) | Num | 19.6 | - | Â | Â | Â |
| Currency1 | Currency for Add. Price 1 | nVarChar | 3 | OCRN | Â | Â | Â |
| AddPrice2 | Additional Price (2) | Num | 19.6 | - | Â | Â | Â |
| Currency2 | Currency for Add. Price 2 | nVarChar | 3 | OCRN | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object | nVarChar | 20 | ADP1 | 4 | Â | Â |
| Factor1 | Reduced By % | Num | 19.6 | - | Â | Â | Â |
| Factor2 | Reduced By % | Num | 19.6 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| PriceType | Price Type | VarChar | 1 | - | O | I | Inventory UoM Price |
| Â | Â | Â | Â | Â | Â | P | Pricing Unit Price |
| Â | Â | Â | Â | Â | Â | M | Both I and P |
| Â | Â | Â | Â | Â | Â | O | Other UoM Price |
| Key | Unique | Field |
| PRIMARY | Yes | ItemCode |
| Â | Â | PriceList |
| Â | Â | UomEntry |