MoversSuite Data Views

MoversSuite provides several SQL scripts designed to create views of MoversSuite data. These scripts provide access to data that populates several areas in MoversSuite, such as the AR Detail grid in AR Credit & Collections. Data from these scripts can import into a Microsoft Excel spreadsheet (refer to Download MoversSuite Data View to Excel).

This data is considered a “dump” of database information. Sorting, grouping, filtering, and other tasks that MoversSuite provides within its application must be managed through an external application, such as Microsoft Excel.

The following table lists the available views. These views can be specifically referenced for this version of MoversSuite through the Welcome to MoversSuite Software topic under the Schema Changes listing.


AgentAddresses	Returns the “Main” address for each agent record.
AgentPhoneNumbers	Returns the agent phone number for the “Phone” and “Fax” type.
AgentsContactInformation	Returns the contact information for all agents.
EDIInvoice	This view displays invoices for the last 30 days generated for EDI customers.
EDIInvoiceException	Access this view to see a list of invoices that were not added to the EDIInvoice view for some reason.
EDIItem	This view displays all items applied within the EDIInvoice view for all invoices. Items are defined within the Customer EDI Item section for each EDI Customer Setup record.
InternationalBOLConsigneeAddresses	Returns the “Main” address for all International BOL consignees
InternationalBOLConsigneePhoneNumbers	Returns the phone numbers for the “Phone” and “Fax” type for all International BOL consignees
InternationalBookingNumberAddresses	Returns the International Booking Number information for the “Pickup” and “Return” location addresses
InternationalBookingNumberPhoneNumbers	Returns the International Booking Number information for the “Phone” and “Fax” type for all International BOL consignees
InternationalCarrierAddresses	Returns the “Main” address for all International Carriers
InternationalConsolidatorAddresses	Returns the “Main” address for all International Carriers
InternationalCustomsAgentAddresses	Returns the “Main” address for all International Customs Agents
JobInformation	Returns the store information including name, contact and phone numbers for the “Phone” and “Fax” type for all job/store records
LocalServices	Returns a complete listing of information for all Local Services records
LocalServicesCrew	Returns a listing of crew assignments and scheduled and actual times for all Local Services record with crew assignments
LocalServicesEquipment	Returns a listing of equipment assignments and scheduled and actual times for all Local Services record with equipment assignments
LocalServicesWithinNextWeek	Returns a listing of all services with a service date between the current date and seven days into the future. It includes all active services (excluded services that are “Idle”, “Not Cleared”, “Pending”, or “Voided”).
MaterialItemCodeMapIDsInUse	Produces a list of primary keys for each Item Code associated to a Materials item along with the Material Type identifier.
OrderAddresses	Returns a list of all main addresses associated to an order, included those specified as the “Origin”, “Destination”, and “MovingTo” addresses.
OrderPhoneNumbers	Returns a list of all main phone numbers associated to an order including those with a phone type of “Origin Home”, “Origin Work”, “Destination Home”, “Destination Work”, “Moving To Home”, and “Moving To Work”.
OrdersFinancialInformation	Provides billing and financial information on all orders. Includes billing contact and address, national account information, branch information, rating information, revenue clerk assignment, etc.
SafetySystemEquipmentStatus	Returns a list of all equipment and corresponding safety status, i.e. on hold (Black), date expired (Red), date expiring within 30 days (Yellow), and in good standing (Green).
SafetySystemPersonnelStatus	Returns a list of all users and their corresponding safety status, i.e. on hold (Black), date expired (Red), date expiring within 30 days (Yellow), and in good standing (Green).
vARCreditCollections	Refer to vARCreditCollections Data View for details.
vCashReceipts	Refer to vCashReceipts Data View for details.
vClaimsGrid	Refer to vClaimsGrid Data View for details.
vClaimsSummaryAmounts	Refer to vClaimsSummaryAmounts Data View for details.
vCustomerInformation	Refer to vCustomerInformation Data View for details.
vInternational	Refer to vInternational Data View for details.
vLocalDispatchGrid	Refer to vLocalDispatchGrid Data View for details.
vLongDistanceDispatchGrid	Refer to vLongDistanceDispatchGrid Data View for details.
vMilitaryGovernment	Refer to vMilitaryGovernment Data View for details.
vOrderActualCPU	Refer to vOrderActualCPU Data View for details.
vOrderEstimatedCPU	Refer to vOrderEstimatedCPU Data View for details.
vOrderInformation	Refer to vOrderInformation Data View for details.
vPaymentManagement	Refer to vPaymentManagement Data View for details.
vPRMilitaryScores	Refer to vPRMilitaryScores Data View for details.
vRetainedRevenue	Refer to vRetainedRevenue Data View for details.
vRevenueEntry	Refer to vRevenueEntry Data View for details.
vSpecialServices	Refer to vSpecialServices Data View for details.
XtraStopInformation	Produces a list of all extra stop records along with addresses and contact information for each.

RELATED TOPIC:

Download MoversSuite Data View to Excel

Export To

Military EDI Views