Moso ExtractActivityTransactions


				

Contents

Overview

This is a listing of Activity usage within a given time period including GL Codes, Time and Location of the Activity, Member Information, and Service Provider’s Name.

Basis

ActivityTransactionEvent and ActivityTransactionNonEvent functions.

Links To

  • Activity Table
  • TxTransaction Table
  • TxInvoice Table
  • Item Table
  • AccessItem Table
  • ServiceItem Table
  • PartyRole Table
  • WorkUnitLog Table
  • rpt_ActivityHistory View
  • MemberAgreementInvoiceRequestItem Table
  • BusinessUnit Table

Input Parameters

  • Start Date
  • End Date
  • User Business Unit ID (default = 1)
  • Filter Business Unit ID (null = all business units)

Filtered By

  • Item.ItemTypeID = 2 when linking to AccessItem
  • Item.ItemTypeID = 3 when linking to ServiceItem
  • WorkUnitLog.OperationID = 1
  • Activity.UnitsAcquired > 0
  • ActivityTransactionEvent.TargetDate > Input parameter start date
  • ActivityTransactionNonEvent.TargetDate > Input parameter start date
  • ActivityTransactionEvent.TargetDate < Input parameter end date
  • ActivityTransactionNonEvent.TargetDate < Input parameter end date

The function contains a Union All of records from ActivityTransactionEvent and ActivityTransactionNonEvent. All fields listed below are related to ActivityTransactionNonEvent. These are repeated in the Union for ActivityTransactionEvent.

Fields

Name Data Type Table/View Description
ActivityTransactionID Int ActivityTransactionNonEvent Transaction ID
ActivityTypeId Int ActivityTransactionNonEvent ID for the type of activity
IsAccountingCredit Boolean ActivityTransactionNonEvent Is this a credit transaction (true/false)
TargetDate DateTime ActivityTransactionNonEvent Date Time of the Activity Action in the local time of the workstation where the action occurred
TargetDate_ZoneFormat Char ActivityTransactionNonEvent Time Zone for the Target Date (EST, PST)
TargetDate_UTC DateTime ActivityTransactionNonEvent Coordinated Universal Time of the Target Date
GroupId Int ActivityTransactionNonEvent Group ID number
RedemptionType Int ActivityTransactionNonEvent Use, No Show, Late Cancel
ReinstatementReasonId Int ActivityTransactionNonEvent Reason ID for why the activity was reinstated
ReinstatementName Char ActivityTransactionNonEvent Reinstatement Description
AppointmentId Int ActivityTransactionNonEvent Appointment ID number from scheduler if action was from scheduler
BusinessUnitId Int ActivityTransactionNonEvent Business Unit ID for the activity action
ActivityBusinessUnitName Char BusinessUnit Activity Business Unit Name
WorkUnitId Int WorkUnitLog Work unit ID for the activity action
SaleBusinessUnitId Int TxTransaction Business Unit ID for the sale
SaleBusinessUnitName Char BusinessUnit Sale Business Unit Name
SaleItemId Int TxTransaction Item ID for the sale
ActivityDescription Char Item Activity Description
SaleTxTransactionId Int TxTransaction Transaction ID for the sale
SaleTxGroupId Int TxTransaction Group ID for the sale
SaleTxInvoiceId Int TxTransaction Sale Invoice ID
SaleTransactionTime DateTime TxTransaction Date/Time of sale
SaleTransactionTime_ZoneFormat Char TxTransaction Time zone for the sale
SaleTransactionTime_UTC DateTime TxTransaction Date/Time of sale - Coordinated Universal Time
SaleWorkUnitId Int TxTransaction Work unit ID for the sale
SaleQuantity Decimal TxTransaction Quantity sold
SaleAmount Currency TxTransaction Amount of sale
MemberFirstName Char rpt_ActivityHistory Member's First Name
MemberLastName Char rpt_ActivityHistory Member's Last Name
MemberPartyRoleId Int Activity Party Role ID for the Member Owning of the Activity
MemberPartyId Int PartyRole Party ID for the Member Owning of the Activity
MemberRoleId Int PartyRole Role ID for the Member Owning of the Activity (Member ID)
ProviderPartyRoleId Int ActivityTransactionNonEvent Party Role ID of the Service Provider
ProviderPartyId Int PartyRole Party ID of the Provider
ProviderRoleId Int PartyRole Role ID (Employee ID) of the Service Provider
ActivityId Int Activity ID for the activity
ActivityStartDate Date Activity Start date for the activity
ActivityStartTime Time Activity Start time for the activity
ActivityStart_ZoneFormat Char Activity Time zone for the activity Start Date
ActivityStartDate_UTC Date Activity Start date for the activity - Coordinated Universal Time
ActivityStartTime_UTC Time Activity Start time for the activity - Coordinated Universal Time
ActivityEndDate Date Activity End date for the activity (Expiration Date)
ActivityEndTime Time Activity End date for the activity (Expiration Date)
ActivityEnd_ZoneFormat Char Activity End date time zone for the activity
ActivityEndDate_UTC Date Activity End date for the activity - Coordinated Universal Time
ActivityEndTime_UTC Time Activity End time for the activity - Coordinated Universal Time
ActivityUnits Int Activity Number of activity units
GLRevenueId Int MemberAgreementInvoiceRequestItem or Item depending on if the activity is recurring General Ledger ID for recurring billing
GLDeferredId Int Item General Ledger ID if deferred
GLRedemptionId Int AccessItem or Service Item depending on Item.ItemTypeID General Ledger ID if redeeming the activity
Amount Currency ActivityTransactionNonEvent Amount of the activity
DateSequence Target Date Sequence for multiple ActivityTransactions with the same ID
CountOfDates Number of date sequences for the ActivityTransactionID
RealizeTime DateTime ActivityTransactionNonEvent Date the activity was realized
RealizeTime_ZoneFormat Char ActivityTransactionNonEvent Time Zone for the realized activity
RealizeTime_UTC DateTime ActivityTransactionNonEvent Date the activity was realized - Coordinated Universal Time
TrainerFirstName Char rpt_ActivityHistory Trainer's First Name
TrainerLastName Char rpt_ActivityHistory Trainer's Last Name


MosoMRM Extracts

Data Feeds
Moso_CheckInExport
Moso_ExtractActivityTransactions
Moso_ExtractFinancial
Moso_ExtractPaymentByItem
Moso_GLTransactions
Moso_MemberAgreementExtract
Moso_MemberAgreementDetailExtract



System Configuration
The MosoMRM User Interface
The MosoMRM Glossary
Setting Up Your MosoMRM System
The MosoMRM Modules
Operation Security
Feature Security Moso myClub