Table: dbo.XactPay_Setup_Transmission_Result
Table containing XactPay setup file history
Columns
NameTypeConstraintsDescription
xactpay_setup_transmission_result_KEYint (4)NOT NULLPrimary key for this table.
xactpay_setup_transmission_KEYint (4)NOT NULLXactPay_Setup_Transmission key.
thirdparty_worker_compensation_transmission_status_type_KEYint (4)NOT NULLFile status.
status_change_datedatetime (8, 3)NOT NULLThe date the result status changed.
ack_data_xmlnvarchar (-1)NOT NULLAcknowledgement data.
connect_event_idint (4)NOT NULLEvent number from Connect.
Primary key
NameColumnsDescription
PK_XactPay_Setup_Transmission_Resultxactpay_setup_transmission_result_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_trthirdparty_worker_compensation_transmission_status_type_KEYThirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY)
FK_XactPay_Setup_Transmission_Result__XactPay_Setup_Transmission__xactpay_setup_transmission_KEYxactpay_setup_transmission_KEYXactPay_Setup_Transmission (xactpay_setup_transmission_KEY)

Schema diagram