RE_LSOPTIMIZE_F

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN
2	DEFAULTROW	Character(1)	VARCHAR2(1) NOT NULL	Default Row
3	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: RE_REGION_DMSN
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: RE_BUS_UNIT
5	SPACE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Space Unit of measure (Sq Feet or Sq Meters) Prompt Table: UNITS_TBL
6	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: RE_CAL_SRCH
7	PRIOR_ACCT_PERIOD	Number(3,0)	SMALLINT NOT NULL	Prior Periods
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_EFF_VW
9	TXN_GRP	Character(1)	VARCHAR2(1) NOT NULL	Transaction Group 1=Base Rent 2=Security Deposit 3=Straightline Accounting 4=Operating Expense 5=Percent Rent 6=Miscellaneous Rent 7=Manual Fee 8=Lease Obligation 9=Lease Interest Expense A=Prior Period Lease Obligation B=Prior Period Lease Interest C=Rent Expense D=Lease Incentive
10	TXN_GRP_LIST	Number(5,0)	INTEGER NOT NULL	Charge Group List