Extended UD Table Fields

Yahoo Archive
1
Got it. Thanks guys!



________________________________
From: Stephen Edginton <stephene@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, August 15, 2012 8:44 AM
Subject: RE: [Vantage] Extended UD Table Fields

That is how all Extended UD Tables work
Table_UD.ForeignSysRowID = Table.SysRowID


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: 15 August 2012 13:17
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Extended UD Table Fields



I didn't even realize they had the Show User Defined Tables button in the phrase build. I brought in the Project_UD table and it automatically created a link. Does this seem right?

Project_UD.ForeignSysRowID is linked to Project.SysRowID

________________________________
From: Jose Gomez <jose@...<mailto:jose%40josecgomez.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, August 15, 2012 8:08 AM
Subject: Re: [Vantage] Extended UD Table Fields

They are linked through the Primary Key of the Parent Table. Do a BAQ
against this table and you'll see its Company , PrimaryKey

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Wed, Aug 15, 2012 at 8:03 AM, tkoch77 <tkoch77@...<mailto:tkoch77%40yahoo.com>> wrote:

> **
>
>
> In 9.05 I used extended UD table maintenance to create more fields for the
> project table. Using ABL code how do you update one of these fields? When
> writing an ABL Action the new UD fields don't appear as part of the Project
> table, but instead in the Project_UD table. I'm not seeing how this
> project_ud table is linked to the project table?
>
> Thanks for any help,
>
> Ted
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
2
In 9.05 I used extended UD table maintenance to create more fields for the project table. Using ABL code how do you update one of these fields? When writing an ABL Action the new UD fields don't appear as part of the Project table, but instead in the Project_UD table. I'm not seeing how this project_ud table is linked to the project table?

Thanks for any help,

Ted
3
They are linked through the Primary Key of the Parent Table. Do a BAQ
against this table and you'll see its Company , PrimaryKey

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Wed, Aug 15, 2012 at 8:03 AM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> In 9.05 I used extended UD table maintenance to create more fields for the
> project table. Using ABL code how do you update one of these fields? When
> writing an ABL Action the new UD fields don't appear as part of the Project
> table, but instead in the Project_UD table. I'm not seeing how this
> project_ud table is linked to the project table?
>
> Thanks for any help,
>
> Ted
>
>
>


[Non-text portions of this message have been removed]
4
I didn't even realize they had the Show User Defined Tables button in the phrase build. I brought in the Project_UD table and it automatically created a link. Does this seem right?


Project_UD.ForeignSysRowID is linked to Project.SysRowID



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 15, 2012 8:08 AM
Subject: Re: [Vantage] Extended UD Table Fields

They are linked through the Primary Key of the Parent Table. Do a BAQ
against this table and you'll see its Company , PrimaryKey

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Wed, Aug 15, 2012 at 8:03 AM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> In 9.05 I used extended UD table maintenance to create more fields for the
> project table. Using ABL code how do you update one of these fields? When
> writing an ABL Action the new UD fields don't appear as part of the Project
> table, but instead in the Project_UD table. I'm not seeing how this
> project_ud table is linked to the project table?
>
> Thanks for any help,
>
> Ted
>
>Â
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
5
That is how all Extended UD Tables work
Table_UD.ForeignSysRowID = Table.SysRowID


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: 15 August 2012 13:17
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Extended UD Table Fields



I didn't even realize they had the Show User Defined Tables button in the phrase build. I brought in the Project_UD table and it automatically created a link. Does this seem right?

Project_UD.ForeignSysRowID is linked to Project.SysRowID

________________________________
From: Jose Gomez <jose@...<mailto:jose%40josecgomez.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, August 15, 2012 8:08 AM
Subject: Re: [Vantage] Extended UD Table Fields

They are linked through the Primary Key of the Parent Table. Do a BAQ
against this table and you'll see its Company , PrimaryKey

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Wed, Aug 15, 2012 at 8:03 AM, tkoch77 <tkoch77@...<mailto:tkoch77%40yahoo.com>> wrote:

> **
>
>
> In 9.05 I used extended UD table maintenance to create more fields for the
> project table. Using ABL code how do you update one of these fields? When
> writing an ABL Action the new UD fields don't appear as part of the Project
> table, but instead in the Project_UD table. I'm not seeing how this
> project_ud table is linked to the project table?
>
> Thanks for any help,
>
> Ted
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]