Table Schema: mf_invoices

This topic describes the columns in the mf_invoices table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
invoice_guid uniqueidentifier 1 0 1 Primary Key 7  
company_guid uniqueidentifier 0 0 2 Company-F-mf_companies 0 mf_companies.company_guid
catalog_guid uniqueidentifier 0 1 3 Catalog-F-mf_catalogs 0 mf_catalogs.catalog_guid
site_guid uniqueidentifier 0 1 4 Site-F-mf_sites 0 mf_sites.site_guid
customer_guid uniqueidentifier 0 1 5 Customer-F-mf_customers 0 mf_customers.customer_guid
order_guid uniqueidentifier 0 1 6 Order-F-mf_orders 0 mf_orders.order_guid
shipping_order_guid uniqueidentifier 0 1 7 Shipping Order-F-mf_shipping_orders 0 mf_shipping_orders.shipping_order_guid
return_order_guid uniqueidentifier 0 1 8   0  
user_guid uniqueidentifier 0 1 9 User that created the invoice-F-mf_users 0  
term_guid uniqueidentifier 0 1 10 Terms-F-mf_terms 0 mf_terms.term_guid
linked_invoice_guid uniqueidentifier 0 1 11   0 mf_invoices.invoice_guid
invoice_code_guid uniqueidentifier 0 1 12   0  
localization_guid uniqueidentifier 0 1 13   0  
iso_culture_cd varchar (15) 0 1 14   0 mf_iso_cultures.iso_culture_cd
taxation_policy_type_id smallint 0 0 15   0 mf_taxation_policy_types.taxation_policy_type_id
invoice_state_id smallint 0 1 16 Billing Address State-F-mf_states 0 mf_country_regions.country_region_id
invoice_country_id smallint 0 1 17 Billing Address Country-F-mf_countries 0 mf_countries.country_id
invoice_type_id smallint 0 0 18 Invoice type-F-mf_invoice_types 0 mf_invoice_types.invoice_type_id
iso_currency_cd char (3) 0 1 19   0 mf_iso_currencies.iso_currency_cd
invoice_id varchar (50) 0 0 20 Id used for uniquely identifying an invoice 0  
invoice_reference_id varchar (50) 0 1 21 Refernce Id that can be used as an id in another system 0  
invoice_date datetime 0 0 22 Invoice date 0  
invoice_ship_date datetime 0 1 23 Invoice ship date 0  
invoice_paid_date datetime 0 1 24 Invoice paid date 0  
invoice_attention varchar (255) 0 1 25 Billing attention 0  
invoice_company_name varchar (255) 0 1 26 Billing company name 0  
invoice_address varchar (80) 0 1 27 Billing address 0  
invoice_address2 varchar (80) 0 1 28 Billing address line 2 0  
invoice_address3 varchar (80) 0 1 29 Billing address line 3 0  
invoice_city varchar (50) 0 1 30 Billing address city 0  
invoice_postal_code varchar (50) 0 1 31 Billing Address postal code 0  
invoice_country_region_name nvarchar (50) 0 1 32   0  
invoice_phone varchar (25) 0 1 33 Billing address phone 0  
invoice_email varchar (80) 0 1 34 Billing email 0  
invoice_subtotal money 0 0 35 Sub total 0  
invoice_subtotal_tax money 0 0 36 Sub total 0  
invoice_tax_rate_based bit 0 0 37 Indicates whether shipping has to be calculated at the item level 0  
invoice_tax money 0 0 38 Tax 0  
invoice_tax_rate decimal (7,6) 0 1 39 Tax rate 0  
invoice_tax_rate_state decimal (7,6) 0 1 40 State tax rate 0  
invoice_tax_rate_county decimal (7,6) 0 1 41 County tax rate 0  
invoice_tax_rate_city decimal (7,6) 0 1 42 City tax rate 0  
invoice_tax_rate_vat decimal (7,6) 0 1 43 Vat tax rate 0  
invoice_tax_shipping bit 0 0 44 Indicates whether shipping has to be taxed 0  
invoice_tax_handling bit 0 0 45 Indicates whether handling has to be taxed 0  
invoice_tax_item_based bit 0 0 46 Indicates whether shipping has to be calculated at the item level 0  
invoice_shipping_item_based bit 0 0 47 Indicates whether shipping has to be calculated at the item level 0  
invoice_shipping_manual bit 0 0 48 Indicates whether shipping has been modified manually 0  
invoice_shipping money 0 0 49 Invoice shipping 0  
invoice_shipping_tax money 0 0 50 Tax 0  
invoice_shipping_locked tinyint 0 0 51   0  
invoice_handling money 0 0 52 Invoice handling 0  
invoice_handling_tax money 0 0 53 Tax 0  
invoice_handling_locked tinyint 0 0 54   0  
invoice_insurance money 0 0 55 Invoice handling 0  
invoice_insurance_locked tinyint 0 0 56   0  
invoice_discount_rate decimal (7,6) 0 1 57 Discount rate 0  
invoice_discount money 0 0 58 Discount 0  
invoice_discount_description varchar (255) 0 1 59   0  
invoice_discount_locked tinyint 0 0 60   0  
invoice_price_adjustment money 0 0 61   0  
invoice_price_adjustment_tax money 0 0 62   0  
invoice_total money 0 0 63 Total 0  
invoice_adjustment money 0 0 64 Summary field-mf_invoice_transactions 0  
invoice_credit money 0 0 65 Summary field-mf_invoice_transactions 0  
invoice_finance_charge money 0 0 66 Summary field-mf_invoice_transactions 0  
invoice_payment money 0 0 67 Summary field-mf_invoice_transactions 0  
invoice_balance_due money 0 0 68 Balance due 0  
invoice_amount_paid money 0 0 69 Amount paid 0  
invoice_term_due_days smallint 0 1 70   0  
invoice_fulfilled tinyint 0 0 71   0  
invoice_exported tinyint 0 0 72   0  
invoice_void tinyint 0 0 73 Status flag- Indicates whether the invoice is voided 0  
invoice_force_closed tinyint 0 0 74   0  
invoice_paid tinyint 0 0 75 Status flag- Indicates whether the invoice is paid 0  
invoice_alert tinyint 0 0 76 Status flag- Indicates whether the invoice is alerted 0  
invoice_visible tinyint 0 0 77 Status flag- Indicates whether the invoice is visible 0  
invoice_new tinyint 0 0 78 Status flag- Indicates whether the invoice is new 0  
invoice_approved tinyint 0 0 79 Work Flow flag- Indicates whether the invoice is approved 0  
invoice_suspended tinyint 0 0 80 Status flag- Indicates whether the invoice is suspended 0  
invoice_locked tinyint 0 0 81 Status flag- Indicates whether the invoice is locked 0  
invoice_closed tinyint 0 0 82 Work Flow flag- Indicates whether the invoice is closed 0  
invoice_filed tinyint 0 0 83 Work Flow flag- Indicates whether the invoice is filed 0  
invoice_flag tinyint 0 0 84 Used by UI as a way to assign records to different colored flags-F-mf_flags 0  
lu_dt datetime 0 0 85 Record update date 0  
cr_dt datetime 0 0 86 Record created date 0  
lu_guid uniqueidentifier 0 1 87 Record updated by-F-mf_users 0  
cr_guid uniqueidentifier 0 1 88 Record created by-F-mf_users 0  
invoice_product_tax money 0 0 89 Tax 0  
invoice_tax_converted bit 0 0 90   0  
invoice_discount_converted bit 0 0 91   0  
invoice_scrub_scheduled_date datetime 0 1 94   0  
invoice_scrub_completed_date datetime 0 1 95   0  

Return to index of tables