PO_CHNG_ADDR (SQL Table)	Index Back
PO 1 Time Addr Change PO One Time Address change record.

PO_CHNG_ADDR

(SQL Table)

PO 1 Time Addr Change

PO One Time Address change record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
Default Value: 1

5 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number

6 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number

7 REASON_SEQ Number(5,0) INTEGER NOT NULL Reason Sequence

8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

13 CITY Character(30) VARCHAR2(30) NOT NULL City

14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

17 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

18 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

19 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

20 COUNTY Character(30) VARCHAR2(30) NOT NULL County

21 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

23 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

24 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

25 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix

26 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

27 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension

28 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number Default Value: 1
5	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
6	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
7	REASON_SEQ	Number(5,0)	INTEGER NOT NULL	Reason Sequence
8	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
9	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
10	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
11	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
12	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
13	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
14	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
15	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
16	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
17	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
18	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
19	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
20	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
21	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
22	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
23	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
24	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
25	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
26	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
27	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
28	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
29	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.
30	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.