| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Base Price | Base price for the item/item class/whse/qc grade/frtbill_mthd/uom combination. May be zero. | Item Price.Base Price | BASE_PRICE | BASE_PRICE | 119233 |
| Break Type | Indicates the type of price breaks defined for this record. Valid values are: 0 = no price breaks defined, 1 = qty breakpoints defined, 2 = value breakpoints defined. | Item Price.Break Type | BREAK_TYPE | BREAK_TYPE | 120263 |
| Break point Price | Unit price which applies for this break value/qty. | Item Price.Break point Price | BREAKPOINT_PRICE | BREAKPOINT_PRICE | 120261 |
| Break type ID | Surrogate id which uniquely identifies this row. | Item Price.Break type ID | BREAKTYPE_ID | BREAKTYPE_ID | 120262 |
| Comments | Freeform text/comments. | Item Price.Comments | COMMENTS | COMMENTS | 122592 |
| Created By | | Item Price.Created By | CREATED_BY | CREATED_BY | 125196 |
| Creation Date | | Item Price.Creation Date | CREATION_DATE | CREATION_DATE | 126623 |
| Currency Code | Currency code for pricelist; FK to GL_CURR_MST. | Item Price.Currency Code | CURRENCY_CODE | CURRENCY_CODE | 127046 |
| Frieght Bill Method | Freight bill method to which these prices apply. Contains a NULL value to denote an "ALL" condition. | Item Price.Frieght Bill Method | FRIEGHT_BILL_MTHD | FRIEGHT_BILL_MTHD | 134734 |
| Item Description | Short description of the item that is displayed during the item look up. | Item Price.Item Description | ITEM_DESCRIPTION | ITEM_DESCRIPTION | 137743 |
| Item ID | Surrogate key for the item for which results are recorded. | Item Price.Item ID | ITEM_ID | ITEM_ID | 137784 |
| Item Number | Name of the item. | Item Price.Item Number | ITEM_NUMBER | ITEM_NUMBER | 137849 |
| Item Primary UOM | Uom of the item by which the inventory balances are maintained. | Item Price.Item Primary UOM | ITEM_UOM | ITEM_UOM | 137937 |
| Item Secondary UOM | Second UOM for in which inventory balances are maintained, for dual UOM items. | Item Price.Item Secondary UOM | ITEM_UOM2 | ITEM_UOM2 | 137950 |
| Last Update Date | | Item Price.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 141150 |
| Last Updated By | | Item Price.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139776 |
| Price Break point Factor | Percent which is applied to base price for this price detail to compute the unit price for the break value or qty. | Item Price.Price Break point Factor | BREAKPOINT_FACTOR | BREAKPOINT_FACTOR | 120260 |
| Price Break point Quantity | Quantity break for price. | Item Price.Price Break point Quantity | QTY_BREAKPOINT | QTY_BREAKPOINT | 157178 |
| Price Break point Value | Value break for price (item qty * base price). | Item Price.Price Break point Value | VALUE_BREAKPOINT | VALUE_BREAKPOINT | 167302 |
| Price Class | Item price class. May be NULL when ITEM_ID has a valid value. | Item Price.Price Class | PRICE_CLASS | PRICE_CLASS | 155322 |
| Price ID | Surrogate id to uniquely identify each row. | Item Price.Price ID | PRICE_ID | PRICE_ID | 155329 |
| Price Item Line Number | For use with future or custom pricing when fields, such as attribute columns, are used as part of the key, but are not part of the defined key. Default is zero. | Item Price.Price Item Line Number | PRICEITEM_LINE_NO | PRICEITEM_LINE_NO | 155294 |
| Price Type | Type of prices established as price breaks. Valid values are: 0 ,1,2 & 3 | Item Price.Price Type | PRICE_TYPE | PRICE_TYPE | 155390 |
| Price Uom | Pricing uom | Item Price.Price Uom | PRICE_UOM | PRICE_UOM | 155391 |
| Price break Line No | Part of primary key to distinguish between unique quantity and value breaks. | Item Price.Price break Line No | PRICEBREAK_LINE_NO | PRICEBREAK_LINE_NO | 155293 |
| Price list Code | Unique identifier for a pricelist. Name or code entered by user. | Item Price.Price list Code | PRICELIST_CODE | PRICELIST_CODE | 155295 |
| Price list Description | Description of price list. | Item Price.Price list Description | PRICELIST_DESC1 | PRICELIST_DESC1 | 155296 |
| Price list ID | Pricelist to which these item prices belong. | Item Price.Price list ID | PRICELIST_ID | PRICELIST_ID | 155297 |
| Price sort Name | Pricelist sort name. | Item Price.Price sort Name | PRICESORT_NAME | PRICESORT_NAME | 155298 |
| Quality Control Grade | QC grade of the lot. | Item Price.Quality Control Grade | QC_GRADE | QC_GRADE | 157152 |
| Warehouse Code | Warehouse which contains the item balances. | Item Price.Warehouse Code | WAREHOUSE_CODE | WAREHOUSE_CODE | 167694 |
| Warehouse Description | Name of the warehouse. | Item Price.Warehouse Description | WAREHOUSE_DESC | WAREHOUSE_DESC | 167700 |