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