[Home] [Help] [Dependency Information]
Object Name: | IBY_FORMATS_TL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FORMATS_TL |
Subobject Name: | |
Status: | VALID |
IBY_FORMATS stores payment file format information, including the name of the XDO template used to create payment files and the extract upon which the template depends.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FORMATS_TL_FORMATCODE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORMAT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMAT_CODE | VARCHAR2 | (30) | Yes | Payment format identifier |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the record's current language |
FORMAT_NAME | VARCHAR2 | (300) | Yes | Payment format name |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT FORMAT_CODE
, LANGUAGE
, SOURCE_LANG
, FORMAT_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_FORMATS_TL;
IBY.IBY_FORMATS_TL does not reference any database object
IBY.IBY_FORMATS_TL is referenced by following:
|
|
|