PV_REQ_LN_FLVW

(SQL View)
 Index Back

Requisition Line View


SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , ' ' , A.QTY_REQ , A.ITM_SETID , A.INV_ITEM_ID , A.DESCR254_MIXED , A.VENDOR_SETID , A.VENDOR_ID , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , A.BUYER_ID , A.CATEGORY_ID , A.UNIT_OF_MEASURE , A.MFG_ID , A.MFG_ITM_ID , A.PRICE_REQ , A.MERCHANDISE_AMT , A.INSPECT_CD , A.SYSTEM_SOURCE , A.CURRENCY_CD , A.INVENTORY_SRC_FLG , A.PCT_UNIT_PRC_TOL , A.PCT_UNIT_PRC_TOL_L , A.UNIT_PRC_TOL_L , A.UNIT_PRC_TOL , A.CURRENCY_CD_BASE , A.UNIT_MEASURE_STD , A.MERCH_AMT_BSE , A.QTY_REQ_STD , A.PRICE_REQ_BSE , A.UNIT_PRC_TOL_BSE , A.CONSOLIDATE_FLG , A.VNDR_LOC , A.GPO_ID , A.GPO_CNTRCT_NBR , A.PHYSICAL_NATURE , A.VAT_SVC_PERFRM_FLG , A.CC_USE_FLAG , A.CURR_STATUS , A.AMT_ONLY_FLG , A.ORIG_INV_ITEM_ID , A.DESCR254_MIXED2 , A.AUTO_SUB_FLG , A.PO_GROUP_ID , A.PRIMARY_UNIT , A.UNIT_ALLOC_QTY , A.UNIT_ALLOC_AMT , A.LN_TYPE , A.SOURCE_STATUS , %subrec(PUR_USR_LIN_SBR, A) , B.CATEGORY_CD FROM PS_REQ_LINE A , PS_ITM_CAT_TBL B WHERE A.CURR_STATUS <> 'X' AND A.CATEGORY_ID = B.CATEGORY_ID AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_GROUP WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND REC_GROUP_ID = 'FS_18') AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_ITM_CAT_TBL C WHERE B.SETID = C.SETID AND B.CATEGORY_TYPE = C.CATEGORY_TYPE AND B.CATEGORY_CD = C.CATEGORY_CD AND B.CATEGORY_ID = C.CATEGORY_ID AND C.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

Default Value: NEXT

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 PV_DOT Character(1) VARCHAR2(1) NOT NULL DOT
5 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

11 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
12 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
13 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

14 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_VW

15 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: UNITS_TBL

16 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

17 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
18 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
19 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
20 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes

Y/N Table Edit

Default Value: N

21 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 INVENTORY_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Source Flag
24 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
25 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
26 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
27 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
28 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
29 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
30 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
31 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
32 PRICE_REQ_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
33 UNIT_PRC_TOL_BSE Number(14,5) DECIMAL(13,5) NOT NULL Base Unit Price Tolerance
34 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes
35 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
36 GPO_ID Character(18) VARCHAR2(18) NOT NULL GPO ID
37 GPO_CNTRCT_NBR Character(25) VARCHAR2(25) NOT NULL GPO Contract Number
38 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
39 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
40 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card
41 CURR_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status
A=Approved
C=Closed
D=Denied
H=Hold
O=Open
P=Pending
X=Canceled
42 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes

Y/N Table Edit

43 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
44 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
45 AUTO_SUB_FLG Character(1) VARCHAR2(1) NOT NULL Auto Item Substitution
N=No
S=Substituted by Sourcing
Y=Yes
46 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

Prompt Table: PO_GROUP_VW

47 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes

Y/N Table Edit

Default Value: N

48 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
49 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt
50 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
CAT=Catalog Item
CUST=Custom Item
DC=Direct Connect Item
DCEX=Exchange Item
DCPO=Punchout Item
DCRT=Round Trip
DCTP=Transparent Punchout Item
DESR=Ad-hoc Item
EF=Express Form Item
OS=Order Sheet
SDF=Supplemental Data Form
SPRO=Service
SR=ePro Special Request Item
SRFC=Fixed Cost Service Item
SRTM=Time and Material Service Item
SRVC=Variable Cost Service Item
51 SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL AutoSource Status
A=Available
C=Sourcing Complete
E=Non-Price Error
I=Sourcing In Process
N=Non-Price Error
P=Pricing Error
52 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
53 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
54 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
55 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
56 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
57 CUSTOM_DATE_B Date(10) DATE Custom Date
58 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
59 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code