SIRVA North American Van Line Statement Format

 

The following table lists the anticipated fields imported from SIRVA North American.

 

Note

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

 

 

Statement Field

Starting Field Location (Size)

Field Description

Contract

1 (8)

Order Number in MoversSuite

Description

9 (17)

Customer name or line item description

Actual Weight

30 (5)

Weight associated to the item (NOT USED)

Miles

35 (4)

Miles associated to the item (NOT USED)

Tariff/Rate

39 (4)

Tariff or rate of the item (NOT USED)

Commission Percentage

43 (3)

Percentage (as NN.N) for commission

Agency

47 (4)

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

Amount

53 (7)

This amount will be used for the payment or charge if the Commission Amount is zero.

Debit/Credit Indicator

60 (1)

Item is a credit if this field contains a C, 2, 4, 7, 8, or 9 or is a debit if it is D or 3.

Service (Type) Code

62 (2)

Accounting code for the item.  Must match to an Item Code in MoversSuite.

Transaction Code

64 (4)

Process identifier from North American.

Commission Amount

73 (7)

This amount will be referenced for the payment or charge item if this amount is not zero, otherwise the Amount field (above) will be used.

Journal

81 (1)

Journal flag (NOT USED)

 

 

Note

If the Amount placed beginning in position 73 is zero, then a second Amount will pull from position 53.

 

 

RELATED TOPICS:

SIRVA Allied Van Line Statement Format

SIRVA sHub Integration Setup and Administration