Where in the Database can we find where the sequence number is stored for the WI files ?


 Product(s):Exor CIM / FIM
 Version(s):04.05.00.08
 Environment:Windows XP 64 bit
 Area:Invoice File
 Subarea:N\A

Problem

Where in the Database can we find where the sequence number is stored for the WI files ?



Solution

Try the interface_headers table  where the file type = 'WI'  and check the value in the column ih_seq_no

or in sql try

select *
from interface_headers
where ih_file_type='WI'
order by ih_created_date desc


 



 Original Author:Clive T