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:
Payment Management Setup and Administration
UniGroup Download Setup and Administration