ReleaseUpdateTransformDB40_LedgerTrx.ledgerTransGeneralJournalAcctEntry 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_LedgerTrx |
Method |
ledgerTransGeneralJournalAcctEntry |
Description |
Handles the live pre-processing population of records in the GeneralJournalAccountEntry table based on existing records in the LedgerTrans table. |
Script Type |
Preprocessing 60: Live Preprocessing 60: Delta |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 |
Affected Modules and Tables
Affected Modules |
|---|
General ledger |
Affected Tables |
|---|
LedgerTrans |
GeneralJournalAccountEntry |
GeneralJournalEntry |
Remarks
This is a helper method called by the main live preprocessing script and delta script for the LedgerTrans table. The GeneralJournalAccountEntry table will contain one record for every record found in the LedgerTrans table.
Data Migration Section
From Table: LedgerTrans |
To Table: GeneralJournalAccountEntry |
|---|---|
AllocateLevel |
AllocationLevel |
Correct |
IsCorrection |
Crediting |
IsCredit |
DocumentDate |
DocumentDate |
DocumentNum |
DocumentNumber |
AmountMST |
FunctionalCurrencyAmount |
PaymReference |
PaymentReference |
AmountCur |
TransactionCurrencyAmount |
CurrencyCode |
TransactionCurrencyCode |
TransType |
TransactionType |
Posting |
PostingType |
RecId |
DEL_LedgerTransRefRecId |
DataAreaId |
DEL_DataAreaId |
AccountNum/Dimension |
LedgerDimension |
AmountMSTSecond |
ReportingCurrencyAmount |
From Table: GeneralJournalEntry |
To Table: GeneralJournalAccountEntry |
|---|---|
RecId |
GeneralJournalEntry |