Use this template to import Customer relation (CRM) project data from any third party product into Sage X3 and to export from Sage X3. You can also use this template to delete project data.
Import is authorized in modification mode, provided that the functional rules are complied with.
The template is based on the screen and classes.
The mandatory fields are defined in the project classes.
On creation:
You must include all mandatory fields.
When running the import in modification mode, the Competitor - CPP value is searched against the collection.
When running the import in modification mode, the Date - ENDDAT and Step - STE values are searched against the collection.
When running the import in modification mode, the Date - ENDDATX and Step - STEX values are searched against the collection.
When running the import in modification mode, the Code - SBBPJ value is searched against the collection.
This template can be used in import and export modes. The data is updated in the following tables :
Table |
Table description |
---|---|
ATEXTRA [AXX] |
Texts to translate |
AUTILIS [AUS] |
|
BPARTNER [BPR] |
|
BPCUSTOMER [BPC] |
|
CMARKETING [CMG] |
|
CONTACT [CNT] |
Contacts |
CONTACTCRM [AIN] |
|
MAILING [OMM] |
|
MEDIA [OMN] |
|
OPPOR [OPP] |
|
OPPORCPP [OCP] |
Project competitor |
OPPORCRM [OPPCRM] |
CRM project |
OPPORSBB [OBB] |
Sub-project |
OPPORSTA [OSA] |
Project after-sales steps |
OPPORSTB [OSB] |
Project pre-sales steps |
PHONING [OMP] |
|
PIMPL [PIM] |
|
SALESREP [REP] |
|
SERREQUEST [SRE] |
|
SQUOTE [SQH] |
|
TABCUR [TCU] |
|
TRADESHOW [OMT] |