Table: dbo.XactPay_Payroll_Transmission
Table containing XactPay payroll file information
Columns
Name | Type | Constraints | Description
xactpay_payroll_transmission_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | The associated client.
number_of_employees | int (4) | NOT NULL | Number of employees contained in this payroll file.
gross_pay | decimal (9, 2) | NOT NULL | Total gross pay contained in this payroll file.
check_date | smalldatetime (4) | NOT NULL | The date of checks contained in this payroll file.
payroll_data_xml | nvarchar (-1) | NOT NULL | Payroll file XML.
period_begin_date | smalldatetime (4) | NOT NULL | Period beginning date that this payroll transmission covers
period_end_date | smalldatetime (4) | NOT NULL | Period ending date that this payroll transmission covers

Primary key
Name | Columns | Description
PK_XactPay_Payroll_Transmission | xactpay_payroll_transmission_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_XactPay_Payroll_Transmission__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_XactPay_Payroll_Transmission_Result__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEY | xactpay_payroll_transmission_KEY | XactPay_Payroll_Transmission_Result |
FK_XactPay_N_Payroll_Bank_Transaction__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEY | xactpay_payroll_transmission_KEY | XactPay_N_Payroll_Bank_Transaction |