iRancho is a Brazilian livestock management software for beef and dairy cattle operations. The connector extracts your herd (animals, weighings, lot and pasture movements, deaths, breeding exposures and handling executions), your farm structure and assets (farms, subdivisions, improvements, machinery and refuelings), animal sales and cattle purchase slips, your finances (accounts, transactions, categories, cost centers and cost allocations), and your inputs, stock and feed (products, stock movements, feed formulas, batches and nutrition). With it you can analyze herd performance, costs and results in your Lakehouse.

Configuring iRancho as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the iRancho option from the list of connectors. Click Next and you’ll be prompted to add your access.

1. Add account access

iRancho authenticates with an integration token. To generate it:

Log in to iRancho with a user of the account.
Open Configurações (settings).
Under Token de integração, click Gerar token and confirm.
Copy the token.

iRancho warns that the integration token gives other systems access to read and change your account’s data. The Nekt connector only reads data. Deleting the token in iRancho (Excluir token) stops the connector from working until a new token is set.

The following configurations are available:

Integration Token: the token generated in iRancho. Required.
Start Date: the earliest date from which dated records are synced: animal movements, deaths, breeding exposures, handling executions, stock movements, financial transactions and cost allocations. Required. Every sync re-reads from this date, because iRancho lets you back-date, edit and delete these records, so an earlier date makes each sync longer. Registers such as animals, farms, products and sales are always synced in full.
Requests Per Minute: how fast the connector may call iRancho. The default is 120.

Once you’re done, click Next.

2. Select streams

Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. You can select entire groups of streams or pick specific ones.

Tip: The stream can be found more easily by typing its name.

Select the streams and click Next.

3. Configure data streams

Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.

Layer: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
Folder: a folder can be created inside the selected layer to group all tables being created from this new data source.
Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix to all tables at once and make this process faster!
Sync Type: every iRancho stream is FULL_TABLE: each sync replaces the table with what iRancho currently holds. Read more about Sync Types here.

Once you are done configuring, click Next.

4. Configure data source

Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can define some additional settings:

Configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource here.

Once you are ready, click Next to finalize the setup.

5. Check your new source

You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.

For you to be able to see it on your Catalog, you need at least one successful source run.

Streams and Fields

Below you’ll find all available data streams from iRancho and their corresponding fields. API reference: iRancho API.

Column names follow iRancho’s own field names (in Portuguese). Every table also has a raw_payload column with the whole record exactly as iRancho returned it, so information without a column of its own is still available. Lists and objects are stored as JSON text. Calendar dates are kept as the date shown in iRancho, and timestamps are converted to UTC.

Animals

Every animal of the account, active and inactive.Primary key: id_animal

Field	Type	Description
`id_animal`	String	Unique identifier of the animal (UUID).
`id_animal_fazenda`	String	Identification of the animal on the farm (the tag number users see). Not unique: it can be reused after the animal is deactivated.
`no_animal`	String	Name of the animal.
`nome`	String	Name of the animal, as some endpoints spell it.
`id_brinco_eletronico`	String	Electronic ear tag (RFID).
`id_rastreabilidade`	String	SISBOV traceability identifier.
`id_rastreabilidade_manejo`	String	Handling identifier.
`id_animal_nascimento`	String	Birth registration number.
`id_animal_definitivo`	String	Definitive registration number.
`dt_nascimento`	Date	Birth date.
`idade_meses`	Number	Age in months.
`id_sexo`	Integer	Sex of the animal (1 male, 2 female).
`no_sexo`	String	Name of the sex.
`id_raca`	Integer	Identifier of the breed.
`no_raca`	String	Name of the breed.
`id_categoria_animal`	Integer	Identifier of the current animal category.
`no_categoria_animal`	String	Name of the current animal category.
`id_atividade`	Integer	Current activity (1 cria/breeding, 2 recria/rearing, 3 engorda/fattening).
`no_animal_atividade`	String	Name of the current activity.
`id_situacao_vaca`	Integer	Reproductive status of the cow.
`no_situacao_vaca`	String	Name of the cow’s reproductive status.
`id_cor_pelagem`	Integer	Identifier of the coat colour.
`no_pelagem`	String	Name of the coat colour.
`id_padrao_racial`	Integer	Identifier of the breed standard.
`no_padrao_racial`	String	Name of the breed standard.
`id_tipo_parto`	Integer	Identifier of the type of birth.
`no_tipo_parto`	String	Name of the type of birth.
`id_tipo_chifre`	Integer	Identifier of the horn type.
`no_tipo_chifre`	String	Name of the horn type.
`ic_animal_ativo`	Boolean	Whether the animal is active in the herd.
`ic_animal_castrado`	Boolean	Whether the animal is castrated.
`publico`	Boolean	Whether the animal is flagged as public.
`peso`	Number	Last recorded weight, in kilograms.
`dt_ultima_pesagem`	Date	Date of the last weighing.
`id_fazenda`	Integer	Identifier of the farm the animal is on.
`no_fazenda`	String	Name of the farm the animal is on.
`id_fazenda_subdivisao`	Integer	Identifier of the subdivision (pasture or pen) the animal is in.
`no_subdivisao`	String	Name of the subdivision the animal is in.
`dt_ultima_movimentacao`	Datetime	Timestamp of the last move between subdivisions.
`id_lote`	Integer	Identifier of the lot the animal belongs to.
`no_lote`	String	Name of the lot the animal belongs to.
`id_pai`	String	Identifier of the sire, when registered.
`pai_id_animal_fazenda`	String	Farm identification of the sire.
`pai_no_animal`	String	Name of the sire.
`mae_id_animal_fazenda`	String	Farm identification of the dam.
`mae_no_animal`	String	Name of the dam.
`mae_receptora`	String	Recipient dam, for embryo transfer.
`id_venda_animal`	Integer	Identifier of the sale the animal left in, when sold.
`dt_morte_animal`	Datetime	Timestamp of the animal’s death, when dead.
`no_morte_causa`	String	Cause of death, when dead.
`sr_sui_abcz`	String	ABCZ series.
`id_melhoramento_delta_gen`	String	DeltaGen genetic improvement identifier.
`ps_nascimento`	Number	Birth weight, in kilograms.
`ps_desmame`	Number	Weaning weight, in kilograms.
`dt_desmame`	Date	Weaning date.
`dt_compra_animal`	Date	Purchase date, when bought.
`vr_compra_animal`	Number	Purchase price, when bought.
`dt_venda_animal`	Date	Sale date, when sold.
`vr_venda_animal`	Number	Sale price, when sold.
`qt_vaca_partos`	Integer	Number of calvings of the cow.
`dt_vaca_primeiro_parto`	Date	Date of the cow’s first calving.
`dt_vaca_ultimo_parto`	Date	Date of the cow’s last calving.
`detalhes`	String (JSON)	Additional details of the animal: weights, purchase, sale, calvings, origin (JSON object).
`dt_criacao`	Datetime	Timestamp the animal was registered in iRancho.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Weighings

Weighing history of every animal, one row per weighing.Primary key: record_key

Field	Type	Description
`record_key`	String	Identifier of the record built by the connector from the fields that identify it (or a hash of the record when iRancho does not send them).
`id_pesagem`	String	Identifier of the weighing.
`id_animal`	String	Identifier of the weighed animal (UUID).
`id_animal_fazenda`	String	Farm identification of the weighed animal.
`dt_pesagem`	Datetime	Timestamp of the weighing.
`ps_animal`	Number	Weight of the animal, in kilograms.
`nu_gmdup`	Number	Average daily gain since the previous weighing, in kilograms per day.
`id_tipo_pesagem`	Integer	Identifier of the weighing type.
`no_tipo_pesagem`	String	Name of the weighing type.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Lot Movements

Entries and exits of animals in lots, one row per movement. Read in date windows by movement date, from Start Date.Primary key: record_key

Field	Type	Description
`record_key`	String	Identifier of the record built by the connector from the fields that identify it (or a hash of the record when iRancho does not send them).
`id_animal`	String	Identifier of the animal (UUID).
`id_animal_fazenda`	String	Farm identification of the animal.
`id_lote`	Integer	Identifier of the lot.
`lote`	String	Name of the lot.
`dt_animal_entrada_lote`	Date	Date the animal entered the lot.
`dt_animal_saida_lote`	Date	Date the animal left the lot (empty while it is still in it).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Subdivision Movements

Moves of animals between subdivisions (pastures, pens), one row per move. Read in date windows by movement date, from Start Date.Primary key: record_key

Field	Type	Description
`record_key`	String	Identifier of the record built by the connector from the fields that identify it (or a hash of the record when iRancho does not send them).
`id_animal`	String	Identifier of the animal (UUID).
`id_animal_fazenda`	String	Farm identification of the animal.
`id_fazenda_subdivisao`	Integer	Identifier of the subdivision the animal moved into.
`no_subdivisao`	String	Name of the subdivision the animal moved into.
`id_fazenda`	Integer	Identifier of the farm of the subdivision.
`no_fazenda`	String	Name of the farm of the subdivision.
`dt_movimentacao`	Datetime	Timestamp of the move.
`dt_saida_subdivisao`	Datetime	Timestamp the animal left the subdivision (empty while it is still in it).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Deaths

Death records, read in date windows by death date, from Start Date.Primary key: record_key

Field	Type	Description
`record_key`	String	Identifier of the record built by the connector from the fields that identify it (or a hash of the record when iRancho does not send them).
`id_morte`	String	Identifier of the death record.
`id_animal`	String	Identifier of the dead animal (UUID).
`id_animal_fazenda`	String	Farm identification of the dead animal.
`dt_morte_animal`	Datetime	Timestamp of the death.
`id_morte_causa`	Integer	Identifier of the cause of death.
`no_morte_causa`	String	Name of the cause of death.
`id_morte_tipo`	Integer	Identifier of the type of death.
`no_morte_tipo`	String	Name of the type of death.
`id_morte_destino`	Integer	Identifier of the carcass destination.
`id_responsavel`	String	Identifier of the person responsible for the record.
`ds_remocao_animal`	String	Description of the carcass removal.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Breeding Exposures

Breeding exposures (natural mating, AI, FTAI, embryo transfer) of every animal whose exposure started on or after Start Date, with their pregnancy diagnosis and calving status.Primary key: id_exposicao_reprodutiva

Field	Type	Description
`id_exposicao_reprodutiva`	String	Unique identifier of the breeding exposure.
`id_tipo_exposicao_reprodutiva`	Integer	Type of exposure (1 natural mating, 2 AI, 3 multiple sires, 4 FTAI, 5 ET, 6 IVF, 7 clone).
`no_tipo_exposicao_reprodutiva`	String	Name of the exposure type.
`id_animal_situacao_exposicao`	Integer	Status of the exposure (1 planned, 2 done, 3 confirmed, 4 calving due, 5 calving recorded, 6 unproductive).
`no_exposicao_situacao`	String	Name of the exposure status.
`id_vaca`	String	Identifier of the cow (UUID).
`vaca_id_animal_fazenda`	String	Farm identification of the cow.
`id_touro`	String	Identifier of the bull (UUID).
`touro_id_animal_fazenda`	String	Farm identification of the bull.
`doador_id_animal_fazenda`	String	Farm identification of the donor, for embryo transfer.
`id_time_touro`	Integer	Identifier of the bull team, for multiple-sire exposures.
`no_time_touro`	String	Name of the bull team.
`dt_inicio_exposicao`	Date	Start date of the exposure.
`dt_termino_exposicao`	Date	End date of the exposure.
`dt_inicio_previsao_parto`	Date	Start of the expected calving period.
`dt_termino_previsao_parto`	Date	End of the expected calving period.
`dt_inicio_janela_parto`	Date	Start of the calving window.
`dt_confirmacao_prenhes`	Datetime	Timestamp the pregnancy was confirmed.
`dt_realizacao_exame`	Date	Date of the pregnancy diagnosis exam.
`vr_resultado_exame`	String	Result of the pregnancy diagnosis exam.
`ic_parto_realizado`	Boolean	Whether the calving happened.
`ic_exame_diagnostico_realizado`	Boolean	Whether the pregnancy diagnosis was done.
`ic_prenhes_confirmada`	Boolean	Whether the pregnancy is confirmed.
`ic_apresentou_cio`	Boolean	Whether the cow showed heat.
`id_lote`	Integer	Identifier of the lot where the exposure started.
`id_safra`	Integer	Identifier of the breeding season.
`ds_safra`	String	Name of the breeding season.
`nascimentos_reproducao`	String (JSON)	Births resulting from the exposure (JSON array).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Handling Extracts

Handling (manejo) executions registered in iRancho, one row per lane execution, with the animals handled stored as JSON. Read week by week by execution date, from Start Date.Primary key: record_key

Field	Type	Description
`record_key`	String	Identifier of the record built by the connector from the fields that identify it (or a hash of the record when iRancho does not send them).
`idExecucaoRaia`	Integer	Identifier of the lane execution.
`idExecucaoManejo`	Integer	Identifier of the handling execution (groups its lanes).
`idExecucaoManejoApp`	String	Identifier of the execution in the iRancho field app.
`idManejo`	Integer	Identifier of the handling protocol.
`nomeManejo`	String	Name of the handling protocol.
`dataExecucao`	Date	Reference date of the execution.
`dtInicial`	Date	Start date of the handling execution.
`status`	Integer	Status of the lane execution.
`qtAnimais`	Integer	Number of animals in the execution.
`raia_id`	Integer	Identifier of the lane (raia).
`raia_nu_dias`	Integer	Day number of the lane in the protocol.
`manejo`	String (JSON)	Execution details: date, animals handled with weights, medications, exams and exits (JSON object).
`dtCriacao`	Datetime	Timestamp the execution was created.
`dtAlteracao`	Datetime	Timestamp the execution was last changed.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Farms

Farms of the account.Primary key: id_fazenda

Field	Type	Description
`id_fazenda`	Integer	Unique identifier of the farm.
`no_fazenda`	String	Name of the farm.
`qt_area_total`	Number	Total area of the farm, in the farm’s unit of measure.
`qt_area_reserva`	Number	Legal reserve area of the farm, in the farm’s unit of measure.
`no_unidade_medida`	String	Unit of measure of the areas (square metres or hectares).
`qt_subdivisoes`	Integer	Number of subdivisions (pastures, pens) of the farm.
`latitude`	Number	Latitude of the farm headquarters.
`longitude`	Number	Longitude of the farm headquarters.
`no_municipio`	String	Municipality of the farm.
`sg_uf`	String	State (UF) of the farm.
`ic_sisbov_fazenda`	Boolean	Whether the farm takes part in SISBOV traceability.
`ativo`	Boolean	Whether the farm is active.
`coordenadas`	String (JSON)	Boundary polygon of the farm drawn in iRancho (JSON object).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Subdivisions

Subdivisions of every farm: pastures, pens and paddocks.Primary key: id_fazenda_subdivisao

Field	Type	Description
`id_fazenda_subdivisao`	Integer	Unique identifier of the subdivision.
`id_fazenda`	Integer	Identifier of the farm the subdivision belongs to.
`no_subdivisao`	String	Name of the subdivision.
`sg_subdivisao`	String	Short code of the subdivision.
`qt_area_subdivisao`	Number	Area of the subdivision, in the farm’s unit of measure.
`capacidade_max`	Integer	Maximum number of animals the subdivision holds.
`id_subdivisao_tipo`	Integer	Type of subdivision (5 = feedlot pen).
`id_subdivisao_pastagem`	Integer	Identifier of the pasture type.
`id_fazenda_setor`	Integer	Identifier of the farm sector the subdivision is in.
`no_fazenda_setor`	String	Name of the farm sector.
`id_fazenda_retiro`	Integer	Identifier of the retiro (sub-area) the subdivision is in.
`no_fazenda_retiro`	String	Name of the retiro.
`ic_ativo`	Boolean	Whether the subdivision is active.
`coordenadas`	String (JSON)	Boundary polygon of the subdivision drawn in iRancho (JSON object).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Improvements

Farm improvements such as buildings, fences and corrals.Primary key: id_benfeitoria

Field	Type	Description
`id_benfeitoria`	Integer	Unique identifier of the improvement.
`no_benfeitoria`	String	Name of the improvement.
`no_benfeitoria_tipo`	String	Type of improvement.
`id_fazenda`	Integer	Identifier of the farm the improvement is on.
`aa_benfeitoria`	Integer	Year the improvement was built.
`vida_util`	Integer	Useful life of the improvement, in years.
`vr_benfeitoria`	Number	Value of the improvement, in BRL.
`porcentagem_atividade`	Number	Share of the improvement used by the activity, in percent.
`observacao`	String	Notes about the improvement.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Machinery

Machinery and vehicles, including deactivated ones.Primary key: id_maquinario

Field	Type	Description
`id_maquinario`	Integer	Unique identifier of the machine.
`no_maquinario`	String	Name of the machine.
`id_maquinario_tipo`	Integer	Identifier of the machine type.
`no_maquinario_tipo`	String	Name of the machine type.
`id_marca`	Integer	Identifier of the brand.
`no_maquinario_marca`	String	Name of the brand.
`id_modelo`	String	Model of the machine (free text, despite the name).
`aa_fabricacao_maquinario`	Integer	Year of manufacture.
`aa_compra_maquinario`	Integer	Year of purchase.
`vr_compra_maquinario`	Number	Purchase value, in BRL.
`co_placa_maquinario`	String	Licence plate or internal code.
`id_fazenda`	Integer	Identifier of the farm the machine belongs to.
`ic_combustivel_tipo`	Integer	Identifier of the fuel type (product subcategory).
`no_combustivel`	String	Name of the fuel type.
`ic_unidade_trabalho`	String	Unit the usage is measured in (km, hora, nenhum).
`vida_util`	Integer	Useful life, in years.
`porcentagem_atividade`	Number	Share of the machine used by the activity, in percent.
`ic_estado_maquinario`	Boolean	Whether the machine is active.
`dt_desativacao`	Date	Date the machine was deactivated.
`observacao`	String	Notes about the machine.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Refuelings

Fuel fills of every machine.Primary key: id_maquinario_abastecimento

Field	Type	Description
`id_maquinario_abastecimento`	Integer	Unique identifier of the refueling.
`id_maquinario`	Integer	Identifier of the machine refueled.
`no_maquinario`	String	Name of the machine refueled.
`dt_abastecimento`	Date	Date of the refueling.
`qt_abastecimento`	Number	Quantity of fuel, in litres.
`vr_unidade_abastecimento`	Number	Price per litre, in BRL.
`nu_odometro`	Number	Odometer or hour-meter reading at the refueling.
`ic_abasteceu_na_fazenda`	Boolean	Whether the fuel came from the farm’s own stock.
`id_combustivel_tipo`	Integer	Identifier of the fuel type (product subcategory).
`no_combustivel`	String	Name of the fuel product.
`no_responsavel`	String	Person responsible for the refueling.
`no_estoque_origem`	String	Stock the fuel was taken from, when refueled at the farm.
`id_fazenda`	Integer	Identifier of the farm, when refueled at the farm.
`de_operacao_abastecimento`	String	Description of the operation.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Contacts

Contacts: suppliers, buyers, producers and employees.Primary key: id_pessoa

Field	Type	Description
`id_pessoa`	String	Unique identifier of the contact (UUID).
`nome`	String	Name of the contact.
`sobrenome`	String	Surname of the contact.
`no_completo`	String	Full name of the contact.
`email`	String	Email address of the contact.
`nu_cpf_cnpj`	String	CPF or CNPJ of the contact.
`tel_comercial`	String	Business phone.
`tel_residencial`	String	Home phone.
`tipo_pessoa`	String	Individual (pessoa_fisica) or company (pessoa_juridica).
`fk_id_municipio`	Integer	Identifier of the municipality (IBGE).
`fk_id_estado`	Integer	Identifier of the state (IBGE).
`fazendas`	String (JSON)	Third-party farms registered for the contact (JSON array).
`categorias`	String (JSON)	Categories of the contact: supplier, producer, customer, employee… (JSON array).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Contact Categories

Categories contacts are grouped in.Primary key: id_contato_categoria

Field	Type	Description
`id_contato_categoria`	Integer	Unique identifier of the category (1 supplier, 2 producer, 3 customer, 4 employee, 5 partner, 6 other, 7 manufacturer).
`de_categoria`	String	Name of the category.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Sales

Animal sales, all of them on every sync.Primary key: id_venda_animal

Field	Type	Description
`id_venda_animal`	Integer	Unique identifier of the sale.
`dt_venda`	Date	Date of the sale.
`qt_animal`	Integer	Number of animals sold.
`peso_medio_animal`	Number	Average live weight of the animals sold, in kilograms.
`peso_total_animal`	Number	Total live weight of the animals sold, in kilograms.
`pct_rend_carcaca_total`	Number	Carcass yield, in percent.
`vr_venda_total`	Number	Total value of the sale, in BRL.
`fk_id_fazenda`	Integer	Identifier of the farm the animals left from.
`no_fazenda_origem`	String	Name of the farm the animals left from.
`id_pessoa`	String	Identifier of the buyer (a contact).
`no_destino`	String	Name of the buyer.
`no_responsavel`	String	Name of the user responsible for the sale.
`qt_macho`	Integer	Number of males sold.
`peso_medio_macho_kg`	Number	Average live weight of the males sold, in kilograms.
`peso_total_macho_kg`	Number	Total live weight of the males sold, in kilograms.
`vr_medio_macho`	Number	Average value per male sold, in BRL.
`qt_femea`	Integer	Number of females sold.
`peso_medio_femea_kg`	Number	Average live weight of the females sold, in kilograms.
`peso_total_femea_kg`	Number	Total live weight of the females sold, in kilograms.
`vr_medio_femea`	Number	Average value per female sold, in BRL.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Sale Items

Animals sold in each sale, one row per animal, read from each sale’s detail.Primary key: id_venda_animal, id_animal

Field	Type	Description
`id_venda_animal`	Integer	Identifier of the sale.
`id_animal`	String	Identifier of the animal sold (UUID).
`id_animal_fazenda`	String	Farm identification of the animal sold.
`dt_venda`	Date	Date of the sale.
`tipo_venda`	String	How the sale was priced (Peso Vivo = live weight, Unidade = per head).
`id_pessoa`	String	Identifier of the buyer (a contact).
`fk_id_fazenda`	Integer	Identifier of the farm the animal left from.
`id_produtor_fazenda`	Integer	Destination producer farm (empty when sold to a slaughterhouse).
`ps_morto_frigorifico`	Number	Carcass weight at the slaughterhouse for the sale, in kilograms.
`pct_rend_carcaca_total`	Number	Carcass yield of the sale, in percent.
`ic_status_venda_sisbov`	Boolean	Whether the sale is a SISBOV sale.
`vr_venda_animal`	Number	Sale value of this animal, in BRL.
`ps_frigorifico`	Number	Carcass weight of this animal at the slaughterhouse, in kilograms.
`pct_rend_carcaca`	Number	Carcass yield of this animal, in percent.
`no_lote`	String	Lot the animal was in.
`no_sexo`	String	Sex of the animal.
`no_raca`	String	Breed of the animal.
`id_venda_animal_gta`	Integer	Identifier of the transit document (GTA) the animal left with.
`nu_gta`	String	Number of the GTA.
`nu_serie_gta`	String	Series of the GTA.
`no_carreta`	String	Truck the animal left in.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Purchase Slips

Cattle purchase slips (borderôs de compra).Primary key: id_bordero_digital

Field	Type	Description
`id_bordero_digital`	Integer	Unique identifier of the purchase slip.
`dt_compra`	Date	Purchase date.
`dt_pagamento`	Date	Payment date.
`situacao`	String	Status of the purchase slip.
`fazenda_origem`	String	Farm the animals were bought from.
`fazenda_destino`	String	Farm the animals were taken to.
`fornecedor`	String	Supplier of the animals.
`responsavel`	String	User responsible for the purchase slip.
`qt_animais`	Integer	Number of animals bought.
`ps_medio`	Number	Average weight of the animals, in kilograms.
`ps_total`	Number	Total weight of the animals, in kilograms.
`vr_medio`	Number	Average value per animal, in BRL.
`vr_arroba`	Number	Price per arroba (15 kg), in BRL.
`vr_total`	Number	Total value of the purchase, in BRL.
`observacoes`	String	Notes.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Financial Accounts

Financial accounts: cash, checking, savings, investment and credit card.Primary key: id_conta

Field	Type	Description
`id_conta`	Integer	Unique identifier of the account.
`no_fin_conta`	String	Name of the account.
`nu_conta`	String	Bank account number.
`nu_conta_agencia`	String	Bank branch number.
`saldo_inicial`	Number	Opening balance of the account, in BRL.
`ic_conta_principal`	Boolean	Whether this is the main account.
`ic_lock_transacao`	Integer	Edit lock state of the account’s transactions.
`id_fin_tipo_conta`	Integer	Account type (1 cash, 2 checking, 3 savings, 4 investment, 5 credit card).
`no_fin_tipo_conta`	String	Name of the account type.
`id_banco`	Integer	Identifier of the bank (empty for cash accounts).
`no_banco`	String	Name of the bank.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Financial Transactions

Financial transactions of every account, read month by month from Start Date to 12 months ahead (future installments already exist). One row per installment, recurrence occurrence and account side of a transfer. Forecasts of recurrences that were not recorded yet are not extracted.Primary key: id_conta, id_transacao

Field	Type	Description
`id_conta`	Integer	Identifier of the account the transaction is in.
`id_transacao`	String	Identifier of the transaction (a new one is generated when the transaction is edited).
`dt_transacao`	Date	Date of the transaction or installment (its due date for future ones).
`no_transacao_apelido`	String	Name of the transaction.
`vr_transacao`	Number	Value of this transaction or installment, in BRL (always positive; see ic_receita_despesa).
`ic_receita_despesa`	String	R for revenue, D for expense.
`no_tipo_pagamento`	String	Payment type: A_VISTA, PARCELADO, RECORRENTE or TRANSFERENCIA.
`ic_liquidado`	Boolean	Whether the transaction is settled (paid or received).
`id_transacao_conta_dia`	Integer	Order of the transaction within the account and day.
`id_categoria_transacao`	Integer	Identifier of the transaction category.
`no_categoria_transacao`	String	Name of the transaction category.
`id_subcategoria_transacao`	Integer	Identifier of the transaction subcategory.
`no_subcategoria_transacao`	String	Name of the transaction subcategory.
`id_centro_custo`	Integer	Identifier of the cost center.
`id_fin_atividade`	Integer	Identifier of the activity (within the cost center).
`id_fazenda`	Integer	Identifier of the farm the transaction is assigned to.
`id_pessoa`	String	Identifier of the contact (payer or payee).
`nu_documento_transacao`	String	Document or bank statement code of the transaction.
`fk_id_transacao`	String	Identifier of the originating transaction (first installment or origin side of a transfer).
`id_recorrencia`	Integer	Identifier of the recurrence rule, for recurring transactions.
`id_conta_destino`	Integer	Destination account, for transfers.
`vr_transacao_total`	Number	Total value of the transaction across installments, in BRL.
`ic_custo`	Boolean	Whether the transaction has costs allocated to animals.
`qtd_custos`	Integer	Number of animals the transaction’s cost is allocated to.
`de_observacao`	String	Notes about the transaction.
`de_destinacao`	String	Destination (purpose) text of the transaction.
`tags`	String (JSON)	Tags of the transaction (JSON array).
`documentos_fiscais`	String (JSON)	Fiscal documents (invoices) of the transaction (JSON array).
`parcelas`	String (JSON)	Other installments of the transaction, on the first installment (JSON array).
`item`	String (JSON)	Line items of the transaction (JSON array).
`fin_recorrencia`	String (JSON)	Recurrence rule, for recurring transactions (JSON object).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Financial Categories

Transaction categories.Primary key: id_categoria_transacao

Field	Type	Description
`id_categoria_transacao`	Integer	Unique identifier of the category.
`no_categoria_transacao`	String	Name of the category (default categories come in Portuguese).
`ic_receita_despesa`	String	R for revenue categories, D for expense categories.
`id_assinatura`	Integer	Subscription that created the category (0 = iRancho default).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Financial Subcategories

Transaction subcategories.Primary key: id_subcategoria_transacao

Field	Type	Description
`id_subcategoria_transacao`	Integer	Unique identifier of the subcategory.
`no_subcategoria_transacao`	String	Name of the subcategory.
`de_subcategoria_transacao`	String	Description of the subcategory.
`id_categoria_transacao`	Integer	Identifier of the category the subcategory belongs to.
`id_assinatura`	Integer	Subscription that created the subcategory (0 = iRancho default).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Cost Centers

Cost centers.Primary key: id_centro_custo

Field	Type	Description
`id_centro_custo`	Integer	Unique identifier of the cost center.
`no_centro_custo`	String	Name of the cost center.
`de_centro_custo`	String	Description of the cost center.
`id_assinatura`	Integer	Subscription that created the cost center (0 = iRancho default).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Financial Activities

Activities within cost centers.Primary key: id_fin_atividade

Field	Type	Description
`id_fin_atividade`	Integer	Unique identifier of the activity.
`no_fin_atividade`	String	Name of the activity.
`de_fin_atividade`	String	Description of the activity.
`id_fin_centro_custo`	Integer	Identifier of the cost center the activity belongs to.
`id_assinatura`	Integer	Subscription that created the activity (0 = iRancho default).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Transaction Tags

Tags (markers) of financial transactions.Primary key: id_tag

Field	Type	Description
`id_tag`	Integer	Unique identifier of the tag.
`no_tag`	String	Name of the tag.
`no_tag_cor`	String	Colour of the tag (hex code without ’#’).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Cost Types

Types of cost allocation.Primary key: id_tp_custo

Field	Type	Description
`id_tp_custo`	Integer	Unique identifier of the cost type.
`tp_custo`	String	Name of the cost type.
`id_assinatura`	Integer	Subscription that created the cost type (0 = iRancho default).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Cost Allocations

Costs allocated to animals by accrual month, read month by month from Start Date. A recurring allocation appears once per month.Primary key: id_fin_competencia, dt_alocacao_custo

Field	Type	Description
`id_fin_competencia`	Integer	Identifier of the cost allocation.
`dt_alocacao_custo`	Date	Accrual date of the allocation.
`de_custo`	String	Description of the cost.
`vr_custo_a_ratear`	Number	Amount apportioned among the animals, in BRL.
`id_tp_custo`	Integer	Identifier of the cost type.
`tp_custo`	String	Name of the cost type.
`custo_recorrencia`	String (JSON)	Recurrence rule, for recurring allocations (JSON object).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Products

Products and inputs, active and inactive, with their current stock.Primary key: id_produto

Field	Type	Description
`id_produto`	String	Unique identifier of the product.
`nome`	String	Name of the product.
`id_produto_assinatura`	String	Product code defined by the user (‘ID único’ in iRancho).
`ic_produto_ativo`	Boolean	Whether the product is active.
`id_produto_categoria`	Integer	Identifier of the product category.
`no_produto_categoria`	String	Name of the product category.
`fk_id_produto_subcategoria`	Integer	Identifier of the product subcategory.
`fk_id_produto_fabricante`	String	Identifier of the manufacturer (a contact).
`no_fabricante`	String	Name of the manufacturer.
`id_unidade_base`	Integer	Identifier of the base unit of measure.
`no_unidade_base`	String	Name of the base unit of measure.
`sg_unidade_base`	String	Symbol of the base unit of measure.
`qt_estoque`	Number	Current stock across all locations, in the base unit.
`qt_minima_produto`	Number	Minimum stock alert level, in the base unit.
`qt_maxima_produto`	Number	Maximum stock alert level, in the base unit.
`pct_proteina_bruta`	Number	Crude protein, in percent (feed inputs).
`pct_nutrientes_digestiveis_totais`	Number	Total digestible nutrients, in percent (feed inputs).
`pct_materia_seca`	Number	Dry matter, in percent (feed inputs).
`qt_dia_carencia_abate`	Integer	Slaughter withdrawal period, in days (pharmacy products).
`ic_produzido_fazenda`	Boolean	Whether the product is produced on the farm.
`ic_usado_pasto`	Boolean	Whether the product is used on pasture.
`ic_monitorar_produto`	Boolean	Whether the product’s stock is monitored.
`ic_especifico_sexo`	Boolean	Whether the product applies to one sex only.
`publico`	Boolean	Whether the product comes from iRancho’s shared catalogue.
`embalagens`	String (JSON)	Packagings the product can be moved in (JSON array).
`saldos`	String (JSON)	Stock lots per location, with FIFO unit cost (JSON array).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Stock Locations

Stock locations (warehouses) of each farm.Primary key: id_produto_estoque

Field	Type	Description
`id_produto_estoque`	Integer	Unique identifier of the stock location.
`no_produto_estoque`	String	Name of the stock location.
`id_fazenda`	Integer	Identifier of the farm the stock location belongs to.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Product Movements

Stock movements of every product (entries, exits, internal consumption, losses, sales, transfers), read month by month by movement date, from Start Date.Primary key: id_movimentacao_produto

Field	Type	Description
`id_movimentacao_produto`	Integer	Unique identifier of the stock movement.
`id_produto_sistema`	String	Identifier of the product moved (see products.id_produto).
`id_produto`	String	Product code shown as ‘ID único’ in iRancho (not the product identifier).
`produto_nome`	String	Name of the product moved.
`categoria`	String	Category of the product.
`subcategoria`	String	Subcategory of the product.
`dt_movimentacao`	Date	Date of the movement.
`id_tipo_movimentacao_produto`	Integer	Movement type (1 exit, 2 entry, 3 internal consumption, 4 loan, 5 loss, 6 sale, 7 stock transfer, 8 purchase).
`ds_tipo_movimentacao`	String	Name of the movement type.
`qt_unidade`	Number	Quantity moved, in the unit used.
`unidade`	String	Unit the quantity was moved in.
`qt_movimentacao_un_base`	Number	Quantity moved, in the product’s base unit.
`vr_produto_unidade_base`	Number	Unit value in the base unit, in BRL.
`vr_frete`	Number	Freight value, in BRL.
`nome_estoque_origem`	String	Stock location the product left from.
`destino`	String	Destination of the movement.
`no_pessoa`	String	Supplier or contact of the movement.
`nu_nota_fiscal`	String	Invoice number.
`dt_validade_produto`	Date	Expiry date of the product moved.
`manejo`	String	Handling (manejo) that generated the movement, when any.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Feed Formulas

Feed formulas (rations).Primary key: id_produto_formula

Field	Type	Description
`id_produto_formula`	String	Unique identifier of the formula (the identifier of the formula’s product).
`nome`	String	Name of the formula.
`id_unidade_base`	Integer	Identifier of the formula’s base unit of measure.
`sg_unidade_base`	String	Symbol of the formula’s base unit of measure.
`pct_materia_seca`	Number	Dry matter of the formula, in percent.
`pct_peso_vivo`	Number	Planned intake as a share of live weight, in percent.
`nu_gdp`	Number	Expected daily weight gain.
`ic_arredondar`	String	Rounding mode of quantities (N none, C up, B down).
`qt_casa_decimal`	Integer	Decimal places used when rounding.
`qt_batidas`	Integer	Number of batches mixed with the formula.
`composicao_formula`	String (JSON)	Ingredients of the formula and their share (JSON array).
`dt_criacao`	Datetime	Timestamp the formula was created.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Feed Batches

Feed batches mixed from formulas.Primary key: id_batida

Field	Type	Description
`id_batida`	Integer	Unique identifier of the batch.
`dt_batida`	Datetime	Timestamp the batch was mixed.
`id_produto_formula`	String	Identifier of the formula mixed.
`no_formula`	String	Name of the formula mixed.
`qt_planejada`	Number	Planned quantity.
`qt_produzida`	Number	Quantity actually produced.
`pct_materia_seca`	Number	Dry matter of the batch, in percent.
`pct_proteina_bruta`	Number	Crude protein of the batch, in percent.
`pct_nutrientes_digestiveis_totais`	Number	Total digestible nutrients of the batch, in percent.
`id_pessoa_planejamento`	String	Identifier of the person who planned the batch.
`id_pessoa_producao`	String	Identifier of the person who mixed the batch.
`no_responsavel`	String	Name of the person responsible.
`id_maquinario`	Integer	Identifier of the mixer used.
`movimentacoes_batida`	String (JSON)	Stock movements generated by the batch, with unit costs (JSON array).
`baixas_da_batida`	String (JSON)	Ingredients consumed by the batch (JSON array).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Nutrition Entries

Feed supplied to each subdivision per day.Primary key: id_nutricao

Field	Type	Description
`id_nutricao`	Integer	Unique identifier of the nutrition entry.
`dt_nutricao`	Date	Date the feed was supplied.
`id_fazenda_subdivisao`	Integer	Identifier of the subdivision (pasture or pen) fed.
`no_subdivisao`	String	Name of the subdivision fed.
`id_fazenda`	Integer	Identifier of the farm.
`id_produto`	String	Identifier of the product supplied to the adults.
`no_produto`	String	Name of the product supplied to the adults.
`qt_produto`	Number	Quantity supplied to the adults.
`id_unidade_medida_produto`	Integer	Unit of the quantity supplied.
`id_produto_creep`	String	Identifier of the creep-feed product supplied to the calves.
`no_produto_creep`	String	Name of the creep-feed product.
`qt_produto_creep`	Number	Quantity of creep feed supplied.
`id_unidade_medida_creep`	Integer	Unit of the creep-feed quantity.
`qt_animais`	Integer	Number of animals in the subdivision that day.
`qt_bezerros`	Integer	Number of calves in the subdivision that day.
`tp_sobra`	String	Leftover level (nada, pouco, medio, muito).
`qt_sobra`	Number	Leftover quantity.
`tp_sobra_creep`	String	Creep-feed leftover level.
`qt_sobra_creep`	Number	Creep-feed leftover quantity.
`id_unidade_medida_sobra`	Integer	Unit of the leftover quantity.
`id_salgador`	String	Identifier of the person who supplied the feed.
`no_salgador`	String	Name of the person who supplied the feed.
`ds_observacoes`	String	Notes.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Lots

Lots (batches) animals are grouped in.Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the lot (lote) animals are grouped in.
`name`	String	Name of the lot (lote) animals are grouped in.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Breeds

Cattle breeds.Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the breed (raça).
`name`	String	Name of the breed (raça).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Animal Categories

Animal categories (calf, steer, bull, heifer, cow).Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the animal category (1 bezerro, 2 garrote, 3 touro, 4 boi, 5 bezerra, 6 novilha, 7 vaca).
`name`	String	Name of the animal category (1 bezerro, 2 garrote, 3 touro, 4 boi, 5 bezerra, 6 novilha, 7 vaca).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Sexes

Animal sexes.Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the sex (1 male, 2 female).
`name`	String	Name of the sex (1 male, 2 female).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Weighing Types

Types of weighing.Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the weighing type.
`name`	String	Name of the weighing type.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Product Categories

Product categories.Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the product category (1 Farmácia, 2 Nutricionais, 3 Combustíveis, 4 Ferramentas, 5 Peças, 6 Agrícolas, 7 EPIs, 8 Outros Insumos, 9 Lubrificantes).
`name`	String	Name of the product category (1 Farmácia, 2 Nutricionais, 3 Combustíveis, 4 Ferramentas, 5 Peças, 6 Agrícolas, 7 EPIs, 8 Outros Insumos, 9 Lubrificantes).
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Product Subcategories

Product subcategories, with their category.Primary key: id, id_produto_categoria

Field	Type	Description
`id`	Integer	Identifier of the product subcategory.
`name`	String	Name of the product subcategory.
`id_produto_categoria`	Integer	Identifier of the product category the subcategory belongs to.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Units of Measure

Units of measure.Primary key: id

Field	Type	Description
`id`	Integer	Identifier of the unit of measure.
`name`	String	Name of the unit of measure.
`raw_payload`	String (JSON)	The whole record exactly as iRancho returned it (JSON object), including fields that have no column of their own.

Documentation

Get started

Context

Activate

Workspace

Resources

iRancho as a data source

Configuring iRancho as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Streams and Fields

​Configuring iRancho as a Source

​1. Add account access

​2. Select streams

​3. Configure data streams

​4. Configure data source

​5. Check your new source

​Streams and Fields

Configuring iRancho as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Streams and Fields