| This table contains partner logininformation/credentials associated with Swipeclock application, needed while establishing connection from ACS. This table has a 0..1 to 1 relationship with Firm. |
| firm_KEY | int (4) | NOT NULL | Primary and foreign key. Foreign-keyed to Firm, which is home to Swipeclock partner login credentials. |
| 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. |
| accountant_id | bigint (8) | NOT NULL | An UnquotedJSON Number is to be provided as specified by the Swipeclock documentation |
| is_synced | bit (1) | NOT NULL | This should be set to boolean based on data saved in swipeclock microservice. Value of this column will be used to determine whether data is synced or not to microservice database. |