94 lines
4.3 KiB
SQL
94 lines
4.3 KiB
SQL
-- ALREADY_RECEIPT_GROSS_WEIGHT
|
|
ALTER TABLE "RECEIPT_MATERIAL_DETAIL"
|
|
ADD "ALREADY_RECEIPT_GROSS_WEIGHT" DECIMAL(20, 8) NULL;
|
|
COMMENT ON COLUMN "RECEIPT_MATERIAL_DETAIL"."ALREADY_RECEIPT_GROSS_WEIGHT" IS '累计已收货毛重(KG)，称重实绩';
|
|
|
|
-- ALREADY_RECEIPT_NET_WEIGHT
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL
|
|
ADD ALREADY_RECEIPT_NET_WEIGHT DECIMAL(20, 8) NULL;
|
|
COMMENT ON COLUMN RECEIPT_MATERIAL_DETAIL.ALREADY_RECEIPT_NET_WEIGHT IS '累计已收货净重(KG)';
|
|
|
|
-- ALREADY_RECEIPT_VOLUME
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL
|
|
ADD ALREADY_RECEIPT_VOLUME DECIMAL(20, 8) NULL;
|
|
COMMENT ON COLUMN RECEIPT_MATERIAL_DETAIL.ALREADY_RECEIPT_VOLUME IS '累计已收货体积(CBM)';
|
|
|
|
-- ALREADY_RECEIPT_AREA
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL
|
|
ADD ALREADY_RECEIPT_AREA DECIMAL(20, 8) NULL;
|
|
COMMENT ON COLUMN RECEIPT_MATERIAL_DETAIL.ALREADY_RECEIPT_AREA IS '累计已收货面积(SQM)';
|
|
|
|
|
|
ALTER TABLE OUT_MATERIAL_DETAIL ADD COPY_TOTAL_WEIGHT DECIMAL;
|
|
ALTER TABLE OUT_MATERIAL_DETAIL ADD COPY_CODE_REFERENCE_IDS VARCHAR;
|
|
|
|
ALTER TABLE PICKING_MATERIAL_DETAIL ADD COPY_CODE_REFERENCE_IDS VARCHAR;
|
|
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL ADD PALLET_NUMBER VARCHAR;
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL ADD COPY_BATCH VARCHAR;
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL ADD COPY_QUANTITY VARCHAR;
|
|
ALTER TABLE RECEIPT_MATERIAL_DETAIL ADD COPY_DETAILS VARCHAR;
|
|
|
|
|
|
ALTER TABLE SHELF_MATERIAL_DETAIL ADD PALLET_NUMBER VARCHAR;
|
|
ALTER TABLE SHELF_MATERIAL_DETAIL ADD COPY_BATCH VARCHAR;
|
|
ALTER TABLE SHELF_MATERIAL_DETAIL ADD COPY_QUANTITY VARCHAR;
|
|
ALTER TABLE SHELF_MATERIAL_DETAIL ADD COPY_DETAILS VARCHAR;
|
|
|
|
|
|
ALTER TABLE NGWL_TEST_WMS.IN_MATERIAL_DETAIL ADD OMS_IN_MATERIAL_DETAIL varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.STOCK_IN_ORDER ADD OMS_STOCK_IN_ORDER_ID varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.RECEIPT_MATERIAL_DETAIL ADD oms_in_material_detail varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.SHELF_MATERIAL_DETAIL ADD OMS_IN_MATERIAL_DETAIL varchar(100) NULL;
|
|
|
|
ALTER TABLE NGWL_TEST_OMS.RESERVATION_IN_MATERIAL_DETAIL ADD INBOUND_ITEMS varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_OMS.RESERVATION_OUT_MATERIAL_DETAIL ADD INBOUND_ITEMS varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.STOCK_RECEIPT_ORDER ADD BUSINESS_ORDER_NO varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_ORDER ADD BUSINESS_ORDER_NO varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_ORDER ADD OUT_ORDER_NUMBER varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_ORDER ADD ORDER_TYPE_CODE varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_ORDER ADD ORDER_TYPE_NAME varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_ORDER ADD PRIORITY_LEVEL_CODE varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_ORDER ADD PRIORITY_LEVEL_NAME varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_MATERIAL_DETAIL ADD lotNo varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.REVIEW_MATERIAL_DETAIL ADD PACK_ID varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.REVIEW_MATERIAL_DETAIL ADD PACK_CODE varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.REVIEW_MATERIAL_DETAIL ADD PACK_NAME varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.REVIEW_MATERIAL_DETAIL ADD PACK_DETAIL_ID varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_WMS.PICKING_MATERIAL_DETAIL ADD IN_ORDER_NUMBER varchar(100) NULL;
|
|
|
|
|
|
|
|
ALTER TABLE stock_receipt_order ADD oms_stock_in_order_id VARCHAR(64);
|
|
|
|
CREATE TABLE NGWL_TEST_SYSTEM.LINE_MANAGEMENT (
|
|
ID BIGINT NOT NULL AUTO_INCREMENT,
|
|
ORGANIZATION_ID BIGINT DEFAULT NULL,
|
|
ORGANIZATION_NAME VARCHAR(100) DEFAULT NULL,
|
|
TOP_ORGANIZATION_ID BIGINT DEFAULT NULL,
|
|
WAREHOUSE_ID BIGINT DEFAULT NULL,
|
|
WAREHOUSE_NAME VARCHAR(100) DEFAULT NULL,
|
|
ROUTE_CODE VARCHAR(100) DEFAULT NULL,
|
|
ROUTE_NAME VARCHAR(200) DEFAULT NULL,
|
|
CUSTOMER_JSON CLOB DEFAULT NULL,
|
|
CREATE_BY BIGINT DEFAULT NULL,
|
|
CREATE_BY_NAME VARCHAR(50) DEFAULT NULL,
|
|
CREATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP NULL,
|
|
UPDATE_BY BIGINT DEFAULT NULL,
|
|
UPDATE_BY_NAME VARCHAR(50) DEFAULT NULL,
|
|
UPDATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP NULL,
|
|
DEL_FLAG TINYINT DEFAULT 1 NULL,
|
|
CONSTRAINT PK_LINE_MANAGEMENT PRIMARY KEY (ID)
|
|
);
|
|
ALTER TABLE NGWL_TEST_USER."USER" ADD LINE_MANAGEMENT_ID varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_USER."USER" ADD ROUTE_CODE varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_USER."USER" ADD ROUTE_NAME varchar(100) NULL;
|
|
ALTER TABLE NGWL_TEST_USER."USER" ADD DELIVERY_ORDER varchar(100) NULL;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|