Import/export template >  Module Common Data >  Import/export template TPV (Supplier invoice types)  

Display all Hide all

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

Mandatory fields in the template

The following fields should be imported at least:

  • Code,
  • 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 supplier invoice type will be set to multi-legislation.
    • If the parameter is entered, the attached legislation code populates the Legislation field. The supplier 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

TABPIVTYP [TPV]

Supp invoice type table