Isa Interchange Control Header

810 INVOICES

Version 4010VICS

ISA – INTERCHANGE CONTROL HEADER

Segment&
Element / Element Name / Value/Description / Length
Min / Max
ISA01 / Authorization Information Qualifier / ‘00’ / 2 / 2
ISA02 / NOT USED / NOT USED / 0 / 0
ISA03 / Security Information Qualifier / ‘00’ / 2 / 2
ISA04 / NOT USES / NOT USED / 0 / 0
ISA05 / Interchange ID Qualifier / Sender Qualifier / 2 / 2
ISA06 / Interchange Sender ID / Sender ID / 15 / 15
ISA07 / Interchange ID Qualifier / ‘12’ / 2 / 2
ISA08 / Interchange Receiver ID / ‘2059560036’ / 15 / 15
ISA09 / Interchange Date / YYMMDD / 6 / 6
ISA10 / Interchange Time / HHMM / 4 / 4
ISA11 / Interchange Control Standards ID / ‘U’ / 1 / 1
ISA12 / Interchange Control Version Number / ‘00401’ / 5 / 5
ISA13 / Interchange Control Number / Sequentially Assigned / 9 / 9
ISA14 / Acknowledgement Requested / ‘0’ / 1 / 1
ISA15 / Test Indicator / ‘P’ / 1 / 1
EXAMPLE / ISA*00**00**01*0123456789*12*2059560036*120201*0816*U*00401*000000001*0*P*>

GS – FUNCTIONAL GROUP HEADER

Segment&
Element / Element Name / Value/Description / Length
Min / Max
GS01 / Functional Identifier Code / ‘IN’ / 2 / 2
GS02 / Application Sender’s Code / Sender ID / 2 / 15
GS03 / Application Receiver’s Code / '2059560036’ / 2 / 15
GS04 / Date / CCYYMMDD / 8 / 8
GS05 / Time / HHMM / 4 / 4
GS06 / Group Control Number / Sequentially Assigned to each Functional Group / 1 / 9
GS07 / Responsible Agency Code / ‘X’ / 1 / 1
GS08 / Version/Release/Industry Code / ‘004010VICS’ / 1 / 12
EXAMPLE / GS*IN*0123456789*2059560036*20120201*0816*000000001*X*004010VICS

St - Transaction Set Header

Segment&
Element / Element Name / Value/Description / Length
Min / Min
ST01 / Transaction Set ID Code / ‘810’ / 3 / 3
ST02 / Transaction Set Code Number / Sequentially Assigned Within Functional Group / 4 / 9
EXAMPLE / ST*810*024580001

BIG - Beginning Segment for Invoice

Segment&
Element / Element Name / Value/Description / Length
Min / Min
BIG01 / Date / CCYYMMDD / 8 / 8
BIG02 / Invoice Number / Vendor Invoice Number / 1 / 10
BIG03 / NOT USED / NOT USED
BIG04 / Purchase Order Number / HSG PO Number / 1 / 22
EXAMPLE / BIG*20120320*869303**287556

*BIG02 may not be duplicated within a two year period of time.

n1 - Name

Segment&
Element / Element Name / Value/Description / Length
Min / Min
N101 / Entity Identifier Code / ‘ST’ = Ship To / 2 / 3
N102 / NOT USED / NOT USED
N103 / Identification Code Qualifier / ‘92’ = Assigned by Buyer / 2 / 2
N104 / Identification Code / HSG Ship to Store / 2 / 80
EXAMPLE / N1*ST**92*14 (Consolidated), N1*ST**92*240 (Non-Consolidated)

*Consolidated invoices must reference a ship to location of “14”

*Non-Consolidated invoices must reference the actual location that received the product “HSG ship to store number”

*Team Division must reference location “41”

ITD - Terms of Sale / Deferred Terms of Sale

Segment / Element Name / Value/Description / Length
Min / Min
ITD01 – ITD02 / NOT USED / NOT USED
ITD03 / Terms Discount Percent / Discount Percentage / 1 / 6
ITD04 / Terms Discount Due Date / CCYYMMDD / 8 / 8
ITD05 / NOT USED / NOT USED
ITD06 / Terms Net Due Date / CCYYMMDD / 8 / 8
ITD07 / NOT USED / NOT USED
ITD08 / Terms Discount Amount / Total Discount Amount in Dollars / 1 / 10
EXAMPLE / ITD***0*20120519**20120519**00

IT1 - Baseline Item Data

Segment / Element Name / Value/Description / Length
Min / Min
IT101 / NOT USED / NOT USED
IT102 / Quantity Invoiced / Quantity Invoiced / 1 / 10
IT103 / Unit or Basis for Measurement / ‘EA’ = Each / 2 / 2
IT104 / Unit Price / Unit Cost / 1 / 17
IT105 / NOT USED / NOT USED
IT106 / Product / Service ID Qualifier / ‘UP’ = UPC; ‘EN’ = EAN / 2 / 2
IT107 / Product / Service ID / Item UPC (12 digit) or EAN (13 digit) Number / 1 / 48
IT108 / Product / Service ID Qualifier / ‘VC’ = Vendor Catalog / 2 / 2
IT109 / Product / Service ID / Vendor Catalog / 1 / 48
EXAMPLE / IT1**2*EA*8.35**UP*736097009090*VC*22440168

TDS - Total Monetary Value Summary

Segment / Name / Value/Description / Length
Min / Min
TDS01 / Amount / Total Amount of the Invoice (incl. charges, less allowances) before Terms discount (ITD08) / 1 / 15
TDS02 / Amount / Amount Eligible for Discount / 1 / 15
TDS03 / Amount / Discounted Amount Due / 1 / 15
TDS04 / Amount / Total Amount of Terms Discount = ITD08 / 1 / 15
EXAMPLE / TDS*2340*2340*2340*0

*TDS01: Product cost (total IT1) + Credit (C) – Allowance (A)

TDS02: Total IT1 segments (number of units x cost)

TDS03: Total IT1 – Discount +/- SAC

TDS04: Dollar amount of the discount (found in the ITD08)

SAC - Service, Promotion, Allowance or Charges

Segment / Name / Value/Description / Length
Min / Min
SAC01 / Allowance, Service or Charge Indicator / ‘C’ = Charge
‘A’ = Allowance / 1 / 1
SAC02 / Promotion, Allowance or Charge Code / ‘D240’= Freight
‘C000’ = Defect Allow / 4 / 4
SAC03-SAC04 / NOT USED / NOT USED
SAC05 / Amount / Charge Amount / 1 / 15
SAC06 -SAC14 / NOT USED / NOT USED
SAC15 / Description / Free Form Text / 1 / 80
EXAMPLE / SAC*C*D240***1769**********FREIGHT CHARGE

*SAC SEGMENT NOT REQUIRED IF THERE IS NO FREIGHT OR ALLOWANCE CHARGE* Freight only applicable on HSG Team Division orders (Loc #41) & Direct to store orders (Dropship) orders.

ISS- INVOICE Shipment Summary

Segment&
Element / Element Name / Value/Description / Length
Min / Min
ISS01 / Number of Units Shipped / Total Number of Cases Invoiced / 1 / 10
ISS02 / Unit or Basis for Measurement Code / ‘CA’ = Cases / 2 / 2
ISS03 / Weight / Weight of Cases Invoiced / 1 / 10
ISS04 / Unit or Basis for Measurement Code / ‘LB’ = Pounds / 2 / 2
EXAMPLE / ISS*1*CA*2.56*LB

CTT- TRANSACTION totals

Segment&
Element / Element Name / Value/Description / Length
Min / Min
CTT01 / Number of line items / Total Number of Line Items Invoiced(IT1 Segments) / 1 / 6
EXAMPLE / CTT*1

SE - TRANSACTION set trailer

Segment&
Element / Element Name / Value/Description / Length
Min / Min
SE01 / Number of Included Segments / Number of Segments / 1 / 10
SE02 / Transaction Set Control Number / Control Number – Same as the ST02 / 4 / 9
EXAMPLE / SE*10*0028

GE – FUNCTIONAL GROUP TRAILER

Segment&
Element / Element Name / Value/Description / Length
Min / Max
GE01 / Number of Transaction Sets Included / Number of Transactional Sets within / 1 / 6
GE02 / Group Control Number / Function Group Control number- the same as the GS06 / 1 / 9
Example / GE*1*1

IEA – INTERCHANGE CONTROL TRAILER

Segment&
Element / Element Name / Value/Description / Length
Min / Max
IEA01 / Number of Included Functional Groups / Number of Functional Groups / 1 / 5
IEA02 / Interchange Group Control / Interchange Control Number= ISA13 / 9 / 9
Example / IEA*1*000000001

Sample 810 Invoices

Non-Consolidated (By Store)

ST*810*000000107

BIG*20060524*2050**124520

N1*ST**92*01

ITD***0*20060530**20060622**000

IT1**3*EA*14**UP*666003007936 *VC*221579 827

IT1**5*EA*14**UP*091208100425*VC*221579 827

IT1**5*EA*14**UP*091208100432*VC*221579 827

TDS*18200*18200*18200*000

ISS*11*CA*40*LB

CTT*3

SE*11*000000107

Consolidated

ST*810*17

BIG*20120207*6024998088**237233

N1*ST**92*14

ITD***0*20120308**20120308**0

IT1**105*EA*6.07**UP*886039713865*VC*X17280

IT1**105*EA*6.07**UP*886039713926*VC*X17284

TDS*127470*127470*127470*0

ISS*70*CA*102.297*LB

CTT*2

SE*10*17

Prepack 810

ST*810*0001

BIG*20120210*6025018482**241131

N1*ST**92*14

ITD***0*20120311**20120311**0

IT1**100*EA*27**UP*886051127510*VC*J88322

IT1**100*EA*27**UP*886051127527*VC*J88322

IT1**100*EA*27**UP*886051127534*VC*J88322

IT1**200*EA*27**UP*886051127480*VC*J88322

IT1**100*EA*27**UP*886051127541*VC*J88322

IT1**200*EA*27**UP*886051127497*VC*J88322

IT1**200*EA*27**UP*886051127558*VC*J88322

IT1**200*EA*27**UP*886051127503*VC*J88322

TDS*3240000*3240000*3240000*0

ISS*100*CA*1944.444*LB

CTT*8

SE*16*0001

Team Division w/Freight

ST*810*0026

BIG*20120207*0939006832**270329

N1*ST**92*041

ITD******20120507

IT1**1*EA*46.06**UP*886059077084*VA*454149-011

TDS*5343*4606*5343*0

SAC*C*D240***737**********FREIGHT CHARGE

ISS*1*CA*2.2*LB

CTT*1

SE*10*0026

810 w/Defect Allow

ST*810*11244~

BIG*20120209*9011718774**283159

N1*ST**92*505

ITD******20120310

IT1**3*EA*30.25**UP*052178171617*SZ*36 32

IT1**3*EA*30.25**UP*052178171655*SZ*38 34

IT1**1*EA*30.25**UP*052178179477*SZ*36 30

IT1**3*EA*30.25**UP*052178138924*SZ*34 32

IT1**3*EA*30.25**UP*052178142143*SZ*38 30

TDS*39128*39325*39128*0

SAC*A*C000***197**********DEFECT ALLOW.

ISS*1*CA*24*LB

CTT*5

SE*14*11244

810 w/Discount (ITD) & Freight

ST*810*12950001

BIG*20120209*1574231**268467

N1*ST**92*41

ITD***0*20120409**20120409**4100

IT1**2*EA*60.00**UP*714195942327*VC*2966000012106

IT1**1*EA*40.00**UP*714195273797*VC*12704166

IT1**1*EA*45.00**UP*714195280078*VC*12647266

TDS*21580*20500*17480*4100

SAC*C*D240***1080**********FREIGHT

ISS*1*CA*12*LB