Atlas Settlement Statement Import

 

Users can import settlement statements directly into Payment Management.  The option to select and process an “Atlas Statement” will be available through the Import function.

 

Note: Users must be assigned to the “Atlas Statement Integration” security module (see Atlas Integration Setup and Administration).

 

The following table lists the fields imported into MoversSuite through the Atlas Statement import.  Note: only the fields interpreted by MoversSuite are represented here.

 

Field

Type (Size)

Field Description

Agent Settlement Header

 

 

Vendor ID

String (15)

The agent identification number (correlates to the Agent ID field in Agent Setup).

Settlement ID

String (15)

This is a value combining the settlement type (Driver, 3rd Party, etc.) and the Vendor ID (in the format of the Vendor ID followed by a dash and then the Settlement ID, e.g. “01234 – Driver”.

Settlement Date

DateTime

This is the date of settlement (journal/wire date) for the batch (in MM/DD/CCYY format).

System Date Type

String (100)

The type set for the batch, such as “Bank Deposit.”

Net Settlement

Decimal

The net settlement amount (in cents).

Document Header

 

 

Order Number

String (15)

This is Order Number or Control Number of the shipment.

Document Number

String (21)

The document number for the shipment. 

Document Type

Integer

The transaction payment type that will map to Payee Code values define in Carrier Setup (Military/Government).

Document Amount

Decimal

The dollar amount of the transaction.

Shipper

String (100)

The description of the transaction item.

Document Description

String (500)

The description for the document (typically the Order Number).

The application will reference the Order Number value.  If that is not available, then the Document Number value will be referenced.

AP Distribution Record

 

 

This section contains the distribution information when the document is a payment on the order.

AP Detail Distribution Code

String (6)

The distribution code supported on the Atlas mainframe.

AP Detail AP Amount

Decimal

The rating engine pay type dollar amount.