# MS Conversion

Updated: 11/30/2021, 7:00:45 PM
Created: 11/30/2021, 7:00:45 PM
Last Updated By: Jake Tuttle
Read Time: 1 minute(s)

# Description

The MS code allows an alternate sort sequence to be defined for sort fields. It takes the general from:

MS
1

Use of the MS code is only relevant when used in a field 8 pre-process code and applied to a field that is specified in a sort clause. In all other cases it will be ignored.

The sort sequence to be used is defined in a special record named SEQ that you must create in the ERRMSG file. Field 1 of this record contains a sequence of ASCII characters that define the order for sorting.

# Example

SEQ (defined in ERRMSG file)
001 aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ9876543210 ,.?!"";:+-*/^=()[]{}<>@#$%&"~\|
1
2

INV.CODE (data definition record)

001 A
.
.
008 MS
1
2
3
4
SORT SALES BY INV.CODE INV.CODE ID-SUPP
1
SALES....
AbC789
ABC789
ABC788
dEF123
1
2
3
4
5

Back to Conversion Processing