Statement Field

Starting Field Location (Size)

Field Description

Statement Month

1 (2)

The Statement Date is comprised of the Statement Month followed by “/01/” and then the Statement Year. The Statement Date set is the end of period date. The two period dates per month are the 15^th of the month and the last date of the month.

Statement Year

3 (1)

Reference Code

8 (1)

First character of the Contract value is used to determine how the payment will be processed.  If the Reference Code is a number (0 – 9), then the Payment Code will be set to “M” for a cash receipt; if the Reference Code is the letter “V” then the record is considered claim related and will have a Payment Code of “C”, otherwise, if the Reference Code is any letter than “C” the item will be treated as a payment with a Payment Code of “P.”

Contract

8 (6)

Represents the Order Number in MoversSuite. Other needed data is pulled from the retrieved order record.

Description

14 (14)

Text description for the transaction.

Line Type

30 (2)

Line item code.  Used to determine if the item is a balance forward (Line Type of “01”) or not.  Balance forward items are not included in an import.

Agency

41 (5)

Agency representing the record is comprised of 4 characters beginning at position 41 followed by “00” (two zeros) and then a single code from position 45.  A total of seven characters.

Service Code

46 (1)

Service code that displays for the transaction.

Amount

47 (8)

Dollar amount of the transaction item.

Service Code Modifier

55 (1)

The Service Code Modifier, if not blank, is appended to the Service Code (in format of “N-N”).