Table: dbo.Insurepay_Setup_Transmission | |||
Table containing client specific InsurePay setup information. | |||
Columns | |||
Name | Type | Constraints | Description |
insurepay_setup_transmission_KEY | int (4) | NOT NULL | Primary key for this table. |
client_KEY | int (4) | NOT NULL | Foreign key for this table.The associated InsurePay_Client key. |
number_of_employee | int (4) | NOT NULL | number of employee included in the Insurepay setup file. |
setup_data_xml | nvarchar (-1) | NOT NULL | insurepay setup xml data for the client. |
Primary key | |||
Name | Columns | Description | |
PK_Insurepay_Setup_Transmission | insurepay_setup_transmission_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Insurepay_Setup_Transmission__Insurepay_Client__client_KEY | client_KEY | Insurepay_Client (client_KEY) |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Insurepay_Setup_Transmission_Result__Insurepay_Setup_Transmission__insurepay_setup_transmission_KEY | insurepay_setup_transmission_KEY | Insurepay_Setup_Transmission_Result |