Datanory Production » Datanory - SNEKKU

SELECT

b.customer_code,

b.customer_name,

*

FROM

txn_invoice_history_header a

INNER JOIN

customer b ON a.customer_id = b.customer_id

WHERE

a.org_id ='snekku'  
    AND  b.customer_code like'10812'  

order by a.created_date desc

select * from member where member_id= '054e3f6fc4bb4bbf98f791a6db0f54b4'
 select * from stg_accounting_import_credit_note where DOC_NO= 'CN24/001190' order by CREATED_DATE desc
 -- in staging table the balance is 0

select * from txn_credit_note_history_header where customer_id= '616DF5CFC28B48A2BE55EBE0A2B9BAC3' order by created_date desc
 -- credit note balance I notice there is 63.45 instead of 0
    select * from txn_credit_note_history_detail where credit_note_id= 'F09E5BC2A2944E798985CBEED527205A' order by created_date desc

select s.BALANCE, s.DOC_NO
    from stg_accounting_import_credit_note s
    INNER JOIN sync_integration_token t ON t.token_id = s.TOKEN_ID
    inner join txn_credit_note_history_header h on h.credit_note_no = s.DOC_NO
    WHERE s.TOKEN_ID = '522DFDB9-59EB-4464-BD7E-761C916C92Bf' AND s.PROCESS_ID = '8652446e-c0e9-4c29-861e-febe4432410c' and h.credit_note_balance <> cast(s.BALANCE as decimal(18,2)) and s.DOC_NO= 'CN24/001190'

select * from txn_credit_note_history_header_at where credit_note_no like 'CN24/001190' order