IN_CART_ITEM_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.INV_CART_ID , A.INV_ITEM_ID , A.COMPARTMENT , A.CART_COUNT_ID , A.COUNT_ORDER , A.SUFFICIENT_STOCK , A.CART_COUNT_QTY , A.UNIT_OF_MEASURE , A.QTY_OPTIMAL , 0 , A.LAST_OPRID , A.LAST_DTTM_UPDATE , B.DESCR60 , B.DESCR , 'Y' , ' ' , ' ' FROM PS_CART_CT_INF_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.CART_COUNT_ID = ( SELECT MAX(CART_COUNT_ID) FROM PS_CART_CT_INF_INV WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND INV_CART_ID = A.INV_CART_ID AND INV_ITEM_ID = A.INV_ITEM_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment
5 CART_COUNT_ID Number(10,0) DECIMAL(10) NOT NULL Par Location Count ID
6 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order
7 SUFFICIENT_STOCK Character(1) VARCHAR2(1) NOT NULL Sufficient Stock
N=NOT SUFFICIENT STOCK
Y=SUFFICIENT STOCK
8 CART_COUNT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Par Location Count Quantity
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 QTY_OPTIMAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Optimal Qty
11 AVG_CART_USAGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Usage
12 LAST_OPRID Character(30) VARCHAR2(30) NOT NULL Last Response Operator
13 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
16 INCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL include flag
17 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
18 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID