Products Table

The aim of this worksheet is to identify products that will be referenced in the CFEs and store the different alternative identification codes.

The objective of pre-identify products from CFEs is to minimize everyday traffic information between the system and eFactura. The revenue service requires (if corresponds) the different codes to identify the products: EAN, DUN, PLU, etc.

There is another spreadsheet to identify the various alternatives of product codes. The Internal Code 1 “INT1” will be used as the primary identifier for products table.

In the situation that additional encodings of the product are represented as different fields in the same table of products, you must use the "Products" sheet. You must charge the first two columns (INT1 and Description) mandatory and the remaining columns (optionally) that corresponds to the alternative codes.

In case that the alternative encodings are identified with a separate system table you must charge only the first two columns (INT1 and Description) of “Products” sheet (mandatory) and then charge the "Codes per Types" sheet where there’s a relationship between the internal code “INT1” and “Code of Type” an identification code for that type. The types of codes identified by the revenue service are identified in the third sheet "Type of Codes".

Link

Products Table