RE_LS_TRM

(SQL Table)
Index Back

Lease Recurring Terms

Contains Base Rent, Operating Expenses and Miscellaneous rent terms.

# 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 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID
3 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
1=Base Rent
2=Security Deposit
3=Straightline Accounting
4=Operating Expense
5=Percent Rent
6=Miscellaneous Rent
7=Manual Fee
8=Lease Obligation
9=Lease Interest Expense
A=Prior Period Lease Obligation
B=Prior Period Lease Interest
C=Rent Expense
D=Lease Incentive
4 EFFDT_FROM Date(10) DATE Effective Date From
5 EFFDT_TO Date(10) DATE Effective Date To
6 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

Prompt Table: RE_SCHEDULE

7 TRM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Recurring Term Amount
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant

Prompt Table: %EDITTABLE2

10 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: RE_SHIPTO_VW

11 STRLN_FLG Character(1) VARCHAR2(1) NOT NULL Straightline Accounting

Y/N Table Edit

Default Value: N

12 ESC_TYPE Character(1) VARCHAR2(1) NOT NULL Escalation Type
0=None
1=Index
2=Stepped

Default Value: 0

13 INDEX_BASIS_DATE Date(10) DATE Index Basis Date
14 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

Prompt Table: RE_IDX_DEFN

15 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.

Prompt Table: RE_MISC_INT_DVW

16 TRM_CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Lease Terms Calendar ID

Prompt Table: RE_CAL_DETL_VW

17 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

18 CATCH_UP_FLG Character(1) VARCHAR2(1) NOT NULL Catch Up Flag
N=No
Y=Yes

Default Value: N

19 CATCH_UP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Catch Up Amount
20 RE_ESC_FREQ Character(2) VARCHAR2(2) NOT NULL Escalation Frequency
01=Months
A1=Years
D1=Days
W1=Weeks

Default Value: 01

21 START_DATE Date(10) DATE Start Date for Gen Standing PO
22 RE_STEP_ESC_BY Character(1) VARCHAR2(1) NOT NULL Escalate By
A=Amount
P=Percentage

Default Value: A

23 ESC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Escalation Amount

Default Value: 0

24 RE_STEP_ESC_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Escalation Percentage

Default Value: 0

25 RE_ESC_DURATION Number(5,0) INTEGER NOT NULL Duration

Default Value: 1

26 RE_COST_PER_METRIC Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to capture cost per metric for term amount
27 RE_ESC_PER_METRIC Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to capture escalation per metric for a lease
28 RE_MTM_EXTENSION Character(1) VARCHAR2(1) NOT NULL MTM Extension Filed

Y/N Table Edit

Default Value: N

29 RE_MTM_DURATION Number(4,0) SMALLINT NOT NULL MTM Duration Field
30 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: RE_VNDR_LOC

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

Prompt Table: RE_CUST_ADDR_BI

32 EFFDT Date(10) DATE Effective Date

Default Value: %date

33 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
34 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
35 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
36 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
37 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
38 VAT_PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
39 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
40 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
41 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
42 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
43 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
44 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
45 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
46 VAT_NRCVR_ALL_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Non-Recoverable VAT
47 VAT_NRCVR_CHRG_CD Character(10) VARCHAR2(10) NOT NULL ProrateVAT Non-Recovery
48 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
49 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
50 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.
51 VAT_RPT_CNTRY_SRC Character(1) VARCHAR2(1) NOT NULL VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country
52 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
53 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
54 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
55 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
56 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
57 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State
58 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
59 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
60 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner
61 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner
62 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
63 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed
64 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
65 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
66 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
67 VAT_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
68 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag
69 VAT_NON_SUSP_FLG Character(1) VARCHAR2(1) NOT NULL Not subject to Suspension
70 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
71 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
72 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
73 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
74 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
75 VAT_RCRD_OUTPT_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
76 VAT_RCRD_INPT_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
77 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
78 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
79 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
80 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
81 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated
82 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
83 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
84 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
85 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
86 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
N=No
Y=Yes
87 LEASE_PYMT_TYPE Character(1) VARCHAR2(1) NOT NULL Lease Payment Type
A=Advance
O=One Time
R=Arrears

Default Value: R

88 PAYMENT_GROUP Number(3,0) SMALLINT NOT NULL Field For Payment Group

Default Value: 1

89 CAPITALIZE_SW Character(1) VARCHAR2(1) NOT NULL Capitalized

Y/N Table Edit

Default Value: N

90 INTERIM_RENT_SW Character(1) VARCHAR2(1) NOT NULL Interim Rent

Default Value: N

91 OPTION_CD Character(20) VARCHAR2(20) NOT NULL This is used as a Key in the RE_LSE_OPTION record
92 OPTION_TYPE Character(1) VARCHAR2(1) NOT NULL This Field is used to configure Option Type for lease options.
1=Other
2=Penalties
3=Renewal Option
4=Purchase Option
93 REASONABLE_CERTAIN Character(1) VARCHAR2(1) NOT NULL Reasonably Certain

Y/N Table Edit

94 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
95 FV_PCT Number(10,6) DECIMAL(9,6) NOT NULL Percentage of Fair Value
96 TERM_RENT_TYPE Character(2) VARCHAR2(2) NOT NULL List of Rent Type for Transaction Group
00=Residual Value
01=Base Rent
02=Operating Expense
03=Miscellaneous Rent
04=Initial Direct Cost
05=Prepaid Rent
06=Purchase Option
07=Renewal Option
08=Penality Option
09=Lease Incentives
10=Prepaid Rent
97 INT_WITH_AP_BI Character(1) VARCHAR2(1) NOT NULL Integrate with Accounts Payable

Y/N Table Edit

Default Value: Y

98 RENT_EXPENSE Number(27,3) DECIMAL(26,3) NOT NULL Rent Expense Field
99 PV_MLP Signed Number(28,3) DECIMAL(26,3) NOT NULL Present Value
100 REFERENCE_TEXT Character(30) VARCHAR2(30) NOT NULL Reference Text
101 DESCRLONG Long Character CLOB Long Description
102 AGREEMENT_NUM Character(10) VARCHAR2(10) NOT NULL Agreement Number
103 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
104 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
105 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
106 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.