AR_PAYMENT_SCHEDULES_ALL
The AR_PAYMENT_SCHEDULES_ALL table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. Oracle Receivables groups different transactions by entering one of these values in the CLASS column: INV for Invoice, DM for Debit Memo, CM for Credit Memo, CB for Chargeback, PMT for receipt and BR for bills receivable. Transaction classes determine if a transaction relates to RA_CUSTOMER_TRX_ALL table or AR_CASH_RECEIPTS_ALL table. Using the CUSTOMER_TRX_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to RA_CUSTOMER_TRX_ALL table for nonpayment transaction entries, such as the creation of credit memos, debit memos, invoices, or chargebacks. Using the CASH_RECEIPT_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the AR_CASH_RECEIPTS_ALL table for invoice-related payment transactions. When a receipt is applied, Receivables updates the AMOUNT_APPLIED, AMOUNT_DUE_REMAINING, and STATUS columns. The STATUS column changes from OP for open to CL for closed 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. 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 are 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 currently available for this customer. For invoices with split terms, Oracle Receivables creates one record in the RA_CUSTOMER_TRX_ALL table and one record in the AR_PAYMENT_SCHEDULES_ALL table for each installment. In the AR_PAYMENT_SCHEDULES_ALL table, the DUE_DATE and AMOUNT_DUE_REMAINING columns can differ for each installment of a split term invoice. Each installment is differentiated by the TERMS_SEQUENCE_NUMBER column. If you create a debit memo reversal when you reverse a receipt, 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 reversed receipt. Receivables creates a new payment schedule record when you create a chargeback. The ASSOCIATED_CASH_RECEIPT_ID column is the cash receipt of the payment you entered when you created the chargeback. The ACTUAL_DATE_CLOSED column gives the date you applied a payment or credit 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 the transaction was closed.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
AR_PAYMENT_SCHEDULES_PK |
PAYMENT_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Yes | Identifies the payment schedule | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |||
| AMOUNT_ON_ACCOUNT | NUMBER | Amount of receipt placed on account. | ||||
| AMOUNT_OTHER_ACCOUNT | NUMBER | Oracle internal use only. | ||||
| STAGED_DUNNING_LEVEL | NUMBER | 2 | Dunning level of the item as printed on the dunning correspondence | |||
| DUNNING_LEVEL_OVERRIDE_DATE | DATE | System date that user manually adjusted the dunning level of a debit item | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| DUE_DATE | DATE | Yes | Due date of this installment | |||
| AMOUNT_DUE_ORIGINAL | NUMBER | Yes | Original due amount. | |||
| AMOUNT_DUE_REMAINING | NUMBER | Yes | The current amount due remaining | |||
| NUMBER_OF_DUE_DATES | NUMBER | 18 | Yes | The total number of installments for this invoice | ||
| STATUS | VARCHAR2 | 30 | Yes | Lookup code for the status of the item | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Lookup code for the currency of the invoice | ||
| CLASS | VARCHAR2 | 20 | Yes | Lookup code for the class of the payment schedule | ||
| CUSTOMER_ID | NUMBER | 18 | Identifies the customer associated with the item | |||
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Identifies the customer site associated with the customer. This must be a 'BILL_TO' site. | |||
| CUSTOMER_TRX_ID | NUMBER | 18 | Transaction identifier. | |||
| CASH_RECEIPT_ID | NUMBER | 18 | Identifies the payment (cash receipt) | |||
| ASSOCIATED_CASH_RECEIPT_ID | NUMBER | 18 | Identifier for CASH_RECEIPT_ID of receipt from which chargeback is created | |||
| TERM_ID | NUMBER | 18 | Identifies the terms used in calculating the payment schedule | |||
| TERMS_SEQUENCE_NUMBER | NUMBER | 18 | The sequence number given to each installment for multiple payment terms | |||
| GL_DATE_CLOSED | DATE | Yes | The accounting date when the schedule was closed. If the schedule is not closed it will not have a value. To improve performance this column must have a value, so it is populated with largest date of 31-DEC-4712. | |||
| ACTUAL_DATE_CLOSED | DATE | Yes | The actual date when the schedule was closed. If the schedule is not closed it will not have a value. To improve performance this column must have a value, so it is populated with largest date of 31-DEC-4712. | |||
| DISCOUNT_DATE | DATE | Not currently used. | ||||
| AMOUNT_LINE_ITEMS_ORIGINAL | NUMBER | Original line amount of the item | ||||
| AMOUNT_LINE_ITEMS_REMAINING | NUMBER | Remaining line amount of the item | ||||
| AMOUNT_APPLIED | NUMBER | Amount applied to the installment. | ||||
| AMOUNT_ADJUSTED | NUMBER | Amount adjusted against the item | ||||
| AMOUNT_IN_DISPUTE | NUMBER | The amount in dispute against the item | ||||
| AMOUNT_CREDITED | NUMBER | The amount credited against the item | ||||
| RECEIVABLES_CHARGES_CHARGED | NUMBER | Amount of receivables charges incurred against the item | ||||
| RECEIVABLES_CHARGES_REMAINING | NUMBER | Amount of receivables charges remaining | ||||
| FREIGHT_ORIGINAL | NUMBER | Original freight amount for the item | ||||
| FREIGHT_REMAINING | NUMBER | Remaining freight amount for the item | ||||
| TAX_ORIGINAL | NUMBER | Original tax amount for the item | ||||
| TAX_REMAINING | NUMBER | Remaining tax amount for the item | ||||
| DISCOUNT_ORIGINAL | NUMBER | Not currently used. | ||||
| DISCOUNT_REMAINING | NUMBER | Not currently used. | ||||
| DISCOUNT_TAKEN_EARNED | NUMBER | Actual amount of earned discount taken for the item | ||||
| DISCOUNT_TAKEN_UNEARNED | NUMBER | Actual amount of unearned discount taken for the item | ||||
| IN_COLLECTION | VARCHAR2 | 1 | Y or N flag to indicate whether the item is in collection | |||
| CASH_APPLIED_ID_LAST | NUMBER | Not currently used. | ||||
| CASH_APPLIED_DATE_LAST | DATE | Not currently used. | ||||
| CASH_APPLIED_AMOUNT_LAST | NUMBER | Not currently used. | ||||
| CASH_APPLIED_STATUS_LAST | VARCHAR2 | 30 | Not currently used. | |||
| CASH_GL_DATE_LAST | DATE | Not currently used. | ||||
| CASH_RECEIPT_ID_LAST | NUMBER | 18 | Not currently used. | |||
| CASH_RECEIPT_DATE_LAST | DATE | Not currently used. | ||||
| CASH_RECEIPT_AMOUNT_LAST | NUMBER | Not currently used. | ||||
| CASH_RECEIPT_STATUS_LAST | VARCHAR2 | 30 | Not currently used. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type. | |||
| EXCHANGE_DATE | DATE | Conversion rate date. | ||||
| EXCHANGE_RATE | NUMBER | Conversion rate. | ||||
| ADJUSTMENT_ID_LAST | NUMBER | 18 | Not currently used. | |||
| ADJUSTMENT_DATE_LAST | DATE | Not currently used. | ||||
| ADJUSTMENT_GL_DATE_LAST | DATE | Not currently used. | ||||
| ADJUSTMENT_AMOUNT_LAST | NUMBER | Not currently used. | ||||
| FOLLOW_UP_DATE_LAST | DATE | Date the customer was last contacted with reference to the item | ||||
| FOLLOW_UP_CODE_LAST | VARCHAR2 | 30 | Lookup code for the outcome of the last follow up with the customer | |||
| PROMISE_DATE_LAST | DATE | Oracle internal use only. The latest promise date of the promise dates given by the customer for paying this installment. | ||||
| PROMISE_AMOUNT_LAST | NUMBER | Oracle internal use only. The sum of all the amounts promised by the customer for this installment. | ||||
| COLLECTOR_LAST | NUMBER | 18 | The last collector that called the customer | |||
| CALL_DATE_LAST | DATE | The last date a collector called a customer | ||||
| TRX_NUMBER | VARCHAR2 | 30 | The transaction number of the item | |||
| TRX_DATE | DATE | The transaction date of the item | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| REVERSED_CASH_RECEIPT_ID | NUMBER | 18 | 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 of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Schedules (AR_PAYMENT_SCHEDULES) | ||
| GL_DATE | DATE | Yes | Accounting date. | |||
| ACCTD_AMOUNT_DUE_REMAINING | NUMBER | Yes | Open amount of transaction in functional currency | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |||
| 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 | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| SELECTED_FOR_RECEIPT_BATCH_ID | NUMBER | 18 | Identifier for automatic receipt batch. A transaction is available for automatic receipt if this column is null and invoice is associated with an automatic payment method. | |||
| LAST_CHARGE_DATE | DATE | Date on which the late charge was last calculated for the transaction installment. | ||||
| SECOND_LAST_CHARGE_DATE | DATE | Not currently used. | ||||
| 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 | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| CONS_INV_ID | NUMBER | 18 | Consolidated invoice ID that contains this transaction | |||
| CONS_INV_ID_REV | NUMBER | 18 | Identifies a consolidated billing number that includes a cash receipt reversal | |||
| EXCLUDE_FROM_DUNNING_FLAG | VARCHAR2 | 1 | Y or N indicates whether this customer should be excluded from the dunning process | |||
| BR_AMOUNT_ASSIGNED | NUMBER | Amount of a bill receivable that is applied to a transaction in the transaction currency. | ||||
| RESERVED_TYPE | VARCHAR2 | 30 | Identifies transactions that have been reserved by another entity. | |||
| RESERVED_VALUE | NUMBER | 18 | Stores the ID of the entity that is reserving this transaction. | |||
| ACTIVE_CLAIM_FLAG | VARCHAR2 | 1 | This will be used to determine if an active claim exists in Trade Management for this transaction. | |||
| EXCLUDE_FROM_CONS_BILL_FLAG | VARCHAR2 | 1 | Indicates that the current payment schedule must be excluded from the consolidated bill. | |||
| PAYMENT_APPROVAL | VARCHAR2 | 30 | This column is used to approve or reject an invoice for payment. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Transaction type sequence identifier. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| DEL_CONTACT_EMAIL_ADDRESS | VARCHAR2 | 1000 | E-Mail address of the customer bill-to contact who receives printed transactions. | |||
| PRINT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the last print. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| EXPECTED_COLLECTION_AMOUNT | NUMBER | Amount expected to be received. | ||||
| EXPECTED_COLLECTION_DATE | DATE | The date when the payment is expected to be received. | ||||
| COLLECTION_BASED_FORECAST_DATE | DATE | Oracle internal use only. System date calculated from the due date, promise date, and expected collection date for cash forecasting purposes. | ||||
| COLLECTION_BASED_FORECAST_AMT | NUMBER | Oracle internal use only. System amount calculated from the amount due, amount promised, and expected collection amount for cash forecasting purposes. | ||||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier of the legal entity assigned to the transaction installment. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_PAYMENT_SCHEDULES_ALL | hz_cust_accounts | CUSTOMER_ID |
| AR_PAYMENT_SCHEDULES_ALL | ar_receivable_applications_all | CASH_APPLIED_ID_LAST |
| AR_PAYMENT_SCHEDULES_ALL | ar_cash_receipts_all | CASH_RECEIPT_ID_LAST |
| AR_PAYMENT_SCHEDULES_ALL | ar_adjustments_all | ADJUSTMENT_ID_LAST |
| AR_PAYMENT_SCHEDULES_ALL | ar_collectors | COLLECTOR_LAST |
| AR_PAYMENT_SCHEDULES_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AR_PAYMENT_SCHEDULES_ALL | ar_batches_all | SELECTED_FOR_RECEIPT_BATCH_ID |
| AR_PAYMENT_SCHEDULES_ALL | hz_cust_site_uses_all | CUSTOMER_SITE_USE_ID |
| AR_PAYMENT_SCHEDULES_ALL | ar_cons_inv_all | CONS_INV_ID |
| AR_PAYMENT_SCHEDULES_ALL | ar_cons_inv_all | CONS_INV_ID_REV |
| AR_PAYMENT_SCHEDULES_ALL | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| AR_PAYMENT_SCHEDULES_ALL | ra_customer_trx_all | CUSTOMER_TRX_ID |
| AR_PAYMENT_SCHEDULES_ALL | ar_cash_receipts_all | CASH_RECEIPT_ID |
| AR_PAYMENT_SCHEDULES_ALL | ar_cash_receipts_all | ASSOCIATED_CASH_RECEIPT_ID |
| AR_PAYMENT_SCHEDULES_ALL | ar_cash_receipts_all | REVERSED_CASH_RECEIPT_ID |
| AR_PAYMENT_SCHEDULES_ALL | ra_terms_b | TERM_ID |
| ar_cons_inv_trx_all | ar_payment_schedules_all | ADJ_PS_ID |
| iex_delinquencies_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_adjustments_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_cash_remit_refs_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| iex_case_folder_objects | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_cash_reco_lines_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_autorec_exceptions | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_automatch_trx_t | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_interest_lines_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_bpa_print_requests | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| jl_br_ar_pay_sched_aux | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_trx_summary_hist | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_interim_cash_receipts_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_interim_cash_rcpt_lines_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_dispute_history | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| jl_br_ar_coll_docs_det_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_receivable_applications_all | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| ar_receivable_applications_all | ar_payment_schedules_all | APPLIED_PAYMENT_SCHEDULE_ID |
| ar_late_charge_trx_t | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_PAYMENT_SCHEDULES_N1 | Non Unique | Default | TRX_DATE |
| AR_PAYMENT_SCHEDULES_N10 | Non Unique | Default | ACTUAL_DATE_CLOSED, CLASS |
| AR_PAYMENT_SCHEDULES_N11 | Non Unique | Default | CUSTOMER_ID, TRX_NUMBER |
| AR_PAYMENT_SCHEDULES_N12 | Non Unique | Default | ASSOCIATED_CASH_RECEIPT_ID |
| AR_PAYMENT_SCHEDULES_N13 | Non Unique | Default | SELECTED_FOR_RECEIPT_BATCH_ID |
| AR_PAYMENT_SCHEDULES_N14 | Non Unique | Default | CONS_INV_ID |
| AR_PAYMENT_SCHEDULES_N15 | Non Unique | Default | RESERVED_TYPE, RESERVED_VALUE |
| AR_PAYMENT_SCHEDULES_N16 | Non Unique | Default | REQUEST_ID |
| AR_PAYMENT_SCHEDULES_N17 | Non Unique | Default | GL_DATE_CLOSED, DUE_DATE |
| AR_PAYMENT_SCHEDULES_N18 | Non Unique | Default | STATUS, CLASS, DUE_DATE |
| AR_PAYMENT_SCHEDULES_N2 | Non Unique | Default | CUSTOMER_TRX_ID |
| AR_PAYMENT_SCHEDULES_N3 | Non Unique | Default | TRX_NUMBER |
| AR_PAYMENT_SCHEDULES_N4 | Non Unique | Default | DUE_DATE |
| AR_PAYMENT_SCHEDULES_N5 | Non Unique | Default | CUSTOMER_SITE_USE_ID, STATUS |
| AR_PAYMENT_SCHEDULES_N6 | Non Unique | Default | CUSTOMER_ID, STATUS |
| AR_PAYMENT_SCHEDULES_N7 | Non Unique | Default | CUSTOMER_ID, GL_DATE |
| AR_PAYMENT_SCHEDULES_N9 | Non Unique | Default | GL_DATE_CLOSED, CLASS, STATUS |
| AR_PAYMENT_SCHEDULES_U1 | Unique | Default | PAYMENT_SCHEDULE_ID |
| AR_PAYMENT_SCHEDULES_U2 | Unique | Default | CASH_RECEIPT_ID |
| AR_PAYMENT_SCHEDULES_U3 | Unique | Default | REVERSED_CASH_RECEIPT_ID |