CTX / EDI Vendor Payments

1. CTX / EDIVendor Payments Denise Quirarte Kansas City Financial Center Customer Advisory Board Las Vegas, Nevada December 12, 2006

2. TOPICS • Benefits of CTX • File format information • CTX Payment Offset – beginning November, 2007

3. Advantages of using Vector Connexion (CTX) Application • The ability to include up to 9,999 addendum records for each payment • Ability to make one vendor payment for multiple invoices • Vendor Bank statement will reflect invoice information • Invoice Number • Invoice Dollar Amount • The agency has two basic formats they can use for the payment file. • 820 format – X12 format for customers with EDI capability • Flat file format - for non-EDI capable agencies

4. The NACHA Record Structure (sent from FMS to FRB)All Fixed-Length 94 Character Records Same Structure Used For All Corporate Payment Formats 1 - File Header Record Addresses, Controls 5 - Company/Batch Header First Batch - Payer, Transaction Type, Settlement Date 6 - Entry Detail Record Payee, Account Number, Amount Optional - None for CCD, One for CCD +, Many for CTX 7 - Entry Detail Addenda 6 - Entry Detail Record Next Payee, Account Number, Amount 6 - Entry Detail Record Another Payee, Account Number, Amount 8 - Company/Batch Control Counts, Total Amounts for First Batch 5 - Company/Batch Header Start Second Batch 6 - Entry Detail Record Payee, Account Number, Amount 8 - Company/Batch Control Counts, Total Amounts for Second Batch 9 - File Control Record Counts, Total Amounts for Entire File

5. Important CTX Format Information • FMS Website for CTX file formats • http://fms.treas.gov/ctx/formats.html • CTX Addendum records information is obtained from the following segments • RMR • REF • RMT

6. EDI to ACH - CCD+ EDI Data ACH Format RMR*IV*12345677**500\ 7 - Entry Detail Addenda Addendum record for a payment of $500 for Invoice #12345677

7. 6 - Entry Detail Record 7 - Entry Detail Addenda 7 - Entry Detail Addenda EDI to ACH - CTX EDI Data ACH Format ST*820*1234\ BPR*C*1703.16*C*ACH*CTX*0111036183* ZZ*12345678***01*031100209*DA* 12341234123*960912*VEN\ TRN*1*360012001234\ REF*72*1234567890\ N1*PE*Federal Express*FI*456129876\ N1*PR*NASA\ ENT*123456\ RMR*IV*12345677**500\ RMR*IV*12345678*AI*703.16\ REF*RB*8.125%*$3.16 is interest for 20 days\ RMR*IV*12345679*AI*500*700*200\ SE*12*1234\ 7 - Entry Detail Addenda

8. CTX Offset • CTX Offset payments will be offset beginning November, 2007 • Reference • TFM # 2006-XX – CTX Payment Offset through TOP • TFM # 2005-07 - Instructions for submitting Vendor Payment Requests, Section 3d • TFM # 4-2000 – Payment Issue Disbursing Procedures

9. Critical Fields for Offset CTX Payment records • ASC X12 820 Payment Format • BPR 17 must contain: • VEN to indicate vendor payment • PCS to indicate child support payment • BPR 17 is skipped for miscellaneous payments • BPR 18 must contain the value ZZ • BPR 19 contains the TOP eligibility code • YES indicates the payment is eligible for offset • NOT indicates the payment is not eligible for offset. If the full payment amount is not legally eligible to be 100 % offset, place NOT in this field • Flat File Payment Format • Field 4 is used to indicate the type of payment • V – vendor payment • M – miscellaneous payment • Field 12 is used to indicate offset eligibility • Y – eligible for offset • N – not eligible for offset

10. Reference Information • CTX Offset • Agency Notification Letter – 11/02/2006 • FMS Draft TFM • Revised Formats for Offset • CTX / EDI Terminology • EDI Business Cycle • RMR Structure • RMR Data Elements • REF Structure • RMT Structure

11. Kansas City Financial Center CTX Points of Contact • Testing • Connie Borchers (816)414-2336 • Connie.Borchers@fms.treas.gov • Telecommunication • Eugene Phillips (816)414-2328 • Eugene.Phillips@fms.treas.gov

12. Reference Material

13. CTX / EDI Terminology • CTX: Corporate Trade Exchange is a corporate ACH format, which allows for up to 9,999 addenda records with approximately 800,000 characters • EDI: Electronic Data Interchange - computer to computer electronic transmission of routine business information in a standard format • ANSI: American National Standards Institute • ASC: Accredited Standards Committee • ASC X12: Committee for Financial EDI • ASC X12 820: Transaction set for Payment Order/Remittance Advice

14. EDI Business Cycle RFQs Purchase Orders Vendor Agency Procurement Office VAN Quotes Invoices Agency Finance Office Remittance Information Payment File (820/Flat File) Federal Reserve Bank Servicing Financial Center Vendor's Financial Institution FMSnet ACH Network Payment and Remittance Information CTX or CCD+ Payment and Remittance Information CTX or CCD+

15. RMR Structure RMR - Remittance Advice Accounts Receivable Open Item Reference Field X 12 Num Ref Description 01 128 Reference Number Qualifier 02 127 Reference Number 03 482 Payment Action Code 04 782 Monetary Amount 05 777 Total Invoice or Credit/Debit 06 780 Amount of Discount Taken

16. RMR Important Data Elements 128 - Reference Number Qualifier CT - Contract Number IV- Invoice Number PO - Purchase Order Number RB - Rate Code (interest rate) 482 - Payment Action Code AI - Amount Paid Inclusive of Discounts and Adjustments PP - Partial Payment PI - Pay Item

17. REF Structure REF - Reference Numbers Field X12 Num Ref Description 01 128 Reference Number Qualifier 02 127 Reference Number 03 127 Description

18. RMT Structure RMT - Remittance Advice Field X12 Num Ref Description 01 128 Reference Number Qualifier 02 127 Reference Number 03 782 Monetary Amount 04 777 Total Invoice or Credit/Debit 05 778 Amount Subject to Terms Disc. 06 779 Discounted Amount Due 07 780 Amount of Discount Taken 08 782 Monetary Amount* 09 426 Adjustment Reason Code AN 1/80 * This monetary amount is any amount deducted from or added to an invoice for any reason other than a discount.