Table 76 - Level 2 Pricing Policy
Available at:
- This article presents the fields of the Level 2 Pricing Policy integration layout . To better understand Pricing Policies and their Levels, before integrating this table, consult our article and learn about the logic that Demander uses to evaluate and apply pricing policies in Price Policy Resolution.
- To carry out this integration, you must send the information together with:
| Order | Field Description | Format and Size | Required | Version | Note |
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=76 (2) | Yes | 4.18 | |
| 2 | Code (code) | Integer (20) | Yes | 4.18 | Unique Policy Level 2 Code. |
| 3 | Level 1 Policy (codNivel1) | Integer (10) | Yes | 4.18 | This field determines which Level 1 Pricing Policy the record belongs to. |
| 4 | Line (line) | Integer (10) | Yes | 4.18 | Field used to facilitate the identification of Level 2 items. |
| 5 | Effective Date (dataInicioVigencia) | Date | Yes | 4.18 | Determines the Effective Date of this policy. If it is out of effect, the system disregards this policy. Policy. |
| 6 | Effective End Date (dataFimVigencia) | Date | Yes | 4.18 | Determines the Effective Effective Date of this policy. If it is out of effect, the system disregards this policy. Policy. |
| 7 | Initial Value (valorInicial) | Decimal (10.2) | No | 5.13 | Gross value of products from which this policy begins to be applied. |
| 8 | Initial Value (valorFinal) | Decimal (10.2) | No | 5.13 | Gross value of products from which this policy ceases to be applied. |
| 9 | Branch Code (codFilial) | Text (15) | No | 4.18 | Branch CodeUnit no. Demander. |
| 10 | Seller Code (codVendedor) | Integer (10) | No | 4.18 | Seller Code in Demander. |
| 11 | Customer Code (codCliente) | Text (30) | No | 4.18 | Customer Code in Demander. |
| 12 | UF - State (uf) | Text(2) | No | 4.18 | Example (RS,MG,SP) |
| 13 | Segment Code (codSegmento) | Text (30) | No | 4.18 | Customer Segment Code in Demander. |
| 14 | Product Group Code (codGrupoProduto) | Text (30) | No | 4.18 | Product Group Code in Demander. |
| 15 | Product Code (codProduto) | Text (30) | No | 4.18 | Product Code in Demander. |
| 16 | Customer Type Code (codTipoCliente) | Text (30) | No | 4.18 | Customer Type Code in Demander. |
| 17 | Sales Division Code (codDivisaoVendas) | Text (30) | No | 4.18 | Sales Division Code in Demander. |
| 18 | Price List Code (codListaPreco) | Text (20) | No | 4.18 | Price List Code in Demander. |
| 19 | Payment Condition Code (codCondicaoPagamento) | Text (20) | No | 4.18 | Payment Terms Code in Demander. |
| 20 | Payment Terms Code (codFormaPagamento) | Text (20) | No | 4.18 | Payment Method Code in Demander. |
| 21 | Product Segment Code (codSegmentoDoProduto) | Text (20) | No | 4.44 | Product Segment Code in Demander. |
| 22 | Initial Quantity (qtdeInicial) | Decimal (10.2) | Yes | 4.52 | |
| 23 | Final Quantity (qtdeFinal) | Decimal (10.2) | Yes | 4.52 | |
| 24 | Freight Type Code (codTipoFrete) | Integer | No | 5.2 | Freight Type Code in Demander. |
| 25 | idRegraConfigurador | Integer | No | 5.13 | Defines the configurator rule |
| 26 | Order type code (tipoPedido) | Integer | No | 5.19 | Order Type Code related to this policy |
| 27 | Initial weight (pesoInicial) | Decimal | No | 5.19 | Initial weight for applying the policy (gross weight or net weight depending on level 1 policy) |
| 28 | Final weight (pesoFinal) | Decimal | No | 5.19 | Final weight for policy application (gross weight or net weight depending on level 1 policy) |
Registration Example:
76|2527290001|1089|3|2015-04-13|2999-12-31|||51||41408001|||||||||||