ReleaseUpdateDB60_Proj.updateProjRevenueTrans Upgrade Script [AX 2012]

Updated: July 23, 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

updateProjRevenueTrans

Description

Populates the new transaction cost and sales amount tables.

Affected Modules

Project

Affected Tables

ProjRevenueTrans

ProjRevenueTransSale

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.

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

Table

Field

Extended Data Type

-or- Base Enum

ProjRevenueTrans

TotalSalesAmountCur

ProjTotalSalesAmount

ProjRevenueTransSale

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


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

Community Additions

ADD
Show: