01. DATOS GENERALES
| Producto | TOTVS Backoffice | ||||
|---|---|---|---|---|---|
| Línea de producto: | Línea Protheus | ||||
| Segmento: | Backoffice | ||||
| Módulo: | SIGAFIS - Libros Fiscales | ||||
| Función: |
| ||||
| País: | Argentina | ||||
| Ticket: | |||||
| Requisito/Story/Issue (informe el requisito vinculado): | DMICNS-13789 |
02. SITUACIÓN/REQUISITO
Se solicita la migración de los campos de impuestos de alícuota, base imponible y valor; de la tabla DBC del fuente RUP_ARG12114 para ATUSX.
03. SOLUCIÓN
Se crearon los campos de Alícuota, Base Imponible y Valor; de la tabla DBC, de acuerdo con las propiedades que se tienen para cada uno de los campos en el fuente RUP_ARG12114.
04. INFORMACIÓN ADICIONAL
Actualización al Diccionario de Datos:
Pacote: 010290
Descripción: DMICNS-13789 - MIGRACIÓN DE CAMPOS DE IMPUESTOS DE TABLA DBC - RUP_ARG12114
| Propiedades de campos de Alícuota | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| X3_ARQUIVO | X3_CAMPO | X3_TIPO | X3_TAMANHO | X3_DECIMAL | X3_TITULO | X3_DESCRIC | X3_PICTURE | X3_VALID | X3_BROWSE | X3_VISUAL | X3_CONTEXT |
| DBC | DBC_ALIMPA | N | 6 | 2 | Alic Imp. A | Alic Imp. A | @E 999.99 | MaFisRef("IT_ALIQIVA","MT120",M->DBC_ALIMPA) | S | V | R |
| DBC | DBC_ALIMPB | N | 6 | 2 | Alic Imp. B | Alic Imp. b | @E 999.99 | MaFisRef("IT_ALIQIVB","MT120",M->DBC_ALIMPB) | S | V | R |
| DBC | DBC_ALIMPC | N | 6 | 2 | Alic Imp. C | Alic Imp. C | @E 999.99 | MaFisRef("IT_ALIQIVC","MT120",M->DBC_ALIMPC) | S | V | R |
| DBC | DBC_ALIMPD | N | 6 | 2 | Alic Imp. D | Alic Imp. D | @E 999.99 | MaFisRef("IT_ALIQIVD","MT120",M->DBC_ALIMPD) | S | V | R |
| DBC | DBC_ALIMPE | N | 6 | 2 | Alic Imp. E | Alic Imp. E | @E 999.99 | MaFisRef("IT_ALIQIVE","MT120",M->DBC_ALIMPE) | S | V | R |
| DBC | DBC_ALIMPF | N | 6 | 2 | Alic Imp. F | Alic Imp. F | @E 999.99 | MaFisRef("IT_ALIQIVF","MT120",M->DBC_ALIMPF) | S | V | R |
| DBC | DBC_ALIMPG | N | 6 | 2 | Alic Imp. G | Alic Imp. G | @E 999.99 | MaFisRef("IT_ALIQIVG","MT120",M->DBC_ALIMPG) | S | V | R |
| DBC | DBC_ALIMPJ | N | 6 | 2 | Alic Imp. J | Alic Imp. J | @E 999.99 | MaFisRef("IT_ALIQIVJ","MT120",M->DBC_ALIMPJ) | S | V | R |
| DBC | DBC_ALIMPK | N | 6 | 2 | Alic Imp. K | Alic Imp. K | @E 999.99 | MaFisRef("IT_ALIQIVK","MT120",M->DBC_ALIMPK) | S | V | R |
| DBC | DBC_ALIMPL | N | 6 | 2 | Alic Imp. L | Alic Imp. L | @E 999.99 | MaFisRef("IT_ALIQIVL","MT120",M->DBC_ALIMPL) | S | V | R |
| DBC | DBC_ALIMPM | N | 6 | 2 | Alic Imp. M | Alic Imp. M | @E 999.99 | MaFisRef("IT_ALIQIVM","MT120",M->DBC_ALIMPM) | S | V | R |
| DBC | DBC_ALIMPN | N | 6 | 2 | Alic Imp. N | Alic Imp. N | @E 999.99 | MaFisRef("IT_ALIQIVN","MT120",M->DBC_ALIMPN) | S | V | R |
| DBC | DBC_ALIMPO | N | 6 | 2 | Alic Imp. O | Alic Imp. O | @E 999.99 | MaFisRef("IT_ALIQIVO","MT120",M->DBC_ALIMPO) | S | V | R |
| DBC | DBC_ALIMPP | N | 6 | 2 | Alic Imp. P | Alic Imp. P | @E 999.99 | MaFisRef("IT_ALIQIVP","MT120",M->DBC_ALIMPP) | S | V | R |
| DBC | DBC_ALIMPQ | N | 6 | 2 | Alic Imp. Q | Alic Imp. Q | @E 999.99 | MaFisRef("IT_ALIQIVQ","MT120",M->DBC_ALIMPQ) | S | V | R |
| DBC | DBC_ALIMPR | N | 6 | 2 | Alic Imp. R | Alic Imp. R | @E 999.99 | MaFisRef("IT_ALIQIVR","MT120",M->DBC_ALIMPR) | S | V | R |
| DBC | DBC_ALIMPS | N | 6 | 2 | Alic Imp. S | Alic Imp. S | @E 999.99 | MaFisRef("IT_ALIQIVS","MT120",M->DBC_ALIMPS) | S | V | R |
| DBC | DBC_ALIMPT | N | 6 | 2 | Alic Imp. T | Alic Imp. T | @E 999.99 | MaFisRef("IT_ALIQIVT","MT120",M->DBC_ALIMPT) | S | V | R |
| DBC | DBC_ALIMPU | N | 6 | 2 | Alic Imp. U | Alic Imp. U | @E 999.99 | MaFisRef("IT_ALIQIVU","MT120",M->DBC_ALIMPU) | S | V | R |
| DBC | DBC_ALIMPV | N | 6 | 2 | Alic Imp. V | Alic Imp. V | @E 999.99 | MaFisRef("IT_ALIQIVV","MT120",M->DBC_ALIMPV) | S | V | R |
| DBC | DBC_ALIMPW | N | 6 | 2 | Alic Imp. W | Alic Imp. W | @E 999.99 | MaFisRef("IT_ALIQIVW","MT120",M->DBC_ALIMPW) | S | V | R |
| DBC | DBC_ALIMPX | N | 6 | 2 | Alic Imp. X | Alic Imp. X | @E 999.99 | MaFisRef("IT_ALIQIVX","MT120",M->DBC_ALIMPX) | S | V | R |
| DBC | DBC_ALIMPY | N | 6 | 2 | Alic Imp. Y | Alic Imp. Y | @E 999.99 | MaFisRef("IT_ALIQIVY","MT120",M->DBC_ALIMPY) | S | V | R |
| Propiedades de campos de Base Imponible | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| X3_ARQUIVO | X3_CAMPO | X3_TIPO | X3_TAMANHO | X3_DECIMAL | X3_TITULO | X3_DESCRIC | X3_PICTURE | X3_VALID | X3_BROWSE | X3_VISUAL | X3_CONTEXT |
| DBC | DBC_BSIMPA | N | 14 | 2 | Base Imp. A | Base Imp. A | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVA","MT120",M->DBC_BSIMPA) | S | V | R |
| DBC | DBC_BSIMPB | N | 14 | 2 | Base Imp. B | Base Imp. B | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVB","MT120",M->DBC_BSIMPB) | S | V | R |
| DBC | DBC_BSIMPC | N | 14 | 2 | Base Imp. C | Base Imp. C | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVC","MT120",M->DBC_BSIMPC) | S | V | R |
| DBC | DBC_BSIMPD | N | 14 | 2 | Base Imp. D | Base Imp. D | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVD","MT120",M->DBC_BSIMPD) | S | V | R |
| DBC | DBC_BSIMPE | N | 14 | 2 | Base Imp. E | Base Imp. E | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVE","MT120",M->DBC_BSIMPE) | S | V | R |
| DBC | DBC_BSIMPF | N | 14 | 2 | Base Imp. F | Base Imp. F | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVF","MT120",M->DBC_BSIMPF) | S | V | R |
| DBC | DBC_BSIMPG | N | 14 | 2 | Base Imp. G | Base Imp. G | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVG","MT120",M->DBC_BSIMPG) | S | V | R |
| DBC | DBC_BSIMPJ | N | 14 | 2 | Base Imp. J | Base Imp. J | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVJ","MT120",M->DBC_BSIMPJ) | S | V | R |
| DBC | DBC_BSIMPK | N | 14 | 2 | Base Imp. K | Base Imp. K | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVK","MT120",M->DBC_BSIMPK) | S | V | R |
| DBC | DBC_BSIMPL | N | 14 | 2 | Base Imp. L | Base Imp. L | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVL","MT120",M->DBC_BSIMPL) | S | V | R |
| DBC | DBC_BSIMPM | N | 14 | 2 | Base Imp. M | Base Imp. M | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVM","MT120",M->DBC_BSIMPM) | S | V | R |
| DBC | DBC_BSIMPN | N | 14 | 2 | Base Imp. N | Base Imp. N | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVN","MT120",M->DBC_BSIMPN) | S | V | R |
| DBC | DBC_BSIMPO | N | 14 | 2 | Base Imp. O | Base Imp. O | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVO","MT120",M->DBC_BSIMPO) | S | V | R |
| DBC | DBC_BSIMPP | N | 14 | 2 | Base Imp. P | Base Imp. P | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVP","MT120",M->DBC_BSIMPP) | S | V | R |
| DBC | DBC_BSIMPQ | N | 14 | 2 | Base Imp. Q | Base Imp. Q | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVQ","MT120",M->DBC_BSIMPQ) | S | V | R |
| DBC | DBC_BSIMPR | N | 14 | 2 | Base Imp. R | Base Imp. R | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVR","MT120",M->DBC_BSIMPR) | S | V | R |
| DBC | DBC_BSIMPS | N | 14 | 2 | Base Imp. S | Base Imp. S | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVS","MT120",M->DBC_BSIMPS) | S | V | R |
| DBC | DBC_BSIMPT | N | 14 | 2 | Base Imp. T | Base Imp. T | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVT","MT120",M->DBC_BSIMPT) | S | V | R |
| DBC | DBC_BSIMPU | N | 14 | 2 | Base Imp. U | Base Imp. U | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVU","MT120",M->DBC_BSIMPU) | S | V | R |
| DBC | DBC_BSIMPV | N | 14 | 2 | Base Imp. V | Base Imp. V | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVV","MT120",M->DBC_BSIMPV) | S | V | R |
| DBC | DBC_BSIMPW | N | 14 | 2 | Base Imp. W | Base Imp. W | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVW","MT120",M->DBC_BSIMPW) | S | V | R |
| DBC | DBC_BSIMPX | N | 14 | 2 | Base Imp. X | Base Imp. X | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVX","MT120",M->DBC_BSIMPX) | S | V | R |
| DBC | DBC_BSIMPY | N | 14 | 2 | Base Imp. Y | Base Imp. Y | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVY","MT120",M->DBC_BSIMPY) | S | V | R |
| Propiedades de campos de Valor Impuesto | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| X3_ARQUIVO | X3_CAMPO | X3_TIPO | X3_TAMANHO | X3_DECIMAL | X3_TITULO | X3_DESCRIC | X3_PICTURE | X3_VALID | X3_BROWSE | X3_VISUAL | X3_CONTEXT |
| DBC | DBC_VLIMPA | N | 14 | 2 | Valor Imp. A | Valor Imp. A | @E 99,999,999,999.99 | MaFisRef("IT_VALIVA","MT120",M->DBC_VLIMPA) | S | V | R |
| DBC | DBC_VLIMPB | N | 14 | 2 | Valor Imp. B | Valor Imp. B | @E 99,999,999,999.99 | MaFisRef("IT_VALIVB","MT120",M->DBC_VLIMPB) | S | V | R |
| DBC | DBC_VLIMPC | N | 14 | 2 | Valor Imp. C | Valor Imp. C | @E 99,999,999,999.99 | MaFisRef("IT_VALIVC","MT120",M->DBC_VLIMPC) | S | V | R |
| DBC | DBC_VLIMPD | N | 14 | 2 | Valor Imp. D | Valor Imp. D | @E 99,999,999,999.99 | MaFisRef("IT_VALIVD","MT120",M->DBC_VLIMPD) | S | V | R |
| DBC | DBC_VLIMPE | N | 14 | 2 | Valor Imp. E | Valor Imp. E | @E 99,999,999,999.99 | MaFisRef("IT_VALIVE","MT120",M->DBC_VLIMPE) | S | V | R |
| DBC | DBC_VLIMPF | N | 14 | 2 | Valor Imp. F | Valor Imp. F | @E 99,999,999,999.99 | MaFisRef("IT_VALIVF","MT120",M->DBC_VLIMPF) | S | V | R |
| DBC | DBC_VLIMPG | N | 14 | 2 | Valor Imp. G | Valor Imp. G | @E 99,999,999,999.99 | MaFisRef("IT_VALIVG","MT120",M->DBC_BSIMPG) | S | V | R |
| DBC | DBC_VLIMPJ | N | 14 | 2 | Valor Imp. J | Valor Imp. J | @E 99,999,999,999.99 | MaFisRef("IT_VALIVJ","MT120",M->DBC_BSIMPJ) | S | V | R |
| DBC | DBC_VLIMPK | N | 14 | 2 | Valor Imp. K | Valor Imp. K | @E 99,999,999,999.99 | MaFisRef("IT_VALIVK","MT120",M->DBC_VLIMPK) | S | V | R |
| DBC | DBC_VLIMPL | N | 14 | 2 | Valor Imp. L | Valor Imp. L | @E 99,999,999,999.99 | MaFisRef("IT_VALIVL","MT120",M->DBC_VLIMPL) | S | V | R |
| DBC | DBC_VLIMPM | N | 14 | 2 | Valor Imp. M | Valor Imp. M | @E 99,999,999,999.99 | MaFisRef("IT_VALVM","MT120",M->DBC_VLIMPM) | S | V | R |
| DBC | DBC_VLIMPN | N | 14 | 2 | Valor Imp. N | Valor Imp. N | @E 99,999,999,999.99 | MaFisRef("IT_VALIVN","MT120",M->DBC_VLIMPN) | S | V | R |
| DBC | DBC_VLIMPO | N | 14 | 2 | Valor Imp. O | Valor Imp. O | @E 99,999,999,999.99 | MaFisRef("IT_VALIVO","MT120",M->DBC_VLIMPO) | S | V | R |
| DBC | DBC_VLIMPP | N | 14 | 2 | Valor Imp. P | Valor Imp. P | @E 99,999,999,999.99 | MaFisRef("IT_VALIVP","MT120",M->DBC_VLIMPP) | S | V | R |
| DBC | DBC_VLIMPQ | N | 14 | 2 | Valor Imp. Q | Valor Imp. Q | @E 99,999,999,999.99 | MaFisRef("IT_VALIVQ","MT120",M->DBC_VLIMPQ) | S | V | R |
| DBC | DBC_VLIMPR | N | 14 | 2 | Valor Imp. R | Valor Imp. R | @E 99,999,999,999.99 | MaFisRef("IT_VALIVR","MT120",M->DBC_VLIMPR) | S | V | R |
| DBC | DBC_VLIMPS | N | 14 | 2 | Valor Imp. S | Valor Imp. S | @E 99,999,999,999.99 | MaFisRef("IT_VALIVS","MT120",M->DBC_VLIMPS) | S | V | R |
| DBC | DBC_VLIMPT | N | 14 | 2 | Valor Imp. T | Valor Imp. T | @E 99,999,999,999.99 | MaFisRef("IT_VALIVT","MT120",M->DBC_VLIMPT) | S | V | R |
| DBC | DBC_VLIMPU | N | 14 | 2 | Valor Imp. U | Valor Imp. U | @E 99,999,999,999.99 | MaFisRef("IT_VALIVU","MT120",M->DBC_VLIMPU) | S | V | R |
| DBC | DBC_VLIMPV | N | 14 | 2 | Valor Imp. V | Valor Imp. V | @E 99,999,999,999.99 | MaFisRef("IT_VALIVV","MT120",M->DBC_VLIMPV) | S | V | R |
| DBC | DBC_VLIMPW | N | 14 | 2 | Valor Imp. W | Valor Imp. W | @E 99,999,999,999.99 | MaFisRef("IT_VALIVW","MT120",M->DBC_VLIMPW) | S | V | R |
| DBC | DBC_VLIMPX | N | 14 | 2 | Valor Imp. X | Valor Imp. X | @E 99,999,999,999.99 | MaFisRef("IT_VALIVX","MT120",M->DBC_VLIMPX) | S | V | R |
| DBC | DBC_VLIMPY | N | 14 | 2 | Valor Imp. Y | Valor Imp. Y | @E 99,999,999,999.99 | MaFisRef("IT_VALIVY","MT120",M->DBC_VLIMPY) | S | V | R |
Si los campos no existen en el ambiente, inicialmente serán creados como "No Usados". Si los campos serán utilizados para el cálculo de impuestos, se deberá realizar el ajuste vía Configurador (SIGACFG) para cambiar los campos a "Usados"
¡IMPORTANTE!
05. ASUNTOS RELACIONADOS
- No aplica.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas