This table contains partner login["BR"] information/credentials associated with SwipeClock application, needed while establishing connection from ACS. This["BR"] table has a 0..1 to 1 relationship with Firm. |
firm_KEY | int (4) | NOT NULL | Primary and foreign["BR"] key. Foreign-keyed to Firm, which is home to SwipeClock partner login credentials. |
encrypted_accountant_secret | nvarchar (-1) | NOT NULL | The["BR"] accountant secret of swipe clock partner login, which is an auto generated field in SwipeClock application["BR"] 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. |