eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_AR_PMT_SCHEDULES_F

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

FII.FII_AR_PMT_SCHEDULES_F does not reference any database object

FII.FII_AR_PMT_SCHEDULES_F is referenced by following:

APPS: FII_AR_PMT_SCHEDULES_F