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

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