DIST_VALIDATEH(SQL View) |
Index Back |
|---|---|
AM Validate Template-Lease Pay |
| select distinct 'Lease Payment', a.setid, a.category from ps_category_tbl a where lease_sw = 'Y' and not exists (Select 'x' from ps_dist_tmpl_tbl b, PS_INSTALLATION_AM c where a.setid = b.setid and a.category = b.category and b.trans_type = c.type_lease_payment) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description 20 |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Asset Category |