| 解决方案： |
根据应收单的信息在单据结算表Ap_CloseBill中直接插入一行记录即可。
语句：
use ufdata_059_2005
INSERT INTO Ap_CloseBill
(cVouchType, cVouchID, dVouchDate, iPeriod, cDwCode, cCoVouchType, cCoVouchID,
dCoVouchDate, cDigest, cexch_name, iExchRate, iAmount, iAmount_f, iRAmount,
iRAmount_f, cOperator, cCancelMan, bPrePay, bStartFlag, cCode, iPayForOther,
cSrcFlag, cFlag, bSend, bReceived, cSSCode)
VALUES ('48', '0000016117', CONVERT(DATETIME, '2003-03-13 00:00:00', 102), 3, 'FQ1045',
'48', '0000016117', CONVERT(DATETIME, '2005-03-13 00:00:00', 102), '客户交本息费;',
'人民币', 1, 3664.41, 3664.41, 0, 0, '闫国丽', '闫国丽', 1, 0, '1001', 0, 'A', 'AR', 0, 0, '43') |