Moso GLTransactions


				

Contents

Overview

Financial GL extract is used as a base by Moso_GLFinancialExport. This function is the same as GLTransactions except this function uses local time instead of UTC time in the date filter.

Basis

TxTransaction

Links To

  • TxInvoice Table
  • WorkUnit Table
  • PartyRole Table
  • TxPayment Table
  • TenderType Table
  • ClientAccount Table
  • TaxRate Table
  • MemberAgreementInvoiceRequestItem Table
  • Item Table
  • TaxRate Table
  • DiscountCode Table

Input Parameters

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

Filtered By

  • ClientAccount.IsExternal = null or 0
  • TxTransaction.Amount <> 0
  • TxTransaction.TxTypeId <> 100 ( Display Only)

Fields

Name Data Type Table/View Description
TxInvoiceId Int TxTransaction Invoice ID
InvBusinessUnitId Int TxTransactions Business Unit ID for the transaction
InvTargetDate DateTime TxTransactions Date/Time of the invoice
InvTargetDate_UTC DateTime TxTransactions UTC Date/Time of the transaction
InvTargetDate_ZoneFormat Char TxTransactions Time Zone where the transaction took place
TxTransactionId Int TxTransaction Transaction Group ID (Item group in transaction table includes item sale, discounts, taxes and payment transaction records)
Time DateTime TxTransactions Date/Time of the transaction
Time_ZoneFormat Char TxTransactions Time Zone where the transaction took place
Time_Utc DateTime TxTransactions UTC Date/Time of the transaction
BusinessUnitId Int TxTransactions Business Unit ID for the transaction
EndpointId Int WorkUnit ID of the Workstation where the transaction took place.
LIBusinessUnitID Int WorkUnit Logged in Business Unit
WSBusinessUnitID Int WorkUnit Workstation Business Unit
AuthenticatedUserId Int WorkUnit User ID of the Staff that was logged in when the transaction was created
POSShiftId Int WorkUnit Shift ID for the Point of Sale.
TxTypeId Int TxTransaction Transaction Type ID
    0 = Invalid
    1 = Sale
    2 = Tax
    3 = Discount
    4 = Payment
    5 = CashBack
    100 = DisplayOnly
SaleItemId Int TxTransaction Code for the item sold
Quantity Decimal TxTransaction Quantity sold
TaxGroupId Int TaxRate Tax Group ID when TxTransaction.TxTypeId = 2
DiscountCodeId Int TxTransaction Discount Code (Member Discount, Employee Discount, etc.)
Description Char TxTransaction Description of Activity
Amount Currency TxTransaction Amount of transaction
GLId Int MemberAgreementInvoiceRequestItem, Item, or TenderType based on TxTransaction.TxTypeID General Ledger ID
TxPaymentId Int TxTransaction Payment method (Cash, Credit Card, etc.)
TenderTypeId Int TxPayment Tender Report Group ID (Cash Tender, Non Cash Tender)
TenderReportGroupId Int TenderType Tender Report Group ID (Cash Tender, Non Cash Tender)
TenderInterfaceId Int TenderType Tender Interface ID (From TenderType table)
CreditCardTypeId Int TxPayment Credit Card Type ID (Visa, MasterCard, etc.)
PartyRoleId Int TxInvoice Role ID for the party making the transaction
PartyId Int PartyRole Party Id for the member
LinkTypeId Int TxTransaction Link Type ID
    0 = Invalid
    1 = Member Agreement Item
        2 = Invoice Request Item
        3 = Payment Request Item
        4 = Cancel Request Item
LinkId Int TxTransaction Link ID
MemberAgreementId Int MemberAgreementInvoiceRequest or MemberAgreementPaymentRequest based on value of TxTransaction.LinkTypeId Member Agreement Id that the transaction is linked to


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