existing recurring billing records or AREF assumptions. If there are no recurring billing entries, AREF Assumption Rules will be used for the given
Building /Revision combination. The lease revenue is written to the F15L109 file. This function also assumes all unlocked lease revenue
records have been deleted before entry into this BSFN.
BuildingMCUIYAREF Building to calculate lease
revenue
UnitUNITIYAREF Unit to calculate lease revenue
Revision NumberRVNBIYRevision Number of Budget
Calculation
Unit Sq. FootageSUSAIYSqare Footage of Unit
(based on Area Type)
Lease NumberDOCOIYReal Estate module's Lease
Number; Zero means AREF estimated lease
Lease TypeEV01O Lease type - (L = Real Estate
Production Lease, A = AREF Estimated Lease
Lease Rev Begin DateEFTBIYStarting lease date
Lease Rev End DateEFTEIYEnding lease date
Budget Begin DateEFTBI Starting budget date
Budget End DateEFTEI Ending budget date
Retrieval Bill Code 1GLCI Bill Code used to
retrieve recurring billing data (Detail Assumption only)
Retrieval Bill Code 2GLCI Bill Code used to
retrieve recurring billing data (Detail Assumption only)
Retrieval Bill Code 3GLCI Bill Code used to
retrieve recurring billing data (Detail Assumption only)
Subledger TypeSBLI Type of Subledger for unit
number
Apply AREF RulesEV01I 0 = Only use Recurring
Billing - Bypass AREF Rules for all periods1 = Use AREF Rules when Recurring Billing records have not been processed during the period2 = Only use
AREF Rules - Bypass Recurring Billing for all periods3 = Use AREF Rules after all Recurring Billing records have ended during the lease term
Update Budget ResultsEV01I 0 = Does not
update the F15L109
GLG7OBJIYAAI range for determining revenue accounts
GLG11OBJIYAAI range for determining revenue accounts
GLG13OBJIYAAI range for determining revenue accounts
lease or specified period of lease
CompanyCOI Company of AREF Building
PropertyMCUSI Property Number of AREF Building
Computer IDCTIDIYComputer ID for cache
retrieval
Called from Detail AsmpEV01IYFlag to indicate if
called from Detail assumptions BSFN
Initialize and error check BF F15L109 Update
If called from detail assumptions is zero blank or null
Adjust lease revenue begin and end dates to budget begin and end dates
Initialize Lease Revenue to zero
If Lease Type is "L" (Real Estate Production Lease)
If any Retrieval Bill codes are not blank,
If Retrieval Bill Code 1 blank, set RBEnded(1) true
If Retrieval Bill Code 2 blank, set RBEnded(2) true
If Retrieval Bill Code 3 blank, set RBEnded(3) true
Set processing period/century/fiscal year to lease begin period/century/fiscal year
Get processing period begin and end dates - B15L0006 (NEW)
If return status failed, Insert dates into cache - B15L0006 (NEW)
While processing period/century/fiscal year less than or equal to lease end period/century/fiscal year
Initialize Do No Process, Recurring Billing Processed, and RB Select Number flags
If BF Lease Type is "L", set CheckRB to true. Else, set CheckRB to false
Set work billing date for recurring billing
If BF Apply AREF Rules not equal 2
Set RBCodes Found to true
Loop through each retrieval bill code based on RBSelect Number
After all 3 selects, set RBCodesFound to true
If fetch unsuccessful
If do not process false
Validate bill code/AAI
If valid bill code and account id
If record exists true
Add period amounts to lease revenue
If bill code billable for period/century/fiscal year
Set recurring billing processed to true
Set CheckRB to false
Assign RBEnded flags from BillingStatusEnded flag based on RBSelect Number
Fetch next F1502B record
Fetch active unit assumption information from F15L102
Check free rent for current period
Validate bill code/AAI
If valid bill code and account id
If record exists true
Add period amounts to lease revenue
Calculate Year in Budget for growing amounts
AREF Grow Amount - N15L1091
De-annualize grown lease revenue (by number of periods in fiscal year)
Calculate proration on recurring billing amount based on lease dates
If free rent month, check GLGs for debit to revenue account (multiply by -1)
Add billing amount to Lease Revenue
Get processing period begin and end dates - B15L0006 (NEW)
If return status failed, Insert dates into cache - B15L0006 (NEW)
D15L0003 - AREF Calculate Existing Lease Revenue
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szBuilding | MCU | char | REQ | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szUnitNo | UNIT | char | REQ | 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
| ||||
mnRevisionNumber | RVNB | MATH_NUMERIC | REQ | INPUT |
A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
| ||||
mnUnitSqFootage_SUSA | SUSA | MATH_NUMERIC | REQ | INPUT |
You can use this field to enter an override square footage amount to use when calculating Sales Overage Billings. Square footage may be
| ||||
mnLeaseNumber_DOCO | DOCO | MATH_NUMERIC | REQ | 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 | REQ | INPUT |
An option that specifies the type of processing for an event. | ||||
jdLeaseRevBeginDate_EFTB | EFTB | JDEDATE | REQ | INPUT |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
jdLeaseRevEndDate_EFTE | EFTE | JDEDATE | REQ | INPUT |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
jdBudgetBeginDate_EFTB | EFTB | JDEDATE | REQ | 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 | REQ | INPUT |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
szRetrievalBillCode1_GLC | GLC | char | OPT | INPUT |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
szRetrievalBillCode2_GLC | GLC | char | OPT | INPUT |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
szRetrievalBillCode3_GLC | GLC | char | OPT | INPUT |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
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
| ||||
cApplyAREFRules_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
cUpdateBudgetResults_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
szGLG6_OBJ | OBJ | char | REQ | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szGLG7_OBJ | OBJ | char | REQ | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szGLG11_OBJ | OBJ | char | REQ | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szGLG13_OBJ | OBJ | char | REQ | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
mnLeaseRevenue_AN01 | AN01 | MATH_NUMERIC | OPT | OUTPUT |
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
szCompany_CO | CO | char | REQ | 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
| ||||
szComputerID_CTID | CTID | char | REQ | INPUT |
cCalledFromDetailAsmp_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
cAsmp1TermCalculation | 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 |