Mosaic - Transaction Details Export File - Field Definitions
- Sue Busker
The file formats are the same as the csv exports in the Transaction Search module in Mosaic.
Note: The Prompt1 through Prompt6 fields will only be present if the dataset includes at least one transaction with data in those fields.
TransactionId,LastName,FirstName,StudentId,CustomerAccount,TransactionDate,PosDeviceName,Cashier,Tender,ARAccountCode,ARAgencyName,Barcode,DCC,Description,SoldQuantity,ProductCost,SellingPrice,ExtendedSellingPrice,LineDiscount,TransDiscount,SalesEventDiscount,SalesTax,Prompt1,Prompt1Value,Prompt2,Prompt2Value,Prompt3,Prompt3Value,Prompt4,Prompt4Value,Prompt5,Prompt5Value,Prompt6,Prompt6Value
Field | Definition/Notes | Example |
|---|---|---|
Transactionid | The transaction number. If more than one SKU was purchased on a transaction, there will be a line for each with the same transaction number. | TR-1234567 |
LastName | The customer's last name. | Smith |
FirstName | The customer's first name. | Carol |
Studentid | The student ID as entered in the Customers module in the Student ID field on the customer's profile. | 123456789 |
CustomerAccount | The account number seen in the Customers module in the Account Number field on the customer's profile. | Cust-0000001 |
TrasactionDate | The date and time the transaction was completed. | 11/1/2023 10:52 |
POSDeviceName | The register on which the transaction was completed. | Reg 1 |
Cashier | The name of the user logged into the register when the transaction was completed. | Bill Johnson |
Tender | The name of the tender(s). If more than one tender was used on a transaction, they will be separated by a | symbol. | AR Charge |Cash |
ARAccountCode | The account code seen in the AR Account Management module in the Account Code field on the AR Account. If more than one account was used on a transaction, they will be separated by a | symbol. | FinAid | Pell |
ARAgencyName | The agency name seen in the AR Account Management module in the Agency Name field on the AR Account. If more than one account was used on a transaction, they will be separated by a | symbol. | Financial Aid | Pell Grant |
Barcode | The barcode associated with the SKU sold on the transaction. | 49000040869 |
DCC | The DCC associated with the SKU sold on the transaction. | 50-31-01 |
Description | The description or author/title of the Sku sold on the transaction. | Coca Cola Zero |
SoldQuantity | The quantity of the SKU sold on the transaction. | 2 |
ProductCost | The accounting cost of the SKU sold on the transaction. This value is not yet calculated in Mosaic so the field will be blank. |
|
SellingPrice | The retail selling price of the SKU at the time of the transaction. | 1.99 |
ExtendedSellingPrice | The selling price of the SKU sold on the transaction x quantity sold. | 3.98 |
LineDiscount | The amount of discount applied to a specific line item (SKU) on the transaction. This includes any discounts as a result of DCC rules on AR accounts. The sign for discount will be negative on a sale transaction and positive on a refund transaction. | -0.25 |
TransDiscount | The amount of discount applied as a transaction discount to the entire transaction. If there are multiple SKUs on the transaction, the amount will be distributed proportionally among the line items. The sign for discount will be negative on a sale transaction and positive on a refund transaction. | -5.00 |
SalesEventDiscount | The amount of discount as the result of a sale event. If there are multiple SKUs on the transaction, the amount will be distributed proportionally among the line items. The sign for discount will be negative on a sale transaction and positive on a refund transaction. | -5.00 |
SalesTax | The amount of sales tax collected on the sale of this SKU. | 0.15 |
Prompt1 | The label of Prompt 1 if set on the tender in POS Admin. | Dept |
Prompt1Value | The value entered for prompt 1 if entered on the transaction. | Psych |
Prompt2 | The label of Prompt 2 if set on the tender in POS Admin. | Dept Auth |
Prompt2Value | The value entered for prompt 2 if entered on the transaction. | A7485 |
Prompt3 | The label of Prompt 3 if set on the tender in POS Admin. | Sub Account Number |
Prompt3Value | The value entered for prompt 3 if entered on the transaction. | 9658-5 |
Prompt4 | The label of Prompt 4 if set on the tender in POS Admin. | Project Code |
Prompt4Value | The value entered for prompt 4 if entered on the transaction. | KW8567N |
Prompt5 | The label of Prompt 5 if set on the tender in POS Admin. | Reference ID |
Prompt5Value | The value entered for prompt 5 if entered on the transaction. | 974536321 |
Prompt6 | The label of Prompt 6 if set on the tender in POS Admin. | Fund |
Prompt6Value | The value entered for prompt 6 if entered on the transaction. | Grant award |