Untitled
json
2 months ago
9.1 kB
1
Indexable
Never
{ "id": 5780775, "company_id": 1183, "company_name": "SunRent", "subsidiary_name": "Marcelo Mesquita Rochebois Campello", "uc_number": "412154909", "company_group_type": "7", "rent_type": 1, "share_perc": 0.0367, "invoice_start_date": "2023-05-19 00:00:00", "invoice_end_date": "2023-06-20 00:00:00", "datetime_read": "2023-06-01 00:00:00", "economy_contract_perc": 0.15, "rent_value_fixed_rs": 0.0, "billing_total_rs": 248.35, "energy_hp_next_cycle_balance_kwh": null, "energy_fp_next_cycle_balance_kwh": null, "energy_hr_next_cycle_balance_kwh": -0.0, "energy_hp_credit_used_kwh": 0.0, "energy_fp_credit_used_kwh": 0.0, "energy_hr_credit_used_kwh": 0.0, "demand_hp_inductive_whitout_icms_kwh": 0.0, "demand_fp_inductive_whitout_icms_kwh": 0.0, "demand_fp_inductive_whitout_icms_rs": 0.0, "demand_hr_inductive_whitout_icms_kwh": 0.0, "energy_consumption_fp_tusd_kwh": 190.0, "energy_consumption_fp_te_kwh": 190.0, "energy_consumption_hp_tusd_kwh": 0.0, "energy_consumption_hp_te_kwh": 0.0, "energy_consumption_hr_tusd_kwh": 0.0, "energy_consumption_hr_te_kwh": 0.0, "energy_injected_fp_te_kwh": 190.84, "energy_injected_hp_te_kwh": 0.0, "energy_injected_hr_te_kwh": 0.0, "energy_compensated_invoice_fp_kwh": 190.0, "energy_compensated_invoice_hp_kwh": 0.0, "energy_compensated_invoice_hr_kwh": 0.0, "tariff_energy_consumption_hp_te": 0.0, "tariff_energy_consumption_hp_tusd": 0.0, "tariff_energy_consumption_fp_te": 0.45392, "tariff_energy_consumption_fp_tusd": 0.55935, "tariff_energy_consumption_hr_te": 0.0, "tariff_energy_consumption_hr_tusd": 0.0, "tariff_energy_injected_fp_ouc_mpt_te": 0.45392, "tariff_energy_injected_fp_ouc_mpt_tusd": 0.44748, "tariff_energy_injected_fp_ouc_opt_te": 0.0, "tariff_energy_injected_fp_ouc_opt_tusd": 0.0, "tariff_energy_injected_fp_muc_mpt_te": 0.0, "tariff_energy_injected_fp_muc_mpt_tusd": 0.0, "tariff_energy_injected_fp_muc_opt_te": 0.0, "tariff_energy_injected_fp_muc_opt_tusd": 0.0, "tariff_energy_injected_hp_ouc_mpt_te": 0.0, "tariff_energy_injected_hp_ouc_mpt_tusd": 0.0, "tariff_energy_injected_hp_ouc_opt_te": 0.0, "tariff_energy_injected_hp_ouc_opt_tusd": 0.0, "tariff_energy_injected_hp_muc_mpt_te": 0.0, "tariff_energy_injected_hp_muc_mpt_tusd": 0.0, "tariff_energy_injected_hp_muc_opt_te": 0.0, "tariff_energy_injected_hp_muc_opt_tusd": 0.0, "tariff_energy_injected_hr_ouc_mpt_te": 0.0, "tariff_energy_injected_hr_ouc_mpt_tusd": 0.0, "tariff_energy_injected_hr_ouc_opt_te": 0.0, "tariff_energy_injected_hr_ouc_opt_tusd": 0.0, "tariff_energy_injected_hr_muc_mpt_te": 0.0, "tariff_energy_injected_hr_muc_mpt_tusd": 0.0, "tariff_energy_injected_hr_muc_opt_te": 0.0, "tariff_energy_injected_hr_muc_opt_tusd": 0.0, "tariff_flag_green_hp": 0.0, "tariff_flag_yellow_hp": 0.0, "tariff_flag_red_hp": 0.0, "tariff_flag_green_fp": 0.0, "tariff_flag_yellow_fp": 0.0, "tariff_flag_red_fp": 0.0, "tariff_flag_green_hr": 0.0, "tariff_flag_yellow_hr": 0.0, "tariff_flag_red_hr": 0.0, "tariff_flag_compensated_green_hp": 0.0, "tariff_flag_compensated_yellow_hp": 0.0, "tariff_flag_compensated_red_hp": 0.0, "tariff_flag_compensated_green_fp": 0.0, "tariff_flag_compensated_yellow_fp": 0.0, "tariff_flag_compensated_red_fp": 0.0, "demand_with_taxes_rs": 0.0, "demand_complementary_rs": 0.0, "energy_consumption_tusd_rs": 106.2765, "energy_consumption_te_rs": 86.2448, "energy_injected_fp_ouc_mpt_te_rs": 86.2448, "energy_injected_fp_ouc_mpt_tusd_rs": 85.0212, "energy_injected_fp_ouc_opt_te_rs": 0.0, "energy_injected_fp_ouc_opt_tusd_rs": 0.0, "energy_injected_fp_muc_mpt_te_rs": 0.0, "energy_injected_fp_muc_mpt_tusd_rs": 0.0, "energy_injected_fp_muc_opt_te_rs": 0.0, "energy_injected_fp_muc_opt_tusd_rs": 0.0, "energy_injected_hp_ouc_mpt_te_rs": 0.0, "energy_injected_hp_ouc_mpt_tusd_rs": 0.0, "energy_injected_hp_ouc_opt_te_rs": 0.0, "energy_injected_hp_ouc_opt_tusd_rs": 0.0, "energy_injected_hp_muc_mpt_te_rs": 0.0, "energy_injected_hp_muc_mpt_tusd_rs": 0.0, "energy_injected_hp_muc_opt_te_rs": 0.0, "energy_injected_hp_muc_opt_tusd_rs": 0.0, "energy_injected_hr_ouc_mpt_te_rs": 0.0, "energy_injected_hr_ouc_mpt_tusd_rs": 0.0, "energy_injected_hr_ouc_opt_te_rs": 0.0, "energy_injected_hr_ouc_opt_tusd_rs": 0.0, "energy_injected_hr_muc_mpt_te_rs": 0.0, "energy_injected_hr_muc_mpt_tusd_rs": 0.0, "energy_injected_hr_muc_opt_te_rs": 0.0, "energy_injected_hr_muc_opt_tusd_rs": 0.0, "flag_green_invoice_rs": 0.0, "flag_yellow_invoice_rs": 0.0, "flag_red_invoice_rs": 0.0, "flag_total_with_taxes_rs": 0.0, "flag_green_compensated_rs": 0.0, "flag_yellow_compensated_rs": 0.0, "flag_red_compensated_rs": 0.0, "flag_total_compensated_rs": 0.0, "ufer_rs": 0.0, "ufdr_rs": 0.0, "charge_cip": 0.0, "charge_fines_and_interest": 0.0, "charge_tax_distribution": 0.0, "discount_exemption_demand_reversal_injunction_icms": 0.0, "discount_exemption_tusd_reversal_injunction_icms": 0.0, "discount_reduction_invoice_icms": 0.0, "discount_fic_dic_dmic": 0.0, "discount_energy_hp": 0.0, "discount_demand": 0.0, "discount_energy_hp_tusd_resolution_77": 0.0, "discount_demand_tusd_resolution_77": 0.0, "discount_injunction_icms": 0.0, "discount_rural": 0.0, "discount_night_irrigant": 0.0, "discount_charge_others": 17.99, "credits_next_invoice": 0.0, "credits_scheduled_shutdown": 0.0, "discount_ecoenel": 0.0, "icms_perc": 0.22, "icms_rural_perc": 0.0, "icms_irrigant_perc": 0.0, "pis_pasep_perc": 0.0106, "cofins_perc": 0.049, "energy_hp_balance_kwh": null, "energy_fp_balance_kwh": null, "energy_hr_balance_kwh": 0.0, "energy_compensated_invoice_hp_rs": 0.0, "energy_compensated_invoice_fp_rs": 171.266, "energy_compensated_invoice_hr_rs": 0.0, "energy_compensated_rs": 171.266, "energy_compensated_calculated_fp_kwh": null, "energy_compensated_calculated_hp_kwh": null, "energy_compensated_calculated_hr_kwh": 0.0, "energy_uncompensated_hp_kwh": 0.0, "energy_uncompensated_fp_kwh": 0.0, "energy_uncompensated_hr_kwh": 0.0, "demand_rs": 0.0, "energy_compensated_calculated_hp_rs": 0.0, "energy_compensated_calculated_fp_rs": 0.0, "energy_compensated_calculated_hr_rs": 0.0, "flag_green_uncompensated_rs": 0.0, "flag_yellow_uncompensated_rs": 0.0, "flag_red_uncompensated_rs": 0.0, "ufer_with_taxes_rs": 0.0, "ufdr_with_taxes_rs": 0.0, "flag_green_calculated_rs": 0.0, "flag_yellow_calculated_rs": 0.0, "flag_red_calculated_rs": 0.0, "tusd_calculated_icms_rs": 316.2493, "discounts_and_charges_total": 0.0, "captive_cost_rs": 171.266, "eventual_consumption_charge_rs": 0.0, "rent_rs": 145.5761, "economy_real_rs": 25.6899, "uuid": "1183_2023-06-01 00:00:00", "energy_hp_next_cycle_balance_invoice_kwh": 0.0, "energy_fp_next_cycle_balance_invoice_kwh": 0.0, "energy_hr_next_cycle_balance_invoice_kwh": 0.0, "energy_consumption_fp_kwh": 189.0, "icms_perc_tusd": 0.2, "icms_perc_te": 0.2, "share_perc_invoice": 0.0, "tariff_energy_consumption_fp": 1.10512, "tariff_energy_consumption_hp": 0.0, "invoice_barcode_number_line": "836900000024483500531072423554047112101332529375"