[Home] [Help] [Dependency Information]
Object Name: | FII_AR_DISPUTE_HISTORY_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_DISPUTE_HISTORY_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_DISPUTE_HISTORY_F_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DISPUTE_HISTORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISPUTE_HISTORY_ID | NUMBER | (15) | Yes | Dispute history identifier |
TIME_ID | NUMBER | (15) | Yes | Time identifier |
DISPUTE_AMOUNT_TRX | NUMBER | Disputed amount in the transactional currency | ||
DISPUTE_AMOUNT_FUNC | NUMBER | Disputed amount in the functional currency | ||
DISPUTE_AMOUNT_PRIM | NUMBER | Disputed amount in the DBI primary currency | ||
DISPUTE_AMOUNT_SEC | NUMBER | Disputed amount in the DBI secondary currency | ||
START_DATE | DATE | Yes | Dispute start date | |
END_DATE | DATE | Dispute end date | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Yes | Bill to customer account identifier of the disputed payment schedule |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Yes | Bill to customer site use identifier of the disputed payment schedule |
PAYMENT_SCHEDULE_ID | NUMBER | (15) | Yes | Disputed payment schedule identifier |
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Transaction identifier of the disputed payment schedule |
DUE_DATE | DATE | Yes | Disputed payment schedule due date | |
ACTUAL_DATE_CLOSED | DATE | Yes | The actual date when the payment schedule was closed. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT DISPUTE_HISTORY_ID
, TIME_ID
, DISPUTE_AMOUNT_TRX
, DISPUTE_AMOUNT_FUNC
, DISPUTE_AMOUNT_PRIM
, DISPUTE_AMOUNT_SEC
, START_DATE
, END_DATE
, ORG_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, PAYMENT_SCHEDULE_ID
, CUSTOMER_TRX_ID
, DUE_DATE
, ACTUAL_DATE_CLOSED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FII.FII_AR_DISPUTE_HISTORY_F;
FII.FII_AR_DISPUTE_HISTORY_F does not reference any database object
FII.FII_AR_DISPUTE_HISTORY_F is referenced by following:
|
|
|