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