[Home] [Help] [Dependency Information]
Object Name: | FII_AR_PMT_SCHEDULES_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_PMT_SCHEDULES_F |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_AR_PMT_SCHEDULES_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FILTER_DATE
PAYMENT_SCHEDULE_ID BILL_TO_CUSTOMER_ID CLASS ORG_ID TERM_ID CUST_TRX_TYPE_ID |
FII_AR_PMT_SCHEDULES_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUSTOMER_TRX_ID
TERM_ID TERMS_SEQUENCE_NUMBER |
FII_AR_PMT_SCHEDULES_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PAYMENT_SCHEDULE_ID
CUSTOMER_TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_SCHEDULE_ID | NUMBER | (15) | Yes | Payment schedule identifier |
TIME_ID | NUMBER | (15) | Yes | Time identifier |
CLASS | VARCHAR2 | (20) | Yes | Transaction class |
AMOUNT_DUE_ORIGINAL_TRX | NUMBER | Original due amount of the transaction | ||
AMOUNT_DUE_ORIGINAL_FUNC | NUMBER | Original due amount of the transaction in the functional currency | ||
AMOUNT_DUE_ORIGINAL_PRIM | NUMBER | Original due amount of the transaction in the DBI primary currency | ||
AMOUNT_DUE_ORIGINAL_SEC | NUMBER | Original due amount of the transaction in the DBI secondary currency | ||
AMOUNT_DUE_REMAINING_TRX | NUMBER | Balance of the transaction in the transactional currency | ||
AMOUNT_DUE_REMAINING_FUNC | NUMBER | Balance of the transaction in the functional currency | ||
AMOUNT_DUE_REMAINING_PRIM | NUMBER | Balance of the transaction in the DBI primary currency | ||
AMOUNT_DUE_REMAINING_SEC | NUMBER | Balance of the transaction in the DBI secondary currency | ||
TRX_DATE | DATE | Yes | Transaction date | |
GL_DATE | DATE | Yes | GL date | |
FILTER_DATE | DATE | Yes | Filter date is equal to either trx_date or gl_date | |
DUE_DATE | DATE | Yes | Due date | |
STATUS | VARCHAR2 | (30) | Yes | Status of the transaction as either open (OP) or closed (CL) |
CUSTOMER_TRX_ID | NUMBER | (15) | Transaction identifier | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Lookup code for the currency of the invoice |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Bill to customer account identifier | |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill to customer site use identifier | |
ORG_ID | NUMBER | (15) | Organization identifier | |
USER_ID | NUMBER | (15) | Yes | Transaction creator user identifier |
CUST_TRX_TYPE_ID | NUMBER | (15) | Transaction type identifier | |
TRANSACTION_NUMBER | VARCHAR2 | (30) | Transaction number | |
TERM_ID | NUMBER | (15) | Payment term identifier | |
BATCH_SOURCE_ID | NUMBER | (15) | Application source that caused this transaction to get created in AR schema (ra_customer_trx) | |
EARNED_DISCOUNT_AMOUNT_TRX | NUMBER | Earned discount taken in the transactional currency | ||
EARNED_DISCOUNT_AMOUNT_FUNC | NUMBER | Earned discount taken in the functional currency | ||
EARNED_DISCOUNT_AMOUNT_PRIM | NUMBER | Earned discount taken in the DBI primary currency | ||
EARNED_DISCOUNT_AMOUNT_SEC | NUMBER | Earned discount taken in the DBI secondary currency | ||
UNEARNED_DISCOUNT_AMOUNT_TRX | NUMBER | Unearned discount taken in the transactional currency | ||
UNEARNED_DISCOUNT_AMOUNT_FUNC | NUMBER | Unearned discount taken in the functional currency | ||
UNEARNED_DISCOUNT_AMOUNT_PRIM | NUMBER | Unearned discount taken in the DBI primary currency | ||
UNEARNED_DISCOUNT_AMOUNT_SEC | NUMBER | Unearned discount taken in the DBI secondary currency | ||
ADJUSTED_AMOUNT_TRX | NUMBER | Adjusted amount in the transactional currency | ||
ADJUSTED_AMOUNT_FUNC | NUMBER | Adjusted amount in the functional currency | ||
ADJUSTED_AMOUNT_PRIM | NUMBER | Adjusted amount in the DBI primary currency | ||
ADJUSTED_AMOUNT_SEC | NUMBER | Adjusted amount in the DBI secondary currency | ||
DISPUTED_AMOUNT_TRX | NUMBER | Disputed amount in the transactional currency | ||
DISPUTED_AMOUNT_FUNC | NUMBER | Disputed amount in the functional currency | ||
DISPUTED_AMOUNT_PRIM | NUMBER | Disputed amount in the DBI primary currency | ||
DISPUTED_AMOUNT_SEC | NUMBER | Disputed amount in the DBI secondary currency | ||
ORDER_REF_NUMBER | VARCHAR2 | (30) | Order number of transaction | |
ACTUAL_DATE_CLOSED | DATE | Yes | Date on which transaction schedule is fully paid. If not closed, this column is populated with largest date (V7db supports 31-DEC-4712) | |
EXCHANGE_RATE | NUMBER | The currency conversion rate to convert amounts from transactional currency to functional currency | ||
EXCHANGE_DATE | DATE | The exchange rate date used to convert transactional currency amounts to functional currency amounts | ||
PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | Populated for regular credit memos with the identifier of the credited transaction. This identifier is not populated for on-account credit memos that are applied to transactions. | |
CREATION_DATE | DATE | Yes | Standard who columns | |
CREATED_BY | NUMBER | (15) | Yes | Standard who columns |
LAST_UPDATE_DATE | DATE | Yes | Standard who columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who columns |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who columns | |
TERMS_SEQUENCE_NUMBER | NUMBER | (15) | The sequence number given to each installment for multiple payment terms |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_SCHEDULE_ID
, TIME_ID
, CLASS
, AMOUNT_DUE_ORIGINAL_TRX
, AMOUNT_DUE_ORIGINAL_FUNC
, AMOUNT_DUE_ORIGINAL_PRIM
, AMOUNT_DUE_ORIGINAL_SEC
, AMOUNT_DUE_REMAINING_TRX
, AMOUNT_DUE_REMAINING_FUNC
, AMOUNT_DUE_REMAINING_PRIM
, AMOUNT_DUE_REMAINING_SEC
, TRX_DATE
, GL_DATE
, FILTER_DATE
, DUE_DATE
, STATUS
, CUSTOMER_TRX_ID
, INVOICE_CURRENCY_CODE
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, ORG_ID
, USER_ID
, CUST_TRX_TYPE_ID
, TRANSACTION_NUMBER
, TERM_ID
, BATCH_SOURCE_ID
, EARNED_DISCOUNT_AMOUNT_TRX
, EARNED_DISCOUNT_AMOUNT_FUNC
, EARNED_DISCOUNT_AMOUNT_PRIM
, EARNED_DISCOUNT_AMOUNT_SEC
, UNEARNED_DISCOUNT_AMOUNT_TRX
, UNEARNED_DISCOUNT_AMOUNT_FUNC
, UNEARNED_DISCOUNT_AMOUNT_PRIM
, UNEARNED_DISCOUNT_AMOUNT_SEC
, ADJUSTED_AMOUNT_TRX
, ADJUSTED_AMOUNT_FUNC
, ADJUSTED_AMOUNT_PRIM
, ADJUSTED_AMOUNT_SEC
, DISPUTED_AMOUNT_TRX
, DISPUTED_AMOUNT_FUNC
, DISPUTED_AMOUNT_PRIM
, DISPUTED_AMOUNT_SEC
, ORDER_REF_NUMBER
, ACTUAL_DATE_CLOSED
, EXCHANGE_RATE
, EXCHANGE_DATE
, PREVIOUS_CUSTOMER_TRX_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TERMS_SEQUENCE_NUMBER
FROM FII.FII_AR_PMT_SCHEDULES_F;
FII.FII_AR_PMT_SCHEDULES_F does not reference any database object
FII.FII_AR_PMT_SCHEDULES_F is referenced by following:
|
|
|