1. Texada Knowledge Center
  2. Texada Analytics
  3. Data Available and Visualizations in Texada Analytics

Accounting Visualizations in Texada Analytics

Describes the data models available in Texada Analytics for accounting use.

Type

Conceptual

Audience

All

Products

Texada Analytics, SRM

In This Article

Business Context

Use Texada Analytics to analyze and monitor accounts payable and receivable data. Texada Analytics can help you identify any potential misreporting and areas of improvement.

Data Sources

The following points of data are all available in the Texada Analytics report.

Table

Column

Description

Type

Accounts Payable

Balance

 

Double

Accounts Payable

Currency

 

String

Accounts Payable

Detail Line

 

String

Accounts Payable

Division

 

String

Accounts Payable

Due Date

 

DateTime

Accounts Payable

Hold

 

String

Accounts Payable

Invoice Age

Today's date to Due Date in days

Int64

Accounts Payable

Invoice Amount by Age

Sum of Amount by Age Bucket

Double

Accounts Payable

Invoice Date

Last 3 years of data

DateTime

Accounts Payable

Invoice Num

 

String

Accounts Payable

Original Amount

 

Double

Accounts Payable

Sum of Amount

Sum of original amount

Double

Accounts Payable

Vendor Num

 

String

Accounts Payable

VendorInvoiceNum

Vendor Num + Invoice N

String

Accounts Payable Details

Detail

 

String

Accounts Payable Details

Division

 

String

Accounts Payable Details

GL Account Num

 

String

Accounts Payable Details

GLGL Transaction Num

 

String

Accounts Payable Details

Invoice Date

Last 3 years of data

DateTime

Accounts Payable Details

Invoice Num

 

String

Accounts Payable Details

Item Rec

 

String

Accounts Payable Details

PO Num

 

String

Accounts Payable Details

Qty Rec

 

Double

Accounts Payable Details

Seq

 

String

Accounts Payable Details

Vendor Num

 

String

Accounts Payable Details

VendorInvoiceNum

Vendor Num + Invoice N

String

Accounts Receivable

Amount Paid

 

Double

Accounts Receivable

Balance

 

Double

Accounts Receivable

Currency

 

String

Accounts Receivable

Customer Num

 

String

Accounts Receivable

Division

 

String

Accounts Receivable

Document Date

Last 3 years of data

DateTime

Accounts Receivable

Document Num

 

String

Accounts Receivable

Due Date

 

DateTime

Accounts Receivable

GLGL Transaction Num

 

String

Accounts Receivable

Invoice Age AR

Today's date to Due Date

Double

Accounts Receivable

Invoice Amount b Age AR

Sum of Amount AR by Age Bucket

Int64

Accounts Receivable

Original Amount

 

Double

Accounts Receivable

Pay Method

 

String

Accounts Receivable

PO Num

 

String

Accounts Receivable

Source

 

String

Accounts Receivable

Source Type

 

String

Accounts Receivable

Sum of Amount AR

Sum of Original Amount

Double

Accounts Receivable

Type

 

String

AgingBucket AP

Age

CALCULATED

Int64

AgingBucket AP

Bucket

CALCULATED

String

AgingBucket AR

Age

CALCULATED

Int64

AgingBucket AR

Bucket

CALCULATED

String

Calendar AP

Date

CALCULATED

DateTime

Calendar AP

Month

CALCULATED

String

Calendar AP

Month Number

CALCULATED

Int64

Calendar AP

Year

CALCULATED

Int64

Calendar AP

Year Month

CALCULATED

String

Calendar AP

Year Month Number

CALCULATED

Int64

Calendar AR

Date

CALCULATED

DateTime

Calendar AR

Month

CALCULATED

String

Calendar AR

Month Number

CALCULATED

Int64

Calendar AR

Year

CALCULATED

Int64

Calendar AR

Year Month

CALCULATED

String

Calendar AR

Year Month Number

CALCULATED

Int64

Credit Rating

Credit Rating Code

 

String

Credit Rating

Credit Rating Description

 

String

Customers Accounting

Alpha

 

String

Customers Accounting

City

 

String

Customers Accounting

Contact

 

String

Customers Accounting

Credit Rating

 

String

Customers Accounting

Currency

 

String

Customers Accounting

Customer Name

 

String

Customers Accounting

Customer Num

 

String

Customers Accounting

Finance

 

String

Customers Accounting

ON Account

 

String

Customers Accounting

Opened Date

 

DateTime

Customers Accounting

Province

 

String

Customers Accounting

Salesman

 

String

Customers Accounting

Type

 

String

Internal Use

Internal Use

INTERNAL USE

String

Vendors

Account Num

 

String

Vendors

City

 

String

Vendors

Currency

 

String

Vendors

GL Account Num

 

String

Vendors

Province

 

String

Vendors

Purchases

 

Double

Vendors

Vendor Alpha

 

String

Vendors

Vendor Name

 

String

Vendors

Vendor Num

 

String

 

Refresh Rate

Refresh begins at 12 a.m. EST.

Access and Security

Not applicable, no approval process

Out-of-the-Box Visualizations

The following visualizations are all available out-out-the-box.

Report Page

Visualization Title

Description

Filters on the Page

Accounts Payable

Original Amount by Year

Original payable amounts broken down by time, drill down to smaller time frames.

Time

Vendor Name

Accounts Payable

By Currency

Original payable amounts broken down by currency

Time

Vendor Name

Accounts Payable

Vendor Province

Map chart plotting original amount by vendor province

Time

Vendor Name

Accounts Payable

Original Amount by Vendor Name

Original payable amount broken down by vendor name,sorted in descending order

Time

Vendor Name

Accounts Payable

Tabular data

Table showing invoice number, invoice date, Vendor Num and Original Amount. 

Time

Vendor Name

Accounts Payable Breakdown

Invoice Amount by Age Bucket

Payable due by current, 1-30 days, 31-60 days, 61-90 days and 90+ days

Division 

Vendor Name

Accounts Payable Breakdown

Original Amount by Year

Original payable amounts broken down by time. Drill down to smaller time frames.

Division 

Vendor Name

Accounts Payable Breakdown





Tabular data

Tabular data showing invoice num, PO Num, Invoice Date, Due date, Division, Currency, Hold, Item Rec and Original Amount. 

Division 

Vendor Name

Accounts receivable

Original Amount by Year

Original receivable amounts broken down by time. Drill down to smaller time frames.

Time

Accounts receivable

By Currency

Original receivable amounts broken down by currency

Time

Accounts receivable

Customer Province

Map chart plotting original amount by customer province

Time

Accounts receivable

Original Amount by Customer Name

Original Amount by Customer Name

Time

Accounts receivable

Tabular Data

Tabular data with Document Num, Document Date, Customer Num and Original Amount

Time

Accounts Receivable Breakdown

Invoice Amount by Age AR 

Receivables by current, 1-30 days, 31-60 days, 61-90 days and 90+ days

Division
Customer Name

Accounts Receivable Breakdown

Original Amount by Year

Original receivable amounts broken down by time. Drill down to smaller time frames.

Division
Customer Name

Accounts Receivable Breakdown

Tabular Data

Tabular data with document number, customer num, customer name, currency, division, document date, PO Num, Source, Type and Original Amount. 

Division
Customer Name