Mapping Data Identifiers to Application Identifiers

 

The user of these mapping tables are provided a word of caution. Application Identifiers, for the most part, have a specific length and format of the data. Data Identifiers, for the most part, do NOT have a specific length and format of the data.

Data
Identifier

Description

Application
Identifier

Category 1

Reserved

A-999A Reserved

Category 2

Container Information

B Container Type (internally assigned or mutually defined) No Equivalent
1B Returnable container identification code assigned by the container owner or the appropriate regulatory agency or (e.g., a metal tub, basket, reel, unit load device (ULD), trailer, tank, or intermodal container) (excludes gas cylinders See "2B") 8003 or 8004
2B Gas Cylinder Container Identification Code assigned by the manufacturer in conformance with U.S. Department of Transportation (D.O.T.) standards. No Equivalent
3B Motor Freight Transport Equipment Identification Code assigned by the manufacturer in conformance with International Standards Organization (ISO) standards. No Equivalent
4B-999B Reserved

Category 3

Field Continuation

C Continuation of an Item Code (Category 16) assigned by Customer that is too long for a required field size No Equivalent
1C Continuation of Traceability Code (Category 20) assigned by Supplier No Equivalent
2C Continuation of Serial Number (Category 19) assigned by Supplier No Equivalent
3C Continuation of Free Text (Category 26) mutually defined between Supplier/Carrier/Customer No Equivalent
4C Continuation of Transaction Reference (Category 11) mutually defined between Supplier/Carrier/Customer No Equivalent
5C Continuation of Item Code (Category 16) Assigned by Supplier No Equivalent
6C- 999C Reserved

Category 4

Date

D Format YYMMDD (Significance of Data Mutually Defined) No Equivalent
1D Format DDMMYY (Significance of Data Mutually Defined) No Equivalent
2D Format MMDDYY (Significance of Data Mutually Defined) No Equivalent
3D Format YDDD (Julian) (Significance of Data Mutually Defined) No Equivalent
4D Format YYMMDD (Significance of Data Mutually Defined) No Equivalent
5D ISO format YYMMDD immediately followed by an ANSI X12.3 Data Element Number 374 Qualifier providing a code specifying type of date (e.g., ship date, manufacture date) No Equivalent
5D...405 Production Date (YYMMDD) 11
5D...836 Expiration Date (YYMMDD) 17
No Equivalent Packaging Date (YYMMDD) 13
No Equivalent Best Before/Sell By Date (Quality) (YYMMDD) 15
6D ISO format YYYYMMDD immediately followed by an ANSI X12.3 Data Element Number 374 Qualifier providing a code specifying type of date (e.g., ship date, manufacture date) No Equivalent
7D Format MMYY(Significance of Data Mutually Defined) No Equivalent
8D Reserved
9D Date (structure and significance mutually defined) No Equivalent
10D Format YYWW (Significance of Data Mutually Defined) No Equivalent
11D Format YYYYWW (Significance of Data Mutually Defined) No Equivalent
12D Format YYYYMMDD (Significance of Data Mutually Defined) No Equivalent
13D-999D Reserved

Category 5

Reserved

E - 999E Reserved

Category 6

Reserved

F - 999F Reserved

Category 7

Reserved

G - 999G Reserved

Category 8

Human Resources

H Reserved
1H Employee Identification Code assigned by employer No Equivalent
2H U.S. Social Security Number No Equivalent
3H ID Number for non-employee (internally assigned or mutually defined) (e.g., contract workers, vendors, service, and delivery personnel) No Equivalent
4H National Social Security Number No Equivalent
5H - 999H Reserved

Category 9

Reserved

I U.S. Vehicle Identification Number - VIN No Equivalent
1I Abbreviated VIN Code No Equivalent
3I - 999I Not recommended for use due to similarity of "1" to "I" - Reserved

Category 10

License Plate

J Unique license plate number* 00
1J Unique license plate number* assigned to a transport unit which is the lowest level of packaging, the unbreakable unit. 00
2J Unique license plate number* assigned to a transport unit which contains multiple packages. 00
3J Unique license plate number* assigned to a transport unit which is the lowest level of packaging, the unbreakable unit and which has EDI data associated with the unit 00
4J Unique license plate number* assigned to a transport unit which contains multiple packages and which is associated with EDI data. 00
*Note: For a license plate number to be unique world wide requires: 1) A unique number assigned by the trading partner, 2) A unique code assigned to the trading partner by an organization, and 3) A unique code providing global identification of the assigning organization.
5J - 999J Reserved

Category 11

Transaction Reference Used in Trading Relationships

K Order number assigned by Customer to identify a Purchasing Transaction (e.g., purchase order number) 400
1K Order number assigned by Supplier to identify a Purchasing Transaction No Equivalent
2K Bill of Lading/Waybill/Shipment Identification Code assigned by Supplier/Shipper No Equivalent
3K Bill of Lading/Waybill/Shipment Identification Code assigned by Carrier No Equivalent
4K Line number of the order assigned by Customer to identify a Purchasing Transaction 400
5K Reference number assigned by the Customer to identify a Shipment Authorization (Release) against an established Purchase Order 400
6K PRO# Assigned by Carrier No Equivalent
7K Carrier Mode in Free Text format mutually defined between Customer and Supplier (e.g., Air, Truck, Boat, Rail) No Equivalent
8K Contract Number No Equivalent
9K Generic Transaction Reference Code (internally assigned or mutually defined) No Equivalent
10K Invoice Number No Equivalent
11K Packing List Number No Equivalent
12K SCAC (Standard Carrier Alpha Code) (an4 - dash "-" filled left) and carrier assigned PROgressive number No Equivalent
13K Reserved
14K Combined Order Number and Line Number in the format nn...nn+nn...n where a plus symbol (+) is used as a delimiter between the Order Number and Line Number. 400
15K KANBAN Number No Equivalent
16K DELINS Number: code assigned to identify a document which contains delivery information No Equivalent
17K Check Number No Equivalent
18K - 999K Reserved

Data
Identifier

Description

Application
Identifier

Category 12

Location Reference

L Storage Location No Equivalent
1L Location No Equivalent
2L Ship To: Location code defined by an industry standard or mutually defined 410
3L Ship From: Location code defined by an industry standard or mutually defined No Equivalent
No Equivalent Bill To (Invoice To) Location Code Using EAN-13 411
No Equivalent Purchase From (Location Code of Party from Whom Goods are Purchased) Location Code Using EAN-13 412
4L Country of Origin, two-character ISO 3166 country code See Next Entry
See Prior Entry Country of Origin, three-digit ISO 3166 country code 422
5L Ship For: Location code defined by an industry standard or mutually defined 413
6L Route Code assigned by the supplier to designate a specific transportation path No Equivalent
No Equivalent UPC/EAN Location Code for Physical Identification 414
7L - 19L Reserved
The following identifiers can be used to provide for Location identification which is different than or in addition to Location Reference provided by "L".
20L First Level (internally assigned) No Equivalent
21L Second Level (internally assigned) No Equivalent
22L Third Level (internally assigned) No Equivalent
23L Fourth Level (internally assigned) No Equivalent
24L Fifth Level (internally assigned) No Equivalent
25L - 50L Reserved
The following two identifiers are to be used for shipments within the jurisdiction of a single postal authority.
51L Ship From: - Location code defined by a postal authority (e.g., 5-digit and 9-digit ZIP codes identifying U.S. locations or 6-character postal codes identifying Canadian locations) No Equivalent
52L Ship To: - Location code defined by a postal authority (e.g., 5-digit and 9-digit ZIP codes identifying U.S. locations or 6-character postal codes identifying Canadian locations) 420
53L Reserved
The following identifiers are to be used for shipments between locations governed by different postal authorities
54L Ship From: - Location code defined by a postal authority in the format: postal code (e.g., 5-digit ZIP codes identifying U.S. locations or 6- or 7-character postal codes identifying United Kingdom locations) followed by two character ISO 3166 country code No Equivalent
55L Ship To: - Location code defined by a postal authority in the format: postal code (e.g., 5-digit ZIP codes identifying U.S. locations or 6- or 7-character postal codes identifying United Kingdom locations) No Equivalent
No Equivalent Ship To: - Location code defined by a postal authority in the format: postal code followed by three digit ISO 3166 country code (e.g., a 5-digit ZIP codes identifying U.S. locations or 6- or 7-character postal codes identifying United Kingdom locations) 421
56L - 999L Reserved

Category 13

Reserved

M - 999M Reserved

Category 14

Industry Assigned Codes

N National/NATO Stock Number (NSN) No Equivalent
1N Product Characteristic Data defined by the Chemical Industry Data Exchange (CIDX) No Equivalent
2N Reserved
3N Coding Structure in Accordance with Format Defined by Electronic Industries Association Japan (EIA-J) No Equivalent
4N EAN/UCC Application Identifiers (AI plus data) EAN/UCC AIs
5N - 999N Reserved

Category 15

Reserved

O - 999O Reserved. Not recommended for use due to similarity of "0" (zero) to "O"

Category 16

Item Identification

P Item Identification Code assigned by Customer 241
1P Item Identification Code assigned by Supplier No Equivalent
2P Code assigned to specify the revision level for an Item (e.g., engineering change level, edition, or revision) No Equivalent
3P Combined manufacturer identification code/item code under the 12/13-digit EAN/UCC formats, plus supplemental codes, if any U.P.C./EAN
No Equivalent Roll products - Width, Length, Core Diameter, Direction, & Splices 8001
4P Item Code portion of EAN/UCC formats No Equivalent
5P Freight Classification Item Number assigned by Carrier for purposes of rating hazardous materials (e.g., Motor, Freight, Air, Boat, Rail Classification) No Equivalent
6P Combined supplier identification and item code (internally assigned or mutually defined) No Equivalent
7P Common Language Equipment Identification (CLEI) assigned by the manufacturer to some telecommunications equipment No Equivalent
8P 14-digit EAN/UCC format for SCC-14 code structure 01
9P Reserved
10P Hazardous Material Code as defined by ANSI X12.3 in the format Data Element 208 (1-character code qualifier) followed by Data Element 209 (Hazardous Material Code) No Equivalent
11P Reserved
12P Document Type (e.g., Pick List, Design Drawing, etc.) (internally assigned or mutually defined) No Equivalent
13P VMRS System Code No Equivalent
14P VMRS System and Assembly Code No Equivalent
15P VMRS System, Assembly, & Part Code No Equivalent
16P VMRS System, Assembly, or Part Code (User Modified) No Equivalent
17P Combined UCC supplier identification and item code assigned by the supplier 01
18P Combined VMRS supplier ID and supplier assigned part number No Equivalent
19P Reserved

+

HIBCC - Quantity, Date, Batch, and Link 22
No Equivalent Product Variant 20
The following five identifiers can be used to provide for Item identification (Item ID) which is different than or in addition to Item ID provided by "P".
20P First Level (Customer Assigned) No Equivalent
21P Second Level (Customer Assigned) No Equivalent
22P Third Level (Customer Assigned) No Equivalent
23P Fourth Level (Customer Assigned) No Equivalent
24P Fifth Level (Customer Assigned) No Equivalent
25P - 29P Reserved
The following five identifiers can be used to provide for Item identification (Item ID) which is different than or in addition to Item ID provided by "1P".
30P First Level (Supplier Assigned) No Equivalent
31P Second Level (Supplier Assigned) No Equivalent
32P Third Level (Supplier Assigned) No Equivalent
33P Fourth Level (Supplier Assigned) No Equivalent
34P Fifth Level (Supplier Assigned) No Equivalent
35P - 999P Reserved

Data
Identifier

Description

Application
Identifier

Category 17

Measurement

Q Quantity, Number of Pieces, or Amount (numeric only) (unit of measure and significance mutually defined) 30
1Q Theoretical Length/Weight (numeric only) No Equivalent
2Q Actual Weight (numeric only) No Equivalent
3Q Unit of Measure, as defined by the two character ANSI X12.3 Data Element Number 355 Unit of Measurement Code No Equivalent
4Q Gross Amount No Equivalent
5Q Net Amount No Equivalent
6Q Reserved
7Q Quantity, Amount, or Number of Pieces in the format: Quantity followed by the two character ANSI X12.3 Data Element Number 355 Unit of Measurement Code No Equivalent
7Q...58 Net Weight, Kilograms 310
7Q...MR Length or 1st Dimension, Meters 311 or 331
7Q...MR Width, Diameter, or 2nd Dimension, Meters 312 or 332
7Q...MR Depth, Height, or Thickness or 3rd Dimension, Meters 313 or 333
7Q...SM Area, Square Meters 314 or 334
7Q...LT Volume, Liters 315 or 335
7Q...CO Volume, Cubic Meters (Net) 316
7Q...CR Volume, Cubic Meters (Gross) 336
7Q...PN Net Weight, Pounds 320
7Q...ED Length or 1st Dimension, Inches 321 or 341
7Q...EZ Length or 1st Dimension, Feet 322 or 342
7Q...YD Length or 1st Dimension, Yards 323
7Q...GY Length or 1st Dimension, Yards (Gross) 343
7Q...ED Width, Diameter, or 2nd Dimension, Inches 324 or 344
7Q...EZ Width, Diameter, or 2nd Dimension, Feet 325 or 345
7Q...YD Width, Diameter, or 2nd Dimension, Yards 326
7Q...GY Width, Diameter, or 2nd Dimension, Yards (Gross) 346
7Q...ED Depth, Thickness, Height or 3rd Dimension, Inches 327 or 347
7Q...EZ Depth, Thickness, Height or 3rd Dimension, Feet 328 or 348
7Q...YD Depth, Thickness, Height or 3rd Dimension, Yards 329
7Q...GY Depth, Thickness, Height or 3rd Dimension, Yards (Gross) 349
7Q...GT Gross Weight, Kilograms 330
7Q...KM Kilograms per Square Meter 337
7Q...PG Gross Weight, Pounds 340
7Q...SI Area, Square Inches 350 or 353
7Q...SF Area, Square Feet 351 or 354
7Q...SY Area, Square Yards 352 or 355
7Q...TO Net Weight, Troy Ounces 356
7Q...OZ Net Weight, Ounces 357
7Q...QT Volume, Quarts 360 or 362
7Q...GA Volume, Gallons 361
7Q...GN Volume, Gallons (Gross) 363
7Q...CI Volume, Cubic Inches 364 or 367
7Q...CF Volume, Cubic Feet 365 or 368
7Q...CY Volume, Cubic Yards 366 or 369
8Q Reserved
9Q Piece Weight: weight of a single item No Equivalent
10Q Reserved
11Q Tare Weight: weight of an empty container No Equivalent
12Q Monetary Value established by the Supplier in the format of: the value followed by an ISO 4217 data element code for representing unit of value of currencies and funds (e.g., 12Q2.50USD) (2.50 Monetary Value No Equivalent
13Q # of # ("this is the nth piece of x pieces in this shipment"). Presented in the format "n/x", where the "/" (slash) is used as a delimiter between two values. No Equivalent
14Q Beginning Secondary Quantity No Equivalent
15Q Ending Secondary Quantity No Equivalent
16Q - 999Q Reserved

Category 18

Miscellaneous

R Reserved
1R Return Authorization Code (RMA) assigned by the Supplier No Equivalent
2R Return Code assigned by the Customer No Equivalent
3R - 999R Reserved

Data
Identifier

Description

Application
Identifier

Category 19

Traceability Number for an Entity

S Serial number or code assigned by the Supplier to an entity for its lifetime, (e.g., computer serial number, traceability number, contract tool identification) 21
1S Additional code assigned by the Supplier to an entity for its lifetime (e.g., traceability number, computer serial number) No Equivalent
2S Advance Shipment Notification (ASN) Shipment ID corresponds to ANSI ASC X12 Data Element 396 and BGM 351 UN/EDIFACT Data Elements No Equivalent
3S Unique Package Identification assigned by Supplier (lowest level of packaging which has a package ID code; shall contain like items) No Equivalent
4S Package Identification assigned by Supplier to master packaging containing like items on a single customer order No Equivalent
5S Package Identification assigned by Supplier to master packaging containing unlike items on a single customer order No Equivalent
6S Package Identification assigned by Supplier to master packaging containing like items over multiple customer orders No Equivalent
7S Package Identification assigned by Supplier to master packaging containing unlike items over multiple customer orders No Equivalent
8S Supplier ID/Unique Container ID presented in the data format specified by the EAN/UCC SSCC-18 00
9S Package Identification, Generic (mutually defined) No Equivalent
10S Machine, cell, or tool ID code No Equivalent
11S Fixed asset ID code No Equivalent
12S Document Number (internally assigned or mutually defined) No Equivalent
13S Container Security Seal No Equivalent
14S 4th Class Non-identical parcel post manifesting No Equivalent
15S Serial Number Assigned by the Vendor Entity, that can only be used in conjunction with "13V" No Equivalent
16S Reserved
17S Combined UCC supplier identification and unique package identification assigned by the supplier No Equivalent
18S Reserved
19S Combined Dun & Bradstreet company identification of the supplier followed by a unique package identification assigned by the supplier, in the format nn...nn+nn...n where a plus symbol (+) is used as a delimiter between the DUNS Number and unique package No Equivalent
20S Traceability code for an entity assigned by the customer No Equivalent
21S Combined U.S. D.O.T. Tire Manufacturer Plant Code and unique tire identification assigned by the supplier No Equivalent
22S Electronic Serial Number for Cellular Mobile Telephones 8002
23S - 29S Reserved
30S Additional traceability code for an entity assigned by the supplier in addition to or different from the traceability code(s) provided by "S" or "1S" 250
31S Beginning Serial Number for serial numbers in sequence No Equivalent
32S Ending Serial Number for serial numbers in sequence No Equivalent
33S - 999S Reserved

Category 20

Traceability Number for a Group of Entities

T Traceability Number assigned by the Customer to identify/trace a unique group of entities (e.g., lot, batch, heat) No Equivalent
No Equivalent Lot Number (Transitional Use) 23
1T Traceability Number assigned by the Supplier to identify/trace a unique group of entities, (e.g., lot, batch, heat) 10
2T Reserved
3T U.S. EPA vehicle identification for emissions testing) No Equivalent
4T - 19 T Reserved
The following five identifiers can be used to provide for identification of a group of entities which is different than or in addition to identification provided by "T".
20T First Level (Customer Assigned) No Equivalent
21T Second Level (Customer Assigned) No Equivalent
22T Third Level (Customer Assigned) No Equivalent
23T Fourth Level (Customer Assigned) No Equivalent
24T Fifth Level (Customer Assigned) No Equivalent
25T - 29T Reserved
The following five identifiers can be used to provide for identification of a group of entities which is different than or in addition to identification provided by "1T".
30T First Level (Supplier Assigned) No Equivalent
31T Second Level (Supplier Assigned) No Equivalent
32T Third Level (Supplier Assigned) No Equivalent
33T Fourth Level (Supplier Assigned) No Equivalent
34T Fifth Level (Supplier Assigned) No Equivalent
35T - 999T Reserved

š4*q9 UYkmO7E%TyxM:QOU[ei:\e!Yͩ}!1)aI9-v R9(JaG_%)겍8CE>?Er=((AuY1 *a;H O#mFYN~MArF fhM85xɸNJ'B!Gge\n/~]#fxCC )2dN.qXtNމm C %y WyQ]U\riEq́ Z.ŬYf}p1yPI9M-to9LԦC)׍oEɓmI=-|#{u9 z fajY4@:w] ZyvMA" ?P%5K!^we(r]6es[@ l̷Tp˽ qV,DŽӉJvm4ϴ4%PyydGY-Q[UifP _@Y9!}?FI-5cS9?XSĈ )8A3wE==6 }/uɀ }a !KCZպ4L,M|ǜAaetJ`V=54sd5}8!\'eX<]rto0t q[p_VHjÝqmkm0@~o%IFyQD͍܅ZD^Y`4}1_IҰ-y:BC99ݠb‘/)ssMDEWv_k=yC0u ? 2C a&.UW eXM:A^|Z ౓u5(9ḒyW!?oesj繄]na쭵Fp xZ*Qʼb qm-+ffm*8g.%VyrQɛ'Ui4ae`Y}31c,7I(-v1~刂9j#A^X)ZCyEm=S u{, 9 EaU Z {<x_M`[MAftRWXmr5bj!ske!T]`'!~ di=H%:p;q@m חz%y5AQBU>^Gi/S1͓/74ˋaYk}b1ZaGxIf-ߡ s<9- ݆- mf/)A <sE ?d#=U yu @^aY6DfĦ+чV[&_uMAp~vZىpxQ35rEɩg!eI2[2M]_Τb@ Q0߳?Eaq1oomB]{L%|ry0}KߗQGmU{iJ+_T;H]Yk}5t1!0BbR#I-t-̡^(9/?/`h)(܍B?7E[fg=D u1. GJaQasRFVl lMIAKu3AB.015Pwb,!g;:&oqPi&*,m{:*W%Wy̿ QU4NIi}k͙SғQ~YQ0MA %QJֱ657?­s!0e]-]B8 E8 p]Rȯqq#ÉCm0 +%yp%fQ0Uwih~VC

Data
Identifier

Description

Application
Identifier

Category 21

Reserved

U - 999U Reserved

Category 22

Party to the Transaction

V Supplier Code assigned by Customer No Equivalent
1V Supplier Code assigned by Supplier No Equivalent
2V 6-digit Company Prefix as assigned by the Uniform Code Council (UCC) No Equivalent
3V Company Prefix as assigned by the appropriate EAN International (EAN) Numbering Organization No Equivalent
4V Carrier Identification Code assigned by an industry standard mutually defined by the Supplier, Carrier, and Customer No Equivalent
5V Financial Institution Identification Code (mutually defined) No Equivalent
6V Manufacturer's identification code (mutually defined) No Equivalent
7V Code assigned to a party which has financial liability for an entity or group of entities (e.g., owner of inventory) (mutually defined) No Equivalent
8V Customer code assigned by the customer No Equivalent
9V Customer code assigned by the supplier No Equivalent
10V Reserved
11V Organization with budget responsibility for an entity, process, or procedure (e.g., shop, division, department)(internally assigned) No Equivalent
12V DUNS number identifying manufacturer No Equivalent
13V DUNS number identifying supplier No Equivalent
14V DUNS number identifying customer No Equivalent
15V Carrier-assigned shipper number No Equivalent
16V VMRS Supplier ID No Equivalent
17V U.S. DoD CAGE Number No Equivalent
18V - 999V Reserved

Category 23

Activity Reference

W Work Order Number (e.g., "Production Paper") (internally assigned) No Equivalent
1W Operation Sequence Number No Equivalent
2W Operation Code/Work Code - the type of work to be performed (internally assigned or mutually defined) No Equivalent
3W Combined Work Order Number and Operation Sequence Number in the format nn...n+nn...n where a plus symbol (+) is used as a delimiter between the Work Order Number and the Operation Sequence Number No Equivalent
4W Status Code (internally assigned or mutually defined) No Equivalent
5W - 999W Reserved