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
Addresses, Controls

• 1 - File Header Record

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
RMRIV12345677500\


7 - Entry Detail Addenda
Addendum record for a payment of 500 for Invoice
12345677
7
EDI to ACH - CTX
EDI Data ACH Format

• ST8201234\
• BPRC1703.16CACHCTX0111036183
• ZZ1234567801031100209DA
• 12341234123960912VEN\
• TRN1360012001234\
• REF721234567890\
• N1PEFederal ExpressFI456129876\
• N1PRNASA\
• ENT123456\
• RMRIV12345677500\
• RMRIV12345678AI703.16\
• REFRB8.1253.16 is interest for 20 days\
• RMRIV12345679AI500700200\
• SE121234\
  
  

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 [phone]
• Connie.Borchers_at_fms.treas.gov
• Telecommunication
• Eugene Phillips [phone]
• Eugene.Phillips_at_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
Vendor
RFQs Purchase Orders

• 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 Pa
yment 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 Descr
iption
18
RMT Structure
RMT - Remittance Advice Field X12 Num Ref
Description 01 128 Reference Number
Qualifier 02 127 Reference Number 03 782 Mo
netary 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 Adjust
ment 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.