:::tip{title="储值余额调整"}
储值卡批量调整余额
:::



![image.png](/static/img/03c894d1c2fdc4e64bf486f4bc339d64.image.webp)

![1733456744156.jpg](/static/img/4a3afc3e54565f2ade116b5ee3c038de.1733456744156.webp)



:::warning{title="注意"}
>导入之后，检查无误，需要审核即可
:::




![](https://school.hansonvip.com/static/img/373d360268d16bcf8c5e4308a2f0c0ee.image.webp)

储值卡批量调整余额

:::tip{title="提示"}
用户资料--单据访问权
:::




![1733391745028.png](/static/img/274f8f70b5c2b42f981fe2fc904810b7.1733391745028.webp)

回答：缺少脚本


```

--20241116外协加工计划单出库单入库单加单据类型及单据登记修正.sql
-- 外协加工计划单单据登记修正
IF EXISTS(SELECT 1 FROM sys_tables WHERE tbl_id='EMM_CLT_DAT_JGJH')
DELETE FROM sys_tables WHERE tbl_id='EMM_CLT_DAT_JGJH'

IF NOT EXISTS(SELECT 1 FROM Emm_sys_tables WHERE tbl_id='EMM_CLT_DAT_JGJH')
    INSERT INTO Emm_sys_tables (tbl_id,tbl_name,tbl_explain,tbl_type,tbl_dtl,sys_valid)
        VALUES ('EMM_CLT_DAT_JGJH','外协加工计划单','外协加工计划单','dat1',1,1)
GO
-- 外协加工出库单单据登记修正
IF EXISTS(SELECT 1 FROM sys_tables WHERE tbl_id='EMM_CLT_DAT_JGCK')
DELETE FROM sys_tables WHERE tbl_id='EMM_CLT_DAT_JGCK'

IF NOT EXISTS(SELECT 1 FROM Emm_sys_tables WHERE tbl_id='EMM_CLT_DAT_JGCK')
    INSERT INTO Emm_sys_tables (tbl_id,tbl_name,tbl_explain,tbl_type,tbl_dtl,sys_valid)
        VALUES ('EMM_CLT_DAT_JGCK','外协加工出库单','外协加工出库单','dat1',1,1)
GO

-- 外协加工入库单单据登记修正
IF EXISTS(SELECT 1 FROM sys_tables WHERE tbl_id='EMM_CLT_DAT_JGRK')
DELETE FROM sys_tables WHERE tbl_id='EMM_CLT_DAT_JGRK'

IF NOT EXISTS(SELECT 1 FROM Emm_sys_tables WHERE tbl_id='EMM_CLT_DAT_JGRK')
    INSERT INTO Emm_sys_tables (tbl_id,tbl_name,tbl_explain,tbl_type,tbl_dtl,sys_valid)
        VALUES ('EMM_CLT_DAT_JGRK','外协加工入库单','外协加工入库单','dat1',1,1)
GO



```

违反了 PRIMARY KEY 约束“PK BAS USER TICK”

:::tip{title="提示"}
查询SQL版本
:::



SELECT @@VERSION;

查询SQL版本

:::tip{title="CxPriority"}
收银系统报错：列名'CxPriority'无效
:::





![1731376617781.png](/static/img/1c646bf5b184e7843762bb9b41d91cac.1731376617781.webp)



>回答:缺少脚本


```
--- 2024071910.0新促销添加促销优先级字段
if not exists(select 1 from syscolumns where id=OBJECT_ID(N'dbo.ERP8_Dat_CX') and name='CxPriority')
	alter table ERP8_Dat_CX add CxPriority numeric(3,0) null CONSTRAINT [DF_ERP8_Dat_CX_CxPriority]  DEFAULT (0)  --- 优先级 默认是 0 3位数字
GO

```

列名'CxPriority'无效

:::tip{title="OnePosCheMoreDouYInCoups"}
收银系统报错：列名'OnePosCheMoreDouYInCoups'无效。
:::




![image.png](/static/img/a67c8e19c367f2cd42e9e3dd6d533a52.image.webp)

回答：缺少脚本


```
--- 2024-10-16收银允许一张POS单用多张抖音券
if not exists(select 1 from syscolumns where id=OBJECT_ID(N'BAS_Shp') and name='OnePosCheMoreDouYInCoups')
	alter table BAS_Shp  add OnePosCheMoreDouYInCoups bit null    -- POS 收银允许一张POS单用多张抖音券
GO

if not exists(select 1 from syscolumns where id=OBJECT_ID(N'Dat_Gtss_Coupons_DouYin') and name='certificate_id')
	alter table Dat_Gtss_Coupons_DouYin  add certificate_id nvarchar(200) null    -- POS 抖音券券码 唯一券ID 退券需要
GO


```