EPT_STORE_BILL_IN_HEAD.sql
14.8 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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
/*
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:47
*/
-- ----------------------------
-- Table structure for EPT_STORE_BILL_IN_HEAD
-- ----------------------------
DROP TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD";
CREATE TABLE "EPORT"."EPT_STORE_BILL_IN_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 ,
"GOODS_TYPE" VARCHAR2(1 BYTE) NULL ,
"CONTR_NO" VARCHAR2(255 BYTE) NULL ,
"TRADE_CODE" VARCHAR2(50 BYTE) NOT NULL ,
"TRADE_NAME" VARCHAR2(255 BYTE) NOT NULL ,
"NUM" NUMBER(18,5) NULL ,
"GROSS_WT" NUMBER(18,5) NULL ,
"NET_WT" NUMBER(18,5) NULL ,
"PROVIDER_CODE" VARCHAR2(50 BYTE) NULL ,
"PROVIDER_NAME" VARCHAR2(255 BYTE) NULL ,
"PRE_START_DATE" DATE NOT NULL ,
"PRE_END_DATE" DATE NOT NULL ,
"IN_START_DATE" DATE NULL ,
"IN_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 ,
"CREATE_DATE" DATE 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 NULL ,
"STATUS" NUMBER(11) DEFAULT 0 NULL ,
"STATUS_IN" NUMBER(11) DEFAULT 0 NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."SEQ_NO" IS '外部对接编号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."PLAT_NO2" IS '外部企业编码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."CUSTOMS" IS '对接海关区域代码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."STORE_BILL_NO" IS '进库单号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."EMS_NO" IS '账册编号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."ENTRY_ID" IS '报关单号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."STORE_TYPE" IS '入库方式';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."ORDERS_NO" IS '提单号/转关单号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."GOODS_TYPE" IS '货物性质';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."CONTR_NO" IS '入库合同号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."TRADE_CODE" IS '经营单位代码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."TRADE_NAME" IS '经营单位名称';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."NUM" IS '件数';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."GROSS_WT" IS '毛重';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."NET_WT" IS '净重';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."PROVIDER_CODE" IS '供货商编号';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."PROVIDER_NAME" IS '供货商名称';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."PRE_START_DATE" IS '预报开始时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."PRE_END_DATE" IS '预报结束时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."IN_START_DATE" IS '入库开始时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."IN_END_DATE" IS '入库结束时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."REMARK" IS '备注';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."AREA_CODE" IS '区域代码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."CUSTOMS_CODE" IS '主管海关';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."TRADES_CODE" IS '企业编码';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."STEP_ID" IS '当前环节';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."CREATE_PERSON" IS '创建人';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."CREATE_DATE" IS '创建时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."DECLARE_PERSON" IS '申报人';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."DECLARE_DATE" IS '申报时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."APPROVE_PERSON" IS '审批人';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."APPROVE_DATE" IS '审批时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."OUTER_COMMENT" IS '外部审批意见';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."INNER_COMMENT" IS '内部审批意见';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."IS_DELETE" IS '删除标志';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."CREATE_ID" IS '创建人员ID';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."UPDATE_ID" IS '更新人员ID';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."UPDATE_DATE" IS '更新时间';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."STATUS" IS '审核状态(0:未通过,1已通过)';
COMMENT ON COLUMN "EPORT"."EPT_STORE_BILL_IN_HEAD"."STATUS_IN" IS '确报状态0未确报1已确报';
-- ----------------------------
-- Records of EPT_STORE_BILL_IN_HEAD
-- ----------------------------
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('7', '524564', '1', '1', '1', '1', '1', '2', '1', '2', '1', '1', '1', '1', '1', '2', '1', '1', TO_DATE('2017-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-27 16:19:08', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '1', '1', '1', TO_DATE('2017-08-27 16:19:08', 'YYYY-MM-DD HH24:MI:SS'), null, '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('8', '2', '2', '1', '1', '1', '1', '3', '1', '2', '1', '1', '1', '1', '1', '2', '1', '1', TO_DATE('2017-08-10 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-17 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-11 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-23 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-27 17:09:24', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-09 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-09 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '1', '1', '1', TO_DATE('2017-08-27 17:12:01', 'YYYY-MM-DD HH24:MI:SS'), '0', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('9', '1', '1', '1', '1', '1', null, '2', '1', '2', '1', '1', '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-27 20:45:15', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '0', '1', '1', TO_DATE('2017-08-30 13:08:06', 'YYYY-MM-DD HH24:MI:SS'), '0', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('2', '20170829', '220194002', '4604', null, '234', null, '4', null, '1', null, '333', '444', '15', '10', '10', '1203241', null, TO_DATE('2017-05-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-15 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '暂无备注.', '456554', '4064', '1234', '123', '啊顺', TO_DATE('2017-05-13 15:30:32', 'YYYY-MM-DD HH24:MI:SS'), null, TO_DATE('2017-05-25 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, '0', '1', '1', TO_DATE('2017-08-29 19:59:50', 'YYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('1', '222', '333', '444', '555', '666', '777', '3', '888', '3', null, 'zj', 'zj', null, null, null, null, null, TO_DATE('2017-05-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-05-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, 'a', 'jd', '223', '021', 'sff', '421', TO_DATE('2017-05-13 00:23:11', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, 'b', 'c', '0', '1', '1', TO_DATE('2017-05-13 15:30:39', 'YYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('11', '2', '1', '1', '1', '1', '11', '2', '1', '2', null, '11', '1', '11', '1', '1', '1', '1', TO_DATE('2017-08-09 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-17 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '1', '1', '1', '1', '1', TO_DATE('2017-08-30 16:02:27', 'YYYY-MM-DD HH24:MI:SS'), '1', null, '1', null, null, null, '0', '1', '1', TO_DATE('2017-08-30 16:02:27', 'YYYY-MM-DD HH24:MI:SS'), null, '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('4', '666', '4', '123', '3321', '23', '213', '1', '32', '1', '3213', '213', '123', '321', '123', '123', '213323', '123', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '123', '23', '312', '13', '123', '3132', TO_DATE('2017-08-22 11:55:49', 'YYYY-MM-DD HH24:MI:SS'), '23', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '123', TO_DATE('2017-08-10 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '12', '123', '0', '1', '1', TO_DATE('2017-08-27 17:29:28', 'YYYY-MM-DD HH24:MI:SS'), '0', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('5', '2', '1', '2', '1', '1', 'Q', '3', '1', '2', '11', '11', '1', '1', '1', '1', '1', null, TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '11', '1', '1', '1', '1', '1', TO_DATE('2017-08-22 14:52:12', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '11', TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '去', 'Q1', '1', '1', '1', TO_DATE('2017-08-22 14:52:12', 'YYYY-MM-DD HH24:MI:SS'), '0', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('10', '1', '1', '1', '1', '1', '1', '2', '1', '2', '1', '1', '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-05 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-27 21:44:41', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-03 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '0', '1', '1', TO_DATE('2017-08-27 21:44:41', 'YYYY-MM-DD HH24:MI:SS'), null, '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('3', '1', '5', '1', '1', '1', '1', '6', '1', '3', '1', '1', '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-19 18:09:11', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '0', '1', '1', TO_DATE('2017-08-27 21:23:14', 'YYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "EPORT"."EPT_STORE_BILL_IN_HEAD" VALUES ('6', '1', '6', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), null, null, '1', '1', '1', '1', '1', '1', TO_DATE('2017-08-24 18:24:55', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-08-08 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', '1', '0', '1', '1', TO_DATE('2017-08-27 17:29:40', 'YYYY-MM-DD HH24:MI:SS'), '0', '0');
-- ----------------------------
-- Indexes structure for table EPT_STORE_BILL_IN_HEAD
-- ----------------------------
-- ----------------------------
-- Checks structure for table EPT_STORE_BILL_IN_HEAD
-- ----------------------------
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("SEQ_NO" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("PLAT_NO2" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CUSTOMS" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("EMS_NO" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("STORE_TYPE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("TRADE_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("TRADE_NAME" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("PRE_START_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("PRE_END_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("AREA_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CUSTOMS_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("TRADES_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("STEP_ID" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CREATE_PERSON" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CREATE_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("SEQ_NO" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("PLAT_NO2" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CUSTOMS" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("EMS_NO" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("STORE_TYPE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("TRADE_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("TRADE_NAME" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("PRE_START_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("PRE_END_DATE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("AREA_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CUSTOMS_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("TRADES_CODE" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("STEP_ID" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CREATE_PERSON" IS NOT NULL);
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD CHECK ("CREATE_DATE" IS NOT NULL);
-- ----------------------------
-- Primary Key structure for table EPT_STORE_BILL_IN_HEAD
-- ----------------------------
ALTER TABLE "EPORT"."EPT_STORE_BILL_IN_HEAD" ADD PRIMARY KEY ("ID");