Application Object Library - BISM_OBJECT_TYPES | |
---|---|
Column Name | Descritpion |
OBJECT_TYPE_ID | |
OBJECT_TYPE_NAME |
Application Object Library - BISM_DATABASE | |
---|---|
Column Name | Descritpion |
DATABASE_ID |
Application Object Library - BISM_EXPORT | |
---|---|
Column Name | Descritpion |
GROUP_NAME | |
GROUP_ID | |
FILE_NAME | |
TIME_CREATED | |
TEXT | |
BINARYDATA |
Application Object Library - BISM_SUBJECTS | |
---|---|
Column Name | Descritpion |
SUBJECT_ID | |
SUBJECT_NAME | |
SUBJECT_TYPE |
Application Object Library - BISM_PRIVILEGES | |
---|---|
Column Name | Descritpion |
PRIVILEGE_ID | |
PRIVILEGE_NAME | |
DESCRIPTION |
Application Object Library - BISM_PARAMETERS | |
---|---|
Column Name | Descritpion |
NAME | |
VALUE |
Application Object Library - BISM_OBJECTS | |
---|---|
Column Name | Descritpion |
USER_VISIBLE | |
LAST_MODIFIED_BY | |
OBJECT_NAME | |
TITLE | |
APPLICATION | |
DATABASE | |
DESCRIPTION | |
KEYWORDS | |
XML | |
APPLICATION_SUBTYPE1 | |
COMP_SUBTYPE1 | |
OBJECT_TYPE_ID | |
COMP_SUBTYPE2 | |
COMP_SUBTYPE3 | |
EXTENSIBLE_ATTRIBUTES | |
TIME_DATE_LAST_ACCESSED | |
VERSION | |
TIME_DATE_CREATED | |
TIME_DATE_MODIFIED | |
OBJECT_ID | |
CONTAINER_ID | |
FOLDER_ID | |
CREATED_BY |
Application Object Library - BISM_PERMISSIONS | |
---|---|
Column Name | Descritpion |
SUBJECT_ID | |
OBJECT_ID | |
PRIVILEGE |
Application Object Library - BISM_AGGREGATES | |
---|---|
Column Name | Descritpion |
CONTAINER_ID | |
CONTAINEE_ID | |
AGGREGATE_INFO |
Application Object Library - BISM_GROUPS | |
---|---|
Column Name | Descritpion |
USER_ID | |
GROUP_ID |
Application Object Library - BISM_ASSOCIATES | |
---|---|
Column Name | Descritpion |
SOURCE_ID | |
TARGET_ID | |
NAME | |
VALUE |
Application Object Library - AMS_INFMET_ORDER_GT | |
---|---|
Column Name | Descritpion |
PRIMARY_PARTY_ID | |
CONTACT_REL_PARTY_ID | |
LAST_ACTIVATION_DATE | |
ACTIVITY_METRIC_ID | |
SOURCE_CATEGORY | |
OBJECT_ID |
Application Object Library - AMS_INFMET_RESP_GT | |
---|---|
Column Name | Descritpion |
PRIMARY_PARTY_ID | |
CONTACT_REL_PARTY_ID | |
LAST_ACTIVATION_DATE | |
ACTIVITY_METRIC_ID | |
SOURCE_CATEGORY |
Application Object Library - AMS_INFMET_LEAD_GT | |
---|---|
Column Name | Descritpion |
PRIMARY_PARTY_ID | |
CONTACT_REL_PARTY_ID | |
LAST_ACTIVATION_DATE | |
ACTIVITY_METRIC_ID | |
SOURCE_CATEGORY | |
OBJECT_ID |
Application Object Library - FEM_INTG_DIM_HIER_C1_GT | |
---|---|
Column Name | Descritpion |
PARENT_DEPTH_NUM | |
CHILD_LEAF_FLAG | |
PARENT_DISPLAY_CODE | |
PARENT_ID | |
CHILD_DEPTH_NUM | |
CHILD_DISPLAY_CODE | |
CHILD_ID | |
SINGLE_DEPTH_FLAG | |
DISPLAY_ORDER_NUM | |
DIMENSION_GROUP_ID |
Application Object Library - FEM_INTG_DIM_HIER_C2_GT | |
---|---|
Column Name | Descritpion |
PARENT_DEPTH_NUM | |
CHILD_LEAF_FLAG | |
PARENT_DISPLAY_CODE | |
PARENT_ID | |
CHILD_DEPTH_NUM | |
CHILD_DISPLAY_CODE | |
CHILD_ID | |
SINGLE_DEPTH_FLAG | |
DISPLAY_ORDER_NUM | |
DIMENSION_GROUP_ID |
Application Object Library - FEM_INTG_DIM_HIER_C3_GT | |
---|---|
Column Name | Descritpion |
PARENT_DEPTH_NUM | |
CHILD_LEAF_FLAG | |
PARENT_DISPLAY_CODE | |
PARENT_ID | |
CHILD_DEPTH_NUM | |
CHILD_DISPLAY_CODE | |
CHILD_ID | |
SINGLE_DEPTH_FLAG | |
DISPLAY_ORDER_NUM | |
DIMENSION_GROUP_ID |
Application Object Library - BIM_I_ATTR_NAME_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
ID | |
VALUE | |
LANGUAGE |
Application Object Library - BIM_I_BGT_CAB_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00043$ | |
TRANSACTION_CREATE_DATE | |
HOLDBACK_C | |
SYS_NC00040$ | |
TRANSFER_IN | |
TRANSFER_IN_C | |
TRANSFER_OUT | |
TRANSFER_OUT_C | |
ACCRUAL | |
ACCRUAL_C | |
COMMITTED | |
COMMITTED_C | |
PLANNED | |
FUND_ID | |
PLANNED_C | |
SYS_NC00042$ | |
UTILIZED | |
UTILIZED_C | |
ORIGINAL_BUDGET_S | |
ORIGINAL_BUDGET_S_C | |
HOLDBACK_S | |
HOLDBACK_S_C | |
TRANSFER_IN_S | |
TRANSFER_IN_S_C | |
TRANSFER_OUT_S | |
PARENT_FUND_ID | |
TRANSFER_OUT_S_C | |
ACCRUAL_S | |
ACCRUAL_S_C | |
COMMITTED_S | |
COMMITTED_S_C | |
PLANNED_S | |
PLANNED_S_C | |
UTILIZED_S | |
UTILIZED_S_C | |
COUNT_ALL | |
CATEGORY_ID | |
SYS_NC00045$ | |
PARENT_CATEGORY_ID | |
LEAF_NODE_FLAG | |
SYS_NC00041$ | |
ORIGINAL_BUDGET | |
ORIGINAL_BUDGET_C | |
SYS_NC00044$ | |
HOLDBACK |
Application Object Library - BIM_I_BGT_FCT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00043$ | |
TRANSACTION_CREATE_DATE | |
HOLDBACK_C | |
SYS_NC00040$ | |
TRANSFER_IN | |
TRANSFER_IN_C | |
TRANSFER_OUT | |
TRANSFER_OUT_C | |
ACCRUAL | |
ACCRUAL_C | |
COMMITTED | |
COMMITTED_C | |
PLANNED | |
FUND_ID | |
PLANNED_C | |
SYS_NC00042$ | |
UTILIZED | |
UTILIZED_C | |
ORIGINAL_BUDGET_S | |
ORIGINAL_BUDGET_S_C | |
HOLDBACK_S | |
HOLDBACK_S_C | |
TRANSFER_IN_S | |
TRANSFER_IN_S_C | |
TRANSFER_OUT_S | |
FUND_TYPE | |
TRANSFER_OUT_S_C | |
ACCRUAL_S | |
ACCRUAL_S_C | |
COMMITTED_S | |
COMMITTED_S_C | |
PLANNED_S | |
PLANNED_S_C | |
UTILIZED_S | |
UTILIZED_S_C | |
COUNT_ALL | |
PARENT_FUND_ID | |
SYS_NC00045$ | |
CATEGORY_ID | |
LEAF_NODE_FLAG | |
SYS_NC00041$ | |
ORIGINAL_BUDGET | |
ORIGINAL_BUDGET_C | |
SYS_NC00044$ | |
HOLDBACK |
Application Object Library - BIM_I_OBJ_NAME_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
SOURCE_CODE_ID | |
NAME | |
LANGUAGE | |
OBJECT_ID | |
OBJECT_TYPE | |
OBJECT_TYPE_MEAN | |
ACTIVITY_ID | |
CHILD_OBJECT_USAGE |
Application Object Library - BIM_I_LD_HEADER_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
LEAD_ID | |
CHANNEL_CODE | |
SYS_NC00042$ | |
CUST_CATEGORY | |
LEAD_RANK_ID | |
SYS_NC00045$ | |
LEAD_SOURCE | |
LEAD_STATUS | |
SYS_NC00048$ | |
LEAD_REGION | |
LEAD_COUNTRY | |
SYS_NC00061$ | |
QUALIFIED_FLAG | |
SOURCE_CODE_ID | |
SYS_NC00035$ | |
OBJECT_TYPE | |
LEAD_CREATION_DATE | |
OBJECT_ID | |
SYS_NC00038$ | |
SYS_NC00039$ | |
CHILD_OBJECT_TYPE | |
CHILD_OBJECT_ID | |
SYS_NC00051$ | |
OBJECT_REGION | |
OBJECT_COUNTRY | |
SYS_NC00054$ | |
CHILD_OBJECT_REGION | |
CHILD_OBJECT_COUNTRY | |
SYS_NC00057$ | |
LEAD_AMOUNT | |
DUMMY_FR1 | |
SYS_NC00041$ | |
CUSTOMER_FLAG | |
LEAD_TOUCHED_DATE | |
CUSTOMER_ID | |
SYS_NC00044$ | |
LEAD_NAME | |
CLOSE_REASON | |
SYS_NC00047$ | |
ALLC | |
SYS_NC00060$ | |
SYS_NC00063$ | |
SYS_NC00034$ | |
LEAD_CONVERTED_DATE | |
SYS_NC00037$ | |
SYS_NC00052$ | |
SYS_NC00050$ | |
SYS_NC00053$ | |
SYS_NC00056$ | |
SYS_NC00059$ | |
LEAD_DEAD_DATE | |
SYS_NC00040$ | |
SYS_NC00043$ | |
SYS_NC00046$ | |
SYS_NC00049$ | |
SYS_NC00062$ | |
LEAD_CLOSED_DATE | |
SYS_NC00055$ | |
TRANSACTION_CREATE_DATE | |
GROUP_ID | |
SYS_NC00058$ | |
RESOURCE_ID |
Application Object Library - BIM_I_LP_ITEM_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
LEAD_CLOSED_DATE | |
TRANSACTION_CREATE_DATE | |
GROUP_ID | |
RESOURCE_ID | |
CHANNEL_CODE | |
CUST_CATEGORY | |
PRODUCT_CATEGORY_ID | |
ITEM_ID | |
ORGANIZATION_ID | |
LEAD_RANK_ID | |
FROWID | |
LEAD_SOURCE | |
LEAD_STATUS | |
LEAD_REGION | |
LEAD_COUNTRY | |
SOURCE_CODE_ID | |
OBJECT_TYPE | |
OBJECT_ID | |
CHILD_OBJECT_TYPE | |
CHILD_OBJECT_ID | |
OBJECT_REGION | |
SROWID | |
OBJECT_COUNTRY | |
CHILD_OBJECT_REGION | |
CHILD_OBJECT_COUNTRY | |
BUSINESS_UNIT_ID | |
LEAD_AMOUNT | |
QUALIFIED_FLAG | |
CUSTOMER_ID | |
LEAD_NAME | |
CLOSE_REASON | |
LEAD_ID | |
LEAD_LINE_ID | |
LEAD_CREATION_DATE | |
LEAD_TOUCHED_DATE | |
LEAD_CONVERTED_DATE | |
LEAD_DEAD_DATE |
Application Object Library - BIM_SGMT_ACT_H_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
SEGMENT_ID | |
SYS_NC00009$ | |
ACTIVITY_ID | |
SYS_NC00008$ | |
CATEGORY_ID | |
SOURCE_CODE_ID | |
SYS_NC00010$ | |
SCHEDULE_START_DATE | |
SCHEDULE_PURPOSE | |
SYS_NC00012$ | |
COUNT_ALL | |
SYS_NC00011$ |
Application Object Library - BIM_I_ORD_COL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
UMARK | |
CHILD_OBJECT_TYPE | |
SYS_NC00031$ | |
OBJECT_REGION | |
OBJECT_COUNTRY | |
SYS_NC00034$ | |
OBJECT_STATUS | |
ACTIVITY_ID | |
SYS_NC00026$ | |
BOOKED_AMT_F | |
BOOKED_AMT_F_C | |
SYS_NC00029$ | |
INVOICED_AMT_F | |
INVOICED_AMT_F_C | |
SYS_NC00032$ | |
BOOKED_AMT_S | |
TRANSACTION_CREATE_DATE | |
BOOKED_AMT_S_C | |
SYS_NC00035$ | |
SYS_NC00030$ | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
SYS_NC00024$ | |
ALL_C | |
SOURCE_CODE_ID | |
OBJECT_ID | |
SYS_NC00033$ | |
OBJECT_TYPE | |
VBH_CATEGORY_ID | |
SYS_NC00025$ | |
PRIMARY_CATEGORY_ID | |
METRIC_TYPE | |
SYS_NC00028$ | |
CHILD_OBJECT_ID |
Application Object Library - BIM_SGMT_VAL_B_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
BOOKED_AMT_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
BOOKED_COUNT | |
REVENUE | |
REVENUE_C | |
REVENUE_S | |
REVENUE_S_C | |
COUNT_ALL | |
SEGMENT_ID | |
TRANSACTION_CREATE_DATE | |
ACQUIRED_CUSTOMERS | |
TOTAL_CUSTOMERS | |
LOST_CUSTOMERS | |
SEGMENT_SIZE | |
SEGEMENT_SIZE_C | |
BOOKED_AMT |
Application Object Library - BIV_ACT_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | |
SR_CREATION_CHANNEL | |
SYS_NC00025$ | |
FIRST_OPENED_COUNT | |
REOPENED_COUNT | |
SYS_NC00028$ | |
CLOSED_COUNT | |
MV_GROUPING_ID | |
SYS_NC00031$ | |
MV_DAY_ID | |
MV_WEEK_ID | |
SYS_NC00034$ | |
MV_PERIOD_ID | |
MV_ENT_QTR_ID | |
SYS_NC00024$ | |
MV_ENT_YEAR_ID | |
PERIOD_TYPE_ID | |
MV_FIRST_OPENED_COUNT | |
SYS_NC00027$ | |
SYS_NC00026$ | |
MV_REOPENED_COUNT | |
MV_CLOSED_COUNT | |
SYS_NC00030$ | |
MV_COUNT | |
SYS_NC00033$ | |
GRP_ID | |
INCIDENT_TYPE_ID | |
SYS_NC00029$ | |
INCIDENT_SEVERITY_ID | |
VBH_CATEGORY_ID | |
SYS_NC00032$ | |
PRODUCT_ID | |
CUSTOMER_ID | |
SYS_NC00035$ | |
OWNER_GROUP_ID |
Application Object Library - BIV_RES_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
SR_CREATION_CHANNEL | |
SYS_NC00048$ | |
RESOLUTION_CODE | |
RESOLUTION_COUNT | |
SYS_NC00051$ | |
TOTAL_TIME_TO_RESOLUTION | |
TIME_TO_RESOLUTION_B1 | |
SYS_NC00054$ | |
TIME_TO_RESOLUTION_B2 | |
TIME_TO_RESOLUTION_B3 | |
SYS_NC00044$ | |
TIME_TO_RESOLUTION_B4 | |
TIME_TO_RESOLUTION_B5 | |
SYS_NC00047$ | |
TIME_TO_RESOLUTION_B6 | |
PERIOD_TYPE_ID | |
TIME_TO_RESOLUTION_B7 | |
SYS_NC00050$ | |
SYS_NC00052$ | |
TIME_TO_RESOLUTION_B8 | |
TIME_TO_RESOLUTION_B9 | |
SYS_NC00053$ | |
TIME_TO_RESOLUTION_B10 | |
MV_GROUPING_ID | |
SYS_NC00043$ | |
MV_DAY_ID | |
MV_WEEK_ID | |
SYS_NC00046$ | |
MV_PERIOD_ID | |
MV_ENT_QTR_ID | |
MV_ENT_YEAR_ID | |
GRP_ID | |
MV_TOTAL_TIME_TO_RESOLUTION | |
MV_TIME_TO_RESOLUTION_B1 | |
MV_TIME_TO_RESOLUTION_B2 | |
MV_TIME_TO_RESOLUTION_B3 | |
MV_TIME_TO_RESOLUTION_B4 | |
MV_TIME_TO_RESOLUTION_B5 | |
MV_TIME_TO_RESOLUTION_B6 | |
MV_TIME_TO_RESOLUTION_B7 | |
MV_TIME_TO_RESOLUTION_B8 | |
MV_TIME_TO_RESOLUTION_B9 | |
INCIDENT_TYPE_ID | |
MV_TIME_TO_RESOLUTION_B10 | |
SYS_NC00055$ | |
MV_COUNT | |
INCIDENT_SEVERITY_ID | |
VBH_CATEGORY_ID | |
SYS_NC00042$ | |
PRODUCT_ID | |
CUSTOMER_ID | |
SYS_NC00045$ | |
OWNER_GROUP_ID |
Application Object Library - BIV_B_AGE_H_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
REPORT_DATE | |
BACKLOG_AGE_B1 | |
SYS_NC00047$ | |
BACKLOG_AGE_B2 | |
BACKLOG_AGE_B3 | |
SYS_NC00050$ | |
BACKLOG_AGE_B4 | |
BACKLOG_AGE_B5 | |
SYS_NC00046$ | |
BACKLOG_AGE_B6 | |
BACKLOG_AGE_B7 | |
BACKLOG_AGE_B8 | |
BACKLOG_AGE_B9 | |
BACKLOG_AGE_B10 | |
INCIDENT_TYPE_ID | |
ESCALATED_COUNT | |
SYS_NC00045$ | |
TOTAL_ESCALATED_AGE | |
ESCALATED_AGE_B1 | |
ESCALATED_AGE_B2 | |
ESCALATED_AGE_B3 | |
ESCALATED_AGE_B4 | |
ESCALATED_AGE_B5 | |
ESCALATED_AGE_B6 | |
ESCALATED_AGE_B7 | |
ESCALATED_AGE_B8 | |
VBH_TOP_NODE_FLAG | |
ESCALATED_AGE_B9 | |
ESCALATED_AGE_B10 | |
UNOWNED_COUNT | |
TOTAL_UNOWNED_AGE | |
UNOWNED_AGE_B1 | |
UNOWNED_AGE_B2 | |
UNOWNED_AGE_B3 | |
UNOWNED_AGE_B4 | |
UNOWNED_AGE_B5 | |
UNOWNED_AGE_B6 | |
VBH_PARENT_CATEGORY_ID | |
UNOWNED_AGE_B7 | |
SYS_NC00048$ | |
UNOWNED_AGE_B8 | |
UNOWNED_AGE_B9 | |
UNOWNED_AGE_B10 | |
VBH_CHILD_CATEGORY_ID | |
INCIDENT_SEVERITY_ID | |
SYS_NC00051$ | |
RESOLVED_FLAG | |
BACKLOG_COUNT | |
SYS_NC00044$ | |
TOTAL_BACKLOG_AGE |
Application Object Library - BIV_BAC_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | |
INCIDENT_STATUS_ID | |
SYS_NC00038$ | |
RESOLVED_FLAG | |
BACKLOG_COUNT | |
SYS_NC00025$ | |
ESCALATED_COUNT | |
UNOWNED_COUNT | |
SYS_NC00028$ | |
MV_GRP_ID | |
ENT_YEAR_ID | |
SYS_NC00031$ | |
ENT_QTR_ID | |
ENT_PERIOD_ID | |
SYS_NC00034$ | |
WEEK_ID | |
PERIOD_TYPE_ID | |
REPORT_DATE_JULIAN | |
SYS_NC00037$ | |
SYS_NC00026$ | |
MV_COUNT | |
MV_BACKLOG_COUNT | |
SYS_NC00027$ | |
MV_ESCALATED_COUNT | |
MV_UNOWNED_COUNT | |
SYS_NC00030$ | |
SYS_NC00033$ | |
GRP_ID | |
INCIDENT_TYPE_ID | |
SYS_NC00029$ | |
INCIDENT_SEVERITY_ID | |
VBH_CATEGORY_ID | |
SYS_NC00032$ | |
PRODUCT_ID | |
CUSTOMER_ID | |
SYS_NC00035$ | |
OWNER_GROUP_ID |
Application Object Library - BIV_CLO_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
SR_CREATION_CHANNEL | |
SYS_NC00048$ | |
RESOLUTION_CODE | |
CLOSED_COUNT | |
SYS_NC00051$ | |
TOTAL_TIME_TO_CLOSE | |
TIME_TO_CLOSE_B1 | |
SYS_NC00054$ | |
TIME_TO_CLOSE_B2 | |
TIME_TO_CLOSE_B3 | |
SYS_NC00044$ | |
TIME_TO_CLOSE_B4 | |
TIME_TO_CLOSE_B5 | |
SYS_NC00047$ | |
TIME_TO_CLOSE_B6 | |
PERIOD_TYPE_ID | |
TIME_TO_CLOSE_B7 | |
SYS_NC00050$ | |
SYS_NC00052$ | |
TIME_TO_CLOSE_B8 | |
TIME_TO_CLOSE_B9 | |
SYS_NC00053$ | |
TIME_TO_CLOSE_B10 | |
MV_GROUPING_ID | |
SYS_NC00043$ | |
MV_DAY_ID | |
MV_WEEK_ID | |
SYS_NC00046$ | |
MV_PERIOD_ID | |
MV_ENT_QTR_ID | |
MV_ENT_YEAR_ID | |
GRP_ID | |
MV_TOTAL_TIME_TO_CLOSE | |
MV_TIME_TO_CLOSE_B1 | |
MV_TIME_TO_CLOSE_B2 | |
MV_TIME_TO_CLOSE_B3 | |
MV_TIME_TO_CLOSE_B4 | |
MV_TIME_TO_CLOSE_B5 | |
MV_TIME_TO_CLOSE_B6 | |
MV_TIME_TO_CLOSE_B7 | |
MV_TIME_TO_CLOSE_B8 | |
MV_TIME_TO_CLOSE_B9 | |
INCIDENT_TYPE_ID | |
MV_TIME_TO_CLOSE_B10 | |
SYS_NC00055$ | |
MV_COUNT | |
INCIDENT_SEVERITY_ID | |
VBH_CATEGORY_ID | |
SYS_NC00042$ | |
PRODUCT_ID | |
CUSTOMER_ID | |
SYS_NC00045$ | |
OWNER_GROUP_ID |
Application Object Library - BIX_CALL_PRESP_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00009$ | |
SOURCE_CODE_ID | |
PARTY_ID | |
SYS_NC00008$ | |
TRANSACTION_CREATE_DATE | |
RESPONSE_COUNT | |
SYS_NC00007$ | |
RESPONSE_COUNT_C | |
ALL_COUNT |
Application Object Library - BIX_AI_CALL_DETAILS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00101$ | |
G_ID | |
SERVER_GROUP_ID | |
SYS_NC00099$ | |
RESOURCE_ID | |
OUTCOME_ID | |
SYS_NC00089$ | |
RESULT_ID | |
REASON_ID | |
SYS_NC00092$ | |
PARTY_ID | |
CALL_CALLS_OFFERED_TOTAL | |
SYS_NC00098$ | |
CALLS_OFFERED_TOTAL_XCNT | |
CALL_CALLS_OFFERED_ABOVE_TH | |
SYS_NC00091$ | |
CALLS_OFFERED_ABOVE_TH_XCNT | |
ROW_TYPE | |
CALL_CALLS_HANDLED_TOTAL | |
SYS_NC00097$ | |
SYS_NC00095$ | |
CALLS_HANDLED_TOTAL_XCNT | |
CALL_CALLS_HANDLED_ABOVE_TH | |
SYS_NC00102$ | |
CALLS_HANDLED_ABOVE_TH_XCNT | |
CALL_CALLS_ABANDONED | |
SYS_NC00090$ | |
CALLS_ABANDONED_XCNT | |
CALL_CALLS_TRANSFERRED | |
SYS_NC00096$ | |
CALLS_TRANSFERRED_XCNT | |
CALL_IVR_TIME | |
IVR_TIME_XCNT | |
TIME_ID | |
CALL_ROUTE_TIME | |
ROUTE_TIME_XCNT | |
CALL_QUEUE_TIME | |
QUEUE_TIME_XCNT | |
CALL_TOT_QUEUE_TO_ABANDON | |
TOT_QUEUE_TO_ABANDON_XCNT | |
CALL_TOT_QUEUE_TO_ANSWER | |
TOT_QUEUE_TO_ANSWER_XCNT | |
CALL_TALK_TIME | |
TALK_TIME_XCNT | |
PERIOD_TYPE_ID | |
CALL_CONT_CALLS_OFFERED_NA | |
SYS_NC00100$ | |
CONT_CALLS_OFFERED_NA_XCNT | |
CALL_CONT_CALLS_HANDLED_TOT_NA | |
CONT_CALLS_HANDLED_TOT_NA_XCNT | |
AGENT_TALK_TIME_NAC | |
TALK_TIME_NAC_XCNT | |
AGENT_WRAP_TIME_NAC | |
WRAP_TIME_NAC_XCNT | |
AGENT_CALLS_TRAN_CONF_TO_NAC | |
CALLS_TRAN_CONF_TO_NAC_XCNT | |
PERIOD_START_DATE | |
AGENT_CALLS_HANDLED_TOTAL | |
AGENT_HANDLED_TOTAL_XCNT | |
AGENT_CALLS_HANDLED_ABOVE_TH | |
AGENT_HANDLED_ABOVE_TH_XCNT | |
AGENT_CALLS_ANSWERED_BY_GOAL | |
AGENT_ANSWERED_BY_GOAL_XCNT | |
AGENT_SR_CREATED | |
SR_CREATED_XCNT | |
AGENT_LEADS_CREATED | |
LEADS_CREATED_XCNT | |
PERIOD_START_TIME | |
AGENT_LEADS_AMOUNT | |
SYS_NC00094$ | |
LEADS_AMOUNT_XCNT | |
AGENT_LEADS_CONVERTED_TO_OPP | |
LEADS_CONVERTED_TO_OPP_XCNT | |
AGENT_OPPORTUNITIES_CREATED | |
OPPORTUNITIES_CREATED_XCNT | |
AGENT_OPPORTUNITIES_WON | |
OPPORTUNITIES_WON_XCNT | |
AGENT_OPPORTUNITIES_WON_AMOUNT | |
OPPORTUNITIES_WON_AMOUNT_XCNT | |
MEDIA_ITEM_TYPE | |
AGENT_OPPORTUNITIES_CROSS_SOLD | |
OPPORTUNITIES_CROSS_SOLD_XCNT | |
AGENT_OPPORTUNITIES_UP_SOLD | |
OPPORTUNITIES_UP_SOLD_XCNT | |
AGENT_OPPORTUNITIES_DECLINED | |
OPPORTUNITIES_DECLINED_XCNT | |
AGENT_OPPORTUNITIES_LOST | |
OPPORTUNITIES_LOST_XCNT | |
AGENT_PREVIEW_TIME | |
PREVIEW_TIME_XCNT | |
CLASSIFICATION_VALUE | |
AGENTCALL_ORR_COUNT | |
SYS_NC00093$ | |
CALL_ORR_COUNT_XCNT | |
AGENTCALL_PR_COUNT | |
CALL_PR_COUNT_XCNT | |
AGENT_CONT_CALLS_HAND_NA | |
CONT_CALLS_HAND_NA_XCNT | |
AGENT_CONT_CALLS_TC_NA | |
CONT_CALLS_TC_NA_XCNT | |
XCNT | |
DNIS_NAME |
Application Object Library - BIX_EMAIL_DETAILS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00086$ | |
TIME_ID | |
REASON_ID | |
SYS_NC00089$ | |
G_ID | |
ROW_TYPE | |
SYS_NC00092$ | |
EMAILS_OFFERED_IN_PERIOD | |
EMAILS_FETCHED_IN_PERIOD | |
SYS_NC00088$ | |
EMAILS_REPLIED_IN_PERIOD | |
EMAILS_RPLD_BY_GOAL_IN_PERIOD | |
SYS_NC00091$ | |
AGENT_EMAILS_RPLD_BY_GOAL | |
EMAILS_DELETED_IN_PERIOD | |
SYS_NC00087$ | |
EMAILS_TRNSFRD_OUT_IN_PERIOD | |
PERIOD_TYPE_ID | |
EMAILS_TRNSFRD_IN_IN_PERIOD | |
SYS_NC00090$ | |
SYS_NC00085$ | |
EMAILS_RSL_AND_TRFD_IN_PERIOD | |
EMAILS_ASSIGNED_IN_PERIOD | |
EMAILS_AUTO_ROUTED_IN_PERIOD | |
EMAILS_AUTO_UPTD_SR_IN_PERIOD | |
SR_CREATED_IN_PERIOD | |
ACCUMULATED_OPEN_EMAILS | |
ACCUMULATED_OPEN_AGE | |
ACCUMULATED_EMAILS_IN_QUEUE | |
ACCUMULATED_QUEUE_TIME | |
PERIOD_START_DATE | |
EMAIL_RESP_TIME_IN_PERIOD | |
AGENT_RESP_TIME_IN_PERIOD | |
ACCUMULATED_EMAILS_ONE_DAY | |
ACCUMULATED_EMAILS_THREE_DAYS | |
ACCUMULATED_EMAILS_WEEK | |
ACCUMULATED_EMAILS_WEEK_PLUS | |
ONE_RSLN_IN_PERIOD | |
TWO_RSLN_IN_PERIOD | |
THREE_RSLN_IN_PERIOD | |
FOUR_RSLN_IN_PERIOD | |
EMAIL_ACCOUNT_ID | |
INTERACTION_THREADS_IN_PERIOD | |
SYS_NC00094$ | |
EMAILS_ORR_COUNT_IN_PERIOD | |
EMAILS_AUTO_REPLIED_IN_PERIOD | |
EMAILS_AUTO_DELETED_IN_PERIOD | |
EMAILS_AUTO_RESOLVED_IN_PERIOD | |
EMAILS_COMPOSED_IN_PERIOD | |
LEADS_CREATED_IN_PERIOD | |
EMAILS_REROUTED_IN_PERIOD | |
EMAILS_OFFERED_C | |
EMAILS_FETCHED_C | |
EMAIL_CLASSIFICATION_ID | |
EMAILS_REPLIED_C | |
EMAILS_RPLD_BY_GOAL_C | |
AGENT_EMAILS_RPLD_BY_GOAL_C | |
EMAILS_DELETED_C | |
EMAILS_TRNSFRD_OUT_C | |
EMAILS_TRNSFRD_IN_C | |
EMAILS_RSL_AND_TRFD_C | |
EMAILS_ASSIGNED_C | |
EMAILS_AUTO_ROUTED_C | |
EMAILS_AUTO_UPTD_SR_C | |
AGENT_ID | |
SR_CREATED_C | |
SYS_NC00084$ | |
ACCU_OPEN_EMAILS_C | |
ACCU_OPEN_AGE_C | |
ACCU_EMAILS_IN_QUEUE_C | |
ACCU_QUEUE_TIME_C | |
EMAIL_RESP_TIME_C | |
AGENT_RESP_TIME_C | |
ACCU_EMAILS_ONE_DAY_C | |
ACCU_EMAILS_THREE_DAYS_C | |
ACCU_EMAILS_WEEK_C | |
PARTY_ID | |
ACCU_EMAILS_WEEK_PLUS_C | |
ONE_RSLN_C | |
TWO_RSLN_C | |
THREE_RSLN_C | |
FOUR_RSLN_C | |
INTERACTION_THREAD_C | |
EMAILS_ORR_COUNT_C | |
EMAILS_AUTO_REPLIED_C | |
EMAILS_AUTO_DELETED_C | |
EMAILS_AUTO_RESOLV_C | |
OUTCOME_ID | |
EMAILS_COMPOSED_C | |
SYS_NC00093$ | |
LEADS_CREATED_C | |
EMAILS_REROUTED_C | |
TOT_CNT | |
RESULT_ID |
Application Object Library - CSF_MD_ADM_BOUNDS_MAT_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00011$ | |
SYS_NC00010$ | |
AREA | |
ADMIN_BOUND_ID | |
ADMIN_LEVEL | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00006$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
INST_STYLE_ID | |
NAME | |
SYS_NC00013$ | |
SYS_NC00012$ |
Application Object Library - CSF_MD_HYDROS_MAT_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00011$ | |
INST_STYLE_ID | |
SYS_NC00010$ | |
WATER_TYPE | |
HYDROGRAPHY_ID | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00006$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
NAME | |
AREA | |
SYS_NC00013$ | |
SYS_NC00012$ |
Application Object Library - CSF_MD_LAND_USES_MAT_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00010$ | |
PARK_TYPE | |
LANDUSE_ID | |
INST_STYLE_ID | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY | |
AREA | |
SYS_NC00007$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00013$ | |
SYS_NC00012$ |
Application Object Library - CSF_MD_POIS_MAT_V | |
---|---|
Column Name | Descritpion |
POI_ID | |
SYS_NC00013$ | |
SYS_NC00017$ | |
SYS_NC00012$ | |
SYS_NC00015$ | |
FOOD_TYPE | |
SYS_NC00010$ | |
FEATURE_CODE | |
SYS_NC00008$ | |
SYS_NC00016$ | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
SYS_NC00009$ | |
IMPORTANCE | |
NAME | |
SYS_NC00011$ | |
POI_ADDRESS | |
TELEPHONE_NUMBER | |
POPULATION | |
CHAIN_NAME | |
SYS_NC00014$ | |
INST_STYLE_ID |
Application Object Library - CSF_MD_RAIL_SEGS_MAT_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00011$ | |
RAILROAD_SEGMENT_ID | |
SYS_NC00003$ | |
SYS_NC00008$ | |
SYS_NC00010$ | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
NAME | |
SYS_NC00009$ | |
SYS_NC00006$ | |
INST_STYLE_ID |
Application Object Library - CSF_MD_RD_SEGS_FUN0_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
FEATURE_CODE | |
SYS_NC00026$ | |
FERRY_TYPE | |
ACCESS_CAR | |
SYS_NC00029$ | |
ACCESS_CARPOOL | |
ACCESS_DELIVERY | |
SYS_NC00024$ | |
ACCESS_TAXI | |
ACCESS_PEDESTRIAN | |
ROAD_SEGMENT_ID | |
ACCESS_BUS | |
ACCESS_BICYCLE | |
ACCESS_EMERGENCY | |
NAME | |
ACCESS_TRUCK | |
SYS_NC00025$ | |
INST_STYLE_ID | |
SYS_NC00027$ | |
CONSTRUCTION_STATUS | |
FUNCTIONAL_CLASS | |
SYS_NC00008$ | |
SYS_NC00005$ | |
FORM_OF_WAY | |
SYS_NC00002$ | |
SYS_NC00028$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
SPEED_CATEGORY | |
LANE_CATEGORY | |
ONEWAY_DIRECTION | |
TOLL_ROAD | |
SYS_NC00023$ | |
PAVED |
Application Object Library - CSF_MD_RD_SEGS_FUN1_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
FEATURE_CODE | |
SYS_NC00026$ | |
FERRY_TYPE | |
ACCESS_CAR | |
SYS_NC00029$ | |
ACCESS_CARPOOL | |
ACCESS_DELIVERY | |
SYS_NC00024$ | |
ACCESS_TAXI | |
ACCESS_PEDESTRIAN | |
ROAD_SEGMENT_ID | |
ACCESS_BUS | |
ACCESS_BICYCLE | |
ACCESS_EMERGENCY | |
NAME | |
ACCESS_TRUCK | |
SYS_NC00025$ | |
INST_STYLE_ID | |
SYS_NC00027$ | |
CONSTRUCTION_STATUS | |
FUNCTIONAL_CLASS | |
SYS_NC00008$ | |
SYS_NC00005$ | |
FORM_OF_WAY | |
SYS_NC00002$ | |
SYS_NC00028$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
SPEED_CATEGORY | |
LANE_CATEGORY | |
ONEWAY_DIRECTION | |
TOLL_ROAD | |
SYS_NC00023$ | |
PAVED |
Application Object Library - CSF_MD_RD_SEGS_FUN2_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
FEATURE_CODE | |
SYS_NC00026$ | |
FERRY_TYPE | |
ACCESS_CAR | |
SYS_NC00029$ | |
ACCESS_CARPOOL | |
ACCESS_DELIVERY | |
SYS_NC00024$ | |
ACCESS_TAXI | |
ACCESS_PEDESTRIAN | |
ROAD_SEGMENT_ID | |
ACCESS_BUS | |
ACCESS_BICYCLE | |
ACCESS_EMERGENCY | |
NAME | |
ACCESS_TRUCK | |
SYS_NC00025$ | |
INST_STYLE_ID | |
SYS_NC00027$ | |
CONSTRUCTION_STATUS | |
FUNCTIONAL_CLASS | |
SYS_NC00008$ | |
SYS_NC00005$ | |
FORM_OF_WAY | |
SYS_NC00002$ | |
SYS_NC00028$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
SPEED_CATEGORY | |
LANE_CATEGORY | |
ONEWAY_DIRECTION | |
TOLL_ROAD | |
SYS_NC00023$ | |
PAVED |
Application Object Library - CSF_MD_RD_SEGS_FUN3_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
FEATURE_CODE | |
SYS_NC00026$ | |
FERRY_TYPE | |
ACCESS_CAR | |
SYS_NC00029$ | |
ACCESS_CARPOOL | |
ACCESS_DELIVERY | |
SYS_NC00024$ | |
ACCESS_TAXI | |
ACCESS_PEDESTRIAN | |
ROAD_SEGMENT_ID | |
ACCESS_BUS | |
ACCESS_BICYCLE | |
ACCESS_EMERGENCY | |
NAME | |
ACCESS_TRUCK | |
SYS_NC00025$ | |
INST_STYLE_ID | |
SYS_NC00027$ | |
CONSTRUCTION_STATUS | |
FUNCTIONAL_CLASS | |
SYS_NC00008$ | |
SYS_NC00005$ | |
FORM_OF_WAY | |
SYS_NC00002$ | |
SYS_NC00028$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
SPEED_CATEGORY | |
LANE_CATEGORY | |
ONEWAY_DIRECTION | |
TOLL_ROAD | |
SYS_NC00023$ | |
PAVED |
Application Object Library - CSF_MD_RD_SEGS_FUN4_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
FEATURE_CODE | |
SYS_NC00026$ | |
FERRY_TYPE | |
ACCESS_CAR | |
SYS_NC00029$ | |
ACCESS_CARPOOL | |
ACCESS_DELIVERY | |
SYS_NC00024$ | |
ACCESS_TAXI | |
ACCESS_PEDESTRIAN | |
ROAD_SEGMENT_ID | |
ACCESS_BUS | |
ACCESS_BICYCLE | |
ACCESS_EMERGENCY | |
NAME | |
ACCESS_TRUCK | |
SYS_NC00025$ | |
INST_STYLE_ID | |
SYS_NC00027$ | |
CONSTRUCTION_STATUS | |
FUNCTIONAL_CLASS | |
SYS_NC00008$ | |
SYS_NC00005$ | |
FORM_OF_WAY | |
SYS_NC00002$ | |
SYS_NC00028$ | |
GEOMETRY | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
SPEED_CATEGORY | |
LANE_CATEGORY | |
ONEWAY_DIRECTION | |
TOLL_ROAD | |
SYS_NC00023$ | |
PAVED |
Application Object Library - BIM_I_BGT_CAT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
HOLDBACK | |
SYS_NC00054$ | |
HOLDBACK_C | |
TRANSFER_IN | |
SYS_NC00057$ | |
TRANSFER_IN_C | |
TRANSFER_OUT | |
SYS_NC00047$ | |
TRANSFER_OUT_C | |
ACCRUAL | |
SYS_NC00050$ | |
ACCRUAL_C | |
COMMITTED | |
SYS_NC00053$ | |
COMMITTED_C | |
PERIOD_TYPE_ID | |
PLANNED | |
SYS_NC00056$ | |
SYS_NC00052$ | |
PLANNED_C | |
UTILIZED | |
UTILIZED_C | |
ORIGINAL_BUDGET_S | |
ORIGINAL_BUDGET_S_C | |
HOLDBACK_S | |
HOLDBACK_S_C | |
TRANSFER_IN_S | |
TRANSFER_IN_S_C | |
FUND_ID | |
TRANSFER_OUT_S | |
TRANSFER_OUT_S_C | |
ACCRUAL_S | |
ACCRUAL_S_C | |
COMMITTED_S | |
COMMITTED_S_C | |
PLANNED_S | |
PLANNED_S_C | |
UTILIZED_S | |
UTILIZED_S_C | |
PARENT_FUND_ID | |
COUNT_ALL | |
SYS_NC00055$ | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
CATEGORY_ID | |
LEAF_NODE_FLAG | |
SYS_NC00048$ | |
PARENT_CATEGORY_ID | |
ORIGINAL_BUDGET | |
SYS_NC00051$ | |
ORIGINAL_BUDGET_C |
Application Object Library - BIM_SGMT_VAL_F_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00035$ | |
TIME_ID | |
BOOKED_COUNT | |
SYS_NC00029$ | |
REVENUE | |
REVENUE_S | |
SYS_NC00032$ | |
ACQUIRED_CUSTOMERS_C | |
TOTAL_CUSTOMERS_C | |
LOST_CUSTOMERS_C | |
SEGMENT_SIZE_C | |
BOOKED_AMT_C | |
BOOKED_AMT_S_C | |
BOOKED_COUNT_C | |
PERIOD_TYPE_ID | |
REVENUE_C | |
SYS_NC00030$ | |
REVENUE_S_C | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
ALL_C | |
SEGMENT_ID | |
ACQUIRED_CUSTOMERS | |
SYS_NC00033$ | |
TOTAL_CUSTOMERS | |
LOST_CUSTOMERS | |
SYS_NC00031$ | |
SEGMENT_SIZE | |
BOOKED_AMT | |
SYS_NC00034$ | |
BOOKED_AMT_S |
Application Object Library - BIV_ACT_H_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00021$ | |
TIME_ID | Nested Grouping ID Column for Time |
CLOSED_COUNT | Count of closed activity |
SYS_NC00015$ | |
MV_FIRST_OPENED_COUNT | Count Column |
MV_REOPENED_COUNT | Count Column |
SYS_NC00018$ | |
MV_CLOSED_COUNT | Count Column |
MV_COUNT | Row Count |
PERIOD_TYPE_ID | Period type identifier based on XTD nested model |
SYS_NC00016$ | |
INCIDENT_TYPE_ID | Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension |
VBH_TOP_NODE_FLAG | Indicates if VBH_PARENT_CATEGORY_ID is for a top node in the hierarchy |
SYS_NC00019$ | |
VBH_PARENT_CATEGORY_ID | Parent Product Category identifier, from eni_denorm_hierarchies.parent_id |
VBH_CHILD_CATEGORY_ID | Child Product Category identifier, from eni_denorm_hierarchies.imm_child_id |
SYS_NC00017$ | |
INCIDENT_SEVERITY_ID | Severity identifier, from cs_incidents_audit_b.incident_severity_id |
FIRST_OPENED_COUNT | Count of first opened activity |
SYS_NC00020$ | |
REOPENED_COUNT | Count of reopened activity |
Application Object Library - BIM_I_LD_BASE_MV | |
---|---|
Column Name | Descritpion |
UMARK | Number of Hot Leads converted to Opportunity |
LEAD_SOURCE | Source system of the lead |
LEAD_STATUS | The status of this sales lead like OPEN, CLOSED, DEAD |
LEAD_REGION | Region of the country associated with lead |
LEAD_COUNTRY | Country associated with lead |
SOURCE_CODE_ID | Source Code ID of the Marketing Object to which this lead is attached |
OBJECT_TYPE | Type of the object in case of schedules attached to lead. |
OBJECT_ID | Country associated with lead |
CHILD_OBJECT_TYPE | Type of the object in case of schedules attached to lead. |
CHILD_OBJECT_ID | ID of the object in case of schedules attached to lead |
OBJECT_REGION | Region of the country of the marketing object associated with lead |
TRANSACTION_CREATE_DATE | Transaction Create Date |
OBJECT_COUNTRY | Country of the marketing object associated with lead |
CHILD_OBJECT_REGION | Region of Child Object |
CHILD_OBJECT_COUNTRY | Country of Child Object |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEAD_CREATION_DATE | Creation date of the lead |
LEADS_QUALIFIED | Number of Qualified Leads |
ALEADS_CONVERTED | Number of A Leads converted to Opportunity |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
LEADS_CUSTOMER | Number of Leads from existing Customers |
LEADS_PROSPECT | Number of Leads from prospective Customers |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
LEAD_CONVERTED_DATE | Date on which lead converted into opportunity |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEADS_CONV_CUSTOMER | Number of Leads from existing Customer which converted to Opportunity |
LEADS_CONV_PROSPECT | Number of Leads from prospective Customer which converted to Opportunity |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY16_FR | |
DUMMY17_FR | |
CHANNEL_CODE | Sales channel of the lead |
CUST_CATEGORY | Industry of the lead |
LEAD_RANK_ID | Ranking ID for the lead generated |
Application Object Library - BIM_I_BGT_LVL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
HOLDBACK | |
SYS_NC00054$ | |
HOLDBACK_C | |
TRANSFER_IN | |
SYS_NC00057$ | |
TRANSFER_IN_C | |
TRANSFER_OUT | |
SYS_NC00047$ | |
TRANSFER_OUT_C | |
ACCRUAL | |
SYS_NC00050$ | |
ACCRUAL_C | |
COMMITTED | |
SYS_NC00053$ | |
COMMITTED_C | |
PERIOD_TYPE_ID | |
PLANNED | |
SYS_NC00056$ | |
SYS_NC00052$ | |
PLANNED_C | |
UTILIZED | |
UTILIZED_C | |
ORIGINAL_BUDGET_S | |
ORIGINAL_BUDGET_S_C | |
HOLDBACK_S | |
HOLDBACK_S_C | |
TRANSFER_IN_S | |
TRANSFER_IN_S_C | |
FUND_ID | |
TRANSFER_OUT_S | |
TRANSFER_OUT_S_C | |
ACCRUAL_S | |
ACCRUAL_S_C | |
COMMITTED_S | |
COMMITTED_S_C | |
PLANNED_S | |
PLANNED_S_C | |
UTILIZED_S | |
UTILIZED_S_C | |
FUND_TYPE | |
COUNT_ALL | |
SYS_NC00055$ | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
PARENT_FUND_ID | |
CATEGORY_ID | |
SYS_NC00048$ | |
LEAF_NODE_FLAG | |
ORIGINAL_BUDGET | |
SYS_NC00051$ | |
ORIGINAL_BUDGET_C |
Application Object Library - BIM_I_ORD_INT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
UMARK | |
OBJECT_REGION | |
SYS_NC00031$ | |
OBJECT_COUNTRY | |
OBJECT_STATUS | |
SYS_NC00034$ | |
ACTIVITY_ID | |
CATEGORY_FLAG | |
SYS_NC00026$ | |
BOOKED_AMT_F | |
BOOKED_AMT_F_C | |
SYS_NC00029$ | |
INVOICED_AMT_F | |
INVOICED_AMT_F_C | |
SYS_NC00032$ | |
BOOKED_AMT_S | |
TRANSACTION_CREATE_DATE | |
BOOKED_AMT_S_C | |
SYS_NC00024$ | |
SYS_NC00030$ | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
ALL_C | |
SOURCE_CODE_ID | |
OBJECT_ID | |
SYS_NC00033$ | |
OBJECT_TYPE | |
VBH_CATEGORY_ID | |
SYS_NC00025$ | |
METRIC_TYPE | |
CHILD_OBJECT_ID | |
SYS_NC00028$ | |
CHILD_OBJECT_TYPE |
Application Object Library - BIM_SGMT_ACT_B_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
RESP_CNT | |
LEADS | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
BOOKED_AMT | |
BOOKED_AMT_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
SEGMENT_ID | |
COUNT_ALL | |
ACTIVITY_ID | |
SCHEDULE_PURPOSE | |
CATEGORY_ID | |
SOURCE_CODE_ID | |
TRANSACTION_CREATE_DATE | |
ACTIVITIES_COUNT | |
RESPONSES |
Application Object Library - BIM_I_LP_BASE_MV | |
---|---|
Column Name | Descritpion |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
ITEM_ID | Inventory item id of the product assigned to the lead lines |
ORGANIZATION_ID | Inventory organization identifier of the assigned to the lead lines |
LEAD_RANK_ID | Ranking ID for the lead generated |
LEAD_SOURCE | Source system of the lead |
LEAD_STATUS | The status of this sales lead like OPEN, CLOSED, DEAD |
LEAD_REGION | Region of the country associated with lead |
LEAD_COUNTRY | Country associated with lead |
SOURCE_CODE_ID | Source Code ID of the Marketing Object to which this lead is attached |
OBJECT_TYPE | Type of the object in case of schedules attached to lead. |
OBJECT_ID | ID of the marketing object directly associated with lead. |
TRANSACTION_CREATE_DATE | Transaction Create Date |
CHILD_OBJECT_TYPE | Type of the object in case of schedules attached to lead. |
CHILD_OBJECT_ID | ID of the object in case of schedules attached to lead |
OBJECT_REGION | Region of the country of the marketing object associated with lead |
OBJECT_COUNTRY | Country of the marketing object associated with lead |
CHILD_OBJECT_REGION | Region of Child Object |
CHILD_OBJECT_COUNTRY | Country of Child Object |
BUSINESS_UNIT_ID | Business Unit Id |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
LEADS_OPEN | Number of Open Leads |
LEAD_CREATION_DATE | Creation date of the lead |
LEADS_CHANGED | Number of Leads whose information has been modified |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
LEAD_CONVERTED_DATE | Date on which lead converted into opportunity |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
CHANNEL_CODE | Sales channel of the lead |
CUST_CATEGORY | Industry of the lead |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
Application Object Library - BIV_RES_H_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | Nested Grouping ID Column for Time |
TIME_TO_RESOLUTION_B1 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 1 |
SYS_NC00037$ | |
TIME_TO_RESOLUTION_B2 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 2 |
TIME_TO_RESOLUTION_B3 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 3 |
SYS_NC00033$ | |
TIME_TO_RESOLUTION_B4 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 4 |
TIME_TO_RESOLUTION_B5 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 5 |
TIME_TO_RESOLUTION_B6 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 6 |
TIME_TO_RESOLUTION_B7 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 7 |
TIME_TO_RESOLUTION_B8 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 8 |
TIME_TO_RESOLUTION_B9 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 9 |
TIME_TO_RESOLUTION_B10 | Count of Service Requests closed with combination of dimensional values and time to resolution in bucket range 10 |
PERIOD_TYPE_ID | Period type identifier based on XTD nested model |
MV_RESOLUTION_COUNT | |
SYS_NC00039$ | |
MV_TOTAL_TIME_TO_RESOLUTION | Count Column |
MV_TIME_TO_RESOLUTION_B1 | Count Column |
MV_TIME_TO_RESOLUTION_B2 | Count Column |
MV_TIME_TO_RESOLUTION_B3 | Count Column |
MV_TIME_TO_RESOLUTION_B4 | Count Column |
MV_TIME_TO_RESOLUTION_B5 | Count Column |
MV_TIME_TO_RESOLUTION_B6 | Count Column |
MV_TIME_TO_RESOLUTION_B7 | Count Column |
MV_TIME_TO_RESOLUTION_B8 | Count Column |
INCIDENT_TYPE_ID | Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension |
MV_TIME_TO_RESOLUTION_B9 | Count Column |
MV_TIME_TO_RESOLUTION_B10 | Count Column |
MV_COUNT | Row Count |
VBH_TOP_NODE_FLAG | Indicates if VBH_PARENT_CATEGORY_ID is for a top node in the hierarchy |
SYS_NC00035$ | |
VBH_PARENT_CATEGORY_ID | Parent Product Category identifier, from eni_denorm_hierarchies.parent_id |
VBH_CHILD_CATEGORY_ID | Child Product Category identifier, from eni_denorm_hierarchies.imm_child_id |
SYS_NC00038$ | |
INCIDENT_SEVERITY_ID | Severity identifier, from cs_incidents_audit_b.incident_severity_id |
RESOLUTION_COUNT | Count of Service Requests closed with combination of dimensional values |
SYS_NC00034$ | |
TOTAL_TIME_TO_RESOLUTION | Total (sum) for time to resolution of Service Requests resolved with combination of dimensional values |
Application Object Library - BIV_BAC_H_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00021$ | |
TIME_ID | Nested Grouping ID Column for Time |
ESCALATED_COUNT | Count of escalated Service Requests in backlog |
SYS_NC00020$ | |
UNOWNED_COUNT | Count of unowned Service Requests in backlog |
MV_BACKLOG_COUNT | Count Column |
SYS_NC00023$ | |
MV_ESCALATED_COUNT | Count Column |
MV_UNOWNED_COUNT | Count Column |
SYS_NC00018$ | |
MV_COUNT | Row Count |
PERIOD_TYPE_ID | Period type identifier based on XTD nested model |
SYS_NC00016$ | |
INCIDENT_TYPE_ID | Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension |
VBH_TOP_NODE_FLAG | Indicates if VBH_PARENT_CATEGORY_ID is for a top node in the hierarchy |
SYS_NC00019$ | |
VBH_PARENT_CATEGORY_ID | Parent Product Category identifier, from eni_denorm_hierarchies.parent_id |
VBH_CHILD_CATEGORY_ID | Child Product Category identifier, from eni_denorm_hierarchies.imm_child_id |
SYS_NC00022$ | |
INCIDENT_SEVERITY_ID | Severity identifier, from cs_incidents_audit_b.incident_severity_id |
RESOLVED_FLAG | Flag indicates the resolution status of the backlog audit record |
SYS_NC00017$ | |
BACKLOG_COUNT | Count of Service Requests in backlog |
Application Object Library - BIV_CLO_H_SUM_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | Nested Grouping ID Column for Time |
TIME_TO_CLOSE_B1 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 1 |
SYS_NC00037$ | |
TIME_TO_CLOSE_B2 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 2 |
TIME_TO_CLOSE_B3 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 3 |
SYS_NC00033$ | |
TIME_TO_CLOSE_B4 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 4 |
TIME_TO_CLOSE_B5 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 5 |
TIME_TO_CLOSE_B6 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 6 |
TIME_TO_CLOSE_B7 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 7 |
TIME_TO_CLOSE_B8 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 8 |
TIME_TO_CLOSE_B9 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 9 |
TIME_TO_CLOSE_B10 | Count of Service Requests closed with combination of dimensional values and time to close in bucket range 10 |
PERIOD_TYPE_ID | Period type identifier based on XTD nested model |
MV_CLOSED_COUNT | Count Column |
SYS_NC00039$ | |
MV_TOTAL_TIME_TO_CLOSE | Count Column |
MV_TIME_TO_CLOSE_B1 | Count Column |
MV_TIME_TO_CLOSE_B2 | Count Column |
MV_TIME_TO_CLOSE_B3 | Count Column |
MV_TIME_TO_CLOSE_B4 | Count Column |
MV_TIME_TO_CLOSE_B5 | Count Column |
MV_TIME_TO_CLOSE_B6 | Count Column |
MV_TIME_TO_CLOSE_B7 | Count Column |
MV_TIME_TO_CLOSE_B8 | Count Column |
INCIDENT_TYPE_ID | Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension |
MV_TIME_TO_CLOSE_B9 | Count Column |
MV_TIME_TO_CLOSE_B10 | Count Column |
MV_COUNT | Row Count |
VBH_TOP_NODE_FLAG | Indicates if VBH_PARENT_CATEGORY_ID is for a top node in the hierarchy |
SYS_NC00035$ | |
VBH_PARENT_CATEGORY_ID | Parent Product Category identifier, from eni_denorm_hierarchies.parent_id |
VBH_CHILD_CATEGORY_ID | Child Product Category identifier, from eni_denorm_hierarchies.imm_child_id |
SYS_NC00038$ | |
INCIDENT_SEVERITY_ID | Severity identifier, from cs_incidents_audit_b.incident_severity_id |
CLOSED_COUNT | Count of Service Requests closed with combination of dimensional values |
SYS_NC00034$ | |
TOTAL_TIME_TO_CLOSE | Total (sum) for time to close of Service Requests closed with combination of dimensional values |
Application Object Library - BIM_LD_CAMP_GH_MV | |
---|---|
Column Name | Descritpion |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
RANK_A | Number of Leads with Rank = A |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
SOURCE_CODE_ID | Source Code ID of the Marketing Object to which this lead is attached |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
TRANSACTION_CREATE_DATE | Transaction Create Date |
LEAD_CREATION_DATE | Creation date of the lead |
LEAD_CONVERTED_DATE | Date on which lead converted into opportunity |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
Application Object Library - BIM_SGMT_ACT_CH_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | |
RESPONSES_C | |
SYS_NC00031$ | |
LEADS | |
LEADS_C | |
SYS_NC00034$ | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
SYS_NC00030$ | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
SYS_NC00033$ | |
BOOKED_AMT | |
BOOKED_AMT_C | |
BOOKED_AMT_S | |
PERIOD_TYPE_ID | |
BOOKED_AMT_S_C | |
SYS_NC00029$ | |
ALL_CNT | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
SEGMENT_ID | |
ACTIVITY_ID | |
SYS_NC00032$ | |
CATEGORY_ID | |
CATEGORY_ID_C | |
SYS_NC00035$ | |
ACTIVITIES_COUNT | |
ACTIVITIES_COUNT_C | |
SYS_NC00028$ | |
RESPONSES |
Application Object Library - BIM_I_LD_GH_SUM_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
LEAD_SOURCE | |
LEAD_REGION | |
LEAD_COUNTRY | |
LEADS | |
LEADS_NEW | |
LEADS_OPEN | |
LEADS_CHANGED | |
LEADS_CONVERTED | |
LEADS_DEAD | |
LEADS_CLOSED | |
GROUP_ID | |
LEADS_QUALIFIED | |
ORDERS_BOOKED_AMT | |
ORDERS_INVOICED_AMT | |
LEAD_AMOUNT | |
RANK_A | |
RANK_B | |
RANK_C | |
RANK_D | |
RANK_Z | |
LEADS_QUALIFIED_A | |
RESOURCE_ID | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
CHANNEL_CODE | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
CUST_CATEGORY | |
TRANSACTION_CREATE_DATE | |
LEAD_CREATION_DATE | |
LEAD_CONVERTED_DATE | |
LEAD_RANK_ID |
Application Object Library - BIM_I_LP_GH_SUM_MV | |
---|---|
Column Name | Descritpion |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEAD_RANK_ID | Ranking ID for the lead generated |
LEAD_SOURCE | Source system of the lead |
CHANNEL_CODE | Sales channel of the lead |
CUST_CATEGORY | Industry of the lead |
LEAD_REGION | Region of the country associated with lead |
LEAD_COUNTRY | ID of the marketing object directly associated with lead. |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
TRANSACTION_CREATE_DATE | Transaction Create Date |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
LEAD_CREATION_DATE | Creation date of the lead |
DUMMY18_FR | |
LEAD_CONVERTED_DATE | Date on which lead converted into opportunity |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
ITEM_ID | |
ORGANIZATION_ID |
Application Object Library - BIM_SGMT_ACT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
TIME_ID | |
LEADS | |
SYS_NC00034$ | |
LEADS_C | |
NEW_OPPORTUNITY_AMT | |
SYS_NC00029$ | |
NEW_OPPORTUNITY_AMT_C | |
NEW_OPPORTUNITY_AMT_S | |
SYS_NC00032$ | |
NEW_OPPORTUNITY_AMT_S_C | |
BOOKED_AMT | |
BOOKED_AMT_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
PERIOD_TYPE_ID | |
ALL_CNT | |
SYS_NC00030$ | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
SEGMENT_ID | |
CATEGORY_ID | |
SYS_NC00033$ | |
CATEGORY_ID_C | |
ACTIVITIES_COUNT | |
SYS_NC00028$ | |
ACTIVITIES_COUNT_C | |
RESPONSES | |
SYS_NC00031$ | |
RESPONSES_C |
Application Object Library - BIM_SGMT_ACT_SH_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | |
RESPONSES_C | |
SYS_NC00031$ | |
LEADS | |
LEADS_C | |
SYS_NC00034$ | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
SYS_NC00030$ | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
SYS_NC00033$ | |
BOOKED_AMT | |
BOOKED_AMT_C | |
BOOKED_AMT_S | |
PERIOD_TYPE_ID | |
BOOKED_AMT_S_C | |
SYS_NC00029$ | |
ALL_CNT | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
SEGMENT_ID | |
SOURCE_CODE_ID | |
SYS_NC00032$ | |
CATEGORY_ID | |
CATEGORY_ID_C | |
SYS_NC00035$ | |
ACTIVITIES_COUNT | |
ACTIVITIES_COUNT_C | |
SYS_NC00028$ | |
RESPONSES |
Application Object Library - BIM_I_LD_AGE_SG_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
AGE_3_BELOW | |
AGE_3_TO_7 | |
AGE_8_TO_14 | |
AGE_15_TO_21 | |
AGE_22_TO_28 | |
AGE_29_TO_35 | |
AGE_36_TO_42 | |
AGE_42_TO_ABOVE | |
C_DAYS | |
P_DAYS | |
GROUP_ID | |
C_LEADS_OPEN | |
P_LEADS_OPEN | |
C_ADAYS | |
P_ADAYS | |
C_ALEADS_OPEN | |
P_ALEADS_OPEN | |
RESOURCE_ID | |
CHANNEL_CODE | |
CUST_CATEGORY | |
LEAD_RANK_ID | |
LEAD_SOURCE | |
LEAD_COUNTRY | |
DIM_ID |
Application Object Library - BIM_I_LD_GENSG_T_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
UPDATE_TIME_ID | |
TIME_ID | |
UPDATE_PERIOD_TYPE_ID | |
PERIOD_TYPE_ID | |
LEADS | |
LEADS_NEW | |
LEADS_OPEN | |
LEADS_CHANGED | |
LEADS_CONVERTED | |
CONVERSION_TIME | |
GROUP_ID | |
LEADS_DEAD | |
LEADS_CLOSED | |
LEADS_QUALIFIED | |
LEADS_NEW_CONV | |
LEADS_NEW_CHANGED | |
RANK_A | |
RANK_B | |
RANK_C | |
RANK_D | |
RANK_Z | |
RESOURCE_ID | |
LEADS_QUALIFIED_A | |
ORDERS_BOOKED_AMT | |
ORDERS_INVOICED_AMT | |
LEAD_AMOUNT | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
CHANNEL_CODE | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
CUST_CATEGORY | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
DUMMY22_FR | |
DUMMY23_FR | |
DUMMY24_FR | |
DUMMY25_FR | |
DUMMY26_FR | |
LEAD_RANK_ID | |
DUMMY27_FR | |
DUMMY28_FR | |
DUMMY29_FR | |
DUMMY30_FR | |
DUMMY31_FR | |
LEAD_SOURCE | |
LEAD_REGION | |
LEAD_COUNTRY |
Application Object Library - BIM_I_LP_GENSG_T_MV | |
---|---|
Column Name | Descritpion |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEAD_COUNTRY | ID of the marketing object directly associated with lead. |
ITEM_ID | |
ORGANIZATION_ID | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
LEADS_OPEN | Number of Open Leads |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_CHANGED | Number of Leads whose information has been modified |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
LEAD_RANK_ID | Ranking ID for the lead generated |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
DUMMY22_FR | |
DUMMY23_FR | |
LEAD_SOURCE | Source system of the lead |
DUMMY24_FR | |
DUMMY25_FR | |
DUMMY26_FR | |
DUMMY27_FR | |
DUMMY28_FR | |
DUMMY29_FR | |
DUMMY30_FR | |
CHANNEL_CODE | Sales channel of the lead |
CUST_CATEGORY | Industry of the lead |
LEAD_REGION | Region of the country associated with lead |
Application Object Library - BIM_LD_CAMP_T_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00065$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00060$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
SYS_NC00063$ | |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
SYS_NC00059$ | |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
SYS_NC00062$ | |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_D | Number of Leads with Rank = D |
SYS_NC00058$ | |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
SOURCE_CODE_ID | Source Code ID of the Marketing Object to which this lead is attached |
DUMMY15_FR | |
SYS_NC00061$ | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
DUMMY22_FR | |
DUMMY23_FR | |
DUMMY24_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
DUMMY25_FR | |
DUMMY26_FR | |
DUMMY27_FR | |
DUMMY28_FR | |
DUMMY29_FR | |
DUMMY30_FR | |
DUMMY31_FR | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00064$ | |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
SYS_NC00057$ | |
LEADS_OPEN | Number of Open Leads |
Application Object Library - BIM_I_MKT_FCT_MV | |
---|---|
Column Name | Descritpion |
UMARK | |
OBJECT_REGION | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CHILD_OBJECT_COUNTRY | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CHILD_OBJECT_REGION | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
BUSINESS_UNIT_ID | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
START_DATE | |
BOOKED_ORDER_AMOUNT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
INVOICED_ORDER_AMOUNT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
END_DATE | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
OBJECT_STATUS | |
CHILD_OBJECT_STATUS | |
OBJECT_PURPOSE | |
CHILD_OBJECT_PURPOSE | |
TRANSACTION_CREATE_DATE | |
ACTIVITY_TYPE | |
ACTIVITY_ID | |
LEAD_SOURCE | |
CHANNEL_CODE | |
LEAD_RANK_ID | |
CUST_CATEGORY | |
LEAD_CREATION_DATE | |
LEAD_CONVERTED_DATE | |
LEADS | |
LEADS_C | |
SOURCE_CODE_ID | |
RANK_A | |
RANK_A_C | |
RANK_B | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
OBJECT_TYPE | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
OBJECT_ID | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
CHILD_OBJECT_TYPE | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
LEADS_QUALIFIED_A_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
CHILD_OBJECT_ID | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
OBJECT_COUNTRY | |
COST_FORECASTED | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
CATEGORY_ID | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C |
Application Object Library - BIM_I_LD_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00056$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_NEW | Number of New Leads |
SYS_NC00050$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_A | Number of Leads with Rank = A |
SYS_NC00052$ | |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
CHANNEL_CODE | Sales channel of the lead |
DUMMY12_FR | |
SYS_NC00055$ | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
SYS_NC00051$ | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LD_CCAT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00056$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_NEW | Number of New Leads |
SYS_NC00050$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_A | Number of Leads with Rank = A |
SYS_NC00052$ | |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
CUST_CATEGORY | Industry of the lead |
DUMMY12_FR | |
SYS_NC00055$ | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
SYS_NC00051$ | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LD_GEN_SG_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_OPEN | Number of Open Leads |
SYS_NC00053$ | |
LEADS_CHANGED | Number of Leads whose information has been modified |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RANK_A | Number of Leads with Rank = A |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_B | Number of Leads with Rank = B |
SYS_NC00052$ | |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
DUMMY2_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
DUMMY13_FR | |
SYS_NC00051$ | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
SYS_NC00054$ | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
LEADS | Number of leads |
SYS_NC00050$ | |
LEADS_NEW | Number of New Leads |
Application Object Library - BIM_I_LD_QUAL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00056$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_NEW | Number of New Leads |
SYS_NC00050$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_A | Number of Leads with Rank = A |
SYS_NC00052$ | |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
LEAD_RANK_ID | Ranking ID for the lead generated |
DUMMY12_FR | |
SYS_NC00055$ | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
SYS_NC00051$ | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LD_REGN_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00056$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_NEW | Number of New Leads |
SYS_NC00050$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_A | Number of Leads with Rank = A |
SYS_NC00052$ | |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
LEAD_COUNTRY | Country associated with lead |
DUMMY12_FR | |
SYS_NC00055$ | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
SYS_NC00051$ | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LD_SRC_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00056$ | |
UMARK | Required for mvs using Union All for fast Refreshability. This column is for internal purposes only |
LEADS_NEW | Number of New Leads |
SYS_NC00050$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
RANK_A | Number of Leads with Rank = A |
SYS_NC00052$ | |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
LEAD_SOURCE | Source system of the lead |
DUMMY12_FR | |
SYS_NC00055$ | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
SYS_NC00051$ | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LP_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00059$ | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_NEW | Number of New Leads |
SYS_NC00057$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
SYS_NC00056$ | |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
LEADS_A | |
SYS_NC00052$ | |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
CHANNEL_CODE | Id of the sales channel of the leads |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
DUMMY11_FR | |
SYS_NC00055$ | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
DUMMY21_FR | |
DUMMY22_FR | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
SYS_NC00058$ | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LP_CCAT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00059$ | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_NEW | Number of New Leads |
SYS_NC00057$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
SYS_NC00056$ | |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
LEADS_A | |
SYS_NC00052$ | |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
CUST_CATEGORY | Industry of the lead |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
DUMMY11_FR | |
SYS_NC00055$ | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
DUMMY21_FR | |
DUMMY22_FR | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
SYS_NC00058$ | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LP_GEN_SG_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00059$ | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_NEW | Number of New Leads |
SYS_NC00057$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
SYS_NC00056$ | |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
LEADS_A | |
SYS_NC00052$ | |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
DUMMY11_FR | |
SYS_NC00055$ | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
DUMMY21_FR | |
DUMMY22_FR | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00058$ | |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
ITEM_ID | |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_I_LP_SRC_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00059$ | |
GROUP_ID | |
LEADS_NEW | |
SYS_NC00057$ | |
LEADS_OPEN | |
LEADS_CHANGED | |
SYS_NC00053$ | |
LEADS_CONVERTED | |
CONVERSION_TIME | |
SYS_NC00056$ | |
LEADS_DEAD | |
LEADS_CLOSED | |
LEADS_QUALIFIED | |
LEADS_NEW_CONV | |
LEADS_NEW_CHANGED | |
RESOURCE_ID | |
LEADS_A | |
SYS_NC00052$ | |
RANK_A | |
RANK_B | |
RANK_C | |
RANK_D | |
RANK_Z | |
LEADS_QUALIFIED_A | |
LEAD_AMOUNT | |
ORDERS_BOOKED_AMT | |
ORDERS_INVOICED_AMT | |
LEAD_SOURCE | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
UPDATE_TIME_ID | |
DUMMY11_FR | |
SYS_NC00055$ | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
TIME_ID | |
DUMMY21_FR | |
DUMMY22_FR | |
UPDATE_PERIOD_TYPE_ID | |
SYS_NC00058$ | |
PERIOD_TYPE_ID | |
PRODUCT_CATEGORY_ID | |
SYS_NC00054$ | |
LEADS |
Application Object Library - BIM_I_LP_QUAL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00059$ | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_NEW | Number of New Leads |
SYS_NC00057$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
SYS_NC00056$ | |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
LEADS_A | |
SYS_NC00052$ | |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_RANK_ID | Rank id of the leads |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
DUMMY11_FR | |
SYS_NC00055$ | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
DUMMY21_FR | |
DUMMY22_FR | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
SYS_NC00058$ | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_LD_CAMP_SG_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00050$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
RANK_D | Number of Leads with Rank = D |
SYS_NC00052$ | |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
SOURCE_CODE_ID | Source Code ID of the Marketing Object to which this lead is attached |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
DUMMY11_FR | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
IMMEDIATE_PARENT_ID | Parent Source Code Id |
DUMMY15_FR | |
SYS_NC00048$ | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
DUMMY21_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
SYS_NC00051$ | |
LEADS | Number of leads |
LEADS_NEW | Number of New Leads |
SYS_NC00047$ | |
LEADS_OPEN | Number of Open Leads |
Application Object Library - BIM_I_MKT_CPB_MV | |
---|---|
Column Name | Descritpion |
TIME_ID | |
CHILD_OBJECT_TYPE | |
SOURCE_CODE_ID | |
TOTAL_COST | |
TOTAL_COST_FR | |
BOOKED_AMT | |
BOOKED_AMT_FR | |
INVOICED_AMT | |
INVOICED_AMT_FR | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_FR | |
PERIOD_TYPE_ID | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_FR | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_FR | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_FR | |
ACTIVITY_ID | |
BUDGET_APPROVED | |
BUDGET_APPROVED_FR | |
ACTUAL_COST | |
UMARKER | |
ACTUAL_COST_FR | |
LEADS | |
TOTAL_LEADS_FR | |
TOTAL_COST_S | |
TOTAL_COST_S_FR | |
BOOKED_AMT_S | |
BOOKED_AMT_S_FR | |
INVOICED_AMT_S | |
INVOICED_AMT_S_FR | |
WON_OPPORTUNITY_AMT_S | |
OBJECT_ID | |
WON_OPPORTUNITY_AMT_S_FR | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_FR | |
ACTUAL_COST_S | |
ACTUAL_COST_S_FR | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_FR | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_FR | |
ALL_COUNT_FR | |
OBJECT_TYPE | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
OBJECT_COUNTRY | |
CATEGORY_ID | |
OBJECT_REGION | |
CHILD_OBJECT_ID |
Application Object Library - BIM_I_OBJ_METR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00160$ | |
TIME_ID | |
LEAD_RANK_ID | |
EVEN_ENDED_C | |
SYS_NC00149$ | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
CUST_CATEGORY | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
ACTIVITY_ID | |
COST_FORECASTED_S_C | |
SYS_NC00152$ | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
BOOKED_ORDER_AMOUNT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
INVOICED_ORDER_AMOUNT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
RESPONSES_FORECASTED | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
RESPONSES_FORECASTED_C | |
DUMMY1_FR | |
SYS_NC00148$ | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
SYS_NC00151$ | |
LEADS | |
LEADS_C | |
SYS_NC00147$ | |
RANK_A | |
PERIOD_TYPE_ID | |
RANK_A_C | |
SYS_NC00150$ | |
SYS_NC00156$ | |
RANK_B | |
RANK_B_C | |
SYS_NC00146$ | |
RANK_C | |
RANK_C_C | |
SYS_NC00159$ | |
RANK_D | |
RANK_D_C | |
SYS_NC00158$ | |
RANK_Z | |
RANK_Z_C | |
SYS_NC00161$ | |
LEADS_CONVERTED | |
OBJECT_REGION | |
LEADS_CONVERTED_C | |
SYS_NC00157$ | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
OBJECT_COUNTRY | |
LEADS_NEW_C | |
SYS_NC00155$ | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
SOURCE_CODE_ID | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
IMMEDIATE_PARENT_ID | |
ORDERS_BOOKED_AMT_C | |
SYS_NC00154$ | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
COST_FORECASTED | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
CATEGORY_ID | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
LEAD_SOURCE | |
WON_OPPORTUNITY_AMT_C | |
SYS_NC00153$ | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CHANNEL_CODE | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED |
Application Object Library - BIM_I_LP_REGN_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00059$ | |
GROUP_ID | Group ID of the Salesrep Attached to the lead |
LEADS_NEW | Number of New Leads |
SYS_NC00057$ | |
LEADS_OPEN | Number of Open Leads |
LEADS_CHANGED | Number of Leads whose information has been modified |
SYS_NC00053$ | |
LEADS_CONVERTED | Number of Leads converted to Opportunity |
CONVERSION_TIME | Time difference between Lead Creation Date and Lead Conversion Date |
SYS_NC00056$ | |
LEADS_DEAD | Number of Leads with status = DEAD |
LEADS_CLOSED | Number of Leads with status = CLOSED |
LEADS_QUALIFIED | Number of Qualified Leads |
LEADS_NEW_CONV | Number of new Leads converted to Opportunity |
LEADS_NEW_CHANGED | Number of new Leads whose information has been modified |
RESOURCE_ID | Resource ID of the Salesrep Attached to the lead |
LEADS_A | |
SYS_NC00052$ | |
RANK_A | Number of Leads with Rank = A |
RANK_B | Number of Leads with Rank = B |
RANK_C | Number of Leads with Rank = C |
RANK_D | Number of Leads with Rank = D |
RANK_Z | Number of Leads with Rank other than A,B,C and D |
LEADS_QUALIFIED_A | Number of Qualified Hot Leads |
LEAD_AMOUNT | Total Amount available with the lead to make the deal |
ORDERS_BOOKED_AMT | Booked Order Amount |
ORDERS_INVOICED_AMT | Invoiced Order Amount |
LEAD_COUNTRY | Id of the country asscociated with leads |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
DUMMY7_FR | |
DUMMY8_FR | |
DUMMY9_FR | |
DUMMY10_FR | |
UPDATE_TIME_ID | The time id which derived from fii_time_day on the basis of ead_creation_date and lead_converted_date. It represents id of day/week/period/qtr/year. Update_time_id is used to calculate count of leads created and converted in the same perio |
DUMMY11_FR | |
SYS_NC00055$ | |
DUMMY12_FR | |
DUMMY13_FR | |
DUMMY14_FR | |
DUMMY15_FR | |
DUMMY16_FR | |
DUMMY17_FR | |
DUMMY18_FR | |
DUMMY19_FR | |
DUMMY20_FR | |
TIME_ID | The time id which derived from fii_time_day on the basis of transaction_create_date and rolluptype. It represents id of day/week/period/qtr/year |
DUMMY21_FR | |
DUMMY22_FR | |
UPDATE_PERIOD_TYPE_ID | update_period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64. |
SYS_NC00058$ | |
PERIOD_TYPE_ID | period_type_id is used to represents rollup type i.e day/week/period/qtr/year.The value stores in this column to represents day/week/period/qtr/year are 1/16/32/64 |
PRODUCT_CATEGORY_ID | Product category id assigned to the lead lines |
SYS_NC00054$ | |
LEADS | Number of leads |
Application Object Library - BIM_MKT_KPI_F_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TRANSACTION_CREATE_DATE | |
LEAD_CREATION_DATE | |
EVEN_SCH_ENDED | |
SYS_NC00143$ | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
LEAD_CONVERTED_DATE | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
LEADS | |
BOOKED_ORDER_AMOUNT_S | |
SYS_NC00133$ | |
BOOKED_ORDER_AMOUNT_S_C | |
INVOICED_ORDER_AMOUNT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
LEADS_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_A | |
SYS_NC00139$ | |
RANK_A_C | |
RANK_B | |
SYS_NC00142$ | |
RANK_B_C | |
RANK_C | |
SYS_NC00138$ | |
RANK_C_C | |
OBJECT_REGION | |
RANK_D | |
SYS_NC00141$ | |
SYS_NC00140$ | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
OBJECT_COUNTRY | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
CATEGORY_ID | |
LEADS_PROSPECT | |
SYS_NC00136$ | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
LEADS_QUALIFIED_A_C | |
LEAD_SOURCE | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVEC | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
CHANNEL_CODE | |
COST_FORECASTED | |
SYS_NC00135$ | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
LEAD_RANK_ID | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
CUST_CATEGORY | |
OPEN_OPPORTUNITY_AMT | |
SYS_NC00134$ | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
ACTIVITY_ID | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C |
Application Object Library - BIM_OBJ_LD_CCAT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00140$ | |
TIME_ID | |
CATEGORY_ID_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00143$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RESPONSES_FORECASTED | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RESPONSES_FORECASTED_C | |
COST_ACTUAL_S_C | |
SYS_NC00139$ | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RESPONSES_POSITIVE | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
RESPONSES_POSITIVE_C | |
SYS_NC00142$ | |
LEADS | |
LEADS_C | |
SYS_NC00141$ | |
RANK_A | |
RANK_A_C | |
RANK_B | |
PERIOD_TYPE_ID | |
RANK_B_C | |
SYS_NC00147$ | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
OBJECT_COUNTRY | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
OBJECT_COUNTRY_C | |
LEADS_CHANGED_C | |
SYS_NC00146$ | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
SOURCE_CODE_ID | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
OBJECT_REGION | |
ORDERS_INVOICED_AMT_C | |
SYS_NC00145$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
CUST_CATEGORY | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
IMMEDIATE_PARENT_ID | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00144$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
CATEGORY_ID | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_I_CPB_METR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
TOTAL_LEADS_C | |
SYS_NC00050$ | |
TOTAL_COST | |
TOTAL_COST_C | |
SYS_NC00053$ | |
BOOKED_AMT | |
BOOKED_AMT_C | |
SYS_NC00046$ | |
INVOICED_AMT | |
INVOICED_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
BUDGET_APPROVED | |
PERIOD_TYPE_ID | |
BUDGET_APPROVED_C | |
SYS_NC00052$ | |
ACTUAL_COST | |
ACTUAL_COST_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
TOTAL_COST_S | |
SOURCE_CODE_ID | |
TOTAL_COST_S_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
ACTUAL_COST_S | |
IMMEDIATE_PARENT_ID | |
ACTUAL_COST_S_C | |
SYS_NC00048$ | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
OBJECT_REGION | |
OBJECT_COUNTRY | |
SYS_NC00051$ | |
CATEGORY_ID | |
ACTIVITY_ID | |
SYS_NC00047$ | |
TOTAL_LEADS |
Application Object Library - BIM_I_MKT_CRPL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
TIME_ID | |
TOTAL_COST | |
TOTAL_COST_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
ACTUAL_COST | |
ACTUAL_COST_C | |
BOOKED_AMT | |
BOOKED_AMT_C | |
INVOICED_AMT | |
INVOICED_AMT_C | |
PERIOD_TYPE_ID | |
WON_OPPORTUNITY_AMT | |
SYS_NC00039$ | |
WON_OPPORTUNITY_AMT_C | |
TOTAL_COST_S | |
TOTAL_COST_S_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
ADMIN_FLAG | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
ACTUAL_COST_S | |
ACTUAL_COST_S_C | |
ALL_C | |
GROUPING_ID | |
OBJECT_COUNTRY | |
SYS_NC00038$ | |
OBJECT_COUNTRY_C | |
CATEGORY_ID | |
SYS_NC00037$ | |
CATEGORY_ID_C | |
TOTAL_LEADS | |
SYS_NC00040$ | |
TOTAL_LEADS_C |
Application Object Library - BIM_OBJ_LD_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00140$ | |
TIME_ID | |
CATEGORY_ID_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00143$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RESPONSES_FORECASTED | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RESPONSES_FORECASTED_C | |
COST_ACTUAL_S_C | |
SYS_NC00139$ | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RESPONSES_POSITIVE | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
RESPONSES_POSITIVE_C | |
SYS_NC00142$ | |
LEADS | |
LEADS_C | |
SYS_NC00141$ | |
RANK_A | |
RANK_A_C | |
RANK_B | |
PERIOD_TYPE_ID | |
RANK_B_C | |
SYS_NC00147$ | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
OBJECT_COUNTRY | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
OBJECT_COUNTRY_C | |
LEADS_CHANGED_C | |
SYS_NC00146$ | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
SOURCE_CODE_ID | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
OBJECT_REGION | |
ORDERS_INVOICED_AMT_C | |
SYS_NC00145$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
CHANNEL_CODE | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
IMMEDIATE_PARENT_ID | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00144$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
CATEGORY_ID | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_OBJ_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00140$ | |
TIME_ID | |
RESPONSES_FORECASTED | |
EVEN_SCH_ENDED | |
SYS_NC00142$ | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
RESPONSES_FORECASTED_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
RESPONSES_POSITIVE | |
ORDERS_BOOKED_AMT_S | |
SYS_NC00138$ | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
RESPONSES_POSITIVE_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
LEADS | |
SYS_NC00141$ | |
LEADS_C | |
RANK_A | |
RANK_A_C | |
RANK_B | |
RANK_B_C | |
PERIOD_TYPE_ID | |
RANK_C | |
SYS_NC00145$ | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
OBJECT_COUNTRY | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
OBJECT_COUNTRY_C | |
LEADS_DEAD | |
SYS_NC00144$ | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
SOURCE_CODE_ID | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
IMMEDIATE_PARENT_ID | |
COST_FORECASTED | |
SYS_NC00143$ | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
CATEGORY_ID | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
CATEGORY_ID_C | |
OPEN_OPPORTUNITY_AMT | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
ACTIVITY_ID | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C |
Application Object Library - BIM_I_OBJ_METS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
RESPONSES_FORECASTED_C | |
EVEN_SCH_ENDED_C | |
SYS_NC00138$ | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
RESPONSES_POSITIVE | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
ORDERS_BOOKED_AMT_S | |
RESPONSES_POSITIVE_C | |
BOOKED_ORDER_AMOUNT_S_C | |
SYS_NC00141$ | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
LEADS | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
LEADS_C | |
RANK_A | |
RANK_A_C | |
RANK_B | |
RANK_B_C | |
RANK_C | |
PERIOD_TYPE_ID | |
RANK_C_C | |
SYS_NC00140$ | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
OBJECT_COUNTRY | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
OBJECT_COUNTRY_C | |
LEADS_DEAD_C | |
SYS_NC00143$ | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
SOURCE_CODE_ID | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
COST_FORECASTED | |
IMMEDIATE_PARENT_ID | |
COST_FORECASTED_C | |
SYS_NC00139$ | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
CATEGORY_ID | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
OPEN_OPPORTUNITY_AMT | |
CATEGORY_ID_C | |
OPEN_OPPORTUNITY_AMT_C | |
SYS_NC00142$ | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
RESPONSES_FORECASTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C | |
EVEN_SCH_ENDED |
Application Object Library - BIM_MKT_KPI_INT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00143$ | |
TIME_ID | |
CUST_CATEGORY | |
CAMP_SCH_ENDED | |
SYS_NC00149$ | |
CAMP_SCH_ENDED_C | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
ACTIVITY_ID | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
LEADS | |
COST_ACTUAL_S | |
SYS_NC00152$ | |
COST_ACTUAL_S_C | |
BOOKED_ORDER_AMOUNT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
INVOICED_ORDER_AMOUNT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LEADS_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
DUMMY1_FR | |
DUMMY2_FR | |
DUMMY3_FR | |
DUMMY4_FR | |
DUMMY5_FR | |
DUMMY6_FR | |
RANK_A | |
DUMMY7_FR | |
SYS_NC00148$ | |
DUMMY8_FR | |
ALL_C | |
RANK_A_C | |
RANK_B | |
SYS_NC00151$ | |
RANK_B_C | |
RANK_C | |
SYS_NC00147$ | |
RANK_C_C | |
PERIOD_TYPE_ID | |
RANK_D | |
SYS_NC00150$ | |
SYS_NC00156$ | |
RANK_D_C | |
RANK_Z | |
SYS_NC00146$ | |
RANK_Z_C | |
LEADS_CONVERTED | |
SYS_NC00145$ | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
SYS_NC00144$ | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
OBJECT_REGION | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER | |
SYS_NC00155$ | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
CATEGORY_ID | |
LEADS_QUALIFIED_A | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
PARENT_CATEGORY_ID | |
COST_ACTUAL | |
SYS_NC00154$ | |
COST_ACTUAL_C | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
LEAD_SOURCE | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
CHANNEL_CODE | |
LOST_OPPORTUNITY_AMT | |
SYS_NC00153$ | |
LOST_OPPORTUNITY_AMT_C | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
LEAD_RANK_ID | |
EVEN_STARTED | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C |
Application Object Library - BIM_OBJ_LD_SRC_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00140$ | |
TIME_ID | |
CATEGORY_ID_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00143$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RESPONSES_FORECASTED | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RESPONSES_FORECASTED_C | |
COST_ACTUAL_S_C | |
SYS_NC00139$ | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RESPONSES_POSITIVE | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
RESPONSES_POSITIVE_C | |
SYS_NC00142$ | |
LEADS | |
LEADS_C | |
SYS_NC00141$ | |
RANK_A | |
RANK_A_C | |
RANK_B | |
PERIOD_TYPE_ID | |
RANK_B_C | |
SYS_NC00147$ | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
OBJECT_COUNTRY | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
OBJECT_COUNTRY_C | |
LEADS_CHANGED_C | |
SYS_NC00146$ | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
SOURCE_CODE_ID | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
OBJECT_REGION | |
ORDERS_INVOICED_AMT_C | |
SYS_NC00145$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
LEAD_SOURCE | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
IMMEDIATE_PARENT_ID | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00144$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
CATEGORY_ID | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_OBJ_LD_QUAL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00140$ | |
TIME_ID | |
CATEGORY_ID_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00143$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RESPONSES_FORECASTED | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RESPONSES_FORECASTED_C | |
COST_ACTUAL_S_C | |
SYS_NC00139$ | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RESPONSES_POSITIVE | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
RESPONSES_POSITIVE_C | |
SYS_NC00142$ | |
LEADS | |
LEADS_C | |
SYS_NC00141$ | |
RANK_A | |
RANK_A_C | |
RANK_B | |
PERIOD_TYPE_ID | |
RANK_B_C | |
SYS_NC00147$ | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
OBJECT_COUNTRY | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
OBJECT_COUNTRY_C | |
LEADS_CHANGED_C | |
SYS_NC00146$ | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
SOURCE_CODE_ID | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
OBJECT_REGION | |
ORDERS_INVOICED_AMT_C | |
SYS_NC00145$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
LEAD_RANK_ID | |
REVENUE_FORECASTED_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
IMMEDIATE_PARENT_ID | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00144$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
CATEGORY_ID | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_OBJ_REGN_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00140$ | |
TIME_ID | |
RESPONSES_FORECASTED | |
EVEN_SCH_ENDED | |
SYS_NC00142$ | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
RESPONSES_FORECASTED_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
RESPONSES_POSITIVE | |
ORDERS_BOOKED_AMT_S | |
SYS_NC00138$ | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
RESPONSES_POSITIVE_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
LEADS | |
SYS_NC00141$ | |
LEADS_C | |
RANK_A | |
RANK_A_C | |
RANK_B | |
RANK_B_C | |
PERIOD_TYPE_ID | |
RANK_C | |
SYS_NC00145$ | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
OBJECT_COUNTRY | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
OBJECT_COUNTRY_C | |
LEADS_DEAD | |
SYS_NC00144$ | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
SOURCE_CODE_ID | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
IMMEDIATE_PARENT_ID | |
COST_FORECASTED | |
SYS_NC00143$ | |
COST_FORECASTED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
CATEGORY_ID | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
CATEGORY_ID_C | |
OPEN_OPPORTUNITY_AMT | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
OBJECT_REGION | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C |
Application Object Library - BIM_MKT_LD_CCAT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
LEADS_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00138$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RANK_A | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RANK_A_C | |
COST_ACTUAL_S_C | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RANK_B | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
PERIOD_TYPE_ID | |
RANK_Z_C | |
SYS_NC00136$ | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
CUST_CATEGORY | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER_C | |
SYS_NC00135$ | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
OBJECT_COUNTRY_C | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
CATEGORY_ID | |
COST_ACTUAL_C | |
SYS_NC00134$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
CATEGORY_ID_C | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
COL_C | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
LEADS | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_MKT_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
LEADS_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00138$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RANK_A | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RANK_A_C | |
COST_ACTUAL_S_C | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RANK_B | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
PERIOD_TYPE_ID | |
RANK_Z_C | |
SYS_NC00136$ | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
ACTIVITY_ID | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER_C | |
SYS_NC00135$ | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
OBJECT_COUNTRY_C | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
CATEGORY_ID | |
COST_ACTUAL_C | |
SYS_NC00134$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
CATEGORY_ID_C | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
COL_C | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
LEADS | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_I_CPB_METS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
TOTAL_LEADS_C | |
SYS_NC00050$ | |
TOTAL_COST | |
TOTAL_COST_C | |
SYS_NC00053$ | |
BOOKED_AMT | |
BOOKED_AMT_C | |
INVOICED_AMT | |
INVOICED_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
BUDGET_APPROVED | |
PERIOD_TYPE_ID | |
BUDGET_APPROVED_C | |
SYS_NC00052$ | |
ACTUAL_COST | |
ACTUAL_COST_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
TOTAL_COST_S | |
SOURCE_CODE_ID | |
TOTAL_COST_S_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
ACTUAL_COST_S | |
IMMEDIATE_PARENT_ID | |
ACTUAL_COST_S_C | |
SYS_NC00048$ | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
OBJECT_COUNTRY | |
OBJECT_COUNTRY_C | |
SYS_NC00051$ | |
CATEGORY_ID | |
CATEGORY_ID_C | |
SYS_NC00047$ | |
TOTAL_LEADS |
Application Object Library - BIM_I_CPB_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
TOTAL_LEADS | |
SYS_NC00047$ | |
TOTAL_LEADS_C | |
TOTAL_COST | |
SYS_NC00050$ | |
TOTAL_COST_C | |
BOOKED_AMT | |
SYS_NC00046$ | |
BOOKED_AMT_C | |
INVOICED_AMT | |
INVOICED_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
PERIOD_TYPE_ID | |
BUDGET_APPROVED | |
SYS_NC00045$ | |
BUDGET_APPROVED_C | |
ACTUAL_COST | |
ACTUAL_COST_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
SOURCE_CODE_ID | |
TOTAL_COST_S | |
TOTAL_COST_S_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
IMMEDIATE_PARENT_ID | |
ACTUAL_COST_S | |
SYS_NC00048$ | |
ACTUAL_COST_S_C | |
ALL_C | |
GROUPING_ID | |
ACTIVITY_ID | |
OBJECT_COUNTRY | |
SYS_NC00051$ | |
OBJECT_COUNTRY_C | |
CATEGORY_ID | |
SYS_NC00044$ | |
CATEGORY_ID_C |
Application Object Library - BIM_MKT_LD_CHNL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
LEADS_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00138$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RANK_A | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RANK_A_C | |
COST_ACTUAL_S_C | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RANK_B | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
PERIOD_TYPE_ID | |
RANK_Z_C | |
SYS_NC00136$ | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
CHANNEL_CODE | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER_C | |
SYS_NC00135$ | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
OBJECT_COUNTRY_C | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
CATEGORY_ID | |
COST_ACTUAL_C | |
SYS_NC00134$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
CATEGORY_ID_C | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
COL_C | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
LEADS | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_I_CPB_REGN_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
TIME_ID | |
TOTAL_LEADS | |
SYS_NC00054$ | |
TOTAL_LEADS_C | |
TOTAL_COST | |
SYS_NC00050$ | |
TOTAL_COST_C | |
BOOKED_AMT | |
SYS_NC00053$ | |
BOOKED_AMT_C | |
INVOICED_AMT | |
INVOICED_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
PERIOD_TYPE_ID | |
BUDGET_APPROVED | |
SYS_NC00052$ | |
BUDGET_APPROVED_C | |
ACTUAL_COST | |
ACTUAL_COST_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
SOURCE_CODE_ID | |
TOTAL_COST_S | |
TOTAL_COST_S_C | |
BOOKED_AMT_S | |
BOOKED_AMT_S_C | |
INVOICED_AMT_S | |
INVOICED_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
IMMEDIATE_PARENT_ID | |
ACTUAL_COST_S | |
SYS_NC00055$ | |
ACTUAL_COST_S_C | |
BUDGET_APPROVED_SCH | |
BUDGET_APPROVED_SCH_C | |
BUDGET_APPROVED_SCH_S | |
BUDGET_APPROVED_SCH_S_C | |
ALL_C | |
GROUPING_ID | |
OBJECT_REGION | |
OBJECT_COUNTRY | |
SYS_NC00048$ | |
OBJECT_COUNTRY_C | |
CATEGORY_ID | |
SYS_NC00051$ | |
CATEGORY_ID_C |
Application Object Library - BIM_MKT_KPI_CNT_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
RANK_A | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
BUDGET_REQUESTED_S_C | |
RANK_A_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
COST_ACTUAL_S_C | |
RANK_B | |
ORDERS_BOOKED_AMT_S | |
ORDERS_BOOKED_AMT_S_C | |
ORDERS_INVOICED_AMT_S | |
ORDERS_INVOICED_AMT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
LOST_OPPORTUNITY_AMT_S_C | |
RANK_B_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
RANK_Z_C | |
PERIOD_TYPE_ID | |
LEADS_CONVERTED | |
SYS_NC00136$ | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEADS_OPEN_C | |
OBJECT_COUNTRY | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
LEADS_CUSTOMER_C | |
OBJECT_COUNTRY_C | |
LEADS_PROSPECT | |
SYS_NC00135$ | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
LEADS_QUALIFIED_A_C | |
CATEGORY_ID | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
COST_ACTUAL_C | |
CATEGORY_ID_C | |
COST_FORECASTED | |
SYS_NC00134$ | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
ORDERS_INVOICED_AMT_C | |
COL_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
LOST_OPPORTUNITY_AMT_C | |
LEADS | |
OPEN_OPPORTUNITY_AMT | |
SYS_NC00133$ | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
EVEN_STARTED_C | |
LEADS_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED | |
CAMP_SCH_ENDED_C |
Application Object Library - BIM_MKT_LD_QUAL_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
LEADS_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00138$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RANK_A | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RANK_A_C | |
COST_ACTUAL_S_C | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RANK_B | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
PERIOD_TYPE_ID | |
RANK_Z_C | |
SYS_NC00136$ | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEAD_RANK_ID | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER_C | |
SYS_NC00135$ | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
OBJECT_COUNTRY_C | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
CATEGORY_ID | |
COST_ACTUAL_C | |
SYS_NC00134$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
CATEGORY_ID_C | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
COL_C | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
LEADS | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_MKT_REGN_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
LEADS_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00138$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RANK_A | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RANK_A_C | |
COST_ACTUAL_S_C | |
BOOKED_ORDER_AMOUNT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
INVOICED_ORDER_AMOUNT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RANK_B | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
PERIOD_TYPE_ID | |
RANK_Z_C | |
SYS_NC00136$ | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
OBJECT_REGION | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER_C | |
SYS_NC00135$ | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
OBJECT_COUNTRY_C | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
CATEGORY_ID | |
COST_ACTUAL_C | |
SYS_NC00134$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
CATEGORY_ID_C | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
COL_C | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
LEADS | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIM_MKT_LD_SRC_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00137$ | |
TIME_ID | |
LEADS_C | |
CAMP_SCH_ENDED_C | |
SYS_NC00138$ | |
EVEN_SCH_ENDED | |
EVEN_SCH_ENDED_C | |
REGISTRATIONS | |
REGISTRATIONS_C | |
CANCELLATIONS | |
CANCELLATIONS_C | |
ATTENDANCE | |
ATTENDANCE_C | |
BUDGET_REQUESTED_S | |
RANK_A | |
BUDGET_REQUESTED_S_C | |
BUDGET_APPROVED_S | |
BUDGET_APPROVED_S_C | |
REVENUE_FORECASTED_S | |
REVENUE_FORECASTED_S_C | |
REVENUE_ACTUAL_S | |
REVENUE_ACTUAL_S_C | |
COST_FORECASTED_S | |
COST_FORECASTED_S_C | |
COST_ACTUAL_S | |
RANK_A_C | |
COST_ACTUAL_S_C | |
ORDERS_BOOKED_AMT_S | |
BOOKED_ORDER_AMOUNT_S_C | |
ORDERS_INVOICED_AMT_S | |
INVOICED_ORDER_AMOUNT_S_C | |
NEW_OPPORTUNITY_AMT_S | |
NEW_OPPORTUNITY_AMT_S_C | |
WON_OPPORTUNITY_AMT_S | |
WON_OPPORTUNITY_AMT_S_C | |
LOST_OPPORTUNITY_AMT_S | |
RANK_B | |
LOST_OPPORTUNITY_AMT_S_C | |
OPEN_OPPORTUNITY_AMT_S | |
OPEN_OPPORTUNITY_AMT_S_C | |
ALL_C | |
RANK_B_C | |
RANK_C | |
RANK_C_C | |
RANK_D | |
RANK_D_C | |
RANK_Z | |
PERIOD_TYPE_ID | |
RANK_Z_C | |
SYS_NC00136$ | |
LEADS_CONVERTED | |
LEADS_CONVERTED_C | |
LEADS_CONVERSION_TIME | |
LEADS_CONVERSION_TIME_C | |
ALEADS_CONVERTED | |
ALEADS_CONVERTED_C | |
ALEADS_CONVERSION_TIME | |
ALEADS_CONVERSION_TIME_C | |
LEADS_OPEN | |
LEAD_SOURCE | |
LEADS_OPEN_C | |
LEADS_NEW | |
LEADS_NEW_C | |
LEADS_CHANGED | |
LEADS_CHANGED_C | |
LEADS_DEAD | |
LEADS_DEAD_C | |
LEADS_CLOSED | |
LEADS_CLOSED_C | |
LEADS_CUSTOMER | |
OBJECT_COUNTRY | |
LEADS_CUSTOMER_C | |
SYS_NC00135$ | |
LEADS_PROSPECT | |
LEADS_PROSPECT_C | |
LEADS_CONV_CUSTOMER | |
LEADS_CONV_CUSTOMER_C | |
LEADS_CONV_PROSPECT | |
LEADS_CONV_PROSPECT_C | |
LEADS_QUALIFIED | |
LEADS_QUALIFIED_C | |
LEADS_QUALIFIED_A | |
OBJECT_COUNTRY_C | |
LEADS_QUALIFIED_A_C | |
RESPONSES_POSITIVE | |
RESPONSES_POSITIVE_C | |
RESPONSES_FORECASTED | |
RESPONSES_FORECASTED_C | |
ORDERS_BOOKED | |
ORDERS_BOOKED_C | |
CUSTOMERS_TARGETED | |
CUSTOMERS_TARGETED_C | |
COST_ACTUAL | |
CATEGORY_ID | |
COST_ACTUAL_C | |
SYS_NC00134$ | |
COST_FORECASTED | |
COST_FORECASTED_C | |
BUDGET_APPROVED | |
BUDGET_APPROVED_C | |
BUDGET_REQUESTED | |
BUDGET_REQUESTED_C | |
ORDERS_BOOKED_AMT | |
ORDERS_BOOKED_AMT_C | |
ORDERS_INVOICED_AMT | |
CATEGORY_ID_C | |
ORDERS_INVOICED_AMT_C | |
REVENUE_ACTUAL | |
REVENUE_ACTUAL_C | |
REVENUE_FORECASTED | |
REVENUE_FORECASTED_C | |
NEW_OPPORTUNITY_AMT | |
NEW_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_AMT | |
WON_OPPORTUNITY_AMT_C | |
LOST_OPPORTUNITY_AMT | |
COL_C | |
LOST_OPPORTUNITY_AMT_C | |
SYS_NC00139$ | |
OPEN_OPPORTUNITY_AMT | |
OPEN_OPPORTUNITY_AMT_C | |
WON_OPPORTUNITY_CNT | |
WON_OPPORTUNITY_CNT_C | |
LOST_OPPORTUNITY_CNT | |
LOST_OPPORTUNITY_CNT_C | |
CAMP_STARTED | |
CAMP_STARTED_C | |
EVEN_STARTED | |
LEADS | |
EVEN_STARTED_C | |
CAMP_SCH_STARTED | |
CAMP_SCH_STARTED_C | |
EVEN_SCH_STARTED | |
EVEN_SCH_STARTED_C | |
CAMP_ENDED | |
CAMP_ENDED_C | |
EVEN_ENDED | |
EVEN_ENDED_C | |
CAMP_SCH_ENDED |
Application Object Library - BIX_AO_CALL_DETAILS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00101$ | |
G_ID | Grouping Set identifier |
SCHEDULE_ID | Campaign Schedule id for which call information is summarized |
SYS_NC00105$ | |
SOURCE_CODE_ID | Source Code id of the Campaign/Campaign Schedule id for which call information is summarized |
DIALING_METHOD | Dialing method of the outbound calls (Predictive,Preview or Progressive) |
SYS_NC00093$ | |
OUTCOME_ID | Outcome id for which call information is summarized |
RESULT_ID | Result id for which call information is summarized |
SYS_NC00099$ | |
REASON_ID | Reason id for which call information is summarized |
CALL_CALLS_OFFERED_TOTAL | Total number of inbound calls |
SYS_NC00104$ | |
CALLS_OFFERED_TOTAL_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CALLS_OFFERED_ABOVE_TH | Number of calls offered excluding the shortcalls |
SYS_NC00098$ | |
CALLS_OFFERED_ABOVE_TH_XCNT | Mandatory Column for enabling fast refresh of MV |
ROW_TYPE | Summarization level identifier to distinguish between the different grouping sets |
CALL_CALLS_HANDLED_TOTAL | Total number of calls answered by agents |
SYS_NC00103$ | |
SYS_NC00095$ | |
CALLS_HANDLED_TOTAL_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CALLS_HANDLED_ABOVE_TH | Number of calls answered by agents, where the call duration is greater than pre-defined threshold (profile value) |
SYS_NC00097$ | |
CALLS_HANDLED_ABOVE_TH_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CALLS_ABANDONED | Number of calls which were not handled by an agent (abandoned in queue) |
SYS_NC00102$ | |
CALLS_ABANDONED_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CALLS_ABANDONED_US | Number of calls which are considered to be abandoned, as per FTC regulations |
SYS_NC00096$ | |
CALLS_ABANDONED_US_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CALLS_TRANSFERRED | Number of calls transferred |
CALLS_TRANSFERRED_XCNT | Mandatory Column for enabling fast refresh of MV |
TIME_ID | Foreign key to time dimension |
CALL_IVR_TIME | Amount of time spent in IVR |
IVR_TIME_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_ROUTE_TIME | Amount of time that was spent in ROUTING |
ROUTE_TIME_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_QUEUE_TIME | Amount of time that was spent in queue |
QUEUE_TIME_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_TOT_QUEUE_TO_ABANDON | Total amount of time spent in queue for abandoned calls |
TOT_QUEUE_TO_ABANDON_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_TOT_QUEUE_TO_ANSWER | Total amount of time spent in queue for handled calls |
TOT_QUEUE_TO_ANSWER_XCNT | Mandatory Column for enabling fast refresh of MV |
PERIOD_TYPE_ID | Identifies the period type (day, week,month, quarter, year) |
CALL_TALK_TIME | Amount of time that was spent talking on calls |
SYS_NC00100$ | |
TALK_TIME_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CONT_CALLS_OFFERED_NA | Number of offered calls which continued from the previous time bucket |
CONT_CALLS_OFFERED_NA_XCNT | Mandatory Column for enabling fast refresh of MV |
CALL_CONT_CALLS_HANDLED_TOT_NA | Number of handled calls which continued from the previous time bucket |
CONT_CALLS_HANDLED_TOT_NA_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_TALK_TIME_NAC | Amount of time spent by the resource in talking |
TALK_TIME_NAC_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_WRAP_TIME_NAC | Amount of time spent by the resource in wrapping up the interaction |
WRAP_TIME_NAC_XCNT | Mandatory Column for enabling fast refresh of MV |
PERIOD_START_DATE | Start date of the period for which call information is summarized |
AGENT_CALLS_TRAN_CONF_TO_NAC | Number of calls in which the agent was transferred-in or conferenced-in to a call |
CALLS_TRAN_CONF_TO_NAC_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_CALLS_HANDLED_TOTAL | Total number of calls handled by the agent |
AGENT_HANDLED_TOTAL_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_CALLS_HANDLED_ABOVE_TH | Number of calls handled by the agent where the call duration was more than the threshold value |
AGENT_HANDLED_ABOVE_TH_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_CALLS_ANSWERED_BY_GOAL | Number of calls handled by the agent where the call was answered within the servicelevel goal |
AGENT_ANSWERED_BY_GOAL_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_SR_CREATED | Number of service requests created by the agent |
SR_CREATED_XCNT | Mandatory Column for enabling fast refresh of MV |
SERVER_GROUP_ID | Call Center for which call information is summarized |
AGENT_LEADS_CREATED | Number of leads created by the agent |
SYS_NC00106$ | |
LEADS_CREATED_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_LEADS_AMOUNT | Amount of leads created by the agent |
LEADS_AMOUNT_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_LEADS_CONVERTED_TO_OPP | N/A (future release) |
LEADS_CONVERTED_TO_OPP_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_OPPORTUNITIES_CREATED | Number of opportunities created by the agent |
OPPORTUNITIES_CREATED_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_OPPORTUNITIES_WON | Number of opportunities won by the agent |
OPPORTUNITIES_WON_XCNT | Mandatory Column for enabling fast refresh of MV |
RESOURCE_ID | Resource Id for which call information is summarized |
AGENT_OPPORTUNITIES_WON_AMOUNT | Amount of the opportunities won by the agent |
OPPORTUNITIES_WON_AMOUNT_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_OPPORTUNITIES_CROSS_SOLD | N/A (future release) |
OPPORTUNITIES_CROSS_SOLD_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_OPPORTUNITIES_UP_SOLD | N/A (future release) |
OPPORTUNITIES_UP_SOLD_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_OPPORTUNITIES_DECLINED | N/A (future release) |
OPPORTUNITIES_DECLINED_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_OPPORTUNITIES_LOST | N/A (future release) |
OPPORTUNITIES_LOST_XCNT | Mandatory Column for enabling fast refresh of MV |
PARTY_ID | Customer id for which call information is summarized |
AGENT_PREVIEW_TIME | N/A (future release) |
SYS_NC00094$ | |
PREVIEW_TIME_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENTCALL_ORR_COUNT | Count of the outcome, result, and reason combination for the agent |
CALL_ORR_COUNT_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENTCALL_PR_COUNT | Count of positive responses in interactions handled by the agent |
CALL_PR_COUNT_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENTCALL_CONTACT_COUNT | Count of the contact outcomes in interactions handled by the agent |
CALL_CONTACT_COUNT_XCNT | Mandatory Column for enabling fast refresh of MV |
AGENT_CONT_CALLS_HAND_NA | Number of calls handled by the agent which continued from the previous time bucket |
CONT_CALLS_HAND_NA_XCNT | Mandatory Column for enabling fast refresh of MV |
CAMPAIGN_ID | Campaign id for which call information is summarized |
AGENT_CONT_CALLS_TC_NA | Number of calls transferred to the agent which continued from the previous time bucket |
CONT_CALLS_TC_NA_XCNT | Mandatory Column for enabling fast refresh of MV |
XCNT | Mandatory Column for enabling fast refresh of MV |
Application Object Library - BIL_OBI_PIPE_G_MV | |
---|---|
Column Name | Descritpion |
UMARKER | Required for MVs using Union All for fast refreshability. |
WTD_PIPELINE_AMT | Sum of total weighted pipeline amounts if the opty is closed in the same period in primary currency. |
OPEN_AMT | Sum of open amounts if the opty is closed in the same period in primary currency. |
PERIOD_OPEN_AMT | Sum of open amounts at the start date of the period for those opty having close date in the same period in primary currency. |
PIPELINE_AMT_S | Sum of pipeline amounts if the opty is closed in the same period in secondary currency. |
WTD_PIPELINE_AMT_S | Sum of total weighted pipeline amounts if the opty is closed in the same period in secondary currency. |
OPEN_AMT_S | Sum of open amounts if the opty is closed in the same period in secondary currency. |
PERIOD_OPEN_AMT_S | Sum of open amounts at the start date of the period for those opty having close date in the same period in secondary currency. |
PIPELINE_AMT_XCNT | Dummy count column required to create fast refresh MV |
WTD_PIPELINE_AMT_XCNT | Dummy count column required to create fast refresh MV |
OPEN_AMT_XCNT | Dummy count column required to create fast refresh MV |
PARENT_SALES_GROUP_ID | Parent group identifier for the sales group. |
PERIOD_OPEN_AMT_XCNT | Dummy count column required to create fast refresh MV |
PIPELINE_AMT_XCNT_S | Dummy count column required to create fast refresh MV |
WTD_PIPELINE_AMT_XCNT_S | Dummy count column required to create fast refresh MV |
OPEN_AMT_XCNT_S | Dummy count column required to create fast refresh MV |
PERIOD_OPEN_AMT_XCNT_S | Dummy count column required to create fast refresh MV |
XCNT | Dummy count column required to create fast refresh MV |
SALES_GROUP_ID | Sales group identifier who gets the sales credits. |
SALESREP_ID | Salesperson or resource identifier who gets sales credits. Will never be null. |
EFFECTIVE_TIME_ID | Effective date rolled up over day, week, period, quarter, year to display pipeline data for period end |
PRODUCT_CATEGORY_ID | The product category to which the item in this sales credit line belongs to. |
ITEM_ID | The concatenated value of item and the master org id. If the opportunity line is assigned to category then -1. |
ROLLUP_FLAG | Flag to distinguish between rollup and non-rolled up amount |
PIPELINE_AMT | Sum of pipeline amounts if the opty is closed in the same period in primary currency. |
Application Object Library - BIL_OBI_OPTY_PG_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
EFFECTIVE_TIME_ID | Effective date rolled up over day, week, period, quarter, year. Effective date is opportunity creation date for new opportunity, conversion date for converted from leads, close date for rest of the measures. |
WON_OPTY_AMT | Sales credit amount If the opportunity has been WON in primary currency. |
SYS_NC00057$ | |
WON_OPTY_AMT_S | Sales credit amount If the opportunity has been WON in secondary currency . |
LOST_OPTY_AMT | Sales credit amount If the opportunity has been LOST in primary currency. |
SYS_NC00050$ | |
LOST_OPTY_AMT_S | Sales credit amount If the opportunity has been LOST in secondary currency. |
NO_OPTY_AMT | Sales credit amount If the opportunity has been NO OPPORTUNITY in primary currency. |
SYS_NC00053$ | |
NO_OPTY_AMT_S | Sales credit amount If the opportunity has been NO OPPORTUNITY in secondary currency. |
CNV_OPTY_AMT | Sales credit amount If the opportunity has been Linked to / converted from a lead in primary currency |
SYS_NC00056$ | |
CNV_OPTY_AMT_S | Sales credit amount If the opportunity has been Linked to / converted from a lead in secondary currency |
NFP_YR | Sum of sales credit if the opty is created and closed in the same year in primary currency |
NFP_YR_S | Sum of sales credit if the opty is created and closed in the same year in secondary currency |
PARENT_SALES_GROUP_ID | The parent of the sales group appearing in the sales_group_id column |
NFP_QTR | Sum of sales credit if the opty is created and closed in the same quarter in primary currency |
SYS_NC00052$ | |
NFP_QTR_S | Sum of sales credit if the opty is created and closed in the same quarter in secondary currency |
NFP_PER | Sum of sales credit if the opty is created and closed in the same period in primary currency |
NFP_PER_S | Sum of sales credit if the opty is created and closed in the same period in secondary currency |
NFP_WK | Sum of sales credit if the opty is created and closed in the same week in primary currency |
NFP_WK_S | Sum of sales credit if the opty is created and closed in the same week in secondary currency |
NEW_OPTY_XCNT | Dummy count column required to create fast refresh MV |
NEW_OPTY_XCNT_S | Dummy count column required to create fast refresh MV |
WON_OPTY_XCNT | Dummy count column required to create fast refresh MV |
WON_OPTY_XCNT_S | Dummy count column required to create fast refresh MV |
SALES_GROUP_ID | Sales group identifier who get the sales credits |
LOST_OPTY_XCNT | Dummy count column required to create fast refresh MV |
LOST_OPTY_XCNT_S | Dummy count column required to create fast refresh MV |
NO_OPTY_XCNT | Dummy count column required to create fast refresh MV |
NO_OPTY_XCNT_S | Dummy count column required to create fast refresh MV |
CNV_OPTY_AMT_XCNT | Dummy count column required to create fast refresh MV |
CNV_OPTY_AMT_XCNT_S | Dummy count column required to create fast refresh MV |
NFP_YR_XCNT | Dummy count column required to create fast refresh MV |
NFP_YR_XCNT_S | Dummy count column required to create fast refresh MV |
NFP_QTR_XCNT | Dummy count column required to create fast refresh MV |
NFP_QTR_XCNT_S | Dummy count column required to create fast refresh MV |
SALESREP_ID | Salesperson or resource identifier who gets sales credits. For sales group rollup, this column has a value of NULL |
NFP_PER_XCNT | Dummy count column required to create fast refresh MV |
SYS_NC00055$ | |
NFP_PER_XCNT_S | Dummy count column required to create fast refresh MV |
NFP_WK_XCNT | Dummy count column required to create fast refresh MV |
NFP_WK_XCNT_S | Dummy count column required to create fast refresh MV |
ALL_XCNT | Dummy count column required to create fast refresh MV |
ENT_YEAR_ID | Columns like ent_yr_id,grouping_id( |
ENT_QTR_ID | Columns like ent_yr_id,grouping_id( |
ENT_PERIOD_ID | Columns like ent_yr_id,grouping_id( |
XGRP | Columns like ent_yr_id,grouping_id( |
PRODUCT_CATEGORY_ID | The product category to which the item in this sales credit line belongs to |
ITEM_ID | NULL for valid items and -1 for rows in assigned to category union all |
SYS_NC00051$ | |
ROLLUP_FLAG | Flag to distinguish between rollup and non-rolled up amount |
NEW_OPTY_AMT | Amount of any created opportunity in primary currency |
SYS_NC00054$ | |
NEW_OPTY_AMT_S | Amount of any created opportunity in secondary currency |
Application Object Library - BIL_OBI_FST_PG_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
TXN_TIME_ID | Transaction date is Last update date representing As-of-date. |
FORECAST_AMT | My Forecast Amounts in primary currency. |
SYS_NC00034$ | |
FORECAST_AMT_S | My Forecast Amounts in secondary currency. |
FORECAST_AMT_SUB | Forecast Amount for my Subordinates in primary currency. |
SYS_NC00029$ | |
FORECAST_AMT_SUB_S | Forecast Amount for my Subordinates in secondary currency. |
OPP_FORECAST_AMT | Opportunity forecast amount in primary currency. |
SYS_NC00032$ | |
OPP_FORECAST_AMT_S | Opportunity forecast amount in secondary currency. |
OPP_FORECAST_AMT_SUB | Opportunity forecast amount in primary currency for subordinates. |
SYS_NC00035$ | |
OPP_FORECAST_AMT_SUB_S | Opportunity forecast amount in secondary currency for subordinates. |
FORECAST_AMT_XCNT | Dummy count column required to create fast refresh MV |
FORECAST_AMT_XCNT_S | Dummy count column required to create fast refresh MV |
TXN_PERIOD_TYPE_ID | Period type of txn_time_id. Valid period type in BIS Enterprise calendar. |
FORECAST_AMT_SUB_XCNT | Dummy count column required to create fast refresh MV |
SYS_NC00030$ | |
FORECAST_AMT_SUB_XCNT_S | Dummy count column required to create fast refresh MV |
OPP_FORECAST_AMT_XCNT | Dummy count column required to create fast refresh MV |
OPP_FORECAST_AMT_S_XCNT | Dummy count column required to create fast refresh MV |
OPP_FORECAST_AMT_SUB_XCNT | Dummy count column required to create fast refresh MV |
OPP_FORECAST_AMT_SUB_S_XCNT | Dummy count column required to create fast refresh MV |
ALL_XCNT | Dummy count column required to create fast refresh MV |
EFFECTIVE_TIME_ID | Effective date rolled up over week, period, quarter, year. |
EFFECTIVE_PERIOD_TYPE_ID | Period type of effective_time_id. Valid period type in BIS Enterprise calendar. |
SYS_NC00033$ | |
PARENT_SALES_GROUP_ID | Parent sales group identifier. |
SALES_GROUP_ID | Sales group identifier. |
SYS_NC00028$ | |
SALESREP_ID | Salesperson or resource identifier. |
PRODUCT_CATEGORY_ID | Identifier of Product Category. |
SYS_NC00031$ | |
CREDIT_TYPE_ID | Identifier of Forecast Credit Type. |
Application Object Library - AR_IL_CASH_RECEIPTS_GT | This is a global temporary table, used for israeli receipt printing program. |
---|---|
Column Name | Descritpion |
CASH_RECEIPT_ID | Cash Receipt Id |
MATURITY_DATE | Maturity Date |
METHOD_NAME | Method Name |
BANK_ACCOUNT | |
BANK_NAME | Bank Name |
BANK_BRANCH_NAME | Bank Branch Name |
CUSTOMER_NAME | Customer Name |
CUSTOMER_NUMBER | Customer Number |
TAX_REGISTRATION_NUMBER | Tax Registration Number |
CUST_ACCOUNT_ID | Customer Account Id |
CUST_ACCT_SITE_ID | Customer Account Site Id |
RECEIPT_NUMBER | |
ADDRESS_LINE1 | Customer Address Line1 |
ADDRESS_LINE2 | Customer Address Line2 |
USER_NAME | User Name |
ATTRIBUTE1 | Attribute1 |
ATTRIBUTE2 | Attribute2 |
CITY | City |
POSTAL_CODE | Postal Code |
COPY_OR_ORIGINAL | Copy or Original |
RECEIPT_DATE | Receipt Date |
RECEIPT_STATUS | Receipt Status |
DOCUMENT_NUMBER | Document Number |
RECEIPT_AMOUNT | Receipt Amount |
CURRENCY | Currency |
CREDIT_CARD_NO | Credit Card Number |
CREDIT_CARD_TYPE | Credit Card Type |
Application Object Library - CSF_WOM_ROAD_HIWAY_MAT_V | |
---|---|
Column Name | Descritpion |
LINK_ID | |
SYS_NC00007$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
NAME | |
SYS_NC00010$ | |
IS_FERRY | |
SYS_NC00006$ | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - AR_REM_CR_ID_GTT | |
---|---|
Column Name | Descritpion |
CASH_RECEIPT_HISTORY_ID | |
CASH_RECEIPT_ID |
Application Object Library - DDR_BS_INV_SKU_BU_DAY_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00076$ | |
MFG_ORG_CD | |
CNT_TOTAL | |
ON_HAND_QTY_PRMRY | |
ON_HAND_QTY_ALT | |
RECVD_QTY_PRMRY | |
RECVD_QTY_ALT | |
IN_TRANSIT_QTY_PRMRY | |
IN_TRANSIT_QTY_ALT | |
BCK_ORDR_QTY_PRMRY | |
BCK_ORDR_QTY_ALT | |
QLTY_HOLD_QTY_PRMRY | |
RTL_ORG_CD | |
QLTY_HOLD_QTY_ALT | |
SYS_NC00075$ | |
ON_HAND_NET_COST_AMT | |
ON_HAND_NET_COST_AMT_RPT | |
SYS_NC00074$ | |
RECVD_NET_COST_AMT | |
RECVD_NET_COST_AMT_RPT | |
SYS_NC00073$ | |
IN_TRANSIT_NET_COST_AMT | |
IN_TRANSIT_NET_COST_AMT_RPT | |
SYS_NC00079$ | |
BCKORDR_NET_COST_AMT | |
BCKORDR_NET_COST_AMT_RPT | |
SYS_NC00072$ | |
QLTY_HOLD_NET_COST_AMT | |
ORG_BSNS_UNIT_ID | |
QLTY_HOLD_NET_COST_AMT_RPT | |
SYS_NC00078$ | |
ON_HAND_RTL_AMT | |
ON_HAND_RTL_AMT_RPT | |
SYS_NC00071$ | |
RECVD_RTL_AMT | |
RECVD_RTL_AMT_RPT | |
SYS_NC00077$ | |
IN_TRANSIT_RTL_AMT | |
IN_TRANSIT_RTL_AMT_RPT | |
BCKORDR_RTL_AMT | |
BCKORDR_RTL_AMT_RPT | |
QLTY_HOLD_RTL_AMT | |
ITM_TYP | |
QLTY_HOLD_RTL_AMT_RPT | |
CNT_ON_HAND_QTY_PRMRY | |
CNT_ON_HAND_QTY_ALT | |
CNT_RECVD_QTY_PRMRY | |
CNT_RECVD_QTY_ALT | |
CNT_IN_TRANSIT_QTY_PRMRY | |
CNT_IN_TRANSIT_QTY_ALT | |
CNT_BCK_ORDR_QTY_PRMRY | |
CNT_BCK_ORDR_QTY_ALT | |
CNT_QLTY_HOLD_QTY_PRMRY | |
GLBL_ITEM_ID | |
CNT_QLTY_HOLD_QTY_ALT | |
CNT_ON_HAND_NET_COST_AMT | |
CNT_ON_HAND_NET_COST_AMT_RPT | |
CNT_RECVD_NET_COST_AMT | |
CNT_RECVD_NET_COST_AMT_RPT | |
CNT_IN_TRANSIT_NET_COST_AMT | |
CNT_IN_TRANSIT_NET_CST_AMT_RPT | |
CNT_BCKORDR_NET_COST_AMT | |
CNT_BCKORDR_NET_COST_AMT_RPT | |
CNT_QLTY_HOLD_NET_COST_AMT | |
GLBL_ITEM_ID_TYP | |
CNT_QLTY_HOLD_NET_COST_AMT_RPT | |
CNT_ON_HAND_RTL_AMT | |
CNT_ON_HAND_RTL_AMT_RPT | |
CNT_RECVD_RTL_AMT | |
CNT_RECVD_RTL_AMT_RPT | |
CNT_IN_TRANSIT_RTL_AMT | |
CNT_IN_TRANSIT_RTL_AMT_RPT | |
CNT_BCKORDR_RTL_AMT | |
CNT_BCKORDR_RTL_AMT_RPT | |
CNT_QLTY_HOLD_RTL_AMT | |
MFG_SKU_ITEM_ID | |
CNT_QLTY_HOLD_RTL_AMT_RPT | |
RTL_SKU_ITEM_ID | |
DAY_CD |
Application Object Library - DDR_BS_FRCST_VRSN_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
MFG_ORG_CD | |
CNT_TOTAL | |
SYS_NC00012$ | |
SYS_NC00015$ | |
SYS_NC00018$ | |
RTL_ORG_CD | |
SYS_NC00016$ | |
ORG_BSNS_UNIT_ID | |
GLBL_ITEM_ID | |
SYS_NC00011$ | |
GLBL_ITEM_ID_TYP | |
RTL_SKU_ITEM_ID | |
SYS_NC00014$ | |
DAY_CD | |
MFG_SKU_ITEM_ID | |
SYS_NC00017$ | |
MAX_FRCST_VRSN |
Application Object Library - DDR_R_BSNS_QTR_DN_MV | |
---|---|
Column Name | Descritpion |
BQTR_ROWID | |
QTR_DESC | |
QTR_CD | |
QTR_NBR | |
QTR_STRT_DT | |
QTR_END_DT | |
QTR_TIMESPN | |
LAST_YR_THIS_QTR_ID | |
LAST_QTR_THIS_YR_ID | |
BSNS_YR_ID | |
YR_DESC | |
BYR_ROWID | |
YR_NBR | |
YR_CD | |
YR_STRT_DT | |
YR_END_DT | |
YR_TIMESPN | |
CAL_ROWID | |
QTR_TRANS_ROWID | |
MFG_ORG_CD | |
CLNDR_CD | |
ORG_CD | |
CLNDR_DESC | |
BSNS_QTR_ID |
Application Object Library - DDR_R_BASE_DAY_DN_MV | |
---|---|
Column Name | Descritpion |
DAY_ROWID | |
CLNDR_CD | |
ORG_CD | |
CLNDR_DESC | |
DAY_CD | |
BASE_DAY_ID | |
CLNDR_DT | |
CLNDR_DT_DESC | |
DAY_OF_YR | |
WKEND_IND | |
LAST_YR_THIS_DAY_CD | |
BDAY_ROWID | |
LAST_DAY_THIS_YR_CD | |
BSNS_WK_ID | |
WK_DESC | |
WK_CD | |
WK_NBR | |
WK_STRT_DT | |
WK_END_DT | |
WK_TIMESPN | |
BSNS_MNTH_ID | |
MNTH_DESC | |
BWK_ROWID | |
MNTH_CD | |
MNTH_STRT_DT | |
MNTH_END_DT | |
MNTH_NBR | |
MNTH_TIMESPN | |
BSNS_QTR_ID | |
QTR_DESC | |
QTR_CD | |
QTR_NBR | |
QTR_STRT_DT | |
BMNTH_ROWID | |
QTR_END_DT | |
QTR_TIMESPN | |
BSNS_YR_ID | |
YR_DESC | |
YR_NBR | |
YR_CD | |
YR_STRT_DT | |
YR_END_DT | |
YR_TIMESPN | |
BQTR_ROWID | |
BYR_ROWID | |
CAL_ROWID | |
DAY_TRANS_ROWID | |
MFG_ORG_CD |
Application Object Library - DDR_R_BSNS_YR_DN_MV | |
---|---|
Column Name | Descritpion |
BYR_ROWID | |
YR_DESC | |
YR_NBR | |
YR_STRT_DT | |
YR_END_DT | |
YR_TIMESPN | |
LAST_YR_ID | |
CAL_ROWID | |
YR_TRANS_ROWID | |
MFG_ORG_CD | |
CLNDR_CD | |
CLNDR_DESC | |
ORG_CD | |
BSNS_YR_ID | |
YR_CD |
Application Object Library - DDR_R_BSNS_MNTH_DN_MV | |
---|---|
Column Name | Descritpion |
BMNTH_ROWID | |
BSNS_MNTH_ID | |
MNTH_DESC | |
MNTH_CD | |
MNTH_STRT_DT | |
MNTH_END_DT | |
MNTH_NBR | |
MNTH_TIMESPN | |
LAST_YR_THIS_MNTH_ID | |
LAST_MNTH_THIS_YR_ID | |
BSNS_QTR_ID | |
BQTR_ROWID | |
QTR_DESC | |
QTR_NBR | |
QTR_CD | |
QTR_STRT_DT | |
QTR_END_DT | |
QTR_TIMESPN | |
BSNS_YR_ID | |
YR_DESC | |
YR_NBR | |
YR_CD | |
BYR_ROWID | |
YR_STRT_DT | |
YR_END_DT | |
YR_TIMESPN | |
CAL_ROWID | |
MNTH_TRANS_ROWID | |
MFG_ORG_CD | |
CLNDR_CD | |
ORG_CD | |
CLNDR_DESC |
Application Object Library - DDR_R_BSNS_WK_DN_MV | |
---|---|
Column Name | Descritpion |
BWK_ROWID | |
CLNDR_DESC | |
BSNS_WK_ID | |
WK_DESC | |
WK_NBR | |
WK_CD | |
WK_STRT_DT | |
WK_END_DT | |
WK_TIMESPN | |
LAST_YR_THIS_WK_ID | |
LAST_WK_THIS_YR_ID | |
BMNTH_ROWID | |
BSNS_MNTH_ID | |
MNTH_DESC | |
MNTH_CD | |
MNTH_STRT_DT | |
MNTH_END_DT | |
MNTH_NBR | |
MNTH_TIMESPN | |
BSNS_QTR_ID | |
QTR_DESC | |
QTR_NBR | |
BQTR_ROWID | |
QTR_CD | |
QTR_STRT_DT | |
QTR_END_DT | |
QTR_TIMESPN | |
BSNS_YR_ID | |
YR_DESC | |
YR_NBR | |
YR_CD | |
YR_STRT_DT | |
YR_END_DT | |
BYR_ROWID | |
YR_TIMESPN | |
CAL_ROWID | |
WK_TRANS_ROWID | |
MFG_ORG_CD | |
CLNDR_CD | |
ORG_CD |
Application Object Library - DDR_R_INV_RULE_DN_MV | |
---|---|
Column Name | Descritpion |
ITM_BU_ASSC_ROWID | |
EFF_TO_DT | |
SKU_BU_INV_RULE_ROWID | |
MFG_ORG_CD | |
RTL_ORG_CD | |
RTL_BSNS_UNIT_ID | |
GLBL_ITEM_ID | |
GLBL_ITEM_ID_TYP | |
MIN_STCK_ON_HAND_QTY_PRMRY | |
EFF_FROM_DT |
Application Object Library - DDR_R_MFG_ITEM_DIV_DN_MV | |
---|---|
Column Name | Descritpion |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
MFG_ORG_NAME | |
MFG_ITEM_DIV_ID | |
MFG_DIV_CD | |
MFG_DIV_NAME | |
MFG_ITEM_CMPNY_ID |
Application Object Library - DDR_R_MFG_ITEM_CLS_DN_MV | |
---|---|
Column Name | Descritpion |
CLS_ROWID | |
MFG_ITEM_GRP_ID | |
MFG_GRP_CD | |
MFG_GRP_NAME | |
MFG_ITEM_DIV_ID | |
MFG_DIV_CD | |
MFG_DIV_NAME | |
MFG_ITEM_CMPNY_ID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
MFG_ORG_NAME | |
MFG_ITEM_CLASS_ID | |
MFG_CLASS_CD | |
MFG_CLASS_NAME |
Application Object Library - DDR_R_MFG_ITEM_GRP_DN_MV | |
---|---|
Column Name | Descritpion |
GRP_ROWID | |
MFG_DIV_CD | |
MFG_DIV_NAME | |
MFG_ITEM_CMPNY_ID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
MFG_ORG_NAME | |
MFG_ITEM_GRP_ID | |
MFG_GRP_CD | |
MFG_GRP_NAME | |
MFG_ITEM_DIV_ID |
Application Object Library - DDR_R_MFG_ITEM_ITM_DN_MV | |
---|---|
Column Name | Descritpion |
ITM_ROWID | |
ORG_CD | |
MFG_ITEM_ID | |
MFG_ITEM_NAME | |
MFG_ITEM_NBR | |
MFG_BRND_CD | |
MFG_ITEM_DESC | |
MFG_ITEM_SHORT_DESC | |
MFG_ITEM_SCND_DESC | |
BRND_NAME | |
BRND_DESC | |
SBC_ROWID | |
MFG_ITEM_SBC_ID | |
MFG_SBC_CD | |
MFG_SBC_NAME | |
MFG_ITEM_CLASS_ID | |
MFG_CLASS_CD | |
MFG_CLASS_NAME | |
MFG_ITEM_GRP_ID | |
MFG_GRP_CD | |
MFG_GRP_NAME | |
MFG_ITEM_DIV_ID | |
CLS_ROWID | |
MFG_DIV_CD | |
MFG_DIV_NAME | |
MFG_ITEM_CMPNY_ID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
LKUP_ROWID | |
MFG_ORG_CD | |
MFG_ORG_NAME |
Application Object Library - DDR_R_MFG_ITEM_SBC_DN_MV | |
---|---|
Column Name | Descritpion |
SBC_ROWID | |
MFG_SBC_NAME | |
MFG_ITEM_CLASS_ID | |
MFG_CLASS_CD | |
MFG_CLASS_NAME | |
MFG_ITEM_GRP_ID | |
MFG_GRP_CD | |
MFG_GRP_NAME | |
MFG_ITEM_DIV_ID | |
MFG_DIV_CD | |
MFG_DIV_NAME | |
CLS_ROWID | |
MFG_ITEM_CMPNY_ID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
MFG_ORG_NAME | |
MFG_ITEM_SBC_ID | |
MFG_SBC_CD |
Application Object Library - DDR_R_ORG_BU_CHNLTYP_DN_MV | |
---|---|
Column Name | Descritpion |
BU_ROWID | |
ORG_TYP | |
ORG_NAME | |
ORG_BSNS_UNIT_ID | |
BSNS_UNIT_CD | |
BSNS_UNIT_NAME | |
CHNL_TYP_CD | |
CHNL_TYP_DESC | |
MKT_AREA_ID_1 | |
MKT_AREA_CD_1 | |
MKT_AREA_TYP_1 | |
DSTRCT_ROWID | |
STORE_MGR | |
STORE_OPEN_DT | |
STORE_CLOSE_DT | |
STORE_TYP | |
NEW_STORE_IND | |
GLBL_LOC_ID | |
GLBL_LOC_ID_TYP | |
BSNS_UNIT_CNCPT | |
ORG_DSTRCT_ID | |
DSTRCT_CD | |
RGN_ROWID | |
DSTRCT_NAME | |
DSTRCT_MGR_NAME | |
ORG_RGN_ID | |
RGN_CD | |
RGN_NAME | |
RGN_MGR_NAME | |
ORG_AREA_ID | |
AREA_CD | |
AREA_NAME | |
AREA_MGR_NAME | |
AREA_ROWID | |
ORG_CHAIN_ID | |
CHAIN_CD | |
CHAIN_NAME | |
CHAIN_MGR_NAME | |
CHAIN_ROWID | |
ORG_ROWID | |
LKUP_MST_ROWID | |
MFG_ORG_CD | |
ORG_CD |
Application Object Library - DDR_R_ORG_CHN_DN_MV | |
---|---|
Column Name | Descritpion |
CHAIN_ROWID | |
CHAIN_MGR_NAME | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_CD | |
ORG_TYP | |
ORG_NAME | |
ORG_CHAIN_ID | |
CHAIN_CD | |
CHAIN_NAME |
Application Object Library - DDR_R_ORG_RGN_DN_MV | |
---|---|
Column Name | Descritpion |
RGN_ROWID | |
RGN_CD | |
RGN_NAME | |
RGN_MGR_NAME | |
ORG_AREA_ID | |
AREA_CD | |
AREA_NAME | |
AREA_MGR_NAME | |
ORG_CHAIN_ID | |
CHAIN_CD | |
CHAIN_NAME | |
AREA_ROWID | |
CHAIN_MGR_NAME | |
CHAIN_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_CD | |
ORG_TYP | |
ORG_NAME | |
ORG_RGN_ID |
Application Object Library - DDR_R_PRD_DRTN_DN_MV | |
---|---|
Column Name | Descritpion |
MFG_ORG_CD | |
PRD_ROWID | |
CLNDR_CD | |
PRD_CD | |
PRD_ID | |
PRD_TYP | |
PRD_DRTN | |
PRD_DRTN_YTD | |
CNT_PRD_DRTN_YTD | |
CNT_TOTAL |
Application Object Library - DDR_R_RTL_ITEM_CLS_DN_MV | |
---|---|
Column Name | Descritpion |
CLS_ROWID | |
RTL_CLASS_CD | |
RTL_CLASS_NAME | |
RTL_ITEM_DEPT_ID | |
RTL_DEPT_CD | |
RTL_DEPT_NAME | |
RTL_ITEM_GRP_ID | |
RTL_GRP_CD | |
RTL_GRP_NAME | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
DPT_ROWID | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_NAME | |
ORG_CD | |
RTL_ITEM_CLASS_ID |
Application Object Library - DDR_R_RTL_ITEM_DEPT_DN_MV | |
---|---|
Column Name | Descritpion |
DPT_ROWID | |
RTL_DEPT_NAME | |
RTL_ITEM_GRP_ID | |
RTL_GRP_CD | |
RTL_GRP_NAME | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_NAME | |
ORG_CD | |
RTL_ITEM_DEPT_ID | |
RTL_DEPT_CD |
Application Object Library - DDR_R_ORG_AREA_DN_MV | |
---|---|
Column Name | Descritpion |
AREA_ROWID | |
AREA_NAME | |
AREA_MGR_NAME | |
ORG_CHAIN_ID | |
CHAIN_CD | |
CHAIN_NAME | |
CHAIN_MGR_NAME | |
CHAIN_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_CD | |
ORG_TYP | |
ORG_NAME | |
ORG_AREA_ID | |
AREA_CD |
Application Object Library - DDR_R_RTL_ITEM_GRP_DN_MV | |
---|---|
Column Name | Descritpion |
GRP_ROWID | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_NAME | |
ORG_CD | |
RTL_ITEM_GRP_ID | |
RTL_GRP_CD | |
RTL_GRP_NAME |
Application Object Library - DDR_R_RTL_ITEM_ITM_DN_MV | |
---|---|
Column Name | Descritpion |
ITM_ROWID | |
ORG_NAME | |
ORG_CD | |
RTL_ITEM_ID | |
RTL_ITEM_NBR | |
RTL_ITEM_NAME | |
RTL_BRND_CD | |
RTL_ITEM_SHORT_DESC | |
RTL_ITEM_SCND_DESC | |
RTL_ITEM_DESC | |
BRND_NAME | |
SBC_ROWID | |
BRND_DESC | |
RTL_ITEM_SBC_ID | |
RTL_SBC_CD | |
RTL_SBC_NAME | |
RTL_ITEM_CLASS_ID | |
RTL_CLASS_CD | |
RTL_CLASS_NAME | |
RTL_ITEM_DEPT_ID | |
RTL_DEPT_CD | |
RTL_DEPT_NAME | |
CLS_ROWID | |
RTL_ITEM_GRP_ID | |
RTL_GRP_CD | |
RTL_GRP_NAME | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID | |
DPT_ROWID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
LKP_ROWID | |
MFG_ORG_CD |
Application Object Library - DDR_R_RTL_ITEM_SBC_DN_MV | |
---|---|
Column Name | Descritpion |
SBC_ROWID | |
RTL_ITEM_SBC_ID | |
RTL_SBC_CD | |
RTL_SBC_NAME | |
RTL_ITEM_CLASS_ID | |
RTL_CLASS_CD | |
RTL_CLASS_NAME | |
RTL_ITEM_DEPT_ID | |
RTL_DEPT_CD | |
RTL_DEPT_NAME | |
RTL_ITEM_GRP_ID | |
CLS_ROWID | |
RTL_GRP_CD | |
RTL_GRP_NAME | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID | |
DPT_ROWID | |
GRP_ROWID | |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_NAME | |
ORG_CD |
Application Object Library - DDR_R_RTL_ITEM_DIV_DN_MV | |
---|---|
Column Name | Descritpion |
DIV_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_NAME | |
ORG_CD | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID |
Application Object Library - DDR_R_RTL_ITEM_SKU_DN_MV | |
---|---|
Column Name | Descritpion |
SKU_ROWID | |
MFG_ORG_CD | |
ORG_NAME | |
ORG_CD | |
RTL_SKU_ITEM_ID | |
RTL_SKU_ITEM_NBR | |
RTL_SKU_ITEM_NAME | |
GLBL_ITEM_ID | |
GLBL_ITEM_ID_TYP | |
UNIT_PRICE_FCTR | |
SZ_TYP_CD | |
ITM_ROWID | |
STCK_ITEM_TYP_CD | |
STCK_ITEM_STYLE_CD | |
STCK_ITEM_DYE_CD | |
STCK_ITEM_COLOR_CD | |
STCK_ITEM_COATING_CD | |
STCK_ITEM_WEAVE_CD | |
STCK_ITEM_FABRIC_CD | |
STCK_ITEM_FIBER_CD | |
SU_LAST_RCVD_COST_ESTBL_DT | |
SU_LAST_RCVD_NET_COST_AMT | |
SBC_ROWID | |
SU_LAST_RCVD_NET_COST_AMT_LCL | |
SU_LAST_RCVD_NET_COST_AMT_RPT | |
RTL_SKU_SLNG_PRC_ID | |
RTL_SKU_ITEM_TYP_CD | |
RTL_SKU_ITEM_INDSTRY_IDNT_CD | |
RTL_SKU_ITEM_SLNG_PRICE_NBR | |
RTL_SKU_ITEM_DESC | |
RTL_SKU_ITEM_LONG_DESC | |
RECALL_IND | |
PCK_SELLBL_CD | |
CLS_ROWID | |
PCK_SMPL_CD | |
PCK_ORDRBL_CD | |
PCK_IND | |
PKG_SZ | |
PCK_SELLBL_DESC | |
PCK_SMPL_DESC | |
PCK_ORDRBL_DESC | |
RTL_ITEM_ID | |
RTL_ITEM_NBR | |
RTL_ITEM_NAME | |
DPT_ROWID | |
RTL_BRND_CD | |
RTL_ITEM_SHORT_DESC | |
RTL_ITEM_SCND_DESC | |
RTL_ITEM_DESC | |
BRND_NAME | |
BRND_DESC | |
RTL_ITEM_SBC_ID | |
RTL_SBC_CD | |
RTL_SBC_NAME | |
RTL_ITEM_CLASS_ID | |
GRP_ROWID | |
RTL_CLASS_CD | |
RTL_CLASS_NAME | |
RTL_ITEM_DEPT_ID | |
RTL_DEPT_CD | |
RTL_DEPT_NAME | |
RTL_ITEM_GRP_ID | |
RTL_GRP_CD | |
RTL_GRP_NAME | |
RTL_ITEM_DIV_ID | |
RTL_DIV_CD | |
DIV_ROWID | |
RTL_DIV_NAME | |
RTL_ITEM_CMPNY_ID | |
EFF_FROM_DT | |
EFF_TO_DT | |
ORG_ROWID | |
LKP_ROWID |
Application Object Library - DDR_R_ORG_DSTRCT_DN_MV | |
---|---|
Column Name | Descritpion |
DSTRCT_ROWID | |
ORG_DSTRCT_ID | |
DSTRCT_CD | |
DSTRCT_NAME | |
DSTRCT_MGR_NAME | |
ORG_RGN_ID | |
RGN_CD | |
RGN_NAME | |
RGN_MGR_NAME | |
ORG_AREA_ID | |
AREA_CD | |
RGN_ROWID | |
AREA_NAME | |
AREA_MGR_NAME | |
ORG_CHAIN_ID | |
CHAIN_CD | |
CHAIN_NAME | |
CHAIN_MGR_NAME | |
AREA_ROWID | |
CHAIN_ROWID | |
ORG_ROWID | |
MFG_ORG_CD | |
ORG_CD | |
ORG_TYP | |
ORG_NAME |
Application Object Library - DDR_R_MFG_ITEM_SKU_DN_MV | |
---|---|
Column Name | Descritpion |
SKU_ROWID | |
MFG_ORG_NAME | |
ORG_CD | |
MFG_SKU_ITEM_ID | |
MFG_SKU_ITEM_NAME | |
MFG_SKU_ITEM_NBR | |
GLBL_ITEM_ID | |
GLBL_ITEM_ID_TYP | |
UNIT_PRICE_FCTR | |
SZ_TYP_CD | |
STCK_ITEM_WEAVE_CD | |
ITM_ROWID | |
STCK_ITEM_TYP_CD | |
STCK_ITEM_STYLE_CD | |
STCK_ITEM_FIBER_CD | |
STCK_ITEM_FABRIC_CD | |
STCK_ITEM_DYE_CD | |
STCK_ITEM_COLOR_CD | |
STCK_ITEM_COATING_CD | |
SU_LAST_RCVD_NET_COST_AMT_RPT | |
SU_LAST_RCVD_NET_COST_AMT_LCL | |
SU_LAST_RCVD_NET_COST_AMT | |
SBC_ROWID | |
SU_LAST_RCVD_COST_ESTBL_DT | |
SU_LAST_RCVD_BASE_COST_AMT_RPT | |
SU_LAST_RCVD_BASE_COST_AMT_LCL | |
SU_LAST_RCVD_BASE_COST_AMT | |
SU_LNDED_COST_AMT | |
SU_LNDED_COST_AMT_LCL | |
SU_LNDED_COST_AMT_RPT | |
PKG_SZ | |
MFG_SKU_ITEM_TYP_CD | |
MFG_SKU_ITEM_DESC | |
CLS_ROWID | |
MFG_SKU_ITEM_LNG_DESC | |
COLLCTN_SKU_FLG | |
AVLBL_FOR_SL_DT | |
RECALL_IND | |
UOM_CD | |
ALT_UOM_CD | |
MFG_ITEM_DESC | |
MFG_ITEM_ID | |
MFG_ITEM_NAME | |
MFG_ITEM_NBR | |
GRP_ROWID | |
MFG_BRND_CD | |
MFG_ITEM_SHORT_DESC | |
MFG_ITEM_SCND_DESC | |
BRND_NAME | |
BRND_DESC | |
MFG_ITEM_SBC_ID | |
MFG_SBC_CD | |
MFG_SBC_NAME | |
MFG_ITEM_CLASS_ID | |
MFG_CLASS_CD | |
DIV_ROWID | |
MFG_CLASS_NAME | |
MFG_ITEM_GRP_ID | |
MFG_GRP_CD | |
MFG_GRP_NAME | |
MFG_ITEM_DIV_ID | |
MFG_DIV_CD | |
MFG_DIV_NAME | |
MFG_ITEM_CMPNY_ID | |
EFF_FROM_DT | |
EFF_TO_DT | |
ORG_ROWID | |
LKUP_ROWID | |
MFG_ORG_CD |
Application Object Library - DDR_BS_FRCST_LST_SLS_MV | |
---|---|
Column Name | Descritpion |
MFG_ORG_CD | |
FRCST_ROWID | |
MAXVRSN_ROWID | |
SLS_ROWID | |
RTL_ORG_CD | |
ORG_BSNS_UNIT_ID | |
MFG_SKU_ITEM_ID | |
RTL_SKU_ITEM_ID | |
DAY_CD | |
MAX_FRCST_VRSN | |
ACT_FRCST_SLS_AMT_RPT | |
ACT_FRCST_SLS_QTY_PRMRY |
Application Object Library - DDR_BS_CLS_DAY_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00006$ | |
MFG_ORG_CD | |
SYS_NC00008$ | |
SYS_NC00007$ | |
SYS_NC00009$ | |
CLNDR_CD | |
MFG_ITEM_CLASS_ID | |
DAY_CD | |
NUM_MFG_SKU_ITEMS |
Application Object Library - DDR_BS_ITM_BU_ASSC_DAY_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
MFG_ORG_CD | |
SYS_NC00010$ | |
SYS_NC00015$ | |
RTL_ORG_CD | |
SYS_NC00012$ | |
SYS_NC00014$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
RTL_BSNS_UNIT_ID | |
MFG_ITEM_ID | |
RTL_ITEM_ID | |
CLNDR_CD | |
DAY_CD | |
TOTAL_BU_ITM_DAYS |
Application Object Library - DDR_R_ORG_BU_DN_MV | |
---|---|
Column Name | Descritpion |
BU_DN_ROWID | |
CHNL_TYP_CD | |
CHNL_TYP_DESC | |
STORE_MGR | |
STORE_OPEN_DT | |
STORE_CLOSE_DT | |
STORE_TYP | |
NEW_STORE_IND | |
GLBL_LOC_ID | |
GLBL_LOC_ID_TYP | |
BSNS_UNIT_CNCPT | |
MKT_AREA_ROWID | |
MKT_AREA_ID | |
MKT_AREA_CD | |
MKT_AREA_TYP | |
MKT_AREA_NAME | |
MKT_AREA_DESC | |
ORG_DSTRCT_ID | |
DSTRCT_CD | |
DSTRCT_NAME | |
DSTRCT_MGR_NAME | |
ORG_RGN_ID | |
MFG_ORG_CD | |
RGN_CD | |
RGN_NAME | |
RGN_MGR_NAME | |
ORG_AREA_ID | |
AREA_CD | |
AREA_NAME | |
AREA_MGR_NAME | |
ORG_CHAIN_ID | |
CHAIN_CD | |
CHAIN_NAME | |
ORG_CD | |
CHAIN_MGR_NAME | |
ORG_TYP | |
ORG_NAME | |
ORG_BSNS_UNIT_ID | |
BSNS_UNIT_CD | |
BSNS_UNIT_NAME |
Application Object Library - DDR_BS_FRCST_ITM_BU_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
MFG_ORG_CD | |
RTL_ITEM_CLASS_ID | |
SYS_NC00038$ | |
BSNS_WK_ID | |
BSNS_MNTH_ID | |
SYS_NC00028$ | |
BSNS_YR_ID | |
CNT_TOTAL | |
SYS_NC00031$ | |
ACT_FRCST_SLS_AMT_RPT | |
ACT_FRCST_SLS_QTY_PRMRY | |
SYS_NC00034$ | |
FRCST_SLS_QTY_PRMRY | |
FRCST_SLS_QTY_ALT | |
SYS_NC00037$ | |
FRCST_SLS_AMT | |
RTL_ORG_CD | |
FRCST_SLS_AMT_RPT | |
SYS_NC00027$ | |
SYS_NC00039$ | |
CNT_ACT_FRCST_SLS_AMT_RPT | |
CNT_ACT_FRCST_SLS_QTY_PRMRY | |
SYS_NC00030$ | |
CNT_FRCST_SLS_QTY_PRMRY | |
CNT_FRCST_SLS_QTY_ALT | |
SYS_NC00033$ | |
CNT_FRCST_SLS_AMT | |
CNT_FRCST_SLS_AMT_RPT | |
ORG_BSNS_UNIT_ID | |
ITM_TYP | |
SYS_NC00029$ | |
ORG_RGN_ID | |
ORG_CHAIN_ID | |
SYS_NC00032$ | |
MFG_ITEM_ID | |
MFG_ITEM_CLASS_ID | |
SYS_NC00035$ | |
RTL_ITEM_ID |
Application Object Library - DDR_BS_INV_ITM_BU_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00086$ | |
MFG_ORG_CD | |
RTL_ITEM_CLASS_ID | |
SYS_NC00079$ | |
BSNS_WK_ID | |
BSNS_MNTH_ID | |
SYS_NC00082$ | |
BSNS_YR_ID | |
CNT_TOTAL | |
SYS_NC00088$ | |
IN_STCK_BU_ITM_DAYS | |
UNDR_STCK_BU_ITM_DAYS | |
SYS_NC00078$ | |
ON_HAND_QTY_PRMRY | |
ON_HAND_QTY_ALT | |
SYS_NC00081$ | |
RECVD_QTY_PRMRY | |
RTL_ORG_CD | |
RECVD_QTY_ALT | |
SYS_NC00087$ | |
SYS_NC00085$ | |
IN_TRANSIT_QTY_PRMRY | |
IN_TRANSIT_QTY_ALT | |
SYS_NC00077$ | |
BCK_ORDR_QTY_PRMRY | |
BCK_ORDR_QTY_ALT | |
SYS_NC00080$ | |
QLTY_HOLD_QTY_PRMRY | |
QLTY_HOLD_QTY_ALT | |
ON_HAND_NET_COST_AMT | |
ON_HAND_NET_COST_AMT_RPT | |
RECVD_NET_COST_AMT | |
ORG_BSNS_UNIT_ID | |
RECVD_NET_COST_AMT_RPT | |
IN_TRANSIT_NET_COST_AMT | |
IN_TRANSIT_NET_COST_AMT_RPT | |
BCKORDR_NET_COST_AMT | |
BCKORDR_NET_COST_AMT_RPT | |
QLTY_HOLD_NET_COST_AMT | |
QLTY_HOLD_NET_COST_AMT_RPT | |
ON_HAND_RTL_AMT | |
ON_HAND_RTL_AMT_RPT | |
RECVD_RTL_AMT | |
ITM_TYP | |
RECVD_RTL_AMT_RPT | |
SYS_NC00084$ | |
IN_TRANSIT_RTL_AMT | |
IN_TRANSIT_RTL_AMT_RPT | |
BCKORDR_RTL_AMT | |
BCKORDR_RTL_AMT_RPT | |
QLTY_HOLD_RTL_AMT | |
QLTY_HOLD_RTL_AMT_RPT | |
CNT_ON_HAND_QTY_PRMRY | |
CNT_ON_HAND_QTY_ALT | |
CNT_RECVD_QTY_PRMRY | |
ORG_RGN_ID | |
CNT_RECVD_QTY_ALT | |
CNT_IN_TRANSIT_QTY_PRMRY | |
CNT_IN_TRANSIT_QTY_ALT | |
CNT_BCK_ORDR_QTY_PRMRY | |
CNT_BCK_ORDR_QTY_ALT | |
CNT_QLTY_HOLD_QTY_PRMRY | |
CNT_QLTY_HOLD_QTY_ALT | |
CNT_ON_HAND_NET_COST_AMT | |
CNT_ON_HAND_NET_COST_AMT_RPT | |
CNT_RECVD_NET_COST_AMT | |
ORG_CHAIN_ID | |
CNT_RECVD_NET_COST_AMT_RPT | |
SYS_NC00083$ | |
CNT_IN_TRANSIT_NET_COST_AMT | |
CNT_IN_TRANSIT_NET_CST_AMT_RPT | |
CNT_BCKORDR_NET_COST_AMT | |
CNT_BCKORDR_NET_COST_AMT_RPT | |
CNT_QLTY_HOLD_NET_COST_AMT | |
CNT_QLTY_HOLD_NET_COST_AMT_RPT | |
CNT_ON_HAND_RTL_AMT | |
CNT_ON_HAND_RTL_AMT_RPT | |
CNT_RECVD_RTL_AMT | |
MFG_ITEM_ID | |
CNT_RECVD_RTL_AMT_RPT | |
CNT_IN_TRANSIT_RTL_AMT | |
CNT_IN_TRANSIT_RTL_AMT_RPT | |
CNT_BCKORDR_RTL_AMT | |
CNT_BCKORDR_RTL_AMT_RPT | |
CNT_QLTY_HOLD_RTL_AMT | |
CNT_QLTY_HOLD_RTL_AMT_RPT | |
MFG_ITEM_CLASS_ID | |
SYS_NC00089$ | |
RTL_ITEM_ID |
Application Object Library - DDR_BS_SHIP_ITM_BU_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
MFG_ORG_CD | |
RTL_ITEM_CLASS_ID | |
SYS_NC00031$ | |
BSNS_WK_ID | |
BSNS_MNTH_ID | |
SYS_NC00034$ | |
BSNS_YR_ID | |
CNT_TOTAL | |
SYS_NC00023$ | |
SHIP_QTY_PRMRY | |
SHIP_QTY_ALT | |
SYS_NC00026$ | |
SHIP_AMT | |
SHIP_AMT_RPT | |
SYS_NC00029$ | |
CNT_SHIP_QTY_PRMRY | |
RTL_ORG_CD | |
CNT_SHIP_QTY_ALT | |
SYS_NC00032$ | |
SYS_NC00030$ | |
CNT_SHIP_AMT | |
CNT_SHIP_AMT_RPT | |
SYS_NC00035$ | |
SYS_NC00024$ | |
ORG_BSNS_UNIT_ID | |
ITM_TYP | |
SYS_NC00033$ | |
ORG_RGN_ID | |
ORG_CHAIN_ID | |
SYS_NC00025$ | |
MFG_ITEM_ID | |
MFG_ITEM_CLASS_ID | |
SYS_NC00028$ | |
RTL_ITEM_ID |
Application Object Library - DDR_BS_ORDR_ITM_BU_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
MFG_ORG_CD | |
RTL_ITEM_CLASS_ID | |
BSNS_WK_ID | |
BSNS_MNTH_ID | |
BSNS_YR_ID | |
CNT_TOTAL | |
ORDR_QTY_PRMRY | |
ORDR_QTY_ALT | |
ORDR_AMT | |
ORDR_AMT_RPT | |
CNT_ORDR_QTY_PRMRY | |
RTL_ORG_CD | |
CNT_ORDR_QTY_ALT | |
CNT_ORDR_AMT | |
CNT_ORDR_AMT_RPT | |
SYS_NC00030$ | |
ORG_BSNS_UNIT_ID | |
SYS_NC00033$ | |
SYS_NC00025$ | |
SYS_NC00028$ | |
SYS_NC00031$ | |
SYS_NC00034$ | |
ITM_TYP | |
SYS_NC00023$ | |
SYS_NC00026$ | |
SYS_NC00029$ | |
SYS_NC00032$ | |
SYS_NC00035$ | |
ORG_RGN_ID | |
SYS_NC00024$ | |
ORG_CHAIN_ID | |
MFG_ITEM_ID | |
MFG_ITEM_CLASS_ID | |
RTL_ITEM_ID |
Application Object Library - DDR_BS_SLSR_ITM_BU_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
MFG_ORG_CD | |
MFG_ITEM_CLASS_ID | |
SYS_NC00048$ | |
RTL_ITEM_ID | |
RTL_ITEM_CLASS_ID | |
SYS_NC00051$ | |
BSNS_WK_ID | |
BSNS_MNTH_ID | |
SYS_NC00054$ | |
BSNS_YR_ID | |
PRMTN_FLAG | |
SYS_NC00057$ | |
CNT_TOTAL | |
ACT_BU_ITM_DAYS_SCANNED | |
SYS_NC00044$ | |
SLS_QTY_PRMRY | |
RTL_ORG_CD | |
SLS_QTY_ALT | |
SYS_NC00047$ | |
SYS_NC00052$ | |
SLS_AMT | |
SLS_AMT_RPT | |
SYS_NC00050$ | |
SLS_COST_AMT | |
SLS_COST_AMT_RPT | |
SYS_NC00053$ | |
RTRN_QTY_PRMRY | |
RTRN_QTY_ALT | |
SYS_NC00056$ | |
RTRN_AMT | |
RTRN_AMT_RPT | |
SYS_NC00043$ | |
RTRN_COST_AMT | |
ORG_BSNS_UNIT_ID | |
RTRN_COST_AMT_RPT | |
SYS_NC00046$ | |
CNT_SLS_QTY_PRMRY | |
CNT_SLS_QTY_ALT | |
CNT_SLS_AMT | |
CNT_SLS_AMT_RPT | |
CNT_SLS_COST_AMT | |
CNT_SLS_COST_AMT_RPT | |
CNT_RTRN_QTY_PRMRY | |
CNT_RTRN_QTY_ALT | |
CNT_RTRN_AMT | |
ITM_TYP | |
CNT_RTRN_AMT_RPT | |
SYS_NC00055$ | |
CNT_RTRN_COST_AMT | |
CNT_RTRN_COST_AMT_RPT | |
MKT_AREA_ID | |
CHNL_TYP_CD | |
SYS_NC00058$ | |
ORG_RGN_ID | |
ORG_CHAIN_ID | |
SYS_NC00045$ | |
MFG_ITEM_ID |
Application Object Library - DDR_SV_ITM_BU_ASSC_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
MFG_ORG_CD | |
SYS_NC00010$ | |
SYS_NC00015$ | |
SYS_NC00012$ | |
RTL_ORG_CD | |
SYS_NC00014$ | |
SYS_NC00011$ | |
RTL_BSNS_UNIT_ID | |
MFG_ITEM_ID | |
RTL_ITEM_ID | |
BSNS_WK_ID | |
TOTAL_BU_ITM_DAYS | |
CNT_DAYS | |
CNT_TOTAL |
Application Object Library - DDR_SV_CLS_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00009$ | |
MFG_ORG_CD | |
SYS_NC00008$ | |
SYS_NC00010$ | |
SYS_NC00011$ | |
MFG_ITEM_CLASS_ID | |
BSNS_WK_ID | |
NUM_MFG_SKU_ITEMS | |
WK_TIMESPN | |
CNT_DAYS | |
CNT_TOTAL |
Application Object Library - DDR_SV_ITM_BU_ASSC_MNTH_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
MFG_ORG_CD | |
SYS_NC00010$ | |
SYS_NC00015$ | |
SYS_NC00012$ | |
RTL_ORG_CD | |
SYS_NC00014$ | |
SYS_NC00011$ | |
RTL_BSNS_UNIT_ID | |
MFG_ITEM_ID | |
RTL_ITEM_ID | |
BSNS_MNTH_ID | |
TOTAL_BU_ITM_DAYS | |
CNT_WKS | |
CNT_TOTAL |
Application Object Library - DDR_SV_CLS_MNTH_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00009$ | |
MFG_ORG_CD | |
SYS_NC00008$ | |
SYS_NC00010$ | |
SYS_NC00011$ | |
MFG_ITEM_CLASS_ID | |
BSNS_MNTH_ID | |
NUM_MFG_SKU_ITEMS | |
MNTH_TIMESPN | |
CNT_WKS | |
CNT_TOTAL |
Application Object Library - DDR_SV_INV_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00086$ | |
BSNS_WK_ID | |
ORG_DIM_ID | |
SYS_NC00081$ | |
SYS_NC00088$ | |
SYS_NC00087$ | |
ORG_DIM_LVL | |
MFG_ITEM_DIM_ID | |
MFG_ITEM_DIM_LVL | |
RTL_ITEM_DIM_ID | |
RTL_ITEM_DIM_LVL | |
CNT_TOTAL | |
IN_STCK_BU_ITM_DAYS | |
CNT_IN_STCK_BU_ITM_DAYS | |
UNDR_STCK_BU_ITM_DAYS | |
BSNS_MNTH_ID | |
CNT_UNDR_STCK_BU_ITM_DAYS | |
ON_HAND_QTY_PRMRY | |
ON_HAND_QTY_ALT | |
RECVD_QTY_PRMRY | |
RECVD_QTY_ALT | |
IN_TRANSIT_QTY_PRMRY | |
IN_TRANSIT_QTY_ALT | |
BCK_ORDR_QTY_PRMRY | |
BCK_ORDR_QTY_ALT | |
QLTY_HOLD_QTY_PRMRY | |
ORG_RGN_ID | |
QLTY_HOLD_QTY_ALT | |
ON_HAND_NET_COST_AMT | |
ON_HAND_NET_COST_AMT_RPT | |
RECVD_NET_COST_AMT | |
RECVD_NET_COST_AMT_RPT | |
IN_TRANSIT_NET_COST_AMT | |
IN_TRANSIT_NET_COST_AMT_RPT | |
BCKORDR_NET_COST_AMT | |
BCKORDR_NET_COST_AMT_RPT | |
QLTY_HOLD_NET_COST_AMT | |
ORG_CHAIN_ID | |
QLTY_HOLD_NET_COST_AMT_RPT | |
ON_HAND_RTL_AMT | |
ON_HAND_RTL_AMT_RPT | |
RECVD_RTL_AMT | |
RECVD_RTL_AMT_RPT | |
IN_TRANSIT_RTL_AMT | |
IN_TRANSIT_RTL_AMT_RPT | |
BCKORDR_RTL_AMT | |
BCKORDR_RTL_AMT_RPT | |
SYS_NC00085$ | |
QLTY_HOLD_RTL_AMT | |
MFG_ITEM_CLASS_ID | |
QLTY_HOLD_RTL_AMT_RPT | |
CNT_ON_HAND_QTY_PRMRY | |
CNT_ON_HAND_QTY_ALT | |
CNT_RECVD_QTY_PRMRY | |
CNT_RECVD_QTY_ALT | |
CNT_IN_TRANSIT_QTY_PRMRY | |
CNT_IN_TRANSIT_QTY_ALT | |
CNT_BCK_ORDR_QTY_PRMRY | |
CNT_BCK_ORDR_QTY_ALT | |
CNT_QLTY_HOLD_QTY_PRMRY | |
RTL_ITEM_CLASS_ID | |
CNT_QLTY_HOLD_QTY_ALT | |
CNT_ON_HAND_NET_COST_AMT | |
CNT_ON_HAND_NET_COST_AMT_RPT | |
CNT_RECVD_NET_COST_AMT | |
CNT_RECVD_NET_COST_AMT_RPT | |
CNT_IN_TRANSIT_NET_COST_AMT | |
CNT_IN_TRANSIT_NET_CST_AMT_RPT | |
CNT_BCKORDR_NET_COST_AMT | |
CNT_BCKORDR_NET_COST_AMT_RPT | |
CNT_QLTY_HOLD_NET_COST_AMT | |
ITM_TYP | |
CNT_QLTY_HOLD_NET_COST_AMT_RPT | |
SYS_NC00084$ | |
CNT_ON_HAND_RTL_AMT | |
CNT_ON_HAND_RTL_AMT_RPT | |
CNT_RECVD_RTL_AMT | |
CNT_RECVD_RTL_AMT_RPT | |
SYS_NC00083$ | |
CNT_IN_TRANSIT_RTL_AMT | |
CNT_IN_TRANSIT_RTL_AMT_RPT | |
CNT_BCKORDR_RTL_AMT | |
CNT_BCKORDR_RTL_AMT_RPT | |
CNT_QLTY_HOLD_RTL_AMT | |
BSNS_CLNDR_DIM_ID | |
CNT_QLTY_HOLD_RTL_AMT_RPT | |
GROUPING_ID | |
BSNS_CLNDR_DIM_LVL | |
SYS_NC00089$ | |
SYS_NC00082$ |
Application Object Library - DDR_SV_SHIP_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
BSNS_MNTH_ID | |
MFG_ITEM_DIM_ID | |
SYS_NC00024$ | |
MFG_ITEM_DIM_LVL | |
RTL_ITEM_DIM_ID | |
RTL_ITEM_DIM_LVL | |
CNT_TOTAL | |
SHIP_QTY_PRMRY | |
SHIP_QTY_ALT | |
SHIP_AMT | |
SHIP_AMT_RPT | |
CNT_SHIP_QTY_PRMRY | |
ORG_CHAIN_ID | |
CNT_SHIP_QTY_ALT | |
SYS_NC00025$ | |
CNT_SHIP_AMT | |
CNT_SHIP_AMT_RPT | |
GROUPING_ID | |
MFG_ITEM_CLASS_ID | |
RTL_ITEM_CLASS_ID | |
SYS_NC00028$ | |
ITM_TYP | |
BSNS_CLNDR_DIM_ID | |
SYS_NC00026$ | |
BSNS_CLNDR_DIM_LVL | |
ORG_DIM_ID | |
SYS_NC00029$ | |
ORG_DIM_LVL |
Application Object Library - DDR_SV_FRCST_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00035$ | |
BSNS_MNTH_ID | |
ORG_DIM_LVL | |
SYS_NC00029$ | |
MFG_ITEM_DIM_ID | |
MFG_ITEM_DIM_LVL | |
SYS_NC00032$ | |
RTL_ITEM_DIM_ID | |
RTL_ITEM_DIM_LVL | |
CNT_TOTAL | |
ACT_FRCST_SLS_AMT_RPT | |
ACT_FRCST_SLS_QTY_PRMRY | |
FRCST_SLS_QTY_PRMRY | |
FRCST_SLS_QTY_ALT | |
ORG_RGN_ID | |
FRCST_SLS_AMT | |
SYS_NC00030$ | |
FRCST_SLS_AMT_RPT | |
CNT_ACT_FRCST_SLS_AMT_RPT | |
CNT_ACT_FRCST_SLS_QTY_PRMRY | |
CNT_FRCST_SLS_QTY_PRMRY | |
CNT_FRCST_SLS_QTY_ALT | |
CNT_FRCST_SLS_AMT | |
CNT_FRCST_SLS_AMT_RPT | |
GROUPING_ID | |
ORG_CHAIN_ID | |
MFG_ITEM_CLASS_ID | |
SYS_NC00033$ | |
RTL_ITEM_CLASS_ID | |
ITM_TYP | |
SYS_NC00031$ | |
BSNS_CLNDR_DIM_ID | |
BSNS_CLNDR_DIM_LVL | |
SYS_NC00034$ | |
ORG_DIM_ID |
Application Object Library - DDR_SV_ORDR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
BSNS_MNTH_ID | |
MFG_ITEM_DIM_ID | |
MFG_ITEM_DIM_LVL | |
RTL_ITEM_DIM_ID | |
RTL_ITEM_DIM_LVL | |
CNT_TOTAL | |
SYS_NC00025$ | |
ORDR_QTY_PRMRY | |
ORDR_QTY_ALT | |
SYS_NC00028$ | |
ORDR_AMT | |
ORDR_AMT_RPT | |
SYS_NC00026$ | |
CNT_ORDR_QTY_PRMRY | |
ORG_CHAIN_ID | |
CNT_ORDR_QTY_ALT | |
SYS_NC00029$ | |
CNT_ORDR_AMT | |
CNT_ORDR_AMT_RPT | |
SYS_NC00024$ | |
GROUPING_ID | |
MFG_ITEM_CLASS_ID | |
RTL_ITEM_CLASS_ID | |
ITM_TYP | |
BSNS_CLNDR_DIM_ID | |
BSNS_CLNDR_DIM_LVL | |
ORG_DIM_ID | |
ORG_DIM_LVL |
Application Object Library - DDR_SV_SLSR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
BSNS_MNTH_ID | |
BSNS_CLNDR_DIM_ID | |
SYS_NC00054$ | |
BSNS_CLNDR_DIM_LVL | |
ORG_DIM_ID | |
SYS_NC00047$ | |
ORG_DIM_LVL | |
MFG_ITEM_DIM_ID | |
SYS_NC00050$ | |
MFG_ITEM_DIM_LVL | |
RTL_ITEM_DIM_ID | |
SYS_NC00053$ | |
RTL_ITEM_DIM_LVL | |
CNT_TOTAL | |
SYS_NC00046$ | |
ACT_BU_ITM_DAYS_SCANNED | |
ORG_RGN_ID | |
CNT_ACT_BU_ITM_DAYS_SCANNED | |
SYS_NC00052$ | |
SLS_QTY_PRMRY | |
SLS_QTY_ALT | |
SLS_AMT | |
SLS_AMT_RPT | |
SLS_COST_AMT | |
SLS_COST_AMT_RPT | |
RTRN_QTY_PRMRY | |
RTRN_QTY_ALT | |
RTRN_AMT | |
ORG_CHAIN_ID | |
RTRN_AMT_RPT | |
RTRN_COST_AMT | |
RTRN_COST_AMT_RPT | |
CNT_SLS_QTY_PRMRY | |
CNT_SLS_QTY_ALT | |
CNT_SLS_AMT | |
CNT_SLS_AMT_RPT | |
CNT_SLS_COST_AMT | |
CNT_SLS_COST_AMT_RPT | |
CNT_RTRN_QTY_PRMRY | |
MKT_AREA_ID | |
CNT_RTRN_QTY_ALT | |
SYS_NC00055$ | |
CNT_RTRN_AMT | |
CNT_RTRN_AMT_RPT | |
CNT_RTRN_COST_AMT | |
CNT_RTRN_COST_AMT_RPT | |
GROUPING_ID | |
CHNL_TYP_CD | |
ITM_TYP | |
SYS_NC00048$ | |
MFG_ITEM_CLASS_ID | |
RTL_ITEM_CLASS_ID | |
SYS_NC00051$ | |
PRMTN_FLAG |
Application Object Library - DDR_SV_CLS_QTR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00009$ | |
MFG_ORG_CD | |
SYS_NC00008$ | |
SYS_NC00010$ | |
SYS_NC00011$ | |
MFG_ITEM_CLASS_ID | |
BSNS_QTR_ID | |
NUM_MFG_SKU_ITEMS | |
QTR_TIMESPN | |
CNT_MNTHS | |
CNT_TOTAL |
Application Object Library - DDR_SV_ITM_BU_ASSC_QTR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
MFG_ORG_CD | |
SYS_NC00010$ | |
SYS_NC00015$ | |
SYS_NC00012$ | |
RTL_ORG_CD | |
SYS_NC00014$ | |
SYS_NC00011$ | |
RTL_BSNS_UNIT_ID | |
MFG_ITEM_ID | |
RTL_ITEM_ID | |
BSNS_QTR_ID | |
TOTAL_BU_ITM_DAYS | |
CNT_MNTHS | |
CNT_TOTAL |
Application Object Library - DDR_SV_CLS_YR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00009$ | |
MFG_ORG_CD | |
SYS_NC00008$ | |
SYS_NC00010$ | |
SYS_NC00011$ | |
MFG_ITEM_CLASS_ID | |
BSNS_YR_ID | |
NUM_MFG_SKU_ITEMS | |
YR_TIMESPN | |
CNT_QTRS | |
CNT_TOTAL |
Application Object Library - DDR_SV_ITM_BU_ASSC_YR_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00013$ | |
MFG_ORG_CD | |
SYS_NC00010$ | |
SYS_NC00015$ | |
SYS_NC00012$ | |
RTL_ORG_CD | |
SYS_NC00014$ | |
SYS_NC00011$ | |
RTL_BSNS_UNIT_ID | |
MFG_ITEM_ID | |
RTL_ITEM_ID | |
BSNS_YR_ID | |
TOTAL_BU_ITM_DAYS | |
CNT_QTRS | |
CNT_TOTAL |
Application Object Library - CSF_MD_ADM_BOUNDS_MAT_WM_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
AREA | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_HYDROS_MAT_EU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
WATER_TYPE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_LAND_USES_MAT_AU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
PARK_TYPE | |
SYS_NC00010$ | |
AREA | |
SYS_NC00006$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_LAND_USES_MAT_EU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
PARK_TYPE | |
SYS_NC00010$ | |
AREA | |
SYS_NC00006$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_LAND_USES_MAT_NA_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
PARK_TYPE | |
SYS_NC00010$ | |
AREA | |
SYS_NC00006$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_LAND_USES_MAT_WM_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00011$ | |
SYS_NC00009$ | |
PARK_TYPE | |
SYS_NC00010$ | |
AREA | |
SYS_NC00006$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_POIS_MAT_AU_V | |
---|---|
Column Name | Descritpion |
POI_ID | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
FEATURE_CODE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_ADM_BOUNDS_MAT_EU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
AREA | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_POIS_MAT_NA_V | |
---|---|
Column Name | Descritpion |
POI_ID | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
FEATURE_CODE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_POIS_MAT_EU_V | |
---|---|
Column Name | Descritpion |
POI_ID | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
FEATURE_CODE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_RAIL_SEGS_MAT_AU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00004$ | |
SYS_NC00009$ | |
SYS_NC00006$ | |
SYS_NC00003$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ |
Application Object Library - CSF_MD_POIS_MAT_WM_V | |
---|---|
Column Name | Descritpion |
POI_ID | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
FEATURE_CODE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_RAIL_SEGS_MAT_EU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00004$ | |
SYS_NC00009$ | |
SYS_NC00006$ | |
SYS_NC00003$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ |
Application Object Library - CSF_MD_RAIL_SEGS_MAT_NA_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00004$ | |
SYS_NC00009$ | |
SYS_NC00006$ | |
SYS_NC00003$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ |
Application Object Library - CSF_MD_RAIL_SEGS_MAT_WM_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00004$ | |
SYS_NC00009$ | |
SYS_NC00006$ | |
SYS_NC00003$ | |
SYS_NC00008$ | |
NAME | |
SYS_NC00005$ | |
GEOMETRY | |
SYS_NC00007$ |
Application Object Library - CSF_MD_RD_SEGS_FUN0_AU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN0_EU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN0_NA_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN0_WM_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN1_AU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN1_EU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN1_NA_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN1_WM_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN2_AU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN2_EU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN2_NA_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN2_WM_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN3_NA_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN3_EU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN3_AU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN3_WM_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN4_AU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN4_EU_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN4_NA_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CSF_MD_HYDROS_MAT_AU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
WATER_TYPE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - DDR_BS_BU_ITM_ASSC_WK_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00009$ | |
MFG_ORG_CD | |
RTL_ORG_CD | |
SYS_NC00008$ | |
RTL_BSNS_UNIT_ID | |
MFG_ITEM_ID | |
SYS_NC00010$ | |
BSNS_WK_ID | |
TOTAL_BU_ITM_DAYS | |
SYS_NC00007$ | |
SYS_NC00011$ |
Application Object Library - CSF_MD_HYDROS_MAT_WM_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
WATER_TYPE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_ADM_BOUNDS_MAT_AU_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
AREA | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_ADM_BOUNDS_MAT_NA_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
AREA | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_HYDROS_MAT_NA_V | |
---|---|
Column Name | Descritpion |
FEATURE_CODE | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00009$ | |
WATER_TYPE | |
SYS_NC00010$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
GEOMETRY |
Application Object Library - CSF_MD_RD_SEGS_FUN4_WM_V | |
---|---|
Column Name | Descritpion |
SYS_NC00003$ | |
SYS_NC00007$ | |
SYS_NC00004$ | |
SYS_NC00006$ | |
NAME | |
SYS_NC00008$ | |
SYS_NC00005$ | |
SYS_NC00002$ | |
GEOMETRY |
Application Object Library - CLA_CN_INV_BALANCE_GT | |
---|---|
Column Name | Descritpion |
TRANSACTION_DATE_FROM | |
BEGINNING_BALANCE_AMOUNT | |
PERIOD_INBOUND_QUANTITY | |
PERIOD_INBOUND_AMOUNT | |
PERIOD_OUTBOUND_QUANTITY | |
PERIOD_OUTBOUND_AMOUNT | |
ADJUSTMENT_COST | |
ENDING_BALANCE_QUANTITY | |
ENDING_BALANCE_AMOUNT | |
TRANSACTION_DATE_TO | |
ORGANIZATION_ID | |
SUBINVENTORY_CODE | |
ITEM_ID | |
ITEM_NUMBER | |
ITEM_DESCRIPTION | |
PRIMARY_UOM | |
BEGINNING_BALANCE_QUANTITY |
No hay comentarios:
Publicar un comentario