PHP код:
insert_recordset _to ( LineNum, TransDate, Voucher, JournalId, JournalType, ItemId, Qty, CostPrice, PriceUnit, CostMarkup, CostAmount, SalesAmount, InventTransId, InventTransIdFather, LedgerAccountIdOffset, InventOnHand, Counted, Dimension,
DEL_Log, BOMLine, DEL_Posted, DEL_ConfigId, InventTransIdReturn, ProjCategoryId, ProjId, InventDimId, ToInventDimId, ReqPOId, EmplId, AssetTransType, AssetId, AssetBookId, ProjTaxGroupId, ProjSalesCurrencyId, ProjLinePropertyId,
ProjTaxItemGroupId, ProjUnitID, ProjSalesPrice, InventRefType, InventRefId, InventRefTransId, ScrapTypeId_RU, DEL_ReportId_RU, DEL_OffSessionId_RU, K_BaseOfMovment, ReasonNum, IBSReasonNum, Broken)
select
LineNum, TransDate, Voucher, JournalId, JournalType, ItemId, Qty, CostPrice, PriceUnit, CostMarkup, CostAmount, SalesAmount, InventTransId, InventTransIdFather, LedgerAccountIdOffset, InventOnHand, Counted, Dimension, DEL_Log,
BOMLine, DEL_Posted, DEL_ConfigId, InventTransIdReturn, ProjCategoryId, ProjId, InventDimId, ToInventDimId, ReqPOId, EmplId, AssetTransType, AssetId, AssetBookId, ProjTaxGroupId, ProjSalesCurrencyId, ProjLinePropertyId, ProjTaxItemGroupId,
ProjUnitID, ProjSalesPrice, InventRefType, InventRefId, InventRefTransId, ScrapTypeId_RU, DEL_ReportId_RU, DEL_OffSessionId_RU, K_BaseOfMovment, ReasonNum, IBSReasonNum, Broken
from _from
where _from.