[Home] [Help] [Dependency Information]
Object Name: | SY_SOFT_DTL# |
---|---|
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SY_SOFT_DTL_ID | NUMBER | (15) | Yes | |
TABLE_CODE | VARCHAR2 | (16) | Yes | |
SOFTWARE_CODE | VARCHAR2 | (8) | Yes | |
CO_CODE | VARCHAR2 | (4) | ||
TABLE_NAME | VARCHAR2 | (16) | Yes | |
TABLE_DESC | VARCHAR2 | (70) | Yes | |
TABLE_CLASS | VARCHAR2 | (16) | Yes | |
MONTHLY | VARCHAR2 | (70) | ||
WEEKLY | VARCHAR2 | (70) | ||
DAILY | VARCHAR2 | (70) | ||
HOURLY | VARCHAR2 | (70) | ||
MINUTE | VARCHAR2 | (70) | ||
DIRECTION_IND | NUMBER | (5) | Yes | |
INTERFACE_ID | NUMBER | (15) | Yes | |
IMPORTED_DATE | DATE | Yes | ||
EXPORTED_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
DELETE_MARK | NUMBER | (5) | Yes | |
TRANS_CNT | NUMBER | (10) | ||
SEQ_NO | NUMBER | (5) | Yes | |
SYNC_METHOD | NUMBER | (5) | Yes | |
CO_SPECIFIC_IND | NUMBER | (10) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
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#;
|
|
|