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

VIEW: APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V

Object Details
Object Name: AR_PAYMENT_SCHEDULES_ALL_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_PAYMENT_SCHEDULES_ALL_MRC_V
Subobject Name:
Status: VALID

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Identifies the payment schedule
CUSTOMER_TRX_ID NUMBER (15)
Identifies the item itself
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Conversion type used to convert foreign currency transactions
EXCHANGE_DATE DATE

Currency conversion date used to convert the transactional currency amount to reporting currency amount
EXCHANGE_RATE NUMBER

Currency conversion rate used to convert the transactional currency amount to reporting currency amount
ACCTD_AMOUNT_DUE_REMAINING NUMBER
Yes AMOUNT_DUE_REMAINING in the functional currency
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.
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
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
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_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
MRC_CUSTOMER_TRX_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, item identifier 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)
EXCLUDE_FROM_CONS_BILL_FLAG VARCHAR2 (1)
Indicates that the current payment schedule must be excluded from the consolidated bill.
Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      ACCTD_AMOUNT_DUE_REMAINING
,      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
,      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
,      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
,      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_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      MRC_ACCTD_AMOUNT_DUE_REMAINING
,      MRC_CUSTOMER_TRX_ID
,      BR_AMOUNT_ASSIGNED
,      RESERVED_TYPE
,      RESERVED_VALUE
,      ACTIVE_CLAIM_FLAG
,      EXCLUDE_FROM_CONS_BILL_FLAG
FROM APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V;

Dependencies

[top of page]

APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V references the following:

SchemaAPPS
SynonymAR_MC_PAYMENT_SCHEDULES
SynonymAR_PAYMENT_SCHEDULES_ALL
APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V is referenced by following:

SchemaAPPS
ViewAR_AEL_SL_REC_MRC_V