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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PSA_MF_PAYMENT_SCHEDULES_V

Object Details

Object Name:	PSA_MF_PAYMENT_SCHEDULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSA.PSA_MF_PAYMENT_SCHEDULES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PSA_MF_PAYMENT_SCHEDULES_V is used by Multi-Fund Accounts Receivables to view payment schedules for Multi-Fund transactions only. This View is functionally similar to AR_PAYMENT_SCHEDULES_ALL.
AR_PAYMENT_SCHEDULES_ALL joins to the RA_CUSTOMER_TRX_ALL table
for nonpayment transaction entries such as the creation of
credit memos, debit memos, invoices, chargebacks, or
deposits. AR_PAYMENT_SCHEDULES_ALL uses the foreign key
CUSTOMER_TRX_ID to join to the RA_CUSTOMER_TRX_ALL table for
these transactions. AR_PAYMENT_SCHEDULES_ALL joins to the
AR_CASH_RECEIPTS_ALL table for invoice-related payment
transactions using the foreign key CASH_RECEIPT_ID.
PSA_MF_PAYMENT_SCHEDULES_V joins AR_PAYMENT_SCHEDULES_ALL
and PSA_MF_BALANCES_VIEW to split transactions into multiple funds.
Transactions should be of type Multi-Fund Invoices or Credit Memos applied to Multi-Fund Invoices.
This View is used for reporting purposes and is used in PSA Aging 4 Buckets Report.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Identifies the payment schedule
CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)	Yes	Revenue distribution identifier
DUE_DATE	DATE		Yes	Due date of this installment
AMOUNT_DUE_ORIGINAL	NUMBER			Original amount due
AMOUNT_DUE_REMAINING	NUMBER			Current amount due remaining
AMOUNT_CREDITED	NUMBER			Amount credited against the item
AMOUNT_IN_DISPUTE	NUMBER			Amount in dispute against the item
AMOUNT_ADJUSTED_PENDING	NUMBER			Amount of pending adjustment
STATUS	VARCHAR2	(30)	Yes	Lookup code for the item status
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Lookup code for the invoice currency
CLASS	VARCHAR2	(20)	Yes	Lookup code for the payment schedule class
CUST_TRX_TYPE_ID	NUMBER	(15)		Identifies the item transaction type
CUSTOMER_ID	NUMBER	(15)		Identifies the customer associated with the item
CUSTOMER_SITE_USE_ID	NUMBER	(15)		Identifies the customer site associated with the customer; must be a BILL_TO site
CUSTOMER_TRX_ID	NUMBER	(15)		Identifies the item itself
CASH_RECEIPT_ID	NUMBER	(15)		Identifies the payment, cash receipt
ASSOCIATED_CASH_RECEIPT_ID	NUMBER	(15)		Identifier for CASH_RECEIPT_ID of receipt from which the chargeback is created
TERM_ID	NUMBER	(15)		Identifies the terms used in calculating the payment schedule
GL_DATE_CLOSED	DATE		Yes	The accounting date on which the schedule was closed; if the schedule is not closed, it is filled with largest date (V7db supports '31-DEC-4712') because this a Not Null column to improve performance of the aging report.
ACTUAL_DATE_CLOSED	DATE		Yes	Actual date on which the schedule was closed. When not closed, populate with large date (V7db supports'31-DEC-4712') because it is a Not Null column to improve performance of the aging report.
AMOUNT_APPLIED	NUMBER			Amount applied to the item
AMOUNT_ADJUSTED	NUMBER			Amount adjusted against the item
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type used
EXCHANGE_DATE	DATE			Exchange rate date used
EXCHANGE_RATE	NUMBER			Exchange rate used
TRX_NUMBER	VARCHAR2	(30)		Item transaction number
TRX_DATE	DATE			Item transaction date
REVERSED_CASH_RECEIPT_ID	NUMBER	(15)		Identifier for CASH_RECEIPT_ID of reversed receipt from which debit memo is created
GL_DATE	DATE		Yes	General Ledger date
ACCTD_AMOUNT_DUE_REMAINING	NUMBER			Open amount of transaction in functional currency
RECEIPT_CONFIRMED_FLAG	VARCHAR2	(1)		Y or N flag for a receipt to indicate whether the receipt has been confirmed
DISPUTE_DATE	DATE			Dispute date
ORG_ID	NUMBER	(15)		Organization identifier
CONS_INV_ID	NUMBER	(15)		Consolidated invoice identifier that contains this transaction
MF_RECEIVABLES_CCID	NUMBER	(15)		Multi-Fund Transaction Distribution identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYMENT_SCHEDULE_ID
,      CUST_TRX_LINE_GL_DIST_ID
,      DUE_DATE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      AMOUNT_CREDITED
,      AMOUNT_IN_DISPUTE
,      AMOUNT_ADJUSTED_PENDING
,      STATUS
,      INVOICE_CURRENCY_CODE
,      CLASS
,      CUST_TRX_TYPE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUSTOMER_TRX_ID
,      CASH_RECEIPT_ID
,      ASSOCIATED_CASH_RECEIPT_ID
,      TERM_ID
,      GL_DATE_CLOSED
,      ACTUAL_DATE_CLOSED
,      AMOUNT_APPLIED
,      AMOUNT_ADJUSTED
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      TRX_NUMBER
,      TRX_DATE
,      REVERSED_CASH_RECEIPT_ID
,      GL_DATE
,      ACCTD_AMOUNT_DUE_REMAINING
,      RECEIPT_CONFIRMED_FLAG
,      DISPUTE_DATE
,      ORG_ID
,      CONS_INV_ID
,      MF_RECEIVABLES_CCID
FROM APPS.PSA_MF_PAYMENT_SCHEDULES_V;

Dependencies

[top of page]

APPS.PSA_MF_PAYMENT_SCHEDULES_V references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; PSA_MF_BALANCES_VIEW; PSA_MF_TRX_DIST_ALL; PSA_TRX_TYPES_ALL; RA_CUSTOMER_TRX_ALL; RA_CUST_TRX_LINE_GL_DIST_ALL

APPS.PSA_MF_PAYMENT_SCHEDULES_V is not referenced by any database object