Table Schema: mf

This topic describes the columns in the mf_carts 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
cart_guid	uniqueidentifier	1	0	1
company_guid	uniqueidentifier	0	0	2
catalog_guid	uniqueidentifier	0	1	3
customer_guid	uniqueidentifier	0	1	4
agent_guid	uniqueidentifier	0	1	5
cart_type_id	smallint	0	0	6
cart_application_cd	varchar (50)	0	1	7
cart_description	varchar (50)	0	1	8
cart	text	0	1	9
cart_persist_timeout_mins	int	0	1	10
cart_persist	tinyint	0	0	11
cart_tag	varchar (100)	0	1	12
cart_pricing_request_checksum	varchar (255)	0	1	13
cart_pricing_request_dt	datetime	0	1	14
cart_pricing_response	varchar (max)	0	1	15
order_quote_id	varchar (50)	0	1	16
order_type_id	smallint	0	1	17
order_bill_attention	varchar (255)	0	1	18
order_item_count	smallint	0	1	19
order_item_quantity_count	int	0	1	20
order_total	money	0	1	21
lu_dt	datetime	0	0	22
cr_dt	datetime	0	0	23

Table Schema: mf_carts