Notes

See UniGroup Download Setup and Administration for information on enabling statement functionality for UniGroup.

For each order, a single payment is created for all line items with matching Payment Codes that maps to the Payment Code of “Receivables;” all negative and positive items are combined into one single entry; the Statement Import Detail screen lists each individual item comprising the payment amount.

Statement Field

Starting Field Location (Size)

Field Description

Van Line Code

1 (1)

Van line company code of the agent

Agent Number

2 (5)

Agency of the payment or charge used to identify the correct branch

Order Company Code

7 (1)

Van line code of the order

Booking Agent Number

8 (5)

Used to build Order Number for match in MoversSuite

Order Sequence

13 (7)

Used to build Order Number for match in MoversSuite

Order Year

20 (1)

Used to build Order Number for match in MoversSuite

Partial Shipment

21 (1)

Used to build Order Number for match in MoversSuite

Bill Supplement

22 (3)

Billing supplement code

Transaction Date

25 (8)

Transaction date for the item (as MMDDYY)

Group Number

33 (3)

Group that this item belongs to in UniGroup

Group Sequence Number

36 (5)

Sequence number of the group that this item belongs to in UniGroup

Shipper Name

41 (20)

Name associated to the order associated to this item

Description

61 (35)

Particular description assigned to this item

Amount

96 (16)

Transaction amount for this item (formatted with two decimal places)

Negative Amount Indicator

112 (1)

A blank for this field indicates a positive transaction amount while a hyphen (-) indicates a negative amount

Driver Company Code

113 (1)

Van line that the driver is associated with

Driver Number

114 (6)

Driver’s identification number

Employee Company Code

120 (1)

Van line that the driver’s company represents

Employee Agent

121 (5)

Agency of the driver.

Service Code/Distribution Code

126 (3)

Service Code to be applied to the payment or charge.

Payment Code

129 (4)

Payment Code to be applied to the payment or charge.

Claim Number

133 (6)

Claim number associated to the payment or charge.

Batch Identifier

139 (9)

Van line batch identifier.

Note

MoversSuite Order Number is comprised of the Booking Agent Number, Order Sequence, Order year, and Partial Shipment fields.  See Order Number Setup for more information.