ReleaseUpdateDB60_Proj.updateProjItemTrans 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	updateProjItemTrans
Description	Populates the new transaction cost and sales amount tables.

Affected Modules and Tables

Affected Modules
Project

Affected Tables
ProjItemTrans
ProjItemTransCost
ProjItemTransSale

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 was created. For the item transaction type, the ProjItemTransCost and ProjItemTransSale tables are the new tables that were added.

Data Migration Section

From Table: ProjItemTrans	To Table: ProjItemTransCost
DEL_TransStatus	TransStatus
DefaultDimension	DefaultDimension

From Table: ProjItemTrans	To Table: ProjItemTransSale
ProjTransId	ProjTransId
TransDate	LedgerTransdate
DEL_SalesPrice	SalesPrice
DEL_LedgerSalesPosted	LedgerSalesPosted
DEL_LedgerSalesAmount	LedgerSalesAmount
DEL_TransStatus	TransStatus
DEL_LineAmount	LineAmount
DefaultDimension	DefaultDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
ProjItemTrans	TotalCostAmountCur	ProjTotalCostAmount
ProjItemTrans	TotalSalesAmountCur	ProjTotalSalesAmount
ProjItemTransCost
ProjItemTransSale

Deleted Tables or Fields

Table	Field
ProjItemTrans	DEL_SalesPrice
ProjItemTrans	DEL_LedgerSalesPosted
ProjItemTrans	DEL_LedgerSalesAmount
ProjItemTrans	DEL_LineAmount
ProjItemTrans	DEL_TransStatus