| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 2 |
FILE_LEASE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
File Lease ID
|
| 3 |
INTFC_PROC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Interace Processing status
DON=Done
ERR=Error
INP=In Progress
NEW=New
Default Value: NEW
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RE_NONVW
|
| 5 |
LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
|
| 6 |
LS_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
|
| 7 |
LEASE_OBLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
|
| 8 |
LEASE_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Lease Name
|
| 9 |
LSE_TYPE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table:
RE_LS_TYPE_NAME
|
| 10 |
PRINCIPAL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table:
%EDITTABLE
|
| 11 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
RE_VNDR_LOC
|
| 12 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
RE_CUST_ADDR_BI
|
| 13 |
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
|
| 14 |
LEASE_START_DT |
Date(10) |
DATE |
Lease Start Date
|
| 15 |
LEASE_END_DT |
Date(10) |
DATE |
Lease Termination Date
|
| 16 |
LEASE_SIGNED_DT |
Date(10) |
DATE |
Lease Signed Date
|
| 17 |
LEASE_TERM |
Number(6,0) |
INTEGER NOT NULL |
Lease Term (Periods)
|
| 18 |
LS_ADMIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Lease Administrator
Prompt Table:
RE_INTFC_LA
|
| 19 |
PRTFL_MGR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Portfolio Manager
Prompt Table:
RE_INTFC_PM
|
| 20 |
SPACE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Lease Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
PRORATE_PCT |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Prorate Percentage
|
| 23 |
PRORATION_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Method to prorate partial periods
1=No proration
2=365 Days
3=360 Days
|
| 24 |
EXCL_BASE_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Base Year
Y/N Table Edit
Default Value: N
|
| 25 |
BASE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Base Year
|
| 26 |
BASE_YEAR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Year Amount
|
| 27 |
MAX_OPEX_INC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Max Op. Ex. Increase/Year
|
| 28 |
MAX_OPEX_INC_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Op. Ex. Increase/Year
|
| 29 |
MAX_RENT_INC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Max Lease Rent Escalation
|
| 30 |
MAX_RENT_INC_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Max Lease Rent Escalation
|
| 31 |
RE_OVERRIDE_STLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override
D=Default from Lease
O=Override
Default Value: D
|
| 32 |
RE_STLINE_ST_DT |
Date(10) |
DATE |
Straightline Start Date
|
| 33 |
RE_STLINE_END_DT |
Date(10) |
DATE |
Straightline End Date
|
| 34 |
REFERENCE_TEXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Text
|
| 35 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 36 |
LS_CLASSIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for Lease Classification
C=Finance
O=Operating
|
| 37 |
IMPLICIT_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Implicit Interest Rate
|
| 38 |
BORROW_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Incremental Borrowing Rate
|
| 39 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 40 |
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
|
| 41 |
ALLOCATION_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Basis
1=Price
2=Percent
3=Manual
Default Value: 3
|
| 42 |
PRORATE_LS_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognize Monthly Expense
Y/N Table Edit
|
| 43 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 44 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 45 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 46 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|