WM_WO_MAT_MR(SQL Table) |
Index Back |
|---|---|
Work Order Material Ready |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 5 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 6 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 7 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | QTY_SCHEDULED_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Scheduled base |
| 10 | WO_MAT_NEED_DT | Date(10) | DATE | Work Management Material needed date. This field is used when committing inventory and the needed date |
| 11 | WO_COMMIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Management Commit Flag. This flag handles WO commitments against PS Inventory
1=Not Committed 2=In Process 3=Committed |
| 12 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 13 | QTY_AVAILABLE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Available |
| 14 | QTY_ALLOC_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity allocation |
| 15 | QTY_PICK_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Pick Base |
| 16 | QTY_PEGGED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 06/16/04 EGS: Created. |
| 17 | MATERIAL_READY_CD | Character(2) | VARCHAR2(2) NOT NULL |
Material Ready Code
10=Ready 20=Not Ready 30=Undetermined |
| 18 | PEG_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL | Pegging Exception |
| 19 | NEG_AVAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Negative Available Flag |
| 20 | PAST_DUE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Past Due Flag |
| 21 | REQ_NULL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Null Date Requisition Flag |
| 22 | MR_REASON_CD | Character(2) | VARCHAR2(2) NOT NULL |
Not Ready Reason Code
10=Ready 20=Negative Available 30=Late Supply 40=Past Due Supply 50=Undefined Due Date 60=No Quantity Available 70=Insufficient QTY Available 75=Insufficient Peg Quantity 80=Not Pegged 90=Multiple Reasons |
| 23 | NR_REASON_CNT | Number(3,0) | SMALLINT NOT NULL | Reason Count |
| 24 | UD_REASON_CNT | Number(3,0) | SMALLINT NOT NULL | Reason Count |