Your INSERT lists 7 fields:
INSERT INTO [ax].[WaitingKitchenStatus]
(
[TRANSACTIONID]
, [LineNote]
, [Item]
, [CreationDate]
, [CreationTime]
, [active]
,[Gruop]
)
But the actual SELECT that provides the information only supplies 3:
SELECT ab.COMMENT
,[ax].[ECORESPRODUCTTRANSLATION].[NAME]
, ab.[ITEMID]
FROM ax.RetailTransactionSalesTrans ab
The system won't "invent" data. Either supply 4
NULL
values as well, or only list the columns you do provide data for. (I'm guessing you are only providing the
LineNote
and the
Item
, plus a Name that has no obvious column to store it in, so you might want to think about your data a little more carefully.)