Module: Service Request Management
VIA_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
VIA_ID | NUMBER | 38 | 0 | True | ID | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | System | ||||
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. | |||||
OBJECT_ID | NUMBER | 38 | 0 | Foreign key that references SVC_SERVICES_REQUESTS (SR_ID) if this channel is for an SR, or SVC_SR_MESSAGES (MESSAGE_ID) if this channel is for an SR MESSAGE. | |||
OBJECT_TYPE_CODE | VARCHAR2 | 32 | Lookup code that indicates whether the OBJECT_ID is for SR or for SR_Message. | DW_CXSR_OBJECT_TYPE_CODE_D_TL | Code | ||
CHANNEL_ID | NUMBER | 38 | 0 | Channel ID | DW_CXSR_CHANNELS_D_TL | CHANNEL_ID | |
ROUTING_CODE | VARCHAR2 | 32 | Lookup code that indicates how the message was routed to the PARTY_VIA_END_POINT. For example, if the message is an email, whether the recipient is a TO, CC, or BCC recipient. | DW_CXSR_ROUTING_CODE_D_TL | Code | ||
DELETED_FLAG | VARCHAR2 | 16 | Indicates whether this via record is logically deleted (Y or N). |
Copyright © 2019, 2023, Oracle and/or its affiliates.