UniGroup Van Line Statement Format

 

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

 

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

 

Statement Field

Starting Field Location (Size)

Field Description

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. You can review these items along with other batch information through the Statement Import Detail screen.

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)

Needed to build Order Number for match in MoversSuite

Order Sequence

13 (7)

Order Year

20 (1)

Partial Shipment

21 (1)

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.

 

 

RELATED TOPICS:

Import Menu

Payment Management

Payment Management Setup and Administration

Statement Import Process

Statement Imports

UniGroup Download Setup and Administration