# Presentation: 677289

## 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

- 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

## The NACHA Record Structure (sent from FMS to FRB)All Fixed-Length 94 Character Records Same Structure Used For All Corporate Payment Formats

- 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

- 5 - Company/Batch Header

- 5 - Company/Batch Header

- 6 - Entry Detail Record

- 6 - Entry Detail Record

- 6 - Entry Detail Record

- 6 - Entry Detail Record

- 7 - Entry Detail Addenda

- 8 - Company/Batch Control

- 8 - Company/Batch Control

- 9 - File Control Record

- Addresses, Controls

- First Batch - Payer, Transaction Type, Settlement Date

- Payee, Account Number, Amount

- Optional - _**None for CCD, One for CCD +, Many for        **_**	****	**_**CTX**_

- Next Payee, Account Number, Amount

- Another Payee, Account Number, Amount

- Counts, Total Amounts for First Batch

- Start Second Batch

- Payee, Account Number, Amount

- Counts, Total Amounts for Second Batch

- Counts, Total Amounts for Entire File

## Important CTX Format Information

- FMS Website for CTX file formats
-   _[http://fms.treas.gov/ctx/formats.html](http://fms.treas.gov/ctx/formats.html)_
- CTX Addendum records information is obtained from the following segments
- RMR
- REF
- RMT

## EDI to ACH - CCD+

**EDI to ACH - CCD+**

- RMR*IV*12345677**500\

- EDI Data									ACH Format

- 7 - Entry Detail Addenda

- Addendum record for a payment of $500 for Invoice #12345677

## EDI to ACH - CTX

**EDI to ACH - CTX**

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

- EDI Data									ACH Format

- 7 -  Entry Detail Addenda

## 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

## 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

## 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

## 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

## Reference Material

## CTX / EDI Terminology

**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

## EDI Business Cycle

**EDI Business Cycle**

- Agency
- Procurement
- Office

- Agency
- Finance
- Office

**Payment File**
- (820/Flat File)

- Servicing  Financial Center

- FMSnet

**Payment and**
**Remittance Information**
- CTX or CCD+

- ACH Network

-      Federal Reserve Bank

- Vendor's Financial Institution

**Remittance**
**Information**

- Vendor

- Quotes
- Invoices

- VAN

- RFQs
- Purchase Orders

**Payment and**
**Remittance **
**Information**
- CTX
- or CCD+

## 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

## 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

## REF Structure

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

## 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.