Mosaic - Transactions Export File - Field Definitions
The file formats are the same as the csv exports in the Transaction Search module in Mosaic.
Field | Definition/Notes | Example |
---|---|---|
Transactionid | The transaction number. If more than one tender was used 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 |
ARAgencyName | The agency name seen in the AR Account Management module in the Agency Name field on the AR Account. | Financial Aid |
ARAccountCode | The account code seen in the AR Account Management module in the Account Code field on the AR Account. | FinAid |
TransactionDate | 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, there will be a line for each with the same transaction number. | AR Charge |
TenderAmount | The dollar amount for the specific tender on the transaction. | 100.57 |
TransactionType | Types will be Sale, Refund, Pay In, or Pay Out | Sale |
TransactionTotal | The total dollar amount of the transaction. If there are multiple lines for the transaction, the same total will appear on all. | 250.39 |
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 |