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