· 5 years ago · Jul 16, 2020, 11:40 AM
1CREATE TABLE IF NOT EXISTS `kupivip_gate_dbo_gs_Select_Headers` (
2 `EntryNo` varchar(255) NOT NULL,
3 `PROCESS_TYPE` varchar(255) DEFAULT NULL,
4 `ORDER_NO` varchar(255) DEFAULT NULL,
5 `ORDER_DATETIME` varchar(255) DEFAULT NULL,
6 `PAYMENT_METHOD_CODE` varchar(255) DEFAULT NULL,
7 `CampaignCode` varchar(255) DEFAULT NULL,
8 `CampaignName` varchar(255) DEFAULT NULL,
9 `CampaignStartDate` varchar(255) DEFAULT NULL,
10 `CampaignEndDate` varchar(255) DEFAULT NULL,
11 `SHIPPING_AGENT_CODE` varchar(255) DEFAULT NULL,
12 `SHIPPING_AGENT_SERVICE_CODE` varchar(255) DEFAULT NULL,
13 `SHIPPING_AMOUNT` varchar(255) DEFAULT NULL,
14 `SHIP_TO_COUNTRY_REGION_CODE` varchar(255) DEFAULT NULL,
15 `ORDER_AMOUNT` varchar(255) DEFAULT NULL,
16 `COUPON_AMOUNT_ALL` varchar(255) DEFAULT NULL,
17 `VAT_AMOUNT` varchar(255) DEFAULT NULL,
18 `ACCOUNT_ID` varchar(255) DEFAULT NULL,
19 `AccountMobile` varchar(255) DEFAULT NULL,
20 `AccountPhone1` varchar(255) DEFAULT NULL,
21 `DELIVER_TO_CUSTOMER_NAME` varchar(255) DEFAULT NULL,
22 `DELIVER_TO_CUSTOMER_SURNAME` varchar(255) DEFAULT NULL,
23 `DELIVER_TO_COUNTRY` varchar(255) DEFAULT NULL,
24 `DELIVER_TO_POST_CODE` varchar(255) DEFAULT NULL,
25 `DELIVER_TO_CITY` varchar(255) DEFAULT NULL,
26 `DELIVER_TO_ADRESS_STREET` varchar(255) DEFAULT NULL,
27 `DELIVER_TO_ADRESS_HOUSE` varchar(255) DEFAULT NULL,
28 `DELIVER_TO_ADRESS_CORPS` varchar(255) DEFAULT NULL,
29 `DELIVER_TO_ADRESS_APARTMENT` varchar(255) DEFAULT NULL,
30 `DELIVER_KLADR_ID` varchar(255) DEFAULT NULL,
31 `DELIVER_TO_EMAIL` varchar(255) DEFAULT NULL,
32 `DELIVER_TO_PHONE` varchar(255) DEFAULT NULL,
33 `COUPON_ID` varchar(255) DEFAULT NULL,
34 `COUPON_TYPE` varchar(255) DEFAULT NULL,
35 `COUPON_UNIT` varchar(255) DEFAULT NULL,
36 `COUPON_AMOUNT` varchar(255) DEFAULT NULL,
37 `COUPON_REMAINS` varchar(255) DEFAULT NULL,
38 `COUPON_CREATION_DATETIME` varchar(255) DEFAULT NULL,
39 `COUPON_START_DATETIME` varchar(255) DEFAULT NULL,
40 `COUPON_END_DATETIME` varchar(255) DEFAULT NULL,
41 `COUPON_DESCRIPTION` varchar(255) DEFAULT NULL,
42 `HOST` varchar(255) DEFAULT NULL,
43 `STATUS_ID` varchar(255) DEFAULT NULL,
44 `AMOUNT_PAYMENT_INCL_VAT` varchar(255) DEFAULT NULL,
45 `PAYMENT_COMPLETED` varchar(255) DEFAULT NULL,
46 `Agent_OrderNO` varchar(255) DEFAULT NULL,
47 `Author` varchar(255) DEFAULT NULL,
48 `CustomerComment` varchar(255) DEFAULT NULL,
49 `EmplComment` varchar(255) DEFAULT NULL,
50 `CancelReason` varchar(255) DEFAULT NULL,
51 `LoyalCardNumber` varchar(255) DEFAULT NULL,
52 `Account_SexId` varchar(255) DEFAULT NULL,
53 `Account_Birthday` varchar(255) DEFAULT NULL,
54 `ShippingDateFrom` varchar(255) DEFAULT NULL,
55 `OrderCell` varchar(255) DEFAULT NULL,
56 `ShippingDateTo` varchar(255) DEFAULT NULL,
57 `TrackNumber` varchar(255) DEFAULT NULL,
58 `CampaignParams` varchar(255) DEFAULT NULL,
59 `ValidDeliver` varchar(255) DEFAULT NULL,
60 `CustomerStatus` varchar(255) DEFAULT NULL,
61 `ExternalNo` varchar(255) DEFAULT NULL,
62 `SubStatusId` varchar(255) DEFAULT NULL,
63 `DeliverToAdressEntrance` varchar(255) DEFAULT NULL,
64 `DeliverToAdressIntercom` varchar(255) DEFAULT NULL,
65 `DeliverToAdressFloor` varchar(255) DEFAULT NULL,
66 `DeliverToAdressCompanyName` varchar(255) DEFAULT NULL,
67 `DeliverToAdressExtPhone` varchar(255) DEFAULT NULL,
68 `DeliverToAdressNeedPass` varchar(255) DEFAULT NULL,
69 `DeliverToAdressIsOffice` varchar(255) DEFAULT NULL,
70 `PromoCall` varchar(255) DEFAULT NULL,
71 `PostamatId` varchar(255) DEFAULT NULL,
72 `LPExpense` varchar(255) DEFAULT NULL,
73 `LPCalcId` varchar(255) DEFAULT NULL,
74 `MDOrder` varchar(255) DEFAULT NULL,
75 `FIASCode` varchar(255) DEFAULT NULL,
76 `idDeliverAddrRoute` varchar(255) DEFAULT NULL,
77 `idDeliverAddrDeliver` varchar(255) DEFAULT NULL,
78 `HomeAddress` varchar(255) DEFAULT NULL,
79 PRIMARY KEY (`EntryNo`),
80 KEY `ORDER_NO` (`ORDER_NO`)
81)
82 ENGINE = InnoDB;