EDI - Copy only specific transaction to a folder

Hi!

Here is a simple tutorial how to copy only a specific functional group type of EDI transaction.

In my example I need to copy all the 997 ( Functional Acknowledgment) to a specific folder.

My folder hierachy is /myhome/source/folder/CLIENT / (job / folder-in / folder-out) / YEAR / MONTH / DAY / myfile

where myfile is a single ISA per file and could be gzipped.

1 - Extract all gzipped EDI files under folder-in and folder-outfind /myhome/source/folder -type f -iwholename *folder* -iwholename *.gz  -exec zgrep -l '^ISA' {} \; -exec gunzip {} \;

2 - Copy all the 997 to /home/MY_FOLDER (Where FA is the GS Transaction code of the 997)find /myhome/source/folder -type f -iwholename *folder* -exec pcregrep -Ml '^ISA.*GS.FA'  {} \; -exec cp -rf {} /home/MY_FOLDER/ \;

EDI -=- Sample query to select and move transactions

Hi

If you have a bunch of EDI files, you may want to extract only specific transactions and move them to a folder. Here's a sample query. It moves all the PO (850) and the invoices (810) to the folder "MYFOLDER" in my home directory. The dot (.) in the grep represents any characters so this query will works will all delimiters.

find . -type f -exec grep -Rl 'ST.8[15]0' {} \; -exec cp -rf {} ~/MYFOLDER/ \;

EDI & EDIFACT Document Mapping

Hi!

Here's a mapping between commons EDI & EDIFACT transactions.

TRANSACTION SET/DOCUMENT	ANSI SET	EDIFACT
PRODUCT/PRICING TRANSACTIONS
Price Sales Catalog	832	PRICAT
Price Authorization Acknowledgement/Status	845	ATHSTS
Specification/Technical Information	841	PRDSPE
Request For Quotation	840	REQOTE
Response To Request For Quotation	843	QUOTES
Electronic Bid Form	833	--
ORDERING TRANSACTIONS
Purchase Order	850	ORDERS
Purchase Order Acknowledgement	855	ORDRSP
Purchase Order Change	860	ORDCHG
Purchase Order Change Acknowledgement	865	ORDRSP
Order Status Inquiry	869	ORSSTA
Order Status Report	870	ORDREP
Contract Award	836	--
MATERIALS MANAGEMENT TRANSACTIONS
Planning Schedule/Material Release	830	DELFOR
Shipping Schedule	862	DELJIT
Production Sequence	866	--
Ship Notice/manifest (ASN)	856	DESADV
Report of Test Results	863	QALITY
Material Safety Data Sheet	848	--
Contract Award	836	--
SHIPPING/RECEIVING TRANSACTIONS
Shipment Information (Bill of Lading)	858	IFTMCS
Receiving Advice	861	RECADV
Non-conformance Information-Disposition Transaction, Cause/Correction	842	NONCON
INVENTORY MANAGEMENT TRANSACTIONS
Inventory Inquiry/Advice	846	INVRPT
Product Transfer and Resale Report	867	SLSRPT
Product Transfer Account Adjustment	844	--
Response To Product Transfer Account Adjustment	849	--
FINANCIAL TRANSACTIONS
Invoice	810	INVOIC
Freight Invoice	859	IFTMCS
Payment order/Remittance Advice (EFT)	820	REMADV
Lockbox	823	--
Financial Information Reporting	821	--
CONTROL TRANSACTIONS
Functional Acknowledgement	997	CONTRL
Application Advice	824	BANSTA
Trading Partner Profile	838	PARTIN

EDI -=- List of Valid Interchange Qualifiers in EDI

Hi!

The interchange qualifier is used to describe the interchange identifier. For example, if we have a qualifier 12, it says that the interchange identifier is a phone number. Here's the list of all the valid identifiers in EDI (X12 - V004010)

• 01 - Duns (Dun & Bradstreet)
• 02 - SCAC (Standard Carrier Alpha Code)
• 03 - FMC (Federal Maritime Commission)
• 04 - IATA (International Air Transport Association)
• 08 - UCC EDI Communications ID (Comm ID)
• 09 - X.121 (CCITT)
• 10 - Department of Defense (DoD) Activity Address Code
• 11 - DEA (Drug Enforcement Administration)
• 12 - Phone (Telephone Companies)
• 13 - UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
• 14 - Duns Plus Suffix
• 15 - Petroleum Accountants Society of Canada Company Code
• 16 - Duns Number With 4-Character Suffix
• 17 - American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
• 18 - Association of American Railroads (AAR) Standard Distribution Code
• 19 - EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
• 20 - Health Industry Number (HIN)
• 21 - Integrated Postsecondary Education Data System, or (IPEDS)
• 22 - Federal Interagency Commission on Education, or FICE
• 23 - National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
• 24 - The College Board's Admission Testing Program 4- Digit Code of Postsecondary Institutes, or ATP
• 25 - American College Testing Program 4-Digit Code of Postsecondary Institutions, or ACT
• 26 - Statistics of Canada List of Postsecondary Institutions
• 27 - Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 28 - Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
• 29 - Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 30 - U.S. Federal Tax Identification Number 31 Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
• 32 - U.S. Federal Employer Identification Number (FEIN) 33 National Association of Insurance Commissioners Company Code (NAIC)
• 34 - Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
• 35 - Statistics Canada Canadian College Student Information System Institution Codes
• 36 - Statistics Canada University Student Information System Institution Codes
• 37 - Society of Property Information Compilers and Analysts
• AM - Association Mexicana del Codigo de Producto (AMECOP) Communication ID
• NR - National Retail Merchants Association (NRMA) - Assigned
• SN - Standard Address Number
• ZZ - Mutually Defined

Really Good B2B Integration Tool

Last week, I visited the EXTOL's company to have more details about the EXTOL Business Integrator software. EXTOL Business Integrator (EBI) is platform-independent business integration middleware, with seamless support for “lights-out” business-to-business (B2B), Software as a Service (SaaS), internal application-to-application (A2A) and data integration.

It is designed to replace – and bridge the gaps between – conventional EDI translators, data integration tools, business process automation tools, web services toolkits, XML transformation toolkits and spreadsheet integrators. EBI spans this broad range of capabilities by providing a flexible set of integration services that can be combined and configured to suit a variety of business purposes, all without programming.

With EBI, you can handle B2B, A2A, SaaS and data integration problems individually or in any combination required by your business. EBI can implement simple, point-to-point solutions that automate parts of larger business processes, or to implement longer, more complex business processes that connect applications, trading partners, services and business data resources.


EBI includes a powerful and highly flexible set of business integration services, including process automation, data transformation, messaging and communications, event management, scheduling, and adapter-based connections to internal and external sources and targets, as well process monitoring, auditing, and governance tools. The solution seamlessly integrates with your existing applications and business processes through business events, schedules, application actions or explicit process invocations.

For conclusion, EBI is a really great product. It is insanely easy to use and it has a lot of features!

+1 for the guys of EXTOL!

EDI -=- List of EDI transactions

Hi!

Here is the list of the EDI transactions based on the ASC X12 standards for EDI.

• 105 Business Entity Filings
• 106 Motor Carrier Rate Proposal
• 107 Request for Motor Carrier Rate Proposal
• 108 Response to a Motor Carrier Rate Proposal
• 109 Vessel Content Details
• 110 Air Freight Details and Invoice
• 111 Individual Insurance Policy and Client Information
• 112 Property Damage Report
• 113 Election Campaign and Lobbyist Reporting
• 114 Air Shipment Status Message
• 120 Vehicle Shipping Order
• 121 Vehicle Service
• 124 Vehicle Damage
• 125 Multilevel Railcar Load Details
• 126 Vehicle Application Advice
• 127 Vehicle Baying Order
• 128 Dealer Information
• 129 Vehicle Carrier Rate Update
• 130 Student Educational Record (Transcript)
• 131 Student Educational Record (Transcript) Acknowledgment
• 132 Human Resource Information
• 133 Educational Institution Record
• 135 Student Aid Origination Record
• 138 Educational Testing and Prospect Request and Report
• 139 Student Loan Guarantee Result
• 140 Product Registration
• 141 Product Service Claim Response
• 142 Product Service Claim
• 143 Product Service Notification
• 144 Student Loan Transfer and Status Verification
• 146 Request for Student Educational Record (Transcript)
• 147 Response to Request for Student Educational Record (Transcript)
• 148 Report of Injury, Illness or Incident
• 149 Notice of Tax Adjustment or Assessment
• 150 Tax Rate Notification
• 151 Electronic Filing of Tax Return Data Acknowledgment
• 152 Statistical Government Information
• 153 Unemployment Insurance Tax Claim or Charge Information
• 154 Secured Interest Filing
• 155 Business Credit Report
• 157 Notice of Power of Attorney
• 158 Tax Jurisdiction Sourcing
• 159 Motion Picture Booking Confirmation
• 160 Transportation Automatic Equipment Identification
• 161 Train Sheet
• 163 Transportation Appointment Schedule Information
• 170 Revenue Receipts Statement
• 175 Court and Law Enforcement Notice
• 176 Court Submission
• 179 Environmental Compliance Reporting
• 180 Return Merchandise Authorization and Notification
• 185 Royalty Regulatory Report
• 186 Insurance Underwriting Requirements Reporting
• 187 Premium Audit Request and Return
• 188 Educational Course Inventory
• 189 Application for Admission to Educational Institutions
• 190 Student Enrollment Verification
• 191 Student Loan Pre-Claims and Claims
• 194 Grant or Assistance Application
• 195 Federal Communications Commission (FCC) License Application
• 196 Contractor Cost Data Reporting
• 197 Real Estate Title Evidence
• 198 Loan Verification Information
• 199 Real Estate Settlement Information
• 200 Mortgage Credit Report
• 201 Residential Loan Application
• 202 Secondary Mortgage Market Loan Delivery
• 203 Secondary Mortgage Market Investor Report
• 204 Motor Carrier Load Tender
• 205 Mortgage Note
• 206 Real Estate Inspection
• 210 Motor Carrier Freight Details and Invoice
• 211 Motor Carrier Bill of Lading
• 212 Motor Carrier Delivery Trailer Manifest
• 213 Motor Carrier Shipment Status Inquiry
• 214 Transportation Carrier Shipment Status Message
• 215 Motor Carrier Pickup Manifest
• 216 Motor Carrier Shipment Pickup Notification
• 217 Motor Carrier Loading and Route Guide
• 218 Motor Carrier Tariff Information
• 219 Logistics Service Request
• 220 Logistics Service Response
• 222 Cartage Work Assignment
• 223 Consolidators Freight Bill and Invoice
• 224 Motor Carrier Summary Freight Bill Manifest
• 225 Response to a Cartage Work Assignment
• 227 Trailer Usage Report
• 240 Motor Carrier Package Status
• 242 Data Status Tracking
• 244 Product Source Information
• 245 Real Estate Tax Service Response
• 248 Account Assignment/Inquiry and Service/Status
• 249 Animal Toxicological Data
• 250 Purchase Order Shipment Management Document
• 251 Pricing Support
• 252 Insurance Producer Administration
• 255 Underwriting Information Services
• 256 Periodic Compensation
• 259 Residential Mortgage Insurance Explanation of Benefits
• 260 Application for Mortgage Insurance Benefits
• 261 Real Estate Information Request
• 262 Real Estate Information Report
• 263 Residential Mortgage Insurance Application Response
• 264 Mortgage Loan Default Status
• 265 Real Estate Title Insurance Services Order
• 266 Mortgage or Property Record Change Notification
• 267 Individual Life, Annuity and Disability Application
• 268 Annuity Activity
• 269 Health Care Benefit Coordination Verification
• 270 Eligibility, Coverage or Benefit Inquiry
• 271 Eligibility, Coverage or Benefit Information
• 272 Property and Casualty Loss Notification
• 273 Insurance/Annuity Application Status
• 274 Healthcare Provider Information
• 275 Patient Information
• 276 Health Care Claim Status Request
• 277 Health Care Information Status Notification
• 278 Health Care Services Review Information
• 280 Voter Registration Information
• 283 Tax or Fee Exemption Certification
• 284 Commercial Vehicle Safety Reports
• 285 Commercial Vehicle Safety and Credentials Information Exchange
• 286 Commercial Vehicle Credentials
• 288 Wage Determination
• 290 Cooperative Advertising Agreements
• 300 Reservation (Booking Request) (Ocean)
• 301 Confirmation (Ocean)
• 303 Booking Cancellation (Ocean)
• 304 Shipping Instructions
• 309 Customs Manifest
• 310 Freight Receipt and Invoice (Ocean)
• 311 Canada Customs Information
• 312 Arrival Notice (Ocean)
• 313 Shipment Status Inquiry (Ocean)
• 315 Status Details (Ocean)
• 317 Delivery/Pickup Order
• 319 Terminal Information
• 322 Terminal Operations and Intermodal Ramp Activity
• 323 Vessel Schedule and Itinerary (Ocean)
• 324 Vessel Stow Plan (Ocean)
• 325 Consolidation of Goods In Container
• 326 Consignment Summary List
• 350 Customs Status Information
• 352 U.S. Customs Carrier General Order Status
• 353 Customs Events Advisory Details
• 354 U.S. Customs Automated Manifest Archive Status
• 355 U.S. Customs Acceptance/Rejection
• 356 U.S. Customs Permit to Transfer Request
• 357 U.S. Customs In-Bond Information
• 358 Customs Consist Information
• 361 Carrier Interchange Agreement (Ocean)
• 362 Cargo Insurance Advice of Shipment
• 404 Rail Carrier Shipment Information
• 410 Rail Carrier Freight Details and Invoice
• 412 Trailer or Container Repair Billing
• 414 Rail Carhire Settlements
• 417 Rail Carrier Waybill Interchange
• 418 Rail Advance Interchange Consist
• 419 Advance Car Disposition
• 420 Car Handling Information
• 421 Estimated Time of Arrival and Car Scheduling
• 422 Equipment Order
• 423 Rail Industrial Switch List
• 424 Rail Carrier Services Settlement
• 425 Rail Waybill Request
• 426 Rail Revenue Waybill
• 429 Railroad Retirement Activity
• 431 Railroad Station Master File
• 432 Rail Deprescription
• 433 Railroad Reciprocal Switch File
• 434 Railroad Mark Register Update Activity
• 435 Standard Transportation Commodity Code Master
• 436 Locomotive Information
• 437 Railroad Junctions and Interchanges Activity
• 440 Shipment Weights
• 451 Railroad Event Report
• 452 Railroad Problem Log Inquiry or Advice
• 453 Railroad Service Commitment Advice
• 455 Railroad Parameter Trace Registration
• 456 Railroad Equipment Inquiry or Advice
• 460 Railroad Price Distribution Request or Response
• 463 Rail Rate Reply
• 466 Rate Request
• 468 Rate Docket Journal Log
• 470 Railroad Clearance
• 475 Rail Route File Maintenance
• 485 Ratemaking Action
• 486 Rate Docket Expiration
• 490 Rate Group Definition
• 492 Miscellaneous Rates
• 494 Rail Scale Rates
• 500 Medical Event Reporting
• 501 Vendor Performance Review
• 503 Pricing History
• 504 Clauses and Provisions
• 511 Requisition
• 517 Material Obligation Validation
• 521 Income or Asset Offset
• 527 Material Due-In and Receipt
• 536 Logistics Reassignment
• 540 Notice of Employment Status
• 561 Contract Abstract
• 567 Contract Completion Status
• 568 Contract Payment Management Report
• 601 U.S. Customs Export Shipment Information
• 602 Transportation Services Tender
• 620 Excavation Communication
• 622 Intermodal Ramp Activity
• 625 Well Information
• 650 Maintenance Service Order
• 715 Intermodal Group Loading Plan
• 753 Request for Routing Instructions
• 754 Routing Instructions
• 805 Contract Pricing Proposal
• 806 Project Schedule Reporting
• 810 Invoice
• 811 Consolidated Service Invoice/Statement
• 812 Credit/Debit Adjustment
• 813 Electronic Filing of Tax Return Data
• 814 General Request, Response or Confirmation
• 815 Cryptographic Service Message
• 816 Organizational Relationships
• 818 Commission Sales Report
• 819 Joint Interest Billing and Operating Expense Statement
• 820 Payment Order/Remittance Advice
• 821 Financial Information Reporting
• 822 Account Analysis
• 823 Lockbox
• 824 Application Advice
• 826 Tax Information Exchange
• 827 Financial Return Notice
• 828 Debit Authorization
• 829 Payment Cancellation Request
• 830 Planning Schedule with Release Capability
• 831 Application Control Totals
• 832 Price/Sales Catalog
• 833 Mortgage Credit Report Order
• 834 Benefit Enrollment and Maintenance
• 835 Health Care Claim Payment/Advice
• 836 Procurement Notices
• 837 Health Care Claim
• 838 Trading Partner Profile
• 839 Project Cost Reporting
• 840 Request for Quotation
• 841 Specifications/Technical Information
• 842 Nonconformance Report
• 843 Response to Request for Quotation
• 844 Product Transfer Account Adjustment
• 845 Price Authorization Acknowledgment/Status
• 846 Inventory Inquiry/Advice
• 847 Material Claim
• 848 Material Safety Data Sheet
• 849 Response to Product Transfer Account Adjustment
• 850 Purchase Order
• 851 Asset Schedule
• 852 Product Activity Data
• 852 Product Activity Data Plus Module
• 853 Routing and Carrier Instruction
• 854 Shipment Delivery Discrepancy Information
• 855 Purchase Order Acknowledgment
• 856 Ship Notice/Manifest
• 857 Shipment and Billing Notice
• 858 Shipment Information
• 859 Freight Invoice
• 860 Purchase Order Change Request - Buyer Initiated
• 861 Receiving Advice/Acceptance Certificate
• 862 Shipping Schedule
• 863 Report of Test Results
• 864 Text Message
• 865 Purchase Order Change Acknowledgment/Request - Seller Initiated
• 866 Production Sequence
• 867 Product Transfer and Resale Report
• 868 Electronic Form Structure
• 869 Order Status Inquiry
• 870 Order Status Report
• 871 Component Parts Content
• 872 Residential Mortgage Insurance Application
• 873 Commodity Movement Services
• 874 Commodity Movement Services Response
• 875 Grocery Products Purchase Order
• 876 Grocery Products Purchase Order Change
• 877 Manufacturer Coupon Family Code Structure
• 878 Product Authorization/De-authorization
• 879 Price Information
• 880 Grocery Products Invoice
• 881 Manufacturer Coupon Redemption Detail
• 882 Direct Store Delivery Summary Information
• 883 Market Development Fund Allocation
• 884 Market Development Fund Settlement
• 885 Retail Account Characteristics
• 886 Customer Call Reporting
• 887 Coupon Notification
• 888 Item Maintenance
• 889 Promotion Announcement
• 891 Deduction Research Report
• 893 Item Information Request
• 894 Delivery/Return Base Record
• 895 Delivery/Return Acknowledgment or Adjustment
• 896 Product Dimension Maintenance
• 920 Loss or Damage Claim - General Commodities
• 924 Loss or Damage Claim - Motor Vehicle
• 925 Claim Tracer
• 926 Claim Status Report and Tracer Reply
• 928 Automotive Inspection Detail
• 940 Warehouse Shipping Order
• 943 Warehouse Stock Transfer Shipment Advice
• 944 Warehouse Stock Transfer Receipt Advice
• 945 Warehouse Shipping Advice
• 946 Delivery Information Message
• 947 Warehouse Inventory Adjustment Advice
• 980 Functional Group Totals
• 990 Response to a Load Tender
• 993 Secured Receipt or Acknowledgment
• 994 Administrative Message
• 996 File Transfer
• 997 Functional Acknowledgment
• 998 Set Cancellation
• 999 Acceptance/Rejection Advice