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