RE_OPEXAUDIT_AD(SQL View) |
Index Back |
|---|---|
Operating Expense Audit AddView for Adding Operating Expense Audit |
| SELECT A.OPEXAUDIT_ID , A.LS_KEY , LT.TERM_ID , L.BUSINESS_UNIT , L.LS_NBR , LT.AGREEMENT_NUM , L.LEASE_OBLG , LT.PRINCIPAL_ID FROM PS_RE_LS L , PS_RE_OPEXAUDIT A , PS_RE_LS_TRM LT WHERE L.LS_KEY = A.LS_KEY AND A.LS_KEY = LT.LS_KEY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPEXAUDIT_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Primary Key for Operating Expense Audit (Auto Generated Number)
Default Value: 0 |
| 2 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 3 | TERM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: RE_OPR_BU.BUSINESS_UNIT Prompt Table: SP_BU_RE_NONVW |
| 5 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_LS_AEH_VW |
| 6 | AGREEMENT_NUM |
Character(10) | VARCHAR2(10) NOT NULL |
Agreement Number
Prompt Table: RE_OPEX_AGMT_VW |
| 7 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 8 | PRINCIPAL_ID |
Character(15) | VARCHAR2(15) NOT NULL | Landlord ID |