模板介绍

模板说明

执行查询金蝶云星空中的基础数据中的客户数据，可以查询到后同步到数仓或者经过变换后同步到其他业务系统中去

流程图

依赖组件

1.需要下载金蝶云星空拉取客户操作组件
2.需要创建相应的表结构或者让输出组件自动建表

依赖表结构

CREATE TABLE `金蝶云星空拉取客户`  (
  `Id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `FCreateOrgId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FShortName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FCOUNTRY` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FPROVINCIAL` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FADDRESS` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FZIP` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FTRADINGCURRID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;```

使用评价