Posts in: SQL

INV - Inventory On Hand

Retrieve on-hand inventory quantities for items filtered by item number and organization.

Retrieve details about subinventories, their types, locator control, and associated organizations.

Retrieve UOM classes, units, base flags, and conversions.

Retrieve cross-reference information for inventory items, including relationships, UOM, and descriptions.

Retrieve a summary count of ESS jobs by their state with human-readable status.