RE_OPEXAUDIT (SQL Table)	Index Back
Operating Expense Audit Level 0 Record for Operating Expense Audit / Reconciliation.

RE_OPEXAUDIT

(SQL Table)

Operating Expense Audit

Level 0 Record for Operating Expense Audit / Reconciliation.

# 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
Prompt Table: %EDITTABLE

3 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID

4 AGREEMENT_NUM Character(10) VARCHAR2(10) NOT NULL Agreement Number

5 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant
Prompt Table: %EDITTABLE

6 FROM_DATE Date(10) DATE NOT NULL From Date

7 TO_DATE Date(10) DATE NOT NULL To Date

8 OPEXAUDIT_STS Character(1) VARCHAR2(1) NOT NULL Operating Expense Audit Status
1=Pending
2=Processed
3=Pending Approval
Default Value: 1

9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

11 TOT_RENT_AREA Number(18,3) DECIMAL(17,3) NOT NULL Rentable Area

12 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table: UNITS_TBL

13 MAX_OPEX_INC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Op. Ex. Increase/Year

14 MAX_OPEX_INC_PCT Number(6,2) DECIMAL(5,2) NOT NULL Max Op. Ex. Increase/Year

15 PRORATE_PCT Number(16,6) DECIMAL(15,6) NOT NULL Prorate Percentage

16 BASE_YEAR Number(4,0) SMALLINT NOT NULL Base Year

17 BASE_YEAR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Year Amount

18 EXCL_BASE_YEAR Character(1) VARCHAR2(1) NOT NULL Exclude Base Year

19 OPEX_LIMIT Number(3,0) SMALLINT NOT NULL Operating Expenses Limit

20 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables

21 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
Prompt Table: RE_SHIPTO_VW

22 DST_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
Default Value: 4

23 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

24 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

25 AUDIT_STATUS Character(10) VARCHAR2(10) NOT NULL Operating Expense Audit Status Field
Prompt Table: RE_AUDIT_STATUS

26 RE_AUDIT_FREQ Character(2) VARCHAR2(2) NOT NULL Audit window frequency
01=Months
A1=Years
D1=Days
W1=Weeks
Default Value: 01

27 RECEIVED_DT Date(10) DATE Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).

28 DEADLINE_DT Date(10) DATE Deadline Date

29 AUDIT_WINDOW Number(3,0) SMALLINT NOT NULL Audit Window

#	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 Prompt Table: %EDITTABLE
3	TERM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Financial Term ID
4	AGREEMENT_NUM	Character(10)	VARCHAR2(10) NOT NULL	Agreement Number
5	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant Prompt Table: %EDITTABLE
6	FROM_DATE	Date(10)	DATE NOT NULL	From Date
7	TO_DATE	Date(10)	DATE NOT NULL	To Date
8	OPEXAUDIT_STS	Character(1)	VARCHAR2(1) NOT NULL	Operating Expense Audit Status 1=Pending 2=Processed 3=Pending Approval Default Value: 1
9	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
11	TOT_RENT_AREA	Number(18,3)	DECIMAL(17,3) NOT NULL	Rentable Area
12	SPACE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Space Unit of measure (Sq Feet or Sq Meters) Prompt Table: UNITS_TBL
13	MAX_OPEX_INC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Max Op. Ex. Increase/Year
14	MAX_OPEX_INC_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Max Op. Ex. Increase/Year
15	PRORATE_PCT	Number(16,6)	DECIMAL(15,6) NOT NULL	Prorate Percentage
16	BASE_YEAR	Number(4,0)	SMALLINT NOT NULL	Base Year
17	BASE_YEAR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Year Amount
18	EXCL_BASE_YEAR	Character(1)	VARCHAR2(1) NOT NULL	Exclude Base Year
19	OPEX_LIMIT	Number(3,0)	SMALLINT NOT NULL	Operating Expenses Limit
20	LEASE_OBLG	Character(1)	VARCHAR2(1) NOT NULL	Lease Obligation either Payables or Receivables Lease 1=Payables 2=Receivables
21	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: RE_SHIPTO_VW
22	DST_ALLOC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Distribution Allocation Method 1=Percentage 2=Amount 3=Area 4=None 5=Quantity Default Value: 4
23	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
24	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
25	AUDIT_STATUS	Character(10)	VARCHAR2(10) NOT NULL	Operating Expense Audit Status Field Prompt Table: RE_AUDIT_STATUS
26	RE_AUDIT_FREQ	Character(2)	VARCHAR2(2) NOT NULL	Audit window frequency 01=Months A1=Years D1=Days W1=Weeks Default Value: 01
27	RECEIVED_DT	Date(10)	DATE	Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
28	DEADLINE_DT	Date(10)	DATE	Deadline Date
29	AUDIT_WINDOW	Number(3,0)	SMALLINT NOT NULL	Audit Window