LEASE_OBLG1=Payables
2=Receivables
LS_KEYRE_LS_NBR_OBLG(SQL View) |
Index Back |
|---|---|
Leases Numbers by Obligation |
| SELECT LEASE_OBLG ,LS_KEY ,LS_NBR ,LEASE_NAME ,BUSINESS_UNIT FROM PS_RE_AM_LS_VW WHERE LEASE_KIND = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 2 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 3 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 4 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |