ODBC customer ID

Question

I am making an ODBC connection from UPS WorldShip to BusinessWorks 2013. I am able to map most of the WorldShip values to BusinessWorks values in the ARInvoice table. I want to link the BW customer ID or number to UPS. 
 
 1. Does one of the values in the ARInvoice table map to the BW Customer ID? If so, which one? None looked obvious to us. 
 2. If not, within WorldShip we can create a link between two foreign tables (Businessworks database tables) and then grab the customer ID from a different BW table. If #1 is a no, what fields would we need to link here? 
 
 Matthew

Vince Settipane · Accepted Answer

ARInvoices connects to ARCustomer via ARInvoice.FKARCustomer & ARCustomer.SKARCustomer 
 Tables for fields can be found here 
 na.sage.com/.../resources 
 then under Product & Information --> Tables and Fields 
 
 EDIT 2017 
 See KB 19339

Coleen Graber · Answer

Heather- We have an article in our Knowledge Base for Tables and Fields. Open the BWGFormats.pdf file in Attachments in the Knowledge Base article #19339 "Where do I find the table and field names?" Note: The file structure has not changed since 2013, so the article does indicate 2013 File Formats. 
Thanks, 
Coleen

Coleen Graber · Answer

Heather- I am sorry you are having issues access the File Formats document. You can access the File Formats by going to resolution #19339 I mentioned above and opening the .pdf attachement. In that article, if you scroll all the way to the bottom, there is an ATTACHMENTS section. In there is a .pdf file you can open for the file formats (BWGFormats.pdf). The steps in the article show how to get to the file formats within the Sage BusinessWorks program. I tested those steps and they are working successfully for me. To verify you were at the correct Sage Businessworks Home page, in BusinessWorks go to View and make sure "Viewer" is selected. If selected that will dispay the Sage Businessworks Home page in the center of your Sage BusinessWorks screen. You should see "Welcome" , "All About Sage BusinessWorks", etc... Under the All About Sage BusinessWorks, you should see "What's New?", "Community" and then "Sage BusinessWorks News". If you select "Sage BusinessWorks News", that will open you to a Resources screen. In there you will see an optionfor "Features sheets". Hit the plus sign (+) to expand it. Once expended, the 6ths item down is "File Formats". That will open the File Formats document. Note: If you are not on a current version (v2017), your links may not be pointing to the correct location. Let me know if you are still unable to open the File Formats. 
Thanks, 
Coleen

Sage BusinessWorks

ODBC customer ID

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING