| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_NONVW
|
| 2 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 3 |
LEASE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Lease ID
Prompt Table:
LEASE_ID_VW
|
| 4 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_FS
|
| 5 |
VENDOR_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Vendor Contact
|
| 6 |
LEASE_DT |
Date(10) |
DATE |
Lease Date
Default Value: %date
|
| 7 |
RESPONSIBILITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Responsibility
|
| 8 |
MRP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Minimum Rental Payment
|
| 9 |
EXECUTORY_COSTS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Executory Costs
|
| 10 |
MLP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Minimum Lease Payment
|
| 11 |
PV_MLP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Present Value
|
| 12 |
CAP_LEASE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Capitalized Lease Amount
|
| 13 |
GUAR_RESIDUAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Guaranteed Residual Value
|
| 14 |
ACTUAL_RESIDUAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Residual Value
|
| 15 |
TSFR_OWNERSHIP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Ownership
Y/N Table Edit
Default Value: N
|
| 16 |
RENEWAL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Bargain Renewal Option
Y/N Table Edit
Default Value: N
|
| 17 |
RENEWAL_PENALTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Renewal Payment Penalty
|
| 18 |
BPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Bargain Purchase Option
Y/N Table Edit
Default Value: N
|
| 19 |
BPO_PAYMENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bargain Purchase Option Paymnt
|
| 20 |
IMPLICIT_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Implicit Interest Rate
|
| 21 |
BORROW_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Incremental Borrowing Rate
|
| 22 |
ITC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Investment Tax Credit Amount
|
| 23 |
ITC_TAKEN_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
ITC Taken Year
|
| 24 |
LEASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Type
C=Capital
O=Operating
Default Value: C
|
| 25 |
LEASE_TERM |
Number(6,0) |
INTEGER NOT NULL |
Lease Term (Periods)
|
| 26 |
FMV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fair (Market) Value Amount
|
| 27 |
EST_LIFE |
Number(6,0) |
INTEGER NOT NULL |
Estimated Life
|
| 28 |
PYMNT_SCHED_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Schedule ID
Prompt Table:
LEASE_SCH_ID
|
| 29 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 30 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BU_BOOK_VW2.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 31 |
STEP_LEASE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Step Lease
Y/N Table Edit
|
| 32 |
ACCEPTANCE_DT |
Date(10) |
DATE |
Acceptance Date
|
| 33 |
LEASE_PYMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Payment Type
A=Advance
O=One Time
R=Arrears
|
| 34 |
EXPIRATION_DT |
Date(10) |
DATE |
Expiration Date
|
| 35 |
LEASE_COMMENCE_DT |
Date(10) |
DATE |
Commencement Date
|
| 36 |
LEASE_END_DT |
Date(10) |
DATE |
Lease End Date
|
| 37 |
LEASE_RECEIPT_DT |
Date(10) |
DATE |
Receipt Date
|
| 38 |
INTERIM_RENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Interim Rent (Monthly)
|
| 39 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 40 |
DAYS_TO_ALERT |
Number(3,0) |
SMALLINT NOT NULL |
Display Alert Days
|
| 41 |
FV_TEMPLATE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Fair Value Template ID
Prompt Table:
AM_FV_TEMPLATE
|
| 42 |
FV_GROUP_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
FV Group ID used to group related FV Assets
Prompt Table:
%EDITTABLE
|
| 43 |
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.
|
| 44 |
PLP_CURPD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Payments in Curr. Period
Y/N Table Edit
Default Value: N
|
| 45 |
PLP_ACCTG_DT |
Date(10) |
DATE |
Prior Lease Payment Acc Dt
|
| 46 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
IN_VNDR_LOC_VW
|
| 47 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 48 |
GUAR_RESIDUAL_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Guaranteed Residual Percent
|
| 49 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 50 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 51 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 52 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|