CVS INVOICE
TRANSACTION SET 810, VERSION 4010

Please go here to view what CVS lists as critical conditions.  If you do not comply with these conditions your invoices will NOT be processed.

Please note: Bolded segments have been modified.

The following segments will be received by CVS.

ISA - To start and identify an interchange of one or more functional group (s) and interchange related control segments.

GS - To indicate the beginning of a functional group and to provide control information.

ST - To indicate the start of a transaction set and to assign a control number.

BIG - To indicate the beginning of an invoice and transmit identifying numbersand dates.

REF - To specify identifying numbers.

N1 - To identify party by type of organization , name and code. *

N2 - Additional name information.

N3 - Address information.

N4 - Geographic location.

ITD - To identify terms of sale. (invoice level)

DTM - To specify pertinent dates and times.

FOB - To specify FOB related instructions.

IT1 - To specify the basic and most frequently used line item data for the invoice and related transactions.

CTP - Pricing Information (if applicable)

PID - To describe a product or process in coded or free-form format

PO4 - To specify item physical details.

ITD - To identify terms of sale. (item level of invoice) *

SAC - To specify allowances, charges or services. *

TDS - To specify the total invoice discounts and amounts.

SAC - To specify allowances, charges or services - vendor.

ISS - To specify summary details of total items shipped in terms of quantity, weight and volume.

CTT - To transmit a hash total for a specific element in the transaction set.

SE - To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (st)and ending (se) segments).

GE - To indicate the end of a functional group and to provide control information.

IEA - To define the end of an interchange of one or more functional groups and interchange related control segments.

* - This segment could occur multiple times within its group

CVS INVOICE
TRANSACTION SET 810, VERSION 4010

SEG
ID
    FIELD
LENGTH
VALUE

ISA

07

Receiver Transmission

x(02)

ZZ - Front Store (OTC Items)

       

01 - Pharmacy

 

08

Receiver Transmission Code

x(09)

CVS Warehouse Vendor or

CVSINVDSD -Direct Store Vendor

GS
ST

HEADER AREA

BIG 01 Invoice Date 9(8) CCYYMMDD
  02 Invoice Number X(22) Vendor’s Invoice Number
  03 P.O.Date 9(8) CCYYMMDD
  04 P.O. Number 9(7) CVS P.O. # being Invoiced

(May Not Apply To DSD Vendors)

  07 Transaction Code x(2) FOR CREDITS
        ‘CR or ‘CN’ acceptable
REF 01 Reference Number Qualifier x(2) ‘VR’ Vendor # assigned by CVS FOR DSD VENDORS ONLY
  02 Reference Number 9(4) Value defined by Ref 01
N1 01 Entity ID Code x(2) ‘ST ‘ Ship To
  03 ID Code Qualifier x(2) ‘9 ‘ Use if Front Store (OTC Items)

‘11’ Use if Pharmacy (DEA Number)

  04 ID Code x(13) If N1 03 = ‘9 ‘

Duns #001786664 + 4 Digit Suffix

(See Attached Whse Ship-To ID Table OR Duns #001786664 + Store Number)

If N1 - 03 = ‘11’

PM0124723 = Woonsocket, RI RM0145347 = Lumberton, NJ

PR0205559 = Knoxville, TN

RH0197170 = Indianapolis, IN

RA0125078 = Novi, MI

CVS INVOICE
TRANSACTION SET 810, VERSION 4010

HEADER AREA (continued)

SEG
ID
    FIELD
LENGTH
VALUE
N1 01 Entity ID Code X(2) ‘RE’ REMIT TO
  02 Name X(35) Vendor name
  03 ID Code Qualifier X(2) ‘9 ‘ - use for OTC or

‘11’ - use for Pharmacy

  04 ID Code X(13) Duns number for OTC or

DEA number for Pharmacy

ITD

01

Terms Type Code

x(2)

‘01’ - Basic

       

‘02’ - EOM

       

‘04’ - Deferred or Installment

       

‘07’ - Extended

 

02

Terms Basis Date Code

x(2)

‘3’ - Invoice Date

       

‘4’ - Specified Date

 

03

Terms Discount Pct

99.999

Discount percent

 

05

Terms Discount Days

9(3)

Discount days

 

06

Terms Net Due Date

9(8)

CCYYMMDD Date when Total Amount becomes Due.

 

07

Terms Net Days

9(3)

Net days

 

09

Terms Defer. Due Date

9(8)

Payment 1,2,3 dates

 

10

Deferred Amount Due

9(7)v99

 

ITD

11

Pct of Invoice Pay

99v9

Payment 1,2,3 percent

         

DTM

01

Date/Time Qualifier

x(3)

‘011’ = Shipped

 

02

Date

x(8)

Shipped Date - CCYYMMDD

FOB 01 Ship Method of Payment x(2) ‘BP’ Paid by Buyer
        ‘CC’ Collect
        ‘FO’ FOB Port of Call
        ‘PB’ Backhaul
        ‘PC’ Prepaid but charged to Customer
        ‘PP’ Prepaid
        ‘TP’ Third Party Pay
  02 Location Qualifier x(2) ‘OR’ Shipping Point
  03 Description x(80) Shipping Point Location

DETAIL AREA

SEG
ID
    FIELD
LENGTH
VALUE
IT1 02 # of Units Invoiced 9(10) Quantity billed for this item
  03 Unit of Measure Basis x(2) ‘PC’ - Pieces
        ‘EA’ - Eaches
        ‘DZ’ - Dozens
        ‘CA’ - Cases
  04 Price per Unit 9(4).999 Unit Price
  05 Type of Price Code   ‘DS’ Price after disc.
        ‘CP’ Price before discount.
        ‘PR’ Promotion
  06 Element Type x(2) ‘UI’ Item UPC
  07 ID # for Product 9(11) Item UPC Number or
  08 Element Type x(2) ‘ND’ NDC
  09 ID # for Product 9(11) Item NDC Number or
  10 Element Type x(2) ‘PI’
  11 ID # for Product 9(6) CVS Item Number or
  12 Element Type x(2) ‘UA’
  13 ID # for Product 9(12) Case UPC
         
CTP 02 Price ID Code X(3) "AWP" only accepted code
  03 Avg. Wholesale Price 9(4).999  

PID

01

Item Description Type

x(1)

‘F’

 

05

Description

x(30)

Description and Size
         
PO4 01 Case Pack 9(6) CVS ordered case pack

ITD

01

Terms Type Code

x(2)

01 - Basic

       

02 - EOM

       

04 - Deferred or Installment

       

07 – Extended

 

02

Terms Basis Date Code

x(2)

3 - Invoice Date

       

4 – Specified Date

 

03

Terms Discount Percent

99.999

Discount Percent

 

05

Terms Discount Days

9(3)

Discount Days

 

06

Terms Net Due Date

9(8)

CCYYMMDD Date when Total Amount becomes Due

 

07

Terms Net Days

9(3)

Net days

 

09

Terms Defer. Due Date

9(8)

Payment 1,2,3 dates

 

10

Deferred Amount Due

9(7)v99

 

 

SEG
ID
    FIELD
LENGTH
VALUE
 

11

Pct of Invoice Pay

99v9

Payment 1,2,3 percent

SAC

01

Allowance Indicator

x(1)

A = Allowance    

        C = Charge
 

02

Promo,Allowance, Charge Code

x(4)

Always = ZZZZ

 

05

Allowance Amount

9(7)V99

 
 

06

Allowance % Qualifier

9(1)

1 = Item List Cost

 

07

Allowance %

9(4).99

 
 

08

Allowance Rate

9(8).99

 
 

12

Method of Handling

9(2)

01=Bill Back

       

02=Off-Invoice

        06=Charge
 

15

Allowance Description

x(80)

Allowance Description

       

Display

       

Purchasing

       

Advertising

       

Roto (TAB)

       

Feature (WB)

       

Media (TV)

       

Additional Advertising

       

CMA (Additional)

       

Freight Charges

       

Taxes - Sales, Non-resale items

       

Pallet Charges

       

Other

SUMMARY AREA

TDS 01 Total Invoice Amount. 9(8)v99 Total Invoice.

The amount of invoice (including charges, less allowances) before terms discount, if applicable.

  02 Amount subject to terms or discount . 9(8)v99 Invoice Amount subject to discount.

The amount upon which the terms discount amount is calculated.

  03 Discount Amount Due. 9(8)v99 The amount of invoice due if paid by terms discount due date (total invoice amount less cash discount).
  04 Terms Discount Amount. 9(8)v99 The total amount of terms discount.

VENDOR LEVEL ALLOWANCES IF APPLICABLE

SAC

01

Allowance Indicator

x(1)

A = Allowance    

        C = Charge
 

02

Promo,Allowance, Charge Code

x(4)

Always = ZZZZ

 

05

Allowance Amount

9(7)V99

 
 

06

Allowance % Qualifier

9(1)

1 = Item List Cost

 

07

Allowance %

9(4).99

 
 

08

Allowance Rate

9(8).99

 
 

12

Method of Handling

9(2)

01=Bill Back

       

02=Off-Invoice

        06=Charge
 

15

Allowance Description

x(80)

Allowance Description

       

Promo

       

Display

       

Ad

       

Other

       

Quantity Allowance

       

Truckload

       

Carload

       

Backhaul

       

Additional

       

Taxes - Sales, Non-Resale Items

       

Pallet Charge

       

Freight Charge

ISS 01 Total Number of units shipped 9(6)  
  02 Unit of measurement x(2) ‘PC’ - Pieces
        ‘EA’ - Eaches
        ‘DZ’ - Dozens
        ‘CA’ - Cases
CTT 01 Number Line Items 9(6) Total number of UPC’s or NDC’s on invoice

SE

GE

IEA

DUNS
SUFFIX
CODE NAME STREET CITY ST ZIP AREA
CODE
PHONE EXT.
A101 A1 CVS Distribution, Inc. 2600 Morgan Rd. Bessemer AL 35023 205 424-3421 248
D101 OTC D1 CVS Distribution, Inc. 43800 Genmar Dr. Novi MI 48374 248 348-5240
D202 RX D2 CVS Distribution, Inc. 43800 Genmar Dr. Novi MI 48374 248 348-5240
D303 BULK D3 CVS Distribution, Inc. 43800 Genmar Dr. Novi MI 48374 248 348-5240
H101 H1 CVS Distribution, Inc. 1230 Andrews Ave. Henderson NC 27536 919 492-8985
I101 OTC I1 CVS Distribution, Inc. 2800 Enterprise St. Indianapolis IN 46219 317 353-1451 3510
I202 RX I2 CVS Distribution, Inc. 7590 Empire Dr. Indianapolis IN 46219 317 353-1458 3264
M101 OTC M1 CVS Distribution, Inc. 500 Lansdowne Rd. Fredricksburg VA 22408 540 898-3422 3424
M404 BULK M4 CVS Distribution, Inc. 501 Lansdowne Rd. Fredricksburg VA 22408 800 866-4796 3440
M606 M6 CVS Distribution, Inc. 501 Lansdowne Rd. Fredricksburg VA 22408 800 866-4796 3440
N101 OTC N1 CVS Distribution, Inc. One Berry Drive Lumberton NJ 08048 609 267-6700 308
N202 RX N2 CVS Distribution, Inc. One Berry Drive Lumberton NJ 08048 609 267-6700 308
P101 P1 CVS Distribution, Inc. 322 Revco Rd. Somerset PA 15501 814 445-2092
S101 S1 CVS Distribution, Inc. 111 Revco Rd. North Augusta SC 29841 803 278-4664
T101 T1 CVS Distribution, Inc. 10008 Parkside Dr. Knoxville TN 37922 423 693-2711 310
T202 RX T2 CVS Distribution, Inc. 10017 Kingston Pike Knoxville TN 37922 423 693-2716 Receiving
W101 W1 CVS Distribution, Inc. 400 Founders Dr. Woonsocket RI 02895 401 765-1500 6470
W202 W2 CVS Distribution, Inc. 400 Founders Dr. Woonsocket RI 02895 401 765-1500 6470
W303 W3 CVS Distribution, Inc. 108 Mason St. Woonsocket RI 02895 401 235-5101
W404 W4 CVS Distribution, Inc. 108 Mason St. Woonsocket RI 02895 401 235-5101
W505 W5 CVS Distribution, Inc. 150 Industrial Dr. No. Smithfield RI 02896 401 765-1500 6470
W707 W7 CVS Distribution, Inc. 150 Industrial Dr. No. Smithfield RI 02896 401 765-1500 6470
W808 W8 CVS Distribution, Inc. 50 Fortin Dr. Woonsocket RI 02895 401 765-1500 6470

This page was last updated 08/18/1999