Appendix B: TP Databases and File Information


Overview

The trading partner database 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 are stored in Access tables and dBase III tables. (For map development, the program uses the data in Access tables, but at run time 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.

File

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 on the use of these fields.