ReleaseUpdateTransformDB50_Ledger.ledgerBudgetPreProcessing 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 |
ledgerBudgetPreProcessing |
Description |
Transforms data from the LedgerBudget table to the BudgetTransactionHeader and BudgetTransactionLine 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 |
|---|
LedgerBudget |
Remarks
This upgrade inserts records into the BudgetTransactionHeader and BudgetTransactionLine tables 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 |