Menu

Spend Reporting Codes

Table of Country Codes

Used in Column K in an Excel file or in Field 11 of the Customer file in a Text submission. See the entire list based on the ISO-3166-1-alpha-3 standard on Wikipedia.
Country Country Code Country Country Code
United States USA Canada CAN
Mexico MEX Anguilla AIA
Antigua and Barbuda ATG Aruba ABW
Bahamas BHS Barbados BRB
Belize BLZ Bermuda BMU
Cayman Islands CYM Costa Rica CRI
Cuba CUB Dominica DMA
Dominican Republic DOM El Salvador SLV
Grenada GRD Guadeloupe GLP
Guatemala GTM Haiti HTI
Honduras HND Jamaica JAM
Martinique MTQ Montserrat MSR
Panama PAN Puerto Rico PRI
Saint Kitts and Nevis KNA Saint Lucia LCA
Saint Vincent and The Grenadines VCT St. Pierre and Miquelon SPM
Trinidad and Tobago TTO Turks And Caicos Islands TCA
Virgin Islands (British) VGB Virgin Islands (U.S.) VIR

 

A Table of Currency Codes

Used in Column AA in an Excel file or in Field 12 of the Usage file in a Text submission. See the entire list based on the ISO 4217 standard on Wikipedia.
Currency Currency Code Currency Currency Code
United States Dollar USD Canadian Dollar CAD
Mexican Peso MXN Netherlands Antillies Guilder ANG
Aruban Florin AWG Barbados Dollar BMD
Bermudian Dollar BMD Bahamian Dollar BSD
Belize Dollar BZD Costa Rican Colon CRC
Cuban Peso CUP/CUC Dominican Republic Peso DOP
European Euro EUR Guatemalan Quetzal GTQ
Honduran Lempira HNL Haitain Gourde HTG
Jamaican Dollar JMD Cayman Islands Dollar KYD
Panamanian Balboa PAB Trinidad & Tobago Dollar TTD
Eastern Caribbean Dollar XCD

 

A Table of Unit of Measure Description Codes

Used in Column T in an Excel file or in Field 12 of the Item file in a Text submission.
Unit of Measure Description UOM Code Unit of Measure Description UOM Code
Box BX Case CS
Count CT Decatherm DTH
Dozen DZ Each EA
Feet FT Gallon GL
Gram GM Half Gallon HGL
Half Pint HPT Hour HR
Inch IN Kilogram KG
Kilowatt KW Liter LTR
Megawatt-Hour MWH Milliliter ML
Ounce OZ Pack PCK
Pair PR Pint PT
Pound LB Quart QT
Roll RL Service SRV
Tin or Can TIN Ton T
Yard YD

 

A Table of Indicator Codes

Quantity Indicator Codes are used in Column W in an Excel file or in Field 8 of the Usage file in a Text submission. Valid Weight Shipped Indicator Codes are highlighed in yellow below. Weight Shipped Indicator Codes are used in Column X in an Excel file or in Field 10 of the Usage file in a Text submission
Pack Unit Equivalent Indicator Pack Unit Equivalent Indicator
100 Case C Half Bushel Each E
1000 Case C Half Case Half Case HC
10# or 10 LB 10# TP Half Gallon Each E
5 Gallon 5 Gallon 5G Head Each E
5# or 5LB 5# 5P Inch Inch IN
Bag Case C Kilogram Kilogram K
Basket Case C Liter Liter L
Block Each E Meter Meter M
Bottle Each E Metric Ton Metric Ton MT
Box Case C MilliLiter MilliLiter ML
Bucket Case C Ounce Ounce OZ
Bunch Each E Package Each E
Bundle Each E Packet Each E
Bushel Case C Pair Pair PR
Can Each E Pallet Pallet PA
Carton Case C Piece Each E
Case Case C Pint Pint PT
Count Each E Pouch Each E
Crate Case C Pound Pound P
Cubic Foot Cubic Foot CF Quart Quart QT
Cubic Yard Cubic Yard CY Quarter Each E
Dozen Dozen D Roll Each E
Each Each E Service Service SRV
Feet Feet FT Set Each E
Flat Case C Tin Each E
Gallon Gallon G Ton Ton T
Gram Gram GR Tray Case C
Gross Gross R Tub Gallon G
Unit Each E
Yard Yard Y