2025-04-17 11:37:16 3563 保存单据状态信息到中间表失败：小锋: SELECT a.CREATEDATE 制单时间, b.NAME 制单人, a.ATTACHER 附件张数, a.BILLCODE 单据编号, c.NAME 部门名称, a.PaymentAmount 报销金额, a.CapPaymentAmount 报销金额大写, a.PayReason 报销事由, d.TravelSDate 开始日期, d.TravelEDate 结束日期, e.VALUENAME 区域, d.TravelPlace 目的地, d.Vehicle 交通工具, d.Traveler 出差人, d.OrgName 科室, f.VALUENAME 食宿方式, d.TotalAmount 报销合计, * FROM After_Engage a left join D_USER b on a.CREATECODE_XID=b.id left join D_ORGANIZATION c on a.ORGCODE_XID=c.id left join After_EngageCL d on a.id=d.SHEETPOINTER_XID left join D_Parameter_Line e on d.TRAVELAREA_XID=e.id left join D_Parameter_Line f on d.HOTELFOODTYPE_XID=f.ID 小锋: select a.BILLCODE 单据编号 ,a.CREATEDATE 单据日期 ,b.NAME 报销部门 ,c.NAME 报销人 ,a.PAYMENTAMOUNT 报销金额 ,a.EvectionDateS 出发日期 ,a.EvectionDateE 返回日期 ,a.CarAmount 车船费 ,a.CityAmount 市内交通费 ,a.HotelAmount 住宿费 ,a.HotelDay 住宿天数 ,a.MeetingAmount 会议费 ,a.TrainAmount 培训费 ,a.FoodAmount 伙食费 ,a.OtherAmount 其他费用 ,f.NAME , g.NAME ,d.AGE --,h.VALUENAME ,i.VALUENAME ,PhoneNo , J.DocType AS 单据类型 , K.DOCSTATUS AS 单据状态 ,J.DOCUMENTID AS 单据ID from Rate_OutPay a left join D_ORGANIZATION b on a.ORGCODE_XID=b.ID left join d_user c on a.CREATECODE_XID=c.ID left join RateTrainerList d on a.id=d.SHEETPOINTER_XID left join D_USER f on d.EMPNAME_XID=f.id left join D_ORGANIZATION g on f.ORGNAME_XID=g.id left join D_Parameter_Line h on f.DUTYNAME_XID=f.id left join D_Parameter_Line i on f.JSZC_XID=i.id LEFT JOIN AD_CHECKDOC J ON A.ID=J.DOCUMENTID AND J.DOCTABLENAME='Rate_OutPay' LEFT JOIN AD_Node K ON J.NEXTNODE_XID=K.ID where BILLCODE like 'WCBX2024%' SELECT a.CREATEDATE 制单时间, b.NAME 制单人, a.ATTACHER 附件张数, a.BILLCODE 单据编号, c.NAME 部门名称, a.PaymentAmount 报销金额, a.CapPaymentAmount 报销金额大写, a.PayReason 报销事由, d.TravelSDate 开始日期, d.TravelEDate 结束日期, e.VALUENAME 区域, d.TravelPlace 目的地, d.Vehicle 交通工具, d.Traveler 出差人, d.OrgName 科室, f.VALUENAME 食宿方式, d.TotalAmount 报销合计, d.HYPXAmount 培训费, d.TrafficAmount 车船费, d.PlaneAomunt 飞机费, d.HotelPeople 住宿天数, d.HotelAmount 住宿费, d.FoodDays 伙食天数, d.FoodAllowanceAmount 伙食费, d.TrafficDays 交通补助天数, d.TrafficAllowanceAmount 交通费, d.OtherAmount 其他费用, J.DocType AS 单据类型, K.DOCSTATUS AS 单据状态, J.DOCUMENTID AS 单据ID FROM After_Engage a left join D_USER b on a.CREATECODE_XID=b.id left join D_ORGANIZATION c on a.ORGCODE_XID=c.id left join After_EngageCL d on a.id=d.SHEETPOINTER_XID left join D_Parameter_Line e on d.TRAVELAREA_XID=e.id left join D_Par 参数名: Invalid value for Cause 实际值是 小锋: SELECT a.CREATEDATE 制单时间, b.NAME 制单人, a.ATTACHER 附件张数, a.BILLCODE 单据编号, c.NAME 部门名称, a.PaymentAmount 报销金额, a.CapPaymentAmount 报销金额大写, a.PayReason 报销事由, d.TravelSDate 开始日期, d.TravelEDate 结束日期, e.VALUENAME 区域, d.TravelPlace 目的地, d.Vehicle 交通工具, d.Traveler 出差人, d.OrgName 科室, f.VALUENAME 食宿方式, d.TotalAmount 报销合计, * FROM After_Engage a left join D_USER b on a.CREATECODE_XID=b.id left join D_ORGANIZATION c on a.ORGCODE_XID=c.id left join After_EngageCL d on a.id=d.SHEETPOINTER_XID left join D_Parameter_Line e on d.TRAVELAREA_XID=e.id left join D_Parameter_Line f on d.HOTELFOODTYPE_XID=f.ID 小锋: select a.BILLCODE 单据编号 ,a.CREATEDATE 单据日期 ,b.NAME 报销部门 ,c.NAME 报销人 ,a.PAYMENTAMOUNT 报销金额 ,a.EvectionDateS 出发日期 ,a.EvectionDateE 返回日期 ,a.CarAmount 车船费 ,a.CityAmount 市内交通费 ,a.HotelAmount 住宿费 ,a.HotelDay 住宿天数 ,a.MeetingAmount 会议费 ,a.TrainAmount 培训费 ,a.FoodAmount 伙食费 ,a.OtherAmount 其他费用 ,f.NAME , g.NAME ,d.AGE --,h.VALUENAME ,i.VALUENAME ,PhoneNo , J.DocType AS 单据类型 , K.DOCSTATUS AS 单据状态 ,J.DOCUMENTID AS 单据ID from Rate_OutPay a left join D_ORGANIZATION b on a.ORGCODE_XID=b.ID left join d_user c on a.CREATECODE_XID=c.ID left join RateTrainerList d on a.id=d.SHEETPOINTER_XID left join D_USER f on d.EMPNAME_XID=f.id left join D_ORGANIZATION g on f.ORGNAME_XID=g.id left join D_Parameter_Line h on f.DUTYNAME_XID=f.id left join D_Parameter_Line i on f.JSZC_XID=i.id LEFT JOIN AD_CHECKDOC J ON A.ID=J.DOCUMENTID AND J.DOCTABLENAME='Rate_OutPay' LEFT JOIN AD_Node K ON J.NEXTNODE_XID=K.ID where BILLCODE like 'WCBX2024%' SELECT a.CREATEDATE 制单时间, b.NAME 制单人, a.ATTACHER 附件张数, a.BILLCODE 单据编号, c.NAME 部门名称, a.PaymentAmount 报销金额, a.CapPaymentAmount 报销金额大写, a.PayReason 报销事由, d.TravelSDate 开始日期, d.TravelEDate 结束日期, e.VALUENAME 区域, d.TravelPlace 目的地, d.Vehicle 交通工具, d.Traveler 出差人, d.OrgName 科室, f.VALUENAME 食宿方式, d.TotalAmount 报销合计, d.HYPXAmount 培训费, d.TrafficAmount 车船费, d.PlaneAomunt 飞机费, d.HotelPeople 住宿天数, d.HotelAmount 住宿费, d.FoodDays 伙食天数, d.FoodAllowanceAmount 伙食费, d.TrafficDays 交通补助天数, d.TrafficAllowanceAmount 交通费, d.OtherAmount 其他费用, J.DocType AS 单据类型, K.DOCSTATUS AS 单据状态, J.DOCUMENTID AS 单据ID FROM After_Engage a left join D_USER b on a.CREATECODE_XID=b.id left join D_ORGANIZATION c on a.ORGCODE_XID=c.id left join After_EngageCL d on a.id=d.SHEETPOINTER_XID left join D_Parameter_Line e on d.TRAVELAREA_XID=e.id left join D_Par 。