Table Schema: mf_item_vendors

This topic describes the columns in the mf_item_vendors table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
item_guid uniqueidentifier 1 0 1   0 mf_items.item_guid
vendor_guid uniqueidentifier 1 0 2   0 mf_vendors.vendor_guid
vendor_item_cd nvarchar (50) 0 1 3   0  
vendor_item_description nvarchar (100) 0 1 4   0  
vendor_item_price money 0 1 5   0  
vendor_item_lead_time smallint 0 1 6   0  
vendor_item_quantity_minimum int 0 1 7   0  
vendor_item_quantity_on_order int 0 1 8   0  
vendor_item_quantity_available int 0 1 9   0  
vendor_preferred tinyint 0 0 10   0  
lu_dt datetime 0 0 11   0  
cr_dt datetime 0 0 12   0  
lu_guid uniqueidentifier 0 1 13   0  
cr_guid uniqueidentifier 0 1 14   0  

Return to index of tables