Table: dbo.XactPay_Payroll_Transmission
Table containing XactPay payroll file information
Columns
NameTypeConstraintsDescription
xactpay_payroll_transmission_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLThe associated client.
number_of_employeesint (4)NOT NULLNumber of employees contained in this payroll file.
gross_paydecimal (9, 2)NOT NULLTotal gross pay contained in this payroll file.
check_datesmalldatetime (4)NOT NULLThe date of checks contained in this payroll file.
payroll_data_xmlnvarchar (-1)NOT NULLPayroll file XML.
period_begin_datesmalldatetime (4)NOT NULLPeriod beginning date that this payroll transmission covers
period_end_datesmalldatetime (4)NOT NULLPeriod ending date that this payroll transmission covers
Primary key
NameColumnsDescription
PK_XactPay_Payroll_Transmissionxactpay_payroll_transmission_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Payroll_Transmission__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_XactPay_Payroll_Transmission_Result__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEYxactpay_payroll_transmission_KEYXactPay_Payroll_Transmission_Result
FK_XactPay_N_Payroll_Bank_Transaction__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEYxactpay_payroll_transmission_KEYXactPay_N_Payroll_Bank_Transaction

Schema diagram