Skip to main content
Answer

DAC - ARRegisterAlias Access

  • October 10, 2022
  • 6 replies
  • 125 views

ketiller
Jr Varsity III
Forum|alt.badge.img

Hi, 

 

I was wondering if it’s possible to access the DAC “ARRegiserAlias”. I can preview the Source Data but cannot access the table when creating a GI. 

 

Thank you,

KT

Best answer by Kandy Beatty

HI @ketiller 

I created this GI that you could work off:

 

You need to use various tables to find what you are exactly looking for. 

6 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • October 10, 2022

Hello KT, Where are you seeing ARRegisterAlias?  Please post a screen shot of what you are seeing, as more information is needed.

Sometimes “Alias” names are used for tables/DACs when the same table needs to be joined twice, such as in a report. Perhaps the alias DAC is a copy of AR Register. Maybe.

 

What fields do you need in your GI, that you see in ARRegisterAlias but not in ARRegister?

Laura


ketiller
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • October 11, 2022

Hi @laura01

Please see the screenshot below, This is from the Payments and Applications form. I would like to pull in information from the “Application History” detail section, that is where I found the ARRRegisterAlias table.

Thank you,

 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • October 11, 2022

Hi @laura01

Please see the screenshot below, This is from the Payments and Applications form. I would like to pull in information from the “Application History” detail section, that is where I found the ARRRegisterAlias table.

Thank you,

 

Hi @ketiller 

What field specifically are you looking for?


ketiller
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • October 11, 2022

Hi, @kbeatty21 I want to add the Description, Due Date, and Customer Order Nbr (not pictured) to an existing GI.

 

Thank you,

Kage


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • Answer
  • October 11, 2022

HI @ketiller 

I created this GI that you could work off:

 

You need to use various tables to find what you are exactly looking for. 


ketiller
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • October 11, 2022

Hi, @kbeatty21 

Thank you for the GI, I will review and test it in my environment. 

Thank you,

Kage