PL_CAP_USG_DTAO(SQL Table) |
Index Back |
|---|---|
Capacity Usage Detail with PIDTemporary table -- Capacity Usage Detail by Production ID or Planned Order ID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PL_RESOURCE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 01/14/03 JC (CN#PL880-1): Added label SPL_WORK_CENTER |
| 5 | START_DTTM |
DateTime(26) | TIMESTAMP | start date time |
| 6 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 7 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 8 | PL_SC_START_DATE |
DateTime(26) | TIMESTAMP | PL_SC_START_DATE |
| 9 | PL_ORDER_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
RAG# Added filed for Planning Phoneix.
BA=Buying Agreement NFC=Net Forecast PDN=Production Order PLN=Planned Order PPO=Planned Purchase Order PPR=Planned Production PSS=Strategic Sourcing Event PTR=Planned Transfer PUR=Purchase Order SO=Sales Order SOH=Starting On Hand Qty SR=Material Stock Request TFR=Transfer XD=Extra Demand |
| 10 | PL_SC_END_DATE | DateTime(26) | TIMESTAMP | PL_SC_END_DATE |
| 11 | QTY_REQUIRED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Work Order quantity required |
| 12 | PL_RSRC_LD | Number(16,4) | DECIMAL(15,4) NOT NULL | PL_RSRC_LD |
| 13 | PL_RSRC_LD_PCT | Number(16,4) | DECIMAL(15,4) NOT NULL | PL_RSRC_LD_PCT |