[Home] [Help] [Dependency Information]
Object Name: | FII_AR_TRANSACTIONS_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_TRANSACTIONS_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_TRANSACTIONS_F_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CUSTOMER_TRX_ID |
FII_AR_TRANSACTIONS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TIME_ID |
FII_AR_TRANSACTIONS_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BILL_TO_CUSTOMER_ID
BILL_TO_SITE_USE_ID |
FII_AR_TRANSACTIONS_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUSTOMER_TRX_ID
FILTER_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Transaction identifier |
ORG_ID | NUMBER | (15) | Organization identifier | |
TIME_ID | NUMBER | (15) | Yes | Time identifier |
TRX_DATE | DATE | Yes | Transaction date | |
GL_DATE | DATE | Yes | GL date | |
CLASS | VARCHAR2 | (20) | Yes | Transaction class (INV, DM, CB, DEP, BR, CM) |
AMOUNT_DUE_ORIGINAL_TRX | NUMBER | Original amount due of the transaction in the transactional currency | ||
AMOUNT_DUE_ORIGINAL_FUNC | NUMBER | Original amount due of the transaction in the functional currency | ||
AMOUNT_DUE_ORIGINAL_PRIM | NUMBER | Original amount due of the transaction in the DBI primary currency | ||
AMOUNT_DUE_ORIGINAL_SEC | NUMBER | Original amount due of the transaction in the DBI secondary currency | ||
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Yes | Bill to customer account identifier |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Yes | Bill to customer site use identifier |
TRANSACTION_NUMBER | VARCHAR2 | (20) | Yes | Transaction number |
CUST_TRX_TYPE_ID | NUMBER | (15) | Yes | Transaction type identifier |
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) | |
FILTER_DATE | DATE | Yes | Filter date is equal to either trx_date or gl_date | |
ORDER_REF_NUMBER | VARCHAR2 | (30) | Order number of transaction | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Lookup code for the currency of the invoice |
EXCHANGE_RATE | NUMBER | The currency conversion rate to convert amounts from transactional currency to functional currency | ||
EXCHANGE_DATE | DATE | The currency conversion date to convert amounts from transactional currency to functional currency | ||
INITIAL_CUSTOMER_TRX_ID | NUMBER | (15) | Deposit transaction identifier if the transaction is applied to a deposit | |
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. | |
USER_ID | NUMBER | (15) | Yes | Transaction creator user identifier |
INV_BA_AMOUNT_FUNC | NUMBER | Original amount due of invoice transactions in the functional currency | ||
INV_BA_AMOUNT_PRIM | NUMBER | Original amount due of invoice transactions in the DBI primary currency | ||
INV_BA_AMOUNT_SEC | NUMBER | Original amount due of invoice transactions in the DBI secondary currency | ||
INV_BA_COUNT | NUMBER | Number of invoices | ||
DM_BA_AMOUNT_FUNC | NUMBER | Original amount due of debit memo transactions in the functional currency | ||
DM_BA_AMOUNT_PRIM | NUMBER | Original amount due of debit memo transactions in the DBI primary currency | ||
DM_BA_AMOUNT_SEC | NUMBER | Original amount due of debit memo transactions in the DBI secondary currency | ||
DM_BA_COUNT | NUMBER | Number of debit memos | ||
CB_BA_AMOUNT_FUNC | NUMBER | Original amount due of chargeback transactions in the functional currency | ||
CB_BA_AMOUNT_PRIM | NUMBER | Original amount due of chargeback transactions in the DBI primary currency | ||
CB_BA_AMOUNT_SEC | NUMBER | Original amount due of chargeback transactions in the DBI secondary currency | ||
CB_BA_COUNT | NUMBER | Number of chargebacks | ||
BR_BA_AMOUNT_FUNC | NUMBER | Original amount due of bills receivable transactions in the functional currency | ||
BR_BA_AMOUNT_PRIM | NUMBER | Original amount due of bills receivable in the DBI primary currency | ||
BR_BA_AMOUNT_SEC | NUMBER | Original amount due of bills receivable in the DBI secondary currency | ||
BR_BA_COUNT | NUMBER | Number of bills receivable | ||
DEP_BA_AMOUNT_FUNC | NUMBER | Original amount due of deposit transactions in the functional currency | ||
DEP_BA_AMOUNT_PRIM | NUMBER | Original amount due of deposit transactions in the DBI primary currency | ||
DEP_BA_AMOUNT_SEC | NUMBER | Original amount due of deposit transactions in the DBI secondary currency | ||
DEP_BA_COUNT | NUMBER | Number of deposits | ||
CM_BA_AMOUNT_FUNC | NUMBER | Original amount due of credit memo transactions in the functional currency | ||
CM_BA_AMOUNT_PRIM | NUMBER | Original amount due of credit memo transactions in the DBI primary currency | ||
CM_BA_AMOUNT_SEC | NUMBER | Original amount due of credit memo transactions in the DBI secondary currency | ||
CM_BA_COUNT | NUMBER | Number of credit memos | ||
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 | |
AR_CREATION_DATE | DATE | Yes | Creation date in AR source table |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, ORG_ID
, TIME_ID
, TRX_DATE
, GL_DATE
, CLASS
, AMOUNT_DUE_ORIGINAL_TRX
, AMOUNT_DUE_ORIGINAL_FUNC
, AMOUNT_DUE_ORIGINAL_PRIM
, AMOUNT_DUE_ORIGINAL_SEC
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, TRANSACTION_NUMBER
, CUST_TRX_TYPE_ID
, TERM_ID
, BATCH_SOURCE_ID
, FILTER_DATE
, ORDER_REF_NUMBER
, INVOICE_CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_DATE
, INITIAL_CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_ID
, USER_ID
, INV_BA_AMOUNT_FUNC
, INV_BA_AMOUNT_PRIM
, INV_BA_AMOUNT_SEC
, INV_BA_COUNT
, DM_BA_AMOUNT_FUNC
, DM_BA_AMOUNT_PRIM
, DM_BA_AMOUNT_SEC
, DM_BA_COUNT
, CB_BA_AMOUNT_FUNC
, CB_BA_AMOUNT_PRIM
, CB_BA_AMOUNT_SEC
, CB_BA_COUNT
, BR_BA_AMOUNT_FUNC
, BR_BA_AMOUNT_PRIM
, BR_BA_AMOUNT_SEC
, BR_BA_COUNT
, DEP_BA_AMOUNT_FUNC
, DEP_BA_AMOUNT_PRIM
, DEP_BA_AMOUNT_SEC
, DEP_BA_COUNT
, CM_BA_AMOUNT_FUNC
, CM_BA_AMOUNT_PRIM
, CM_BA_AMOUNT_SEC
, CM_BA_COUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, AR_CREATION_DATE
FROM FII.FII_AR_TRANSACTIONS_F;
FII.FII_AR_TRANSACTIONS_F does not reference any database object
FII.FII_AR_TRANSACTIONS_F is referenced by following:
|
|
|