SOURCE_BUS_UNITORDER_NOORDER_INT_LINE_NOSCHED_LINE_NBRPRODUCT_IDPROD_COMPONENT_IDASY=Assembly
ORD=Order
Y/N Table Edit
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
N=No
Y=Yes
SHIP_CFGKIT_VW(SQL View) |
Index Back |
|---|---|
Cfg Prod Kit Shipment Detl Vw/* mmt 04/05/05 Data model changes */ /* 06/09/04 PWF */ /* 07/10/04 PWF */ |
| SELECT DISTINCT OP.BUSINESS_UNIT , OP.ORDER_NO , OP.ORDER_INT_LINE_NO , SI.SCHED_LINE_NBR , OP.PARENT_ITEM_ID , OP.PRODUCT_ID , MI.INV_ITEM_ID , OP.QTY_PER , %Round(%DecMult(OP.QTY_PER, UM.CONVERSION_RATE), 4) , OP.QTY_CODE , OP.OPTIONAL_SHIP , OP.UNIT_OF_MEASURE , ' ' , 0 , 0 , 0 , 0 , MI.UNIT_MEASURE_STD , 0 , 0 , ' ' , 0 , MI.INVENTORY_ITEM FROM PS_PROD_ITEM PI , PS_CP_OPT_HDR OP , PS_MASTER_ITEM_TBL MI , PS_INV_ITEM_UOM UM , PS_SET_CNTRL_REC SC , PS_SHIP_DTL_INV_VW SI WHERE SC.SETID = PI.SETID AND SC.SETCNTRLVALUE = OP.BUSINESS_UNIT AND SC.RECNAME = 'PROD_ITEM' AND PI.SETID = MI.SETID AND SI.SOURCE_BUS_UNIT = OP.BUSINESS_UNIT AND SI.BUSINESS_UNIT = OP.BUSINESS_UNIT_IN AND SI.ORDER_NO = OP.ORDER_NO AND SI.ORDER_INT_LINE_NO = OP.ORDER_INT_LINE_NO AND SI.PARENT_PROD_ID = OP.PARENT_ITEM_ID AND PI.INV_ITEM_ID = MI.INV_ITEM_ID AND MI.INVENTORY_ITEM = 'Y' AND PI.PRODUCT_ID = OP.PRODUCT_ID AND OP.CP_MODE = 'S' AND OP.MFG_PURCH_FLG = 'K' AND PI.SETID = UM.SETID AND PI.INV_ITEM_ID = UM.INV_ITEM_ID AND OP.UNIT_OF_MEASURE = UM.UNIT_OF_MEASURE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 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 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | PROD_COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product Component ID |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 8 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 9 | QTY_PER_BASE | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity Per in Base UOM |
| 10 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 11 | OPTIONAL_SHIP | Character(1) | VARCHAR2(1) NOT NULL |
OK to Ship Without
Y/N Table Edit |
| 12 | KIT_UOM | Character(3) | VARCHAR2(3) NOT NULL | Product Kit UOM |
| 13 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 14 | QTY_REQUESTED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested |
| 15 | QTY_PICKED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Picked |
| 16 | QTY_PICK_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Pick Base |
| 17 | QTY_SHIPPED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
| 18 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 19 | QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Ship Base |
| 20 | MAX_QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Quantity Ship Base UOM |
| 21 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |
| 22 | QTY_SHIPPED_CONV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
| 23 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |