PARLOC_ITEM_VW

(SQL View)
 Index Back

Inventory Cart Template

Inventory Cart Template

SELECT A.BUSINESS_UNIT , A.INV_CART_ID , B.INV_ITEM_ID , B.COMPARTMENT , D.DESCR60 , B.COUNT_ORDER , B.QTY_OPTIMAL , B.UNIT_OF_MEASURE , D.UNIT_MEASURE_STD , E.CONVERSION_RATE , B.AVG_CART_USAGE , B.DISTRIB_TYPE , B.TRANSFER_COST , B.PRICE_MARKUP_PCT , B.CHARGE_CODE , B.ACCOUNT , B.ALTACCT , B.DEPTID ,%subrec(cf16_an_sbr,a) ,%subrec(pc_cf1_n_sbr,a) , B.FOQ , B.QTY_MAXIMUM , B.COUNT_REQUIRED , B.CART_REPLEN_CTRL , B.CART_REPLEN_OPT , B.CONS_NON_STOCK , B.BCKORDR_CNCL_FLAG , B.MATERIAL_RECON_FLG , B.USG_TRCKNG_METHOD , B.CHARGE_MARKUP_PCNT , B.CHARGE_MARKUP_AMT FROM PS_CART_ATTRIB_INV A , PS_CART_TEMPL_INV B , PS_SET_CNTRL_REC C , PS_MASTER_ITEM_TBL D , PS_INV_ITEM_UOM E WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.INV_CART_ID = A.INV_CART_ID AND C.RECNAME = 'MASTER_ITEM_TBL' AND D.SETID = C.SETID AND D.INV_ITEM_ID = B.INV_ITEM_ID AND E.SETID = C.SETID AND E.INV_ITEM_ID = B.INV_ITEM_ID AND E.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE AND ((C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.CART_REPLEN_OPT IN ('01', '04')) OR (C.SETCNTRLVALUE = A.BUSINESS_UNIT_PO AND B.CART_REPLEN_OPT IN ('02','03')))

# 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

Prompt Table: %EDIT_CART_ITEM

4 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment
5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
6 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order
7 QTY_OPTIMAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Optimal Qty
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 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
11 AVG_CART_USAGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Usage
12 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE
Set Control Field: ORDER_BU

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

Prompt Table: %EDIT_CART_CHRG

16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

17 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

19 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

20 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

21 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

22 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

23 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

24 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

25 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

26 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

27 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

28 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

29 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

30 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

31 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

32 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

33 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

34 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

35 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

36 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

37 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

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

Y/N Table Edit

Default Value: N

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

Default Value: 01

42 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

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

Y/N Table Edit

Default Value: N

44 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

Default Value: N

45 MATERIAL_RECON_FLG Character(1) VARCHAR2(1) NOT NULL Material Reconciliation Flag

Y/N Table Edit

Default Value: N

46 USG_TRCKNG_METHOD Character(2) VARCHAR2(2) NOT NULL Usage Tracking Method
01=None
02=Billing
03=Costing

Default Value: 01

47 CHARGE_MARKUP_PCNT Signed Number(16,2) DECIMAL(14,2) NOT NULL Charge Markup %
48 CHARGE_MARKUP_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Charge Markup Amt