Table Schema: mf_shipment_transactions

This topic describes the columns in the mf_shipment_transactions table.

Column Name Data Type Primary Key Is Nullable Column ID Comment 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  

Return to index of tables