466 lines
26 KiB
SQL
466 lines
26 KiB
SQL
ALTER TABLE "NGWL_TEST_BMS"."NC_LOG" ADD COLUMN "SEND_TIME" DATE;
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_BMS"."NC_LOG"."SEND_TIME" IS '推送时间';
|
|
|
|
ALTER TABLE "NGWL_TEST_FINANCE"."NC_LOG" ADD COLUMN "SEND_TIME" DATE;
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."NC_LOG"."SEND_TIME" IS '推送时间';
|
|
|
|
ALTER TABLE "NGWL_TEST_PRODUCT"."SYS_ORGANIZATION" ADD COLUMN "NC_CODE" VARCHAR2(128);
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_PRODUCT"."SYS_ORGANIZATION"."NC_CODE" IS 'nc编码';
|
|
|
|
|
|
----------------------------------------------- 2026-03-28已上线生产----------------------------------------------
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "LOT_NO" VARCHAR2(200);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "SINGLE_GROSS_WEIGHT" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "SINGLE_VOLUME" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "DISCOUNT_RATE" DECIMAL(10,2);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "MONTHLY_WAREHOUSE_FEE" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "HALF_MONTH_WH_FEE" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL" ADD COLUMN "CONTRACT_FEE" DECIMAL(10,4);
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."LOT_NO" IS 'LOT编号';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."SINGLE_GROSS_WEIGHT" IS '单件毛重 (KG)';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."SINGLE_VOLUME" IS '单件体积 (CBM)';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."DISCOUNT_RATE" IS '折扣 (%)';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."MONTHLY_WAREHOUSE_FEE" IS '每月仓租';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."HALF_MONTH_WH_FEE" IS '半月仓租';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."IN_MATERIAL_DETAIL"."CONTRACT_FEE" IS '合同费用';
|
|
|
|
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_IN_ORDER" ADD COLUMN "BUSINESS_ORDER_NO" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_IN_ORDER" ADD COLUMN "BUSINESS_TYPE" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_IN_ORDER" ADD COLUMN "DOCUMENT_CREATOR" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_IN_ORDER" ADD COLUMN "DOCUMENT_CREATOR_NAME" VARCHAR2(200);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_IN_ORDER" ADD COLUMN "DOCUMENT_DATE" DATE;
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_IN_ORDER" ADD COLUMN "ORDER_STATUS" VARCHAR2(20);
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_IN_ORDER"."BUSINESS_ORDER_NO" IS '业务单号';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_IN_ORDER"."BUSINESS_TYPE" IS '业务类型';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_IN_ORDER"."DOCUMENT_CREATOR" IS '制单人';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_IN_ORDER"."DOCUMENT_CREATOR_NAME" IS '制单人名称';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_IN_ORDER"."DOCUMENT_DATE" IS '制单日期';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_IN_ORDER"."ORDER_STATUS" IS '订单状态';
|
|
|
|
|
|
DROP TABLE IF EXISTS "NGWL_TEST_WMS"."SYS_TABLE_CONFIG";
|
|
CREATE TABLE "NGWL_TEST_WMS"."SYS_TABLE_CONFIG" (
|
|
"ORGANIZATION_ID" BIGINT,
|
|
"KEY" VARCHAR2(500),
|
|
"VALUE" TEXT,
|
|
"TOP_ORGANIZATION_ID" BIGINT,
|
|
"ORGANIZATION_NAME" VARCHAR(200),
|
|
"REMARK" VARCHAR(200),
|
|
"WAREHOUSE_ID" BIGINT,
|
|
"DETAIL_VALUE" TEXT,
|
|
"MATERIAL_ADD_TYPE" VARCHAR2(100),
|
|
"CREATE_TIME" TIMESTAMP(6),
|
|
"CREATE_BY" BIGINT DEFAULT 0,
|
|
"CREATE_BY_NAME" VARCHAR(200 CHAR) DEFAULT '',
|
|
"UPDATE_TIME" TIMESTAMP(6),
|
|
"UPDATE_BY" BIGINT DEFAULT 0,
|
|
"UPDATE_BY_NAME" VARCHAR(200 CHAR) DEFAULT '',
|
|
"DEL_FLAG" TINYINT DEFAULT 1,
|
|
"ID" BIGINT IDENTITY(1,1) NOT NULL
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."ORGANIZATION_ID" IS '组织id';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."TOP_ORGANIZATION_ID" IS '一级组织表ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."ORGANIZATION_NAME" IS '组织名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."REMARK" IS '备注';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."WAREHOUSE_ID" IS '仓库id';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."DETAIL_VALUE" IS '明细内容';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."MATERIAL_ADD_TYPE" IS '物料添加方式';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."CREATE_TIME" IS '创建时间';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."CREATE_BY" IS '创建人用户ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."CREATE_BY_NAME" IS '创建人姓名';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."UPDATE_TIME" IS '最后修改时间';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."UPDATE_BY" IS '最后修改人用户ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."UPDATE_BY_NAME" IS '修改人姓名';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."DEL_FLAG" IS '删除标记：0-无状态，1-正常，2-已删除';
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."SYS_TABLE_CONFIG"."ID" IS 'id';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table SYS_TABLE_CONFIG
|
|
-- ----------------------------
|
|
ALTER TABLE "NGWL_TEST_WMS"."SYS_TABLE_CONFIG" ADD PRIMARY KEY ("ID");
|
|
|
|
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_OUT_ORDER" ADD COLUMN "CARRIER_NAME" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_OUT_ORDER" ADD COLUMN "BUSINESS_ORDER_NO" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_OUT_ORDER" ADD COLUMN "BUSINESS_TYPE" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_OUT_ORDER" ADD COLUMN "DOCUMENT_CREATOR" VARCHAR2(128);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_OUT_ORDER" ADD COLUMN "DOCUMENT_CREATOR_NAME" VARCHAR2(200);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."STOCK_OUT_ORDER" ADD COLUMN "DOCUMENT_DATE" DATE;
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_OUT_ORDER"."CARRIER_NAME" IS '承运商';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_OUT_ORDER"."BUSINESS_ORDER_NO" IS '业务单号';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_OUT_ORDER"."BUSINESS_TYPE" IS '业务类型';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_OUT_ORDER"."DOCUMENT_CREATOR" IS '制单人';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_OUT_ORDER"."DOCUMENT_CREATOR_NAME" IS '制单人名称';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."STOCK_OUT_ORDER"."DOCUMENT_DATE" IS '制单日期';
|
|
|
|
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "IN_ORDER_NUMBER" VARCHAR(32 CHAR) DEFAULT '';
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "LOT_NO" VARCHAR2(200);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "SINGLE_GROSS_WEIGHT" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "SINGLE_VOLUME" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "DISCOUNT_RATE" DECIMAL(10,2);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "MONTHLY_WAREHOUSE_FEE" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "HALF_MONTH_WH_FEE" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "CONTRACT_FEE" DECIMAL(10,4);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "STOCK_UNIT" VARCHAR2(100);
|
|
|
|
ALTER TABLE "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL" ADD COLUMN "STOCK_QUANTITY" DECIMAL(10,4);
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."IN_ORDER_NUMBER" IS '入库单号';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."LOT_NO" IS 'LOT编号';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."SINGLE_GROSS_WEIGHT" IS '单件毛重 (KG)';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."SINGLE_VOLUME" IS '单件体积 (CBM)';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."DISCOUNT_RATE" IS '折扣 (%)';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."MONTHLY_WAREHOUSE_FEE" IS '每月仓租';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."HALF_MONTH_WH_FEE" IS '半月仓租';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."CONTRACT_FEE" IS '合同费用';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."STOCK_UNIT" IS '库存单位';
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_WMS"."OUT_MATERIAL_DETAIL"."STOCK_QUANTITY" IS '库存件数'
|
|
|
|
----------------------------------已发布生产----------------------------------------
|
|
|
|
/*
|
|
Navicat Premium Dump SQL
|
|
|
|
Source Server : 113.44.106.61
|
|
Source Server Type : Dameng
|
|
Source Server Version : 8014116 (08.01.4116)
|
|
Source Host : 113.44.106.61:5236
|
|
Source Schema : NGWL_TEST_OMS
|
|
|
|
Target Server Type : Dameng
|
|
Target Server Version : 8014116 (08.01.4116)
|
|
File Encoding : 65001
|
|
|
|
Date: 22/04/2026 08:57:55
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for RESERVATION_MATERIAL_INVENTORY
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY";
|
|
CREATE TABLE "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY" (
|
|
"RESERVATION_MATERIAL_INVENTORY_ID" BIGINT IDENTITY(1,1) NOT NULL,
|
|
"ORGANIZATION_ID" BIGINT DEFAULT 0,
|
|
"ORGANIZATION_NAME" VARCHAR(100 CHAR) DEFAULT '',
|
|
"TOP_ORGANIZATION_ID" BIGINT DEFAULT 0,
|
|
"MATERIAL_BASE_INFO_ID" BIGINT DEFAULT 0,
|
|
"MATERIAL_DETAIL_ID" BIGINT,
|
|
"WAREHOUSE_ID" BIGINT DEFAULT 0,
|
|
"WAREHOUSE_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"WAREHOUSE_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"STORAGE_SECTION_ID" BIGINT DEFAULT 0,
|
|
"STORAGE_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"STORAGE_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"STORAGE_LOCATION_ID" BIGINT DEFAULT 0,
|
|
"STORAGE_LOCATION_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"STORAGE_LOCATION_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"BATCH_NUMBER" VARCHAR(50 CHAR) DEFAULT '',
|
|
"MATERIAL_STATUS_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"MATERIAL_STATUS_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"CONTAINER_ID" BIGINT DEFAULT 0 NOT NULL,
|
|
"CONTAINER_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"CONTAINER_TYPE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"CONTAINER_TYPE_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"INVENTORY_QUANTITY" DECIMAL(20,2) DEFAULT 0.,
|
|
"ALLOCATION_QUANTITY" DECIMAL(20,2) DEFAULT 0.,
|
|
"FREEZE_QUANTITY" DECIMAL(20,2) DEFAULT 0.,
|
|
"REMARK" VARCHAR(255 CHAR) DEFAULT '',
|
|
"CREATE_TIME" TIMESTAMP,
|
|
"CREATE_BY" BIGINT DEFAULT 0,
|
|
"CREATE_BY_NAME" VARCHAR(20 CHAR) DEFAULT '',
|
|
"UPDATE_TIME" TIMESTAMP,
|
|
"UPDATE_BY" BIGINT DEFAULT 0,
|
|
"UPDATE_BY_NAME" VARCHAR(20 CHAR) DEFAULT '',
|
|
"DEL_FLAG" TINYINT DEFAULT 1,
|
|
"IS_ABLE" TINYINT DEFAULT 1,
|
|
"UNIT" VARCHAR2(128),
|
|
"NET_WEIGHT" DECIMAL(10,2),
|
|
"GROSS_WEIGHT" DECIMAL(10,2),
|
|
"VOLUME" DECIMAL(10,2),
|
|
"AREA" DECIMAL(10,2),
|
|
"SHIPPER_ID" BIGINT,
|
|
"SHIPPER_CODE" VARCHAR(50),
|
|
"SHIPPER_NAME" VARCHAR(100),
|
|
"PRODUCTION_DATE" DATE,
|
|
"EXPIRY_DATE" DATE,
|
|
"INVENTORY_DATE" DATE,
|
|
"BATCH_REF_NO" VARCHAR(100),
|
|
"SHEET_REF_NO" VARCHAR(100),
|
|
"BOX_PALLET_NO" VARCHAR(200),
|
|
"EXT_ATTR_1" VARCHAR2(255),
|
|
"EXT_ATTR_2" VARCHAR2(255),
|
|
"EXT_ATTR_3" DATE DEFAULT '',
|
|
"EXT_ATTR_4" DATE,
|
|
"UNIT_NAME" VARCHAR2(255),
|
|
"BAR_CODE" VARCHAR(255),
|
|
"IN_ORDER_NUMBER" VARCHAR(100),
|
|
"LOT_NUMBER" VARCHAR(100)
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."RESERVATION_MATERIAL_INVENTORY_ID" IS '物料库存id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."ORGANIZATION_ID" IS '组织表ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."ORGANIZATION_NAME" IS '组织名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."TOP_ORGANIZATION_ID" IS '一级组织表ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."MATERIAL_BASE_INFO_ID" IS '物料基础信息id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."MATERIAL_DETAIL_ID" IS '上架单物料明细id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."WAREHOUSE_ID" IS '仓库id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."WAREHOUSE_CODE" IS '仓库编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."WAREHOUSE_NAME" IS '仓库名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."STORAGE_SECTION_ID" IS '库区id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."STORAGE_CODE" IS '库区编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."STORAGE_NAME" IS '库区名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."STORAGE_LOCATION_ID" IS '库位id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."STORAGE_LOCATION_CODE" IS '库位编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."STORAGE_LOCATION_NAME" IS '库位名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."BATCH_NUMBER" IS '批次号';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."MATERIAL_STATUS_CODE" IS '物料状态编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."MATERIAL_STATUS_NAME" IS '物料状态名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CONTAINER_ID" IS '容器id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CONTAINER_CODE" IS '容器编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CONTAINER_TYPE" IS '容器类型 数据字典';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CONTAINER_TYPE_NAME" IS '容器类型名称 数据字典';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."INVENTORY_QUANTITY" IS '库存数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."ALLOCATION_QUANTITY" IS '可用数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."FREEZE_QUANTITY" IS '冻结数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."REMARK" IS '备注';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CREATE_TIME" IS '创建时间';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CREATE_BY" IS '创建人用户ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."CREATE_BY_NAME" IS '创建人姓名';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."UPDATE_TIME" IS '最后修改时间';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."UPDATE_BY" IS '最后修改人用户ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."UPDATE_BY_NAME" IS '修改人姓名';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."DEL_FLAG" IS '删除标记：0-无状态，1-正常，2-已删除';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."IS_ABLE" IS '盘点是否可用：0-禁用 1-可用';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."UNIT" IS '单位';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."NET_WEIGHT" IS '净重(KG)';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."GROSS_WEIGHT" IS '毛重(KG)';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."VOLUME" IS '体积(CBM)';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."AREA" IS '面积(SQM)';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."SHIPPER_ID" IS '货主ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."SHIPPER_CODE" IS '货主编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."SHIPPER_NAME" IS '货主名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."PRODUCTION_DATE" IS '生产日期';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."EXPIRY_DATE" IS '过期日期';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."INVENTORY_DATE" IS '存货日期';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."BATCH_REF_NO" IS 'Batch Ref NO''s';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."SHEET_REF_NO" IS 'Sheet Ref NO''s';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."BOX_PALLET_NO" IS '箱号/卡板号';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."EXT_ATTR_1" IS '扩展字段1';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."EXT_ATTR_2" IS '扩展字段2';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."EXT_ATTR_3" IS '扩展字段3';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."EXT_ATTR_4" IS '扩展字段4';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."UNIT_NAME" IS '单位名';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."IN_ORDER_NUMBER" IS '入库单号';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY"."LOT_NUMBER" IS 'LOT编号';
|
|
COMMENT ON TABLE "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY" IS '物料库存表';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table RESERVATION_MATERIAL_INVENTORY
|
|
-- ----------------------------
|
|
ALTER TABLE "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY" ADD PRIMARY KEY ("RESERVATION_MATERIAL_INVENTORY_ID");
|
|
|
|
-- ----------------------------
|
|
-- Indexes structure for table RESERVATION_MATERIAL_INVENTORY
|
|
-- ----------------------------
|
|
CREATE INDEX "NGWL_TEST_OMS"."IDX_MAT_INV_BASE_ID"
|
|
ON "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY" ("MATERIAL_BASE_INFO_ID" ASC)
|
|
UNUSABLE;
|
|
CREATE INDEX "NGWL_TEST_OMS"."IDX_MAT_INV_LOC_MAT_SHIPPER_ID"
|
|
ON "NGWL_TEST_OMS"."RESERVATION_MATERIAL_INVENTORY" ("MATERIAL_BASE_INFO_ID" ASC, "SHIPPER_ID" ASC)
|
|
UNUSABLE;
|
|
|
|
|
|
|
|
/*
|
|
Navicat Premium Dump SQL
|
|
|
|
Source Server : 113.44.106.61
|
|
Source Server Type : Dameng
|
|
Source Server Version : 8014116 (08.01.4116)
|
|
Source Host : 113.44.106.61:5236
|
|
Source Schema : NGWL_TEST_OMS
|
|
|
|
Target Server Type : Dameng
|
|
Target Server Version : 8014116 (08.01.4116)
|
|
File Encoding : 65001
|
|
|
|
Date: 22/04/2026 09:00:34
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for RESERVATION_INVENTORY_ADJUSTMENT_RECORD
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD";
|
|
CREATE TABLE "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD" (
|
|
"INVENTORY_ADJUSTMENT_ID" BIGINT IDENTITY(1,1) NOT NULL,
|
|
"ORGANIZATION_ID" BIGINT DEFAULT 0,
|
|
"ORGANIZATION_NAME" VARCHAR(100 CHAR) DEFAULT '',
|
|
"TOP_ORGANIZATION_ID" BIGINT DEFAULT 0,
|
|
"MATERIAL_INVENTORY_ID" BIGINT,
|
|
"MATERIAL_BASE_INFO_ID" BIGINT DEFAULT 0,
|
|
"MATERIAL_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"MATERIAL_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"BAR_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"SHIPPER_ID" BIGINT DEFAULT 0,
|
|
"SHIPPER_NAME" VARCHAR(50 CHAR) DEFAULT '',
|
|
"WAREHOUSE_ID" BIGINT DEFAULT 0,
|
|
"WAREHOUSE_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"WAREHOUSE_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"STORAGE_SECTION_ID" BIGINT DEFAULT 0,
|
|
"STORAGE_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"STORAGE_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"STORAGE_LOCATION_ID" BIGINT DEFAULT 0,
|
|
"STORAGE_LOCATION_CODE" VARCHAR(32 CHAR) DEFAULT '',
|
|
"STORAGE_LOCATION_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"ADJUST_TYPE" TINYINT DEFAULT 0,
|
|
"ADJUST_DIRECTION" TINYINT DEFAULT 0,
|
|
"ADJUST_BEFORE_STATUS_CODE" VARCHAR(32 CHAR) DEFAULT '0',
|
|
"ADJUST_BEFORE_STATUS_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"ADJUST_AFTER_STATUS_CODE" VARCHAR(32 CHAR) DEFAULT '0',
|
|
"ADJUST_AFTER_STATUS_NAME" VARCHAR(64 CHAR) DEFAULT '',
|
|
"INVENTORY_BEFORE_QUANTITY" DECIMAL(20,2) DEFAULT 0.,
|
|
"ALLOCATION_BEFORE_QUANTITY" DECIMAL(20,2),
|
|
"FREEZE_BEFORE_QUANTITY" DECIMAL(20,2),
|
|
"INVENTORY_AFTER_QUANTITY" DECIMAL(20,2) DEFAULT 0.,
|
|
"ALLOCATION_AFTER_QUANTITY" DECIMAL(20,2),
|
|
"FREEZE_AFTER_QUANTITY" DECIMAL(20,2),
|
|
"CREATE_TIME" TIMESTAMP,
|
|
"CREATE_BY" BIGINT DEFAULT 0,
|
|
"CREATE_BY_NAME" VARCHAR(20 CHAR) DEFAULT '',
|
|
"UPDATE_TIME" TIMESTAMP,
|
|
"UPDATE_BY" BIGINT DEFAULT 0,
|
|
"UPDATE_BY_NAME" VARCHAR(20 CHAR) DEFAULT '',
|
|
"DEL_FLAG" TINYINT DEFAULT 1,
|
|
"ADJUST_ACTION" VARCHAR2(100),
|
|
"RELATE_NO" VARCHAR2(128),
|
|
"NET_WEIGHT" DECIMAL(18,3) DEFAULT NULL,
|
|
"GROSS_WEIGHT" DECIMAL(18,3) DEFAULT NULL,
|
|
"VOLUME" DECIMAL(18,3) DEFAULT NULL,
|
|
"AREA" DECIMAL(18,3) DEFAULT NULL,
|
|
"ADJUSTED_NET_WEIGHT" DECIMAL(18,3) DEFAULT NULL,
|
|
"ADJUSTED_GROSS_WEIGHT" DECIMAL(18,3) DEFAULT NULL,
|
|
"ADJUSTED_VOLUME" DECIMAL(18,3) DEFAULT NULL,
|
|
"ADJUSTED_AREA" DECIMAL(18,3) DEFAULT NULL,
|
|
"IN_ORDER_NUMBER" VARCHAR(100),
|
|
"LOT_NUMBER" VARCHAR(100),
|
|
"BATCH_NUMBER" VARCHAR(50 CHAR) DEFAULT ''
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."INVENTORY_ADJUSTMENT_ID" IS '库存调整记录id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ORGANIZATION_ID" IS '组织表ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ORGANIZATION_NAME" IS '组织名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."TOP_ORGANIZATION_ID" IS '一级组织表ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."MATERIAL_INVENTORY_ID" IS '物料库存id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."MATERIAL_BASE_INFO_ID" IS '物料基础信息id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."MATERIAL_CODE" IS '物料编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."MATERIAL_NAME" IS '物料名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."BAR_CODE" IS '物料条形码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."SHIPPER_ID" IS '货主id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."SHIPPER_NAME" IS '货主名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."WAREHOUSE_ID" IS '仓库id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."WAREHOUSE_CODE" IS '仓库编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."WAREHOUSE_NAME" IS '仓库名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."STORAGE_SECTION_ID" IS '库区id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."STORAGE_CODE" IS '库区编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."STORAGE_NAME" IS '库区名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."STORAGE_LOCATION_ID" IS '库位id';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."STORAGE_LOCATION_CODE" IS '库位编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."STORAGE_LOCATION_NAME" IS '库位名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_TYPE" IS '调整类型：0：无状态 1：数量调整 2：状态调整 3:库存冻结';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_DIRECTION" IS '调整方向：0：无状态 1：增库存 2：减库存';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_BEFORE_STATUS_CODE" IS '调整前状态编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_BEFORE_STATUS_NAME" IS '调整前状态名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_AFTER_STATUS_CODE" IS '调整后状态编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_AFTER_STATUS_NAME" IS '调整后状态名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."INVENTORY_BEFORE_QUANTITY" IS '调整前库存数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ALLOCATION_BEFORE_QUANTITY" IS '调整前可用数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."FREEZE_BEFORE_QUANTITY" IS '调整前冻结数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."INVENTORY_AFTER_QUANTITY" IS '调整后库存数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ALLOCATION_AFTER_QUANTITY" IS '调整后可用数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."FREEZE_AFTER_QUANTITY" IS '调整后冻结数量';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."CREATE_TIME" IS '创建时间';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."CREATE_BY" IS '创建人用户ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."CREATE_BY_NAME" IS '创建人姓名';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."UPDATE_TIME" IS '最后修改时间';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."UPDATE_BY" IS '最后修改人用户ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."UPDATE_BY_NAME" IS '修改人姓名';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."DEL_FLAG" IS '删除标记：0-无状态，1-正常，2-已删除';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."ADJUST_ACTION" IS '调整动作';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."RELATE_NO" IS '关联单号';
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD"."BATCH_NUMBER" IS '批次号';
|
|
COMMENT ON TABLE "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD" IS '库存调整记录';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table RESERVATION_INVENTORY_ADJUSTMENT_RECORD
|
|
-- ----------------------------
|
|
ALTER TABLE "NGWL_TEST_OMS"."RESERVATION_INVENTORY_ADJUSTMENT_RECORD" ADD PRIMARY KEY ("INVENTORY_ADJUSTMENT_ID");
|
|
|
|
ALTER TABLE "NGWL_TEST_OMS"."RESERVATION_STOCK_IN_ORDER" ADD COLUMN "IN_QUANTITY" DECIMAL(20,2) DEFAULT 0.;
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_OMS"."RESERVATION_STOCK_IN_ORDER"."IN_QUANTITY" IS '计划数量';
|
|
|
|
-------------------------已发布生产----------------------------------------------------------------- |