SORT_SEQUENCE is a 10 digit numeric field used to specify the sort sequence for the Record #, Field # and is used for Record # with Record Type = 'Detail Record' only.
For Record # with Record Type = 'Detail Level 1' to 'Detail Level 5', it uses the same Sort from Record Type = 'Detail Record' so that the Detail Level n records are followed after the 'Detail Record'
e.g. Interface File need to sort by: Department, Employee First Name, Last Name
- For the Fld# entry that specify 'Department', enter sort sequence: 100
- For the Fld# that specify 'Employee First Name', enter sort sequence: 150
- For the Fld# that specify 'Employee Last Name', enter sort sequence: 200
All Sort sequences must be entered on entries with the same Record Number.
Sort Sequence is not supported for XML file format because XML file may specify many different Record # to generate XML begin and end tags and the XML tags are not able to sort along with the data.