ISTech Support Forum - Tables details

Welcome, Guest. Please Login.

	05/06/24 at 13:37:55 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues

Pages: 1

Tables details (Read 1504 times)

archoninc Browser Posts: 5	Tables details 10/30/07 at 13:46:00 Hi, To be able to create a few reports, we need the details and definitions of the tables used in EVO/DBA. Where can we find this? Thanks
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Tables details Reply #1 - 10/31/07 at 04:51:58 A good starter place is Help > File Names > File Names. Somewhere on the ISTS website there is, or at least, was, an XLS file with more information including the actual list of fields by table and some descriptions.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

HB Full Member I love DBA Posts: 216 Gender:	Re: Tables details Reply #2 - 10/31/07 at 06:24:05 If you cannot find it on the ISTTECH website, send me an email and I will send you the xls spreadsheet with the file names (helmut@generalpencil.com)
Back to top	Helmut Bode General Pencil Co. DBA Classic 2004.1 w/IS Tech update 7/25/13 EVO-ERP Pervasive 11 Win2008 Server Terminal Server 12 Users IP Logged

archoninc Browser Posts: 5	Re: Tables details Reply #3 - 10/31/07 at 06:58:24 Hi, I found one Excel document, thanks. Actually, I am looking for the tables and fields where the information for shipping carrier name, shipping date, and shipping numbers documents are saved.
Back to top	IP Logged

HB Full Member I love DBA Posts: 216 Gender:	Re: Tables details Reply #4 - 10/31/07 at 07:14:47 That would be BKARINV and BKARINVL for header and detail (for not invoiced orders) and BKARHINV and BKARHINVL (for posted invoices).
Back to top	Helmut Bode General Pencil Co. DBA Classic 2004.1 w/IS Tech update 7/25/13 EVO-ERP Pervasive 11 Win2008 Server Terminal Server 12 Users IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: Tables details Reply #5 - 10/31/07 at 07:17:58 Shipping carrier name and tracking number are added to the end of the SO notes (BKARDESC), then moved to the invoice notes (BKARHDSC) at the time of posting. The field is BK_DESC_NOTES in both cases. The actual ship date is in BKARHIVL, the invoiced line items. The field is BKAR_INVL_ASD.
Back to top	IP Logged

archoninc Browser Posts: 5	Re: Tables details Reply #6 - 10/31/07 at 09:14:17 Thank you very much for the help!!
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues