ReleaseUpdateDB60_Proj.updateProjCostTrans 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 |
updateProjCostTrans |
|
Description |
Populates the new transaction cost and sales amount tables. |
A project transaction can now support multiple cost and sales amounts. For example, a project transaction can be billed to multiple customers. To support multiple cost and sales amounts, another level of tables were created. For the expense transaction type, the ProjCostTransCost and ProjCostTransSale tables are the new tables that were added.
|
From Table: ProjCostTrans |
To Table: ProjCostTransCost |
|---|---|
|
TransId |
TransId |
|
TransDate |
LedgerTransdate |
|
DEL_CostPrice |
CostPrice |
|
TotalCostAmountCur |
LineAmount |
|
DEL_LedgerStatusCost |
LedgerStatusCost |
|
DEL_TransStatus |
TransStatus |
|
DEL_WIPPeriod |
WIPPeriod |
|
DEL_CostAmountLedger |
CostAmountLedger |
|
DEL_CostPriceCurrency |
CostPriceCurrency |
|
DefaultDimension |
DefaultDimension |
|
From Table: ProjCostTrans |
To Table: ProjCostTransSale |
|---|---|
|
TransId |
TransId |
|
TransDate |
LedgerTransdate |
|
DEL_SalesPrice |
SalesPrice |
|
TotalSalesAmountCur |
LineAmount |
|
DEL_LedgerSalesPosted |
LedgerSalesPosted |
|
DEL_LedgerSalesAmount |
LedgerSalesAmount |
|
DEL_TransStatus |
TransStatus |
|
DefaultDimension |
DefaultDimension |
|
Table |
Field |
|---|---|
|
ProjCostTrans |
DEL_CostPrice |
|
ProjCostTrans |
DEL_LedgerStatusCost |
|
ProjCostTrans |
DEL_WIPPeriod |
|
ProjCostTrans |
DEL_CostAmountLedger |
|
ProjCostTrans |
DEL_CostPriceCurrency |
|
ProjCostTrans |
DEL_SalesPrice |
|
ProjCostTrans |
DEL_LedgerSalesPosted |
|
ProjCostTrans |
DEL_LedgerSalesAmount |
|
ProjCostTrans |
DEL_TransStatus |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).