Page tree
Skip to end of metadata
Go to start of metadata

Export Overview

This is a sample export template to pull remittance information to Amex.  

Note: The output needs to be a text file.

Standard Template

Unanet Export template: Unanet Export to Amex - Remittance File.csv

This document from American Express describes how the remittance process works, including the required file format: Amex Remittance File Specifications - from Amex.doc

Header Record
#
Name
Value
Align
Size
Format
Null Value
Description
1Record Type
"00"
Right2  

The constant number 00 stands for Transmittal Header.

This is a required field and the value provided is standard.

2Load Number
"0000065614"
Right10  

Unique 10 digit number assigned by American Express at the time of setup.

This is a required field and the value provided is standard.

3Creation Date
SELECTION_END_DATE
Left8DATE(yyyyMMdd) 

This is a required field.

 The date file was created by company, including 4 position year.(yyyymmdd).

4CID
"707253"
Right6  

This is a required field.

This constant number is an unique six-digit number assigned by American Express.

5Book Number"6614"Right4  This constant number is a four position identifier assigned by American Express at the time of setup.
6Processing Indicator
"00"
Right2  This is a required field.
7Test File Indicator
"TT"
Left2  

This is a required field.

Allowed options are:

  • TT - Test File
  • Blanks - Production File 
8File Sequence Number
"01"
Right2  

This is a required field.

This is the numeric sequence of files sent by COMPANY.  E.G. first file will contain 01, second file 02, 99th file 99, 100th file rolls back to 01

This number is used by American Express to check for skipped or duplicated files. (Manual number change)

9Filler Left184  

This is a required field.

This field is reserving 184 bytes for the record.

Detail Record
1Record Type
IF (LINE_ITEM_PAYMENT_METHOD IN 
"Corp. Card|Company Paid") {
"10"
} ELSE {
!IGNORERECORD!
}
Left2  

The constant number 10 stands for Remittance Detail.

This is a required field and the value provided is standard.

2Remittance Amount
SUM(IF (LINE_ITEM_PAYMENT_METHOD 
IN "Corp. Card|Company Paid") {
MATH(LINE_ITEM_ALLOC_AMT * 100)
})
Left13

NUMBER(-000000000000;

+000000000000)

 

This is a required field.

This logic is the dollar amount for the card member, which is approved on the expense voucher.

Any value 0 or greater would have a plus; any value less than zero would have a minus.
- Credit - reduces balance on Card member account (i.e. a remittance to AMEX)
+ Debit - increases balance on Card member account (i.e. reversal of previously paid expense)

3Corporate Card Number
PERSON_USER05
Right15  

This is a required field.

The file must contain a valid Corporate Card Number, which is 15 digits without spaces.

4Filler Left69  

This is a required field.

This field is reserving 69 bytes for the record.

5Remittance Msg Code"01"Right2  

This is a required field.

This message will appear on the Card member statement along with the payment credited to the account.  This literal is driven by a required two-digit number which is located on the Remittance Detail Record in the file layout.

Allowed options are:

  • 01 - Corporate Remittance Received
  • 02 - Corporate Deduction of credit balance
  • 03 - Proceedds of Expense Voucher
  • 05 - Debit Remit for airline credit
  • 07 - Adjustment
6Descriptive Msg Code for Line 2 Left2  

This is field is not required.

The code which drives the descriptive bill message on the billing statement.  These messages will appear on the statement in the same sequence as they are on the file.

Allowed options are:

  • 01 - Expense Report #
  • 02 - Expense Voucher #
  • 03 - Airline Ticket #
  • 04 - Trip Date
  • 05 - Job #
  • 06 - Client #
  • 07 - Period Ending
  • 08 - Week Ending
  • 09 - Week #
  • 10 - Travel Authorization #
  • 11 - Agency Name
  • 12 - Third Party Processor
  • 13 - Expense Report #s
  • 14 - Expense Voucher #s
  • 15 - Airline Ticket #s
  • 16 - Trip Dates
  • 17 - Job #s

Note: There are singular and plural version of the descriptive billing messages.

7Company Data For Line 2 Left16  This is field is not required.
8Descriptive Msg Code For Line 3 Left2  This is field is not required.
9Company Data For Line 3 Left16  This is field is not required.
10Descriptive Msg Code For Line 4 Left2  This is field is not required.
11Company Data For Line 4 Left16  This is field is not required.
12Filler Left65  

This is a required field.

This field is reserving 65 bytes for the record.

File Trailer Record
1Record Type"99"Right2  

The constant number 99 stands for Summary Trailer.

This is a required field and the value provided is standard.

2Filler Left1  

This is a required field.

This field is reserving 1 byte for the record.

3Corporate Card Remittance Total Dollars
SUM (IF (LINE_ITEM_PAYMENT_METHOD 
IN "Corp. Card|Company Paid") {
MATH(LINE_ITEM_ALLOC_AMT * 100)
})
Left12NUMBER(000000000000) 

This is a required field.

The value must be Credit amount (sum of all corporate card transactions).

4Corporate Card Remittance Total Records
FIELDSUM (DETAIL, 5)
Right6NUMBER(000000) 

This is a required field.

The value must be value greater than zero. (number of credit card transactions in the file).

5Filler Left1  

This is a required field.

This field is reserving 1 byte for the record.

6Zero filled
"000000000000000000"
Right18  This is a required field.
7Filler Left180  

This is a required field.

This field is reserving 180 bytes for the record.

Note:  There should be one ‘Transmittal Header’ record and one ‘Summary Trailer’ Record per file.

 

Template logic options

Value
Size
Format
Null Value
Description

 

Additional Information

KC - Credit Card Integrations, Imports, and the IMU

 

  • No labels