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 walkthrough 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: dbo.bAPTD

AP Amount On Hold

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

Vista table.field: dbo.bAPTD

AP Amount Paid

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

Vista table.field: dbo.bAPTD

AP Balance

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

Vista table.field: dbo.bAPTD

AP Days Until Due

The number of days from current date until Due Date.

Vista table.field: dbo.bAPTD

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: dbo.bAPTD

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: dbo.bGLDT

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: dbo.bGLDT

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: dbo.bGLDT

GL Balance

The total General Ledger net balance. References ActualDate.

Vista table.field: dbo.bGLDT

AP Transactions

AP Reference

The AP Reference value.

Vista table.field: dbo.bAPTH

Invoice Description

The description for the AP Invoice.

Vista table.field: dbo.bAPTH

AP Vendor

AP Company

The AP Company number.

Vista table.field: dbo.bAPTH

AP Company - Name

The AP Company number concatenated with HQ Company name.

Vista table.field: dbo.bAPTH

dbo.bHQCO

AP Company Name

The AP Company name.

Vista table.field: dbo.bAPTH

Vendor

AP Vendor number.

Vista table.field: dbo.bAPVM

Vendor - Name

Vendor concatenated with Vendor Name.

Vista table.field: dbo.bAPTH

Vendor Group

The AP Vendor group.

Vista table.field: dbo.bAPVM

Vendor Name

The AP Vendor name.

Vista table.field: dbo.bAPVM

AR Customer

AR Company

The AR Company number.

Vista table.field: dbo.bARCO

dbo.bHQCO

AR Company - Name

AR Company concatenated with HQ Company Name.

Vista table.field:

AR Company Name

The AR Company name.

Vista table.field:

Customer

The AR Customer number.

Vista table.field: dbo.bARCM

Customer - Name

Customer concatenated with Customer Name.

Vista table.field: dbo.bARCM

Customer Group

The AR Customer group.

Vista table.field: dbo.bARCM

Customer Name

The AR Customer name.

Vista table.field: dbo.bARCM

AR Transactions

Customer Reference

The Customer Reference value.

Vista table.field: dbo.bARTH

Invoice

The invoice identifier.

Vista table.field: dbo.bARTH

Invoice Description

The description of the AR invoice.

Vista table.field: dbo.bARTH

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.

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: dbo.bGLAC

Active

Checks active flag Y/N for the GL Account.

Vista table.field: dbo.bGLAC

Description

The description for the GL Account.

Vista table.field: dbo.bGLAC

GL Account

The GL Account number.

Vista table.field: dbo.bGLAC

GL Company

The GL Company number.

Vista table.field: dbo.bGLCO

GL Company - Name

GL Company concatenated with GL Company Name.

Vista table.field: dbo.bGLCO

dbo.bHQCO

GL Company Name

The GL Company name.

Vista table.field: dbo.bGLCO

Normal Balance

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

Vista table.field: dbo.bGLAC

Part1

GL Account part 1.

Vista table.field: dbo.bGLAC

Part2

GL Account part 2.

Vista table.field: dbo.bGLAC

Part3

GL Account part 3.

Vista table.field: dbo.bGLAC