Account
Our customers and our customers customers. Account allows you to build a hierarchy.
Bin location
Bin location in warehouse
Carrier
A corporation transporting goods
Channel
A corporation or website selling goods
Contact
A person or corporation, with name, address and contact details
Container
A physical packaging material, which can contain inventory items.
Customer
End customers
Contacts (default)
- contact
- billing contact
Additional contacts possible, for example:
- ship to contact
- ship notification contact
Hold
An item which is in exception state, several things can go on hold:
- InventoryItem
- Order
- OrderLineItem
- PickList
Holiday
One or more days or one part of a day where there is no business conducted.
InventoryItem
Individual items on inventory. For every item on inventory we create one inventory_item record. This include every single item in the case of bulk units. For example: ten individual pens would have 10 inventory item records
Adding ten pens to inventory would create ten exact same entries in the table (apart from the id of course). Removing ten pens from inventory would mark all ten items as retired
LicensePlate
Usually a printed label that refers to either a Container or an InventoryItem
Location
Warehouse locations
Order
Our main transaction for Boxture, must contain one or more order-lines
OrderLine
Belongs to an order, and stores ordered quantity one product only.
OrderLineItem
Belongs to an order-line and stores individual inventory items for an order-line.
Order types
Sales order
Order issued by an account to a customer
Transfer
Orders to transfer inventory from one location to another
PurchaseOrder
Orders to receive inventory from a vendor into a loction
PackingMaterial
Packing materials can be stored in inventory and are a type of packing material. We maintain levels for each packing material, the lower the level, the closer it is around the product.
PickList
A list of items to pick for one or more orders in the warehouse.
PickListLine
A picklist must contain one or more pick list lines. Each picklist-line contains one product to pick for at least quantity 1.
Product
Products we (possibly) keep inventory for and which are orderable.
ProductAlias
For some channels we keep aliases for the product, so as to have channels order their own product names
ProductCategory
We can possibly order products in categories
ProductComponent
Components are used for kitting. Some products can exist of other products. When you order a kit, the components are exploded on order line items.
ProductPackaging
This contains how a product should be packaged, optionally with exceptions per location.
Reason
Contains all reasons why items can go on hold.
ServiceType
Service types per carrier
Shipment
A shipment will be created upon packing an order, a shipment consists of one or more parcels.
Parcel
A parcel belongs to a shipment and can usually be tracked using it's own tracking-number
ParcelItem
An item in a parcel.
Shipping method
Shipping methods dictate how an order should be shipped, possibly referring to a service-type. One or more shipping methods can refer to the same service-type.
Tote
A tote is used when Picking and Packing. There can be multiple totes per order, but a tote can only contain one order.
User
Users which will login to the system