select TOP(100) * from SP_FIRM_FILE_LOAD ORDER BY 1 DESC

select TOP(100) * from SP_FIRM_FILE_LOAD_MAPPING


INSERT INTO SP_FIRM_FILE_LOAD (NAME_FILE_LOAD, TYPE_RECORD, NAME_FILE_LOAD_S) VALUES ('ВЭД Подтверждение поставщика', 'T_P_ZAKAZ_DOC_GOOD', 'ВЭД п/п')
declare @ID_FIRM_FILE_LOAD int = 20;
INSERT INTO SP_FIRM_FILE_LOAD_MAPPING (ID_FIRM_FILE_LOAD, WORK_SHEET_NAME, FIELD_NAME_SOURCE, FIELD_NAME_DESTINATION, DATA_TYPE) VALUES
(@ID_FIRM_FILE_LOAD, 'Лист1','Количество PI, шт','KOL_GOOD_NETTO','I'),
(@ID_FIRM_FILE_LOAD, 'Лист1','Цена PI','PRICE','F'),
(@ID_FIRM_FILE_LOAD, 'Лист1','Дата Производства','DAT_DOCUMENT','D'),
(@ID_FIRM_FILE_LOAD, 'Лист1','Номер инвойса','NOM_DOCUMENT','I');