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 |