General Extraction

auth_user_histories

Column	Type	Description
auth_user_history_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
user_id	int64	User; references users.id.
role_name	string	Role name.
created_at_date_only	date	Calendar date (date-only) derived from creation time for daily-grain analytics.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

business_groups

Column	Type	Description
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
name	string	Name.
status	string	Status.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

checklist_executions

Column	Type	Description
checklist_execution_id	int64	Primary key of this exported row (same as the source model id).
checklist_id	int64	Identifier for checklist; references the related entity id.
executable_id	int64	Identifier for executable; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
executable_type	string	Executable type.
status	string	Status.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

checklists

Column	Type	Description
checklist_id	int64	Primary key of this exported row (same as the source model id).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
active	string	Active.
name	string	Name.
resource_type	string	Resource type.
status	string	Status.
version	int32	Integer measure or counter: version.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

cities

Column	Type	Description
city_id	int64	Primary key of this exported row (same as the source model id).
city_name	string	City name.
country_name	string	Country name.
region_code	string	Region code (IBGE or internal).
region_label_es	string	Region label in Spanish.
region_label_pt_br	string	Region label in Brazilian Portuguese (pt-BR).
state_name	string	State name.
uf_name	string	Brazilian state name or UF-related label.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

collaborators

Column	Type	Description
collaborator_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
original_resource_id	int64	Identifier for original resource; references the related entity id.
referenced_company_id	int64	Identifier for referenced company; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
active	string	Active.
activity_name	string	Activity name.
name	string	Name.
origin_type	string	Origin type.
related_resource_name	string	Related resource name.
shared_with_tenancy_ids	string	Comma-separated list of tenancy ids the record is shared with.
admission_at	dateTime	Timestamp for hire date.
inactivated_at	dateTime	Timestamp for inactive since.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

collect_task_items

Column	Type	Description
collect_task_item_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
collect_task_id	int64	Identifier for collection task; references the related entity id.
storage_waste_packing_id	int64	Identifier for storage waste packing; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_id	int64	Identifier for waste; references the related entity id.
waste_packing_id	int64	Identifier for waste packing; references the related entity id.
execution_mode	string	Execution mode.
justification_type	string	Justification type.
state_justification_type	string	State justification type.
task_service_name	string	Task service name.
un_quantity	string	Unit quantity.
observation	string	Observation.
state_observation	string	State observation.
packing_quantity	double	Numeric value: packing quantity.
quantity	double	Numeric value: quantity.
solicitation_packing_quantity	double	Numeric value: request packing quantity.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

collect_task_states

Column	Type	Description
collect_task_state_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
collect_task_id	int64	Identifier for collection task; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_generation_point_id	int64	Identifier for waste generation point; references the related entity id.
justification_type	string	Justification type.
shift_name	string	Shift name.
state	string	State.
observation	string	Observation.
is_current_state	boolean	Boolean flag: is current state.
shift_reference_date	date	Calendar date for shift reference.
created_at	dateTime	Creation timestamp on the source record.
executed_at	dateTime	Timestamp for executed.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

collect_tasks

Column	Type	Description
collect_task_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
collect_task_group_id	int64	Identifier for collection task group; references the related entity id.
driver_collaborator_id	int64	Identifier for driver collaborator; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
vehicle_id	int64	Identifier for vehicle; references the related entity id.
waste_disposal_id	int64	Identifier for waste disposal; references the related entity id.
waste_generation_point_group_id	int64	Identifier for waste generation point group; references the related entity id.
waste_generation_point_id	int64	Identifier for waste generation point; references the related entity id.
current_state	string	Current state.
generation_mode	string	Generation mode.
recurrence_type	string	Recurrence type.
shift_name	string	Shift name.
transport_route_name	string	Transport route name.
recurrence_description	string	Recurrence description.
is_urgent	boolean	Boolean flag: is urgent.
shift_reference_date	date	Calendar date for shift reference.
created_at	dateTime	Creation timestamp on the source record.
current_executed_at	dateTime	Timestamp for current executed.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

companies

Column	Type	Description
company_id	int64	Company; references companies.id.
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
main_tenancy_id	int64	Identifier for main tenant; references the related entity id.
active	string	Active.
address_number	string	Address number.
alias_name	string	Trade name name.
city	string	City.
code_erp	string	Code as synchronized from ERP.
complete_name	string	Full name.
country	string	Country.
cpf_cnpj	string	Brazilian company or person tax id (CPF/CNPJ) as stored or formatted in the export.
district	string	District.
facility_type	string	Facility type.
formatted_cpf_cnpj	string	Display-formatted CPF/CNPJ.
lat	string	Geographic latitude.
lng	string	Geographic longitude.
state	string	State.
street	string	Street.
zip_code	string	Postal (ZIP) code.
managed_wastes_ids	string	Managed wastes ids.
service_types_ids	string	Comma-separated service type ids.
waste_groups_ids	string	Comma-separated waste group ids.
waste_treatments_ids	string	Comma-separated waste treatment ids.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

construction_progress_stages

Column	Type	Description
construction_progress_stage_id	int64	Primary key of this exported row (same as the source model id).
construction_progress_id	int64	Identifier for construction progress; references the related entity id.
construction_stage_id	int64	Identifier for construction stage; references the related entity id.
month	string	Month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

construction_stage_by_resources

Column	Type	Description
construction_stage_by_resource_id	int64	Primary key of this exported row (same as the source model id).
construction_stage_id	int64	Identifier for construction stage; references the related entity id.
resource_id	int64	Identifier for resource; references the related entity id.
resource_type	string	Resource type.
stage_description	string	Stage description.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

construction_stages

Column	Type	Description
construction_stage_id	int64	Primary key of this exported row (same as the source model id).
company_id	int64	Company; references companies.id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
description	string	Description.
is_standart	boolean	Boolean flag: is standart.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

environmental_goal_details

Column	Type	Description
environmental_goal_detail_id	int64	Primary key of this exported row (same as the source model id).
environmental_goal_id	int64	Identifier for environmental goal; references the related entity id.
month	string	Month.
year	string	Year.
goal_value	double	Numeric value: goal value.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

environmental_goals

Column	Type	Description
environmental_goal_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
goal_category_type	string	Goal category type.
goal_objective_type	string	Goal objective type.
goal_resource_type	string	Goal resource type.
goal_unit	string	Goal unit.
goal_description	string	Goal description.
goal_resource_ids	string	Goal resource ids.
co2_reduction	double	Numeric value: CO₂ reduction.
co2_scope_1_value	double	Numeric value: CO₂ scope 1 value.
co2_scope_2_value	double	Numeric value: CO₂ scope 2 value.
co2_scope_3_value	double	Numeric value: CO₂ scope 3 value.
co2_total_value	double	Numeric value: CO₂ total value.
goal_value	double	Numeric value: goal value.
goal_year_value	double	Numeric value: goal year value.
yearly_co2	double	Numeric value: yearly CO₂.
yearly_increase_value	double	Numeric value: yearly increase value.
is_percent	boolean	Boolean flag: is percent.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

financial_movements

Column	Type	Description
financial_movement_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
partner_id	int64	Identifier for partner; references the related entity id.
product_id	int64	Identifier for product; references the related entity id.
service_type_id	int64	Identifier for service type; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_movement_id	int64	Identifier for waste movement; references the related entity id.
activity_type	string	Activity type.
billing_way	string	Billing method.
operation	string	Operation.
product_type	string	Product type.
status	string	Status.
observation	string	Observation.
unitary_value	double	Numeric value: unit value.
value	double	Numeric value: value.
is_manual	boolean	Boolean flag: is manual.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
emitted_date	dateTime	Timestamp for issued.
execution_date	dateTime	Timestamp for execution.
movement_date	dateTime	Timestamp for movement.
received_date	dateTime	Timestamp for received.
updated_at	dateTime	Last update timestamp on the source record.

fuels

Column	Type	Description
fuel_id	int64	Primary key of this exported row (same as the source model id).
UN	string	Unit of measure abbreviation (e.g. packaging unit).
description	string	Description.
density	double	Numeric value: density.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

incident_reports

Column	Type	Description
incident_report_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
process_id	int64	Identifier for process; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
department_name	string	Department name.
registered_by	string	Display name of the user who registered the record.
registration_source	string	Registration source.
responsible	string	Responsible.
shift	string	Shift.
status	string	Status.
who_registered	string	Name of the person who registered the record.
action_description	string	Action description.
complement	string	Notes.
description	string	Description.
improvement_suggestion	string	Improvement suggestion.
critical	boolean	Boolean flag: critical.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
expected_finish_at	dateTime	Timestamp for expected finish.
finished_at	dateTime	Timestamp for finished.
register_at	dateTime	Timestamp for registration.
updated_at	dateTime	Last update timestamp on the source record.

inventory_movements

Column	Type	Description
inventory_movement_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
process_id	int64	Identifier for process; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_generation_point_id	int64	Identifier for waste generation point; references the related entity id.
waste_group_id	int64	Identifier for waste group; references the related entity id.
waste_id	int64	Identifier for waste; references the related entity id.
accumulate_packing_name	string	Accumulated packing name.
accumulate_packing_unit_measure	string	Accumulated packing unit measure.
department	string	Department.
environmental_economic_category	string	Environmental economic category.
full_hour_interval	string	Full hour interval.
half_hour_interval	string	Half hour interval.
ibama_agency_code	string	IBAMA agency code.
inform_environment_alert_state	string	Inform environment alert state.
inventory_type	string	Inventory type.
model_code	string	Model code.
movement_time	string	Movement time.
packing_name	string	Packing name.
packing_unit_measure	string	Packing unit measure.
physical_state	string	Physical state.
process	string	Process.
quantity_input_method	string	Quantity input method.
reference_month	string	Reference month.
shift	string	Shift.
status	string	Status.
translated_shift	string	Translated shift.
unit_measure	string	Unit measure.
waste	string	Waste.
waste_class	string	Waste class.
waste_group	string	Waste group.
environmental_alert_observation	string	Environmental alert observation.
inventory_observation	string	Inventory observation.
movement_link	string	Movement link.
accumulate_packing_capacity	double	Numeric value: accumulated packing capacity.
capacity_usage	double	Numeric value: capacity usage.
kg_quantity	double	Numeric value: kg quantity.
packing_capacity	double	Numeric value: packing capacity.
quantity	double	Numeric value: quantity.
imported_from_government	boolean	Boolean flag: imported from government.
movement_date_only	date	Movement date only.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
movement_date	dateTime	Timestamp for movement.
updated_at	dateTime	Last update timestamp on the source record.

invoice_items

Column	Type	Description
invoice_item_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
company_id	int64	Company; references companies.id.
invoice_id	int64	Identifier for invoice; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
invoice_status	string	Invoice status.
item_code	string	Item code.
item_name	string	Item name.
ncm_code	string	Ncm code.
unit_measure	string	Unit measure.
quantity	double	Numeric value: quantity.
unit_gross_weight	double	Numeric value: unit gross weight.
unit_net_weight	double	Numeric value: unit net weight.
value	double	Numeric value: value.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
invoice_issue_date	dateTime	Timestamp for invoice issue.
updated_at	dateTime	Last update timestamp on the source record.

invoices

Column	Type	Description
invoice_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
company_id	int64	Company; references companies.id.
seller_company_id	int64	Identifier for seller company; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
transporter_company_id	int64	Identifier for transporter company; references the related entity id.
danfe_number	string	Brazilian electronic invoice (NF-e / DANFE) access key or number.
invoice_number	string	Invoice number.
national_registry_number	string	National registry number.
reverse_danfe_number	string	Reversed or lookup variant of DANFE / NF-e number.
reverse_invoice_number	string	Reverse invoice number.
seller_national_registry_number	string	Seller national registry number.
status	string	Status.
transporter_national_registry_number	string	Transporter national registry number.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
event_date	dateTime	Timestamp for event.
issue_date	dateTime	Timestamp for issue.
updated_at	dateTime	Last update timestamp on the source record.

monthly_construction_collaborators

Column	Type	Description
monthly_construction_collaborator_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
month	string	Month.
year	string	Year.
description	string	Description.
month_number	int64	Integer measure or counter: month number.
value	double	Numeric value: value.
end_of_month_date	date	Calendar date for end of month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_construction_progress

Column	Type	Description
monthly_construction_progress_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
formatted_partner_cnpj	string	Formatted partner CNPJ.
measure_mode	string	Measure mode.
month	string	Month.
partner_name	string	Partner name.
year	string	Year.
description	string	Description.
building_area	double	Numeric value: building area.
building_time	double	Numeric value: building time.
month_number	int64	Integer measure or counter: month number.
value	double	Numeric value: value.
value_m2	double	Numeric value: value m².
end_of_month_date	date	Calendar date for end of month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_effluent_consumptions

Column	Type	Description
monthly_effluent_consumption_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
month	string	Month.
year	string	Year.
description	string	Description.
month_number	int64	Integer measure or counter: month number.
value	double	Numeric value: value.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_energy_consumptions

Column	Type	Description
monthly_energy_consumption_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
description	string	Description.
value	double	Numeric value: value.
end_of_month_date	date	Calendar date for end of month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_feedstock

Column	Type	Description
monthly_feedstock_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
month	string	Month.
un	string	Unit of measure abbreviation.
year	string	Year.
description	string	Description.
month_number	int64	Integer measure or counter: month number.
value	double	Numeric value: value.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_fuel_consumptions

Column	Type	Description
monthly_fuel_consumption_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
fuel_name	string	Fuel name.
un	string	Unit of measure abbreviation.
description	string	Description.
fuel_consumption_m3	double	Numeric value: fuel consumption m³.
value	double	Numeric value: value.
end_of_month_date	date	Calendar date for end of month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_production

Column	Type	Description
monthly_production_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
month	string	Month.
un	string	Unit of measure abbreviation.
year	string	Year.
description	string	Description.
month_number	int64	Integer measure or counter: month number.
value	double	Numeric value: value.
end_of_month_date	date	Calendar date for end of month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

monthly_water_consumptions

Column	Type	Description
monthly_water_consumption_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
enterprise_tenancy_id	int64	Identifier for site tenant; references the related entity id.
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
description	string	Description.
value	double	Numeric value: value.
end_of_month_date	date	Calendar date for end of month.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

packings

Column	Type	Description
packing_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
name	string	Name.
packing_type_name	string	Packing type name.
unit_measure	string	Unit measure.
capacity	double	Numeric value: capacity.
tare_weight	double	Numeric value: tare weight.
unit_weight	double	Numeric value: unit weight.
is_unitary	boolean	Boolean flag: is unit.
is_waste_accumulation_central	boolean	Boolean flag: is waste accumulation central.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

partner_auditorships

Column	Type	Description
partner_auditorship_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
auditorship_status	string	Audit status.
auditorship_time_status	string	Audit time status.
auditorship_type	string	Audit type.
rating_type	string	Rating type.
recurrence_type	string	Recurrence type.
auditorship_users	string	Audit users.
shared_with_tenancy_ids	string	Comma-separated list of tenancy ids the record is shared with.
rating_value	double	Numeric value: rating value.
cancellation_date	dateTime	Timestamp for cancellation.
conclusion_date	dateTime	Timestamp for conclusion.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
prevision_date	dateTime	Timestamp for prevision.
updated_at	dateTime	Last update timestamp on the source record.

partner_homologation_history

Column	Type	Description
partner_homologation_history_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
partner_id	int64	Identifier for partner; references the related entity id.
homologation_situation	string	Approval situation.
changed_date_at	date	Calendar date for changed date.
changed_at	dateTime	Timestamp for changed.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

partners

Column	Type	Description
partner_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
city_id	int64	Identifier for city; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
active	string	Active.
address_number	string	Address number.
city	string	City.
country	string	Country.
cpf_cnpj	string	Brazilian company or person tax id (CPF/CNPJ) as stored or formatted in the export.
district	string	District.
formatted_cpf_cnpj	string	Display-formatted CPF/CNPJ.
lat	string	Geographic latitude.
lng	string	Geographic longitude.
name	string	Name.
partner_homologation_type	string	Partner approval type.
partner_situation	string	Partner situation.
partner_type	string	Partner type.
state	string	State.
street	string	Street.
zip_code	string	Postal (ZIP) code.
contract_ids	string	Comma-separated contract ids.
managed_wastes	string	Managed wastes.
related_tenancy_ids	string	Comma-separated related tenancy ids.
related_tenancy_names	string	Comma-separated related tenancy names.
service_types	string	Service types.
waste_groups	string	Waste groups.
waste_treatments	string	Waste treatments.
elo_construction_building_area	double	Eloverde construction module: building area metric.
elo_construction_building_time	double	Eloverde construction module: building time metric.
elo_construction_generation_goal	double	Eloverde construction module: generation goal.
elo_construction_segregation_quality_goal	double	Eloverde construction module: segregation quality goal.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
situation_date	dateTime	Timestamp for situation.
updated_at	dateTime	Last update timestamp on the source record.

powerbi_reports

Column	Type	Description
powerbi_report_id	int64	Primary key of this exported row (same as the source model id).
report_id	string	Identifier for report; references the related entity id.
report_name	string	Report name.
workspace_id	string	Workspace id.
workspace_name	string	Workspace display name.
report_row_levels	string	Power BI or report row hierarchy levels (serialized).
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

powerbi_widgets

Column	Type	Description
powerbi_widget_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
company_id	int64	Company; references companies.id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
user_id	int64	User; references users.id.
widget_id	int64	Dashboard widget id.
is_widget_active	string	Is widget active.
powerbi_report_id	string	Identifier for Power BI report; references the related entity id.
view_name	string	Power BI or analytics view name.
widget_name	string	Dashboard widget display name.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

processes

Column	Type	Description
process_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
department_name	string	Department name.
name	string	Name.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

programming_logistic_day_details

Column	Type	Description
programming_logistic_day_detail_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
programming_logistic_main_detail_id	int64	Identifier for scheduling logistics main detail; references the related entity id.
adjustment_quantity	decimal	Adjustment quantity.
factory_plan_quantity	decimal	Factory plan quantity.
in_progress_quantity	decimal	In progress quantity.
market_quantity	decimal	Market quantity.
pre_planning_quantity	decimal	Pre planning quantity.
received_quantity	double	Numeric value: received quantity.
adjustment_opened_at	dateTime	Timestamp for adjustment opened.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
done_closed_at	dateTime	Timestamp for done closed.
factory_plan_opened_at	dateTime	Timestamp for factory plan opened.
in_progress_opened_at	dateTime	Timestamp for in progress opened.
market_opened_at	dateTime	Timestamp for market opened.
pre_planning_opened_at	dateTime	Timestamp for pre planning opened.
updated_at	dateTime	Last update timestamp on the source record.
week_date	dateTime	Timestamp for week.

programming_logistic_main_details

Column	Type	Description
programming_logistic_main_detail_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
partner_id	int64	Identifier for partner; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_id	int64	Identifier for waste; references the related entity id.
current_status_value	string	Current status value.
justification_active	string	Justification active.
partner_code_erp	string	Partner code ERP.
partner_interaction	string	Partner interaction.
purchase_order_number	string	Purchase order number.
transport_type	string	Transport type.
waste_code_erp	string	Waste code in the ERP integration.
purchase_order_balance	double	Numeric value: purchase order balance.
real_gcall	double	Numeric value: real gcall.
week_number	int32	Integer measure or counter: week number.
is_active	boolean	Boolean flag: is active.
current_status_updated_at	dateTime	Timestamp for current status updated.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
purchase_order_validity	dateTime	Purchase order validity.
updated_at	dateTime	Last update timestamp on the source record.
week_end_date	dateTime	Timestamp for week end.
week_start_date	dateTime	Timestamp for week start.

programming_logistic_transporter_details

Column	Type	Description
programming_logistic_transporter_detail_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
partner_transporter_id	int64	Identifier for partner transporter; references the related entity id.
programming_logistic_main_detail_id	int64	Identifier for scheduling logistics main detail; references the related entity id.
percentage	decimal	Percentage.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

programming_logistic_waste_details

Column	Type	Description
programming_logistic_waste_detail_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_id	int64	Identifier for waste; references the related entity id.
programming_logistic_day_detail_ids	string	Scheduling logistics day detail ids.
programming_logistic_main_detail_ids	string	Scheduling logistics main detail ids.
last_state_quantity	double	Numeric value: last state quantity.
quantity	double	Numeric value: quantity.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
programming_date	dateTime	Timestamp for scheduling.
updated_at	dateTime	Last update timestamp on the source record.

resource_action_plan_items

Column	Type	Description
resource_action_plan_item_id	int64	Primary key of this exported row (same as the source model id).
plan_id	int64	Identifier for plan; references the related entity id.
status	string	Status.
cancellation_justification	string	Cancellation justification.
custom_tag_ids	string	Comma-separated custom tag ids attached to the record.
description	string	Description.
conclusion_date	dateTime	Timestamp for conclusion.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
until_when	dateTime	Until when.
updated_at	dateTime	Last update timestamp on the source record.

resource_action_plans

Column	Type	Description
resource_action_plan_id	int64	Primary key of this exported row (same as the source model id).
audit_id	int64	Identifier for audit; references the related entity id.
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
entity_id	int64	Identifier for entity; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
action_situation	string	Action situation.
entity_type	string	Entity type.
objective	string	Objective.
responsibles	string	Responsibles.
shared_with_tenancy_ids	string	Comma-separated list of tenancy ids the record is shared with.
what	string	Free-text “what” field (incident / checklist narrative).
when	string	Free-text “when” field.
where	string	Free-text “where” field.
why	string	Free-text “why” field.
auditor	int32	Auditor.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
until_when	dateTime	Until when.
updated_at	dateTime	Last update timestamp on the source record.

resource_active_histories

Column	Type	Description
resource_active_history_id	int64	Primary key of this exported row (same as the source model id).
resource_id	int64	Identifier for resource; references the related entity id.
changed_at	string	Timestamp for changed.
resource_type	string	Resource type.
status	string	Status.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

resource_attachment_images

Column	Type	Description
resource_attachment_image_id	int64	Primary key of this exported row (same as the source model id).
resource_id	int64	Identifier for resource; references the related entity id.
file_name	string	File name.
resource_type	string	Resource type.
image_url	string	Image url.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

restrict_resources_by_tenancy

Column	Type	Description
restrict_resources_by_tenancy_id	int64	Primary key of this exported row (same as the source model id).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
resource_type	string	Resource type.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

service_types

Column	Type	Description
service_type_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
activity	string	Activity.
name	string	Name.
is_treatment	boolean	Boolean flag: is treatment.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

tenancies

Column	Type	Description
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
city_id	int64	Identifier for city; references the related entity id.
company_id	int64	Company; references companies.id.
active	string	Active.
city	string	City.
code_erp	string	Code as synchronized from ERP.
company_alias_name	string	Company trade name name.
company_name	string	Company name.
country	string	Country.
cpf_cnpj	string	Brazilian company or person tax id (CPF/CNPJ) as stored or formatted in the export.
facility_type	string	Facility type.
formatted_cpf_cnpj	string	Display-formatted CPF/CNPJ.
state	string	State.
system_module	string	System module.
tenancy_name	string	Tenant name.
breadcrumb	string	Hierarchical breadcrumb string for UI or reporting.
managed_wastes	string	Managed wastes.
service_types	string	Service types.
waste_groups	string	Waste groups.
waste_treatments	string	Waste treatments.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

tenancy_hierarchies

Column	Type	Description
tenancy_hierarchy_id	string	Primary key of this exported row (same as the source model id).
parent_id	int64	Identifier for parent; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

translation_decoders

Column	Type	Description
translation_decoder_id	int64	Primary key of this exported row (same as the source model id).
translatable_id	int64	Identifier for translatable; references the related entity id.
language	string	Language.
translatable_type	string	Translatable type.
translation_key	string	Translation key in the application i18n system.
translation	string	Translated or raw translation string (see DTO).
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

user_tenancies

Column	Type	Description
user_tenancy_id	string	Primary key of this exported row (same as the source model id).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
user_id	int64	User; references users.id.
role	string	Role.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

users

Column	Type	Description
user_id	int64	User; references users.id.
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
active	string	Active.
email	string	Email.
link_business_group_logo	string	Link business group logo.
login	string	Login.
name	string	Name.
sector	string	Sector.
user_type	string	User type.
username	string	Username.
job_description	string	Job description.
token	string	API or session token string when exported (sensitive; handle with care).
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
last_request_at	dateTime	Timestamp for last request.
updated_at	dateTime	Last update timestamp on the source record.

vehicles

Column	Type	Description
vehicle_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
driver_collaborator_id	int64	Identifier for driver collaborator; references the related entity id.
referenced_company_id	int64	Identifier for referenced company; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
active	string	Active.
plate	string	Plate.
description	string	Description.
capacity	double	Numeric value: capacity.
tare_weight	double	Numeric value: tare weight.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_blend_batch_composition_items

Column	Type	Description
waste_blend_batch_composition_item_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
document_id	int64	Identifier for document; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_disposal_id	int64	Identifier for waste disposal; references the related entity id.
waste_environmental_license_id	int64	Identifier for waste environmental license; references the related entity id.
batch_code	string	Batch code.
environmental_license_code	string	Environmental license code.
environmental_license_protocol	string	Environmental license protocol.
ibama_agency_code	string	IBAMA agency code.
waste_ids	string	Comma-separated waste catalog ids.
current_balance	double	Numeric value: current balance.
current_stock	double	Numeric value: current stock.
start_balance	double	Numeric value: start balance.
tone_quantity	double	Numeric value: ton quantity.
usage_percentage	double	Numeric value: usage percentage.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_environmental_license_items

Column	Type	Description
waste_environmental_license_item_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
document_id	int64	Identifier for document; references the related entity id.
generator_company_id	int64	Identifier for generator company; references the related entity id.
recycler_company_id	int64	Identifier for recycler company; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
code	string	Code.
protocol_number	string	Protocol number.
type	string	Type.
ibama_agency_codes	string	IBAMA agency codes.
waste_ids	string	Comma-separated waste catalog ids.
waste_movement_ids	string	Comma-separated waste movement ids (when exported as a list).
current_balance	double	Numeric value: current balance.
current_license_balance	double	Numeric value: current license balance.
start_balance	double	Numeric value: start balance.
start_license_balance	double	Numeric value: start license balance.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_generation_points

Column	Type	Description
waste_generation_point_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
company_generator_id	int64	Identifier for company generator; references the related entity id.
tenancy_generator_id	int64	Identifier for tenant generator; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
department_name	string	Department name.
internal_code	string	Internal code.
name	string	Name.
point_code	string	Point code.
type	string	Type.
observation	string	Observation.
point_active	boolean	Boolean flag: point active.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_groups

Column	Type	Description
waste_group_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
name	string	Name.
translation_key	string	Translation key in the application i18n system.
type	string	Type.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_movement_declaration_items

Column	Type	Description
waste_movement_declaration_item_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
declarant_company_id	int64	Identifier for declarant company; references the related entity id.
generator_company_id	int64	Identifier for generator company; references the related entity id.
recycler_company_id	int64	Identifier for recycler company; references the related entity id.
service_type_id	int64	Identifier for service type; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
treatment_type_id	int64	Identifier for treatment type; references the related entity id.
agency	string	Agency.
code	string	Code.
ibama_agency_code	string	IBAMA agency code.
period	string	Period.
period_type	string	Period type.
status	string	Status.
translated_status	string	Translated status.
waste_name	string	Waste name.
disposal_kg_quantity	double	Numeric value: disposal kg quantity.
generated_kg_quantity	double	Numeric value: generated kg quantity.
storage_kg_quantity	double	Numeric value: storage kg quantity.
has_items	boolean	Boolean flag: has items.
period_date	date	Calendar date for period.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_movements_environment_economics

Column	Type	Description
waste_movements_environment_economic_id	string	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_movement_id	int64	Identifier for waste movement; references the related entity id.
environment_category	string	Environment category.
environment_group	string	Environment group.
environmental_variable	string	Environmental variable.
language	string	Language.
movement_type	string	Movement type.
un	string	Unit of measure abbreviation.
value	double	Numeric value: value.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_packings

Column	Type	Description
waste_packing_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
name	string	Name.
packing_type	string	Packing type.
type	string	Type.
un	string	Unit of measure abbreviation.
waste_packing_code	string	Waste packing code.
capacity	double	Numeric value: capacity.
tare_weight	double	Numeric value: tare weight.
unit_weight	double	Numeric value: unit weight.
created_at	dateTime	Creation timestamp on the source record.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

waste_treatments

Column	Type	Description
waste_treatment_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
standard_treatment_id	int64	Identifier for standard treatment; references the related entity id.
name	string	Name.
translation_key	string	Translation key in the application i18n system.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

wastes

Column	Type	Description
waste_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
waste_group_id	int64	Identifier for waste group; references the related entity id.
generator_identification	string	Generator identifier.
group_name	string	Group name.
ibama_agency_code	string	IBAMA agency code.
ibama_waste_identifier	string	IBAMA waste identifier.
name	string	Name.
packing_group	string	Packing group.
physical_condition	string	Physical condition.
recycler_identification	string	Recycler identifier.
shipment_name	string	Shipment name.
un	string	Unit of measure abbreviation.
waste_class	string	Waste class.
waste_class_name_es	string	Waste class name Spanish.
waste_class_name_pt	string	Waste class name Portuguese.
waste_hazard_status	string	Waste hazard status.
waste_ibama_identifier	string	Waste IBAMA identifier.
ibama_agency_description	string	IBAMA agency description.
shared_with_tenancy_ids	string	Comma-separated list of tenancy ids the record is shared with.
density	double	Numeric value: density.
destination_cost	double	Numeric value: destination cost.
raw_material_cost	double	Numeric value: raw material cost.
transport_cost	double	Numeric value: transport cost.
unity_weight	double	Numeric value: unit weight.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
updated_at	dateTime	Last update timestamp on the source record.

work_permissions

Column	Type	Description
work_permission_id	int64	Primary key of this exported row (same as the source model id).
business_group_id	int64	Business group; references business_groups.id (customer / account grouping).
executed_by_company_id	int64	Identifier for executed by company; references the related entity id.
tenancy_id	int64	Tenant (organizational unit); references tenancies.id.
executed_by_company_name	string	Executed by company name.
scope	string	Scope.
sector	string	Sector.
status	string	Status.
activities	string	Activities.
collaborators	string	Collaborators.
responsibles	string	Responsibles.
shared_with_tenancy_ids	string	Comma-separated list of tenancy ids the record is shared with.
deleted_at	dateTime	Soft-delete timestamp when the record is marked deleted.
emission	dateTime	Emission.
updated_at	dateTime	Last update timestamp on the source record.
validity	dateTime	Validity.