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 swipe clock partner login, which is an auto generated field["BR"] in SwipeClock application entered while requesting data into ACS from SwipeClock application, for connection purposes.["BR"] 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.