BUSINESS_UNITLEASE_OBLG1=Payables
2=Receivables
LEASE_NAMERE_LS_OBLG_NAME(SQL View) |
Index Back |
|---|---|
Lease View obligation by nameLease View by Business Unit and obligation to select name |
| SELECT BUSINESS_UNIT , LEASE_OBLG , LEASE_NAME FROM %Table(RE_LS) WHERE LEASE_STATUS <> '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 3 | LEASE_NAME |
Character(60) | VARCHAR2(60) NOT NULL | Lease Name |