The trace log, and for that matter, the fields the customization point to,
are "datasets". These usually correspond to tables, but as you noticed,
they're not always a perfect match.
For example, if you do a GetByID in Order Entry, that method returns a Sales
Order dataset. The OrderHed table has the CustNum field, and to maintain
database normalization, if you want the CustID or Customer Name, you'd have
to go to the Customer table to get those fields. However, the GetByID may
return those fields as well in the dataset. They are not part of the
OrderHed table, but they are a field within the OrderHed dataset.
As far as rules for where to find them, I haven't found anything other than
detective work, lots of experience, and boards such as this.
HTH,
Kevin Simon
SimsTrak Consulting
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Saturday, January 15, 2011 11:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Tracing Options - Log File
The tracer is usually a nice fast way to see all the tables/fields involved
after you save a record.
But, every once in while, the trace log will lists a field that really
doesn't exist.
I'm wondering what is going on in these cases?
[Non-text portions of this message have been removed]
are "datasets". These usually correspond to tables, but as you noticed,
they're not always a perfect match.
For example, if you do a GetByID in Order Entry, that method returns a Sales
Order dataset. The OrderHed table has the CustNum field, and to maintain
database normalization, if you want the CustID or Customer Name, you'd have
to go to the Customer table to get those fields. However, the GetByID may
return those fields as well in the dataset. They are not part of the
OrderHed table, but they are a field within the OrderHed dataset.
As far as rules for where to find them, I haven't found anything other than
detective work, lots of experience, and boards such as this.
HTH,
Kevin Simon
SimsTrak Consulting
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Saturday, January 15, 2011 11:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Tracing Options - Log File
>Thanks but not really what I meant.
> Data dictionary viewer
The tracer is usually a nice fast way to see all the tables/fields involved
after you save a record.
But, every once in while, the trace log will lists a field that really
doesn't exist.
I'm wondering what is going on in these cases?
[Non-text portions of this message have been removed]