Table Schema: mf_inventory_site_transactions

This topic describes the columns in the mf_inventory_site_transactions table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
inventory_site_transaction_guid uniqueidentifier 1 0 1   0  
company_guid uniqueidentifier 0 0 2   0  
site_guid uniqueidentifier 0 0 3   0 mf_sites.site_guid
item_guid uniqueidentifier 0 0 4   0 mf_items.item_guid
inventory_guid uniqueidentifier 0 0 5   0  
inventory_receipt_guid uniqueidentifier 0 1 6   0  
inventory_lot_guid uniqueidentifier 0 1 7   0  
batch_guid uniqueidentifier 0 1 8   0  
inventory_transaction_type_id smallint 0 0 9   0 mf_inventory_transaction_types.inventory_transaction_type_id
inventory_site_transaction_date datetime 0 0 10   0  
inventory_site_transaction_quantity int 0 0 11   0  
inventory_site_transaction_unit_cost money 0 1 12   0  
inventory_site_transaction_description varchar (255) 0 1 13   0  
inventory_site_transaction_posted bit 0 0 14   0  
lu_dt datetime 0 0 15   0  
cr_dt datetime 0 0 16   0  
lu_guid uniqueidentifier 0 1 17   0  
cr_guid uniqueidentifier 0 1 18   0  

Return to index of tables