[Home] [Help] [Dependency Information]
Object Name: | SY_SOFT_DTL |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.SY_SOFT_DTL |
Subobject Name: | |
Status: | VALID |
Defines tables and their attributes for use in supporting a given Third-Party integration.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SY_SOFT_DTL_PK | NORMAL | UNIQUE | APPS_TS_SEED | SY_SOFT_DTL_ID |
SY_SOFT_DTL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
CO_CODE
SOFTWARE_CODE TABLE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SY_SOFT_DTL_ID | NUMBER | (15) | Yes | Surrogate for the row |
TABLE_CODE | VARCHAR2 | (16) | Yes | Database table name that is synchronized |
SOFTWARE_CODE | VARCHAR2 | (8) | Yes | Software Code (as defined in sy_soft_mst.) |
CO_CODE | VARCHAR2 | (4) | Company for which synchronization setup information is specified. A NULL value indicates that it is either a Non-MultiOrg setup or the synchronization is for all companies. A valid company value indicates that it is a Multi-Org setup and the synchronization setup info is for this company. | |
TABLE_NAME | VARCHAR2 | (16) | Yes | Table used as part of interface between OPM and third-party software. |
TABLE_DESC | VARCHAR2 | (70) | Yes | Description of table |
TABLE_CLASS | VARCHAR2 | (16) | Yes | Describes transaction type. Valid values: Master File or Document. |
MONTHLY | VARCHAR2 | (70) | Column to mark frequency of interface execution. Must mark 1 of 5 columns(MONTHLY, WEEKLY, HOURLY, DAILY, MINUTE) with an X. | |
WEEKLY | VARCHAR2 | (70) | Column to mark frequency of interface execution. Must mark 1 of 5(MONTHLY, WEEKLY, HOURLY, DAILY, MINUTE) columns with an X. | |
DAILY | VARCHAR2 | (70) | Column to mark frequency of interface execution. Must mark 1 of 5(MONTHLY, WEEKLY, HOURLY, DAILY, MINUTE) columns with an X. | |
HOURLY | VARCHAR2 | (70) | Column to mark frequency of interface execution. Must mark 1 of 5(MONTHLY, WEEKLY, HOURLY, DAILY, MINUTE) columns with an X. | |
MINUTE | VARCHAR2 | (70) | Column to mark frequency of interface execution. Must mark 1 of 5(MONTHLY, WEEKLY, HOURLY, DAILY, MINUTE) columns with an X. | |
DIRECTION_IND | NUMBER | (5) | Yes | 0=Update is coming into OPM from third-party package;1=Update goes from OPM into third-party package. |
INTERFACE_ID | NUMBER | (15) | Yes | Unique identifier of Synchronization run executed. |
IMPORTED_DATE | DATE | Yes | Date and time of most recent data import into OPM | |
EXPORTED_DATE | DATE | Yes | Date and time of most recent data export out of OPM | |
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 | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TRANS_CNT | NUMBER | (10) | Not currently used | |
SEQ_NO | NUMBER | (5) | Yes | Sequence in which the table names appear on the screen |
SYNC_METHOD | NUMBER | (5) | Yes | Synchronization Method between OPM and Oracle Financials: 1 - Synchronized via Database Triggers; 0 - Synchronized by running GL Synchronization Process. |
CO_SPECIFIC_IND | NUMBER | (10) | Yes | Indicates if the synchronization is company specific (=1) or applies to all companier (=0) |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT SY_SOFT_DTL_ID
, TABLE_CODE
, SOFTWARE_CODE
, CO_CODE
, TABLE_NAME
, TABLE_DESC
, TABLE_CLASS
, MONTHLY
, WEEKLY
, DAILY
, HOURLY
, MINUTE
, DIRECTION_IND
, INTERFACE_ID
, IMPORTED_DATE
, EXPORTED_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, DELETE_MARK
, TRANS_CNT
, SEQ_NO
, SYNC_METHOD
, CO_SPECIFIC_IND
, LAST_UPDATE_LOGIN
FROM GMF.SY_SOFT_DTL;
GMF.SY_SOFT_DTL does not reference any database object
GMF.SY_SOFT_DTL is referenced by following:
|
|
|