ReleaseUpdateDB60_Basic.updateNumberSequenceTableReference Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_Basic

Method

updateNumberSequenceTableReference

Description

Updates references to the NumberSequenceTable table as a result of the primary key being changed for that table. Constructs a number sequence for each extended data type.

Affected Modules and Tables

Affected Modules

Basic

Project

Affected Tables

ProjJournalName

ProjJournalTable

ProjInvoiceJour

NumberSequenceTable

NumberSequenceScope

Data Migration Section

From Table: NumberSequenceTable

To Table: ProjJournalName

RecId

VoucherNumberSequenceTable

From Table: NumberSequenceTable

To Table: ProjJournalTable

RecId

VoucherNumberSequenceTable

From Table: NumberSequenceTable

To Table: ProjInvoiceJour

RecId

VoucherNumberSequenceTable

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

ProjJournalName

VoucherNumberSequenceTable

ProjVoucherNumberSequenceTable

ProjJournalTable

VoucherNumberSequenceTable

ProjVoucherNumberSequenceTable

ProjInvoiceJour

VoucherNumberSequenceTable

ProjVoucherNumberSequenceTable

Deleted Tables or Fields

Table

Field

ProjJournalName

DEL_VoucherSeqId

ProjJournalTable

DEL_VoucherSeqId

ProjInvoiceJour

DEL_VoucherSequenceCode