ASCP Table MSC_FULL_PEGGING values of field SUPPLY_TYPE
What lookup is being used to interpret the value in the field MSC_FULL_PEGGING.SUPPLY_TYPE?
I see values of 1,2,3,5,7,8,10,11,13, 18 in my data.
I found some sql that used a decode statement that used:
1, 'Purchase Order',
2, 'Purchase Requisition',
3, 'Work Order',
11, 'Intransit Shipment',
12, 'Intransit receipt',
Which I thought was lookup MRP_ORDER_TYPE because I see which seemed to make sense:
5, 'Planned Order',
7, 'Non Standard Job', (Please define this)
8, 'PO In Receiving',
11, 'Intransit Shipment',
13, 'Suggested Repetitive Schedule',
18, 'On Hand
If this field is interpreted using an MRP_ORDER_TYPE lookup then what is 10? If not which lookup table can I use to get the 'English' version of the Supply_Type? What is a 'Non Standard Job'