ITM_VND_PRCE_VW

(SQL View)
 Index Back

Price/UOM Supplier Loc For Ite

Price/UOM Supplier Loc For Item with Supplier Priority

SELECT A.EIP_CTL_ID , A.SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.UNIT_OF_MEASURE , A.CURRENCY_CD , A.QTY_MIN , A.EFFDT , %subrec(ITM_VND_UMP_ESR, A) , A.AUDIT_ACTN , A.IN_PROCESS_FLG , B.ITM_VNDR_PRIORITY FROM PS_ITM_VND_UMPR_EC A , PS_ITM_VENDOR B , PS_MASTER_ITEM_TBL C WHERE B.SETID = A.SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.VENDOR_SETID = A.VENDOR_SETID AND B.VENDOR_ID = A.VENDOR_ID AND C.SETID = A.SETID AND C.INV_ITEM_ID = A.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

7 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

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

9 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity

Default Value: 1

10 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

11 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

12 PRICE_VNDR Number(16,5) DECIMAL(15,5) NOT NULL Vendor Price
13 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
14 EXT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance
15 USE_STD_TOLERANCES Character(1) VARCHAR2(1) NOT NULL Use Item Standard Tolerances

Y/N Table Edit

Default Value: N

16 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
17 PCT_EXT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance
18 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %
19 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
20 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
21 EXT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance - Under
22 PCT_EXT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance - Under
23 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
24 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
25 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
26 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority