CART_ERR_INV_VW

(SQL View)
 Index Back

Inv Cart Repl Error View


SELECT BUSINESS_UNIT , INV_CART_ID , CART_COUNT_ID , INV_ITEM_ID , COMPARTMENT , COUNT_ORDER , CART_COUNT_QTY , UNIT_OF_MEASURE , QTY_OPTIMAL , DISTRIB_TYPE , TRANSFER_COST , PRICE_MARKUP_PCT , CHARGE_CODE , LAST_OPRID , LAST_DTTM_UPDATE , CART_COUNT_STATUS , CART_REPLEN_OPT , QTY_OPTION , SUFFICIENT_STOCK , FOQ , QTY_MAXIMUM , COUNT_REQUIRED , CART_REPLEN_CTRL , CONS_NON_STOCK , BCKORDR_CNCL_FLAG , TRANSFER_CALC_TYPE FROM PS_CART_CT_INF_INV WHERE CART_COUNT_STATUS = '3'

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDIT_CART_ITEM

5 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment
6 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order
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: %EDIT_CART_UOM

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

Prompt Table: CM_DISTR_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 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
17 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

18 QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Qty Option
01=Count Qty
02=Request Qty
19 SUFFICIENT_STOCK Character(1) VARCHAR2(1) NOT NULL Sufficient Stock
N=NOT SUFFICIENT STOCK
Y=SUFFICIENT STOCK

Y/N Table Edit

20 FOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Fixed Order Quantity
21 QTY_MAXIMUM Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Qty
22 COUNT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Count Required

Y/N Table Edit

23 CART_REPLEN_CTRL Character(2) VARCHAR2(2) NOT NULL Replenishment Control
01=Par
02=Fixed Order Qty
03=Min/Max

Default Value: 01

24 CONS_NON_STOCK Character(1) VARCHAR2(1) NOT NULL Consolidate Non-Stock

Y/N Table Edit

25 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
26 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