martes, 29 de abril de 2014

My FND Table Descriptions hand book (I have big hands) part1

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() etc Are used for fast refreshability
ENT_QTR_ID Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
ENT_PERIOD_ID Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
XGRP Columns like ent_yr_id,grouping_id() etc Are used for fast refreshability
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