Compartilhar via


ReleaseUpdateTransformDB40_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

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

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

LedgerBudget

Remarks

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

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

*