Stored Procedures

BUILD09 > MoversSuite2 > Stored Procedures

Name
arvy.GetBranchesByConnectIdentifier
arvy.GetCrewByLocalService
arvy.GetEquipmentByLocalService
arvy.GetLocalDispatchByDateAndBranch
dbo.AddSalesTaxRevenueItems
dbo.AddXmlSystemRequestQueue
dbo.AdvanceBATBuildGLNumber_Legacy
dbo.AdvanceBATBuildGLNumber_XLedger
dbo.ARCGetCustomerClasses
dbo.ARCUpdateCustomerAlertsConvertToXLedger
dbo.ARCUpdateCustomerCreditLimit_Legacy
dbo.ARCUpdateCustomerCreditLimit_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.BATErrorVerifyAccountingSystem
dbo.BcImportAccounts
dbo.BcImportCustomers
dbo.BcImportDimensions
dbo.BcImportDimensionValues
dbo.BcImportVendors
dbo.BIUserInformation
dbo.BuildGPWarehouse_Legacy
dbo.BuildGPWarehouse_XLedger
dbo.BuildGPWarehouse_XLedger_Initialize
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.GetAccountingBankAccounts
dbo.GetARCCustomerContacts_Legacy
dbo.GetARCCustomerContacts_XLedger
dbo.GetBranchesByVendorConnectIntegrator
dbo.GetCommStmtHeaderInformation
dbo.GetContactMessages
dbo.GetCountryCodeStandards
dbo.GetCreditLimitTypes
dbo.GetCustomerCreditInfo_Legacy
dbo.GetCustomerCreditInfo_XLedger
dbo.GetCustomerPhone1AreaCodeLocalNbrExt_Legacy
dbo.GetCustomerPhone1AreaCodeLocalNbrExt_XLedger
dbo.GetDocumentByteSize
dbo.GetExistingConversations
dbo.GetGlobalSystemOptionValue
dbo.GetInternationalContainersForLetter
dbo.GetInternationalContainerTotalsForLetter
dbo.GetInvoiceDetailsForLetter
dbo.GetInvoiceInfoForLetter
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.GetUsaCountryCodeStandardId
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.MssWebCheckCanEditOrderInvoiceRequirement
dbo.MssWebCheckContactMappedToAnyLocation
dbo.MssWebCheckContactMappedToAnyQuote
dbo.MssWebCheckOrderLocationCanBeDeleted
dbo.MssWebClearPreviousAccountProfileDetails
dbo.MssWebCreateDocumentReceivedTask
dbo.MssWebCreateDuplicateOrder
dbo.MssWebCreateInternationalContainer
dbo.MssWebCreateInternationalLiftVan
dbo.MssWebCreateOrderAdditionalCharge
dbo.MssWebCreateOrderTask
dbo.MssWebCreateOrderThirdPartyService
dbo.MssWebCreateQuoteHeader
dbo.MssWebDeleteDbEvents
dbo.MssWebDeleteDocument
dbo.MssWebDeleteEmailSignature
dbo.MssWebDeleteInternationalContainer
dbo.MssWebDeleteInternationalLiftVan
dbo.MssWebDeleteOAndILocalServiceLocationMapping
dbo.MssWebDeleteOrderAdditionalCharge
dbo.MssWebDeleteOrderAddress
dbo.MssWebDeleteOrderContact
dbo.MssWebDeleteOrderContactAddress
dbo.MssWebDeleteOrderContactPhone
dbo.MssWebDeleteOrderLocation
dbo.MssWebDeleteOrderLocationAddress
dbo.MssWebDeleteOrderThirdPartyService
dbo.MssWebDeleteScheduledMessage
dbo.MssWebDeleteThirdPartyErrors
dbo.MssWebDeleteThirdPartyErrorsPriorTo
dbo.MssWebExportOrderContactToAccountProfile
dbo.MssWebExportOrderLocationtToAccountProfile
dbo.MssWebGetAccountDetails
dbo.MssWebGetAccountingCustomerBillToAddresses
dbo.MssWebGetAccountingCustomerLookupItem
dbo.MssWebGetAccountingCustomerLookupItems
dbo.MssWebGetAccountingVendorGridItems
dbo.MssWebGetAccountingVendorLookupItems
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.MssWebGetConfiguredInvoiceRequirementType
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.MssWebGetInternationalContainer
dbo.MssWebGetInternationalContainers
dbo.MssWebGetInternationalContainerSizeTypeLookups
dbo.MssWebGetInternationalContainersLookup
dbo.MssWebGetInternationalLiftVan
dbo.MssWebGetInternationalLiftVans
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.MssWebGetOrderGuaranteePriceChargeCredit
dbo.MssWebGetOrderGuaranteePriceInfo
dbo.MssWebGetOrderInvoiceRequirementTypeId
dbo.MssWebGetOrderLocationBuildingConstraint
dbo.MssWebGetOrderLocationBuildingConstraintQuestions
dbo.MssWebGetOrderLocationBuildingConstraints
dbo.MssWebGetOrderNumbersByContactPriKeys
dbo.MssWebGetOrderOperationalNote
dbo.MssWebGetOrderRatesByRateType
dbo.MssWebGetOrderSakariCustomContacts
dbo.MssWebGetOrderSakariCustomerContacts
dbo.MssWebGetOrderSakariPersonnelContacts
dbo.MssWebGetOrderTaskDefinition
dbo.MssWebGetOrderTaskIdentifiers
dbo.MssWebGetOrderTasks
dbo.MssWebGetOrderTasksBranches
dbo.MssWebGetOrderThirdPartyErrorsCount
dbo.MssWebGetOrderThirdPartyIntegrations
dbo.MssWebGetOrderThirdPartyServices
dbo.MssWebGetOrderUnreadAndScheduledCount
dbo.MssWebGetOrderWorkTickets
dbo.MssWebGetOrganizationLaborEmailAddresses
dbo.MssWebGetOutgoingMessages
dbo.MssWebGetPaymentMethods
dbo.MssWebGetPaymentTypes
dbo.MssWebGetPermissionsForUserAndBranches
dbo.MssWebGetPermissionsForUserAndOrdersBranches
dbo.MssWebGetQuoteHeadersByOrderId
dbo.MssWebGetQuoteServiceProviderBillToLookups
dbo.MssWebGetQuoteServiceProviderTypeLookupItems
dbo.MssWebGetQuoteStatusLookups
dbo.MssWebGetQuoteSummaryByQuoteId
dbo.MssWebGetRateTypeLookupItems
dbo.MssWebGetRecentlyUsedEmailAddresses
dbo.MssWebGetRevenueGroupLookupItems
dbo.MssWebGetSakariAccountId
dbo.MssWebGetSakariContactByPhoneNumbers
dbo.MssWebGetScheduledMessage
dbo.MssWebGetScheduledMessages
dbo.MssWebGetScopeOfWorkOrderMap
dbo.MssWebGetSectionPreferences
dbo.MssWebGetSmsOrderLevelInformation
dbo.MssWebGetSmsTemplates
dbo.MssWebGetSmsUnreadMessageCount
dbo.MssWebGetSortOrderForGroupedLineItem
dbo.MssWebGetSortOrderForTopLevelQuoteItems
dbo.MssWebGetTaskDependencyDates
dbo.MssWebGetTaskPriorities
dbo.MssWebGetTaskUsers
dbo.MssWebGetThirdPartyErrorDocDataType
dbo.MssWebGetThirdPartyErrors
dbo.MssWebGetThirdPartyErrorXmlData
dbo.MssWebGetUngroupedLineItemsByQuoteId
dbo.MssWebGetUserSakariSignature
dbo.MssWebInsertEmailSignature
dbo.MssWebInsertOAndILocalServiceLocations
dbo.MssWebInsertOrderContact
dbo.MssWebInsertOrderLocation
dbo.MssWebInsertQuoteLineItem
dbo.MssWebInsertUpdateDeleteServiceDetailOrderMap
dbo.MssWebInsertUpdateOrderContactAddress
dbo.MssWebInsertUpdateOrderContactPhone
dbo.MssWebInsertUpdateOrderLocationAddress
dbo.MssWebInsertUpdateOrderLocationBuildingConstraint
dbo.MssWebInsertUpdateRecentlyUsedEmail
dbo.MssWebInsertUpdateScheduledMessage
dbo.MssWebInsertUpdateUserSignature
dbo.MssWebInternationalContainerLoadTypeLookups
dbo.MssWebInternationalGetLiftVanStatusLookup
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.MssWebUpdateInternationalContainer
dbo.MssWebUpdateInternationalLiftVan
dbo.MssWebUpdateOrderAdditionalCharge
dbo.MssWebUpdateOrderClaimAlert
dbo.MssWebUpdateOrderContact
dbo.MssWebUpdateOrderDuplicateLocationAddressType
dbo.MssWebUpdateOrderGuaranteePriceInfo
dbo.MssWebUpdateOrderLocation
dbo.MssWebUpdateOrderTasks
dbo.MssWebUpdateOrderThirdPartyService
dbo.MssWebUpdateSakariContactLastReadAt
dbo.MssWebUpdateSectionPreference
dbo.MssWebUpdateSmsContactName
dbo.MssWebUpdateSortOrderForGroupedLineItem
dbo.MssWebUpdateSortOrderForTopLevelQuoteItems
dbo.MssWebUpdateTaskComplete
dbo.MssWebUpdateTaskNotApplicable
dbo.MssWebUpdateTaskPriorities
dbo.MssWebUpdateUserProfileEmailAddress
dbo.ReEnqueueFailedTransactions
dbo.ReportStandardARCollections_Legacy
dbo.ReportStandardARCollections_XLedger
dbo.RevenueGetThirdPartyVendor1099Flag_Legacy
dbo.RevenueGetThirdPartyVendor1099Flag_XLedger
dbo.RevenueRatingImportDetailInsert
dbo.RevenueRatingImportHeaderInsert
dbo.RevenueRatingImportInvoiceDetails
dbo.RevenueRatingImportInvoiceDetailUpdateAgent
dbo.SaveRecurringPaymentInfoForStorage
dbo.SetSystemValidationByKey
dbo.SetXmlSystemRequestStatus
dbo.spAPPG_RunApplyGridForAccountingSystem
dbo.spAPPG_XLRunApplyGrid
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.spCSMBuildStatement_Legacy
dbo.spCSMBuildStatement_XLedger
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.UpdateApplyGridOriginalBalances
dbo.UpdateCommissionOnHoldStatus_Legacy
dbo.UpdateCommissionOnHoldStatus_XLedger
dbo.UpdateCurrentDriverName
dbo.UpdateCustomerCreditInfo
dbo.UpdateDocumentNameExtensionOnly
dbo.UpdateErrorCodeStatisticsInBulk
dbo.UpdateLastReadAt
dbo.UpdatePlasticDealHppSessionInfo
dbo.UpdateTasks
dbo.UpdateXLApplyGridOriginalBalances
dbo.UpsertARCCustomerContact_Legacy
dbo.UpsertARCCustomerContact_XLedger
dbo.UpsertXmlOrderLink
dbo.ValidateAccountingSystemRequirements_Legacy
dbo.ValidateAccountingSystemRequirements_XLedger
dbo.ValidateWheatonOrder
dbo.VanlineStatementMoveToRatingImport
dbo.VerifyDateInOpenAccountingPostingPeriod
dbo.VerifyDateInOpenAccountingPostingPeriodForAllBranches
dbo.VerifyDateInOpenAccountingPostingPeriodForSelectedBranches
dbo.XLedgerBeginNewSyncHistory
dbo.XLedgerChangeTransactionHoldStatuses
dbo.XLedgerCheckForTransactionUploadErrors
dbo.XLedgerCheckForTransactionUploadErrorsForManager
dbo.XLedgerCheckForTransactionUploadErrorsForRevenueClerk
dbo.XLedgerCheckIfTransactionUploadCompleted
dbo.XLedgerDeleteUnencounteredSubledgerHiddenIndicators
dbo.XLedgerDequeueJournalEntryBatchHeader
dbo.XLedgerGetConfigSyncRequestInfo
dbo.XLedgerGetEnqueuedAccountTransactionApplyTos
dbo.XLedgerGetEnqueuedAccountTransactions
dbo.XLedgerGetNextEnqueuedJournalEntryBatchHeader
dbo.XLedgerGetSubmittedHoldChangesBatch
dbo.XLedgerImportAccountingPeriodRange
dbo.XLedgerImportAccountingPeriods
dbo.XLedgerImportAccounts
dbo.XLedgerImportApTransactions
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.XLedgerMarkTransactionHoldStatusChangeAsFailure
dbo.XLedgerMarkTransactionsPostAsFailure
dbo.XLedgerMarkTransactionsPostAsSuccess
dbo.XLedgerRequestTransactionHoldChange
dbo.XLedgerTransactionsForUploadFailure
dbo.XmlExportFromOrderNoLastName
dbo.XmlExportLocalServicesInformation
dbo.XmlExportOfficeIndustrialInformation
dbo.XmlExportOrderContact
dbo.XmlExportOrderLocation
dbo.XmlExportUserDefinedFields
dbo.XmlImportProcessOfficeIndustrial
dbo.XmlImportProcessRatingInvoiceDetails
rdld.CheckCustomerNumber
rdld.CheckForOrderNumberDups
rdld.CheckVendorNumber
rdld.FindBadXmlOrderLinkExternalKeys
rdld.GetClaimDetailsForDriver
rdld.GetClaimsForDriver
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