=== TABLES === InternetCosas_Dispositivos Pagos_Cajas_Diarias Pagos_Ingresos Ventas_Pagos Nucleo_Empresas Nucleo_Turnos Pagos_Cajas_Historial SaaS_Gestion_Empresa_CaracteristicaPl Nomina_Conceptos_Config Seguridad_Perfiles Seguridad_Perfil_Permisos Nomina_Pagos_Historial Pagos_Cajas_Egresos Seguridad_Usuarios Nomina_Pagos_Detalle Catalogo_Menu_Config Identidad_Usuarios Facturacion_Tipos_Documento Seguridad_Perfiles Seguridad_Usuarios === CAJAS DIARIAS === [ { "id_cajaDi": "86D4E5DB-1E40-4999-A552-04486C1C904E", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "BC24ABA1-D752-4CA9-8BA1-056C60009D25", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "D2AE93D7-0286-4BE3-9BE5-0AE0D7F821BA", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "CA730A48-1CC1-4160-A527-0F9F7606C3BF", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "36D50C5C-D38F-4071-894B-109C9C0CE3C4", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "4BF1F542-8E8B-46C1-9163-1121B7953D8B", "sucursal_id": "12DA1EFB-8C49-4924-AA89-E609663FE043", "usuario_id": "B5DC4828-9EEB-4FE8-84D5-DE8E326B09FB", "estado": "inactivo" }, { "id_cajaDi": "D88D3374-4249-40BE-862B-12FF928B3190", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "3AC6B0A6-D848-448A-8013-1373CFDF517F", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "77AFF0A3-BB69-4E8D-B60C-13C95C6584D4", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "E7D95402-B5E5-4D90-B492-191703F5B55B", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "3337B99A-5BC3-4C6C-A4AB-1D5BBCA6EF28", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "EC343B98-5433-460C-8AEB-21A6AF179E7A", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "CE7FD4BA-3F33-41C9-8A4A-29C593167467", "estado": "inactivo" }, { "id_cajaDi": "091D9238-9746-4B55-ACE5-241D60C1DB67", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "F0DE47AA-CF88-41DA-BBB8-2451A2CE5EBD", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F2353FF4-D723-4E4F-A8DB-27D83F32ED0F", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "934DCB72-AE15-4ACB-B7A4-281183D0A73C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "D318ED12-6DA6-4D77-8DAC-281E5B0C91B1", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "58CAC8A1-71CC-49E7-8D28-2F89F51F252D", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F33127EE-57DE-413C-B35A-30DCB7777D34", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "49890771-903A-464D-A685-3AB690F68CD7", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "C9E7910C-698E-4676-830A-3AF3706E9AFF", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "5E865017-5E1F-408B-BB71-3D78D9509E00", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "43BF99BA-0CBE-4665-BB8B-3EDC62A5B6F1", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "9AEC0D84-5B04-4C7B-9B8F-446BF7553218", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "E09353F2-7177-49D2-B015-480EEE08CEA0", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "3FC4DF80-DBD0-4960-9746-486B97EB2570", "sucursal_id": "12DA1EFB-8C49-4924-AA89-E609663FE043", "usuario_id": "B5DC4828-9EEB-4FE8-84D5-DE8E326B09FB", "estado": "inactivo" }, { "id_cajaDi": "90D5E3C6-A034-42AB-8474-4961514A0B3C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "36E03080-7FA4-48B4-A7EC-4BD20EDF39FC", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "E2969D90-E37F-43BD-9DC8-4F12CCC8573C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "6C469846-3972-4760-B3C2-54AE58F0992C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F05B672A-04D0-4623-A3AB-5802E0FBC13D", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F3D3A8D1-56B1-4FCD-BFBA-5842A7EB0387", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "7485EC49-6E2E-43C4-9406-5867DBC9F380", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "E4F7D188-F28B-4CFF-A3F9-5A41219D9211", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "D416616B-C015-4CBF-B3D2-5B7A3B2F08C0", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "069FF4CE-16F5-434F-879E-60E161A24750", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "6D2401D1-902D-4561-8D0A-61F1048D3BE1", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "1F0A631B-0DCB-4CEE-873E-622C211614E6", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "73B87CD5-AFEA-4F0B-A709-628C90AAEF82", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "9D8C4995-6D6B-4B65-B7AE-6505C7048AD6", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "C9CA1B0A-E311-47CB-9590-65D9A24551FE", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "0FC511EF-9017-4BE2-A99E-66B0479BC5D0", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "A8BE3432-0335-43CC-9D48-6893620EA799", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "9C3529BF-A121-41A8-BCA9-6A0600B06B13", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "C6AE9DE8-3D90-4799-B738-6F11921052A0", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "8F7AA275-ADDB-4E6C-AC88-716E5E6B98DB", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "337C3BD3-AFBC-4F68-BA6C-732D35678F96", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "FB8FDC17-D2AC-4D65-A137-73E8260C6103", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "EE677E54-9F29-4BE9-87E5-73F94C2ED33C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "CBD59276-7962-4EE2-AF23-78D3722FCBE7", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "23D7E0A6-2B5E-4406-A82D-7A7B46784F42", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "5714224C-1D3C-4154-9F9F-7B846D39CF29", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "9FD2E9FE-61ED-436D-9151-7F9A4DB0C1F7", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "3CB8EEEE-33B0-42AD-92CE-81D0B08CB7AB", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "1550DD78-8F1F-44E2-A91F-81E9F450B7CC", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "3AD4BCA5-DA60-4607-A208-820761829649", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "7D3D1BCE-619D-4CD5-9919-83029F97FD7B", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "CE7FD4BA-3F33-41C9-8A4A-29C593167467", "estado": "inactivo" }, { "id_cajaDi": "63886B38-1DF5-41AA-B567-8308A6A6DA23", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "381F807D-59AE-44B4-8475-832B41A1F842", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "4D274728-8629-48CF-8A3F-839728359ABF", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "EA7BF856-D2E1-4FD9-8313-85113D221CD4", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "E487E51D-EA60-4F60-A7C3-891280B3FF0F", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "9AE011F2-4218-4ED4-97D2-8C25C9A95274", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "B83E464D-1E6C-47D1-9063-8C7D60A42675", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "0325A8C3-EDB8-439A-9768-8E8C2410541C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "8B6B01DC-F1CE-4472-AC86-8EFF7D35BF30", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "9748004D-BD33-41CD-B13D-90B0B13461C5", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "F90359DD-1EF6-4D51-A3E0-931429378EF2", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "730CEEE7-A9F7-4CF9-AFCE-94E325452E67", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F57A19DA-5BDD-40E9-BB5F-98CD56E3FB87", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "5DAFB250-6945-47E6-A9EA-9A84B115FF71", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "56BA232D-F426-4132-BB2B-9B2209A86990", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "B7450A89-66CA-495E-A2AD-9FE78DA6F731", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "DB312D0F-6A5B-4867-8949-A1EDEF949A6E", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "BD4BC0BB-B2CD-461E-A7BE-A25D3D28C511", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "313F5E81-77B5-454C-A4D2-A68F73717523", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "2797B955-5376-47DB-B58E-A7BE594CDF91", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "1F2BE2FB-626F-46A7-806E-A7F923B73F92", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "905D8B83-BF61-4570-9ABA-A89D7D04B4B8", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F0F2E6A7-C82D-4AC9-9506-A96DDDF352C8", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "F2DA0D04-CC42-488E-951B-B2183DE74FBA", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "A5139234-BA8F-4EC0-998F-B3C5B7E095FE", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "F5699250-E9B7-49CE-82C6-B4C594F6903F", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "5EADDDCB-BD2A-405B-85D6-B6BFD7C2FB02", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "66C99184-1F53-4A22-8F3A-B8939A2D613D", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "FDFE445E-9F3B-4685-893D-BAF526E397F8", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "447524D9-A558-407A-BE70-BBFF4C47D8C3", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "9F58D8F5-A44E-4697-B307-BC430C674FFC", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "99A15F26-E48A-473D-ACE5-BC54B4417F27", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "0E060846-54B2-4045-9495-C1451687EE4B", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "144FD960-5FF3-48A2-BE78-C247938110ED", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "1F918C82-57A7-44FD-9126-C32BF6ED41AE", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "activo" }, { "id_cajaDi": "83062B26-B2EE-46AB-8CF9-C4DE09134ED2", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "2264680E-CEA8-47DA-ABFF-C8C80B14A258", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "E25CFA0F-60AA-4702-A944-C9425505033A", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "06FF3E8D-62CF-4435-AF9D-CB027E61A27E", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "CE7FD4BA-3F33-41C9-8A4A-29C593167467", "estado": "inactivo" }, { "id_cajaDi": "7673DCCC-A7F4-4DD0-9F0F-CD4E8C09E205", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "ECBCF89E-BB67-4960-BC22-CDA7F8EB7C5F", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "317F33A0-36E7-44FE-8D92-D0D91A08343E", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "A56C6F8E-FE68-4C69-9113-D252BEE8CCCC", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "CE7FD4BA-3F33-41C9-8A4A-29C593167467", "estado": "inactivo" }, { "id_cajaDi": "DEF82539-8186-498E-B158-D30ED9BBBC2C", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "27663513-1BED-417B-BC33-D6210402C1D9", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "0BC28F86-6B2C-4B08-8EC2-D7621B89C68B", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "4293FAC9-517B-44B7-9007-D7A3A81FFAFB", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "7FD09006-F967-4FC3-B0D7-DBBB198761FB", "sucursal_id": "810EC678-C8E4-40E4-BFAC-8852693A7B15", "usuario_id": "43920FA2-8081-4409-8762-C7D30E2CA30B", "estado": "inactivo" }, { "id_cajaDi": "FF029C99-0E54-4877-8219-DD423C278E60", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "D11540FF-3026-434B-858C-E1E20B130134", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "3FF016A9-7CE3-4175-AE09-E247DFC90A36", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "83063A99-2540-4482-9C4C-E2FAE80C7B07", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "A73B6D45-D1BB-4EC0-9B01-E372E1F3A3C6", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "D9301360-C595-4538-A673-E49FBF700F68", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "6EA684A5-2E84-4ECE-A452-E8B12766F4D3", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "9094C70E-57DB-4C79-8DA6-F001C0C8D917", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "400B28F6-E3A1-40A5-9000-F0AE7D7D5D7C", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "C4669614-51DF-4175-B12A-F212E9EB3CF8", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "74056136-EF3E-4E36-BB3B-F25C7F3674BE", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "48C97C02-E372-406D-8430-F2FBA0F35919", "sucursal_id": "186BBB10-D67B-4EFA-971A-66EDB00DBDAE", "usuario_id": "6547146C-9B50-49FF-AB39-324B0268A682", "estado": "inactivo" }, { "id_cajaDi": "6C51D500-29F1-40B1-91F5-F333B8867780", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "D752D30E-B604-4465-88F9-2599B84A8649", "estado": "inactivo" }, { "id_cajaDi": "EA357385-7F79-4E74-B596-F699970E7D93", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" }, { "id_cajaDi": "95BB4032-0BED-46C4-86B5-FD0D032D6F26", "sucursal_id": "7EA7F94D-F02C-4B26-9B3B-94015FFCA6DF", "usuario_id": "921CAE76-BC61-47F5-9C98-4999A439D10D", "estado": "inactivo" } ] === CAJAS HISTORIAL === [ { "id_historial": "2182", "caja_id": "1F918C82-57A7-44FD-9126-C32BF6ED41AE", "fecha_apertura": "2026-10-02 12:34:00.0000000 +00:00", "fecha_cierre": null, "monto_inicial": "200.00", "monto_final_esperado": ".00", "total_ingresos_efectivo": null, "monto_final_real": null, "observaciones": null, "total_ingresos_tarjetas": ".00", "total_ingresos_qr": ".00", "total_propinas": ".00" }, { "id_historial": "2181", "caja_id": "8F7AA275-ADDB-4E6C-AC88-716E5E6B98DB", "fecha_apertura": "2026-10-02 09:24:26.0000000 +00:00", "fecha_cierre": "2026-10-02 12:31:43.0000000 +00:00", "monto_inicial": "200.00", "monto_final_esperado": ".00", "total_ingresos_efectivo": "356.00", "monto_final_real": "356.00", "observaciones": null, "total_ingresos_tarjetas": ".00", "total_ingresos_qr": ".00", "total_propinas": ".00" }, { "id_historial": "2177", "caja_id": "D9301360-C595-4538-A673-E49FBF700F68", "fecha_apertura": "2026-10-01 16:18:14.0000000 -05:00", "fecha_cierre": "2026-10-01 17:11:24.0000000 +00:00", "monto_inicial": "200.00", "monto_final_esperado": ".00", "total_ingresos_efectivo": "396.00", "monto_final_real": "396.00", "observaciones": null, "total_ingresos_tarjetas": ".00", "total_ingresos_qr": ".00", "total_propinas": ".00" } ] === CAJEROS / USUARIOS EN HISTORIAL === SistenaPiter
Internal Server Error

Illuminate\Database\QueryException

vendor\laravel\framework\src\Illuminate\Database\Connection.php:838

SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'usuario_apertura' no es válido. (Connection: sqlsrv, Host: 127.0.0.1, Port: 1433, Database: sistema_piter, SQL: select distinct [usuario_apertura], [id_caja] from [Pagos_Cajas_Historial])

LARAVEL 12.51.0
PHP 8.2.12
UNHANDLED
CODE 42S22
500
GET
https://www.piterpro.com

Exception trace

7 vendor frames
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))
vendor\laravel\framework\src\Illuminate\Database\Connection.php:838
Illuminate\Database\Connection->run(string, array, object(Closure))
vendor\laravel\framework\src\Illuminate\Database\Connection.php:794
Illuminate\Database\Connection->select(string, array, boolean)
vendor\laravel\framework\src\Illuminate\Database\Connection.php:411
Illuminate\Database\Query\Builder->runSelect()
vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:3438
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:3423
Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))
vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:4013
Illuminate\Database\Query\Builder->get()
vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:3422
scratch\check_db_info.php
scratch\check_db_info.php:27
22echo "\n=== CAJAS HISTORIAL ===\n";23$historial = DB::table('Pagos_Cajas_Historial')->orderBy('fecha_apertura', 'desc')->limit(3)->get();24echo json_encode($historial, JSON_PRETTY_PRINT);2526echo "\n=== CAJEROS / USUARIOS EN HISTORIAL ===\n";27$cajeros = DB::table('Pagos_Cajas_Historial')->select('usuario_apertura', 'id_caja')->distinct()->get();28echo json_encode($cajeros, JSON_PRETTY_PRINT);2930

Queries

sqlsrv
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
8.07ms
sqlsrv
select * from [Pagos_Cajas_Diarias]
1.1ms
sqlsrv
select top 3 * from [Pagos_Cajas_Historial] order by [fecha_apertura] desc
1.22ms

Headers

host
www.piterpro.com
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept
*/*
accept-language
en-us,en;q=0.5
accept-charset
ISO-8859-1,utf-8;q=0.7,*;q=0.7
accept-encoding
gzip, br, zstd, deflate
via
1.1 squid-proxy-5b96dc6d46-hz8zm (squid/6.13)
x-forwarded-for
10.1.139.20
cache-control
max-age=259200
connection
keep-alive

Body

// No request body

Routing

// No routing context

Routing parameters

// No routing parameters