Mapping Requirements v.4010 850 Direct Store Delivery

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
DIRECT STORE DELIVERY

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


FOB -
F.O.B. Related Instructions

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.

N3 -
To specify pertinent shipping address

N4 -
To specify pertinent shipping geographic location

N1 -
To specify pertinent billing information

PO1 -
To specify baseline item data.

PID -
To indicate product/item description.

PO4 -
To indicate item physical details.

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.

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
DIRECT STORE DELIVERY


SEG     FIELD  
ID   DESCRIPTION LENGTH VALUE
         
ISA 05 Sender Transm. x(2) ZZ = Front Store
  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 Note Reference Cd x(2) ZZ - Special Handling
  03 Message x(60) PO Comment-must be reviewed
        "Call Str 48 Hrs. in advance for Del."
PER 01 Contact Function x(2) DC - Delivery Contact
  02 Store Number x(20) Store Number
  03 Communication Number Qualifier x(2) TE - Telephone Number
  04 Phone Number x(9) 999-999-9999 Store Phone #

FOB

01

Method of Payment

xx

PO - Prepaid Only

SAC

01

Allowance Indicator

x(1)

A Allowance

 

06

Allowance % Qualifier

9(1)

1 = Item List Cost

 

07

Allowance %

9(4).99

 
 

12

Method of Handling

9(2)

01=Bill Back

       

02=Off-Invoice

 

15

Allowance Description

x(80)

Allowance Description

       

Promo

       

Ad

       

Other

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
DIRECT STORE DELIVERY

SEG

 

FIELD

 

ID

 

LENGTH

VALUE

ITD

01

Terms Type Code

x(2)

01 - Basic

 

02

Terms Basis Date Cd

x(1)

3- Invoice 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

DTM

01

Date/Time Qualifier

x(3)

010 = Delivery date

064 = Do Not Deliver Before

063 = Do Not Deliver After

       

063/064 will always be together, they define the receiving window

 

02

Date

X(8)

Date CCYYMMDD

N1

01

Entity ID Code

x(2)

ST - ship to

 

03

ID Code Qualifier

x(2)

9 - Duns w/4 digit Store #

 

04

ID Code & Suffix

x(17)

 

N3

01

Address Information

x(35)

Street Address

 

02

Address Information

x(35)

Street Address

N4

01

City Name

x(30)

City Name

 

02

State

x(2)

State

 

03

Postal Code

x(11)

Zip Code

N1

01

Entity ID Code

x(2)

BT - Bill to

 

03

ID Code Qualifier

x(2)

9 -

 

04

ID Code & Suffix

x(17)

Duns w/4 digit suffix

PO1

02

Quantity Ordered

9(7)

On Order Quantity

 

03

Unit of Measure

x(2)

PC - Pieces

 

04

Unit Price

9(4).999

Unit price

 

06

Prod Id Qualifier

x(2)

PI - CVS Item code

 

07

Product ID

9(6)

CVS Item Number

 

08

Prod Id Qualifier

x(2)

UI - UPC Code

 

09

Product ID

9(11)

UPC Number - 1,5,5

 

10

Product ID Qualifier

x(2)

UA

 

11

Product ID

9(12)

Case UPC Code

CVS PURCHASE ORDER
TRANSACTION SET 850, VERSION 4010
DIRECT STORE DELIVERY

NO UPC AVAILABLE = PO1 06 WILL BE CVS ITEM NUMBER = PO1 07 WILL CONTAIN CVS ITEM #

PID SEGMENT CONTAINS CVS DESCRIPTION AND SIZE

PID IS ONLY SENT UNDER THE ABOVE CONDITION

SEG
ID

 

FIELD
LENGTH

VALUE

PID

01

Item Description Type

x(1)

F

 

05

Description

x(30)

Item description and size

PO4

01

Pack

9(6)

Case Pack

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