D1500290 - Sales Analysis Sq Footage Calculations
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szSalesAnalysisSumCode | SASC | char | OPT | INPUT |
This field is used to identify the manner in which Sales History information is grouped together and summarized when Sales Analysis
| ||||
szBuilding | 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
| ||||
mnTenant | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szUnitNo | 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
| ||||
mnDoingBusinessAsNumber | DBAN | MATH_NUMERIC | OPT | INPUT |
The address book number that identifies the name under which a tenant operates, if the tenant name is different from the tenant name on the
| ||||
szProductCodeRetail | PRDC | char | OPT | INPUT |
Product Codes are four-character, user-defined Codes which you use to categorize Tenants' Sales. The Codes are used for Sales
| ||||
szProjectNumber | 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
| ||||
szCompany | 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
| ||||
mnLeaseNumber | 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,
| ||||
szULICode | ULI | char | OPT | INPUT |
The Urban Land Industry (ULI) Code is an industry standard code used to identify the nature of a business or enterprise. The ULI is a real
| ||||
szReprtCdePropertyMg11 | RM11 | char | OPT | INPUT |
One of twenty user-defined Reporting Codes which exists within the Property Management system. These Codes, which are three
| ||||
szReprtCdePropertyMg12 | RM12 | char | OPT | INPUT |
One of twenty user-defined Reporting Codes which exists within the Property Management system. These Codes, which are three
| ||||
szReprtCdePropertyMg13 | RM13 | char | OPT | INPUT |
One of twenty user-defined Reporting Codes which exists within the Property Management system. These Codes, which are three
| ||||
szReprtCdePropertyMg14 | RM14 | char | OPT | INPUT |
One of twenty user-defined Reporting Codes which exists within the Property Management system. These Codes, which are three
| ||||
szReprtCdePropertyMg15 | RM15 | char | OPT | INPUT |
One of twenty user-defined Reporting Codes which exists within the Property Management system. These Codes, which are three
| ||||
szFloor | FLOR | char | OPT | INPUT |
The number that identifies the floor on which the unit exists. This is an alphanumeric user defined code (system 15, type FL), such as 1 for
| ||||
szReprtCdePropertyMg21 | RM21 | char | OPT | INPUT |
A user defined, three-character code that you can use to further define and categorize records such as property or buildings, floors, units,
| ||||
szReprtCdePropertyMg22 | RM22 | char | OPT | INPUT |
A user defined, three-character code that you can use to further define and categorize records such as property or buildings, floors, units,
| ||||
szReprtCdePropertyMg23 | RM23 | char | OPT | INPUT |
A user defined, three-character code that you can use to further define and categorize records such as property or buildings, floors, units,
| ||||
szReprtCdePropertyMg24 | RM24 | char | OPT | INPUT |
A user defined, three-character code that you can use to further define and categorize records such as property or buildings, floors, units,
| ||||
szReprtCdePropertyMg25 | RM25 | char | OPT | INPUT |
A user defined, three-character code that you can use to further define and categorize records such as property or buildings, floors, units,
| ||||
szTenantSalesCategory | ULI2 | char | OPT | INPUT |
An additional ULI (Urban Land Institute) Code for Tenant Sales categorization.
The ULI Code is an industry-standard code used to identify
| ||||
jdDateBeginningEffective | 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.
| ||||
jdBeginGenerationYear | 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.
| ||||
jdBeginGenerationQuarter | 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.
| ||||
jdBeginGenerationPeriod | 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.
| ||||
jdEndGenerationDate | 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
| ||||
mnChangeMonthlySales | MSCH | MATH_NUMERIC | OPT | OUTPUT |
The change in the gross amount of monthly sales for the current year vs the prior year. | ||||
mnThisYrMonthSaleSqFt | MFTY | MATH_NUMERIC | OPT | OUTPUT |
The amount of monthly sales per square foot for the current year. | ||||
mnLastYrMonthSaleSqFt | MFLY | MATH_NUMERIC | OPT | OUTPUT |
The amount of monthly sales per square foot for the prior year. | ||||
mnChgMonthlySalesSqFt | MFCH | MATH_NUMERIC | OPT | OUTPUT |
The change in the amount of monthly sales per square foot for the current year vs the prior year. | ||||
mnPercChgMonthSales | MFPC | MATH_NUMERIC | OPT | OUTPUT |
The percent change in the amount of monthly gross sales for the current year vs the prior year. | ||||
mnChangeQuarterlySales | QSCH | MATH_NUMERIC | OPT | OUTPUT |
The change in the gross amount of quarterly sales for the current year vs the prior year. | ||||
mnThisYrQtrSalesSqFt | QFTY | MATH_NUMERIC | OPT | OUTPUT |
The amount of quarterly sales per square foot for the current year. | ||||
mnLastYrQtrSalesSqFt | QFLY | MATH_NUMERIC | OPT | OUTPUT |
The amount of quarterly sales per square foot for the prior year. | ||||
mnChgQuarterlySalesSqft | QFCH | MATH_NUMERIC | OPT | OUTPUT |
The change in the amount of quarterly sales per square foot for the current year vs the prior year. | ||||
mnPercChgQtrSales | QFPC | MATH_NUMERIC | OPT | OUTPUT |
The percent change in the amount of quarterly gross sales for the current year vs the prior year. | ||||
mnChangeYTDSales | YSCH | MATH_NUMERIC | OPT | OUTPUT |
The change in the gross amount of year-to-date sales for the current year vs the prior year. | ||||
mnThisYrYTDSalesSqft | YFTY | MATH_NUMERIC | OPT | OUTPUT |
The amount of year-to-date sales per square foot for the current year. | ||||
mnLastYrYTDSalesSqft | YFLY | MATH_NUMERIC | OPT | OUTPUT |
The amount of year-to-date sales per square foot for the prior year. | ||||
mnChangeYTDSalesSqFt | YFCH | MATH_NUMERIC | OPT | OUTPUT |
The change in the amount of year-to-date sales per square foot for the current year vs the prior year. | ||||
mnPercChgYTDSales | YFPC | MATH_NUMERIC | OPT | OUTPUT |
The percent change in the amount of year-to-date gross sales for the current year vs the prior year. | ||||
mnSqFtThisYear | SFTY | MATH_NUMERIC | OPT | OUTPUT |
The applicable square footage for the current year. In the Tenant Sales Analysis system, this is the square footage upon which all per
| ||||
mnSqFtLastYear | SFLY | MATH_NUMERIC | OPT | OUTPUT |
The applicable square footage for the prior year. In the Tenant Sales Analysis system, this is calculated and stored for reference. | ||||
mnNetChgSqFt | NCSF | MATH_NUMERIC | OPT | OUTPUT |
This is the net difference in the square footage associated with a given sales analysis record from the first month of the prior year to the last
| ||||
mnAbsoluteChgSqFt | ACSF | MATH_NUMERIC | OPT | OUTPUT |
This is the sum total of the absolute values of all square-foot changes associated with a given sales analysis record during the periods
| ||||
mnNetChgSqFtQtd | NCSQ | MATH_NUMERIC | OPT | OUTPUT |
This amount is the difference between previous and current quarter square footage. | ||||
mnAbsoluteChgSqFtQtd | ACSQ | MATH_NUMERIC | OPT | OUTPUT |
This is the sum total of the absolute values of all square-foot changes associated with a given sales analysis record during the periods
| ||||
mnNetChgSqFtYtd | NCSY | MATH_NUMERIC | OPT | OUTPUT |
This amount is the difference between previous and current year square footage. | ||||
mnAbsoluteChgSqFtYtd | ACSY | MATH_NUMERIC | OPT | OUTPUT |
This is the sum total of the absolute values of all square-foot changes associated with a given sales analysis record during the periods
| ||||
cReturnStatus | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
mnThisYearMonthlySales | MSTY | MATH_NUMERIC | OPT | INPUT |
The gross amount of monthly sales for the current year. | ||||
mnThisYearQtrSales | QSTY | MATH_NUMERIC | OPT | INPUT |
The gross amount of quarterly sales for the current year. | ||||
mnYearToDateSales | YSTY | MATH_NUMERIC | OPT | INPUT |
The gross amount of year-to-date sales for the current year. | ||||
mnLastYearMonthlySales | MSLY | MATH_NUMERIC | OPT | INPUT |
The gross amount of monthly sales for the prior year. | ||||
mnLastYearQtrSales | QSLY | MATH_NUMERIC | OPT | INPUT |
The gross amount of quarterly sales for the prior year. | ||||
mnLastYearYTDSales | YSLY | MATH_NUMERIC | OPT | INPUT |
The gross amount of year-to-date sales for the prior year. | ||||
mnGenerationYear | YR | MATH_NUMERIC | OPT | NONE |
The calendar year for this calendar. | ||||
mnGenerationCentury | CTRY | MATH_NUMERIC | OPT | NONE |
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
| ||||
mnPriorGenerationYear | YR | MATH_NUMERIC | OPT | NONE |
The calendar year for this calendar. | ||||
mnPriorGenerationCentury | CTRY | MATH_NUMERIC | OPT | NONE |
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
| ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. |
None |
None |