attribute_options_view #
List of attributes and their options configured in ALIX
| attribute_id | Attribute ID |
| attribute_cid | Attribute CID |
| attribute_created_by | Created by |
| attribute_created_by_id | Creator ID |
| attribute_created_date | Creation date |
| attribute_description | Description (primary language) |
| attribute_exist | False : deleted, true : not deleted |
| attribute_modified_by | Modified by |
| attribute_modified_by_id | Modifier ID |
| attribute_modified_date | Date modified |
| attribute_option_attribute_id | ID of the attribute associated with the attribute option |
| attribute_option_cid | Attribute option CID |
| attribute_option_color | Attribute option color |
| attribute_option_created_by | Attribute option created by |
| attribute_option_created_by_id | Creator ID of the attribute option |
| attribute_option_created_date | Attribute option creation date |
| attribute_option_description | Attribute option description (primary language) |
| attribute_option_exist | False : deleted, true : not deleted |
| attribute_option_id | Attribute option ID |
| attribute_option_modified_by | Attribute option modified by |
| attribute_option_modified_by_id | Attribute option modifier ID |
| attribute_option_modified_date | Attribute option date modified |
| attribute_option_secondary_description | Attribute option description (secondary language) |
| attribute_option_sku_suffix | SKU suffix |
| attribute_option_status | Attribute option status |
| attribute_option_template_id | Associated part ID |
| attribute_option_use_sku_as_suffix | Use the SKU as a suffix |
| attribute_secondary_description | Description (secondary language) |
| attribute_status | Status |
| attribute_type | Type |
bill_item_view #
Information on bills line items
| account_name | Account Name |
| bill_date | Bill date |
| bill_external_id | External bill ID |
| bill_id | Bill ID |
| bill_is_overdue | Is the bill late? |
| bill_name | Bill name |
| bill_status | Bill status |
| cid | CID |
| conversion_factor | Line item conversion factor |
| created_by_id | Creator ID |
| created_date | Creation date |
| currency_code | Currency code |
| currency_symbol | Currency symbol |
| dimension_to_display | Quantity, weight, length, surface or volume |
| exist | False : deleted, true : not deleted |
| expense_account_id | Bill expense account ID |
| external_id | External line item ID |
| id | ID |
| is_taxed | Is the item taxed? |
| measure | Measure |
| measure_unit | Line item unit of measure |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| name | Bill name |
| notes | Notes |
| purchase_order_billed_count | Total measure invoiced for this purchase order line item |
| purchase_order_id | Associated purchase order ID |
| purchase_order_item_id | Purchase order line item ID |
| purchase_order_measure | Line item measure |
| purchase_order_name | Associated purchase order name |
| rank | Bill row rank |
| tax_id | Bill line item tax ID |
| template_id | Associated item ID |
| template_inventory_management_type | Associated item inventory management type |
| template_title | Associated item description |
| unit_cost | Item unit cost |
| zoho_books_tax_id | Zoho books tax ID |
bill_view #
Bills information
| bill_date | Bill date |
| bill_to_address_id | Billing address ID |
| cid | CID |
| company_id | Company name |
| created_by_id | Creator ID |
| created_date | Creation date |
| currency_code | Currency code |
| currency_id | Currency ID |
| currency_symbol | Currency symbol |
| due_date | Due date |
| exchange_rate | Exchange rates |
| exist | False : deleted, true : not deleted |
| external_id | External bill ID |
| id | ID |
| is_overdue | Is the bill late? |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| name | Name |
| notes | Notes |
| payment_terms | Payment term |
| reference_number | Associated purchase order reference number |
| status | Status |
| terms_and_conditions | Terms and conditions |
| vendor_company_name | Vendor company name |
| vendor_display_name | Vendor display name |
| vendor_id | Vendor ID |
| vendor_tax_id | Vendor tax ID |
| vendor_zoho_books_tax_id | Vendor Zoho Books tax Id |
chart_of_accounts_view #
List of accounts in the chart of accounts
| cid | CID |
| code | Account code |
| company_id | Company ID |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| description | Description |
| exist | False: deleted, true: not deleted |
| external_id | External ID |
| external_type | External type |
| id | Account ID |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| name | Account name |
| status | Status |
| type | Account type |
checklist_item_view #
Checklist item information
| checklist_id | ID of the associated checklist |
| cid | CID |
| comment | Comment |
| copied_from_template_id | Template ID from which the item was copied |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| custom_field_definition_id | Custom field definition ID |
| custom_field_description | Custom field description |
| custom_field_id | Custom field ID |
| custom_field_name | Custom field name |
| custom_field_type | Custom field type (text, number, checkbox, tri-state selector) |
| custom_field_value | Custom field value |
| description | Description |
| enable_photo | Enable photos? |
| exist | False: deleted, true: dot deleted |
| id | ID |
| is_done | Is the item done? |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| sort_order | Order in which the item appears in the checklist |
| title | Title |
checklist_view #
Checklist information
| cid | CID |
| comment | Comment |
| config | Configuration type |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| description | Instruction |
| exist | False: deleted, true: not deleted |
| hyperlink | Hyperlink for instructions |
| id | Checklist ID |
| is_compliant | Is compliant |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| template_id | Associated card ID |
| title | Title |
| type | Type (shipment, good receipt or card step) |
contact_person_view #
Contact person information in the customer file
| exist | False : deleted, true : not deleted |
| cid | CID |
| contact_id | Associated contact ID |
| created_date | Creation date |
| department | Department |
| designation | Designation |
| external_id | External ID of the contact person |
| first_name | First name |
| id | Contact person ID |
| is_invoice | Is a billing contact |
| is_primary_contact | Is the primary contact |
| last_name | Surname |
| mobile | Mobile |
| modified_date | Date modified |
| phone | Phone number |
| salutation | Title |
| skype | Skype |
| zoho_books_contact_person_id | Contact person ID in Zoho Books |
| zoho_crm_contact_id | Contact ID in Zoho CRM |
demand_planning_view #
Demand planning view
| cid | CID |
| contact_company_name | Contact company name |
| contact_id | Associated contact ID |
| inventory_id | Inventory ID |
| inventory_tag | Inventory tag |
| invoice_title | Invoice title |
| item_detailed_number | Associated project number – card number |
| item_title | Title |
| location_code | Location code |
| location_title | Location title |
| measure | Measure |
| planned_date | Planned date |
| planned_type | |
| project_id | Associated project ID |
| receipt_title | Associated goods receipt title |
| received_date | Associated goods receipt date |
| sales_order_number | Associated sales order number |
| sales_order_reference | Associated sales order reference number |
| shipment_id | Associated shipment ID |
| shipment_list_id | Associated shipment list ID |
| shipment_list_number | Associated shipment list number |
| shipment_number | Associated shipment number |
| supplier_company_name | Vendor company name |
| supplier_part_number | Vendor part number |
| template_id | Associated item ID |
| warehouse_code | Warehouse code |
| warehouse_title | Warehouse title |
inventory_comments_view #
Inventories comments
All fields from the inventory_view are also found in this view.
| comment_comments_bi | Comment |
| comment_created_by | Comment creator |
| comment_created_date | Comment creation date |
inventory_date_view #
Inventory up to the date selected in ALIX
Date set in: Settings -> Accounting -> Configurations
| asset_account_name | Associated asset account name |
| cid | CID |
| company_name | Company name |
| converted_measure_in | Converted measure of the most recent inventory transaction (either in or out, cannot be both) * |
| converted_measure_out | Converted measure of the most recent inventory transaction (either in or out, cannot be both) * |
| converted_unit_cost | Converted unit cost * |
| created_by | Creator of the most recent transaction |
| created_date | Creation date of the most recent transaction |
| created_date_overwrite | Manual creation date |
| dimension | Quantity, weight, length, surface or volume |
| expense_account_name | Associated expense account name |
| group_name | Associated item group name |
| id | Most recent transaction ID |
| income_account_name | Associated income account name |
| inventory_balance | Inventory balance |
| inventory_category | Inventory category |
| inventory_converted_planned_unit_cost | Inventory converted planned unit cost * |
| inventory_converted_real_unit_cost | Inventory actual converted cost * |
| inventory_created_by | Inventory created by |
| inventory_created_date | Inventory creation date |
| inventory_date | Inventory date |
| inventory_description | Inventory description |
| inventory_ean | Inventory EAN |
| inventory_exist | False : deleted, true : not deleted |
| inventory_expiration_date | Inventory expiration date |
| inventory_id | Inventory ID |
| inventory_invoice_date | Inventory purchase order date |
| inventory_invoice_title | Either the title of the sales order, purchase order or the manual value entered in the inventory |
| inventory_location | Inventory location |
| inventory_location_code | Inventory location code |
| inventory_management_type | Associated item inventory management type |
| inventory_manufacturer | Inventory manufacturer |
| inventory_material | Inventory material |
| inventory_modified_by | Inventory modified by |
| inventory_modified_date | Inventory modification date |
| inventory_part_number | Inventory part number |
| inventory_planned_unit_cost | Inventory planned unit cost * |
| inventory_project | Inventory project |
| inventory_raw_material | Inventory raw material |
| inventory_raw_metric | Inventory raw metric |
| inventory_real_unit_cost | Inventory real unit cost |
| inventory_received_date | Inventory received date |
| inventory_received_title | Inventory goods receipt title |
| inventory_revision | Inventory revision |
| inventory_serial_number | Inventory serial number |
| inventory_sku | Inventory SKU |
| inventory_status | Inventory status |
| inventory_supplier | Inventory vendor |
| inventory_tag | Inventory tag |
| inventory_treatment | Inventory treatment |
| inventory_upc | Inventory UPC |
| item_id | Associated card ID |
| item_number | Associated card number |
| item_statut | Associated card status |
| item_tag | Associated card tag |
| ledger_location | Inventory location at the time of the transaction |
| ledger_location_code | Inventory location code at the time of the transaction |
| length_in | Length in |
| length_out | Length out |
| measure_in | Measure in |
| mesure_out | Measure out |
| modified_by | Modifier of the most recent transaction |
| modified_date | Modified date of the most recent transaction |
| plant_code | Associated site code |
| plant_id | Associated site ID |
| plant_name | Associated site name |
| previous_ledger_location | Previous inventory location, when changing location in transaction |
| previous_ledger_location_code | Previous inventory location code, when changing location in transaction |
| qty_at_date | Quantity to date |
| qty_in | Quantity in |
| qty_out | Quantity out |
| reason | Reason |
| reception_item_id | Line item ID in the goods receipt |
| related_ledger_id | ID of the associated transaction (which balances the transaction) |
| snapped_exchange_rate | Associated purchase order exchange rate |
| surface_in | Surface in |
| surface_out | Surface out |
| type | Inventory type |
| unit_cost | Unit cost |
| unit_cost_at_date | Unit cost to date |
| value_at_date | Value on date |
| volume_in | Volume in |
| volume_out | Volume out |
| warehouse | Entrepôt |
| weight_in | Weight in |
| weight_out | Weight out |
inventory_history_and_planned_transaction_view #
Inventory transactions history
| asset_account_code | Associated asset account code |
| asset_account_description | Associated asset account description |
| asset_account_id | Associated asset account ID |
| asset_account_name | Associated asset account name |
| calculated_planned_unit_cost | Calculated planned unit cost |
| carrier_name | Carrier name |
| carrier_po_number | Purchase order number associated with the carrier |
| category_code | Associated item category code |
| category_id | Associated item category id |
| category_title | Associated item category name |
| cid | CID |
| created_by | Transaction creator |
| created_by_id | Transaction creator ID |
| created_date | Transaction creation date |
| customer_company_name | Associated customer company name |
| customer_id | Associated customer ID |
| description | Associated item description (primary language) |
| dimension_to_display | Quantity, weight, length, surface or volume |
| ean | Associated item EAN |
| exist | False: deleted, true: not deleted |
| expense_account_code | Associated expense account code |
| expense_account_description | Associated expense account description |
| expense_account_id | Associated expense account ID |
| expense_account_name | Associated expense account name |
| expiration_delay | Associated item expiration delay |
| expiration_delay_unit | Associated item expiration delay unit |
| group_id | Associated item group ID |
| group_name | Associated item group name |
| income_account_code | Associated income account code |
| income_account_description | Associated income account description |
| income_account_id | Associated income account ID |
| income_account_name | Associated income account name |
| initial_measure | Associated inventory initial measure |
| instructions | Associated item unformatted instructions |
| inventory_balance | Inventory balance |
| inventory_id | Inventory ID |
| inventory_location | Inventory location |
| inventory_location_code | Inventory location code |
| inventory_management_type | Associated item inventory management type |
| inventory_purchase_order_number | Associated inventory purchase order number |
| inventory_sku | Inventory SKU |
| inventory_status | Inventory status |
| inventory_supplier_part_number | Inventory vendor part number |
| inventory_tag | Inventory tag |
| inventory_vendor_name | Inventory vendor name |
| inventory_warehouse_code | Inventory warehouse code |
| inventory_warehouse_title | Inventory warehouse title |
| is_manufactured | Can the associated item be manufactured? |
| is_printable | Can the associated item be printed? |
| is_purchased | Can the associated item be purchased? |
| is_selling | Can the associated item be sold? |
| is_taxed | Is the associated item taxed? |
| item_number | Associated card number |
| item_title | Associated card title |
| ledger_location | Inventory location at the time of the transaction |
| ledger_location_code | Inventory location code at the time of the transaction |
| ledger_type | Transaction type |
| location_id | Location ID |
| location_level_id | Location level ID |
| location_private_tag | Location tag used to generate the barcode |
| location_warehouse_id | Location warehouse ID |
| main_supplier_base_cost | Associated item main vendor cost |
| main_supplier_contact_category_id | Associated item main vendor contact category ID |
| main_supplier_contact_code | Associated item main vendor contact code |
| main_supplier_contact_company_name | Associated item main vendor contact company name |
| main_supplier_contact_display_name | Associated item main vendor name |
| main_supplier_contact_external_id | Associated item main vendor contact external ID |
| main_supplier_contact_id | Associated item main vendor contact ID |
| main_supplier_contact_language | Associated item main vendor contact language |
| main_supplier_contact_notes | Associated item main vendor contact notes |
| main_supplier_contact_owner_id | Associated item main vendor contact owner ID |
| main_supplier_contact_payment_term_id | Associated item main vendor contact payment term ID |
| main_supplier_contact_payment_terms | Associated item main vendor contact payment term |
| main_supplier_contact_price_list_id | Associated item main vendor contact price list ID |
| main_supplier_contact_website | Associated item main vendor contact website |
| main_supplier_contact_woo_commerce_contact_id | Associated item main vendor contact WooCommerce contact ID |
| main_supplier_contact_zoho_books_contact_id | Associated item main vendor contact Zoho Books contact ID |
| main_supplier_contact_zoho_books_tax_id | Associated item main vendor contact Zoo Books tax ID |
| main_supplier_contact_zoho_crm_account_id | Associated item main vendor contact Zoho CRM account ID |
| main_supplier_conversion_factor | Associated item main vendor conversion factor |
| main_supplier_currency_currency_code | Associated item main vendor currency code |
| main_supplier_currency_currency_format | Associated item main vendor currency format |
| main_supplier_currency_currency_name | Associated item main vendor currency name |
| main_supplier_currency_currency_symbol | Associated item main vendor currency symbol |
| main_supplier_currency_effective_date | Associated item main vendor currency effective date |
| main_supplier_currency_exchange_rate | Associated item main vendor currency exchange date |
| main_supplier_currency_external_id | Associated item main vendor currency external ID |
| main_supplier_currency_id | Associated item main vendor currency ID |
| main_supplier_currency_is_base_currency | Is the currency the base currency of the associated item primary vendor? |
| main_supplier_currency_price_precision | Associated item main vendor currency price precision |
| main_supplier_custom_unit | Associated item main vendor custom unit |
| main_supplier_discount | Associated item main vendor discount |
| main_supplier_id | Associated item main vendor ID |
| main_supplier_list_price | Associated item main vendor list price |
| main_supplier_minimum_order_qty | Associated item main vendor minimum order quantity |
| main_supplier_notes | Associated item main vendor notes |
| main_supplier_part_number | Associated item main vendor part number |
| main_supplier_purchase_increment | Associated item main vendor purchase increment |
| main_supplier_purchasing_lead_time | Associated item main vendor purchasing lead time |
| main_supplier_purchasing_lead_time_unit | Associated item main vendor purchasing lead time unit |
| main_supplier_ranking | Associated item main vendor ranking |
| main_supplier_unit_cost | Associated item main vendor unit cost |
| manufacturer | Inventory manufacturer |
| manufacturing_order_comment_count | Associated manufacturing order comment count |
| manufacturing_order_external_id | Associated manufacturing order external ID |
| manufacturing_order_file_count | Associated manufacturing order file count |
| manufacturing_order_formated_number | Associated manufacturing order formated number |
| manufacturing_order_has_planned_consumption | Does the associated manufacturing order have planned consumption? |
| manufacturing_order_icon_label | Associated manufacturing order icon label |
| manufacturing_order_id | Associated manufacturing order ID |
| manufacturing_order_income_account_id | Associated manufacturing order income account ID |
| manufacturing_order_instructions | Associated manufacturing order instructions |
| manufacturing_order_is_gross_or_net | Is the associated manufacturing order gross or net? |
| manufacturing_order_is_net_consumption | For consumption, true : net, false: gross |
| manufacturing_order_number | Associated manufacturing order number |
| manufacturing_order_on_net_update_production | For production, true : net, false: gross |
| manufacturing_order_output_behaviour_type | Inventory production behavior type |
| manufacturing_order_output_end_step_id | Inventory production end step ID |
| manufacturing_order_output_end_step_rank | Inventory production end step rank |
| manufacturing_order_output_end_vs_id | Inventory production end value stream ID |
| manufacturing_order_output_end_vs_rank | Inventory production end value stream rank |
| manufacturing_order_output_id | Inventory production ID |
| manufacturing_order_output_inventory_id | Inventory production target inventory ID |
| manufacturing_order_output_is_auto_print | Is automatic printing enabled on inventory production? |
| manufacturing_order_output_is_mandatory | Is inventory production mandatory? |
| manufacturing_order_output_is_target_inventory | Inventory production target inventory |
| manufacturing_order_output_measure | Inventory production measure |
| manufacturing_order_output_measure_unit | Inventory production measure unit |
| manufacturing_order_output_print_label_id | Inventory production print label ID |
| manufacturing_order_output_print_quantity | Inventory production print quantity |
| manufacturing_order_output_produced | Associated manufacturing order output produced |
| manufacturing_order_part_number | Associated manufacturing order part number |
| manufacturing_order_promised_date | Associated manufacturing order promised date |
| manufacturing_order_promised_delay | Associated manufacturing order promised delay |
| manufacturing_order_promised_delay_unit | Associated manufacturing order promised delay unit |
| manufacturing_order_revision | Associated manufacturing order revision |
| manufacturing_order_secondary_title | Associated manufacturing order name (secondary language) |
| manufacturing_order_sku | Associated manufacturing order SKU |
| manufacturing_order_tag | Associated manufacturing order tag |
| manufacturing_order_tare_type_id | Associated manufacturing order tare type ID |
| manufacturing_order_title | Associated manufacturing order name (primary language) |
| manufacturing_order_treatment | Associated manufacturing order treatment |
| manufacturing_order_trimmed_instructions | Associated manufacturing order trimmed instructions |
| manufacturing_order_type | Associated manufacturing order type |
| manufacturing_order_weight_gross | Associated manufacturing order weight gross |
| manufacturing_order_weight_gross_unit | Associated manufacturing order weight gross unit |
| manufacturing_order_weight_net | Associated manufacturing order weight net |
| manufacturing_order_weight_net_unit | Associated manufacturing order weight net unit |
| manufacturing_order_weight_tare | Associated manufacturing order weight tare |
| manufacturing_order_weight_tare_unit | Associated manufacturing order weight tare unit |
| material_code | Associated item material code |
| material_id | Associated item material id |
| material_private_tag | Associated item material private tag |
| material_title | Associated item material title |
| measure_unit | Measure unit |
| min_selling_measure | Minimum order quantity |
| modified_by | Transaction modifier |
| modified_by_id | Transaction modifier ID |
| modified_date | Transaction modification date |
| part_number | Part number |
| planned_measure | Planned measure |
| planned_target_inventory_id | Planned target inventory ID |
| planned_unit_cost | Planned unit cost |
| plant_code | Site code |
| plant_name | Site name |
| previous_ledger_location | Previous inventory location, when changing location in transaction |
| previous_ledger_location_code | Previous inventory location code, when changing location in transaction |
| raw_id | Associated item raw ID |
| raw_imperial_title | Associated item raw imperial title |
| raw_metric_title | Associated item raw metric title |
| raw_private_tag | Associated item raw private tag |
| real_measure | Real measure |
| related_inventory_tag | Related inventory tag |
| revision | Revision |
| sales_order_number | Associated sales order number |
| sales_order_reference_number | Associated sales order reference number |
| secondary_description | Related item description (secondary language) |
| selling_unit | Unit sales unit of measure |
| serial_number | Associated inventory serial number |
| shipment_id | Associated shipment ID |
| shipment_list_id | Associated shipment list ID |
| shipment_list_number | Associated shipment list number |
| shipment_number | Associated shipment number |
| sku | SKU |
| supplier_id | Inventory vendor ID |
| tare_type_id | Associated manufacturing order tare type ID |
| template_id | Associated item ID |
| template_location_code | Associated item location code |
| template_location_title | Associated item location title |
| transaction_date | Transaction date |
| transaction_type | Transaction type |
| treatment_code | Treatment code |
| treatment_id | Treatment ID |
| treatment_title | Treatment title |
| trimmed_instructions | Associated item instructions |
| type | Inventory type |
| unit_selling_price | Unit selling price |
| unit_weight | Unit weight |
| upc | UPC |
| weight_unit | Weight unit |
inventory_planning_view #
Inventory planning overview
| asset_account_code | Associated asset account code |
| asset_account_description | Associated asset account description |
| asset_account_id | Associated asset account ID |
| asset_account_name | Associated asset account name |
| calculated_planned_unit_cost | Calculated planned unit cost |
| category_code | Associated item category code |
| category_id | Associated item category id |
| category_title | Associated item category name |
| cid | CID |
| contact_company_name | Contact company name |
| contact_id | Associated contact ID |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| description | Description (primary language) |
| dimension_order | |
| dimension_to_display | Quantity, weight, length, surface or volume |
| ean | EAN |
| exist | False : deleted, true : not deleted |
| expense_account_code | Associated expense account code |
| expense_account_description | Associated expense account description |
| expense_account_id | Associated expense account ID |
| expense_account_name | Associated expense account name |
| expiration_delay | Associated item expiration delay |
| expiration_delay_unit | Associated item expiration delay unit |
| group_id | Associated item group ID |
| group_name | Associated item group name |
| income_account_code | Associated income account code |
| income_account_description | Associated income account description |
| income_account_id | Associated income account ID |
| income_account_name | Associated income account name |
| initial_measure | Associated inventory initial measure |
| instructions | Associated item unformatted instructions |
| inventory_management_type | Associated item inventory management type |
| inventory_tag | Inventory tag |
| inventory_to_fill_id | |
| invoice_title | Invoice title |
| is_manufactured | Can the associated item be manufactured? |
| is_printable | Can the associated item be printed? |
| is_purchased | Can the associated item be purchased? |
| is_selling | Can the associated item be sold? |
| is_taxed | Is the associated item taxed? |
| item_detailed_number | Associated project number – card number |
| item_title | Title |
| location_code | Location code |
| location_id | Location ID |
| location_level_id | Location level ID |
| location_private_tag | Location private tag |
| location_title | Location name |
| location_warehouse_id | Location warehouse ID |
| main_supplier_base_cost | Associated item main vendor cost |
| main_supplier_contact_category_id | Associated item main vendor contact category ID |
| main_supplier_contact_code | Associated item main vendor contact code |
| main_supplier_contact_company_name | Associated item main vendor contact company name |
| main_supplier_contact_contact_type | Associated main vendor contact type |
| main_supplier_contact_display_name | Associated main vendor name |
| main_supplier_contact_external_id | Associated main vendor contact external ID |
| main_supplier_contact_id | Associated main vendor contact ID |
| main_supplier_contact_is_portal_enabled | Vendor Zoho portal access enabled |
| main_supplier_contact_language | Associated main vendor contact language |
| main_supplier_contact_markup | Associated main vendor contact markup |
| main_supplier_contact_notes | Associated main vendor contact notes |
| main_supplier_contact_owner_id | Associated main vendor contact owner ID |
| main_supplier_contact_payment_term_id | Associated main vendor contact payment term ID |
| main_supplier_contact_payment_terms | Associated main vendor contact payment term |
| main_supplier_contact_price_list_id | Associated main vendor contact price list ID |
| main_supplier_contact_website | Associated main vendor contact website |
| main_supplier_contact_woo_commerce_contact_id | Associated main vendor contact WooCommerce contact ID |
| main_supplier_contact_zoho_books_contact_id | Associated item main vendor contact Zoho Books contact ID |
| main_supplier_contact_zoho_books_tax_id | Associated main vendor contact Zoho Books tax ID |
| main_supplier_contact_zoho_crm_account_id | Associated main vendor contact Zoho CRM account ID |
| main_supplier_conversion_factor | Associated main vendor conversion factor |
| main_supplier_currency_currency_code | Associated main vendor currency code |
| main_supplier_currency_currency_format | Associated main vendor currency format |
| main_supplier_currency_currency_name | Associated main vendor currency name |
| main_supplier_currency_currency_symbol | Associated main vendor currency symbol |
| main_supplier_currency_effective_date | Associated main vendor exchange rate effective date |
| main_supplier_currency_exchange_rate | Associated main vendor currency exchange rate |
| main_supplier_currency_external_id | Associated main vendor currency external ID |
| main_supplier_currency_id | Associated main vendor currency ID |
| main_supplier_currency_is_base_currency | Is the currency of the associated primary vendor the base currency? |
| main_supplier_currency_price_precision | Associated main vendor currency price precision |
| main_supplier_custom_unit | Associated main vendor custom unit |
| main_supplier_discount | Associated main vendor discount |
| main_supplier_display_name | Associated item main vendor name |
| main_supplier_id | Associated item main vendor ID |
| main_supplier_list_price | Associated item main vendor list price |
| main_supplier_minimum_order_qty | Associated item main vendor minimum order quantity |
| main_supplier_notes | Associated item main vendor notes |
| main_supplier_part_number | Associated item main vendor part number |
| main_supplier_purchase_increment | Associated item main vendor purchase increment |
| main_supplier_purchasing_lead_time | Associated item main vendor purchasing lead time |
| main_supplier_purchasing_lead_time_unit | Associated item main vendor purchasing lead time unit |
| main_supplier_ranking | Associated item main vendor ranking |
| main_supplier_unit_cost | Associated item main vendor unit cost |
| manufacturer | Inventory manufacturer |
| manufacturing_order_comment_count | Associated manufacturing order comment count |
| manufacturing_order_external_id | Associated manufacturing order external ID |
| manufacturing_order_file_count | Associated manufacturing order file count |
| manufacturing_order_formated_number | Associated manufacturing order formated number |
| manufacturing_order_has_planned_consumption | Does the associated manufacturing order have planned consumption? |
| manufacturing_order_icon_filename | Associated manufacturing order icon filename |
| manufacturing_order_icon_label | Associated manufacturing order icon label |
| manufacturing_order_id | Associated manufacturing order ID |
| manufacturing_order_income_account_id | Associated manufacturing order income account ID |
| manufacturing_order_instructions | Associated manufacturing order instructions |
| manufacturing_order_is_gross_or_net | Is the associated manufacturing order gross or net? |
| manufacturing_order_is_net_consumption | For consumption, true : net, false: gross |
| manufacturing_order_number | Associated manufacturing order number |
| manufacturing_order_on_net_update_production | For production, true : net, false: gross |
| manufacturing_order_output_behaviour_type | Inventory production behavior type |
| manufacturing_order_output_end_step_id | Inventory production end step ID |
| manufacturing_order_output_end_step_rank | Inventory production end step rank |
| manufacturing_order_output_end_vs_id | Inventory production end value stream ID |
| manufacturing_order_output_end_vs_rank | Inventory production end value stream rank |
| manufacturing_order_output_id | Inventory production ID |
| manufacturing_order_output_inventory_id | Inventory production target inventory ID |
| manufacturing_order_output_is_auto_print | Is automatic printing enabled on inventory production? |
| manufacturing_order_output_is_mandatory | Is inventory production mandatory? |
| manufacturing_order_output_is_target_inventory | Inventory production target inventory |
| manufacturing_order_output_item_step_id | ID of the association between the item and the inventory production step |
| manufacturing_order_output_measure | Inventory production measure |
| manufacturing_order_output_measure_unit | Inventory production measure unit |
| manufacturing_order_output_print_label_id | Inventory production print label ID |
| manufacturing_order_output_print_quantity | Inventory production print quantity |
| manufacturing_order_output_private_tag | Inventory production private tag |
| manufacturing_order_output_produced | Associated manufacturing order output produced |
| manufacturing_order_part_number | Associated manufacturing order part number |
| manufacturing_order_promised_date | Associated manufacturing order promised date |
| manufacturing_order_promised_delay | Associated manufacturing order promised delay |
| manufacturing_order_promised_delay_unit | Associated manufacturing order promised delay unit |
| manufacturing_order_revision | Associated manufacturing order revision |
| manufacturing_order_secondary_title | Associated manufacturing order name (secondary language) |
| manufacturing_order_sku | Associated manufacturing order SKU |
| manufacturing_order_tag | Associated manufacturing order tag |
| manufacturing_order_tare_type_id | Associated manufacturing order tare type ID |
| manufacturing_order_title | Associated manufacturing order name (primary language) |
| manufacturing_order_treatment | Associated manufacturing order treatment |
| manufacturing_order_trimmed_instructions | Associated manufacturing order trimmed instructions |
| manufacturing_order_type | Associated manufacturing order type |
| manufacturing_order_weight_gross | Associated manufacturing order weight gross |
| manufacturing_order_weight_gross_unit | Associated manufacturing order weight gross unit |
| manufacturing_order_weight_net | Associated manufacturing order weight net |
| manufacturing_order_weight_net_unit | Associated manufacturing order weight net unit |
| manufacturing_order_weight_tare | Associated manufacturing order weight tare |
| manufacturing_order_weight_tare_unit | Associated manufacturing order weight tare unit |
| material_code | Material code |
| material_id | Material ID |
| material_private_tag | Material private tag |
| material_title | Material title |
| measure | Planned measure |
| measure_unit | Measure unit |
| min_selling_measure | Minimum selling quantity |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| part_number | Part number |
| planned_date | Planned date |
| planned_target_inventory_id | Planned target inventory ID |
| planned_type | |
| planned_unit_cost | Planned unit cost |
| planning_type | |
| private_tag | Private tag |
| raw_id | Associated raw ID |
| raw_imperial_title | Associated raw imperial title |
| raw_metric_title | Associated raw metric title |
| raw_private_tag | Associated raw private tag |
| receipt_title | Associated goods receipt title |
| received_date | Associated goods receipt date |
| revision | Revision |
| sales_order_number | Associated sales order number |
| sales_order_reference | Associated sales order reference number |
| secondary_description | Related item description (secondary language) |
| selling_unit | Unit sales unit of measure |
| serial_number | Associated inventory serial number |
| shipment_number | Associated shipment number |
| sku | SKU |
| supplier_company_name | Vendor company name |
| supplier_part_number | Vendor part number |
| tare_type_id | Associated manufacturing order tare type ID |
| template_id | Associated item ID |
| template_location_code | Associated item location code |
| template_location_title | Associated item location title |
| template_title | Associated item title |
| treatment_code | Treatment code |
| treatment_id | Treatment ID |
| treatment_private_tag | Treatment private tag |
| treatment_title | Treatment title |
| trimmed_instructions | Trimmed instructions |
| type | Item Type |
| unit_selling_price | Unit sales price |
| unit_weight | Unit weight |
| upc | UPC code |
| warehouse_code | Warehouse code |
| warehouse_title | Warehouse title |
| weight_unit | Weight unit |
inventory_view #
View of inventories
| aisle_code | Aisle Code |
| available_measure | Available measur |
| bay_code | Bay Code |
| category_id | Associated category ID |
| category_title | Associated category title |
| cid | CID |
| client_company_name | Customer company name |
| client_display_name | Customer name |
| client_id | Customer ID |
| company_name | Company name |
| converted_current_measure | Converted current measure * |
| converted_initial_measure | Converted initial measure * |
| converted_planned_unit_cost | Converted planned unit cost * |
| converted_real_unit_cost | Converted actual unit cost * |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| current_length | Current length |
| current_measure | Current measure * |
| current_qty | Current quantity |
| current_surface | Current surface |
| current_volume | Current volume |
| current_weight | Current weight |
| current_width | Current width |
| description | Description (primary language) |
| dimension_to_display | Quantity, weight, length, surface or volume |
| due_date | Due date |
| exist | False : deleted, true : not deleted |
| expiration_date | Expiration date |
| gross_weight | Gross weight |
| id | Inventory ID |
| initial_length | Initial length |
| initial_measure | Initial measure * |
| initial_qty | Initial quantity |
| initial_surface | Initial surface |
| initial_volume | Initial volume |
| initial_weight | Initial weight |
| initial_width | Initial width |
| instructions | Instructions |
| inventory_condition_color | Associated inventory condition color |
| inventory_condition_icon_class | Associated inventory condition icon |
| inventory_condition_id | Associated inventory condition ID |
| inventory_condition_is_consumable | Is the inventory consumable? (associated inventory condition) |
| inventory_condition_is_planable | Is the inventory planable? (associated inventory condition) |
| inventory_condition_is_sellable | Is the inventory sellable? (associated inventory condition) |
| inventory_condition_name | Inventory condition name (primary language) |
| inventory_condition_secondary_name | Inventory condition name (secondary language) |
| invoice_date | Invoice date |
| invoice_title | Invoice title |
| is_bin | Is the inventory a bin? |
| is_dropship | Is the inventory a dropshipping? |
| landed_cost | Landed cost |
| last_po_expected_delivery_date | Expected delivery date of the last purchase order |
| last_po_name | Last purchase order name |
| last_po_notes | Notes to the last purchase order |
| last_po_order | Date of last purchase order |
| last_po_reference_number | Reference number of the last purchase order |
| last_po_shipment_preference | Last purchase order delivery preference |
| last_po_terms_and_conditions | Last purchase order terms and conditions |
| length_unit | Length unit |
| level_code | Level code |
| location | Location |
| location_code | Location code |
| location_id | Location ID |
| manufactured_date | Manufactured date |
| manufactured_ledger_id | Transaction ID that produced the inventory |
| manufacturer | Manufacturer |
| material_id | Material ID |
| material_title | Material title |
| measure_unit | Measure unit |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Modified date |
| net_weight | Net weight |
| other_cost | Other costs |
| part_number | Part number |
| planned_output_id | Associated planned inventory production ID |
| planned_target_inventory_display_name | Display name of the associated target inventory |
| planned_target_inventory_id | Planned target inventory ID |
| planned_target_inventory_location_code | Planned target inventory location code |
| planned_target_inventory_tag | Planned target inventory tag |
| planned_unit_cost | Planned unit cost |
| plant_code | Associated plant code |
| plant_id | Associated plant ID |
| plant_name | Associated plant name |
| project_client_address_id | Project customer address ID |
| project_client_on_label | Projet customer on label |
| project_formated_number | Associated project number as displayed in ALIX |
| project_id | Associated project ID |
| project_number | Associated project number |
| project_title | Project year + project number + project title |
| project_title_raw | Project title |
| project_type | Project type |
| project_year | Project date |
| purchase_order_item_contract_number | Associated purchase order item contract number |
| purchase_order_item_id | Associated purchase order item ID |
| purchase_order_reference_number | Associated purchase order reference number |
| raw_id | Raw ID |
| raw_imperial_title | Raw imperial title |
| raw_metric_title | Raw metric title |
| real_unit_cost | Real unit cost |
| receipt_carrier | Associated goods receipt carrier |
| receipt_title | Associated goods receipt title |
| received_date | Associated goods receipt date |
| received_datetime | Associated goods receipt date time |
| reception_checklist_id | Associated goods receipt checklist ID |
| reception_id | Associated goods receipt ID |
| reception_item_id | Associated goods receipt line item ID |
| reserved_measure | Reserved measure |
| resource_first_name | Talent first name |
| resource_last_name | Talent last name |
| return_date | Return date |
| return_number | Return number |
| revision | Revision |
| secondary_description | Description (secondary language) |
| serial_number | Serial number |
| status | Status |
| status_name | Status name |
| supplier_currency_code | Vendor currency code |
| supplier_currency_symbol | Vendor currency symbol |
| supplier_discount | Vendor discount |
| supplier_exchange_rate | Vendor exchange rate |
| supplier_id | Vendor ID |
| supplier_list_price | Vendor price list |
| supplier_name | Vendor name |
| supplier_part_number | Vendor part number |
| surface_unit | Surface unit |
| tag | Tag |
| tare_unit | Tare unit |
| tare_weight | Tare |
| template_asset_account_code | Associated item asset account code |
| template_asset_account_description | Associated item asset account description |
| template_asset_account_id | Associated item asset account ID |
| template_asset_account_name | Associated item asset account name |
| template_country_of_origin_id | Associated item country of origin |
| template_country_of_origin_primary_name | Associated item country of origin name (primary language) |
| template_country_of_origin_secondary_name | Associated item country of origin name (secondary language) |
| template_description | Associated item description (primary language) |
| template_ean | Associated item EAN |
| template_expense_account_code | Associated item expense account code |
| template_expense_account_description | Associated item expense account description |
| template_expense_account_id | Associated item expense account ID |
| template_expense_account_name | Associated item expense account name |
| template_group_name | Associated item group name |
| template_harmonized_system_code_code | Associated item HS code code |
| template_harmonized_system_code_description | Associated item HS code description |
| template_harmonized_system_code_id | Associated item HS code ID |
| template_id | Associated item ID |
| template_income_account_code | Associated item income account code |
| template_income_account_description | Associated item income account description |
| template_income_account_id | Associated item income account id |
| template_income_account_name | Associated item income account name |
| template_inventory_management_type | Associated item inventory management type |
| template_is_manufactured | Is the associated item manufactured? |
| template_is_printable | Is the associated item printable? |
| template_is_purchased | Is the associated item purchased? |
| template_is_selling | Is the associated item sellable? |
| template_long_description_purchase | Associated item long description, Purchase tab (primary language) |
| template_long_description_sale | Associated item long description, Sales tab (primary language) |
| template_long_secondary_description_purchase | Associated item long description, Purchase tab (secondary language) |
| template_long_secondary_description_sale | Associated item long description, Sales tab (secondary language) |
| template_manufacturing_order_id | Associated item manufacturing order ID |
| template_part_number | Associated item part number |
| template_secondary_description | Associated item description (secondary language) |
| template_sku | Associated item SKU |
| template_title | Associated item title |
| template_type | Associated item type |
| template_unit_weight | Associated item unit weight |
| template_upc | Associated item UPC |
| treatment | Treatment |
| treatment_id | Treatment ID |
| treatment_title | Treatment title |
| trimmed_instructions | Trimmed instructions |
| unit_weight | Unit weight |
| volume_unit | Volume unit |
| warehouse_code | Warehouse code |
| warehouse_description | Warehouse description |
| warehouse_title | Warehouse title |
| weight_input_is_gross_or_net | Is the weight entered gross or net? |
| weight_unit | Weight unit |
| width_unit | Width unit |
| zone_code | Zone code |
| zone_description | Zone description |
| zone_title | Zone title |
invoice_item_view #
Invoice line items information
| id | Invoice line item ID |
| account_name | Invoice line item account name |
| cid | CID |
| contract_number | Invoice line item contract number |
| created_by | Invoice line item creator |
| created_by_id | Invoice line item creator ID |
| created_date | Invoice line item creation date |
| currency_code | Associated currency code |
| currency_symbol | Associated currency symbol |
| dimension_to_display | Quantity, weight, length, surface or volume |
| discount | Invoice line item discount |
| exist | False: deleted, true: not deleted |
| external_id | External ID |
| income_account_id | Associated account account ID |
| invoice_date | Invoice date |
| invoice_external_id | Invoice external ID |
| invoice_id | Invoice ID |
| invoice_is_overdue | Is the invoice late? |
| invoice_name | Invoice name |
| invoice_status | Invoice status |
| is_taxed | Is the line item taxed? |
| measure | Measure |
| measure_unit | Measure unit |
| modified_by | Invoice line item modifier |
| modified_by_id | Invoice line item modifier ID |
| modified_date | Invoice line item modified date |
| name | Invoice line item name |
| notes | Invoice line item notes |
| overwritten_notes | |
| primary_notes | Associated sales order line item notes (primary language) |
| promised_date | Associated sales order line item promised_date |
| rank | Invoice line item rank |
| sales_order_invoiced_count | Associated sales order invoiced count |
| sales_order_item_id | Associated sales order line item id |
| sales_order_measure | Associated sales order measure |
| sales_order_name | Associated sales order name |
| secondary_notes | Associated sales order line item notes (secondary language) |
| tax_id | Associated tax ID |
| template_id | Associated item ID |
| template_sku | Associated item SKU |
| template_title | Associated item title |
| unit_selling_price | Unit sales price |
| zoho_books_tax_id | Zoho Books associated tax ID |
invoice_view #
Invoice information
| id | Invoice ID |
| exist | False: deleted, true: not deleted |
| bill_to_address_id | Billing address ID |
| cid | CID |
| client_company_name | Associated custumer company name |
| client_display_name | Associated custumer name |
| company_id | Company ID |
| config | Payment method config |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| currency_code | Currency code |
| currency_id | Currency ID |
| currency_symbol | Currency symbol |
| customer_id | Associated customer ID |
| due_date | Expected date |
| exchange_rate | Exchange rates |
| external_id | External ID |
| invoice_date | Invoice date |
| is_overdue | Is the invoice late? |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| name | Name |
| notes | Notes |
| payment_terms | Payment terms |
| reference_number | Reference number |
| ship_to_address_id | Shipping address ID |
| status | Status |
| subject | Subject |
| terms_and_conditions | Terms and conditions |
item_basic_view #
Manufacturing card information
| attribute_description | Associated attribute description |
| attribute_id | Associated attribute ID |
| attribute_option_description | Associated attribute option description |
| attribute_option_display_description | SKU – item description, if no item: associated attribute option description |
| attribute_option_id | Associated attribute option ID |
| cid | CID |
| country_of_origin_id | Country of origin ID |
| country_of_origin_primary_name | Country of origin name (primary language) |
| country_of_origin_secondary_name | Country of origin name (secondary language) |
| created_from_formatted_number | Formatted number (3 digits) of the card used to create this card (template or copied card) |
| created_from_id | ID of the card used to create this card (template or copied card) |
| created_from_number | Number of the card used to create this card (template or copied card) |
| created_from_status | Status of the card used to create this card (template or copied card) |
| created_from_tag | TAG of the card used to create this card (template or copied card) |
| created_from_title | Title of the card used to create this card (template or copied card) |
| current_step_code | Current step code |
| current_step_id | Current step ID |
| current_step_number | Current step number |
| current_step_title | Current step title |
| current_vs_id | Current value stream ID |
| current_vs_title | Current value stream title |
| harmonized_system_code_code | Associated HS code |
| harmonized_system_code_description | Associated HS code description |
| harmonized_system_code_id | Associated HS code ID |
| item_child_count | Child card count |
| item_comment_count | Card comment count |
| item_created_by_email | Creator email |
| item_created_by_first_name | Creator first name |
| item_created_by_full_name | Creator full name |
| item_created_by_id | Creator ID |
| item_created_by_last_name | Creator last name |
| item_created_by_mobile | Creator mobile |
| item_created_by_phone | Creator phone |
| item_created_date | Creation date |
| item_detailed_number | Associated project number – card number |
| item_exist | False: deleted, true: not deleted |
| item_file_count | Card file count |
| item_finish_good_date | Finish good manufactured date |
| item_finish_good_resource | Finish good manufactured talent full name |
| item_finished_child_count | Finished card child count |
| item_first_time_good | Did the card complete all its steps without errors? |
| item_formatted_number | Formatted card number (3 digits) |
| item_has_planned_consumption | Does the card have a planned consumption? |
| item_id | Card ID |
| item_instructions | Card instructions |
| item_invoice_date | Last associated invoice date |
| item_invoice_number | Last associated invoice number |
| item_is_advanced_planning | Is the card in advanced planning mode? |
| item_is_invoiced | Is the card charged? |
| item_last_resource_email | Last talent email |
| item_last_resource_first_name | Last talent first name |
| item_last_resource_full_name | Last talent full name |
| item_last_resource_id | Last talent ID |
| item_last_resource_last_name | Last talent last name |
| item_last_resource_mobile | Last talent mobile |
| item_last_resource_phone | Last talent phone |
| item_modified_by_email | Modifier email |
| item_modified_by_first_name | Modifier first name |
| item_modified_by_full_name | Modifier full name |
| item_modified_by_id | Modifier ID |
| item_modified_by_last_name | Modifier last name |
| item_modified_by_mobile | Modifier mobile |
| item_modified_by_phone | Modifier phone |
| item_modified_date | Modified date |
| item_number | Card number |
| item_plant_id | Associated site ID |
| item_plant_name | Associated site name |
| item_part_number | Part number |
| item_promised_date | Promised date |
| item_qty_planned | Quantity planned |
| item_qty_real | Quantity real |
| item_qty_scrap | Quantity scrap |
| item_revision | Revision |
| item_rework | Is the card on rework? |
| item_rework_date | Rework date |
| item_sequence | Sequence |
| item_sku | SKU |
| item_stack_rank | Card rank |
| item_status | Status |
| item_tag | Item tag |
| item_template_id | Related item ID |
| item_title | Title |
| item_total_lead_time | Total lead time |
| item_total_work_time | Time work time for the card |
| item_treatment | Treatment |
| item_type | Card type |
| item_weight_gross | Card weight gross |
| item_weight_gross_unit | Card weight gross unit |
| item_weight_net | Card weight net |
| item_weight_net_unit | Card weight net unit |
| item_weight_tare | Card weight tare |
| item_weight_tare_unit | Card weight tare unit |
| location_code | Card location code |
| location_id | Card location ID |
| location_title | Card location title |
| parent_item_formatted_number | Parent item formatted number (3 digits) |
| parent_item_id | Parent card ID |
| parent_item_number | Parent card number |
| parent_item_sequence | Parent card sequence |
| parent_item_status | Parent card status |
| parent_item_tag | Parent card tag |
| parent_item_title | Parent card title |
| project_detailed_title | Number + associated project title |
| project_exist | Does the project exist? |
| project_formatted_number | Associated project formatted number |
| project_id | Associated project ID |
| project_number | Associated project number |
| project_promised_date | Promised project date |
| project_status | Project status |
| project_title | Associated project title |
| project_type | Associated project type |
| project_year | Associated project year |
| reporting_tag_names | Associated reporting tag names |
| shipment_id | Associated shipment ID |
| shipment_list_id | Associated shipping list ID |
| shipment_list_number | Associated shipping list number |
| shipment_name | Associated shipment name |
| shipment_number | Associated shipment number |
| shipment_ponumber | Associated shipment purchase order number |
| shipment_status | Associated shipment status |
| slot_id | Equipment ID |
| slot_item_count | Equipment card count |
| slot_max_item_count | Equipment max card count |
| slot_name | Equipment name |
| so_item_id | Associated sales order line item ID |
| splitted_from_formatted_number | Number (3 digits) of the splitted card to create this one |
| splitted_from_id | ID of the splitted card to create this one |
| splitted_from_number | Number of the splitted card to create this one |
| splitted_from_status | Status of the splitted card to create this one |
| splitted_from_tag | TAG of the splitted card to create this one |
| splitted_from_title | Title of the splitted card to create this one |
| unit_selling_price | Associated sales order line item unit selling price |
item_consumption_view #
Consumption by card
All fields from the item_basic_view view are also found in this view.
| consumption_created_by | Consumption creator |
| consumption_created_by_id | Consumption creator ID |
| consumption_created_date | Consumption date |
| consumption_created_date_overwrite | Manual consumption date |
| consumption_id | Material consumed ID |
| consumption_length | Consumption length |
| consumption_length_unit | Consumption length unit of measure |
| consumption_measure | Consumption measure |
| consumption_measure_unit | Consumption measure unit |
| consumption_modified_by | Consumption modifier |
| consumption_modified_by_id | Consumption modifier ID |
| consumption_modified_date | Consumption modified date |
| consumption_private_tag | Consumption private tag |
| consumption_qty | Consumption quantity |
| consumption_surface | Consumption surface |
| consumption_surface_unit | Consumption surface unit |
| consumption_unit_cost | Consumption unit cost |
| consumption_volume | Consumption volume |
| consumption_volume_unit | Consumption volume unit |
| consumption_weight | Consumption weight |
| consumption_weight_unit | Consumption weight unit |
| consumption_width | Consumption width |
| consumption_width_unit | Consumption width unit |
| converted_planned_consumption_measure | Converted planned consumption measure * |
| material_title | Material title |
| planned_consumption_created_by | Planned consumption creator |
| planned_consumption_created_by_id | Planned consumption creator ID |
| planned_consumption_created_date | Planned consumption creation date |
| planned_consumption_id | Planned consumption ID |
| planned_consumption_length | Planned consumption length |
| planned_consumption_length_unit | Planned consumption length unit |
| planned_consumption_measure | Planned consumption measure * |
| planned_consumption_measure_unit | Planned consumption measure unit |
| planned_consumption_modified_by | Planned consumption modified by |
| planned_consumption_modified_by_id | Planned consumption modifier ID |
| planned_consumption_modified_date | Planned consumption modified date |
| planned_consumption_planned_unit_cost | Planned consumption planned unit cost |
| planned_consumption_private_tag | Planned consumption private tag |
| planned_consumption_qty | Planned consumption quantity |
| planned_consumption_surface | Planned consumption surface |
| planned_consumption_surface_unit | Planned consumption surface unit |
| planned_consumption_volume | Planned consumption volume |
| planned_consumption_volume_unit | Planned consumption volume unit |
| planned_consumption_weight | Planned consumption weight |
| planned_consumption_weight_unit | Planned consumption weight unit |
| planned_consumption_width | Planned consumption width |
| planned_consumption_width_unit | Planned consumption width unit |
| related_consumption_inventory_tag | Associated inventory tag (which balances consumption) |
| template_id | Associated item ID |
| template_sku | Associated item SKU |
| template_title | Associated item Title |
item_planned_consumption_view #
Card planned consumption informations
| planned_consumption_id | Planned consumption ID |
| converted_planned_consumption_measure | Converted measure * |
| planned_consumption_batch | Batch size |
| planned_consumption_behaviour_type | Behaviour type |
| planned_consumption_blade_width | Blade width |
| planned_consumption_child_count | Child count |
| planned_consumption_cid | Planned consumption CID |
| planned_consumption_copied_from_id | Source planned consumption ID (when copying) |
| planned_consumption_created_by | Created by |
| planned_consumption_created_by_id | Creator ID |
| planned_consumption_created_date | Creation date |
| planned_consumption_exists | False: deleted, true: not deleted |
| planned_consumption_is_auto | Is planned consumption automatic? |
| planned_consumption_item_id | Related part ID |
| planned_consumption_measure | Measure * |
| planned_consumption_measure_unit | Measure unit |
| planned_consumption_modified_by | Modified by |
| planned_consumption_modified_by_id | Modifier ID |
| planned_consumption_modified_date | Modified date |
| planned_consumption_parent_id | Associated parent ID |
| planned_consumption_sort_order | Sort order |
| planned_consumption_source_inventory_id | Associated source inventory ID |
| planned_consumption_step_id | Associated step ID |
| planned_consumption_template_id | Associated item ID |
item_step_planning #
Step information for each card
| attribute_description | Associated attribute description |
| attribute_id | Associated attribute ID |
| attribute_option_description | Association attribute option description |
| attribute_option_id | Associated attribute option ID |
| checklist_id | Associated checklist ID |
| cid | CID |
| created_from_formatted_number | Formatted number (3 digits) of the card used to create this card (template or copied card) |
| created_from_id | ID of the card used to create this card (template or copied card) |
| created_from_number | Number of the card used to create this card (template or copied card) |
| created_from_status | Status of the card used to create this card (template or copied card) |
| created_from_tag | TAG of the card used to create this card (template or copied card) |
| created_from_title | Title of the card used to create this card (template or copied card) |
| current_step_code | Current step code |
| current_step_id | Current step ID |
| current_step_number | Current step number |
| current_step_title | Current step title |
| current_vs_id | Current value stream ID |
| current_vs_title | Current value stream title |
| equipment_time_sum | Equipment times sum |
| item_child_count | Card child count |
| item_comment_count | Card comment count |
| item_created_by_email | Creator email |
| item_created_by_first_name | Creator first name |
| item_created_by_full_name | Creator full name |
| item_created_by_id | Creator ID |
| item_created_by_last_name | Creator last name |
| item_created_by_mobile | Creator cell phone |
| item_created_by_phone | Creator phone |
| item_created_date | Creation date |
| item_detailed_number | Detailed card number |
| item_exist | False: deleted, true: not deleted |
| item_file_count | Card file count |
| item_finish_good_date | Finish good manufactured date |
| item_finish_good_resource | Finish good manufactured talent full name |
| item_finished_child_count | Finished card child count |
| item_first_time_good | Did the card complete all its steps without errors? |
| item_formatted_number | Formatted card number |
| item_has_planned_consumption | Does the card have a planned consumption? |
| item_id | Card ID |
| item_instructions | Card instructions |
| item_invoice_date | Invoice date associated with the card |
| item_invoice_number | Invoice number associated with the card |
| item_is_invoiced | Is the card charged? |
| item_last_resource_email | Last person email |
| item_last_resource_first_name | Last person first name |
| item_last_resource_full_name | Last person full name |
| item_last_resource_id | Last person ID |
| item_last_resource_last_name | Last person last name |
| item_last_resource_mobile | Last person cell phone |
| item_last_resource_phone | Last person phone |
| item_modified_by_email | Modifier email |
| item_modified_by_first_name | Modifier first name |
| item_modified_by_full_name | Modifier full name |
| item_modified_by_id | Modifier ID |
| item_modified_by_last_name | Modifier last name |
| item_modified_by_mobile | Modifier cell |
| item_modified_by_phone | Modifier phone |
| item_modified_date | Date modified |
| item_number | Card number |
| item_part_number | Card part number |
| item_promised_date | Card promised date |
| item_qty_planned | Planned quantity |
| item_qty_real | Actual quantity |
| item_qty_scrap | Scrapped quantity |
| item_revision | Card revision |
| item_rework | Is the card on rework? |
| item_rework_date | Rework date |
| item_sku | Card SKU |
| item_stack_rank | Current column card rank |
| item_status | Card status |
| item_step_exist | False: deleted, true: not deleted |
| item_step_file_count | Step file count |
| item_step_id | ID of the association between the card and the step |
| item_step_is_constant_time | False: planned time is multiplied by planned batch size, true: time is not multiplied |
| item_step_is_planned_split | Will the card be split after this step? |
| item_step_status | Step status, the definitions of which are as follows: doneftg: the step has been done once donenoftg: the step was done more than once todo: the step is to be done in_progress: current step waiting: the step is pending skipped: the step has been skipped done: the step has ben done (see correspondence with colors in the operation board here) |
| item_step_trimmed_instructions | Step instructions |
| item_tag | Card TAG |
| item_template_id | Associated item ID |
| item_title | Card title |
| item_total_lead_time | Card total lead time |
| item_total_work_time | Card total work time |
| item_treatment | Card treatment |
| item_type | Card type |
| item_weight_gross | Card gross |
| item_weight_gross_unit | Card gross unit of measure |
| item_weight_net | Card net |
| item_weight_net_unit | Card net unit of measure |
| item_weight_tare | Card tare |
| item_weight_tare_unit | Card tare unit of measure |
| location_code | Card location code |
| location_id | Card location ID |
| location_title | Card location title |
| parent_item_formatted_number | Formatted parent card number |
| parent_item_id | Parent card ID |
| parent_item_number | Parent card number |
| parent_item_status | Parent card status |
| parent_item_tag | Parent card tag |
| parent_item_title | Parent card title |
| planned_equipment_time | Planned equipment time |
| planned_slot_id | Planned equipment ID |
| planned_slot_name | Planned equipment name |
| planned_worktime | Planned work time |
| project_desired_date | Associated project desired date |
| project_detailed_title | Project number + project title |
| project_exist | False: deleted, true: not deleted |
| project_formatted_number | Associated project number as displayed in ALIX |
| project_id | Associated project ID |
| project_number | Associated project number |
| project_promised_date | Associated project promised date |
| project_status | Associated project status |
| project_title | Associated project title |
| project_type | Associated project type |
| project_year | Associated project year |
| sales_order_company_name | Responsible site company name |
| sales_order_customer_company_name | Associated sales order customer name |
| sales_order_customer_display_name | Associated sales order customer company name |
| sales_order_desired_date | Associated sales order desired date |
| sales_order_exist | False: deleted, true: not deleted |
| sales_order_external_number | Associated sales order external number |
| sales_order_fulfillment_status | Associated sales order fulfillment status |
| sales_order_id | Associated sales order ID |
| sales_order_invoice_status | Associated sales order invoice status |
| sales_order_name | Associated sales order name |
| sales_order_paid_status | Associated sales order paid status |
| sales_order_plant_code | Associated sales order responsible site code |
| sales_order_plant_name | Associated sales order responsible site name |
| sales_order_promised_date | Associated sales order promised date |
| sales_order_reference_number | Associated sales order reference number |
| sales_order_sales_order_date | Associated sales order date |
| sales_order_status | Associated sales order status |
| shipment_id | Associated shipment ID |
| shipment_name | Associated shipment name |
| shipment_number | Associated shipment number |
| shipment_ponumber | Associated shipment purchase order number |
| shipment_status | Associated shipment status |
| slot_id | Equipment ID |
| slot_item_count | Equipment card count |
| slot_max_item_count | Equipment max card count |
| slot_name | Equipment name |
| step_code | Step code |
| step_equipment_capacity | Step max equipment capacity |
| step_id | Step ID |
| step_rank | Step rank |
| step_resource_capacity | Step max resource capacity |
| step_title | Step title |
| valuestream_id | Associated value stream ID |
| valuestream_rank | Associated value stream rank |
| valuestream_title | Associated value stream title |
| worktime_sum | Work time sum |
order_planning_view #
Order planning view
| cid | CID |
| inventory_id | Inventory ID |
| inventory_tag | Inventory tag |
| invoice_title | Invoice title |
| item_detailed_number | Associated project number – card number |
| item_title | Title |
| location_code | Location code |
| location_title | Location name |
| measure | Measure |
| planned_date | |
| planned_type | Planned date |
| receipt_title | Associated goods receipt title |
| received_date | Associated goods receipt date |
| sales_order_number | Associated sales order number |
| sales_order_reference | Associated sales order reference number |
| shipment_number | Associated shipment number |
| supplier_company_name | Vendor company name |
| supplier_part_number | Vendor part number |
| template_id | Associated item ID |
| warehouse_code | Warehouse code |
| warehouse_title | Warehouse title |
resource_time_entry_flat_view #
Time entries sum per day per employee
| resource_id | Talent ID |
| resource_exist | False: deleted, true: not deleted |
| cid | CID |
| department_costing | Associated department costing |
| department_id | Associated department ID |
| department_title | Associated department title |
| entry_break_time_minutes | Length in minutes of the break time entry |
| entry_break_type | Break entry type |
| entry_clock_in | Clock in entry UTC |
| entry_clock_in_to_tz | Clock in entry in the time zone |
| entry_clock_out | Clock out entry UTC |
| entry_clock_out_to_tz | Clock out entry in the time zone |
| entry_date | Entry date |
| entry_day_of_week | Entry day of the week |
| entry_exist | False: deleted, true: not deleted |
| entry_id | Entry ID |
| entry_in_comment | Entry in comment |
| entry_is_work_time | Is time entry working time? |
| entry_manual_comment | Entry manual comment |
| entry_manual_entry | True: manual entry, false: automatic |
| entry_out_comment | Entry out comment |
| entry_shift_end | Shift end entry |
| entry_shift_start | Shift start entry |
| entry_timezone | Time zone |
| entry_total_hours | Total duration in hours of the time entry |
| entry_total_hours_round | Rounded total duration in hours of the time entry |
| entry_total_seconds | Total duration in seconds of the time entry |
| plant_code | Associated site code |
| plant_id | Associated site ID |
| plant_name | Associated site name |
| position_id | Associated position ID |
| position_title | Associate position title |
| resource_active | Is the talent active? |
| resource_costing | Talent cost |
| resource_created_date | Talent creation date |
| resource_email | |
| resource_first_name | First name |
| resource_fringe | % fringe |
| resource_full_name | Full name |
| resource_last_name | Last name |
| resource_manager_email | Supervisor email |
| resource_manager_first_name | Supervisor first name |
| resource_manager_full_name | Supervisor full name |
| resource_manager_id | Supervisor ID |
| resource_manager_last_name | Supervisor last name |
| resource_manager_mobile | Supervisor mobile |
| resource_manager_phone | Supervisor phone |
| resource_mobile | Mobile |
| resource_modified_date | Modified date |
| resource_notes | Notes |
| resource_number | Employee number |
| resource_phone | Telephone |
| resource_pin | PIN |
| resource_project_supervisor | Is the talent a project manager? |
| resource_show_in_pay | View on payroll |
| resource_user_view | In the operations board, does the talent see all the cards or only his own? True: all cards, false: only his own |
| shift_code | Associated shift code |
| shift_description | Associated shift description |
| shift_id | Associated shift ID |
| shift_title | Associated shift title |
resource_time_entry_view #
Time entry information
| break_total_hours | Total break hours |
| break_total_hours_round | Rounded total break hours |
| cid | CID |
| department_costing | Cost per department |
| department_id | Associated department ID |
| department_title | Associated department title |
| diner_total_hours | Total lunch hours |
| diner_total_hours_round | Total rounded lunch hours |
| entry_clock_in | Clock in entry UTC |
| entry_clock_in_to_tz | Clock in entry in the time zone |
| entry_clock_out | Clock out entry UTC |
| entry_clock_out_to_tz | Clock out entry in the time zone |
| entry_date | Entry date |
| entry_day_of_week | Entry day of week |
| entry_exist | False: deleted, true: not deleted |
| entry_id | Entry ID |
| entry_in_comment | Entry in comment |
| entry_manual_comment | Entry manual comment |
| entry_manual_entry | True: manual entry, false: automatic |
| entry_out_comment | Entry out comment |
| entry_shift_end | Shift end entry |
| entry_shift_start | Shift start entry |
| entry_timezone | Time zone |
| entry_total_hours | Entry total hours |
| entry_total_hours_round | Entry rounded total hours |
| entry_without_lunch | Total time (without lunch break, if worked more than 4 hours) |
| entry_without_lunch_entry | Total time without lunch |
| entry_without_lunch_entry_round | Rounded total time without lunch |
| plant_code | Associated site code |
| plant_id | Associated site ID |
| plant_name | Associated site name |
| position_id | Associated position ID |
| position_title | Associate position title |
| resource_active | Is the talent active? |
| resource_costing | Resource cost |
| resource_created_date | Creation date |
| resource_email | |
| resource_exist | False: deleted, true: not deleted |
| resource_first_name | First name |
| resource_fringe | % fringe |
| resource_full_name | Full name |
| resource_id | Talent ID |
| resource_last_name | Last name |
| resource_manager_email | Supervisor email |
| resource_manager_first_name | Supervisor first name |
| resource_manager_full_name | Supervisor full name |
| resource_manager_id | Supervisor ID |
| resource_manager_last_name | Supervisor last name |
| resource_manager_mobile | Supervisor mobile |
| resource_manager_phone | Supervisor phone |
| resource_mobile | Supervisor mobile |
| resource_modified_date | Date modified |
| resource_notes | Notes |
| resource_number | Employee number |
| resource_phone | Telephone |
| resource_pin | PIN |
| resource_project_supervisor | Is the talent a project manager? |
| resource_show_in_pay | View on payroll |
| resource_user_view | In the operation board, does the talent see all the cards or only his own? True: all cards, false: only his own |
| shift_code | Associated shift code |
| shift_description | Associated shift description |
| shift_detail_lunch | Expected duration of the lunch |
| shift_id | Associated shift ID |
| shift_title | Associated shift title |
sales_order_view #
Sales order line item information
| active_planned_ledger_planned_measure_sum | Sum of all active reservations for the associated item |
| active_reserved_count | Active reservation count |
| attribute_description | Associated item attribute description (primary language) |
| attribute_id | Associated item attribute ID |
| attribute_option_description | Associated item attribute option description (primary language) |
| attribute_option_display_description | SKU + associated item attribute option description (primary language) |
| attribute_option_display_secondary_description | SKU + associated item attribute option description (secondary language) |
| attribute_option_id | Associated item attribute option ID |
| attribute_option_secondary_description | Associated item attribute option description (secondary language) |
| attribute_secondary_description | Associated item attribute description (secondary language) |
| billing_address_address | Customer billing address street |
| billing_address_attention | Customer billing address attention |
| billing_address_city | Customer billing address city |
| billing_address_country | Customer billing address country |
| billing_address_phone | Customer billing address phone |
| billing_address_state | Customer billing address province |
| billing_address_state_code | Customer billing address province code |
| billing_address_street2 | Customer billing address street 2 |
| billing_address_zip | Customer billing address postal code |
| category_code | Category code |
| category_title | Category title |
| cid | CID |
| client_company_name | Customer company name |
| client_cp_department | Customer primary contact department |
| client_cp_designation | Customer primary contact designation |
| client_cp_email | Customer primary contact email |
| client_cp_first_name | Customer primary contact first name |
| client_cp_last_name | Customer primary contact last name |
| client_cp_mobile | Customer primary contact mobile |
| client_cp_phone | Customer primary contact phone |
| client_display_name | Customer name |
| computed_unit_price | Computed unit price |
| contract_number | Contract number |
| converted_computed_unit_price | Converted computed unit price |
| converted_measure | Converted orderded measure |
| converted_unit_selling_price | Converted unit price |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| custom_service_template_id | Custom service associated item ID |
| dimension_to_display | Quantity, weight, length, surface or volume |
| discount | Discount |
| discounted_unit_price | Discounted unit price |
| equipment_planned_cost | Associated manufacturing order equipment planned cost |
| equipment_pricing | Associated manufacturing order equipment cost |
| exist | False: Deleted, true: Not deleted |
| expense_account_id | Associated expense account ID |
| external_id | External ID |
| id | Line item ID |
| income_account_external_id | Associated income account external ID |
| income_account_id | Associated income account ID |
| invoice_date | Most recent invoice date |
| invoice_external_id | Most recent external invoice ID |
| invoice_number | Most recent associated invoice number |
| invoiced_count | Invoices count |
| is_assigned_to_shipment | Is the line item assigned to a shipment? |
| is_invoiced | Is the line item invoiced? |
| is_taxed | Is the line item taxed? |
| long_notes | Long description |
| manufacturing_order_current_step_id | Associated manufacturing order current step id |
| manufacturing_order_formated_number | Associated manufacturing order formatted number |
| manufacturing_order_id | Associated manufacturing order ID |
| manufacturing_order_status | Associated manufacturing order status |
| manufacturing_order_template_id | Associated manufacturing order item id |
| material_code | Material code |
| material_planned_cost | Associated manufacturing order material planned cost |
| material_pricing | Associated manufacturing order materials cost |
| material_title | Material title |
| measure | Ordered measure |
| measure_assigned_to_shipment | Measure assigned to a shipment |
| measure_remaining_to_ship | Remaining measure to be shipped |
| measure_unit | Unit of measure |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Modified date |
| name | Name |
| notes | Notes |
| overwritten_name | Manual description |
| overwritten_notes | Manual long description |
| part_number | Part number |
| planned_manufacturing_order_id | Planned associated manufacturing order id |
| planned_unit_cost | Associated item planned unit cost |
| primary_name | Name (primary language) |
| primary_notes | Notes (primary language) |
| project_exist | False: Deleted, true: Not deleted |
| project_formated_number | Associated sales project name |
| project_id | Associated sales project ID |
| project_sales_currency_code | Associated sales project currency code |
| project_sales_currency_symbol | Associated sales project currency symbol |
| project_sales_exchange_rate | Associated sales project exchange rate |
| project_status | Associated sales project status |
| project_title | Associated sales project title |
| project_type | Associated sales project type |
| promised_date | Promised date (from the associated manufaturing order or the line item or the associated sales order) |
| raw_imperial_title | Raw imperial title |
| raw_metric_title | Raw metric title |
| reporting_tag_names | Reporting tags (from the sales order if the related card is a sales order, from the card if it’s a manufacturing order) |
| resolved_planned_ledger_planned_measure_sum | All resolved reservations sum for the associated item |
| resource_planned_cost | Associated manufacturing order resource planned cost |
| resource_pricing | Associated manufacturing order resource selling prince |
| sales_currency_code | Currency code |
| sales_currency_symbol | Currency symbol |
| sales_exchange_rate | “Sales order” + sales order exchange rate |
| sales_order_company_id | Company ID |
| sales_order_company_name | Company name |
| sales_order_exist | False: Deleted, true: Not deleted |
| sales_order_fulfillment_status | Sales order fulfillment status |
| sales_order_id | Sales order ID |
| sales_order_invoice_status | Sales order invoice status |
| sales_order_item_mark_as_invoiced | Is the sales order line item marked as invoiced? |
| sales_order_item_mark_as_shipped | Is the sales order line item marked as shipped? |
| sales_order_name | Sales order name |
| sales_order_paid_status | Sales order payment status |
| sales_order_plant_code | Sales order responsible site code |
| sales_order_plant_name | Sales order responsible site name |
| sales_order_quote_number | Sales order quote number |
| sales_order_status | Sales order status |
| sales_ranking | Line item rank |
| salesperson_email | Salesperson email |
| salesperson_id | Salesperson ID |
| salesperson_name | Salesperson name |
| salesperson_phone | Salesperson phone |
| schedule_id | Schedule release ID |
| secondary_name | Name (secondary language) |
| secondary_notes | Notes (secondary language) |
| shipment_date | Associated shipment date (if the entire order is shipped in one shipment) |
| shipment_id | Associated shipment ID (if the entire order is shipped in one shipment) |
| shipment_list_id | Associated shipment list ID (if the entire order is shipped in one shipment) |
| shipment_list_number | Associated shipment list number (if the entire order is shipped in one shipment) |
| shipment_number | Associated shipment number (if the entire order is shipped in one shipment) |
| shipped_count | Shipment count |
| shipping_address_address | Shipping address street |
| shipping_address_attention | Shipping address attention |
| shipping_address_city | Shipping address city |
| shipping_address_country | Shipping address country |
| shipping_address_phone | Shipping address phone |
| shipping_address_state | Shipping address province |
| shipping_address_state_code | Shipping address province code |
| shipping_address_street2 | Shipping address street 2 |
| shipping_address_zip | Shipping address zip code |
| show_in_sales | For manufacturing orders. True: appears in the sales order, false: does not appear |
| subcontract_planned_cost | Associated manufacturing order subcontract planned cost |
| subcontract_pricing | Associated manufacturing order subcontract selling price |
| tax_id | Associated tax ID |
| template_group_id | Associated item group ID |
| template_group_name | Associated item group name |
| template_id | Associated item ID |
| template_inventory_management_type | Associated item inventory management type |
| template_is_manufactured | Is the associated item manufactured? |
| template_manufacturing_order_id | Associated item manufacturing order ID |
| template_sku | Associated item SKU |
| template_unit_weight | Associated item unit weight |
| template_weight_unit | Associated item unit weight unit |
| treatment_code | Treatment code |
| treatment_title | Treatment title |
| unit_price | Unit price |
| unit_selling_price | Unit selling price |
| weight_net | Net weight |
| weight_net_unit | Net weight unit |
| weight_tare | Tare weight |
| zoho_books_tax_id | Zoho Books tax ID |
shipment_line_item_view #
Shipment line items information
| converted_current_measure | Converted current measure |
| converted_planned_measure | Converted planned measure |
| created_by | Created by |
| created_date | Creation date |
| current_measure | Current measure |
| destination_address | Destination address street |
| destination_address_id | Destination address ID |
| destination_city | Destination address city |
| destination_country | Destination address country |
| destination_state | Destination address province |
| destination_street2 | Destination address street 2 |
| destination_zip | Destination address postal code |
| dimension_to_display | Quantity, weight, length, surface or volume |
| exist | False: deleted, true: not deleted |
| id | Shipment item ID |
| measure_unit | Measure unit |
| modified_by | Modified by |
| modified_date | Date modified |
| planned_measure | Planned measure |
| sales_order_company_id | Associated sales order company ID |
| sales_order_company_name | Associated sales order company name |
| sales_order_exist | False: deleted, true: not deleted |
| sales_order_fulfillment_status | Associated sales order fulfillment status |
| sales_order_id | Associated sales order ID |
| sales_order_invoice_status | Associated sales order invoice status |
| sales_order_item_contract_number | Associated sales order line item contract number |
| sales_order_item_exist | False: deleted, true: not deleted |
| sales_order_item_id | Associated sales order line item ID |
| sales_order_item_invoice_date | Associated sales order line item last invoice date |
| sales_order_item_invoice_number | Associated sales order line item last invoice number |
| sales_order_item_invoiced_count | Associated sales order line item quantity invoiced |
| sales_order_item_is_invoiced | Is the associated sales order line item invoiced? |
| sales_order_item_measure | Associated sales order line item measure |
| sales_order_item_primary_name | Associated sales order line item name (primary language) |
| sales_order_item_promised_date | Associated sales order line item promised date |
| sales_order_item_secondary_name | Associated sales order line name (secondary language) |
| sales_order_item_shipped_count | Associated sales order line item shipped count |
| sales_order_name | Associated sales order name |
| sales_order_paid_status | Associated sales order payment status |
| sales_order_plant_code | Associated sales order responsible site code |
| sales_order_plant_name | Associated sales order responsible site name |
| sales_order_status | Associated sales order status |
| shipment_carrier_company_name | Associated carrier company name |
| shipment_carrier_display_name | Associated carrier name |
| shipment_carrier_id | Associated carrier ID |
| shipment_checklist_id | Associated checklist ID |
| shipment_cid | CID |
| shipment_client_company_name | Associated customer company name |
| shipment_client_display_name | Associated customer name |
| shipment_client_id | Associated customer ID |
| shipment_client_is_shipper | Is the customer the shipper? |
| shipment_cost | Shipment cost |
| shipment_created_by | Shipment created by |
| shipment_created_date | Shipment creation date |
| shipment_exist | False: deleted, true: not deleted |
| shipment_expedited_date | Shipment date |
| shipment_formatted_number | Shipment number |
| shipment_id | Shipment ID |
| shipment_instructions | Shipment instructions |
| shipment_is_gray_label | True: the shipment is in “Grey label” mode, false: it is not |
| shipment_list_id | Associated shipment list ID |
| shipment_list_number | Associated shipment list number |
| shipment_modified_by | Shipment modified by |
| shipment_modified_date | Shipment modified date |
| shipment_name | Shipment name |
| shipment_number | Shipment number |
| shipment_planned_date | Shipment planned date |
| shipment_planned_datetime | Shipment planned date and hour/minutes |
| shipment_po_number | Associated purchase order number |
| shipment_shipper_address_id | Shipper address ID |
| shipment_status | Shipping Status |
| shipment_step_id | Associated shipment step ID |
| shipment_step_title | Associated shipment step title |
| shipment_tracking_number | Shipment tracking number |
| shipment_trailer | Shipment trailer |
| shipment_year | Year |
| shipper_address | Shipper address street |
| shipper_city | Shipper address city |
| shipper_country | Shipper address country |
| shipper_state | Shipper address province |
| shipper_street2 | Shipper address street 2 |
| shipper_zip | Shipper address postal code |
| template_category_code | Associated item category code |
| template_category_title | Associated item category title |
| template_group_id | Associated item group id |
| template_group_name | Associated item group name |
| template_inventory_management_type | Associated item inventory management type |
| template_is_manufactured | Is the associated item manufactured? |
| template_manufacturing_order_id | Associated item manufacturing order ID |
| template_material_code | Associated item material code |
| template_material_title | Associated item material title |
| template_raw_imperial_title | Associated item imperial title |
| template_raw_metric_title | Associated item metric title |
| template_sku | Associated item SKU |
| template_treatment_code | Associated item treatment code |
| template_treatment_title | Associated item treatment title |
| template_unit_weight | Associated item unit weight |
| template_weight_unit | Associated item unit weight unit |
shipment_view #
Shipment information
| carrier_company_name | Associated carrier company name |
| carrier_display_name | Associated carier name |
| carrier_id | Associated carrier ID |
| checklist_id | Associated checklist ID |
| cid | CID |
| client_company_name | Associated customer company name |
| client_display_name | Associated customer name |
| client_id | Associated customer ID |
| client_is_shipper | Is the customer the shipper? |
| cost | Shipment cost |
| created_by | Created by |
| created_date | Creation date |
| destination_address | Destination address street |
| destination_address_id | Destination address ID |
| destination_city | Destination address city |
| destination_country | Destination address country |
| destination_state | Destination address province |
| destination_street2 | Destination address street 2 |
| destination_zip | Destination address postal code |
| exist | False: deleted, true: not deleted |
| expedited_date | Shipment date |
| formated_number | Shipment number |
| id | Shipment ID |
| instructions | Instructions |
| is_gray_label | True: the shipment is in “Grey label” mode, false: it is not |
| modified_by | Modified by |
| modified_date | Modified date |
| name | Name |
| number | Shipment number |
| planned_date | Planned delivery date |
| planned_datetime | Planned delivery date and hour/minutes |
| po_number | Associated purchase order number |
| shipper_address | Shipper address street |
| shipper_address_id | Shipper address ID |
| shipper_city | Shipper address city |
| shipper_country | Shipper address country |
| shipper_state | Shipper address province |
| shipper_street2 | Shipper address street 2 |
| shipper_zip | Shipper address postal code |
| status | Shipment status |
| step_id | Associated shipment step ID |
| step_title | Associated shipment step title |
| tracking_number | Tracking number |
| trailer | Trailer |
| year | Year |
template_view #
Item informations
| asset_account_code | Associated asset account code |
| asset_account_description | Associated asset account description |
| asset_account_id | Associated asset account ID |
| asset_account_name | Associated asset account name |
| associated_raw_template_id | Associated raw ID |
| attribute_description | Associated attribute description |
| attribute_id | Associated attribute ID |
| attribute_option_description | Associated attribute option description (primary language) |
| attribute_option_display_description | SKU + associated attribute option description (primary language) |
| attribute_option_display_secondary_description | SKU + associated attribute option description (secondary language) |
| attribute_option_id | Associated attribute option ID |
| attribute_option_secondary_description | Associated attribute option description (secondary language) |
| available_measure_inventory_sum | Available quantity (ready + ordered) |
| available_measure_inventory_total_cost | Total cost of available inventory |
| category_code | Associated category code |
| category_id | Associated category ID |
| category_title | Associated category title |
| cid | CID |
| configurable_template_id | Parent configurable item ID (if variant) |
| configurable_type | Configurable type |
| converted_initial_measure | Converted initial measure (display unit) |
| converted_planned_unit_cost | Converted planned unit cost (display unit) |
| country_of_origin_id | Country of origin ID |
| country_of_origin_primary_name | Country of origin name (primary language) |
| country_of_origin_secondary_name | Country of origin name (secondary language) |
| created_by | Created by |
| created_by_id | Creator ID |
| created_date | Creation date |
| customer_consignment_required | Is the item a customer consignment? |
| customer_finished_good_required | Is the item a finished good? |
| description | Item description (primary language) |
| dimension_to_display | Quantity, weight, length, surface or volume |
| ean | EAN code |
| exist | False: deleted, true: not deleted |
| expense_account_code | Associated expense account code |
| expense_account_description | Associated expense account description |
| expense_account_id | Associated expense account ID |
| expense_account_name | Associated expense account name |
| expiration_delay | Expiration delay |
| expiration_delay_unit | Expiration delay unit |
| group_id | Associated group ID |
| group_name | Associated group name |
| harmonized_system_code_code | Associated HS code |
| harmonized_system_code_description | Associated HS code description |
| harmonized_system_code_id | Associated HS code ID |
| id | ID |
| initial_measure | Initial measure |
| instructions | Instructions (unformatted) |
| inventory_aggregate_count | Inventory records count |
| inventory_management_type | Inventory management type |
| is_allowed_consignment_customer | Allowed for customer consignment? |
| is_alternative_items_allowed | Alternative items allowed? |
| is_configurable | Is the item configurable? |
| is_customer_specific | Is the item customer specific? |
| is_manufactured | Can the item be manufactured? |
| is_printable | Can the item be printed? |
| is_purchased | Can the item be purchased? |
| is_selling | Can the item be sold? |
| is_taxed | Is the item taxed? |
| is_using_purchase_order_item_part_number | Is the purchase order part number used on inventory? |
| location_code | Default location code |
| location_id | Default location ID |
| location_level_id | Location level ID |
| location_private_tag | Location private tag |
| location_title | Location title |
| location_warehouse_id | Location warehouse ID |
| long_description_purchase | Long description (Purchase tab – primary language) |
| long_description_sale | Long description (Sales tab – primary language) |
| long_secondary_description_purchase | Long description (Purchase tab – secondary language) |
| long_secondary_description_sale | Long description (Sales tab – secondary language) |
| main_supplier_base_cost | Associated main vendor cost (base currency) |
| main_supplier_contact_category_id | Associated main vendor contact category ID |
| main_supplier_contact_code | Associated main vendor contact code |
| main_supplier_contact_company_name | Associated main vendor company name |
| main_supplier_contact_contact_type | Associated main vendor contact type |
| main_supplier_contact_display_name | Associated main vendor name |
| main_supplier_contact_external_id | Associated main vendor contact external ID |
| main_supplier_contact_id | Associated main vendor contact ID |
| main_supplier_contact_is_portal_enabled | Vendor Zoho portal access enabled |
| main_supplier_contact_language | Associated main vendor contact language |
| main_supplier_contact_markup | Associated main vendor contact markup |
| main_supplier_contact_notes | Associated main vendor contact notes |
| main_supplier_contact_owner_id | Associated main vendor contact owner ID |
| main_supplier_contact_payment_terms | Associated main vendor contact payment term |
| main_supplier_contact_price_list_id | Associated main vendor contact price list ID |
| main_supplier_contact_tax_id | Associated main vendor contact tax ID |
| main_supplier_contact_website | Associated main vendor contact website |
| main_supplier_contact_woo_commerce_contact_id | Associated main vendor contact WooCommerce contact ID |
| main_supplier_contact_zoho_books_contact_id | Associated item main vendor contact Zoho Books contact ID |
| main_supplier_contact_zoho_books_tax_id | Associated main vendor contact Zoho Books tax ID |
| main_supplier_contact_zoho_crm_account_id | Associated main vendor contact Zoho CRM account ID |
| main_supplier_conversion_factor | Associated main vendor conversion factor |
| main_supplier_currency_currency_code | Associated main vendor currency code |
| main_supplier_currency_currency_format | Associated main vendor currency format |
| main_supplier_currency_currency_name | Associated main vendor currency name |
| main_supplier_currency_currency_symbol | Associated main vendor currency symbol |
| main_supplier_currency_effective_date | Associated main vendor exchange rate effective date |
| main_supplier_currency_exchange_rate | Associated main vendor currency exchange rate |
| main_supplier_currency_external_id | Associated main vendor currency external ID |
| main_supplier_currency_id | Associated main vendor currency ID |
| main_supplier_currency_is_base_currency | Is the currency of the associated primary vendor the base currency? |
| main_supplier_currency_price_precision | Associated main vendor currency price precision |
| main_supplier_custom_unit | Associated main vendor custom unit |
| main_supplier_description | Associated main vendor description |
| main_supplier_discount | Associated main vendor discount |
| main_supplier_id | Associated main vendor ID |
| main_supplier_list_price | Associated main vendor list price |
| main_supplier_minimum_order_qty | Associated main vendor minimum order quantity |
| main_supplier_notes | Associated main vendor notes |
| main_supplier_part_number | Associated main vendor part number |
| main_supplier_purchase_increment | Associated main vendor purchase increment |
| main_supplier_purchasing_lead_time | Associated main vendor purchasing lead time |
| main_supplier_purchasing_lead_time_unit | Associated main vendor purchasing lead time unit |
| main_supplier_ranking | Associated main vendor ranking |
| main_supplier_unit_cost | Associated main vendor unit cost |
| manufacturer | Manufacturer |
| manufacturing_order_comment_count | Associated manufacturing order comment count |
| manufacturing_order_external_id | Associated manufacturing order external ID |
| manufacturing_order_formated_number | Associated manufacturing order formatted number |
| manufacturing_order_icon_filename | Associated manufacturing order icon file name |
| manufacturing_order_icon_label | Associated manufacturing order icon label |
| manufacturing_order_id | Associated manufacturing order ID |
| manufacturing_order_income_account_id | Associated manufacturing order income account ID |
| manufacturing_order_instructions | Associated manufacturing order instructions |
| manufacturing_order_is_gross_or_net | Is the associated manufacturing order gross or net? |
| manufacturing_order_is_net_consumption | For consumption: true = net, false = gross |
| manufacturing_order_number | Associated manufacturing order number |
| manufacturing_order_on_net_update_production | If true: update inventory production on card net weight change |
| manufacturing_order_output_behaviour_type | Inventory production behavior type |
| manufacturing_order_output_end_step_id | Inventory production end step ID |
| manufacturing_order_output_end_step_rank | Inventory production end step rank |
| manufacturing_order_output_end_vs_id | Inventory production end value stream ID |
| manufacturing_order_output_end_vs_rank | Inventory production end value stream rank |
| manufacturing_order_output_id | Inventory production ID |
| manufacturing_order_output_inventory_id | Inventory production target inventory ID |
| manufacturing_order_output_is_auto_print | Is automatic printing enabled on inventory production? |
| manufacturing_order_output_is_mandatory | Is inventory production mandatory? |
| manufacturing_order_output_is_target_inventory | Inventory production target inventory |
| manufacturing_order_output_item_step_id | ID of the association between the item and the inventory production step |
| manufacturing_order_output_measure | Inventory production measure |
| manufacturing_order_output_measure_unit | Inventory production measure unit |
| manufacturing_order_output_print_label_id | Inventory production print label ID |
| manufacturing_order_output_print_quantity | Inventory production print quantity |
| manufacturing_order_output_private_tag | Inventory production private tag |
| manufacturing_order_output_produced | Associated manufacturing order output produced |
| manufacturing_order_part_number | Associated manufacturing order part number |
| manufacturing_order_promised_date | Associated manufacturing order promised date |
| manufacturing_order_promised_delay | Associated manufacturing order promised delay |
| manufacturing_order_promised_delay_unit | Associated manufacturing order promised delay unit |
| manufacturing_order_revision | Associated manufacturing order revision |
| manufacturing_order_secondary_title | Associated manufacturing order name (secondary language) |
| manufacturing_order_sku | Associated manufacturing order SKU |
| manufacturing_order_tag | Associated manufacturing order tag |
| manufacturing_order_tare_type_id | Associated manufacturing order tare type ID |
| manufacturing_order_title | Associated manufacturing order name (primary language) |
| manufacturing_order_treatment | Associated manufacturing order treatment |
| manufacturing_order_trimmed_instructions | Associated manufacturing order trimmed instructions |
| manufacturing_order_type | Associated manufacturing order type |
| manufacturing_order_weight_gross | Associated manufacturing order weight gross |
| manufacturing_order_weight_gross_unit | Associated manufacturing order weight gross unit |
| manufacturing_order_weight_net | Associated manufacturing order weight net |
| manufacturing_order_weight_net_unit | Associated manufacturing order weight net unit |
| manufacturing_order_weight_tare | Associated manufacturing order weight tare |
| manufacturing_order_weight_tare_unit | Associated manufacturing order weight tare unit |
| material_code | Material code |
| material_id | Material ID |
| material_private_tag | Material private tag |
| material_title | Material title |
| measure_unit | Measure unit |
| min_selling_measure | Minimum selling quantity |
| modified_by | Modified by |
| modified_by_id | Modifier ID |
| modified_date | Date modified |
| output_aggregate_count | Planned outputs count |
| part_number | Part number |
| pending_measure_inventory_sum | Pending production quantity |
| planned_target_inventory_id | Planned target inventory ID |
| planned_unit_cost | Planned unit cost |
| plannedConsumption_aggregate_count | Planned consumption count |
| private_tag | Item private tag |
| prompt_extra_consignment | Prompt extra consignment |
| raw_id | Associated raw ID |
| raw_imperial_title | Associated raw imperial title |
| raw_metric_title | Associated raw metric title |
| raw_private_tag | Associated raw private tag |
| revision | Revision |
| sales_customer_id | Associated customer ID |
| sales_price_compute_mode | Sales price computation mode |
| secondary_description | Description (secondary language) |
| selling_unit | Selling unit |
| serial_number | Serial number |
| sku | SKU |
| status | Status |
| surface_unit | Surface unit |
| tare_type_id | Tare type ID |
| target_inventory_mandatory | Is target inventory mandatory? |
| template_title | Item title |
| total_measure_inventory_sum | Total ready stock quantity |
| total_measure_inventory_total_cost | Total ready stock cost |
| treatment_code | Treatment code |
| treatment_id | Treatment ID |
| treatment_private_tag | Treatment private tag |
| treatment_title | Treatment title |
| trimmed_instructions | Trimmed instructions |
| type | Item type |
| unit_selling_price | Unit selling price |
| unit_surface | Unit surface |
| unit_volume | Unit volume |
| unit_weight | Unit weight |
| united_nations_number | UN number |
| united_nations_number_id | UN number ID |
| united_nations_number_packing_group | UN packing group |
| united_nations_number_primary_hazard_class | Hazard class (primary language) |
| united_nations_number_primary_proper_shipping_name | Proper shipping name (primary language) |
| united_nations_number_secondary_hazard_class | Hazard class (secondary language) |
| united_nations_number_secondary_proper_shipping_name | Proper shipping name (secondary language) |
| upc | UPC code |
| update_item_on_purchase_order_issue | Update item unit costs on purchase order issue |
| volume_unit | Volume unit |
| weight_unit | Weight unit |
* Difference between measures and converted measures #
Measures: all measures are saved in the ALIX database under the same units of measure.
- Weight: gram
- Length: mm
- Surface: square millimeter
- Volume: cubic millimeter
Converted measure: measure in the unit of measure you set in ALIX for this item.
More documentation on analytic tables to come…