BUSINESS_UNIT_RELS_NBR1=Payables
2=Receivables
RE_LSNBR_PAY_VW(SQL View) |
Index Back |
|---|---|
RE Lease Number ViewRE Lease Number View |
| SELECT BUSINESS_UNIT , LS_NBR , LEASE_OBLG , LEASE_NAME FROM PS_RE_LS WHERE LEASE_OBLG = '1' AND LS_CLASSIFICATION = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RE |
Character(5) | VARCHAR2(5) NOT NULL | RE Business Unit |
| 2 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 3 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 4 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |