SIRVA Allied Van Line Statement Format

 

The following table lists the anticipated fields imported from SIRVA Allied. This format is referenced for the SIRVA Statement option from within the Import Menu.

 

See SIRVA STS Integration Setup and Administration for information on enabling this functionality.

 

NOTE: The Van Line Code for import SIRVA transactions is an “A” (for Allied).

 

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.

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”).

 

 

RELATED TOPICS:

Import Menu

Payment Management

Payment Management Setup and Administration

SIRVA STS Integration Setup and Administration

SIRVA North American Van Line Statement Format

Statement Import Process

Statement Imports