Table: dbo.XactPay_Setup_Transmission
Table containing XactPay setup file information
Columns
NameTypeConstraintsDescription
xactpay_setup_transmission_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLThe associated client.
number_of_employeesint (4)NOT NULLNumber of employees.
is_seasonal_businessbit (1)NOT NULLSeasonal business indicator.
seasonal_explanationnvarchar (100)NOT NULLExplanation of seasonal business.
number_of_payrollsint (4)NOT NULLNumber of payrolls contained in file.
setup_data_xmlnvarchar (-1)NOT NULLSetup file XML.
Primary key
NameColumnsDescription
PK_XactPay_Setup_Transmissionxactpay_setup_transmission_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Setup_Transmission__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_XactPay_Setup_Transmission_Result__XactPay_Setup_Transmission__xactpay_setup_transmission_KEYxactpay_setup_transmission_KEYXactPay_Setup_Transmission_Result

Schema diagram