Total Pageviews

July 3, 2016

7/03/2016 02:05:00 AM
1
Mapping Between GL and AR



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