CART_CT_INQ_VW

(SQL View)
 Index Back

Par Loc Count Inquiry View


SELECT BUSINESS_UNIT , INV_CART_ID , CART_COUNT_ID , COUNT_ORDER , INV_ITEM_ID , COMPARTMENT , CART_COUNT_QTY , UNIT_OF_MEASURE , QTY_OPTIMAL , DISTRIB_TYPE , TRANSFER_COST , PRICE_MARKUP_PCT , CHARGE_CODE , LAST_OPRID , LAST_DTTM_UPDATE , DEMAND_DATE , CART_COUNT_STATUS , PROCESS_INSTANCE , SUFFICIENT_STOCK , CART_REPLEN_OPT , TRANSFER_CALC_TYPE , BUSINESS_UNIT_PO , REQ_ID , REPLEN_STATUS FROM PS_CART_CT_INF_INV

# 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 CART_COUNT_ID Number(10,0) DECIMAL(10) NOT NULL Par Location Count ID
4 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

6 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment
7 CART_COUNT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Par Location Count Quantity
8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_STCK_UOM_VW

9 QTY_OPTIMAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Optimal Qty
10 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
11 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
12 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
13 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code

Prompt Table: CHARGE_CODE_INV

14 LAST_OPRID Character(30) VARCHAR2(30) NOT NULL Last Response Operator
15 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.
16 DEMAND_DATE Date(10) DATE Demand Date
17 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

Prompt Table: PSXLATITEM

18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
19 SUFFICIENT_STOCK Character(1) VARCHAR2(1) NOT NULL Sufficient Stock
N=NOT SUFFICIENT STOCK
Y=SUFFICIENT STOCK
20 CART_REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Par Replenishment Option
01=Stock
02=Stockless
03=Non-Stock
04=Not Replenished
21 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost

Default Value: 0

22 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
23 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
24 REPLEN_STATUS Character(1) VARCHAR2(1) NOT NULL Replenish Status
1=Ready
2=Error
3=In Process
4=Processed
5=Canceled