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

Affected Modules and Tables

Affected Modules
Project

Affected Tables
ProjOnAccTrans
ProjOnAccTransSale

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 on-account transaction type, the ProjOnAccTransSale table is the new table that was added.

Data Migration Section

From Table: ProjOnAccTrans	To Table: ProjOnAccTransSale
TransId	TransId
TransDate	LedgerTransdate
DEL_Amount	Amount
DEL_WIPPeriod	WIPPeriod
DEL_LedgerSalesAmount	LedgerSalesAmount
DEL_TransStatus	TransStatus
DefaultDimension	DefaultDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
ProjOnAccTrans	TotalSalesAmountCur	ProjTotalSalesAmount
ProjOnAccTransSale

Deleted Tables or Fields

Table	Field
ProjOnAccTrans	DEL_Amount
ProjOnAccTrans	DEL_WIPPeriod
ProjOnAccTrans	DEL_LedgerSalesAmount
ProjOnAccTrans	DEL_TransStatus