SP_PRDKIT_OPRVW(SQL View) |
Index Back |
|---|---|
CP Config Kit View |
| SELECT C.OPRID , A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.CP_MODE , A.CP_COMP_SEQ , A.PARENT_ITEM_ID , A.INV_ITEM_ID , A.PRODUCT_ID , A.MFG_PURCH_FLG , A.QTY_PER , A.QTY_CODE , A.OPTIONAL_SHIP , A.UNIT_OF_MEASURE FROM PS_CP_OPT_HDR A , PS_BUS_UNIT_TBL_FS B , PS_SEC_BU_OPR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND MFG_PURCH_FLG = 'K' AND CP_MODE = 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW |
| 3 | 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 |
| 4 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 5 | CP_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Rule Processing Modes Field
A=CRM Internal C=Model Tester M=Direct Production Order R=Direct Requisition Order S=Sales Order W=CRM External Default Value: S |
| 6 | CP_COMP_SEQ | Number(3,0) | SMALLINT NOT NULL | Component Sequence Field |
| 7 | PARENT_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Item ID |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 10 | MFG_PURCH_FLG | Character(1) | VARCHAR2(1) NOT NULL | Manufacture or Purchase Flag |
| 11 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 12 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 13 | OPTIONAL_SHIP | Character(1) | VARCHAR2(1) NOT NULL | OK to Ship Without |
| 14 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |