EXD_VND_INV_VW4 (SQL View)	Index Back
Supplier Inv View

EXD_VND_INV_VW4

(SQL View)

Supplier Inv View

SELECT DISTINCT A.ORG_SETID , A.ORG_CODE , A.ORG_TAX_LOC_CD FROM PS_EXD_VND_INV_LN A , PS_EXD_VND_INV_HDR B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.EXD_DOC_NBR_SER = A.EXD_DOC_NBR_SER AND B.EXD_INVOICE_NO = A.EXD_INVOICE_NO AND B.EXD_INVOICE_STATUS <> '3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.

3 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
3	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.