Table Schema: mf_invoice_items

This topic describes the columns in the mf_invoice_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
invoice_item_guid uniqueidentifier 1 0 1   5  
invoice_guid uniqueidentifier 0 0 2   0 mf_invoices.invoice_guid
order_item_guid uniqueidentifier 0 1 3   0 mf_order_items.order_item_guid
linked_invoice_item_guid uniqueidentifier 0 1 4   0  
item_guid uniqueidentifier 0 1 5   0  
item_price_level_guid uniqueidentifier 0 1 6   0  
invoice_item_line_id smallint 0 1 7   0  
invoice_item_cd varchar (50) 0 1 8   0  
invoice_item_description varchar (255) 0 1 9   0  
invoice_item_description_localized nvarchar (255) 0 1 10   0  
invoice_item_description_locked tinyint 0 0 11   0  
invoice_item_notes varchar (2000) 0 1 12   0  
invoice_item_quantity int 0 0 13   0  
invoice_item_unit_price decimal (16,6) 0 0 14   0  
invoice_item_unit_price_ref decimal (16,6) 0 1 15   0  
invoice_item_tax money 0 0 16   0  
invoice_item_tax_rate decimal (7,6) 0 1 17   0  
invoice_item_product_tax money 0 0 18   0  
invoice_item_shipping money 0 0 19   0  
invoice_item_shipping_tax money 0 0 20   0  
invoice_item_handling money 0 0 21   0  
invoice_item_handling_tax money 0 0 22   0  
invoice_item_insurance money 0 0 23   0  
invoice_item_discount_rate decimal (7,6) 0 1 24   0  
invoice_item_discount money 0 1 25   0  
invoice_item_discount2 money 0 0 26   0  
invoice_item_discount_description varchar (255) 0 1 27   0  
invoice_item_price_adjustment money 0 0 28   0  
invoice_item_price_adjustment_tax money 0 0 29   0  
invoice_item_invoice_price_adjustment money 0 0 30   0  
invoice_item_invoice_price_adjustment_tax money 0 0 31   0  
invoice_item_extended_price money 0 0 32   0  
invoice_item_taxable tinyint 0 0 33   0  
invoice_item_approved tinyint 0 0 34   0  
lu_dt datetime 0 0 35   0  
cr_dt datetime 0 0 36   0  
lu_guid uniqueidentifier 0 1 37   0  
cr_guid uniqueidentifier 0 1 38   0  

Return to index of tables