Accounting Visualizations in Texada Analytics

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

Type

Conceptual

Audience

All

Products

Texada Analytics, SRM

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