Some of the Important Tables related to CSB:
- iby_trxn_summaries_all – Holds the information related the CSB current batch ( DEBIT_AUTHORIZATION_ID, MBATCHID (Holds CSB Msgid)).
- iby_debit_authorizations – Holds the information related to Debit authorization mapping (AUTH_CANCEL_DATE, CREDITOR_LEGAL_ENTITY_ID).
- xle_entity_profiles – Holds the information related to the Legal entity name mapped to Debit authorization.
- xle_firstparty_information_v
- iby_fndcpt_tx_extensions – Any updates on Debit_debit_autorization_id in IBY_TRXN_SUMMARIES_ALL Table needs to be updated. (DEBIT_AUTHORIZATION_ID)
iby_trxn_summaries_all Table Status collum:
100 – Pending for process and will be picked in the next run.
0 – All lines were picked and a payment file got generated for these lines.
114 – Transactions was canceled in an open batch (void)
Some of the Important Queries related to CSB issue:
Query to know the Receipt number for that particular TRXNMID:
select RECEIPT_NUMBER from ar_cash_receipts_all where payment_trxn_extension_id in (
select trxn_extension_id from iby_fndcpt_tx_operations where transactionid in (
select transactionid from iby_trxn_summaries_all
where TRXNMID IN ()));
Query to know the Invoice for that particular TRXNMID:
select * from apps.ra_customer_trx_all where payment_trxn_extension_id in (
select trxn_extension_id from apps.iby_fndcpt_tx_operations where transactionid in (
select transactionid from apps.iby_trxn_summaries_all where TRXNMID = ))
