N15L0004 - AREF Calculate Detail Assumption (New)
This function calculates a units detail assumptions. Each detail assumption is computed and posted to the Budget Results file based on a specified
calculation method. This function also assumes all unlocked lease revenue records have been deleted before entry into this BSFN.
Building MCUIYAREF Building to calculate lease revenue
Revision NumberRVNBIYRevision Number of Budget Calculation
Unit UNITIYAREF Unit to calculate lease revenue
Lease TypeEV01O Lease type - (L = Real Estate Production Lease, A = AREF Estimated Lease
Lease End DateEFTEO Lease 1 end date
PropertyMCUSI Property Number of AREF Building
Budget Begin DateEFTBIYStarting budget date
Budget End DateEFTEIYEnding budget date
Subledger TypeSBLI Type of Subledger for unit number
CM 1Rent X Detail Market Rate First Period of Lease
CM 2(Rent X (% Grown Year 1 Detail Market Rate)) + First Period of Lease
+
(Rent X (% Grown Year N Detail Market Rate)).
Where N = Number of Years of Lease
CM 3(Detail Market Rate X Unit Square Footage) X Years of LeaseFirst Period of Lease
CM 4(Rent X (Fxd Grown Year 1 Detail Market Rate)) + First Period of Lease
(Rent X (Fxd Grown Year 3 Detail Market Rate))
CM 5(Detail Market Rate X Unit Square Footage) / 12 Each Period of Lease
CM 6Detail Market Rate Each Year of Lease - 1st Period of lease then period 1
thereafter
CM 7 - %(Rent Year 1 X (% Growth Pattern Year 1)) + First Period of Lease
(Rent Year 3 X (% Growth Pattern Year 3)) +
'85 +
(Rent Year 15 X (% Growth Pattern Year 15))
CM 7 - FXFixed Amount Growth Pattern Year 1 + First Period of Lease
Fixed Amount Growth Pattern Year 3 +
'85+
Fixed Amount Growth Pattern Year 15
CM 7 - SFUnit Sq. Ft. X (SF Growth Pattern Year 1) + First Period of Lease
Unit Sq. Ft. X (SF Growth Pattern Year 3) +
'85+
Unit Sq. Ft. X (SF Growth Pattern Year 15)
OT - %Detail Market Rate X Grown % Growth Pattern Each Year of Lease - 1st Period of lease then period 1
thereafter
OT - FXDetail Market Rate + Grown Fixed Growth Pattern Each Year of Lease - 1st Period of lease then period 1
thereafter
OT - SFDetail Market Rate + Grown Square Foot Growth Pattern Each Year of Lease - 1st Period of lease then period 1
thereafter
Calculate period/century/fiscal year for lease and budget begin and end dates and 4 digit loop years
Set Lease Start and End within budget flags
Calculate lease term in years (# of months/12)
Select F15L112 Detail Assumptions
Fetch F15L112 record returning all information
While detail assumptions exist
If cache record not locked
If cache record not locked
Apply calculation method 1 calculation
Add assumption amount to existing F15L109 posting amount - first period of lease
If cache record not locked
If all 3 retrieval bill codes are blank
Loop through each year of lease and apply calculation method 2 calculation
Add assumption amount to existing F15L109 posting amount - first period of lease
If cache record not locked
Add assumption amount to existing F15L109 posting amount - first period of lease
If cache record not locked
If all 3 retrieval bill codes are blank
Loop through 3 year of lease and apply calculation method 4 calculation
Add assumption amount to existing F15L109 posting amount - first period of lease
If cache record not locked
Add assumption amount to existing F15L109 posting amount
If cache record not locked
Add assumption amount to existing F15L109 posting amount
If cache record not locked
If growth pattern type is fixed
Apply calculation method 7-Percent calculation
Increment grow year
D15L0004 - AREF Calculate Detail Assumption
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szBuilding_MCU | MCU | char | OPT | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnRevisionNumber_RVNB | RVNB | MATH_NUMERIC | OPT | INPUT |
A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
| ||||
szUnitNo_UNIT | UNIT | char | OPT | INPUT |
The number that identifies the actual space within a building that is or can be leased, such as an apartment, office, retail space, parking
| ||||
mnLeaseNumber_DOCO | DOCO | MATH_NUMERIC | OPT | INPUT |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
cLeaseType_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
jdLeaseBeginDate_EFTB | EFTB | JDEDATE | OPT | INPUT |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
jdLeaseEndDate_EFTE | EFTE | JDEDATE | OPT | INPUT |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
szCompany_CO | CO | char | OPT | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szProperty_MCUS | MCUS | char | OPT | INPUT |
Either a subsequent business unit or a project number.
A subsequent business unit specifies where to charge costs (or revenues) when the
| ||||
mnUnitSqFootage_SUSA | SUSA | MATH_NUMERIC | OPT | INPUT |
You can use this field to enter an override square footage amount to use when calculating Sales Overage Billings. Square footage may be
| ||||
jdBudgetBeginDate_EFTB | EFTB | JDEDATE | OPT | INPUT |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
jdBudgetEndDate_EFTE | EFTE | JDEDATE | OPT | INPUT |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
szAssumption_ASP1 | ASP1 | char | OPT | INPUT |
A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use
| ||||
szAsmpActioin_AACT | AACT | char | OPT | INPUT |
A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule. The following assumption actions are
| ||||
szComputerID_CTID | CTID | char | OPT | INPUT |
cSubledgerType_SBLT | SBLT | char | OPT | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
cAsmp1TermCalculation_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
cAddDowntime | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
jdOriginalBudgetEndDate | EFTE | JDEDATE | OPT | NONE |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
|
None |
None |