OUAC_A6_U6_EC

#	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	OUAC_TRAN_ID	Character(2)	VARCHAR2(2) NOT NULL	OUAC Transaction Identifier
5	OUAC_REF_NBR	Character(11)	VARCHAR2(11) NOT NULL	OUAC Reference Number
6	OUAC_CNV_APPL_NBR	Character(1)	VARCHAR2(1) NOT NULL	OUAC Converted Application Nbr
7	EXPIRATION_DT	Date(10)	DATE	Expiration Date
8	OUAC_DIST_NBR	Character(2)	VARCHAR2(2) NOT NULL	OUAC Distribution Number
9	OUAC_APPL_NBR	Character(2)	VARCHAR2(2) NOT NULL	OUAC Application Number
10	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
11	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
12	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
13	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
14	OUAC_ADV_STD_PROG	Character(3)	VARCHAR2(3) NOT NULL	Advanced Standing Program Prompt Table: OUAC_PROG_TBL
15	OUAC_ADV_STD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Advance Standing Year
16	ZIP	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
17	OUAC_POS_92_95	Character(4)	VARCHAR2(4) NOT NULL	OUAC Transaction Pos. 92-95
18	DATE_LOADED	Date(10)	DATE	Date Loaded