[Home] [Help] [Dependency Information]
Object Name: | CS_SR_SERVICE_REQUEST_I_T |
---|---|
Object Type: | TYPE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
REQUEST_DATE | DATE |
|
|
TYPE_ID | NUMBER |
|
|
STATUS_ID | NUMBER |
|
|
SEVERITY_ID | NUMBER |
|
|
URGENCY_ID | NUMBER |
|
|
CLOSED_DATE | DATE |
|
|
OWNER_ID | NUMBER |
|
|
OWNER_GROUP_ID | NUMBER |
|
|
PUBLISH_FLAG | VARCHAR2 | (1) | |
SUMMARY | VARCHAR2 | (80) | |
CALLER_TYPE | VARCHAR2 | (30) | |
CUSTOMER_ID | NUMBER |
|
|
CUSTOMER_NUMBER | VARCHAR2 | (30) | |
EMPLOYEE_ID | NUMBER |
|
|
VERIFY_CP_FLAG | VARCHAR2 | (1) | |
CUSTOMER_PRODUCT_ID | NUMBER |
|
|
PLATFORM_ID | NUMBER |
|
|
PLATFORM_VERSION | VARCHAR2 | (250) | |
DB_VERSION | VARCHAR2 | (250) | |
PLATFORM_VERSION_ID | NUMBER |
|
|
CP_COMPONENT_ID | NUMBER |
|
|
CP_COMPONENT_VERSION_ID | NUMBER |
|
|
CP_SUBCOMPONENT_ID | NUMBER |
|
|
CP_SUBCOMPONENT_VERSION_ID | NUMBER |
|
|
LANGUAGE_ID | NUMBER |
|
|
LANGUAGE | VARCHAR2 | (4) | |
INVENTORY_ITEM_ID | NUMBER |
|
|
INVENTORY_ORG_ID | NUMBER |
|
|
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | |
ORIGINAL_ORDER_NUMBER | NUMBER |
|
|
PURCHASE_ORDER_NUM | VARCHAR2 | (50) | |
PROBLEM_CODE | VARCHAR2 | (50) | |
EXP_RESOLUTION_DATE | DATE |
|
|
INSTALL_SITE_USE_ID | NUMBER |
|
|
REQUEST_ATTRIBUTE_1 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_2 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_3 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_4 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_5 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_6 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_7 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_8 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_9 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_10 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_11 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_12 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_13 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_14 | VARCHAR2 | (150) | |
REQUEST_ATTRIBUTE_15 | VARCHAR2 | (150) | |
REQUEST_CONTEXT | VARCHAR2 | (30) | |
BILL_TO_SITE_USE_ID | NUMBER |
|
|
BILL_TO_CONTACT_ID | NUMBER |
|
|
SHIP_TO_SITE_USE_ID | NUMBER |
|
|
SHIP_TO_CONTACT_ID | NUMBER |
|
|
RESOLUTION_CODE | VARCHAR2 | (50) | |
ACT_RESOLUTION_DATE | DATE |
|
|
PUBLIC_COMMENT_FLAG | VARCHAR2 | (1) | |
PARENT_INTERACTION_ID | NUMBER |
|
|
CONTRACT_SERVICE_ID | NUMBER |
|
|
CONTRACT_ID | NUMBER |
|
|
PROJECT_NUMBER | VARCHAR2 | (120) | |
QA_COLLECTION_PLAN_ID | NUMBER |
|
|
ACCOUNT_ID | NUMBER |
|
|
RESOURCE_TYPE | VARCHAR2 | (30) | |
RESOURCE_SUBTYPE_ID | NUMBER |
|
|
CUST_PO_NUMBER | VARCHAR2 | (50) | |
CUST_TICKET_NUMBER | VARCHAR2 | (50) | |
SR_CREATION_CHANNEL | VARCHAR2 | (50) | |
OBLIGATION_DATE | DATE |
|
|
TIME_ZONE_ID | NUMBER |
|
|
TIME_DIFFERENCE | NUMBER |
|
|
SITE_ID | NUMBER |
|
|
CUSTOMER_SITE_ID | NUMBER |
|
|
TERRITORY_ID | NUMBER |
|
|
INITIALIZE_FLAG | VARCHAR2 | (1) | |
CP_REVISION_ID | NUMBER |
|
|
INV_ITEM_REVISION | VARCHAR2 | (3) | |
INV_COMPONENT_ID | NUMBER |
|
|
INV_COMPONENT_VERSION | VARCHAR2 | (3) | |
INV_SUBCOMPONENT_ID | NUMBER |
|
|
INV_SUBCOMPONENT_VERSION | VARCHAR2 | (3) | |
TIER | VARCHAR2 | (250) | |
TIER_VERSION | VARCHAR2 | (250) | |
OPERATING_SYSTEM | VARCHAR2 | (250) | |
OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | |
DATABASE | VARCHAR2 | (250) | |
CUST_PREF_LANG_ID | NUMBER |
|
|
CATEGORY_ID | NUMBER |
|
|
GROUP_TYPE | VARCHAR2 | (30) | |
GROUP_TERRITORY_ID | NUMBER |
|
|
INV_PLATFORM_ORG_ID | NUMBER |
|
|
PRODUCT_REVISION | VARCHAR2 | (240) | |
COMPONENT_VERSION | VARCHAR2 | (3) | |
SUBCOMPONENT_VERSION | VARCHAR2 | (3) | |
COMM_PREF_CODE | VARCHAR2 | (30) | |
LAST_UPDATE_DATE | DATE |
|
|
CREATION_DATE | DATE |
|
|
CREATED_BY | NUMBER |
|
|
LAST_UPDATED_BY | NUMBER |
|
|
LAST_UPDATE_LOGIN | NUMBER |
|
|
OWNER_ASSIGNED_FLAG | VARCHAR2 | (3) | |
OWNER_ASSIGNED_TIME | DATE |
|
|
LAST_UPDATE_CHANNEL | VARCHAR2 | (10) | |
CUST_PREF_LANG_CODE | VARCHAR2 | (4) |
|
|
|