[Home] [Help] [Dependency Information]
Object Name: | AR_PAYMENT_SCHEDULES_FLEX_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_PAYMENT_SCHEDULES_FLEX_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_SCHEDULE_ID | NUMBER | (15) | ||
ACCTD_AMOUNT_DUE_REMAINING | NUMBER | |||
AMOUNT_DUE_ORIGINAL | NUMBER | |||
AMOUNT_DUE_REMAINING | NUMBER | |||
CLASS | VARCHAR2 | (20) | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
DUE_DATE | DATE | |||
GL_DATE | DATE | |||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
NUMBER_OF_DUE_DATES | NUMBER | (15) | ||
STATUS | VARCHAR2 | (30) | ||
ACTUAL_DATE_CLOSED | DATE | |||
ADJUSTMENT_AMOUNT_LAST | NUMBER | |||
ADJUSTMENT_DATE_LAST | DATE | |||
ADJUSTMENT_GL_DATE_LAST | DATE | |||
ADJUSTMENT_ID_LAST | NUMBER | (15) | ||
AMOUNT_ADJUSTED | NUMBER | |||
AMOUNT_ADJUSTED_PENDING | NUMBER | |||
AMOUNT_APPLIED | NUMBER | |||
AMOUNT_CREDITED | NUMBER | |||
AMOUNT_IN_DISPUTE | NUMBER | |||
AMOUNT_LINE_ITEMS_ORIGINAL | NUMBER | |||
AMOUNT_LINE_ITEMS_REMAINING | NUMBER | |||
ASSOCIATED_CASH_RECEIPT_ID | NUMBER | (15) | ||
CALL_DATE_LAST | DATE | |||
CASH_APPLIED_AMOUNT_LAST | NUMBER | |||
CASH_APPLIED_DATE_LAST | DATE | |||
CASH_APPLIED_ID_LAST | NUMBER | |||
CASH_APPLIED_STATUS_LAST | VARCHAR2 | (30) | ||
CASH_GL_DATE_LAST | DATE | |||
CASH_RECEIPT_AMOUNT_LAST | NUMBER | |||
CASH_RECEIPT_DATE_LAST | DATE | |||
CASH_RECEIPT_ID | NUMBER | (15) | ||
CASH_RECEIPT_ID_LAST | NUMBER | (15) | ||
CASH_RECEIPT_STATUS_LAST | VARCHAR2 | (30) | ||
COLLECTOR_LAST | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
CUST_TRX_TYPE_ID | NUMBER | (15) | ||
DISCOUNT_DATE | DATE | |||
DISCOUNT_ORIGINAL | NUMBER | |||
DISCOUNT_REMAINING | NUMBER | |||
DISCOUNT_TAKEN_EARNED | NUMBER | |||
DISCOUNT_TAKEN_UNEARNED | NUMBER | |||
EXCHANGE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
FOLLOW_UP_CODE_LAST | VARCHAR2 | (30) | ||
FOLLOW_UP_DATE_LAST | DATE | |||
FREIGHT_ORIGINAL | NUMBER | |||
FREIGHT_REMAINING | NUMBER | |||
GL_DATE_CLOSED | DATE | |||
IN_COLLECTION | VARCHAR2 | (1) | ||
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). | |
PROMISE_AMOUNT_LAST | NUMBER | |||
PROMISE_DATE_LAST | DATE | |||
RECEIPT_CONFIRMED_FLAG | VARCHAR2 | (1) | ||
RECEIVABLES_CHARGES_CHARGED | NUMBER | |||
RECEIVABLES_CHARGES_REMAINING | NUMBER | |||
REVERSED_CASH_RECEIPT_ID | NUMBER | (15) | ||
SELECTED_FOR_RECEIPT_BATCH_ID | NUMBER | (15) | ||
TAX_ORIGINAL | NUMBER | |||
TAX_REMAINING | NUMBER | |||
TERMS_SEQUENCE_NUMBER | NUMBER | (15) | ||
TERM_ID | NUMBER | (15) | ||
TRX_DATE | DATE | |||
TRX_NUMBER | VARCHAR2 | (30) | ||
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). | |
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). | ||
DISPUTE_DATE | DATE | |||
LAST_CHARGE_DATE | DATE | |||
SECOND_LAST_CHARGE_DATE | DATE | |||
DOC_SEQUENCE_VALUE | NUMBER | (15) | ||
RECEIPT_METHOD_ID | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | (30) | ||
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 | |
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 | |
PURCHASE_ORDER | VARCHAR2 | (50) | ||
DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | ||
INTERFACE_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_CONTEXT | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_SCHEDULE_ID
, ACCTD_AMOUNT_DUE_REMAINING
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, CLASS
, CREATED_BY
, CREATION_DATE
, DUE_DATE
, GL_DATE
, INVOICE_CURRENCY_CODE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, NUMBER_OF_DUE_DATES
, STATUS
, ACTUAL_DATE_CLOSED
, ADJUSTMENT_AMOUNT_LAST
, ADJUSTMENT_DATE_LAST
, ADJUSTMENT_GL_DATE_LAST
, ADJUSTMENT_ID_LAST
, AMOUNT_ADJUSTED
, AMOUNT_ADJUSTED_PENDING
, AMOUNT_APPLIED
, AMOUNT_CREDITED
, AMOUNT_IN_DISPUTE
, AMOUNT_LINE_ITEMS_ORIGINAL
, AMOUNT_LINE_ITEMS_REMAINING
, ASSOCIATED_CASH_RECEIPT_ID
, CALL_DATE_LAST
, CASH_APPLIED_AMOUNT_LAST
, CASH_APPLIED_DATE_LAST
, CASH_APPLIED_ID_LAST
, CASH_APPLIED_STATUS_LAST
, CASH_GL_DATE_LAST
, CASH_RECEIPT_AMOUNT_LAST
, CASH_RECEIPT_DATE_LAST
, CASH_RECEIPT_ID
, CASH_RECEIPT_ID_LAST
, CASH_RECEIPT_STATUS_LAST
, COLLECTOR_LAST
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, CUSTOMER_TRX_ID
, CUST_TRX_TYPE_ID
, DISCOUNT_DATE
, DISCOUNT_ORIGINAL
, DISCOUNT_REMAINING
, DISCOUNT_TAKEN_EARNED
, DISCOUNT_TAKEN_UNEARNED
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, FOLLOW_UP_CODE_LAST
, FOLLOW_UP_DATE_LAST
, FREIGHT_ORIGINAL
, FREIGHT_REMAINING
, GL_DATE_CLOSED
, IN_COLLECTION
, LAST_UPDATE_LOGIN
, PROMISE_AMOUNT_LAST
, PROMISE_DATE_LAST
, RECEIPT_CONFIRMED_FLAG
, RECEIVABLES_CHARGES_CHARGED
, RECEIVABLES_CHARGES_REMAINING
, REVERSED_CASH_RECEIPT_ID
, SELECTED_FOR_RECEIPT_BATCH_ID
, TAX_ORIGINAL
, TAX_REMAINING
, TERMS_SEQUENCE_NUMBER
, TERM_ID
, TRX_DATE
, TRX_NUMBER
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DISPUTE_DATE
, LAST_CHARGE_DATE
, SECOND_LAST_CHARGE_DATE
, DOC_SEQUENCE_VALUE
, RECEIPT_METHOD_ID
, USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PURCHASE_ORDER
, DEFAULT_USSGL_TRANSACTION_CODE
, DEFAULT_USSGL_TRX_CODE_CONTEXT
, INTERFACE_HEADER_ATTRIBUTE1
, INTERFACE_HEADER_ATTRIBUTE2
, INTERFACE_HEADER_ATTRIBUTE3
, INTERFACE_HEADER_ATTRIBUTE4
, INTERFACE_HEADER_ATTRIBUTE5
, INTERFACE_HEADER_ATTRIBUTE6
, INTERFACE_HEADER_ATTRIBUTE7
, INTERFACE_HEADER_ATTRIBUTE8
, INTERFACE_HEADER_ATTRIBUTE9
, INTERFACE_HEADER_ATTRIBUTE10
, INTERFACE_HEADER_ATTRIBUTE11
, INTERFACE_HEADER_ATTRIBUTE12
, INTERFACE_HEADER_ATTRIBUTE13
, INTERFACE_HEADER_ATTRIBUTE14
, INTERFACE_HEADER_ATTRIBUTE15
, INTERFACE_HEADER_CONTEXT
FROM APPS.AR_PAYMENT_SCHEDULES_FLEX_VIEW;
APPS.AR_PAYMENT_SCHEDULES_FLEX_VIEW is not referenced by any database object
|
|
|