eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: RA_CUSTOMER_TRX_LINES_ALL

Product:	AR - Receivables
Description:	Invoice, debit memo, chargeback, credit memo and commitment lines
Implementation/DBA Data:	AR.RA_CUSTOMER_TRX_LINES_ALL

Primary Key: RA_CUSTOMER_TRX_LINES_PK

CUSTOMER_TRX_LINE_ID

Primary Key: RA_CUSTOMER_TRX_LINES_UK1

CUSTOMER_TRX_ID
LINE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_ALL	RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.INITIAL_CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.LINK_TO_CUST_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_ITEM_EXCEPTION_RATES	RA_CUSTOMER_TRX_LINES_ALL.ITEM_EXCEPTION_RATE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_TAX_EXEMPTIONS_ALL	RA_CUSTOMER_TRX_LINES_ALL.TAX_EXEMPTION_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_MEMO_LINES_ALL_B	RA_CUSTOMER_TRX_LINES_ALL.MEMO_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_VAT_TAX_ALL_B	RA_CUSTOMER_TRX_LINES_ALL.VAT_TAX_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_ALL	RA_CUSTOMER_TRX_LINES_ALL.BR_REF_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_PAYMENT_SCHEDULES_ALL	RA_CUSTOMER_TRX_LINES_ALL.BR_REF_PAYMENT_SCHEDULE_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_LINES_ALL.BR_ADJUSTMENT_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_LOCATION_VALUES_OLD	RA_CUSTOMER_TRX_LINES_ALL.LOCATION_SEGMENT_ID
RA_CUSTOMER_TRX_LINES_ALL	OKC_K_LINES_B	RA_CUSTOMER_TRX_LINES_ALL.CONTRACT_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	HZ_CUST_ACCOUNTS	RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_CONTACT_ID
RA_CUSTOMER_TRX_LINES_ALL	IBY_FNDCPT_TX_EXTENSIONS	RA_CUSTOMER_TRX_LINES_ALL.PAYMENT_TRXN_EXTENSION_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_INTEREST_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.INTEREST_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_ALL	RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_RULES	RA_CUSTOMER_TRX_LINES_ALL.ACCOUNTING_RULE_ID
RA_CUSTOMER_TRX_LINES_ALL	GL_SETS_OF_BOOKS_11I	RA_CUSTOMER_TRX_LINES_ALL.SET_OF_BOOKS_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_SALES_TAX	RA_CUSTOMER_TRX_LINES_ALL.SALES_TAX_ID
AR_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_ADJUSTMENTS_ALL.CUSTOMER_TRX_LINE_ID
AR_CREDIT_MEMO_AMOUNTS	RA_CUSTOMER_TRX_LINES_ALL	AR_CREDIT_MEMO_AMOUNTS.CUSTOMER_TRX_LINE_ID
AR_CUSTOMER_CALL_TOPICS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_CUSTOMER_CALL_TOPICS_ALL.CUSTOMER_TRX_LINE_ID
AR_INTERIM_CASH_RCPT_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_INTERIM_CASH_RCPT_LINES_ALL.CUSTOMER_TRX_LINE_ID
AR_RAMC_AUDIT_TRAIL	RA_CUSTOMER_TRX_LINES_ALL	AR_RAMC_AUDIT_TRAIL.CUSTOMER_TRX_LINE_ID
AR_RECEIVABLE_APPLICATIONS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_LINE_ID
AR_REVENUE_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_REVENUE_ADJUSTMENTS_ALL.FROM_CUST_TRX_LINE_ID
AR_REVENUE_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_REVENUE_ADJUSTMENTS_ALL.TO_CUST_TRX_LINE_ID
CST_REVENUE_RECOGNITION_LINES	RA_CUSTOMER_TRX_LINES_ALL	CST_REVENUE_RECOGNITION_LINES.CUSTOMER_TRX_LINE_ID
CST_MARGIN_TEMP	RA_CUSTOMER_TRX_LINES_ALL	CST_MARGIN_TEMP.CUSTOMER_TRX_LINE_ID
FII_AR_SALES_CREDITS	RA_CUSTOMER_TRX_LINES_ALL	FII_AR_SALES_CREDITS.INVOICE_LINE_ID
JAI_AR_ETCS_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_ETCS_T.SOURCE_DOCUMENT_ID
JAI_AR_SUP_LINES	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_SUP_LINES.CUSTOMER_TRX_LINE_ID
JAI_AR_SUP_TAXES	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_SUP_TAXES.CUSTOMER_TRX_LINE_ID
JAI_AR_SUP_TAXES	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_SUP_TAXES.LINK_TO_CUST_TRX_LINE_ID
JAI_AR_TRX_CM_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_CM_T.INV_TRX_LINE_ID
JAI_AR_TRX_CM_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_CM_T.CM_TRX_LINE_ID
JAI_AR_TRX_INS_LINES_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_INS_LINES_T.CUSTOMER_TRX_LINE_ID
JAI_AR_TRX_INS_LINES_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_INS_LINES_T.LINK_TO_CUST_TRX_LINE_ID
JAI_AR_TRX_LINES	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID
JAI_AR_TRX_TAX_CALC_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_TAX_CALC_T.CUSTOMER_TRX_LINE_ID
JAI_AR_TRX_TAX_CALC_T	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_TAX_CALC_T.LINK_TO_CUST_TRX_LINE_ID
JAI_AR_TRX_TAX_LINES	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_TAX_LINES.CUSTOMER_TRX_LINE_ID
JAI_AR_TRX_TAX_LINES	RA_CUSTOMER_TRX_LINES_ALL	JAI_AR_TRX_TAX_LINES.LINK_TO_CUST_TRX_LINE_ID
JAI_RGM_REFS_ALL	RA_CUSTOMER_TRX_LINES_ALL	JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID
JL_BR_AR_COMP_INV_ALL	RA_CUSTOMER_TRX_LINES_ALL	JL_BR_AR_COMP_INV_ALL.CUSTOMER_TRX_LINE_ID
JMF_GTA_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	JMF_GTA_TRX_LINES_ALL.AR_TRX_LINE_ID
LNS_AMORTIZATION_LINES	RA_CUSTOMER_TRX_LINES_ALL	LNS_AMORTIZATION_LINES.CUST_TRX_LINE_ID
OE_ORDER_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	OE_ORDER_LINES_ALL.REFERENCE_CUSTOMER_TRX_LINE_ID
OKL_XTL_SELL_INVS_B	RA_CUSTOMER_TRX_LINES_ALL	OKL_XTL_SELL_INVS_B.ILL_ID
RA_CM_REQUEST_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CM_REQUEST_LINES_ALL.CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.INITIAL_CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.LINK_TO_CUST_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_LINE_ID
RA_CUST_TRX_LINE_GL_DIST_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_LINE_ID
RA_CUST_TRX_LINE_SALESREPS_ALL	RA_CUSTOMER_TRX_LINES_ALL	RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_LINE_ID
SO_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	SO_LINES_ALL.CREDIT_INVOICE_LINE_ID