GM_EC_ADDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	RECORD_ID	Character(3)	VARCHAR2(3) NOT NULL	Record ID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
9	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
10	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
11	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
14	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
15	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
16	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
17	STATE	Character(6)	VARCHAR2(6) NOT NULL	State