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: AR_ADJUSTMENTS_ALL

Product:	AR - Receivables
Description:	Pending and approved invoice adjustments
Implementation/DBA Data:	AR.AR_ADJUSTMENTS_ALL

Primary Key: AR_ADJUSTMENTS_PK

ADJUSTMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_ADJUSTMENTS_ALL	GL_SETS_OF_BOOKS_11I	AR_ADJUSTMENTS_ALL.SET_OF_BOOKS_ID
AR_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_ALL	AR_ADJUSTMENTS_ALL.SUBSEQUENT_TRX_ID
AR_ADJUSTMENTS_ALL	AR_APPROVAL_USER_LIMITS	AR_ADJUSTMENTS_ALL.APPROVED_BY
AR_ADJUSTMENTS_ALL	AR_CASH_RECEIPTS_ALL	AR_ADJUSTMENTS_ALL.ASSOCIATED_CASH_RECEIPT_ID
AR_ADJUSTMENTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_ADJUSTMENTS_ALL.ASSOCIATED_APPLICATION_ID
AR_ADJUSTMENTS_ALL	AR_TRANSACTION_HISTORY_ALL	AR_ADJUSTMENTS_ALL.LINK_TO_TRX_HIST_ID
AR_ADJUSTMENTS_ALL	AR_INTEREST_HEADERS_ALL	AR_ADJUSTMENTS_ALL.INTEREST_HEADER_ID
AR_ADJUSTMENTS_ALL	AR_INTEREST_LINES_ALL	AR_ADJUSTMENTS_ALL.INTEREST_LINE_ID
AR_ADJUSTMENTS_ALL	GL_CODE_COMBINATIONS	AR_ADJUSTMENTS_ALL.CODE_COMBINATION_ID
AR_ADJUSTMENTS_ALL	AR_BATCHES_ALL	AR_ADJUSTMENTS_ALL.BATCH_ID
AR_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_ALL	AR_ADJUSTMENTS_ALL.CUSTOMER_TRX_ID
AR_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_ADJUSTMENTS_ALL.CUSTOMER_TRX_LINE_ID
AR_ADJUSTMENTS_ALL	AR_DISTRIBUTION_SETS_ALL	AR_ADJUSTMENTS_ALL.DISTRIBUTION_SET_ID
AR_ADJUSTMENTS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_ADJUSTMENTS_ALL.PAYMENT_SCHEDULE_ID
AR_ADJUSTMENTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_ADJUSTMENTS_ALL.RECEIVABLES_TRX_ID
AR_APPROVAL_ACTION_HISTORY	AR_ADJUSTMENTS_ALL	AR_APPROVAL_ACTION_HISTORY.ADJUSTMENT_ID
AR_DISTRIBUTIONS_ALL	AR_ADJUSTMENTS_ALL	AR_DISTRIBUTIONS_ALL.SOURCE_ID
AR_MC_ADJUSTMENTS	AR_ADJUSTMENTS_ALL	AR_MC_ADJUSTMENTS.ADJUSTMENT_ID
AR_MC_DISTRIBUTIONS_ALL	AR_ADJUSTMENTS_ALL	AR_MC_DISTRIBUTIONS_ALL.SOURCE_ID
AR_PAYMENT_SCHEDULES_ALL	AR_ADJUSTMENTS_ALL	AR_PAYMENT_SCHEDULES_ALL.ADJUSTMENT_ID_LAST
AR_STATEMENT_LINE_CLUSTERS	AR_ADJUSTMENTS_ALL	AR_STATEMENT_LINE_CLUSTERS.ADJUSTMENT_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_ADJUSTMENTS_ALL	RA_CUSTOMER_TRX_LINES_ALL.BR_ADJUSTMENT_ID