1 / 18

CTX / EDI Vendor Payments

CTX / EDI Vendor Payments. Denise Quirarte Kansas City Financial Center Customer Advisory Board Las Vegas, Nevada December 12, 2006. TOPICS. Benefits of CTX File format information CTX Payment Offset – beginning November, 2007. Advantages of using Vector Connexion (CTX) Application.

Anita
Download Presentation

CTX / EDI Vendor Payments

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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.

More Related