psdi.app.inventory

Interface InventorySetRemote

    • Field Detail

      • ITEM

        static final java.lang.String ITEM
        Relationship to the Item table, used to find the item for a given inventory record.
        (item.itemnum = inventory.itemnum)
        The resulting set will contain one object.
        See Also:
        Constant Field Values
      • ALTITEM

        static final java.lang.String ALTITEM
        Relationship to the AltItem table, used to find the alternative items for the item for a given Inventory record.
        (altitem.itemnum = inventory.itemnum)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVBALANCES

        static final java.lang.String INVBALANCES
        Relationship to the InvBalances table, used to find the on hand balances for a given inventory record.
        (invbalances.itemnum = inventory.itemnum and invbalances.location = inventory.location and invbalances.siteid = inventory.siteid)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVBALANCES_DEFAULT

        static final java.lang.String INVBALANCES_DEFAULT
        Relationship to the InvBalances table, used to find the balances on hand for a given inventory's default bin.
        (invbalances.itemnum = inventory.itemnum and invbalances.location = inventory.location and invbalances.binnum=inventory.binnum )
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • HOLDINGBALANCE

        static final java.lang.String HOLDINGBALANCE
        Relationship to the InvBalances table, used to find the balances in the holding location for a given inventory item.
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVBALANCES_NOREC

        static final java.lang.String INVBALANCES_NOREC
        Relationship to the InvBalances, used to find the unreconciled balances for a given inventory record.
        (invbalances.itemnum = inventory.itemnum and invbalances.location = inventory.location and invbalances.reconciled = no)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVTRANS

        static final java.lang.String INVTRANS
        Relationship to the InvTrans table, used to find the transactions for a given inventory record.
        (invtrans.itemnum = inventory.itemnum and invtrans.storeloc = inventory.location)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • MATUSETRANS

        static final java.lang.String MATUSETRANS
        Relationship to the MatUseTrans table, used to find the materials issues for a given inventory record.
        (matusetrans.itemnum = inventory.itemnum and matusetrans.storeloc = inventory.location)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVRESERVE

        static final java.lang.String INVRESERVE
        Relationship to the InvReserve table, used to find inventory reservations for a given inventory record.
        (invreserve.itemnum = inventory.itemnum and invreserve.location = inventory.location)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • LOCATIONS

        static final java.lang.String LOCATIONS
        Relationship to the Locations table, used to find the location for a given inventory record.
        (locations.location = inventory.location)
        The resulting set will contain one object.
        See Also:
        Constant Field Values
      • LOCATIONS_ADDTOSTORE

        static final java.lang.String LOCATIONS_ADDTOSTORE
        Relationship to the Locations table, used to find the location information for a given inventory record on column AddToStoreLoc.
        (locations.location = inventory.AddToStoreLoc)
        The resulting set will contain one object.

        Note: AddToStoreLoc is a non-persistent column for the Inventory object. See the attribute defined in Inventory for more information.
        This relationship is primarily used for the Add Item to Store action in the Item application.
        See Also:
        Constant Field Values
      • MATRECTRANS

        static final java.lang.String MATRECTRANS
        Relationship to the MatRecTrans table, used to find the receipts/transfers for a given inventory record.
        (matrectrans.itemnum = inventory.itemnum and matrectrans.tostoreloc = inventory.location)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVVENDOR_SQL

        static final java.lang.String INVVENDOR_SQL
        Relationship to the InvVendor table, used to find all item vendor records for a given Inventory record - SQLServer only.
        ( invendor.itemnum = inventory.itemnum
        and
        (((inventory.vendor != '' and (invendor.vendor=inventory.vendor)) or (inventory.vendor =''))
        and
        (((inventory.manufacturer !='') and (invendor.manufacturer=inventory.manufacturer)) or (inventory.manufacturer =''))
        and
        (((inventory.modelnum !='') and (invendor.modelnum=inventory.modelnum)) or (inventory.modelnum =''))
        and
        (((inventory.catalogcode !='') and (invendor.catalogcode=inventory.catalogcode)) or (inventory.catalogcode =''))) )
        The resulting set will contain zero or more objects.

        This relationship is primarily used by MEA to be used for SQLServer.
        See Also:
        Constant Field Values
      • INVVENDOR

        static final java.lang.String INVVENDOR
        Relationship to the InvVendor table, used to find all item vendor records for a given Inventory record.
        (invvendor.itemnum = inventory.itemnum)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVVENDOR_PRIMARY

        static final java.lang.String INVVENDOR_PRIMARY
        Relationship to the InvVendor table, used to find the Invvendor record that matches the vendor,modelnum, and manufacturer of the given Inventory record.
        (invvendor.itemnum = inventory.itemnum and invvendor.vendor=inventory.vendor
        and invvendor.manufacturer = inventory.manufacturer and invvendor.modelnum=inventory.modelnum )
        The resulting set will contain zero or one object.
        See Also:
        Constant Field Values
      • INVVENDOR_ORA

        static final java.lang.String INVVENDOR_ORA
        Relationship to the InvVendor table, used to find all item vendor records for a given Inventory record - ORACLE only.
        ( invendor.itemnum = inventory.itemnum
        and
        (((inventory.vendor is not null and (invendor.vendor=inventory.vendor)) or (inventory.vendor is null))
        and
        (((inventory.manufacturer is not null) and (invendor.manufacturer=inventory.manufacturer)) or (inventory.manufacturer is null))
        and
        (((inventory.modelnum is not null) and (invendor.modelnum=inventory.modelnum)) or (inventory.modelnum is null))
        and
        (((inventory.catalogcode is not null) and (invendor.catalogcode=inventory.catalogcode)) or (inventory.catalogcode is null))) )
        The resulting set will contain zero or more objects

        This relationship is primarily used by MEA to be used for ORACLE.
        See Also:
        Constant Field Values
      • INVENTORY

        static final java.lang.String INVENTORY
        Relationship to the Inventory table, used to find the same Inventory record for a given Inventory record.
        (inventory.itemnum = inventory.itemnum and inventory.location = inventory.location and inventory.siteid = inventory.siteid)
        The resulting set will contain one object.
        See Also:
        Constant Field Values
      • INVADJUSTMENT

        static final java.lang.String INVADJUSTMENT
        Relationship to the non-persistent InvAdjustment table.
        (invAdjustment.itemnum = inventory.itemnum and invAdjustment.location = inventory.location)
        The resulting set will contain zero objects.

        This relationship is used only for the Inventory Adjustment action pages on the Inventory application.
        See Also:
        Constant Field Values
      • ISSUECURRENTITEM

        static final java.lang.String ISSUECURRENTITEM
        Relationship to the non-persistent IssueCurrentItem table.
        (IssueCurrentItem.itemnum = inventory.itemnum and IssueCurrentItem.storeloc = inventory.location)
        The resulting set will contain zero objects.

        This relationship is used only for the Issue Current Item action page on the Inventory application.
        See Also:
        Constant Field Values
      • TRANSFERCURITEM

        static final java.lang.String TRANSFERCURITEM
        Relationship to the non-persistent TransferCurItem table.
        (TransferCurItem.itemnum = inventory.itemnum and TransferCurItem.storeloc = inventory.location)
        The resulting set will contain zero objects.

        This relationship is used only for the Transfer Current Item action page on the Inventory application.
        See Also:
        Constant Field Values
      • REORDERITEMS

        static final java.lang.String REORDERITEMS
        Relationship to the non-persistent ReorderItems table.
        (ReorderItems.storeloc = inventory.location)
        The resulting set will contain zero objects.

        This relationship is used only for the Reorder Items action page on the Inventory application.
        See Also:
        Constant Field Values
      • REORDERPAD

        static final java.lang.String REORDERPAD
        Relationship to the ReorderPad table, used to find the quantity and cost information for the item to be reordered for all its storerooms.
        (ReorderPad.Itemnum = inventory.Itemnum)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • ASSET

        static final java.lang.String ASSET
        Relationship to the Asset table, used to find the Inventory's rotating asset.
        (Inventory.itemnum = Asset.itemnum)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • INVLOT

        static final java.lang.String INVLOT
        Relationship to the InvLot table, used to find the InvLot record for a given Inventory record.
        (Inventory.lotnum = invlot.lotnum)
        The resulting set will contain zero or one object.

        LotNum is a non-persistent column for the Inventory object. See the attribute defined in Inventory for more information.
        See Also:
        Constant Field Values
      • SPAREPART

        static final java.lang.String SPAREPART
        Relationship to the Sparpart table, used to find all spare parts for the given Inventory record.
        (Inventory.itemnum = sparepart.itemnum)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values
      • VENDOR

        static final java.lang.String VENDOR
        Relationship to the Companies table, used to find the primary vendor for the given Inventory record.
        (Inventory.vendor = Companies.company)
        The resulting set will contain zero or one object.
        See Also:
        Constant Field Values
      • MANUFACTURER

        static final java.lang.String MANUFACTURER
        Relationship to the Companies table, used to find the manufacturer for a given Inventory record.
        (Inventory.manufacturer = Companies.company)
        The resulting set will contain zero or one object.
        See Also:
        Constant Field Values
      • DOCLINKS

        static final java.lang.String DOCLINKS
        Relationship to the Doclinks table, used to find all documents for a given item.
        (doclinks.keytable = 'ITEM' and doclinks.keycolumn = 'ITEMNUM' and doclinks.keyvalue = item.itemnum).
        The resulting set will contain zero or more objects.

        Note: The Item.ItemNum field value will be formatted to match the DocLinks.KeyValue data type.
        See Also:
        Constant Field Values
      • WHEREUSED

        static final java.lang.String WHEREUSED
        Relationship to the WhereUsed table, used to find the items in the virtual WhereUsed table for a given item.
        (Inventory.itemnum = Whereused.assetnum)
        The resulting set will contain zero or more objects.
        See Also:
        Constant Field Values