CP_PRODKIT_VW(SQL View) |
Index Back |
|---|---|
CP Config Kit ViewView of CP_OPT_HDR |
| Select BUSINESS_UNIT, ORDER_NO, ORDER_INT_LINE_NO, CP_MODE, CP_COMP_SEQ, PARENT_ITEM_ID, INV_ITEM_ID, PRODUCT_ID, MFG_PURCH_FLG, QTY_PER, QTY_CODE, OPTIONAL_SHIP, UNIT_OF_MEASURE from PS_CP_OPT_HDR where MFG_PURCH_FLG = 'K' AND CP_MODE = 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW |
| 2 | 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 |
| 3 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | 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 |
| 5 | CP_COMP_SEQ | Number(3,0) | SMALLINT NOT NULL | Component Sequence Field |
| 6 | PARENT_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Item ID |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 8 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 9 | MFG_PURCH_FLG | Character(1) | VARCHAR2(1) NOT NULL | Manufacture or Purchase Flag |
| 10 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 11 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 12 | OPTIONAL_SHIP | Character(1) | VARCHAR2(1) NOT NULL | OK to Ship Without |
| 13 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |