| id |
integer |
Yes |
Yes |
nextval('inventory_price_matrix_id_seq'::regclass) |
Unique identifier |
| whse |
character varying(6) |
No |
No |
|
Warehouse for the price, if applicable - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Part number for price, if applicable - links to inventory.part_no |
| uom_code |
character varying(10) |
No |
No |
|
Unit of measure code for price, if applicable - links to inventory_uoms.uom |
| product_code |
character varying(10) |
No |
No |
|
Product code for price, if applicable - links to inventory.product_code |
| cust_no |
character varying(20) |
No |
No |
|
Customer code for price, if applicable - links to customer.cust_no |
| ship_id |
character varying(20) |
No |
No |
|
Customer Shipto ID for price, if applicable - links to addresses.ship_id |
| cust_price_code |
character varying(1) |
No |
No |
|
Not used |
| territory |
character varying(10) |
No |
No |
|
Territory for price, if applicable - links to addresses.sales_terr |
| cust_udef2 |
character varying(40) |
No |
No |
|
Customer type for price, if applicable - links to customers.misc1 |
| min_qty |
numeric(15,5) |
No |
No |
|
Minimum quantity required for price |
| start_date |
date |
No |
No |
|
Start date for this price to be applicable |
| end_date |
date |
No |
No |
|
End date for this price to be applicable |
| override |
boolean |
No |
No |
|
High Priority has been checked on this price causing this price to override all other prices, even if there is a lower one; FALSE = No TRUE = Yes |
| score |
smallint |
No |
No |
|
Score given to the price used to determine which price is used at Sales time |
| promo_code |
character varying(25) |
No |
No |
|
Promotion code or price peason added by the user |
| amount_type |
character varying(1) |
No |
No |
|
How the sell price is calculated; D = Discount M = Markup P = Price |
| amount |
numeric(15,5) |
No |
No |
|
Used with amount_type to calculate the price |
| vendor_cost |
numeric(15,5) |
No |
No |
|
Vendor contract cost for this item, for this promotion |
| vendor_no |
character varying(20) |
No |
No |
|
Vendor number giving the promotional cost - links to vendors.vendor_no |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |