Datanory Production » Datanory - SNEKKU

Handover to rashdan

Azhar:
This one already fix for the future.

SELECT ihh.col_no,ihh.org_id,*
FROM txn_mobile_collection_detail cd
INNER JOIN txn_mobile_collection_header ihh ON cd.col_id = ihh.col_id
WHERE cd.status = 'approved' AND cd.web_paid IS NULL;
-- based on this query there are 3 collection that the web paid is null

the web paid suppose not to be null
first settle this collection
CCMN3000022--> for this collection we need to patch web paid based on the
-- Th
SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE '%CCMN3000022%'

select * from txn_mobile_collection_detail where col_id= 'ad92964a-a196-4158-8fe2-8f001dbd4a0f'
To do -
already requested to user to perform deletion in the mysoft
1) have to patch sync date into NULL (SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE '%CCMN3000022%')
2) PATCH the web paid accordingly since there is 2 type of payment (cash and reciept)
3) request user cheque number since the temporary receipt cannot be duplicated.

4 re run the integration ( trigger it )
THis isssue has been fixed and expected to deploy today

Can refer afiq if the ticket is not clear