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_PAYMENT_SCHEDULES_ALL

Product:	AR - Receivables
Description:	All transactions except adjustments and miscellaneous cash receipts
Implementation/DBA Data:	AR.AR_PAYMENT_SCHEDULES_ALL

Primary Key: AR_PAYMENT_SCHEDULES_PK

PAYMENT_SCHEDULE_ID

Primary Key: AR_PAYMENT_SCHEDULES_UK1

CUSTOMER_TRX_ID
TERMS_SEQUENCE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_PAYMENT_SCHEDULES_ALL	HZ_CUST_ACCOUNTS	AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_ID
AR_PAYMENT_SCHEDULES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_PAYMENT_SCHEDULES_ALL.CASH_APPLIED_ID_LAST
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.CASH_RECEIPT_ID_LAST
AR_PAYMENT_SCHEDULES_ALL	AR_ADJUSTMENTS_ALL	AR_PAYMENT_SCHEDULES_ALL.ADJUSTMENT_ID_LAST
AR_PAYMENT_SCHEDULES_ALL	AR_COLLECTORS	AR_PAYMENT_SCHEDULES_ALL.COLLECTOR_LAST
AR_PAYMENT_SCHEDULES_ALL	FND_CURRENCIES	AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE
AR_PAYMENT_SCHEDULES_ALL	FND_CURRENCIES	AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE
AR_PAYMENT_SCHEDULES_ALL	HZ_CUST_ACCOUNTS	AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_ID
AR_PAYMENT_SCHEDULES_ALL	AR_BATCHES_ALL	AR_PAYMENT_SCHEDULES_ALL.SELECTED_FOR_RECEIPT_BATCH_ID
AR_PAYMENT_SCHEDULES_ALL	HZ_CUST_SITE_USES_ALL	AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID
AR_PAYMENT_SCHEDULES_ALL	RA_CUST_TRX_TYPES_ALL	AR_PAYMENT_SCHEDULES_ALL.CUST_TRX_TYPE_ID
AR_PAYMENT_SCHEDULES_ALL	RA_CUSTOMER_TRX_ALL	AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.ASSOCIATED_CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.REVERSED_CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_ALL	RA_TERMS_B	AR_PAYMENT_SCHEDULES_ALL.TERM_ID
AR_ADJUSTMENTS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_ADJUSTMENTS_ALL.PAYMENT_SCHEDULE_ID
AR_AUDIT_DATA	AR_PAYMENT_SCHEDULES_ALL	AR_AUDIT_DATA.PAYMENT_SCHEDULE_ID
AR_AUTOREC_EXCEPTIONS	AR_PAYMENT_SCHEDULES_ALL	AR_AUTOREC_EXCEPTIONS.PAYMENT_SCHEDULE_ID
AR_BPA_PRINT_REQUESTS	AR_PAYMENT_SCHEDULES_ALL	AR_BPA_PRINT_REQUESTS.PAYMENT_SCHEDULE_ID
AR_CASH_BASIS_DISTS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_CASH_BASIS_DISTS_ALL.PAYMENT_SCHEDULE_ID
AR_CORR_PAY_SCHED_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_CORR_PAY_SCHED_ALL.PAYMENT_SCHEDULE_ID
AR_CUSTOMER_CALL_TOPICS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_CUSTOMER_CALL_TOPICS_ALL.PAYMENT_SCHEDULE_ID
AR_DISPUTE_HISTORY	AR_PAYMENT_SCHEDULES_ALL	AR_DISPUTE_HISTORY.PAYMENT_SCHEDULE_ID
AR_INTERIM_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_INTERIM_CASH_RECEIPTS_ALL.PAYMENT_SCHEDULE_ID
AR_INTERIM_CASH_RCPT_LINES_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_INTERIM_CASH_RCPT_LINES_ALL.PAYMENT_SCHEDULE_ID
AR_MC_CASH_BASIS_DISTS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_MC_CASH_BASIS_DISTS_ALL.PAYMENT_SCHEDULE_ID
AR_MC_PAYMENT_SCHEDULES	AR_PAYMENT_SCHEDULES_ALL	AR_MC_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
AR_MC_RECEIVABLE_APPS	AR_PAYMENT_SCHEDULES_ALL	AR_MC_RECEIVABLE_APPS.PAYMENT_SCHEDULE_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SCHEDULE_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_PAYMENT_SCHEDULE_ID
JAI_AR_PAYMENT_AUDITS	AR_PAYMENT_SCHEDULES_ALL	JAI_AR_PAYMENT_AUDITS.PAYMENT_SCHEDULE_ID
JL_BR_AR_COLLECTION_DOCS_ALL	AR_PAYMENT_SCHEDULES_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.PAYMENT_SCHEDULE_ID
JL_BR_AR_PAY_SCHED_AUX	AR_PAYMENT_SCHEDULES_ALL	JL_BR_AR_PAY_SCHED_AUX.PAYMENT_SCHEDULE_ID
OKL_TXL_ADJSTS_LNS_B	AR_PAYMENT_SCHEDULES_ALL	OKL_TXL_ADJSTS_LNS_B.PSL_ID
OKL_TXL_ADJSTS_LNS_ALL_B	AR_PAYMENT_SCHEDULES_ALL	OKL_TXL_ADJSTS_LNS_ALL_B.PSL_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_PAYMENT_SCHEDULES_ALL	RA_CUSTOMER_TRX_LINES_ALL.BR_REF_PAYMENT_SCHEDULE_ID