| Table: dbo.XactPay_Setup_Transmission | |||
| Table containing XactPay setup file information | |||
| Columns | |||
| Name | Type | Constraints | Description |
| xactpay_setup_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. |
| is_seasonal_business | bit (1) | NOT NULL | Seasonal business indicator. |
| seasonal_explanation | nvarchar (100) | NOT NULL | Explanation of seasonal business. |
| number_of_payrolls | int (4) | NOT NULL | Number of payrolls contained in file. |
| setup_data_xml | nvarchar (-1) | NOT NULL | Setup file XML. |
| Primary key | |||
| Name | Columns | Description | |
| PK_XactPay_Setup_Transmission | xactpay_setup_transmission_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_XactPay_Setup_Transmission__Client__client_KEY | client_KEY | Client (client_KEY) | |
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_XactPay_Setup_Transmission_Result__XactPay_Setup_Transmission__xactpay_setup_transmission_KEY | xactpay_setup_transmission_KEY | XactPay_Setup_Transmission_Result | |