ReleaseUpdateDB60_Proj.updateProjRevenueTrans Upgrade Script

Article
05/18/2015

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

Affected Modules and Tables

Affected Modules
Project

Affected Tables
ProjRevenueTrans
ProjRevenueTransSale

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 fee transaction type, the ProjRevenueTransSale is the new table that was added.

Data Migration Section

From Table: ProjRevenueTrans	To Table: ProjRevenueTransSale
TransId	TransId
TransDate	LedgerTransdate
DEL_SalesPrice	SalesPrice
TotalSalesAmountCur	LineAmount
DEL_LedgerSalesPosted	LedgerSalesPosted
DEL_LedgerSalesAmount	LedgerSalesAmount
DEL_TransStatus	TransStatus
DEL_WIPPeriod	WIPPeriod
DEL_WIPType	WIPType
DEL_ControlVersion	ControlVersion
DEL_ControlId	ControlId
DefaultDimension	DefaultDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
ProjRevenueTrans	TotalSalesAmountCur	ProjTotalSalesAmount
ProjRevenueTransSale

ProjRevenueTrans

TotalSalesAmountCur

ProjTotalSalesAmount

ProjRevenueTransSale

Deleted Tables or Fields

Table	Field
ProjRevenueTrans	DEL_SalesPrice
ProjRevenueTrans	DEL_LedgerSalesPosted
ProjRevenueTrans	DEL_LedgerSalesAmount
ProjRevenueTrans	DEL_TransStatus
ProjRevenueTrans	DEL_WIPPeriod
ProjRevenueTrans	DEL_WIPType
ProjRevenueTrans	DEL_ControlVersion
ProjRevenueTrans	DEL_ControlId

Share via