Appendix B: Trading Partner Databases and File Information

The trading partner database (see Table B-1) consists of three tables that contain information about the company, its trading partners, and the trade agreements that have been set up between them. In the non-ODBC version, the company information is stored in an ASCII flat file, and the trading partner and trade agreement information is stored in Access tables and dBase III tables. (For map development, the program uses the data in Access tables, but at runtime, the program uses the data in dBase III tables.) In the ODBC version, the three tables can be stored in any ODBC-compliant database. The user must assign a data source name (DSN) that points to the trading partner database and use the appropriate ODBC driver.

Table B-1: Trading partner database table descriptions

Table

Description

wixset.dat

Contains company information for non-ODBC databases

wixset

Contains company information for ODBC databases

customer.dbf/.mdb

Contains trading partner information for non-ODBC databases

tp

Contains trading partner information for ODBC databases

tradstat.dbf/.mdb

Contains trade agreement information for non-ODBC databases

tradstat

Contains trade agreement information for ODBC databases

See the ECMap Reference Guide for additional information about these fields.