Table Schema: mf_shipment

This topic describes the columns in the mf_shipment_transactions 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 Count	Reference To
shipment_transaction_guid	uniqueidentifier	1	0	1	1
company_guid	uniqueidentifier	0	0	2	0
shipment_guid	uniqueidentifier	0	0	3	0	mf_shipments.shipment_guid
provider_instance_guid	uniqueidentifier	0	1	4	0
shipment_transaction_type_id	smallint	0	0	5	0	mf_shipment_transaction_types.shipment_transaction_type_id
shipment_transaction_id	varchar (100)	0	1	6	0
shipment_transaction_reference_id	varchar (100)	0	1	7	0
shipment_transaction_date	datetime	0	0	8	0
shipment_transaction_cost	money	0	0	9	0
shipment_transaction_provider_instance_request_key	varchar (50)	0	1	10	0
shipment_transaction_provider_instance_request_label	varchar (255)	0	1	11	0
shipment_transaction_provider_instance_request_data	varchar (max)	0	1	12	0
shipment_transaction_provider_instance_request_version	varchar (25)	0	1	13	0
shipment_transaction_provider_instance_response_key	varchar (50)	0	1	14	0
shipment_transaction_provider_instance_response_label	varchar (255)	0	1	15	0
shipment_transaction_provider_instance_response_data	varchar (max)	0	1	16	0
shipment_transaction_provider_instance_response_version	varchar (25)	0	1	17	0
shipment_transaction_error	bit	0	0	18	0
lu_dt	datetime	0	0	19	0
cr_dt	datetime	0	0	20	0
lu_guid	uniqueidentifier	0	1	21	0
cr_guid	uniqueidentifier	0	1	22	0

Table Schema: mf_shipment_transactions