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

© Copyright 2000-2023, Salesforce, Inc. All rights reserved. Various trademarks held by their respective owners.

 Show URL Submit FeedbackPrivacy Policy
X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used. By continuing to use this site you are giving us your consent to do this. Privacy Policy.