Index of analytic tables

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_basic_view

Customer and vendor information

contact_person_full_name	Contact person full name
contact_person_id	Contact person ID
contact_person_is_invoice	Is a billing contact
contact_person_last_name	Contact person last name
contact_person_mobile	Contact person mobile
contact_person_phone	Contact person phone number
contact_price_list_id	Contact price list ID
contact_tax_id_number	Contact tax ID number
contact_type	Contact type (customer, vendor, etc.)
contact_website	Contact website
currency_code	Currency code
currency_name	Currency name
currency_symbol	Currency symbol
display_name	Contact display name
invoice_recipient_behaviour	Invoice recipient behaviour
is_carrier	Is the contact a carrier?
payement_term	Payment term
payement_term_id	Payment term ID
payement_term_label	Payment term label
related_contact_id	Related contact ID (e.g. customer linked to a vendor)
shipping_address	Complete shipping address
shipping_address_attention	Attention of the shipping address
shipping_address_city	Shipping address city
shipping_address_country	Shipping address country
shipping_address_id	Shipping address ID
shipping_address_phone	Shipping address phone
shipping_address_state	Shipping address province
shipping_address_state_code	Shipping address province
shipping_address_street2	Additional address line
shipping_address_zip	Shipping address postal code
status	Contact status (active / inactive)
zoho_books_contact_id	Contact ID in Zoho Books

 

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
email	Email
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	Specific type of transaction (receipt, sale, production, etc.)
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	Order of dimensions
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
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	Specific type of transaction (receipt, sale, production, etc.)
planned_unit_cost	Planned unit cost
planning_type	Planning category for calculating net stock level (what we have + what comes in – what goes out)
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_production_view

Inventory production information

category_id	Associated category ID
category_title	Associated category title
cid	CID
converted_current_measure	Converted current measure *
converted_initial_measure	Converted initial measure *
created_by	Created by
created_by_id	Creator ID
created_date	Creation date
current_measure	Current measure
current_volume	Current volume
description	Description (primary language)
dimension_to_display	Quantity, weight, length, surface or volume
due_date	Due date
equipment_title	Name of the equipment used
exist	False : deleted, true : not deleted
expiration_date	Expiration date
gross_weight	Gross weight
id	Inventory ID
initial_measure	Initial measure
instructions	Instructions
inventory_project_formated_number	Associated project number as displayed in ALIX
inventory_project_id	Associated project ID
inventory_project_number	Associated project number
inventory_project_title	Project year + project number + project title
inventory_project_year	Project date
invoice_date	Invoice date
invoice_title	Invoice title
is_bin	Is the inventory a bin?
is_dropship	Is the inventory a dropshipping?
item_formatted_number	Formatted card number (3 digits)
item_id	Item ID
length_unit	Length unit
location	Location
location_code	Location code
location_id	Location ID
manufactured_by	Manufactured by
manufactured_by_id	Manufactured by ID
manufactured_date	Manufactured date
manufactured_equipment_id	ID of the equipment that produced the inventory
manufactured_ledger_id	Transaction ID that produced the inventory
manufactured_measure	Manufactured measure
manufacturer	Manufacturer
material_id	Material ID
measure_unit	Measure unit
modified_by	Modified by
modified_by_id	Modifier ID
modified_date	Modified date
part_number	Part number
planned_target_inventory_id	Planned target inventory ID
planned_unit_cost	Planned unit cost
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_year	Project date
raw_id	Raw ID
raw_imperial_title	Raw imperial title
raw_metric_title	Raw metric title
real_unit_cost	Real unit cost
receipt_title	Associated goods receipt title
received_date	Associated goods receipt date
return_date	Return date
return_number	Return number
revision	Revision
secondary_description	Description (secondary language)
serial_number	Serial number
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
tag	Tag
tare_unit	Tare unit
tare_weight	Tare
template_description	Associated item description (primary language)
template_ean	Associated item EAN
template_id	Associated item ID
template_secondary_description	Associated item description (secondary language)
template_sku	Associated item SKU
template_upc	Associated item UPC
treatment	Treatment
treatment_title	Treatment title
trimmed_instructions	Trimmed instructions
unit_weight	Unit weight
volume_unit	Volume unit
weight_input_is_gross_or_net	Is the weight entered gross or net?

 

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 (in second)
item_total_work_time	Time work time for the card (in second)
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_leadtime_view

Leadtime by steps

All fields from the item_basic_view view are also found in this view.

leadtime_cid	Leadtime CID
leadtime_datetime_in	Start date and time
leadtime_datetime_out	End date and time
leadtime_id	Leadtime ID
leadtime_is_first_time_good	True: no step was done more than once, false: a step has been done more than once
leadtime_leadtime_hours	Number of hours of leadtime
leadtime_leadtime_minutes	Number of minutes of leadtime
leadtime_leadtime_seconds	Number of seconds of leadtime
leadtime_move_in_by	Move in by
leadtime_move_out_by	Move out by
leadtime_step_title	Step 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 (in second)
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 (in second)
item_total_work_time	Card total work time (in second)
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 (in second)
planned_slot_id	Planned equipment ID
planned_slot_name	Planned equipment name
planned_worktime	Planned work time (in second)
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 (in second)

 

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 date
planned_type	Specific type of transaction (receipt, sale, production, etc.)
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

 

purchase_order_item_view

Purchase order line item informations

account_code	Associated account code
account_external_id	Associated account external ID
account_id	Associated account ID
account_name	Associated account name
billing_address_address	Billing address street
billing_address_attention	Billing address attention
billing_address_city	Billing address city
billing_address_country	Billing address country
billing_address_phone	Billing address phone
billing_address_state	Billing address province
billing_address_street2	Billing address street 2
billing_address_zip	Billing address postal code
category_title	Associated item category name
cid	CID
company_name	Vendor company name
contact_person_email	Contact person email
contact_person_first_name	Contact person first name
contact_person_last_name	Contact person last name
contact_person_phone	Contact person phone
converted_po_item_cost	Item converted cost *
converted_po_item_measure	Item converted measure *
currency_code	Currency code
currency_symbol	Currency symbol
dropship_client_company_name	Drop shipping customer company name
dropship_client_display_name	Drop shipping customer name
material_title	Associated item material title
plant_name	Associated site name
po_created_by	Purchase order created by
po_created_by_id	Purchase order creator ID
po_created_date	Purchase order creation date
po_expected_delivery_date	Purchase order expected delivery date
po_is_dropship	Is the order drop shipping?
po_is_supplier_pickup	Will the order be picked up at the supplier?
po_item_billed_bypassed	Is the purchase order line marked as billed?
po_item_billed_count	Purchase order line item total measure billed
po_item_contract_number	Purchase order line item contract number
po_item_conversion_factor	Conversion factor
po_item_cost	Purchase order line item cost
po_item_created_by	Purchase order line item created by
po_item_created_by_id	Purchase order line item creator ID
po_item_created_date	Purchase order line item creation date
po_item_discount	Purchase order line discount
po_item_exist	False: deleted, true: not deleted
po_item_expected_delivery_date	Purchase order line item expected delivery date
po_item_id	Purchase order line item ID
po_item_measure	Purchase order line item measurement
po_item_modified_by	Purchase order line item modified by
po_item_modified_by_id	Purchase order line item modifier ID
po_item_modified_date	Purchase order line item modified date
po_item_name	Purchase order line item associated item description
po_item_notes	Purchase order line item associated notes
po_item_overwritten_name	Purchase order line item manual description (if different from the item)
po_item_overwritten_notes	Purchase order line item manual notes (if different from the item)
po_item_primary_name	Purchase order line item description (primary language)
po_item_primary_notes	Purchase order line item notes (primary language)
po_item_received_bypassed	Is the purchase order line marked as received?
po_item_received_count	Purchase order line item total measure received
po_item_secondary_name	Purchase order line item description (secondary language)
po_item_secondary_notes	Purchase order line item notes (secondary language)
po_item_supplier_part_number	Purchase order line item vendor part number
po_item_template_id	Purchase order line item associated item ID
po_item_unit	Purchase order line item measure unit
po_item_unit_cost_without_discount	Purchase order line item undiscounted measure unit
po_modified_by	Purchase order modified by
po_modified_by_id	Purchase order modifier ID
po_modified_date	Purchase order modification date
po_name	Purchase order PO number
po_notes	Purchase order notes
po_order_date	Purchase order date
po_project_id	Purchase order associated project ID
po_receiving_status	Purchase order receipt status
po_reference_number	Purchase order reference number
po_shipment_preference	Purchase order shipment preference
po_status_status	Purchase order status
po_terms_and_conditions	Purchase order terms and conditions
purchase_order_id	Purchase order ID
rank	Purchase order line item rank
raw_imperial_title	Associated item raw imperial title
raw_metric_title	Associated item raw metric title
resource_first_name	Associated talent first name
resource_last_name	Associated talent last name
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_street2	Shipping address street 2
shipping_address_zip	Shipping address postal code
supplier_billing_address_address	Vendor billing address street
supplier_billing_address_attention	Vendor billing address attention
supplier_billing_address_city	Vendor billing address city
supplier_billing_address_country	Vendor billing address country
supplier_billing_address_phone	Vendor billing address phone
supplier_billing_address_state	Vendor billing address province
supplier_billing_address_street2	Vendor billing address street 2
supplier_billing_address_zip	Vendor billing address postal code
supplier_contact_company_name	Vendor company name
supplier_contact_display_name	Vendor name
supplier_contact_language	Vendor language
supplier_shipping_address_address	Vendor shipping address street
supplier_shipping_address_attention	Vendor shipping address attention
supplier_shipping_address_city	Vendor shipping address city
supplier_shipping_address_country	Vendor shipping address country
supplier_shipping_address_phone	Vendor shipping address phone
supplier_shipping_address_state	Vendor shipping address state
supplier_shipping_address_street2	Vendor shipping address street 2
supplier_shipping_address_zip	Vendor shipping address postal code
template_description	Purchase order line item associated item description (primary language)
template_dimension	Purchase order line item associated item dimension
template_is_taxed	Is the associated item taxable?
template_is_using_supplier_part_number	Is the part number from the purchase order used on the inventory?
template_manufacturer	Purchase order line item associated item vendor
template_moq	Purchase order line item associated item minimum order quantity
template_part_number	Purchase order line item associated item part number
template_purchase_increment	Purchase order line item associated item purchase increment
template_revision	Purchase order line item associated item revision
template_secondary_description	Purchase order line item associated item description (secondary language)
template_sku	Purchase order line item associated item SKU
template_unit	Purchase order line item associated item unit of measure
template_unit_cost	Purchase order line item associated item unit cost
treatment_title	Purchase order line item associated item treatment_title

 

reception_item_view

List of goods receipt  line items

cid	CID
consignment_item_id	Associated consignment line item ID
created_by	Created by
created_by_id	Creator ID
created_date	Creation date
exist	False : deleted, true : not deleted
id	ID
inventory_description	Inventory description
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_id	Inventory location ID
inventory_part_number	Inventory part number
inventory_planned_target_inventory_id	Inventory planned target inventory ID
inventory_planned_target_inventory_tag	Inventory planned target inventory tag
inventory_plant_id	Inventory associated site ID
inventory_project_id	Inventory associated project ID
inventory_revision	Inventory revision
inventory_secondary_description	Inventory description (secondary language)
inventory_serial_number	Inventory serial number
inventory_status	Inventory status
inventory_supplier_part_number	Inventory vendor part number
inventory_tag	Inventory tag
inventory_weight_unit	Inventory weight unit
is_partial	Is the receipt partial?
location_code	Location code
location_title	Location name
measure	Measure
modified_by	Modified by
modified_by_id	Modifier ID
modified_date	Date modified
partial_value_raw	Raw partial goods receipt value
planned_ledger_id	Associated planned transaction ID
planned_ledger_partial_receipt_id	Associated planned transaction partial receipt ID
planned_ledger_planned_measure	Associated planned transaction planned measure
purchase_order_item_id	Associated purchase order line item ID
reception_carrier	Associated goods receipt carrier
reception_checklist_id	Associated goods receipt checklist ID
reception_driver	Associated goods receipt driver
reception_id	Associated goods receipt ID
reception_invoice_reference	Associated goods receipt invoice reference number
reception_is_apply_weight_on_unique_inventory	Apply weight on a single inventory?
reception_name	Associated goods receipt name
reception_notes	Associated goods receipt notes
reception_plant_id	Associated goods receipt site ID
reception_receipt_datetime	Goods receipt date and time
reception_receipt_posting_date	Goods receipt posting date
reception_status	Associated goods receipt status
tare_type_id	Associated tare type ID
tare_unit	Tare unit
tare_weight	Tare
template_id	Associated item ID
template_sku	Associated item SKU
template_target_inventory_mandatory	Is inventory production mandatory for the associated item?
unit_weight	Unit weight
vendor_display_name	Vendor name
vendor_language	Vendor language
weight_input_is_gross_or_net	Is the weight entered gross or net?

 

reception_view

Goods receipt list

carrier	Carrier name
checklist_id	Associated checklist ID
cid	CID
config	Configuration type
created_by	Created by
created_by_id	Creator ID
created_date	Creation date
display_gross_register_created_by	Displayed gross scale reading created by
display_gross_register_created_by_id	Displayed gross scale reading creator ID
display_gross_register_end	Displayed gross scale reading end
display_gross_register_id	Displayed gross scale reading ID
display_gross_register_measure	Displayed gross scale reading measure
display_gross_register_name	Displayed gross scale reading name
display_gross_register_reading_date	Displayed gross scale reading date
display_gross_register_start	Displayed gross scale reading start
display_net_register_created_by	Displayed net scale reading created by
display_net_register_created_by_id	Displayed net scale reading creator ID
display_net_register_end	Displayed net scale reading end
display_net_register_id	Displayed net scale reading ID
display_net_register_measure	Displayed net scale reading measure
display_net_register_name	Displayed net scale reading name
display_net_register_reading_date	Displayed net scale reading date
display_net_register_start	Displayed net scale reading start
display_tare_register_created_by	Displayed tare scale reading created by
display_tare_register_created_by_id	Displayed tare scale reading creator ID
display_tare_register_end	Displayed tare scale reading end
display_tare_register_id	Displayed tare scale reading ID
display_tare_register_measure	Displayed tare scale reading measure
display_tare_register_name	Displayed tare scale reading name
display_tare_register_reading_date	Displayed tare scale reading date
display_tare_register_start	Displayed tare scale reading start
driver	Driver
emailing_details	Email sending details
exist	False : deleted, true : not deleted
gross_is_calculated	Is the gross weight calculated?
gross_is_manual	Is the gross weight entered manually?
gross_weight_manual_reading_register_id	Manual gross weight scale reading ID
gross_weight_reading_register_id	Gross weight scale reading ID
id	ID
invoice_reference	Associated invoice reference number
is_apply_weight_on_unique_inventory	Apply weight on a single inventory?
is_print_on_receive	Print label on receipt?
is_show_weighings_section	Show the weighing section?
modified_by	Modified by
modified_by_id	Modifier ID
modified_date	Date modified
name	Name
net_is_calculated	Is the net weight calculated?
net_is_manual	Is the net weight entered manually?
net_weight_manual_reading_register_id	Manual net weight scale reading ID
net_weight_reading_register_id	Net weight scale reading ID
notes	Notes
old_scale_gross_register_created_by	Legacy IIoT gross scale reading created by
old_scale_gross_register_created_by_id	Legacy IIoT gross scale reading creator ID
old_scale_gross_register_id	Legacy IIoT gross scale reading ID
old_scale_gross_register_measure	Legacy IIoT gross scale reading measure
old_scale_gross_register_name	Legacy IIoT gross scale reading name
old_scale_gross_register_reading_date	Legacy IIoT gross scale reading date
old_scale_net_register_created_by	Legacy IIoT net scale reading created by
old_scale_net_register_created_by_id	Legacy IIoT net scale reading creator ID
old_scale_net_register_id	Legacy IIoT net scale reading ID
old_scale_net_register_measure	Legacy IIoT net scale reading measure
old_scale_net_register_name	Legacy IIoT net scale reading name
old_scale_net_register_reading_date	Legacy IIoT net scale reading date
old_scale_tare_register_created_by	Legacy IIoT tare scale reading created by
old_scale_tare_register_created_by_id	Legacy IIoT tare scale reading creator ID
old_scale_tare_register_id	Legacy IIoT tare scale reading ID
old_scale_tare_register_measure	Legacy IIoT tare scale reading measure
old_scale_tare_register_name	Legacy IIoT tare scale reading name
old_scale_tare_register_reading_date	Legacy IIoT tare scale reading date
planned_receipt_posting_date	Planned goods receipt posting date
plant_id	Associated site ID
receipt_datetime	Goods receipt date and time
receipt_posting_date	Goods receipt posting date
status	Status
tare_is_calculated	Is the tare weight calculated?
tare_is_manual	Is the tare weight entered manually?
tare_weight_manual_reading_register_id	Manual tare weight scale reading ID
tare_weight_reading_register_id	Tare weight scale reading ID
vendor_company_name	Vendor company name
vendor_default_billing_address_address	Vendor default billing address street
vendor_default_billing_address_attention	Vendor default billing address attention
vendor_default_billing_address_city	Vendor default billing address city
vendor_default_billing_address_country	Vendor default billing address country
vendor_default_billing_address_external_id	Vendor default billing address external ID
vendor_default_billing_address_fax	Vendor default billing address fax
vendor_default_billing_address_id	Vendor default billing address ID
vendor_default_billing_address_phone	Vendor default billing address phone
vendor_default_billing_address_state	Vendor default billing address province
vendor_default_billing_address_state_code	Vendor default billing address province code
vendor_default_billing_address_street2	Vendor default billing address street 2
vendor_default_billing_address_zip	Vendor default billing address postal code
vendor_default_billing_address_zoho_books_address_id	Vendor default billing address Zoho Books ID
vendor_default_checklist_id	Vendor default checklist ID
vendor_id	Vendor ID
vendor_language	Vendor language
vendor_main_person_email	Vendor primary contact email
vendor_name	Vendor name
weight_input_is_gross_or_net	Is the weight entered gross or net?

 

 

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	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	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

 

step_view

Information of the steps in the value streams

cid	CID
color	Step color
created_by	Step created by
created_by_id	Creator ID
created_date	Creation date
default_card_tab	Opening tab of a card in this step
equipment_cost_rate	Hourly rate cost equipment
exist	False: deleted, true: not deleted
id	ID
is_inspection	Is the step an inspection step?
is_max_eq_time_lock	Does the step become locked when the equipment value is exceeded?
is_max_nb_items_lock	Does the step become locked when the max number of cards is exceeded?
is_max_res_time_lock	Does the step become locked when the talent value is exceeded?
is_open_on_move	Does the card open when moving in the step?
is_pacemaker	Is the step the pacemaker of the production line?
is_rework	Is the step a quarantine step ?
is_sort_locked	Is the choice of sorting locked in the column?
is_validation	Does the step check that the consuptions are all done?
ismanualranking	Can the steps cards be moved in the column?
isshipment	Is the step a shipping step?
iswip	Is the step a waiting step?
isworktimeauto	Is the working time automatic?
max_eq_time	Maximum equipment time allowed
max_eq_time_unit	Unit of measure for maximum equipment time
max_nb_items	Maximum number of cards allowed
max_res_time	Maximum working time allowed
max_res_time_unit	Unit of measure for maximum working time
modified_by	Modified by
modified_by_id	Modifier ID
modified_date	Date modified
rank	Rank in the value stream
resource_cost_rate	Hourly rate cost talent
sellingprice_equipement	Hourly rate selling equipment
sellingprice_ressources	Hourly rate selling talent
slot_wipof_id	Equipment ID on which the step is pending
sort_direction	Column sorting direction
sort_type	Column sorting type
stepcode	Code
stepid	Step ID
threshold_nb_items	Number of cards before alert
title	Title
vsid	Value stream ID
wipof	Waiting for

 

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…