GM_EC_BUD_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	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
9	SUB_PROP_NBR	Character(15)	VARCHAR2(15) NOT NULL	SUB_PROP_NBR
10	BUDGET_ID	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_ID
11	BUDGET_PERIOD_GM	Number(3,0)	SMALLINT NOT NULL	BUDGET_PERIOD_GM
12	BUDGET_LN	Number(6,0)	INTEGER NOT NULL	BUDGET_LN
13	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
14	BUDGET_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_CATEGORY
15	SPONSOR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SPONSOR_AMT
16	FA_RATE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	FA_RATE_TYPE
17	RATE_EFFDT	Date(10)	DATE	Rate Effective Date
18	FA_RATE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	FA_RATE_PCT
19	FA_BASE_ID	Character(5)	VARCHAR2(5) NOT NULL	FA_BASE_ID