UPG_RE_AET

(SQL Table)
Index Back

Real Estate Upgrade State Rec

State Record for Real Estate Upgrade

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 TERM_SCHED_ID Number(30,0) DECIMAL(30) NOT NULL Lease Term Schedule ID
4 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
5 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID
6 SCHED_DATE Date(10) DATE Schedule Date
7 END_DT Date(10) DATE End Date
8 LS_TXN_ID Number(25,0) DECIMAL(25) NOT NULL Lease Transaction ID
9 LS_TXN_SRC_ID Number(30,0) DECIMAL(30) NOT NULL Lease Transaction Source ID
10 TRM_CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Lease Terms Calendar ID
11 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 AGREEMENT_NUM Character(10) VARCHAR2(10) NOT NULL Agreement Number
14 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
15 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
16 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine