| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 3 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
PARENT_LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Parent Lease Key
Prompt Table:
RE_LS_NUMBER
|
| 6 |
LS_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
|
| 7 |
LSE_TYPE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table:
RE_LS_TYPE_NAME
|
| 8 |
LEASE_OBLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
|
| 9 |
LEASE_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Lease Name
|
| 10 |
LEASE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Status
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred
Default Value: 1
|
| 11 |
PRIOR_LEASE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Status
|
| 12 |
ORIG_LS_END_DT |
Date(10) |
DATE |
Original Lease End Date
|
| 13 |
SPACE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table:
UNITS_TBL
|
| 14 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
RE_REGION_NAME
|
| 15 |
REFERENCE_TEXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Text
|
| 16 |
SLS_REFERENCE_TEXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Sales Reference Text
|
| 17 |
LS_ADMIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Lease Administrator
Prompt Table:
RE_PTY_LA
|
| 18 |
PRTFL_MGR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Portfolio Manager
Prompt Table:
RE_PTY_PM
|
| 19 |
EXPIRATION_DATE |
Date(10) |
DATE |
Expiration Date
|
| 20 |
RE_MTM_EXTENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
MTM Extension Filed
Y/N Table Edit
Default Value: N
|
| 21 |
LS_CLASSIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for Lease Classification
C=Finance
O=Operating
|
| 22 |
IS_PROPERTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field For Real Estate Property
|
| 23 |
NEW_LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
To track the transfer in/out of a lease
|
| 24 |
RE_LS_XFER_DATE |
Date(10) |
DATE |
Date on which Lease was transferred
|
| 25 |
NEW_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
New Business Unit
|
| 26 |
NOTE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Lease Note ID
|
| 27 |
LEASE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Lease ID
|
| 28 |
ACCEPTANCE_DT |
Date(10) |
DATE |
Acceptance Date
|
| 29 |
LEASE_RECEIPT_DT |
Date(10) |
DATE |
Receipt Date
|
| 30 |
LEASE_REPORT_DT |
Date(10) |
DATE |
Lease Report Date
|
| 31 |
DAYS_TO_ALERT |
Number(3,0) |
SMALLINT NOT NULL |
Display Alert Days
|
| 32 |
CONVERT_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Stamp
|
| 33 |
CONVERT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator ID
|
| 34 |
COLLECTIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Collectibility Probable
Y/N Table Edit
Default Value: N
|
| 35 |
PRINCIPAL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table:
%EDITTABLE2
|
| 36 |
PRENT_PRNCPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table:
%EDITTABLE2
|
| 37 |
PRENT_SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Percent Rent Ship to Location
Prompt Table:
RE_SHIPTO_VW
|
| 38 |
SECDEP_PRNCPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table:
%EDITTABLE2
|
| 39 |
SECDEP_SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Security Deposit Ship to Location
Prompt Table:
RE_SHIPTO_VW
|
| 40 |
LEASE_SIGNED_DT |
Date(10) |
DATE |
Lease Signed Date
|
| 41 |
LEASE_START_DT |
Date(10) |
DATE |
Lease Start Date
|
| 42 |
LEASE_END_DT |
Date(10) |
DATE |
Lease Termination Date
|
| 43 |
LEASE_TERM |
Number(6,0) |
INTEGER NOT NULL |
Lease Term (Periods)
|
| 44 |
PRIM_PROPERTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Primary Property
Prompt Table:
RE_PRIMPPTY_SEL
|
| 45 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
RE_VNDR_LOC
|
| 46 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
RE_CUST_ADDR_BI
|
| 47 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Lease Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 48 |
SLS_EST_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Estimation Method
1=Prior Period
2=Past 6 Period Average
3=Same Period Last Year
|
| 49 |
SLS_ADJ_FACTOR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sales Adjustment Factor
Default Value: 1
|
| 50 |
MIN_FEE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Minimum Fee
|
| 51 |
MAX_FEE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Maximum Fee for Lease Category
|
| 52 |
TOT_PPTY_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Total Property Area
|
| 53 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DETL_VW
|
| 54 |
BI_CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Billing Calendar ID
Prompt Table:
RE_BILL_CAL_VW
|
| 55 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table:
SCHEDULE_TBL
|
| 56 |
TOT_USE_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Usable Area
|
| 57 |
TOT_RENT_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Rentable Area
|
| 58 |
PRORATE_PCT |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Prorate Percentage
|
| 59 |
MAX_OPEX_INC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Max Op. Ex. Increase/Year
|
| 60 |
MAX_OPEX_INC_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Op. Ex. Increase/Year
|
| 61 |
MAX_RENT_INC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Max Lease Rent Escalation
|
| 62 |
MAX_RENT_INC_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Lease Rent Escalation
|
| 63 |
EXCL_BASE_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Base Year
Y/N Table Edit
Default Value: N
|
| 64 |
BASE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Base Year
|
| 65 |
BASE_YEAR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Year Amount
|
| 66 |
PRORATION_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Method to prorate partial periods
1=No proration
2=365 Days
3=360 Days
|
| 67 |
IMPLICIT_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Implicit Interest Rate
|
| 68 |
BORROW_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Incremental Borrowing Rate
|
| 69 |
PARTIAL_PRORATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Year Proration For Percent Rent setup
Y/N Table Edit
|
| 70 |
SLS_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Compuation Methods for computing percent rent
1=Category Based
2=Weekly Sales
3=Each Period
4=Cumulative
5=Cumulative Pro Rata
6=Modified Cumulative
7=Lease Pro Rata
8=Cumulative BreakPoint Prorata
Default Value: 5
|
| 71 |
PCT_DST_ALLOC_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
Default Value: 4
|
| 72 |
SEC_DST_ALLOC_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
Default Value: 4
|
| 73 |
RE_OVERRIDE_STLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override
D=Default from Lease
O=Override
Default Value: D
|
| 74 |
RE_STLINE_ST_DT |
Date(10) |
DATE |
Straightline Start Date
|
| 75 |
RE_STLINE_END_DT |
Date(10) |
DATE |
Straightline End Date
|
| 76 |
SLS_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
RE_SLS_VNDR_LOC
|
| 77 |
SLS_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
RE_SLS_CUST_LOC
|
| 78 |
BPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Bargain Purchase Option
Y/N Table Edit
Default Value: N
|
| 79 |
BPO_PAYMENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bargain Purchase Option Paymnt
|
| 80 |
RENEWAL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Bargain Renewal Option
Y/N Table Edit
Default Value: N
|
| 81 |
RENEWAL_PENALTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Renewal Payment Penalty
|
| 82 |
TSFR_OWNERSHIP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Ownership
Y/N Table Edit
Default Value: N
|
| 83 |
MLP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Minimum Lease Payment
|
| 84 |
PV_MLP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Present Value
|
| 85 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %Date
|
| 86 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 87 |
ASSET_LIFE |
Number(6,0) |
INTEGER NOT NULL |
Field for Asset Life
|
| 88 |
TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Code
Prompt Table:
TRANS_CODE_VW
|
| 89 |
ROU_ASSET |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
ROU Asset
|
| 90 |
ALLOCATION_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Basis
1=Price
2=Percent
3=Manual
Default Value: 3
|
| 91 |
PV_BPO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Present Value of Purchase Option
|
| 92 |
PV_PENALITY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Present Value of Penality
|
| 93 |
PV_GRV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Present Value of Guranteed Residual Value
|
| 94 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 95 |
PRORATE_LS_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognize Monthly Expense
|
| 96 |
RECOGNITION_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from Recognition Flag
Default Value: N
|
| 97 |
CALC_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Rounding
Default Value: N
|
| 98 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: PRE
|
| 99 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 100 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 101 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 102 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|