Waste Disposals Extraction

waste_disposals

Column	Type	Description
waste_disposal_id	int64	waste_movements.id — analytics row id for the movement (not waste_disposals.id).
waste_movement_id	int64	waste_disposals.id — parent disposal header id (waste_movements.waste_disposal_id).
business_group_id	int64	Business group of the movement’s company (company.business_group_id).
company_carrier_id	int64	Company id of the carrier on the waste disposal.
company_generator_id	int64	Company id of the generator on the waste disposal.
company_recycler_id	int64	Company id of the destination / recycler on the waste disposal.
packing_id	int64	Packing id on the movement (0 when absent in source).
process	int64	Process id from the disposal line, or movement process_id if line process is null.
temporary_storage_company_id	int64	Id from transport task temporary_storage_company_id (company or referenced partner).
tenancy_id	int64	Tenant id (tenancies.id) — organizational unit / department scope for the movement.
transport_task_main_detail_id	int64	Linked transport task id (transport_tasks.id) when the disposal has a transport task.
treatment_type	int64	Waste treatment type id on the disposal line (waste_treatments.id).
waste_group	int64	Waste group id on the disposal line.
waste_group_id	int64	Waste group id on the movement (waste_movements.waste_group_id).
waste_id	int64	Waste id on the movement (0 when missing in source).
carrier_cnpj	string	Carrier company tax id (CPF/CNPJ) as stored; '-' when missing.
carrier_invoices	string	Invoice numbers for carrier invoices on the disposal, comma-separated.
carrier_name	string	Carrier trade name (alias_name).
emitted_waste_treatment	string	Treatment at shipment: first treatment change record’s original value, or default treatment name on the disposal line.
environmental_economic_category	string	Environmental–economic category from the waste master data.
formatted_carrier_cnpj	string	Carrier tax id formatted for display.
formatted_generator_cnpj	string	Generator tax id formatted.
formatted_recycler_cnpj	string	Recycler tax id formatted.
formatted_temporary_storage_company_cnpj	string	Temporary storage party tax id formatted.
generator_city	string	Generator city (main partner address).
generator_cnpj	string	Generator tax id as stored.
generator_name	string	Generator trade name.
generator_state	string	Generator state (UF) (main partner address).
order_of_service	string	Service order reference on the disposal.
other_invoices	string	Other invoice numbers on the disposal, comma-separated.
packing_name	string	Packing name.
packing_unity_measure	string	Packing unit abbreviation (typo in column name: “unity” = unit).
received_waste_treatment	string	Treatment at receipt: latest treatment change record’s new value, or default treatment name.
recycler_city	string	Recycler city (main partner address).
recycler_cnpj	string	Recycler tax id as stored.
recycler_invoices	string	Recycler invoice numbers, comma-separated.
recycler_name	string	Recycler trade name.
recycler_state	string	Recycler state (UF).
reference_month	string	Reference month stored on the waste movement.
segregation_quality	string	Human-readable segregation quality on the disposal (Good / Medium / Poor — labels follow DTO locale).
status	string	Raw disposal status enum value from waste_disposals.status.
status_mtrs	string	Disposal status rendered as short label for reporting (text is Portuguese in the current DTO, e.g. in transit, received).
temporary_storage_company_cnpj	string	Temporary storage party tax id (resolved from Company or Partner linked to transport task).
temporary_storage_company_name	string	Name: company complete_name or partner name.
cdfs	string	Final destination certificates (CDF) from MTR integration details, aggregated.
integration_errors	string	Integration error messages from non-ELOVERDE manifests in failed integration status, concatenated.
mtrs	string	MTR codes from integration helper (getMTRDetails / code).
schemas	string	Manifest schema values from MTR details (integration source).
emitted_quantity	double	Shipped quantity in the movement’s unit, converted to kg when the unit is not kg (see getQuantity / unit conversion).
kg_difference_received_emitted	double	kg received − kg shipped; null if either side is null.
kg_emitted_quantity	double	Shipped mass in kg (from disposal line exp_quantity or movement kg_quantity).
kg_received_quantity	double	Received mass in kg (line received_quantity, else fallback to shipped / movement kg).
m3_emitted_quantity	double	Shipped volume in m³ estimated as kg ÷ waste density (defaults to 1000 kg/m³ when density missing or zero).
m3_received_quantity	double	Received volume in m³, same density rule as emitted.
packing_capacity	double	Packing capacity from the packing master.
percentage_difference_received_emitted	double	Relative gap (kg_received ÷ kg_emitted) − 1; 0 when invalid or kg_emitted ≤ 0.
received_quantity	double	Received quantity in the movement’s unit (with kg conversion when needed).
t_difference_received_emitted	double	Metric-ton difference: kg_difference_received_emitted / 1000.
unitary_packing_quantity	double	Units per packing on the disposal–waste line (unitary_packing_quantity).
waste_height	double	Derived ratio movement quantity ÷ generator enterprise building area when area exists; else null.
imported_from_government	boolean	Whether the disposal was imported from a government source.
mtr_expired	boolean	Whether the disposal is flagged as MTR expired.
emitted_date	dateTime	Disposal expedition / shipment date (waste_disposals.exp_date).
issue_date	dateTime	Disposal issue date (issue_date, or exp_date if issue is null).
movement_date	dateTime	Movement timestamp on the waste movement (movemented_at).
received_date	dateTime	Receipt datetime at destination (waste_disposals.received_at).
updated_at	dateTime	Last update of the waste movement.
deleted_at	dateTime	Soft delete of the waste movement row.