PV_MERCHVALXREF

(SQL Table)
Index Back

Supplier Value Cross Reference

8/30/07 - JK - Added Record Description.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 PV_PSFT_VALUE Character(50) VARCHAR2(50) NOT NULL PeopleSoft Value
3 PV_MERCH_VALUE Character(50) VARCHAR2(50) NOT NULL Merchant Value
4 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID

Prompt Table: PV_DC_XREF_VW

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

Prompt Table: SETID_TBL

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

Prompt Table: VNDR_VNDSET_VW

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

Prompt Table: VNDR_LOC_REQ_VW