ReleaseUpdateDB60_Proj.updateProjEmplTrans Upgrade Script [AX 2012]

Updated: July 22, 2010

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

updateProjEmplTrans

Description

Populates the new transaction cost and sales amount tables.

Affected Modules

Project

Affected Tables

ProjEmplTrans

ProjEmplTransCost

ProjEmplTransSale

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 were created. For the hour transaction type, the ProjEmplTransCost and ProjEmplTransSale tables are the new tables that were added.

From Table: ProjEmplTrans

To Table: ProjEmplTransCost

TransId

TransId

TransDate

LedgerTransdate

DEL_CostPrice

CostPrice

TotalCostAmountCur

LineAmount

DEL_LedgerStatusCost

LedgerStatusCost

DEL_TransStatus

TransStatus

DEL_WIPPeriod

WIPPeriod

DefaultDimension

DefaultDimension

TotalCostAmountCur

LedgerCostAmountMST

From Table: ProjEmplTrans

To Table: ProjEmplTransSale

TransId

TransId

TransDate

LedgerTransdate

DEL_SalesPrice

SalesPrice

TotalSalesAmountCur

LineAmount

DEL_LedgerSalesPosted

LedgerSalesPosted

DEL_LedgerSalesAmount

LedgerSalesAmount

DEL_TransStatus

TransStatus

DefaultDimension

DefaultDimension

Table

Field

Extended Data Type

-or- Base Enum

ProjEmplTrans

TotalCostAmountCur

ProjTotalCostAmount

ProjEmplTrans

TotalSalesAmountCur

ProjTotalSalesAmount

ProjEmplTransCost

ProjEmplTransSale

Table

Field

ProjEmplTrans

DEL_CostPrice

ProjEmplTrans

DEL_LedgerStatusCost

ProjEmplTrans

DEL_WIPPeriod

ProjEmplTrans

DEL_SalesPrice

ProjEmplTrans

DEL_LedgerSalesPosted

ProjEmplTrans

DEL_LedgerSalesAmount

ProjEmplTrans

DEL_TransStatus


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: