IAT processing requires database support for International ACH Transaction batch headers, entry records, and required addenda. A practical first iteration mirrors ACH record layouts and separates unparsed records from parsed records, leaving room for asynchronous file processing later. section 11.3.1
The initial schema uses several deliberate implementation choices:
- Add at least nine tables for parsed IAT records while retaining the existing unparsed-record structure. section 11.3.1
- Start with mostly VARCHAR fields, then consider NUMERIC or DATE constraints for stronger data integrity in later iterations. section 11.3.1
IAT addenda type 12
The ach_iat_addenda_712_records table stores the addenda type code, originator city, state, country, postal code, and entry-detail sequence number. Its name reflects the 712 prefix appearing in these file records. section 11.3.1
