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
|
