Table 401 - Product Price Exclusion
This article presents the fields and operating logic of the integration layout for Product Price Exclusion.
To carry out this integration, it is necessary to send the information together with Table 13 – Product Price.
Exclusion rules:
-
When the codCliente field is entered: The deletion will be applied apenas to the specified customer, considering the combination: codProduto + codListaPreco + codCliente.
-
When the codCliente field is not provided: All combinations of codProduto + codListaPreco will be excluded from whether or not they are associated with a customer (codCliente).
This functionality offers greater flexibility in the price exclusion process, allowing for both targeted exclusions for specific customers and bulk exclusions by product and price list.
Order | Field Description | Format and Size | Required | Version | Remarks |
| 1 | Table identifier (IDENTIFICADOR) | FIXED= 401 | Yes | 4.40 | |
| 2 | Product Code (codProduto) | Text (30) | Yes | 4.40 | |
| 3 | Price List Code (codListaPreco) | Text (20) | Yes | 4.40 | |
| 4 | Customer Code (codCliente) | Integer (10) | No | 4.40 |
Registration Examples:
401|1000|01|11| 401|1000|02||