What's the relation from the table ItemUnit to the table unitsTypeUom in suiteQL?

AI generated answer (using internal Slack threads):

In NetSuite, the

ItemUnit

table and the

unitsTypeUom

table are related through the concept of Units of Measure (UoM). The

ItemUnit

table holds the information about the units of measure that are used for an item. This includes the primary stock unit, primary purchase unit, and primary sale unit. On the other hand, the

unitsTypeUom

table holds the information about the different types of units of measure that are available in the system. This includes units like Each, Bag, Pack, Case, etc. The relation between these two tables is established when an item is created or updated. The units of measure that are assigned to the item in the

ItemUnit

table must be available in the

unitsTypeUom

table. For example, if an item has a primary stock unit of 'Each', then 'Each' must be a unit of measure type in the

unitsTypeUom

table. In terms of SuiteQL, you would typically join these two tables on the unit type field to get a complete picture of the units of measure for an item. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******