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: TableAR.AR_PAYMENT_SCHEDULES_ALL
Subobject Name:
Status: VALID


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:
{{"bul:1"}}INV - Invoice
{{"bul:1"}}DM - Debit Memo
{{"bul:1"}}GUAR - Guarantee
{{"bul:1"}}CM - Credit Memo
{{"bul:1"}}DEP - Deposit
{{"bul:1"}}CB - Chargeback
{{"bul:1"}}PMT - Receipt
{{"bul:1"}}BR - Bills Receivable
{{"bodytext"}}Transaction classes determine if a transaction relates to either the RA_CUSTOMER_TRX_ALL table or the AR_CASH_RECEIPTS_ALL table. Using the CUSTOMER_TRX_ID foreign key column, the AR_PAYMENT_SCHEDULES_ALL table joins to the RA_CUSTOMER_TRX_ALL table for non-payment 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 invoice-related payment transactions.
.
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. 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, 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 you create a chargeback in the Receipts window. The ASSOCIATED_CASH_RECEIPT_ID column is the cash receipt of the payment that you entered when you created the chargeback in this window.
.
The ACTUAL_DATE_CLOSED column gives the date that 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 General Ledger date that your transaction was closed on.
For more details, see Technical Perspective: Transactions (Oracle Receivables User Guide).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_PAYMENT_SCHEDULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
ColumnZD_EDITION_NAME
AR_PAYMENT_SCHEDULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_RECEIPT_ID
ColumnPAYMENT_SCHEDULE_ID
ColumnZD_EDITION_NAME
AR_PAYMENT_SCHEDULES_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVERSED_CASH_RECEIPT_ID
ColumnPAYMENT_SCHEDULE_ID
ColumnZD_EDITION_NAME
AR_PAYMENT_SCHEDULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_DATE
AR_PAYMENT_SCHEDULES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTUAL_DATE_CLOSED
ColumnCLASS
AR_PAYMENT_SCHEDULES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnTRX_NUMBER
AR_PAYMENT_SCHEDULES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSOCIATED_CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSELECTED_FOR_RECEIPT_BATCH_ID
AR_PAYMENT_SCHEDULES_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONS_INV_ID
AR_PAYMENT_SCHEDULES_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESERVED_TYPE
ColumnRESERVED_VALUE
AR_PAYMENT_SCHEDULES_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
AR_PAYMENT_SCHEDULES_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_DATE_CLOSED
ColumnDUE_DATE
ColumnINVOICE_CURRENCY_CODE
ColumnSELECTED_FOR_RECEIPT_BATCH_ID
ColumnSTATUS
AR_PAYMENT_SCHEDULES_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_DATE_CLOSED
ColumnORG_ID
AR_PAYMENT_SCHEDULES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
AR_PAYMENT_SCHEDULES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_NUMBER
AR_PAYMENT_SCHEDULES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDUE_DATE
AR_PAYMENT_SCHEDULES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_SITE_USE_ID
ColumnSTATUS
ColumnCUSTOMER_ID
ColumnINVOICE_CURRENCY_CODE
ColumnEXCLUDE_FROM_CONS_BILL_FLAG
AR_PAYMENT_SCHEDULES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnSTATUS
ColumnINVOICE_CURRENCY_CODE
ColumnCLASS
ColumnDUE_DATE
AR_PAYMENT_SCHEDULES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnGL_DATE
AR_PAYMENT_SCHEDULES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_DATE_CLOSED
ColumnCLASS
ColumnGL_DATE
ColumnACCTD_AMOUNT_DUE_REMAINING
Columns
Name Datatype Length Mandatory Comments
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Identifies the payment schedule
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 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 (foreign key to FND_USER.USER_ID).
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 (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DUE_DATE DATE
Yes Due date of this installment
AMOUNT_DUE_ORIGINAL NUMBER
Yes The original amount due
AMOUNT_DUE_REMAINING NUMBER
Yes The current amount due remaining
NUMBER_OF_DUE_DATES NUMBER (15) 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
CUST_TRX_TYPE_ID NUMBER (15)
Identifies the transaction type of the item
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. This 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 chargeback is created
TERM_ID NUMBER (15)
Identifies the terms used in calculating the payment schedule
TERMS_SEQUENCE_NUMBER NUMBER (15)
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, this column is populated with largest date (V7db supports 31-DEC-4712) because, to improve aging report performance, this column must have a value.
ACTUAL_DATE_CLOSED DATE
Yes The actual date when the schedule was closed. If not closed, this column is populated with largest date (V7db supports 31-DEC-4712) because, to improve aging report performance, this column must have a value.
DISCOUNT_DATE DATE

No longer 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 item
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

No longer used
DISCOUNT_REMAINING NUMBER

No longer 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

No longer used
CASH_APPLIED_DATE_LAST DATE

No longer used
CASH_APPLIED_AMOUNT_LAST NUMBER

No longer used
CASH_APPLIED_STATUS_LAST VARCHAR2 (30)
No longer used
CASH_GL_DATE_LAST DATE

No longer used
CASH_RECEIPT_ID_LAST NUMBER (15)
No longer used
CASH_RECEIPT_DATE_LAST DATE

No longer used
CASH_RECEIPT_AMOUNT_LAST NUMBER

No longer used
CASH_RECEIPT_STATUS_LAST VARCHAR2 (30)
No longer used
EXCHANGE_RATE_TYPE VARCHAR2 (30)
The exchange rate type used
EXCHANGE_DATE DATE

The exchange rate date used
EXCHANGE_RATE NUMBER

The exchange rate used
ADJUSTMENT_ID_LAST NUMBER (15)
No longer used
ADJUSTMENT_DATE_LAST DATE

No longer used
ADJUSTMENT_GL_DATE_LAST DATE

No longer used
ADJUSTMENT_AMOUNT_LAST NUMBER

No longer 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

The last date by which the customer promised to pay
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)
The transaction number of the item
TRX_DATE DATE

The transaction date of the item
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 date
ACCTD_AMOUNT_DUE_REMAINING NUMBER
Yes Open amount of transaction in functional currency
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
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 (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SELECTED_FOR_RECEIPT_BATCH_ID NUMBER (15)
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

This column is reserved for future use. RA_SITE_USES.LAST_CHARGE_DATE is being moved down to this level.
SECOND_LAST_CHARGE_DATE DATE

This column is reserved for future use. RA_SITE_USES.SECOND_LAST_CHARGE_DATE is being moved down to this level.
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)
Organization identifier
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)
Consolidated invoice ID that contains this transaction
CONS_INV_ID_REV NUMBER (15)
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
MRC_CUSTOMER_TRX_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, item identifier pairs
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, exchange rate type used for converting pairs
MRC_EXCHANGE_DATE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, exchange date for converting pairs
MRC_EXCHANGE_RATE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, exchange rate used for converting pairs
MRC_ACCTD_AMOUNT_DUE_REMAINING VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, open amount of transaction in reporting currency(s) pairs
BR_AMOUNT_ASSIGNED NUMBER

Amount of transaction that was assigned to a bill receivable
RESERVED_TYPE VARCHAR2 (30)
Identifies transactions that have been reserved by another entity.
RESERVED_VALUE NUMBER (15)
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.
ZD_EDITION_NAME VARCHAR2 (30) Yes
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
,      ZD_EDITION_NAME
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:

SchemaAR
ViewAR_PAYMENT_SCHEDULES_ALL#