Compartir a través de


ReleaseUpdateDB60_Proj.updateProjCostTrans 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

ReleaseUpdateDB60_Proj

Method

updateProjCostTrans

Description

Populates the new transaction cost and sales amount tables.

Affected Modules and Tables

Affected Modules

Project

Affected Tables

ProjCostTrans

ProjCostTransCost

ProjCostTransSale

Remarks

A project transaction can now support multiple cost and sales amounts. For example, a project transaction can be billed to multiple customers. To support multiple cost and sales amounts, another level of tables were created. For the expense transaction type, the ProjCostTransCost and ProjCostTransSale tables are the new tables that were added.

Data Migration Section

From Table: ProjCostTrans

To Table: ProjCostTransCost

TransId

TransId

TransDate

LedgerTransdate

DEL_CostPrice

CostPrice

TotalCostAmountCur

LineAmount

DEL_LedgerStatusCost

LedgerStatusCost

DEL_TransStatus

TransStatus

DEL_WIPPeriod

WIPPeriod

DEL_CostAmountLedger

CostAmountLedger

DEL_CostPriceCurrency

CostPriceCurrency

DefaultDimension

DefaultDimension

From Table: ProjCostTrans

To Table: ProjCostTransSale

TransId

TransId

TransDate

LedgerTransdate

DEL_SalesPrice

SalesPrice

TotalSalesAmountCur

LineAmount

DEL_LedgerSalesPosted

LedgerSalesPosted

DEL_LedgerSalesAmount

LedgerSalesAmount

DEL_TransStatus

TransStatus

DefaultDimension

DefaultDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

ProjCostTrans

TotalCostAmountCur

ProjTotalCostAmount

ProjCostTrans

TotalSalesAmountCur

ProjTotalSalesAmount

ProjCostTransCost

ProjCostTransSale

Deleted Tables or Fields

Table

Field

ProjCostTrans

DEL_CostPrice

ProjCostTrans

DEL_LedgerStatusCost

ProjCostTrans

DEL_WIPPeriod

ProjCostTrans

DEL_CostAmountLedger

ProjCostTrans

DEL_CostPriceCurrency

ProjCostTrans

DEL_SalesPrice

ProjCostTrans

DEL_LedgerSalesPosted

ProjCostTrans

DEL_LedgerSalesAmount

ProjCostTrans

DEL_TransStatus