|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Items - Prices
Table Name: ITM1
Table Description: Items - Prices
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| PriceList | Price List No. | Int | 6 | OPLN | Â | Â | Â |
| Price | List Price | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency for List Price | nVarChar | 3 | OCRN | Â | Â | Â |
| Ovrwritten | Manual Price Entry | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Factor | Factor | Num | 19.6 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object | nVarChar | 20 | ADP1 | 4 | Â | Â |
| 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 | Â | Â | Â |
| Ovrwrite1 | Manual Price Entry (1) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Ovrwrite2 | Manual Price Entry (2) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BasePLNum | Base Price List No. | Int | 6 | OPLN | Â | Â | Â |
| UomEntry | UoM Entry | Int | 11 | OUOM | Â | Â | Â |
| PriceType | Price Type | VarChar | 1 | - | M | I | Inventory UoM Price |
| Â | Â | Â | Â | Â | Â | P | Pricing Unit Price |
| Â | Â | Â | Â | Â | Â | M | Both I and P |
| Â | Â | Â | Â | Â | Â | O | Other UoM Price |
| Key | Unique | Field |
| PRIMARY | Yes | ItemCode |
| Â | Â | PriceList |
| CURRENCY | No | Currency |
| PRICE_LIST | No | PriceList |
| MANUAL | No | Ovrwritten |