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 |