IAT - International Transactions
Contents
IAT - International Transactions
You can import data files to create IAT transactions - just like any other type of transaction.
Requirements
Knowledge of IAT
The IAT format is a fairly complex format compared to our other formats, such as CCD and PPD.
For example, instead of four required fields for CCD and PPD (Name, Amount, ABA and Account number), there are over forty different fields required by IAT!
If you are not familiar with the complexities of IAT, we recommend that you use our Add a Record interface which can walk you through the process.
Unfortunately, Treasury Software is not structured to provide training in IAT, only in the use of our software.
Map all fields!
All fields noted below are required to be mapped - even if they are empty (blank), or of $0.00 amount.
Failure to import all of the fields may result in a lack of ACH Universal to create a proper transaction, while others may allow the transaction to be created - but ultimately they may be rejected by the NACHA network.
Tip: Use the mapping template International - IAT
We have pre-mapped the fields to match the template supplied with the Excel file 'International - IAT.xls'.
Of course, you can certainly map your own template.
Mapping Fields
Below are screen shots of the fields as shown in the Sample account, along with Sample data.
We recommend using the file below as a template (included with ACH Universal):
C:\Users\Public\Treasury Software\Tutorial\ACHData\International - IAT.xls
Note: The data samples below indicate the range of data that can be imported.
Field references
Field Name |
Sample Data |
Description of data |
|
Date |
9/18/2009 |
|
Date format |
Name |
Joe Worker |
|
Alphanumeric |
Amount |
($1,983.34) |
|
Numeric/currency. Use standard sign protocols (positive DR; negative CR) |
Receiver_ID_Number |
Emp#8763 |
|
Alphanumeric |
Originator_Name |
Hershey USA |
|
Alphanumeric |
Originator_Street |
4567 Kiss St. |
|
Alphanumeric |
Originator_City |
Hershey |
|
Alphanumeric |
Originator_State |
PA |
|
Alphanumeric |
Foreign_Exchange_Indicator |
FF |
|
Acceptable 2 position values: 'FF' (Fixed-Fixed); 'FV' (Fixed-Faviable); or 'VF' (Variable-Fixed) |
Originator_Status_Govt_Bank_TF |
FALSE |
|
Acceptable values: 'True' (Gov't entity) or 'False' (Bank or anyone else) |
Foreign_Exchange_Rate |
|
Alphanumeric. Note: This is a nickname for ease of use, as the actual field is named Foreign Exchange Reference. |
|
Foreign_Amount |
$0.00 |
|
Numeric/currency |
Originating_Currency |
USD |
|
Alphanumeric - must be valid abbreviation |
Foreign_Exchange_Reference_Indicator |
3 |
|
Acceptable values (one digit): '1' (Foreign Exchange Rate); '2' (Foreign Exchange Reference Number); or '3' (Space). Describes content of Foreign_Exchange_Rate field. Tip: If Foreign Exchange Indicator is FF, then this entry should be '3' (space filled). |
Outbound_Inbound_TF |
0 |
|
Acceptable values (one-digit): '0' (zero - Outbound - originates in US); '1' (inbound - originates from international). Note: Do not confuse the origination with the cash DR/CR flow. |
Receiver_Currency |
USD |
|
Alphanumeric - must be valid abbreviation |
RDFI_ABA |
81519361 |
|
Numeric |
RDFI_Account |
88776699 |
|
Numeric |
Company_Entry_Description |
Payroll |
|
Alphanumeric |
SEC_Code |
IAT |
|
Alphanumeric - must be valid abbreviation |
Originator_Country |
US |
|
Alphanumeric |
Originator_Zip |
17033 |
|
Alphanumeric |
Originator_ID_Number |
227777777 |
|
Numeric |
OFAC_Screening_Gateway |
|
|
All users - leave blank unless specifically instructed. (For Gateway operators '0' indicates a blocked party has not been found. '1' Indicates a blocked party) |
OFAC_Screening_Secondary |
|
|
All users - leave blank unless specifically instructed. (For Gateway operators '0' indicates a blocked party has not been found. '1' Indicates a blocked party) |
Foreign_Trace |
Batch#2393 |
|
Alphanumeric |
Transaction_Type_Code |
SAL |
|
Alphanumeric |
Remittance |
|
Alphanumeric. Free form text that is inserted into the '17' records, a.k.a Remittance Information. |
|
Receiver_Street |
7654 Oak Dr |
|
Alphanumeric |
Receiver_City |
Jericho |
|
Alphanumeric |
Receiver_State |
NY |
|
Alphanumeric |
Receiver_Country |
US |
|
Alphanumeric |
Receiver_Zip |
11753 |
|
Alphanumeric |
ODFI_Name |
Bank of Hershey |
|
Alphanumeric |
ODFI_US_Foreign_TF |
02 |
|
Acceptable values (two-digit): '01' US; '02' Foreign |
ODFI_ABA |
063000047 |
|
Alphanumeric |
ODFI_Branch_Country_Code |
US |
|
Alphanumeric - must be valid abbreviation |
RDFI_Name |
Bank of Jericho |
|
Alphanumeric |
RDFI_US_Foreign_TF |
01 |
|
Acceptable values (two-digit): '01' US; '02' Foreign |
RDFI_Branch_Country_Code |
US |
|
Alphanumeric - must be valid abbreviation |
Gateway_Operator |
223092390 |
|
Numeric |