GM_EC_FA

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
8	FA_AGREEMENT_NBR	Character(11)	VARCHAR2(11) NOT NULL	Agreement Number
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	FA_AGREEMENT_DT	Date(10)	DATE	Agreement Date
12	FA_NEG_RT_STAT	Character(4)	VARCHAR2(4) NOT NULL	Rate Negotiation Status FINL=Final FIXD=Fixed PRED=Pre-determined PROV=Provisional
13	NEGOTIATION_AGENCY	Character(1)	VARCHAR2(1) NOT NULL	Negotiation Agency D=DHHS O=ONR T=Other
14	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50