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. |