SQLCreate_X12_TA1_InterchangeNoteCode.sql

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].tbl_TA1_InterChangeNoteCode(
	[InterchangeNoteCode] [char](3) NULL,
	[InterchangeNote] [varchar](128) NULL
) ON [PRIMARY]

GO

Create Index [InterchangeNoteCode] On tbl_TA1_InterChangeNoteCode([InterchangeNoteCode])

SET ANSI_PADDING OFF
GO

Insert Into tbl_TA1_InterChangeNoteCode Select '000', 'No Errors'
Insert Into tbl_TA1_InterChangeNoteCode Select '001', 'The Interchange Control Number in the Header and Trailer do not match The value in the header is used as an acknowledgement'
Insert Into tbl_TA1_InterChangeNoteCode Select '002', 'The Standard as noted in the Control Standards Identifier is not supported'
Insert Into tbl_TA1_InterChangeNoteCode Select '003', 'The version of the controls is not supported'
Insert Into tbl_TA1_InterChangeNoteCode Select '004', 'The segment terminator is not valid'
Insert Into tbl_TA1_InterChangeNoteCode Select '005', 'Invalid interchange ID qualifier for sender'
Insert Into tbl_TA1_InterChangeNoteCode Select '006', 'Invalid interchange ID for sender'
Insert Into tbl_TA1_InterChangeNoteCode Select '007', 'Invalid interchange ID qualifier for recipient'
Insert Into tbl_TA1_InterChangeNoteCode Select '008', 'Invalid interchange ID for recipient'
Insert Into tbl_TA1_InterChangeNoteCode Select '009', 'Unknown interchange receiver ID'
Insert Into tbl_TA1_InterChangeNoteCode Select '010', 'Invalid Authorization Information Qualifier Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '011', 'Invalid Authorization Information Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '012', 'Invalid Security Information Qualifier Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '013', 'Invalid Security Information Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '014', 'Invalid Interchange Date Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '015', 'Invalid Interchange Time Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '016', 'Invalid Interchange Standards ID Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '017', 'Invalid Interchange Version ID number'
Insert Into tbl_TA1_InterChangeNoteCode Select '018', 'Invalid Interchange Control Number'
Insert Into tbl_TA1_InterChangeNoteCode Select '019', 'Invalid Acknowledgement Request Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '020', 'Invalid Test Indicator value'
Insert Into tbl_TA1_InterChangeNoteCode Select '021', 'Invalid Number of Included Group Value'
Insert Into tbl_TA1_InterChangeNoteCode Select '022', 'Invalid control structure'
Insert Into tbl_TA1_InterChangeNoteCode Select '023', 'Improper end of file'
Insert Into tbl_TA1_InterChangeNoteCode Select '024', 'Invalid Interchange content'
Insert Into tbl_TA1_InterChangeNoteCode Select '025', 'Duplicate Interchange Control Number'
Insert Into tbl_TA1_InterChangeNoteCode Select '026', 'Invalid Data Element Separator'
Insert Into tbl_TA1_InterChangeNoteCode Select '027', 'Invalid Component element Separator'
Insert Into tbl_TA1_InterChangeNoteCode Select '028', 'Invalid Delivery date in the Deferred Delivery Request'
Insert Into tbl_TA1_InterChangeNoteCode Select '029', 'Invalid Delivery time in the Deferred Delivery Request'
Insert Into tbl_TA1_InterChangeNoteCode Select '030', 'Invalid Delivery time code in the Deferred Delivery Request'
Insert Into tbl_TA1_InterChangeNoteCode Select '031', 'Invalid grade of service code'