beeline group EDI

Sales report as ANSI format 997

 

File content  Date Version Type
Receiving Confirmation 09.01.2018 1.0 ANSI

 

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 Header 0 1  
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-ISA02 I01/I02 M div. Authorization Qualifier and Information 00 
No Authorization Information available
ISA03-ISA04 I03/I04 M div. Security Qualifier and Information 00 
No Security Information available
ISA05 I05 M ID 2/2 Interchange ID Qualifier 08
Sender
ISA06 I06 M AN 1/15 Sender ID Sender Identification, e.g. 9254291001
ISA07 I05 M ID 2/2 Interchange ID Qualifier 12 
Receiver
ISA08 I07 M AN 1/15 Receiver ID Receiver Identification, e.g. 4049789941
ISA09 I08 M DT 6/8 Interchange Date YYMMDD 
Date, e.g. 141111
ISA10 I09 M N0 3/3 Interchange Time HHMM
Time, e.g. 0351
ISA11 I10 M ID 1/1 Interchange Control Standards Identifier U 
U.S. EDI Community
ISA12 I11 M ID 5/5 Control Version Number 00401 
Draft Standards for Trial Use approved
ISA13 I12 M N0 1/9 Interchange Control Number Unique Number of the Message,
e.g. 000000005
ISA14 I13 M ID 1/1 Technical Acknowledgement required Code sent by Sender to request Acknowledgement
e.g. 0
ISA15 I14 M ID 1/1 Test Indicator T = Test 
P = Production
ISA16 I15 not used      
 
Example: ISA*00*00*08*9254291001*12*4049789941*141111
*0351*U*00401*000000005*0*P  
GS Functional Group Header 0 1  
Function: Indicates the beginning of a functional group and to provide control information.  
 Ref. Des   Data element   Satus   Attribute   Name   Content/Notes 
GS01 479 M ID 2/2 Functional Identifier Code PD 
Product Activity Data
GS02 142 M AN 2/15 Sender ID Qualifier Sender Identification, e.g. 9254291001
GS03 124 M AN 2/15 Receiver ID Qualifier Receiver Identification, e.g. 4049789941
GS04 373 M DT 6/8 Date YYMMDD
e.g. 141111
GS05 337 M N 4/8 Time HHMM
e.g. 0351
GS06 28 M N0 1/9 Group Control Number 5
Assigned Number by Sender
GS07 445 M ID 1/2 Responsible Agency Code X
Accredited Standards Committee X12
GS08 480 M AN 1/12 Control Version 00401
Draft Standards for Trial Use approved
 
Example: GS*PD*925291001*4049789941*20141111*0351*5*x*004010  
ST Transaction Set Header M 1  
Function: Indicates the start of a transaction set and to assign a control number.  
 Ref. Des   Data element   Satus   Attribute   Name   Content/Notes 
ST01 143 M ID 3/3 Transaction Set Identifier Code 997 
Code uniquely identifying a Transaction Set
ST02 329 M AN 4/9 Transaction Set Control Number Unique in Transaction Set
 
Example: ST*997*0001  
AK1 Functional Group Response Header M 1  
Function: To start acknowledgment of a functional group.  
 Ref. Des   Data element   Satus   Attribute   Name   Content/Notes 
AK101 479 M ID 2/2 AK101 is the functional ID found in the GS segment(GS01) PO
AK102 28 M N0 1/9 AK102 is the functional group control number found in the GS segment 1
 
Example: AK1*PO*1  
AK9 Functional Group Response Trailer 0 >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 
A901 715 M ID 1/1 Functional Group Acknowledge Code A = Accepted, E = Accepted, but errors were noted
A902 97 M N0 1/6 Number of Transaction Sets Included 2
A903 123 M N0 1/6 Number of Received Transaction Sets 1
A904 2 M N0 1/6 Number of Accepted Transaction Sets 1
A905 715 O ID 1/3 Functional Group Syntax Error Code  
A906 97 O ID 1/3 Functional Group Syntax Error Code  
A907 123 O ID 1/3 Functional Group Syntax Error Code  
A908 2 O ID 1/3 Functional Group Syntax Error Code  
A909 2 O ID 1/3 Functional Group Syntax Error Code  
 
Example: AK9*A*2*1*1  
SE Transaction Set Trailer M 1  
Function: Indicates the number of included segments.  
 Ref. Des   Data element   Satus   Attribute   Name   Content/Notes 
SE01 96 M ID 2/2 Number of Included Segments Number of Segments in the Message,
e.g. 4174
SE02 329 not used      
 
Example: SE*4174  
GE Functional Group Trailer O 1  
Function: Indicates the end of a functional group and to provide control information.  
 Ref. Des   Data element   Satus   Attribute   Name   Content/Notes 
GE01 97 M N0 1/6 Number of Transaction Sets Included Amount of included Messages / Group Segments, e.g. 1
GE02 28 M N0 1/9 Group Control Number Group Segment Number from GS06, e.g. 5
 
Example: GE*1*5  
IEA Interchange Control Trailer O 1  
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 
IEA01 I16 M N0 1/5 Number of Included Functional Groups Amount of included Function Groups within one Data Transfer
IEA02 I12 M N0 1/9 Interchange Control Number Interchange Number from ISA13, e.g. 5
 
Example: IEA*1*000000005  


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

ANSI receiving confirmation 

 

Element Definition Example
Format    
N0 integer N03 = exact 3 integer positions
N0...35 = up to 35 integer positions
AN alphanumeric AN12 = exact 12 alphanumeric positions
AN...35 = up to 35 alphanumeric positions
DT date  
ID identifier  
R explicit  
Status    
M must  
O optional