EXD_INV_ADJ_VW3 (SQL View)	Index Back
Excise Adj Inventory View Tbl

EXD_INV_ADJ_VW3

(SQL View)

Excise Adj Inventory View Tbl

SELECT DISTINCT SETID , ORG_CODE FROM PS_EXD_ADJ_HDR WHERE 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.

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