ReleaseUpdateDB60_Proj.updateProjOnAccTrans 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 |
updateProjOnAccTrans |
Description |
Populates the new transaction cost and sales amount tables. |
Affected Modules and Tables
Affected Modules |
|---|
Project |
Affected Tables |
|---|
ProjOnAccTrans |
ProjOnAccTransSale |
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 on-account transaction type, the ProjOnAccTransSale table is the new table that was added.
Data Migration Section
From Table: ProjOnAccTrans |
To Table: ProjOnAccTransSale |
|---|---|
TransId |
TransId |
TransDate |
LedgerTransdate |
DEL_Amount |
Amount |
DEL_WIPPeriod |
WIPPeriod |
DEL_LedgerSalesAmount |
LedgerSalesAmount |
DEL_TransStatus |
TransStatus |
DefaultDimension |
DefaultDimension |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
ProjOnAccTrans |
TotalSalesAmountCur |
ProjTotalSalesAmount |
ProjOnAccTransSale |
Deleted Tables or Fields
Table |
Field |
|---|---|
ProjOnAccTrans |
DEL_Amount |
ProjOnAccTrans |
DEL_WIPPeriod |
ProjOnAccTrans |
DEL_LedgerSalesAmount |
ProjOnAccTrans |
DEL_TransStatus |