id |
integer |
Yes |
Yes |
nextval('vendor_pricing_id_seq'::regclass) |
|
uom |
character varying(10) |
No |
No |
|
Unit of measure |
price |
numeric(15,5) |
No |
No |
|
Price |
starting_date |
date |
No |
No |
|
Start date |
ending_date |
date |
No |
No |
|
End Date |
auto_erase_record |
boolean |
No |
No |
|
Remove record when expired TRUE = Yes FALSE = No |
vendor_code |
character varying(34) |
No |
No |
|
Vendor's code |
min_ord_qty |
numeric(15,5) |
No |
No |
|
Minimum quantity to purchase |
updatecostprice |
boolean |
No |
No |
|
Update vendor cost when receioving PO |
_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 |
|
|
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[] |
Quantity break level |
break_qty_price |
numeric(15,5)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Quantity break price |