The BP import may involve up to five different tables defined as follows.

The main file to set up is BPARTNER.

Prerequisite

The setup must follow the tab presentation order for BP management.

The import of the bank ID number and contacts can refer to address codes that must have been loaded beforehand.

Mandatory fields in the template

For BP object, the mandatory fields for the template are the following:

  • BP code (BPRNUM) for the BP table (BPARTNER)
  • Address code (BPAADD) for address table (BPADDRESS)

One level (or record) is required for the BP table and another one for the address table.
This rule applies to all BPs.

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

BID [BID]

Bank ID statement

BPADDRESS [BPA]

Addresses

BPARTNER [BPR]

Business partner

BPCARRIER [BPT]

Carriers

BPCUSTOMER [BPC]

Customers

BPSUPPLIER [BPS]

Suppliers

CONTACT [CNT]

Contacts

CONTACTCRM [AIN]

Contact relationships

FACILITY [FCY]

Sites

GACCCODE [CAC]

Accounting codes

TABCOUNTRY [TCY]

Country table