# Dictionary Service
# GET /api/dictionary/window
Gets the metadata of the window, the metadata of the tabs it contains and the metadata of the list of fields.
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- window identifier.uid- universally unique window identifier.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/window?token=%3Ctoken-generated-for-demo-api%3E&language=es&uuid=a52192bc-fb40-11e8-a479-7a0060f0aa01&id=53102'
# Response Body:
{
"code": 200,
"result": {
"id": 53102,
"uuid": "a52192bc-fb40-11e8-a479-7a0060f0aa01",
"name": "Relation Type",
"description": "",
"help": "",
"is_active": true,
"is_sales_transaction": true,
"window_type": "M",
"tabs": [
{
"id": 53285,
"uuid": "a4a25ff6-fb40-11e8-a479-7a0060f0aa01",
"name": "Tipo Relación",
"description": "",
"help": "",
"table_name": "AD_RelationType",
"sequence": 10,
"tab_level": 0,
"is_active": true,
"is_single_row": false,
"is_advanced_tab": false,
"is_has_tree": false,
"is_info_tab": false,
"is_sort_tab": false,
"is_translation_tab": false,
"is_read_only": false,
"is_insert_record": true,
"is_view": false,
"is_deleteable": true,
"is_document": false,
"is_change_log": false,
"access_level": 7,
"link_column_name": "",
"sort_order_column_name": "",
"sort_yes_no_column_name": "",
"parent_column_name": "",
"display_logic": "",
"commit_warning": "",
"query": "SELECT AD_RelationType.*, (SELECT NVL(AD_Client.Name,'') FROM AD_Client WHERE AD_RelationType.AD_Client_ID=AD_Client.AD_Client_ID) AS \"DisplayColumn_AD_Client_ID\", (SELECT NVL(AD_Org.Name,'') FROM AD_Org WHERE AD_RelationType.AD_Org_ID=AD_Org.AD_Org_ID) AS \"DisplayColumn_AD_Org_ID\", Type_AD_Ref_List_Trl.Name AS \"DisplayColumn_Type\", AD_Reference_Source_ID_AD_Reference_Trl.Name AS \"DisplayColumn_AD_Reference_Source_ID\", Role_Source_AD_Ref_List_Trl.Name AS \"DisplayColumn_Role_Source\", AD_Reference_Target_ID_AD_Reference_Trl.Name AS \"DisplayColumn_AD_Reference_Target_ID\", Role_Target_AD_Ref_List_Trl.Name AS \"DisplayColumn_Role_Target\" FROM AD_RelationType AS AD_RelationType LEFT JOIN AD_Ref_List AS Type_AD_Ref_List ON(Type_AD_Ref_List.Value = AD_RelationType.Type AND Type_AD_Ref_List.AD_Reference_ID = 53332) LEFT JOIN AD_Ref_List_Trl AS Type_AD_Ref_List_Trl ON(Type_AD_Ref_List_Trl.AD_Ref_List_ID = Type_AD_Ref_List.AD_Ref_List_ID AND Type_AD_Ref_List_Trl.AD_Language = 'es_VE') LEFT JOIN AD_Reference AS AD_Reference_Source_ID_AD_Reference ON(AD_Reference_Source_ID_AD_Reference.AD_Reference_ID = AD_RelationType.AD_Reference_Source_ID) LEFT JOIN AD_Reference_Trl AS AD_Reference_Source_ID_AD_Reference_Trl ON(AD_Reference_Source_ID_AD_Reference_Trl.AD_Reference_ID = AD_Reference_Source_ID_AD_Reference.AD_Reference_ID AND AD_Reference_Source_ID_AD_Reference_Trl.AD_Language = 'es_VE') LEFT JOIN AD_Ref_List AS Role_Source_AD_Ref_List ON(Role_Source_AD_Ref_List.Value = AD_RelationType.Role_Source AND Role_Source_AD_Ref_List.AD_Reference_ID = 53331) LEFT JOIN AD_Ref_List_Trl AS Role_Source_AD_Ref_List_Trl ON(Role_Source_AD_Ref_List_Trl.AD_Ref_List_ID = Role_Source_AD_Ref_List.AD_Ref_List_ID AND Role_Source_AD_Ref_List_Trl.AD_Language = 'es_VE') LEFT JOIN AD_Reference AS AD_Reference_Target_ID_AD_Reference ON(AD_Reference_Target_ID_AD_Reference.AD_Reference_ID = AD_RelationType.AD_Reference_Target_ID) LEFT JOIN AD_Reference_Trl AS AD_Reference_Target_ID_AD_Reference_Trl ON(AD_Reference_Target_ID_AD_Reference_Trl.AD_Reference_ID = AD_Reference_Target_ID_AD_Reference.AD_Reference_ID AND AD_Reference_Target_ID_AD_Reference_Trl.AD_Language = 'es_VE') LEFT JOIN AD_Ref_List AS Role_Target_AD_Ref_List ON(Role_Target_AD_Ref_List.Value = AD_RelationType.Role_Target AND Role_Target_AD_Ref_List.AD_Reference_ID = 53331) LEFT JOIN AD_Ref_List_Trl AS Role_Target_AD_Ref_List_Trl ON(Role_Target_AD_Ref_List_Trl.AD_Ref_List_ID = Role_Target_AD_Ref_List.AD_Ref_List_ID AND Role_Target_AD_Ref_List_Trl.AD_Language = 'es_VE')",
"where_clause": "",
"order_by_clause": "",
"parent_tab_uuid": "",
"processes": [],
"fields": [
{
"id": 58065,
"uuid": "8d85bffc-fb40-11e8-a479-7a0060f0aa01",
"name": "Compañía",
"description": "Compañía para esta instalación.",
"help": "Compañía o entidad legal. No se pueden compartir datos entre diferentes compañías.",
"sequence": 10,
"column_name": "AD_Client_ID",
"element_name": "AD_Client_ID",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "@#AD_Client_ID@",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Client",
"key_column_name": "AD_Client.AD_Client_ID",
"display_column_name": "",
"query": "SELECT AD_Client.AD_Client_ID,NULL,NVL(AD_Client.Name,'-1'),AD_Client.IsActive, AD_Client.UUID FROM AD_Client WHERE AD_Client.AD_Client_ID <> 0 ORDER BY 3",
"direct_query": "SELECT AD_Client.AD_Client_ID,NULL,NVL(AD_Client.Name,'-1'),AD_Client.IsActive, AD_Client.UUID FROM AD_Client WHERE AD_Client.AD_Client_ID=?",
"validation_code": "AD_Client.AD_Client_ID <> 0",
"zoom_windows": [
{
"id": 109,
"uuid": "a521762e-fb40-11e8-a479-7a0060f0aa01",
"name": "Compañía",
"description": "Mantener Compañías",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 58069,
"uuid": "8d85ed9c-fb40-11e8-a479-7a0060f0aa01",
"name": "Organización.",
"description": "Entidad organizacional dentro de la compañía.",
"help": "Una organización es una unidad de la compañía o entidad legal - Ej. Tiendas y departamentos. Es posible compartir datos entre organizaciones.",
"sequence": 20,
"column_name": "AD_Org_ID",
"element_name": "AD_Org_ID",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "@#AD_Org_ID@",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Org",
"key_column_name": "AD_Org.AD_Org_ID",
"display_column_name": "",
"query": "SELECT AD_Org.AD_Org_ID,NULL,NVL(AD_Org.Name,'-1'),AD_Org.IsActive, AD_Org.UUID FROM AD_Org WHERE (AD_Org.IsSummary='N' OR AD_Org.AD_Org_ID=0) ORDER BY 3",
"direct_query": "SELECT AD_Org.AD_Org_ID,NULL,NVL(AD_Org.Name,'-1'),AD_Org.IsActive, AD_Org.UUID FROM AD_Org WHERE AD_Org.AD_Org_ID=?",
"validation_code": "(AD_Org.IsSummary='N' OR AD_Org.AD_Org_ID=0)",
"zoom_windows": [
{
"id": 110,
"uuid": "a5210fa4-fb40-11e8-a479-7a0060f0aa01",
"name": "Organización",
"description": "Mantener Organizaciones",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 58068,
"uuid": "8d26ea2c-fb40-11e8-a479-7a0060f0aa01",
"name": "Nombres",
"description": "Identificador alfanumérico de la entidad.",
"help": "El nombre de una entidad (registro) se usa como una opción de búsqueda predeterminada, adicional al código. El nombre es de hasta 60 caracteres de longitud.",
"sequence": 30,
"column_name": "Name",
"element_name": "Name",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": true,
"is_allow_logging": true,
"is_selection_column": true,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 1,
"display_logic": "",
"display_type": 10,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 60
},
{
"id": 58064,
"uuid": "8d7b37c6-fb40-11e8-a479-7a0060f0aa01",
"name": "Activo",
"description": "El registro está activo en el sistema.",
"help": "Hay dos métodos para que los registros no estén disponibles en el sistema: Uno es eliminar el registro; el otro es desactivarlo. Un registro desactivado no está disponible para selección; pero está disponible para Informes.",
"sequence": 40,
"column_name": "IsActive",
"element_name": "IsActive",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": true,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 20,
"default_value": "Y",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 58066,
"uuid": "8d26e8c4-fb40-11e8-a479-7a0060f0aa01",
"name": "Descripción",
"description": "Opción de una breve descripción del registro.",
"help": "Una descripción de hasta 255 caracteres.",
"sequence": 50,
"column_name": "Description",
"element_name": "Description",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": true,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 10,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 255
},
{
"id": 58067,
"uuid": "8d265a62-fb40-11e8-a479-7a0060f0aa01",
"name": "Dirigido",
"description": "Indica si uno \"ve\" el otro lado de la relación para cada punta, o solo para el origen",
"help": "",
"sequence": 60,
"column_name": "IsDirected",
"element_name": "IsDirected",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 20,
"default_value": "N",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 58075,
"uuid": "8d2726fe-fb40-11e8-a479-7a0060f0aa01",
"name": "Tipo",
"description": "Tipo de validación (SQL; Java Script; Java Language)",
"help": "Indica el tipo de validación que ocurrirá. Esto puede ser SQL; Java Script o Java Language.",
"sequence": 70,
"column_name": "Type",
"element_name": "Type",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": true,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 17,
"default_value": "I",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Ref_List",
"key_column_name": "AD_Ref_List.Value",
"display_column_name": "Name",
"query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=53332 ORDER BY 3",
"direct_query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=53332 AND AD_Ref_List.Value=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 58071,
"uuid": "8d0e3b62-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia Origen",
"description": "",
"help": "",
"sequence": 80,
"column_name": "AD_Reference_Source_ID",
"element_name": "AD_Reference_Source_ID",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 18,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Reference",
"key_column_name": "AD_Reference.AD_Reference_ID",
"display_column_name": "Name",
"query": "SELECT AD_Reference.AD_Reference_ID,NULL,NVL(AD_Reference_Trl.Name,'-1'),AD_Reference.IsActive, AD_Reference.UUID FROM AD_Reference INNER JOIN AD_Reference_TRL ON (AD_Reference.AD_Reference_ID=AD_Reference_Trl.AD_Reference_ID AND AD_Reference_Trl.AD_Language='es_VE') WHERE AD_Reference.ValidationType='T'\nAND exists ( /* reference must have an active AD_Ref_Table entry */\n select * from AD_Ref_Table t\n where t.AD_Reference_ID=AD_Reference.AD_Reference_ID\n and t.IsActive='Y'\n) ORDER BY 3",
"direct_query": "SELECT AD_Reference.AD_Reference_ID,NULL,NVL(AD_Reference_Trl.Name,'-1'),AD_Reference.IsActive, AD_Reference.UUID FROM AD_Reference INNER JOIN AD_Reference_TRL ON (AD_Reference.AD_Reference_ID=AD_Reference_Trl.AD_Reference_ID AND AD_Reference_Trl.AD_Language='es_VE') WHERE AD_Reference.ValidationType='T'\nAND exists ( /* reference must have an active AD_Ref_Table entry */\n select * from AD_Ref_Table t\n where t.AD_Reference_ID=AD_Reference.AD_Reference_ID\n and t.IsActive='Y'\n) AND AD_Reference.AD_Reference_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 58072,
"uuid": "8d270656-fb40-11e8-a479-7a0060f0aa01",
"name": "Rol Fuente",
"description": "Si se define, este rol será utilizado como rótulo para el destino a acercar en vez del nombre de la ventana",
"help": "",
"sequence": 90,
"column_name": "Role_Source",
"element_name": "Role_Source",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": true,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 17,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Ref_List",
"key_column_name": "AD_Ref_List.Value",
"display_column_name": "Name",
"query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=53331 ORDER BY 3",
"direct_query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=53331 AND AD_Ref_List.Value=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 50
},
{
"id": 58073,
"uuid": "8d270728-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia Destino",
"description": "",
"help": "",
"sequence": 100,
"column_name": "AD_Reference_Target_ID",
"element_name": "AD_Reference_Target_ID",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 18,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Reference",
"key_column_name": "AD_Reference.AD_Reference_ID",
"display_column_name": "Name",
"query": "SELECT AD_Reference.AD_Reference_ID,NULL,NVL(AD_Reference_Trl.Name,'-1'),AD_Reference.IsActive, AD_Reference.UUID FROM AD_Reference INNER JOIN AD_Reference_TRL ON (AD_Reference.AD_Reference_ID=AD_Reference_Trl.AD_Reference_ID AND AD_Reference_Trl.AD_Language='es_VE') WHERE AD_Reference.ValidationType='T'\nAND exists ( /* reference must have an active AD_Ref_Table entry */\n select * from AD_Ref_Table t\n where t.AD_Reference_ID=AD_Reference.AD_Reference_ID\n and t.IsActive='Y'\n) ORDER BY 3",
"direct_query": "SELECT AD_Reference.AD_Reference_ID,NULL,NVL(AD_Reference_Trl.Name,'-1'),AD_Reference.IsActive, AD_Reference.UUID FROM AD_Reference INNER JOIN AD_Reference_TRL ON (AD_Reference.AD_Reference_ID=AD_Reference_Trl.AD_Reference_ID AND AD_Reference_Trl.AD_Language='es_VE') WHERE AD_Reference.ValidationType='T'\nAND exists ( /* reference must have an active AD_Ref_Table entry */\n select * from AD_Ref_Table t\n where t.AD_Reference_ID=AD_Reference.AD_Reference_ID\n and t.IsActive='Y'\n) AND AD_Reference.AD_Reference_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 58074,
"uuid": "8d2707f0-fb40-11e8-a479-7a0060f0aa01",
"name": "Rol Destino",
"description": "Si se define, este rol será utilizado como rótulo para el destino a acercar en vez del nombre de la ventana",
"help": "",
"sequence": 110,
"column_name": "Role_Target",
"element_name": "Role_Target",
"is_displayed": true,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": true,
"is_encrypted": false,
"is_same_line": true,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": true,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 17,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Ref_List",
"key_column_name": "AD_Ref_List.Value",
"display_column_name": "Name",
"query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=53331 ORDER BY 3",
"direct_query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=53331 AND AD_Ref_List.Value=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 50
},
{
"id": 58070,
"uuid": "8d85eeaa-fb40-11e8-a479-7a0060f0aa01",
"name": "Tipo Relación",
"description": "",
"help": "",
"sequence": 0,
"column_name": "AD_RelationType_ID",
"element_name": "AD_RelationType_ID",
"is_displayed": false,
"is_displayed_grid": true,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": true,
"is_key": true,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": true,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 13,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
}
]
}
]
}
}
# Response Codes:
200when successful500in case of error### GET /api/dictionary/process
Gets the metadata of the process/report, and the metadata of the parameter list (fields).
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- process/report identifier.uuid- universally unique identifier of the process/report.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/process?token=%3Ctoken-generated-for-demo-api%3E&language=es&uuid=a42acf86-fb40-11e8-a479-7a0060f0aa01&id=205'
# Response Body:
{
"code": 200,
"result": {
"id": 205,
"uuid": "a42acf86-fb40-11e8-a479-7a0060f0aa01",
"name": "Reinicia Cache",
"description": "Reinicia el Cache del sitema ** Cerrar todas las ventanas antes de iniciar **",
"help": "Para aumentar funcionamiento, Adempiere reasigna los datos usados. Este proceso despeja el cache local.",
"is_report": false,
"access_level": 7,
"show_help": "",
"is_direct_print": false,
"is_active": true,
"report_export_types": [],
"parameters": []
}
}
# Response Codes:
200when successful500in case of error### GET /api/dictionary/browser
Gets the metadata of the smart browser and the metadata of the parameter list/search criteria (fields) it contains, as well as the metadata of the associated processes without their parameter list (fields).
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- smart query identifier.uuid- universal unique identifier of the smart query.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/browser?token=%3Ctoken-generated-for-demo-api%3E&language=es&uuid=91fa2410-12c9-11e9-865a-17caaf9b4956&id=54137'
# Response Body:
{
"code": 200,
"result": {
"id": 54137,
"uuid": "91fa2410-12c9-11e9-865a-17caaf9b4956",
"value": "ProcessPayrollIncidence",
"name": "Process Incidence (Manual)",
"description": "This Smart Browse allow Approve Incidence by Employee Manual",
"help": "Result of process is a Incidence approved and waiting use in payroll process, after approve you can get sum of incidence by concept using a helper method \"getIncidence(ConceptValue, From, To)\"",
"access_level": 3,
"query": "SELECT hi.HR_Incidence_ID AS \"HI_HR_Incidence_ID\",hi.HR_AttendanceBatch_ID AS \"HI_HR_AttendanceBatch_ID\",hi.AD_Org_ID AS \"HI_AD_Org_ID\",hi.IsActive AS \"HI_IsActive\",hi.Created AS \"HI_Created\",hi.Updated AS \"HI_Updated\",hi.CreatedBy AS \"HI_CreatedBy\",hi.UpdatedBy AS \"HI_UpdatedBy\",hi.ServiceDate AS \"HI_ServiceDate\",hi.HR_ShiftIncidence_ID AS \"HI_HR_ShiftIncidence_ID\",hi.S_TimeExpense_ID AS \"HI_S_TimeExpense_ID\",hi.HR_Concept_ID AS \"HI_HR_Concept_ID\",hi.Processing AS \"HI_Processing\",hi.Qty AS \"HI_Qty\",hi.Amt AS \"HI_Amt\",hi.C_DocType_ID AS \"HI_C_DocType_ID\",hi.C_BPartner_ID AS \"HI_C_BPartner_ID\",hi.AD_Client_ID AS \"HI_AD_Client_ID\",hi.UUID AS \"HI_UUID\",hi.DocumentNo AS \"HI_DocumentNo\",hi.DateDoc AS \"HI_DateDoc\",hi.Processed AS \"HI_Processed\",hi.HR_Employee_ID AS \"HI_HR_Employee_ID\",hi.IsApproved AS \"HI_IsApproved\",hi.Description AS \"HI_Description\",hi.DocStatus AS \"HI_DocStatus\",hi.DocAction AS \"HI_DocAction\",hi.IsManual AS \"HI_IsManual\",hi.DocumentNote AS \"HI_DocumentNote\", (SELECT NVL(C_BPartner.Name,'') FROM C_BPartner WHERE hi.C_BPartner_ID=C_BPartner.C_BPartner_ID) AS \"DisplayColumn_HI_C_BPartner_ID\", (SELECT NVL(HR_Concept.Value,'')||' - '||NVL(HR_Concept.Name,'') FROM HR_Concept WHERE hi.HR_Concept_ID=HR_Concept.HR_Concept_ID) AS \"DisplayColumn_HI_HR_Concept_ID\", IsManual_AD_Ref_List_Trl.Name AS \"DisplayColumn_HI_IsManual\", (SELECT NVL(HR_ShiftIncidence.Description,'')||' - '||NVL(HR_ShiftIncidence.EventType,'') FROM HR_ShiftIncidence WHERE hi.HR_ShiftIncidence_ID=HR_ShiftIncidence.HR_ShiftIncidence_ID) AS \"DisplayColumn_HI_HR_ShiftIncidence_ID\", (SELECT NVL(HR_AttendanceBatch.DocumentNo,'')||' - '||NVL((SELECT NVL(C_BPartner.Name,'') FROM C_BPartner WHERE HR_AttendanceBatch.C_BPartner_ID=C_BPartner.C_BPartner_ID),'') FROM HR_AttendanceBatch WHERE hi.HR_AttendanceBatch_ID=HR_AttendanceBatch.HR_AttendanceBatch_ID) AS \"DisplayColumn_HI_HR_AttendanceBatch_ID\", DocStatus_AD_Ref_List_Trl.Name AS \"DisplayColumn_HI_DocStatus\" FROM HR_Incidence hi LEFT JOIN AD_Ref_List AS IsManual_AD_Ref_List ON(IsManual_AD_Ref_List.Value = hi.IsManual AND IsManual_AD_Ref_List.AD_Reference_ID = 319) LEFT JOIN AD_Ref_List_Trl AS IsManual_AD_Ref_List_Trl ON(IsManual_AD_Ref_List_Trl.AD_Ref_List_ID = IsManual_AD_Ref_List.AD_Ref_List_ID AND IsManual_AD_Ref_List_Trl.AD_Language = 'es_VE') LEFT JOIN AD_Ref_List AS DocStatus_AD_Ref_List ON(DocStatus_AD_Ref_List.Value = hi.DocStatus AND DocStatus_AD_Ref_List.AD_Reference_ID = 131) LEFT JOIN AD_Ref_List_Trl AS DocStatus_AD_Ref_List_Trl ON(DocStatus_AD_Ref_List_Trl.AD_Ref_List_ID = DocStatus_AD_Ref_List.AD_Ref_List_ID AND DocStatus_AD_Ref_List_Trl.AD_Language = 'es_VE')",
"where_clause": "hi.Processed = 'N'",
"order_by_clause": "19,18,23",
"is_updateable": false,
"is_deleteable": false,
"is_selected_by_default": false,
"is_collapsible_by_default": true,
"is_executed_query_by_default": false,
"is_show_total": true,
"view_uuid": "1996f034-12c9-11e9-85f8-1ba35068cb15",
"window": {
"id": 53627,
"uuid": "c31e4ff0-12c7-11e9-a96e-23babc97a8af",
"name": "Payroll Incidence",
"description": "Payroll Incidence",
"help": "",
"is_active": true,
"is_sales_transaction": true,
"window_type": "M",
"tabs": []
},
"process": {
"id": 54137,
"uuid": "915f8752-12c9-11e9-8653-3bd574d3ac4a",
"name": "Procesar Incidencia de Nómina",
"description": "Procesar Incidencia de Nómina Manual",
"help": "Procesar Incidencia de Nómina Manual desde Visor Inteligente",
"is_report": false,
"access_level": 3,
"show_help": "",
"is_direct_print": false,
"is_active": true,
"report_export_types": [],
"parameters": []
},
"is_active": true,
"fields": [
{
"id": 62496,
"uuid": "9469fedc-12c9-11e9-96d0-4b1db6847096",
"name": "Tipo de Documento",
"description": "Tipo de documento o reglas",
"help": "El tipo de documento determina la secuencia del documento y las reglas de proceso",
"sequence": 0,
"column_name": "HI_C_DocType_ID",
"element_name": "C_DocType_ID",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "C_DocType",
"key_column_name": "C_DocType.C_DocType_ID",
"display_column_name": "",
"query": "SELECT C_DocType.C_DocType_ID,NULL,NVL(C_DocType_Trl.Name,'-1'),C_DocType.IsActive, C_DocType.UUID FROM C_DocType INNER JOIN C_DocType_TRL ON (C_DocType.C_DocType_ID=C_DocType_Trl.C_DocType_ID AND C_DocType_Trl.AD_Language='es_VE') ORDER BY 3",
"direct_query": "SELECT C_DocType.C_DocType_ID,NULL,NVL(C_DocType_Trl.Name,'-1'),C_DocType.IsActive, C_DocType.UUID FROM C_DocType INNER JOIN C_DocType_TRL ON (C_DocType.C_DocType_ID=C_DocType_Trl.C_DocType_ID AND C_DocType_Trl.AD_Language='es_VE') WHERE C_DocType.C_DocType_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 135,
"uuid": "a520e196-fb40-11e8-a479-7a0060f0aa01",
"name": "Tipo de Documento",
"description": "Mantener tipos de documentos",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 20,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62498,
"uuid": "95025f9c-12c9-11e9-96d6-933ef003f1df",
"name": "Creado Por.",
"description": "Usuario que creó este registro.",
"help": "El campo creado por, indica el usuario que creó este registro.",
"sequence": 0,
"column_name": "HI_CreatedBy",
"element_name": "CreatedBy",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 18,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_User",
"key_column_name": "AD_User.AD_User_ID",
"display_column_name": "Name",
"query": "SELECT AD_User.AD_User_ID,NULL,NVL(AD_User.Name,'-1'),AD_User.IsActive, AD_User.UUID FROM AD_User ORDER BY AD_User.Name",
"direct_query": "SELECT AD_User.AD_User_ID,NULL,NVL(AD_User.Name,'-1'),AD_User.IsActive, AD_User.UUID FROM AD_User WHERE AD_User.AD_User_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 108,
"uuid": "a5216710-fb40-11e8-a479-7a0060f0aa01",
"name": "Usuario",
"description": "Mantener Usuarios del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62497,
"uuid": "94b6aa16-12c9-11e9-96d3-bb81cd3c43ae",
"name": "Compañía",
"description": "Compañía para esta instalación.",
"help": "Compañía o entidad legal. No se pueden compartir datos entre diferentes compañías.",
"sequence": 0,
"column_name": "HI_AD_Client_ID",
"element_name": "AD_Client_ID",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Client",
"key_column_name": "AD_Client.AD_Client_ID",
"display_column_name": "",
"query": "SELECT AD_Client.AD_Client_ID,NULL,NVL(AD_Client.Name,'-1'),AD_Client.IsActive, AD_Client.UUID FROM AD_Client ORDER BY 3",
"direct_query": "SELECT AD_Client.AD_Client_ID,NULL,NVL(AD_Client.Name,'-1'),AD_Client.IsActive, AD_Client.UUID FROM AD_Client WHERE AD_Client.AD_Client_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 109,
"uuid": "a521762e-fb40-11e8-a479-7a0060f0aa01",
"name": "Compañía",
"description": "Mantener Compañías",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62489,
"uuid": "924895b4-12c9-11e9-96bb-839213352d8c",
"name": "Organización.",
"description": "Entidad organizacional dentro de la compañía.",
"help": "Una organización es una unidad de la compañía o entidad legal - Ej. Tiendas y departamentos. Es posible compartir datos entre organizaciones.",
"sequence": 0,
"column_name": "HI_AD_Org_ID",
"element_name": "AD_Org_ID",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Org",
"key_column_name": "AD_Org.AD_Org_ID",
"display_column_name": "",
"query": "SELECT AD_Org.AD_Org_ID,NULL,NVL(AD_Org.Name,'-1'),AD_Org.IsActive, AD_Org.UUID FROM AD_Org ORDER BY 3",
"direct_query": "SELECT AD_Org.AD_Org_ID,NULL,NVL(AD_Org.Name,'-1'),AD_Org.IsActive, AD_Org.UUID FROM AD_Org WHERE AD_Org.AD_Org_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 110,
"uuid": "a5210fa4-fb40-11e8-a479-7a0060f0aa01",
"name": "Organización",
"description": "Mantener Organizaciones",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62490,
"uuid": "9298f05e-12c9-11e9-96be-0fb2df723d1a",
"name": "Creado.",
"description": "Fecha de creación de este registro.",
"help": "El campo creado, indica la fecha en que este registro fue creado.",
"sequence": 0,
"column_name": "HI_Created",
"element_name": "Created",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 16,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 0
},
{
"id": 62491,
"uuid": "92e4f6b6-12c9-11e9-96c1-ef8f1ad8a8c9",
"name": "Empleado Nómina",
"description": "",
"help": "",
"sequence": 0,
"column_name": "HI_HR_Employee_ID",
"element_name": "HR_Employee_ID",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 30,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "HR_Employee",
"key_column_name": "HR_Employee.HR_Employee_ID",
"display_column_name": "C_BPartner_ID",
"query": "SELECT HR_Employee.HR_Employee_ID,NULL,NVL(HR_Employee.C_BPartner_ID,'-1'),HR_Employee.IsActive, HR_Employee.UUID FROM HR_Employee ORDER BY 3",
"direct_query": "SELECT HR_Employee.HR_Employee_ID,NULL,NVL(HR_Employee.C_BPartner_ID,'-1'),HR_Employee.IsActive, HR_Employee.UUID FROM HR_Employee WHERE HR_Employee.HR_Employee_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 53323,
"uuid": "a521f428-fb40-11e8-a479-7a0060f0aa01",
"name": "Empleado (Todos)",
"description": "Mantenimiento de Empleados",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 53033,
"uuid": "a521befe-fb40-11e8-a479-7a0060f0aa01",
"name": "Empleado",
"description": "Mantenimiento de empleados de nómina",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62492,
"uuid": "9330f566-12c9-11e9-96c4-e7760cbfff5d",
"name": "Actualizado.",
"description": "Permite ver si algún registro en especifico esta actualizado.",
"help": "Permite ver si algún registro en especifico esta actualizado.",
"sequence": 0,
"column_name": "HI_Updated",
"element_name": "Updated",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 16,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 0
},
{
"id": 62499,
"uuid": "9550fea4-12c9-11e9-96d9-e743fb5d90c5",
"name": "Descripción",
"description": "Opción de una breve descripción del registro.",
"help": "Una descripción de hasta 255 caracteres.",
"sequence": 0,
"column_name": "HI_Description",
"element_name": "Description",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 14,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 255
},
{
"id": 62500,
"uuid": "95a145bc-12c9-11e9-96dc-cf25db51e6fe",
"name": "Acción en el Documento",
"description": "El estado destino del documento",
"help": "Usted encuentra el estado actual en el campo Estado del Documento. Las opciones son listadas en una ventana emergente",
"sequence": 0,
"column_name": "HI_DocAction",
"element_name": "DocAction",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 28,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 2
},
{
"id": 62501,
"uuid": "95f07e48-12c9-11e9-96df-9bddbe0796b4",
"name": "Activo",
"description": "El registro está activo en el sistema.",
"help": "Hay dos métodos para que los registros no estén disponibles en el sistema: Uno es eliminar el registro; el otro es desactivarlo. Un registro desactivado no está disponible para selección; pero está disponible para Informes.",
"sequence": 0,
"column_name": "HI_IsActive",
"element_name": "IsActive",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 20,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 62503,
"uuid": "96915598-12c9-11e9-96e5-974ad45a3699",
"name": "Procesado",
"description": "El documento ha sido procesado",
"help": "El cuadro de verificación procesada indica que un documento ha sido procesado",
"sequence": 0,
"column_name": "HI_Processed",
"element_name": "Processed",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 20,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 62504,
"uuid": "96dccf0a-12c9-11e9-96e8-c71fc4784c14",
"name": "Procesar Ahora",
"description": "",
"help": "",
"sequence": 0,
"column_name": "HI_Processing",
"element_name": "Processing",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 20,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 62505,
"uuid": "972b8c3a-12c9-11e9-865d-a36087875605",
"name": "Immutable Universally Unique Identifier",
"description": "Immutable Universally Unique Identifier",
"help": "\"A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data, unlike a natural (or business) key which is derived from application data. \" , According to Wikipedia http://en.wikipedia.org/wiki/Surrogate_key",
"sequence": 0,
"column_name": "HI_UUID",
"element_name": "UUID",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 10,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 36
},
{
"id": 62506,
"uuid": "977c3c5c-12c9-11e9-8660-27c58e303de0",
"name": "Actualizado por.",
"description": "User who updated this records",
"help": "The Updated By field indicates the user who updated this record.",
"sequence": 0,
"column_name": "HI_UpdatedBy",
"element_name": "UpdatedBy",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 18,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_User",
"key_column_name": "AD_User.AD_User_ID",
"display_column_name": "Name",
"query": "SELECT AD_User.AD_User_ID,NULL,NVL(AD_User.Name,'-1'),AD_User.IsActive, AD_User.UUID FROM AD_User ORDER BY AD_User.Name",
"direct_query": "SELECT AD_User.AD_User_ID,NULL,NVL(AD_User.Name,'-1'),AD_User.IsActive, AD_User.UUID FROM AD_User WHERE AD_User.AD_User_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 108,
"uuid": "a5216710-fb40-11e8-a479-7a0060f0aa01",
"name": "Usuario",
"description": "Mantener Usuarios del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62507,
"uuid": "97ca8358-12c9-11e9-8663-ab643c122f68",
"name": "Aprobado",
"description": "Indica si este documento requiere aprobación",
"help": "El Cuadro de Verificación Aprobado indica si este documento requiere aprobación antes de que pueda ser procesado",
"sequence": 0,
"column_name": "HI_IsApproved",
"element_name": "IsApproved",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 17,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Ref_List",
"key_column_name": "AD_Ref_List.Value",
"display_column_name": "Name",
"query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=319 ORDER BY 3",
"direct_query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=319 AND AD_Ref_List.Value=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 100,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 62511,
"uuid": "99010562-12c9-11e9-866f-07de9591c27d",
"name": "Incidencia de Nómina",
"description": "Incidencia de Nómina para Empleado",
"help": "",
"sequence": 10,
"column_name": "HI_HR_Incidence_ID",
"element_name": "HR_Incidence_ID",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": true,
"is_parent": false,
"is_updateable": false,
"is_identifier": true,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 13,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62508,
"uuid": "9816dee2-12c9-11e9-8666-db66b32a30c6",
"name": "No. del Documento",
"description": "Número de secuencia del documento para cada documento",
"help": "El número del documento es usualmente generado en automático por el sistema y determinado por el tipo del documento. Si el documento no se salva; el número preliminar se despliega entre El número del documento es usualmente generado en automático por el sistema y determinado por el tipo del documento. Si el documento no se salva; el número preliminar se despliega entre \"<>\".\n\n Si el tipo de documento de su documento no tiene secuencia automatica definida, el campo está vacío si usted crea un nuevo doc. Esto es para documentos los cuales usualmente tiene un número externo (Como factura de proveedor). Si usted deja este campo vacío, el sistema generará un número de doc para usted.",
"sequence": 20,
"column_name": "HI_DocumentNo",
"element_name": "DocumentNo",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 10,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 60
},
{
"id": 62515,
"uuid": "9a411188-12c9-11e9-867b-d3f7b8840a51",
"name": "F. Documento",
"description": "Fecha del documento",
"help": "La fecha del documento indica la fecha en que el documento fue generado. Puede o no ser la misma que la fecha contable.",
"sequence": 30,
"column_name": "HI_DateDoc",
"element_name": "DateDoc",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": true,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 15,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": true,
"is_order_by": true,
"seq_no_grid": 30,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 0
},
{
"id": 62495,
"uuid": "941c61e0-12c9-11e9-96cd-dff72d21296e",
"name": "Socio del Negocio",
"description": "Identifica un Socio del Negocio",
"help": "Un Socio del Negocio es cualquiera con quien usted realiza transacciones. Este puede incluir Proveedores; Clientes; Empleados o Vendedores.",
"sequence": 40,
"column_name": "HI_C_BPartner_ID",
"element_name": "C_BPartner_ID",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 30,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "C_BPartner",
"key_column_name": "C_BPartner.C_BPartner_ID",
"display_column_name": "",
"query": "SELECT C_BPartner.C_BPartner_ID,NULL,NVL(C_BPartner.Name,'-1'),C_BPartner.IsActive, C_BPartner.UUID FROM C_BPartner ORDER BY 3",
"direct_query": "SELECT C_BPartner.C_BPartner_ID,NULL,NVL(C_BPartner.Name,'-1'),C_BPartner.IsActive, C_BPartner.UUID FROM C_BPartner WHERE C_BPartner.C_BPartner_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 123,
"uuid": "a520de12-fb40-11e8-a479-7a0060f0aa01",
"name": "Socio del Negocio",
"description": "Mantener Socios del Negocio",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": true,
"seq_no_grid": 10,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62510,
"uuid": "98b4733c-12c9-11e9-866c-cb9a9781a44f",
"name": "Concepto Nómina.",
"description": "The Payroll Concept allows to define all the perception and deductions elements needed to define a payroll.",
"help": "",
"sequence": 50,
"column_name": "HI_HR_Concept_ID",
"element_name": "HR_Concept_ID",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": true,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "HR_Concept",
"key_column_name": "HR_Concept.HR_Concept_ID",
"display_column_name": "",
"query": "SELECT HR_Concept.HR_Concept_ID,NULL,NVL(HR_Concept.Value,'-1') ||'_'|| NVL(HR_Concept.Name,'-1'),HR_Concept.IsActive, HR_Concept.UUID FROM HR_Concept ORDER BY 3",
"direct_query": "SELECT HR_Concept.HR_Concept_ID,NULL,NVL(HR_Concept.Value,'-1') ||'_'|| NVL(HR_Concept.Name,'-1'),HR_Concept.IsActive, HR_Concept.UUID FROM HR_Concept WHERE HR_Concept.HR_Concept_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 53036,
"uuid": "a521bff8-fb40-11e8-a479-7a0060f0aa01",
"name": "Catálogo de Conceptos",
"description": "Mantenimiento del catálogo de conceptos de nómina",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 60,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62493,
"uuid": "9382db7e-12c9-11e9-96c7-0f6d5e4ad1d2",
"name": "Cantidad",
"description": "Cantidad",
"help": "La Cantidad indica el número de un producto específico o artículo para este documento",
"sequence": 60,
"column_name": "HI_Qty",
"element_name": "Qty",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": true,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 29,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 0
},
{
"id": 62494,
"uuid": "93ce838a-12c9-11e9-96ca-578e44355433",
"name": "Monto",
"description": "Monto",
"help": "Monto",
"sequence": 70,
"column_name": "HI_Amt",
"element_name": "Amt",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": true,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 12,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 0
},
{
"id": 62502,
"uuid": "9643517c-12c9-11e9-96e2-1384234c5c6a",
"name": "F. Servicio",
"description": "Fecha en que el servicio fue proporcionado",
"help": "La fecha del servicio indica la fecha en que el servicio fue proveído.",
"sequence": 80,
"column_name": "HI_ServiceDate",
"element_name": "ServiceDate",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": true,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 15,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": true,
"is_order_by": true,
"seq_no_grid": 40,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 0
},
{
"id": 62514,
"uuid": "99e96c30-12c9-11e9-8678-37842c324d22",
"name": "Manual",
"description": "Éste es un proceso manual.",
"help": "El cuadro de verificación manual indica si el proceso será hecho manualmente.",
"sequence": 90,
"column_name": "HI_IsManual",
"element_name": "IsManual",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 17,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Ref_List",
"key_column_name": "AD_Ref_List.Value",
"display_column_name": "Name",
"query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=319 ORDER BY 3",
"direct_query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=319 AND AD_Ref_List.Value=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 90,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 1
},
{
"id": 62516,
"uuid": "9a928bda-12c9-11e9-aeff-c7b9ac47fa76",
"name": "Incidencia de Turno",
"description": "Incidencias que Aplican para un Turno",
"help": "Usado para configurar las incidencias que aplican a un determinado turno",
"sequence": 100,
"column_name": "HI_HR_ShiftIncidence_ID",
"element_name": "HR_ShiftIncidence_ID",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "HR_ShiftIncidence",
"key_column_name": "HR_ShiftIncidence.HR_ShiftIncidence_ID",
"display_column_name": "",
"query": "SELECT HR_ShiftIncidence.HR_ShiftIncidence_ID,NULL,NVL(HR_ShiftIncidence.Description,'-1') ||'_'|| NVL(HR_ShiftIncidence.EventType,'-1'),HR_ShiftIncidence.IsActive, HR_ShiftIncidence.UUID FROM HR_ShiftIncidence ORDER BY 3",
"direct_query": "SELECT HR_ShiftIncidence.HR_ShiftIncidence_ID,NULL,NVL(HR_ShiftIncidence.Description,'-1') ||'_'|| NVL(HR_ShiftIncidence.EventType,'-1'),HR_ShiftIncidence.IsActive, HR_ShiftIncidence.UUID FROM HR_ShiftIncidence WHERE HR_ShiftIncidence.HR_ShiftIncidence_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 53302,
"uuid": "a521d6a0-fb40-11e8-a479-7a0060f0aa01",
"name": "Turno de Trabajo",
"description": "Mantenimiento a turnos de trabajo.",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 53304,
"uuid": "a521d79a-fb40-11e8-a479-7a0060f0aa01",
"name": "Grupo de Turnos",
"description": "Mantenimiento al grupo de turnos.",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 70,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62509,
"uuid": "98647fda-12c9-11e9-8669-478fe6a50d39",
"name": "Lote de Asistencia",
"description": "Documento de Lote de Asistencia",
"help": "",
"sequence": 110,
"column_name": "HI_HR_AttendanceBatch_ID",
"element_name": "HR_AttendanceBatch_ID",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 19,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "HR_AttendanceBatch",
"key_column_name": "HR_AttendanceBatch.HR_AttendanceBatch_ID",
"display_column_name": "",
"query": "SELECT HR_AttendanceBatch.HR_AttendanceBatch_ID,NULL,NVL(HR_AttendanceBatch.DocumentNo,'-1') ||'_'|| NVL((SELECT NVL(C_BPartner.Name,''), HR_AttendanceBatch.UUID FROM C_BPartner WHERE HR_AttendanceBatch.C_BPartner_ID=C_BPartner.C_BPartner_ID),'-1'),HR_AttendanceBatch.IsActive FROM HR_AttendanceBatch ORDER BY 3",
"direct_query": "SELECT HR_AttendanceBatch.HR_AttendanceBatch_ID,NULL,NVL(HR_AttendanceBatch.DocumentNo,'-1') ||'_'|| NVL((SELECT NVL(C_BPartner.Name,''), HR_AttendanceBatch.UUID FROM C_BPartner WHERE HR_AttendanceBatch.C_BPartner_ID=C_BPartner.C_BPartner_ID),'-1'),HR_AttendanceBatch.IsActive FROM HR_AttendanceBatch WHERE HR_AttendanceBatch.HR_AttendanceBatch_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 53625,
"uuid": "90ff675c-12c7-11e9-946f-dbabcc08830c",
"name": "Registro de Asistencia",
"description": "Documento de Registro de Asistencia",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 80,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 10
},
{
"id": 62512,
"uuid": "994f172a-12c9-11e9-8672-c3aac73d4bc8",
"name": "Estado del Documento",
"description": "El estado actual del documento",
"help": "El estado del documento indica el estado del documento en este momento. Si usted quiere cambiar el estado de Documento; use el campo acción de documento",
"sequence": 120,
"column_name": "HI_DocStatus",
"element_name": "DocStatus",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 17,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"reference": {
"table_name": "AD_Ref_List",
"key_column_name": "AD_Ref_List.Value",
"display_column_name": "Name",
"query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=131 ORDER BY 3",
"direct_query": "SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive, AD_Ref_List.UUID FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language='es_VE') WHERE AD_Ref_List.AD_Reference_ID=131 AND AD_Ref_List.Value=?",
"validation_code": "",
"zoom_windows": [
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
},
{
"id": 101,
"uuid": "a5212b92-fb40-11e8-a479-7a0060f0aa01",
"name": "Referencia",
"description": "Mantener Referencias del Sistema",
"is_sales_transaction": true,
"is_active": false
}
]
},
"is_query_criteria": true,
"is_order_by": false,
"seq_no_grid": 50,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 2
},
{
"id": 62513,
"uuid": "999c34f6-12c9-11e9-8675-fb1cb9c28833",
"name": "Nota de Documento",
"description": "Información adicional para un documento",
"help": "La nota de documento se usa para registrar cualquier información adicional considerando este producto.",
"sequence": 130,
"column_name": "HI_DocumentNote",
"element_name": "DocumentNote",
"is_displayed": true,
"is_displayed_grid": false,
"is_read_only": true,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 14,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 2000
}
]
}
}
# Response Codes:
200when successful500in case of error
# GET /api/dictionary/form
Gets the form metadata.
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- form identifier.uuid- universally unique identifier of the form.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/form?token=%3Ctoken-generated-for-demo-api%3E&language=es&uuid=8e427700-fb40-11e8-a479-7a0060f0aa01&id=113'
# Response Body:
{
"code": 200,
"result": {
"id": 113,
"uuid": "8e427700-fb40-11e8-a479-7a0060f0aa01",
"name": "Punto de Venta",
"description": "Terminal de Punto de Venta",
"help": "Ingresar transacciones a través de una terminal de punto de venta. Automáticamente, tarjetas de crédito son reconocidas.",
"access_level": 0,
"file_name": "VPOS",
"is_active": true
}
}
# Response Codes:
200when successful500in case of error
# GET /api/dictionary/field
Gets the metadata of the form.
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- field identifier.uuid- universally unique identifier of the field.element_uuid- universally unique identifier of the element.table_name- table where the field is referenced.column_name- column name of the field in the table.element_column_name- name of the element column in the table.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/field?token=%3Ctoken-generated-for-demo-api%3E&language=es&element_column_name=ProductValue'
# Response Body:
{
"code": 200,
"result": {
"id": 1675,
"uuid": "8cc8589a-fb40-11e8-a479-7a0060f0aa01",
"name": "Código Producto",
"description": "Código del producto",
"help": "",
"sequence": 0,
"column_name": "ProductValue",
"element_name": "ProductValue",
"is_displayed": false,
"is_displayed_grid": false,
"is_read_only": false,
"is_allow_copy": false,
"is_encrypted": false,
"is_same_line": false,
"is_heading": false,
"is_field_only": false,
"is_quick_entry": false,
"is_mandatory": false,
"is_key": false,
"is_parent": false,
"is_updateable": false,
"is_identifier": false,
"is_allow_logging": false,
"is_selection_column": false,
"is_range": false,
"is_always_updateable": false,
"is_translated": false,
"identifier_sequence": 0,
"display_logic": "",
"display_type": 10,
"default_value": "",
"read_only_logic": "",
"mandatory_logic": "",
"callout": "",
"column_sql": "",
"v_format": "",
"value_min": "",
"value_max": "",
"format_pattern": "",
"is_query_criteria": false,
"is_order_by": false,
"seq_no_grid": 0,
"sort_no": 0,
"is_info_only": false,
"is_active": true,
"default_value_to": "",
"field_length": 40
}
}
# Response Codes:
200when successful500in case of error
# GET /api/dictionary/reference
Gets the metadata of the reference.
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- identifier of the reference.uuid- universally unique identifier of the reference.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/reference?token=%3Ctoken-generated-for-demo-api%3E&language=es&uuid=a47df90e-fb40-11e8-a479-7a0060f0aa01'
# Response Body:
{
"code": 200,
"result": {
"table_name": "AD_Column",
"key_column_name": "AD_Column.AD_Column_ID",
"display_column_name": "Name",
"query": "SELECT AD_Column.AD_Column_ID,NULL,NVL(AD_Column_Trl.Name,'-1'),AD_Column.IsActive, AD_Column.UUID FROM AD_Column INNER JOIN AD_Column_TRL ON (AD_Column.AD_Column_ID=AD_Column_Trl.AD_Column_ID AND AD_Column_Trl.AD_Language='es_VE') WHERE AD_Column.AD_Reference_ID=20 ORDER BY AD_Column.Name",
"direct_query": "SELECT AD_Column.AD_Column_ID,NULL,NVL(AD_Column_Trl.Name,'-1'),AD_Column.IsActive, AD_Column.UUID FROM AD_Column INNER JOIN AD_Column_TRL ON (AD_Column.AD_Column_ID=AD_Column_Trl.AD_Column_ID AND AD_Column_Trl.AD_Language='es_VE') WHERE AD_Column.AD_Reference_ID=20 AND AD_Column.AD_Column_ID=?",
"validation_code": "",
"zoom_windows": [
{
"id": 100,
"uuid": "a5212b06-fb40-11e8-a479-7a0060f0aa01",
"name": "Tabla y Columna",
"description": "Mantener tablas y columnas",
"is_sales_transaction": true,
"is_active": false
}
]
}
}
# Response Codes:
200when successful500in case of error
# GET /api/dictionary/validation
Gets the metadata of the validation rule.
# Parameters:
token- user token returned fromPOST /adempiere-api/user/login.language- language for response translations.id- validation rule identifier.uuid- universally unique identifier of the validation rule.
# Body of the Petitión:
null
# Example of a Call:
curl --silent --location --request GET 'https://api.erpya.com/api/adempiere/dictionary/validation?token=%3Ctoken-generated-for-demo-api%3E&language=es&uuid=a4cac0ae-fb40-11e8-a479-7a0060f0aa01'
# Response Body:
{
"code": 200,
"result": {
"id": 52461,
"uuid": "a4cac0ae-fb40-11e8-a479-7a0060f0aa01",
"name": "AD_Process_Para of Link Column Process",
"description": "",
"validation_code": "AD_Process_Para.AD_Process_ID=(SELECT AD_Process_ID FROM AD_ColumnProcess WHERE AD_ColumnProcess_ID=@AD_ColumnProcess_ID@)",
"type": "S"
}
}
# Response Codes:
200when successful500in case of error