Table containing XactPay payroll file information |
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 |