| id |
integer |
Yes |
Yes |
nextval('vendor_pricing_id_seq'::regclass) |
Unique identifier |
| uom |
character varying(10) |
No |
No |
|
Unit of Measure for this record |
| price |
numeric(15,5) |
No |
No |
|
Price for this record |
| auto_erase_record |
boolean |
No |
No |
|
Remove record after expiry flag; FALSE = No TRUE = Yes |
| vendor_code |
character varying(34) |
No |
No |
|
Vendor code for record - links to vendors.vendor_no |
| min_ord_qty |
numeric(15,5) |
No |
No |
|
Minimum order quantity permited to order |
| updatecostprice |
boolean |
No |
No |
|
Automatically update this record when receiving this item; FALSE = No TRUE = Yes |
| _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 |
| inventory_id |
integer |
Yes |
No |
|
ID deom table inventory.id |
| vendor_id |
integer |
Yes |
No |
|
ID from table vendor.id |
| break_qty |
numeric(11)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Minimum order quantity to qualify for this price, level 1 -15 |
| break_qty_price |
numeric(15,5)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Price when ordering specified quantity, level 1 -15 |
| valid_dates |
daterange |
No |
No |
|
Valid date range for this record |