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: | No aplica. | ||||
Requisito/Story/Issue (informe el requisito vinculado): | DMICNS-13786 |
02. SITUACIÓN/REQUISITO
Se requiere la migración de los campos de impuestos alícuota (D2_VALIMP?), base imponible (D2_BASIMP?) y valor (D2_VALIMP?) de la tabla SD2 del RUP_ARG12114 para ATUSX.
03. SOLUCIÓN
Se crearon los campos de Alícuota, Base Imponible y Valor; de la tabla SD2, 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: 010334
Descripción: Migración de campos de impuestos de tabla SD2 - 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 |
SD2 | D2_ALQIMPA | N | 6 | 2 | Alic Imp. A | Alic Imp. A | @E 999.99 | MaFisRef("IT_ALIQIVA","MT100",M->D2_ALQIMPA) | S | V | R |
SD2 | D2_ALQIMPB | N | 6 | 2 | Alic Imp. B | Alic Imp. B | @E 999.99 | MaFisRef("IT_ALIQIVB","MT100",M->D2_ALQIMPB) | S | V | R |
SD2 | D2_ALQIMPC | N | 6 | 2 | Alic Imp. C | Alic Imp. C | @E 999.99 | MaFisRef("IT_ALIQIVC","MT100",M->D2_ALQIMPC) | S | V | R |
SD2 | D2_ALQIMPD | N | 6 | 2 | Alic Imp. D | Alic Imp. D | @E 999.99 | MaFisRef("IT_ALIQIVD","MT100",M->D2_ALQIMPD) | S | V | R |
SD2 | D2_ALQIMPE | N | 6 | 2 | Alic Imp. E | Alic Imp. E | @E 999.99 | MaFisRef("IT_ALIQIVE","MT100",M->D2_ALQIMPE) | S | V | R |
SD2 | D2_ALQIMPF | N | 6 | 2 | Alic Imp. F | Alic Imp. F | @E 999.99 | MaFisRef("IT_ALIQIVF","MT100",M->D2_ALQIMPF) | S | V | R |
SD2 | D2_ALQIMPG | N | 6 | 2 | Alic Imp. G | Alic Imp. G | @E 999.99 | MaFisRef("IT_ALIQIVG","MT100",M->D2_ALQIMPG) | S | V | R |
SD2 | D2_ALQIMPJ | N | 6 | 2 | Alic Imp. J | Alic Imp. J | @E 999.99 | MaFisRef("IT_ALIQIVJ","MT100",M->D2_ALQIMPJ) | S | V | R |
SD2 | D2_ALQIMPK | N | 6 | 2 | Alic Imp. K | Alic Imp. K | @E 999.99 | MaFisRef("IT_ALIQIVK","MT100",M->D2_ALQIMPK) | S | V | R |
SD2 | D2_ALQIMPL | N | 6 | 2 | Alic Imp. L | Alic Imp. L | @E 999.99 | MaFisRef("IT_ALIQIVL","MT100",M->D2_ALQIMPL) | S | V | R |
SD2 | D2_ALQIMPM | N | 6 | 2 | Alic Imp. M | Alic Imp. M | @E 999.99 | MaFisRef("IT_ALIQIVM","MT100",M->D2_ALQIMPM) | S | V | R |
SD2 | D2_ALQIMPN | N | 6 | 2 | Alic Imp. N | Alic Imp. N | @E 999.99 | MaFisRef("IT_ALIQIVN","MT100",M->D2_ALQIMPN) | S | V | R |
SD2 | D2_ALQIMPO | N | 6 | 2 | Alic Imp. O | Alic Imp. O | @E 999.99 | MaFisRef("IT_ALIQIVO","MT100",M->D2_ALQIMPO) | S | V | R |
SD2 | D2_ALQIMPP | N | 6 | 2 | Alic Imp. P | Alic Imp. P | @E 999.99 | MaFisRef("IT_ALIQIVP","MT100",M->D2_ALQIMPP) | S | V | R |
SD2 | D2_ALQIMPQ | N | 6 | 2 | Alic Imp. Q | Alic Imp. Q | @E 999.99 | MaFisRef("IT_ALIQIVQ","MT100",M->D2_ALQIMPQ) | S | V | R |
SD2 | D2_ALQIMPR | N | 6 | 2 | Alic Imp. R | Alic Imp. R | @E 999.99 | MaFisRef("IT_ALIQIVR","MT100",M->D2_ALQIMPR) | S | V | R |
SD2 | D2_ALQIMPS | N | 6 | 2 | Alic Imp. S | Alic Imp. S | @e 999.99 | MaFisRef("IT_ALIQIVS","MT100",M->D2_ALQIMPS) | S | V | R |
SD2 | D2_ALQIMPT | N | 6 | 2 | Alic Imp. T | Alic Imp. T | @E 999.99 | MaFisRef("IT_ALIQIVT","MT100",M->D2_ALQIMPT) | S | V | R |
SD2 | D2_ALQIMPU | N | 6 | 2 | Alic Imp. U | Alic Imp. U | @E 999.99 | MaFisRef("IT_ALIQIVU","MT100",M->D2_ALQIMPU) | S | V | R |
SD2 | D2_ALQIMPV | N | 6 | 2 | Alic Imp. V | Alic Imp. V | @E 999.99 | MaFisRef("IT_ALIQIVV","MT100",M->D2_ALQIMPV) | S | V | R |
SD2 | D2_ALQIMPW | N | 6 | 2 | Alic Imp. W | Alic Imp. W | @E 999.99 | MaFisRef("IT_ALIQIVW","MT100",M->D2_ALQIMPW) | S | V | R |
SD2 | D2_ALQIMPX | N | 6 | 2 | Alic Imp. X | Alic Imp. X | @E 999.99 | MaFisRef("IT_ALIQIVX","MT100",M->D2_ALQIMPX) | S | V | R |
SD2 | D2_ALQIMPY | N | 6 | 2 | Alic Imp. Y | Alic Imp. Y | @E 999.99 | MaFisRef("IT_ALIQIVY","MT100",M->D2_ALQIMPY) | 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 |
SD2 | D2_BASIMPA | N | 14 | 2 | Base Imp. A | Base Imp. A | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVA","MT100",M->D2_BASIMPA) | S | V | R |
SD2 | D2_BASIMPB | N | 14 | 2 | Base Imp. B | Base Imp. B | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVB","MT100",M->D2_BASIMPB) | S | V | R |
SD2 | D2_BASIMPC | N | 14 | 2 | Base Imp. C | Base Imp. C | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVC","MT100",M->D2_BASIMPC) | S | V | R |
SD2 | D2_BASIMPD | N | 14 | 2 | Base Imp. D | Base Imp. D | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVD","MT100",M->D2_BASIMPD) | S | V | R |
SD2 | D2_BASIMPE | N | 14 | 2 | Base Imp. E | Base Imp. E | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVE","MT100",M->D2_BASIMPE) | S | V | R |
SD2 | D2_BASIMPF | N | 14 | 2 | Base Imp. F | Base Imp. F | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVF","MT100",M->D2_BASIMPF) | S | V | R |
SD2 | D2_BASIMPG | N | 14 | 2 | Base Imp. G | Base Imp. G | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVG","MT100",M->D2_BASIMPG) | S | V | R |
SD2 | D2_BASIMPJ | N | 14 | 2 | Base Imp. J | Base Imp. J | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVJ","MT100",M->D2_BASIMPJ) | S | V | R |
SD2 | D2_BASIMPK | N | 14 | 2 | Base Imp. K | Base Imp. K | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVK","MT100",M->D2_BASIMPK) | S | V | R |
SD2 | D2_BASIMPL | N | 14 | 2 | Base Imp. L | Base Imp. L | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVL","MT100",M->D2_BASIMPL) | S | V | R |
SD2 | D2_BASIMPM | N | 14 | 2 | Base Imp. M | Base Imp. M | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVM","MT100",M->D2_BASIMPM) | S | V | R |
SD2 | D2_BASIMPN | N | 14 | 2 | Base Imp. N | Base Imp. N | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVN","MT100",M->D2_BASIMPN) | S | V | R |
SD2 | D2_BASIMPO | N | 14 | 2 | Base Imp. O | Base Imp. O | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVO","MT100",M->D2_BASIMPO) | S | V | R |
SD2 | D2_BASIMPP | N | 14 | 2 | Base Imp. P | Base Imp. P | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVP","MT100",M->D2_BASIMPP) | S | V | R |
SD2 | D2_BASIMPQ | N | 14 | 2 | Base Imp. Q | Base Imp. Q | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVQ","MT100",M->D2_BASIMPQ) | S | V | R |
SD2 | D2_BASIMPR | N | 14 | 2 | Base Imp. R | Base Imp. R | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVR","MT100",M->D2_BASIMPR) | S | V | R |
SD2 | D2_BASIMPS | N | 14 | 2 | Base Imp. S | Base Imp. S | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVS","MT100",M->D2_BASIMPS) | S | V | R |
SD2 | D2_BASIMPT | N | 14 | 2 | Base Imp. T | Base Imp. T | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVT","MT100",M->D2_BASIMPT) | S | V | R |
SD2 | D2_BASIMPU | N | 14 | 2 | Base Imp. U | Base Imp. U | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVU","MT100",M->D2_BASIMPU) | S | V | R |
SD2 | D2_BASIMPV | N | 14 | 2 | Base Imp. V | Base Imp. V | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVV","MT100",M->D2_BASIMPV) | S | V | R |
SD2 | D2_BASIMPW | N | 14 | 2 | Base Imp. W | Base Imp. W | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVW","MT100",M->D2_BASIMPW) | S | V | R |
SD2 | D2_BASIMPX | N | 14 | 2 | Base Imp. X | Base Imp. X | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVX","MT100",M->D2_BASIMPX) | S | V | R |
SD2 | D2_BASIMPY | N | 14 | 2 | Base Imp. Y | Base Imp. Y | @E 99,999,999,999.99 | MaFisRef("IT_BASEIVY","MT100",M->D2_BASIMPY) | 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 |
SD2 | D2_VALIMPA | N | 14 | 2 | Valor Imp. A | Valor Imp. A | @E 99,999,999,999.99 | MaFisRef("IT_VALIVA","MT100",M->D2_VALIMPA) | S | V | R |
SD2 | D2_VALIMPB | N | 14 | 2 | Valor Imp. B | Valor Imp. B | @E 99,999,999,999.99 | MaFisRef("IT_VALIVB","MT100",M->D2_VALIMPB) | S | V | R |
SD2 | D2_VALIMPC | N | 14 | 2 | Valor Imp. C | Valor Imp. C | @E 99,999,999,999.99 | MaFisRef("IT_VALIVC","MT100",M->D2_VALIMPC) | S | V | R |
SD2 | D2_VALIMPD | N | 14 | 2 | Valor Imp. D | Valor Imp. D | @E 99,999,999,999.99 | MaFisRef("IT_VALIVD","MT100",M->D2_VALIMPD) | S | V | R |
SD2 | D2_VALIMPE | N | 14 | 2 | Valor Imp. E | Valor Imp. E | @E 99,999,999,999.99 | MaFisRef("IT_VALIVE","MT100",M->D2_VALIMPE) | S | V | R |
SD2 | D2_VALIMPF | N | 14 | 2 | Valor Imp. F | Valor Imp. F | @E 99,999,999,999.99 | MaFisRef("IT_VALIVF","MT100",M->D2_VALIMPF) | S | V | R |
SD2 | D2_VALIMPG | N | 14 | 2 | Valor Imp. G | Valor Imp. G | @E 99,999,999,999.99 | MaFisRef("IT_VALIVG","MT100",M->D2_VALIMPG) | S | V | R |
SD2 | D2_VALIMPJ | N | 14 | 2 | Valor Imp. J | Valor Imp. J | @E 99,999,999,999.99 | MaFisRef("IT_VALIVJ","MT100",M->D2_VALIMPJ) | S | V | R |
SD2 | D2_VALIMPK | N | 14 | 2 | Valor Imp. K | Valor Imp. K | @E 99,999,999,999.99 | MaFisRef("IT_VALIVK","MT100",M->D2_VALIMPK) | S | V | R |
SD2 | D2_VALIMPL | N | 14 | 2 | Valor Imp. L | Valor Imp. L | @E 99,999,999,999.99 | MaFisRef("IT_VALIVL","MT100",M->D2_VALIMPL) | S | V | R |
SD2 | D2_VALIMPM | N | 14 | 2 | Valor Imp. M | Valor Imp. M | @E 99,999,999,999.99 | MaFisRef("IT_VALIVM","MT100",M->D2_VALIMPM) | S | V | R |
SD2 | D2_VALIMPN | N | 14 | 2 | Valor Imp. N | Valor Imp. N | @E 99,999,999,999.99 | MaFisRef("IT_VALIVN","MT100",M->D2_VALIMPN) | S | V | R |
SD2 | D2_VALIMPO | N | 14 | 2 | Valor Imp. O | Valor Imp. O | @E 99,999,999,999.99 | MaFisRef("IT_VALIVO","MT100",M->D2_VALIMPO) | S | V | R |
SD2 | D2_VALIMPP | N | 14 | 2 | Valor Imp. P | Valor Imp. P | @E 99,999,999,999.99 | MaFisRef("IT_VALIVP","MT100",M->D2_VALIMPP) | S | V | R |
SD2 | D2_VALIMPQ | N | 14 | 2 | Valor Imp. Q | Valor Imp. Q | @E 99,999,999,999.99 | MaFisRef("IT_VALIVQ","MT100",M->D2_VALIMPQ) | S | V | R |
SD2 | D2_VALIMPR | N | 14 | 2 | Valor Imp. R | Valor Imp. R | @E 99,999,999,999.99 | MaFisRef("IT_VALIVR","MT100",M->D2_VALIMPR) | S | V | R |
SD2 | D2_VALIMPS | N | 14 | 2 | Valor Imp. S | Valor Imp. S | @E 99,999,999,999.99 | MaFisRef("IT_VALIVS","MT100",M->D2_VALIMPS) | S | V | R |
SD2 | D2_VALIMPT | N | 14 | 2 | Valor Imp. T | Valor Imp. T | @E 99,999,999,999.99 | MaFisRef("IT_VALIVT","MT100",M->D2_VALIMPT) | S | V | R |
SD2 | D2_VALIMPU | N | 14 | 2 | Valor Imp. U | Valor Imp. U | @E 99,999,999,999.99 | MaFisRef("IT_VALIVU","MT100",M->D2_VALIMPU) | S | V | R |
SD2 | D2_VALIMPV | N | 14 | 2 | Valor Imp. V | Valor Imp. V | @E 99,999,999,999.99 | MaFisRef("IT_VALIVV","MT100",M->D2_VALIMPV) | S | V | R |
SD2 | D2_VALIMPW | N | 14 | 2 | Valor Imp. W | Valor Imp. W | @E 99,999,999,999.99 | MaFisRef("IT_VALIVW","MT100",M->D2_VALIMPW) | S | V | R |
SD2 | D2_VALIMPX | N | 14 | 2 | Valor Imp. X | Valor Imp. X | @E 99,999,999,999.99 | MaFisRef("IT_VALIVX","MT100",M->D2_VALIMPX) | S | V | R |
SD2 | D2_VALIMPY | N | 14 | 2 | Valor Imp. Y | Valor Imp. Y | @E 99,999,999,999.99 | MaFisRef("IT_VALIVY","MT100",M->D2_VALIMPY) | S | V | R |
05. ASUNTOS RELACIONADOS
- No aplica.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas