ReleaseUpdateTransformDB50_Ledger.ledgerBudgetDeltaPreProcessing 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 |
ledgerBudgetDeltaPreProcessing |
Description |
Transforms data from the LedgerBudget table to the BudgetTransactionHeader and BudgetTransactionLine tables. |
Script Type |
Preprocessing 60: Delta Preprocessing 60: Single user |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
|---|
General ledger |
Affected Tables |
|---|
LedgerBudget |
Remarks
This upgrade inserts records into the BudgetTransactionHeader and BudgetTransactionLine tables from the LedgerBudget table, updates existing records in the BudgetTransactionHeader and BudgetTransactionLine tables, and deletes records from the BudgetTransactionHeader and BudgetTransactionLine tables that no longer have an associated record from the LedgerBudget table.
Data Migration Section
From Table: LedgerBudget |
To Table: BudgetTransactionHeader |
|---|---|
RecId |
TransactionNumber |
ModelNum |
BudgetModelId |
StartDate |
Date |
Active |
TransactionStatus |
From Table: LedgerBudget |
To Table: BudgetTransactionLine |
|---|---|
StartDate |
Date |
Currency |
TransactionCurrency |
Qty |
Quantity |
Price |
Price |
Amount |
TransactionCurrencyAmount |
AmountMST |
AccountingCurrencyAmount |
Cov |
IncludeInCashFlowForecast |
TaxGroup |
TaxGroup |
Comment |
Comment |
ProjTransId |
ProjTransBudgetTransId |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
BudgetTransactionHeader |
||
BudgetTransactionLine |
Deleted Tables or Fields
Table |
Field |
|---|---|
LedgerBudget |