| Advanced Supply Chain Planning - MSC_INT_31_MEM_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__GROUP_NAME | |
| OI__OPERATION_CODE |
| Advanced Supply Chain Planning - MSC_INT_35_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__RUN_TIME | |
| OI__PRECEDING_OPERATION_CODE | |
| OI__TIME_UOM | |
| OI__RESOURCE_CODE | |
| OI__SCHEDULED_START_TIME | |
| OI__SNAPSHOT_DATE | |
| OI__INTEGRATION_ID | |
| OI__DESCRIPTION | |
| OI__NEXT_OPERATION_CODE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PLAN_NAME | |
| OI__FORECAST_CODE | |
| OI__PLAN_SOURCE | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__CREATED_DATE | |
| OI__PERIOD_SIZE | |
| OI__BRANCH_CODE | |
| OI__PRODUCTION_SCHEDULE_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_SET | |
| OI__28 | |
| OI__ACTUAL_RESOURCE_GROUP_NAME | |
| OI__SCHEDULED_END_TIME | |
| OI__ELAPSED_TIME |
| Advanced Supply Chain Planning - MSC_INT_34_E_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_CODE | |
| OI__PARENT_WORK_ORDER_CODE | |
| OI__20 | |
| OI__BRANCH_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__ITEM_CODE | |
| OI__QUANTITY | |
| OI__REMAINING_QUANTITY | |
| OI__YIELD | |
| OI__LEAD_TIME_OFFSET | |
| OI__END_TIME_OFFSET |
| Advanced Supply Chain Planning - MSC_INT_32_E_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_CODE | |
| OI__SETUP_TIME | |
| OI__QUEUE_TIME | |
| OI__MOVE_TIME | |
| OI__OVERLAP | |
| OI__TEMPORAL_RELATION | |
| OI__MIN_SEPARATION | |
| OI__MAX_SEPARATION | |
| OI__YIELD | |
| OI__CUMULATIVE_YIELD | |
| OI__START_DATE | |
| OI__BRANCH_CODE | |
| OI__REQUESTED_DATE | |
| OI__COMPLETION_DATE | |
| OI__ALLOW_OFFLOADING | |
| OI__EARLIEST_START | |
| OI__LATEST_END | |
| OI__OPERATION_SET_NAME | |
| OI__OPERATION_CODE | |
| OI__CONSTRAINTS_FLAG | |
| OI__RUN_TIME | |
| OI__STATUS | |
| OI__REMAINING_TIME | |
| OI__TIME_UNIT |
| Advanced Supply Chain Planning - MSC_INT_33_E_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_OR_GROUP | |
| OI__END_TIME_OFFSET | |
| OI__PARENT_WORK_ORDER_CODE | |
| OI__19 | |
| OI__ROUTING_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__OPERATION_SET_CODE | |
| OI__PREFERRED_OPERATION | |
| OI__WORK_ORDER_CODE | |
| OI__ITEM_CODE | |
| OI__QUANTITY | |
| OI__BRANCH_CODE | |
| OI__REMAINING_QUANTITY | |
| OI__SCRAP_FACTOR | |
| OI__CONSUMED_ITEM_SET | |
| OI__LEAD_TIME_OFFSET |
| Advanced Supply Chain Planning - MSC_INT_36_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__DURATION | |
| OI__TRANSPORT_MODE_CODE | |
| OI__DURATION_UNIT | |
| OI__OPERATION_INSTANCE_COUNT | |
| OI__SOURCING_TYPE | |
| OI__29 | |
| OI__30 | |
| OI__ITEM_CODE | |
| OI__FIRM_STATUS | |
| OI__ENABLE_DATE | |
| OI__DISABLE_DATE | |
| OI__INTEGRATION_ID | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__DESTINATION_CODE | |
| OI__OPERATION_CODE | |
| OI__OPERATION_DESCRIPTION | |
| OI__PLAN_NAME | |
| OI__OPERATION_SET_NAME | |
| OI__SCHEDULED_START_DATE | |
| OI__ORIGIN_CODE | |
| OI__SCHEDULED_COMPLETION_DATE |
| Advanced Supply Chain Planning - MSC_INT_40_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__21 | |
| OI__ACTUAL_RESOURCE_CODE | |
| OI__ACTUAL_RESOURCE_TYPE | |
| OI__22 | |
| OI__CAPACITY_REQUIRED | |
| OI__FORECAST_SOURCE | |
| OI__PLANNED_RESOURCE_TYPE | |
| OI__RESOURCE_SET | |
| OI__INTEGRATION_ID | |
| OI__START_DATE | |
| OI__CREATED_DATE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__PLANNED_RESOURCE_CODE | |
| OI__OPERATION_CODE | |
| OI__ITEM_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__DESCRIPTION | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_38_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__DURATION | |
| OI__CUSTOMER_CODE | |
| OI__DURATION_UNIT | |
| OI__OPERATION_INSTANCE_COUNT | |
| OI__NUMBER_OF_PERIODS | |
| OI__29 | |
| OI__30 | |
| OI__SNAPSHOT_DATE | |
| OI__FIRM_STATUS | |
| OI__PLAN_SOURCE | |
| OI__INTEGRATION_ID | |
| OI__CREATED_DATE | |
| OI__SCHEDULED_COMPLETION_DATE | |
| OI__SCHEDULED_START_DATE | |
| OI__OPERATION_DESCRIPTION | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__FORECAST_CODE | |
| OI__OPERATION_CODE | |
| OI__ITEM_CODE | |
| OI__PLAN_NAME | |
| OI__OPERATION_SET_NAME | |
| OI__DESCRIPTION | |
| OI__PERIOD_SIZE | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_37_TV_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SOURCING_PERCENT | |
| OI__PREFERENCE | |
| OI__ORIGIN_CODE | |
| OI__DESTINATION_CODE | |
| OI__SOURCING_TYPE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE |
| Advanced Supply Chain Planning - MSC_INT_39_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__WORK_ORDER_SCHEDULE_NAME | |
| OI__BRANCH_CODE | |
| OI__ACTUAL_ITEM_DESCRIPTION | |
| OI__QUANTITY | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__ACTUAL_ITEM_CODE | |
| OI__OPERATION_CODE | |
| OI__PLANNED_ITEM_CODE | |
| OI__INTEGRATION_ID | |
| OI__PLANNED_ITEM_DESCRIPTION | |
| OI__ENABLE_DATE | |
| OI__OPERATION_SET_NAME | |
| OI__DESCRIPTION | |
| OI__SOURCE | |
| OI__ITEM_CODE | |
| OI__CREATED_DATE | |
| OI__PLANNING_PERIOD_START_DATE | |
| OI__DISABLE_DATE | |
| OI__PLANNING_PERIOD_END_DATE | |
| OI__PLANNING_HORIZON_LENGTH | |
| OI__CONSUMED_ITEM_SET | |
| OI__HORIZON_UNITS |
| Advanced Supply Chain Planning - MSC_INT_3_TV | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| A__EFFECTIVE_DATE | |
| OI__COST | |
| OI__PREFERENCE |
| Advanced Supply Chain Planning - MSC_INT_41_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__WORK_ORDER_SCHEDULE_NAME | |
| OI__OPERATION_SET_NAME | |
| OI__TIME_UOM | |
| OI__DURATION | |
| OI__SCHEDULED_START_DATE | |
| OI__SCHEDULED_END_TIME | |
| OI__INTEGRATION_ID | |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_CODE | |
| OI__RUN_TIME | |
| OI__SCHEDULED_START_TIME | |
| OI__PRODUCTION_SCHEDULE_CODE | |
| OI__DESCRIPTION | |
| OI__PRECEDING_OPERATION_CODE | |
| OI__ELAPSED_TIME | |
| OI__NEXT_OPERATION_CODE | |
| OI__SOURCE | |
| OI__DURATION_UNIT | |
| OI__CREATED_DATE | |
| OI__PLANNING_PERIOD_START_DATE | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__PLANNING_PERIOD_END_DATE | |
| OI__PLANNING_HORIZON_LENGTH | |
| OI__SCHEDULED_COMPLETION_DATE | |
| OI__HORIZON_UNITS |
| Advanced Supply Chain Planning - MSC_INT_42_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__ACTUAL_ITEM_CODE | |
| OI__ACTUAL_ITEM_DESCRIPTION | |
| OI__PLANNED_ITEM_CODE | |
| OI__DESTINATION_CODE | |
| OI__PLANNED_ITEM_DESCRIPTION | |
| OI__CONSUMED_ITEM_SET | |
| OI__INTEGRATION_ID | |
| OI__PLAN_NAME | |
| OI__SOURCING_TYPE | |
| OI__ORIGIN_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| OI__ITEM_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__DESCRIPTION | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_43_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__WORK_ORDER_SCHEDULE_NAME | |
| OI__ITEM_CODE | |
| OI__QUANTITY | |
| OI__OPERATION_SET_NAME | |
| OI__INTEGRATION_ID | |
| OI__DESCRIPTION | |
| OI__SOURCE | |
| OI__BRANCH_CODE | |
| OI__CREATED_DATE | |
| OI__PLANNING_PERIOD_START_DATE | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__PLANNING_PERIOD_END_DATE | |
| OI__PLANNING_HORIZON_LENGTH | |
| OI__OPERATION_CODE | |
| OI__HORIZON_UNITS |
| Advanced Supply Chain Planning - MSC_INT_44_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__PLANNING_PERIOD_START_DATE | |
| OI__SOURCE | |
| OI__FORECAST_CODE | |
| OI__PLANNING_PERIOD_END_DATE | |
| OI__DESCRIPTION | |
| OI__PLAN_SOURCE | |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__CREATED_DATE | |
| OI__SNAPSHOT_DATE | |
| OI__INTEGRATION_ID | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE | |
| OI__PLANNING_HORIZON_LENGTH | |
| OI__HORIZON_UNITS |
| Advanced Supply Chain Planning - MSC_INT_5_TV | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__AVAILABLE | |
| OI__COST_PER_WEIGHT_UNIT | |
| OI__TRANSPORT_MODE_CODE | |
| OI__WEIGHT_CAPACITY | |
| OI__VOLUME_CAPACITY | |
| OI__ITEM_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__BRANCH_CODE | |
| A__EFFECTIVE_DATE | |
| OI__COST | |
| OI__PREFERENCE | |
| OI__COST_PER_VOLUME_UNIT | |
| OI__LEAD_TIME |
| Advanced Supply Chain Planning - MSC_INT_4_E | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__WORK_BREAKDOWN_LEVEL7 | |
| OI__VOLUME_CAPACITY_UOM | |
| OI__WORK_BREAKDOWN_LEVEL8 | |
| OI__WORK_BREAKDOWN_LEVEL9 | |
| OI__WEIGHT_CAPACITY_UOM | |
| OI__PREVIOUS_MILESTONE_CODE | |
| OI__NEXT_MILESTONE_CODE | |
| OI__LEAD_TIME_UOM | |
| OI__DESCRIPTION | |
| OI__ITEM_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__WORK_BREAKDOWN_LEVEL3 | |
| OI__VISIT_CODE | |
| OI__WORK_BREAKDOWN_LEVEL2 | |
| OI__WORK_ORDER_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__WORK_BREAKDOWN_LEVEL1 | |
| OI__BRANCH_CODE | |
| OI__MULTIPLE | |
| OI__RATIO | |
| OI__WORK_BREAKDOWN_LEVEL4 | |
| OI__WORK_BREAKDOWN_LEVEL5 | |
| OI__WORK_BREAKDOWN_LEVEL6 |
| Advanced Supply Chain Planning - MSC_INT_7_TV | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__FORECAST_CODE | |
| OI__QUANTITY | |
| OI__AVAILABLE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__BRANCH_CODE | |
| A__END_DATE | |
| A__EFFECTIVE_DATE | |
| OI__COST | |
| OI__PREFERENCE | |
| A__START_DATE |
| Advanced Supply Chain Planning - MSC_INT_6_E | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__SHIP_MULTIPLE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__MULTIPLE | |
| OI__RATIO | |
| OI__FORECAST_CODE | |
| OI__MINIMUM_SHIPMENT |
| Advanced Supply Chain Planning - MSC_INT_8_E | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_CODE | |
| OI__END_TIME_OFFSET | |
| OI__DESCRIPTION | |
| OI__PARENT_WORK_ORDER_CODE | |
| OI__16 | |
| OI__CREATED_DATE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__RATIO | |
| OI__BRANCH_CODE | |
| OI__CUSTOMER_CODE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE | |
| OI__MULTIPLE | |
| OI__OPERATION_SET_NAME | |
| OI__CONSUMED_ITEM_SET | |
| OI__PLAN_SOURCE | |
| OI__ITEM_CODE | |
| OI__QUANTITY | |
| OI__SNAPSHOT_DATE | |
| OI__REMAINING_QUANTITY | |
| OI__SCRAP_FACTOR | |
| OI__PLAN_NAME | |
| OI__LEAD_TIME_OFFSET |
| Advanced Supply Chain Planning - MSC_INT_9_E | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_CODE | |
| OI__PARENT_WORK_ORDER_CODE | |
| OI__SAFETY_COVERAGE | |
| OI__17 | |
| OI__BRANCH_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__ITEM_CODE | |
| OI__COVERAGE_UNIT | |
| OI__QUANTITY | |
| OI__REMAINING_QUANTITY | |
| OI__PLAN_NAME | |
| OI__YIELD | |
| OI__LEAD_TIME_OFFSET | |
| OI__END_TIME_OFFSET |
| Advanced Supply Chain Planning - MSC_INT_ALT_RES | |
|---|---|
| Column Name | Descritpion |
| OI__OPER_SET_CODE | |
| OI__NEW_ALT_NUM | |
| OI__RESOURCE_SET | |
| OI__ORGANIZATION_ID | |
| OI__DEPARTMENT_ID | |
| OI__OWNING_DEPARTMENT_ID | |
| OI__ITEM_ID | |
| OI__PRINCIPAL_FLAG | |
| OI__RESOURCE_USAGE | |
| OI__RESOURCE_UNITS | |
| OI__DURATION_RESOURCE | |
| OI__OLD_ALT_NUM | |
| OI__SCHEDULE_FLAG | |
| OI__TIME_UNIT | |
| OI__BASIS_TYPE | |
| OI__SCHEDULE_TO_INSTANCE | |
| OI__BATCH_OP_SEQ_NUM | |
| OI__FIRST_OP_SEQ_NUM | |
| OI__HAS_ALTERNATE | |
| OI__MAX_CAPACITY | |
| OI__RESOURCE_ID | |
| OI__SR_INSTANCE_ID | |
| OI__ROUTING_SEQUENCE_ID | |
| OI__BILL_SEQUENCE_ID | |
| OI__OPERATION_SEQ_NUM | |
| OI__OPERATION_SEQ_ID | |
| OI__RESOURCE_SEQ_NUM |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_GROUP | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__LEVEL | |
| OI__DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_OPERATION | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE |
| Advanced Supply Chain Planning - MSC_INT_BRANCH | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__LATITUDE | |
| OI__LONGITUDE | |
| OI__SHIPPING_CALENDAR | |
| OI__RECEIVING_CALENDAR | |
| OI__PRODUCTION_CALENDAR | |
| OI__BRANCH_NAME | |
| OI__ALTERNATE_BRANCH_ID | |
| OI__BRANCH_TYPE | |
| OI__DESCRIPTION | |
| OI__CITY | |
| OI__STATE_PROVINCE | |
| OI__COUNTRY | |
| OI__POSTAL_CODE |
| Advanced Supply Chain Planning - MSC_INT_BEGINNING_INVENTORY | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__QUALITY_CODE | |
| OI__USER_COMMENT | |
| OI__BRANCH_CODE | |
| OI__LOT_NUMBER | |
| OI__STORAGE_NAME | |
| OI__QUANTITY | |
| OI__LOT_STATUS | |
| OI__STATUS_DATE | |
| OI__MANUFACTURING_DATE | |
| OI__EXPIRY_DATE |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_GROUP_MEM | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__LEVEL | |
| OI__BRANCH_CODE |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_OPERATION_SET | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_OR_GROUP | |
| OI__ROUTING_CODE | |
| OI__OPERATION_SET_CODE | |
| OI__PREFERRED_OPERATION |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_OPERATION_TV | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| A__EFFECTIVE_DATE | |
| OI__AVAILABLE | |
| OI__OVERHEAD_COST |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_OPERATION_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_ROUTING | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ROUTING_CODE | |
| OI__DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_ROUTING_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ROUTING_CODE | |
| OI__DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_ROUTING_TV | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ROUTING_CODE | |
| A__EFFECTIVE_DATE | |
| OI__AVAILABLE | |
| OI__OVERHEAD_COST |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_ROUTING_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ROUTING_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE | |
| OI__OVERHEAD_COST |
| Advanced Supply Chain Planning - MSC_INT_CALENDAR | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__TYPE | |
| OI__CALENDAR_START_DATE | |
| OI__CALENDAR_END_DATE |
| Advanced Supply Chain Planning - MSC_INT_BRANCH_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__LATITUDE | |
| OI__LONGITUDE | |
| OI__SHIPPING_CALENDAR | |
| OI__RECEIVING_CALENDAR | |
| OI__PRODUCTION_CALENDAR | |
| OI__BRANCH_NAME | |
| OI__ALTERNATE_BRANCH_ID | |
| OI__BRANCH_TYPE | |
| OI__DESCRIPTION | |
| OI__CITY | |
| OI__STATE_PROVINCE | |
| OI__COUNTRY | |
| OI__POSTAL_CODE |
| Advanced Supply Chain Planning - MSC_INT_CALENDAR_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__CALENDAR_START_DATE | |
| OI__CALENDAR_END_DATE |
| Advanced Supply Chain Planning - MSC_INT_CALENDAR_TV | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| A__START_DATE | |
| A__END_DATE | |
| OI__EVENT_LABEL | |
| OI__EVENT_TYPE |
| Advanced Supply Chain Planning - MSC_INT_CHANGEOVER_PATTERN | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__COST | |
| OI__PATTERN_PRIORITY | |
| OI__AVAILABILITY_CALENDAR | |
| OI__RESOURCE_CODE | |
| OI__FROM_ATTRIBUTE_VALUE_CODE | |
| OI__TO_ATTRIBUTE_VALUE_CODE | |
| OI__ATTRIBUTE_CODE | |
| OI__DESCRIPTION | |
| OI__FROM_OPERATION | |
| OI__CHANGEOVER_TYPE | |
| OI__DURATION | |
| OI__TO_OPERATION | |
| OI__DURATION_UNITS |
| Advanced Supply Chain Planning - MSC_INT_CALENDAR_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| A__START_DATE | |
| A__END_DATE | |
| OI__UPTIME | |
| OI__DOWN | |
| OI__DELAY | |
| OI__PREMIUM |
| Advanced Supply Chain Planning - MSC_INT_CHANGEOVER_PATTERN_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__AVAILABILITY_CALENDAR | |
| OI__RESOURCE_CODE | |
| OI__FROM_OPERATION | |
| OI__FROM_ATTRIBUTE_VALUE_CODE | |
| OI__TO_ATTRIBUTE_VALUE_CODE | |
| OI__TO_OPERATION | |
| OI__DESCRIPTION | |
| OI__DURATION | |
| OI__DURATION_UNITS | |
| OI__COST | |
| OI__PATTERN_PRIORITY |
| Advanced Supply Chain Planning - MSC_INT_CONSUMED_ITEM_BOM_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__CONSUMED_ITEM_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__SCALING |
| Advanced Supply Chain Planning - MSC_INT_CONSUMED_ITEM_BOM_TV | |
|---|---|
| Column Name | Descritpion |
| OI__CONSUMED_ITEM_SET_CODE | |
| OI__PREFERENCE | |
| OI__OPERATION_CODE | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| A__EFFECTIVE_DATE | |
| OI__AVAILABLE | |
| OI__QUANTITY | |
| OI__SCRAP | |
| OI__CONSUMPTION_OVERHEAD_COST |
| Advanced Supply Chain Planning - MSC_INT_CONSUMED_ITEM_SET | |
|---|---|
| Column Name | Descritpion |
| OI__CONSUMED_ITEM_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__CONSUMED_ITEM_SET_NAME |
| Advanced Supply Chain Planning - MSC_INT_CONSUMED_ITEM_BOM | |
|---|---|
| Column Name | Descritpion |
| OI__CONSUMED_ITEM_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__SCALING |
| Advanced Supply Chain Planning - MSC_INT_CREW | |
|---|---|
| Column Name | Descritpion |
| OI__RESOURCE_CODE | |
| OI__CAPACITY_CONSTRAINT_STATUS | |
| OI__OFF_LOAD_WINDOW | |
| OI__OFF_LOAD_WINDOW_TIME_UNIT | |
| OI__BRANCH_CODE | |
| OI__7 | |
| OI__NAME | |
| OI__DEPARTMENT_CODE | |
| OI__DESCRIPTION | |
| OI__AVAILABILITY_CALENDAR | |
| OI__11 | |
| OI__TIME_FENCE_UNITS | |
| OI__10 | |
| OI__TIME_UNIT_FOR_COST |
| Advanced Supply Chain Planning - MSC_INT_CONSUMED_ITEM_SET_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__CONSUMED_ITEM_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__CONSUMED_ITEM_SET_NAME |
| Advanced Supply Chain Planning - MSC_INT_CREW_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__RESOURCE_CODE | |
| OI__OFF_LOAD_WINDOW | |
| OI__BRANCH_CODE | |
| OI__17 | |
| OI__NAME | |
| OI__DESCRIPTION | |
| OI__21 | |
| OI__AVAILABILITY_CALENDAR | |
| OI__27 | |
| OI__TIME_FENCE_UNITS | |
| OI__TIME_UNIT_FOR_COST | |
| OI__CAPACITY_CONSTRAINT_STATUS |
| Advanced Supply Chain Planning - MSC_INT_CREW_TV | |
|---|---|
| Column Name | Descritpion |
| OI__RESOURCE_CODE | |
| OI__BRANCH_CODE | |
| A__EFFECTIVE_DATE | |
| OI__AVAILABLE_CAPACITY | |
| OI__SETUP_COST | |
| OI__OPERATING_COST | |
| OI__PREMIUM_COST | |
| OI__FIXED_COST | |
| OI__OFF_LOAD_THRESHOLD |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__LONGITUDE | |
| OI__LATITUDE | |
| OI__DEFAULT_SERVICE_OBJECTIVE | |
| OI__NAME | |
| OI__ADDRESS1 | |
| OI__ADDRESS2 | |
| OI__ADDRESS3 | |
| OI__CITY | |
| OI__STATE_PROVINCE | |
| OI__COUNTRY | |
| OI__POSTAL_CODE |
| Advanced Supply Chain Planning - MSC_INT_CREW_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__RESOURCE_CODE | |
| OI__FIXED_COST | |
| OI__OFF_LOAD_THRESHOLD | |
| OI__BRANCH_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE_CAPACITY | |
| OI__PREMIUM_CAPACITY | |
| OI__SETUP_COST | |
| OI__OPERATING_COST | |
| OI__PREMIUM_COST |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_GROUP_MEM | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__LEVEL | |
| OI__CUSTOMER_CODE |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_GROUP | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__LEVEL | |
| OI__DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_GROUP_MEM_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__LEVEL | |
| OI__CUSTOMER_CODE |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_GROUP_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__NAME | |
| OI__LEVEL | |
| OI__DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__LONGITUDE | |
| OI__LATITUDE | |
| OI__DEFAULT_SERVICE_OBJECTIVE | |
| OI__NAME | |
| OI__ADDRESS1 | |
| OI__ADDRESS2 | |
| OI__ADDRESS3 | |
| OI__CITY | |
| OI__STATE_PROVINCE | |
| OI__COUNTRY | |
| OI__POSTAL_CODE |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_SOURCING_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__LEAD_TIME_UOM | |
| OI__RECEIVING_CALENDAR |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_SOURCING | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__LEAD_TIME_UOM | |
| OI__RECEIVING_CALENDAR |
| Advanced Supply Chain Planning - MSC_INT_CUSTOMER_SOURCING_TV | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| A__EFFECTIVE_DATE | |
| OI__PREFERENCE | |
| OI__LEAD_TIME |
| Advanced Supply Chain Planning - MSC_INT_ENTERPRISE_FORECAST | |
|---|---|
| Column Name | Descritpion |
| OI__FORECAST_CODE | |
| OI__FORECAST_SCENARIO | |
| OI__DESCRIPTION | |
| OI__CREATED_DATE | |
| OI__FORECAST_SOURCE | |
| OI__START_DATE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE | |
| OI__FORECAST_NAME |
| Advanced Supply Chain Planning - MSC_INT_INVENTORY_POLICY_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__13 | |
| OI__FORECAST_CONSUMPTION_RULE | |
| OI__22 | |
| OI__17 | |
| OI__TIME_FENCE_UNIT | |
| OI__COVERAGE_UNIT |
| Advanced Supply Chain Planning - MSC_INT_ITEM_BRANCH | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__USE_FIXED_MFG_LEAD_TIME | |
| OI__FIXED_MFG_LEAD_TIME | |
| OI__LEAD_TIME_UNITS | |
| OI__1 | |
| OI__2 | |
| OI__SHIPPING_CALENDAR | |
| OI__RECEIVING_CALENDAR | |
| OI__STORAGE_LOT_SIZE | |
| OI__BRANCH_CODE | |
| OI__ITEM_TYPE | |
| OI__SALEABLE | |
| OI__REBUILDABLE | |
| OI__ACTIVITY_ITEM_TYPE | |
| OI__HOLD_PERIOD | |
| OI__SHELF_LIFE | |
| OI__SHELF_LIFE_UOM |
| Advanced Supply Chain Planning - MSC_INT_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__VOLUME_UOM | |
| OI__STORAGE_REQUIREMENT | |
| OI__SCHEDULING_PRECISION | |
| OI__ITEM_NAME | |
| OI__ALTERNATE_ITEM_ID | |
| OI__DESCRIPTION | |
| OI__PLANNING_UOM | |
| OI__SHIPPING_UOM | |
| OI__WEIGHT | |
| OI__WEIGHT_UOM | |
| OI__VOLUME |
| Advanced Supply Chain Planning - MSC_INT_INVENTORY_POLICY | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__FORECAST_CONSUMPTION_RULE | |
| OI__3 | |
| OI__TIME_FENCE_UNIT | |
| OI__COVERAGE_UNIT |
| Advanced Supply Chain Planning - MSC_INT_INVENTORY_POLICY_TV | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| A__EFFECTIVE_DATE | |
| OI__MAXIMUM_LEVEL | |
| OI__MINIMUM_LEVEL | |
| OI__STOCKOUT_COST | |
| OI__MAXIMUM_COVERAGE | |
| OI__USE_COVER_FOR_SAFETY | |
| OI__USE_COVER_FOR_MAXIMUM |
| Advanced Supply Chain Planning - MSC_INT_ITEM_BRANCH_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__LEAD_TIME_UNITS | |
| OI__20 | |
| OI__21 | |
| OI__SHIPPING_CALENDAR | |
| OI__RECEIVING_CALENDAR | |
| OI__STORAGE_LOT_SIZE | |
| OI__BRANCH_CODE | |
| OI__12 | |
| OI__ITEM_TYPE | |
| OI__SALEABLE | |
| OI__11 | |
| OI__HOLD_PERIOD | |
| OI__SHELF_LIFE | |
| OI__16 | |
| OI__SHELF_LIFE_UOM | |
| OI__USE_FIXED_MFG_LEAD_TIME | |
| OI__15 | |
| OI__FIXED_MFG_LEAD_TIME |
| Advanced Supply Chain Planning - MSC_INT_31_E_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__RESOURCE_CODE |
| Advanced Supply Chain Planning - MSC_INT_35_MEM_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__GROUP_CODE | |
| OI__OPERATION_CODE |
| Advanced Supply Chain Planning - MSC_INT_32_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__RESOURCE_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__CAPACITY_REQUIRED | |
| OI__REQUIRED |
| Advanced Supply Chain Planning - MSC_INT_34_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE | |
| OI__OVERHEAD_COST |
| Advanced Supply Chain Planning - MSC_INT_36_E_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLIER_CODE | |
| OI__ORDER_POLICY | |
| OI__DEMAND_COVERAGE_UNITS | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__LEAD_TIME_UOM | |
| OI__ORDER_MULTIPLE | |
| OI__SHIPPING_CALENDAR | |
| OI__RECEIVING_CALENDAR | |
| OI__MINMAX_ORDER_PERIOD | |
| OI__MINMAX_ORDER_PERIOD_UNIT |
| Advanced Supply Chain Planning - MSC_INT_39_TV_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__CUSTOMER_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_37_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLIER_CODE | |
| OI__MAXIMUM_PERIOD_ORDER | |
| OI__FIXED_ORDER_QUANTITY | |
| OI__DEMAND_COVERAGE_ORDER | |
| OI__STANDARD_LEAD_TIME | |
| OI__PREMIUM_LEAD_TIME | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__PREFERENCE | |
| OI__STANDARD_COST | |
| OI__PREMIUM_COST | |
| OI__MINIMUM_PERIOD_ORDER |
| Advanced Supply Chain Planning - MSC_INT_43_TV_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SOURCING_PERCENT | |
| OI__PREFERENCE | |
| OI__ORIGIN_CODE | |
| OI__DESTINATION_CODE | |
| OI__SOURCING_TYPE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE |
| Advanced Supply Chain Planning - MSC_INT_45_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__SOURCING_TYPE | |
| OI__ENABLE_DATE | |
| OI__DISABLE_DATE |
| Advanced Supply Chain Planning - MSC_INT_47_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__DURATION_UNIT | |
| OI__OPERATION_INSTANCE_COUNT | |
| OI__24 | |
| OI__25 | |
| OI__INTEGRATION_ID | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__23 | |
| OI__OPERATION_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__SCHEDULED_START_DATE | |
| OI__SCHEDULED_COMPLETION_DATE | |
| OI__DURATION |
| Advanced Supply Chain Planning - MSC_INT_48_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__ACTUAL_ITEM_CODE | |
| OI__ACTUAL_ITEM_DESCRIPTION | |
| OI__QUANTITY | |
| OI__INTEGRATION_ID | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| OI__PLANNED_ITEM_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__CONSUMED_ITEM_SET | |
| OI__PLANNED_ITEM_DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_46_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__INTEGRATION_ID | |
| OI__22 | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_SET | |
| OI__23 | |
| OI__ACTUAL_RESOURCE_GROUP_NAME |
| Advanced Supply Chain Planning - MSC_INT_49_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__INTEGRATION_ID | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| OI__ITEM_CODE | |
| OI__OPERATION_SET_NAME | |
| OI__DESCRIPTION | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_50_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__WORK_ORDER_SCHEDULE_NAME | |
| OI__INTEGRATION_ID | |
| OI__DESCRIPTION | |
| OI__SOURCE | |
| OI__CREATED_DATE | |
| OI__PLANNING_PERIOD_START_DATE | |
| OI__PLANNING_PERIOD_END_DATE | |
| OI__PLANNING_HORIZON_LENGTH | |
| OI__HORIZON_UNITS |
| Advanced Supply Chain Planning - MSC_INT_9_TV | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__ITEM_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__BRANCH_CODE | |
| A__EFFECTIVE_DATE | |
| OI__COST | |
| OI__PREFERENCE |
| Advanced Supply Chain Planning - MSC_INT_ACTUAL_RESOURCE_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__CAPACITY_REQUIRED | |
| OI__INTEGRATION_ID | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_SET | |
| OI__RESOURCE_CODE | |
| OI__RESOURCE_TYPE | |
| OI__RESOURCE_DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_ASCP_DEMANDS | |
|---|---|
| Column Name | Descritpion |
| CATEGORY | |
| DEMAND | |
| INSTANCEID | |
| ITEMID | |
| ORGANIZATIONID | |
| PLAN_ID | |
| PERIODEND | |
| SATISFIED | |
| ZONEID |
| Advanced Supply Chain Planning - MSC_INT_ASCP_EXCEPTION_DETAILS | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| PERCENTAGE | |
| PERIODSTART | |
| PERIODEND | |
| ORGANIZATION_ID | |
| ZONE_ID | |
| INSTANCE_ID | |
| ALERTCATEGORY | |
| VIOLATIONCODE | |
| ITEMID | |
| DEPARTMENTID | |
| QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_ASCP_EXPORT_BUCKETS | |
|---|---|
| Column Name | Descritpion |
| PLANID | |
| BUCKETINDEX | |
| BKTSTARTDATE | |
| BKTENDDATE | |
| DAYSINBUCKET | |
| BUCKETTYPE |
| Advanced Supply Chain Planning - MSC_INT_ASCP_DEPENDENT_DEMAND | |
|---|---|
| Column Name | Descritpion |
| CATEGORY | |
| FROMORGID | |
| INSTANCEID | |
| ITEMID | |
| PLAN_ID | |
| PERIODEND | |
| QUANTITY | |
| TOORGID |
| Advanced Supply Chain Planning - MSC_INT_ASCP_LABOUR_UTIL | |
|---|---|
| Column Name | Descritpion |
| UTILIZATION | |
| RESOURCEID | |
| USED | |
| CAPACITY | |
| DETAIL_LEVEL | |
| DEPARTMENTID | |
| INSTANCEID | |
| ORGANIZATIONID | |
| OVERCOST | |
| PLAN_ID | |
| PERIODEND |
| Advanced Supply Chain Planning - MSC_INT_ASCP_KPI | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| CUSTOMER_ID | |
| CUSTOMER_SITE_ID | |
| PRODUCTIONCOST | |
| SUPPLYCOST | |
| INVENTORYCOST | |
| DEMANDCOST | |
| OTHERCOST | |
| ZONEID | |
| DEMANDFILLRATE | |
| ORGANIZATIONID | |
| TRANSPORTATIONCOST | |
| INSTANCEID | |
| SOURCE_ORGANIZATION_ID | |
| TOTALCOST | |
| SOURCE_ORG_INSTANCE_ID | |
| SCENARIONAME | |
| ITEMID | |
| PERIODTYPE | |
| PERIODEND | |
| DEPARTMENTID | |
| TRANSPORTATIONMODE |
| Advanced Supply Chain Planning - MSC_INT_ASCP_INVENTORY | |
|---|---|
| Column Name | Descritpion |
| CATEGORY | |
| STORAGEAMOUNT | |
| INSTANCEID | |
| ITEMID | |
| ONHAND | |
| ORGANIZATIONID | |
| PLAN_ID | |
| PERIOD | |
| PERIODEND | |
| SAFETY |
| Advanced Supply Chain Planning - MSC_INT_ASCP_MFG_PLAN_LABOUR | |
|---|---|
| Column Name | Descritpion |
| CATEGORY | |
| RESOURCEID | |
| RESOURCEUSAGE | |
| DEPARTMENTID | |
| FLOW | |
| INSTANCEID | |
| ITEMID | |
| ORGANIZATIONID | |
| PLAN_ID | |
| PERIODEND | |
| RESOURCECOST |
| Advanced Supply Chain Planning - MSC_INT_ASCP_TOTALPRODCOST | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| ORGANIZATIONID | |
| INSTANCEID | |
| ITEMID | |
| PERIODEND | |
| TOTALPRODCOST |
| Advanced Supply Chain Planning - MSC_INT_ASCP_PRODCOST_KPI | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| ORGANIZATIONID | |
| INSTANCEID | |
| ITEMID | |
| PERIODEND | |
| PRODCOST |
| Advanced Supply Chain Planning - MSC_INT_ASCP_MACHINE_UTIL | |
|---|---|
| Column Name | Descritpion |
| UTILIZATION | |
| RESOURCEID | |
| USED | |
| CAPACITY | |
| DETAIL_LEVEL | |
| DEPARTMENTID | |
| INSTANCEID | |
| ORGANIZATIONID | |
| OVERCOST | |
| PLAN_ID | |
| PERIODEND |
| Advanced Supply Chain Planning - MSC_INT_ASCP_SUPPLY | |
|---|---|
| Column Name | Descritpion |
| CAPACITY | |
| SUPPLIERSITEID | |
| SUPPLY | |
| CATEGORY | |
| COST | |
| INSTANCEID | |
| ITEMID | |
| ORGANIZATIONID | |
| PLAN_ID | |
| PERIODEND | |
| SUPPLIERID |
| Advanced Supply Chain Planning - MSC_INT_ASCP_MFG_PLAN_MACHINE | |
|---|---|
| Column Name | Descritpion |
| CATEGORY | |
| RESOURCEID | |
| RESOURCEUSAGE | |
| DEPARTMENTID | |
| FLOW | |
| INSTANCEID | |
| ITEMID | |
| ORGANIZATIONID | |
| PLAN_ID | |
| PERIODEND | |
| RESOURCECOST |
| Advanced Supply Chain Planning - MSC_INT_ASCP_TRANSPCOST_KPI | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| ORGANIZATIONID | |
| INSTANCEID | |
| ITEMID | |
| PERIODEND | |
| TRANSPCOST |
| Advanced Supply Chain Planning - MSC_INT_ATTRIBUTE_VALUE | |
|---|---|
| Column Name | Descritpion |
| OI__ATTRIBUTE_CODE | |
| OI__ATTRIBUTE_VALUE_CODE | |
| OI__11 | |
| OI__19 |
| Advanced Supply Chain Planning - MSC_INT_ASSIGNED_ATTRIBUTE | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__OPERATION_CODE | |
| OI__ATTRIBUTE_CODE | |
| OI__ATTRIBUTE_VALUE_CODE |
| Advanced Supply Chain Planning - MSC_INT_ASCP_TRANSPORTATION | |
|---|---|
| Column Name | Descritpion |
| CAPACITY | |
| QUANTITY | |
| SUBCATEGORY | |
| TOORGID | |
| CATEGORY | |
| TOINSTANCEID | |
| COST | |
| FROMINSTANCEID | |
| FROMORGID | |
| ITEMID | |
| TRANSPORTMODE | |
| PLAN_ID | |
| PERIODEND |
| Advanced Supply Chain Planning - MSC_INT_BOR_RES_NAME | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__ALT_NUM | |
| OI__RESOURCE_CODE | |
| OI__BOR_NAME |
| Advanced Supply Chain Planning - MSC_INT_CFC_SCENARIO_DETAILS | |
|---|---|
| Column Name | Descritpion |
| DEMAND_PLAN_ID | |
| LAST_REVISION | |
| SCENARIO_ID | |
| SCENARIO_NAME | |
| OUTPUT_PERIOD_TYPE | |
| HORIZON_START_DATE | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY |
| Advanced Supply Chain Planning - MSC_INT_ENT_FCST_DETAIL_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__FORECAST_CODE | |
| OI__CUSTOMER_CODE | |
| OI__FORECAST_DETAIL_NAME |
| Advanced Supply Chain Planning - MSC_INT_ENT_FCST_DETAIL_TV | |
|---|---|
| Column Name | Descritpion |
| OI__FORECAST_CODE | |
| OI__FORECAST_PRIORITY | |
| OI__SATISFACTION_DATE | |
| OI__FORECAST_SCENARIO | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__CUSTOMER_CODE | |
| OI__FORECAST_DETAIL_NAME | |
| A__START_DATE | |
| A__END_DATE | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_ENT_FCST_DETAIL | |
|---|---|
| Column Name | Descritpion |
| OI__FORECAST_CODE | |
| OI__FORECAST_SCENARIO | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__CUSTOMER_CODE | |
| OI__FORECAST_DETAIL_NAME |
| Advanced Supply Chain Planning - MSC_INT_ENT_FCST_DETAIL_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__FORECAST_CODE | |
| OI__CUSTOMER_CODE | |
| OI__FORECAST_DETAIL_NAME | |
| A__START_DATE | |
| A__END_DATE | |
| OI__QUANTITY |
| Advanced Supply Chain Planning - MSC_INT_IMPLEMENTING_RESOURCE | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__RESOURCE_CODE |
| Advanced Supply Chain Planning - MSC_INT_IMPL_RES | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__ALT_NUM | |
| OI__RESOURCE_CODE |
| Advanced Supply Chain Planning - MSC_INT_FIXED_PRODUCTION_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE |
| Advanced Supply Chain Planning - MSC_INT_INV_SAFE_TAR | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SAFETY_STOCK_SCENARIO | |
| OI__DESCRIPTION | |
| OI__PLAN_SOURCE | |
| OI__CREATED_DATE | |
| OI__SNAPSHOT_DATE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE |
| Advanced Supply Chain Planning - MSC_INT_INV_SAFE_TAR_DETAIL_TV | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SAFETY_STOCK_SCENARIO | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| A__EFFECTIVE_DATE | |
| OI__SAFETY_COVERAGE | |
| OI__SAFETY_LEVEL |
| Advanced Supply Chain Planning - MSC_INT_INV_SAFE_TAR_DETAIL | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SAFETY_STOCK_SCENARIO | |
| OI__ITEM_CODE | |
| OI__BRANCH_CODE | |
| OI__COVERAGE_UNIT |
| Advanced Supply Chain Planning - MSC_INT_INV_SAFE_TAR_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__DESCRIPTION | |
| OI__PLAN_SOURCE | |
| OI__CREATED_DATE | |
| OI__SNAPSHOT_DATE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE |
| Advanced Supply Chain Planning - MSC_INT_31_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__FORECAST_SOURCE | |
| OI__PERIOD_SIZE | |
| OI__ORIGIN_CODE | |
| OI__NUMBER_OF_PERIODS | |
| OI__DESTINATION_CODE | |
| OI__SOURCING_TYPE | |
| OI__DESCRIPTION | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| OI__CREATED_DATE | |
| OI__START_DATE |
| Advanced Supply Chain Planning - MSC_INT_32_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PRODUCTION_SCHEDULE_CODE | |
| OI__RUN_TIME | |
| OI__TIME_UOM | |
| OI__INTEGRATION_ID | |
| OI__RESOURCE_CODE | |
| OI__BRANCH_CODE | |
| OI__SCHEDULED_START_TIME | |
| OI__PRECEDING_OPERATION_CODE | |
| OI__NEXT_OPERATION_CODE | |
| OI__SCHEDULED_END_TIME | |
| OI__ELAPSED_TIME |
| Advanced Supply Chain Planning - MSC_INT_32_TV_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SOURCING_PERCENT | |
| OI__BRANCH_CODE | |
| OI__PREFERENCE | |
| OI__ORIGIN_CODE | |
| OI__ITEM_CODE | |
| OI__DESTINATION_CODE | |
| OI__SOURCING_TYPE | |
| A__END_DATE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__QUANTITY | |
| A__START_DATE | |
| OI__CUSTOMER_CODE | |
| OI__AVAILABLE |
| Advanced Supply Chain Planning - MSC_INT_33_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__TRANSPORT_MODE_CODE | |
| OI__FORECAST_CODE | |
| OI__ORIGIN_CODE | |
| OI__DESCRIPTION | |
| OI__PLAN_SOURCE | |
| OI__ITEM_CODE | |
| OI__CREATED_DATE | |
| OI__SNAPSHOT_DATE | |
| OI__SOURCING_TYPE | |
| OI__NUMBER_OF_PERIODS | |
| OI__PERIOD_SIZE | |
| OI__DESTINATION_CODE |
| Advanced Supply Chain Planning - MSC_INT_34_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__RUN_TIME | |
| OI__TIME_UOM | |
| OI__INTEGRATION_ID | |
| OI__BRANCH_CODE | |
| OI__SOURCING_TYPE | |
| OI__ENABLE_DATE | |
| OI__RESOURCE_CODE | |
| OI__DISABLE_DATE | |
| OI__PRECEDING_OPERATION_CODE | |
| OI__PRODUCTION_SCHEDULE_CODE | |
| OI__NEXT_OPERATION_CODE | |
| OI__SCHEDULED_END_TIME | |
| OI__SCHEDULED_START_TIME | |
| OI__ELAPSED_TIME |
| Advanced Supply Chain Planning - MSC_INT_34_TV_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SOURCING_PERCENT | |
| OI__PREFERENCE | |
| OI__ORIGIN_CODE | |
| OI__DESTINATION_CODE | |
| OI__SOURCING_TYPE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE |
| Advanced Supply Chain Planning - MSC_INT_36_TV_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__PLAN_NAME | |
| OI__SOURCING_PERCENT | |
| OI__PREFERENCE | |
| OI__ORIGIN_CODE | |
| OI__DESTINATION_CODE | |
| OI__SOURCING_TYPE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__ITEM_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__AVAILABLE |
| Advanced Supply Chain Planning - MSC_INT_37_E_PLAN | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_SCHEDULE_CODE | |
| OI__ACTUAL_ITEM_CODE | |
| OI__ACTUAL_ITEM_DESCRIPTION | |
| OI__QUANTITY | |
| OI__INTEGRATION_ID | |
| OI__RESOURCE_SET | |
| OI__PEGGED_WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__ACTUAL_RESOURCE_GROUP_NAME | |
| OI__OPERATION_CODE | |
| OI__PLANNED_ITEM_CODE | |
| OI__28 | |
| OI__OPERATION_SET_NAME | |
| OI__CONSUMED_ITEM_SET | |
| OI__PLANNED_ITEM_DESCRIPTION |
| Advanced Supply Chain Planning - MSC_INT_6_TV | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLIER_CODE | |
| OI__FIXED_ORDER_QUANTITY | |
| OI__CAPACITY_REQUIRED | |
| OI__DEMAND_COVERAGE_ORDER | |
| OI__STANDARD_LEAD_TIME | |
| OI__OPERATION_CODE | |
| OI__PREMIUM_LEAD_TIME | |
| OI__RESOURCE_SET_CODE | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__REQUIRED | |
| OI__PREFERENCE | |
| OI__STANDARD_COST | |
| A__EFFECTIVE_DATE | |
| OI__PREMIUM_COST | |
| OI__MINIMUM_PERIOD_ORDER | |
| OI__RESOURCE_CODE | |
| OI__MAXIMUM_PERIOD_ORDER |
| Advanced Supply Chain Planning - MSC_INT_5_E | |
|---|---|
| Column Name | Descritpion |
| OI__WORK_ORDER_CODE | |
| OI__BRANCH_CODE | |
| OI__FIRST_OPERATION_CODE | |
| OI__SECOND_OPERATION_CODE | |
| OI__TEMPORAL_RELATION | |
| OI__MIN_SEPARATION | |
| OI__MAX_SEPARATION | |
| OI__MIN_SEPARATION_TIME_UNIT | |
| OI__MAX_SEPARATION_TIME_UNIT |
| Advanced Supply Chain Planning - MSC_INT_9_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__USE_COVER_FOR_MAXIMUM | |
| OI__ITEM_CODE | |
| OI__MAXIMUM_LEVEL | |
| OI__SUBSTITUTE_ITEM_CODE | |
| A__START_DATE | |
| OI__STOCKOUT_COST | |
| A__END_DATE | |
| OI__COST | |
| OI__PREFERENCE | |
| OI__MAXIMUM_COVERAGE | |
| OI__MINIMUM_LEVEL | |
| OI__USE_COVER_FOR_SAFETY |
| Advanced Supply Chain Planning - MSC_INT_APCC_ITEM_SOURCE | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| SR_INSTANCE_ID | |
| ORGANIZATION_ID | |
| INVENTORY_ITEM_ID | |
| SOURCE_ORG_INSTANCE_ID | |
| SOURCE_ORGANIZATION_ID |
| Advanced Supply Chain Planning - MSC_INT_APCC_ORG_DETAIL | |
|---|---|
| Column Name | Descritpion |
| PLAN_ID | |
| SR_INSTANCE_ID | |
| ORGANIZATION_ID | |
| PERIOD_END | |
| FACILITY_COST | |
| FACILITY_COST_TYPE |
| Advanced Supply Chain Planning - MSC_INT_ACTUAL_RES_HRS | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLY_ID | |
| OI__ASSIGNED_UNITS | |
| OI__START_DATE | |
| OI__END_DATE | |
| OI__RESOURCE_ID | |
| OI__OPERATION_SEQ_NUM | |
| OI__RESOURCE_SEQ_NUM | |
| OI__SR_INSTANCE_ID | |
| OI__ORGANIZATION_ID | |
| OI__DEPARTMENT_ID | |
| OI__RESOURCE_USAGE | |
| OI__ACTUAL_RESOURCE_USAGE |
| Advanced Supply Chain Planning - MSC_INT_8_TV | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLIER_CODE | |
| OI__FIXED_ORDER_QUANTITY | |
| OI__DEMAND_COVERAGE_ORDER | |
| OI__STANDARD_LEAD_TIME | |
| OI__PREMIUM_LEAD_TIME | |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| A__EFFECTIVE_DATE | |
| OI__PREFERENCE | |
| OI__STANDARD_COST | |
| OI__PREMIUM_COST | |
| OI__MINIMUM_PERIOD_ORDER | |
| OI__MAXIMUM_PERIOD_ORDER |
| Advanced Supply Chain Planning - MSC_INT_CUST_ITEM_TR_MODE_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__CUSTOMER_CODE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__SHIP_MULTIPLE | |
| OI__MINIMUM_SHIPMENT |
| Advanced Supply Chain Planning - MSC_INT_CUST_ITEM_TR_MODE | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__CUSTOMER_CODE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__SHIP_MULTIPLE | |
| OI__MINIMUM_SHIPMENT |
| Advanced Supply Chain Planning - MSC_INT_CUST_TR_MODE | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__DESCRIPTION | |
| OI__LEAD_TIME_UOM | |
| OI__WEIGHT_CAPACITY_UOM | |
| OI__VOLUME_CAPACITY_UOM |
| Advanced Supply Chain Planning - MSC_INT_CUST_TR_MODE_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| OI__DESCRIPTION | |
| OI__LEAD_TIME_UOM | |
| OI__WEIGHT_CAPACITY_UOM | |
| OI__VOLUME_CAPACITY_UOM |
| Advanced Supply Chain Planning - MSC_INT_CUST_ITEM_TR_MODE_TV | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__CUSTOMER_CODE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| A__EFFECTIVE_DATE | |
| OI__PREFERENCE | |
| OI__AVAILABLE |
| Advanced Supply Chain Planning - MSC_INT_CUST_TR_MODE_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__LEAD_TIME | |
| OI__AVAILABLE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__WEIGHT_CAPACITY | |
| OI__VOLUME_CAPACITY | |
| OI__COST_PER_WEIGHT_UNIT | |
| OI__COST_PER_VOLUME_UNIT |
| Advanced Supply Chain Planning - MSC_INT_CUST_TR_MODE_TV | |
|---|---|
| Column Name | Descritpion |
| OI__CUSTOMER_CODE | |
| OI__AVAILABLE | |
| OI__BRANCH_CODE | |
| OI__TRANSPORT_MODE_CODE | |
| A__EFFECTIVE_DATE | |
| OI__WEIGHT_CAPACITY | |
| OI__VOLUME_CAPACITY | |
| OI__COST_PER_WEIGHT_UNIT | |
| OI__COST_PER_VOLUME_UNIT | |
| OI__LEAD_TIME |
| Advanced Supply Chain Planning - MSC_INT_IMPLEMENTING_RES | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__RESOURCE_CODE |
| Advanced Supply Chain Planning - MSC_INT_IMPLEMENTING_RES_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__RESOURCE_CODE |
| Advanced Supply Chain Planning - MSC_INT_IMPLEMENTING_RES_TV | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__RESOURCE_SET_CODE | |
| OI__OPERATION_CODE | |
| OI__RESOURCE_GROUP_NAME | |
| OI__RESOURCE_CODE | |
| A__EFFECTIVE_DATE | |
| OI__CAPACITY_REQUIRED | |
| OI__REQUIRED |
| Advanced Supply Chain Planning - MSC_INT_7_TV_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_CODE | |
| OI__USE_COVER_FOR_MAXIMUM | |
| OI__BRANCH_CODE | |
| A__START_DATE | |
| A__END_DATE | |
| OI__MAXIMUM_LEVEL | |
| OI__MINIMUM_LEVEL | |
| OI__STOCKOUT_COST | |
| OI__MAXIMUM_COVERAGE | |
| OI__USE_COVER_FOR_SAFETY |
| Advanced Supply Chain Planning - MSC_INT_8_E_SNO | |
|---|---|
| Column Name | Descritpion |
| OI__BRANCH_CODE | |
| OI__ITEM_CODE | |
| OI__SUBSTITUTE_ITEM_CODE | |
| OI__RATIO | |
| OI__MULTIPLE |
| Advanced Supply Chain Planning - MSC_INT_ALL_DEMAND_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID |
| Advanced Supply Chain Planning - MSC_INT_ALL_SUPPLY_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID |
| Advanced Supply Chain Planning - MSC_INT_ALL_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID |
| Advanced Supply Chain Planning - MSC_INT_ASCP_END_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID |
| Advanced Supply Chain Planning - MSC_INT_ASCP_SUPPLY_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID |
| Advanced Supply Chain Planning - MSC_INT_ASSET | |
|---|---|
| Column Name | Descritpion |
| OI__ASSET_NUMBER | |
| OI__RESOURCE_ID | |
| OI__ASSET_DESCRIPTION | |
| OI__ASSET_GROUP_CODE | |
| OI__ASSET_GROUP | |
| OI__ASSET_GROUP_DESCRIPTION | |
| OI__EQUIPMENT_ITEM_ID | |
| OI__EQUIPMENT_ITEM | |
| OI__EQUIPMENT_SERIAL_NUMBER | |
| OI__DEPARTMENT_ID |
| Advanced Supply Chain Planning - MSC_INT_CMRO_OP_REL | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLY_ID | |
| OI__MIN_SEP_TIME_UNIT | |
| OI__MAX_SEPARATION | |
| OI__MAX_SEP_TIME_UNIT | |
| OI__SR_INSTANCE_ID | |
| OI__ORGANIZATION_ID | |
| OI__FROM_OP_SEQ_NUM | |
| OI__FROM_OP_RES_SEQ_NUM | |
| OI__TO_OP_SEQ_NUM | |
| OI__TO_OP_RES_SEQ_NUM | |
| OI__PRECEDENCE_CONSTRAINT | |
| OI__MIN_SEPARATION |
| Advanced Supply Chain Planning - MSC_INT_CMRO_RES_REQS | |
|---|---|
| Column Name | Descritpion |
| OI__SUPPLY_ID | |
| OI__SR_INSTANCE_ID | |
| OI__ORGANIZATION_ID | |
| OI__OPERATION_SEQ_NUM | |
| OI__RESOURCE_SEQ_NUM | |
| OI__OPERATION_SEQ_ID | |
| OI__RESOURCE_ID | |
| OI__DEPARTMENT_ID | |
| OI__SCHEDULE_FLAG |
| Advanced Supply Chain Planning - MSC_INT_COMPONENT_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID | |
| OI__BILL_SEQUENCE_ID |
| Advanced Supply Chain Planning - MSC_INT_END_ITEM | |
|---|---|
| Column Name | Descritpion |
| OI__ITEM_ID |
| Advanced Supply Chain Planning - MSC_INT_EQUIPMENT | |
|---|---|
| Column Name | Descritpion |
| OI__RESOURCE_CODE | |
| OI__BRANCH_CODE | |
| OI__EQUIPMENT_ITEM | |
| OI__EQUIPMENT_SERIAL_NUMBER | |
| OI__EQUIPMENT_DESCRIPTION |
No hay comentarios:
Publicar un comentario