| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475 |
- -- ============================================================
- -- WO106核销：核销状态控制 + 预核销清单表
- -- ============================================================
- -- 1. GW_EMS_CONFIG加核销状态字段
- ALTER TABLE GW_EMS_CONFIG ADD (
- CHGOFF_STATUS VARCHAR2(2) DEFAULT '0' -- 核销状态 0未核销 1核销中(已预览确认) 2已结案
- );
- COMMENT ON COLUMN GW_EMS_CONFIG.CHGOFF_STATUS IS '核销状态 0未核销 1核销中 2已结案';
- -- 2. 预核销清单表（关务人员预览核对用，确认后据此正式申报）
- CREATE TABLE GW_DCR_PREVIEW (
- PREVIEW_ID NUMBER(18) NOT NULL, -- 主键
- EMS_NO VARCHAR2(50), -- 账册编号
- CHGOFF_BEGIN DATE, -- 核销周期开始
- CHGOFF_DUE DATE, -- 核销周期结束/库存截止日
- D_TYPE VARCHAR2(2), -- 数据类型 1核注清单 2工单 3期末库存
- G_NO NUMBER(8), -- 项号
- -- 类型1：核注清单
- BOND_INVT_NO VARCHAR2(100), -- 保税核注清单号
- IE_FLAG VARCHAR2(2), -- 进出口标志 I/E
- -- 类型2：工单
- WO_NO VARCHAR2(50), -- 工单号
- -- 类型3：期末库存
- WH_CODE VARCHAR2(50), -- 仓库编码
- GDS_MTNO VARCHAR2(50), -- 海关备案料号
- GDS_TYPE VARCHAR2(2), -- 保税物料类型
- PROD_CODE VARCHAR2(50), -- ERP物料编码
- GDS_NM VARCHAR2(200), -- 物料名称
- SPEC VARCHAR2(200), -- 规格型号
- GDECD VARCHAR2(20), -- HS编码
- DCL_UNITCD VARCHAR2(10), -- 申报计量单位
- DCL_QTY NUMBER(18,4), -- 申报数量
- DCL_UPRC VARCHAR2(20), -- 申报单价
- DCL_CURRCD VARCHAR2(10), -- 申报币制
- LAWF_UNITCD VARCHAR2(10), -- 法定计量单位
- -- 公共
- STATUS VARCHAR2(2) DEFAULT '0', -- 预览状态 0预生成 1已确认 2已申报
- CREATE_TIME DATE,
- CONFIRM_TIME DATE,
- DECLARE_TIME DATE,
- REMARK VARCHAR2(500),
- CONSTRAINT PK_GW_DCR_PREVIEW PRIMARY KEY (PREVIEW_ID)
- );
- COMMENT ON TABLE GW_DCR_PREVIEW IS 'WO106预核销清单（关务预览核对用）';
- COMMENT ON COLUMN GW_DCR_PREVIEW.PREVIEW_ID IS '主键';
- COMMENT ON COLUMN GW_DCR_PREVIEW.EMS_NO IS '账册编号';
- COMMENT ON COLUMN GW_DCR_PREVIEW.CHGOFF_BEGIN IS '核销周期开始';
- COMMENT ON COLUMN GW_DCR_PREVIEW.CHGOFF_DUE IS '核销周期结束/库存截止日';
- COMMENT ON COLUMN GW_DCR_PREVIEW.D_TYPE IS '数据类型 1核注清单 2工单 3期末库存';
- COMMENT ON COLUMN GW_DCR_PREVIEW.G_NO IS '项号';
- COMMENT ON COLUMN GW_DCR_PREVIEW.BOND_INVT_NO IS '保税核注清单号';
- COMMENT ON COLUMN GW_DCR_PREVIEW.IE_FLAG IS '进出口标志 I/E';
- COMMENT ON COLUMN GW_DCR_PREVIEW.WO_NO IS '工单号';
- COMMENT ON COLUMN GW_DCR_PREVIEW.WH_CODE IS '仓库编码';
- COMMENT ON COLUMN GW_DCR_PREVIEW.GDS_MTNO IS '海关备案料号';
- COMMENT ON COLUMN GW_DCR_PREVIEW.GDS_TYPE IS '保税物料类型';
- COMMENT ON COLUMN GW_DCR_PREVIEW.PROD_CODE IS 'ERP物料编码';
- COMMENT ON COLUMN GW_DCR_PREVIEW.GDS_NM IS '物料名称';
- COMMENT ON COLUMN GW_DCR_PREVIEW.SPEC IS '规格型号';
- COMMENT ON COLUMN GW_DCR_PREVIEW.GDECD IS 'HS编码';
- COMMENT ON COLUMN GW_DCR_PREVIEW.DCL_UNITCD IS '申报计量单位';
- COMMENT ON COLUMN GW_DCR_PREVIEW.DCL_QTY IS '申报数量';
- COMMENT ON COLUMN GW_DCR_PREVIEW.DCL_UPRC IS '申报单价';
- COMMENT ON COLUMN GW_DCR_PREVIEW.DCL_CURRCD IS '申报币制';
- COMMENT ON COLUMN GW_DCR_PREVIEW.LAWF_UNITCD IS '法定计量单位';
- COMMENT ON COLUMN GW_DCR_PREVIEW.STATUS IS '预览状态 0预生成 1已确认 2已申报';
- COMMENT ON COLUMN GW_DCR_PREVIEW.CREATE_TIME IS '预生成时间';
- COMMENT ON COLUMN GW_DCR_PREVIEW.CONFIRM_TIME IS '确认时间';
- COMMENT ON COLUMN GW_DCR_PREVIEW.DECLARE_TIME IS '申报时间';
- COMMENT ON COLUMN GW_DCR_PREVIEW.REMARK IS '备注';
- CREATE SEQUENCE GW_DCR_PREVIEW_SEQ START WITH 1 INCREMENT BY 1 NOCACHE;
- CREATE INDEX IDX_GW_DCR_PREVIEW_PERIOD ON GW_DCR_PREVIEW (CHGOFF_BEGIN, CHGOFF_DUE, STATUS);
|
