ReleaseUpdateTransformDB40_Ledger.ledgerTransPreProcessing Upgrade Script [AX 2012]
Updated: June 13, 2011
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 |
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).