(3305,0,'EFECTIVO',2,27,3030,0,57999.99999999999,0,'2025-11-25 15:23:30',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3306,0,'EFECTIVO',2,27,3031,0,282000,0,'2025-11-25 15:23:53',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3307,0,'EFECTIVO',2,27,3032,0,243000,0,'2025-11-25 15:24:16',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3308,0,'EFECTIVO',2,27,3033,0,15999.999999999998,0,'2025-11-25 15:24:37',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3309,0,'EFECTIVO',2,27,3034,0,37500,0,'2025-11-25 15:25:03',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3310,0,'EFECTIVO',2,27,3035,0,89800,0,'2025-11-25 15:26:28',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3311,0,'EFECTIVO',2,27,3036,0,39000,0,'2025-11-25 15:34:45',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3312,0,'EFECTIVO',2,27,3037,0,48000,0,'2025-11-25 15:36:51',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3313,0,'DATÁFONO',2,27,3038,0,22000,0,'2025-11-25 15:41:30',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3314,0,'EFECTIVO',2,27,3039,0,6000,0,'2025-11-25 15:45:49',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3315,0,'EFECTIVO',2,27,3040,0,61000,0,'2025-11-25 15:47:42',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3316,0,'EFECTIVO',2,27,3041,0,85000,0,'2025-11-25 15:49:41',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3317,0,'DATÁFONO',2,27,3042,0,22000,0,'2025-11-25 15:50:31',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3318,0,'DATÁFONO',2,27,3043,0,26500,0,'2025-11-25 15:58:38',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3319,0,'DATÁFONO',2,27,3044,0,69000,0,'2025-11-25 16:01:38',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3320,0,'EFECTIVO',2,27,3045,0,7840,0,'2025-11-25 16:06:28',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3321,0,'EFECTIVO',2,27,3046,0,29500,0,'2025-11-25 16:07:00',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3322,0,'TRANSFERENCIA',2,27,3047,0,55500,0,'2025-11-25 16:10:48',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3323,0,'EFECTIVO',2,27,3048,0,23000,0,'2025-11-25 16:13:01',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3324,0,'TRANSFERENCIA',2,27,3049,0,55000,0,'2025-11-25 16:13:46',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3325,0,'EFECTIVO',2,27,3050,0,76000,0,'2025-11-25 16:20:07',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3326,0,'EFECTIVO',2,27,3051,0,20000,0,'2025-11-25 16:20:50',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3327,0,'EFECTIVO',2,27,3052,0,28000,0,'2025-11-25 16:21:30',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3328,0,'EFECTIVO',2,27,3053,0,55000,0,'2025-11-25 16:21:50',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3329,0,'EFECTIVO',2,27,3054,0,63000,0,'2025-11-25 16:22:10',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3330,0,'EFECTIVO',2,27,3055,0,32500,0,'2025-11-25 16:22:32',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3331,0,'EFECTIVO',2,27,3056,0,36500,0,'2025-11-25 16:22:52',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3332,0,'EFECTIVO',2,27,3057,0,30000,0,'2025-11-25 16:23:23',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3333,0,'EFECTIVO',2,27,3058,0,17600,0,'2025-11-25 16:28:52',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3334,0,'TRANSFERENCIA',2,27,3059,0,81500,0,'2025-11-25 16:32:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3335,0,'EFECTIVO',2,27,3060,0,50000,0,'2025-11-25 16:46:55',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3336,0,'EFECTIVO',2,27,3061,0,12000,0,'2025-11-25 16:48:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3337,0,'EFECTIVO',2,27,3062,0,27500,0,'2025-11-25 16:54:29',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3338,0,'EFECTIVO',2,27,3063,0,22000,0,'2025-11-25 17:22:15',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3339,0,'EFECTIVO',2,27,3064,0,15000,0,'2025-11-25 17:41:46',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3340,0,'EFECTIVO',2,27,3065,0,4800,0,'2025-11-25 17:44:16',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3341,0,'EFECTIVO',2,27,3066,0,10400,0,'2025-11-25 17:50:38',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3342,0,'EFECTIVO',2,27,3067,0,35500,0,'2025-11-25 17:53:49',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3343,0,'EFECTIVO',2,28,3068,0,50000,0,'2025-11-26 10:04:42',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3344,0,'EFECTIVO',2,28,3068,0,0,0,'2025-11-26 10:04:42',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3346,0,'EFECTIVO',2,28,3069,0,5500,0,'2025-11-26 11:09:00',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3347,0,'EFECTIVO',2,28,3069,0,0,0,'2025-11-26 11:09:00',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3349,0,'DATÁFONO',2,28,3070,0,91000,0,'2025-11-26 11:27:03',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3350,0,'TRANSFERENCIA',2,28,3071,0,30000,0,'2025-11-26 11:57:47',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3351,0,'EFECTIVO',2,28,3072,0,29500,0,'2025-11-26 12:24:56',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3352,0,'EFECTIVO',2,28,3073,0,48500,0,'2025-11-26 12:25:37',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3353,0,'DATÁFONO',2,28,3074,0,43500,0,'2025-11-26 12:28:08',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3354,0,'TRANSFERENCIA',2,28,3075,0,94000,0,'2025-11-26 12:35:22',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3355,0,'EFECTIVO',2,28,3076,0,3500,0,'2025-11-26 12:37:07',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3356,0,'EFECTIVO',2,28,3077,0,52000,0,'2025-11-26 12:50:50',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3357,0,'EFECTIVO',2,28,3078,0,6000,0,'2025-11-26 12:52:15',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3358,0,'TRANSFERENCIA',2,28,3079,0,25000,0,'2025-11-26 12:52:49',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3359,0,'EFECTIVO',2,28,3080,0,48000,0,'2025-11-26 13:03:27',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3360,0,'EFECTIVO',2,28,3081,0,55000,0,'2025-11-26 13:05:44',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3361,0,'EFECTIVO',2,28,3082,0,88000,0,'2025-11-26 13:06:40',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3362,0,'EFECTIVO',2,28,3083,0,22000,0,'2025-11-26 13:07:58',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3363,0,'EFECTIVO',2,28,3084,0,47000,0,'2025-11-26 13:09:47',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3364,0,'EFECTIVO',2,28,3085,0,47000,0,'2025-11-26 13:12:26',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3365,0,'TRANSFERENCIA',2,28,3086,0,53000,0,'2025-11-26 13:17:54',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3366,0,'EFECTIVO',2,28,3087,0,58000,0,'2025-11-26 13:19:10',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3367,0,'EFECTIVO',2,28,3088,0,9800,0,'2025-11-26 13:21:19',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3368,0,'EFECTIVO',2,28,3089,0,57000,0,'2025-11-26 13:22:53',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3369,0,'EFECTIVO',2,28,3090,0,24500,0,'2025-11-26 13:27:24',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3370,0,'TRANSFERENCIA',2,28,3091,0,29500,0,'2025-11-26 13:31:04',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3371,0,'TRANSFERENCIA',2,28,3092,0,67000,0,'2025-11-26 13:35:46',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3372,0,'EFECTIVO',2,28,3093,0,45500,0,'2025-11-26 13:40:21',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3373,0,'EFECTIVO',2,28,3094,0,23500,0,'2025-11-26 13:41:12',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3374,0,'EFECTIVO',2,28,3095,0,69000,0,'2025-11-26 13:42:09',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3375,0,'DATÁFONO',2,28,3096,0,51000,0,'2025-11-26 13:46:41',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3376,0,'EFECTIVO',2,28,3097,0,55000,0,'2025-11-26 13:47:51',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3377,0,'EFECTIVO',2,28,3098,0,70500,0,'2025-11-26 13:48:43',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3378,0,'EFECTIVO',2,28,3099,0,47000,0,'2025-11-26 13:49:24',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3379,0,'EFECTIVO',2,28,3100,0,31500,0,'2025-11-26 13:52:29',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3380,0,'EFECTIVO',2,28,3101,0,22000,0,'2025-11-26 13:58:02',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3381,0,'EFECTIVO',2,28,3102,0,113000,0,'2025-11-26 14:00:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3382,0,'EFECTIVO',2,28,3103,0,50000,0,'2025-11-26 14:01:33',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3383,0,'EFECTIVO',2,28,3104,0,5000,0,'2025-11-26 14:02:35',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3384,0,'EFECTIVO',2,28,3105,0,112600,0,'2025-11-26 14:03:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3385,0,'EFECTIVO',2,28,3106,0,89000,0,'2025-11-26 14:04:25',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3386,0,'EFECTIVO',2,28,3107,0,53500,0,'2025-11-26 14:07:39',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3387,0,'TRANSFERENCIA',2,28,3108,0,48500,0,'2025-11-26 14:08:20',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3388,0,'EFECTIVO',2,28,3109,0,27000,0,'2025-11-26 14:09:17',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3389,0,'EFECTIVO',2,28,3110,0,22000,0,'2025-11-26 14:11:20',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3390,0,'DATÁFONO',2,28,3111,0,74500,0,'2025-11-26 14:12:22',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3391,0,'DATÁFONO',2,28,3112,0,58000,0,'2025-11-26 14:13:12',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3392,0,'EFECTIVO',2,28,3113,0,51500,0,'2025-11-26 14:15:57',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3393,0,'EFECTIVO',2,28,3114,0,50000,0,'2025-11-26 14:16:47',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3394,0,'EFECTIVO',2,28,3115,0,47000,0,'2025-11-26 14:18:24',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3395,0,'EFECTIVO',2,28,3116,0,25000,0,'2025-11-26 14:22:08',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3396,0,'EFECTIVO',2,28,3117,0,55500,0,'2025-11-26 14:26:27',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3397,0,'EFECTIVO',2,28,3118,0,33500,0,'2025-11-26 14:31:12',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3398,0,'DATÁFONO',2,28,3119,0,66000,0,'2025-11-26 14:38:05',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3399,0,'EFECTIVO',2,28,3120,0,51500,0,'2025-11-26 14:46:22',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3400,0,'EFECTIVO',2,28,3121,0,25000,0,'2025-11-26 14:50:17',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3401,0,'EFECTIVO',2,28,3122,0,23000,0,'2025-11-26 15:07:22',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3402,0,'EFECTIVO',2,28,3123,0,58000,0,'2025-11-26 15:14:01',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3403,0,'EFECTIVO',2,28,3124,0,26000,0,'2025-11-26 15:15:25',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3404,0,'EFECTIVO',2,28,3125,0,49000,0,'2025-11-26 15:25:29',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3405,0,'DATÁFONO',2,28,3126,0,91000,0,'2025-11-26 15:26:15',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3406,0,'EFECTIVO',2,28,3127,0,31000,0,'2025-11-26 15:40:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3407,0,'EFECTIVO',2,28,3128,0,47000,0,'2025-11-26 15:42:07',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3408,0,'EFECTIVO',2,28,3129,0,54000,0,'2025-11-26 15:44:08',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3409,0,'EFECTIVO',2,28,3130,0,123000,0,'2025-11-26 15:45:16',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3410,0,'EFECTIVO',2,28,3131,0,35500,0,'2025-11-26 15:46:16',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3411,0,'EFECTIVO',2,28,3132,0,60000,0,'2025-11-26 15:47:02',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3412,0,'EFECTIVO',2,28,3133,0,36500,0,'2025-11-26 15:47:34',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3413,0,'DATÁFONO',2,28,3134,0,90500,0,'2025-11-26 15:48:42',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3414,0,'EFECTIVO',2,28,3135,0,30000,0,'2025-11-26 15:51:43',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3415,0,'EFECTIVO',2,28,3136,0,37500,0,'2025-11-26 15:52:30',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3416,0,'EFECTIVO',2,28,3137,0,52000,0,'2025-11-26 15:52:53',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3417,0,'EFECTIVO',2,28,3138,0,15999.999999999998,0,'2025-11-26 15:53:11',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3418,0,'EFECTIVO',2,28,3139,0,52000,0,'2025-11-26 15:53:33',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3419,0,'EFECTIVO',2,28,3140,0,32500,0,'2025-11-26 15:53:50',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3420,0,'EFECTIVO',2,28,3141,0,50500,0,'2025-11-26 15:54:54',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3421,0,'EFECTIVO',2,28,3142,0,20000,0,'2025-11-26 15:58:11',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3422,0,'EFECTIVO',2,28,3143,0,25000,0,'2025-11-26 16:02:54',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3423,0,'EFECTIVO',2,28,3144,0,29600,0,'2025-11-26 16:04:37',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3424,0,'EFECTIVO',2,28,3145,0,26000,0,'2025-11-26 16:05:20',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3425,0,'EFECTIVO',2,28,3146,0,25000,0,'2025-11-26 16:05:53',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3426,0,'EFECTIVO',2,28,3147,0,2400,0,'2025-11-26 16:19:07',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3427,0,'EFECTIVO',2,28,3148,0,74500,0,'2025-11-26 16:22:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3428,0,'EFECTIVO',2,28,3149,0,32000,0,'2025-11-26 16:28:47',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3429,0,'EFECTIVO',2,28,3150,0,68800,0,'2025-11-26 16:34:25',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3430,0,'EFECTIVO',2,28,3151,0,44000,0,'2025-11-26 16:38:24',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3431,0,'EFECTIVO',2,28,3152,0,5000,0,'2025-11-26 16:41:17',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3432,0,'TRANSFERENCIA',2,28,3153,0,73500,0,'2025-11-26 17:04:20',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3433,0,'DATÁFONO',2,28,3154,0,26000,0,'2025-11-26 17:15:17',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3434,0,'EFECTIVO',2,28,3155,0,8000,0,'2025-11-26 17:43:43',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3435,0,'EFECTIVO',2,28,3156,0,22000,0,'2025-11-26 17:44:14',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3436,0,'EFECTIVO',2,29,3157,0,34000,0,'2025-11-27 09:17:58',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3437,0,'DATÁFONO',2,29,3157,0,0,0,'2025-11-27 09:17:58',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3439,0,'EFECTIVO',2,29,3158,0,18000,0,'2025-11-27 09:54:16',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3440,0,'TRANSFERENCIA',2,29,3158,0,0,0,'2025-11-27 09:54:16',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3442,0,'EFECTIVO',2,29,3159,0,30000,0,'2025-11-27 10:34:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3443,0,'DATÁFONO',2,29,3159,0,0,0,'2025-11-27 10:34:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3445,0,'EFECTIVO',2,29,3160,0,26500,0,'2025-11-27 11:20:32',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3446,0,'EFECTIVO',2,29,3160,0,0,0,'2025-11-27 11:20:32',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3448,0,'EFECTIVO',2,29,3161,0,2800,0,'2025-11-27 11:34:40',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3449,0,'DATÁFONO',2,29,3162,0,48500,0,'2025-11-27 11:43:19',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3450,0,'EFECTIVO',2,29,3163,0,15000,0,'2025-11-27 11:50:43',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3451,0,'EFECTIVO',2,29,3164,0,28000,0,'2025-11-27 11:57:31',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3452,0,'DATÁFONO',2,29,3165,0,108000,0,'2025-11-27 12:00:55',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3453,0,'EFECTIVO',2,29,3166,0,20000,0,'2025-11-27 12:05:37',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3454,0,'TRANSFERENCIA',2,29,3167,0,30000,0,'2025-11-27 12:26:37',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3455,0,'DATÁFONO',2,29,3168,0,30000,0,'2025-11-27 12:27:16',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3456,0,'DATÁFONO',2,29,3169,0,98800,0,'2025-11-27 12:30:54',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3457,0,'DATÁFONO',2,29,3170,0,78500,0,'2025-11-27 12:35:19',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3458,0,'DATÁFONO',2,29,3171,0,25000,0,'2025-11-27 12:48:41',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3459,0,'EFECTIVO',2,29,3172,0,9500,0,'2025-11-27 12:49:35',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3460,0,'EFECTIVO',2,29,3173,0,55000,0,'2025-11-27 12:50:48',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3461,0,'EFECTIVO',2,29,3174,0,22000,0,'2025-11-27 12:51:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3462,0,'EFECTIVO',2,29,3175,0,26000,0,'2025-11-27 12:52:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3463,0,'DATÁFONO',2,29,3176,0,108000,0,'2025-11-27 12:53:27',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3464,0,'EFECTIVO',2,29,3177,0,26000,0,'2025-11-27 12:58:14',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3465,0,'EFECTIVO',2,29,3178,0,28500,0,'2025-11-27 12:59:14',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3466,0,'EFECTIVO',2,29,3179,0,48500,0,'2025-11-27 13:23:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3467,0,'EFECTIVO',2,29,3180,0,52000,0,'2025-11-27 13:25:19',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3468,0,'EFECTIVO',2,29,3181,0,107000,0,'2025-11-27 13:26:24',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3469,0,'EFECTIVO',2,29,3182,0,26500,0,'2025-11-27 13:29:47',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3470,0,'DATÁFONO',2,29,3183,0,91000,0,'2025-11-27 13:39:41',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3471,0,'EFECTIVO',2,29,3184,0,91000,0,'2025-11-27 13:43:07',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3472,0,'EFECTIVO',2,29,3185,0,74000,0,'2025-11-27 13:48:27',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3473,0,'EFECTIVO',2,29,3186,0,26500,0,'2025-11-27 13:51:10',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3474,0,'EFECTIVO',2,29,3187,0,50000,0,'2025-11-27 13:53:20',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3475,0,'EFECTIVO',2,29,3188,0,53000,0,'2025-11-27 13:55:35',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3476,0,'EFECTIVO',2,29,3189,0,276500,0,'2025-11-27 14:02:52',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3477,0,'EFECTIVO',2,29,3190,0,29400,0,'2025-11-27 14:10:35',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3478,0,'TRANSFERENCIA',2,29,3191,0,22000,0,'2025-11-27 14:12:28',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3479,0,'EFECTIVO',2,29,3192,0,354000,0,'2025-11-27 14:13:10',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3480,0,'EFECTIVO',2,29,3193,0,17600,0,'2025-11-27 14:14:26',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3481,0,'DATÁFONO',2,29,3194,0,103000,0,'2025-11-27 14:19:05',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3482,0,'TRANSFERENCIA',2,29,3195,0,152500,0,'2025-11-27 14:20:23',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3483,0,'DATÁFONO',2,29,3196,0,48500,0,'2025-11-27 14:22:37',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3484,0,'EFECTIVO',2,29,3197,0,22000,0,'2025-11-27 14:24:24',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3485,0,'DATÁFONO',2,29,3198,0,179500,0,'2025-11-27 14:25:13',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3486,0,'TRANSFERENCIA',2,29,3199,0,22000,0,'2025-11-27 14:27:17',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3487,0,'EFECTIVO',2,29,3200,0,169000,0,'2025-11-27 14:31:53',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3488,0,'DATÁFONO',2,29,3201,0,116300,0,'2025-11-27 14:33:58',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3489,0,'EFECTIVO',2,29,3202,0,125000,0,'2025-11-27 14:35:41',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3490,0,'DATÁFONO',2,29,3203,0,49500,0,'2025-11-27 14:38:02',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3491,0,'DATÁFONO',2,29,3204,0,25500,0,'2025-11-27 14:41:52',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3492,0,'EFECTIVO',2,29,3205,0,86000,0,'2025-11-27 14:45:09',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3493,0,'TRANSFERENCIA',2,29,3206,0,29500,0,'2025-11-27 14:46:56',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3494,0,'EFECTIVO',2,29,3207,0,3000,0,'2025-11-27 14:50:44',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3495,0,'EFECTIVO',2,29,3208,0,63000,0,'2025-11-27 14:59:06',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3496,0,'EFECTIVO',2,29,3209,0,26500,0,'2025-11-27 15:00:15',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3497,0,'EFECTIVO',2,29,3210,0,106000,0,'2025-11-27 15:00:59',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3498,0,'TRANSFERENCIA',2,29,3211,0,96500,0,'2025-11-27 15:03:33',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3499,0,'EFECTIVO',2,29,3212,0,57000,0,'2025-11-27 15:04:31',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3500,0,'EFECTIVO',2,29,3213,0,115000,0,'2025-11-27 15:13:52',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3501,0,'EFECTIVO',2,29,3214,0,55500,0,'2025-11-27 15:19:22',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3502,0,'EFECTIVO',2,29,3215,0,40500,0,'2025-11-27 15:23:37',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3503,0,'EFECTIVO',2,29,3216,0,170000,0,'2025-11-27 15:25:54',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3504,0,'EFECTIVO',2,29,3217,0,118500,0,'2025-11-27 15:31:59',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3505,0,'EFECTIVO',2,29,3218,0,53000,0,'2025-11-27 15:32:57',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3506,0,'EFECTIVO',2,29,3219,0,57800,0,'2025-11-27 15:35:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3507,0,'EFECTIVO',2,29,3220,0,82500,0,'2025-11-27 15:35:43',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3508,0,'EFECTIVO',2,29,3221,0,68000,0,'2025-11-27 15:37:53',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3509,0,'TRANSFERENCIA',2,29,3222,0,53000,0,'2025-11-27 15:39:02',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3510,0,'DATÁFONO',2,29,3223,0,182500,0,'2025-11-27 15:40:38',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3511,0,'TRANSFERENCIA',2,29,3224,0,25000,0,'2025-11-27 15:43:08',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3512,0,'EFECTIVO',2,29,3225,0,52000,0,'2025-11-27 15:43:45',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3513,0,'EFECTIVO',2,29,3226,0,18700,0,'2025-11-27 15:44:05',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3514,0,'EFECTIVO',2,29,3227,0,40000,0,'2025-11-27 15:44:52',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3515,0,'EFECTIVO',2,29,3228,0,30000,0,'2025-11-27 15:45:13',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3516,0,'EFECTIVO',2,29,3229,0,133000,0,'2025-11-27 15:45:34',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3517,0,'EFECTIVO',2,29,3230,0,57500,0,'2025-11-27 15:46:03',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3518,0,'EFECTIVO',2,29,3231,0,36500,0,'2025-11-27 15:46:24',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3519,0,'EFECTIVO',2,29,3232,0,97500,0,'2025-11-27 15:47:00',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3520,0,'DATÁFONO',2,29,3233,0,89500,0,'2025-11-27 15:47:52',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3521,0,'EFECTIVO',2,29,3234,0,57999.99999999999,0,'2025-11-27 15:48:57',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3522,0,'EFECTIVO',2,29,3235,0,54000,0,'2025-11-27 15:49:30',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3523,0,'EFECTIVO',2,29,3236,0,44000,0,'2025-11-27 15:53:01',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3524,0,'EFECTIVO',2,29,3237,0,25000,0,'2025-11-27 16:05:10',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3525,0,'TRANSFERENCIA',2,29,3238,0,52500,0,'2025-11-27 16:08:23',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3526,0,'EFECTIVO',2,29,3239,0,26500,0,'2025-11-27 16:09:20',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3527,0,'EFECTIVO',2,29,3240,0,26500,0,'2025-11-27 16:09:49',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3528,0,'EFECTIVO',2,29,3241,0,26500,0,'2025-11-27 16:14:23',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3529,0,'EFECTIVO',2,29,3242,0,59500,0,'2025-11-27 16:14:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3530,0,'EFECTIVO',2,29,3243,0,27000,0,'2025-11-27 16:15:49',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3531,0,'EFECTIVO',2,29,3244,0,74000,0,'2025-11-27 16:16:20',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3532,0,'EFECTIVO',2,29,3245,0,64200,0,'2025-11-27 16:16:59',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3533,0,'EFECTIVO',2,29,3246,0,15999.999999999998,0,'2025-11-27 16:17:48',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3534,0,'EFECTIVO',2,29,3247,0,74000,0,'2025-11-27 16:18:04',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3535,0,'EFECTIVO',2,29,3248,0,42500,0,'2025-11-27 16:18:22',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3536,0,'EFECTIVO',2,29,3249,0,58000,0,'2025-11-27 16:18:38',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3537,0,'EFECTIVO',2,29,3250,0,34500,0,'2025-11-27 16:18:57',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3538,0,'EFECTIVO',2,29,3251,0,182000,0,'2025-11-27 16:19:19',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3539,0,'EFECTIVO',2,29,3252,0,89500,0,'2025-11-27 16:19:36',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3540,0,'EFECTIVO',2,29,3253,0,50000,0,'2025-11-27 16:19:58',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3541,0,'EFECTIVO',2,29,3254,0,61000,0,'2025-11-27 16:20:43',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3542,0,'EFECTIVO',2,29,3255,0,34500,0,'2025-11-27 16:23:38',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3543,0,'EFECTIVO',2,29,3256,0,28500,0,'2025-11-27 16:24:18',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3544,0,'EFECTIVO',2,29,3257,0,38000,0,'2025-11-27 16:34:20',0,0,'distrito',0,0,NULL,0,0.00,0,0,0,0,1,0),(3545,0,'EFECTIVO',2,29,3258,0,43000,0,'2025-11-27 16:39:03',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3546,0,'DATÁFONO',2,29,3259,0,111500,0,'2025-11-27 16:51:52',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3547,0,'EFECTIVO',2,29,3260,0,22000,0,'2025-11-27 16:55:34',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3548,0,'EFECTIVO',2,29,3261,0,6000,0,'2025-11-27 16:57:16',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3549,0,'EFECTIVO',2,29,3262,0,75000,0,'2025-11-27 17:09:45',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3550,0,'TRANSFERENCIA',2,29,3263,0,65300,0,'2025-11-27 17:37:06',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3551,0,'EFECTIVO',2,29,3264,0,31000,0,'2025-11-27 17:41:04',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3552,0,'TRANSFERENCIA',2,29,3265,0,51000,0,'2025-11-27 17:47:39',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3553,0,'EFECTIVO',2,29,3266,0,22000,0,'2025-11-27 17:54:50',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3554,0,'EFECTIVO',2,29,3267,0,22000,0,'2025-11-27 17:55:48',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3555,0,'TRANSFERENCIA',2,29,3268,0,38000,0,'2025-11-27 17:58:36',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0),(3556,0,'EFECTIVO',2,29,3269,0,58000,0,'2025-11-27 18:03:17',0,0,'distrito',0,0,110505,0,0.00,0,0,0,0,1,0);

--
-- Table structure for table `registrosmediosdepago2`
--

CREATE TABLE `registrosmediosdepago2` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `idmayor` int NOT NULL DEFAULT '0',
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `idabono` int DEFAULT '0',
  `valor` double DEFAULT '0',
  `anulado` int NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idabonoprestamo` int DEFAULT '0',
  `idabonoseparado` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `idabonoordenservicio` int DEFAULT '0',
  `abonado` int DEFAULT '0',
  `cuenta_contable` int DEFAULT NULL,
  `idusuariomedidepago` int DEFAULT '0',
  `serviciomediopago` decimal(9,2) DEFAULT '0.00',
  `idabonoreserva` int DEFAULT '0',
  `esanticipo` int DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  `registroafectacaja` int DEFAULT '1',
  `idbolsillo` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idfactura`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `registrosmediosdepago2`
--


--
-- Table structure for table `registrosmediosdepago2021`
--

CREATE TABLE `registrosmediosdepago2021` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `idmayor` int NOT NULL DEFAULT '0',
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `idabono` int DEFAULT '0',
  `valor` double DEFAULT '0',
  `anulado` int NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idabonoprestamo` int DEFAULT '0',
  `idabonoseparado` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `idabonoordenservicio` int DEFAULT '0',
  `abonado` int DEFAULT '0',
  `cuenta_contable` int DEFAULT NULL,
  `idusuariomedidepago` int DEFAULT '0',
  `serviciomediopago` decimal(9,2) DEFAULT '0.00',
  `idabonoreserva` int DEFAULT '0',
  `esanticipo` int DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idfactura`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `registrosmediosdepago2021`
--


--
-- Table structure for table `registrosmediosdepago2022`
--

CREATE TABLE `registrosmediosdepago2022` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `idmayor` int NOT NULL DEFAULT '0',
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `idabono` int DEFAULT '0',
  `valor` double DEFAULT '0',
  `anulado` int NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idabonoprestamo` int DEFAULT '0',
  `idabonoseparado` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `idabonoordenservicio` int DEFAULT '0',
  `abonado` int DEFAULT '0',
  `cuenta_contable` int DEFAULT NULL,
  `idusuariomedidepago` int DEFAULT '0',
  `serviciomediopago` decimal(9,2) DEFAULT '0.00',
  `idabonoreserva` int DEFAULT '0',
  `esanticipo` int DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idfactura`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `registrosmediosdepago2022`
--


--
-- Table structure for table `reservas`
--

CREATE TABLE `reservas` (
  `id` bigint unsigned NOT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `fechain` date DEFAULT NULL,
  `fechaout` date DEFAULT NULL,
  `idusuario` int DEFAULT NULL,
  `idmesa` int DEFAULT NULL,
  `responsable` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `reservas`
--


--
-- Table structure for table `reservasauxiliar`
--

CREATE TABLE `reservasauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cliente` varchar(100) DEFAULT NULL,
  `cedula` varchar(15) DEFAULT NULL,
  `telefono` varchar(25) DEFAULT NULL,
  `fechaentrada` date DEFAULT NULL,
  `fechasalida` date DEFAULT NULL,
  `nacionalidad` varchar(25) DEFAULT NULL,
  `direccion` varchar(100) DEFAULT NULL,
  `ciudad` varchar(25) DEFAULT NULL,
  `marca` varchar(25) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `idcliente` bigint unsigned DEFAULT NULL,
  `idusuario` bigint unsigned DEFAULT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `idreserva` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idcliente` (`idcliente`,`idreserva`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `reservasauxiliar`
--


--
-- Table structure for table `resoluciones`
--

CREATE TABLE `resoluciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `fechainicioresolucion` date DEFAULT NULL,
  `fechafinresolucion` date DEFAULT NULL,
  `desde` bigint NOT NULL DEFAULT '0',
  `hasta` bigint NOT NULL DEFAULT '0',
  `numero` varchar(20) DEFAULT NULL,
  `prefijo` varchar(20) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `resoluciones`
--

INSERT INTO `resoluciones` (`id`, `fecha`, `fechainicioresolucion`, `fechafinresolucion`, `desde`, `hasta`, `numero`, `prefijo`, `cc`, `pv`) VALUES (1,NULL,NULL,NULL,0,0,'1',NULL,1,'distrito'),(2,NULL,NULL,NULL,0,0,'1',NULL,2,'distrito');

--
-- Table structure for table `respuestacostoagrupado`
--

CREATE TABLE `respuestacostoagrupado` (
  `idarticulo` int NOT NULL,
  `idinsumo` int NOT NULL,
  `idusuario` int NOT NULL,
  `cantidad` double NOT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `respuestacostoagrupado`
--


--
-- Table structure for table `respuestacotizacionreceta`
--

CREATE TABLE `respuestacotizacionreceta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` int NOT NULL,
  `idinsumo` bigint NOT NULL,
  `idusuario` int NOT NULL,
  `cantidad` double NOT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `respuestacotizacionreceta`
--

INSERT INTO `respuestacotizacionreceta` (`id`, `idarticulo`, `idinsumo`, `idusuario`, `cantidad`, `pv`) VALUES (1,0,20,1,1,'distrito'),(60,0,20,2,1,'distrito'),(61,0,98,2,2,'distrito');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `rol` varchar(50) DEFAULT ' ',
  `cc` int NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `rol`, `cc`, `pv`) VALUES (7,'CLIENTE',1,'distrito'),(9,'ADMINISTRADOR',1,'distrito'),(19,'CAJERA',2,'distrito'),(22,'DOMICILIARIO',2,'distrito'),(24,'PROVEEDOR',2,'distrito'),(27,'VENDEDOR',2,'distrito'),(30,'MESERO',2,'distrito');

--
-- Table structure for table `secciones`
--

CREATE TABLE `secciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idtienda` bigint unsigned DEFAULT '1',
  `seccion` varchar(30) NOT NULL DEFAULT '',
  `alias` varchar(30) NOT NULL DEFAULT '',
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `orden` int NOT NULL DEFAULT '0',
  `sevende` int NOT NULL DEFAULT '1',
  `extension` varchar(5) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `sesubearappi` int DEFAULT '1',
  `cantidaddearticulos` int DEFAULT '0',
  `sesubeaifood` int DEFAULT '0',
  `idifood` varchar(150) DEFAULT '0',
  `mostrarnombreentienda` bit(1) DEFAULT b'1',
  `iddomiciliario` int DEFAULT NULL,
  `saleentiendavirtual` int DEFAULT '0',
  `idseccionpagina` int DEFAULT '0',
  `urlfoto2` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `secciones`
--

INSERT INTO `secciones` (`id`, `idtienda`, `seccion`, `alias`, `cc`, `orden`, `sevende`, `extension`, `pv`, `sesubearappi`, `cantidaddearticulos`, `sesubeaifood`, `idifood`, `mostrarnombreentienda`, `iddomiciliario`, `saleentiendavirtual`, `idseccionpagina`, `urlfoto2`) VALUES (2,1,'ENTRADAS','',2,2,1,NULL,'extremabelleza',1,4,0,'0',_binary '',NULL,0,0,NULL),(3,1,'DESAYUNOS','',2,3,1,NULL,'extremabelleza',1,6,0,'0',_binary '',NULL,0,0,NULL),(4,1,'PLATO DEL DIA','',2,4,1,NULL,'extremabelleza',1,7,0,'0',_binary '',NULL,0,0,NULL),(5,1,'ALMUERZOS','',2,5,1,NULL,'extremabelleza',1,4,0,'0',_binary '',NULL,0,0,NULL),(6,1,'CARNES','',2,6,1,NULL,'extremabelleza',1,10,0,'0',_binary '',NULL,0,0,NULL),(7,1,'PESCADOS Y MARISCOS','',2,7,1,NULL,'extremabelleza',1,6,0,'0',_binary '',NULL,0,0,NULL),(8,1,'PASTA','',2,8,1,NULL,'extremabelleza',1,4,0,'0',_binary '',NULL,0,0,NULL),(9,1,'ARROCES','',2,9,1,NULL,'extremabelleza',1,3,0,'0',_binary '',NULL,0,0,NULL),(11,1,'BEBIDAS EN BOTELLA','',2,10,1,NULL,'extremabelleza',1,26,0,'0',_binary '',NULL,0,0,NULL),(12,1,'modificadores','',2,15,0,NULL,'extremabelleza',1,58,0,'0',_binary '',NULL,0,0,NULL),(14,1,'ADICIONES','',2,16,1,NULL,'extremabelleza',1,37,0,'0',_binary '',NULL,0,0,NULL),(17,1,'BEBIDAS EN VASO','',2,11,1,NULL,'extremabelleza',1,32,0,'0',_binary '',NULL,0,0,NULL),(18,1,'POSTRES','',2,13,1,NULL,'extremabelleza',1,8,0,'0',_binary '',NULL,0,0,NULL),(19,1,'BEBIDAS MAQUINA','',2,12,1,NULL,'extremabelleza',1,12,0,'0',_binary '',NULL,0,0,NULL),(20,1,'LICORES','',2,14,1,NULL,'extremabelleza',1,7,0,'0',_binary '',NULL,0,0,NULL),(21,1,'MATERIA PRIMA','',2,1,0,NULL,'extremabelleza',1,1,0,'0',_binary '',NULL,0,0,NULL),(22,1,'EVENTOS ESPECIALES','',2,17,1,NULL,'extremabelleza',1,0,0,'0',_binary '',NULL,0,0,NULL);

--
-- Table structure for table `seccionespagina`
--

CREATE TABLE `seccionespagina` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seccion` varchar(30) NOT NULL DEFAULT '',
  `orden` int NOT NULL DEFAULT '0',
  `publico` bit(1) DEFAULT b'1',
  `extension1` varchar(5) DEFAULT 'jpg',
  `extension2` varchar(5) DEFAULT 'jpg',
  `url` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `seccionespagina`
--


--
-- Table structure for table `seguimientovehiculos`
--

CREATE TABLE `seguimientovehiculos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL,
  `placa` varchar(7) DEFAULT NULL,
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `vencido` bigint NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `placa` (`placa`),
  CONSTRAINT `seguimientovehiculos_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `seguimientovehiculos_ibfk_3` FOREIGN KEY (`idz`) REFERENCES `z` (`id`),
  CONSTRAINT `seguimientovehiculos_ibfk_4` FOREIGN KEY (`placa`) REFERENCES `vehiculos` (`placa`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `seguimientovehiculos`
--


--
-- Table structure for table `separados`
--

CREATE TABLE `separados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` int NOT NULL DEFAULT '0',
  `idmayor` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `bruto` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `observacionesseparado` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idmayor` (`idmayor`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `separados`
--


--
-- Table structure for table `shopify`
--

CREATE TABLE `shopify` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sku` varchar(20) DEFAULT NULL,
  `inventory_item_id` varchar(20) DEFAULT NULL,
  `location_id` varchar(20) DEFAULT NULL,
  `product_id` varchar(20) DEFAULT NULL,
  `variant_id` varchar(20) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `sku` (`sku`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shopify`
--


--
-- Table structure for table `situacionesdecocina`
--

CREATE TABLE `situacionesdecocina` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `nombreimpresora` varchar(50) DEFAULT NULL,
  `cc` int DEFAULT NULL,
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'extremabelleza',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `situacionesdecocina`
--

INSERT INTO `situacionesdecocina` (`id`, `situacioncocina`, `nombreimpresora`, `cc`, `COD_SATELITE`, `pv`) VALUES (17,'CAJA','CAJA',2,'miry','miry'),(20,'COCINA','COCINA',2,'miry','miry'),(21,'BEBIDAS','COCINA',2,'miry','miry'),(22,'PARRILLA','COCINA',2,'miry','miry');

--
-- Table structure for table `solicitudesauxiliar`
--

CREATE TABLE `solicitudesauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmesa` int DEFAULT '1',
  `descuento` double NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL,
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `observaciones` varchar(125) DEFAULT NULL,
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirvio el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que el mesero ya entrego el producto',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `descripcion` varchar(100) DEFAULT NULL,
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcaja` (`idcaja`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `solicitudesauxiliar`
--


--
-- Table structure for table `solicitudesenviadas`
--

CREATE TABLE `solicitudesenviadas` (
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `origen` varchar(25) DEFAULT NULL,
  `destino` varchar(50) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `idmayor` int DEFAULT '0',
  `ESTADO` varchar(12) NOT NULL DEFAULT 'ENVIADA',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `costomedio` double DEFAULT '0',
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `solicitudesenviadas`
--


--
-- Table structure for table `solicitudesrecibidas`
--

CREATE TABLE `solicitudesrecibidas` (
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `origen` varchar(25) DEFAULT NULL,
  `destino` varchar(50) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `idmayor` int DEFAULT '0',
  `estado` varchar(25) DEFAULT 'ENVIADA',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `costomedio` double DEFAULT '0',
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `idfactura` int DEFAULT NULL,
  `referencia` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `solicitudesrecibidas`
--


--
-- Table structure for table `tareas`
--

CREATE TABLE `tareas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `idprospecto` bigint unsigned NOT NULL,
  `nota` text,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL,
  `orden` int DEFAULT '0',
  `estado` varchar(25) DEFAULT 'PENDIENTE',
  `tarea` text,
  `pv` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `fecha` (`fecha`,`idprospecto`),
  KEY `idprospecto` (`idprospecto`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tareas`
--


--
-- Table structure for table `temporal`
--

CREATE TABLE `temporal` (
  `id` int NOT NULL,
  `idarticulo` int NOT NULL DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `idusuario` int NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `temporal`
--


--
-- Table structure for table `temporal2`
--

CREATE TABLE `temporal2` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idinsumo` int NOT NULL DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `temporal2`
--


--
-- Table structure for table `tiendas`
--

CREATE TABLE `tiendas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tienda` varchar(50) DEFAULT NULL,
  `extension` varchar(4) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `orden` int DEFAULT '0',
  `url` varchar(220) DEFAULT NULL,
  `COD_SATELITE` varchar(50) DEFAULT NULL,
  `esbodega` int DEFAULT '0',
  `integradoabodega` int DEFAULT '1',
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `estadotienda` varchar(25) DEFAULT 'ABIERTA',
  `urllogo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiendas`
--

INSERT INTO `tiendas` (`id`, `tienda`, `extension`, `cc`, `orden`, `url`, `COD_SATELITE`, `esbodega`, `integradoabodega`, `pv`, `estadotienda`, `urllogo`) VALUES (1,'EXTREMA BELLEZA','png',2,1,'','extremabelleza',0,0,'extremabelleza','ABIERTA',NULL),(2,'EXTREMA PEREIRA',NULL,2,0,NULL,'extremapereira',0,0,'extremapereira','ABIERTA',NULL),(3,'MOR',NULL,2,0,NULL,'mor',0,0,'mor','ABIERTA',NULL),(4,'EXTREMA BELLEZA DOS',NULL,2,0,NULL,'extremabelleza2',0,0,'extremabelleza2','ABIERTA',NULL);

--
-- Table structure for table `tiposdecarroceria`
--

CREATE TABLE `tiposdecarroceria` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipodecarroceria` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `tipodecarroceria` (`tipodecarroceria`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiposdecarroceria`
--

INSERT INTO `tiposdecarroceria` (`id`, `tipodecarroceria`) VALUES (1,'Van'),(2,'Wagon'),(3,'Station '),(4,'Camioneta'),(5,'Microbus'),(6,'Bus'),(7,'Cerrado'),(8,'Doble cabina');

--
-- Table structure for table `tiposdegasto`
--

CREATE TABLE `tiposdegasto` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipodegasto` varchar(150) NOT NULL,
  `fechadecreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cc` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiposdegasto`
--

INSERT INTO `tiposdegasto` (`id`, `tipodegasto`, `fechadecreacion`, `cc`, `pv`) VALUES (4,'MANTENIMIENTO','2021-03-05 20:21:26',2,'distrito'),(5,'INSUMOS','2021-03-05 20:21:32',2,'distrito'),(10,'AGUA','2021-03-17 10:21:03',2,'distrito'),(11,'ENERGIA','2021-03-17 10:21:11',2,'distrito'),(12,'GAS NATURAL','2021-03-17 10:21:18',2,'distrito'),(13,'INTERNET','2021-03-17 10:21:27',2,'distrito'),(15,'IMPLEMENTOS DE ASEO','2021-03-17 10:37:11',2,'distrito'),(16,'GASOLINA','2021-09-30 15:40:36',2,'distrito'),(22,'PUBLICIDAD','2021-10-05 20:55:36',2,'distrito'),(35,'ARRENDO','2021-10-25 21:55:59',2,'distrito'),(36,'NOMINA','2022-05-25 16:17:41',2,'distrito');

--
-- Table structure for table `tiposdeingreso`
--

CREATE TABLE `tiposdeingreso` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipo` varchar(50) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiposdeingreso`
--

INSERT INTO `tiposdeingreso` (`id`, `tipo`, `pv`) VALUES (5,'BASE','distrito'),(6,'','distrito');

--
-- Table structure for table `tiposdenovedad`
--

CREATE TABLE `tiposdenovedad` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tipodenovedad` varchar(50) DEFAULT NULL,
  `descuentoauxilio` int DEFAULT '0',
  `porcentajepagado` decimal(5,2) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `cuenta_mediosdepago` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cc` (`descuentoauxilio`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiposdenovedad`
--


--
-- Table structure for table `tiquetsmediosdepago`
--

CREATE TABLE `tiquetsmediosdepago` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `idmesa` bigint unsigned NOT NULL DEFAULT '1',
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` int DEFAULT '0',
  `valor` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `cuenta_contable` int DEFAULT NULL,
  `esanticipo` tinyint unsigned DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idmesa`)
) ENGINE=InnoDB AUTO_INCREMENT=29916 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiquetsmediosdepago`
--

INSERT INTO `tiquetsmediosdepago` (`id`, `mediodepago`, `cc`, `idmesa`, `idcliente`, `idnc`, `valor`, `pv`, `cuenta_contable`, `esanticipo`, `idanticipo`, `anticpoencm`) VALUES (23328,'EFECTIVO',2,43,1,0,44000,'distrito',110505,0,0,0),(29730,'EFECTIVO',2,42,1,0,40000,'distrito',110505,0,0,0),(29758,'EFECTIVO',2,45,1,0,26500,'distrito',110505,0,0,0);

--
-- Table structure for table `tokenifood`
--

CREATE TABLE `tokenifood` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `token` text,
  `fecha` datetime DEFAULT NULL,
  `merchant_id` varchar(100) DEFAULT NULL,
  `catalog_id` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `client_secret` varchar(100) DEFAULT NULL,
  `url_ifood_authentication_token` varchar(250) DEFAULT NULL,
  `grantType` varchar(25) DEFAULT NULL,
  `clientId` varchar(250) DEFAULT NULL,
  `Secret` varchar(250) DEFAULT NULL,
  `refreshToken` varchar(1250) DEFAULT NULL,
  `urlcreararticulos` varchar(200) DEFAULT NULL,
  `urlparamirarlatienda` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tokenifood`
--


--
-- Table structure for table `tokenrappi`
--

CREATE TABLE `tokenrappi` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `COD_SATELITE` varchar(25) DEFAULT 'extremabelleza',
  `token` text,
  `fecha` datetime DEFAULT NULL,
  `audience` varchar(100) DEFAULT NULL,
  `client_id` varchar(100) DEFAULT NULL,
  `client_secret` varchar(100) DEFAULT NULL,
  `urltoken` varchar(100) DEFAULT NULL,
  `urlmenu` varchar(200) DEFAULT NULL,
  `storeId` varchar(50) NOT NULL,
  `urlactivaciones` varchar(200) DEFAULT NULL,
  `taken` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tokenrappi`
--

INSERT INTO `tokenrappi` (`id`, `COD_SATELITE`, `token`, `fecha`, `audience`, `client_id`, `client_secret`, `urltoken`, `urlmenu`, `storeId`, `urlactivaciones`, `taken`) VALUES (2,'extremabelleza','',NULL,'','','','','','lagringa','','');

--
-- Table structure for table `traslados`
--

CREATE TABLE `traslados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `referenciacruzada` int DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `factor` int DEFAULT '0',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `sku_traslados` varchar(25) DEFAULT NULL,
  `idmayor` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`),
  KEY `fk_traslados_idmayor` (`idmayor`),
  CONSTRAINT `fk_traslados_idmayor` FOREIGN KEY (`idmayor`) REFERENCES `mayorestraslados` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `traslados`
--


--
-- Table structure for table `trasladosauxiliar`
--

CREATE TABLE `trasladosauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmesa` int DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `origen` varchar(25) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃƒÂ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃƒÂ² el producto',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(50) DEFAULT NULL,
  `descripcion` varchar(50) DEFAULT NULL,
  `consecutivo` int DEFAULT '0',
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `sku_traslados_auxiliar` varchar(25) DEFAULT NULL,
  `idcliente` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosauxiliar`
--


--
-- Table structure for table `trasladosdesdecaja`
--

CREATE TABLE `trasladosdesdecaja` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `usuario` varchar(100) DEFAULT NULL,
  `valor` int DEFAULT '0',
  `mediodepago` varchar(100) DEFAULT NULL,
  `idz` int DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trasladosdesdecaja`
--


--
-- Table structure for table `trasladosentransito`
--

CREATE TABLE `trasladosentransito` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consecutivo` int NOT NULL,
  `referenciacruzada` int DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `origen` varchar(25) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `descripcion` varchar(100) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `sku` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosentransito`
--


--
-- Table structure for table `trasladosenviados`
--

CREATE TABLE `trasladosenviados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `factor` int DEFAULT '0',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosenviados`
--


--
-- Table structure for table `trasladosrecibidos`
--

CREATE TABLE `trasladosrecibidos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `bruto` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `referenciacruzada` int DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `factor` int DEFAULT '0',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `estado` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosrecibidos`
--


--
-- Table structure for table `trazabilidad`
--

CREATE TABLE `trazabilidad` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `texto` text,
  `idfactura` bigint unsigned NOT NULL,
  `usuarioenvia` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idfactura_f` (`idfactura`),
  CONSTRAINT `idfactura_f` FOREIGN KEY (`idfactura`) REFERENCES `facturas` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trazabilidad`
--

INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES (1,'2025-11-06 13:48:49','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 08:31:02\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":1,\"snotetop\":null,\"snotes\":\" Id: 603\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL   \",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL   \",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\" \",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"\",\"saddressline1\":\"\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"017575\",\"sdescription\":\"HUEVOS AL GUSTO\",\"snotes\":\".\",\"nunitprice\":14000,\"nquantity\":\"1\",\"nusertotal\":\"14000\",\"icount\":\"1\"}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"52\",\"wtowncode\":\"001\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"52\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}}}}}}}',603,'2'),(2,'2025-11-06 13:48:49','{rerror:1,smessage:{string:{0:Regla: FAJ29, Rechazo: Este código no corresponde a un valor válido de la lista,1:Regla: FAJ09, Rechazo: Este código no corresponde a un valor válido de la lista,2:Regla: CDG01, Rechazo: El código del departamento no coincide con el del municipio,3:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,4:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15628 characters],sdebug1:[encoded data, 17576 characters],yapprovedbytaxoffice:N,scufe:,sqr:NumFac: FEV1&#10;FecFac: 2025-11-06&#10;HorFac: 08:31:02-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 14000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 14000.00&#10;CUFE:&#10;bd2dfb69d760a883ef380a7dafafce731337290ccea8309c7cd8dfee2e70c74eca8f27628f0b0532ef06f668aaa9cc8c&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=bd2dfb69d760a883ef380a7dafafce731337290ccea8309c7cd8dfee2e70c74eca8f27628f0b0532ef06f668aaa9cc8c&#10;,ssignature:E3DIqZFsgp/3aZ8TP2YLRpdoOTc5hiopGwxFBx1UhvBCgI6hsWNvU3uowq9I+Mxfz4FQVIpA3ewecTeOXffqolCRaicv83VhBYXSkH8R3B/8eYbSzzyYPX2IjBQmeZovb/xWKIj06rPiDeS4n7gLjqFWdajLhaClMbvieMVEQHqjVy4QTHS3+TIKS+YOncbI/fKJdc2lRWytKKIcqLguqUTY2xDhioRawFpFzy2+mSNDu/4gbEl2XmkIIB/LvQFTe8bEy/I2+8vsQES/ZaQumCY9KoJHflmk6wJkzIcrLWXPes4BC1kFq+id3x7nU0gptPDFhpj2Q/L1/ZPaj5m7xw==,sdocumentreference:FEV1,rtaxxadocument:327603992,sref:FEV1,irefindex:1},sdebug:Taxxa: 0.317s DIAN: 1.978s (creación 0.791s, revalidación 1.187s baja 0s)}',603,'2'),(3,'2025-11-06 13:50:55','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 13:50:04\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":1,\"snotetop\":null,\"snotes\":\" Id: 636\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL   \",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL   \",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\" 3022841644\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"52\",\"wtowncode\":\"001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"szip\":\"055422\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"017908\",\"sdescription\":\"HUEVO DURO ADICION\",\"snotes\":\".\",\"nunitprice\":1500,\"nquantity\":\"1\",\"nusertotal\":\"1500\",\"icount\":\"1\"},\"2\":{\"sStandardItemIdentification\":\"017910\",\"sdescription\":\"PECHUGA A LA PLANCHA\",\"snotes\":\".\",\"nunitprice\":25000,\"nquantity\":\"1\",\"nusertotal\":\"25000\",\"icount\":\"1\"},\"3\":{\"sStandardItemIdentification\":\"017915\",\"sdescription\":\"POSTA SUDADA\",\"snotes\":\".\",\"nunitprice\":22000,\"nquantity\":\"1\",\"nusertotal\":\"22000\",\"icount\":\"1\"},\"4\":{\"sStandardItemIdentification\":\"017919\",\"sdescription\":\"PANELITA\",\"snotes\":\".\",\"nunitprice\":3000,\"nquantity\":\"1\",\"nusertotal\":\"3000\",\"icount\":\"1\"}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"52\",\"wtowncode\":\"001\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"52\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}}}}}}}',636,'2'),(4,'2025-11-06 13:50:55','{rerror:1,smessage:{string:{0:Regla: FAJ29, Rechazo: Este código no corresponde a un valor válido de la lista,1:Regla: FAJ09, Rechazo: Este código no corresponde a un valor válido de la lista,2:Regla: CDG01, Rechazo: El código del departamento no coincide con el del municipio,3:Regla: FAK29, Notificación: Este código no corresponde a un valor válido de la lista,4:Regla: FAK09, Notificación: Este código no corresponde a un valor válido de la lista,5:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.,6:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[encoded data, 15628 characters],sdebug1:[encoded data, 17840 characters],yapprovedbytaxoffice:N,scufe:,sqr:NumFac: FEV1&#10;FecFac: 2025-11-06&#10;HorFac: 13:50:04-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 51500.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 51500.00&#10;CUFE:&#10;d43e0120f5fbf7c7497917a7f560aeb78a97449c43e6d66fc8f63948c4f19ec57f5dfa204c835c9aaa8e557218254cda&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d43e0120f5fbf7c7497917a7f560aeb78a97449c43e6d66fc8f63948c4f19ec57f5dfa204c835c9aaa8e557218254cda&#10;,ssignature:i8Dj98vPEA89UdRmTGvaOOW99VPy2HAHZf4CoSpQcXgnFglfZ0LwjhVg14K3q+3ivc222wDzbmhz5QDx+fTvgwfkP0AWDBh/824VNeLoERxk3ZAgniRsje39y6TLOP9t4BA4HohbbDmHaBtOTYuzcKy2uG3u3qUNozmI7wH941xV122d1t8C+vmDruAC/kWjchxM7KdsF5Ya8ygxHgt5GTk2lMlBPB04NBH/yGox18ImRBE2q/8grtzE6W18oT1nOyYwVene2OGQytpsEiWQGY/UrC/hdduoYaPlTHxdX+FGs580abqn6z1WFJt2H1iDsNFOoEfHWSxEJZZx/kyNMg==,sdocumentreference:FEV1,rtaxxadocument:327603992,sref:FEV1,irefindex:1},sdebug:Taxxa: 0.344s DIAN: 1.271s (creación 0.657s, revalidación 0.614s baja 0s)}',636,'2'),(5,'2025-11-06 14:01:57','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 08:31:02\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":1,\"snotetop\":null,\"snotes\":\" Id: 603\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL   \",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL   \",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\" \",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"\",\"saddressline1\":\"\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"017575\",\"sdescription\":\"HUEVOS AL GUSTO\",\"snotes\":\".\",\"nunitprice\":14000,\"nquantity\":\"1\",\"nusertotal\":\"14000\",\"icount\":\"1\"}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}}}}}}}',603,'2'),(6,'2025-11-06 14:01:57','{rerror:0,smessage:{string:{0:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15224 characters],sdebug1:[encoded data, 16724 characters],yapprovedbytaxoffice:Y,scufe:bd2dfb69d760a883ef380a7dafafce731337290ccea8309c7cd8dfee2e70c74eca8f27628f0b0532ef06f668aaa9cc8c,sqr:NumFac: FEV1&#10;FecFac: 2025-11-06&#10;HorFac: 08:31:02-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 14000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 14000.00&#10;CUFE:&#10;bd2dfb69d760a883ef380a7dafafce731337290ccea8309c7cd8dfee2e70c74eca8f27628f0b0532ef06f668aaa9cc8c&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=bd2dfb69d760a883ef380a7dafafce731337290ccea8309c7cd8dfee2e70c74eca8f27628f0b0532ef06f668aaa9cc8c&#10;,ssignature:Ip1OR90bGZKlRZbQ1USUd8FKMiJoCPDRJV6k3QxNn0ADlCVDFz63nD54h/ZPtilRzJA+FrUKEmKO2CWSlPmLQebT8popDkga2RY/6rXv5FI4Q0M09oo45LrNnKxa0PjOfWRghy6ZWm6FMsGEB89j1oYfvyVKlLQmEXgSkfO/TgoKVOAWfrsdY3ZaiaQvzv74EPjimggo/CCpGrrOxXjaSn9h5v2U0ag3viori4YvwSFmU6LiwlO0R3e4iEHYutuixNFU7mbVHL9PDL2ujtY9Zm612c27YP4JTX3Ebtrv3S7qjSLv1QcCKWJoSG7oqMUALW3/gkAV4MAwpfVckN8eJA==,sdocumentreference:FEV1,rtaxxadocument:327603992,sref:FEV1,irefindex:1},sdebug:Taxxa: 0.4s DIAN: 1.699s (creación 0.767s, revalidación 0.932s baja 0s)}',603,'2'),(7,'2025-11-06 14:02:53','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 08:38:45\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":2,\"snotetop\":null,\"snotes\":\" Id: 604\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL   \",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL   \",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\" \",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"\",\"saddressline1\":\"\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"017578\",\"sdescription\":\"CARNE CON HUEVO\",\"snotes\":\".\",\"nunitprice\":18000,\"nquantity\":\"2\",\"nusertotal\":\"36000\",\"icount\":\"2\"},\"2\":{\"sStandardItemIdentification\":\"017581\",\"sdescription\":\"CARNE CON HUEVO\",\"snotes\":\".\",\"nunitprice\":18000,\"nquantity\":\"1\",\"nusertotal\":\"18000\",\"icount\":\"1\"}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}}}}}}}',604,'2'),(8,'2025-11-06 14:02:53','{rerror:0,smessage:{string:{0:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15224 characters],sdebug1:[encoded data, 16728 characters],yapprovedbytaxoffice:Y,scufe:50af87fa540faffca4530f9adf9e0140afe1119fe0bb8e6d8af88f506d3eefb589da9c01a90ace9db84be109b53a5fca,sqr:NumFac: FEV2&#10;FecFac: 2025-11-06&#10;HorFac: 08:38:45-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 54000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 54000.00&#10;CUFE:&#10;50af87fa540faffca4530f9adf9e0140afe1119fe0bb8e6d8af88f506d3eefb589da9c01a90ace9db84be109b53a5fca&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=50af87fa540faffca4530f9adf9e0140afe1119fe0bb8e6d8af88f506d3eefb589da9c01a90ace9db84be109b53a5fca&#10;,ssignature:GXN1ggl2SoCjYiUm/EAjtuPfuXKZImRWYOPqi+OIfUe9ugR8qOr1YfRUo4j8CyAiSQsy+gt8u17/ONWyzakiaSBgYf2ys9CyrDzkAFTrLW+TDVBaVciFRikMkWpUYkv1vbRLBm1hNqp7tfh9FozpPIe8LEwzxUOgD8rO0FsNhpL8twtTqKiOZYry9tFC0CXgsFUvkDSttoU+HGISsEO8oInYleFanJLryTko4IuRmnmQoea46HBZVIX7U3GqKnxw6OkEiyOPSfCn4k50V/B1cN1A+MxJVfSosRd/xacltbps5HjcWJ2XXzYJOrx67B8S29eBIH9lTlpAGUDnexq48g==,sdocumentreference:FEV2,rtaxxadocument:327615664,sref:FEV2,irefindex:2},sdebug:Taxxa: 0.372s DIAN: 2.354s (creación 1.712s, revalidación 0.642s baja 0s)}',604,'2'),(9,'2025-11-06 14:34:55','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 14:34:55\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":3,\"snotetop\":null,\"snotes\":\" Id: 653\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL\",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"szip\":\"055422\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"018113\",\"sdescription\":\"AGUA MANANTIAL\",\"snotes\":\"\",\"nunitprice\":5556,\"nquantity\":\"1\",\"nusertotal\":\"5555.555555555555\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":5555.56,\"namount\":444.44}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',653,'2'),(10,'2025-11-06 14:34:55','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17388 characters],yapprovedbytaxoffice:Y,scufe:853a397134d0072d26e55c15c22d5cc08976f4066ba1d57f856916a252a2d2fa8ea440c0d6d7a41a21812c5c585ac59c,sqr:NumFac: FEV3&#10;FecFac: 2025-11-06&#10;HorFac: 14:34:55-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 5555.56&#10;ValIva: 0.00&#10;ValOtroIm: 444.44&#10;ValTolFac: 6000.00&#10;CUFE:&#10;853a397134d0072d26e55c15c22d5cc08976f4066ba1d57f856916a252a2d2fa8ea440c0d6d7a41a21812c5c585ac59c&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=853a397134d0072d26e55c15c22d5cc08976f4066ba1d57f856916a252a2d2fa8ea440c0d6d7a41a21812c5c585ac59c&#10;,ssignature:AqH1TQcX6a3V48yEkG1YcGl/GCQK3wcXJ66Y07u91k8SC8nmM8lWO2pfb9uPH4u4kBfBUBMh6p51OQV48slUu3pAcn9D8daQdVp/XHi5E9b2xCRXSZ/CkX1fTa2eAGhvxcx1GZIu25bTNaTvHaSXi1mCRJ8zJ5PGNo/6ecOmZLtprJYcRyiuaGBTBPzDQTTWCNGxHDPFSFXe8gtOsprQkklyyMT/4a7Gc1l/nSTqFMnTRyxlXjRapsb51WKOz7IexZnX15LlhKF+OugaZe9bf5O0oa5XevmWwKOyGbDzsywemOsDeJPgBavFtWa29uaDnUpzWFZ8c3jOmfBOuUbURA==,sdocumentreference:FEV3,rtaxxadocument:327640558,sref:FEV3,irefindex:3},sdebug:Taxxa: 0.373s DIAN: 2.069s (creación 0.842s, revalidación 1.227s baja 0s)}',653,'2'),(11,'2025-11-06 14:38:33','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 14:38:33\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":4,\"snotetop\":null,\"snotes\":\" Id: 655\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL\",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"szip\":\"055422\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"018117\",\"sdescription\":\"AGUA MANANTIAL\",\"snotes\":\"\",\"nunitprice\":5556,\"nquantity\":\"1\",\"nusertotal\":\"5555.555555555555\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":5555.56,\"namount\":444.44}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',655,'2'),(12,'2025-11-06 14:38:33','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17380 characters],yapprovedbytaxoffice:Y,scufe:340e0ab61359f2d7b95bb05fd3a9ae84f7d42347b897a7da791369a0aaa5e10b7c0a82f09181f3e93d85986e7590928a,sqr:NumFac: FEV4&#10;FecFac: 2025-11-06&#10;HorFac: 14:38:33-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 5555.56&#10;ValIva: 0.00&#10;ValOtroIm: 444.44&#10;ValTolFac: 6000.00&#10;CUFE:&#10;340e0ab61359f2d7b95bb05fd3a9ae84f7d42347b897a7da791369a0aaa5e10b7c0a82f09181f3e93d85986e7590928a&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=340e0ab61359f2d7b95bb05fd3a9ae84f7d42347b897a7da791369a0aaa5e10b7c0a82f09181f3e93d85986e7590928a&#10;,ssignature:gvr8Byd/7Zfnv4Su+3rk1C96bvK5cHmVywx+ZYj7rW3ej+DZXJFSwukd75WuR1xYgmmvHwWi6PKd6n2585GMs8/o7Ux3G2Ri3BEXVC8Ux4PMcZBKkzm4HlsAC9pRk+Qc3lCLbEAhABm3ktdS75//JPokN2L7QaXDv8cSW9KvpujHiW+Ut14sof8Zfr9JC4U/lLpqAShHFI+4+ZmmAFQt7KL/0YSsuZmk1TO8MRIUf+ASwPu6yx/grJ3/fkxMbqV5D0XzlHiRkVFiTQyBuBcYkB318torgCvHCB2eVbKCiLoFEouFs0wh6IwcwwP3VTITgBxZ7OYxpvnPCD0sMIgddA==,sdocumentreference:FEV4,rtaxxadocument:327643040,sref:FEV4,irefindex:4},sdebug:Taxxa: 0.335s DIAN: 1.642s (creación 0.936s, revalidación 0.706s baja 0s)}',655,'2'),(13,'2025-11-06 15:28:40','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-06 15:28:40\",\"tduedate\":\"2025-11-13\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":5,\"snotetop\":null,\"snotes\":\" Id: 677\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-06\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"company\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"SOLUCIONES EN INGENIERIA AMBIENTAL Y SEGURIDAD EN EL TRABAJO SAS\",\"jpartylegalentity\":{\"wdoctype\":\"NIT\",\"sdocno\":\"900596987\"},\"jcontact\":{\"scontactperson\":\"SOLUCIONES EN INGENIERIA AMBIENTAL Y SEGURIDAD EN EL TRABAJO SAS\",\"selectronicmail\":\"CONTABILIDAD@LISOMA.CO\",\"stelephone\":\"3218811609\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"carrera 25 # 39 sur 40\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"018393\",\"sdescription\":\"BOCADILLO\",\"snotes\":\"\",\"nunitprice\":556,\"nquantity\":\"1\",\"nusertotal\":\"555.5555555555555\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":555.56,\"namount\":44.44}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',677,'8'),(14,'2025-11-06 15:28:40','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17388 characters],yapprovedbytaxoffice:Y,scufe:d0026daf2c6540d646dd764afe612942ac8d017d706ad0e6986bf6f4750af00628fa56a4cd3d4a34a7da3486da36ac26,sqr:NumFac: FEV5&#10;FecFac: 2025-11-06&#10;HorFac: 15:28:40-05:00&#10;NitFac: 901944112&#10;DocAdq: 900596987&#10;ValFac: 555.56&#10;ValIva: 0.00&#10;ValOtroIm: 44.44&#10;ValTolFac: 600.00&#10;CUFE:&#10;d0026daf2c6540d646dd764afe612942ac8d017d706ad0e6986bf6f4750af00628fa56a4cd3d4a34a7da3486da36ac26&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d0026daf2c6540d646dd764afe612942ac8d017d706ad0e6986bf6f4750af00628fa56a4cd3d4a34a7da3486da36ac26&#10;,ssignature:OrogueaDHJG2guRoXtaM1nv1XvTzNQMovvvnbfPgk9ptPBPILX6wBbU3+49i1zjXLggA87T3ZdB2RkwXrQi9q4FErg0AHirb9VQqmwTMNv7fYH0iB6qCCbhd+hIEAzZsqJ+a3SCR04q0P524cdPE+6vRCPnC5DHIaokORiRRM1EK4F8UuA+iQVnlvJsn4B89Rya17uRnZ0URbbBzwosz4HHajXDhNnAngndLu+9/W1kqvR/gZ2dDpB8nnfDLHfcS9cPdoDceqgCrGNH99GGrdISmDdeGvQJfItsm71juve/8dC0du4GswkE+wkj90gg4I7cioKgvRSND8bQhtYDhfg==,sdocumentreference:FEV5,rtaxxadocument:327681163,sref:FEV5,irefindex:5},sdebug:Taxxa: 0.662s DIAN: 1.506s (creación 0.799s, revalidación 0.707s baja 0s)}',677,'8'),(15,'2025-11-07 13:28:22','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-07 13:28:22\",\"tduedate\":\"2025-11-14\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":6,\"snotetop\":null,\"snotes\":\" Id: 743\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-07\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"TRUJILLO MEJIA JOHN JAIRO\",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"70564646\"},\"jcontact\":{\"scontactperson\":\"TRUJILLO MEJIA JOHN JAIRO\",\"selectronicmail\":\"contonysonestudio@gmail.com\",\"stelephone\":\"3007734111\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"Calle 39 D sur neo 45 03 calle basura casa 2 piso\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"018989\",\"sdescription\":\"JUEVES SUDADO DE POLLO\",\"snotes\":\"\",\"nunitprice\":24074,\"nquantity\":\"1\",\"nusertotal\":\"24074.074074074073\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":24074.07,\"namount\":1925.93}}},\"2\":{\"sStandardItemIdentification\":\"018993\",\"sdescription\":\"CHICHARRON\",\"snotes\":\"\",\"nunitprice\":20370,\"nquantity\":\"1\",\"nusertotal\":\"20370.37037037037\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":20370.37,\"namount\":1629.63}}},\"3\":{\"sStandardItemIdentification\":\"018997\",\"sdescription\":\"ADICION AGUACATE\",\"snotes\":\"\",\"nunitprice\":3704,\"nquantity\":\"1\",\"nusertotal\":\"3703.7037037037035\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":3703.7,\"namount\":296.3}}},\"4\":{\"sStandardItemIdentification\":\"018998\",\"sdescription\":\"GUANDOLO ADICIONAL\",\"snotes\":\"\",\"nunitprice\":2778,\"nquantity\":\"1\",\"nusertotal\":\"2777.7777777777774\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":2777.78,\"namount\":222.22}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',743,'8'),(16,'2025-11-07 13:28:22','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17388 characters],yapprovedbytaxoffice:Y,scufe:4207e2acf04bc04c6dcb631a04ce579ad552a91152f6a16b3f0c0a17962ddacc85761612a9ca741d2b0f06fd813248a8,sqr:NumFac: FEV6&#10;FecFac: 2025-11-07&#10;HorFac: 13:28:22-05:00&#10;NitFac: 901944112&#10;DocAdq: 70564646&#10;ValFac: 50925.93&#10;ValIva: 0.00&#10;ValOtroIm: 4074.08&#10;ValTolFac: 55000.01&#10;CUFE:&#10;4207e2acf04bc04c6dcb631a04ce579ad552a91152f6a16b3f0c0a17962ddacc85761612a9ca741d2b0f06fd813248a8&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=4207e2acf04bc04c6dcb631a04ce579ad552a91152f6a16b3f0c0a17962ddacc85761612a9ca741d2b0f06fd813248a8&#10;,ssignature:RmdYzgSuIj0F9mWJS5+E7o9GgtAdmmdnZTHAc8dm5cr/hiaaua256swB2wsCFdupQAZPAg+T+EGh9hH/C0fIE7c0Yg+8FI2jmH40O/72iHkbkKE9nVgD1dQPpFttPx0P8UnWJkbLgVLdSuFYCsoqWb5QFFTXE7Px0zo3xyO2PDee/UgE66ejjqIZMteKA3St62IAdlsaLis7z3kULiD0e3eJGCFxhR44vlQ61Gqu21XlkGiwU5tWg6k0pE79ststrVg3RPwRu1c+k81+RZI6rP/exzkmj4HfjFlYXHVhL3QB46SJzaVbO65xlgxszsyLROHV/lEZbtSNvlw6eagsYA==,sdocumentreference:FEV6,rtaxxadocument:328198608,sref:FEV6,irefindex:6},sdebug:Taxxa: 0.344s DIAN: 1.534s (creación 0.839s, revalidación 0.695s baja 0s)}',743,'8'),(17,'2025-11-09 15:37:48','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-09 15:37:47\",\"tduedate\":\"2025-11-16\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":7,\"snotetop\":null,\"snotes\":\" Id: 1076\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"46\",\"tPaymentDueDate\":\"2025-11-09\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"JULIAN LOPEZ\",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"8033605\"},\"jcontact\":{\"scontactperson\":\"JULIAN LOPEZ\",\"selectronicmail\":\"JULIANDLOPEZVELASQUEZ@GMAIL.COM\",\"stelephone\":\"3014887677\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"NA\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"0113185\",\"sdescription\":\"CHICHARRON\",\"snotes\":\"\",\"nunitprice\":24537,\"nquantity\":\"2\",\"nusertotal\":\"49074.07407407407\",\"icount\":\"2\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":49074.07,\"namount\":3925.93}}},\"2\":{\"sStandardItemIdentification\":\"0113190\",\"sdescription\":\"ROBALO A LA MILANESA\",\"snotes\":\"\",\"nunitprice\":23148,\"nquantity\":\"1\",\"nusertotal\":\"23148.148148148146\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":23148.15,\"namount\":1851.85}}},\"3\":{\"sStandardItemIdentification\":\"0113194\",\"sdescription\":\"CERVEZA AGUILA\",\"snotes\":\"\",\"nunitprice\":5556,\"nquantity\":\"1\",\"nusertotal\":\"5555.555555555555\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":5555.56,\"namount\":444.44}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',1076,'16'),(18,'2025-11-09 15:37:48','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17388 characters],yapprovedbytaxoffice:Y,scufe:2931ede34c5761784a953cdcf79325db0552ed82f2ec80befd928b677e3041bf4d32e9cd58d19d74ff2d33060be2161a,sqr:NumFac: FEV7&#10;FecFac: 2025-11-09&#10;HorFac: 15:37:47-05:00&#10;NitFac: 901944112&#10;DocAdq: 8033605&#10;ValFac: 77777.78&#10;ValIva: 0.00&#10;ValOtroIm: 6222.22&#10;ValTolFac: 84000.00&#10;CUFE:&#10;2931ede34c5761784a953cdcf79325db0552ed82f2ec80befd928b677e3041bf4d32e9cd58d19d74ff2d33060be2161a&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=2931ede34c5761784a953cdcf79325db0552ed82f2ec80befd928b677e3041bf4d32e9cd58d19d74ff2d33060be2161a&#10;,ssignature:VS126h9Nae2Y8+x4H5LJw4UjzHZu221VUGnVeCUm01R632zq0JkOw9fJND33J9usI4AkSq55xdnB4Eexp0lqfO7JMQw3v03ELEK9p/nAU0zN4SI524XfV7vgpRuuZ97B2KFNiloUM04WAmTtneoA/KE0JU4tF6ZXYtoyB5IlUhkVTCKFH0wksd6VZ0IcEE/fnQhOYc1lB1IgKrkOaEo1LkXrwWRt9xsZZ2MUtisN1Gz0lFJej1Ig2lvn8VkF/LwkMVDQUPETXao6NGhfXEV9sPAHumlihQzmj5Kr4HxcxcOHhDASdLew/kdBQDqNILMm6hLlJVeoqxwjWZipT8MayQ==,sdocumentreference:FEV7,rtaxxadocument:329524898,sref:FEV7,irefindex:7},sdebug:Taxxa: 0.354s DIAN: 1.348s (creación 0.796s, revalidación 0.552s baja 0s)}',1076,'16'),(19,'2025-11-09 15:44:39','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-09 15:44:38\",\"tduedate\":\"2025-11-16\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":8,\"snotetop\":null,\"snotes\":\" Id: 1079\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"46\",\"tPaymentDueDate\":\"2025-11-09\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"GERMAN ANDRES CALVO RUIZ\",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"71331006\"},\"jcontact\":{\"scontactperson\":\"CALVO RUIZ GERMAN ANDRES\",\"selectronicmail\":\"ferreteria.elcastor@hotmail.com\",\"stelephone\":\"3128764349\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"NA\",\"szip\":\"055422\"}}},\"aallowancecharge\":[{\"schargeindicator\":\"true\",\"sallowancechargereason\":\"Propina\",\"sallowancechargereasoncode\":\"04\",\"smultiplierfactornumeric\":5,\"namount\":\"4565\",\"nbaseamount\":\"84537.03703703704\"}],\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"0113229\",\"sdescription\":\"DOMINGO: SANCOCHO DE BAGRE\",\"snotes\":\"\",\"nunitprice\":25926,\"nquantity\":\"1\",\"nusertotal\":\"25925.925925925923\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":25925.93,\"namount\":2074.07}}},\"2\":{\"sStandardItemIdentification\":\"0113232\",\"sdescription\":\"SOLOMITO\",\"snotes\":\"\",\"nunitprice\":40741,\"nquantity\":\"1\",\"nusertotal\":\"40740.74074074074\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":40740.74,\"namount\":3259.26}}},\"3\":{\"sStandardItemIdentification\":\"0113236\",\"sdescription\":\"MORA\",\"snotes\":\"\",\"nunitprice\":5556,\"nquantity\":\"1\",\"nusertotal\":\"5555.555555555555\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":5555.56,\"namount\":444.44}}},\"4\":{\"sStandardItemIdentification\":\"0113238\",\"sdescription\":\"TINTO MAQUINA\",\"snotes\":\"\",\"nunitprice\":3241,\"nquantity\":\"1\",\"nusertotal\":\"3240.7407407407404\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":3240.74,\"namount\":259.26}}},\"5\":{\"sStandardItemIdentification\":\"0113239\",\"sdescription\":\"COOKIES Y CREAM\",\"snotes\":\"\",\"nunitprice\":9074,\"nquantity\":\"1\",\"nusertotal\":\"9074.074074074073\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":9074.07,\"namount\":725.93}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',1079,'16'),(20,'2025-11-09 15:44:39','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17396 characters],yapprovedbytaxoffice:Y,scufe:db7dac632efaa915ae92cbe41b100a874154eb69576795c0cc1b52bde047e9b6a3396614011e0e5ed30c1253d928ebed,sqr:NumFac: FEV8&#10;FecFac: 2025-11-09&#10;HorFac: 15:44:38-05:00&#10;NitFac: 901944112&#10;DocAdq: 71331006&#10;ValFac: 84537.04&#10;ValIva: 0.00&#10;ValOtroIm: 6762.96&#10;ValTolFac: 95865.00&#10;CUFE:&#10;db7dac632efaa915ae92cbe41b100a874154eb69576795c0cc1b52bde047e9b6a3396614011e0e5ed30c1253d928ebed&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=db7dac632efaa915ae92cbe41b100a874154eb69576795c0cc1b52bde047e9b6a3396614011e0e5ed30c1253d928ebed&#10;,ssignature:aalsqU9QAKUDoKazsIuBMzvH5noqMDdYYgCyNpPkBd8gllpcHbAH2hwa0xCRtonVuXSp/b8g9GM7P1rVEXByCq56w3vran6GpM6KlAYi2Rl0913G/tTOXeqMHy7/OYGhqT1Vn6aHRtORIoYHTNqNdltyC0GGHML8wMsqXbjEjnx1OcMlOY9TWdRbvLv4ai+hy/pMRyy5NVOw/is/oDS/B7cJky3Ou2KQe2TfsKUfqcYqbTpUMXS2irSNV98iTDnWVhMWgsoImoN6OSCKSKI2XHsTftH+WRo8AX03QtduvQnm+2MbAt/bHXivLxp/YDD6wjoH2SoOg6w+WuFmKSbhvA==,sdocumentreference:FEV8,rtaxxadocument:329529258,sref:FEV8,irefindex:8},sdebug:Taxxa: 0.371s DIAN: 1.458s (creación 0.911s, revalidación 0.548s baja 0s)}',1079,'16'),(21,'2025-11-10 14:13:00','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-10 14:13:00\",\"tduedate\":\"2025-11-17\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":9,\"snotetop\":null,\"snotes\":\" Id: 1190\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"10\",\"tPaymentDueDate\":\"2025-11-10\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"ESCUELA DE AUDIO Y SONIDO\",\"jpartylegalentity\":{\"wdoctype\":\"NIT\",\"sdocno\":\"900673166\"},\"jcontact\":{\"scontactperson\":\"ESCUELA DE AUDIO Y SONIDO DE COLOMBIA\",\"selectronicmail\":\"EASCOLOMBIA@HOTMAIL.COM\",\"stelephone\":\"3333379\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"66\",\"wtowncode\":\"66001\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"NA\",\"szip\":\"660001\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"0114420\",\"sdescription\":\"POLLO A LA PARRILLA\",\"snotes\":\"\",\"nunitprice\":35185,\"nquantity\":\"2\",\"nusertotal\":\"70370.37037037036\",\"icount\":\"2\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":70370.37,\"namount\":5629.63}}},\"2\":{\"sStandardItemIdentification\":\"0114423\",\"sdescription\":\"PUNTA DE ANCA AL CARBON\",\"snotes\":\"\",\"nunitprice\":40741,\"nquantity\":\"1\",\"nusertotal\":\"40740.74074074074\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":40740.74,\"namount\":3259.26}}},\"3\":{\"sStandardItemIdentification\":\"0114427\",\"sdescription\":\"LIMONADA NATURAL\",\"snotes\":\"\",\"nunitprice\":5556,\"nquantity\":\"1\",\"nusertotal\":\"5555.555555555555\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":5555.56,\"namount\":444.44}}},\"4\":{\"sStandardItemIdentification\":\"0114428\",\"sdescription\":\"GUANDOLO ADICIONAL\",\"snotes\":\"\",\"nunitprice\":2778,\"nquantity\":\"1\",\"nusertotal\":\"2777.7777777777774\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":2777.78,\"namount\":222.22}}},\"5\":{\"sStandardItemIdentification\":\"0114429\",\"sdescription\":\"COCACOLA CERO\",\"snotes\":\"\",\"nunitprice\":4630,\"nquantity\":\"1\",\"nusertotal\":\"4629.62962962963\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":4629.63,\"namount\":370.37}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',1190,'7'),(22,'2025-11-10 14:13:00','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15696 characters],sdebug1:[encoded data, 17388 characters],yapprovedbytaxoffice:Y,scufe:66b3f10f7c0f7ebb7f72bc92c6aed33af371c40f4ab946f962d6488baff4d6f773d7eaf3d521520c740869fa0def9601,sqr:NumFac: FEV9&#10;FecFac: 2025-11-10&#10;HorFac: 14:13:00-05:00&#10;NitFac: 901944112&#10;DocAdq: 900673166&#10;ValFac: 124074.07&#10;ValIva: 0.00&#10;ValOtroIm: 9925.92&#10;ValTolFac: 133999.99&#10;CUFE:&#10;66b3f10f7c0f7ebb7f72bc92c6aed33af371c40f4ab946f962d6488baff4d6f773d7eaf3d521520c740869fa0def9601&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=66b3f10f7c0f7ebb7f72bc92c6aed33af371c40f4ab946f962d6488baff4d6f773d7eaf3d521520c740869fa0def9601&#10;,ssignature:JfxmNlWe4l39ZNfvzh12KxMsRSpUAOqVEZuoxq4qADLsWL17z6RpF3q9dkPwzMitspVXpm9/fWqdPM8+lkomgiirsC/orqpbI8GR/+Dd8DSIUUYhJ0yheeFd3hMiWG8rze2u5S37qhrFqd7AIDk3476v3yS2BPlOR+0VGfV8Qo1IevYDWb1hz7g/y7uuBHpUyEwF3c6NyNKkOAJHAcj1N0xSVrmn07uyP6GFoOxKbEUT+Zue7Zo/RrFomOllIBnLN/wMTUqggMIkmP2ayZmc9G0ZU4KNFlP1QEOOFyvcvhjBG8hSo4PUUuj2kNouPumjbcJEgTXJyxkk2rvnJLSF3Q==,sdocumentreference:FEV9,rtaxxadocument:329989550,sref:FEV9,irefindex:9},sdebug:Taxxa: 0.546s DIAN: 3.627s (creación 3.082s, revalidación 0.545s baja 0s)}',1190,'7'),(23,'2025-11-10 14:26:14','{\"sToken\":\"834321153356\",\"jApi\":{\"sMethod\":\"classTaxxa.fjDocumentAdd\",\"jParams\":{\"wEnvironment\":\"prod\",\"wVersionUBL\":2.1,\"jDocument\":{\"wdocumenttypecode\":\"01\",\"wdocumenttype\":\"Invoice\",\"rdocumenttemplate\":\"4477128\",\"wcurrency\":\"COP\",\"tissuedate\":\"2025-11-10 14:26:14\",\"tduedate\":\"2025-11-17\",\"sDocumentPrefix\":\"FEV\",\"sDocumentSuffix\":10,\"snotetop\":null,\"snotes\":\" Id: 1196\",\"jextrainfo\":[],\"jPaymentMeans\":{\"1\":{\"wPaymentMeans\":\"1\",\"wPaymentMethod\":\"46\",\"tPaymentDueDate\":\"2025-11-10\",\"sPaymentId\":\"1\"}},\"jbuyer\":{\"wlegalorganizationtype\":\"person\",\"sfiscalresponsibilities\":\"R-99-PN\",\"sfiscalregime\":\"49\",\"scustomername\":\"CONSUMIDOR FINAL\",\"jpartylegalentity\":{\"wdoctype\":\"CC\",\"sdocno\":\"222222222222\"},\"jcontact\":{\"scontactperson\":\"CONSUMIDOR FINAL\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"scountrycode\":\"co\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"szip\":\"055422\"}}},\"jdocumentitems\":{\"1\":{\"sStandardItemIdentification\":\"0114519\",\"sdescription\":\"CARNE MOLIDA\",\"snotes\":\"\",\"nunitprice\":16296,\"nquantity\":\"1\",\"nusertotal\":\"16296.296296296296\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":16296.3,\"namount\":1303.7}}},\"2\":{\"sStandardItemIdentification\":\"0114524\",\"sdescription\":\"RES\",\"snotes\":\"\",\"nunitprice\":16296,\"nquantity\":\"1\",\"nusertotal\":\"16296.296296296296\",\"icount\":\"1\",\"jtax\":{\"jinc\":{\"nrate\":\"8\",\"sname\":\"INC\",\"nbaseamount\":16296.3,\"namount\":1303.7}}}},\"jseller\":{\"sdocid\":\"901944112\",\"saddresszip\":\"055422\",\"wdepartmentcode\":\"05\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"sdoctype\":\"NIT\",\"ssellername\":\"RESTAURANTE BAR EL PORTAL DE MIRY S.A.S\",\"jcontact\":{\"scontactperson\":\"JAVIER ALEXANDER BUSTAMANTE ACEVEDO\",\"selectronicmail\":\"PORTALDEMIRY@GMAIL.COM\",\"stelephone\":\"3022841644\",\"jregistrationaddress\":{\"wdepartmentcode\":\"05\",\"sdepartmentname\":\"ANTIOQUIA\",\"wtowncode\":\"05266\",\"scityname\":\"ENVIGADO\",\"saddressline1\":\"CRA 39  38 A SUR 32\",\"scountrycode\":\"CO\",\"szip\":\"055422\"}},\"stributaryidentificationkey\":\"ZA\",\"stributaryidentificationname\":\"IVA E INC\"}}}}}',1196,'7'),(24,'2025-11-10 14:26:14','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.,2:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15700 characters],sdebug1:[encoded data, 17396 characters],yapprovedbytaxoffice:Y,scufe:4e25bd2780d987818f1116db97edacf446406f1af6a8a25fb9b36b28513ceb138373b783124e4dd636ac1e6ae095f80b,sqr:NumFac: FEV10&#10;FecFac: 2025-11-10&#10;HorFac: 14:26:14-05:00&#10;NitFac: 901944112&#10;DocAdq: 222222222222&#10;ValFac: 32592.59&#10;ValIva: 0.00&#10;ValOtroIm: 2607.40&#10;ValTolFac: 35199.99&#10;CUFE:&#10;4e25bd2780d987818f1116db97edacf446406f1af6a8a25fb9b36b28513ceb138373b783124e4dd636ac1e6ae095f80b&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=4e25bd2780d987818f1116db97edacf446406f1af6a8a25fb9b36b28513ceb138373b783124e4dd636ac1e6ae095f80b&#10;,ssignature:ciWZ6008yEyDVzlIq2XGWH1aa5eN+8+7/ZTIvqe2bxtNGIzymtp8HmouW+I/mphs7TDbocjYetQBd6uz/M7ED/F/FVxHu3WwBbO2vMU3taklvi6lhCeKRs82hI9EVDQ1MZFgUoKvxp2Cfbpm97k9uzILk7bnmuTMe3uKsQi8ll8GLEuBKwcaBeXua4E3XacxdvKCgeuyN1VrYRijLW7tSv9B/cXEMeAnzSiNRg4Ag4r7lS2EHO77ZAuoDQVIpCX5PHR11EwZwwSX3yy9EKMTfkcPB9tmHT4E9qL3WzsCtLXthaV9wUwWi7oOUeBgAATJGZ28uEwButPD697aoGlvWg==,sdocumentreference:FEV10,rtaxxadocument:329997464,sref:FEV10,irefindex:10},sdebug:Taxxa: 0.351s DIAN: 1.327s (creación 0.744s, revalidación 0.583s baja 0s)}',1196,'7'),