[Home] [Help] [Dependency Information]
Object Name: | IBY_TANGIBLE |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TANGIBLE |
Subobject Name: | |
Status: | VALID |
IBY_TANGIBLE stores information about the bills or orders.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TANGIBLE_MTANGIBLEID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MTANGIBLEID |
IBY_TANGIBLE_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_OBJECT_TYPE_CODE |
IBY_TANGIBLE_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_OBJECT_ID |
IBY_TANGIBLE_REFINFO_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFINFO |
IBY_TANGIBLE_TANGIBLEID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TANGIBLEID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MTANGIBLEID | NUMBER | (15) | Yes | system generated ID, this id is exposed to Electronic application unlike others |
TANGIBLEID | VARCHAR2 | (80) | Yes | bill or orderid |
AMOUNT | NUMBER | Yes | Amount | |
CURRENCYNAMECODE | VARCHAR2 | (15) | Yes | code for currency name such USD |
ACCTNO | VARCHAR2 | (80) | customer account number with the biller or merchant | |
REFINFO | VARCHAR2 | (80) | any reference information passed by the Electronic Commerce Application | |
MEMO | VARCHAR2 | (80) | memo for the payment | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | This column is used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
SOURCE_OBJECT_TYPE_CODE | VARCHAR2 | (30) | Type of the originating EC App quote or order. Foreign Key to JTF_OBJECTS_B | |
SOURCE_OBJECT_ID | NUMBER | (15) | Primary Key of the source object | |
ISSUEDATE | DATE | Date the Bills Receivable or Receipt was issued. Added for AR-BR integration | ||
ORDER_MEDIUM | VARCHAR2 | (30) | Order medium/channel from lookup type IBY_ORDER_MEDIUM_TYPE | |
EFT_AUTH_METHOD | VARCHAR2 | (30) | Method used in obtaining authorization for performing EFT debits against the payer's bank account |
Cut, paste (and edit) the following text to query this object:
SELECT MTANGIBLEID
, TANGIBLEID
, AMOUNT
, CURRENCYNAMECODE
, ACCTNO
, REFINFO
, MEMO
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, ISSUEDATE
, ORDER_MEDIUM
, EFT_AUTH_METHOD
FROM IBY.IBY_TANGIBLE;
IBY.IBY_TANGIBLE does not reference any database object
IBY.IBY_TANGIBLE is referenced by following:
|
|
|