sekmet / x12

Generic ANSI X12 Transaction processing in PHP and SQL

X12

Generic ANSI X12 Transactions

Intended to be used as a template (as each X12 implementation is dependent on specific business rules)

X12_811_Export.php
ANSI ASC X12.811 (Financial Series [FIN]) Consolidated Service Invoice/Statement (version 004010)

X12_835_Export.php
ANSI ASC X12.835 Health Care Claim Payment/Advice transaction set ( version: 005010X221 )

X12_999_Import.php
ANSI ASC X12.999 Functional Acknowledgement ( version: 005010X231A1 )

SQLCreate_X12_999_ErrorMessageTable:
Creates a SQL table containing X12 999 response messages

Import_X12_999:
Creates a stored procedure that imports, parses and outputs an email containing the X12 999 response file with response messages.
Note: Requires SQLCreate_X12_999_ErrorMessageTable, created by the above

SQLCreate_TA1_InterChangeNoteCode:
Creates and populates a table, tbl_TA1_InterChangeNoteCode that contains the X12 TA1 Interchange Note Codes and descriptions.

Import_X12_TA1:
Creates a stored procedure that imports, parses and outputs an email containing the X12 TA1 acknowledgement file with response messages.
Note: Requires SQLCreate_X12_TA1_InterChangeNoteCode, created by the above

X12_837_ImportHack
T-SQL only. Imports an 837 into a table and groups the segments by Hierarchical Level so that related data segments may be grouped together. (this was a bit of a hack I used to do a quick and dirty reconciliation, but it's come in useful for ad hoc tasks involving X12 formatted files
X12_837_ImportHack_CreateTables.sql
X12_837_ImportHack.sql

X12_270_Export_Template.sql
Template for outputting an X12 270 Eligibility Inquiry using MS SQL