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

This link (na.sage.com/.../resources) no longer lists Tables and Fields under Product Information. Does anyone have a current link?

If you can't find it. Private message me your email address, I keep on my desktop the file for 2013 & 15 , I haven't located the 2017 file, if there were changes.

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

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

Those directions read:

Resolution
Go to Sage Businessworks Homepage
Select Sage BusinessWorks News
Expand Features sheets
The sixth item down is the File Formats

Problem is, I'm not seeing a "New" on the homepage. I think this KB needs updated as file is now under Resources. I was also hoping that the file would contain a relational database map, which it does not.

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