Share via


ReleaseUpdateDB60_Proj.updateProjRevenueTrans 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

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

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