VENDOR_LOC_X_VW

(SQL View)
 Index Back

Supplier SETID Loc View


SELECT DISTINCT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.PRICE_LOC , A.CURRENCY_CD , A.CUR_RT_TYPE , A.PRICE_SETID , A.PRICE_VENDOR , A.DISP_METHOD , A.PYMNT_TERMS_CD , A.FREIGHT_TERMS , A.PAY_TRM_BSE_DT_DFT , A.MATCH_OPT_FLG , A.MATCH_CNTRL_ID , A.MATCH_OPT , A.ERS_ACTION , A.ERS_FLAG , A.PHYSICAL_NATURE , A.VAT_SVC_PERFRM_FLG , A.BUYER_ID , A.SHIP_TYPE_ID , A.WTHD_CD , A.WTHD_SW , A.VNDR_UPN_FLG FROM PS_VENDOR_LOC A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_LOC B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID
2 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier
3 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location
4 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
7 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
8 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
9 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
10 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
11 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
12 PAY_TRM_BSE_DT_DFT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Accounting Date
C=Constructive Doc Receipt Date
D=Default from Higher Level
I=Invoice Date
R=Receipt Date
S=Ship Date
U=User Specified Date
13 MATCH_OPT_FLG Character(1) VARCHAR2(1) NOT NULL Newly added for R-JMACIA-NQ66A
D=Default from Higher Level
S=Specified
14 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

Prompt Table: MTCH_CNTRL_VW1

15 MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Requires Matching

Y/N Table Edit

Default Value: N

16 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes

Default Value: N

17 ERS_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Eval Rcpt Settlement

Y/N Table Edit

Default Value: N

18 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
19 VAT_SVC_PRFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where Service Performed Option
D=Default from a higher level
S=Specify at this level
20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
21 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
22 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
23 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099

Y/N Table Edit

Default Value: N

24 VNDR_UPN_FLG Character(1) VARCHAR2(1) NOT NULL Vendor Universal Product Number Ready Flag

Y/N Table Edit

Default Value: N