850 Mapping Guide

for ANSI 3040 & 3040VICS

 

 

VERSION: 3.0 DRAFT

 

 

     
  Author: Finlay EDI Department (BTL)
  Publication Date:
  Trading Partner: All
  Created:  
  Modified:  
  Notes:



850
Purchase Order

Functional Group=PO
This Draft Standard for Trial Use contains the format and establishes the data contents of the Purchase Order Transaction Set (850) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice relative to the placement of purchase orders for goods and services. This transaction set should not be used to convey purchase order changes or purchase order acknowledgment information.

Notes:

2/030

PO102 is required.

3/010

The number of line items (CTT01) is the accumulation of the number of PO1 segments. If used, hash total (CTT02) is the sum of the value of quantities ordered (PO102) for each PO1 segment.
       
 
Heading:
  Pos Id Segment Name Req Max Use Repeat Notes Usage                                        
  010 ST Transaction Set Header M 1   Used
  020 BEG Beginning Segment for Purchase Order M 1   Used
  040 REF Reference Numbers (vendor number) O 1   Used
  050 REF Reference Numbers (order type) O 1   Used
  060 REF Reference Numbers (promotion type) O 1   Used
  120 CSH Sales Requirements O 5   Used
Loop ID - SAC 1        
  140 SAC Service, Promotion, Allowance, or Charge Information O 1   Used      
  190 DTM Date/Time Reference (ship date) O 1   Used
  200 DTM Date/Time Reference (cancel date) O 1   Used
  210 DTM Date/Time Reference (promotion/ad date) O 1   Used
  300 TD5 Carrier Details (Routing Sequence/Transit Time) O 1   Used
Loop ID - N1 1        
  460 N1 Name (ship to) O 1   Used      
  470 N3 Address Information O 1   Used      
  480 N4 Geographic Location O >1   Used      
Loop ID - N1 1        
  490 N1 Name (bill to) O 1   Used      
  500 N3 Address Information O 1   Used      
  510 N4 Geographic Location O >1   Used      
Loop ID - N1 1        
  520 N1 Name (buyer) O 1   Used      
 
Detail:
  Pos Id Segment Name Req Max Use Repeat Notes Usage                                        
Loop ID - PO1 100000        
  030 PO1 Baseline Item Data M 1 N2/030 Used      
Loop ID - CTP >1            
  090 CTP Pricing Information O 1   Used          
Loop ID - PID 1            
  130 PID Product/Item Description (ticket description) O 1   Used          
Loop ID - PID 1            
  130 PID Product/Item Description (karat) O 1   Used          
  290 SDQ Destination Quantity O 500   Used      
 
Summary:
  Pos Id Segment Name Req Max Use Repeat Notes Usage                                        
Loop ID - CTT 1        
  010 CTT Transaction Totals O 1 N3/010 Used      
  030 SE Transaction Set Trailer M 1   Used
 
 



ST
Transaction Set Header .
Pos: 010 Max: 1
Heading - Mandatory
Loop: N/A Elements: 2
.

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

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  ST01 143 Transaction Set Identifier Code M ID 3/3 Used
      Description: Code uniquely identifying a Transaction Set
        Code Name_______________________________
      850 Purchase Order
  ST02 329 Transaction Set Control Number M AN 4/9 Used
      Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
 


BEG
Beginning Segment for Purchase Order .
Pos: 020 Max: 1
Heading - Mandatory
Loop: N/A Elements: 4
.

To indicate the beginning of the Purchase Order Transaction Set and transmit identifying numbers and dates

Comments:
1. The date indicated in the BEG04 is the date the PO was initiated, and not the final approval or send date.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  BEG01 353 Transaction Set Purpose Code M ID 2/2 Used
      Description: Code identifying purpose of transaction set
        Code Name_______________________________
      00 Original
      01 *Cancellation
      04 *Change
  BEG02 92 Purchase Order Type Code M ID 2/2 Used
      Description: Code specifying the type of Purchase Order
        Code Name_______________________________
      CN * Consigned Order
      CP * Change to Purchase Order
      LS * Lease
      NS * New Store Opening
      OS * Special Order
      PR * Promotion
      RR * Repair and Return
      SA Stand-alone Order
      SP * Sample
  BEG03 324 Purchase Order Number M AN 7/7 Used
      Description: Identifying number for the Purchase Order assigned by the Finlay system.
      : This value is required by Finlay in a PRF01 element on the 856 Advanced shipment Notice (Order Level, Item Level if master packed).

This value is required by Finlay in a BIG04 element on the 810 Invoice.
  BEG05 373 Date M DT 8/8 Must use
      Description: Date assigned by the Finlay system to Purchase Order, formatted as CCYYMMDD.
      : This value is required by Finlay in a PRF02 element on the 856 Advanced Shipment Notice (Order Level, Item Level if master packed).

This value is required by Finlay in a BIG03 element on the 810 Invoice.
 


REF
Reference Numbers (vendor number) .
Pos: 040 Max: 1
Heading - Optional
Loop: N/A Elements: 2
.

To specify identifying information

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  REF01 128 Reference Identification Qualifier M ID 2/2 Used
      Description: Code qualifying the Reference Identification
        Code Name_______________________________
      IA Internal Vendor Number
  REF02 127 Reference Number (vendor number) C AN 6/6 Used
      Description: Vendor number, assigned by Finlay.
      : This value is required by Finlay in a REF02 element on the 856 Advanced Shipment Notice (Order Level).

This value is required by Finlay in a N104 element on the 810 Invoice.
 


REF
Reference Numbers (order type) .
Pos: 050 Max: 1
Heading - Optional
Loop: N/A Elements: 2
.

To specify identifying information

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  REF01 128 Reference Identification Qualifier M ID 2/2 Used
      Description: Code qualifying the Reference Identification
        Code Name_______________________________
      MR Merchandise Type Code
  REF02 127 Reference Identification C AN 1/1 Used
      Description: Merchandise type code (A=Asset, M=Memo)
      : This value is required by Finlay in a REF02 element on the 810 Invoice.
 


REF
Reference Numbers (promotion type) .
Pos: 060 Max: 1
Heading - Optional
Loop: N/A Elements: 2
.

To specify identifying information

:


This PD qualified REF segment will only be present if order is for an ad or promotion.
Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  REF01 128 Reference Identification Qualifier M ID 2/2 Used
      Description: Code qualifying the Reference Identification
        Code Name_______________________________
      PD Promotion/Deal Number
  REF02 127 Reference Identification C AN 1/15 Used
      Description: Promotion - Ad type
 


CSH
Sales Requirements .
Pos: 120 Max: 5
Heading - Optional
Loop: N/A Elements: 1
.

To specify general conditions or requirements of the sale

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  CSH01 563 Sales Requirement Code O ID 1/1 Used
      Description: Code to identify a specific requirement or agreement of sale
        Code Name_______________________________
      N No Back Order
      Y Back Order if Out of Stock
 


SAC
Service, Promotion, Allowance, or Charge Information .
Pos: 140 Max: 1
Heading - Optional
Loop: SAC Elements: 3
.

To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

:

This segment will be sent only for special orders.
Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  SAC01 248 Allowance or Charge Indicator M ID 1/1 Must use
      Description: Code which indicates an allowance or charge for the service specified
        Code Name_______________________________
      R Allowance Request
  SAC03 559 Agency Qualifier Code C ID 2/2 Used
      Description: Code identifying the agency assigning the code values
        Code Name_______________________________
      VI Voluntary Inter-Industry Commerce Standard (VICS) EDI
  SAC04 1301 Agency Service, Promotion, Allowance, or Charge Code C AN 4/4 Used
      Description: Agency maintained code identifying the service, promotion, allowance, or charge.
      : Finlay will send "OHSO" (OHSO = special order)
 


DTM
Date/Time Reference (ship date) .
Pos: 190 Max: 1
Heading - Optional
Loop: N/A Elements: 2
.

To specify pertinent dates and times

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  DTM01 374 Date/Time Qualifier M ID 3/3 Used
      Description: Code specifying type of date or time, or both date and time
        Code Name_______________________________
      010 Requested Ship
  DTM02 373 Date C DT 8/8 Used
      Description: Requested Ship Date, expressed as CCYYMMDD
 


DTM
Date/Time Reference (cancel date) .
Pos: 200 Max: 1
Heading - Optional
Loop: N/A Elements: 2
.

To specify pertinent dates and times

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  DTM01 374 Date/Time Qualifier M ID 3/3 Used
      Description: Code specifying type of date or time, or both date and time
        Code Name_______________________________
      001 Cancel After
  DTM02 373 Date C DT 8/8 Used
      Description: Cancel After Date, expressed as CCYYMMDD
 


DTM
Date/Time Reference (promotion/ad date) .
Pos: 210 Max: 1
Heading - Optional
Loop: N/A Elements: 2
.

To specify pertinent dates and times

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  DTM01 374 Date/Time Qualifier M ID 3/3 Used
      Description: Code specifying type of date or time, or both date and time
        Code Name_______________________________
      015 Promotion Start
  DTM02 373 Date C DT 8/8 Used
      Description: Promotion or Ad Start Date, expressed as CCYYMMDD
 


TD5
Carrier Details (Routing Sequence/Transit Time) .
Pos: 300 Max: 1
Heading - Optional
Loop: N/A Elements: 1
.

To specify the carrier and sequence of routing and provide transit time information

Comments:
1. When specifying a routing sequence to be used for the shipment movement in lieu of specifying each carrier within the movement, use TD502 to identify the party responsible for defining the routing sequence, and use TD503 to identify the actual routing sequence, specified by the party identified in TD502.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  TD505 387 Routing C AN 1/17 Used
      Description: Free-form description of the routing or requested routing for shipment, or the originating carrier's identity
 


N1
Name (ship to) .
Pos: 460 Max: 1
Heading - Optional
Loop: N1 Elements: 4
.

To identify a party by type of organization, name, and code

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N101 98 Entity Identifier Code M ID 2/3 Used
      Description: Code identifying an organizational entity, a physical location, property or an individual
        Code Name_______________________________
      BS Bill and Ship To
      ST Ship To
  N102 93 Name C AN 1/35 Used
      Description: Free-form name
  N103 66 Identification Code Qualifier C ID 1/2 Used
      Description: Code designating the system/method of code structure used for Identification Code (67)
        Code Name_______________________________
      93 Code assigned by the organization originating the transaction set
  N104 67 Identification Code C AN 6/6 Used
      Description: Finlay's DC or Group/Branch location ID.
      : This value is required by Finlay in a N104 element on the 810 Invoice.
 


N3
Address Information .
Pos: 470 Max: 1
Heading - Optional
Loop: N1 Elements: 2
.

To specify the location of the named party

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N301 166 Address Information M AN 1/35 Used
      Description: Address information
  N302 166 Address Information O AN 1/35 Used
      Description: Address information
 


N4
Geographic Location .
Pos: 480 Max: >1
Heading - Optional
Loop: N1 Elements: 3
.

To specify the geographic place of the named party

Comments:
1. A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
2. N402 is required only if city name (N401) is in the U.S. or Canada.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N401 19 City Name O AN 2/25 Used
      Description: Free-form text for city name
  N402 156 State or Province Code O ID 2/2 Used
      Description: Code (Standard State/Province) as defined by appropriate government agency
  N403 116 Postal Code O ID 3/9 Used
      Description: Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
 


N1
Name (bill to) .
Pos: 490 Max: 1
Heading - Optional
Loop: N1 Elements: 4
.

To identify a party by type of organization, name, and code

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N101 98 Entity Identifier Code M ID 2/3 Used
      Description: Code identifying an organizational entity, a physical location, property or an individual
        Code Name_______________________________
      BT Bill-to-Party
  N102 93 Name C AN 1/35 Used
      Description: Free-form name
  N103 66 Identification Code Qualifier C ID 1/2 Used
      Description: Code designating the system/method of code structure used for Identification Code (67)
        Code Name_______________________________
      93 Code assigned by the organization originating the transaction set
  N104 67 Identification Code C AN 6/6 Used
      Description: Code identifying a party or other code
 


N3
Address Information .
Pos: 500 Max: 1
Heading - Optional
Loop: N1 Elements: 2
.

To specify the location of the named party

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N301 166 Address Information M AN 1/35 Used
      Description: Address information
  N302 166 Address Information O AN 1/35 Used
      Description: Address information
 


N4
Geographic Location .
Pos: 510 Max: >1
Heading - Optional
Loop: N1 Elements: 3
.

To specify the geographic place of the named party

Comments:
1. A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
2. N402 is required only if city name (N401) is in the U.S. or Canada.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N401 19 City Name O AN 2/25 Used
      Description: Free-form text for city name
  N402 156 State or Province Code O ID 2/2 Used
      Description: Code (Standard State/Province) as defined by appropriate government agency
  N403 116 Postal Code O ID 3/9 Used
      Description: Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
 


N1
Name (buyer) .
Pos: 520 Max: 1
Heading - Optional
Loop: N1 Elements: 4
.

To identify a party by type of organization, name, and code

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  N101 98 Entity Identifier Code M ID 2/2 Used
      Description: Code identifying an organizational entity, a physical location, property or an individual
        Code Name_______________________________
      BS Bill and Ship To
      ST Ship To
  N102 93 Name C AN 1/35 Used
      Description: Free-form name
  N103 66 Identification Code Qualifier C ID 1/2 Used
      Description: Code designating the system/method of code structure used for Identification Code (67)
        Code Name_______________________________
      93 Code assigned by the organization originating the transaction set
  N104 67 Identification Code C AN 6/6 Used
      Description: Code identifying a party or other code
 


PO1
Baseline Item Data .
Pos: 030 Max: 1
Detail - Mandatory
Loop: PO1 Elements: 8
.

To specify basic and most frequently used line item data

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  PO101 350 Assigned Identification O AN 4/4 Used
      Description: Line numbers assigned for differentiation within a transaction set
  PO102 330 Quantity Ordered C R 1/7 Used
      Description: Quantity ordered
  PO103 355 Unit or Basis for Measurement Code O ID 2/2 Used
      Description: Code specifying the units in which a value is being expressed.
        Code Name_______________________________
      EA Each
  PO104 212 Unit Price C R 1/10 Used
      Description: Price per unit of product, service, etc.
  PO106 235 Product/Service ID Qualifier C ID 2/2 Used
      Description: Code identifying Product/Service ID (234).
        Code Name_______________________________
      VA Vendor's Style Number
  PO107 234 Product/Service ID (vendor style) C AN 1/10 Used
      Description: Identifying number for a Finlay vendor's product or service.
  PO108 235 Product/Service ID Qualifier C ID 2/2 Used
      Description: Code identifying Product/Service ID (234).
        Code Name_______________________________
      IT Buyer's Style Number
  PO109 234 Product/Service ID C AN 9/9 Used
      Description: Finlay assigned short SKU identification number for this vendor product or service
 


CTP
Pricing Information .
Pos: 090 Max: 1
Detail - Optional
Loop: CTP Elements: 2
.

To specify pricing information

Comments:
1. See Figures Appendix for an example detailing the use of CTP03 and CTP04.
2. See Figures Appendix for an example detailing the use of CTP03, CTP04 and CTP07.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  CTP02 236 Price Identifier Code C ID 3/3 Used
      Description: Code identifying pricing specification
        Code Name_______________________________
      CAT Catalog Price
  CTP03 212 Unit Price C R 1/10 Used
      Description: Finlay's retail price per unit of product, service, etc.
 


PID
Product/Item Description (ticket description) .
Pos: 130 Max: 1
Detail - Optional
Loop: PID Elements: 3
.

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

Comments:
1. If PID01 equals "F", then PID05 is used. If PID01 equals "S", then PID04 is used. If PID01 equals "X", then both PID04 and PID05 are used.
2. Use PID06 when necessary to refer to the product surface or layer being described in the segment.
3. PID07 specifies the individual code list of the agency specified in PID03.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  PID01 349 Item Description Type M ID 1/1 Used
      Description: Code indicating the format of a description
        Code Name_______________________________
      F Free-form
  PID02 750 Product/Process Characteristic Code O ID 2/2 Used
      Description: Code identifying the general class of a product or process characteristic
        Code Name_______________________________
      75 Buyer's Color Description
      91 * Buyer's Item Size Description
  PID05 352 Description C AN 2/11 Used
      Description: Finlay's ticket description for item.
 


PID
Product/Item Description (karat) .
Pos: 130 Max: 1
Detail - Optional
Loop: PID Elements: 3
.

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

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  PID01 349 Item Description Type M ID 1/1 Used
      Description: Code indicating the format of a description
        Code Name_______________________________
      F Free-form
  PID02 750 Product/Process Characteristic Code O ID 2/2 Used
      Description: Code identifying the general class of a product or process characteristic
        Code Name_______________________________
      10 Major Grade
      13 Quality (Quality Level)
      38 Grade
      75 Buyer's Color Description
      91 * Buyer's Item Size Description
  PID05 352 Description C AN 2/2 Used
      Description: Karat classification.
 


SDQ
Destination Quantity .
Pos: 290 Max: 500
Detail - Optional
Loop: PO1 Elements: 4
.

To specify destination and quantity detail

Comments:
1. Finlay may send up to element pair SDQ13 and SDQ14, though only the element pair of SDQ03 and SDQ04 are indicated.
2. All location IDs, in any SDQ element, are required in "Z7" indicated N104 elements on 856 Advance Shipment Notices (Order level) and 810 Invoice.

:

Line item distribution via SDQ segments (cross-docking) is currently in use for watches and special situations for specific vendors. However, the ability to be capable of receiving this segment is advantageous and may be required of all vendors at some future time.
Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  SDQ01 355 Unit or Basis for Measurement Code M ID 2/2 Used
      Description: Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
        Code Name_______________________________
      EA Each
  SDQ02 66 Identification Code Qualifier O ID 1/2 Used
      Description: Code designating the system/method of code structure used for Identification Code (67)
        Code Name_______________________________
      92 Assigned by Buyer or Buyer's Agent
  SDQ03 67 Identification Code M AN 2/80 Used
      Description: Finlay's Group/Branch location ID.
      : This value is required by Finlay in a "Z7" identified N104 element on the 856 Advance Shipment Notice (Order level).

This value is required by Finlay in a "Z7" identified N104 element on the 810 Invoice.
  SDQ04 380 Quantity M R 1/7 Used
      Description: Numeric value of quantity
      :
Element pairs SDQ05/06 through SDQ13/14 may or may not be used, depending on the number of locations that the line item is being distributed to, and are not shown for clarity reasons.
.
.
.

 


CTT
Transaction Totals .
Pos: 010 Max: 1
Summary - Optional
Loop: CTT Elements: 1
.

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

Comments:
1. This segment is intended to provide hash totals to validate transaction completeness and correctness.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  CTT01 354 Number of Line Items M N0 1/6 Must use
      Description: Total number of line items in the transaction set
 


SE
Transaction Set Trailer .
Pos: 030 Max: 1
Summary - Mandatory
Loop: N/A Elements: 2
.

To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

Comments:
1. SE is the last segment of each transaction set.

Element Summary:

                   
  _Ref_ Id _____________Element Name_____________ Req Type Min/Max ___Usage___
  SE01 96 Number of Included Segments M N0 1/10 Used
      Description: Total number of segments included in a transaction set including ST and SE segments
  SE02 329 Transaction Set Control Number M AN 4/9 Used
      Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set