Tables Affected, Listed by Table, S [AX 2012]

Updated: November 1, 2012

Applies To: Microsoft Dynamics AX 2012 R3

This topic provides a list of the tables that would be affected by a given upgrade script. The list is grouped by each table that has links to the applicable data upgrade script topics.

This topic lists the tables whose names begin with the letter S.

ReleaseUpdateDB41_Cust.updateDeliveryDateControlType Upgrade Script

ReleaseUpdateTransformDB40_CRM.updateSalesLine Upgrade Script

ReleaseUpdateTransformDB40_CRM.updateSalesLineDelta Upgrade Script

ReleaseUpdateTransformDB40_Cust.salesLineDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Cust.salesLinePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Prod.updateSalesLine Upgrade Script

ReleaseUpdateTransformDB50_CRM.updateSalesLine Upgrade Script

ReleaseUpdateTransformDB50_CRM.updateSalesLineDelta Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesLineDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesLinePreUpgradeProcess Upgrade Script

ReleaseUpdateDB60_Basic.createSalesLine_IN Upgrade Script

ReleaseUpdateDB60_Basic.updateDirPartyAddress_RU_Fields_RU Upgrade Script

ReleaseUpdateDB60_Basic.updateDirPartyAddress_RU_Fields1_RU Upgrade Script

ReleaseUpdateDB60_Basic.updateUnitOfMeasureConsumers

ReleaseUpdateDB60_Basic.updateUnitOfMeasureConsumers Upgrade Script

ReleaseUpdateDB60_Cust.updateBOs2SalesAgreements

ReleaseUpdateDB60_Cust.updateBOs2SalesAgreements Upgrade Script

ReleaseUpdateDB60_Cust.updateCFOPRecId_BR Upgrade Script

ReleaseUpdateDB60_Cust.updateCustInvoicePackingSlipQtyMatch Upgrade Script

ReleaseUpdateDB60_Cust.updateCustInvoicePackingSlipQtyMatchProj Upgrade Script

ReleaseUpdateDB60_Cust.updateCustInvPackingSlipQtyMatchItemReq Upgrade Script

ReleaseUpdateDB60_Cust.updateDeliveryCFOPRecId_BR Upgrade Script

ReleaseUpdateDB60_Cust.updateGDL_TH_EDT_Records

ReleaseUpdateDB60_Cust.updateGDL_TH_EDT_Records Upgrade Script

ReleaseUpdateDB60_Cust.updateSalesLine Upgrade Script

ReleaseUpdateDB60_Cust.updateSalesLine_BR Upgrade Script

ReleaseUpdateDB60_Cust.updateSalesLine_IN Upgrade Script

ReleaseUpdateDB60_Cust.updateSalesPackingSlipQuantityCorrection Upgrade Script

ReleaseUpdateDB60_Invent.updateInventOriginSalesLine Upgrade Script

ReleaseUpdateDB60_Prod.updateProductionCategories Upgrade Script

ReleaseUpdateDB60_Trv.updateExpenseCategories

ReleaseUpdateDB60_Trv.updateExpenseCategories Upgrade Script

ReleaseUpdateDB41_Cust.updateDeliveryDateControlType Upgrade Script

ReleaseUpdateDB41_smm.updateActivityAssociations

ReleaseUpdateDB41_smm.updateActivityAssociations Upgrade Script

ReleaseUpdateDB41_smm.updateSmmCompetitorGroup

ReleaseUpdateDB41_smm.updateSmmCompetitorGroup Upgrade Script

ReleaseUpdateDB41_smm.updateSmmOpportunity

ReleaseUpdateDB41_smm.updateSmmOpportunity Upgrade Script

ReleaseUpdateDB41_smm.updateSmmQuotationSwotTable

ReleaseUpdateDB41_smm.updateSmmQuotationSwotTable Upgrade Script

ReleaseUpdateTransformDB40_CRM.updateSalesQuotationTable Upgrade Script

ReleaseUpdateTransformDB40_CRM.updateSalesQuotationTableDelta Upgrade Script

ReleaseUpdateTransformDB40_Cust.salesQuotTableDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Cust.salesQuotTablePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Prod.updateSalesQuotationTable Upgrade Script

ReleaseUpdateTransformDB50_CRM.updateSalesQuotationTable Upgrade Script

ReleaseUpdateTransformDB50_CRM.updateSalesQuotationTableDelta Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesQuotTableDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesQuotTablePreUpgradeProcess Upgrade Script

ReleaseUpdateDB60_Basic.updateDirPartyAddress_RU_Fields_RU Upgrade Script

ReleaseUpdateDB60_Basic.updateDirPartyAddress_RU_Fields1_RU Upgrade Script

ReleaseUpdateDB60_Basic.updateEUSalesListListCode Upgrade Script

ReleaseUpdateDB60_Cust.updateCFOPRecId_BR Upgrade Script

ReleaseUpdateDB60_Ledger.updateSalesPurchOperationType_BR Upgrade Script

ReleaseUpdateDB41_Cust.updateDeliveryDateControlType Upgrade Script

ReleaseUpdateDB41_Cust.updateMappingFields Upgrade Script

ReleaseUpdateDB41_smm.updateActivityAssociations

ReleaseUpdateDB41_smm.updateActivityAssociations Upgrade Script

ReleaseUpdateTransformDB40_CRM.updateSalesTable Upgrade Script

ReleaseUpdateTransformDB40_CRM.updateSalesTableDelta Upgrade Script

ReleaseUpdateTransformDB40_Cust.salesTableDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Cust.salesTablePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Prod.updateSalesTable Upgrade Script

ReleaseUpdateTransformDB40_Transptn.salesTableDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Transptn.salesTablePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_CRM.updateSalesTable Upgrade Script

ReleaseUpdateTransformDB50_CRM.updateSalesTableDelta Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesTableDeltaPreUpgradeProces Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesTableDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesTablePreUpgradeProces Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesTablePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Transptn.salesTableDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Transptn.salesTablePreUpgradeProcess Upgrade Script

ReleaseUpdateDB60_Basic.updateDirPartyAddress_RU_Fields_RU Upgrade Script

ReleaseUpdateDB60_Basic.updateDirPartyAddress_RU_Fields1_RU Upgrade Script

ReleaseUpdateDB60_Basic.updateEUSalesListListCode Upgrade Script

ReleaseUpdateDB60_Basic.updateShipCarrierEmailAddress Upgrade Script

ReleaseUpdateDB60_Basic.updateWMSBillOfLading_RU Upgrade Script

ReleaseUpdateDB60_Cust.updateBOs2SalesAgreements

ReleaseUpdateDB60_Cust.updateBOs2SalesAgreements Upgrade Script

ReleaseUpdateDB60_Cust.updateCFOPRecId_BR Upgrade Script

ReleaseUpdateDB60_Cust.updateFiscalDocumentTypeRecId_BR Upgrade Script

ReleaseUpdateDB60_Cust.updateSalesTable_BR Upgrade Script

ReleaseUpdateDB60_Cust.updateSalesTableSymbol Upgrade Script

ReleaseUpdateDB60_Ledger.updateInventProfile_RU Upgrade Script

ReleaseUpdateDB60_Ledger.updateSalesPurchOperationType_BR Upgrade Script

ReleaseUpdateDB60_Proj.updatePurchaseOrder Upgrade Script

ReleaseUpdateTransformDB40_Vend.purchLineDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB40_Vend.vendInvoiceTransSDLDeltaPreUpgrade Upgrade Script

ReleaseUpdateTransformDB40_Vend.vendInvoiceTransSDLPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesLineDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Cust.salesLinePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Vend.purchReqLineDeltaPreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Vend.purchReqLinePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Vend.purchReqLineUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceInfoLineDeltaPreUpgrade Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceInfoLinePreUpgrade Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceInfoLinePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceInfoTableDeltaPreUpgrade Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceInfoTablePreUpgradeProcess Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceTransSDLDeltaPreUpgrade Upgrade Script

ReleaseUpdateTransformDB50_Vend.vendInvoiceTransSDLPreUpgradeProcess Upgrade Script

ReleaseUpdateDB60_Basic.updateEmplAdv_101_RU Upgrade Script

ReleaseUpdateDB60_Cust.updateCustInvoicePackingSlipQtyMatchProj Upgrade Script

ReleaseUpdateDB60_Cust.updateCustInvPackingSlipQtyMatchItemReq Upgrade Script

ReleaseUpdateDB60_PurchReq.updateMarkupTransPurchReqLine Upgrade Script

ReleaseUpdateDB60_PurchReq.updatePurchReqTableAccountingStatus Upgrade Script

ReleaseUpdateDB60_Trv.updateSDAndSDEAndSDL Upgrade Script

ReleaseUpdateDB60_Trv.updateSourceDocumentFK Upgrade Script

ReleaseUpdateDB60_Vend.deleteDanglingSourceDocumentHeaderLine Upgrade Script

ReleaseUpdateDB60_Vend.updatePurchLine Upgrade Script

ReleaseUpdateDB60_Vend.updatePurchLineSourceDocumentLine

ReleaseUpdateDB60_Vend.updatePurchLineSourceDocumentLine Upgrade Script

ReleaseUpdateDB60_Vend.updatePurchTableSourceDocumentLine

ReleaseUpdateDB60_Vend.updatePurchTableSourceDocumentLine Upgrade Script

ReleaseUpdateDB41_Administration.updateDateTimeFields Upgrade Script

ReleaseUpdateDB41_Basic.updateActivityNumberSeqRef

ReleaseUpdateDB41_Basic.updateActivityNumberSeqRef Upgrade Script

ReleaseUpdateDB41_Basic.updateBatchDateTime Upgrade Script

ReleaseUpdateDB41_Basic.updateBatchJournal Upgrade Script

ReleaseUpdateDB41_smm.updateCustomerColumns

ReleaseUpdateDB41_smm.updateCustomerColumns Upgrade Script

ReleaseUpdateDB41_smm.updateOutlookSyncParameters

ReleaseUpdateDB41_smm.updateOutlookSyncParameters Upgrade Script

ReleaseUpdateDB41_smm.updateSalesManagementStatistics

ReleaseUpdateDB41_smm.updateSalesManagementStatistics Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDEL_DirECommunicationTypeTable

ReleaseUpdateDB60_Basic.allowDupDEL_DirECommunicationTypeTable Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDEL_DirECommunicationTypeTxt

ReleaseUpdateDB60_Basic.allowDupDEL_DirECommunicationTypeTxt Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDEL_DirOrganizationDetail

ReleaseUpdateDB60_Basic.allowDupDEL_DirOrganizationDetail Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDEL_DirPrivacyGroupTableIdx

ReleaseUpdateDB60_Basic.allowDupDEL_DirPrivacyGroupTableIdx Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDirParametersKey

ReleaseUpdateDB60_Basic.allowDupDirParametersKey Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDirPartyRelationshipTypeIdx

ReleaseUpdateDB60_Basic.allowDupDirPartyRelationshipTypeIdx Upgrade Script

ReleaseUpdateDB60_Basic.allowDupDirRelationshipTypeTableKey

ReleaseUpdateDB60_Basic.allowDupDirRelationshipTypeTableKey Upgrade Script

ReleaseUpdateDB60_Basic.allowDupsmmBusRelSectorTableKey

ReleaseUpdateDB60_Basic.allowDupsmmBusRelSectorTableKey Upgrade Script

ReleaseUpdateDB60_Basic.deleteDupDirParametersKey

ReleaseUpdateDB60_Basic.deleteDupDirParametersKey Upgrade Script

ReleaseUpdateDB60_Cat.createEcoResProductCategory Upgrade Script

ReleaseUpdateDB60_Jmg.updateDateTimeFields Upgrade Script

ReleaseUpdateDB60_Jmg.updateJmgJobIdNumberSequence Upgrade Script

ReleaseUpdateDB60_Jmg.updateJmgProdParameters Upgrade Script

ReleaseUpdateDB60_Jmg.updateJmgRegistrationSetup Upgrade Script

ReleaseUpdateDB60_PBA.allowDupPBATreeSimpelPBANodeIdx

ReleaseUpdateDB60_PBA.allowDupPBATreeSimpelPBANodeIdx Upgrade Script

ReleaseUpdateDB60_PBA.allowNoDupPBATreeSimpelPBANodeIdx

ReleaseUpdateDB60_PBA.allowNoDupPBATreeSimpelPBANodeIdx Upgrade Script

ReleaseUpdateDB60_smm.allowDupsmmBusRelRevenueParty

ReleaseUpdateDB60_smm.allowDupsmmBusRelRevenueParty Upgrade Script

ReleaseUpdateDB60_smm.allowDupsmmEmailCategoryGroupCategoryIdI

ReleaseUpdateDB60_smm.allowDupsmmEmailCategoryGroupCategoryIdI Upgrade Script

ReleaseUpdateDB60_smm.allowDupsmmQuotationCompetitorGroupParty

ReleaseUpdateDB60_smm.allowDupsmmQuotationCompetitorGroupParty Upgrade Script

ReleaseUpdateDB60_smm.allowDupsmmTMContactResponsesUniqueId

ReleaseUpdateDB60_smm.allowDupsmmTMContactResponsesUniqueId Upgrade Script

ReleaseUpdateDB60_smm.deleteDupsmmBusRelRevenueParty

ReleaseUpdateDB60_smm.deleteDupsmmBusRelRevenueParty Upgrade Script

ReleaseUpdateDB60_smm.deleteDupsmmEmailCategoryGroupCategoryId

ReleaseUpdateDB60_smm.deleteDupsmmEmailCategoryGroupCategoryId Upgrade Script

ReleaseUpdateDB60_smm.deleteDupsmmQuotationCompetitorGroupP

ReleaseUpdateDB60_smm.deleteDupsmmQuotationCompetitorGroupP Upgrade Script

ReleaseUpdateDB60_smm.deleteDupsmmTMContactResponsesUniqueId

ReleaseUpdateDB60_smm.deleteDupsmmTMContactResponsesUniqueId Upgrade Script


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: