DBA Data[Home] [Help] [Dependency Information]

TABLE: GMF.SY_SOFT_DTL

Object Details
Object Name: SY_SOFT_DTL
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.SY_SOFT_DTL
Subobject Name:
Status: VALID


Defines tables and their attributes for use in supporting a given Third-Party integration.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SY_SOFT_DTL_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSY_SOFT_DTL_ID
SY_SOFT_DTL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCO_CODE
ColumnSOFTWARE_CODE
ColumnTABLE_CODE
Columns
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
Query Text

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;

Dependencies

[top of page]

GMF.SY_SOFT_DTL does not reference any database object

GMF.SY_SOFT_DTL is referenced by following:

SchemaGMF
ViewSY_SOFT_DTL#