Thanks Greg.
After making a BAQ and looking at the results... what were these people thinking?
I think I'm just going to go the BPM route.
________________________________
From: Greg Payne <gpayne@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, April 4, 2013 1:31 PM
Subject: RE: [Vantage] Bank Account Address Info
It is stored in the PatchFld Table. Table Name Field is BankAcct, Fieldname fields are Address1, 2, 3, City, State, PostalCode. The data is in the datacharacter field.
I used the searchall sql script that Vic posted to find them.
Greg Payne
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Thursday, April 04, 2013 10:26 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Bank Account Address Info
I'm guessing those fields might be used elsewhere in the system, so if I were to change the bindings the actual address fields would not get updated ever and it might affect other parts of the system. I could do a BPM on the update method to copy the information to UD fields. This seems stupid though, I would think accessing bank information such as its address might be important, it has to be somewhere?
________________________________
From: Jordan Klassen <jordan.k@...<mailto:jordan.k%40bullydog.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Thursday, April 4, 2013 10:07 AM
Subject: RE: [Vantage] Bank Account Address Info
Ted,
The binding for the Bank Address info is:
BankAcct.Address1
BankAcct.State
Etc.
Those columns are not in the table.
I figure the best way to make that information appear in the table is to change the epibindings to customs fields in the table.
Jordan
________________________________
[Bully Dog Logo]<http://www.bullydog.com>
Jordan Klassen | Information Technology
TEL: 940-783-9914 ext: 1828
________________________________
Confidentiality Notice: The information contained in this electronic message is privileged and confidential information intended only for the use of the individual entity or entities named as recipient or recipients. If the reader is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by electronic mail and permanently delete this message from your computer system. Thank you.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ted Koch
Sent: Thursday, April 04, 2013 8:02 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Bank Account Address Info
Hi Vic,
The form is located under Financial Mgmt > AR > Setup > Bank Account. There is an address tab in 9.05.701.
The field is mapped to BankAcct.Address1, but that field is not available in BAQs, Data Dictionary, RDDs etc.
________________________________
From: Vic Drecchio <vic.drecchio@...<mailto:vic.drecchio%40swepcotube.com><mailto:vic.drecchio%40swepcotube.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 4, 2013 9:49 AM
Subject: RE: [Vantage] Bank Account Address Info
Ted, what version? Address tab? I see no address tab in 9.05 and 8.03.
Open it in customization mode and see what table/column the control is
mapped to.
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
tkoch77
Sent: Thursday, April 04, 2013 8:45 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Bank Account Address Info
Hi,
Can anyone direct me to which table contains the bank account address
information? The fields are located in Bank Account Maintenance under the
Address tab. Field help is no help.
Thanks!
-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/><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/.<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]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[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]
After making a BAQ and looking at the results... what were these people thinking?
I think I'm just going to go the BPM route.
________________________________
From: Greg Payne <gpayne@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, April 4, 2013 1:31 PM
Subject: RE: [Vantage] Bank Account Address Info
It is stored in the PatchFld Table. Table Name Field is BankAcct, Fieldname fields are Address1, 2, 3, City, State, PostalCode. The data is in the datacharacter field.
I used the searchall sql script that Vic posted to find them.
Greg Payne
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Thursday, April 04, 2013 10:26 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Bank Account Address Info
I'm guessing those fields might be used elsewhere in the system, so if I were to change the bindings the actual address fields would not get updated ever and it might affect other parts of the system. I could do a BPM on the update method to copy the information to UD fields. This seems stupid though, I would think accessing bank information such as its address might be important, it has to be somewhere?
________________________________
From: Jordan Klassen <jordan.k@...<mailto:jordan.k%40bullydog.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Thursday, April 4, 2013 10:07 AM
Subject: RE: [Vantage] Bank Account Address Info
Ted,
The binding for the Bank Address info is:
BankAcct.Address1
BankAcct.State
Etc.
Those columns are not in the table.
I figure the best way to make that information appear in the table is to change the epibindings to customs fields in the table.
Jordan
________________________________
[Bully Dog Logo]<http://www.bullydog.com>
Jordan Klassen | Information Technology
TEL: 940-783-9914 ext: 1828
________________________________
Confidentiality Notice: The information contained in this electronic message is privileged and confidential information intended only for the use of the individual entity or entities named as recipient or recipients. If the reader is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by electronic mail and permanently delete this message from your computer system. Thank you.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ted Koch
Sent: Thursday, April 04, 2013 8:02 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Bank Account Address Info
Hi Vic,
The form is located under Financial Mgmt > AR > Setup > Bank Account. There is an address tab in 9.05.701.
The field is mapped to BankAcct.Address1, but that field is not available in BAQs, Data Dictionary, RDDs etc.
________________________________
From: Vic Drecchio <vic.drecchio@...<mailto:vic.drecchio%40swepcotube.com><mailto:vic.drecchio%40swepcotube.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 4, 2013 9:49 AM
Subject: RE: [Vantage] Bank Account Address Info
Ted, what version? Address tab? I see no address tab in 9.05 and 8.03.
Open it in customization mode and see what table/column the control is
mapped to.
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
tkoch77
Sent: Thursday, April 04, 2013 8:45 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Bank Account Address Info
Hi,
Can anyone direct me to which table contains the bank account address
information? The fields are located in Bank Account Maintenance under the
Address tab. Field help is no help.
Thanks!
-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/><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/.<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]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[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]