AREFCalculateDenominatorValue

AREF Budget Calculation Functions

Minor Business Rule

Object Name: N15L1091

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Data Structure

D1500470 - Calculate Denominator Value

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szShareFactorDenominatorID	SFDN	char	REQ	INPUT
A code that you set up in the Share Factor Denominator Revisions program (P150122) when you create a rule for denominator exclusions for the Expense Participation Calculation Generation program (R15110). For example, a share factor denominator rule might specify the following: For any anchor tenants over 16,000 square feet, deduct the over square footage from the denominator calculations in the Expense Participation Calculation Generation program.
cExpenseParticComputa	ECMP	char	REQ	INPUT
This code controls portions of Expense Participation charge calculations. B Use the square footage from the EP code for the building. P Use the square footage from the Property EP code. X Calculate average occupied SF in Building during period. Y Calculate average occupied SF in Property during period. N, U Use the Building square footage to calculate the share factor, but use the percentage of occupied Building square feet to gross up expenses. O, V Use the Property square footage to calculate the share factor, but use the percentage of occupied Property square feet to gross up expenses. (See glossary for item GPCT for definition of gross up.) L Group or Subgroup Limit record. Must be Suspended. S, A, M Special codes used during E.P. generation to designate Suspended, Already Billed, and Manual Bill records, respectively.
szCostCenterSubsequent	MCUS	char	OPT	NONE
Either a subsequent business unit or a project number. A subsequent business unit specifies where to charge costs (or revenues) when the original business unit has been closed or suspended. For example, the subsequent business unit can be used in corporate reorganizations when you close a business unit and direct all costs to the subsequent business unit. In this situation, you must enter journal entries to transfer existing balances. A project number is used to group business units within an overall business unit. For example, you can group jobs by project. In this case, the project business unit can also have accounts for tracking overhead costs that can be allocated to jobs.
szCostCenter	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
jdBeginDate	EFTB	JDEDATE	OPT	NONE
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdEndDate	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 generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnDenominatorValue	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnCapValue	CPVA	MATH_NUMERIC	OPT	NONE
A percentage value that you multiply by the average GLA for the EP period to determine the floor occupancy value.
mnCapAmount	CAPA	MATH_NUMERIC	OPT	NONE
The calculated value of the occupancy floor, which is based on the Average GLA and the Cap percentage.

Related Functions

None

Related Tables

None

AREFCalculateTenantExclusionVal

AREF Budget Calculation Functions

Minor Business Rule

Object Name: N15L1091

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Data Structure

D1500460 - Calculate Tenant Exclusion Value

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szEPTenantExclusionRule	TEXR	char	OPT	NONE
A code that you set up in Tenant Exclusion Revisions (P150120) when you create an exclusion rule for a specific type of tenant for the Expense Participation Calculation Generation program (R15110). For example, a tenant exclusion rule might specify the following: Deduct any amounts that are paid to bill code EXPA by an anchor tenant who leases more than 5,000 square feet.
cExpenseParticComputa	ECMP	char	OPT	NONE
This code controls portions of Expense Participation charge calculations. B Use the square footage from the EP code for the building. P Use the square footage from the Property EP code. X Calculate average occupied SF in Building during period. Y Calculate average occupied SF in Property during period. N, U Use the Building square footage to calculate the share factor, but use the percentage of occupied Building square feet to gross up expenses. O, V Use the Property square footage to calculate the share factor, but use the percentage of occupied Property square feet to gross up expenses. (See glossary for item GPCT for definition of gross up.) L Group or Subgroup Limit record. Must be Suspended. S, A, M Special codes used during E.P. generation to designate Suspended, Already Billed, and Manual Bill records, respectively.
szCostCenterSubsequent	MCUS	char	OPT	NONE
Either a subsequent business unit or a project number. A subsequent business unit specifies where to charge costs (or revenues) when the original business unit has been closed or suspended. For example, the subsequent business unit can be used in corporate reorganizations when you close a business unit and direct all costs to the subsequent business unit. In this situation, you must enter journal entries to transfer existing balances. A project number is used to group business units within an overall business unit. For example, you can group jobs by project. In this case, the project business unit can also have accounts for tracking overhead costs that can be allocated to jobs.
szCostCenter	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
cRetrievalType	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cReconcileBillings	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cReceivablePayableFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
jdBeginDate	EFTB	JDEDATE	OPT	NONE
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdEndDate	EFTB	JDEDATE	OPT	NONE
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
mnExclusionAmount	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
szCurrencyCodeFrom	CRCD	char	OPT	NONE
A code that identifies the currency of a transaction.

Related Functions

None

Related Tables

None

AREFEstimateLeaseDates

AREF Budget Calculation Functions

Minor Business Rule

Object Name: N15L1091

Parent DLL: CCRIN

Location: Client/Server

Language: NER

N15L1091 - AREF Estimate Lease Dates

This function identifies the active lease dates for a unit based on a specified period/fiscal year.  If a unit has an active real estate lease based on the
period/fiscal year, the real estate lease information is returned.  If the unit does not have an active real estate lease, an AREF lease is calculated and
returned.  The term of the AREF lease is determined by the active assumption term.  In some cases, an active real estate lease may begin or end in the middle of
a month.  When this happens, there is more than one active lease for a given period.  As a result, a unit can have up to 3 leases in a period for AREF.  For
each active lease in a period, the lease begin and end dates, type and number are returned.  In addition, this function also returns the active assumption
for the specified period.  In addition, this function also returns the active unit assumption, EP rule, and SO rule, and assumption action for a given
period.

In order for this business function to work, B15L0006 - AREF Period Date Cache must be called be called.  First, insert cache must be called and all
period dates must be loaded into cache.  Once the cached is done being used, the Terminate cache function should be called.  Computer ID is passed into this
business function to be used as a key for the cahe retrieval.

Notes:

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 might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
mnPeriodNumber	PN	MATH_NUMERIC	REQ	INPUT
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.
mnFiscalYear	FY	MATH_NUMERIC	REQ	INPUT
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
mnCentury	CTRY	MATH_NUMERIC	REQ	INPUT
The calendar century associated with the year. Enter is the first two digits of the year. For example, 19 indicates any year beginning with 19 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.
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 space, and so on.
jdBudgetStartDate	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. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
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 within the system. The system stores each "what-if" scenario according to the budget revision number you assign.
jdBudgetEndDate	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 generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
szActiveAssumption	ASP1	char	OPT	OUTPUT
A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use this code to reference the Assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header table (F15L102).
szActiveEPRule	EPRD	char	OPT	OUTPUT
A user defined 10-character code that specifies the expense participation rule. This code is a key to the AREF E.P. Rules Header table (F15L104) and the AREF E.P. Rules Detail table (F15L114).
szActiveSORule	SOID	char	OPT	OUTPUT
A user defined, 10-character field that specifies the sales overage rule. This code is a key to the AREF Sales Overage Rules Header table (F15L103) and the Sales Overage Detail table (F15L113).
szActiveAsmpAction	AACT	char	OPT	OUTPUT
A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule. The following assumption actions are defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend
jdLease1BeginDate	EFTB	JDEDATE	OPT	OUTPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdLease1EndDate	EFTE	JDEDATE	OPT	OUTPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnLease1Number	DOCO	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
cLease1Type	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
jdLease2BeginDate	EFTB	JDEDATE	OPT	OUTPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdLease2EndDate	EFTE	JDEDATE	OPT	OUTPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnLease2Number	DOCO	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
cLease2Type	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
jdLease3BeginDate	EFTB	JDEDATE	OPT	OUTPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdLease3EndDate	EFTE	JDEDATE	OPT	OUTPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnLease3Number	DOCO	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
cLease3Type	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szComputerID	CTID	char	REQ	INPUT

szCompany	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 Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
cAsmp1TermCalculation	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
cAddDowntimeToTerm	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 generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

•
A given period can have up to 3 leases.  The scenario only occurs if a real estate lease starts and ends within
the same period.  Information for all 3 leases will be returned based on when the lease is effective.  In most
cases, a period will only have 1 or 2 leases.  When this happens, all remaining lease information will be returned as
null.
• There is only one real estate lease loaded into AREF for a given unit.  If any of the three leases has a lease
type of L, the other leases will be of type A.

D15L109A:
Name AliasI/OReqDescription
Building MCUIYAREF Building to
calculate lease dates
Unit UNITIYAREF Unit to calculate
lease dates
Revision NumberRVNBIYRevision Number of
Budget Calculation
Period NumberPNIYPeriod Number to calculate
lease dates
Century CTRYIYCentury to calculate
lease dates
Fiscal Year FYIYFiscal Year to
calculate lease dates
Budget Begin DateEFTBIYStarting budget date
Budget End DateEFTEIYEnding budget date
Active AssumptionASP1O Unit
Assumption that is active based on assumption assignments and terms
Active EP RuleEPRDO EP Rule that
is active based on assumption assignments and terms
Active SO RuleSOIDO SO Rule that
is active based on assumption assignments and terms
Active Asmp ActionAACTO Unit
Assumption's action - (N)ew or (R)enew
Lease 1 Begin DateEFTBO Lease 1 begin
date
Lease 1 End DateEFTEO Lease 1 end
date
Lease 1 NumberDOCOO Lease 1
document number
Lease 1 TypeEV01O Lease 1 type - (L =
Real Estate Production Lease,  A = AREF Estimated Lease
Lease 2 Begin DateEFTBO Lease 2 begin
date
Lease 2 End DateEFTEO Lease 2 end
date
Lease 2 NumberDOCOO Lease 2
document number
Lease 2 TypeEV01O Lease 2 type - (L =
Real Estate Production Lease,  A = AREF Estimated Lease
Lease 3 Begin DateEFTBO Lease 3 begin
date
Lease 3 End DateEFTEO Lease 3 end
date
Lease 3 NumberDOCOO Lease 3
document number
Lease 3 TypeEV01O Lease 3 type - (L =
Real Estate Production Lease,  A = AREF Estimated Lease

Computer IDCTIDIYComputer ID for key -
Period Date Retrieval Cache Key

Data Structure

D15L109A - AREF Estimate Lease Dates

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
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

mnPeriodNumber PN MATH_NUMERIC REQ INPUT

A number indicating the current accounting period.  This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date.  The current period number
is used to determine posted before and posted after cut off warning messages.  It is also used as the default accounting period in the
preparation of financial reports.

mnFiscalYear FY MATH_NUMERIC REQ INPUT

A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period.
For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the
year 98 rather than 99.

mnCentury CTRY MATH_NUMERIC REQ INPUT

The calendar century associated with the year. Enter is the first two digits of the year. For example, 19 indicates any year beginning with 19
(1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.

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
space, and so on.

jdBudgetStartDate 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.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

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
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

jdBudgetEndDate 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
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

szActiveAssumption ASP1 char OPT OUTPUT

A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use
this code to reference the Assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header
table (F15L102).

szActiveEPRule EPRD char OPT OUTPUT

A user defined 10-character code that specifies the expense participation rule.  This code is a key to the AREF E.P. Rules Header table
(F15L104) and the AREF E.P. Rules Detail table (F15L114).

szActiveSORule SOID char OPT OUTPUT

A user defined, 10-character field that specifies the sales overage rule. This code is a key to the AREF Sales Overage Rules Header table
(F15L103) and the Sales Overage Detail table (F15L113).

szActiveAsmpAction AACT char OPT OUTPUT

A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule.  The following assumption actions are
defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend

jdLease1BeginDate EFTB JDEDATE OPT OUTPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdLease1EndDate EFTE JDEDATE OPT OUTPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnLease1Number DOCO MATH_NUMERIC OPT OUTPUT

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

cLease1Type EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

jdLease2BeginDate EFTB JDEDATE OPT OUTPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdLease2EndDate EFTE JDEDATE OPT OUTPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnLease2Number DOCO MATH_NUMERIC OPT OUTPUT

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

cLease2Type EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

jdLease3BeginDate EFTB JDEDATE OPT OUTPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdLease3EndDate EFTE JDEDATE OPT OUTPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnLease3Number DOCO MATH_NUMERIC OPT OUTPUT

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

cLease3Type EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

szComputerID CTID char REQ INPUT

szCompany 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
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

cAsmp1TermCalculation EV01 char OPT INPUT

An option that specifies the type of processing for an event.

cAddDowntimeToTerm 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
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

Related Functions

None

Related Tables

None

AREFGetAssumptionTerms
AREFGetAssumptionTerms

AREF Budget Calculation Functions

Minor Business Rule

Object Name: N15L1091

Parent DLL: CCRIN

Location: Client/Server

Language: NER

N15L1091 - AREF Get Assumption Terms

This function is designed to identify an active assumption rule for a specified period based on a given building / revision number / unit combination.
With the specified combination, the Unit Master is checked for  an assumption and rule assignments on the unit level.  A unit can have up to 3 assumption
rules for a given budget calculation.  If no unit assumptions are found, the default assumption and rules at the building level are assigned to the unit.  If
the building constant is not found, the default assumption and rules at the property level are assigned to the unit.  When no assumptions are assigned
(at any level), the system does not return any active assumptions.  After the assumptions have been determined, each assigned assumption's term is
calculated.  Assumption terms are based on the Budget Start Date.  Finally, this function also returns the active unit assumption number, EP rule number,
and SO rule number for a given period and fiscal year.

In order for this business function to work, B15L0006 - AREF Period Date Cache must be called be called.  First, insert cache must be called and all
period dates must be loaded into cache.  Once the cached is done being used, the Terminate cache function should be called.  Computer ID is passed into this
business function to be used as a key for the cahe retrieval.

D15L109B:

NameAliasI/OReqDescription

BuildingMCUI
Y AREF Building to calculate assumption
UnitUNITI
Y AREF Unit to calculate assumption
Revision NumberRVNB
I YRevision Number of Budget Calculation
Budget Begin DateEFTB
I YStarting budget date
Budget End DateEFTE
I YEnding budget date
Period NumberPN
I Period Number to determine Active Assumption
CenturyCTRYI
Century to determine Active Assumption
Fiscal YearFY
I Fiscal Year to determine Active Assumption
Asmp 1 UnitASP1
O 1st Unit Assumption that is active based on assumption assignments and terms
Asmp 1 ActionAACT
O 1st Unit Assumption's action - (N)ew or (R)enew
Asmp 1 Begin DateEFTB
O 1st Unit Assumptions Begin Date
Asmp 1 End DateEFTE
O 1st Unit Assumptions End Date
Asmp 1 DowntimeDOWT
O 1st Unit Assumptions Downtime
Asmp 1 EP RuleEPRD
O 1st Unit Expense Participation Rule
Asmp 1 SO RuleSOID
O 1st Unit Sales Overage Rule
Asmp 2ASP2O
2nd Unit Assumption that is active based on assumption assignments and terms
Asmp 2 ActionAACT
O 2nd Unit Assumption's action - (N)ew or (R)enew
Asmp 2 Begin DateEFTB
O 2nd Unit Assumptions Begin Date
Asmp 2 End DateEFTE
O 2nd Unit Assumptions End Date
Asmp 2 DowntimeDOWT
O 2nd Unit Assumptions Downtime
Asmp 2 EP RuleEPRE
O 2nd Unit Expense Participation Rule
Asmp 2 SO RuleSOIE
O 2nd Unit Sales Overage Rule
Asmp 3ASP3O
3rd Unit Assumption that is active based on assumption assignments and terms
Asmp 3 ActionAACT
O 3rd Unit Assumption's action - (N)ew or (R)enew
Asmp 3 Begin DateEFTB
O 3rd Unit Assumptions Begin Date
Asmp 3 End DateEFTE
O 3rd Unit Assumptions End Date
Asmp 3 DowntimeDOWT
O 3rd Unit Assumptions Downtime
Asmp 3 EP RuleEPRF
O 3rd Unit Expense Participation Rule
Asmp 3 SO RuleSOIF
O 3rd Unit Sales Overage Rule
Active Unit AsmpNBR0
O Unit Assumption that is active based on assumption assignments and terms
Active EP RuleNBR0
O EP Rule that is active based on assumption assignments and terms
Active SO RuleNBR0
O SO Rule that is active based on assumption assignments and terms

Computer IDCTIDIYComputer ID for key - Period Retrieval
Cache Key

Data Structure

D15L109B - AREF Get Assumption Terms

Parameter Name Data Item Data Type Req/Opt I/O/Both

szBuilding_MCU 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
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szUnit_UNIT 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
space, and so on.

mnRevisionNumber_RVNB 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
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

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.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

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
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnPeriodNumber_PN PN MATH_NUMERIC REQ INPUT

A number indicating the current accounting period.  This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date.  The current period number
is used to determine posted before and posted after cut off warning messages.  It is also used as the default accounting period in the
preparation of financial reports.

mnCentury_CTRY CTRY MATH_NUMERIC REQ INPUT

The calendar century associated with the year. Enter is the first two digits of the year. For example, 19 indicates any year beginning with 19
(1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.

mnFiscalYear_FY FY MATH_NUMERIC REQ INPUT

A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period.
For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the
year 98 rather than 99.

szAsmp1_ASP1 ASP1 char OPT OUTPUT

A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use
this code to reference the Assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header
table (F15L102).

szAsmp1Action_AACT AACT char OPT OUTPUT

A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule.  The following assumption actions are
defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend

jdAsmp1BeginDate_EFTB EFTB JDEDATE OPT OUTPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdAsmp1EndDate_EFTE EFTE JDEDATE OPT OUTPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnAsmp1DownTime_DOWT DOWT MATH_NUMERIC OPT OUTPUT

A number that specifies the duration of the anticipated vacancy for a unit.  Down time is expressed in months.

szAsmp1EPRule_EPRD EPRD char OPT OUTPUT

A user defined 10-character code that specifies the expense participation rule.  This code is a key to the AREF E.P. Rules Header table
(F15L104) and the AREF E.P. Rules Detail table (F15L114).

szAsmp1SORule_SOID SOID char OPT OUTPUT

A user defined, 10-character field that specifies the sales overage rule. This code is a key to the AREF Sales Overage Rules Header table
(F15L103) and the Sales Overage Detail table (F15L113).

szAsmp2_ASP2 ASP2 char OPT OUTPUT

A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use
this code to reference the Assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header
table (F15L102).

szAsmp2Action_AACT AACT char OPT OUTPUT

A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule.  The following assumption actions are
defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend

jdAsmp2BeginDate_EFTB EFTB JDEDATE OPT OUTPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdAsmp2EndDate_EFTE EFTE JDEDATE OPT OUTPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnAsmp2DownTime_DOWT DOWT MATH_NUMERIC OPT OUTPUT

A number that specifies the duration of the anticipated vacancy for a unit.  Down time is expressed in months.

szAsmp2EPRule_EPRE EPRE char OPT OUTPUT

A user defined 10-character code that specifies the expense participation rule. This code is a key to the AREF E.P. Rules Header table
(F15L104) and the AREF E.P. Rules Detail table (F15L114).

szAsmp2SORule_SOIE SOIE char OPT OUTPUT

A user defined, 10-character value that specifies a sales overage rule. This code is a key to the AREF Sales Overage Rule Header table
(F15L103) and the AREF Sales Overage Detail table (F15L113).

szAsmp3_ASP3 ASP3 char OPT OUTPUT

A code that identifies the assumption that the system uses to calculate the expected revenue and expenses associated with a unit. Use this
code to reference the assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header table
(F15L102).

szAsmp3Action_AACT AACT char OPT OUTPUT

A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule.  The following assumption actions are
defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend

jdAsmp3BeginDate_EFTB EFTB JDEDATE OPT OUTPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdAsmp3EndDate_EFTE EFTE JDEDATE OPT OUTPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnAsmp3DownTime_DOWT DOWT MATH_NUMERIC OPT OUTPUT

A number that specifies the duration of the anticipated vacancy for a unit.  Down time is expressed in months.

szAsmp3EPRule_EPRF EPRF char OPT OUTPUT

A user defined 10-character code that specifies the Expense Participation Rules ID.  This code is a key to the AREF E.P. Rules Header
table (F15L104), and the AREF E.P. Rules Detail table (F15L114).

szAsmp3SORule_SOIF SOIF char OPT OUTPUT

A user defined, 10-character value that specifies a sales overage rule.  This code is a key to the AREF Sales Overage Rule Header table
(F15L103) and the AREF Sales Overage Detail table (F15L113).

mnActiveUnitAsmp_NBR0 NBR0 MATH_NUMERIC OPT OUTPUT

Everest Parent Data Item

mnActiveEPRule_NBR0 NBR0 MATH_NUMERIC OPT OUTPUT

Everest Parent Data Item

mnActiveSORule_NBR0 NBR0 MATH_NUMERIC OPT OUTPUT

Everest Parent Data Item

szComputerID_CTID CTID char REQ INPUT

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
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szAsmp1BCRule_BCRI BCRI char OPT NONE

A user-defined, 10-character field that specifies the bill code rule.

szAsmp2BCRule_BCRJ BCRJ char OPT NONE

A user-defined, 10-character field that specifies the bill code rule.

szAsmp3BCRule_BCRK BCRK char OPT NONE

A user-defined, 10-character field that specifies the bill code rule.

mnActiveBCRule_NBR0 NBR0 MATH_NUMERIC OPT OUTPUT

Everest Parent Data Item

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
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

Related Functions

None

Related Tables

None

GrowAREFBudgetAmount
GrowAREFBudgetAmount

AREF Budget Calculation Functions

Minor Business Rule

Object Name: N15L1091

Parent DLL: CCRIN

Location: Client/Server

Language: NER

N15L1091 - AREF Grow Amount
This function is designed to grow a specified amount based on a growth pattern type and growth amounts.  When this business function is called, the amount
to grow is grown the specified number of years and then returned in the grown amount parameter.  When using a square foot growth pattern, the square
footage must also be passed to the function.

D15L109B:

Name AliasI/OReqDescription

Building MCUIYAREF Building to calculate growth
Revision Number RVNBIYRevision Number of Budget Calculation
Growth Pattern GRPAIYAREF Growth Pattern to retrieve
Unit UNITIYAREF Unit for property retrieval
Amount To Grow AN01IYAmount to be grown
Grown Amount AN01O
Returned amount
Number of Years to GrowNBR0I Number
of years to grow

Square Footage SUSAO Square Footage to use when using a square footage growth pattern

Data Structure

D15L1091 - AREF Budget Calculation - Grow Amount

Parameter Name Data Item Data Type Req/Opt I/O/Both

szBuilding MCU char OPT NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

mnRevisionNumber RVNB MATH_NUMERIC OPT NONE

A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

szGrowthPattern GRPA char OPT NONE

A number that specifies a defined growth pattern. Growth patterns are used to anticipate increasing amounts for lease revenue and
expenses based on several market factors, including the following: o Square feet o Flat amount o Percentage amount o Specified number of
years The Advanced Real Estate Forecasting account definition provides starting values that increase by the growth pattern assigned to the building.

mnAmountToGrow AN01 MATH_NUMERIC OPT NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

szUnitNo UNIT char OPT NONE

The number that identifies the actual space within a building that is or can be leased, such as an apartment, office, retail space, parking
space, and so on.

mnGrownAmount AN01 MATH_NUMERIC OPT NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnNumberofYearsToGrow NBR0 MATH_NUMERIC OPT NONE

Everest Parent Data Item

mnSqFootageArea SUSA MATH_NUMERIC OPT NONE

You can use this field to enter an override square footage amount to use when calculating Sales Overage Billings.  Square footage may be
assigned at the Property/Building, Floor, Unit or Lease level; it can be overridden by the Product Scales specifications for selected
Leases.  Square footage entered here relates to the combination of DBA, Product Code, Building, and Unit identified on the same line.  It does not
relate to the ULI Code or Reporting Codes.

Related Functions

None

Related Tables

None

d Lease
Lease 2 Begin DateEFTBO Lease 2 begin
date
Lease 2 End DateEFTEO Lease 2 end
date
Lease 2 NumberDOCOO Lease 2
document number
Lease 2 TypeEV01O Lease 2 type - (L =
Real Estate Production Lease,  A = AREF Estimated Lease
Lease 3 Begin DateEFTBO Lease 3 begin
date
Lease 3 End DateEFTEO Lease 3 end
date
Lease 3 NumberDOCOO Lease 3
document number
Lease 3 TypeEV01O Lease 3 type - (L =
Real Estate Production Lease,  A = AREF Estimated Lease

Computer IDCTIDIYComputer ID for key -
Period Date Retrieval Cache Key

Data Structure

D15L109A - AREF Estimate Lease Dates

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
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

mnPeriodNumber PN MATH_NUMERIC REQ INPUT

A number indicating the current accounting period.  This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date.  The current period number
is used to determine posted before and posted after cut off warning messages.  It is also used as the default accounting period in the
preparation of financial reports.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szBuilding_MCU	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 might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szUnit_UNIT	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 space, and so on.
mnRevisionNumber_RVNB	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 within the system. The system stores each "what-if" scenario according to the budget revision number you assign.
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. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
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 generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnPeriodNumber_PN	PN	MATH_NUMERIC	REQ	INPUT
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.
mnCentury_CTRY	CTRY	MATH_NUMERIC	REQ	INPUT
The calendar century associated with the year. Enter is the first two digits of the year. For example, 19 indicates any year beginning with 19 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.
mnFiscalYear_FY	FY	MATH_NUMERIC	REQ	INPUT
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
szAsmp1_ASP1	ASP1	char	OPT	OUTPUT
A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use this code to reference the Assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header table (F15L102).
szAsmp1Action_AACT	AACT	char	OPT	OUTPUT
A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule. The following assumption actions are defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend
jdAsmp1BeginDate_EFTB	EFTB	JDEDATE	OPT	OUTPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdAsmp1EndDate_EFTE	EFTE	JDEDATE	OPT	OUTPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnAsmp1DownTime_DOWT	DOWT	MATH_NUMERIC	OPT	OUTPUT
A number that specifies the duration of the anticipated vacancy for a unit. Down time is expressed in months.
szAsmp1EPRule_EPRD	EPRD	char	OPT	OUTPUT
A user defined 10-character code that specifies the expense participation rule. This code is a key to the AREF E.P. Rules Header table (F15L104) and the AREF E.P. Rules Detail table (F15L114).
szAsmp1SORule_SOID	SOID	char	OPT	OUTPUT
A user defined, 10-character field that specifies the sales overage rule. This code is a key to the AREF Sales Overage Rules Header table (F15L103) and the Sales Overage Detail table (F15L113).
szAsmp2_ASP2	ASP2	char	OPT	OUTPUT
A code that specifies the Assumption ID that the system uses to calculate the expected revenue and expenses associated with a unit. Use this code to reference the Assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header table (F15L102).
szAsmp2Action_AACT	AACT	char	OPT	OUTPUT
A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule. The following assumption actions are defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend
jdAsmp2BeginDate_EFTB	EFTB	JDEDATE	OPT	OUTPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdAsmp2EndDate_EFTE	EFTE	JDEDATE	OPT	OUTPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnAsmp2DownTime_DOWT	DOWT	MATH_NUMERIC	OPT	OUTPUT
A number that specifies the duration of the anticipated vacancy for a unit. Down time is expressed in months.
szAsmp2EPRule_EPRE	EPRE	char	OPT	OUTPUT
A user defined 10-character code that specifies the expense participation rule. This code is a key to the AREF E.P. Rules Header table (F15L104) and the AREF E.P. Rules Detail table (F15L114).
szAsmp2SORule_SOIE	SOIE	char	OPT	OUTPUT
A user defined, 10-character value that specifies a sales overage rule. This code is a key to the AREF Sales Overage Rule Header table (F15L103) and the AREF Sales Overage Detail table (F15L113).
szAsmp3_ASP3	ASP3	char	OPT	OUTPUT
A code that identifies the assumption that the system uses to calculate the expected revenue and expenses associated with a unit. Use this code to reference the assumption IDs that you have defined. This code is maintained in the AREF Unit Assumptions Master Header table (F15L102).
szAsmp3Action_AACT	AACT	char	OPT	OUTPUT
A user defined code (15L/UA) that specifies the type of action that applies to the assumption rule. The following assumption actions are defined by PeopleSoft, and should not be changed: N New R Renew B Market Blend
jdAsmp3BeginDate_EFTB	EFTB	JDEDATE	OPT	OUTPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdAsmp3EndDate_EFTE	EFTE	JDEDATE	OPT	OUTPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnAsmp3DownTime_DOWT	DOWT	MATH_NUMERIC	OPT	OUTPUT
A number that specifies the duration of the anticipated vacancy for a unit. Down time is expressed in months.
szAsmp3EPRule_EPRF	EPRF	char	OPT	OUTPUT
A user defined 10-character code that specifies the Expense Participation Rules ID. This code is a key to the AREF E.P. Rules Header table (F15L104), and the AREF E.P. Rules Detail table (F15L114).
szAsmp3SORule_SOIF	SOIF	char	OPT	OUTPUT
A user defined, 10-character value that specifies a sales overage rule. This code is a key to the AREF Sales Overage Rule Header table (F15L103) and the AREF Sales Overage Detail table (F15L113).
mnActiveUnitAsmp_NBR0	NBR0	MATH_NUMERIC	OPT	OUTPUT
Everest Parent Data Item
mnActiveEPRule_NBR0	NBR0	MATH_NUMERIC	OPT	OUTPUT
Everest Parent Data Item
mnActiveSORule_NBR0	NBR0	MATH_NUMERIC	OPT	OUTPUT
Everest Parent Data Item
szComputerID_CTID	CTID	char	REQ	INPUT

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 Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szAsmp1BCRule_BCRI	BCRI	char	OPT	NONE
A user-defined, 10-character field that specifies the bill code rule.
szAsmp2BCRule_BCRJ	BCRJ	char	OPT	NONE
A user-defined, 10-character field that specifies the bill code rule.
szAsmp3BCRule_BCRK	BCRK	char	OPT	NONE
A user-defined, 10-character field that specifies the bill code rule.
mnActiveBCRule_NBR0	NBR0	MATH_NUMERIC	OPT	OUTPUT
Everest Parent Data Item
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 generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.