FND Design Data [Home] [Help]

Lookup Type: MSC_PQ_EXCP

Product: MSC - Advanced Supply Chain Planning
Meaning: For Exceptions Used in ASCP
Description: Field Prompts used for Personal Queries
Quick Codes
Code Meaning Description
ABOVE_MAX_INV_LVL_PCT % above Maximum
ABOVE_TARGET_QTY_PCT % above Target
ACTUAL_OFFSET Actual Offset
ALLOCATED_PERCENTAGE % of Total Supply Allocated
ALLOCATED_QTY Allocated Qty
ALLOCATION_RULE Allocation Rule
ALTERNATE_BOM Alternate BOM
ASSET_ACTIVITY Asset Activity
ASSET_GROUP Asset Group
ASSET_NUMBER Asset Number
ATP_OVERRIDE_FLAG ATP Override
AVAILABLE_CAPACITY Available Capacity Available Capacity
AVAILABLE_DATE Available Date
BELOW_SS_QTY_PCT % quantity below safety stock
BELOW_TARGET_QTY_PCT % below Target
BKT_END_DATE Bucket End Date
BKT_START_DATE Bucket Start Date
CALENDAR_CODE Calendar
CALENDAR_TYPE Calendar Type
CATEGORY_NAME Item Category
COMPRESSION_PCT Compression Percentage
CONSTRAINT_DATE Constraint Date
CONSTRAINT_PCT Constraint Percentage
CUBE Cube
CUBE_OVERLOAD Cube Overload %
CUBE_UNDERLOAD Cube Underload %
CUSTOMER_NAME Customer
CUSTOMER_SITE Customer Site
DAYS_EARLY Days Early
DAYS_EARLY_ARRIVAL Days Early on Arrival
DAYS_EARLY_BEFORE_LADATE Days Early before Latest Acceptable Date
DAYS_LATE Days Late
DAYS_LATE_ARRIVAL Days Late on Arrival
DAYS_LATE_BEYOND_LADATE Days Late beyond Latest Acceptable Date
DAYS_LATE_SUPPLY Days Late (Supply)
DAYS_PAST Days in the Past
DEMAND_CATEGORY_NAME Demand : Item Category
DEMAND_CLASS Demand Class
DEMAND_DATE Demand Date
DEMAND_DEMAND_CLASS Demand : Demand Class
DEMAND_DEMAND_DATE Demand : Demand Date
DEMAND_DUE_DATE Demand Due Date
DEMAND_END_ORDER_NUMBER Demand : Order Number of Sales Orders
DEMAND_ITEM_SEGMENTS Demand : Item
DEMAND_ORDER_NUMBER Demand : Order Number
DEMAND_ORDER_PRIORITY Demand : Priority
DEMAND_ORDER_TYPE Demand : Order Type
DEMAND_ORGANIZATION_CODE Demand : Org
DEMAND_PLANNER_CODE Demand : Planner
DEMAND_PLANNING_GROUP Demand : Planning Group
DEMAND_PRODUCT_FAMILY Demand : Product Family
DEMAND_PROJECT_NUMBER Demand : Project
DEMAND_QUANTITY Demand : Quantity
DEMAND_SALES_ORDER_LINE_PRICE Demand : Value of Sales Order
DEMAND_SCHEDULED_ARRIVAL_DATE Demand : Schedule Arrival Date
DEMAND_TASK_NUMBER Demand : Task
DEMAND_~CUSTOMER_NAME Demand : Customer
DEMAND_~CUSTOMER_SITE Demand : Customer Site
DEPARTMENT_CODE Department Code
DEST_ORGANIZATION_CODE Destination Organization
DOCK_DATE Dock Date
DUE_DATE Due Date
DUE_DATE_QTY_PCT % quantity satisfied by due date
DURATION_DAYS Duration(Days)
END_DATE End Date
END_DATE_FROM End Date From
END_DATE_TO End Date To
END_ORDER_NUMBER Order Number of Sales Orders
EXCESS_DURATION Excess Duration
EXCESS_QUANTITY Excess Quantity
EXCP_AGE Age(in Days)
FIRM_PLANNED_TYPE Firm
FROM_DATE From Date
FROM_PLANNING_GROUP From Planning Group
FROM_PROJECT_NUMBER From Project
FROM_TASK_NUMBER From Task
INTRANSIT_LEAD_TIME New Intransit Lead Time
ITEM_FROM Item From
ITEM_SEGMENTS Item
ITEM_TO Item To
JUST_DATE Date
LATEST_ACCEPTABLE_DATE Latest Acceptable Date
LOAD_PCT Load Percentage
LOAD_RATIO_DIFFERENCE Load Ratio Difference
LOT_EXPIRATION_DATE Lot Expiration Date
MAXIMUM_TIME_OFFSET Maximum Time Offset
MAX_CUBE_ALLOWED Max Cube Allowed
MAX_QTY Maximum Quantity
MAX_WEIGHT_ALLOWED Max Weight Allowed
MINIMUM_TIME_OFFSET Minimum Time Offset
MINIMUM_TRANSFER_QUANTITY Minimum Transfer Quantity
MIN_CUBE_ALLOWED Min Cube Allowed
MIN_WEIGHT_ALLOWED Min Weight Allowed
MODEL_OPTION_CLASS Model/Option Class
NEED_BY_DATE Need By Date
OLD_DUE_DATE Old Due Date
OPERATION_SEQUENCE_NUMBER_FROM Operation Sequence Number From
OPERATION_SEQUENCE_NUMBER_TO Operation Sequence Number To
ORDER_DATE Order Date
ORDER_NUMBER Order Number
ORDER_PRIORITY Priority
ORDER_TYPE Order Type
ORGANIZATION_CODE Org
ORGANIZATION_FROM Organization From
ORGANIZATION_TO Organization To
ORIG_LEAD_TIME Old Intransit Lead Time
ORIG_SCHED_ARRIVAL_DATE Schedule Arrival Date
ORIG_SCHED_SHIP_DATE Schedule Ship Date
ORIG_SHIP_METHOD Old Ship Method
ORIG_SOURCE_ORG_CODE Old Source Org
OVERLOAD_DATE Overload Date
OVERLOAD_PCT Overload Percentage
PERCENT_VARIANCE Percent Variation
PLANNER_CODE Planner
PLANNING_GROUP Planning Group
PRODUCT_FAMILY Product Family
PROJECT_NUMBER Project
PROMISE_ARRIVAL_DATE Promise Arrival Date
PROMISE_SHIP_DATE Promise Ship Date
QTY_MISMATCH_PCT Percentage Quantity Mismatch
QUANTITY Quantity
QUANTITY_BY_DUE_DATE Quantity Satisfied by Due Date Quantity Satisfied by Due Date
REQUESTED_START_DATE Requested Start Date
REQUEST_ARRIVAL_DATE Request Arrival Date
REQUEST_SHIP_DATE Request Ship Date
REQUIRED_CAPACITY Required Capacity Required Capacity
REQUIRED_COMPLETION_DATE Required Completion Date
RESCHEDULE_IN_DAYS Reschedule In Days
RESCHEDULE_OUT_DAYS Reschedule Out Days
RESOURCE_CODE Resource
RESOURCE_SEQUENCE_NUMBER_FROM Resource Sequence Number From
RESOURCE_SEQUENCE_NUMBER_TO Resource Sequence Number To
SALES_ORDER_LINE_PRICE Value of Sales Order
SCHEDULED_ARRIVAL_DATE Planned Arrival Date
SCHED_ARRIVAL_DATE New Schedule Arrival Date
SCHED_SHIP_DATE New Schedule Ship Date
SELF_LIFE_DAYS Shelf Life Days
SETUP_TIME_RATIO Setup Time Ratio
SHIPMENT_ID Trip
SHIP_DATE Ship Date
SHIP_METHOD Ship Method
SHIP_ORGANIZATION_CODE Ship from Organization
SHORTAGE_DATE Shortage Date
SHORTAGE_DURATION Shortage Duration
SHORTAGE_QUANTITY Shortage Quantity
SOURCE_ORGANIZATION_CODE Source Organization
SS_QUANTITY Safety Stock Quantity
START_DATE Start Date
START_DATE_FROM Start Date From
START_DATE_TO Start Date To
SUBSTITUTE_COMP Substitute Component
SUBSTITUTE_COMP_CATE Substitute Component Category
SUBSTITUTE_COMP_PROD Substitute Component Product Family
SUBSTITUTE_ITEM_CATE Substitute Item Category
SUBSTITUTE_ITEM_NAME Substitute Item
SUBSTITUTE_ITEM_PROD Substitute Product Family
SUBSTITUTE_ORG_CODE Substitute Source Organization
SUBSTITUTION_PCT Substitution Percentage
SUGGESTED_DUE_DATE Suggested Due Date
SUPPLIER_NAME Supplier
SUPPLIER_SITE Supplier Site
SUPPLY_DAYS_LATE_SUPPLY Supply : Days Late (Supply)
SUPPLY_DEPARTMENT_CODE Supply : Department Code
SUPPLY_END_DATE Supply : End Date
SUPPLY_FIRM_TYPE Supply : Firm
SUPPLY_ITEM_SEGMENTS Supply : Item
SUPPLY_ORDER_NUMBER Supply : Order Number
SUPPLY_ORDER_NUMBER_FROM Supply Order Number From
SUPPLY_ORDER_NUMBER_TO Supply Order Number To
SUPPLY_ORDER_TYPE Supply : Order Type
SUPPLY_ORGANIZATION_CODE Supply : Org
SUPPLY_OVERLOAD_PCT Supply : Overload Percentage
SUPPLY_PLANNER_CODE Supply : Planner
SUPPLY_PLANNING_GROUP Supply : Planning Group
SUPPLY_PROJECT_NUMBER Supply : Project
SUPPLY_RESOURCE_CODE Supply : Resource
SUPPLY_SHIP_METHOD Supply : Ship Method
SUPPLY_SHORTAGE_DATE Supply : Shortage Date
SUPPLY_SHORTAGE_QUANTITY Supply : Shortage Quantity
SUPPLY_SOURCE_ORG_CODE Supply : Source Org
SUPPLY_START_DATE Supply : Start Date
SUPPLY_SUGGESTED_DUE_DATE Supply : Suggested Due Date
SUPPLY_SUPPLIER_NAME Supply : Supplier
SUPPLY_SUPPLIER_SITE Supply : Supplier Site
SUPPLY_TASK_NUMBER Supply : Task
TARGET_QTY Target Quantity
TASK_NUMBER Task
TO_DATE To Date
TO_PLANNING_GROUP To Planning Group
TO_PROJECT_NUMBER To Project
TO_TASK_NUMBER To Task
UNDERLOAD_DATE Underload Date
UNDERLOAD_PCT Underload Percentage
WEIGHT Weight
WEIGHT_OVERLOAD Weight Overload %
WEIGHT_UNDERLOAD Weight Underload %