RE_LSA_OPEX_DET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | AMND_NBR |
Number(3,0) | SMALLINT NOT NULL | Amendment Number |
| 3 | TERM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 4 | UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Flag
0=No Modification 1=Add 2=Change 3=Delete Default Value: 0 |
| 5 | PRORATA_SHARE_METH | Character(1) | VARCHAR2(1) NOT NULL |
Prorata Share Method
1=Fixed Percentage 2=Occupied Area 3=Occupied Area With Floor 4=Gross Leasable Area 5=None Default Value: 5 |
| 6 | ADMIN_FEE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Admin Fee Method
1=Accrual Method 2=Cash Method 3=Amount 4=None Default Value: 4 |
| 7 | ADMIN_FEE_PERC | Number(6,2) | DECIMAL(5,2) NOT NULL | Admin Fee Percentage |
| 8 | EXCL_BASE_YEAR | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Base Year
Y/N Table Edit Default Value: Y |
| 9 | BASE_YEAR | Number(4,0) | SMALLINT NOT NULL | Base Year |
| 10 | BASE_YEAR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Year Amount |
| 11 | BASE_YEAR_PERC | Number(6,2) | DECIMAL(5,2) NOT NULL | Base Year Percentage |
| 12 | OPEX_CAP_MIN | Character(1) | VARCHAR2(1) NOT NULL |
CAP/MIN
1=Apply 2=Alerts 3=None Default Value: 3 |
| 13 | EXP_GROSS_UP | Character(1) | VARCHAR2(1) NOT NULL |
Expense Gross Up
Y/N Table Edit Default Value: Y |
| 14 | GROSS_UP_PERC | Number(6,2) | DECIMAL(5,2) NOT NULL | Gross Up Percentage |
| 15 | GROSS_UP_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Gross Up Method
A=Method A B=Method B |
| 16 | NOTES_1000 | Long Character(1000) | VARCHAR2(1000) | Represents a field that allows free form text on the instrument definition panels. |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: RE_LS_WRK.CURRENCY_CD |