Business Partners
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.
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] |
|
|
BPCARRIER [BPT] |
|
|
BPCUSTOMER [BPC] |
|
|
BPSUPPLIER [BPS] |
|
|
CONTACT [CNT] |
Contacts |
|
CONTACTCRM [AIN] |
|
|
FACILITY [FCY] |
|
|
GACCCODE [CAC] |
|
|
TABCOUNTRY [TCY] |