ReleaseUpdateTransformDB50_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 |
ReleaseUpdateTransformDB50_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 Microsoft Dynamics AX 2009 |
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 |