Advanced Supply Chain Planning - MSC_ITEMS | This table is used by the collection program to keep track of all inventory item identifiers generated at planning server. |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | Item identifier generated by the collection program from Staging tables to ODS. |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ITEM_NAME | Item name |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
DESCRIPTION | Item description |
ATTRIBUTE15 | Descriptive flexfield segment |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
Advanced Supply Chain Planning - MSC_ITEM_CATEGORIES | This table stores the item assignment to categories within a category set. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
ENABLED_FLAG | Flag indicating whether segment is enabled |
INVENTORY_ITEM_ID | Inventory item identifier |
START_DATE_ACTIVE | Date segment combination becomes active |
END_DATE_ACTIVE | Date segment combination becomes inactive |
SR_INSTANCE_ID | Source application instance identifier |
SR_CATEGORY_ID | Source category identifier |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
CATEGORY_SET_ID | Category set identifier |
ATTRIBUTE15 | Descriptive flexfield segment |
CATEGORY_NAME | Category set name |
DESCRIPTION | Category description |
DISABLE_DATE | Disable date |
SUMMARY_FLAG | Flag indicating whether segment combination includes a summary flag |
Advanced Supply Chain Planning - MSC_ITEM_EXCEPTIONS | This table stores a row per exception message against an item for exceptions generated in the Oracle Advanced planning and scheduling (APS) and the Oracle Supply Chain Hub products. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
DISPLAY | Flag to indicate whether to display this exception |
EXCEPTION_COUNT | Number of exception (for this item) |
RESOURCE_ID | Resource identifier |
DEPARTMENT_ID | Department identifier |
EXCEPTION_GROUP | Indicate item exception group |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
SUPPLIER_ID | Supplier identifier |
SUPPLIER_SITE_ID | Supplier site identifier |
NEW_EXCEPTION_COUNT | New exception count |
COMPANY_ID | Company Identifier |
COMPANY_SITE_ID | Company site identifier |
ORGANIZATION_ID | Organization identifier |
SR_INSTANCE_ID | Source instance identifier for the source org |
INVENTORY_ITEM_ID | Inventory item identifier |
PROJECT_ID | Project identifier |
TASK_ID | Task identifier |
VERSION | Version number of the plan |
PLANNING_GROUP | Planning group |
EXCEPTION_TYPE | Type of exception message |
Advanced Supply Chain Planning - MSC_ITEM_SOURCING | This table stores sourcing information for an item used in Oracle Advanced Planning and Scheduling. This table is also used to store Sourcing information for in line vehicle sequencing (ILVS) in the Supply Chain Hub product. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
AVG_TRANSIT_LEAD_TIME | Intransit lead time between two organizations |
CONVERSION_FACTOR | Conversion factor |
SOURCING_RULE_ID | Sourcing rule or bill of distribution identifier |
ASSIGNMENT_ID | Assignment identifier |
ASSIGNMENT_SET_ID | Assignment set identifier |
ASSIGNMENT_TYPE | Sourcing assignment type |
SOURCING_RULE_TYPE | Sourcing rule type |
SHIP_METHOD | Ship method |
HISTORICAL_ALLOC_QTY | Total historical allocation to supplier for item |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
ORGANIZATION_ID | Organization identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
PROGRAM_APPLICATION_ID | Concurrent Who column |
SR_INSTANCE_ID | Instance Id of the destination organzation |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive Flexfield structure defining column |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
ATTRIBUTE4 | Descriptive Flexfield segment |
ATTRIBUTE5 | Descriptive Flexfield segment |
ATTRIBUTE6 | Descriptive Flexfield segment |
INVENTORY_ITEM_ID | Inventory item identifier |
ATTRIBUTE7 | Descriptive Flexfield segment |
ATTRIBUTE8 | Descriptive Flexfield segment |
ATTRIBUTE9 | Descriptive Flexfield segment |
ATTRIBUTE10 | Descriptive Flexfield segment |
ATTRIBUTE11 | Descriptive Flexfield segment |
ATTRIBUTE12 | Descriptive Flexfield segment |
ATTRIBUTE13 | Descriptive Flexfield segment |
ATTRIBUTE14 | Descriptive Flexfield segment |
ATTRIBUTE15 | Descriptive Flexfield segment |
MIN_TRANSFER_QTY | Minimum transfer quantity |
MAX_TRANSFER_QTY | Maximum transfer quantity |
TRANSFER_TYPE | Transfer type |
TRANSFER_LOT_MULTIPLE | Transfer lot multiple |
FIXED_TRANSFER_QTY | Fixed transfer quantity |
SOURCE_ORGANIZATION_ID | Source organization identifier |
SR_INSTANCE_ID2 | Instance id of the source organization |
SUPPLIER_ID | Supplier identifier |
SUPPLIER_SITE_ID | Source supplier identifier |
EFFECTIVE_DATE | Effective date of this source |
DISABLE_DATE | Disable date of the source |
ALLOCATION_PERCENT | Percent allocated to the source |
RANK | Rank of the source |
SOURCE_TYPE | Source type |
Advanced Supply Chain Planning - MSC_ITEM_SUPPLIERS | This table stores the processing lead time, order modifier, and delivery calendar information for each item - supplier/site. |
---|---|
Column Name | Descritpion |
ORGANIZATION_ID | Organization identifier |
SUPPLIER_CAP_OVER_UTIL_COST | Supplier capacity overutilization cost |
USING_ORGANIZATION_ID | Using organization identifier |
SR_INSTANCE_ID2 | Source instance identifier fo Using Organization |
REFRESH_NUMBER | Refresh number populated by the collection program |
LAST_UPDATE_DATE | Standard Who column |
SR_INSTANCE_ID | Source application instance identifier |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who column |
SUPPLIER_ID | Supplier identifier |
PROGRAM_APPLICATION_ID | Concurrent Who column |
PROGRAM_ID | Concurrent Who column |
PROGRAM_UPDATE_DATE | Concurrent Who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
SUPPLIER_SITE_ID | Supplier site identifier |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
PURCHASING_UNIT_OF_MEASURE | Purchasing unit of measure |
COLLECTED_FLAG | Collected Flag |
ITEM_PRICE | Item Price |
SUPPLIER_ITEM_NAME | Supplier Item Name |
PLANNER_CODE | Planner Code |
VMI_FLAG | VMI planned item flag |
MIN_MINMAX_QUANTITY | Minimum Min Max Quantity |
MAX_MINMAX_QUANTITY | Maximum minmax quantity |
MAXIMUM_ORDER_QUANTITY | Maximum order quantity |
UOM_CODE | Unit of measure code |
VMI_REPLENISHMENT_APPROVAL | VMI Replenishment Approval |
ENABLE_VMI_AUTO_REPLENISH_FLAG | Flag to indicate VMI Auto Replenishment |
DESCRIPTION | Description |
AVERAGE_DAILY_DEMAND | Average daily demand |
SUPPLIER_LEAD_TIME_DATE | Date from which supplier capacity is accumulated |
INVENTORY_ITEM_ID | Inventory item identifier |
PLAN_ID | Plan identifier |
PROCESSING_LEAD_TIME | Processing lead time of supplier |
MINIMUM_ORDER_QUANTITY | Minimum ordered quantity |
FIXED_LOT_MULTIPLIER | Fixed lot multiplier |
DELIVERY_CALENDAR_CODE | Delivery calendar code |
Advanced Supply Chain Planning - MSC_ITEM_ID_LID | This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for items. |
---|---|
Column Name | Descritpion |
SR_INSTANCE_ID | Source application instance identifier |
INVENTORY_ITEM_ID | Inventory item identifier generated at planning server |
SR_INVENTORY_ITEM_ID | Inventory item identifier from source application instance |
Advanced Supply Chain Planning - MSC_LATE_ORDER_MV_TAB | KPI Summary Table |
---|---|
Column Name | Descritpion |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
CREATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
PLAN_ID | plan identifier |
ORGANIZATION_ID | org identifier |
SR_INSTANCE_ID | source application instance identifier |
LATE_ORDER_COUNT | count of late exceptions |
Advanced Supply Chain Planning - MSC_ITEM_CUSTOMERS | Table to hold customer items and cross references. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
LIST_PRICE | List price |
PLANNER_CODE | Planner code |
REFRESH_NUMBER | Refresh number |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Concurrent Who Column |
PROGRAM_APPLICATION_ID | Concurrent Who Column |
CUSTOMER_ID | Customer identifier |
PROGRAM_ID | Concurrent Who Column |
PROGRAM_UPDATE_DATE | Concurrent Who Column |
ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
CUSTOMER_SITE_ID | Customer site identifier |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
INVENTORY_ITEM_ID | Inventory item identifier |
SR_INSTANCE_ID | Source application instance identifier |
CUSTOMER_ITEM_NAME | Customer item name |
DESCRIPTION | Description |
LEAD_TIME | Lead time |
UOM_CODE | Unit of measure code |
Advanced Supply Chain Planning - MSC_LOCAL_ID_DEMAND | MSC_LOCAL_ID_DEMAND table stores the mappings between the Local IDs and the User Defined Keys for all types of Demands. The table is striped by ENTITY_NAME. |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | Transaction ID in the staging table for the record |
CHAR8 | Char8 |
CHAR9 | Char9 |
CHAR10 | Char10 |
DATE1 | Date1 |
DATE2 | Date2 |
DATE3 | Date3 |
DATE4 | Date4 |
DATE5 | Date5 |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
INSTANCE_ID | Instance Identifier |
CREATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
ENTITY_NAME | The entity name to identity the target for the user defined keys |
DATA_SOURCE_TYPE | Source type to identify the source of data , BATCH/XML |
NUMBER1 | Number1 |
NUMBER2 | Number2 |
NUMBER3 | Number3 |
NUMBER4 | Number4 |
LOCAL_ID | ID generated locally by Pre-processor |
NUMBER5 | Number5 |
CHAR1 | Char1 |
CHAR2 | Char2 |
CHAR3 | Char3 |
CHAR4 | Char4 |
CHAR5 | Char5 |
CHAR6 | Char6 |
CHAR7 | Char7 |
Advanced Supply Chain Planning - MSC_LOCAL_ID_ITEM | MSC_LOCAL_ID_ITEM table stores the mappings between the Local IDs and the User Defined Keys for Items. The table is striped by ENTITY_NAME. The entities and their mappings with staging table columns are listed below.ENTITY_NAME: SR_INVENTOR |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | Transaction ID in the staging table for the record |
CHAR10 | Char10 |
DATE1 | Date1 |
DATE2 | Date2 |
DATE3 | Date3 |
DATE4 | Date4 |
DATE5 | Date5 |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
INSTANCE_ID | Instance Identifier |
CREATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | concurrent WHO column |
PROGRAM_ID | concurrent WHO column |
PROGRAM_UPDATE_DATE | concurrent WHO column |
ENTITY_NAME | Entity Name to identify the target for user defined keys |
DATA_SOURCE_TYPE | Source type indicating the source of data |
NUMBER1 | Number1 |
NUMBER2 | Number2 |
NUMBER3 | Number3 |
NUMBER4 | Number4 |
LOCAL_ID | ID generated locally by Pre-processor |
NUMBER5 | Number5 |
CHAR1 | Char1 |
CHAR2 | Char2 |
CHAR3 | Char3 |
CHAR4 | Char4 |
CHAR5 | Char5 |
CHAR6 | Char6 |
CHAR7 | Char7 |
CHAR8 | Char8 |
CHAR9 | Char9 |
Advanced Supply Chain Planning - MSC_LOCAL_ID_MISC | MSC_LOCAL_ID_MISC table stores the mappings between the Local IDs and the User Defined Keys for Sourcing Rules, Projects, Tasks and Categories. The table is striped by ENTITY_NAME. |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | Transaction ID in the staging table for the record |
CHAR9 | Char9 |
CHAR10 | Char10 |
DATE1 | Date1 |
DATE2 | Date2 |
DATE3 | Date3 |
DATE4 | Date4 |
DATE5 | Date5 |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
INSTANCE_ID | Instance Identifier |
CREATION_DATE | Standard WHO column |
CREATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
ENTITY_NAME | The entity name to identify the target for the user defined keys |
DATA_SOURCE_TYPE | source type identifying the source of data , BATCH/XML |
NUMBER1 | Number1 |
NUMBER2 | Number2 |
NUMBER3 | Number3 |
LOCAL_ID | ID generated locally by Pre-processor |
NUMBER4 | Number4 |
NUMBER5 | Number5 |
CHAR1 | Char1 |
CHAR2 | Char2 |
CHAR3 | Char3 |
CHAR4 | Char4 |
CHAR5 | Char5 |
CHAR6 | Char6 |
CHAR7 | Char7 |
CHAR8 | Char8 |
Advanced Supply Chain Planning - MSC_LOCAL_ID_SETUP | MSC_LOCAL_ID_SETUP table stores the mappings between the Local IDs and the User Defined Keys for BOM, Routing, Trading Partners, Departments, Resources and Calendars. The table is striped by ENTITY_NAME. |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | Transaction ID in the staging table for the record |
CHAR9 | Char9 |
CHAR10 | Char10 |
DATE1 | Date1 |
DATE2 | Date2 |
DATE3 | Date3 |
DATE4 | Date4 |
DATE5 | Date5 |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
CREATED_BY | Standard WHO column |
INSTANCE_ID | Instance Identifier |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | concurrent WHO column |
PROGRAM_APPLICATION_ID | concurrent WHO column |
PROGRAM_ID | concurrent WHO column |
PROGRAM_UPDATE_DATE | concurrent WHO column |
ENTITY_NAME | The Entity name to identify the target for the user defined keys |
DATA_SOURCE_TYPE | Source type indicating the source of data |
NUMBER1 | Number1 |
NUMBER2 | Number2 |
NUMBER3 | Number3 |
NUMBER4 | Number4 |
LOCAL_ID | ID generated locally by Pre-processor |
NUMBER5 | Number5 |
CHAR1 | Char1 |
CHAR2 | Char2 |
CHAR3 | Char3 |
CHAR4 | Char4 |
CHAR5 | Char5 |
CHAR6 | Char6 |
CHAR7 | Char7 |
CHAR8 | Char8 |
Advanced Supply Chain Planning - MSC_LOCAL_ID_SUPPLY | MSC_LOCAL_ID_SUPPLY This table stores the mappings between the Local IDs and the User Defined Keys for all the Supplies. The table is striped by ENTITY_NAME. |
---|---|
Column Name | Descritpion |
ST_TRANSACTION_ID | Transaction ID in the staging table for the record |
CHAR10 | Char10 |
DATE1 | Date1 |
DATE2 | Date2 |
DATE3 | Date3 |
DATE4 | Date4 |
DATE5 | Date5 |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
INSTANCE_ID | Instance Identifier |
CREATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent WHO column |
PROGRAM_APPLICATION_ID | Concurrent WHO column |
PROGRAM_ID | Concurrent WHO column |
PROGRAM_UPDATE_DATE | Concurrent WHO column |
ENTITY_NAME | The entity name to identify the target for the user defined keys |
DATA_SOURCE_TYPE | Source type to identify the source of data |
NUMBER1 | Number1 |
NUMBER2 | Number2 |
NUMBER3 | Number3 |
NUMBER4 | Number4 |
LOCAL_ID | ID generated locally by Pre-processor |
NUMBER5 | Number5 |
CHAR1 | Char1 |
CHAR2 | Char2 |
CHAR3 | Char3 |
CHAR4 | Char4 |
CHAR5 | Char5 |
CHAR6 | Char6 |
CHAR7 | Char7 |
CHAR8 | Char8 |
CHAR9 | Char9 |
Advanced Supply Chain Planning - MSC_ITEM_SUBSTITUTES | This table stores all the Relationships between Item Substitutes for planning. |
---|---|
Column Name | Descritpion |
PLAN_ID | Plan identifier |
RELATIONSHIP_TYPE | Type of Relationship between the Items |
RECIPROCAL_FLAG | Reciprocal Flag |
SUBSTITUTION_SET | Substitution set name used to define the Item relationship |
PARTIAL_FULFILLMENT_FLAG | Partial Fulfillment Flag |
RANK | Rank |
USAGE_RATIO | Usage Ratio |
INFERRED_FLAG | Inferred Flag |
REFRESH_ID | Refresh Id |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
SR_INSTANCE_ID | Instance Id of the destination organzation |
LAST_UPDATE_LOGIN | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
ORGANIZATION_ID | |
SUBSTITUTE_FLAG | |
PRIME_ITEM_ID | |
FORWARD_RULE | |
NEW_PLAN_ID | |
NEW_PLAN_LIST | |
APPLIED | |
LOWER_ITEM_ID | Item identifier generated by the collection program from Staging tables to ODS |
SIMULATION_SET_ID | |
HIGHER_ITEM_ID | Item identifier generated by the collection program from Staging tables to ODS |
HIGHEST_ITEM_ID | Highest Item Id |
CUSTOMER_ID | Unique Partner identifier generated by the collection program from Staging tables to ODS |
CUSTOMER_SITE_ID | Unique Partnersite identifier generated by the collection program from Staging tables to ODS |
EFFECTIVE_DATE | Effective Date of the Item Relationship |
DISABLE_DATE | Disable Date of the Item Relationship |
Advanced Supply Chain Planning - MSC_JOB_OPERATIONS | |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | |
ORGANIZATION_ID | |
STANDARD_OPERATION_CODE | |
DEPARTMENT_ID | |
OPERATION_LEAD_TIME_PERCENT | |
MINIMUM_TRANSFER_QUANTITY | |
EFFECTIVITY_DATE | |
DISABLE_DATE | |
OPERATION_TYPE | |
YIELD | |
CUMULATIVE_YIELD | |
PLAN_ID | |
REVERSE_CUMULATIVE_YIELD | |
NET_PLANNING_PERCENT | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | |
CREATION_DATE | |
CREATED_BY | |
REQUEDST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
SR_INSTANCE_ID | |
PROGRAM_UPDATE_DATE | |
REFRESH_NUMBER | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
OPERATION_SEQ_NUM | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
OPERATION_DESC | |
OPERATION_CODE | |
RECOMMENDED | |
ACTUAL_START_DATE | |
ACTUAL_END_DATE | |
NETWORK_START_END | |
RECO_START_DATE | |
RECO_COMPLETION_DATE | |
OPERATION_SEQUENCE_ID |
Advanced Supply Chain Planning - MSC_JOB_OPERATION_NETWORKS | |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | |
CREATED_BY | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
REFRESH_NUMBER | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
PLAN_ID | |
ATTRIBUTE4 | |
TRANSITION_TYPE | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
SR_INSTANCE_ID | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
FROM_OP_SEQ_NUM | |
FROM_OP_SEQ_ID | |
TO_OP_SEQ_NUM | |
TO_OP_SEQ_ID | |
DEPENDENCY_TYPE | |
MAXIMUM_TIME_OFFSET | |
ORGANIZATION_ID | |
MINIMUM_TIME_OFFSET | |
PLANNING_PCT | |
TO_TRANSACTION_ID | |
TOP_TRANSACTION_ID | |
TRANSFER_QTY | |
TRANSFER_UOM | |
TRANSFER_PCT | |
FROM_ITEM_ID | |
MINIMUM_TRANSFER_QTY | |
APPLY_TO_CHARGES | |
RECOMMENDED | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | |
CREATION_DATE |
Advanced Supply Chain Planning - MSC_JOB_OP_RESOURCES | |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | |
RECO_START_DATE | |
ATTRIBUTE13 | |
RECO_COMPLETION_DATE | |
RESOURCE_ID | |
ASSIGNED_UNITS | |
USAGE_RATE_OR_AMOUNT | |
UOM_CODE | |
BASIS_TYPE | |
SCHEDULE_FLAG | |
PLAN_ID | |
RESOURCE_OFFSET_PERCENT | |
ATTRIBUTE12 | |
SCHEDULE_SEQ_NUM | |
PRINCIPAL_FLAG | |
DEPARTMENT_ID | |
ACTIVITY_GROUP_ID | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | |
CREATION_DATE | |
SR_INSTANCE_ID | |
CREATED_BY | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
REFRESH_NUMBER | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
OPERATION_SEQ_NUM | |
ATTRIBUTE4 | |
ALTERNATE_NUM | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
SETUP_ID | |
GROUP_SEQUENCE_ID | |
RESOURCE_SEQ_NUM | |
GROUP_SEQUENCE_NUMBER | |
MAXIMUM_ASSIGNED_UNITS | |
BATCH_NUMBER | |
PARENT_SEQ_NUM | |
FIRM_FLAG | |
ORIG_RESOURCE_SEQ_NUM | |
ORGANIZATION_ID | |
ATTRIBUTE15 | |
ATTRIBUTE14 | |
RECOMMENDED |
Advanced Supply Chain Planning - MSC_JOB_REQUIREMENT_OPS | |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | |
ORGANIZATION_ID | |
COMPONENT_SEQUENCE_ID | |
COMPONENT_PRIORITY | |
DEPARTMENT_ID | |
QUANTITY_PER_ASSEMBLY | |
COMPONENT_YIELD_FACTOR | |
EFFECTIVITY_DATE | |
DISABLE_DATE | |
PLANNING_FACTOR | |
LOW_QUANTITY | |
PLAN_ID | |
HIGH_QUANTITY | |
OPERATION_LEAD_TIME_PERCENT | |
WIP_SUPPLY_TYPE | |
FROM_END_ITEM_UNIT_NUMBER | |
TO_END_ITEM_UNIT_NUMBER | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | |
CREATION_DATE | |
CREATED_BY | |
SR_INSTANCE_ID | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
REFRESH_NUMBER | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
OPERATION_SEQ_NUM | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
COMPONENT_ITEM_ID | |
ATTRIBUTE15 | |
COMPONENT_SCALING_TYPE | |
PRIMARY_COMPONENT_ID | |
SOURCE_PHANTOM_ID | |
RECOMMENDED | |
RECO_DATE_REQUIRED |
Advanced Supply Chain Planning - MSC_JOB_OP_RES_INSTANCES | |
---|---|
Column Name | Descritpion |
TRANSACTION_ID | |
ORGANIZATION_ID | |
START_DATE | |
COMPLETION_DATE | |
BATCH_NUMBER | |
DEPARTMENT_ID | |
PARENT_SEQ_NUM | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
CREATION_DATE | |
CREATED_BY | |
PLAN_ID | |
LAST_UPDATE_LOGIN | |
REQUEST_ID | |
PROGRAM_APPLICATION_ID | |
PROGRAM_ID | |
PROGRAM_UPDATE_DATE | |
ATTRIBUTE_CATEGORY | |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
SR_INSTANCE_ID | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
OPERATION_SEQ_NUM | |
ATTRIBUTE15 | |
REFRESH_NUMBER | |
ORIG_RESOURCE_SEQ_NUM | |
RESOURCE_SEQ_NUM | |
RESOURCE_ID | |
RES_INSTANCE_ID | |
SERIAL_NUMBER | |
EQUIPMENT_ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_ITEM_BRANCH_TV | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
A__EFFECTIVE_DATE | |
OI__ITEM_COST | |
OI__ITEM_PRICE |
Advanced Supply Chain Planning - MSC_INT_ITEM_GROUP_MEM | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__LEVEL | |
OI__ITEM_CODE |
Advanced Supply Chain Planning - MSC_INT_ITEM_BRANCH_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__ITEM_COST | |
OI__ITEM_PRICE |
Advanced Supply Chain Planning - MSC_INT_ITEM_GROUP_SNO | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__LEVEL | |
OI__DESCRIPTION | |
OI__PLANNING_UOM |
Advanced Supply Chain Planning - MSC_INT_ITEM_GROUP | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__LEVEL | |
OI__DESCRIPTION | |
OI__PLANNING_UOM |
Advanced Supply Chain Planning - MSC_INT_ITEM_PRICE_SNO | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__CUSTOMER_CODE |
Advanced Supply Chain Planning - MSC_INT_ITEM_GROUP_MEM_SNO | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__LEVEL | |
OI__ITEM_CODE |
Advanced Supply Chain Planning - MSC_INT_ITEM_PRICE | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__CUSTOMER_CODE |
Advanced Supply Chain Planning - MSC_INT_ITEM_PRICE_TV | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__CUSTOMER_CODE | |
A__EFFECTIVE_DATE | |
OI__PRICE |
Advanced Supply Chain Planning - MSC_INT_ITEM_PRICE_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__CUSTOMER_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__PRICE |
Advanced Supply Chain Planning - MSC_INT_ITEM_STORAGE_SNO | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
OI__STORAGE_COST_TIME | |
OI__STORAGE_COST_TIME_UNIT |
Advanced Supply Chain Planning - MSC_INT_ITEM_STORAGE | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
OI__STORAGE_COST_TIME | |
OI__STORAGE_COST_TIME_UNIT |
Advanced Supply Chain Planning - MSC_INT_ITEM_UOM | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__TO_UOM | |
OI__TO_UOM_TYPE | |
OI__FACTOR |
Advanced Supply Chain Planning - MSC_INT_ITEM_SNO | |
---|---|
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_ITEM_STORAGE_TV | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
A__EFFECTIVE_DATE | |
OI__STORAGE_COST | |
OI__PREFERENCE |
Advanced Supply Chain Planning - MSC_INT_ITEM_STORAGE_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__STORAGE_COST | |
OI__PREFERENCE |
Advanced Supply Chain Planning - MSC_INT_ITEM_TRANSPORT_MODE | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__LANE_CODE | |
OI__TRANSPORT_MODE_CODE | |
OI__AVAILABILITY_CALENDAR | |
OI__SHIP_MULTIPLE | |
OI__MINIMUM_SHIPMENT | |
OI__DEPLOYMENT_PULL_FORWARD |
Advanced Supply Chain Planning - MSC_INT_JOB_ALT_RES | |
---|---|
Column Name | Descritpion |
OI__OPER_SET_CODE | |
OI__RESOURCE_SET | |
OI__ORGANIZATION_ID | |
OI__DEPARTMENT_ID | |
OI__PRINCIPAL_FLAG | |
OI__RESOURCE_USAGE | |
OI__ASSIGNED_UNITS | |
OI__DURATION_RESOURCE | |
OI__SCHEDULE_FLAG | |
OI__TIME_UNIT | |
OI__BASIS_TYPE | |
OI__OLD_ALT_NUM | |
OI__SCHEDULE_TO_INSTANCE | |
OI__ALT_FLAG | |
OI__BATCH_OP_SEQ_NUM | |
OI__FIRST_OP_SEQ_NUM | |
OI__HAS_ALTERNATE | |
OI__MAX_CAPACITY | |
OI__RESOURCE_ID | |
OI__SR_INSTANCE_ID | |
OI__SUPPLY_ID | |
OI__OPERATION_SEQ_NUM | |
OI__OPERATION_SEQ_ID | |
OI__RESOURCE_SEQ_NUM | |
OI__NEW_ALT_NUM |
Advanced Supply Chain Planning - MSC_INT_ITEM_UOM_SNO | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__TO_UOM | |
OI__TO_UOM_TYPE | |
OI__FACTOR |
Advanced Supply Chain Planning - MSC_INT_LANE_SNO | |
---|---|
Column Name | Descritpion |
OI__LANE_CODE | |
OI__DESCRIPTION | |
OI__ORIGIN_BRANCH_CODE | |
OI__DESTINATION_BRANCH_CODE |
Advanced Supply Chain Planning - MSC_INT_LANE | |
---|---|
Column Name | Descritpion |
OI__LANE_CODE | |
OI__DESCRIPTION | |
OI__ORIGIN_BRANCH_CODE | |
OI__DESTINATION_BRANCH_CODE |
Advanced Supply Chain Planning - MSC_INT_MACHINE | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_CODE | |
OI__CAPACITY_CONSTRAINT_STATUS | |
OI__OPTIMIZE_RUN_LENGTH | |
OI__OFF_LOAD_WINDOW | |
OI__OFF_LOAD_WINDOW_TIME_UNIT | |
OI__MINIMUM_CYCLE_TIME | |
OI__MINIMUM_CYCLE_TIME_U_O_M | |
OI__5 | |
OI__MINIMIZE_IDLE_TIME | |
OI__SCHEDULING_OBJECTIVE | |
OI__6 | |
OI__BRANCH_CODE | |
OI__7 | |
OI__8 | |
OI__CAPACITY_TYPE | |
OI__PULL_FORWARD_WINDOW | |
OI__9 | |
OI__MINIMUM_CAPACITY | |
OI__CHANGEOVER_CALCULATION | |
OI__CHANGEOVER_CALENDAR | |
OI__NAME | |
OI__DEPARTMENT_CODE | |
OI__DESCRIPTION | |
OI__AVAILABILITY_CALENDAR | |
OI__4 | |
OI__TIME_UNIT_FOR_COST | |
OI__TIME_FENCE_UNITS |
Advanced Supply Chain Planning - MSC_INT_MACHINE_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__SETUP_COST | |
OI__OPERATING_COST | |
OI__PREMIUM_COST | |
OI__PREMIUM_CAPACITY |
Advanced Supply Chain Planning - MSC_INT_MACHINE_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_MACHINE_SNO | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_CODE | |
OI__OPTIMIZE_RUN_LENGTH | |
OI__OFF_LOAD_WINDOW | |
OI__BRANCH_CODE | |
OI__16 | |
OI__NAME | |
OI__DESCRIPTION | |
OI__20 | |
OI__AVAILABILITY_CALENDAR | |
OI__25 | |
OI__TIME_UNIT_FOR_COST | |
OI__TIME_FENCE_UNITS | |
OI__CAPACITY_CONSTRAINT_STATUS |
Advanced Supply Chain Planning - MSC_INT_OPERATION | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__USE_RUN_TIME | |
OI__MIN_RUN_TIME | |
OI__MAX_RUN_TIME | |
OI__RUN_TIME_UNIT | |
OI__TYPE | |
OI__ROUTING_SEQUENCE_ID | |
OI__BILL_SEQUENCE_ID | |
OI__OPERATION_SEQ_NUM | |
OI__OPERATION_SEQ_ID | |
OI__RESOURCE_SEQ_NUM | |
OI__OPERATION_NAME | |
OI__DESCRIPTION | |
OI__DURATION_RESOURCE_OR_SET | |
OI__FACTOR_RESOURCE_OR_SET | |
OI__PRIMARY_OUTPUT | |
OI__BATCH | |
OI__MIN_RUN_QTY | |
OI__MAX_RUN_QTY |
Advanced Supply Chain Planning - MSC_INT_OPERATION_BOR | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__MINIMUM_RUN_TIME | |
OI__RUN_TIME_UNITS | |
OI__IS_MINIMUM_RUN_BY_TIME | |
OI__OPTIMIZE_RUN_TYPE | |
OI__RESOURCE_SET_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_GROUP_NAME | |
OI__DURATION_RESOURCE | |
OI__LOT_MULTIPLE_RESOURCE | |
OI__RESOURCE_CODE | |
OI__DURATION_UNIT | |
OI__SCALING | |
OI__MINIMUM_RUN_QUANTITY |
Advanced Supply Chain Planning - MSC_INT_OPERATION_BOR_TV | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__PREFERENCE | |
OI__RESOURCE_SET_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_GROUP_NAME | |
OI__CAPACITY_REQUIRED | |
A__EFFECTIVE_DATE | |
OI__AVAILABLE | |
OI__RESOURCE_CODE | |
OI__DURATION | |
OI__LOT_MULTIPLE | |
OI__OVERHEAD_COST |
Advanced Supply Chain Planning - MSC_INT_OPERATION_BOR_SNO | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__MINIMUM_RUN_TIME | |
OI__RUN_TIME_UNITS | |
OI__IS_MINIMUM_RUN_BY_TIME | |
OI__OPTIMIZE_RUN_TYPE | |
OI__RESOURCE_SET_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_GROUP_NAME | |
OI__DURATION_RESOURCE | |
OI__LOT_MULTIPLE_RESOURCE | |
OI__RESOURCE_CODE | |
OI__DURATION_UNIT | |
OI__SCALING | |
OI__MINIMUM_RUN_QUANTITY |
Advanced Supply Chain Planning - MSC_INT_OPERATION_GROUP_MEM | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__OPERATION_CODE | |
OI__GROUP_NAME |
Advanced Supply Chain Planning - MSC_INT_OPERATION_BOR_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__OVERHEAD_COST | |
OI__PREFERENCE | |
OI__RESOURCE_SET_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_GROUP_NAME | |
OI__CAPACITY_REQUIRED | |
A__START_DATE | |
A__END_DATE | |
OI__RESOURCE_CODE | |
OI__AVAILABLE | |
OI__DURATION | |
OI__LOT_MULTIPLE |
Advanced Supply Chain Planning - MSC_INT_OPERATION_GROUP_SNO | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__GROUP_NAME | |
OI__DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_OPERATION_GROUP | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__GROUP_NAME | |
OI__DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_OPERATION_SET_MEM_SNO | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__OPERATION_SET_CODE | |
OI__OPERATION_CODE |
Advanced Supply Chain Planning - MSC_INT_OPERATION_SET | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__OPERATION_SET_CODE | |
OI__OPERATION_SET_NAME | |
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_OPERATION_SET_SNO | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__OPERATION_SET_CODE | |
OI__OPERATION_SET_NAME |
Advanced Supply Chain Planning - MSC_INT_OSFM_PATH | |
---|---|
Column Name | Descritpion |
OI__SR_INSTANCE_ID | |
OI__TRANSACTION_ID | |
OI__FROM_OP_SEQ_NUM | |
OI__TO_OP_SEQ_NUM |
Advanced Supply Chain Planning - MSC_INT_PEGGED_WORK_ORDER_PLAN | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_SCHEDULE_CODE | |
OI__SOURCE | |
OI__MAINTENANCE_OBJECT_ID | |
OI__MAINTENANCE_OBJECT_TYPE | |
OI__REQUESTED_DATE | |
OI__START_DATE | |
OI__COMPLETION_DATE | |
OI__ITEM_CODE | |
OI__ROUTING_CODE | |
OI__INTEGRATION_ID | |
OI__PEGGED_WORK_ORDER_CODE | |
OI__BRANCH_CODE | |
OI__DESCRIPTION | |
OI__FIRM | |
OI__QUANTITY | |
OI__RELEASE_STATUS | |
OI__TYPE |
Advanced Supply Chain Planning - MSC_INT_PRODUCED_ITEM | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__ITEM_CODE |
Advanced Supply Chain Planning - MSC_INT_OPERATION_SNO | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__USE_RUN_TIME | |
OI__MIN_RUN_TIME | |
OI__MAX_RUN_TIME | |
OI__RUN_TIME_UNIT | |
OI__OPERATION_NAME | |
OI__DESCRIPTION | |
OI__DURATION_RESOURCE_OR_SET | |
OI__FACTOR_RESOURCE_OR_SET | |
OI__PRIMARY_OUTPUT | |
OI__BATCH | |
OI__MIN_RUN_QTY | |
OI__MAX_RUN_QTY |
Advanced Supply Chain Planning - MSC_INT_OPERATION_SET_MEM | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__OPERATION_SET_CODE | |
OI__OPERATION_CODE |
Advanced Supply Chain Planning - MSC_INT_PRODUCED_ITEM_SNO | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__ITEM_CODE |
Advanced Supply Chain Planning - MSC_INT_PURCHASE_ORDER_DETAIL | |
---|---|
Column Name | Descritpion |
OI__PURCHASE_ORDER_CODE | |
OI__QUANTITY | |
OI__UNIT_COST | |
OI__FIX | |
OI__LINE_ITEM | |
OI__ITEM_CODE | |
OI__SHIP_DATE | |
OI__ARRIVE_DATE | |
OI__TRANSPORT_MODE | |
OI__CARRIER_NAME | |
OI__VEHICLE_ID | |
OI__ORDER_STATUS |
Advanced Supply Chain Planning - MSC_INT_PRODUCED_ITEM_BOM_TV | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__TRANSACTION_ID | |
A__EFFECTIVE_DATE | |
OI__PRODUCTION_OVERHEAD_COST |
Advanced Supply Chain Planning - MSC_INT_PURCHASE_ORDER | |
---|---|
Column Name | Descritpion |
OI__PURCHASE_ORDER_CODE | |
OI__SUPPLIER_CODE | |
OI__DESTINATION_BRANCH_CODE | |
OI__PURCHASE_ORDER_NAME | |
OI__TRANSACTION_TYPE |
Advanced Supply Chain Planning - MSC_INT_PRODUCED_ITEM_BOM | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__TRANSACTION_ID | |
OI__QUANTITY | |
OI__YIELD |
Advanced Supply Chain Planning - MSC_INT_PRODUCED_ITEM_BOM_SNO | |
---|---|
Column Name | Descritpion |
OI__OPERATION_CODE | |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__TRANSACTION_ID | |
OI__QUANTITY | |
OI__YIELD |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_GROUP | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__GROUP_NAME | |
OI__DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_PURCHASE_ORDER_SNO | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__DESTINATION_BRANCH_CODE | |
OI__ITEM_CODE | |
OI__TRANSPORT_MODE | |
OI__CARRIER_NAME | |
OI__ARRIVE_DATE | |
OI__SHIP_DATE | |
OI__QUANTITY | |
OI__UNIT_COST |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_GROUP_SNO | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__GROUP_NAME | |
OI__DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_GROUP_MEM | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__MEMBER | |
OI__GROUP_NAME |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_PLAN | |
---|---|
Column Name | Descritpion |
OI__PRODUCTION_SCHEDULE_CODE | |
OI__INTEGRATION_ID | |
OI__RESOURCE_CODE | |
OI__BRANCH_CODE | |
OI__RESOURCE_TYPE |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_SCHEDULE_PLAN | |
---|---|
Column Name | Descritpion |
OI__PRODUCTION_SCHEDULE_CODE | |
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_RESOURCE_SET | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_SET_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_SET_NAME |
Advanced Supply Chain Planning - MSC_INT_ROUTING | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__BATCH_FLAG | |
OI__BATCH_OP_SEQ_NUM | |
OI__BATCH_OP_ID | |
OI__BATCH_SIZE | |
OI__CHARGE_SIZE | |
OI__WORK_ORDER_UNIT_OF_EFFORT | |
OI__DURATION_SIZE | |
OI__MIN_TRANSFER_QUANTITY | |
OI__ROUTING_QUANTITY | |
OI__OSFM_FLAG | |
OI__ROUTING_NAME | |
OI__DESCRIPTION | |
OI__PRIMARY_OPERATION_OR_SET | |
OI__WORK_ORDER_ONLY | |
OI__ROUTING_SEQUENCE_ID | |
OI__BILL_SEQUENCE_ID | |
OI__FIRST_OP_SEQ_NUM | |
OI__FIRST_OP_ID |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_GROUP_MEM_SNO | |
---|---|
Column Name | Descritpion |
OI__GROUP_CODE | |
OI__MEMBER | |
OI__GROUP_NAME |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_SET_SNO | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_SET_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_SET_NAME |
Advanced Supply Chain Planning - MSC_INT_SALES_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__ITEM_CODE | |
OI__CUSTOMER_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__QUANTITY | |
OI__UNIT_PRICE |
Advanced Supply Chain Planning - MSC_INT_SALES_ORDER | |
---|---|
Column Name | Descritpion |
OI__SALES_ORDER_CODE | |
OI__ALLOW_PARTIAL_LINES | |
OI__ALLOW_BACK_ORDERS | |
OI__PRIORITY | |
OI__ADDRESS1 | |
OI__ADDRESS2 | |
OI__ADDRESS3 | |
OI__CITY | |
OI__STATE_PROVINCE | |
OI__COUNTRY | |
OI__POSTAL_CODE | |
OI__BILL_TO_CUSTOMER_CODE | |
OI__CREATED_BY | |
OI__CREATED_DATE | |
OI__SALES_ORDER_NAME | |
OI__BILL_TO_CUSTOMER_NAME | |
OI__SHIP_TO_CUSTOMER_CODE | |
OI__SHIP_TO_CUSTOMER_NAME | |
OI__SERVICE_OBJECTIVE | |
OI__STATUS | |
OI__ALLOW_MULTI_SOURCE | |
OI__ALLOW_PARTIAL_ORDERS |
Advanced Supply Chain Planning - MSC_INT_SATISFIED_DEMAND_PLAN | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_SCHEDULE_CODE | |
OI__AVAILABLE_DATE | |
OI__INTEGRATION_ID | |
OI__PEGGED_WORK_ORDER_CODE | |
OI__BRANCH_CODE | |
OI__DEMAND_CODE | |
OI__LINE_ITEM | |
OI__DEMAND_TYPE | |
OI__QUANTITY | |
OI__REQUESTED_DATE |
Advanced Supply Chain Planning - MSC_INT_SALES_SNO | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__ITEM_CODE | |
OI__CUSTOMER_CODE |
Advanced Supply Chain Planning - MSC_INT_ROUTING_SNO | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__ROUTING_NAME | |
OI__DESCRIPTION | |
OI__PRIMARY_OPERATION_OR_SET |
Advanced Supply Chain Planning - MSC_INT_SOURCE_ITEM_PLAN | |
---|---|
Column Name | Descritpion |
OI__ITEM_CODE | |
OI__BRANCH_CODE | |
OI__SOURCING_TYPE |
Advanced Supply Chain Planning - MSC_INT_SALES_ORDER_DETAIL | |
---|---|
Column Name | Descritpion |
OI__SALES_ORDER_CODE | |
OI__EXTENDED_PRICE | |
OI__REQUESTED_DATE | |
OI__SHIP_DATE | |
OI__ARRIVE_DATE | |
OI__PICK_DATE | |
OI__STATUS | |
OI__ALLOW_MULTI_SOURCE | |
OI__ALLOW_PARTIAL_LINES | |
OI__ALLOW_BACK_ORDERS | |
OI__ALLOW_SUBSTITUTIONS | |
OI__LINE_ITEM | |
OI__PRIORITY | |
OI__ADDRESS1 | |
OI__ADDRESS2 | |
OI__ADDRESS3 | |
OI__CITY | |
OI__STATE_PROVINCE | |
OI__COUNTRY | |
OI__POSTAL_CODE | |
OI__SATISFACTION_DATE | |
OI__LINE_ITEM_NAME | |
OI__SHIP_FROM_BRANCH_CODE | |
OI__SHIP_TO_CUSTOMER_NAME | |
OI__SHIP_TO_CUSTOMER_CODE | |
OI__ITEM_CODE | |
OI__QUANTITY | |
OI__UNIT_PRICE |
Advanced Supply Chain Planning - MSC_INT_SCHEDULE_OP_PLAN | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_SCHEDULE_CODE | |
OI__DURATION_UNIT | |
OI__ALT_NUM | |
OI__INTEGRATION_ID | |
OI__PEGGED_WORK_ORDER_CODE | |
OI__BRANCH_CODE | |
OI__OPERATION_CODE | |
OI__OPERATION_SET_NAME | |
OI__SCHEDULED_START_DATE | |
OI__SCHEDULED_COMPLETION_DATE | |
OI__DURATION |
Advanced Supply Chain Planning - MSC_INT_STORAGE_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__STORAGE_WEIGHT_CAPACITY | |
OI__STORAGE_VOLUME_CAPACITY |
Advanced Supply Chain Planning - MSC_INT_STORAGE | |
---|---|
Column Name | Descritpion |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
OI__STORAGE_TYPE | |
OI__DESCRIPTION | |
OI__STORAGE_WEIGHT_UNIT | |
OI__STORAGE_VOLUME_UNIT |
Advanced Supply Chain Planning - MSC_INT_STORAGE_TV | |
---|---|
Column Name | Descritpion |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
A__EFFECTIVE_DATE | |
OI__STORAGE_WEIGHT_CAPACITY | |
OI__STORAGE_VOLUME_CAPACITY |
Advanced Supply Chain Planning - MSC_INT_STORAGE_SNO | |
---|---|
Column Name | Descritpion |
OI__STORAGE_NAME | |
OI__BRANCH_CODE | |
OI__STORAGE_TYPE | |
OI__DESCRIPTION | |
OI__STORAGE_WEIGHT_UNIT | |
OI__STORAGE_VOLUME_UNIT |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_GROUP | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_STANDARD_UOM_SNO | |
---|---|
Column Name | Descritpion |
OI__TO_UOM | |
OI__FROM_UOM | |
OI__UNIT_TYPE | |
OI__FACTOR |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__TIME_FENCE_UNITS | |
OI__NAME | |
OI__CITY | |
OI__STATE_PROVINCE | |
OI__COUNTRY | |
OI__POSTAL_CODE | |
OI__LATITUDE | |
OI__LONGITUDE | |
OI__TIME_FENCE_DURATION |
Advanced Supply Chain Planning - MSC_INT_STANDARD_UOM | |
---|---|
Column Name | Descritpion |
OI__TO_UOM | |
OI__FROM_UOM | |
OI__UNIT_TYPE | |
OI__FACTOR |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_GROUP_SNO | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_GROUP_MEM | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__SUPPLIER_CODE |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_ITEM_TV | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__BRANCH_CODE | |
OI__STANDARD_LEAD_TIME | |
OI__MINIMUM_PERIOD_ORDER | |
OI__PREMIUM_LEAD_TIME | |
OI__ITEM_CODE | |
A__EFFECTIVE_DATE | |
OI__STANDARD_COST | |
OI__PREFERENCE | |
OI__MINIMUM_QUANTITY | |
OI__MAXIMUM_QUANTITY | |
OI__PREMIUM_COST | |
OI__FIXED_ORDER_QUANTITY | |
OI__DEMAND_COVERAGE_ORDER | |
OI__MAXIMUM_PERIOD_ORDER |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_ITEM | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__ORDER_POLICY | |
OI__RECEIVING_CALENDAR | |
OI__ITEM_CODE | |
OI__ORDER_MULTIPLE | |
OI__SHIPPING_CALENDAR | |
OI__MINMAX_ORDER_PERIOD | |
OI__MINMAX_ORDER_PERIOD_UNIT | |
OI__LEAD_TIME_UOM | |
OI__DEMAND_COVERAGE_UNITS | |
OI__BRANCH_CODE |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_GROUP_MEM_SNO | |
---|---|
Column Name | Descritpion |
OI__NAME | |
OI__SUPPLIER_CODE |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_ITEM_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__MAXIMUM_PERIOD_ORDER | |
OI__MINIMUM_PERIOD_ORDER | |
OI__BRANCH_CODE | |
OI__STANDARD_LEAD_TIME | |
OI__PREMIUM_LEAD_TIME | |
OI__ITEM_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__PREFERENCE | |
OI__STANDARD_COST | |
OI__MINIMUM_QUANTITY | |
OI__PREMIUM_COST | |
OI__MAXIMUM_QUANTITY | |
OI__FIXED_ORDER_QUANTITY | |
OI__DEMAND_COVERAGE_ORDER |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_ITEM_SNO | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__ORDER_POLICY | |
OI__RECEIVING_CALENDAR | |
OI__ITEM_CODE | |
OI__ORDER_MULTIPLE | |
OI__SHIPPING_CALENDAR | |
OI__MINMAX_ORDER_PERIOD | |
OI__MINMAX_ORDER_PERIOD_UNIT | |
OI__LEAD_TIME_UOM | |
OI__DEMAND_COVERAGE_UNITS | |
OI__BRANCH_CODE |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_SNO | |
---|---|
Column Name | Descritpion |
OI__SUPPLIER_CODE | |
OI__TIME_FENCE_UNITS | |
OI__NAME | |
OI__CITY | |
OI__STATE_PROVINCE | |
OI__COUNTRY | |
OI__POSTAL_CODE | |
OI__LATITUDE | |
OI__LONGITUDE | |
OI__TIME_FENCE_DURATION |
Advanced Supply Chain Planning - MSC_INT_TEMPORAL_RELATION | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__TIME_UNIT | |
OI__FIRST_OPERATION_SET_CODE | |
OI__SECOND_OPERATION_SET_CODE | |
OI__RELATION | |
OI__MIN_SEPARATION | |
OI__MAX_SEPARATION | |
OI__MOVE_TIME | |
OI__QUEUE_TIME | |
OI__SETUP_TIME |
Advanced Supply Chain Planning - MSC_INT_TEMPORAL_RELATION_SNO | |
---|---|
Column Name | Descritpion |
OI__ROUTING_CODE | |
OI__TIME_UNIT | |
OI__FIRST_OPERATION_SET_CODE | |
OI__SECOND_OPERATION_SET_CODE | |
OI__RELATION | |
OI__MIN_SEPARATION | |
OI__MAX_SEPARATION | |
OI__MOVE_TIME | |
OI__QUEUE_TIME | |
OI__SETUP_TIME |
Advanced Supply Chain Planning - MSC_INT_TRANSFER_ORDER_OUT | |
---|---|
Column Name | Descritpion |
OI__TRANSFER_ORDER_CODE | |
OI__ORDER_STATUS | |
OI__QUANTITY | |
OI__LOT_NUMBER | |
OI__LOT_STATUS | |
OI__MANUFACTURING_DATE | |
OI__EXPIRY_DATE | |
OI__QUALITY_CODE | |
OI__TRANSFER_ORDER_NAME | |
OI__LINE_ITEM | |
OI__ORIGIN_BRANCH_CODE | |
OI__DESTINATION_BRANCH_CODE | |
OI__ITEM_CODE | |
OI__SHIP_DATE | |
OI__TRANSPORT_MODE | |
OI__CARRIER_NAME | |
OI__VEHICLE_ID |
Advanced Supply Chain Planning - MSC_INT_TRANSFER_ORDER_DETAIL | |
---|---|
Column Name | Descritpion |
OI__TRANSFER_ORDER_CODE | |
OI__FIX | |
OI__QUANTITY | |
OI__LOT_NUMBER | |
OI__LOT_STATUS | |
OI__MANUFACTURING_DATE | |
OI__EXPIRY_DATE | |
OI__QUALITY_CODE | |
OI__LINE_ITEM | |
OI__ITEM_CODE | |
OI__SHIP_DATE | |
OI__ARRIVE_DATE | |
OI__TRANSPORT_MODE | |
OI__CARRIER_NAME | |
OI__VEHICLE_ID | |
OI__ORDER_STATUS |
Advanced Supply Chain Planning - MSC_INT_TRANSFER_ORDER_IN | |
---|---|
Column Name | Descritpion |
OI__TRANSFER_ORDER_CODE | |
OI__VEHICLE_ID | |
OI__ORDER_STATUS | |
OI__QUANTITY | |
OI__LOT_NUMBER | |
OI__LOT_STATUS | |
OI__MANUFACTURING_DATE | |
OI__EXPIRY_DATE | |
OI__QUALITY_CODE | |
OI__TRANSFER_ORDER_NAME | |
OI__LINE_ITEM | |
OI__DESTINATION_BRANCH_CODE | |
OI__ORIGIN_BRANCH_CODE | |
OI__TRANSACTION_TYPE | |
OI__ITEM_CODE | |
OI__ARRIVE_DATE | |
OI__TRANSPORT_MODE | |
OI__CARRIER_NAME |
Advanced Supply Chain Planning - MSC_INT_TRANSFER_ORDER | |
---|---|
Column Name | Descritpion |
OI__TRANSFER_ORDER_CODE | |
OI__ORIGIN_BRANCH_CODE | |
OI__DESTINATION_BRANCH_CODE |
Advanced Supply Chain Planning - MSC_INT_TRANSFER_ORDER_SNO | |
---|---|
Column Name | Descritpion |
OI__ORIGIN_BRANCH_CODE | |
OI__DESTINATION_BRANCH_CODE | |
OI__ITEM_CODE | |
OI__TRANSPORT_MODE | |
OI__CARRIER_NAME | |
OI__SHIP_DATE | |
OI__ARRIVE_DATE | |
OI__QUANTITY |
Advanced Supply Chain Planning - MSC_INT_TRANSPORT_MODE | |
---|---|
Column Name | Descritpion |
OI__LANE_CODE | |
OI__17 | |
OI__18 | |
OI__TRANSPORT_MODE_CODE | |
OI__5 | |
OI__DESCRIPTION | |
OI__AVAILABILITY_CALENDAR | |
OI__4 | |
OI__LEAD_TIME_UOM | |
OI__WEIGHT_CAPACITY_UOM | |
OI__VOLUME_CAPACITY_UOM | |
OI__MINIMUM_WEIGHT_USAGE | |
OI__MINIMUM_VOLUME_USAGE |
Advanced Supply Chain Planning - MSC_INT_TRANSPORT_MODE_SNO | |
---|---|
Column Name | Descritpion |
OI__LANE_CODE | |
OI__23 | |
OI__24 | |
OI__TRANSPORT_MODE_CODE | |
OI__15 | |
OI__DESCRIPTION | |
OI__AVAILABILITY_CALENDAR | |
OI__14 | |
OI__LEAD_TIME_UOM | |
OI__WEIGHT_CAPACITY_UOM | |
OI__19 | |
OI__VOLUME_CAPACITY_UOM | |
OI__MINIMUM_WEIGHT_USAGE | |
OI__18 | |
OI__MINIMUM_VOLUME_USAGE |
Advanced Supply Chain Planning - MSC_INT_WORK_ORDER | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__MAINTENANCE_OBJECT_TYPE | |
OI__12 | |
OI__QUANTITY | |
OI__DEMAND | |
OI__DEMAND_LINE_ITEM | |
OI__PRIORITY | |
OI__FIRM | |
OI__ITEM_SERIAL_NUMBER | |
OI__PRODUCES_TO_STOCK | |
OI__ON_HOLD | |
OI__OFF_HOLD_DATE | |
OI__BRANCH_CODE | |
OI__STATUS | |
OI__8 | |
OI__CREATED_DATE | |
OI__REQUESTED_DATE | |
OI__WORK_ORDER_UNIT_OF_EFFORT | |
OI__START_DATE | |
OI__COMPLETION_DATE | |
OI__EARLIEST_START_DATE | |
OI__TARGET_COMPLETION_DATE | |
OI__PARENT_WORK_ORDER_CODE | |
OI__13 | |
OI__CHANGES_ALLOWED | |
OI__DESCRIPTION | |
OI__ITEM_CODE | |
OI__ROUTING_CODE | |
OI__WORK_ORDER_NAME | |
OI__TYPE | |
OI__SOURCE | |
OI__SHUTDOWN_TYPE | |
OI__MAINTENANCE_ACTIVITY | |
OI__ASSET_NUMBER | |
OI__MAINTENANCE_OBJECT_ID |
Advanced Supply Chain Planning - MSC_INT_TRANSPORT_MODE_TV_SNO | |
---|---|
Column Name | Descritpion |
OI__LANE_CODE | |
OI__RETURN_TRIP_TIME | |
OI__TRANSPORT_MODE_CODE | |
A__START_DATE | |
A__END_DATE | |
OI__NUMBER_OF_VEHICLES | |
OI__FLAT_RATE_PER_TRIP | |
OI__COST_PER_WEIGHT_UNIT | |
OI__COST_PER_VOLUME_UNIT | |
OI__LEAD_TIME |
Advanced Supply Chain Planning - MSC_INT_TRANSPORT_MODE_TV | |
---|---|
Column Name | Descritpion |
OI__LANE_CODE | |
OI__TRANSPORT_MODE_CODE | |
A__EFFECTIVE_DATE | |
OI__NUMBER_OF_VEHICLES | |
OI__FLAT_RATE_PER_TRIP | |
OI__COST_PER_WEIGHT_UNIT | |
OI__COST_PER_VOLUME_UNIT | |
OI__LEAD_TIME | |
OI__RETURN_TRIP_TIME |
Advanced Supply Chain Planning - MSC_INT_WORK_ORDER_BOR_SNO | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__RESOURCE_TYPE | |
OI__LEAD_TIME_OFFSET | |
OI__END_TIME_OFFSET | |
OI__CAPACITY_REQUIRED | |
OI__BRANCH_CODE | |
OI__OPERATION_SET_NAME | |
OI__RESOURCE_SET | |
OI__RESOURCE_CODE | |
OI__RESOURCE_DESCRIPTION | |
OI__DURATION | |
OI__REMAINING_DURATION | |
OI__TIME_UNIT |
Advanced Supply Chain Planning - MSC_INT_WORK_ORDER_SNO | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__CREATED_DATE | |
OI__REQUESTED_DATE | |
OI__START_DATE | |
OI__COMPLETION_DATE | |
OI__PARENT_WORK_ORDER_CODE | |
OI__18 | |
OI__CHANGES_ALLOWED | |
OI__ITEM_CODE | |
OI__ROUTING_CODE | |
OI__BRANCH_CODE | |
OI__DESCRIPTION | |
OI__TYPE | |
OI__QUANTITY | |
OI__DEMAND | |
OI__DEMAND_LINE_ITEM | |
OI__PRIORITY | |
OI__STATUS |
Advanced Supply Chain Planning - MSC_INT_WORK_ORDER_OPERATION | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__ACTUAL_END_DATE | |
OI__CONSTRAINTS_FLAG | |
OI__RUN_TIME | |
OI__STATUS | |
OI__REMAINING_TIME | |
OI__TIME_UNIT | |
OI__SETUP_TIME | |
OI__QUEUE_TIME | |
OI__MOVE_TIME | |
OI__OVERLAP | |
OI__BRANCH_CODE | |
OI__TEMPORAL_RELATION | |
OI__MIN_SEPARATION | |
OI__MAX_SEPARATION | |
OI__YIELD | |
OI__CUMULATIVE_YIELD | |
OI__START_DATE | |
OI__REQUESTED_DATE | |
OI__COMPLETION_DATE | |
OI__ALLOW_OFFLOADING | |
OI__EARLIEST_START | |
OI__OPERATION_SET_NAME | |
OI__LATEST_END | |
OI__EARLIEST_START_DATE | |
OI__TARGET_COMPLETION_DATE | |
OI__LOT_MULTIPLE_RESOURCE_SET | |
OI__FIRM_STATUS | |
OI__NEXT_OPERATION_CODE | |
OI__DURATION_RESOURCE_OR_SET | |
OI__14 | |
OI__OPERATION_SEQ_NUM | |
OI__RESOURCE_SEQ_NUM | |
OI__OPERATION_CODE | |
OI__SHUTDOWN_TYPE | |
OI__WORK_ORDER_TYPE | |
OI__OPERATION_NAME | |
OI__OPERATION_DESCRIPTION | |
OI__ACTUAL_START_DATE |
Advanced Supply Chain Planning - MSC_INT_WORK_ORDER_BOR | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__DURATION | |
OI__CAPACITY_REQUIRED | |
OI__REMAINING_DURATION | |
OI__SCALE_DURATION | |
OI__LEAD_TIME_OFFSET | |
OI__TIME_UNIT | |
OI__LOT_MULTIPLE | |
OI__END_TIME_OFFSET | |
OI__BRANCH_CODE | |
OI__RESOURCE_TYPE | |
OI__OPERATION_SET_NAME | |
OI__RESOURCE_SET | |
OI__RESOURCE_DESCRIPTION | |
OI__INST_RES_GROUP_NAME | |
OI__RESOURCE_SET_NAME | |
OI__RESOURCE_CODE | |
OI__RESOURCE_GROUP_NAME | |
OI__IS_PLANNED_RESOURCE | |
OI__PREFERENCE |
Advanced Supply Chain Planning - MSC_INT_MACH_ATTRIBUTE | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_CODE | |
OI__BRANCH_CODE | |
OI__ATTRIBUTE_CODE |
Advanced Supply Chain Planning - MSC_INT_NEXT_WORK_ORDER | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__BRANCH_CODE | |
OI__NEXT_WORK_ORDER_CODE | |
OI__TEMPORAL_CONSTRAINT_TYPE | |
OI__PRECEDENCE_RELATION | |
OI__MIN_SEPARATION | |
OI__MIN_SEPARATION_TIME_UNIT | |
OI__MAX_SEPARATION | |
OI__MAX_SEPARATION_TIME_UNIT | |
OI__TIME_UNIT |
Advanced Supply Chain Planning - MSC_INT_RESOURCE_ATTRIBUTE | |
---|---|
Column Name | Descritpion |
OI__ATTRIBUTE_CODE | |
OI__ATTRIBUTE_DESCRIPTION |
Advanced Supply Chain Planning - MSC_INT_SOURCE1 | |
---|---|
Column Name | Descritpion |
ITEM_CODE | |
BRANCH_CODE |
Advanced Supply Chain Planning - MSC_INT_SOURCE2 | |
---|---|
Column Name | Descritpion |
ITEM_CODE | |
BRANCH_CODE | |
ENABLE_DATE | |
DISABLE_DATE |
Advanced Supply Chain Planning - MSC_INT_SCHEDULE_BOR_PLAN | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_SCHEDULE_CODE | |
OI__RESOURCE_ID | |
OI__INTEGRATION_ID | |
OI__PEGGED_WORK_ORDER_CODE | |
OI__BRANCH_CODE | |
OI__OPERATION_CODE | |
OI__RESOURCE_SET | |
OI__PLAN_RESOURCE_GROUP_NAME | |
OI__ACTUAL_RESOURCE_GROUP_NAME | |
OI__ALT_NUM |
Advanced Supply Chain Planning - MSC_INT_SRC_RECOMMEND_DETAIL | |
---|---|
Column Name | Descritpion |
PLANNAME | |
DESTINATION_CODE | |
SOURCING_TYPE | |
TRANSPORT_MODE_CODE | |
ITEM_CODE | |
START_DATE | |
END_DATE | |
AVAILABLE | |
PREFERENCE | |
SOURCING_PERCENT | |
FORECASTCODE | |
DESCRIPTION | |
PLANSOURCE | |
CREATEDDATE | |
SNAPSHOTDATE | |
NUMBEROFPERIODS | |
PERIODSIZE | |
ORIGIN_CODE |
Advanced Supply Chain Planning - MSC_INT_SUPPLIER_ITEM_BRANCH | |
---|---|
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_TOOL | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_CODE | |
OI__TIME_UNIT_FOR_COST | |
OI__TIME_FENCE_UNITS | |
OI__CAPACITY_CONSTRAINT_STATUS | |
OI__OFF_LOAD_WINDOW | |
OI__OFF_LOAD_WINDOW_TIME_UNIT | |
OI__BRANCH_CODE | |
OI__NAME | |
OI__DEPARTMENT_CODE | |
OI__DESCRIPTION | |
OI__AVAILABILITY_CALENDAR | |
OI__REMAINING_USES | |
OI__MAXIMUM_USES | |
OI__9 | |
OI__10 |
Advanced Supply Chain Planning - MSC_INT_TOOL_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_WORK_ORDER_IMP_RES | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__CAPACITY_REQUIRED | |
OI__BRANCH_CODE | |
OI__OPERATION_SET_NAME | |
OI__RESOURCE_SET | |
OI__INST_RES_GROUP_NAME | |
OI__RESOURCE_CODE | |
OI__RESOURCE_TYPE | |
OI__LEAD_TIME_OFFSET | |
OI__END_TIME_OFFSET |
Advanced Supply Chain Planning - MSC_ITEM_WIPS_F | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
AGGR_TYPE | |
CATEGORY_SET_ID | |
PLAN_RUN_ID | |
SR_CATEGORY_ID | |
SR_INSTANCE_ID | |
ORGANIZATION_ID | |
INVENTORY_ITEM_ID | |
VMI_FLAG | |
WIP_START_DATE | |
WIP_QTY | |
CREATED_BY |
Advanced Supply Chain Planning - MSC_ITEM_INVENTORY_F | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
PAB_VALUE2 | |
MANUFACTURING_COST2 | |
SAFETY_STOCK_QTY | |
MIN_INVENTORY_LEVEL | |
MANUFACTURING_COST | |
MAX_INVENTORY_LEVEL | |
AVG_DAILY_DEMAND | |
OWNING_INST_ID | |
CREATED_BY | |
CREATION_DATE | |
REVENUE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
SHIP_METHOD | |
PLAN_RUN_ID | |
PROGRAM_ID | |
SUPPLY_CHAIN_COST2 | |
CARRYING_COST | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
PURCHASING_COST2 | |
REQUEST_ID | |
ODS_PLAN_ID | |
TRANSPORTATION_COST2 | |
GROSS_MARGIN2 | |
GROSS_MARGIN | |
INV_BUILD_TARGET | |
CARRYING_COST2 | |
AGGR_TYPE | |
PURCHASING_COST | |
CATEGORY_SET_ID | |
SR_INSTANCE_ID | |
SR_CATEGORY_ID | |
TRANSPORTATION_COST | |
DEMAND_VAR_SS_QTY | |
SUP_LTVAR_SS_QTY | |
SUPPLY_CHAIN_COST | |
TRANSIT_LTVAR_SS_QTY | |
MFG_LTVAR_SS_QTY | |
OWNING_ORG_ID | |
TOTAL_UNPOOLED_SAFETY_STOCK | |
INVENTORY_COST_POST | |
INVENTORY_VALUE_POST2 | |
INVENTORY_COST_NO_POST2 | |
INVENTORY_COST_NO_POST | |
INVENTORY_VALUE_NO_POST | |
ORGANIZATION_ID | |
INVENTORY_VALUE_POST | |
INVENTORY_COST_POST2 | |
INVENTORY_VALUE_NO_POST2 | |
LAST_UPDATE_LOGIN | |
SAFETY_STOCK_VALUE | |
SAFETY_STOCK_VALUE2 | |
SAFETY_STOCK_DAYS | |
INVENTORY_VALUE | |
INVENTORY_VALUE2 | |
INVENTORY_ITEM_ID | |
VMI_FLAG | |
IO_PLAN_FLAG | |
ORDER_DATE | |
PAB_QTY | |
REVENUE2 | |
PAB_VALUE |
Advanced Supply Chain Planning - MSC_ITEM_ORDERS_F | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
SUPPLY_QTY | |
VMI_FLAG | |
PLANNED_ORDER_QTY | |
INDEP_DEMAND_QTY | |
CREATION_DATE | |
DEP_DEMAND_QTY | |
SALES_ORDER_VALUE | |
SCHEDULED_REPT_VALUE | |
RETURN_ORDER_VALUE | |
MAKE_ORDER_QTY | |
MAKE_ORDER_LEADTIME | |
MAKE_ORDER_COUNT | |
STOCK_OUTS_COUNT | |
PLAN_RUN_ID | |
NO_ACTIVITY_ITEM_COUNT | |
ITEM_LEADTIME | |
AVG_DAILY_DEMAND | |
DAYS_IN_BKT | |
CREATED_BY | |
LAST_UPDATE_LOGIN | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
PROGRAM_ID | |
SR_INSTANCE_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
INDEP_DEMAND_VALUE | |
ODS_PLAN_ID | |
SCHEDULED_REPT_QTY | |
ONHAND_QTY | |
FORECAST_QTY | |
IO_PLAN_FLAG | |
OWNING_INST_ID | |
ORGANIZATION_ID | |
AGGR_TYPE | |
CATEGORY_SET_ID | |
SR_CATEGORY_ID | |
DMD_PGD_TO_SCHD_RECP | |
DMD_PGD_TO_PLND_ORDER | |
DMD_PGD_TO_ONHAND | |
DMD_PGD_TO_SCHD_RECP_VALUE | |
DMD_PGD_TO_PLND_ORDER_VALUE | |
DMD_PGD_TO_ONHAND_VALUE | |
DMD_PGD_TO_SCHD_RECP_VALUE2 | |
INVENTORY_ITEM_ID | |
DMD_PGD_TO_PLND_ORDER_VALUE2 | |
DMD_PGD_TO_ONHAND_VALUE2 | |
ONHAND_USABLE | |
INTRANSIT_USABLE | |
PLND_XFER_USABLE | |
ONHAND_DEFECTIVE | |
INTRANSIT_DEFECTIVE | |
PLND_XFER_DEFECTIVE | |
SUPPLY_QTY_USABLE | |
SUPPLY_QTY_DEFECTIVE | |
ORDER_DATE | |
SUP_END_PGD_TO_FCST | |
SUP_END_PGD_TO_SO | |
SUP_END_PGD_TO_SS | |
SUP_END_PGD_TO_EXCESS | |
SUP_END_PGD_TO_FCST_VALUE | |
SUP_END_PGD_TO_SO_VALUE | |
SUP_END_PGD_TO_SS_VALUE | |
SUP_END_PGD_TO_EXCESS_VALUE | |
SUP_END_PGD_TO_FCST_VALUE2 | |
SUP_END_PGD_TO_SO_VALUE2 | |
SUP_END_PGD_TO_SS_VALUE2 | |
SUP_END_PGD_TO_EXCESS_VALUE2 | |
ONHAND_VALUE | |
ONHAND_VALUE2 | |
SUBINVENTORY_CODE | |
SCHEDULED_REPT_VALUE2 | |
SALES_ORDER_VALUE2 | |
DEMAND_QTY | |
OWNING_ORG_ID | |
PEGGED_TO_EXCESS_QTY |
Advanced Supply Chain Planning - MSC_INT_ITEM_TRAVEL_DISTANCE | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
SR_INSTANCE_ID | |
INVENTORY_ITEM_ID | |
PERIOD_TYPE | |
PERIOD_END | |
TRANSPORTATION_MODE | |
ITEM_TRAVEL_DISTANCE |
Advanced Supply Chain Planning - MSC_INT_SCHEDULE_MILESTONE | |
---|---|
Column Name | Descritpion |
OI__VISIT_CODE | |
OI__SCHEDULE_MILESTONE_CODE | |
OI__12 | |
OI__EARLIEST_START_DATE | |
OI__TARGET_COMPLETION_DATE |
Advanced Supply Chain Planning - MSC_INT_TOOL_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_TOOL_SNO | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_CODE | |
OI__TIME_FENCE_UNITS | |
OI__CAPACITY_CONSTRAINT_STATUS | |
OI__OFF_LOAD_WINDOW | |
OI__BRANCH_CODE | |
OI__NAME | |
OI__DESCRIPTION | |
OI__AVAILABILITY_CALENDAR | |
OI__REMAINING_USES | |
OI__MAXIMUM_USES | |
OI__26 | |
OI__TIME_UNIT_FOR_COST |
Advanced Supply Chain Planning - MSC_INT_VISIT | |
---|---|
Column Name | Descritpion |
OI__VISIT_CODE | |
OI__VISIT_NAME | |
OI__VISIT_ID | |
OI__DESCRIPTION | |
OI__VISIT_TYPE | |
OI__SRC_PRIORITY | |
OI__PRIORITY | |
OI__EARLIEST_START_DATE | |
OI__REQUESTED_DATE |
Advanced Supply Chain Planning - MSC_INT_WO_CONSUMED_ITEM_BOM | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__SCRAP_FACTOR | |
OI__LEAD_TIME_OFFSET | |
OI__END_TIME_OFFSET | |
OI__PARENT_WORK_ORDER_CODE | |
OI__15 | |
OI__BRANCH_CODE | |
OI__OPERATION_SET_NAME | |
OI__CONSUMED_ITEM_SET | |
OI__ITEM_CODE | |
OI__IS_PLANNED_ITEM | |
OI__QUANTITY | |
OI__REMAINING_QUANTITY | |
OI__PREFERENCE |
Advanced Supply Chain Planning - MSC_INT_WO_OPERATION_SET | |
---|---|
Column Name | Descritpion |
OI__OPERATION_SET_CODE | |
OI__BRANCH_CODE | |
OI__WORK_ORDER_CODE | |
OI__OPERATION_SEQ_NUM | |
OI__RESOURCE_SEQ_NUM |
Advanced Supply Chain Planning - MSC_INT_WO_PRODUCED_ITEM_BOM | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__LEAD_TIME_OFFSET | |
OI__END_TIME_OFFSET | |
OI__PARENT_WORK_ORDER_CODE | |
OI__16 | |
OI__BRANCH_CODE | |
OI__OPERATION_SET_NAME | |
OI__ITEM_CODE | |
OI__TRANSACTION_ID | |
OI__PRODUCT_TYPE | |
OI__QUANTITY | |
OI__REMAINING_QUANTITY | |
OI__YIELD |
Advanced Supply Chain Planning - MSC_ITEMS_F | |
---|---|
Column Name | Descritpion |
PLAN_ID | |
DMD_WITHIN_EXCESS_HORIZON | |
EXCESS_ONORDER | |
EXCESS_ONHAND | |
OBSOLETE_ONORDER | |
OBSOLETE_ONHAND | |
TOTAL_EXCESS | |
EXCESS_FROM_ONHAND_VALUE | |
EXCESS_FROM_ONORDER_VALUE | |
TOTAL_EXCESS_VALUE | |
EXCESS_FROM_ONHAND_VALUE2 | |
PLAN_RUN_ID | |
EXCESS_FROM_ONORDER_VALUE2 | |
TOTAL_EXCESS_VALUE2 | |
TOTAL_OBS | |
OBSOLETE_ONHAND_VALUE | |
OBSOLETE_ONORDER_VALUE | |
TOTAL_OBS_VALUE | |
OBSOLETE_ONHAND_VALUE2 | |
OBSOLETE_ONORDER_VALUE2 | |
TOTAL_OBS_VALUE2 | |
CREATED_BY | |
SR_INSTANCE_ID | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PROGRAM_ID | |
PROGRAM_LOGIN_ID | |
PROGRAM_APPLICATION_ID | |
REQUEST_ID | |
AVG_DAILY_DEMAND | |
ORGANIZATION_ID | |
INVENTORY_ITEM_ID | |
CATEGORY_SET_ID | |
SR_CATEGORY_ID | |
AGGR_TYPE | |
DMD_WITHIN_OBS_HORIZON |
Advanced Supply Chain Planning - MSC_INT_PS_DEMAND_ITEM | |
---|---|
Column Name | Descritpion |
OI__ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_PS_ALL_ITEM | |
---|---|
Column Name | Descritpion |
OI__ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_PS_SUPPLY_ITEM | |
---|---|
Column Name | Descritpion |
OI__ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_PS_END_ITEM | |
---|---|
Column Name | Descritpion |
OI__ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_RESERVATION | |
---|---|
Column Name | Descritpion |
OI__BRANCH_CODE | |
OI__DEMAND_TYPE | |
OI__DEMAND_ORDER_NUMBER | |
OI__DEMAND_ORDER_LINE | |
OI__RESERVATION_NAME | |
OI__DESCRIPTION | |
OI__ITEM_CODE | |
OI__ITEM_SERIAL_NUMBER | |
OI__QUANTITY | |
OI__SUPPLY_TYPE | |
OI__SUPPLY_ORDER_NUMBER | |
OI__SUPPLY_ORDER_LINE |
Advanced Supply Chain Planning - MSC_INT_SHIFT_CALENDAR | |
---|---|
Column Name | Descritpion |
OI__RESOURCE_CODE | |
OI__BRANCH_CODE | |
OI__CALENDAR_CODE |
Advanced Supply Chain Planning - MSC_INT_SUB_COMPONENT_ITEM | |
---|---|
Column Name | Descritpion |
OI__ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_SUPPLY_END_ITEM | |
---|---|
Column Name | Descritpion |
OI__ITEM_ID |
Advanced Supply Chain Planning - MSC_INT_WO_CMRO_CONFIG | |
---|---|
Column Name | Descritpion |
OI__WORK_ORDER_CODE | |
OI__WORK_BREAKDOWN_LEVEL7 | |
OI__WORK_BREAKDOWN_LEVEL8 | |
OI__WORK_BREAKDOWN_LEVEL9 | |
OI__PREVIOUS_MILESTONE_CODE | |
OI__NEXT_MILESTONE_CODE | |
OI__BRANCH_CODE | |
OI__VISIT_CODE | |
OI__WORK_BREAKDOWN_LEVEL1 | |
OI__WORK_BREAKDOWN_LEVEL2 | |
OI__WORK_BREAKDOWN_LEVEL3 | |
OI__WORK_BREAKDOWN_LEVEL4 | |
OI__WORK_BREAKDOWN_LEVEL5 | |
OI__WORK_BREAKDOWN_LEVEL6 |
Advanced Supply Chain Planning - MSC_INT_WO_TEMPORAL_REL | |
---|---|
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_ITEM_INSTANCE_IBUC_GT | |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | |
INSTANCE_ID | |
QUANTITY | |
ZONE | |
REGION_ID | |
WEEK_START_DATE | |
CONTRACT_EXISTS | |
GROUP_ID |
No hay comentarios:
Publicar un comentario