id |
integer |
Yes |
Yes |
nextval('inventory_price_matrix_id_seq'::regclass) |
|
whse |
character varying(6) |
No |
No |
|
Warhouse for the price. |
part_no |
character varying(34) |
No |
No |
|
Part number |
uom_code |
character varying(10) |
No |
No |
|
Unit of measure code |
product_code |
character varying(10) |
No |
No |
|
Product code |
cust_no |
character varying(20) |
No |
No |
|
Customer code that this price is for |
ship_id |
character varying(20) |
No |
No |
|
Customer's ship to ID if the price is only for one ship to. |
cust_price_code |
character varying(1) |
No |
No |
|
|
territory |
character varying(10) |
No |
No |
|
Territory price is assigned to |
cust_udef2 |
character varying(10) |
No |
No |
|
Customer type price is assigned to |
min_qty |
numeric(9) |
No |
No |
|
Minimum quantity required before getting this price |
start_date |
date |
No |
No |
|
Start date for this price |
end_date |
date |
No |
No |
|
Date the price ends |
override |
boolean |
No |
No |
|
If 'High Priority' has been checked on the price then this price overrides all other prices even if there is a lower one. TRUE = Yes FALSE = No |
score |
smallint |
No |
No |
|
The score given to the price. This is used to determine what price type is more important. |
promo_code |
character varying(25) |
No |
No |
|
The 'Price Reason' field added by the user. |
amount_type |
character varying(1) |
No |
No |
|
How the sell price is derived P = Price D = Discount M = Markup |
amount |
numeric(15,5) |
No |
No |
|
|
vendor_cost |
numeric(15,5) |
No |
No |
|
Vendors contract cost for this item for this promo |
vendor_no |
character varying(20) |
No |
No |
|
Vendor giving the promo cost |
_dbversion |
integer |
No |
No |
|
|
_created |
timestamp without time zone |
No |
No |
|
|
_created_by |
character varying(3) |
No |
No |
|
|
_modified |
timestamp without time zone |
No |
No |
|
|
_modified_by |
character varying(3) |
No |
No |
|
|