64 lines
13 KiB
XML
64 lines
13 KiB
XML
<?xml version="1.0" encoding="UTF-8" ?>
|
|
<ManagedForm databaseName="smarmotech" gstVersion="22800" name="ManagedForm" uid="{21564f45-882e-4565-b7b8-a0bfd46fa5f1}">
|
|
<AGSettings/>
|
|
<Record additionalTables="" joinLeft="" joinOperator="" joinRight="" name="Undefined" order="" uid="{e2d45d94-971d-470b-8606-e27a96297b40}" where="">
|
|
<RecordField colName="tipo_emp" fieldIdRef="0" fieldType="TABLE_COLUMN" name="notb00010.tipo_emp" sqlTabName="notb00010" sqlType="CHAR" table_alias_name="" uid="{47ae73d7-bbf4-413e-a028-1fa0947af28d}"/>
|
|
<RecordField colName="descr" fieldIdRef="1" name="descr" sqlTabName="formonly" table_alias_name="" uid="{ed8af583-1cb2-4fd8-a941-074e9d0d19f8}"/>
|
|
<RecordField colName="h_normal" fieldIdRef="6" fieldType="TABLE_COLUMN" name="notb00010.h_normal" precisionDecimal="8" scaleDecimal="2" sqlTabName="notb00010" sqlType="DECIMAL" table_alias_name="" uid="{ef4b6b9d-fc2d-4c0d-8559-08a91e6e9a24}"/>
|
|
<RecordField colName="num_nomi" fieldIdRef="2" fieldType="TABLE_COLUMN" name="notb00010.num_nomi" sqlTabName="notb00010" sqlType="INTEGER" table_alias_name="" uid="{4716f355-5c98-4191-aca9-46b11da12c85}"/>
|
|
<RecordField colName="mes" fieldIdRef="3" fieldType="TABLE_COLUMN" name="notb00010.mes" sqlTabName="notb00010" sqlType="SMALLINT" table_alias_name="" uid="{94d53c45-7cad-43bf-b720-3d6b49afbf0f}"/>
|
|
<RecordField colName="ano" fieldIdRef="5" fieldType="TABLE_COLUMN" name="notb00010.ano" sqlTabName="notb00010" sqlType="SMALLINT" table_alias_name="" uid="{5eb89847-2231-415f-822a-67eb079a4fba}"/>
|
|
<RecordField colName="num_sem" fieldIdRef="7" fieldType="TABLE_COLUMN" name="notb00010.num_sem" sqlTabName="notb00010" sqlType="SMALLINT" table_alias_name="" uid="{ad88e290-a6cb-4529-84f6-09b813711d8f}"/>
|
|
<RecordField colName="nombre_mes" fieldIdRef="4" name="nombre_mes" sqlTabName="formonly" table_alias_name="" uid="{a80c976b-4576-4d76-9ad3-13abddcaf4d6}"/>
|
|
<RecordField colName="fecha_del" fieldIdRef="8" fieldType="TABLE_COLUMN" name="notb00010.fecha_del" sqlTabName="notb00010" sqlType="DATE" table_alias_name="" uid="{5824b1e9-de15-480e-868e-d981ff1444f2}"/>
|
|
<RecordField colName="fecha_al" fieldIdRef="9" fieldType="TABLE_COLUMN" name="notb00010.fecha_al" sqlTabName="notb00010" sqlType="DATE" table_alias_name="" uid="{7a9367ee-d0eb-4489-ad9f-d82a97974eed}"/>
|
|
<RecordField colName="status_t" fieldIdRef="10" fieldType="TABLE_COLUMN" name="notb00010.status_t" sqlTabName="notb00010" sqlType="CHAR" table_alias_name="" uid="{49e04d38-b7b9-49ed-93ef-0177bdc7208c}"/>
|
|
<RecordField colName="us_crea" fieldIdRef="11" fieldType="TABLE_COLUMN" name="notb00010.us_crea" sqlTabName="notb00010" sqlType="CHAR" table_alias_name="" uid="{5aef70e0-6163-475c-8dbf-fc94f880fe47}"/>
|
|
<RecordField colName="us_mod" fieldIdRef="13" fieldType="TABLE_COLUMN" name="notb00010.us_mod" sqlTabName="notb00010" sqlType="CHAR" table_alias_name="" uid="{4c872441-ae6b-4357-b9ca-a4975f294719}"/>
|
|
<RecordField colName="fech_crea" fieldIdRef="12" fieldType="TABLE_COLUMN" name="notb00010.fech_crea" sqlTabName="notb00010" sqlType="DATE" table_alias_name="" uid="{d1d8901b-63f5-44ea-89cb-123257edd67f}"/>
|
|
<RecordField colName="fech_mod" fieldIdRef="14" fieldType="TABLE_COLUMN" name="notb00010.fech_mod" sqlTabName="notb00010" sqlType="DATE" table_alias_name="" uid="{3c3c9c8f-f830-4d2d-8e4d-574a882b3fa7}"/>
|
|
<RecordField colName="" fieldIdRef="15" name="Fecha_cierre_nomina" sqlTabName="" table_alias_name="" uid="{72abb568-5104-4d26-9dc7-581759ef43a7}"/>
|
|
</Record>
|
|
<Form gridHeight="14" gridWidth="86" name="nofmmt009" style="basic" text="GENERACION NOMINAS">
|
|
<ToolBar name="ToolBar1">
|
|
<ToolBarItem comment="Nuevo Periodo" image="new" name="nuevo" text="Periodo"/>
|
|
<ToolBarItem comment="Criterio de busqueda" image="find" name="buscar" text="Buscar Periodo"/>
|
|
<ToolBarSeparator name="ToolBarSeparator1"/>
|
|
<ToolBarItem image="quit" name="salir" text="Salir"/>
|
|
</ToolBar>
|
|
<Grid gridHeight="12" gridWidth="83" name="Grid1" posX="2" posY="1">
|
|
<Label posX="2" posY="1" text="Tipo de Empleado:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" autoNext="true" case="upper" colName="tipo_emp" columnCount="" comment="Digite Q- Quincenal, S- Semanal, V- Vendedor" fieldId="0" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="1" include="Q|S|V|J" name="notb00010.tipo_emp" posX="24" posY="1" rowCount="" sqlTabName="notb00010" sqlType="CHAR" stepX="" stepY="" tabIndex="1" table_alias_name="" widget="Edit"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="descr" columnCount="" fieldId="1" gridHeight="1" gridWidth="9" name="descr" noEntry="true" posX="27" posY="1" rowCount="" sqlTabName="formonly" stepX="" stepY="" tabIndex="2" table_alias_name="" widget="Edit"/>
|
|
<Label posX="38" posY="1" text="Horas Normales"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="h_normal" columnCount="" comment="Digite las horas trabajadas" fieldId="6" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="10" name="notb00010.h_normal" posX="54" posY="1" precisionDecimal="8" rowCount="" scaleDecimal="2" sqlTabName="notb00010" sqlType="DECIMAL" stepX="" stepY="" tabIndex="3" table_alias_name="" widget="Edit"/>
|
|
<Label posX="1" posY="3" text="Numero de la Nomina:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" autoNext="true" colName="num_nomi" columnCount="" comment="Digite el numero de la nomina" fieldId="2" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="4" name="notb00010.num_nomi" posX="23" posY="3" rowCount="" sqlTabName="notb00010" sqlType="INTEGER" stepX="" stepY="" tabIndex="4" table_alias_name="" widget="Edit"/>
|
|
<Label posX="1" posY="5" text="Mes:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" autoNext="true" colName="mes" columnCount="" comment="Digite el mes del periodo" fieldId="3" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="2" name="notb00010.mes" posX="7" posY="5" rowCount="" sqlTabName="notb00010" sqlType="SMALLINT" stepX="" stepY="" tabIndex="5" table_alias_name="" widget="Edit"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="nombre_mes" columnCount="" fieldId="4" gridHeight="1" gridWidth="10" name="nombre_mes" noEntry="true" posX="11" posY="5" rowCount="" sqlTabName="formonly" stepX="" stepY="" tabIndex="8" table_alias_name="" widget="Edit"/>
|
|
<Label posX="24" posY="5" text="Ano:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" autoNext="true" colName="ano" columnCount="" comment="Digite el ano del periodo" fieldId="5" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="4" name="notb00010.ano" notNull="true" posX="30" posY="5" required="true" rowCount="" sqlTabName="notb00010" sqlType="SMALLINT" stepX="" stepY="" tabIndex="6" table_alias_name="" widget="Edit"/>
|
|
<Label posX="38" posY="5" text="Numero de Semanas:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" autoNext="true" colName="num_sem" columnCount="" comment="Digite el numero de semanas del mes" fieldId="7" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="1" name="notb00010.num_sem" posX="58" posY="5" rowCount="" sqlTabName="notb00010" sqlType="SMALLINT" stepX="" stepY="" tabIndex="7" table_alias_name="" widget="Edit"/>
|
|
<Label gridHeight="1" gridWidth="7" name="Label3" posX="2" posY="7" text="Fecha De:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="fecha_del" columnCount="" comment="Digite la fecha inicial del periodo" fieldId="8" fieldType="TABLE_COLUMN" format="dd/mm/yyyy" gridHeight="1" gridWidth="10" name="notb00010.fecha_del" posX="11" posY="7" rowCount="" sqlTabName="notb00010" sqlType="DATE" stepX="" stepY="" tabIndex="9" table_alias_name="" widget="Edit"/>
|
|
<Label gridHeight="1" gridWidth="7" name="Label2" posX="22" posY="7" text="Fecha a:"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="fecha_al" columnCount="" comment="Digite la fecha final del periodo" fieldId="9" fieldType="TABLE_COLUMN" format="dd/mm/yyyy" gridHeight="1" gridWidth="10" name="notb00010.fecha_al" posX="30" posY="7" rowCount="" sqlTabName="notb00010" sqlType="DATE" stepX="" stepY="" tabIndex="10" table_alias_name="" widget="Edit"/>
|
|
<Label gridHeight="1" gridWidth="9" name="Label1" posX="42" posY="7" text="Fecha Cierre"/>
|
|
<DateEdit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="" columnCount="" fieldId="15" gridHeight="1" gridWidth="10" name="Fecha_cierre_nomina" posX="55" posY="7" rowCount="" sqlTabName="" stepX="" stepY="" tabIndex="16" table_alias_name="" title="DateEdit1" widget="DateEdit"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="status_t" columnCount="" fieldId="10" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="1" name="notb00010.status_t" noEntry="true" posX="1" posY="8" rowCount="" sqlTabName="notb00010" sqlType="CHAR" stepX="" stepY="" tabIndex="11" table_alias_name="" widget="Edit"/>
|
|
<Label posX="1" posY="9" text="Usuario Creador"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="us_crea" columnCount="" fieldId="11" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="9" name="notb00010.us_crea" noEntry="true" posX="19" posY="9" rowCount="" sqlTabName="notb00010" sqlType="CHAR" stepX="" stepY="" tabIndex="12" table_alias_name="" widget="Edit"/>
|
|
<Label posX="42" posY="9" text="Usuario Modificador"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="us_mod" columnCount="" fieldId="13" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="9" name="notb00010.us_mod" noEntry="true" posX="64" posY="9" rowCount="" sqlTabName="notb00010" sqlType="CHAR" stepX="" stepY="" tabIndex="13" table_alias_name="" widget="Edit"/>
|
|
<Label posX="1" posY="10" text="Fecha Creacion"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="fech_crea" columnCount="" fieldId="12" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="16" name="notb00010.fech_crea" noEntry="true" posX="19" posY="10" rowCount="" sqlTabName="notb00010" sqlType="DATE" stepX="" stepY="" tabIndex="14" table_alias_name="" widget="Edit"/>
|
|
<Label posX="42" posY="10" text="Fecha Modificacion"/>
|
|
<Edit aggregateColName="" aggregateName="" aggregateTableAliasName="" aggregateTableName="" colName="fech_mod" columnCount="" fieldId="14" fieldType="TABLE_COLUMN" gridHeight="1" gridWidth="16" name="notb00010.fech_mod" noEntry="true" posX="64" posY="10" rowCount="" sqlTabName="notb00010" sqlType="DATE" stepX="" stepY="" tabIndex="15" table_alias_name="" widget="Edit"/>
|
|
</Grid>
|
|
</Form>
|
|
<DiagramLayout>
|
|
<![CDATA[AAAAAgAAAEwAewA1AGEAZQBmADcAMABlADAALQA2ADEANgAzAC0ANAA3ADUAYwAtADgAZABiAGYALQBmAGMAOQA0AGYAOAA4ADAAZgBlADQANwB9QCQAAAAAAABAcjAAAAAAAAAAAAAAAAAAAQAAAEwAewA3ADIAYQBiAGIANQA2ADgALQA1ADEAMAA0AC0ANABkADIANgAtADkAZABjADcALQA1ADgAMQA3ADUAOQBlAGYANAAzAGEANwB9QCQAAAAAAABAd/AAAAAAAAAAAAAAAAAAAQAAAEwAewBhAGQAOAA4AGUAMgA5ADAALQBhADYAYwBiAC0ANAA1ADIAOQAtADgANABmADYALQAwADkAYgA4ADEAMwA3ADEAMQBkADgAZgB9QCQAAAAAAABAZgAAAAAAAAAAAAAAAAAAAQAAAEwAewA3AGEAOQAzADYANwBlAGUALQBkADAAZQBiAC0ANAA0ADgAOQAtAGEAZAA5AGYALQBkADgAMgBhADkANwA5ADcANABlAGUAZAB9QCQAAAAAAABAbqAAAAAAAAAAAAAAAAAAAQAAAEwAewA0AGMAOAA3ADIANAA0ADEALQBhAGUANgBiAC0ANAAzADUANwAtAGIAOQBjAGEALQBhADQAOQA3ADUAZgAyADkANAA3ADEAOQB9QCQAAAAAAABAc6AAAAAAAAAAAAAAAAAAAQAAAEwAewA0ADkAZQAwADQAZAAzADgALQBiADcAYgA5AC0ANAA5AGUAZAAtADkAMwBlAGYALQAwADEANwA3AGIAZABjADcAMgAwADgAYwB9QCQAAAAAAABAcMAAAAAAAAAAAAAAAAAAAQAAAEwAewA1AGUAYgA4ADkAOAA0ADcALQAyADIAMwAxAC0ANAAxADUAZgAtADgAMgAyAGEALQA2ADcAZQBiADAANwA5AGEANABmAGIAYQB9QCQAAAAAAABAYyAAAAAAAAAAAAAAAAAAAQAAAEwAewA0ADcAYQBlADcAMwBkADcALQBiAGIAZgA0AC0ANAAxADMAZQAtAGEAMAAyADgALQAxAGYAYQAwADkANAA3AGEAZgAyADgAZAB9QCQAAAAAAABAQwAAAAAAAAAAAAAAAAAAAQAAAEwAewBlAGYANABiADYAYgA5AGQALQBmAGMAMgBkAC0ANABjADAAZAAtADgANQA1ADkALQAwADgAYQA5ADEAZQA2AGUAOQBhADIANAB9QCQAAAAAAABAVQAAAAAAAAAAAAAAAAAAAQAAAEwAewAzAGMAMwBjADkAYwA4AGYALQBmADgAMwAwAC0ANABkADIAZAAtADgAZQA0AGQALQA1ADcANABhADgAOAAyAGIAMwBmAGEANwB9QCQAAAAAAABAdoAAAAAAAAAAAAAAAAAAAQAAAEwAewBlADIAZAA0ADUAZAA5ADQALQA5ADcAMQBkAC0ANAA3ADAAYgAtADgANgAwADYALQBlADIANwBhADkANgAyADkANwBiADQAMAB9AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAEwAewBhADgAMABjADkANwA2AGIALQA0ADUANwA2AC0ANABkADcANgAtADkAYQBkADMALQAxADMAYQBiAGQAZABjAGEAZgA0AGQANgB9QCQAAAAAAABAaOAAAAAAAAAAAAAAAAAAAQAAAEwAewA0ADcAMQA2AGYAMwA1ADUALQA1AGMAOQA4AC0ANAAxADkAMQAtAGEAYwBhADkALQA0ADYAYgAxADEAZABhADEAMgBjADgANQB9QCQAAAAAAABAWsAAAAAAAAAAAAAAAAAAAQAAAEwAewA1ADgAMgA0AGIAMQBlADkALQBkAGUAMQA1AC0ANAA4ADAAZQAtADgANgA4AGUALQBkADkAOAAxAGYAZgAxADQANAA0AGYAMgB9QCQAAAAAAABAa8AAAAAAAAAAAAAAAAAAAQAAAEwAewBkADEAZAA4ADkAMAAxAGIALQA2ADMAZgA1AC0ANAA0AGUAYQAtADgAOQBjAGIALQAxADIAMwAyADUANwBlAGQAZAA2ADcAZgB9QCQAAAAAAABAdRAAAAAAAAAAAAAAAAAAAQAAAEwAewBlAGQAOABhAGYANQA4ADMALQAxAGMAYgAyAC0ANABmAGQAOAAtAGEAOQA0ADEALQAwADcANABlADkAZAAwAGQAMQA5AGYAOAB9QCQAAAAAAABAToAAAAAAAAAAAAAAAAAAAQAAAEwAewA5ADQAZAA1ADMAYwA0ADUALQA3AGMAYQBkAC0ANAAzAGIAZgAtAGIANwAyADAALQAzAGQANgBiADQAOQBhAGYAYgBmADAAZgB9QCQAAAAAAABAYEAAAAAAAAAAAAAAAAAAAQ==]]>
|
|
</DiagramLayout>
|
|
</ManagedForm> |