Dynamics GP 2016 R2 has Table and Column Changes

image

 

Dynamics GP Support and Services team are spreading the word about changes in Dynamics GP 2016.  Sarah Purdy, Senior Technical Advisor, has written a blog highlighting some of the table changes and column changes in GP 2016 R2.  You can reference her blog at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/21/table-and-column-changes-in-microsoft-dynamics-gp-2016-r2-and-year-end-update.

Here is the information from Sarah’s blog:


New tables that were added to Microsoft Dynamics GP 2016 R2

Table Physical Name Table Technical Name
System Tables

ADH00106                                                       ADH_Favorite_LookupAssignment
ASIEXP101                                                       ASI_FavoritePassword_SETP

Company Tables

APR_DIA_Mandatory_HIST                          
CM30200                                                        CM_Transaction_History
CM30300                                                        CM_Receipt_History
UPR30700                                                       uprEmployeeHistory

Data Type Change on an Existing Column:

The data type changed from ‘STR17_LBAU’ to ‘STR30_LBAU’ for the PAerdocnumber column in the following tables:
PA10502
PA30504
PA10504
PA30500
PA30501
PA30503
PA10500
PA10501
PDK10500
PTE10500
PTE30500

New columns added to existing tables (SYSTEM DB):

ASIEXP101 —   CMPANYID, SmartListPassword
SY40800 —       PowerBIWebClientID, PowerBIAppKey

New columns added to existing tables (COMPANY DB):

CM20200 –     VNDCHKNM
FA49900 —      IncludeTaxInAcqustCost
FA01300 —      IncludeTaxInAcqustCost, ORTAXAMT
IVC10500 —     TXDTLPCTAMT
SOP10105 —    TXDTLPCTAMT
RM30601 —     TXDTLPCTAMT
RM10601 —     TXDTLPCTAMT
FA01400 —      IncludeTaxInAcqustCost
FA01401 —      IncludeTaxInAcqustCost
FA01100 —      IncludeTaxInAcqustCost
FA00100 —      IncludeTaxInAcqustCost
POP10310 —    OriginatingPPTaxAmount
POP30310 —    OriginatingPPTaxAmount
APR_PIP40100 —         ACTINDX, ADRSCODE
PTO00101 —    USERID
Check back to the  Microsoft Dynamics GP 2016 R2 and Year-End Update Upgrade Blog Series Schedule page to review our blog posts related to Upgrading Microsoft Dynamics GP and other helpful resource links.

Thank you, Sarah, for letting us know about the table and column changes.

Advertisements