ReleaseUpdateTransformDB40_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

ReleaseUpdateTransformDB40_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

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

LedgerBudget

Remarks

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

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

*