CHNG_RQST_ADDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor
5	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
7	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
9	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
10	CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Change Type C=Change D=Deleted H=Hold I=Inserted N=New O=Original R=Re-open X=Cancelled
11	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
12	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
13	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
14	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
15	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
16	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
17	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
18	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
19	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
20	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
21	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
22	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
23	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
24	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
25	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
26	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
27	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
28	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
29	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
30	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
31	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
32	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
33	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.