SQL脚本生成凭证

/*生成凭证*/

INSERT INTO t_Voucher(FDate, FTransDate, FYear, FPeriod, FGroupID, FNumber, FReference, FExplanation, FAttachments, FEntryCount, FDebitTotal, FCreditTotal, FInternalInd, FChecked, FPosted, FPreparerID, FCheckerID, FPosterID, FCashierID, FHandler, FObjectName, FParameter, FSerialNum, FTranType, FOwnerGroupID)
VALUES(2017, 11, 1, 1, NULL, '11', 0, 3, $100.0000, $100.0000, NULL, 0, 0, 16394, -1, -1, -1, NULL, NULL, NULL, 1, 0, 1);

Select FDetailID From t_ItemDetail Where FDetailCount = 2 And F1=10272 And F3=10271

INSERT INTO t_ItemDetail(FDetailCount, F1, F3)VALUES(2, 10272, 10271);

INSERT INTO t_ItemDetailV(FDetailID, FItemClassID, FItemID)VALUES(2, 1, 10272);

INSERT INTO t_ItemDetailV(FDetailID, FItemClassID, FItemID)VALUES(2, 3, 10271);

INSERT INTO t_VoucherEntry(FVoucherID, FEntryID, FExplanation, FAccountID, FCurrencyID, FExchangeRateType, FExchangeRate, FDC, FAmountFor, FAmount, FQuantity, FMeasureUnitID, FUnitPrice, FInternalInd, FAccountID2, FSettleTypeID, FSettleNo, FCashFlowItem, FTaskID, FResourceID, FTransNo, FDetailID)
VALUES(1, 0, '11', 1005, 1, 1, 1, 1, $100.0000, $100.0000, 0, 0, 0, NULL, 1054, 0, NULL, 0, 0, 0, NULL, 2);

INSERT INTO t_VoucherEntry(FVoucherID, FEntryID, FExplanation, FAccountID, FCurrencyID, FExchangeRateType, FExchangeRate, FDC, FAmountFor, FAmount, FQuantity, FMeasureUnitID, FUnitPrice, FInternalInd, FAccountID2, FSettleTypeID, FSettleNo, FCashFlowItem, FTaskID, FResourceID, FTransNo, FDetailID)
VALUES(1, 1, NULL, 1054, 1, 1, 1, 0, $83.0000, $83.0000, 0, 0, 0, NULL, 1005, 0, NULL, 0, 0, 0, NULL, 0);

INSERT INTO t_VoucherEntry(FVoucherID, FEntryID, FExplanation, FAccountID, FCurrencyID, FExchangeRateType, FExchangeRate, FDC, FAmountFor, FAmount, FQuantity, FMeasureUnitID, FUnitPrice, FInternalInd, FAccountID2, FSettleTypeID, FSettleNo, FCashFlowItem, FTaskID, FResourceID, FTransNo, FDetailID)
VALUES(1, 2, NULL, 1037, 1, 1, 1, 0, $17.0000, $17.0000, 0, 0, 0, NULL, 1005, 0, NULL, 0, 0, 0, NULL, 0);