Sales report as ANSI format 997

1. Document information

File content DateVersionType
Receiving Confirmation09.01.20181.0ANSI

2. Structure

beeline is able to offer an acknowledgement for the sales report data in ANSI format 997. Attribute shows the minimum length within the first figure and the maximum length within the second figure. This form follows the standard and should include the following segments: 
 

ISA Interchange Control Header01 
Function:Starts and Identifies an interchange of zero or more functional groups and interchange-related control segments.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
ISA01-ISA02I01/I02Mdiv.Authorization Qualifier and Information00 
No Authorization Information available
ISA03-ISA04I03/I04Mdiv.Security Qualifier and Information00 
No Security Information available
ISA05I05MID 2/2Interchange ID Qualifier08
Sender
ISA06I06MAN 1/15Sender IDSender Identification, e.g. 9254291001
ISA07I05MID 2/2Interchange ID Qualifier12 
Receiver
ISA08I07MAN 1/15Receiver IDReceiver Identification, e.g. 4049789941
ISA09I08MDT 6/8Interchange DateYYMMDD 
Date, e.g. 141111
ISA10I09MN0 3/3Interchange TimeHHMM
Time, e.g. 0351
ISA11I10MID 1/1Interchange Control Standards IdentifierU 
U.S. EDI Community
ISA12I11MID 5/5Control Version Number00401 
Draft Standards for Trial Use approved
ISA13I12MN0 1/9Interchange Control NumberUnique Number of the Message,
e.g. 000000005
ISA14I13MID 1/1Technical Acknowledgement requiredCode sent by Sender to request Acknowledgement
e.g. 0
ISA15I14MID 1/1Test IndicatorT = Test 
P = Production
ISA16I15not used   
 
Example:ISA*00*00*08*9254291001*12*4049789941*141111
*0351*U*00401*000000005*0*P  
GS Functional Group Header01 
Function:Indicates the beginning of a functional group and to provide control information.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
GS01479MID 2/2Functional Identifier CodePD 
Product Activity Data
GS02142MAN 2/15Sender ID QualifierSender Identification, e.g. 9254291001
GS03124MAN 2/15Receiver ID QualifierReceiver Identification, e.g. 4049789941
GS04373MDT 6/8DateYYMMDD
e.g. 141111
GS05337MN 4/8TimeHHMM
e.g. 0351
GS0628MN0 1/9Group Control Number5
Assigned Number by Sender
GS07445MID 1/2Responsible Agency CodeX
Accredited Standards Committee X12
GS08480MAN 1/12Control Version00401
Draft Standards for Trial Use approved
 
Example:GS*PD*925291001*4049789941*20141111*0351*5*x*004010  
ST Transaction Set HeaderM1 
Function:Indicates the start of a transaction set and to assign a control number.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
ST01143MID 3/3Transaction Set Identifier Code997 
Code uniquely identifying a Transaction Set
ST02329MAN 4/9Transaction Set Control NumberUnique in Transaction Set
 
Example:ST*997*0001  
AK1 Functional Group Response HeaderM1 
Function:To start acknowledgment of a functional group.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
AK101479MID 2/2AK101 is the functional ID found in the GS segment(GS01)PO
AK10228MN0 1/9AK102 is the functional group control number found in the GS segment1
 
Example:AK1*PO*1  
AK9 Functional Group Response Trailer0>1 
Function:To acknowledge acceptance or rejection of a functional group and report the number of included transaction sets from the original trailer,the accepted sets,and the received sets in this functional group.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
A901715MID 1/1Functional Group Acknowledge CodeA = Accepted, E = Accepted, but errors were noted
A90297MN0 1/6Number of Transaction Sets Included2
A903123MN0 1/6Number of Received Transaction Sets1
A9042MN0 1/6Number of Accepted Transaction Sets1
A905715OID 1/3Functional Group Syntax Error Code 
A90697OID 1/3Functional Group Syntax Error Code 
A907123OID 1/3Functional Group Syntax Error Code 
A9082OID 1/3Functional Group Syntax Error Code 
A9092OID 1/3Functional Group Syntax Error Code 
 
Example:AK9*A*2*1*1  
SE Transaction Set TrailerM1 
Function:Indicates the number of included segments.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
SE0196MID 2/2Number of Included SegmentsNumber of Segments in the Message,
e.g. 4174
SE02329not used   
 
Example:SE*4174  
GE Functional Group TrailerO1 
Function:Indicates the end of a functional group and to provide control information.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
GE0197MN0 1/6Number of Transaction Sets IncludedAmount of included Messages / Group Segments, e.g. 1
GE0228MN0 1/9Group Control NumberGroup Segment Number from GS06, e.g. 5
 
Example:GE*1*5  
IEA Interchange Control TrailerO1 
Function:Defines the end of an interchange of zero or more functional groups and interchange-related.  
 Ref. Des  Data element  Satus  Attribute  Name  Content/Notes 
IEA01I16MN0 1/5Number of Included Functional GroupsAmount of included Function Groups within one Data Transfer
IEA02I12MN0 1/9Interchange Control NumberInterchange Number from ISA13, e.g. 5
 
Example:IEA*1*000000005  


Here you can download a sample receiving confirmation in ANSI format: 

ANSI receiving confirmation 

3. Legend

ElementDefinitionExample
Format  
N0integerN03 = exact 3 integer positions
N0...35 = up to 35 integer positions
ANalphanumericAN12 = exact 12 alphanumeric positions
AN...35 = up to 35 alphanumeric positions
DTdate 
IDidentifier 
Rexplicit 
Status  
Mmust 
Ooptional