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]

TABLE: AR.AR_PAYMENT_SCHEDULES_ALL

Object Details

Object Name:	AR_PAYMENT_SCHEDULES_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_PAYMENT_SCHEDULES_ALL
Subobject Name:
Status:	VALID

The AR_PAYMENT_SCHEDULES_ALL table stores two types of records. The first type represents the payment installments for receivable transactions and the second type represents receipt application to transaction installments. The CLASS column determines whether the record relates to either transaction installment or receipt application.
For transaction installments, the information stored in this table is displayed to the users in the �Installments� form of the transaction workbench. For receipt applications, the information stored in this table is displayed to the users in the �Applications� form of the receipt workbench. Each receipt application creates a row in the table.
This table contains one or more rows for each transaction based on the payment terms associated to the transaction. The DUE_DATE and AMOUNT_DUE_REMAINING columns can differ for each installment of a split term invoice. The TERMS_SEQUENCE_NUMBER column differentiates each installment. Installment records in this table are updated when activities occurs against an invoice, debit memo, chargeback, credit memo or on-account credit.
Oracle Receivables groups different transactions by entering one of the below values in the CLASS column:
INV � Invoice
DM - Debit Memo
GUAR � Guarantee
CM - Credit Memo
DEP - Deposit
CB � Chargeback
PMT - Receipt
BR - Bills Receivable
Using the CUSTOMER_TRX_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the RA_CUSTOMER_TRX_ALL table for transaction entries, such as the creation of credit memos, debit memos, invoices, chargebacks or deposits. Using the CASH_RECEIPT_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the AR_CASH_RECEIPTS_ALL table for receipts.
When a receipt is applied, Oracle Receivables updates the AMOUNT_APPLIED, AMOUNT_DUE_REMAINING, and STATUS columns. The STATUS column changes from �OP� to �CL� for any transaction that has an AMOUNT_DUE_REMAINING value of 0. For a receipt, the amount due that remains includes on-account and unapplied amounts. Oracle Receivables stores debit items such as invoices, debit memos, chargebacks, deposits, and guarantees as positive numbers in the AMOUNT_DUE_REMAINING and AMOUNT_DUE_ORIGINAL columns. Credit items such as credit memos and receipts are stored as negative numbers.
Receipts can be confirmed or not confirmed as designated by the CONFIRMED_FLAG column. The sum of the AMOUNT_DUE_REMAINING column for a customer for all confirmed payment schedules reflects the current customer balance. If this amount is negative, then the AMOUNT_DUE_REMAINING column indicates the credit balance amount that is currently available for this customer.
When a debit memo is created during receipt reversal, Oracle Receivables creates a new payment schedule record for the debit memo and populates the REVERSED_CASH_RECEIPT_ID column with the CASH_RECEIPT_ID column for the receipt that was reversed. Oracle Receivables creates a new payment schedule record when a chargeback is created in the Receipts window. The ASSOCIATED_CASH_RECEIPT_ID column stores the identifier of the cash receipt that is entered when the chargeback is created.
The ACTUAL_DATE_CLOSED column gives the date on which a payment or credit is applied to an open transaction that set the AMOUNT_DUE_REMAINING column to 0 for that transaction. The GL_DATE_CLOSED column indicates the accounting date on which the transaction is closed.
This tables stores seeded rows for specific receipt applications. Those rows store following values in the PAYMENT_SCHEDULE_ID column :
-9 for Credit Card Chargeback application
-8 for Refund application
-7 for Prepayment application
-6 for Credit Card Refund applicatio

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_PAYMENT_SCHEDULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
AR_PAYMENT_SCHEDULES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVERSED_CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_DATE
AR_PAYMENT_SCHEDULES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTUAL_DATE_CLOSED CLASS
AR_PAYMENT_SCHEDULES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID TRX_NUMBER
AR_PAYMENT_SCHEDULES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSOCIATED_CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SELECTED_FOR_RECEIPT_BATCH_ID
AR_PAYMENT_SCHEDULES_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONS_INV_ID
AR_PAYMENT_SCHEDULES_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESERVED_TYPE RESERVED_VALUE
AR_PAYMENT_SCHEDULES_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
AR_PAYMENT_SCHEDULES_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE_CLOSED DUE_DATE
AR_PAYMENT_SCHEDULES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
AR_PAYMENT_SCHEDULES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_NUMBER
AR_PAYMENT_SCHEDULES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DUE_DATE
AR_PAYMENT_SCHEDULES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_SITE_USE_ID STATUS
AR_PAYMENT_SCHEDULES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID STATUS
AR_PAYMENT_SCHEDULES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID GL_DATE
AR_PAYMENT_SCHEDULES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE_CLOSED CLASS

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Internal Identifier of the installment record and primary key for this table.
STAGED_DUNNING_LEVEL	NUMBER	(2)		Dunning level of the payment schedule as printed on the dunning correspondence.
DUNNING_LEVEL_OVERRIDE_DATE	DATE			The system date on which user manually adjusted the dunning level of the transaction.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column. Date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column. User who last updated this row.
CREATION_DATE	DATE		Yes	Standard who column. Date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column. User who created this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column. Operating system login of user who last updated this row.
DUE_DATE	DATE		Yes	Due date of the installment
AMOUNT_DUE_ORIGINAL	NUMBER		Yes	The original amount due of the installment
AMOUNT_DUE_REMAINING	NUMBER		Yes	The current outstanding amount of the installment. This column is updated when: A receipt is applied to the installment A credit memo is applied to the installment An adjustment is performed for the receivables transaction
NUMBER_OF_DUE_DATES	NUMBER	(15)	Yes	The total number of installments created for the associated receivables transaction.
STATUS	VARCHAR2	(30)	Yes	Status of the installment. Possible values are �OP� for open status and �CL� for close status. A payment schedule will have a status of �OP� when amount due remaining is not equal to zero and a status of �CL� when amount due remaining is equal to zero.
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code of the associated transaction.
CLASS	VARCHAR2	(20)	Yes	Identifies the class of transaction to which the installment is related. Possible values are:INV � InvoiceDM - Debit MemoGUAR � GuaranteeCM - Credit MemoDEP - Deposit CB � ChargebackPMT - Receipt BR - Bills Receivable
CUST_TRX_TYPE_ID	NUMBER	(15)		The unique internal identifier for the transaction type of the associated transaction. The field is not populated if the record is related to receipt.
CUSTOMER_ID	NUMBER	(15)		The unique internal identifier of the customer to which the transaction or receipt belongs.
CUSTOMER_SITE_USE_ID	NUMBER	(15)		The unique internal identifier for the Bill To site of the customer.
CUSTOMER_TRX_ID	NUMBER	(15)		The unique internal identifier for the associated receivables transaction. This column is not populated if the record is related to a receipt application.
CASH_RECEIPT_ID	NUMBER	(15)		The unique internal identifier of the associated receipt. This column is populated only if the record is related to a receipt application.
ASSOCIATED_CASH_RECEIPT_ID	NUMBER	(15)		The unique internal identifier of the receipt from which the chargeback is created. This column is populated only if the associated transaction is a chargeback.
TERM_ID	NUMBER	(15)		The unique internal identifier of the payments terms used in calculating the payment schedule. Payment term is derived from the associated receivables transaction.
TERMS_SEQUENCE_NUMBER	NUMBER	(15)		The sequence number given to each installment record. Multiple installment records are created for a receivables transaction when split payment terms are used. For each transaction the sequence number starts with 1 and incremented by 1.
GL_DATE_CLOSED	DATE		Yes	The accounting date when the schedule was closed. If the schedule is not closed, this column is populated with largest date (V7db supports 31-DEC-4712), to improve the aging report performance.
ACTUAL_DATE_CLOSED	DATE		Yes	The actual date when the schedule was closed. If the schedule is not closed, this column is populated with largest date (V7db supports 31-DEC-4712), to improve the aging report performance.
DISCOUNT_DATE	DATE			No longer in use.
AMOUNT_LINE_ITEMS_ORIGINAL	NUMBER			Original line amount of the payment schedule. This column is not populated if the record is related to receipt application.
AMOUNT_LINE_ITEMS_REMAINING	NUMBER			Remaining line amount of the payment schedule. This column is not populated if the record is related to receipt application.
AMOUNT_APPLIED	NUMBER			Receipt amount applied to the installment.
AMOUNT_ADJUSTED	NUMBER			Amount adjusted for the installment.
AMOUNT_IN_DISPUTE	NUMBER			Amount disputed for the installment.
AMOUNT_CREDITED	NUMBER			Credit Memo amount applied to the installment.
RECEIVABLES_CHARGES_CHARGED	NUMBER			Original amount of finance charge applied to the installment. This column is not populated if the record is related to a receipt application.
RECEIVABLES_CHARGES_REMAINING	NUMBER			Remaining amount of finance charge for the payment schedule. This column is not populated if the record is related to a receipt application.
FREIGHT_ORIGINAL	NUMBER			Original freight amount for the payment schedule. This column is not populated if the record is related to receipt a application.
FREIGHT_REMAINING	NUMBER			Remaining freight amount for the payment schedule. This column is not populated if the record is related to a receipt application.
TAX_ORIGINAL	NUMBER			Original tax amount for the payment schedule. This column is not populated if the record is related to a receipt application.
TAX_REMAINING	NUMBER			Remaining tax amount for the payment schedule. This column is not populated if the record is related to a receipt application.
DISCOUNT_ORIGINAL	NUMBER			No longer in use.
DISCOUNT_REMAINING	NUMBER			No longer in use.
DISCOUNT_TAKEN_EARNED	NUMBER			Actual amount of earned discount taken for the installment. This column is populated only if the record is related to a receipt application.
DISCOUNT_TAKEN_UNEARNED	NUMBER			Actual amount of unearned discount taken for the installment. This column is populated only if the record is related to a receipt application.
IN_COLLECTION	VARCHAR2	(1)		This column indicates whether the payment schedule record is transferred to Advanced Collection module. Value �Y� indicates yes and value �N� indicates no.
CASH_APPLIED_ID_LAST	NUMBER			No longer in use.
CASH_APPLIED_DATE_LAST	DATE			No longer in use.
CASH_APPLIED_AMOUNT_LAST	NUMBER			No longer in use.
CASH_APPLIED_STATUS_LAST	VARCHAR2	(30)		No longer in use.
CASH_GL_DATE_LAST	DATE			No longer in use.
CASH_RECEIPT_ID_LAST	NUMBER	(15)		No longer in use.
CASH_RECEIPT_DATE_LAST	DATE			No longer in use.
CASH_RECEIPT_AMOUNT_LAST	NUMBER			No longer in use.
CASH_RECEIPT_STATUS_LAST	VARCHAR2	(30)		No longer in use.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		The exchange rate type used on the associated receivables transaction or receipt.
EXCHANGE_DATE	DATE			The exchange rate date used on the associated receivables transaction or receipt.
EXCHANGE_RATE	NUMBER			The exchange rate used on the associated receivables transaction or receipt.
ADJUSTMENT_ID_LAST	NUMBER	(15)		No longer in use.
ADJUSTMENT_DATE_LAST	DATE			No longer in use.
ADJUSTMENT_GL_DATE_LAST	DATE			No longer in use.
ADJUSTMENT_AMOUNT_LAST	NUMBER			No longer in use.
FOLLOW_UP_DATE_LAST	DATE			Date the customer was last contacted with reference to the associated transaction.
FOLLOW_UP_CODE_LAST	VARCHAR2	(30)		Lookup code value for the outcome of the last follow up with the customer. Possible values for the column are derived from the Receivables lookup code �FOLLOW_UP�.
PROMISE_DATE_LAST	DATE			The last date by which the customer promised to pay the installment.
PROMISE_AMOUNT_LAST	NUMBER			The amount the customer last promised to pay
COLLECTOR_LAST	NUMBER	(15)		The last collector that called the customer
CALL_DATE_LAST	DATE			The last date a collector called a customer
TRX_NUMBER	VARCHAR2	(30)		Transaction number of the associated transaction.
TRX_DATE	DATE			The transaction date of the associated transaction.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
REVERSED_CASH_RECEIPT_ID	NUMBER	(15)		Identifier for CASH_RECEIPT_ID of reversed receipt from which debit memo is created
AMOUNT_ADJUSTED_PENDING	NUMBER			Amount of pending adjustment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
GL_DATE	DATE		Yes	General Ledger accounting date
ACCTD_AMOUNT_DUE_REMAINING	NUMBER		Yes	Open amount of transaction in functional currency
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program who column. Application identifier of the program that last updated this row.
PROGRAM_ID	NUMBER	(15)		Concurrent program who column. Identifier of the program that last updated this row.
PROGRAM_UPDATE_DATE	DATE			Concurrent program who column. Date when a program last updated this row.
RECEIPT_CONFIRMED_FLAG	VARCHAR2	(1)		Y or N flag for a receipt to indicate whether the receipt has been confirmed
REQUEST_ID	NUMBER	(15)		Concurrent program who column. Identifier of the concurrent request that last updated this row.
SELECTED_FOR_RECEIPT_BATCH_ID	NUMBER	(15)		Stores the internal identifier of the automatic receipt batch, which includes the associated transaction. A transaction is available for automatic receipt creation or any other receivable activity only when this column is null.
LAST_CHARGE_DATE	DATE			The Late charges program stores the latest date on which this payment schedule was charged.
SECOND_LAST_CHARGE_DATE	DATE			This column is reserved for future use.
DISPUTE_DATE	DATE			This column stores the last date that was inserted into the AR_DISPUTE_HISTORY table. It basically serves as a placeholder so that the database trigger knows what date to insert.
ORG_ID	NUMBER	(15)		Unique internal identifier of the Operating Unit to which the transaction or receipt belongs.
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
CONS_INV_ID	NUMBER	(15)		This column is used by the Balance Forward Bill (earlier Consolidated Bill) to store the invoice ID that contains this transaction
CONS_INV_ID_REV	NUMBER	(15)		This column is used to store cons. Invoice id that was reversed by the receipt.
EXCLUDE_FROM_DUNNING_FLAG	VARCHAR2	(1)		This column indicates whether this transaction should be excluded from the dunning process. Possible values are Y or N.
MRC_CUSTOMER_TRX_ID	VARCHAR2	(2000)		No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
MRC_ACCTD_AMOUNT_DUE_REMAINING	VARCHAR2	(2000)		No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
BR_AMOUNT_ASSIGNED	NUMBER			Amount of transaction that is assigned to a bill receivable
RESERVED_TYPE	VARCHAR2	(30)		Used in bills receivable. Indicates that the bills receivable is reserved and no activity like receipts can be performed on this transaction.
RESERVED_VALUE	NUMBER	(15)		Used in bills receivable. Indicates that the bills receivable is reserved and no activity like receipts can be performed on this transaction.
ACTIVE_CLAIM_FLAG	VARCHAR2	(1)		This column indicates whether an active claim exists in Trade Management for this transaction.
EXCLUDE_FROM_CONS_BILL_FLAG	VARCHAR2	(1)		Flag to indicate exclusion from balance forward bill. Value �Y� indicates whether the transaction should be excluded from consolidation in a balance forward bill.
PAYMENT_APPROVAL	VARCHAR2	(30)		Used by iReceivables.

Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      STAGED_DUNNING_LEVEL
,      DUNNING_LEVEL_OVERRIDE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DUE_DATE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      NUMBER_OF_DUE_DATES
,      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
,      TERMS_SEQUENCE_NUMBER
,      GL_DATE_CLOSED
,      ACTUAL_DATE_CLOSED
,      DISCOUNT_DATE
,      AMOUNT_LINE_ITEMS_ORIGINAL
,      AMOUNT_LINE_ITEMS_REMAINING
,      AMOUNT_APPLIED
,      AMOUNT_ADJUSTED
,      AMOUNT_IN_DISPUTE
,      AMOUNT_CREDITED
,      RECEIVABLES_CHARGES_CHARGED
,      RECEIVABLES_CHARGES_REMAINING
,      FREIGHT_ORIGINAL
,      FREIGHT_REMAINING
,      TAX_ORIGINAL
,      TAX_REMAINING
,      DISCOUNT_ORIGINAL
,      DISCOUNT_REMAINING
,      DISCOUNT_TAKEN_EARNED
,      DISCOUNT_TAKEN_UNEARNED
,      IN_COLLECTION
,      CASH_APPLIED_ID_LAST
,      CASH_APPLIED_DATE_LAST
,      CASH_APPLIED_AMOUNT_LAST
,      CASH_APPLIED_STATUS_LAST
,      CASH_GL_DATE_LAST
,      CASH_RECEIPT_ID_LAST
,      CASH_RECEIPT_DATE_LAST
,      CASH_RECEIPT_AMOUNT_LAST
,      CASH_RECEIPT_STATUS_LAST
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      ADJUSTMENT_ID_LAST
,      ADJUSTMENT_DATE_LAST
,      ADJUSTMENT_GL_DATE_LAST
,      ADJUSTMENT_AMOUNT_LAST
,      FOLLOW_UP_DATE_LAST
,      FOLLOW_UP_CODE_LAST
,      PROMISE_DATE_LAST
,      PROMISE_AMOUNT_LAST
,      COLLECTOR_LAST
,      CALL_DATE_LAST
,      TRX_NUMBER
,      TRX_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REVERSED_CASH_RECEIPT_ID
,      AMOUNT_ADJUSTED_PENDING
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GL_DATE
,      ACCTD_AMOUNT_DUE_REMAINING
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIPT_CONFIRMED_FLAG
,      REQUEST_ID
,      SELECTED_FOR_RECEIPT_BATCH_ID
,      LAST_CHARGE_DATE
,      SECOND_LAST_CHARGE_DATE
,      DISPUTE_DATE
,      ORG_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      CONS_INV_ID
,      CONS_INV_ID_REV
,      EXCLUDE_FROM_DUNNING_FLAG
,      MRC_CUSTOMER_TRX_ID
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      MRC_ACCTD_AMOUNT_DUE_REMAINING
,      BR_AMOUNT_ASSIGNED
,      RESERVED_TYPE
,      RESERVED_VALUE
,      ACTIVE_CLAIM_FLAG
,      EXCLUDE_FROM_CONS_BILL_FLAG
,      PAYMENT_APPROVAL
FROM AR.AR_PAYMENT_SCHEDULES_ALL;

Dependencies

[top of page]

AR.AR_PAYMENT_SCHEDULES_ALL does not reference any database object

AR.AR_PAYMENT_SCHEDULES_ALL is referenced by following:

APPS: AR_PAYMENT_SCHEDULES; AR_PAYMENT_SCHEDULES_ALL; JL_BR_AR_OCC_DOCS_DUE_DATE_CHG; JL_BR_AR_PAYMENT_SCH_GBL; LNS_LOAN_DTLS_ALL_MV