statement needs to specify the same number of columns as you are
ing. The names do not matter.
The columns you're inserting don't need to come from the table you're selecting from. You can use parameters, local variables, or functions instead.
INSERT INTO table_x (ID_CLI, COMPANY_NAME, EXP_DATE, DTINIT)
SELECT ANCDCF, ANRGSO, @EXP_DATE, SYSDATETIME()
WHERE table_y.ANCDCF = @ID_CUSTOMER
AND table_y.ANRGSO = @COMPANY_NAME;