Follow

06.11.02. ENGINE: Custom Reporting Module Term List

    FIELD NAME DESCRIPTION VALUES
BULK ITEMS    
  Bulk Items    
    Bulk Name: Manually entered item name in your bulk inventory  
    Cost: based off of inventory cost settings  
    Cost UOM: Units of measure based off of inventory cost settings LB / - / OZ / GR
    Is Medicated: Indicates if the bulk item is marked as a medicated item Boolean; 1 / 0 / - (1 =yes / 0 = no )
    Category ID: yeah, its like a nid look in the web address while in the cateogry there's anumber in there its the id  
    Category Name: The Bulk Category (created in customized lists) assigned to this bulk item.  
    Location Name: based on your location drop down where that item is located Grow Tracker / MixTracker / GramTracker
    Is Active (Y/N): Indicates if the bulk item is active inventory or inactive inventory. Boolean; Yes / No
  Bulk Vendors    
    Vendor Name: Vendor/supplier assigned when bulk item was created.  
    License Number: Vendor/supplier assigned when bulk item was created license # in your MJ Freeway Site.  
  Inventory Levels    
    Current Level: Current Inventory Level of the bulk item  
    Current Level UOM: Unit of measure for the Current Level of inventory of the bulk item  
    Current Level (GR): The current Level of the inventory bulk item in Grams. GR
         
EMPLOYEES    
  Employees    
    User Name: The User's assigned Username under Manage Users  
    Mail: User's email address; based on user set up  
    Is Active (Y/N): Indicated if the user is active in your MJ Freeway Site N / Y
    Status:   0 / 1
    First Name: User's First name under Manage Users; based on user set up  
    Middle Initial: User's Middle initial under Manage Users; based on user set up  
    Last Name: User's Last Name under Manage Users; based on user set up  
    Country: User's country in which they reside; based on user set up  
    Providence: User's providence if applicable; based on user set up  
    City: based on user set up  
    Street: based on user set up  
    Additional: based on user set up  
    Zip Code: based on user set up  
    Phone Number: based on user set up  
    Initials: based on user set up  
    MMJ License Number: based on user set up  
    User ID: manually created unique identifier for user based on user set up  
    Location ID: unique identifier based on the location in your drop down  
    Location Name: the location in your dropdown  
  Timeclock Approvals:    
    Employee ID: unique user identifier  
    Employee Username: manually created unique identifier for user based on user set up  
    Timesheet ID: unique numerical identifier  
    Timesheet Day: giving me a blank  
    Estimated Hours: user based calculation of hours entered for that employee  
    Approved hours: user based calculation of hours entered for that employee  
    Approved:   Boolean / - / 1 /
    Approver Username: unique identifier  
  Timeclock Punches    
    Punch ID: unique identifier  
    Employee ID: #  
    Employee Name The User's assigned Username under Manage Users; based upon user setup  
    Punch Type:   / CLOCK_IN / CLOCK_OUT / BREAK_START / BREAK_END
    Timestamp: Unix Timestamp  
    Processed:   Boolean / - / 1 / 0
    Punch – Date only: giving me a blank  
    Punch – Time only: giving me a blank  
         
GROW BATCHES    
  Batches    
    Batch ID: unique identifier  
    Batch Name: The unique batch ID assigned  
    Batch Strain ID: unique identifier created on the back end  
    Strain Name: Denotes the strain contained in this batch  
    Created Timestamp: Unix timestamp  
    First plant add timestamp: Unix timestamp  
    Last plant add timestamp: Unix timestamp  
    Batch Finished:   Boolean; 1 / 0 / - (1 =yes / 0 = no )
    Finished Time: Unix timestamp  
    Batch Complete:   Boolean; 1 / 0 / - (1 =yes / 0 = no )
    Wet Weigh Complete: based on batch details Boolean; 1 / 0 / - (1 =yes / 0 = no )
    Wet Weigh Unfinished: based on batch packages  
    Wet Weigh Byproduct: based on batch packages  
    Wet Weigh Waste: based on batch packages  
    Location Name: the location in your dropdown  
    Created Date:   YYYY-MM-DD
    First Plant Add Date:   YYYY-MM-DD
    Last Plant Add Date:   YYYY-MM-DD
    Finished Date:   YYYY-MM-DD
    Batch Cost: based off of inventory cost settings  
  Batch Plants    
    Plant ID: The unique plant ID assigned to this plant  
  Batch Packages      
    Package ID: unique package identifier for labels; manually entered or autogenerated  
    Package Code: unique identifier  
    Package Type:   finished / waste / byproduct / -
    Package Qty: based on package distribution  
    Prepack Description: based on the units of prepacks allocated for that package  
    Weight: includes total weight of package including packaging  
    Weight UOM: unit of measure for the package including packaging GR /
    Net Weight (GR): The batch net weight in grams GR /
    Package Weight: the batch gross weight  
    Package Weight UOM:   LB / GR / - /
    Distribution Status:    1 / 0 / - /
    Distribution NID: Node ID  
    Current Cost: based off of inventory cost settings  
    Received Cost: based off of inventory cost settings  
    Batch ID: unique identifier associated with that batch in the package  
  Additional Weigh Points      
    Weigh Point: refers to the batch weight details based on terms for grow weigh points in grow customized lists
    Unfinished Weight: refers to the batch weight details  
    Byproduct Weight: refers to the batch weight details  
    Waste Weight: refers to the batch weight details  
    Waste Weight: refers to the batch weight details  
    Weigh UOM refers to the batch weight details unit of measurements GR / - /
  Individual Batch Weighs      
    Weigh point Name:   wet / packaging / cure 1 / cure / trim in / trim out / dry
    Weigh Type:   unfinished / byproduct / waste / finished
    Weigh Subtype:   / - / Grade A
    Weight: batch weight within that package  
    Weight UOM:   LB / GR / - /
    Assigned To: blank  
    Weigh Timestamp: Unix timestamp  
    Weigh Date:   YYYY-MM-DD
    Weigh Time:   HH:MM:SS in military time
GROW CONSUMABLES    
  NONE    
GROW PLANTS    
  Plants    
    Location Name: This indicates the location in the dropdown that plant is in. dropdown
    Plant ID: References the ID given to the plant in Manage Plants  
    Is Active (Y/N): Is the plant active / living Boolean; Y / N
    Strain: From the strains in your grow, which strain this plant is.  
    Grow Location: Indicates the physical current location of this plant  
    Stage: Refers to the stage in life this plant is existing  
    Plant Group: manually entered note  
    Is Mother: Checkbox when you create the plant to denote if it’s a mother Boolean; 1 / 0 / - (1 =yes / 0 = no )
    Mother: Indicates the plant ID for the mother of this plant.  
    Patient Number: based on creating plants information  
    Batch ID: batch associated with this plant if applicable  
    Batch Name: batch name associated plant if applicable  
    Plant Cost: The amount it costs to produce this plant.  
    Created: giving me a blank  
    Month Day:   YYYY-MM
  Plant Modification History    
    Field Updated: the modified field for the plant  
    User Name: the unique identifier of who created the plant modification  
    Modification Date Only:   YYYY-MM-DD
    Value Before: plant field before modification  
    Value After: plant field after modification  
INVENTORY    
  Inventory Levels    
    Inventory Item Name:  All the items you have in your MJ Freeway Inventory  
    Inventory Item Type:   inventory / product
    Current Level:   Transactional based
    Current Level UOM:   OZ / EA
    Current Level (EA): Current level of inventory item for each unit based item  
    Current Level (OZ): current level of inventory item in ounces  
    Current Level (GR): current level of inventory item in gram  
    Inventory Variant: Pricing weight, i.e. gram, 1/8th, 1/2, etc.  
    Variant Name: Pricing weight name  
    Location Name: location in your dropdown  
    Last Cost: based on inventory settings  
    Avg Year Cost: transactional based on inventory settings  
    Calculated Cost: based off of inventory cost settings  
    Is Active (Y/N):   Y / N
    MIP Flag: Based on your inventory cost settings for edibles in MMJ Maximum  
  Inventory Transactions    
    Notes: anything you manually enter into an adjusted note field  
    Type:   Manual / Sale / PO / Restock / Convert / Reconcile / WS_Sale
    Transacted Amt: quantity Transactional based
    Transacted Amt Uom: the unit of measure for that transacted amount Transactional based
    Transacted Amt (OZ): transacted amount in grams Transactional based
    Transacted Amt (GR): if applicable  
    Inv Level After: decimal or whole number Transactional based
    Inventory Level After (GR): transactional based in grams  
    Inventory Package ID: unique package id associated with that item  
    User Name: unique identifier of user in your system  
    Transaction Timestamp: Unix Timestamp  
    Transaction Date Only:   YYYY-MM-DD
    Transaction Time Only:   HH:MM:SS in military time
    Transaction ID: unique numerical identifier  
    Transaction Description: where does this come from?  
    Reason: inventory adjustment reason if applicable in customized lists  
    Title: bulk or simple inventory item in your mj freeway site  
  Inventory Vendors    
    Bulk Inventory Vendor(s): vendor/supplier associated when bulk inventory item was created  
    Product Vendor(s): vendor/supplier associated with simple inventory item when created  
  Inventory Packages    
    Package ID: unique identifier for that package  
    Addl Package ID: manually created unique identifier for that package when created  
    Producer Name: the vendor/supplier assigned when package was created  
    Producer License Number: the license entered for the vendor/supplier upon package creation  
    Batch Number: the batch number associated with the package when package was created  
    Additional Batch ID: manuallly created identifier for the batch associated with this package  
    Current Level: level of inventory in that package  
    UOM: the unit of measure for that package  
    Current Level (EA): level of inventory in each unit  
    Current Level (OZ): current inventory level in ounces  
    Current Level (GR): current inventory level in grams  
    Medicated Weight (GR): medicated package weight in grams if applicable  
    Active:   Boolean True / False
    Date Created:   Weekday - MM - DD - HR-MIN-SEC Timezone YYYY
    Num Days: number of days the package has been in the system  
INVENTORY CONVERSIONS: only relates to the tab inventory > conversions  
  Conversions    
    Conversion ID: unique identifier  
    Convert Date Only: gives me a blank  
    Notes: anything you manually enter into an adjusted note in that field  
    Transfer Variance (GR): need description  
    Completed:   Boolean True / False
    Source Count: numerical ID  
    Target Count: Numerical ID  
    Location Name: the location in your dropdown  
    Location ID: Unique ID  
    Total Source Transacted Weight (GR): transactional based in grams  
    Total Source Transacted: numerical transacted data  
    Total Target Transacted Weight (GR): transactional based in grams  
    Total Target Transacted: numerical transacted data  
  Conversion Inputs: what you are putting in to the conversion  
    Inventory Item Name (IN): bulk and product inventory in your mj freeway site  
    Variant Name (IN): pricing weight  
    Transacted Amt (IN): transactional based input  
    Transacted Amt (OZ) (IN): transactional based input in ounces  
    Transacted Amt (GR) (IN): transactional based input in grams  
    Batch Number (IN): unique identifier of the conversion input  
    Vender Name (IN): supplier/vendor associated with the conversion input  
  Conversion Outputs    
    Inventory Item Name (OUT): manual product item of the inventory input conversion  
    Inventory Variant (OUT): pricing weight for output conversion  
    Transacted Amt (OUT): transactional based amount  
    Transacted Amt (OZ) (OUT): transactional based amount in ouces  
    Transacted Amt (GR) (OUT): transactional based in grams  
    Batch Number (OUT): unique identifer for output product batch  
    Vendor Name (OUT): unique identifier for the supplier/vendor entered  
ORDERS: Sales for the day    
  Orders    
    Order Number: Found in the POS screen next to the patient/customer name.   The number of the transaction for that particular order. pos_completed / pos_canceled / pending / in_checkout / payment_received / pos_in_progress / online_pending / refund_completed
    Order Status Code: This is the back end status of the order  
    Order Status Name: This is the order status seen in the order view page. In checkout / online unprocessed / Payment received / Pending / POS Canceled / POS Completed / POS in Progress / Refund Completed.
    Order Total: The total amount charged to the order.   Shows up to the hundredth thousandths in decimals Transactional based
    Location Name: Based on the location in your drop down  
    Patient Number: Unique identifier created in the patient registration  
    Patient is Tax Exempt: Checkbox assigned in the patient registration Boolean. (-, 0, 1)
    User Name: unique identifier of the mjfreeway site user  
    Created: Unix timestamp  
    Completed Timestamp: Unix Timestamp  
    Completed Date Only: Date the transaction took place YYYY-MM-DD
    Completed Time Only: Shown in military time the time the transaction was completed. hours:minutes:seconds
    Order Type: The type of transaction the order was SALES / REFUND / undefined
    Year Month: the year and month the transaction took place.  YYYY-MM
    Year: The year this transaction occurred YYYY
    Week Day: Day of the week the order took place. Monday / Tuesday / Wednesday / Thursday /Friday / Saturday / Sunday
    Week: With 52 weeks in a calendar year, which ever week the transaction occurred 1 through 52
  Order Payments    
    Order ID: unique identifier for that transaction  
    Method: form of payment/contribution for that transaction POS Cash /- / POS Credit / POS Check / Credit Card / Debit
    Amount: total dollars for that order Transactional based
  Order Products    
    Order Product ID: Unique identifier created for that product   
    Line Title: Name of product sold  
    Qty: The number of units associated with that order line Transactional based
    Price: Created when product is entered into system Transactional based
    Line Subtotal: Indicates the total price(s) of the items on the order before order line item types Transactional based
    Bulk Qty Sold (OZ): Amount of billable weigh on the spot items in ounces The number of transacted units
    Bulk Qty Sold (GR): Amount of billable weigh on the spot items in grams The number of transacted units
    Bulk Qty Dispensed (OZ): weigh on the spot items dispensed in ounces The number of transacted units
    Bulk Qty Dispensed (GR): weigh on the spot items dispensed in grams The number of transacted units
    Prepack Dispensed (OZ): price by weight simple inventory in ounces The number of transacted units
    Prepack Dispensed (GR): price by weight simple inventory in grams The number of transacted units
    Line Discount Amt: dollar amount discounted from that line item  
    Product Title: The name of the item on that order  
    Price Group ID: unique identifier for the pricing group  
    Price Group Name: The level of pricing the the line item on that order was priced  
    Category ID: Unique identifier  
    Category Name: Indicates the catalog category the line item on that order was assigned to  
  Order Line Items: Order line items are the adjustments (percentages or actual amounts) to the products sub total to the order.
    Type: Indicates the type of adjustment made to the order sub total. Tax / - / Coupon / discount / shipping
    Title: Indicates the title of the adjustment being made to the sub total.  
    Amount: Indicates the amount of the adjustment being made to the sub total.  
  Line Item Inventory    
    Order Product Weight ID: Unique identifier  
    Qty: blank  
    Qty Uom: blank  
    Bulk Qty Dispensed: weigh on the spot amount dispensed  
    Bulk Qty Dispensed (GR): weigh on the spot amount dispensed in grams  
    Prepack Dispensed: simple inventory items dispensed  
    Prepack Dispensed (GR): simple inventory items dispensed in grams  
    Package ID: blank  
    Batch Number: unique identifier associated with inventory item  
    Additional Batch ID: additional optional unique identifier for item  
    Vendor Name: supplier/vendor associated with line item  
    Pricing Weight: assigned pricing weight for line item  
    Calculated Cost: based off of inventory cost settings Transactional Based
    Preferred Cost (GR): based off of inventory cost settings in grams  
  Order Log Entries    
    Log Entry Type: gives me a blank  
    Created: Unix timestamp  
    Created Date Only:   YYYY-MM-DD
    Changes: Lists code  
PATIENTS    
  Patients    
    Patient Number: Unique identifier assigned in patient registration; for labels and receipts  
    Patient Active Y/N:   Y / N
    MMJ Card Expiration: Associated only with patient registration / patient agreement & Text marketing  
    Date of Birth: Associated with patient rewards  
    Is Member: Associated with member pricing groups  
    Mailing Address Street: Associated only with patient registration / patient agreement  
    Mailing Address Street 2: Associated only with patient registration / patient agreement  
    Mailing Address City: Associated only with patient registration / patient agreement  
    Mailing Address State: Associated only with patient registration / patient agreement  
    Mailing Address Zip Code: Associated only with patient registration / patient agreement  
    Mailing List: checkbox in patient registration  
    Referral Type: associated only with patient registration / patient agreement / - / weedmaps / medicalmarijuanalisting.org / magazine ad / newspaper / drive by
    Referral Type Other: manually entered data  
    Phone 1: Associated only with patient registration & text marketing  
    Phone 1 Type: Associated only with patient registration  
    Phone 2: Associated only with patient registration  
    Phone 2 Type: Associated only with patient registration  
    Phone 3: Associated only with patient registration  
    Phone 3 Type: Associated only with patient registration  
    Tax Exempt: check box; associated with patient registration Boolean. (-, 0, 1)
    Member Since: date associated with patient registration YYYY-MM-DD
    Override Limits:   Boolean. (-, 0, 1)
    Override Veg: manually entered data in patient registration  
    Override Flower: manually entered data in patient registration  
    Override Plant Total: total based on manually entered data in patient registration  
    Override MMJ: manually entered data in patient registration  
    Notes: anything you manually enter into an adjusted note in that field  
    Extra Info 1: manually entered data; extra patient fields (flex fields) under patient settings  
    Extra Info 2: manually entered data; extra patient fields (flex fields) under patient settings  
    Extra Info 3: manually entered data; extra patient fields (flex fields) under patient settings  
    Caregiver Name: manuallly entered caregiver info in patient regisration  
  Patients Delivery Addresses    
    Delivery Address is Primary: Associated with online ordering; entered in patient record  
    Delivery Address Name: Associated with online ordering; entered in patient record  
    Delivery Address Street: Associated with online ordering; entered in patient record  
    Delivery Address Street 2: Associated with online ordering; entered in patient record  
    Delivery Address State: Associated with online ordering; entered in patient record  
    Delivery Address City: Associated with online ordering; entered in patient record  
    Delivery Address Zip Code: Associated with online ordering; entered in patient record  
    Delivery Address Country: Associated with online ordering; entered in patient record  
PRODUCTS    
  Products: This is pulling from your active products that are input from GramTracker > Inventory > Products. (You can pull from the products, active products, price of products, inventory levels. General description)
    Location Name: Location within your MJ Freeway Site the product ….. Admin > Locations > Setup Locations GrowTracker / MixTracker / GramTracker
    Product Name: All the Tracked products in your MJ Freeway Site  
    Category ID: unique identifier of assigned category in product setup created in the back end of the system  
    Category Name: The Assigned term in your catalog for this product.  
    SKU: Item ID attached to this product; UPC or SKU  
    Description: The product description entered for this product when the product was created.  
    Sell Price: allocated price for that product in the product setup  
    Member Price: allocated member price allocated in product set up  
    Weight Pricing Enabled:   Boolean, 0 / 1
    Cost: based off of inventory cost settings  
    Product Is Active:   Boolean, N / Y
    Inventory Track Type:   / 0 / 1 / 2
    Track Type String: batch tracking of inventory type bulk / simple / not tracked
  Product Vendors:    
    Vendor Name: Indicates who supplied that product to you; vendor associated with batch in package  
    License Number: The suppliers license number of the vendor or producer on the batch  
  Weight Based Pricing:    
    Pricing Weight ID: Indicates the sequence in which the price appears in your pricing group  
    Price: Indicates the billable weight of the item sold  
    Member Price: Indicates the member price you are charging for that item  
    Pricing Weight SKU: need description  
    Pricing Weight Description: name in define pricing weights  
    Priced Qty: actual quantity in define pricing weights  
    UOM: unit of measure for pricing weight  
  Inventory Levels    
    Variant Name: Simple pricing or Price by Weight amount ?  
    Current Level: #; Current Level of Product /can be negative, decimal or whole #  
    Current Level UOM:   / - / OZ / EA
         
         
         
    **Note: the Reporting Engine only works in Mozilla Firefox.   

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments