问题描述：

供应链采购发票（专用）单据的表体上没有字段【备注】，外购入库单上的备注字段如何携带传递到发票单据？

解决方案：

注意：请务必在备份账套中做好测试，避免误操作对账套数据造成影响。

请在SQL Server中，对所需账套数据库实体执行以下SQL语句：

1、购货发票（专用）单据上增加备注字段列；

INSERT INTO ICTemplateEntry(FID,FCtlOrder,FCtlIndex,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FEnable,FPrint,FHeadCaption,FWidth,FNeedCount,FRelationID,FAction,FMustInput,FFilter,FSaveRule,FDefaultCtl,FVisForBillType,FRelateOutTbl,FSysMustInputItem,FHeadCaption_CHT,FHeadCaption_EN,FStatCount,FIsVisibleForList,FCanEditedAllTime,FAllowCopy,FDefaultValue,FMaxValue,FMinValue,FFormat,FPrintStatus,FLookUpType,FOptionExt,FItemClassID,FUserDefineClassID,FDescription,FDescription_CHT,FDescription_EN,IsSupportImport,FLeftForBarCode,FTopForBarCode,FWidthForBarCode,FHeightForBarCode,CanEditedCheck)

values('I02','63','63','2','6','1','0','0','FNote','48','1','备注','1005','0','','','0','','','1','31','0','0','備註','Remarks','0','1','1','1','','','','','0','0','1','0','0','','','','0','100','500','2000','300','0')

GO

2、增加外购入库单备注字段与购货专用发票之间的转换关系，支持携带备注内容。

INSERT INTO ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited)

values('I02','FInStockInterID','FNote','0','0','FNote','FNote','ICStockBillEntry','u1','','0','0')

GO