Table Data dictionary report - inventory_price_matrix

Generated: 9/23/2016 2:46:54 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
bve_price_matrix_pkey Primary key (id)

Report generated by pgAdmin III