应收核销日志查询提示“将截断字符串或二进制数据”
金蝶云社区-Ansel
Ansel
1人赞赏了该文章 851次浏览 未经作者许可,禁止转载编辑于2020年07月17日 09:16:44

K/3 WISE 15.1 应收管理


发票或者收款单都没有异常,查询应收核销日志出现该提示,部分日期而不是全部都会,跟踪了下看了也不应该有超出,文本部分大都设置了255的长度,不知道是哪个存储过程。。。。何解?

Create Table #TmpCheckInfo(
FNumber varchar(255) default(' '),
FRP int default(1),
FSortID int default(-1000),
FDate datetime,
FID int ,
FCheckID int default(0),
FCheckManerID int default(0),
FCheckTypeID int default(0),
FCheckManer varchar(255) default(' '),
FCheckType varchar(255) default(' '),
FTransfer int default(0),
FTransferID int default(0),
FChecker int default(0),
FCurrencyID int default(0),
FExchangeRate decimal(28,10) default(0),
FVoucherID int default(0),
FARtoAR int default(0),
FPreToPre int default(0),
FItemClassID int default(0),
FUnTread int default(0),
FUnEndorse tinyint default(0),
FUnTreadID int default(0),
FType int default(0),
FISinit int default(0),
FInvoiceID int default(0),
FRPBillID int default(0),
FBillID int default(0),
FPre int default(0),
FK3Import int default(0),
FBegID int default(0),
FContactID int default(0),
FBadID int default(0),
FCheckdate dateTime ,
FExplanation varchar(255) default(' '),
FNote varchar(255) default(' '),
FCustomerName varchar(255) default(' '),
FCustomerNumber varchar(255) default(' '),
FDepartmentName varchar(255) default(' '),
FDepartmentNumber varchar(255) default(' '),
FEmployeeName varchar(255) default(' '),
FEmployeeNumber varchar(255) default(' '),
FCurrencyName varchar(255) default(' '),
FCheckUser varchar(255) default(' '),
FBillAmountFor money default(0),
FBillRemainAmountFor money default(0),
FCheckAmount1 money default(0),
FCheckAmountFor1 money default(0),
FCheckAmount2 money default(0),
FCheckAmountFor2 money default(0),
FRemainAmount money default(0),
FRemainAmountFor money default(0),
FContractNo varchar(255) default(' '),
FOrderNo varchar(255) default(' '),
FCheckQty1 decimal(28,10) default(0),
FCheckQty2 decimal(28,10) default(0),
FRemainQty decimal(28,10) default(0),
FItemNumber varchar(255) default(' '),
FItemName varchar(255) default(' '),
FModel varchar(255) default(' '),
FUnitName varchar(255) default(' '),
FFincDate datetime)