GM_SCEN_EXP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
3	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
4	SUB_PROP_NBR	Character(15)	VARCHAR2(15) NOT NULL	SUB_PROP_NBR
5	BUDGET_ID	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_ID
6	BUDGET_PERIOD_GM	Number(3,0)	SMALLINT NOT NULL	BUDGET_PERIOD_GM
7	SEQ_NBR2	Number(15,0)	DECIMAL(15) NOT NULL	Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
8	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Prompt Table: GM_BUD_CAT_TYPE
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	QTY_INTEGER	Number(11,0)	DECIMAL(11) NOT NULL	Quantity Rounded to 0 Decimals Default Value: 1
11	COST_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Rate Default Value: 0
12	BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Billing Rate
13	ACTUAL_BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Bill Rate
14	ADJUSTED_FLAG_BILL	Character(1)	VARCHAR2(1) NOT NULL	Adjusted Flag H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Default Value: N
15	ADJUST_OPTION_BILL	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Option Bill Rate A=Flat Amount N=No Adjustment P=Percentage R=New Rate Default Value: N
16	ADJUSTMENT_BILLAMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Bill Amount
17	ADJUSTMENT_BILLPCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Adjustment Bill Percent
18	ADJUSTMENT_BILL_RT	Number(27,3)	DECIMAL(26,3) NOT NULL	Adjustment Bill Rate
19	BILL_AMT_EXP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
20	COST_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Expense
21	PM_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: PSA_OPPTY_HDR.CURRENCY_CD
23	REVIEW	Character(1)	VARCHAR2(1) NOT NULL	Review