VENDOR_ATT_VW (SQL View)	Index Back
Supplier View Supplier View

VENDOR_ATT_VW

(SQL View)

Supplier View

SELECT A.SETID , A.VENDOR_ID , B.BUSINESS_UNIT , G.PYMNT_TERMS_CD , G.CURRENCY_CD FROM PS_VENDOR A , PS_BUS_UNIT_TBL_AP B , PS_BUS_UNIT_OPT_AP G , PS_SET_CNTRL_REC D , PS_SET_CNTRL_REC E WHERE D.SETCNTRLVALUE = B.BUSINESS_UNIT AND D.REC_GROUP_ID = 'FS_38' AND D.RECNAME = 'VENDOR' AND D.SETID = A.SETID AND B.BUSINESS_UNIT = E.SETCNTRLVALUE AND E.REC_GROUP_ID = 'AP_01' AND E.RECNAME = 'BUS_UNIT_OPT_AP' AND E.SETID = G.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	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.
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code