BI Tool View by Field (Financial)

 

When you want to use a view with a specific field, this table will show you which views within the Business Category > Billing View contain that specific field.

 

The Field column is organized alphabetically. Scroll through the table to find the field needed, and then look to the View column to see which Views contains that field.

 

Field

View

Business Category

1099Flag

BAT Process Data

Financial

Account

GL Order

Financial

AccountDescription

GL Order

Financial

AccountingPostDate

Account Transactions

Financial

AccountingPostDate

BAT Process Data

Financial

AcctDBName

Account Transactions

Financial

AcctDBName

BAT Process Data

Financial

AcctNote

Account Transactions

Financial

AcctNote

BAT Process Data

Financial

ActivityDate

AR Credit Collections Activity

Financial

ActivityType

AR Credit Collections Activity

Financial

ActualDelivery

Cash Receipts

Financial

ActualLoad

Cash Receipts

Financial

Alerts

AR Credit Collections

Financial

Alerts

AR Credit Collections Activity

Financial

Amount

Cash Receipts

Financial

AmountAfterSplits

Commission Statement Detail

Financial

ApplyAmount

Cash Receipts

Financial

ApplyToDocument

Account Transactions

Financial

ApplyToDocument

BAT Process Data

Financial

Authority

Account Transactions

Financial

Authority

BAT Process Data

Financial

AuthorityType

Commission Statement Detail

Financial

Batch

Cash Receipts

Financial

BatchCreateBy

Cash Receipts

Financial

BatchCreateOn

Cash Receipts

Financial

BatchNumber

Account Transactions

Financial

BatchNumber

BAT Process Data

Financial

BatchNumber

GL Order

Financial

BATProcessPriKey

BAT Process Data

Financial

BATSessionID

BAT Process Data

Financial

BillingARBranch

Revenue Branch Audit

Financial

BillingMinorItemID

Revenue Branch Audit

Financial

BillingMinWorkTicket

Revenue Branch Audit

Financial

BillingRevBranch

Revenue Branch Audit

Financial

Branch

AR Credit Collections

Financial

Branch

Cash Receipts

Financial

Branch

GL Order

Financial

Branch

Payment Management

Financial

BranchCode

GL Order

Financial

BranchID

Account Transactions

Financial

BranchID

BAT Process Data

Financial

CashClearingAccount

Payment Management

Financial

CheckNumber

Cash Receipts

Financial

Collector

AR Credit Collections

Financial

CommissionAmount

Commission Statement Detail

Financial

CommissionFactor

Commission Statement Detail

Financial

CommissionPerc

Commission Statement Detail

Financial

Commodity

Commission Statement Detail

Financial

Company

GL Order

Financial

Contact Name

AR Credit Collections Activity

Financial

ControlAmount

Payment Management

Financial

Created Date

Payment Management

Financial

CreatedBy

Payment Management

Financial

CreditAmount

GL Order

Financial

CurrentBalance

AR Credit Collections

Financial

CustId

Account Transactions

Financial

CustId

AR Credit Collections

Financial

CustId

AR Credit Collections Activity

Financial

Customer Name

Account Transactions

Financial

Customer Name

AR Credit Collections

Financial

Customer Name

AR Credit Collections Activity

Financial

Customer Name

BAT Process Data

Financial

Customer Name

Revenue Branch Audit

Financial

Customer_Vendor_Class

GL Order

Financial

Customer_Vendor_ID

GL Order

Financial

Customer_Vendor_Name

GL Order

Financial

CustomerClass

AR Credit Collections

Financial

CustomerClass

AR Credit Collections Activity

Financial

CustomerFirstName

Cash Receipts

Financial

CustomerLastName

Cash Receipts

Financial

CustomerNumber

Account Transactions

Financial

CustomerNumber

AR Credit Collections

Financial

CustomerNumber

AR Credit Collections Activity

Financial

CustomerNumber

BAT Process Data

Financial

CustomerNumber

Revenue Branch Audit

Financial

CustomerNumber2

BAT Process Data

Financial

DateCreated

Commission Statement Detail

Financial

DatePosted

AR Credit Collections

Financial

DatePosted

GL Order

Financial

DaysOld

AR Credit Collections

Financial

DaysOld

AR Credit Collections Activity

Financial

DebitAmount

GL Order

Financial

DepositDate

Payment Management

Financial

Description

Payment Management

Financial

DistributionReference

GL Order

Financial

DocumentAge

AR Credit Collections

Financial

DocumentAmount

Commission Statement Detail

Financial

DocumentDate

Account Transactions

Financial

DocumentDate

AR Credit Collections

Financial

DocumentDate

BAT Process Data

Financial

DocumentDate

Commission Statement Detail

Financial

DocumentDate

GL Order

Financial

DocumentDescription

AR Credit Collections

Financial

DocumentNumber

Account Transactions

Financial

DocumentNumber

AR Credit Collections

Financial

DocumentNumber

BAT Process Data

Financial

DocumentNumber

Commission Statement Detail

Financial

DocumentNumber

GL Order

Financial

DocumentNumber

Revenue Branch Audit

Financial

DocumentType

AR Credit Collections

Financial

DocumentType

Commission Statement Detail

Financial

DocumentType

GL Order

Financial

DownloadBy

Payment Management

Financial

DownloadDate

Payment Management

Financial

Driver

Account Transactions

Financial

Driver

BAT Process Data

Financial

DueDate

Commission Statement Detail

Financial

Finalized

Commission Statement Detail

Financial

FromAddress

AR Credit Collections

Financial

GBLNumber

AR Credit Collections

Financial

GLDate

GL Order

Financial

GLNumber

Account Transactions

Financial

GLNumber

BAT Process Data

Financial

GLNumber

Revenue Branch Audit

Financial

GrossLinehaul

Account Transactions

Financial

HauledWeight

Commission Statement Detail

Financial

ICPriKey

Account Transactions

Financial

ICPriKey

BAT Process Data

Financial

IntercompanyTransaction

Revenue Branch Audit

Financial

Invoice Number

Account Transactions

Financial

Invoice Number

AR Credit Collections

Financial

Invoice Number

AR Credit Collections Activity

Financial

Invoice Number

BAT Process Data

Financial

Invoice Number

Cash Receipts

Financial

InvoiceAmount

Commission Statement Detail

Financial

InvoiceCreatedBy

AR Credit Collections

Financial

InvoiceCreatedDate

AR Credit Collections

Financial

InvoiceDate

Account Transactions

Financial

InvoiceDate

AR Credit Collections

Financial

InvoiceDate

AR Credit Collections Activity

Financial

InvoiceDate

BAT Process Data

Financial

InvoicePayment

Account Transactions

Financial

InvoicePayment

BAT Process Data

Financial

InvoicePaymentAccount

Account Transactions

Financial

InvoicePaymentAccount

BAT Process Data

Financial

InvoiceTotal

AR Credit Collections

Financial

InvoiceTotal

AR Credit Collections Activity

Financial

ItemCode

Account Transactions

Financial

ItemCode

AR Credit Collections

Financial

ItemCode

BAT Process Data

Financial

ItemCode

GL Order

Financial

ItemCode

Revenue Branch Audit

Financial

ItemCodeDescription

Account Transactions

Financial

ItemCodeDescription

GL Order

Financial

ItemCodeDescription

Revenue Branch Audit

Financial

ItemDescription

Account Transactions

Financial

ItemDescription

BAT Process Data

Financial

ItemDescription

Commission Statement Detail

Financial

JournalDate

Account Transactions

Financial

JournalDate

AR Credit Collections

Financial

JournalDate

BAT Process Data

Financial

JournalDate

Cash Receipts

Financial

JournalDate

Commission Statement Detail

Financial

LeadSource

Commission Statement Detail

Financial

LocServBranch

Revenue Branch Audit

Financial

LoggedBy

AR Credit Collections Activity

Financial

LoggedDate

AR Credit Collections Activity

Financial

MainAccount

GL Order

Financial

Miles

Commission Statement Detail

Financial

Module

 

GL Order

Financial

MovingFrom

Cash Receipts

Financial

MovingTo

Cash Receipts

Financial

NANumber

Account Transactions

Financial

NANumber

BAT Process Data

Financial

NationalAccount

AR Credit Collections

Financial

NetAmount

Commission Statement Detail

Financial

NetAmount

GL Order

Financial

Note

AR Credit Collections Activity

Financial

OnHold

Account Transactions

Financial

OnHoldFlag

BAT Process Data

Financial

OpposingGLNumber

Account Transactions

Financial

OpposingGLNumber

BAT Process Data

Financial

OpposingGLNumber

Revenue Branch Audit

Financial

OrderArchived

AR Credit Collections

Financial

OrderArchived

AR Credit Collections Activity

Financial

OrderArchived

Cash Receipts

Financial

OrderArchived

Revenue Branch Audit

Financial

OrderBranch

Cash Receipts

Financial

OrderBranch

Revenue Branch Audit

Financial

OrderId

Account Transactions

Financial

OrderId

AR Credit Collections

Financial

OrderID

Revenue Branch Audit

Financial

OrderNo

Account Transactions

Financial

OrderNo

BAT Process Data

Financial

OrderNumber

AR Credit Collections

Financial

OrderNumber

AR Credit Collections Activity

Financial

OrderNumber

Cash Receipts

Financial

OrderNumber

Commission Statement Detail

Financial

OrderNumber

GL Order

Financial

OrderNumber

Revenue Branch Audit

Financial

OrdPriKey

BAT Process Data

Financial

Origin

GL Order

Financial

OriginalAmount

AR Credit Collections

Financial

PaymentType

Cash Receipts

Financial

PO Number

AR Credit Collections

Financial

PONumber

BAT Process Data

Financial

PostedBy

Cash Receipts

Financial

PostedBy

Payment Management

Financial

PostedDate

Cash Receipts

Financial

PostedDate

Commission Statement Detail

Financial

PostedDate

Payment Management

Financial

PostingDocNumber

BAT Process Data

Financial

PostingUserName

Account Transactions

Financial

PostingUserName

BAT Process Data

Financial

PurchaseOrder

Account Transactions

Financial

ReceiptCreatedBy

Cash Receipts

Financial

ReceiptCreatedOn

Cash Receipts

Financial

ReceiptNumber

Cash Receipts

Financial

Result

AR Credit Collections Activity

Financial

RevenueAmount

Commission Statement Detail

Financial

RevenueBranch

Revenue Branch Audit

Financial

RevenueClerk

AR Credit Collections

Financial

Salesperson

Account Transactions

Financial

Salesperson

AR Credit Collections

Financial

SalesPerson

BAT Process Data

Financial

ServiceCode

Account Transactions

Financial

Shipper

Cash Receipts

Financial

ShipperName

Account Transactions

Financial

ShipperName

AR Credit Collections

Financial

ShipperName

BAT Process Data

Financial

ShipperName

Commission Statement Detail

Financial

ShipperName

GL Order

Financial

ShipperName

Revenue Branch Audit

Financial

Source

Account Transactions

Financial

Source

BAT Process Data

Financial

Source

Revenue Branch Audit

Financial

SourceRecord

Account Transactions

Financial

SourceRecord

BAT Process Data

Financial

SplitBy

Payment Management

Financial

SplitDate

Payment Management

Financial

SplitStatementId

Payment Management

Financial

StartLoadDate

Revenue Branch Audit

Financial

StatementDetailId

Cash Receipts

Financial

StatementHeaderID

Account Transactions

Financial

StatementHeaderID

BAT Process Data

Financial

StatementHeaderId

Cash Receipts

Financial

StatementHeaderId

Payment Management

Financial

Status

Cash Receipts

Financial

Status

Payment Management

Financial

SubAccount

GL Order

Financial

TempForeignID

BAT Process Data

Financial

Ten99Flag

Account Transactions

Financial

ToAddress

AR Credit Collections

Financial

TransactionAmount

Account Transactions

Financial

TransactionAmount

BAT Process Data

Financial

TransactionAmount

Revenue Branch Audit

Financial

TransactionDate

Account Transactions

Financial

TransactionDate

BAT Process Data

Financial

TransactionDate

Revenue Branch Audit

Financial

TransactionDescription

GL Order

Financial

TransactionType

Account Transactions

Financial

TransactionType

BAT Process Data

Financial

TransactionType

Revenue Branch Audit

Financial

TypeOfMove

AR Credit Collections

Financial

TypeOfMove

Commission Statement Detail

Financial

VendorBalance

Commission Statement Detail

Financial

VendorClass

Commission Statement Detail

Financial

VendorClassID

Commission Statement Detail

Financial

VendorID

Commission Statement Detail

Financial

VendorInvoiceNumber

Account Transactions

Financial

VendorInvoiceNumber

BAT Process Data

Financial

VendorName

Account Transactions

Financial

VendorName

BAT Process Data

Financial

VendorName

Commission Statement Detail

Financial

VendorName

Revenue Branch Audit

Financial

VendorNumber

Account Transactions

Financial

VendorNumber

BAT Process Data

Financial

VendorNumber

Revenue Branch Audit

Financial

VoidedBy

Cash Receipts

Financial

VoidedDate

Cash Receipts

Financial

VoidedNote

Cash Receipts

Financial

VoidStatus

GL Order

Financial

VoucherNumber

Account Transactions

Financial

VoucherNumber

BAT Process Data

Financial

VoucherNumber

Commission Statement Detail

Financial

VoucherNumber

GL Order

Financial

WorkTicket

Revenue Branch Audit

Financial