EPT_STORE_BILL_OUT_HEAD.sql
8.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
/*
Navicat Oracle Data Transfer
Oracle Client Version : 11.2.0.1.0
Source Server : orcl
Source Server Version : 110200
Source Host : 192.168.80.10:1521
Source Schema : EPORT
Target Server Type : ORACLE
Target Server Version : 110200
File Encoding : 65001
Date: 2017-08-30 16:46:01
*/
-- ----------------------------
-- Table structure for EPT_STORE_BILL_OUT_HEAD
-- ----------------------------
DROP TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD";
CREATE TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" (
"ID" NUMBER NOT NULL ,
"SEQ_NO" VARCHAR2(36 BYTE) NOT NULL ,
"PLAT_NO2" VARCHAR2(36 BYTE) NOT NULL ,
"CUSTOMS" VARCHAR2(36 BYTE) NOT NULL ,
"STORE_BILL_NO" VARCHAR2(36 BYTE) NULL ,
"EMS_NO" VARCHAR2(20 BYTE) NOT NULL ,
"ENTRY_ID" VARCHAR2(50 BYTE) NULL ,
"STORE_TYPE" VARCHAR2(4 BYTE) NOT NULL ,
"ORDERS_NO" VARCHAR2(50 BYTE) NULL ,
"CONTR_NO" VARCHAR2(50 BYTE) NULL ,
"TRADE_CODE" VARCHAR2(20 BYTE) NOT NULL ,
"TRADE_NAME" VARCHAR2(255 BYTE) NOT NULL ,
"TRADE_MODE" VARCHAR2(4 BYTE) NULL ,
"NUM" NUMBER(18,5) NULL ,
"GROSS_WT" NUMBER(18,5) NULL ,
"NET_WT" NUMBER(18,5) NULL ,
"PROVIDER_CODE" VARCHAR2(30 BYTE) NULL ,
"PROVIDER_NAME" VARCHAR2(255 BYTE) NULL ,
"PRE_START_DATE" DATE NOT NULL ,
"PRE_END_DATE" DATE NOT NULL ,
"OUT_START_DATE" DATE NULL ,
"OUT_END_DATE" DATE NULL ,
"REMARK" VARCHAR2(255 BYTE) NULL ,
"AREA_CODE" VARCHAR2(10 BYTE) NOT NULL ,
"CUSTOMS_CODE" VARCHAR2(10 BYTE) NOT NULL ,
"TRADES_CODE" VARCHAR2(50 BYTE) NOT NULL ,
"STEP_ID" VARCHAR2(10 BYTE) NOT NULL ,
"CREATE_PERSON" VARCHAR2(50 BYTE) NOT NULL ,
"DECLARE_PERSON" VARCHAR2(50 BYTE) NULL ,
"DECLARE_DATE" DATE NULL ,
"APPROVE_PERSON" VARCHAR2(50 BYTE) NULL ,
"APPROVE_DATE" DATE NULL ,
"OUTER_COMMENT" VARCHAR2(500 BYTE) NULL ,
"INNER_COMMENT" VARCHAR2(500 BYTE) NULL ,
"IS_DELETE" NUMBER(11) NULL ,
"CREATE_ID" NUMBER(11) NULL ,
"UPDATE_ID" NUMBER(11) NULL ,
"UPDATE_DATE" DATE NOT NULL ,
"CREATE_DATE" DATE NULL ,
"STATUS" NUMBER(7) DEFAULT 0 NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."SEQ_NO" IS '外部对接编号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."PLAT_NO2" IS '外部企业编码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."CUSTOMS" IS '对接海关区域代码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."STORE_BILL_NO" IS '出库单号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."EMS_NO" IS '账册编号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."ENTRY_ID" IS '报关单号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."STORE_TYPE" IS '出库方式';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."ORDERS_NO" IS '提单号/转关单号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."CONTR_NO" IS '出库合同号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."TRADE_CODE" IS '经营单位代码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."TRADE_NAME" IS '经营单位名称';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."TRADE_MODE" IS '贸易方式';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."NUM" IS '件数';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."GROSS_WT" IS '毛重';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."NET_WT" IS '净重';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."PROVIDER_CODE" IS '供货商编码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."PROVIDER_NAME" IS '供货商名称';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."PRE_START_DATE" IS '预报开始时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."PRE_END_DATE" IS '预报结束时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."OUT_START_DATE" IS '出库开始时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."OUT_END_DATE" IS '出库结束时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."REMARK" IS '备注';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."AREA_CODE" IS '区域代码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."CUSTOMS_CODE" IS '主管海关';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."TRADES_CODE" IS '企业编码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."STEP_ID" IS '当前环节';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."CREATE_PERSON" IS '创建人';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."DECLARE_PERSON" IS '申报人';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."DECLARE_DATE" IS '申报时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."APPROVE_PERSON" IS '审批人';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."APPROVE_DATE" IS '审批时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."OUTER_COMMENT" IS '外部审批意间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."INNER_COMMENT" IS '内部审批意见';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."IS_DELETE" IS '删除标志';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."CREATE_ID" IS '创建人员ID';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."UPDATE_ID" IS '更新人员ID';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."UPDATE_DATE" IS '更新时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_OUT_HEAD"."CREATE_DATE" IS '创建时间';
-- ----------------------------
-- Records of EPT_STORE_BILL_OUT_HEAD
-- ----------------------------
INSERT INTO "EPORT"."EPT_STORE_BILL_OUT_HEAD" VALUES ('2', 'vv', 'vv', 'vv', '123456', 'vvv', null, '2', null, '234', 'vv', 'vv', null, '23', null, null, null, null, TO_DATE('2017-05-19 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, 'ee', '33', '123', 'rr', '44', null, TO_DATE('2017-05-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, TO_DATE('2017-05-15 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '0', '1', '1', TO_DATE('2017-08-30 13:22:51', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-13 15:42:52', 'YYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "EPORT"."EPT_STORE_BILL_OUT_HEAD" VALUES ('1', 'aaa', 'bbb', 'ccc', 'ddd', 'book21', '111222333', '2', '5556', '110', 'jz', 'zj', '0110', '1', '1', '1', '1', '1', TO_DATE('2017-05-26 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-06-21 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'a', '123', 'sz', 'zs', 'ass', 'dsda', null, TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, TO_DATE('2017-08-10 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'q', 'z', '0', '1', '1', TO_DATE('2017-08-27 22:16:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-13 01:34:07', 'YYYY-MM-DD HH24:MI:SS'), '1');
-- ----------------------------
-- Indexes structure for table EPT_STORE_BILL_OUT_HEAD
-- ----------------------------
-- ----------------------------
-- Checks structure for table EPT_STORE_BILL_OUT_HEAD
-- ----------------------------
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("SEQ_NO" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("PLAT_NO2" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("CUSTOMS" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("EMS_NO" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("STORE_TYPE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("TRADE_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("TRADE_NAME" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("PRE_START_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("PRE_END_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("AREA_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("CUSTOMS_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("TRADES_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("STEP_ID" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("CREATE_PERSON" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD CHECK ("UPDATE_DATE" IS NOT NULL);
-- ----------------------------
-- Primary Key structure for table EPT_STORE_BILL_OUT_HEAD
-- ----------------------------
ALTER TABLE "EPORT"."EPT_STORE_BILL_OUT_HEAD" ADD PRIMARY KEY ("ID");