okayapi_jsh_depothead

-- MySQL Table okayapi_jsh_depothead
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_depothead` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `Id` bigint(20) NULL COMMENT '主键',
    `Type` varchar(50) NULL COMMENT '类型(出库/入库)',
    `SubType` varchar(50) NULL COMMENT '出入库分类',
    `ProjectId` bigint(20) NULL COMMENT '项目Id',
    `DefaultNumber` varchar(50) NULL COMMENT '初始票据号',
    `Number` varchar(50) NULL COMMENT '票据号',
    `OperPersonName` varchar(50) NULL COMMENT '操作员名字',
    `CreateTime` datetime NULL COMMENT '创建时间',
    `OperTime` datetime NULL COMMENT '出入库时间',
    `OrganId` bigint(20) NULL COMMENT '供应商Id',
    `HandsPersonId` bigint(20) NULL COMMENT '采购/领料-经手人Id',
    `AccountId` bigint(20) NULL COMMENT '账户Id',
    `ChangeAmount` decimal(24,6) NULL COMMENT '变动金额(收款/付款)',
    `AllocationProjectId` bigint(20) NULL COMMENT '调拨时，对方项目Id',
    `TotalPrice` decimal(24,6) NULL COMMENT '合计金额',
    `PayType` varchar(50) NULL COMMENT '付款类型(现金、记账等)',
    `Remark` varchar(1000) NULL COMMENT '备注',
    `Salesman` varchar(50) NULL COMMENT '业务员（可以多个）',
    `AccountIdList` varchar(50) NULL COMMENT '多账户ID列表',
    `AccountMoneyList` varchar(200) NULL COMMENT '多账户金额列表',
    `Discount` decimal(24,6) NULL COMMENT '优惠率',
    `DiscountMoney` decimal(24,6) NULL COMMENT '优惠金额',
    `DiscountLastMoney` decimal(24,6) NULL COMMENT '优惠后金额',
    `OtherMoney` decimal(24,6) NULL COMMENT '销售或采购费用合计',
    `OtherMoneyList` varchar(200) NULL COMMENT '销售或采购费用涉及项目Id数组（包括快递、招待等）',
    `OtherMoneyItem` varchar(200) NULL COMMENT '销售或采购费用涉及项目（包括快递、招待等）',
    `AccountDay` int(10) NULL COMMENT '结算天数',
    `Status` varchar(1) NULL DEFAULT '0' COMMENT '状态，0未审核、1已审核、2已转采购|销售',
    `LinkNumber` varchar(50) NULL COMMENT '关联订单号',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
    KEY `Id` (`Id`),
    KEY `Type` (`Type`),
    KEY `SubType` (`SubType`),
    KEY `ProjectId` (`ProjectId`),
    KEY `DefaultNumber` (`DefaultNumber`),
    KEY `Number` (`Number`),
    KEY `OperPersonName` (`OperPersonName`),
    KEY `CreateTime` (`CreateTime`),
    KEY `OperTime` (`OperTime`),
    KEY `OrganId` (`OrganId`),
    KEY `HandsPersonId` (`HandsPersonId`),
    KEY `AccountId` (`AccountId`),
    KEY `ChangeAmount` (`ChangeAmount`),
    KEY `AllocationProjectId` (`AllocationProjectId`),
    KEY `TotalPrice` (`TotalPrice`),
    KEY `PayType` (`PayType`),
    KEY `Remark` (`Remark`),
    KEY `Salesman` (`Salesman`),
    KEY `AccountIdList` (`AccountIdList`),
    KEY `AccountMoneyList` (`AccountMoneyList`),
    KEY `Discount` (`Discount`),
    KEY `DiscountMoney` (`DiscountMoney`),
    KEY `DiscountLastMoney` (`DiscountLastMoney`),
    KEY `OtherMoney` (`OtherMoney`),
    KEY `OtherMoneyList` (`OtherMoneyList`),
    KEY `OtherMoneyItem` (`OtherMoneyItem`),
    KEY `AccountDay` (`AccountDay`),
    KEY `Status` (`Status`),
    KEY `LinkNumber` (`LinkNumber`),
    KEY `tenant_id` (`tenant_id`),
    KEY `delete_Flag` (`delete_Flag`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-单据主表';

After replication, you can go to the database to create the database table.