BUSINESS_UNITPrompt Table: SP_BU_RE_NONVW
LS_NBRDefault Value: NEXT
LEASE_OBLG1=Payables
2=Receivables
LS_KEYLS_CLASSIFICATIONC=Finance
O=Operating
Default Value: C
RECOGNITION_EXEMPTY/N Table Edit
Default Value: N
RE_LS_ADD(SQL View) |
Index Back |
|---|---|
Lease Maintenance Add SearchLease Maintenance Add Search |
| SELECT BUSINESS_UNIT , LS_NBR , LEASE_OBLG , LS_KEY , LS_CLASSIFICATION , RECOGNITION_EXEMPT , IS_PROPERTY_FLAG FROM PS_RE_LS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 2 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Default Value: NEXT |
| 3 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 4 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 5 | LS_CLASSIFICATION |
Character(1) | VARCHAR2(1) NOT NULL |
Field for Lease Classification
C=Finance O=Operating Default Value: C |
| 6 | RECOGNITION_EXEMPT |
Character(1) | VARCHAR2(1) NOT NULL |
Exempt from Recognition Flag
Y/N Table Edit Default Value: N |
| 7 | IS_PROPERTY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Field For Real Estate Property |