Skip to content

Fracttal ETL Hub Documentation

Item Upsert Associate Warehouses

Item Upsert Associate Warehouses

Model for associating warehouses to an asset.

General information:

Module	Category
`Items`	`Update and Create`

Molecule details

Input schema:

Field	Type	Required	Description	Default value	Examples
`code`	str	✅	Unique asset code.	`PydanticUndefined`	-
`id_type_item`	str	✅	Asset type.	`PydanticUndefined`	-
`field_1`	str	✅	Name or main description of the asset.	`PydanticUndefined`	-
`field_2`	Optional[str]	❌	Additional field 2.	`None`	-
`field_3`	Optional[str]	❌	Additional field 3.	`None`	-
`field_4`	Optional[str]	❌	Additional field 4.	`None`	-
`field_5`	Optional[str]	❌	Additional field 5.	`None`	-
`field_6`	Optional[str]	❌	Additional field 6.	`None`	-
`active`	Optional[bool]	❌	Indicates whether the asset is active or not.	`None`	-
`barcode`	Optional[str]	❌	Bar-code.	`None`	-
`notes`	Optional[str]	❌	Notes or comments.	`None`	-
`weight`	Optional[str]	❌	Asset weight (for spare parts and tools only)	`None`	-
`purchase_date`	Optional[str]	❌	Purchase date.	`None`	-
`is_serial_control`	Optional[bool]	❌	true if the item is controlled by serial, false otherwise.	`None`	-
`group`	Optional[str]	❌	Asset type.	`None`	-
`group_1`	Optional[str]	❌	Classification 1.	`None`	-
`group_2`	Optional[str]	❌	Classification 2.	`None`	-
`priorities`	Optional[str]	❌	Description of priority.	`None`	-
`id_priority`	Optional[Priority]	❌	Priority ID: 1: Very High, 2: High, 3: Medium, 4: Low, 5: Very Low	`None`	-
`code_parent_location`	Optional[str]	❌	Parent location code.	`None`	-
`latitude`	Optional[str]	❌	Latitude.	`None`	-
`longitud`	Optional[str]	❌	Length.	`None`	-
`unit_code`	Optional[str]	❌	Unit code.	`None`	-
`unit_description`	Optional[str]	❌	Description of the unit.	`None`	-
`visible_to_all`	Optional[str]	❌	Global visibility.	`None`	-
`total_cost`	Optional[str]	❌	Total cost of the asset.	`None`	-
`startup_date`	Optional[str]	❌	Start date for depreciation.	`None`	-
`costs_center`	Optional[str]	❌	Description of the cost center.	`None`	-
`budgets`	Optional[str]	❌	Total cost of straight-line depreciation.	`None`	-
`id_custom_field_group`	Optional[int]	❌	Custom field group id.	`None`	-
`hours_average_daily_use`	Optional[int]	❌	Average daily usage hours (seconds, between 0 and 86400)	`None`	-
`code_warehouse`	Optional[str]	❌	Warehouse code.	`None`	-
`id_warehouse`	Optional[str]	❌	Warehouse ID.	`None`	-
`location`	Optional[str]	❌	Physical location within the warehouse.	`None`	-
`max_stock_level`	Optional[str]	❌	Maximum stock allowed.	`None`	-
`min_stock_level`	Optional[str]	❌	Minimum stock allowed.	`None`	-
`stock`	Optional[str]	❌	Quantity of stock available.	`None`	-
`unit_cost_stock`	Optional[str]	❌	Unit cost of stock.	`None`	-
`equivalence`	Optional[str]	❌	Equivalence.	`None`	-

Usage example:

{
  "code": "A12345",
  "field_1": "Motor principal",
  "id_type_item": "EQUIPO",
  "code_warehouse": "WH001",
  "id_warehouse": "1",
  "barcode": "1234567890",
  "notes": "Activo en operación",
  "location": "Estante 5",
  "max_stock_level": "500",
  "min_stock_level": "10",
  "stock": "100",
  "unit_cost_stock": "50.00",
  "unit_code": "U001",
  "unit_description": "Unidad estándar",
  "visible_to_all": "True",
  "code_parent_location": "LOC001",
  "equivalence": "EQ001"
}

Notes:

All fields are optional except those required by the schema.