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 |