CART_CT_UPD_VW

(SQL View)
 Index Back

Par Location Update View

Par Location Update View

SELECT A.BUSINESS_UNIT , A.INV_CART_ID , A.INV_ITEM_ID , A.COMPARTMENT , B.CART_COUNT_ID , A.COUNT_ORDER , B.SUFFICIENT_STOCK , B.CART_COUNT_QTY , A.UNIT_OF_MEASURE , A.QTY_OPTIMAL , A.AVG_CART_USAGE , B.LAST_OPRID , B.LAST_DTTM_UPDATE , B.CART_COUNT_STATUS , A.CART_REPLEN_OPT , A.TRANSFER_COST , A.PRICE_MARKUP_PCT , A.CHARGE_CODE , A.COUNT_REQUIRED , B.QTY_OPTION , A.SYNCID , B.SYNCDTTM , A.QTY_MAXIMUM FROM PS_CART_TEMPL_INV A , PS_CART_CT_INF_INV B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.INV_CART_ID = A.INV_CART_ID AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.COMPARTMENT = A.COMPARTMENT

# 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_BUIN_NONVW

2 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID

Prompt Table: CART_ATTRIB_INV

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

Y/N Table Edit

Default Value: N

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 CART_COUNT_STATUS Character(3) VARCHAR2(3) NOT NULL Par Location Count Status
1=Unprocessed
2=In Process
3=In Error
4=Complete
5=Interim Hold

Default Value: 1

15 CART_REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Par Replenishment Option
01=Stock
02=Stockless
03=Non-Stock
04=Not Replenished

Default Value: 01

16 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
17 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
18 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code

Prompt Table: CHARGE_CODE_INV

19 COUNT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Count Required

Y/N Table Edit

20 QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Qty Option
01=Count Qty
02=Request Qty

Default Value: 01

21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

Default Value: %Datetime

23 QTY_MAXIMUM Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Qty