WMS-Avlgear
Tables (13)
Box
- box_id (Key) — int — Primary key — NOT NULL
- box width (Field) — int
- bos height (Field2) — int
- box length (Field3) — int
- box qty (Field4) — int
Box Log
- box_id (Key) — int — Foreign key → Box.box_id — NOT NULL
- box use (Field) — int
- box date (Field2) — date
Location
- pd_code (Key) — Foreign key → product_id.pd_code — NOT NULL
- sku_lv (Field) — String
- location (Field2) — String
- quantity (Field3) — int
- Note (Field4) — String
Location Log
- pd_code (Key) — Foreign key → Location.pd_code — NOT NULL
- location (Field) — String
- input_date (Field2) — date
- note (Field3) — String
Order
- sw_num (Field)
- qty (Field2)
- sku_lv (Field3)
- date (Field4)
- od_type (Field5)
Price Log
- pd_code (Key) — Foreign key → product_id.pd_code — NOT NULL
- new_price (Field) — float
- input_date (Field2) — date
- note (Field3) — String
Product
- pd_code (Key) — Foreign key → product_id.pd_code — NOT NULL
- name (Field3) — String
- item_type (Field4) — String
- description (Field5) — String
- unit_price (Field6) — float
- markup (Field7) — float
- cost (Field8) — float
- barcode (Field9) — String
- brand (Field10) — String
- avl_url (Field11) — String
- is_active (Field12) — boolean
- category (Field13) — String
- pd_length (Field14) — int
- ProductWidth (Field15) — int
- ProductHeight (Field16) — int
- ProductWeight (Field17) — float
- Remarks (Field18) — String
- Model (Field19) — String
- Part # (Field20) — String
- Manufacture Part # (Field21) — String
- box measurement (Field22) — int
- Shipped with (Field23) — String
- Best Rate (Field24) — String
- Code (Field25)
- is_modified (Field26) — Boolean
Scan
- sku_lv (Field)
- upc (Field2)
- loc (Field3)
- memo (Field4)
- reasons (Field5)
- serial (Field6)
- scan_time (Field7)
- scanner (Field8)
- scan_type (Field9)
Serial
- pd_code (Key) — Foreign key → Location.pd_code — NOT NULL
- serial (Field2) — String
- input_date (Field3) — Date
- note (Field4) — String
UPC_log
- pd_code (Key) — Foreign key → product_id.pd_code — NOT NULL
- new_upc (Field) — String
- input_date (Field2) — date
- note (Field3) — String
pick log
- sku_lv (Field)
- qty (Field2)
- pick_time (Field3)
product_id
- pd_code (Key) — Primary key — NOT NULL
- sku_lv (Field) — String
- upc (Field2) — String
- price (Field3) — float
sku_log
- pd_code (Key) — Foreign key → product_id.pd_code — NOT NULL
- new_sku (Field) — String
- input_date (Field2) — date
- note (Field3) — String