04. EDI File ID definitions

File ID Direction Explanation
1000 ET6.1 to Web System codes. SQL table System.
1110 Web to ET6.1 EDI Product (compatible with ET6.1 SP4 Product). SQL table EdiProduct, which is later archived to table EdiProductArchive during export process (by .NET edi.exe). In the same time, EdiTransaction (in Torus61, home table) has transactions inserted, which can then be used for billing purposes.
1118 ET6.1 to Web Web product catalog. SQL table CategoryProduct.
1210 ET6.1 to Web Customer data. SQL table Customer.
1310 ET6.1 to Web Supplier data. SQL table Suplier.
3110 ET6.1 to Web Fresh quotation date--quoterm. SQL table QuoMas.
3111 ET6.1 to Web Fresh quotation data-quote. SQL table QuoDet.
4110 ET6.1 to Web Fresh sales confirmation data--scmas. SQL table ScMas.
4111 ET6.1 to Web Fresh sales confirmation data--scdet. SQL table ScDet;
4112 ET6.1 to Web Modified sales confirmation data--scmas.
4113 ET6.1 to Web Modified sales confirmation data--scdet. 
5110 ET6.1 to Web Fresh purchase order data--pomas. SQL table PoMas.
5111 ET6.1 to Web Fresh purchase order data-podet. SQL table PoDet.
5112 ET6.1 to Web Modified purchase order data--pomas. SQL table PoMas.
5113 ET6.1 to Web Modified purchase order data-podet. SQL table PoDet.
6110 ET6.1 to Web Fresh invoice data--memomas. SQL table InvMas.
6111 ET6.1 to Web Fresh invoice data-memodet. SQL table InvDet.
6112 ET6.1 to Web Modified invoice data--memomas. SQL table InvMas.
6113 ET6.1 to Web Modified invoice data-memodet. SQL table InvDet.

Note: File ID is stored in the first 2 bytes of an .edi file, as an integer. It is followed by a 2-byte integer that indicates the field count of records stored after the 128-byte header. (see 05. EDI file structure)