Mapping Requirements – v.4010 850 Front Store/Pharmacy Specification

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
FRONT STORE/PHARMACY


Please note: Bolded segments have been modified.

The following segments will be sent 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.

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

BEG - To indicate the beginning segment for purchase order.

REF - To specify identifying numbers - Multiple times

PER
- To indicate administrative communications contact.

SAC - To specify allowance, charge or service. (vendor level) *

ITD - To identify terms of sale/deferred terms of sale.(vendor level)

DTM - To specify pertinent delivery dates and times.

N1
- To specify pertinent shipping information.

PO1 - To specify baseline item data.

PID - To indicate product/item description.

PO4 - To indicate item physical details.

SAC - To specify allowance, charge or service. (item level) *

ITD - To specify terms of sale/deferred terms of sale. (item level) *

CTT
- To indicate transaction totals.

SE - To indicate transaction set trailer.

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

* - This segment could occur multiple times within its group

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
FRONT STORE/PHARMACY

SEG     FIELD  
ID   DESCRIPTION LENGTH VALUE
         
ISA 05 Sender Transm. x(2) ZZ = Front Store
        01 = Pharmacy
  06 Sender Transm. Cd x(3) CVS
GS        
ST        
BEG 01 Transaction Set x(2) 00-original
  02 PO Type Code x(2) SA - stand alone
  03 PO Number 9(7) PO number
  05 PO Date 9(8) Order date - CCYYMMDD
REF 01 Ref. Number Qualifier x(2) VR Vendor # Assigned by CVS
  02 Ref. # 9(10) Value Defined by Ref01

PURCHASE ORDER COMMENT:

REF 01 REF Reference Cd x(2) ZZ - Special Handling
  03 Message x(60) PO Comment-must be reviewed
        Promotional Data

Seasonal Promotion Code or any

information to better define this order

WHSE CLOSING MESSAGE WHERE APPLICABLE:

REF 01 REF Reference Cd x(2) ZZ - Delivery msg
  03 Message x(60) No receiving from mm/dd/yy
        to mm/dd/yy
PER 01 Contact Function x(2) BD - Buyer Name
  02 Name x(20) Buyer Name
         

SAC

01

Allowance Indicator

x(1)

A Allowance

 

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

 

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
FRONT STORE/PHARMACY

SEG

 

FIELD

 

ID

 

LENGTH

VALUE
 

12

Method of Handling

9(2)

01=Bill Back

       

02=Off-Invoice

 

15

Allowance Description

x(80)

Allowance Description

       

Promo

       

Display

       

Ad

       

Other

       

Quantity Allowance

       

Truckload

       

Carload

       

Backhaul

       

Additional

ITD

01

Terms Type Code

x(2)

01 – Basic

       

02 – EOM

       

04 – Deferred or Installment

       

07 – Extended

 

02

Terms Basis Date Cd

x(1)

3 – Invoice Date

       

4 – Specified Date

 

03

Terms Discount Pct

9(2)

Discount percent

 

05

Terms Discount Days

9(2)

Discount days

 

07

Terms Net Days

9(2)

Net days

 

09

Terms Defer. Due Dt

9(8)

Payment 1,2,3 dates

 

10

Deferred Amount Due

9(7)v99

Required field – ignore

       

will always be a 1

 

11

Pct of Invoice Pay

99v9

Payment 1,2,3 percent

DTM

01

Date/Time Qualifier

x(3)

002 = Delivery

 

02

Date

X(8)

Delivery by Date (CCYYMMDD)

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)

SEG ID

 

 

FIELD LENGTH

VALUE
  04    

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

PO1

02

Quantity Ordered

9(7)

On Order Quantity

 

03

Unit of Measure

x(2)

CA – Cases

 

04

Unit Price

9(4).999

Case Price

 

06

Prod ID Qualifier

x(2)

PI *

 

07

Product ID

9(6)

Purchaser’s Item number

 

08

Prod ID Qualifier

x(2)

ND - NDC Item Number

 

09

Product ID

9(11)

NDC Number (11 digit)

 

10

Product ID Qualifier

x(2)

UI

 

11

Product ID

9(11)

Item UPC Code (11 digit)

  12 Product ID Qualifier x(2) UA *
  13 Product ID 9(12) Case UPC Code

PID

01

Item Descrip Type

x(1)

F

 

05

Description

x(30)

Item comment and/or description

and size

*NO UPC AVAILABLE = WILL BE PURCHASER’S ITEM NUMBER (PI)(6CHARS)

= CASE UPC, IF AVAILABLE (UA)

= PID SEGMENT CONTAINS CVS DESC. AND SIZE FOR REGULAR PRODUCTS: IF CASE UPC IS AVAILABLE WE WILL ALSO SEND

PO4

01

Pack

9(6)

Case Pack

SAC

01

Allowance Indicator

x(1)

A Allowance

 

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

 

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
FRONT STORE/PHARMACY

SEG

 

FIELD

 

ID

 

LENGTH

VALUE

 

12

Method of Handling

9(2)

01=Bill Back

       

02=Off-Invoice

 

15

Allowance Description

x(80)

Allowance Description

       

Display

       

Advertising

       

Roto (TAB)

       

Feature (WB)

       

Media (TV)

       

Additional Advertising

       

CMA (Additional)

       

Other

ITD

01

Terms Basis Date Cd

x(2)

01 - Basic

       

02 - EOM

        04 - Deferred/Installment
       

07 - Extended

 

02

Terms Basis Date Code

x(1)

3 - Invoice Date

       

4 - Specified Date

 

03

Terms Discount Pct

9(2)

Discount percent

 

05

Terms Discount Days

9(2)

Discount days

 

07

Terms Net Days

9(2)

Net days

 

09

Terms Defer. Due Dt

9(8)

Payment 1,2,3 (CCYYMMDD)

 

10

Deferred Amount Due

9(8)v99

Required field - ignore

       

will always be 1

 

11

Pct of Invoice Pay

99v9

Payment 1,2,3 payment

CTT

01

Nmbr Line Items

9(7)

Total number of Items
 

02

Hash Total

9(7)

Total on order qty

SE

       

GE

       

IEA

       

This page was last updated 08/18/1999