[Home] [Help] [Dependency Information]
Object Name: | FII_AR_ADJUSTMENTS_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_ADJUSTMENTS_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_ADJUSTMENTS_F_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADJUSTMENT_ID |
FII_AR_ADJUSTMENTS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUSTOMER_TRX_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJUSTMENT_ID | NUMBER | (15) | Yes | Adjustment identifier |
TIME_ID | NUMBER | (15) | Yes | Time identifier |
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 |
ORG_ID | NUMBER | (15) | Organization identifier | |
AMOUNT_TRX | NUMBER | Adjustment amount in the transactional currency | ||
AMOUNT_FUNC | NUMBER | Adjustment amount in the functional currency | ||
AMOUNT_PRIM | NUMBER | Adjustment amount in the DBI primary global currency | ||
AMOUNT_SEC | NUMBER | Adjustment amount in the DBI secondary global currency | ||
APPLY_DATE | DATE | Yes | Date that the adjustment was applied | |
GL_DATE | DATE | Yes | GL date | |
FILTER_DATE | DATE | Yes | Filter date is equal to either apply_date or gl_date | |
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Identifier of the transaction to which this adjustment is applied |
PAYMENT_SCHEDULE_ID | NUMBER | (15) | Yes | Identifier of the payment schedule to which this adjustment is applied |
USER_ID | NUMBER | (15) | Yes | Adjustment creator user identifier |
ADJ_CLASS | VARCHAR2 | (20) | Class of the transaction (BR,CB,DEP) that resulted in this system-created adjustment | |
SUBSEQUENT_TRX_ID | NUMBER | (15) | Transaction identifier of a credit memo which is applied to an invoice that is associated with a deposit | |
BR_CUSTOMER_TRX_ID | NUMBER | (15) | The bills receivable transaction identifier in case adj_class = 'BR' | |
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 ADJUSTMENT_ID
, TIME_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, ORG_ID
, AMOUNT_TRX
, AMOUNT_FUNC
, AMOUNT_PRIM
, AMOUNT_SEC
, APPLY_DATE
, GL_DATE
, FILTER_DATE
, CUSTOMER_TRX_ID
, PAYMENT_SCHEDULE_ID
, USER_ID
, ADJ_CLASS
, SUBSEQUENT_TRX_ID
, BR_CUSTOMER_TRX_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, AR_CREATION_DATE
FROM FII.FII_AR_ADJUSTMENTS_F;
FII.FII_AR_ADJUSTMENTS_F does not reference any database object
FII.FII_AR_ADJUSTMENTS_F is referenced by following:
|
|
|