PUR_PEG_WS(SQL Table) |
Index Back |
|---|---|
Purchasing Peg info WorkScroll09/14/2018 Nash 28397501 Added EE_SEQ_NUM field to ensure that deleting purchase order lines subsequently without saving, will update the peg status correctly to the work order tables and hence the PC_PO_TO_PC unique constraint is resolved. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DOC_ID | Character(50) | VARCHAR2(50) NOT NULL | ID |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 5 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 6 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW |
| 7 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table: %EDIT_WO_ID |
| 8 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL |
Task Number
Prompt Table: %EDIT_WO_TASK |
| 9 | RSRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor 2=Tools 3=Material |
| 10 | RES_LN_NBR | Number(5,0) | INTEGER NOT NULL |
Resource Line No.
Prompt Table: %EDIT_RES_LINE |
| 11 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 12 | CHNG_NBR_VALUE | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | New Numeric Value |
| 13 | CHAR_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Old Edit Value |
| 14 | DATE_VALUE | Date(10) | DATE | Date Value |
| 15 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
| 16 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 17 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 18 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 19 | REQ_DISTRIB_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |
| 20 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 21 | QTY_PO_PRIOR | Number(16,4) | DECIMAL(15,4) NOT NULL | Prior PO Quantity |
| 22 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 23 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 24 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 25 | EE_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Entry Event Sequence Number |