The Vista: Financials dataset provides a consolidated source of all data related to Accounts Payable, Accounts Receivable, and General Ledger accounts. See the video below for a visual walk through of its fields and measures.

Accounts Payable

AP Amount Billed

The total amount invoiced before subtracting amounts on hold and amounts paid. The sum of Amount where Status is either 1-Available to Pay, 2-On Hold, or 3-Paid. Includes taxes.

Vista table.field: bAPTD.Amount

AP Amount On Hold

The amount on hold (Retention, compliance, etc). The sum of Amount where Status is 2-On Hold.

Vista table.field: bAPTD.Amount

AP Amount Paid

The amount that has been paid. The sum of Amount where Status is 3-Paid.

Vista table.field: bAPTD.Amount

AP Balance

The net AP balance. The Amount invoiced less amounts on hold and amounts paid.

Vista table.field: bAPTD.AmountDue

AP Days Until Due

The number of days from current date until Due Date.

Vista table.field: bAPTH.DueDate - Current Date

AP Tax Amount

The sum of total tax amount on AP Amount Billed. Sum of TotTaxAmount where Status is 1-Available to Pay, 2-On Hold, or 3-Paid.

Vista table.field: bAPTD.TotTaxAmount

Accounts Receivable

AR Amount Invoiced

The total AR amount invoiced.

Vista table.field: bARTH.Invoiced

AR Amount Paid

The total AR amount paid.

Vista table.field: bARTH.Paid

AR Balance

The net AR Balance. The Amount billed less retention and amounts paid.

Vista table.field: bARTH.AmountDue

AR Days Until Due

The amount of days until Due Date. The number of days from the current date until the Due Date.

Vista table.field: bARTH.DueDate

AR Retainage

The total AR retainage.

Vista table.field: bARTH.Retainage

General Ledger

Balance Current Month

The General Ledger Balance for the current month to date. Use with GL Accounts.

Note: If there are no records for the current month, there will be no data for a given General Ledger account.

Vista table.field: bGLDT.Amount

Balance Current Quarter

The General Ledger for the current quarter to date. Use with GL Accounts.

Note: If there are no records for the current month, there will be no data for a given General Ledger account.

Vista table.field: bGLDT.Amount

Balance Current Year

The General Ledger Balance for the current year to date. Use with GL Accounts.

Note: If there are no records for the current month, there will be no data for a given General Ledger account.

Vista table.field: bGLDT.Amount

GL Balance

The total General Ledger net balance. References ActualDate.

Vista table.field: bGLDT.Amount

General Ledger Budget

Budget Amount

Sum of Budget Amount.

Vista table.field: bGLBD.BudgetAmt

Budget Difference

Calculates the difference between the total actual net activity and the total budgeted amount for the selected period or context.

Vista table.field: bGLBL.NetActivity - bGLBD.BudgetAmt

Net Activity

Sum of Net Activity.

Vista table.field: bGLBL.NetActivity

AP Transactions

AP Reference

The AP Reference value.

Vista table.field: bAPTH.APRef

Invoice Description

The description for the AP Invoice.

Vista table.field: bAPTH.Description

AP Vendor

AP Company

The AP Company number.

Vista table.field: bAPTH.APCo

AP Company - Name

The AP Company number concatenated with HQ Company name.

Vista table.field: bAPTH.APCo - bHQCO.Name

dbo.bHQCO

AP Company Name

The AP Company name.

Vista table.field: bHQCO.Name

Vendor

AP Vendor number.

Vista table.field: bAPTH.Vendor

Vendor - Name

Vendor concatenated with Vendor Name.

Vista table.field: bAPTH.Vendor - bAPTH.Name

Vendor Group

The AP Vendor group.

Vista table.field: bAPTH.VendorGroup

Vendor Name

The AP Vendor name.

Vista table.field: bAPTH.Name

AR Customer

AR Company

The AR Company number.

Vista table.field: bARCO.ARCo

AR Company - Name

AR Company concatenated with HQ Company Name.

Vista table.field: bARCO.ARCo - bHQCO.Name

AR Company Name

The AR Company name.

Vista table.field: bHQCO.Name

Customer

The AR Customer number.

Vista table.field: bARTH.Customer

Customer - Name

Customer concatenated with Customer Name.

Vista table.field: bARTH.Customer - bARTH.Name

Customer Group

The AR Customer group.

Vista table.field: bARTH.CustGroup

Customer Name

The AR Customer name.

Vista table.field: bARTH.Customer

AR Transactions

Customer Reference

The Customer Reference value.

Vista table.field: bARTH.CustRef

Invoice

The invoice identifier.

Vista table.field: bARTH.Invoice

Invoice Description

The description of the AR invoice.

Vista table.field: bARTH.Description

Calendar Date

Date

The calendar date of the transaction.

Note: Measures in the Accounts Receivable & Accounts Payable table are related on the Due Date and will refer to that when using visuals with these metrics in conjunction with this date field. This is also the case when creating custom measures.

Month

Includes all dates from the start of the month through the end of the month.

Quarter

Includes all dates from the start of the quarter through the end of the quarter.

Week Ending

The calendar date at the end of a specific workweek.

Year

The numerical value of the calendar year.

Year-Month

Numerical Year - Month (YYYY-MM).

Days Outstanding

Days Outstanding Group

The bucket of Number of Days Outstanding into which the data is categorized.

GL Accounts

Account Type

The GL Account type.

Vista table.field: bGLAC.AcctType

Active

Checks active flag Y/N for the GL Account.

Vista table.field: bGLAC.Active

Description

The description for the GL Account.

Vista table.field: bGLAC.Description

GL Account

The GL Account number.

Vista table.field: bGLAC.GLAcct

GL Account - Description

GL Account concatenated with GL Description.

Vista table.field: bGLAC.Acct - bGLAC.Description

GL Company

The GL Company number.

Vista table.field: bGLAC.GLCo

GL Company - Name

GL Company concatenated with GL Company Name.

Vista table.field: bGLAC.GLCo - bHQCO.Name

dbo.bHQCO

GL Company Name

The GL Company name.

Vista table.field: bHQCO.Name

Major Category

GL major category. Not all GL Accounts will contain values as it it's not a required field.

Vista table.field: vGLMajorCategory.MajorCategory

Major Category - Description

GL major category concatenated with description.

Vista table.field: vGLMajorCategory.MajorCategory - vGLMajorCategory.Description

Major Category Description

Description of the GL major category.

Vista table.field: vGLMajorCategory.Description

Minor Category

GL minor category. Not all GL Accounts will contain values as it it's not a required field.

Vista table.field: vGLMinorCategory.MinorCategory

Minor Category - Description

GL minor category concatenated with description.

Vista table.field: vGLMinorCategory.MinorCategory - vGLMinorCategory.Description

Minor Category Description

Description of the GL minor category.

Vista table.field: vGLMinorCategory.Description

Normal Balance

The GL Account normal balance (whether the account carries credit or debit).

Vista table.field: bGLAC.NormBal

Part1

GL Account part 1.

Vista table.field: bGLAC.Part1

Part2

GL Account part 2.

Vista table.field: bGLAC.Part2

Part3

GL Account part 3.

Vista table.field: bGLAC.Part3

GL Budget Codes

Budget Code

General ledger budget code.

Vista table.field: bGLBC.BudgetCode

Budget Code - Description

General ledger budget code concatenated with description.

Vista table.field: bGLBC.BudgetCode - bGLBC.Description

Budget Code Description

Description of general ledger budget code.

Vista table.field: bGLBC.Description

Notes

General ledger budget code open notes field.

Vista table.field: bGLBC.Notes