f_asset_inventory

f_asset_inventory

Purpose

  1. Tracks inventory of assets, including quantities and locations.

Relationships


  • v_equipment: One-to-Many (1:N)

    • One inventory record can have many equipment items

    • Referenced through asset_type_code

  • v_apparatus: One-to-Many (1:N)

    • One inventory record can have many apparatus

    • Referenced through asset_type_code




Table


Column

Type

Description

client_code

varchar

Organization identifier

asset_type_code

varchar

Asset type

location

varchar

Asset location

sub_location

varchar

Sub-location

item_name

varchar

Item name

quantity

integer

Quantity

min_quantity

integer

Minimum quantity

max_quantity

integer

Maximum quantity

description

varchar

Description

sku

varchar

SKU

package_type

varchar

Package type

vendor_name

varchar

Vendor name

expiration_date

date

Expiration date




    • Related Articles

    • Inventory: Bulk Importing Inventory

      Purpose To provide instructions for importing multiple items of inventory using the inventory import template. The Sample CSV template is attached to the bottom of this article. The MOST recent CSV Spreadsheet is always available for download from ...

    • Inventory Usage and Restock - Request Feature

      Purpose The purpose of this article is to demonstrate how to utilize the Request feature within Inventory Usage and Restock for Apparatus, Stations and Kits. This article covers submitting a request the Inventory Usage and Restock section within the ...

    • Inventory Usage and Restock - Request Feature

      Purpose The purpose of this article is to demonstrate how to utilize the Request feature within Inventory Usage and Restock for Apparatus, Stations and Kits. This article covers submitting a request the Inventory Usage and Restock section within the ...

    • Inventory Usage and Restock - Request Feature

      Purpose The purpose of this article is to demonstrate how to utilize the Request feature within Inventory Usage and Restock for Apparatus, Stations and Kits. This article covers submitting a request the Inventory Usage and Restock section within the ...

    • Inventory Management: Global Restock - General Navigation and Fulfilling Requests

      Purpose The purpose of this article is to demonstrate the general navigation and actions of the Global Restock page in Inventory Management. Related Articles Inventory Management: Global Restock - Creating Custom Views Video Instruction 1. Select ...