Condividi tramite


ReleaseUpdateTransformDB40_Ledger.ledgerTransPreProcessing 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

ReleaseUpdateTransformDB40_Ledger

Method

ledgerTransPreProcessing

Description

Creates and calls the stored procedures for the transformation of the LedgerTrans table to the GeneralJournalHeader, LedgerEntryJournal, LedgerEntryReference, GeneralJournalLine, LedgerEntry, and LedgerEntryJournalizing tables.

Script Type

Preprocessing 60: Live

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

LedgerTrans

GeneralJournalHeader

LedgerEntryJournal

LedgerEntryReference

GeneralJournalLine

LedgerEntry

LedgerEntryJournalizing

Remarks

This method calls various other methods that perform the actual transformations.

Data Migration Section

From Table: LedgerTrans

To Table: GeneralJournalHeader

(GeneratedValue)

LedgerCategory

(GeneratedValue)

LegalEntity

From Table: LedgerTrans

To Table: LedgerEntryJournal

JournalNum

JournalNumber

From Table: LedgerTrans

To Table: LedgerEntryReference

(GeneratedValue)

LedgerEntryJournal

Voucher

ReferenceNumber

TransDate

AccountingDate

AcknowledgementDate

AcknowledgementDate

LedgerPostingJournalID

LedgerPostingJournal

PeriodCode

PeriodCode

JournalNum

JournalNumber

From Table: LedgerTrans

To Table: GeneralJournalLine

(GeneratedValue)

GeneralJournalHeader

RecID

LedgerTrans

(GeneratedValue)

LedgerDimension

AllocateLevel

AllocationLevel

Correct

IsCorrection

Crediting

IsCredit

DocumentDate

DocumentDate

DocumentNum

DocumentNumber

AmountMST

FunctionalCurrencyAmount

PaymReference

PaymentReference

AmountMSTSecond

SecondaryCurrencyAmount

AmountCur

TransactionCurrencyAmount

CurrencyCode

TransactionCurrencyCode

DataAreaID

TransactionCurrencyDataAreaID

TransType

TransactionType

Qty

Quantity

Posting

PostingType

From Table: LedgerTrans

To Table: LedgerEntry

(GeneratedValue)

LedgerEntryReference

(GeneratedValue)

GeneralJournalLine

CompanyBankAccountID

CompanyBankAccount

FurtherPostingType

LedgerTransFurtherPosting

PayMode

PaymentMode

Qty

Quantity

ThirdPartyBankAccountID

ThirdPartyBankAccount

Txt

Text

From Table: LedgerTrans

To Table: LedgerEntryJournalizing

JournalizeNum

Journal

JournalizeSeqNum

SequenceNumber

(GeneratedValue)

LedgerEntry