| id |
integer |
Yes |
Yes |
nextval('inventory_pricing_id_seq'::regclass) |
|
| source |
character varying(1) |
No |
No |
|
Source I = Inventory |
| whse |
character varying(6) |
No |
No |
|
Warhouse |
| cust_or_vend_no |
character varying(20) |
No |
No |
|
|
| ship_id |
character varying(20) |
No |
No |
|
|
| addr_type |
character varying(1) |
No |
No |
|
|
| part_no |
character varying(34) |
No |
No |
|
Part number |
| uom |
character varying(10) |
No |
No |
|
Unit of Measure |
| use_price_factor |
boolean |
No |
No |
|
If the item uses a price factor for the unit of measure |
| price_factor |
numeric(11,5) |
No |
No |
|
The price factor used for the unit of measure's price. |
| modify_status |
boolean |
No |
No |
|
|
| _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 |
|
|
| retail_price |
numeric(15,5)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Array field containing 20 levels of prices |
| break_qty |
numeric(11)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| break_qty_price |
numeric(15,5)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|