The General Ledger Transfer process puts rows into GL_IMPORT_REFERENCES.REFERENCE21 to REFERENCE30.
If the journal is imported in detail the information is copied over to REFERENCE1 to REFERENCE10 in GL_JE_LINES.
If the journal is imported in summary there is no 1 to 1 relationship between the lines in gl and their source references.
If you are customizing it should be note that these are subject to change without warning or notice.
GL_JE_LINES. | GL_IMPORT_ REFERENCES | Adjustments | Transactions | Receipts |
REFERENCE_1 | REFERENCE21 | posting_control_id | posting_control_id | posting_control_id |
REFERENCE_2 | REFERENCE22 | adjustment_id | customer_trx_id | cash_receipt_id |
REFERENCE_3 | REFERENCE23 | line_id | cust_trx_line_gl_dist_id | line_id |
REFERENCE_4 | REFERENCE24 | trx_number | trx_number | receipt_number |
REFERENCE_5 | REFERENCE25 | adjustment_number | cust.account_number | null for CASH |
REFERENCE_6 | REFERENCE26 | cust_trx_type | CUSTOMER | null |
REFERENCE_7 | REFERENCE27 | bill_to_customer_id | bill_to_customer_id | pay_from_customer |
REFERENCE_8 | REFERENCE28 | ADJ | type(CM/DM/CB/INV) | MISC / TRADE |
REFERENCE_9 | REFERENCE29 | source_type prefixed by 'ADJ_' | type||account_class | MISC_sourcetype or TRADE_source_type |
REFERENCE_10 | REFERENCE30 | AR_ADJUSTMENTS | RA_CUST_TRX_LINE_GL_DIST | AR_CASH_RECEIPT_HISTORY |