Master Daily shipment

Tables (33)

AM FBA Input (Untitled28)

  • am_a_id (Key) — int — Primary key — NOT NULL
  • sku (Field) — varchar(50)
  • am_a_qty (Field2) — int
  • am_a_odnum (Field3) — varchar(25)
  • am_a_date (Field4) — date

AM Modified Input (Untitled26)

  • am_m_id (Key) — int — Primary key — NOT NULL
  • sku (Field) — varchar(50)
  • am_m_qty (Field2) — int
  • am_m_odnum (Field3) — varchar(25)
  • am_m_date (Field4) — date

AM Regular input (Untitled3)

  • am_p_id (Key2) — int — Primary key — NOT NULL
  • sku (Field2) — varchar(50)
  • am_qty (Field) — int
  • am_odnum (Field3) — Varchar(25)
  • am_date (Field4) — date

Adjustment Log Table (Untitled32)

  • sku (Key) — varchar(50) — Foreign key → Location Item Data.sku — NOT NULL
  • adj_serial_num (Field) — varchar(50)
  • adj_location (Field2) — varchar(25)
  • adj_date (Field3) — date

Adjustment Note (Untitled33)

  • sku (Key) — varchar(50) — Foreign key → Adjustment Log Table.sku — NOT NULL
  • adj_note (Field) — varchar(250)
  • adj_date (Field2) — date

Amazon claim (Untitled16)

  • az_order_id (Key) — varchar(25) — Primary key — NOT NULL
  • date (Field) — date
  • price (Field2) — float
  • signature_required (Field3) — varchar(10)
  • reason (Field4) — varchar(100)
  • result (Field5) — varchar(25)
  • date_of_result (Field6) — date
  • amazon_verified_date (Field7) — date
  • note (Field8) — varchar(100)
  • loss_win (Field9) — varchar(10)
  • shipping_claimed (Field10) — varchar(2)
  • claim_filing_date (Field11) — date

Bstock (Untitled19)

  • bstock_serial (Field) — int — Primary key
  • condition (Field3) — varchar(10)
  • bstock_store_data (Field2) — date
  • ori_serial (Field4) — varchar(50)

EBay Management (Untitled20)

  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • ebay_qty (Field) — int

FBA Order Detail (Untitled13)

  • order_num (Key) — varchar(25) — Foreign key → Total Order.order_num — NOT NULL
  • sku (Key2) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • fod_chk (Field2) — bit
  • fod_status (Field3) — varchar(10)
  • fod_qty (Field4) — int
  • fba_confirm_date (Field) — date

FBA Shipping (Untitled14)

  • fba_shipment_id (Key) — varchar(25) — Primary key — NOT NULL
  • location (Field) — varchar(25)
  • shipping (Field2) — varchar(10)
  • notes (Field3) — varchar(250)
  • reimbursement_claim (Field4) — varchar(250)

Item Cost log (Untitled25)

  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • item_cost (Field) — float
  • item_map (Field2) — float
  • itme_log (Field3) — date

Item Information (Untitled11)

  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • description (Field) — varchar(200)
  • name (Field3) — varchar(50)
  • item_type (Field4) — varchar(50)
  • item_category (Field5) — varchar(50)
  • itme_brand (Field6) — varchar(25)
  • item_part (Field8) — varchar(50)
  • item_measurements_length (Field9) — int
  • item_measurements_width (Field10) — int
  • item_measurements_height (Field11) — int
  • item_measurements_weight (Field12) — int
  • item_model (Field13) — varchar(50)

Label (Untitled30)

  • label_make_id (Key) — int — Primary key — NOT NULL
  • code (Field) — varchar(20)
  • brand (Field2) — varchar(20)
  • label_date (Field3) — date
  • label_maker (Field4) — varchar(10)

Location Item Data (Untitled24)

  • location_num (Field) — varchar(25) — Primary key
  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • qty (Field2) — int

Location Scan (Untitled10)

  • scan_id (Key2) — int — Primary key — NOT NULL
  • scan_upc (Field3) — varchar(50)
  • scan_loc (Field2) — varchar(15)
  • scan_sku (Field4) — varchar(50)
  • scan_serial (Field5) — varchar(50)
  • scan_user (Field9) — varchar(10)
  • scan_date (Field10) — date

Modified Order Detail (Untitled12)

  • order_num (Key2) — varchar(25) — Foreign key → Total Order.order_num — NOT NULL
  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • mod_chk (Field) — bit
  • mod_status (Field2) — varchar(10)
  • mod_qty (Field3) — int
  • mod_confirm_date (Field4) — date

Note (Untitled4)

  • note_id (Key2) — int — Primary key — NOT NULL
  • order_num (Key) — varchar(25) — Foreign key → Total Order.order_num — NOT NULL
  • Note (String) — varchar(250)
  • note_date (Field) — date

OfferUp Management (Untitled23)

  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • offerup_qty (Field) — int

PM FBA Input (CopyOfUntitled28)

  • pm_a_id (Key) — int — Primary key — NOT NULL
  • sku (Field) — varchar(50)
  • pm_a_qty (Field2) — int
  • pm_a_odnum (Field3) — varchar(25)
  • pm_a_date (Field4) — date

PM Modified Input (Untitled27)

  • pm_m_id (Key) — int — Primary key — NOT NULL
  • sku (Field) — varchar(50)
  • pm_m_qty (Field2) — int
  • pm_m_odnum (Field3) — varchar(25)
  • pm_m_date (Field4) — date

PM Regular input (Untitled2)

  • pm_p_id (Key2) — int — Primary key — NOT NULL
  • sku (Field2) — varchar(50)
  • pm_qty (Field) — int
  • pm_odnum (Field3) — varchar(25)
  • pm_date (Field4) — date

Regular Order Detail (Untitled5)

  • order_num (Key) — varchar(25) — Foreign key → Total Order.order_num — NOT NULL
  • sku (Key2) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • rod_chk (Field3) — bit
  • rod_status (Field4) — varchar(10)
  • rod_qty (Field) — int
  • rod_confirm_date (Field2) — date

Return (Untitled18)

  • order_num (Key2) — varchar(25) — Foreign key → Shipping.order_num — NOT NULL
  • return_reason (Field) — varchar(500)
  • note_bstock (Field3) — varchar(100)
  • rs (Field4) — float
  • item_price (Field5) — float
  • each_price (Field6) — float
  • ship_cost (Field7) — float
  • return_label_cost (Field8) — float
  • sh_adjust (Field9) — float
  • restock_fee (Field10) — float
  • loc_restock (Field11) — float
  • return_chk (Field12) — bit
  • fba_return_num (Field13) — varchar(25)

Return Note (CopyOfUntitled4)

  • rnote_id (Key) — int — Primary key — NOT NULL
  • order_num (Key2) — varchar(25) — Foreign key → Return.order_num — NOT NULL
  • rnote (String) — varchar(250)
  • rnote_date (Field) — date

Reverb Management (Untitled21)

  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • reverb_qty (Field) — int

Scan Note (Untitled6)

  • scan_note_id (Field3) — Primary key
  • scan_id (Key2) — int — Foreign key → Location Scan.scan_id — NOT NULL
  • scan_note (Field) — varchar(250)
  • scan_date (Field2)

Serial Number Table (Untitled31)

  • serial_num (Key2) — varchar(50) — Primary key — NOT NULL
  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • warehouse_status (Field) — bit

Shipping (Untitled15)

  • order_num (Key2) — varchar(25) — Foreign key → Total Order.order_num — NOT NULL
  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • shipped_with (Field) — varchar(10)
  • best_rate (Field2) — varchar(10)
  • dimensions (Field3) — varchar(10)
  • weight (Field4) — float
  • Reasons (Field5) — varchar(100)
  • sku_serial (Field6) — varchar(50)

Shipping Claims Note (Untitled29)

  • cnote_id (Key) — int — Primary key — NOT NULL
  • order_num (Key2) — varchar(25) — Foreign key → shipping claims.order_num — NOT NULL
  • cnote (Field) — varchar(250)
  • cnote_date (Field2) — date

Total Order (Untitled)

  • order_num (Key) — varchar(25) — Primary key — NOT NULL

Walmart Management (Untitled22)

  • sku (Key) — varchar(50) — Foreign key → item for SCM.sku — NOT NULL
  • walmart_qty (Field) — int

item for SCM (Untitled7)

  • sku (Key) — varchar(50) — Primary key — NOT NULL
  • upc (Field2) — varchar(50)
  • total_qty (Field) — int

shipping claims (Untitled17)

  • order_num (Key2) — varchar(25) — Foreign key → Shipping.order_num — NOT NULL
  • date_reported (Field) — date
  • requested (Field2) — float
  • paid (Field3) — float
  • claim_id (Field4) — varchar(50)
  • capital_claim_id (Field5) — varchar(25)
  • tracking_id (Field6) — varchar(50)
  • reason (Field7) — varchar(250)
  • claim_type (Field8) — bit
  • claim_signature (Field9) — bit
  • claim_status (Field11) — bit
  • received_chk (Field12) — bit