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

TABLE: FII.FII_AR_AGING_RECEIVABLES

Object Details
Object Name: FII_AR_AGING_RECEIVABLES
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AR_AGING_RECEIVABLES
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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AR_AGING_RECEIVABLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_ID
FII_AR_AGING_RECEIVABLES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_TO_CUSTOMER_ID
ColumnBILL_TO_SITE_USE_ID
FII_AR_AGING_RECEIVABLES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_ID_DATE
FII_AR_AGING_RECEIVABLES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER (15) Yes Time identifier
EVENT_DATE DATE
Yes Date that corresponds to the time_id
NEXT_AGING_DATE DATE

Next date to age the current record
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
CUSTOMER_TRX_ID NUMBER (15)
Transaction identifier
PAYMENT_SCHEDULE_ID NUMBER (15)
Payment schedule identifier
ADJUSTMENT_ID NUMBER (15)
Adjustment identifier
RECEIVABLE_APPLICATION_ID NUMBER (15)
Receipt or credit memo identifier
TRX_DATE DATE
Yes Transaction date
DUE_DATE DATE
Yes Due date
CURRENT_BUCKET_1_AMOUNT_TRX NUMBER

Current open receivables amount_trx in the first bucket in the transactional currency
CURRENT_BUCKET_1_AMOUNT_FUNC NUMBER

Current open receivables amount_trx in the first bucket in the functional currency
CURRENT_BUCKET_1_AMOUNT_PRIM NUMBER

Current open receivables amount_trx in the first bucket in the DBI primary global currency
CURRENT_BUCKET_1_AMOUNT_SEC NUMBER

Current open receivables amount_trx in the first bucket in the DBI secondary global currency
CURRENT_BUCKET_1_COUNT NUMBER

Number of current open transactions in the first bucket
CURRENT_BUCKET_2_AMOUNT_TRX NUMBER

Current open receivables amount_trx in the second bucket in the transactional currency
CURRENT_BUCKET_2_AMOUNT_FUNC NUMBER

Current open receivables amount_trx in the second bucket in the functional currency
CURRENT_BUCKET_2_AMOUNT_PRIM NUMBER

Current open receivables amount_trx in the second bucket in the DBI primary global currency
CURRENT_BUCKET_2_AMOUNT_SEC NUMBER

Current open receivables amount_trx in the second bucket in the DBI secondary global currency
CURRENT_BUCKET_2_COUNT NUMBER

Number of current open transactions in the second bucket
CURRENT_BUCKET_3_AMOUNT_TRX NUMBER

Current open receivables amount_trx in the third bucket in the transactional currency
CURRENT_BUCKET_3_AMOUNT_FUNC NUMBER

Current open receivables amount_trx in the third bucket in the functional currency
CURRENT_BUCKET_3_AMOUNT_PRIM NUMBER

Current open receivables amount_trx in the third bucket in the DBI primary global currency
CURRENT_BUCKET_3_AMOUNT_SEC NUMBER

Current open receivables amount_trx in the third bucket in the DBI secondary global currency
CURRENT_BUCKET_3_COUNT NUMBER

Number of current open transactions in the third bucket
PAST_DUE_BUCKET_1_AMOUNT_TRX NUMBER

Past due open receivables amount_trx in the first bucket in the transactional currency
PAST_DUE_BUCKET_1_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the first bucket in the functional currency
PAST_DUE_BUCKET_1_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the first bucket in the DBI primary global currency
PAST_DUE_BUCKET_1_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the first bucket in the DBI secondary global currency
PAST_DUE_BUCKET_1_COUNT NUMBER

Number of past due open transactions in the first bucket
PAST_DUE_BUCKET_2_AMOUNT_TRX NUMBER

Past due open receivables amount_trx in the second bucket in the transactional currency
PAST_DUE_BUCKET_2_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the second bucket in the functional currency
PAST_DUE_BUCKET_2_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the second bucket in the DBI primary global currency
PAST_DUE_BUCKET_2_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the second bucket in the DBI secondary global currency
PAST_DUE_BUCKET_2_COUNT NUMBER

Number of past due open transactions in the second bucket
PAST_DUE_BUCKET_3_AMOUNT_TRX NUMBER

Past Due open receivables amount_trx in the third bucket in the transactional currency
PAST_DUE_BUCKET_3_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the third bucket in the functional currency
PAST_DUE_BUCKET_3_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the third bucket in the DBI primary global currency
PAST_DUE_BUCKET_3_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the third bucket in the DBI secondary global currency
PAST_DUE_BUCKET_3_COUNT NUMBER

Number of past due open transactions in the third bucket
PAST_DUE_BUCKET_4_AMOUNT_TRX NUMBER

Past due open receivables amount_trx in the fourth bucket in the transactional currency
PAST_DUE_BUCKET_4_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the fourth bucket in the functional currency
PAST_DUE_BUCKET_4_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the fourth bucket in the DBI primary global currency
PAST_DUE_BUCKET_4_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the fourth bucket in the DBI secondary global currency
PAST_DUE_BUCKET_4_COUNT NUMBER

Number of past due open transactions in the fourth bucket
PAST_DUE_BUCKET_5_AMOUNT_TRX NUMBER

Past due open receivables amount_trx in the fifth bucket in the transactional currency
PAST_DUE_BUCKET_5_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the fifth bucket in the functional currency
PAST_DUE_BUCKET_5_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the fifth bucket in the DBI primary global currency
PAST_DUE_BUCKET_5_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the fifth bucket in the DBI secondary global currency
PAST_DUE_BUCKET_5_COUNT NUMBER

Number of past due open transactions in the fifth bucket
PAST_DUE_BUCKET_6_AMOUNT_TRX NUMBER

Past due open receivables amount_trx in the sixth bucket in the transactional currency
PAST_DUE_BUCKET_6_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the sixth bucket in the functional currency
PAST_DUE_BUCKET_6_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the sixth bucket in the DBI primary global currency
PAST_DUE_BUCKET_6_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the sixth bucket in the DBI secondary global currency
PAST_DUE_BUCKET_6_COUNT NUMBER

Number of past due open transactions in the sixth bucket
PAST_DUE_BUCKET_7_AMOUNT_TRX NUMBER

Past due open receivables amount_trx in the seventh bucket in the transactional currency
PAST_DUE_BUCKET_7_AMOUNT_FUNC NUMBER

Past due open receivables amount_trx in the seventh bucket in the functional currency
PAST_DUE_BUCKET_7_AMOUNT_PRIM NUMBER

Past due open receivables amount_trx in the seventh bucket in the DBI primary global currency
PAST_DUE_BUCKET_7_AMOUNT_SEC NUMBER

Past due open receivables amount_trx in the seventh bucket in the DBI secondary global currency
PAST_DUE_BUCKET_7_COUNT NUMBER

Number of past due open transactions in the seventh bucket
TOTAL_OPEN_COUNT NUMBER

Total number of open transactions
UNAGED_AMOUNT_TRX NUMBER

This column stores an amount (in transactional currency) that does not get aged for the purpose of calculating one or more of the following: billing activity, billed amount, on-account credit, or unapplied deposit
UNAGED_AMOUNT_FUNC NUMBER

This column stores an amount (in functional currency) that does not get aged for the purpose of calculating one or more of the following: billing activity, billed amount, on-account credit, or unapplied deposit
UNAGED_AMOUNT_PRIM NUMBER

This column stores an amount (in primary global currency) that does not get aged for the purpose of calculating one or more of the following: billing activity, billed amount, on-account credit, or unapplied deposit
UNAGED_AMOUNT_SEC NUMBER

This column stores an amount (in secondary global currency) that does not get aged for the purpose of calculating one or more of the following: billing activity, billed amount, on-account credit, or unapplied deposit
CLASS VARCHAR2 (20)
Transaction class (INV, DM, CB, DEP, BR)
BILLING_ACTIVITY_FLAG VARCHAR2 (1)
This flag is set to Y in case the unaged_amount_trx column is used for the billing activity calculation.
BILLED_AMOUNT_FLAG VARCHAR2 (1)
This flag is set to Y in case the unaged_amount_trx column is used for the billed amount calculation.
ON_ACCOUNT_CREDIT_FLAG VARCHAR2 (1)
This flag is set to Y in case the unaged_amount_trx column is used for the on-account credit calculation.
UNAPPLIED_DEPOSIT_FLAG VARCHAR2 (1)
This flag is set to Y in case the unaged_amount_trx column is used for the unapplied deposit calculation.
ACTION VARCHAR2 (30)
This column stores either one of the following values to identify the source of the record: Transaction, Application or Adjustment.
AGING_FLAG VARCHAR2 (1)
This flag is set to Y if the record is an aging record and to N if it is a non-aging record.
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
APPL_TRX_DATE DATE

Equals to: trx_date in case action=''Transaction'', apply_date in case action = ''Application'' or ''Adjustment'''
CURRENT_OPEN_COUNT NUMBER (15)
Total number of current open transactions
PAST_DUE_COUNT NUMBER (15)
Total number of past due open transactions
BILLING_ACTIVITY_COUNT NUMBER

This is the number of billing activity transaction
TIME_ID_DATE DATE
Yes Date that corresponds to time_id
ON_ACCT_CREDIT_AMOUNT_TRX NUMBER

On-Account Credit Amount in Transactional Currency
ON_ACCT_CREDIT_AMOUNT_FUNC NUMBER

On-Account Credit Amount in Functional Currency
ON_ACCT_CREDIT_AMOUNT_PRIM NUMBER

On-Account Credit Amount in Primary Currency
ON_ACCT_CREDIT_AMOUNT_SEC NUMBER

On-Account Credit Amount in Secondary Currency
Query Text

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


SELECT TIME_ID
,      EVENT_DATE
,      NEXT_AGING_DATE
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      ORG_ID
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      ADJUSTMENT_ID
,      RECEIVABLE_APPLICATION_ID
,      TRX_DATE
,      DUE_DATE
,      CURRENT_BUCKET_1_AMOUNT_TRX
,      CURRENT_BUCKET_1_AMOUNT_FUNC
,      CURRENT_BUCKET_1_AMOUNT_PRIM
,      CURRENT_BUCKET_1_AMOUNT_SEC
,      CURRENT_BUCKET_1_COUNT
,      CURRENT_BUCKET_2_AMOUNT_TRX
,      CURRENT_BUCKET_2_AMOUNT_FUNC
,      CURRENT_BUCKET_2_AMOUNT_PRIM
,      CURRENT_BUCKET_2_AMOUNT_SEC
,      CURRENT_BUCKET_2_COUNT
,      CURRENT_BUCKET_3_AMOUNT_TRX
,      CURRENT_BUCKET_3_AMOUNT_FUNC
,      CURRENT_BUCKET_3_AMOUNT_PRIM
,      CURRENT_BUCKET_3_AMOUNT_SEC
,      CURRENT_BUCKET_3_COUNT
,      PAST_DUE_BUCKET_1_AMOUNT_TRX
,      PAST_DUE_BUCKET_1_AMOUNT_FUNC
,      PAST_DUE_BUCKET_1_AMOUNT_PRIM
,      PAST_DUE_BUCKET_1_AMOUNT_SEC
,      PAST_DUE_BUCKET_1_COUNT
,      PAST_DUE_BUCKET_2_AMOUNT_TRX
,      PAST_DUE_BUCKET_2_AMOUNT_FUNC
,      PAST_DUE_BUCKET_2_AMOUNT_PRIM
,      PAST_DUE_BUCKET_2_AMOUNT_SEC
,      PAST_DUE_BUCKET_2_COUNT
,      PAST_DUE_BUCKET_3_AMOUNT_TRX
,      PAST_DUE_BUCKET_3_AMOUNT_FUNC
,      PAST_DUE_BUCKET_3_AMOUNT_PRIM
,      PAST_DUE_BUCKET_3_AMOUNT_SEC
,      PAST_DUE_BUCKET_3_COUNT
,      PAST_DUE_BUCKET_4_AMOUNT_TRX
,      PAST_DUE_BUCKET_4_AMOUNT_FUNC
,      PAST_DUE_BUCKET_4_AMOUNT_PRIM
,      PAST_DUE_BUCKET_4_AMOUNT_SEC
,      PAST_DUE_BUCKET_4_COUNT
,      PAST_DUE_BUCKET_5_AMOUNT_TRX
,      PAST_DUE_BUCKET_5_AMOUNT_FUNC
,      PAST_DUE_BUCKET_5_AMOUNT_PRIM
,      PAST_DUE_BUCKET_5_AMOUNT_SEC
,      PAST_DUE_BUCKET_5_COUNT
,      PAST_DUE_BUCKET_6_AMOUNT_TRX
,      PAST_DUE_BUCKET_6_AMOUNT_FUNC
,      PAST_DUE_BUCKET_6_AMOUNT_PRIM
,      PAST_DUE_BUCKET_6_AMOUNT_SEC
,      PAST_DUE_BUCKET_6_COUNT
,      PAST_DUE_BUCKET_7_AMOUNT_TRX
,      PAST_DUE_BUCKET_7_AMOUNT_FUNC
,      PAST_DUE_BUCKET_7_AMOUNT_PRIM
,      PAST_DUE_BUCKET_7_AMOUNT_SEC
,      PAST_DUE_BUCKET_7_COUNT
,      TOTAL_OPEN_COUNT
,      UNAGED_AMOUNT_TRX
,      UNAGED_AMOUNT_FUNC
,      UNAGED_AMOUNT_PRIM
,      UNAGED_AMOUNT_SEC
,      CLASS
,      BILLING_ACTIVITY_FLAG
,      BILLED_AMOUNT_FLAG
,      ON_ACCOUNT_CREDIT_FLAG
,      UNAPPLIED_DEPOSIT_FLAG
,      ACTION
,      AGING_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      APPL_TRX_DATE
,      CURRENT_OPEN_COUNT
,      PAST_DUE_COUNT
,      BILLING_ACTIVITY_COUNT
,      TIME_ID_DATE
,      ON_ACCT_CREDIT_AMOUNT_TRX
,      ON_ACCT_CREDIT_AMOUNT_FUNC
,      ON_ACCT_CREDIT_AMOUNT_PRIM
,      ON_ACCT_CREDIT_AMOUNT_SEC
FROM FII.FII_AR_AGING_RECEIVABLES;

Dependencies

[top of page]

FII.FII_AR_AGING_RECEIVABLES does not reference any database object

FII.FII_AR_AGING_RECEIVABLES is referenced by following:

SchemaAPPS
SynonymFII_AR_AGING_RECEIVABLES
Materialized ViewFII_AR_NET_REC_INTR_MV