admin/gr_report_java
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
erp_to_push_other
gr_report_java/sql/gzgl.sql
Gjm fc089943bc refactor(config): 更新配置和ERP数据同步功能 
- 将生产环境数据库配置从MySQL切换到达梦数据库
- 添加多个达梦数据库连接配置包括主库、从库、日志库等
- 配置往来单位和物料相关的API接口URL列表
- 重构ERP基础数据同步任务，支持双向同步（ERP↔数据中心）
- 优化计量单位数据同步逻辑，改用编码匹配方式进行增改操作
- 添加物料信息及往来单位子表的批量同步处理功能
- 实现通用数据同步方法，统一异常处理和日志记录
- 调整定时任务执行逻辑，支持ERP到数据中心和反向同步流程
2026-04-17 13:58:42 +08:00

568 lines
44 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
//erp
DROP TABLE IF EXISTS "GSSERVER"."ERP_BFMEASUREUNIT_TABLE";
CREATE TABLE "GSSERVER"."ERP_BFMEASUREUNIT_TABLE" (
"ID" VARCHAR(255) NOT NULL,
"CREATE_TIME" DATE,
"LAST_UPDATE_TIME" DATE,
"CHANGE_TYPE" TINYINT,
"MESSAGE" VARCHAR(8188)
)
;
COMMENT ON COLUMN "GSSERVER"."ERP_BFMEASUREUNIT_TABLE"."ID" IS 'ID';
COMMENT ON COLUMN "GSSERVER"."ERP_BFMEASUREUNIT_TABLE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "GSSERVER"."ERP_BFMEASUREUNIT_TABLE"."LAST_UPDATE_TIME" IS '最后更新时间';
COMMENT ON COLUMN "GSSERVER"."ERP_BFMEASUREUNIT_TABLE"."CHANGE_TYPE" IS '更改类型（1 新增，2更改）';
COMMENT ON COLUMN "GSSERVER"."ERP_BFMEASUREUNIT_TABLE"."MESSAGE" IS '报文';
COMMENT ON TABLE "GSSERVER"."ERP_BFMEASUREUNIT_TABLE" IS 'erp数据同步中间表';
ALTER TABLE "GSSERVER"."ERP_BFMEASUREUNIT_TABLE" ADD PRIMARY KEY ("ID");
DROP TABLE IF EXISTS "GSSERVER"."ERP_MATERIAL_BACKUP";
CREATE TABLE "GSSERVER"."ERP_MATERIAL_BACKUP" (
"ID" VARCHAR(50) NOT NULL,
"CODE" VARCHAR(100),
"NAME" NVARCHAR(3200),
"STATE_ISENABLED" CHAR(1),
"STATE_DISABLETIME" TIMESTAMP(6),
"STATE_ASYNCDELETESTATUS" VARCHAR(50),
"REMARK" VARCHAR(1000),
"ATTACHMENT" CLOB,
"BARCODE" VARCHAR(100),
"DIVISIONID" VARCHAR(50),
"KIND" VARCHAR(50),
"EACHWEIGHT" DECIMAL(18,4),
"WEIGHTUNITID" VARCHAR(50),
"EACHVOLUME" DECIMAL(18,4),
"VOLUMEUNITID" VARCHAR(50),
"MATERIALTYPEID" VARCHAR(50),
"ISSERIALMGR" CHAR(1),
"TAXTYPE" VARCHAR(50),
"FFSCHEMAID" VARCHAR(50),
"ISVALIDPERIOD" CHAR(1),
"VALIDPERIOD" DECIMAL(18,4),
"VALIDPERIODUNIT" VARCHAR(50),
"ISBINLIFE" CHAR(1),
"BINLIFE" DECIMAL(18,4),
"BINLIFEUNIT" VARCHAR(50),
"ISBATCH" CHAR(1),
"BATCHUNIT" VARCHAR(50),
"BATCHCONVERSIONUNIT" VARCHAR(50),
"USEBATCHCONVERSIONRATE" CHAR(1),
"LABEL" VARCHAR(200),
"TIMESTAMP_CREATEDBY" VARCHAR(50),
"TIMESTAMP_CREATEDON" TIMESTAMP(6),
"TIMESTAMP_LASTCHANGEDBY" VARCHAR(50),
"TIMESTAMP_LASTCHANGEDON" TIMESTAMP(6),
"SPECIFICATIONS" NVARCHAR(8000),
"MODEL" NVARCHAR(3200),
"DRAWINGNO" VARCHAR(100),
"MATERIALDESCRIPTION" VARCHAR(1000),
"ISPURCHASE" CHAR(1),
"ISINVENTORY" CHAR(1),
"ISSALES" CHAR(1),
"ISPRODUCTABLE" CHAR(1),
"ISOEM" CHAR(1),
"ISVERSIONMANAGEABLE" CHAR(1),
"PACKAGEMANAGEMENT" CHAR(1),
"SINGLEPIECEMANAGEMENT" CHAR(1),
"PRODUCTCONFIGURATION" CHAR(1),
"SPECIALMANAGEMENT" CHAR(1),
"MODEOFPRODUCTION" VARCHAR(50),
"VIRTUALMATERIALATTR" VARCHAR(50),
"DEFAULTREJECTRATE" DECIMAL(18,4),
"DEFAULTWASTERATE" DECIMAL(18,4),
"PRODUCTIONFEEDINGCONTROL" VARCHAR(50),
"BATCHMEASURE" VARCHAR(50),
"FIXEDQUANTITY" DECIMAL(18,4),
"APPLIEDEXHAUST" CHAR(1),
"ISQC" CHAR(1),
"QCMODE" VARCHAR(50),
"PLANINGMODE" VARCHAR(50),
"ISMPS" CHAR(1),
"PRODUCTBATCHRULE" VARCHAR(50),
"PRODUCTFIXEDBATCH" DECIMAL(18,4),
"INCREMENTBATCH" DECIMAL(18,4),
"PRODUCTBATCHMEASUREUNIT" VARCHAR(50),
"FIXEDADVANCEDAY" DECIMAL(18,4),
"CHANGEADVANCEDAY" DECIMAL(18,4),
"BASEYIELDINCHANGEADVANCEDAY" DECIMAL(18,4),
"BASEYIELDMEASUREUNIT" VARCHAR(50),
"PURCHASEBATCHRULE" VARCHAR(50),
"PURCHASEFIXEDBATCH" DECIMAL(18,4),
"PURCHASEIMCREMENTBATCH" DECIMAL(18,4),
"PURCHASEBATCHMEASUREUNIT" VARCHAR(50),
"PURCHASEFIXEDADVANCEDAY" DECIMAL(18,4),
"PRUCHASECHANGEADVANCEDAY" DECIMAL(18,4),
"BASEYIELDINPURCHASEADVANCEDAY" DECIMAL(18,4),
"PURCHASEBASEYIELDMEASUREUNIT" VARCHAR(50),
"SUMMARY" VARCHAR(1000),
"RATE" DECIMAL(18,4),
"TAXBILLSPECIFICATION" VARCHAR(200),
"TAXCLASSIFICATION" VARCHAR(50),
"DEFAULTUNITPRICE" DECIMAL(18,4),
"UNITPRICETAXINCLUDED" CHAR(1),
"ENJOYPREFERENTIALPOLICIES" CHAR(1),
"CONTENTOFPREFERENTIALPOLICIES" VARCHAR(1000),
"TAXBILLMEASUREUNIT" VARCHAR(50),
"SECLEVEL" INT,
"SECLEVELID" VARCHAR(50),
"GRLACKRATE" DECIMAL(18,4),
"GROVERRATE" DECIMAL(18,4),
"GILACKRATE" DECIMAL(18,4),
"GIOVERRATE" DECIMAL(18,4),
"DEFAULTOUTPUTRATE" DECIMAL(18,4),
"RECOILCONSUMPTION" CHAR(1),
"PICKINGBATCH" DECIMAL(18,4),
"PLANNEDDAILYSUPPLY" DECIMAL(18,4),
"SUPPLYTYPE" VARCHAR(50),
"SINGLEUNIT" VARCHAR(50),
"BILLSTATUS" VARCHAR(50),
"INSTANCEID" VARCHAR(50),
"BILLPARAMS" CLOB,
"BILLMARK" CHAR(1),
"MAINIMAGE" VARCHAR(500),
"MAINIMAGENAME" VARCHAR(200),
"OUTBOUNDSTRATEGY" VARCHAR(50),
"ISQCLEVEL" CHAR(1),
"DOMAINTYPE" VARCHAR(50),
"OWNERORG" VARCHAR(50),
"OWNERDOMAIN" VARCHAR(50),
"MEASUREUNITS" VARCHAR(500),
"NEWCODE" VARCHAR(100),
"NEWNAME" NVARCHAR(3200),
"SAFETYSTOCKCEILING" DECIMAL(18,4),
"SAFETYSTOCKLOWERLIMIT" DECIMAL(18,4),
"FLEXCONFIG" VARCHAR(500),
"QCLEVEL" VARCHAR(50),
"INITIALINSPECTIONREQUIRED" CHAR(1),
"CUSTOMFIELD1" VARCHAR(200),
"CUSTOMFIELD2" VARCHAR(200),
"CUSTOMFIELD3" VARCHAR(200),
"CUSTOMFIELD4" VARCHAR(200),
"CUSTOMFIELD5" VARCHAR(200),
"CUSTOMFIELD6" CLOB,
"ISDOUBLEREVIEW" CHAR(1),
"ISRELEASECONTROL" CHAR(1),
"MINORDERQUANTITY" DECIMAL(18,4),
"MAXORDERQUANTITY" DECIMAL(18,4),
"EXTC_EXTVARCHAR1" VARCHAR(200),
"ISREINSPECTIONPERIOD" CHAR(1),
"REINSPECTIONPERIOD" DECIMAL(18,4),
"REINSPECTIONPERIODUNIT" VARCHAR(50),
"ISOILSEALPERIOD" CHAR(1),
"OILSEALPERIOD" DECIMAL(18,4),
"OILSEALPERIODUNIT" VARCHAR(50),
"TAXCODE" VARCHAR(50),
"ISVIRTUAL" CHAR(1),
"RAWMATERIALGRADE" VARCHAR(200),
"RAWMATERIALTECHNICALSTANDARDS" VARCHAR(500),
"LOWTURNOVERRISK" CHAR(1),
"RESERVEPLANTYPE" VARCHAR(50),
"ABCCLASSIFICATION" VARCHAR(50),
"PROCUREMENTMODE" VARCHAR(50),
"PREPROCESSINGDAYCOUNT" INT,
"POSTPROCESSINGDAYCOUNT" INT,
"VALIDPERIODFORMAT" VARCHAR(50),
"VALIDPERIODCALCRULE" VARCHAR(50),
"VALIDPERIODCALCRULEFLOATVALUE" INT,
"INVENTORYACCOUNTTYPE" VARCHAR(50),
"MAINGENERALMEASUREUNITID" VARCHAR(50),
"AUXGENERALMEASUREUNITID" VARCHAR(50),
"INVOICENAME" VARCHAR(200),
"MNEMOCODE" VARCHAR(100)
)
;
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ID" IS '主键ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CODE" IS '物料编码';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."NAME" IS '物料名称';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."STATE_ISENABLED" IS '是否可用';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."STATE_DISABLETIME" IS '停用时间';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."STATE_ASYNCDELETESTATUS" IS '异步删除状态';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."REMARK" IS '备注';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ATTACHMENT" IS '附件';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BARCODE" IS '条码';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DIVISIONID" IS '事业部ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."KIND" IS '物料大类';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."EACHWEIGHT" IS '单重';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."WEIGHTUNITID" IS '重量单位ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."EACHVOLUME" IS '单个体积';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VOLUMEUNITID" IS '体积单位ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MATERIALTYPEID" IS '物料类型ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISSERIALMGR" IS '是否序列号管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TAXTYPE" IS '税类型';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."FFSCHEMAID" IS '发料方案ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISVALIDPERIOD" IS '是否有效期管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VALIDPERIOD" IS '有效期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VALIDPERIODUNIT" IS '有效期单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISBINLIFE" IS '是否库龄管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BINLIFE" IS '库龄';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BINLIFEUNIT" IS '库龄单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISBATCH" IS '是否批次管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BATCHUNIT" IS '批次单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BATCHCONVERSIONUNIT" IS '批次换算单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."USEBATCHCONVERSIONRATE" IS '是否使用批次换算率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."LABEL" IS '标签';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TIMESTAMP_CREATEDBY" IS '创建人';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TIMESTAMP_CREATEDON" IS '创建时间';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TIMESTAMP_LASTCHANGEDBY" IS '最后修改人';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TIMESTAMP_LASTCHANGEDON" IS '最后修改时间';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SPECIFICATIONS" IS '规格';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MODEL" IS '型号';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DRAWINGNO" IS '图号';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MATERIALDESCRIPTION" IS '物料描述';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISPURCHASE" IS '是否采购件';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISINVENTORY" IS '是否库存管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISSALES" IS '是否销售件';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISPRODUCTABLE" IS '是否可生产';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISOEM" IS '是否OEM件';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISVERSIONMANAGEABLE" IS '是否版本管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PACKAGEMANAGEMENT" IS '包装管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SINGLEPIECEMANAGEMENT" IS '单件管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PRODUCTCONFIGURATION" IS '产品配置';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SPECIALMANAGEMENT" IS '特殊管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MODEOFPRODUCTION" IS '生产模式';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VIRTUALMATERIALATTR" IS '虚拟物料属性';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DEFAULTREJECTRATE" IS '默认拒收率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DEFAULTWASTERATE" IS '默认损耗率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PRODUCTIONFEEDINGCONTROL" IS '生产发料控制';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BATCHMEASURE" IS '批次计量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."FIXEDQUANTITY" IS '固定数量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."APPLIEDEXHAUST" IS '执行用尽';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISQC" IS '是否检验';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."QCMODE" IS '检验模式';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PLANINGMODE" IS '计划模式';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISMPS" IS '是否主生产计划';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PRODUCTBATCHRULE" IS '生产批次规则';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PRODUCTFIXEDBATCH" IS '生产固定批量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."INCREMENTBATCH" IS '生产增量批量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PRODUCTBATCHMEASUREUNIT" IS '生产批量单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."FIXEDADVANCEDAY" IS '固定提前期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CHANGEADVANCEDAY" IS '变动提前期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BASEYIELDINCHANGEADVANCEDAY" IS '变动提前期基数';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BASEYIELDMEASUREUNIT" IS '基数单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PURCHASEBATCHRULE" IS '采购批次规则';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PURCHASEFIXEDBATCH" IS '采购固定批量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PURCHASEIMCREMENTBATCH" IS '采购增量批量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PURCHASEBATCHMEASUREUNIT" IS '采购批量单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PURCHASEFIXEDADVANCEDAY" IS '采购固定提前期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PRUCHASECHANGEADVANCEDAY" IS '采购变动提前期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BASEYIELDINPURCHASEADVANCEDAY" IS '采购提前期基数';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PURCHASEBASEYIELDMEASUREUNIT" IS '采购基数单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SUMMARY" IS '摘要';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."RATE" IS '比率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TAXBILLSPECIFICATION" IS '开票规格';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TAXCLASSIFICATION" IS '税收分类';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DEFAULTUNITPRICE" IS '默认单价';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."UNITPRICETAXINCLUDED" IS '单价是否含税';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ENJOYPREFERENTIALPOLICIES" IS '是否享受优惠政策';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CONTENTOFPREFERENTIALPOLICIES" IS '优惠政策内容';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TAXBILLMEASUREUNIT" IS '开票单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SECLEVEL" IS '安全等级';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SECLEVELID" IS '安全等级ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."GRLACKRATE" IS '入库缺料率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."GROVERRATE" IS '入库超料率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."GILACKRATE" IS '领料缺料率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."GIOVERRATE" IS '领料超料率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DEFAULTOUTPUTRATE" IS '默认产出率';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."RECOILCONSUMPTION" IS '反冲消耗';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PICKINGBATCH" IS '拣货批量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PLANNEDDAILYSUPPLY" IS '计划日供应量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SUPPLYTYPE" IS '供应类型';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SINGLEUNIT" IS '单个单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BILLSTATUS" IS '单据状态';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."INSTANCEID" IS '实例ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BILLPARAMS" IS '单据参数';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."BILLMARK" IS '单据标记';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MAINIMAGE" IS '主图路径';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MAINIMAGENAME" IS '主图名称';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."OUTBOUNDSTRATEGY" IS '出库策略';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISQCLEVEL" IS '是否检验等级';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."DOMAINTYPE" IS '域类型';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."OWNERORG" IS '所属组织';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."OWNERDOMAIN" IS '所属域';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MEASUREUNITS" IS '计量单位组';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."NEWCODE" IS '新编码';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."NEWNAME" IS '新名称';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SAFETYSTOCKCEILING" IS '安全库存上限';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."SAFETYSTOCKLOWERLIMIT" IS '安全库存下限';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."FLEXCONFIG" IS '弹性配置';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."QCLEVEL" IS '检验等级';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."INITIALINSPECTIONREQUIRED" IS '是否需要首检';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CUSTOMFIELD1" IS '自定义字段1';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CUSTOMFIELD2" IS '自定义字段2';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CUSTOMFIELD3" IS '自定义字段3';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CUSTOMFIELD4" IS '自定义字段4';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CUSTOMFIELD5" IS '自定义字段5';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."CUSTOMFIELD6" IS '自定义字段6';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISDOUBLEREVIEW" IS '是否双审';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISRELEASECONTROL" IS '是否发放控制';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MINORDERQUANTITY" IS '最小订货量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MAXORDERQUANTITY" IS '最大订货量';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."EXTC_EXTVARCHAR1" IS '扩展字段1';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISREINSPECTIONPERIOD" IS '是否复检期管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."REINSPECTIONPERIOD" IS '复检期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."REINSPECTIONPERIODUNIT" IS '复检期单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISOILSEALPERIOD" IS '是否油封期管理';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."OILSEALPERIOD" IS '油封期';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."OILSEALPERIODUNIT" IS '油封期单位';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."TAXCODE" IS '税收编码';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ISVIRTUAL" IS '是否虚拟件';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."RAWMATERIALGRADE" IS '原材料等级';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."RAWMATERIALTECHNICALSTANDARDS" IS '原材料技术标准';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."LOWTURNOVERRISK" IS '低周转风险';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."RESERVEPLANTYPE" IS '储备计划类型';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."ABCCLASSIFICATION" IS 'ABC分类';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PROCUREMENTMODE" IS '采购模式';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."PREPROCESSINGDAYCOUNT" IS '前置加工天数';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."POSTPROCESSINGDAYCOUNT" IS '后置加工天数';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VALIDPERIODFORMAT" IS '有效期格式';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VALIDPERIODCALCRULE" IS '有效期计算规则';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."VALIDPERIODCALCRULEFLOATVALUE" IS '有效期计算规则值';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."INVENTORYACCOUNTTYPE" IS '存货科目类型';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MAINGENERALMEASUREUNITID" IS '主计量单位ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."AUXGENERALMEASUREUNITID" IS '辅计量单位ID';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."INVOICENAME" IS '开票名称';
COMMENT ON COLUMN "GSSERVER"."ERP_MATERIAL_BACKUP"."MNEMOCODE" IS '助记码';
COMMENT ON TABLE "GSSERVER"."ERP_MATERIAL_BACKUP" IS 'ERP物料主数据表';
-- ----------------------------
-- Primary Key structure for table ERP_MATERIAL_BACKUP
-- ----------------------------
ALTER TABLE "GSSERVER"."ERP_MATERIAL_BACKUP" ADD PRIMARY KEY ("ID");
/*
Navicat Premium Dump SQL
Source Server : dameng
Source Server Type : Dameng
Source Server Version : 8014170 (08.01.4170)
Source Host : 127.0.0.1:5236
Source Schema : ERP
Target Server Type : Dameng
Target Server Version : 8014170 (08.01.4170)
File Encoding : 65001
Date: 17/04/2026 09:52:22
*/
-- ----------------------------
-- Table structure for ERP_BFPARTNER_BACKUP
-- ----------------------------
DROP TABLE IF EXISTS "GSSERVER"."ERP_BFPARTNER_BACKUP";
CREATE TABLE "GSSERVER"."ERP_BFPARTNER_BACKUP" (
"ID" VARCHAR(255) NOT NULL,
"CODE" VARCHAR(255),
"NAME" NVARCHAR(16383),
"REMARK" VARCHAR(255),
"STATE_ISENABLED" CHAR(1),
"STATE_DISABLETIME" TIMESTAMP(6),
"STATE_ASYNCDELETESTATUS" VARCHAR(255),
"ATTACHMENT" CLOB,
"REPRESENTATIVE" VARCHAR(255),
"INDUSTRY" VARCHAR(255),
"AREA" VARCHAR(255),
"ORGANIZATIONCODE" VARCHAR(255),
"COUNTRYORREGION" VARCHAR(255),
"OFREGION" VARCHAR(255),
"TYPE" VARCHAR(255),
"TIMESTAMP_CREATEDBY" VARCHAR(255),
"TIMESTAMP_CREATEDON" TIMESTAMP(6),
"TIMESTAMP_LASTCHANGEDBY" VARCHAR(255),
"TIMESTAMP_LASTCHANGEDON" TIMESTAMP(6),
"DEFAULTCURRENCYID" VARCHAR(255),
"BILLSTATUS" VARCHAR(255),
"INSTANCEID" VARCHAR(255),
"SUPERIORPARTNER" VARCHAR(255),
"REGISTEREDCAPITAL" VARCHAR(255),
"COMPANYWEBSITE" VARCHAR(255),
"EMAIL" VARCHAR(255),
"DEFAULTADDRESS" VARCHAR(255),
"DEFAULTCONTACT" VARCHAR(255),
"COMPANYORPERSON" VARCHAR(255),
"ISCUSTOMER" CHAR(1),
"ISVENDER" CHAR(1),
"ISOTHER" CHAR(1),
"INTERIORCOMPANY" CHAR(1),
"DISTRIBUTION" CHAR(1),
"INTERIORACCOUNTINGORG" VARCHAR(255),
"INTERIORADMINORG" VARCHAR(255),
"TAXPAYER" VARCHAR(255),
"DEFAULTCOMPANY" VARCHAR(255),
"TAXIDNUMBER" VARCHAR(255),
"REGISTEREDADDRESS" VARCHAR(255),
"CONTACTINFO" VARCHAR(255),
"BANK" VARCHAR(255),
"ACCOUNT" VARCHAR(255),
"TYPEOFTAXPAYER" VARCHAR(255),
"TAXPAYEREMAIL" VARCHAR(255),
"TELFORINVOICE" VARCHAR(255),
"TYPEOFSUPPIER" VARCHAR(255),
"REGIONOFSUPPIER" VARCHAR(255),
"TYPEOFCLIENT" VARCHAR(255),
"REGIONOFCLIENT" VARCHAR(255),
"LINEOFCREDIT" INT,
"ACCOUNTPERIOD" INT,
"BANKFORINVOICE" VARCHAR(255),
"SHORTNAME" VARCHAR(255),
"SUMMARY" VARCHAR(255),
"OWNERORG" VARCHAR(255),
"OWNERDOMAIN" VARCHAR(255),
"SECLEVEL" INT,
"SECLEVELID" VARCHAR(255),
"DOMAINTYPE" VARCHAR(255),
"REFERID1" VARCHAR(255),
"REFERID2" VARCHAR(255),
"REFERID3" VARCHAR(255),
"REFERID4" VARCHAR(255),
"REFERID5" VARCHAR(255),
"PLAINTEXT1" VARCHAR(255),
"PLAINTEXT2" VARCHAR(255),
"PLAINTEXT3" VARCHAR(255),
"PLAINTEXT4" VARCHAR(255),
"PLAINTEXT5" VARCHAR(255),
"DEC1" DECIMAL(18,4),
"DEC2" DECIMAL(18,4),
"DEC3" DECIMAL(18,4),
"DEC4" DECIMAL(18,4),
"DEC5" DECIMAL(18,4),
"UNITNATURE" VARCHAR(255),
"NREMARK" CLOB,
"NSUMMARY" CLOB,
"NREGISTEREDADDRESS" CLOB,
"ENABLEESIGN" VARCHAR(255),
"REGISTEREDTIME" TIMESTAMP(6),
"PAIDINCAPITAL" VARCHAR(255),
"CREDITRATING" VARCHAR(255),
"MANAGEMENTSTATE" VARCHAR(255),
"ACTUALCONTROLLER" VARCHAR(255),
"MNEMOCODE" VARCHAR(255),
"BILLTYPE" VARCHAR(255),
"ACTUALCONTROLLERPARTNER" VARCHAR(255),
"IEOWNERDOMAINS" CLOB,
"BUSINESSSCOPE" CLOB,
"PUBLICRATINGLEVEL" VARCHAR(255),
"PUBLICRATINGSCORE" DECIMAL(18,4),
"INPUBLICBLACKLIST" CHAR(1),
"OFFICEPHONE" VARCHAR(255),
"ENTERPRISESCALE" VARCHAR(255)
)
;
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ID" IS 'ID';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."CODE" IS '编码';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."NAME" IS '名称';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REMARK" IS '备注（弃用）';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."STATE_ISENABLED" IS '是否可用';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."STATE_DISABLETIME" IS '停用时间';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."STATE_ASYNCDELETESTATUS" IS '异步删除状态';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ATTACHMENT" IS '附件';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REPRESENTATIVE" IS '法人代表';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."INDUSTRY" IS '行业';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."AREA" IS '地区';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ORGANIZATIONCODE" IS '社会信用代码';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."COUNTRYORREGION" IS '所属国家或地区';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."OFREGION" IS '行政区划';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TYPE" IS '类别';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TIMESTAMP_CREATEDBY" IS '创建人';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TIMESTAMP_CREATEDON" IS '创建时间';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TIMESTAMP_LASTCHANGEDBY" IS '最后修改人';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TIMESTAMP_LASTCHANGEDON" IS '最后修改时间';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEFAULTCURRENCYID" IS '默认交易币种';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."BILLSTATUS" IS '审批状态';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."INSTANCEID" IS '审批流程ID';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."SUPERIORPARTNER" IS '上级往来单位';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REGISTEREDCAPITAL" IS '注册资金';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."COMPANYWEBSITE" IS '主页';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."EMAIL" IS '电子邮箱';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEFAULTADDRESS" IS '默认地址';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEFAULTCONTACT" IS '默认联系人';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."COMPANYORPERSON" IS '公私性质';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ISCUSTOMER" IS '是否客户';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ISVENDER" IS '是否供应商';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ISOTHER" IS '是否其他';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."INTERIORCOMPANY" IS '是否内部单位';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DISTRIBUTION" IS '是否分配';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."INTERIORACCOUNTINGORG" IS '内部单位核算组织';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."INTERIORADMINORG" IS '内部单位行政组织';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TAXPAYER" IS '纳税人名称';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEFAULTCOMPANY" IS '默认单位名称';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TAXIDNUMBER" IS '纳税人识别号';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REGISTEREDADDRESS" IS '注册地址（弃用）';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."CONTACTINFO" IS '联系电话';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."BANK" IS '开户银行';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ACCOUNT" IS '银行账号';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TYPEOFTAXPAYER" IS '纳税人类型';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TAXPAYEREMAIL" IS '邮箱地址';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TELFORINVOICE" IS '收票手机号';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TYPEOFSUPPIER" IS '供应商类别';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REGIONOFSUPPIER" IS '供应商地区';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."TYPEOFCLIENT" IS '客户类别';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REGIONOFCLIENT" IS '客户地区';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."LINEOFCREDIT" IS '信用额度';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ACCOUNTPERIOD" IS '到账（日）';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."BANKFORINVOICE" IS '开票银行';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."SHORTNAME" IS '简称';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."SUMMARY" IS '摘要（弃用）';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."OWNERORG" IS '所属行政组织ID';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."OWNERDOMAIN" IS '所属作用域ID';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."SECLEVEL" IS '密级等级';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."SECLEVELID" IS '密级';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DOMAINTYPE" IS '使用范围';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REFERID1" IS '关联字段1';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REFERID2" IS '关联字段2';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REFERID3" IS '关联字段3';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REFERID4" IS '关联字段4';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REFERID5" IS '关联字段5';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PLAINTEXT1" IS '显示字段1';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PLAINTEXT2" IS '显示字段2';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PLAINTEXT3" IS '显示字段3';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PLAINTEXT4" IS '显示字段4';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PLAINTEXT5" IS '显示字段5';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEC1" IS '数字字段1';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEC2" IS '数字字段2';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEC3" IS '数字字段3';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEC4" IS '数字字段4';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."DEC5" IS '数字字段5';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."UNITNATURE" IS '单位性质';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."NREMARK" IS '备注';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."NSUMMARY" IS '摘要';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."NREGISTEREDADDRESS" IS '注册地址';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ENABLEESIGN" IS '启用电子签章';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."REGISTEREDTIME" IS '注册时间';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PAIDINCAPITAL" IS '实缴资本';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."CREDITRATING" IS '信用评级';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."MANAGEMENTSTATE" IS '经营状态';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ACTUALCONTROLLER" IS '实际控制人';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."MNEMOCODE" IS '助记码';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."BILLTYPE" IS '审批类型';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ACTUALCONTROLLERPARTNER" IS '实际控制单位';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."IEOWNERDOMAINS" IS '往来单位所属组织范围';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."BUSINESSSCOPE" IS '经营范围';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PUBLICRATINGLEVEL" IS '外部评级等级';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."PUBLICRATINGSCORE" IS '评分';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."INPUBLICBLACKLIST" IS '是否黑名单';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."OFFICEPHONE" IS '办公电话';
COMMENT ON COLUMN "GSSERVER"."ERP_BFPARTNER_BACKUP"."ENTERPRISESCALE" IS '企业规模';
COMMENT ON TABLE "GSSERVER"."ERP_BFPARTNER_BACKUP" IS '往来单位表';
-- ----------------------------
-- Primary Key structure for table ERP_BFPARTNER_BACKUP
-- ----------------------------
ALTER TABLE "GSSERVER"."ERP_BFPARTNER_BACKUP" ADD PRIMARY KEY ("ID");
Reference in New Issue View Git Blame Copy Permalink