AR Links to GL

Link between GL to AR

 When you run AR Transfer to GL , GL_INTERFACE table get first populated with reference columns that is then pushed the detailes in GL_JE_LINES table. Here are the details for Refrence columns.

Adjustments

• REFERENCE21 :posting_control_id
• REFERENCE22 :adjustment_id
• REFERENCE23 :line_id
• REFERENCE24 :trx_number
• REFERENCE25 :adjustment_number
• REFERENCE26 :cust_trx_type
• REFERENCE27 :bill_to_customer_id
• REFERENCE28 :ADJ
• REFERENCE29 :source_type prefixed by ‘ADJ’
• REFERENCE30 :AR_ADJUSTMENTS

Transactions

• REFERENCE21 :posting_control_id
• REFERENCE22 :customer_trx_id
• REFERENCE23 :cust_trx_line_gl_dist_id
• REFERENCE24 :trx_number
• REFERENCE25 :cust.account_number
• REFERENCE26 :CUSTOMER
• REFERENCE27 :bill_to_customer_id
• REFERENCE28 :type(CM/DM/CB/INV)
• REFERENCE29 :type||account_class
• REFERENCE30 :RA_CUST_TRX_LINE_GL_DIST

Applications

• REFERENCE21 :posting_control_id
• REFERENCE22 :cash_receipt_id||receivable_application_id for CASH /receivable_application_id for CM
• REFERENCE23 :line_id
• REFERENCE24 :receipt_number for CASH / trx_number for CM
• REFERENCE25 :trx_number if status = ¿APP¿ / NULL for unapplied records
• REFERENCE26 :cust_trx_type
• REFERENCE27 :pay_from_customer for CASH / bill_to_customer_id for CM
• REFERENCE28 :application_type (TRADE or CCURR for CASH / CMAPP for CM)
• REFERENCE29 :application_type||source_type
• REFERENCE30 :AR_RECEIVABLE_APPLICATIONS

Bills Receivable

• REFERENCE21 :posting_control_id
• REFERENCE22 :transaction_history_id
• REFERENCE23 :line_id
• REFERENCE24 :trx_number
• REFERENCE25 :customer_Trx_id
• REFERENCE26 :cust_trx_type
• REFERENCE27 :drawee_id
• REFERENCE28 :cust_trx_type
• REFERENCE29 :BR_||source_type
• REFERENCE30 :AR_TRANSACTION_HISTORY

Key Tables

In order to obtain what is going to be tranfered to GL you can these Major AR table to drill down information.

• ra_customer_trx_all: Transactions accounting
• ra_cust_trx_line_gl_dist_all: Transactions accounting
• ar_adjustments_all:Adjustments accounting
• ar_distributions_all:Adjustments accounting
• ar_cash_receipt_history_all:Receitps accounting
• ar_distributions_all: Receitps accounting
• ar_receivable_applications_all: Receipt applications accounting
• ar_distributions_all:Receipt applications accounting & misc receipts accounting
• ar_misc_cash_distributions_all:Misc receipts accounting