Stored Procedures Stored Procedures

Name
arvy.GetBranchesByConnectIdentifier
arvy.GetCrewByLocalService
arvy.GetEquipmentByLocalService
arvy.GetLocalDispatchByDateAndBranch
dbo.AddSalesTaxRevenueItems
dbo.AddXmlSystemRequestQueue
dbo.AdvanceBATBuildGLNumber_Legacy
dbo.AdvanceBATBuildGLNumber_XLedger
dbo.AttachDocumentsToOutgoingEmail
dbo.AttachInlineToOutgoingEmail
dbo.AttachLocalFileToOutgoingEmail
dbo.AttachPdfGenerationHtmlToOutgoingEmail
dbo.BATBuildARAPGLNumber_Legacy
dbo.BATBuildARAPGLNumber_XLedger
dbo.BATBuildExpenseGLNumber_Legacy
dbo.BATBuildExpenseGLNumber_XLedger
dbo.BATBuildRevenueGLNumber_Legacy
dbo.BATBuildRevenueGLNumber_XLedger
dbo.BATCheckCustomerStatus
dbo.BATGetXLedgerXglsForAllOrders
dbo.BIUserInformation
dbo.ChangeAlternateBillToOnBillingMinorItems
dbo.CheckForPreexistingContactInfoForSakariAccount
dbo.ClaimsBATBuildSettlementClearingAccount_Legacy
dbo.ClaimsBATBuildSettlementClearingAccount_XLedger
dbo.CompleteMoversSuitePlasticPayment
dbo.DeleteCommStmtHeader
dbo.DeletePMImportStatement
dbo.DeterminePlasticTokenTypeId
dbo.DocumentAutoDownloadApplyRules
dbo.DocumentAutoUploadApplyRules
dbo.DocumentManagementAddImageUpdateDoc
dbo.EmailApiGetEmailDocumentType
dbo.EmailApiGetEmailQueueBacklogCount
dbo.EmailApiGetItemsRequiringPdfGeneration
dbo.EmailApiGetOutgoingEmailDocumentAttachments
dbo.EmailApiGetOutgoingEmailFileAttachments
dbo.EmailApiGetOutgoingEmailInlineAttachments
dbo.EmailApiGetOutgoingEmailInvoiceAttachments
dbo.EmailApiGetPdfInputHtml
dbo.EmailApiMarkFailures
dbo.EmailApiMarkSuccess
dbo.EmailApiPurgeOldEmails
dbo.EnqueueOutgoingEmail
dbo.EnqueueXmlSystemTransferrals
dbo.GenerateAccountingBatches_Legacy
dbo.GenerateAccountingBatches_XLedger
dbo.GetBranchesByVendorConnectIntegrator
dbo.GetCommStmtHeaderInformation
dbo.GetContactMessages
dbo.GetCountryCodeStandards
dbo.GetCustomerPhone1AreaCodeLocalNbrExt_Legacy
dbo.GetCustomerPhone1AreaCodeLocalNbrExt_XLedger
dbo.GetDocumentByteSize
dbo.GetExistingConversations
dbo.GetGlobalSystemOptionValue
dbo.GetMoversConnectTenantTraceId
dbo.GetOpenStorageUsingPlasticPayments
dbo.GetOrderByXmlOrderLink
dbo.GetPaymentTypeFromPlasticTokenTypeId
dbo.GetPendingXmlSystemRequests
dbo.GetPlasticAuthorizationsByOrderID
dbo.GetPlasticInstrumentByInstrumentId
dbo.GetPlasticPaymentInfo
dbo.GetPlasticProviderDepositDate
dbo.GetPlasticProviderHostedPaymentPageOptions
dbo.GetPlasticProvidersByBranch
dbo.GetPlasticProviderTypeTransactionErrorProcessingSetting
dbo.GetPlasticWebDealBranchID
dbo.GetProviderTransactionInformation
dbo.GetSalesCommissionInvoiceArBalance
dbo.GetScheduledMessagesForUser
dbo.GetSystemValidationByKey
dbo.GetUnreadMessageCountForUser
dbo.GetValidationByKey
dbo.GetWheatonConnectionInfo
dbo.GetWheatonOrderInformation
dbo.GetXLedgerOnDemandSyncHistory
dbo.GetXmlOrderLink
dbo.GetXmlSystemOptionBitValue
dbo.GetXmlSystemOptionForVendorConnectKey
dbo.InsertMultipleMobileCrewTimesSendToXmlInterface
dbo.IsXLedgerActive
dbo.ItemCodeVanlineMappingImportAction
dbo.ItemCodeVanlineMappingImportValidation
dbo.ItemCodeVanlineMappingImportWorksheet
dbo.LogAdpSend
dbo.LookupAccountingCustomerIdByCustomerNumber
dbo.MarkWebDealAsReprocessed
dbo.MobileCrewTimeDeletePunch
dbo.MssWebCheckAnySakariAccountExist
dbo.MssWebCheckContactMappedToAnyLocation
dbo.MssWebCheckContactMappedToAnyQuote
dbo.MssWebCheckOrderLocationCanBeDeleted
dbo.MssWebClearPreviousAccountProfileDetails
dbo.MssWebCreateDocumentReceivedTask
dbo.MssWebCreateDuplicateOrder
dbo.MssWebCreateOrderAdditionalCharge
dbo.MssWebCreateOrderTask
dbo.MssWebCreateOrderThirdPartyService
dbo.MssWebCreateQuoteHeader
dbo.MssWebDeleteDbEvents
dbo.MssWebDeleteDocument
dbo.MssWebDeleteEmailSignature
dbo.MssWebDeleteOAndILocalServiceLocationMapping
dbo.MssWebDeleteOrderAdditionalCharge
dbo.MssWebDeleteOrderAddress
dbo.MssWebDeleteOrderContact
dbo.MssWebDeleteOrderContactAddress
dbo.MssWebDeleteOrderContactPhone
dbo.MssWebDeleteOrderLocation
dbo.MssWebDeleteOrderLocationAddress
dbo.MssWebDeleteOrderThirdPartyService
dbo.MssWebDeleteScheduledMessage
dbo.MssWebExportOrderContactToAccountProfile
dbo.MssWebExportOrderLocationtToAccountProfile
dbo.MssWebGetAccountDetails
dbo.MssWebGetAccountProfileContactInfo
dbo.MssWebGetAccountProfileContactsForOrder
dbo.MssWebGetAccountProfileDocumentImage
dbo.MssWebGetAccountProfileDocuments
dbo.MssWebGetAccountProfileNotes
dbo.MssWebGetAccountProfileServiceStatuses
dbo.MssWebGetAccountProfileServicesWithOverrides
dbo.MssWebGetAddressLocationTypes
dbo.MssWebGetAllEnqueuedEvents
dbo.MssWebGetAuthVia
dbo.MssWebGetBillChargesTo
dbo.MssWebGetBuildingAddress
dbo.MssWebGetBuildings
dbo.MssWebGetChargeTypes
dbo.MssWebGetCommodityDetails
dbo.MssWebGetContactInfo
dbo.MssWebGetContractsLookups
dbo.MssWebGetConversationListByOrder
dbo.MssWebGetConversationListByUser
dbo.MssWebGetCoordinatorTypes
dbo.MssWebGetDocumentDeletionReasons
dbo.MssWebGetEmailSignatureContent
dbo.MssWebGetEmailSignatures
dbo.MssWebGetGlobalTasks
dbo.MssWebGetGroupedLineItemsByQuoteId
dbo.MssWebGetHaulModes
dbo.MssWebGetIncomingMessages
dbo.MssWebGetInvoiceRequirementTypes
dbo.MssWebGetItemCodeLookupItems
dbo.MssWebGetJobNo
dbo.MssWebGetLocalServiceMappedLocations
dbo.MssWebGetLocalServiceOriginDestination
dbo.MssWebGetOAndIOrderLocations
dbo.MssWebGetOrderAdditionalCharges
dbo.MssWebGetOrderBillingInformation
dbo.MssWebGetOrderBranchAllDispatcherEmails
dbo.MssWebGetOrderBranchAllLongDistanceDispatcherEmails
dbo.MssWebGetOrderClaimAlertDetail
dbo.MssWebGetOrderClientNote
dbo.MssWebGetOrderContact
dbo.MssWebGetOrderContactLookupItems
dbo.MssWebGetOrderContacts
dbo.MssWebGetOrderDependencyTasks
dbo.MssWebGetOrderEmailAddresses
dbo.MssWebGetOrderEmailOptions
dbo.MssWebGetOrderLocationBuildingConstraint
dbo.MssWebGetOrderLocationBuildingConstraintQuestions
dbo.MssWebGetOrderLocationBuildingConstraints
dbo.MssWebGetOrderNumbersByContactPriKeys
dbo.MssWebGetOrderOperationalNote
dbo.MssWebGetOrderSakariCustomContacts
dbo.MssWebGetOrderSakariCustomerContacts
dbo.MssWebGetOrderSakariPersonnelContacts
dbo.MssWebGetOrderTaskDefinition
dbo.MssWebGetOrderTaskIdentifiers
dbo.MssWebGetOrderTasks
dbo.MssWebGetOrderTasksBranches
dbo.MssWebGetOrderThirdPartyIntegrations
dbo.MssWebGetOrderThirdPartyServices
dbo.MssWebGetOrderUnreadAndScheduledCount
dbo.MssWebGetOrderWorkTickets
dbo.MssWebGetOrganizationLaborEmailAddresses
dbo.MssWebGetOutgoingMessages
dbo.MssWebGetPaymentMethods
dbo.MssWebGetPaymentTypes
dbo.MssWebGetPermissionsForUserAndBranches
dbo.MssWebGetPermissionsForUserAndOrdersBranches
dbo.MssWebGetQuoteHeadersByOrderId
dbo.MssWebGetQuoteStatusLookups
dbo.MssWebGetQuoteSummaryByQuoteId
dbo.MssWebGetRateTypeLookupItems
dbo.MssWebGetRecentlyUsedEmailAddresses
dbo.MssWebGetRevenueGroupLookupItems
dbo.MssWebGetSakariAccountId
dbo.MssWebGetSakariContactByPhoneNumbers
dbo.MssWebGetScheduledMessage
dbo.MssWebGetScheduledMessages
dbo.MssWebGetScopeOfWorkOrderMap
dbo.MssWebGetSmsOrderLevelInformation
dbo.MssWebGetSmsTemplates
dbo.MssWebGetSmsUnreadMessageCount
dbo.MssWebGetSortOrderForGroupedLineItem
dbo.MssWebGetSortOrderForTopLevelQuoteItems
dbo.MssWebGetTaskDependencyDates
dbo.MssWebGetTaskPriorities
dbo.MssWebGetTaskUsers
dbo.MssWebGetUngroupedLineItemsByQuoteId
dbo.MssWebGetUserSakariSignature
dbo.MssWebInsertEmailSignature
dbo.MssWebInsertOAndILocalServiceLocations
dbo.MssWebInsertOrderContact
dbo.MssWebInsertOrderLocation
dbo.MssWebInsertUpdateDeleteServiceDetailOrderMap
dbo.MssWebInsertUpdateOrderContactAddress
dbo.MssWebInsertUpdateOrderContactPhone
dbo.MssWebInsertUpdateOrderLocationAddress
dbo.MssWebInsertUpdateOrderLocationBuildingConstraint
dbo.MssWebInsertUpdateRecentlyUsedEmail
dbo.MssWebInsertUpdateScheduledMessage
dbo.MssWebInsertUpdateUserSignature
dbo.MssWebOrderAdvancedSearch
dbo.MssWebOverrideAccountProfileService
dbo.MssWebQuickFindCustomer
dbo.MssWebRemoveLocalServiceOriginDestinationLocation
dbo.MssWebSetAccountProfilePrimaryContact
dbo.MssWebSubscribeToSakariContact
dbo.MssWebUnsetAccountProfilePrimaryContact
dbo.MssWebUnsubscribeToSakariContact
dbo.MssWebUpdateDocumentProperties
dbo.MssWebUpdateDocumentSendToCrew
dbo.MssWebUpdateEmailAlwaysCopyMeIn
dbo.MssWebUpdateEmailSignature
dbo.MssWebUpdateEmailSignatureDefault
dbo.MssWebUpdateOrderAdditionalCharge
dbo.MssWebUpdateOrderClaimAlert
dbo.MssWebUpdateOrderContact
dbo.MssWebUpdateOrderDuplicateLocationAddressType
dbo.MssWebUpdateOrderLocation
dbo.MssWebUpdateOrderTasks
dbo.MssWebUpdateOrderThirdPartyService
dbo.MssWebUpdateSakariContactLastReadAt
dbo.MssWebUpdateSmsContactName
dbo.MssWebUpdateSortOrderForGroupedLineItem
dbo.MssWebUpdateSortOrderForTopLevelQuoteItems
dbo.MssWebUpdateTaskComplete
dbo.MssWebUpdateTaskNotApplicable
dbo.MssWebUpdateTaskPriorities
dbo.MssWebUpdateUserProfileEmailAddress
dbo.RevenueGetThirdPartyVendor1099Flag_Legacy
dbo.RevenueGetThirdPartyVendor1099Flag_XLedger
dbo.RevenueRatingImportInvoiceDetails
dbo.RevenueRatingImportInvoiceDetailUpdateAgent
dbo.SaveRecurringPaymentInfoForStorage
dbo.SetSystemValidationByKey
dbo.SetXmlSystemRequestStatus
dbo.spBATGenerateFirstCommGLNumber_Legacy
dbo.spBATGenerateFirstCommGLNumber_XLedger
dbo.spBATGenerateFirstRevGLNumber_Legacy
dbo.spBATGenerateFirstRevGLNumber_XLedger
dbo.spBATGenerateFirstThirdPartyGLNumber_Legacy
dbo.spBATGenerateFirstThirdPartyGLNumber_XLedger
dbo.spBATGenerateSecondCommGLNumber_Legacy
dbo.spBATGenerateSecondCommGLNumber_XLedger
dbo.spBATGenerateSecondRevGLNumber_Legacy
dbo.spBATGenerateSecondRevGLNumber_XLedger
dbo.spBATGenerateSecondThirdPartyGLNumber_Legacy
dbo.spBATGenerateSecondThirdPartyGLNumber_XLedger
dbo.spBATGetSingleXLedgerXglId
dbo.spBATGetXLedgerXgls
dbo.spRecordBatOrStorageError
dbo.spRevenueGetItems_Legacy
dbo.spRevenueGetItems_XLedger
dbo.spRevenueGetItemsForRatePlan_Legacy
dbo.spRevenueGetItemsForRatePlan_XLedger
dbo.spStorageGenerateGLNumbers_Legacy
dbo.spStorageGenerateGLNumbers_XLedger
dbo.StageOutgoingEmail
dbo.SubscribeToConversation
dbo.SyncOutgoingEmailStatus
dbo.TransferOpenStoragePaymentMethodToNewProvider
dbo.UnsubscribeFromConversation
dbo.UpdateCurrentDriverName
dbo.UpdateDocumentNameExtensionOnly
dbo.UpdateLastReadAt
dbo.UpdatePlasticDealHppSessionInfo
dbo.UpdateTasks
dbo.UpsertXmlOrderLink
dbo.ValidateAccountingSystemRequirements_Legacy
dbo.ValidateAccountingSystemRequirements_XLedger
dbo.ValidateWheatonOrder
dbo.VanlineStatementMoveToRatingImport
dbo.VerifyDateInOpenAccountingPostingPeriod
dbo.VerifyDateInOpenAccountingPostingPeriodForAllBranches
dbo.XLedgerBeginNewSyncHistory
dbo.XLedgerDeleteUnencounteredSubledgerHiddenIndicators
dbo.XLedgerDequeueJournalEntryBatchHeader
dbo.XLedgerGetConfigSyncRequestInfo
dbo.XLedgerGetEnqueuedAccountTransactions
dbo.XLedgerGetNextEnqueuedJournalEntryBatchHeader
dbo.XLedgerImportAccountingPeriods
dbo.XLedgerImportAccounts
dbo.XLedgerImportAuthorityTypeObjectValues
dbo.XLedgerImportBankAccounts
dbo.XLedgerImportBranchObjectValues
dbo.XLedgerImportCommodityTypeObjectValues
dbo.XLedgerImportCompanies
dbo.XLedgerImportCustomers
dbo.XLedgerImportMoveTypeObjectValues
dbo.XLedgerImportSubledgerHiddenIndicators
dbo.XLedgerImportSuppliers
dbo.XLedgerImportXgls
dbo.XLedgerMarkConfigSyncAsFailure
dbo.XLedgerMarkConfigSyncAsSuccess
dbo.XLedgerMarkSyncUpToDate
dbo.XLedgerMarkTransactionsPostAsFailure
dbo.XLedgerMarkTransactionsPostAsSuccess
dbo.XmlExportFromOrderNoLastName
dbo.XmlExportLocalServicesInformation
dbo.XmlExportOfficeIndustrialInformation
dbo.XmlExportOrderContact
dbo.XmlExportOrderLocation
dbo.XmlExportUserDefinedFields
dbo.XmlImportProcessOfficeIndustrial
dbo.XmlImportProcessRatingInvoiceDetails
rdld.CheckVendorNumber
rdld.FindBadXmlOrderLinkExternalKeys
rdld.GetClaimDetailsForDriver
rdld.GetClaimsForDriver
rdld.GetCustomerInfo
rdld.GetFinanceDetailForDriverAccount
rdld.GetFinanceDetailForDriverOrder
rdld.GetFinanceForDriver
rdld.GetOrderNumberSequences
rdld.GetOrderNumbersRow
rdld.GetShippingDetails
rdld.GetStatementAndReserveForDrivers
rdld.GetSysUserRecords
rdld.GetTradeShows
rdld.UpdatePaperworkRecd
rdld.UpdateShippingDetails
rdld.UpdateTradeShows
rdld.UpdateXmlOrderLink