ReleaseUpdateTransformDB40_Ledger.ledgerBudgetDeltaPreProcessing Upgrade Script [AX 2012]
Updated: June 10, 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 |
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 |
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.
|
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 |
|
Cov |
IncludeInCashFlowForecast |
|
TaxGroup |
TaxGroup |
|
Comment |
Comment |
|
ProjTransId |
ProjTransBudgetTransId |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).