Import/export template >  Module Common Data >  Import/export template TSV (Customer invoice types)  

Display all Hide all

Use the import of customer invoice types to create new customer invoice types or to import modifications made to existing customer invoice types.

Mandatory fields in the template

The following fields should be imported at least:

  • Code,
  • the description,
  • Short description.
Loading specificities of the Legislation field
Because this field is not included in the import template structure, the Legislation code is loaded as follows:
  • Single legislation folder: the Legislation field is set to the legislation code of the folder.
  • Multi-legislation folder: the value of the Legislation field depends on the user parameter LEGFIL - Legislation (selection filter) (SUP chapter, INT group) for the user who starts the import:
    • If the parameter is not entered, the Legislation field is not entered: the imported customer invoice type will be set to multi-legislation.
    • If the parameter is entered, the attached legislation code populates the Legislation field. The customer invoice type will be associated with this legislation.

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

ACODNUM [ANM]

Doc sequence numbers

ATEXTRA [AXX]

Texts to translate

GAUTACE [GAU]

Automatic journals

GJOURNAL [JOU]

Journal codes

GTYPACCENT [GTE]

Document types

TABSIVTYP [TSV]

Customer invoice type table