LEAS_SCH_SM_VW(SQL View) |
Index Back |
|---|---|
LEASE_SCED_SUM_VW |
| SELECT Business_Unit, Asset_Id, sum(obligation_reduce) FROM PS_LEASE_SCHED GROUP BY Business_Unit, Asset_Id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | OBLIGATION_REDUCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Obligation Reduction |