Table: dbo.Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials
This table contains login/configuration["BR"] information related to Swipe Clock. This table has a 0..1 to 1 relationship with Client.
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary and foreign key. Foreign-keyed to Client_Payroll_Information rather than directly to Client.
accountant_id | bigint (8) | NOT NULL | An UnquotedJSON Number is to be provided as specified by the Swipeclock documentation
encrypted_accountant_secret | nvarchar (-1) | NOT NULL | The accountant secret of swipeclock partner login, which is an auto generated field in Swipeclock application entered while requesting data into ACS from Swipeclock application, for connection purposes. This value is encrypted.

Primary key
Name | Columns | Description
PK_Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials__Client_Payroll_Information__client_KEY | client_KEY | Client_Payroll_Information (client_KEY) | Client key on which swipe clock is enabled and it is Foreign-keyed to["BR"] Client_Payroll_Information rather than directly to Client.