LS_KEYTERM_IDPRTA_BASIS_IDPrompt Table: RE_PRTA_BASIS
RE_LS_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 | TERM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 3 | PRTA_BASIS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Prorata Basis ID |
| 4 | PRORATA_BASIS | Character(10) | VARCHAR2(10) NOT NULL |
Prorata Basis
Prompt Table: RE_PRTA_BASIS |
| 5 | TOT_RENT_AREA | Number(18,3) | DECIMAL(17,3) NOT NULL | Rentable Area |
| 6 | TENANT_AREA | Number(18,3) | DECIMAL(17,3) NOT NULL | Tenant Area |
| 7 | FLOOR_PERC | Number(6,2) | DECIMAL(5,2) NOT NULL | Floor Percentage |