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