BUSINESS_UNIT_AMASSET_IDRE_LS_PASSET_VW(SQL View) |
Index Back |
|---|---|
SQL View Lessee Lease AssetSQL View Lessee Lease Asset |
| SELECT A.BUSINESS_UNIT_AM ,A.ASSET_ID ,A.AMND_NBR ,A.CURRENCY_CD ,A.RATE_MULT ,A.RATE_DIV ,A.RT_EFFDT FROM PS_RE_LSA_PPTY A , PS_RE_LS B WHERE A.LS_KEY = B.LS_KEY AND B.LEASE_OBLG = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | AMND_NBR | Number(3,0) | SMALLINT NOT NULL | Amendment Number |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 6 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 7 | RT_EFFDT | Date(10) | DATE | The effective date for a given item of market rate data. |