Dolores,
Do you have the CRM module or customer connect? Are you in other version
other than 6.1? If no to these questions, the fields are after the user
defined and blank characters in the customer table. Below is a picture
of the customer table with data structure.
Good luck!
Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.
2044 N. Dominick
Chicago, IL 60614
Phone: 773-871-9643 Fax: 773-871-6675
________________________________
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Hernandez, Dolores
Sent: Monday, October 22, 2007 2:58 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Bill to address
Mario, I looked at that table and the data is not there.
________________________________
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mario Aguirre
Sent: Monday, October 22, 2007 12:12 PM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Bill to address
Dolores,
In 6.1, the bill to address is in the customer table under the fields
BTName, BTCity, etc. Hope that helps.
Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.
________________________________
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Hernandez, Dolores
Sent: Monday, October 22, 2007 2:01 PM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Bill to address
Ok Robert, stupid question, but where is this options menu? The only
options menu I see is the one on the main screen and it only allows me
to change id, plant, company, etc...
________________________________
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Robert Brown
Sent: Monday, October 22, 2007 11:43 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Bill to address
Under the Options menu, select Developer Mode, load the Customer app,
select Customization from the tools menu, and then click on the field
you are interested in. The table.field name will be displayed.
----- Original Message ----
From: "Hernandez, Dolores" <
dhernandez@...
<mailto:dhernandez%40energycranes.com>
<mailto:dhernandez%40energycranes.com>
<mailto:dhernandez%40energycranes.com>
<mailto:dhernandez%40energycranes.com> >
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Monday, October 22, 2007 2:23:36 PM
Subject: [Vantage] Bill to address
Can anyone please tell me in which table I can find the Bill To Address
that I see when I go into customer Maintenance and click on "Billing"
and then on "Bill To". I looked at the customer table and see that
there is a "BTAddress" field there, but no data, so it must be else
where; but where?
Thanks,
____________ _________ _________ _________ _________ __
Dolores Hernandez
Software Analyst
Energy Cranes, LLC
6707 Northwind Drive
Houston, Texas 77041
Tel: 713-896-5178
Fax: 713-896-5142
Email: dhernandez@energycr anes.com
[Non-text portions of this message have been removed]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <
http://mail.yahoo.com> <
http://mail.yahoo.com
<
http://mail.yahoo.com> > <
http://mail.yahoo.com <
http://mail.yahoo.com>
<
http://mail.yahoo.com <
http://mail.yahoo.com> > > <
http://mail.yahoo.com <
http://mail.yahoo.com> <
http://mail.yahoo.com
<
http://mail.yahoo.com> >
<
http://mail.yahoo.com <
http://mail.yahoo.com> <
http://mail.yahoo.com
<
http://mail.yahoo.com> > > >
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]