Compartilhar via


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