LS_KEYAMND_NBRTERM_IDPRTA_BASIS_ID0=No Modification
1=Add
2=Change
3=Delete
Default Value: 0
Prompt Table: RE_PRTA_BASIS
RE_LSA_OPX_PRTA(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 | PRTA_BASIS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Prorata Basis ID |
| 5 | UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Flag
0=No Modification 1=Add 2=Change 3=Delete Default Value: 0 |
| 6 | PRORATA_BASIS | Character(10) | VARCHAR2(10) NOT NULL |
Prorata Basis
Prompt Table: RE_PRTA_BASIS |
| 7 | TOT_RENT_AREA | Number(18,3) | DECIMAL(17,3) NOT NULL | Rentable Area |
| 8 | TENANT_AREA | Number(18,3) | DECIMAL(17,3) NOT NULL | Tenant Area |
| 9 | FLOOR_PERC | Number(6,2) | DECIMAL(5,2) NOT NULL | Floor Percentage |