ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Tables details
http://www.istechforum.com/YaBB.pl?num=1193777160

Message started by archoninc on 10/30/07 at 13:46:00

Title: Tables details
Post by archoninc on 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

Title: Re: Tables details
Post by David Waldmann on 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.

Title: Re: Tables details
Post by HB on 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)

Title: Re: Tables details
Post by archoninc on 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.

Title: Re: Tables details
Post by HB on 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).

Title: Re: Tables details
Post by GasGiant on 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.

Title: Re: Tables details
Post by archoninc on 10/31/07 at 09:14:17

Thank you very much for the help!! :)