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

updateProjEmplTrans

Description

Populates the new transaction cost and sales amount tables.

Affected Modules and Tables

Affected Modules

Project

Affected Tables

ProjEmplTrans

ProjEmplTransCost

ProjEmplTransSale

Remarks

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

Data Migration Section

From Table: ProjEmplTrans

To Table: ProjEmplTransCost

TransId

TransId

TransDate

LedgerTransdate

DEL_CostPrice

CostPrice

TotalCostAmountCur

LineAmount

DEL_LedgerStatusCost

LedgerStatusCost

DEL_TransStatus

TransStatus

DEL_WIPPeriod

WIPPeriod

DefaultDimension

DefaultDimension

TotalCostAmountCur

LedgerCostAmountMST

From Table: ProjEmplTrans

To Table: ProjEmplTransSale

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

ProjEmplTrans

TotalCostAmountCur

ProjTotalCostAmount

ProjEmplTrans

TotalSalesAmountCur

ProjTotalSalesAmount

ProjEmplTransCost

ProjEmplTransSale

Deleted Tables or Fields

Table

Field

ProjEmplTrans

DEL_CostPrice

ProjEmplTrans

DEL_LedgerStatusCost

ProjEmplTrans

DEL_WIPPeriod

ProjEmplTrans

DEL_SalesPrice

ProjEmplTrans

DEL_LedgerSalesPosted

ProjEmplTrans

DEL_LedgerSalesAmount

ProjEmplTrans

DEL_TransStatus