| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| currency_id | NUMBER | 39 | 0 | Currency ID | |||
| date_last_modified | TIMESTAMP | Date last modified (GMT). This states when the price type was modified. | |||||
| discount_pct | NUMBER | 5 | 2 | Default discount % | |||
| isinactive | VARCHAR2 | 3 | item is inactive | ||||
| isonline | VARCHAR2 | 3 | Display in web site | ||||
| item_id | NUMBER | 39 | 0 | Item ID | |||
| item_price_extid | VARCHAR2 | 255 | Item price external ID | ||||
| item_price_id | NUMBER | 39 | 0 | Item price ID | |||
| item_quantity_id | NUMBER | 39 | 0 | Item quantity ID | |||
| item_unit_price | NUMBER | 30 | 15 | Item unit price | |||
| name | VARCHAR2 | 60 | Name |