RE_OPADT_APP_VW

(SQL View)
 Index Back

Audit Op Exp Fluid Appr record

Record used in Audit Operating Expense Fluid Approval Page.

SELECT B.OPEXAUDIT_ID ,A.LS_KEY ,C.REVISION_NBR ,A.BUSINESS_UNIT ,A.LS_NBR ,B.CURRENCY_CD ,A.LEASE_NAME ,B.AGREEMENT_NUM ,B.OPEXAUDIT_STS ,B.PRINCIPAL_ID , CASE A.LEASE_OBLG WHEN '1' THEN ( SELECT L.PRINCIPAL_NAME1 FROM PS_RE_LANDLORD_VW L WHERE B.PRINCIPAL_ID = L.VENDOR_ID) WHEN '2' THEN ( SELECT T.PRINCIPAL_NAME1 FROM PS_RE_TENANT_VW T WHERE B.PRINCIPAL_ID = T.PRINCIPAL_ID) END AS PRINCIPAL_NAME1 ,B.FROM_DATE ,B.TO_DATE ,A.SPACE_UOM FROM PS_RE_LS A , PS_RE_OPEXAUDIT B , PS_RE_OPEXADT_REV C WHERE B.LS_KEY = A.LS_KEY AND B.OPEXAUDIT_ID = C.OPEXAUDIT_ID AND C.REVISION_NBR = ( SELECT MAX(C1.REVISION_NBR) FROM PS_RE_OPEXADT_REV C1 WHERE C.OPEXAUDIT_ID = C1.OPEXAUDIT_ID)

# 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)
2 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
3 REVISION_NBR Number(3,0) SMALLINT NOT NULL Sales Report Revision Number - Number (3)
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
8 AGREEMENT_NUM Character(10) VARCHAR2(10) NOT NULL Agreement Number
9 OPEXAUDIT_STS Character(1) VARCHAR2(1) NOT NULL Operating Expense Audit Status
1=Pending
2=Processed
3=Pending Approval
10 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant
11 PRINCIPAL_NAME1 Character(40) VARCHAR2(40) NOT NULL Used to hold Tenant/Landlord name when switching between VENDOR and CUSTOMER data
12 FROM_DATE Date(10) DATE From Date
13 TO_DATE Date(10) DATE To Date
14 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)