This table contains description for Snapshots
Module:
SNAPSHOT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SNAPSHOT_ID | NUMBER | 38 | 0 | True | System generated unique Identifier for Sales Stage | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System generated key | ||||
| LAST_UPDATE_LOGIN | VARCHAR2 | 64 | Indicates the session login associated to the user who last updated the row | ||||
| LAST_UPDATED_BY | VARCHAR2 | 128 | Indicates the user who last updated the row | ||||
| PERIOD_END_FLAG | VARCHAR2 | 16 | Flag to indicate if the Period has ended | ||||
| PURGE_DATE | DATE | Data Purge Date | |||||
| QUARTER_END_FLAG | VARCHAR2 | 16 | Flag to indicate if the Quarter has ended | ||||
| SNAPSHOT_DATE | DATE | Date when the snapshot was generated | |||||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database i.e. a different mobile database or the server | |||||
| YEAR_END_FLAG | VARCHAR2 | 16 | Flag to indicate if the Year has ended | ||||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time of the last update of the row. |
Copyright © 2019, 2025, Oracle and/or its affiliates.