Table Schema: mf_customer

This topic describes the columns in the mf_customer_statistics table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Reference To
customer_guid	uniqueidentifier	1	0	1	mf_customers.customer_guid
company_guid	uniqueidentifier	0	0	2
organization_guid	uniqueidentifier	0	1	3
customer_balance	money	0	1	4
customer_open_invoice_count	money	0	1	5
customer_open_credit	money	0	1	6
customer_sales_order_amount_mtd	money	0	1	7
customer_sales_order_amount_ytd	money	0	1	8
customer_sales_order_amount_pyr	money	0	1	9
customer_sales_order_return_amount_mtd	money	0	1	10
customer_sales_order_return_amount_ytd	money	0	1	11
customer_sales_order_return_amount_pyr	money	0	1	12
customer_sales_order_payment_amount_mtd	money	0	1	13
customer_sales_order_payment_amount_ytd	money	0	1	14
customer_sales_order_payment_amount_pyr	money	0	1	15
customer_invoice_amount_mtd	money	0	1	16
customer_invoice_amount_ytd	money	0	1	17
customer_invoice_amount_pyr	money	0	1	18
customer_margin_amount_mtd	money	0	1	19
customer_margin_amount_ytd	money	0	1	20
customer_margin_amount_pyr	money	0	1	21
customer_last_invoice_amount	money	0	1	22
customer_last_invoice_date	money	0	1	23
customer_last_shipped_date	datetime	0	1	24
customer_last_payment_amount	money	0	1	25
customer_last_payment_date	datetime	0	1	26
customer_average_pay_time	smallint	0	1	27
customer_first_order_date	datetime	0	1	28
customer_last_called_date	datetime	0	1	29
customer_last_allocated_date	datetime	0	1	30

Table Schema: mf_customer_statistics