https://documentacion.conarpesa.com.ar/index.php?action=history&feed=atom&title=ARTICULOS%2FCONSULTA_SALDOS ARTICULOS/CONSULTA SALDOS - Historial de revisiones 2026-05-05T22:30:56Z Historial de revisiones de esta página en la wiki MediaWiki 1.41.1 https://documentacion.conarpesa.com.ar/index.php?title=ARTICULOS/CONSULTA_SALDOS&diff=1680&oldid=prev Luciano Carou en 18:14 10 ene 2025 2025-01-10T18:14:54Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="es"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Revisión anterior</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revisión del 20:14 10 ene 2025</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l28">Línea 28:</td> <td colspan="2" class="diff-lineno">Línea 28:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Observaciones adicionales sobre los campos ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Observaciones adicionales sobre los campos ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Relaciones==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Relaciones==</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>==<del style="font-weight: bold; text-decoration: none;">Triggers</del>==</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>== <ins style="font-weight: bold; text-decoration: none;">[[QUEESESTO/CRITERIOS CONSULTA|Resultado de la consulta]] </ins>==</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">{| class="wikitable"</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">! Columna !! Nombre !! Atributo !! Observaciones</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|1||FARTICULO||[[ARTICULOS|ART]]||Código de artículo</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|2||FDESCRIPCION||[[VARCHAR|VARCHAR]]||Descripción del artículo.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|3||FCANTIDAD||[[NUMERIC|NUMERIC]]||Cantidad en stock.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|4||FKILOS||[[NUMERIC|NUMERIC]]||Cantidad por medida.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|5||FEMPAQUE||[[ARTICULOS/UNIDAD MEDIDA|ARTUNIDADMEDIDA]]||Unidad de medida del artículo.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|6||FCLASIFICACION||[[ARTICULOS/CLASIFICACION|ARTCLASIFICACION]]||Clasificación del artículo, si corresponde.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|7||FDEPOSITO||[[ALMACEN|ALMACEN]]||Código de depósito.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|8||FDEPOSITO.DESCRIPCION||[[VARCHAR|VARCHAR]]||Descripción del depósito.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|9||FFAMILIA||[[ARTICULOS/FAMILIAS|ARTFAMILIA]]||Código de familia del artículo.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|10||FSUBFAMILIA||[[ARTICULOS/SUBFAMILIAS|ARTSUBFAMILIA]]||Código de subfamilia del artículo.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|}</ins></div></td></tr> </table> Luciano Carou https://documentacion.conarpesa.com.ar/index.php?title=ARTICULOS/CONSULTA_SALDOS&diff=1679&oldid=prev Luciano Carou: Página creada con «==Descripción== La consulta '''ARTMOVTABLA_SALDOS_Consulta''' (Artículos, saldos de stock) muestra los artículos con saldo definidos según los criterios. == Estructura == Category:MANUAL/USUARIO Category:ARTICULOS ==Identidad== * Tabla: '''ARTMOVTABLA_SALDOS_Consulta''' * Tipo: '''CONSULTA''' * Catálogo: '''ERP COMERCIAL''' == Criterios de la consulta == {| class="wikitable" |- ! Columna !! Camp…» 2025-01-10T18:09:33Z <p>Página creada con «==Descripción== La consulta &#039;&#039;&#039;ARTMOVTABLA_SALDOS_Consulta&#039;&#039;&#039; (Artículos, saldos de stock) muestra los artículos con saldo definidos según los criterios. == Estructura == <a href="/index.php?title=Categor%C3%ADa:MANUAL/USUARIO" title="Categoría:MANUAL/USUARIO">Category:MANUAL/USUARIO</a> <a href="/index.php?title=Categor%C3%ADa:ARTICULOS" title="Categoría:ARTICULOS">Category:ARTICULOS</a> ==<a href="/index.php?title=QUEESESTO/IDENTIDAD&amp;action=edit&amp;redlink=1" class="new" title="QUEESESTO/IDENTIDAD (la página no existe)">Identidad</a>== * Tabla: &#039;&#039;&#039;ARTMOVTABLA_SALDOS_Consulta&#039;&#039;&#039; * Tipo: &#039;&#039;&#039;CONSULTA&#039;&#039;&#039; * Catálogo: &#039;&#039;&#039;<a href="/index.php?title=ERP_COMERCIAL" title="ERP COMERCIAL">ERP COMERCIAL</a>&#039;&#039;&#039; == <a href="/index.php?title=QUEESESTO/CRITERIOS_CONSULTA&amp;action=edit&amp;redlink=1" class="new" title="QUEESESTO/CRITERIOS CONSULTA (la página no existe)">Criterios de la consulta</a> == {| class=&quot;wikitable&quot; |- ! Columna !! Camp…»</p> <p><b>Página nueva</b></p><div>==Descripción==<br /> La consulta &#039;&#039;&#039;ARTMOVTABLA_SALDOS_Consulta&#039;&#039;&#039; (Artículos, saldos de stock) muestra los artículos con saldo definidos según los criterios.<br /> == Estructura ==<br /> [[Category:MANUAL/USUARIO]]<br /> [[Category:ARTICULOS]]<br /> ==[[QUEESESTO/IDENTIDAD|Identidad]]==<br /> * Tabla: &#039;&#039;&#039;ARTMOVTABLA_SALDOS_Consulta&#039;&#039;&#039;<br /> * Tipo: &#039;&#039;&#039;CONSULTA&#039;&#039;&#039;<br /> * Catálogo: &#039;&#039;&#039;[[ERP COMERCIAL]]&#039;&#039;&#039;<br /> == [[QUEESESTO/CRITERIOS CONSULTA|Criterios de la consulta]] ==<br /> {| class=&quot;wikitable&quot;<br /> |-<br /> ! Columna !! Campo físico !! Campo lógico !! Atributo !! Descripción !! Etiquetas !! Observaciones<br /> |-<br /> |1||FDESDE||Desde||&#039;&#039;&#039;[[ARTICULOS|ART]]&#039;&#039;&#039;||Artículos, saldos de stock||REQ||Código inicial de artículo.<br /> |-<br /> |2||FHASTA||Hasta||&#039;&#039;&#039;[[ARTICULOS|ART]]&#039;&#039;&#039;||Artículos, saldos de stock||REQ||Código final de artículo.<br /> |-<br /> |3||FDEPOSITO||Depósito||&#039;&#039;&#039;[[ALMACEN|ALMACEN]]&#039;&#039;&#039;||Artículos, saldos de stock||||Código de depósito, es opcional. Si no se ingresa trae todos los depósitos.<br /> |-<br /> |4||FFECHA||Fecha||&#039;&#039;&#039;[[DATETIME|DATETIME]]&#039;&#039;&#039;||Fecha y hora.||REQ||Fecha a la que se consultan los saldos.<br /> |-<br /> |5||FCONSALDO||Con saldo||&#039;&#039;&#039;[[BIT|BIT]]&#039;&#039;&#039;||Campo lógico, admite 1, 0 y NULL||REQ||Marcar para ver únicamente ítems con saldo, sin marcar muestra todo.<br /> |-<br /> |6||FATRIBUTOS||Atributos||&#039;&#039;&#039;[[BIT|BIT]]&#039;&#039;&#039;||Campo lógico, admite 1, 0 y NULL||REQ||Marcar para que los artículos con saldo muestren sus atributos (unidad de medida y clasificación por lo menos).<br /> |-<br /> |}<br /> == Observaciones adicionales sobre los campos ==<br /> ==Relaciones==<br /> ==Triggers==</div> Luciano Carou