-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 產生日期: 2017 年 05 月 05 日 22:41
-- 伺服器版本: 5.6.12-log
-- PHP 版本: 5.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 資料庫: `3g010_20123`
--
CREATE DATABASE IF NOT EXISTS `3g010_20123` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `3g010_20123`;

-- --------------------------------------------------------

--
-- 表的結構 `account`
--

CREATE TABLE IF NOT EXISTS `account` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `acctext` text,
  `accrate` text,
  `accnote` text,
  `accmoney` int(11) DEFAULT NULL,
  `accsort` int(11) DEFAULT NULL,
  `accpic` int(11) DEFAULT NULL,
  `accinit` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qcust`
--

CREATE TABLE IF NOT EXISTS `qcust` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `CUSTNO` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CUSTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `MOBIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `MSN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL,
  `DEPTNO` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ADDRESS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `CREATEDATE` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `CREATETIME` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `BIRTHDAY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `C1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `C2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `C3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `M1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `M2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `M3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `S1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `S2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `S3` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qcust`
--

INSERT INTO `qcust` (`UID`, `XID`, `TR`, `CUSTNO`, `CUSTNAME`, `MOBIL`, `EMAIL`, `MSN`, `GMAIL`, `GPSLA`, `GPSLO`, `DEPTNO`, `EMPID`, `DISCOUNT`, `ADDRESS`, `PS`, `BANKNO`, `BANKNAME`, `COUNTRY`, `TRADETYPE`, `STATE`, `PIC`, `CREATEDATE`, `CREATETIME`, `BIRTHDAY`, `C1`, `C2`, `C3`, `M1`, `M2`, `M3`, `S1`, `S2`, `S3`) VALUES
('3G010_20123', 3, '20', 'A1', '西門店', '0988287769', 'cwbuyer@kimo.com', '', '', 0, 0, '', '888', 100, '', '', '5', 'AA1', '1', '3', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2013-02-04', '141124024830', '', '1', '0', '0', '1', '', '', '1', '', '\r'),
('3G010_20123', 5, '40', 'A11', '一姐', 'null', 'null', 'null', 'null', 0, 0, 'null', 'nul', 0, 'null', 'null', '5', 'AA1', '1', '4', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2013-01-08', '141124024830', 'null', '1', '0', '0', '0', 'n', 'n', '0', 'n', 'n'),
('3G010_20123', 6, '40', 'A12', '二姐', '', '', '', '', 0, 0, '', '', 0, '', '', '5', 'AA1', '1', '4', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2013-01-08', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 7, '40', 'A13', '三姐', '', '', '', '', 0, 0, '', '', 0, '', '', '5', 'AA1', '1', '4', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2013-01-08', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 2, '20', 'AA', '東區旗艦店', '', '', '', 'null', 0, 0, '', '888', 100, '', '', '5', 'AA1', '1', '3', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2012-12-28', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 4, '10', 'C001', '13行', '0911', '', '', 'null', 0, 0, '', '888', 100, '', '', '2', 'AA1', '1', '0', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2013-01-08', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 49, '30', 'C4008', 'BigFek', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980+2980  中美街  萬花筒', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '090103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 44, '30', 'C7011', 'DCC&Nuna', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, 'C7011', '8000+8000=16000(送平板2980)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '060103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 78, '30', 'C7040', '達伯洋行', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, 'C7040', '8000+4980+2980……N', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-05-20', '150520082214', '', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 32, '30', 'Ca001', 'FHC桐花', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000+2980*2=13960', '1', 'AA1', '1', '1', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 33, '30', 'Ca002', 'WINK威克洋行有限公', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '32040=2670*12月繳', '1', 'AA1', '1', '1', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 34, '30', 'Ca003', 'Homeshop', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980*6=29880', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 35, '30', 'Ca004', 'Honey讚', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000+2980=10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '100102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 36, '30', 'Ca005', '1109韓服', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '8000+2980=10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-06-22', '150621231947', '050103', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 37, '30', 'Ca006', '樺穎', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '(8000+2980)*3=32940', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '020103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 42, '30', 'Ca009', 'CIRCLE', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '小軒8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '050103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 50, '30', 'Ca010', '奶油妮莎(小龍)', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '9000  (平板+手機)？？？', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-01-27', '150127041601', '010103', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 45, '30', 'Ca012', 'DS&US', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '板橋4980*3=14940…N', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '030104', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 46, '30', 'Ca013', 'FreeWay', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 103, '30', 'Ca014', 'Perfect', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000+2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '010104', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 48, '30', 'Ca015', 'jjstore', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 53, '30', 'Ca016', 'Kawatata', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '8000+2980*2', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 54, '30', 'Ca017', 'KiKi&MiKa', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000*2+2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 55, '30', 'Ca018', 'Kills', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '8000+2980…N', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 56, '30', 'Ca019', 'kR.S', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '8000+2980....N', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-05-20', '150520082027', '010104', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 62, '30', 'Ca023', 'Pannel', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '060103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 66, '30', 'Ca027', 'Sofa', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 67, '30', 'Ca028', 'STYLEKEY', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '100104', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 68, '30', 'Ca029', 'ViVianCode', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '15000(匯)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '010103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 69, '30', 'Ca030', '姿雪', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '120102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 71, '30', 'Ca032', '晶采服飾', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000+2980+2980=13960', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '120103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 73, '30', 'Ca035', '第五街', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '10980(5月收)，4980(9月收)104改收15000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '090103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 75, '30', 'Ca037', '輕時尚', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 76, '30', 'Ca038', '轉角', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 79, '30', 'Ca041', '采欣', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '060103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 80, '30', 'Ca042', '韓蒂雅', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 88, '30', 'Ca050', 'Ones', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-10-16', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 91, '30', 'Ca054', '可祥Ke Chiang', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '可祥4980*5=24900', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 92, '30', 'Ca055', '富發鞋', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980*2+2980=12940', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 94, '30', 'Ca056', '那殿', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '10980(網路未穩)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '120103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 95, '30', 'Ca057', '(掛)行星怪獸', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '1031022收硬體8095+405=8500有開發票', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 97, '30', 'Ca059', 'IN2TWO', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000+2980(未收)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '010103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 98, '30', 'Ca060', 'GUSTA', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980+2000=6980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 99, '30', 'Ca061', '可可衣股份有限公司', '', 'Billy', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '6000', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '120103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 108, '30', 'Ca064', '花緹', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '10980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 110, '30', 'Ca066', '米卡+琪琪', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '8000+10980=18980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 8, '10', 'K001', '東大門', '0911', '', '', '', 0, 0, '', '888', 100, '', '', '3', 'AA1', '1', '0', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2013-01-08', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 101, '30', 'S35063', 'MINIDEER(竹東)', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '6980試用未收', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-28', '150104020814', '010104', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 65, '30', 'S4026', 'RichMu逢甲', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980*2+2980=12940=12323+617(發票)給八年11', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '120103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 70, '30', 'S4031', 'Gram&Co台北婕盈', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980。103\0623匯款', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 89, '30', 'S4051', '衣寶羅', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, 'S4051', '(沙鹿2980未收)1021011收硬體22940', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '000102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 105, '30', 'S4062', 'Gram&co台中婕盈', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '5960', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '050103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 106, '30', 'S4063', 'ASTARTA', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '100103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 114, '30', 'S4070', '木札果', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, 'S4070', '4980*2+2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '010104', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 60, '30', 'S7023', '西瓜太郎', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, 'S7023', '2980。103三月或五月', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '000103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 81, '30', 'S7043', '加減乘除', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, 'S7043', '4980*5。約103\07', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 87, '30', 'S7049', 'Doota', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980+2980(收今年跟去年)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '120102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 61, '30', 'Sa007', 'OHYes', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '14940+4980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '110102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 57, '30', 'Sa020', 'LadyFirst', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980*4', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-16', '141124024830', '110102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 58, '30', 'Sa021', '小田Lightning', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '臨江街原(2980)。12000…N  (LightningBeBe)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '100103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 59, '30', 'Sa022', 'Molly', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '士林大北路6號。4000…N', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 63, '30', 'Sa024', 'Rabbit', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '120102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 64, '30', 'Sa025', 'WhiteRabbit', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980*4*85%=16940', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '050103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 72, '30', 'Sa033', '畇龍越南百貨', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980(未收)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-10-15', '141124024830', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 74, '30', 'Sa036', 'CoCo裟鈴工坊', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980  (CoCoserlinna102/12/09匯錢)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '120102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 77, '30', 'Sa039', 'MiNi將公館', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '4980…10311月底需收款', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '100103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 82, '30', 'Sa044', 'Jolly Jolly', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '大安路2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '050103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 83, '30', 'Sa045', 'Passy東區(掛)', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980.(掛)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '050102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 84, '30', 'Sa046', 'Dream士林', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '大東路2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '050102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 90, '30', 'Sa053', '彩緹', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '102收5960', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '070102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 104, '30', 'Sa058', 'MEI士林', '', '', '', 'null', 0, 0, 'AA1', 'A11', 0, '', '2980 倉儲用', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '100102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 102, '30', 'Sa064', 'Mela', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '試用未收', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '010104', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 111, '30', 'Sa067', '師大小朱', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '5960', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 112, '30', 'Sa068', 'color將(師大阿勇)', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4980*2=9960', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '070103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 113, '30', 'Sa069', '東東(師大阿勇弟)', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, 'Sa069', '4000+2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 115, '30', 'Sa071', '阿龍(師大)', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980(匯)', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '010103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 116, '30', 'Sa072', 'MISSPARK', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '110102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 117, '30', 'Sa073', '完美皇后', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '4000+2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-21', '141124024830', '110103', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 118, '30', 'Sa074', '小鄭', '', '', '', 'null', 0, 0, 'AA1', 'A11', 100, '', '2980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-17', '141124024830', '100102', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 119, '30', 'A009', 'VIP', 'null', 'null', 'null', 'null', 0, 0, 'null', 'nul', 0, 'null', 'null', '1', 'AA1', '3', '5', '1', 'null', '2014-11-24', '141124041352', 'null', '1', '0', '0', 'n', 'n', 'n', 'n', 'n', 'n'),
('3G010_20123', 123456789, '30', 'root001', 'webRoot', '098828', 'purch@gmail.com', '0987654321', NULL, NULL, NULL, 'AA', NULL, 100, NULL, NULL, NULL, NULL, '1', '4', NULL, NULL, '2014-01-01', '140101000000', '1010', '1', '5', '0', NULL, NULL, NULL, NULL, NULL, NULL),
('3G010_20123', 123, '30', 'C7078', 'SYS馨園(飾品)', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-28', '150104020814', '', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 124, '30', 'S3001', '小雅', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-01-04', '150104020814', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 120, '30', 'S34075', '1855(五家)畢先生', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '預估16800', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-28', '150104020814', '010104', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 121, '30', 'Sa076', '可萊兒(二家)', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '預估9960', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-28', '150104020814', '020104', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 122, '30', 'Sa077', 'Glass', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '4000+2980=6980', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2014-11-28', '150104020814', '00000', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 125, '30', 'Ca801', '藝比特', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-01-04', '150104030538', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 126, '30', 'Ca802', '泛美', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '', '', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-01-04', '150104031246', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 127, '20', 'A', 'VIP', 'null', 'null', 'null', 'null', 0, 0, 'null', 'nul', 0, 'null', 'null', '4', 'AA1', '3', '零', '1', 'null', '2015-01-08', '150108113518', 'null', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n'),
('3G010_20123', 128, '30', 'Sa078', '士林許', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '台北市士林區大東路25號', '', '1', 'AA1', '1', '5', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '2015-01-13', '150113155704', '', '1', '0', '0', '0', '', '', '0', '', '\r'),
('3G010_20123', 1, '30', '000168', 'VIP', '0988287769', 'cwbuyer@kimo.com', '', 'null', 0, 0, 'AA', '888', 100, '', '', '5', 'AAA', '1', '5', '1', '/mnt/sdcard/CWBuyer/PARA/04.jpg', '2013-01-21', '170313001525', '', '1', '', '', '1', '', '', '1', '', '\r'),
('3G010_20123', 9, '30', '009668', 'VSOP', '', '', '', 'null', 0, 0, 'AA', '888', 100, '', '', '1', 'AAA', '1', '5', '1', '/storage/sdcard0/cwbuyer/para/04.jpg', '2013-02-04', '170313001525', '', '1', '', '', '0', '', '', '0', '', '\r'),
('3G010_20123', 99, '30', 'CW7313', 'SOEN', '', '', '', 'null', 0, 0, 'AA', 'A11', 100, '桃園市中山路84號', '', '1', 'AAA', '1', '5', '1', '/storage/emulated/0/cwbuyer/para/04.jpg', '2017-03-13', '170313001535', '', '1', '0', '0', '1', '0', '0', '1', '1', '0');

-- --------------------------------------------------------

--
-- 表的結構 `qc_color`
--

CREATE TABLE IF NOT EXISTS `qc_color` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `NO1` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `TXT` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` varchar(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_color`
--

INSERT INTO `qc_color` (`UID`, `XID`, `NO1`, `TXT`, `PIC`) VALUES
('3G010_20123', 1, '01', '黑色', '0XFF000000'),
('3G010_20123', 2, '02', '白色', '0XFFFFFFFF'),
('3G010_20123', 3, '29', '花色', '0XFFFF00ED'),
('3G010_20123', 4, '04', '淺灰', '0XFFA0A0A0'),
('3G010_20123', 6, '06', '橘色', '0XFFFF7C11'),
('3G010_20123', 8, '08', '粉紅', '0XFFFF51D9'),
('3G010_20123', 27, '27', '米黃', '0XFFF2EC4F'),
('3G010_20123', 24, '24', '淺綠', '0XFF5CFF54'),
('3G010_20123', 25, '25', '褐色', '0XFF546318'),
('3G010_20123', 26, '26', '黃褐', '0XFFE0D321'),
('3G010_20123', 28, '28', '米白', '0XFFEFFF7A'),
('3G010_20123', 5, '05', '紅色', '0XFFFF0000'),
('3G010_20123', 22, '22', '綠色', '0XFF45D824'),
('3G010_20123', 23, '23', '藍綠', '0XFF2C8968'),
('3G010_20123', 18, '18', '駝色', '0XFFEA691E'),
('3G010_20123', 21, '21', '軍綠', '0XFF15420B'),
('3G010_20123', 15, '15', '淺藍', '0XFF106BCC'),
('3G010_20123', 20, '20', '卡其', '0XFFD1EF94'),
('3G010_20123', 19, '19', '淺駝', '0XFFFFAE19'),
('3G010_20123', 17, '17', '黃色', '0XFFFFD505'),
('3G010_20123', 16, '16', '湖藍', '0XFF71E2E2'),
('3G010_20123', 10, '10', '淺咖', '0XFFC69C3F'),
('3G010_20123', 11, '11', '紫色', '0XFFA800A2'),
('3G010_20123', 14, '14', '寶藍', '0XFF152460'),
('3G010_20123', 13, '13', '藍色', '0XFF1549A8'),
('3G010_20123', 9, '09', '咖啡', '0XFF986C00'),
('3G010_20123', 12, '12', '粉紫', '0XFFD982FF'),
('3G010_20123', 7, '07', '桃紅', '0XFFFF00E1'),
('3G010_20123', 29, '30', '暗褐色', '0XFF452700');

-- --------------------------------------------------------

--
-- 表的結構 `qc_country`
--

CREATE TABLE IF NOT EXISTS `qc_country` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `NAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `RATE` double DEFAULT NULL,
  `PIC` text,
  `LAMIN` double DEFAULT NULL,
  `LAMAX` double DEFAULT NULL,
  `LOMIN` double DEFAULT NULL,
  `LOMAX` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_country`
--

INSERT INTO `qc_country` (`UID`, `XID`, `NAME`, `RATE`, `PIC`, `LAMIN`, `LAMAX`, `LOMIN`, `LOMAX`) VALUES
('3g010_20123', 2, '中國', 4.9, 'drawable/country_chi', 17, 52, 47, 119.6),
('3g010_20123', 1, '台灣', 1, 'drawable/country_twn', 21, 26.1, 119.7, 123),
('3g010_20123', 3, '韓國', 0.03, 'drawable/country_koe', 33, 33, 125, 129),
('3G010_20123', 4, '日本', 0.38, 'drawable/country_jpn', 26.2, 26.2, 127.1, 149),
('3G010_20123', 5, '香港', 3.9, 'drawable/country_hk', 21.879, 22.517, 113.575, 114.46);

-- --------------------------------------------------------

--
-- 表的結構 `qc_default`
--

CREATE TABLE IF NOT EXISTS `qc_default` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BATCH` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `FACTNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `PRODUCT` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ITEMFIRST` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `SEASON` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `YEAR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `EMPLOY` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `ACCOUNT` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `BAROUT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `FILEOUT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PRINTOUT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CA1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CA2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CA3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CB1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CB2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CB3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CC1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CC2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CC3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CD1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CD2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CD3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `HID` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qc_defpri`
--

CREATE TABLE IF NOT EXISTS `qc_defpri` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `DEFPRI` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_defpri`
--

INSERT INTO `qc_defpri` (`UID`, `XID`, `DEFPRI`, `COUNTRY`, `P0`, `P1`, `P2`, `P3`, `P4`, `P5`) VALUES
('3G010_20123', 59, '9650.0', '1', 9650, 9650, 0, 15500, 0, 15500),
('3G010_20123', 62, '2700.0', '1', 2700, 2700, 0, 4500, 0, 4500),
('3G010_20123', 56, '7350.0', '1', 7350, 7350, 0, 8500, 0, 8500),
('3G010_20123', 54, '4500.0', '1', 4500, 4500, 0, 6500, 0, 6500),
('3G010_20123', 58, '42.0', '1', 42, 42, 0, 80, 0, 80),
('3G010_20123', 51, '10500.0', '1', 10500, 10500, 0, 18000, 0, 18000),
('3G010_20123', 63, '1800.0', '1', 1800, 1800, 0, 2800, 0, 2800),
('3G010_20123', 53, '840.0', '1', 840, 840, 0, 2000, 0, 2000),
('3G010_20123', 61, '9500.0', '1', 9500, 9500, 0, 11500, 0, 11500),
('3G010_20123', 52, '7350.0', '1', 7350, 7350, 0, 8500, 0, 8500),
('3G010_20123', 57, '6800.0', '1', 6800, 6800, 0, 8500, 0, 8200),
('3G010_20123', 64, '1050.0', '1', 1050, 1050, 0, 2000, 0, 2000),
('3G010_20123', 55, '4500.0', '1', 4500, 4500, 0, 7000, 0, 7000),
('3G010_20123', 60, '5460.0', '1', 5460, 5460, 0, 9500, 0, 9500),
('3G010_20123', 65, '190.0', '1', 190, 190, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- 表的結構 `qc_macc`
--

CREATE TABLE IF NOT EXISTS `qc_macc` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `ID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `QNOM` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `TXT` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `IOKEY` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qc_quality`
--

CREATE TABLE IF NOT EXISTS `qc_quality` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `QUA10` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA11` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA20` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA21` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA30` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA31` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA40` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA41` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA50` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA51` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA60` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA61` varchar(4) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_quality`
--

INSERT INTO `qc_quality` (`UID`, `XID`, `QUA10`, `QUA11`, `QUA20`, `QUA21`, `QUA30`, `QUA31`, `QUA40`, `QUA41`, `QUA50`, `QUA51`, `QUA60`, `QUA61`) VALUES
('3G010_20123', 2, '聚酯纖維', '35', '棉', '60', '金屬纖維', '2', '彈性纖維', '3', 'null', 'null', 'null', 'null'),
('3G010_20123', 1, '聚酯纖維', '60', '棉', '35', '金屬纖維', '2', '彈性纖維', '3', 'null', 'null', 'null', 'null'),
('3G010_20123', 2, '聚酯纖維', '35', '棉', '60', '金屬纖維', '2', '彈性纖維', '3', 'null', 'null', 'null', 'null'),
('3G010_20123', 1, '聚酯纖維', '60', '棉', '35', '金屬纖維', '2', '彈性纖維', '3', 'null', 'null', 'null', 'null');

-- --------------------------------------------------------

--
-- 表的結構 `qc_size`
--

CREATE TABLE IF NOT EXISTS `qc_size` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `SIZES` varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_size`
--

INSERT INTO `qc_size` (`UID`, `XID`, `SIZES`) VALUES
('3G010_20123', 2, 'S,M,L,XL'),
('3G010_20123', 3, 'M,L,XL,2XL,3XL'),
('3G010_20123', 1, 'F'),
('3G010_20123', 5, '25,26,27,28,29,30'),
('3G010_20123', 7, '220,225,230,235,240,245,250,255,260,265'),
('3G010_20123', 4, '35,36,37,38,39,40'),
('3G010_20123', 6, '28,30,32,34,36,38');

-- --------------------------------------------------------

--
-- 表的結構 `qc_type`
--

CREATE TABLE IF NOT EXISTS `qc_type` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `ID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `GOODTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SEASON` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `ADDCOST` double DEFAULT NULL,
  `PIC` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_type`
--

INSERT INTO `qc_type` (`UID`, `XID`, `ID`, `GOODTYPE`, `COUNTRY`, `SEASON`, `ADDCOST`, `PIC`) VALUES
('3G010_20123', 164, 'null', '觸控螢幕', '1', '4', 0, '/mnt/sdcard/download/1468126-1_XXL.jpeg'),
('3G010_20123', 163, 'null', '華碩主機', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1411767637467.jpg'),
('3G010_20123', 169, 'null', 'GODEX 條碼機', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416735551825.jpg'),
('3G010_20123', 184, 'null', '門市電腦安裝費', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416734351780.jpg'),
('3G010_20123', 179, 'null', '條碼貼紙', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1412480962983.jpg'),
('3G010_20123', 182, 'null', '軟體合約', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1412480871194.jpg'),
('3G010_20123', 183, 'null', '伺服器安裝費', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416734188460.jpg'),
('3G010_20123', 175, 'null', '碳帶', '1', '4', 0, '/mnt/sdcard/DCIM/Camera/20141003_211422.jpg'),
('3G010_20123', 174, 'null', '熱感紙捲', '1', '4', 0, '/mnt/sdcard/DCIM/Camera/20141003_211422.jpg'),
('3G010_20123', 190, 'null', '掃描器', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416737773150.jpg'),
('3G010_20123', 191, 'null', '線 材', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416738757421.jpg'),
('3G010_20123', 192, 'null', '控制盒', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416744008656.jpg'),
('3G010_20123', 197, 'null', '分享器', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416741931741.jpg'),
('3G010_20123', 198, 'null', '平板', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416744357132.jpg'),
('3G010_20123', 193, 'null', '錢櫃', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416739684589.jpg'),
('3G010_20123', 200, 'null', '記憶體', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416742678379.jpg'),
('3G010_20123', 201, 'null', '藍芽接受器', '1', '4', 0, '/mnt/sdcard/000000000000/Cate_1416742936390.jpg'),
('3G010_20123', 202, '0', '固態硬碟', '1', '4', 0, '/mnt/sdcard/141124032647/Cate_1416934495191.jpg'),
('3G010_20123', 204, '0', '集線器', '1', '4', 0, '/mnt/sdcard/141124032647/Cate_1416935937119.jpg'),
('3G010_20123', 205, '0', '維護費', '1', '4', 0, '/mnt/sdcard/141124032647/Cate_1420758845174.jpg'),
('3G010_20123', 206, '0', '吊牌', '1', '4', 0, '/mnt/sdcard/141124032647/Cate_1420760749812.jpg');

-- --------------------------------------------------------

--
-- 表的結構 `qc_wash`
--

CREATE TABLE IF NOT EXISTS `qc_wash` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `WASH10` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH11` text,
  `WASH20` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH21` text,
  `WASH30` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH31` text,
  `WASH40` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH41` text,
  `WASH50` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH51` text,
  `WASH60` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH61` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qc_wash`
--

INSERT INTO `qc_wash` (`UID`, `XID`, `WASH10`, `WASH11`, `WASH20`, `WASH21`, `WASH30`, `WASH31`, `WASH40`, `WASH41`, `WASH50`, `WASH51`, `WASH60`, `WASH61`) VALUES
('3G010_20123', 2, '/mnt/sdcard/cwbuyer/wash/bleach2.png', 'null', '/mnt/sdcard/cwbuyer/wash/dry1.png', 'null', '/mnt/sdcard/cwbuyer/wash/dry2.png', 'null', '/mnt/sdcard/cwbuyer/wash/dry4.png', 'null', '/mnt/sdcard/cwbuyer/wash/dry7.png', 'null', '/mnt/sdcard/cwbuyer/wash/dry8.png', 'null'),
('3G010_20123', 1, '/mnt/sdcard/cwbuyer/wash/bleach0.png', 'null', '/mnt/sdcard/cwbuyer/wash/bleach1.png', 'null', '/mnt/sdcard/cwbuyer/wash/bleach2.png', 'null', '/mnt/sdcard/cwbuyer/wash/bleach3.png', 'null', '/mnt/sdcard/cwbuyer/wash/dry0.png', 'null', '', 'null');

-- --------------------------------------------------------

--
-- 表的結構 `qdept`
--

CREATE TABLE IF NOT EXISTS `qdept` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `DEPTID` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADTYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qdetail`
--

CREATE TABLE IF NOT EXISTS `qdetail` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `MID` int(11) DEFAULT NULL,
  `SUPPLY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT1` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT2` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT` double DEFAULT NULL,
  `BATCH` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `BILL` double DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `ADDCOST` double DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL,
  `SEASON` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(12) DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `PICTURE` text,
  `QUALITY_ID` int(11) DEFAULT NULL,
  `WASH_ID` int(11) DEFAULT NULL,
  `COLORNO` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `COLOR` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `SIZE` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `INLIST` text CHARACTER SET utf8,
  `IMPO` double DEFAULT NULL,
  `IMPOS` double DEFAULT NULL,
  `OUTPO` double DEFAULT NULL,
  `OUTPOS` double DEFAULT NULL,
  `SPOS` double DEFAULT NULL,
  `SPOSS` double DEFAULT NULL,
  `IM_OUTSTK` double DEFAULT NULL,
  `IM_POSSTK` double DEFAULT NULL,
  `ORD` double DEFAULT NULL,
  `ACCOUNT` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `ATLIST` varchar(512) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qdetail`
--

INSERT INTO `qdetail` (`UID`, `TR`, `MID`, `SUPPLY`, `COUNTRY`, `SOURCENO`, `GOODSNO`, `GOODSTYPE`, `GOODSNAME`, `UNIT1`, `UNIT2`, `UNIT`, `BATCH`, `BILL`, `BILLRATE`, `ADDCOST`, `P0`, `P1`, `P2`, `P3`, `P4`, `P5`, `SEASON`, `PS`, `CREATEDATETIME`, `STATE`, `PIC`, `PICTURE`, `QUALITY_ID`, `WASH_ID`, `COLORNO`, `COLOR`, `SIZE`, `INLIST`, `IMPO`, `IMPOS`, `OUTPO`, `OUTPOS`, `SPOS`, `SPOSS`, `IM_OUTSTK`, `IM_POSSTK`, `ORD`, `ACCOUNT`, `ATLIST`) VALUES
('3G010_20123', '10', 54, 'T01', '1', '168', '168001', '182', '軟體合約8000', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 0, 0, 8000, '4', '', '2014-11-01', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141101084448699.jpg', '', 1, 1, '02', '白色', 'F', '1000', 1000, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 56, 'T01', '1', '168', '168003', '182', '軟體合約4980', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 0, 0, 4980, '4', '', '2014-11-01', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141101085045283.jpg', '', 1, 1, '02', '白色', 'F', '1000', 1000, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 57, 'T01', '1', '168', '168006', '182', '軟體合約2000', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 0, 0, 2000, '4', '', '2014-11-01', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141101085314781.jpg', '', 1, 1, '02', '白色', 'F', '1000', 1000, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 58, 'T01', '1', '168', '168005', '182', '軟體合約2980', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 0, 0, 2980, '4', '168005', '2014-11-17', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141117162706086.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 59, 'T01', '1', '168', '168002', '182', '軟體合約6000', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 6000, 0, 6000, '4', '', '2014-11-17', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141117163000461.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 60, 'T01', '1', '168', '168004', '182', '軟體合約', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 4000, 0, 4000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221064058072.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 61, 'T01', '1', '168', '168009', '163', '華碩主機', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 10500, 0, 0, 15000, 0, 15000, '4', '168009', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221060511464.jpg', '', 1, 1, '02', '白色', 'F', '20', 20, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 62, 'T01', '1', '168', '168007', '183', '伺服器安裝費', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 3000, 0, 3000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123172413887.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 63, 'T01', '1', '168', '168008', '184', '門市電腦安裝費', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 2000, 0, 2000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123172541815.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 64, 'T01', '1', '168', '168010', '169', 'GODEXRT200條碼機', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 7000, 7000, 0, 12000, 0, 12000, '4', 'GODEXRT200條碼機', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221064012282.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 65, 'T01', '1', '168', '168011', '169', 'GODEXDT2條碼機', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 4500, 0, 0, 7000, 0, 7000, '4', 'GODEXDT2條碼機', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221063711398.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 66, 'T01', '1', '168', '168012', '169', 'GODEXG530條碼機', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 9200, 9200, 0, 15500, 14500, 15500, '4', 'GODEXG530條碼機', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221063635040.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 67, 'T01', '1', '168', '168013', '169', 'GODEXG300條碼機', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 5200, 5200, 0, 9500, 0, 9500, '4', 'GODEXG300條碼機', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221063605337.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 68, 'T01', '1', '168', '168014', '169', 'GODEXG500條碼機', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 7500, 7500, 0, 13000, 12500, 13000, '4', 'GODEXG500條碼機', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221063509949.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 69, 'T01', '1', '168', '168015', '190', '條馬掃描器Z3190BT', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 4500, 4500, 0, 6500, 0, 6500, '4', '條馬掃描器Z3190BT', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221063140044.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 70, 'T01', '1', '168', '168016', '190', '條碼掃描器Z3220', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 800, 800, 0, 2000, 1800, 2000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221062934318.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 71, 'T01', '1', '168', '168017', '190', 'MINI掃描器MT1097', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 2700, 2700, 0, 4000, 0, 4000, '4', 'MINI掃描器MT1097', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123182802117.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 72, 'T01', '1', '168', '168018', '191', 'PC轉接線OTG', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 42, 42, 0, 100, 0, 100, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123183609309.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 73, 'T01', '1', '168', '168019', '197', '分享器', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 688, 688, 0, 1300, 0, 1300, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221062333598.jpg', '', 1, 1, '02', '白色', 'F', '2', 2, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 74, 'T01', '1', '168', '168020', '193', '錢櫃信格', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 1800, 1800, 0, 2500, 0, 2500, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123184915276.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 75, 'T01', '1', '168', '168021', '164', '觸控螢幕TD2220', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 7350, 7350, 0, 8000, 0, 8000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221063419959.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 76, 'T01', '1', '168', '168022', '164', '觸控螢幕給奇', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 6800, 6800, 0, 8000, 0, 8000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123190245223.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 77, 'T01', '1', '168', '168023', '174', '80mm*80M', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 29, 29, 0, 45, 0, 45, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123190531377.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 78, 'T01', '1', '168', '168024', '174', '60*mm*100M', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 42, 42, 0, 60, 0, 60, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221062224195.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 79, 'T01', '1', '168', '168025', '179', '35*25*1000張', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 42, 42, 0, 70, 0, 70, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221061845015.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 80, 'T01', '1', '168', '168026', '179', '35*25*1400張', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 42, 42, 0, 70, 0, 70, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221061801372.jpg', '', 1, 1, '02', '白色', 'F', '100', 100, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 81, 'T01', '1', '168', '168027', '175', '碳帶40*300mGR100', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 120, 120, 0, 180, 0, 180, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221061604706.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 82, 'T01', '1', '168', '168028', '175', '碳帶46*91mMR-102', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 40, 40, 0, 80, 0, 80, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221061434248.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 83, 'T01', '1', '168', '168029', '192', '控制盒', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 1000, 1000, 0, 2000, 0, 2000, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123200802713.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 84, 'T01', '1', '168', '168030', '198', '平板NOTE8', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 7500, 7500, 0, 8800, 0, 8800, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123200641871.jpg', '', 1, 1, '02', '白色', 'S,M,L,XL', '200,0,0,0', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 85, 'T01', '1', '168', '168031', '198', '平板NEXUS二代', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 6200, 6200, 0, 7800, 0, 7800, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123195533967.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 86, 'T01', '1', '168', '168032', '200', '記憶體', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 1050, 1050, 0, 1500, 0, 1500, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123193924723.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 87, 'T01', '1', '168', '168033', '201', '藍芽接受器', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 250, 250, 0, 400, 0, 400, '4', '', '2014-11-23', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141123194353427.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 88, 'T01', '1', '168', '168034', '202', '創見', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 2066, 2066, 0, 3000, 0, 3000, '4', '', '2014-11-26', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221061238984.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 89, 'T01', '1', '168', '168035', '202', '台製硬碟', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 1800, 1800, 0, 3000, 0, 3000, '4', '', '2014-11-26', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221061102205.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 90, 'T01', '1', '168', '168036', '204', 'Swich集線器', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 250, 250, 0, 450, 0, 450, '4', '', '2014-11-26', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221060723850.jpg', '', 1, 1, '02', '白色', 'F', '200', 200, 0, 0, 0, 0, 0, 0, 0, 0, '6', NULL),
('3G010_20123', '10', 91, 'T01', '1', '168', '168037', '179', '條碼紙雙層直一刀', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 42, 42, 0, 65, 0, 65, '4', '', '2014-12-10', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20141221060929189.jpg', '', 1, 1, '02', '白色', 'F', '100', 100, 0, 0, 0, 0, 1, 1, 1, 0, '6', NULL),
('3G010_20123', '10', 92, 'T01', '1', '168', '168038', '205', '維護費', 'AA2', '2014', 0, '168', 160717100414, 1, 0, 0, 0, 0, 500, 0, 500, '4', '', '2015-01-09', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/168/mtr_20150109071709475.jpg', '', 1, 1, '02', '白色', 'F', '100', 100, 0, 0, 0, 0, 1, 1, 1, 0, '6', NULL),
('3G010_20123', '10', 94, 'T01', '1', '668', '668001', '197', '分享器', 'AA2', '2014', 1, '668', 160717105401, 1, 0, 840, 840, 0, 2000, 0, 2000, '4', '', '2016-07-17', '0', '/storage/sdcard0/cwbuyer/IMPORT/20123/668/mtr_20160717184835480.jpg', '', 1, 1, '02，01', '白色，黑色', 'F', '1，1', 2, 0, 0, 0, 0, 1, 1, 1, 0, '6', NULL),
('3G010_20123', '10', 90, 'T01', '1', '169', '169001', '206', '吊牌', 'AAA', '2015', 0, '168', 170308034145, 1, 0, 190, 190, 0, 250, 0, 250, '4', '', '2017-03-08', '0', '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20170308112554554.jpg', '', 1, 1, '02', '白色', 'F', '0', 0, 0, 0, 0, 0, 1, 1, 1, 0, '6', NULL);

-- --------------------------------------------------------

--
-- 表的結構 `qemp`
--

CREATE TABLE IF NOT EXISTS `qemp` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `QEMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `QEMPNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `MOBIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `MSN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL,
  `DEPTNO` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `ADDRESS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `BIRTHDAY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qfact`
--

CREATE TABLE IF NOT EXISTS `qfact` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `FACTNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `FACTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `MOBIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `MSN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL,
  `DEPTNO` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ADDRESS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `BIRTHDAY` datetime DEFAULT NULL,
  `CREATEDATETIME` varchar(12) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qfact`
--

INSERT INTO `qfact` (`UID`, `TR`, `FACTNO`, `FACTNAME`, `MOBIL`, `EMAIL`, `MSN`, `GMAIL`, `GPSLA`, `GPSLO`, `DEPTNO`, `EMPID`, `DISCOUNT`, `ADDRESS`, `PS`, `BANKNO`, `BANKNAME`, `COUNTRY`, `TRADETYPE`, `STATE`, `PIC`, `BIRTHDAY`, `CREATEDATETIME`) VALUES
('3G010_20123', '10', 'T01', '寶島', '', '', '', '', 0, 0, 'AA', '888', 100, '', '', '4', 'AAA', '1', '0', '1', '/mnt/sdcard/cwbuyer/ALBUN/cu20150914050110420.jpg', '0000-00-00 00:00:00', '170308034146'),
('3G010_20123', 'nu', 'T02', '內湖華碩', '', '', '', '', 0, 0, '', '666', 0, '', '', 'null', 'AA1', '1', '0', '1', 'null', '0000-00-00 00:00:00', '141124024829'),
('3G010_20123', 'nu', 'T03', '信格', '', '', '', '', 0, 0, '', '666', 0, '', '', 'null', 'AA1', '1', '0', '1', 'null', '0000-00-00 00:00:00', '141124024829'),
('3G010_20123', 'nu', 'T05', '凡盛', '', '', '', '', 0, 0, '', '666', 0, '', '', 'null', 'AA1', '1', '0', '1', 'null', '0000-00-00 00:00:00', '141124024829'),
('3G010_20123', '10', 'C01', '恆', '', '', '', '', 0, 0, 'AA', '888', 100, '', '', '4', 'AAA', '2', '0', '1', '/mnt/sdcard/cwbuyer/ALBUN/cu20150914050201290.png', '0000-00-00 00:00:00', '170308034146'),
('3G010_20123', '10', 'G2301', '金馬', '', '', '', '', 0, 0, 'AA', '888', 100, '', '', '4', 'AAA', '2', '0', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '0000-00-00 00:00:00', '170308034146'),
('3G010_20123', '10', 'K001', '預設廠商', '', '', '', '', 0, 0, 'AA', '888', 100, '', '', '4', 'AAA', '3', '0', '1', '/mnt/sdcard/cwbuyer/ALBUN/cu20150914045811320.png', '0000-00-00 00:00:00', '170308034146'),
('3G010_20123', '10', 'U2101', 'US', '', '', '', '', 0, 0, 'AA', '888', 100, '', '', '0', 'AAA', '3', '0', '1', '/mnt/sdcard/cwbuyer/para/04.jpg', '0000-00-00 00:00:00', '170308034146');

-- --------------------------------------------------------

--
-- 表的結構 `qhead`
--

CREATE TABLE IF NOT EXISTS `qhead` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `QKIND` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `FORMNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `HANDNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `FORMDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(12) DEFAULT NULL,
  `ISCONFIRM` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `ISCHECK` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `ISLIST` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `EMPNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USER` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USERNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNO` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `ORDCASH` double DEFAULT NULL,
  `ORDCARD` double DEFAULT NULL,
  `CASH` double DEFAULT NULL,
  `CARD` double DEFAULT NULL,
  `ATOT` double DEFAULT NULL,
  `ORDDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `FINEDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `ASUM` double DEFAULT NULL,
  `BSUM` double DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `COSTS` double DEFAULT NULL,
  `TURESUM` double DEFAULT NULL,
  `DISMONEY` double DEFAULT NULL,
  `BANKNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `ATM` double DEFAULT NULL,
  `ATMDATE` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `TRCASH` double DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `PS1` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `PS2` varchar(512) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qhead`
--

INSERT INTO `qhead` (`UID`, `TR`, `ID`, `QKIND`, `FORMNO`, `HANDNO`, `FORMDATE`, `CREATEDATETIME`, `ISCONFIRM`, `ISCHECK`, `ISLIST`, `EMPID`, `EMPNAME`, `USER`, `USERNAME`, `TRADETYPE`, `DEPTNO`, `ORDCASH`, `ORDCARD`, `CASH`, `CARD`, `ATOT`, `ORDDATE`, `FINEDATE`, `ASUM`, `BSUM`, `BILLRATE`, `COSTS`, `TURESUM`, `DISMONEY`, `BANKNO`, `BANKNAME`, `ATM`, `ATMDATE`, `TRCASH`, `PS`, `PS1`, `PS2`) VALUES
('3G010_20123', 'Y1', 1501090751, '10', 'AA1168', '+9322', '2015-01-09', '150108235202', 'Y', 'N', 'n', '666', '168', 'T01', 'T01', '0', 'AA', 0, 0, 0, 0, 9322, '', '', 15776000, 15776000, 1, 15776000, 15776000, 0, 'null', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y2', 1008, '32', 'AA13400000', '+53', '2014-11-24', '141129033339', 'N', 'N', '', 'A11', '一姐', 'C7011', 'DCC&Nuna', '5', 'AA', 0, 0, 0, 0, 53, '', '', 12580, 12580, 0, 8440, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y1', 1006, '30', 'AA13400001', '+1', '2014-11-25', '141129033002', 'Y', 'N', '', 'A11', '一姐', 'Sa074', '小鄭', '5', 'AA', 0, 0, 2980, 0, 1, '', '2014-11-25', 2980, 2980, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13400002', '+1', '2014-11-26', '141127020517', 'Y', 'N', '', 'A11', '一姐', 'Sa039', 'MiNi將公館', '5', 'AA', 0, 0, 4980, 0, 1, '', '2014-11-26', 4980, 4980, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13400003', '+1', '2014-11-19', '141127021033', 'Y', 'N', '', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', 0, 0, 2980, 0, 1, '', '2014-11-19', 2980, 2980, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', '30', 30, '30', 'AA13400004', '+114', '2014-12-09', '141210013739', 'Y', 'N', '', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', 0, 0, 64400, 0, 114, '', '2014-12-09', 64400, 64400, 0, 32588, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', '30', 30, '30', 'AA13500000', '+11', '2014-04-01', '150104024211', 'Y', 'N', '', 'A11', '一姐', 'S3001', '小雅', '5', 'AA', 0, 0, 13000, 0, 11, '', '2013-04-01', 13000, 13000, 0, 7414, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', '30', 30, '30', 'AA13500001', '+16', '2014-04-01', '150104024120', 'Y', 'N', '', 'A11', '一姐', 'S4063', 'ASTARTA', '5', 'AA', 0, 0, 48000, 0, 16, '', '2013-04-01', 48000, 48000, 0, 29440, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500002', '+2', '2014-05-01', '150104023952', 'Y', 'N', '', 'A11', '一姐', 'Ca005', '1109韓服', '5', 'AA', 0, 0, 10980, 0, 2, '', '2014-05-01', 10980, 10980, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500003', '+15', '2013-10-14', '150104025011', 'Y', 'N', '', 'A11', '一姐', 'Sa045', 'Passy東區(掛)', '5', 'AA', 0, 0, 17670, 0, 15, '', '2013-10-14', 17670, 17670, 0, 10240, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', '30', 30, '30', 'AA13500004', '+1', '2013-07-02', '150104031618', 'Y', 'N', '', 'A11', '一姐', 'Ca802', '泛美', '5', 'AA', 0, 0, 1000, 0, 1, '', '2013-07-02', 1000, 1000, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500005', '+1', '2013-07-01', '150104031547', 'Y', 'N', '', 'A11', '一姐', 'Ca801', '藝比特', '5', 'AA', 0, 0, 500, 0, 1, '', '2013-07-01', 500, 500, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500006', '+1', '2013-07-01', '150108232651', 'Y', 'N', '', 'A11', '一姐', 'Ca801', '藝比特', '5', 'AA', 0, 0, 500, 0, 1, '', '2013-07-01', 500, 500, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500007', '+1', '2013-07-02', '150108234056', 'Y', 'N', '', 'A11', '一姐', 'Ca802', '泛美', '5', 'AA', 0, 0, 1000, 0, 1, '', '2013-07-02', 1000, 1000, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500008', '+1', '2013-07-03', '150108235654', 'Y', 'N', '', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', 0, 0, 250, 0, 1, '', '2013-07-03', 250, 250, 0, 190, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500009', '+1', '2015-01-13', '150113155938', 'Y', 'N', '', 'A11', '一姐', 'Sa078', '士林許', '5', 'AA', 0, 0, 4980, 0, 1, '', '2015-01-13', 4980, 4980, 0, 0, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA13500010', '+85', '2015-03-30', '150330074009', 'Y', 'N', '', 'A11', '一姐', 'Ca006', '樺穎', '5', 'AA', 0, 0, 0, 0, 85, '', '', 5750, 5750, 0, 3570, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y2', 1008, '32', 'AA13500011', '+85', '2015-03-30', '150621232450', 'N', 'N', '', 'A11', '一姐', 'Ca006', '樺穎', '5', 'AA', 0, 0, 0, 0, 85, '', '', 5750, 5750, 0, 3570, 0, 0, '1', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 10, '10', 'AA11400000', '+33', '2014-11-24', '150621232707', 'Y', 'N', '', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', 0, 0, 0, 0, 33, '', '', 84867, 84867, 0, 69867, 69867, 0, '3', 'AA1', 0, '', 0, '', '', ''),
('3G010_20123', 'Y2', 1008, '32', 'AA23500000', '+1-1', '2015-10-13', '151013085919', 'N', 'N', '', 'A11', '一姐', '000168', 'VIP', '5', 'AA', 0, 0, 0, 0, 0, '', '', 0, 0, 0, -13, -25, 0, '1', 'AA2', 0, '', 0, '', '', ''),
('3G010_20123', 'Y2', 1008, '32', 'AA23500001', '+2', '2015-10-13', '151013085914', 'N', 'N', '', 'A11', '一姐', '000168', 'VIP', '5', 'AA', 0, 0, 3000, 15000, 2, '', '2015-10-13', 18000, 18000, 0, 0, 18000, 0, '1', 'AA2', 0, '', 0, '', '', ''),
('3G010_20123', 'Y1', 30, '30', 'AA23500002', '+1', '2015-10-13', '151013153538', 'N', 'Y', '', 'A11', '一姐', '000168', 'VIP', '5', 'AA', 0, 0, 0, 0, 1, '', '', 500, 500, 0, 380, 500, 0, '1', 'AA2', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 31, '31', 'AA23500003', '+3', '2015-10-13', '151013153235', 'N', 'Y', '', 'A11', '一姐', '000168', 'VIP', '5', 'A1', 100, 0, 0, 0, 3, '2015-10-13', '', 195, 195, 0, 126, 195, 0, '1', 'AA2', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA6000168', '+1', '2015-10-13', '151013153538', 'R', 'Y', '', 'A11', '一姐', '000168', 'VIP', '5', 'AA', 0, 0, 0, 0, 1, '', '', 250, 250, 0, 190, 500, 0, '1', 'AA2', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AA23600000', '+2', '2016-07-17', '160717101213', 'Y', 'N', '', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', 0, 0, 0, 0, 2, '', '', 4000, 4000, 0, 1680, 4000, 0, '1', 'AA2', 0, '', 0, '', '', ''),
('3G010_20123', 'Y0', 30, '30', 'AAA3700000', '+28', '2017-03-13', '170313002601', 'Y', 'N', '', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', 0, 0, 0, 0, 28, '', '', 124400, 124400, 0, 52020, 133830, 0, '1', 'AAA', 0, '', 0, '', '', '');

-- --------------------------------------------------------

--
-- 表的結構 `qitems`
--

CREATE TABLE IF NOT EXISTS `qitems` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `QKIND` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `FORMNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `HANDNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `FORMDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(12) DEFAULT NULL,
  `ISCONFIRM` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `ISCHECK` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `EMPNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USER` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USERNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNO` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNOS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT1` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT2` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT` double DEFAULT NULL,
  `UNITPRICE` double DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ACOST` double DEFAULT NULL,
  `RATE` double DEFAULT NULL,
  `RATEPRICE` double DEFAULT NULL,
  `REALSUM` double DEFAULT NULL,
  `SUBPRICE` double DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL,
  `COLOR` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `SIZE` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `ORDDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `FINEDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `BATCH` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `SUPPLY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COLORS` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `SIZES` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT10` double DEFAULT NULL,
  `UNIT20` double DEFAULT NULL,
  `UNIT30` double DEFAULT NULL,
  `UNIT40` double DEFAULT NULL,
  `PIC` tinytext,
  `PS` text,
  `SEASON` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `YEAR` varchar(4) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qitems`
--

INSERT INTO `qitems` (`UID`, `TR`, `ID`, `QKIND`, `FORMNO`, `HANDNO`, `FORMDATE`, `CREATEDATETIME`, `ISCONFIRM`, `ISCHECK`, `EMPID`, `EMPNAME`, `USER`, `USERNAME`, `TRADETYPE`, `DEPTNO`, `GOODSNO`, `GOODSNOS`, `SOURCENO`, `UNIT1`, `UNIT2`, `UNIT`, `UNITPRICE`, `DISCOUNT`, `ACOST`, `RATE`, `RATEPRICE`, `REALSUM`, `SUBPRICE`, `P0`, `P1`, `P2`, `P3`, `P4`, `P5`, `COLOR`, `SIZE`, `ORDDATE`, `FINEDATE`, `BATCH`, `SUPPLY`, `GOODSTYPE`, `GOODSNAME`, `COLORS`, `SIZES`, `UNIT10`, `UNIT20`, `UNIT30`, `UNIT40`, `PIC`, `PS`, `SEASON`, `COUNTRY`, `YEAR`) VALUES
('3G010_20123', '30', 0, '30', 'AA13400002', '+0', '2014-11-26', '141127100436', 'Y', 'N', 'A11', '一姐', 'Sa039', 'MiNi將公館', '5', 'AA', '168003', '168003-02-F', '168', '白色', '02', 0, 4980, 100, 0, 1, 0, 0, 4980, 0, 0, 0, 0, 0, 4980, '02', 'F', '', '', '168', 'T01', '軟體合約', '軟體合約4980', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101085045283.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400003', '+0', '2014-11-19', '141127100851', 'Y', 'N', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', '168005', '168005-02-F', '168', '白色', '02', 0, 2980, 100, 0, 1, 0, 0, 2980, 0, 0, 0, 0, 0, 2980, '02', 'F', '', '', '168', 'T01', '軟體合約', '軟體合約2980', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117162706086.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400001', '+0', '2014-11-25', '141127100302', 'Y', 'N', 'A11', '一姐', 'Sa074', '小鄭', '5', 'AA', '168005', '168005-02-F', '168', '白色', '02', 0, 2980, 100, 0, 1, 0, 0, 2980, 0, 0, 0, 0, 0, 2980, '02', 'F', '', '', '168', 'T01', '軟體合約', '軟體合約2980', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117162706086.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210091443', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168009', '168009-02-F', '168', '白色', '02', 0, 15000, 100, 0, 1, 0, 0, 15000, 10500, 0, 0, 15000, 0, 15000, '02', 'F', 'null', 'null', '168', 'T01', '華碩主機', '華碩主機', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/para/img_additem.png', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210091651', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168007', '168007-02-F', '168', '白色', '02', 0, 3000, 100, 0, 1, 0, 0, 3000, 0, 0, 0, 3000, 0, 3000, '02', 'F', 'null', 'null', '168', 'T01', '伺服器安裝費', '伺服器安裝費', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123172413887.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210091839', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168022', '168022-02-F', '168', '白色', '02', 0, 8000, 100, 6800, 1, 0, 0, 8000, 6800, 6800, 0, 8000, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '觸控螢幕 給奇', '觸控螢幕 給奇', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123190245223.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210092016', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168016', '168016-02-F', '168', '白色', '02', 0, 1800, 100, 800, 1, 0, 0, 1800, 800, 800, 0, 2000, 1800, 2000, '02', 'F', 'null', 'null', '168', 'T01', '條碼掃描器 Z3220', '條碼掃描器 Z3220', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123182617012.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210092122', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168020', '168020-02-F', '168', '白色', '02', 0, 2500, 100, 1800, 1, 0, 0, 2500, 1800, 1800, 0, 2500, 0, 2500, '02', 'F', 'null', 'null', '168', 'T01', '錢櫃', '錢櫃 信格', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123184915276.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210092223', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168029', '168029-02-F', '168', '白色', '02', 0, 2000, 100, 1000, 1, 0, 0, 2000, 1000, 1000, 0, 2000, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '控制盒', '控制盒', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123200802713.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210092405', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168030', '168030-02-S', '168', '白色', '02', 0, 8500, 100, 7500, 1, 0, 0, 8500, 7500, 7500, 0, 8800, 0, 8800, '02', 'S', 'null', 'null', '168', 'T01', '平板NOT8', '平板NOT8', '白色', 'S,M,L,XL', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123200641871.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210092552', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168012', '168012-02-F', '168', '白色', '02', 0, 15000, 100, 9200, 1, 0, 0, 15000, 9200, 9200, 0, 15500, 14500, 15500, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX G530 條碼機', 'GODEX G530 條碼機', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123175801602.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+0', '2014-12-09', '141210092651', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168019', '168019-02-F', '168', '白色', '02', 0, 1200, 100, 688, 1, 0, 0, 1200, 688, 688, 0, 1300, 0, 1300, '02', 'F', 'null', 'null', '168', 'T01', '平板NOT8', '分享器', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141126004414276.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+9', '2014-12-09', '141210093514', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168037', '168037-02-F', '168', '白色', '02', 0, 65, 100, 4200, 1, 0, 0, 6500, 42, 42, 0, 65, 0, 65, '02', 'F', 'null', 'null', '168', 'T01', '條碼紙雙層中一刀', '條碼紙雙層直一刀', '白色', 'F', 0, 0, 100, 0, '/mnt/sdcard/cwbuyer/para/img_additem.png', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13400004', '+9', '2014-12-09', '141210093559', 'Y', 'N', 'A11', '一姐', 'Sa077', 'Glass', '5', 'AA', '168027', '168027-02-F', '168', '白色', '02', 0, 180, 100, 600, 1, 0, 0, 900, 120, 120, 0, 180, 0, 180, '02', 'F', 'null', 'null', '168', 'T01', '碳帶40*300m GR100', '碳帶40*300m GR100', '白色', 'F', 0, 0, 5, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123192031229.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500002', '+0', '2014-05-01', '150104103704', 'Y', 'N', 'A11', '一姐', 'Ca005', '1109韓服', '5', 'AA', '168005', '168005-02-F', '168', '白色', '02', 0, 2980, 100, 0, 1, 0, 0, 2980, 0, 0, 0, 0, 0, 2980, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約2980', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117162706086.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500002', '+0', '2014-05-01', '150104103732', 'Y', 'N', 'A11', '一姐', 'Ca005', '1109韓服', '5', 'AA', '168001', '168001-02-F', '168', '白色', '02', 0, 8000, 100, 0, 1, 0, 0, 8000, 0, 0, 0, 0, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約8000', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101084448699.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500001', '+0', '2014-04-01', '150104102422', 'Y', 'N', 'A11', '一姐', 'S4063', 'ASTARTA', '5', 'AA', '168031', '168031-02-F', '168', '白色', '02', 0, 9500, 100, 12400, 1, 0, 0, 19000, 6200, 6200, 0, 7800, 0, 7800, '02', 'F', 'null', 'null', '168', 'T01', '平板 NEXUS二代', '平板 NEXUS二代', '白色', 'F', 0, 0, 2, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123195533967.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500001', '+0', '2014-04-01', '150104102700', 'Y', 'N', 'A11', '一姐', 'S4063', 'ASTARTA', '5', 'AA', '168015', '168015-02-F', '168', '白色', '02', 0, 6500, 100, 9000, 1, 0, 0, 13000, 4500, 4500, 0, 6500, 0, 6500, '02', 'F', 'null', 'null', '168', 'T01', '條馬掃描器 Z3190 BT', '條馬掃描器 Z3190 BT', '白色', 'F', 0, 0, 2, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063140044.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500001', '+5', '2014-04-01', '150104102855', 'Y', 'N', 'A11', '一姐', 'S4063', 'ASTARTA', '5', 'AA', '168026', '168026-02-F', '168', '白色', '02', 0, 90, 100, 420, 1, 0, 0, 900, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼貼紙 單層', '35*25*1400張', '白色', 'F', 0, 0, 10, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061801372.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500001', '+16', '2014-04-01', '150104103030', 'Y', 'N', 'A11', '一姐', 'S4063', 'ASTARTA', '5', 'AA', '168027', '168027-02-F', '168', '白色', '02', 0, 250, 100, 120, 1, 0, 0, 250, 120, 120, 0, 180, 0, 180, '02', 'F', 'null', 'null', '168', 'T01', '碳帶40*300m GR100', '碳帶40*300m GR100', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061604706.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500001', '+16', '2014-04-01', '150104103103', 'Y', 'N', 'A11', '一姐', 'S4063', 'ASTARTA', '5', 'AA', '168014', '168014-02-F', '168', '白色', '02', 0, 14850, 100, 7500, 1, 0, 0, 14850, 7500, 7500, 0, 13000, 12500, 13000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX G500 條碼機', 'GODEX G500 條碼機', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063509949.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500000', '+0', '2014-04-01', '150104101834', 'Y', 'N', 'A11', '一姐', 'S3001', '小雅', '5', 'AA', '168028', '168028-02-F', '168', '白色', '02', 0, 90, 100, 120, 1, 0, 0, 270, 40, 40, 0, 80, 0, 80, '02', 'F', 'null', 'null', '168', 'T01', '碳帶46*91m MR-102 ', '碳帶46*91m MR-102 ', '白色', 'F', 0, 0, 3, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061434248.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500000', '+0', '2014-04-01', '150104101906', 'Y', 'N', 'A11', '一姐', 'S3001', '小雅', '5', 'AA', '168025', '168025-02-F', '168', '白色', '02', 0, 90, 100, 294, 1, 0, 0, 630, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼紙雙層中一刀', '35*25*1000張', '白色', 'F', 0, 0, 7, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061845015.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500000', '+11', '2014-04-01', '150104102019', 'Y', 'N', 'A11', '一姐', 'S3001', '小雅', '5', 'AA', '168010', '168010-02-F', '168', '白色', '02', 0, 12100, 100, 7000, 1, 0, 0, 12100, 7000, 7000, 0, 12000, 0, 12000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX RT200 條碼機', 'GODEX RT200 條碼機', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064012282.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500003', '+0', '2013-10-14', '150104104524', 'Y', 'N', 'A11', '一姐', 'Sa045', 'Passy東區(掛)', '5', 'AA', '168010', '168010-02-F', '168', '白色', '02', 0, 12000, 100, 7000, 1, 0, 0, 12000, 7000, 7000, 0, 12000, 0, 12000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX RT200 條碼機', 'GODEX RT200 條碼機', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064012282.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500003', '+0', '2013-10-14', '150104104616', 'Y', 'N', 'A11', '一姐', 'Sa045', 'Passy東區(掛)', '5', 'AA', '168017', '168017-02-F', '168', '白色', '02', 0, 4500, 100, 2700, 1, 0, 0, 4500, 2700, 2700, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', 'MINI 掃描器 MT1097', 'MINI 掃描器 MT1097', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123182802117.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500003', '+0', '2013-10-14', '150104104811', 'Y', 'N', 'A11', '一姐', 'Sa045', 'Passy東區(掛)', '5', 'AA', '168025', '168025-02-F', '168', '白色', '02', 0, 90, 100, 420, 1, 0, 0, 900, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼紙雙層中一刀', '35*25*1000張', '白色', 'F', 0, 0, 10, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061845015.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500003', '+0', '2013-10-14', '150104104910', 'Y', 'N', 'A11', '一姐', 'Sa045', 'Passy東區(掛)', '5', 'AA', '168028', '168028-02-F', '168', '白色', '02', 0, 90, 100, 120, 1, 0, 0, 270, 40, 40, 0, 80, 0, 80, '02', 'F', 'null', 'null', '168', 'T01', '碳帶46*91m MR-102 ', '碳帶46*91m MR-102 ', '白色', 'F', 0, 0, 3, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061434248.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500005', '+1', '2013-07-01', '150104111517', 'Y', 'N', 'A11', '一姐', 'Ca801', '藝比特', '5', 'AA', '168004', '168004-02-F', '168', '白色', '02', 0, 500, 100, 0, 1, 0, 0, 500, 0, 0, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064058072.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500004', '+2', '2013-07-02', '150104111353', 'Y', 'N', 'A11', '一姐', 'Ca802', '泛美', '5', 'AA', '168004', '168004-02-F', '168', '白色', '02', 0, 1000, 100, 0, 1, 0, 0, 1000, 0, 0, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064058072.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500006', '+0', '2013-07-01', '150109072458', 'Y', 'N', 'A11', '一姐', 'Ca801', '藝比特', '5', 'AA', '168038', '168038-02-F', '168', '白色', '02', 0, 500, 100, 0, 1, 0, 0, 500, 0, 0, 0, 500, 0, 500, '02', 'F', 'null', 'null', '168', 'T01', '維護費', '維護費', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20150109071709475.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500007', '+0', '2013-07-02', '150109073919', 'Y', 'N', 'A11', '一姐', 'Ca802', '泛美', '5', 'AA', '168038', '168038-02-F', '168', '白色', '02', 0, 1000, 100, 0, 1, 0, 0, 1000, 0, 0, 0, 500, 0, 500, '02', 'F', 'null', 'null', '168', 'T01', '維護費', '維護費', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20150109071709475.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168001', '168001-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約8000', '白色', 'F', 1000, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101084448699.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168003', '168003-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 4980, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約4980', '白色', 'F', 1000, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101085045283.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168006', '168006-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約2000', '白色', 'F', 1000, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101085314781.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168005', '168005-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2980, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約2980', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117162706086.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168002', '168002-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 6000, 0, 6000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約6000', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117163000461.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168004', '168004-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064058072.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168009', '168009-02-F', '168', '白色', '02', 0, 10500, 100, 0, 1, 210000, 0, 210000, 10500, 0, 0, 15000, 0, 15000, '02', 'F', 'null', 'null', '168', 'T01', '華碩主機', '華碩主機', '白色', 'F', 20, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221060511464.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168007', '168007-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 3000, 0, 3000, '02', 'F', 'null', 'null', '168', 'T01', '伺服器安裝費', '伺服器安裝費', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123172413887.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168008', '168008-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 2000, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '門市電腦安裝費', '門市電腦安裝費', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123172541815.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168010', '168010-02-F', '168', '白色', '02', 0, 7000, 100, 1400000, 1, 1400000, 0, 1400000, 7000, 7000, 0, 12000, 0, 12000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX 條碼機', 'GODEX RT200 條碼機', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064012282.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168011', '168011-02-F', '168', '白色', '02', 0, 4500, 100, 0, 1, 900000, 0, 900000, 4500, 0, 0, 7000, 0, 7000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX 條碼機', 'GODEX DT2 條碼機', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063711398.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168012', '168012-02-F', '168', '白色', '02', 0, 9200, 100, 1840000, 1, 1840000, 0, 1840000, 9200, 9200, 0, 15500, 14500, 15500, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX 條碼機', 'GODEX G530 條碼機', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063635040.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168013', '168013-02-F', '168', '白色', '02', 0, 5200, 100, 1040000, 1, 1040000, 0, 1040000, 5200, 5200, 0, 9500, 0, 9500, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX 條碼機', 'GODEX G300 條碼機', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063605337.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168014', '168014-02-F', '168', '白色', '02', 0, 7500, 100, 1500000, 1, 1500000, 0, 1500000, 7500, 7500, 0, 13000, 12500, 13000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX 條碼機', 'GODEX G500 條碼機', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063509949.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168015', '168015-02-F', '168', '白色', '02', 0, 4500, 100, 900000, 1, 900000, 0, 900000, 4500, 4500, 0, 6500, 0, 6500, '02', 'F', 'null', 'null', '168', 'T01', '掃描器', '條馬掃描器 Z3190 BT', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063140044.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168016', '168016-02-F', '168', '白色', '02', 0, 800, 100, 160000, 1, 160000, 0, 160000, 800, 800, 0, 2000, 1800, 2000, '02', 'F', 'null', 'null', '168', 'T01', '掃描器', '條碼掃描器 Z3220', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221062934318.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168017', '168017-02-F', '168', '白色', '02', 0, 2700, 100, 540000, 1, 540000, 0, 540000, 2700, 2700, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', '掃描器', 'MINI 掃描器 MT1097', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123182802117.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168018', '168018-02-F', '168', '白色', '02', 0, 42, 100, 8400, 1, 8400, 0, 8400, 42, 42, 0, 100, 0, 100, '02', 'F', 'null', 'null', '168', 'T01', '線 材', 'PC轉接線 OTG', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123183609309.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168019', '168019-02-F', '168', '白色', '02', 0, 688, 100, 1376, 1, 1376, 0, 1376, 688, 688, 0, 1300, 0, 1300, '02', 'F', 'null', 'null', '168', 'T01', '分享器', '分享器', '白色', 'F', 2, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221062333598.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168020', '168020-02-F', '168', '白色', '02', 0, 1800, 100, 360000, 1, 360000, 0, 360000, 1800, 1800, 0, 2500, 0, 2500, '02', 'F', 'null', 'null', '168', 'T01', '錢櫃', '錢櫃 信格', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123184915276.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168021', '168021-02-F', '168', '白色', '02', 0, 7350, 100, 1470000, 1, 1470000, 0, 1470000, 7350, 7350, 0, 8000, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '觸控螢幕', '觸控螢幕TD2220', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063419959.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168022', '168022-02-F', '168', '白色', '02', 0, 6800, 100, 1360000, 1, 1360000, 0, 1360000, 6800, 6800, 0, 8000, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '觸控螢幕', '觸控螢幕 給奇', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123190245223.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168023', '168023-02-F', '168', '白色', '02', 0, 29, 100, 5800, 1, 5800, 0, 5800, 29, 29, 0, 45, 0, 45, '02', 'F', 'null', 'null', '168', 'T01', '熱感紙捲', '80mm*80M', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123190531377.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168024', '168024-02-F', '168', '白色', '02', 0, 42, 100, 8400, 1, 8400, 0, 8400, 42, 42, 0, 60, 0, 60, '02', 'F', 'null', 'null', '168', 'T01', '熱感紙捲', '60*mm*100M', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221062224195.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168025', '168025-02-F', '168', '白色', '02', 0, 42, 100, 8400, 1, 8400, 0, 8400, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼貼紙', '35*25*1000張', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061845015.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168026', '168026-02-F', '168', '白色', '02', 0, 42, 100, 4200, 1, 4200, 0, 4200, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼貼紙', '35*25*1400張', '白色', 'F', 100, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061801372.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168027', '168027-02-F', '168', '白色', '02', 0, 120, 100, 24000, 1, 24000, 0, 24000, 120, 120, 0, 180, 0, 180, '02', 'F', 'null', 'null', '168', 'T01', '碳帶', '碳帶40*300m GR100', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061604706.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168028', '168028-02-F', '168', '白色', '02', 0, 40, 100, 8000, 1, 8000, 0, 8000, 40, 40, 0, 80, 0, 80, '02', 'F', 'null', 'null', '168', 'T01', '碳帶', '碳帶46*91m MR-102 ', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061434248.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168029', '168029-02-F', '168', '白色', '02', 0, 1000, 100, 200000, 1, 200000, 0, 200000, 1000, 1000, 0, 2000, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '控制盒', '控制盒', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123200802713.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168030', '168030-02-S', '168', '白色', '02', 0, 7500, 100, 1500000, 1, 1500000, 0, 1500000, 7500, 7500, 0, 8800, 0, 8800, '02', 'S', 'null', 'null', '168', 'T01', '平板', '平板NOTE8', '白色', 'S,M,L,XL', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123200641871.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168031', '168031-02-F', '168', '白色', '02', 0, 6200, 100, 1240000, 1, 1240000, 0, 1240000, 6200, 6200, 0, 7800, 0, 7800, '02', 'F', 'null', 'null', '168', 'T01', '平板', '平板 NEXUS二代', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123195533967.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168032', '168032-02-F', '168', '白色', '02', 0, 1050, 100, 210000, 1, 210000, 0, 210000, 1050, 1050, 0, 1500, 0, 1500, '02', 'F', 'null', 'null', '168', 'T01', '記憶體', '記憶體', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123193924723.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', '666', 'null', 'T01', 'T01', '0', 'AA', '168033', '168033-02-F', '168', '白色', '02', 0, 250, 100, 50000, 1, 50000, 0, 50000, 250, 250, 0, 400, 0, 400, '02', 'F', 'null', 'null', '168', 'T01', '藍芽接受器', '藍芽接受器', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123194353427.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168034', '168034-02-F', '168', '白色', '02', 0, 2066, 100, 413200, 1, 413200, 0, 413200, 2066, 2066, 0, 3000, 0, 3000, '02', 'F', 'null', 'null', '168', 'T01', '固態硬碟', '創見', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061238984.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168035', '168035-02-F', '168', '白色', '02', 0, 1800, 100, 360000, 1, 360000, 0, 360000, 1800, 1800, 0, 3000, 0, 3000, '02', 'F', 'null', 'null', '168', 'T01', '固態硬碟', '台製硬碟', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061102205.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168036', '168036-02-F', '168', '白色', '02', 0, 250, 100, 50000, 1, 50000, 0, 50000, 250, 250, 0, 450, 0, 450, '02', 'F', 'null', 'null', '168', 'T01', '集線器', 'Swich 集線器', '白色', 'F', 200, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221060723850.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168037', '168037-02-F', '168', '白色', '02', 0, 42, 100, 4200, 1, 4200, 0, 4200, 42, 42, 0, 65, 0, 65, '02', 'F', 'null', 'null', '168', 'T01', '條碼貼紙', '條碼紙雙層直一刀', '白色', 'F', 100, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221060929189.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA1168', '168', '2015-01-09', '1501090751', 'Y', 'n', 'AA1', 'null', 'T01', 'T01', '0', 'AA', '168038', '168038-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 500, 0, 500, '02', 'F', 'null', 'null', '168', 'T01', '維護費', '維護費', '白色', 'F', 100, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20150109071709475.jpg', 'null', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500008', '+0', '2013-07-03', '150109075437', 'Y', 'N', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', '169001', '169001-02-F', '169', '白色', '02', 0, 250, 100, 190, 1, 0, 0, 250, 190, 190, 0, 250, 0, 250, '02', 'F', 'null', 'null', '168', 'T01', '吊牌', '吊牌', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20150109074935164.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500009', '+0', '2015-01-13', '150113235910', 'Y', 'N', 'A11', '一姐', 'Sa078', '士林許', '5', 'AA', '168003', '168003-02-F', '168', '白色', '02', 0, 4980, 100, 0, 1, 0, 0, 4980, 0, 0, 0, 0, 0, 4980, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約4980', '白色', 'F', 0, 0, 1, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101085045283.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500010', '+0', '2015-03-30', '150330153419', 'Y', 'N', 'A11', '一姐', 'Ca006', '樺穎', '5', 'AA', '168025', '168025-02-F', '168', '白色', '02', 0, 70, 100, 2100, 1, 0, 0, 3500, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼紙雙層中一刀', '35*25*1000張', '白色', 'F', 0, 0, 50, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061845015.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500010', '+0', '2015-03-30', '150330153508', 'Y', 'N', 'A11', '一姐', 'Ca006', '樺穎', '5', 'AA', '168023', '168023-02-F', '168', '白色', '02', 0, 45, 100, 870, 1, 0, 0, 1350, 29, 29, 0, 45, 0, 45, '02', 'F', 'null', 'null', '168', 'T01', '熱感紙捲', '80mm*80M', '白色', 'F', 0, 0, 30, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123190531377.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA13500010', '+0', '2015-03-30', '150330153544', 'Y', 'N', 'A11', '一姐', 'Ca006', '樺穎', '5', 'AA', '168027', '168027-02-F', '168', '白色', '02', 0, 180, 100, 600, 1, 0, 0, 900, 120, 120, 0, 180, 0, 180, '02', 'F', 'null', 'null', '168', 'T01', '碳帶40*300m GR100', '碳帶40*300m GR100', '白色', 'F', 0, 0, 5, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061604706.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115332', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168001', '168001-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約8000', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101084448699.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115348', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168002', '168002-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 6000, 0, 6000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約6000', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117163000461.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115401', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168003', '168003-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 4980, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約4980', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101085045283.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115416', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168004', '168004-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064058072.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115428', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168005', '168005-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2980, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約2980', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141117162706086.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115439', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168006', '168006-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '軟體合約', '軟體合約2000', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard//cwbuyer/IMPORT/20123/168/mtr_20141101085314781.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115449', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168007', '168007-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 3000, 0, 3000, '02', 'F', 'null', 'null', '168', 'T01', '伺服器安裝費', '伺服器安裝費', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123172413887.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115500', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168008', '168008-02-F', '168', '白色', '02', 0, 0, 100, 0, 1, 0, 0, 0, 0, 0, 0, 2000, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '門市電腦安裝費', '門市電腦安裝費', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123172541815.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115510', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168009', '168009-02-F', '168', '白色', '02', 0, 10500, 100, 0, 1, 0, 0, 10500, 10500, 0, 0, 15000, 0, 15000, '02', 'F', 'null', 'null', '168', 'T01', '華碩主機', '華碩主機', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221060511464.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115524', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168010', '168010-02-F', '168', '白色', '02', 0, 7000, 100, 7000, 1, 0, 0, 7000, 7000, 7000, 0, 12000, 0, 12000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX RT200 條碼機', 'GODEX RT200 條碼機', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221064012282.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115533', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168011', '168011-02-F', '168', '白色', '02', 0, 4500, 100, 0, 1, 0, 0, 4500, 4500, 0, 0, 7000, 0, 7000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX DT2 條碼機', 'GODEX DT2 條碼機', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063711398.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115544', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168012', '168012-02-F', '168', '白色', '02', 0, 9200, 100, 9200, 1, 0, 0, 9200, 9200, 9200, 0, 15500, 14500, 15500, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX G530 條碼機', 'GODEX G530 條碼機', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063635040.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115557', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168013', '168013-02-F', '168', '白色', '02', 0, 5200, 100, 5200, 1, 0, 0, 5200, 5200, 5200, 0, 9500, 0, 9500, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX G300 條碼機', 'GODEX G300 條碼機', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063605337.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115607', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168014', '168014-02-F', '168', '白色', '02', 0, 7500, 100, 7500, 1, 0, 0, 7500, 7500, 7500, 0, 13000, 12500, 13000, '02', 'F', 'null', 'null', '168', 'T01', 'GODEX G500 條碼機', 'GODEX G500 條碼機', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063509949.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115616', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168015', '168015-02-F', '168', '白色', '02', 0, 4500, 100, 4500, 1, 0, 0, 4500, 4500, 4500, 0, 6500, 0, 6500, '02', 'F', 'null', 'null', '168', 'T01', '條馬掃描器 Z3190 BT', '條馬掃描器 Z3190 BT', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063140044.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115626', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168016', '168016-02-F', '168', '白色', '02', 0, 800, 100, 800, 1, 0, 0, 800, 800, 800, 0, 2000, 1800, 2000, '02', 'F', 'null', 'null', '168', 'T01', '條碼掃描器 Z3220', '條碼掃描器 Z3220', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221062934318.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115636', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168017', '168017-02-F', '168', '白色', '02', 0, 2700, 100, 2700, 1, 0, 0, 2700, 2700, 2700, 0, 4000, 0, 4000, '02', 'F', 'null', 'null', '168', 'T01', 'MINI 掃描器 MT1097', 'MINI 掃描器 MT1097', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123182802117.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115646', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168018', '168018-02-F', '168', '白色', '02', 0, 42, 100, 42, 1, 0, 0, 42, 42, 42, 0, 100, 0, 100, '02', 'F', 'null', 'null', '168', 'T01', '線 材', 'PC轉接線 OTG', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123183609309.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115656', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168019', '168019-02-F', '168', '白色', '02', 0, 1000, 100, 1000, 1, 0, 0, 1000, 688, 688, 0, 1300, 0, 1300, '02', 'F', 'null', 'null', '168', 'T01', '平板NOT8', '分享器', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221062333598.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115706', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168020', '168020-02-F', '168', '白色', '02', 0, 1800, 100, 1800, 1, 0, 0, 1800, 1800, 1800, 0, 2500, 0, 2500, '02', 'F', 'null', 'null', '168', 'T01', '錢櫃', '錢櫃 信格', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123184915276.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115715', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168021', '168021-02-F', '168', '白色', '02', 0, 7350, 100, 7350, 1, 0, 0, 7350, 7350, 7350, 0, 8000, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '觸控螢幕TD2220', '觸控螢幕TD2220', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221063419959.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115725', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168022', '168022-02-F', '168', '白色', '02', 0, 6800, 100, 6800, 1, 0, 0, 6800, 6800, 6800, 0, 8000, 0, 8000, '02', 'F', 'null', 'null', '168', 'T01', '觸控螢幕 給奇', '觸控螢幕 給奇', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123190245223.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115734', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168023', '168023-02-F', '168', '白色', '02', 0, 29, 100, 29, 1, 0, 0, 29, 29, 29, 0, 45, 0, 45, '02', 'F', 'null', 'null', '168', 'T01', '熱感紙捲', '80mm*80M', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123190531377.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115743', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168024', '168024-02-F', '168', '白色', '02', 0, 42, 100, 42, 1, 0, 0, 42, 42, 42, 0, 60, 0, 60, '02', 'F', 'null', 'null', '168', 'T01', '熱感紙捲', '60*mm*100M', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221062224195.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115752', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168025', '168025-02-F', '168', '白色', '02', 0, 42, 100, 42, 1, 0, 0, 42, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼紙雙層中一刀', '35*25*1000張', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061845015.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115802', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168026', '168026-02-F', '168', '白色', '02', 0, 42, 100, 42, 1, 0, 0, 42, 42, 42, 0, 70, 0, 70, '02', 'F', 'null', 'null', '168', 'T01', '條碼貼紙 單層', '35*25*1400張', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061801372.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115811', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168027', '168027-02-F', '168', '白色', '02', 0, 120, 100, 120, 1, 0, 0, 120, 120, 120, 0, 180, 0, 180, '02', 'F', 'null', 'null', '168', 'T01', '碳帶40*300m GR100', '碳帶40*300m GR100', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061604706.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115820', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168028', '168028-02-F', '168', '白色', '02', 0, 40, 100, 40, 1, 0, 0, 40, 40, 40, 0, 80, 0, 80, '02', 'F', 'null', 'null', '168', 'T01', '碳帶46*91m MR-102 ', '碳帶46*91m MR-102 ', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141221061434248.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115828', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168029', '168029-02-F', '168', '白色', '02', 0, 660, 100, 660, 1, 0, 0, 660, 1000, 1000, 0, 2000, 0, 2000, '02', 'F', 'null', 'null', '168', 'T01', '控制盒', '控制盒', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123200802713.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115845', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168030', '168030-02-S', '168', '白色', '02', 0, 7500, 100, 7500, 1, 0, 0, 7500, 7500, 7500, 0, 8800, 0, 8800, '02', 'S', 'null', 'null', '168', 'T01', '平板NOT8', '平板NOTE8', '白色', 'S,M,L,XL', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123200641871.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115902', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168031', '168031-02-F', '168', '白色', '02', 0, 6200, 100, 6200, 1, 0, 0, 6200, 6200, 6200, 0, 7800, 0, 7800, '02', 'F', 'null', 'null', '168', 'T01', '平板 NEXUS二代', '平板 NEXUS二代', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123195533967.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115911', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168032', '168032-02-F', '168', '白色', '02', 0, 1050, 100, 1050, 1, 0, 0, 1050, 1050, 1050, 0, 1500, 0, 1500, '02', 'F', 'null', 'null', '168', 'T01', '記憶體', '記憶體', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123193924723.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '10', 0, '10', 'AA11400000', 'null', '2014-11-24', '141124115919', 'Y', 'N', 'A11', '一姐', 'K001', '預設廠商', '0', 'AA', '168033', '168033-02-F', '168', '白色', '02', 0, 250, 100, 250, 1, 0, 0, 250, 250, 250, 0, 400, 0, 400, '02', 'F', 'null', 'null', '168', 'T01', '藍芽接受器', '藍芽接受器', '白色', 'F', 1, 0, 0, 0, '/mnt/sdcard/cwbuyer/IMPORT/20123/168/mtr_20141123194353427.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '31', 0, '31', 'AA23500003', '+0', '2015-10-13', '151013233220', 'N', 'Y', 'A11', '一姐', '000168', 'VIP', '5', 'A1', '168037', '168037-02-F', '168', '白色', '02', 3, 65, 100, 126, 1, 0, 0, 195, 42, 42, 0, 65, 0, 65, '02', 'F', '0', 'null', '168', 'T01', '條碼貼紙', '條碼紙雙層直一刀', '白色', 'F', 0, 0, 3, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221060929189.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA23500002', '+0', '2015-10-13', '151013224432', 'O', 'Y', 'A11', '一姐', '000168', 'VIP', '5', 'AA', '169001', '169001-02-F', '169', '白色', '02', 1, 250, 100, 380, 1, 0, 0, 500, 190, 190, 0, 250, 0, 250, '02', 'F', '0', 'null', '168', 'T01', '吊牌', '吊牌', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20150109074935164.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA6000168', '+0', '2015-10-13', '151013224432', 'R', 'Y', 'A11', '一姐', '000168', 'VIP', '5', 'AA', '169001', '169001-02-F', '169', '白色', '02', 1, 250, 100, 190, 1, 0, 0, 250, 190, 190, 0, 250, 0, 250, '02', 'F', '0', 'null', '168', 'T01', '吊牌', '吊牌', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20150109074935164.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA23600000', '+0', '2016-07-17', '160717180744', 'Y', 'N', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', '668001', '668001-02-F', '668', '白色', '02，01', 0, 2000, 100, 840, 1, 0, 0, 2000, 840, 840, 0, 2000, 0, 2000, '02', 'F', '1', 'null', '668', 'T01', '分享器', '分享器', '白色，黑色', 'F', 0, 0, 1, 0, '/storage/sdcard0/cwbuyer/IMPORT/20123/668/mtr_20160717180426212.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AA23600000', '+0', '2016-07-17', '160717180744', 'Y', 'N', 'A11', '一姐', 'A009', 'VIP', '5', 'AA', '668001', '668001-01-F', '668', '黑色', '02，01', 0, 2000, 100, 840, 1, 0, 0, 2000, 840, 840, 0, 2000, 0, 2000, '01', 'F', '1', 'null', '668', 'T01', '分享器', '分享器', '白色，黑色', 'F', 0, 0, 1, 0, '/storage/sdcard0/cwbuyer/IMPORT/20123/668/mtr_20160717180426212.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080145', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168027', '168027-02-F', '168', '白色', '02', 0, 200, 100, 120, 1, 0, 0, 200, 120, 120, 0, 180, 0, 180, '02', 'F', '0', 'null', '168', 'T01', '碳帶', '碳帶40*300mGR100', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221061604706.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080304', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168009', '168009-02-F', '168', '白色', '02', 0, 20000, 100, 0, 1, 0, 0, 20000, 10500, 0, 0, 15000, 0, 15000, '02', 'F', '0', 'null', '168', 'T01', '華碩主機', '華碩主機', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221060511464.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080334', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168009', '168009-02-F', '168', '白色', '02', 0, 11000, 100, 0, 1, 0, 0, 33000, 10500, 0, 0, 15000, 0, 15000, '02', 'F', '0', 'null', '168', 'T01', '華碩主機', '華碩主機', '白色', 'F', 0, 0, 3, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221060511464.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080414', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168037', '168037-02-F', '168', '白色', '02', 0, 70, 100, 420, 1, 0, 0, 700, 42, 42, 0, 65, 0, 65, '02', 'F', '0', 'null', '168', 'T01', '條碼貼紙', '條碼紙雙層直一刀', '白色', 'F', 0, 0, 10, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221060929189.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080454', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168014', '168014-02-F', '168', '白色', '02', 0, 13500, 100, 7500, 1, 0, 0, 13500, 7500, 7500, 0, 13000, 12500, 13000, '02', 'F', '0', 'null', '168', 'T01', 'GODEX條碼機', 'GODEXG500條碼機', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221063509949.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080515', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168013', '168013-02-F', '168', '白色', '02', 0, 9500, 100, 5200, 1, 0, 0, 9500, 5200, 5200, 0, 9500, 0, 9500, '02', 'F', '0', 'null', '168', 'T01', 'GODEX條碼機', 'GODEXG300條碼機', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221063605337.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080559', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '668001', '668001-01-F', '668', '黑色', '02，01', 0, 1800, 100, 840, 1, 0, 0, 1800, 840, 840, 0, 2000, 0, 2000, '01', 'F', '1', 'null', '668', 'T01', '分享器', '分享器', '白色，黑色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/668/mtr_20160717184835480.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080622', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '668001', '668001-01-F', '668', '黑色', '02，01', 0, 800, 100, 840, 1, 0, 0, 800, 840, 840, 0, 2000, 0, 2000, '01', 'F', '1', 'null', '668', 'T01', '分享器', '分享器', '白色，黑色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/668/mtr_20160717184835480.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+0', '2017-03-13', '170313080652', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168021', '168021-02-F', '168', '白色', '02', 0, 7800, 100, 29400, 1, 0, 0, 31200, 7350, 7350, 0, 8000, 0, 8000, '02', 'F', '0', 'null', '168', 'T01', '觸控螢幕', '觸控螢幕TD2220', '白色', 'F', 0, 0, 4, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221063419959.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+23', '2017-03-13', '170313080831', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168015', '168015-02-F', '168', '白色', '02', 0, 6500, 100, 4500, 1, 0, 0, 6500, 4500, 4500, 0, 6500, 0, 6500, '02', 'F', '0', 'null', '168', 'T01', '掃描器', '條馬掃描器Z3190BT', '白色', 'F', 0, 0, 1, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221063140044.jpg', '', '4', '台灣', '2014'),
('3G010_20123', '30', 0, '30', 'AAA3700000', '+23', '2017-03-13', '170313080901', 'Y', 'N', 'A11', '一姐', 'CW7313', 'SOEN', '5', 'AA', '168016', '168016-02-F', '168', '白色', '02', 0, 1800, 100, 3200, 1, 0, 0, 7200, 800, 800, 0, 2000, 1800, 2000, '02', 'F', '0', 'null', '168', 'T01', '掃描器', '條碼掃描器Z3220', '白色', 'F', 0, 0, 4, 0, '/storage/emulated/0/cwbuyer/IMPORT/20123/168/mtr_20141221062934318.jpg', '', '4', '台灣', '2014');

-- --------------------------------------------------------

--
-- 表的結構 `qmacc`
--

CREATE TABLE IF NOT EXISTS `qmacc` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `QKIND` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `FORMNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `FORMDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CTIME` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `UTIME` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `ISCONFIRM` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `QATYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QNOM` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `QNOI` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `MOUT` double DEFAULT NULL,
  `MINTO` double DEFAULT NULL,
  `MBEFORE` double DEFAULT NULL,
  `MBALANCE` double DEFAULT NULL,
  `MBETWEEN` double DEFAULT NULL,
  `MAFTER` double DEFAULT NULL,
  `DEPTNO` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `DEVISE` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ATMNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `ATMNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `ATMDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `EMPNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qmtrm`
--

CREATE TABLE IF NOT EXISTS `qmtrm` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `MID` int(11) DEFAULT NULL,
  `SUPPLY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT1` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT2` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT` double DEFAULT NULL,
  `BATCH` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `BILL` double DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `ADDCOST` double DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL,
  `SEASON` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `COLORS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(16) DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `PICTURE` text,
  `QUALITY_ID` int(11) DEFAULT NULL,
  `WASH_ID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qmtrs`
--

CREATE TABLE IF NOT EXISTS `qmtrs` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `MID` int(11) DEFAULT NULL,
  `ID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNOS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COLORNO` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `COLOR` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `SIZE` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `IMPO` double DEFAULT NULL,
  `IMPOS` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `OUTPO` double DEFAULT NULL,
  `OUTPOS` double DEFAULT NULL,
  `SPOS` double DEFAULT NULL,
  `SPOSS` double DEFAULT NULL,
  `IM_OUTSTK` double DEFAULT NULL,
  `IM_POSSTK` double DEFAULT NULL,
  `ORD` double DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `qpandn`
--

CREATE TABLE IF NOT EXISTS `qpandn` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `PNDNFKIND` int(11) DEFAULT NULL,
  `PNDNPKIND` int(11) DEFAULT NULL,
  `PNDNCKIND` int(11) DEFAULT NULL,
  `PNDNSTATE` int(11) DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `USER` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USERNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `PNDNADAY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `PNDNBDAY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(36) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `UNITPRICE` int(11) DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ACOST` double DEFAULT NULL,
  `EXPRICE` double DEFAULT NULL,
  `DATA` varchar(4096) CHARACTER SET utf8 DEFAULT NULL,
  `DATA0` varchar(4096) CHARACTER SET utf8 DEFAULT NULL,
  `PNDNDD` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTSNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `PARTSNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `LASTSTKN` int(11) DEFAULT NULL,
  `LASTSTKM` double DEFAULT NULL,
  `AINN` int(11) DEFAULT NULL,
  `AINM` double DEFAULT NULL,
  `ASTN` int(11) DEFAULT NULL,
  `ASTM` double DEFAULT NULL,
  `ASTKN` int(11) DEFAULT NULL,
  `ASTKM` double DEFAULT NULL,
  `APANN` int(11) DEFAULT NULL,
  `APANM` double DEFAULT NULL,
  `ADEFN` int(11) DEFAULT NULL,
  `ADEFM` double DEFAULT NULL,
  `CDT` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `APIN` int(11) DEFAULT NULL,
  `SDT` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的結構 `update_yn`
--

CREATE TABLE IF NOT EXISTS `update_yn` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `Q1` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q2` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q3` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q4` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q5` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q6` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q7` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q8` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q9` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q10` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q11` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q12` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q13` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q14` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q15` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q16` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q17` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q18` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q19` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q20` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q21` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q22` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q23` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q24` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q25` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q26` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q27` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q28` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q29` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q30` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `DEVISE` varchar(12) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `update_yn`
--

INSERT INTO `update_yn` (`UID`, `Q1`, `Q2`, `Q3`, `Q4`, `Q5`, `Q6`, `Q7`, `Q8`, `Q9`, `Q10`, `Q11`, `Q12`, `Q13`, `Q14`, `Q15`, `Q16`, `Q17`, `Q18`, `Q19`, `Q20`, `Q21`, `Q22`, `Q23`, `Q24`, `Q25`, `Q26`, `Q27`, `Q28`, `Q29`, `Q30`, `DEVISE`) VALUES
('3G010_20123', '100000000000', '150108234714', '141124032647', '100000000000', '150108234924', '100000000000', '100000000000', '170308034146', '170313001535', '170308034145', '100000000000', '170313002601', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '1', '100000000000', '1', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA0'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '151011001813', '100000000000', '150621232707', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '1', '100000000000', '1', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA1'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '160717105401', '100000000000', '160717101213', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '1', '100000000000', '1', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA2'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA3'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'A11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'B11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'C11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'D11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'E11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'F11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'G11'),
('3G010_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'H11');

-- --------------------------------------------------------

--
-- 表的結構 `web_info`
--

CREATE TABLE IF NOT EXISTS `web_info` (
  `web_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水編號',
  `web_mode` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'footer模式選擇',
  `web_content` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'footer內容',
  `web_extension` text COLLATE utf8_unicode_ci COMMENT '保留_用於延伸功能',
  PRIMARY KEY (`web_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- 轉存資料表中的資料 `web_info`
--

INSERT INTO `web_info` (`web_id`, `web_mode`, `web_content`, `web_extension`) VALUES
(1, 'index', '1234010_794264063968067_6917766777345863845_n.jpg', '1'),
(2, 'index', '10410653_798677313526742_7805153780910238614_n.jpg', '2'),
(3, 'index', '10362376_793178147409992_5380605959974036311_n.jpg', '3'),
(4, 'index', '10346271_795118400549300_7055907741190574998_n.jpg', '4'),
(5, 'index', '10311752_787714347956372_8733761965507660314_n.jpg', '5'),
(6, 'index', '10154892_797033700357770_5937167687260495313_n.jpg', '6');

-- --------------------------------------------------------

--
-- 表的結構 `web_msg_board`
--

CREATE TABLE IF NOT EXISTS `web_msg_board` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水編號',
  `msg_userNo` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '使用者編號',
  `msg_content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '留言內容',
  `msg_reply` text COLLATE utf8_unicode_ci COMMENT '回覆內容',
  `msg_createTime` datetime NOT NULL COMMENT '留言時間',
  `msg_replyTime` datetime DEFAULT NULL COMMENT '回覆時間',
  PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的結構 `web_prod_introduction`
--

CREATE TABLE IF NOT EXISTS `web_prod_introduction` (
  `prod_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水編號',
  `BATCH` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT '批號',
  `GOODSNO` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '商品編號',
  `prod_detail` text COLLATE utf8_unicode_ci NOT NULL COMMENT '線上編輯器內容',
  `PIC1` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC2` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC3` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC4` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC5` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  PRIMARY KEY (`prod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
