X12 810 Invoice

X12 Release 4010

This Draft Standard for Trial Use contains the format and establishes the data contents of the Invoice Transaction Set (810) 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 billing for goods and services provided.

Delimiters

• ~ Segment
• * Element
• > Component

ISA

Interchange Control Header

RequiredMax use 1

To start and identify an interchange of zero or more functional groups and interchange-related control segments

ISA-01 · I01 · Authorization Information Qualifier · Required · Code to identify the type of information in the Authorization Information · 00 No Authorization Information Present (No Meaningful Information in I02)

ISA-02 · I02 · Authorization Information · Required Min 10 Max 10 · Information used for additional identification or authorization of the interchange sender or the data in the interchange; the type of information is set by the Authorization Information Qualifier (I01)

ISA-03 · I03 · Security Information Qualifier · Required · Code to identify the type of information in the Security Information · 00 No Security Information Present (No Meaningful Information in I04)

ISA-04 · I04 · Security Information · Required Min 10 Max 10 · This is used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier (I03)

ISA-05 · I05 · Interchange ID Qualifier · Required Min 2 Max 2 · Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified · Codes 01 Duns (Dun & Bradstreet) 02 SCAC (Standard Carrier Alpha Code) 03 FMC (Federal Maritime Commission) 04 IATA (International Air Transport Association) 08 UCC EDI Communications ID (Comm ID) 09 X.121 (CCITT) 10 Department of Defense (DoD) Activity Address Code 11 DEA (Drug Enforcement Administration) 12 Phone (Telephone Companies) 13 UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code) 14 Duns Plus Suffix 15 Petroleum Accountants Society of Canada Company Code 16 Duns Number With 4-Character Suffix 17 American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit) 18 Association of American Railroads (AAR) Standard Distribution Code 19 EDI Council of Australia (EDICA) Communications ID Number (COMM ID) 20 Health Industry Number (HIN) 21 Integrated Postsecondary Education Data System, or (IPEDS) 22 Federal Interagency Commission on Education, or FICE 23 National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES 24 The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP 25 American College Testing Program 4-Digit Code of Postsecondary Institutions, or ACT 26 Statistics of Canada List of Postsecondary Institutions 27 Carrier Identification Number as assigned by Health Care Financing Administration (HCFA) 28 Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA) 29 Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA) 30 U.S. Federal Tax Identification Number 31 Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC) 32 U.S. Federal Employer Identification Number (FEIN) 33 National Association of Insurance Commissioners Company Code (NAIC) 34 Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA) 35 Statistics Canada Canadian College Student Information System Institution Codes 36 Statistics Canada University Student Information System Institution Codes 37 Society of Property Information Compilers and Analysts AM Association Mexicana del Codigo de Producto (AMECOP) Communication ID NR National Retail Merchants Association (NRMA) - Assigned SN Standard Address Number ZZ Mutually Defined

ISA-06 · I06 · Interchange Sender ID · Required Min 15 Max 15 · Identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element

ISA-07 · I05 · Interchange ID Qualifier · Required Min 2 Max 2 · Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified · Codes 01 Duns (Dun & Bradstreet) 02 SCAC (Standard Carrier Alpha Code) 03 FMC (Federal Maritime Commission) 04 IATA (International Air Transport Association) 08 UCC EDI Communications ID (Comm ID) 09 X.121 (CCITT) 10 Department of Defense (DoD) Activity Address Code 11 DEA (Drug Enforcement Administration) 12 Phone (Telephone Companies) 13 UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code) 14 Duns Plus Suffix 15 Petroleum Accountants Society of Canada Company Code 16 Duns Number With 4-Character Suffix 17 American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit) 18 Association of American Railroads (AAR) Standard Distribution Code 19 EDI Council of Australia (EDICA) Communications ID Number (COMM ID) 20 Health Industry Number (HIN) 21 Integrated Postsecondary Education Data System, or (IPEDS) 22 Federal Interagency Commission on Education, or FICE 23 National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES 24 The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP 25 American College Testing Program 4-Digit Code of Postsecondary Institutions, or ACT 26 Statistics of Canada List of Postsecondary Institutions 27 Carrier Identification Number as assigned by Health Care Financing Administration (HCFA) 28 Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA) 29 Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA) 30 U.S. Federal Tax Identification Number 31 Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC) 32 U.S. Federal Employer Identification Number (FEIN) 33 National Association of Insurance Commissioners Company Code (NAIC) 34 Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA) 35 Statistics Canada Canadian College Student Information System Institution Codes 36 Statistics Canada University Student Information System Institution Codes 37 Society of Property Information Compilers and Analysts AM Association Mexicana del Codigo de Producto (AMECOP) Communication ID NR National Retail Merchants Association (NRMA) - Assigned SN Standard Address Number ZZ Mutually Defined

ISA-08 · I07 · Interchange Receiver ID · Required Min 15 Max 15 · Identification code published by the receiver of the data; When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them

ISA-09 · I08 · Interchange Date · Required YYMMDD format · Date of the interchange

ISA-10 · I09 · Interchange Time · Required HHMM format · Time of the interchange

ISA-11 · I10 · Interchange Control Standards Identifier · Required · Code to identify the agency responsible for the control standard used by the message that is enclosed by the interchange header and trailer · U U.S. EDI Community of ASC X12, TDCC, and UCS

ISA-12 · I11 · Interchange Control Version Number · Required · This version number covers the interchange control segments · 00401 Draft Standards for Trial Use Approved for Publication by ASC X12 Procedures Review Board through October 1997

ISA-13 · I12 · Interchange Control Number · Required Min 9 Max 9 · A control number assigned by the interchange sender

ISA-14 · I13 · Acknowledgment Requested · Required Min 1 Max 1 · Code sent by the sender to request an interchange acknowledgment (TA1) · 0 No Acknowledgment Requested 1 Interchange Acknowledgment Requested

ISA-15 · I14 · Usage Indicator · Required Min 1 Max 1 · Code to indicate whether data enclosed by this interchange envelope is test, production or information · I Information P Production Data T Test Data

ISA-16 · I15 · Component Element Separator · Required Min 1 Max 1 · Type is not applicable; the component element separator is a delimiter and not a data element; this field provides the delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator · > Component Element Separator

GS

Functional Group Header

RequiredMax use 1

To indicate the beginning of a functional group and to provide control information

GS-01 · 479 · Functional Identifier Code · Required · Code identifying a group of application related transaction sets · IN Invoice Information (810,819)

GS-02 · 142 · Application Sender's Code · Required Min 2 Max 15 · Code identifying party sending transmission; codes agreed to by trading partners

GS-03 · 124 · Application Receiver's Code · Required Min 2 Max 15 · Code identifying party receiving transmission. Codes agreed to by trading partners

GS-04 · 373 · Date · Required CCYYMMDD format · Date expressed as CCYYMMDD

GS-05 · 337 · Time · Required HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format · Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

GS-06 · 28 · Group Control Number · Required Min 1 Max 9 · Assigned number originated and maintained by the sender

GS-07 · 455 · Responsible Agency Code · Required Min 1 Max 2 · Code used in conjunction with Data Element 480 to identify the issuer of the standard · T Transportation Data Coordinating Committee (TDCC) X Accredited Standards Committee X12

GS-08 · 480 · Version / Release / Industry Identifier Code · Required · Code indicating the version, release, subrelease, and industry identifier of the EDI standard being used, including the GS and GE segments; if code in DE455 in GS segment is X, then in DE 480 positions 1-3 are the version number; positions 4-6 are the release and subrelease, level of the version; and positions 7-12 are the industry or trade association identifiers (optionally assigned by user); if code in DE455 in GS segment is T, then other formats are allowed · 004010 Draft Standards Approved for Publication by ASC X12 Procedures Review Board through October 1997

Heading

ST

010

Transaction Set Header

RequiredMax use 1

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

ST-01 · 143 · Transaction Set Identifier Code · Required · Code uniquely identifying a Transaction Set The transaction set identifier (ST01) used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set). · 810 Invoice

ST-02 · 329 · Transaction Set Control Number · Required Min 4 Max 9 · Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

BIG

020

Beginning Segment for Invoice

RequiredMax use 1

To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates

BIG-01 · 373 · Date · Required CCYYMMDD format · Date expressed as CCYYMMDD BIG01 is the invoice issue date.

BIG-02 · 76 · Invoice Number · Required Min 1 Max 22 · Identifying number assigned by issuer · Usage notes Do not send dashes, slashes, spaces, periods, or other special characters in the invoice number field. 3M invoice number field is limited to a length of 16 characters.

BIG-04 · 324 · Purchase Order Number · Required Min 1 Max 22 · Identifying number for Purchase Order assigned by the orderer/purchaser · Usage notes Purchase order number will be numeric and 10 digits in length.

BIG-07 · 640 · Transaction Type Code · Required · Code specifying the type of transaction BIG07 is used only to further define the type of invoice when needed. · CR Credit Memo Send only positive dollar values in all amount fields. PR Product (or Service)

CUR

040

Currency

RequiredMax use 1

To specify the currency (dollars, pounds, francs, etc.) used in a transaction

CUR-01 · 98 · Entity Identifier Code · Required · Code identifying an organizational entity, a physical location, property or an individual · BY Buying Party (Purchaser)

CUR-02 · 100 · Currency Code · Required Min 3 Max 3 · Code (Standard ISO) for country in whose currency the charges are specified

REF

050

Reference Identification

OptionalMax use 12

To specify identifying information

REF-01 · 128 · Reference Identification Qualifier · Required · Code qualifying the Reference Identification · 4N Special Payment Reference Number KID/FIK number (payment reference number) BM Bill of Lading Number CL Seller's Credit Memo DJ Delivery Ticket Number PK Packing List Number Q8 Registration Number Vendor's Company Registration Number

REF-02 · 127 · Reference Identification · Required Min 1 Max 30 · Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

N1 N1 Loop other codes

RequiredMax >1

Variants (all may be used)

N1N1 Loop RE

N1

070

Name

RequiredMax use 1

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

N1-01 · 98 · Entity Identifier Code · Required · Code identifying an organizational entity, a physical location, property or an individual · BT Bill-to-Party II Issuer of Invoice ST Ship To VN Vendor

N1-02 · 93 · Name · Required Min 1 Max 60 · Free-form name

N1-03 · 66 · Identification Code Qualifier · Required · Code designating the system/method of code structure used for Identification Code (67) · 92 Assigned by Buyer or Buyer's Agent

N1-04 · 67 · Identification Code · Required Min 2 Max 80 · Code identifying a party or other code This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party. · Usage notes 3M assigned vendor number, plant, or company code. May differ by address type. Please return the value sent on the 850 for the specific N101 qualifier used.

N2

080

Additional Name Information

OptionalMax use 2

To specify additional names or those longer than 35 characters in length

N2-01 · 93 · Name · Required Min 1 Max 60 · Free-form name

N2-02 · 93 · Name · Optional Min 1 Max 60 · Free-form name

N3

090

Address Information

RequiredMax use 2

To specify the location of the named party

N3-01 · 166 · Address Information · Required Min 1 Max 55 · Address information

N3-02 · 166 · Address Information · Optional Min 1 Max 55 · Address information

N4

100

Geographic Location

RequiredMax use 1

To specify the geographic place of the named party

Example

If Location Identifier (N4-06) is present, then Location Qualifier (N4-05) is required

N4-01 · 19 · City Name · Optional Min 2 Max 30 · Free-form text for city name A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.

N4-02 · 156 · State or Province Code · Optional Min 2 Max 2 · Code (Standard State/Province) as defined by appropriate government agency N402 is required only if city name (N401) is in the U.S. or Canada.

N4-03 · 116 · Postal Code · Optional Min 3 Max 15 · Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04 · 26 · Country Code · Optional Min 2 Max 3 · Code identifying the country

N4-05 · 309 · Location Qualifier · Optional · Code identifying type of location · 34 District RG Region Code

N4-06 · 310 · Location Identifier · Optional Min 1 Max 30 · Code which identifies a specific location

REF

110

Reference Identification

OptionalMax use 12

To specify identifying information

REF-01 · 128 · Reference Identification Qualifier · Required · Code qualifying the Reference Identification · VX Value-Added Tax Registration Number (Europe) Used in the VN and ST N1 loops for vendor and 3M VAT IDs respectively.

REF-02 · 127 · Reference Identification · Required Min 1 Max 30 · Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

N1 N1 Loop RE

RequiredMax >1

Variants (all may be used)

N1N1 Loop other codes

N1

070

Name

RequiredMax use 1

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

N1-01 · 98 · Entity Identifier Code · Required · Code identifying an organizational entity, a physical location, property or an individual · RE Party to receive commercial invoice remittance

N1-02 · 93 · Name · Required Min 1 Max 60 · Free-form name

N2

080

Additional Name Information

OptionalMax use 2

To specify additional names or those longer than 35 characters in length

N2-01 · 93 · Name · Required Min 1 Max 60 · Free-form name

N2-02 · 93 · Name · Optional Min 1 Max 60 · Free-form name

N3

090

Address Information

RequiredMax use 2

To specify the location of the named party

N3-01 · 166 · Address Information · Required Min 1 Max 55 · Address information

N3-02 · 166 · Address Information · Optional Min 1 Max 55 · Address information

N4

100

Geographic Location

RequiredMax use 1

To specify the geographic place of the named party

Example

If Location Identifier (N4-06) is present, then Location Qualifier (N4-05) is required

N4-01 · 19 · City Name · Optional Min 2 Max 30 · Free-form text for city name A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.

N4-02 · 156 · State or Province Code · Optional Min 2 Max 2 · Code (Standard State/Province) as defined by appropriate government agency N402 is required only if city name (N401) is in the U.S. or Canada.

N4-03 · 116 · Postal Code · Optional Min 3 Max 15 · Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04 · 26 · Country Code · Optional Min 2 Max 3 · Code identifying the country

N4-05 · 309 · Location Qualifier · Optional · Code identifying type of location · 34 District RG Region Code

N4-06 · 310 · Location Identifier · Optional Min 1 Max 30 · Code which identifies a specific location

REF

110

Reference Identification

OptionalMax use 12

To specify identifying information

REF-01 · 128 · Reference Identification Qualifier · Required · Code qualifying the Reference Identification · VX Value-Added Tax Registration Number (Europe) Used in the VN and ST N1 loops for vendor and 3M VAT IDs respectively.

REF-02 · 127 · Reference Identification · Required Min 1 Max 30 · Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

ITD

130

Terms of Sale/Deferred Terms of Sale

RequiredMax use >1

To specify terms of sale

ITD-01 · 336 · Terms Type Code · Required · Code identifying type of payment terms If the code in ITD01 is "04", then ITD07 or ITD09 is required and either ITD10 or ITD11 is required; if the code in ITD01 is "05", then ITD06 or ITD07 is required. · 02 End of Month (EOM) 05 Discount Not Applicable 06 Mixed 08 Basic Discount Offered 09 Proximo 10 Instant 14 Previously agreed upon ZZ Mutually Defined

ITD-02 · 333 · Terms Basis Date Code · Optional · Code identifying the beginning of the terms period · 3 Invoice Date

ITD-03 · 338 · Terms Discount Percent · Optional Min 1 Max 6 · Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date

ITD-05 · 351 · Terms Discount Days Due · Optional Min 1 Max 3 · Number of days in the terms discount period by which payment is due if terms discount is earned

ITD-07 · 386 · Terms Net Days · Optional Min 1 Max 3 · Number of days until total invoice amount is due (discount not applicable)

ITD-12 · 352 · Description · Optional Min 1 Max 80 · A free-form description to clarify the related data elements and their content

ITD-13 · 765 · Day of Month · Optional Min 1 Max 2 · The numeric value of the day of the month between 1 and the maximum day of the month being referenced

DTM

140

Date/Time Reference

OptionalMax use 10

To specify pertinent dates and times

DTM-01 · 374 · Date/Time Qualifier · Required · Code specifying type of date or time, or both date and time · 002 Delivery Requested 011 Shipped

DTM-02 · 373 · Date · Required CCYYMMDD format · Date expressed as CCYYMMDD

N9 Loop

OptionalMax >1

N9

240

Reference Identification

RequiredMax use 1

To transmit identifying information as specified by the Reference Identification Qualifier

Usage notes

Send only if sending vendor messages on the 810. Do not send messages received in the 850 back in the 810.

N9-01 · 128 · Reference Identification Qualifier · Required · Code qualifying the Reference Identification · I5 Invoice Identification See country specific requirements in appendix. L1 Letters or Notes

N9-02 · 127 · Reference Identification · Required Min 1 Max 30 · Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

MSG

250

Message Text

RequiredMax use 10

To provide a free-form format that allows the transmission of text information

Usage notes

See appendix for country specific requirements.
Please do not include any special characters in MSG segments.

MSG-01 · 933 · Free-Form Message Text · Required Min 1 Max 264 · Free-form message text

Detail

IT1 Loop

RequiredMax 200000

IT1

010

Baseline Item Data (Invoice)

RequiredMax use 1

To specify the basic and most frequently used line item data for the invoice and related transactions

Usage notes

3M allows different units of measures for the quantity shipped and for the price. 3M considers the price in the CTP03 as the PO price. The quantity in the PO102 is the quantity in the shipping unit of measure. The quantity in the CTP04 is the quantity in the pricing unit of measure.
If necessary the vendor can calculate the price in shipping unit of measure using the following formula:
Price in shipping uom = ((CTP03/CTP07) x CTP04) / PO102
Example:
Outbound PO: PO10001010EABP7000138216**RPCT060921468~ CTPUCP22.2310ASSEL5~
Calculation:
Price in shipping uom = ((CTP03/CTP07) x CTP04) / PO102
= ((22.23 / 5) x 10) / 10 = $4.446 EA
Example: IT100010240EA40*BP0000000071VPVENDORSKUUK04710367340423* MGMFG_PARTRP*23344~

Example

If either Quantity Invoiced (IT1-02), Unit or Basis for Measurement Code (IT1-03) or Unit Price (IT1-04) are present, then the others are required

If either Product/Service ID Qualifier (IT1-06) or Product/Service ID (IT1-07) is present, then the other is required

If either Product/Service ID Qualifier (IT1-08) or Product/Service ID (IT1-09) is present, then the other is required

If either Product/Service ID Qualifier (IT1-10) or Product/Service ID (IT1-11) is present, then the other is required

If either Product/Service ID Qualifier (IT1-12) or Product/Service ID (IT1-13) is present, then the other is required

If either Product/Service ID Qualifier (IT1-14) or Product/Service ID (IT1-15) is present, then the other is required

IT1-01 · 350 · Assigned Identification · Required Min 1 Max 20 · Alphanumeric characters assigned for differentiation within a transaction set IT101 is the purchase order line item identification. · Usage notes Return line item number exactly as received on the purchase order.

IT1-02 · 358 · Quantity Invoiced · Required Min 1 Max 10 · Number of units invoiced (supplier units)

IT1-03 · 355 · Unit or Basis for Measurement Code · Required Min 2 Max 2 · Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

IT1-04 · 212 · Unit Price · Optional Min 1 Max 15 · Price per unit of product, service, commodity, etc. · Usage notes IT104 is calculated from information in the PO1 and CTP segment of the PO. Calculation: IT104 = ((CTP03/CTP07) x CTP04) / PO102

IT1-06 · 235 · Product/Service ID Qualifier · Optional · Code identifying the type/source of the descriptive number used in Product/Service ID (234) IT106 through IT125 provide for ten different product/service IDs for each item. For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU. · Usage notes 3M Buyer's Part Number (BP) must be returned if sent on PO. · BP Buyer's Part Number MG Manufacturer's Part Number RP Replaced Part Number UK U.P.C./EAN Shipping Container Code (1-2-5-5-1) VP Vendor's (Seller's) Part Number

IT1-07 · 234 · Product/Service ID · Optional Min 1 Max 48 · Identifying number for a product or service

IT1-08 · 235 · Product/Service ID Qualifier · Optional · Code identifying the type/source of the descriptive number used in Product/Service ID (234) · BP Buyer's Part Number MG Manufacturer's Part Number RP Replaced Part Number UK U.P.C./EAN Shipping Container Code (1-2-5-5-1) VP Vendor's (Seller's) Part Number

IT1-09 · 234 · Product/Service ID · Optional Min 1 Max 48 · Identifying number for a product or service

IT1-10 · 235 · Product/Service ID Qualifier · Optional Min 2 Max 2 · Code identifying the type/source of the descriptive number used in Product/Service ID (234)

IT1-11 · 234 · Product/Service ID · Optional Min 1 Max 48 · Identifying number for a product or service

IT1-12 · 235 · Product/Service ID Qualifier · Optional Min 2 Max 2 · Code identifying the type/source of the descriptive number used in Product/Service ID (234)

IT1-13 · 234 · Product/Service ID · Optional Min 1 Max 48 · Identifying number for a product or service

IT1-14 · 235 · Product/Service ID Qualifier · Optional Min 2 Max 2 · Code identifying the type/source of the descriptive number used in Product/Service ID (234)

IT1-15 · 234 · Product/Service ID · Optional Min 1 Max 48 · Identifying number for a product or service

CTP

050

Pricing Information

RequiredMax use 25

To specify pricing information

Usage notes

3M allows different units of measures for the quantity shipped and for the price. 3M considers the price in the CTP03 as the PO price. The quantity in the PO102 is the quantity in the shipping unit of measure. The quantity in the CTP04 is the quantity in the pricing unit of measure.
If necessary the vendor can calculate the price in shipping unit of measure using the following formula:
Price in shipping uom = ((CTP03/CTP07) x CTP04) / PO102
Example:
Outbound PO: PO10001010EABP7000138216**RPCT060921468~ CTPUCP22.2310ASSEL5~
Calculation:
Price in shipping uom = ((CTP03/CTP07) x CTP04) / PO102
= ((22.23 / 5) x 10) / 10
= $4.446 EA
Example: CTPUCP10096.000CSSEL*1~
Price of $100.00 per 1 CS.
96 CS = 240 EA (from IT102 and IT103) Line item total = $9600.00
CTPUCP512.00CSSEL1000~
Price of $5 per 1000 CS or $5/1000=$.005 per CS
12 CS = 35000 EA (from PO102 and PO103) Line item total = $.06
CTP**UCP1025.000CSSEL25~
Price of $10.00 per 25 CS or $10/25=$.40 per CS. 25 CS = 100 EA (from PO102 and PO103)
Line item total = $10.00

CTP-02 · 236 · Price Identifier Code · Required · Code identifying pricing specification · UCP Unit cost price

CTP-03 · 212 · Unit Price · Required Min 1 Max 15 · Price per unit of product, service, commodity, etc. See Figures Appendix for an example detailing the use of CTP03 and CTP04. See Figures Appendix for an example detailing the use of CTP03, CTP04 and CTP07.

CTP-04 · 380 · Quantity · Required Min 1 Max 15 · Numeric value of quantity

CTP-05 · C001 · Composite Unit of Measure

C001-01 · 355 · Unit or Basis for Measurement Code · Required Min 2 Max 2 · Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

CTP-06 · 648 · Price Multiplier Qualifier · Required · Code indicating the type of price multiplier · SEL Selling Multiplier

CTP-07 · 649 · Multiplier · Required Min 1 Max 10 · Value to be used as a multiplier to obtain a new value CTP07 is a multiplier factor to arrive at a final discounted price. A multiplier of .90 would be the factor if a 10% discount is given.

PID Loop

OptionalMax 1000

PID

060

Product/Item Description

OptionalMax use 1

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

PID-01 · 349 · Item Description Type · Required · Code indicating the format of a description 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. · F Free-form

PID-05 · 352 · Description · Required Min 1 Max 80 · A free-form description to clarify the related data elements and their content

Summary

TDS

010

Total Monetary Value Summary

RequiredMax use 1

To specify the total invoice discounts and amounts

TDS-01 · 610 · Amount · Required Min 1 Max 15 · Monetary amount TDS01 is the total amount of invoice (including charges, less allowances) before terms discount (if discount is applicable). · Usage notes Total invoice/credit amount.

TXI

020

Tax Information

OptionalMax use 10

To specify tax information

Example

If either Tax Jurisdiction Code Qualifier (TXI-04) or Tax Jurisdiction Code (TXI-05) is present, then the other is required

TXI-01 · 963 · Tax Type Code · Required · Code specifying the type of tax · CP County/Parish Sales Tax CS City Sales Tax CT County Tax GS Goods and Services Tax Goods and Services Tax / GST LS State and Local Sales Tax LT Local Sales Tax (All Applicable Sales Taxes by Taxing Authority Below the State Level) OH Other Taxes Quebec Sales Tax/QST SP State/Provincial Tax Provincal Sales Tax / PST ST State Sales Tax VA Value Added Tax ZZ Mutually Defined Harmonized Sales Tax / HST

TXI-02 · 782 · Monetary Amount · Required Min 1 Max 15 · Monetary amount TXI02 is the monetary amount of the tax.

TXI-03 · 954 · Percent · Optional Min 1 Max 10 · Percentage expressed as a decimal TXI03 is the tax percent expressed as a decimal.

TXI-04 · 955 · Tax Jurisdiction Code Qualifier · Optional · Code identifying the source of the data used in tax jurisdiction code · CD Customer defined

TXI-05 · 956 · Tax Jurisdiction Code · Optional Min 1 Max 10 · Code identifying the taxing jurisdiction · Usage notes Should contain the 2 character province or state abbreviation.

TXI-09 · 325 · Tax Identification Number · Optional Min 1 Max 20 · Number assigned to a purchaser (buyer, orderer) by a taxing jurisdiction (state, county, etc.); often called a tax exemption number or certificate number · Usage notes Use to send GST/HST, QST ids. If QST is sent, GST/HST also needs to be sent in a separate TXI segment.

SAC Loop

OptionalMax >1

Usage notes

SAC only used if billing misc or freight charges.
Do not use SAC for billing tax, use TXI segment instead.

SAC

040

Service, Promotion, Allowance, or Charge Information

RequiredMax use 1

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

Usage notes

SAC only used if billing misc or freight charges.
Do not use SAC for billing tax, use TXI segment instead.

SAC-01 · 248 · Allowance or Charge Indicator · Required · Code which indicates an allowance or charge for the service specified If SAC01 is "A" or "C", then at least one of SAC05, SAC07, or SAC08 is required. · C Charge

SAC-02 · 1300 · Service, Promotion, Allowance, or Charge Code · Required Min 4 Max 4 · Code identifying the service, promotion, allowance, or charge

SAC-05 · 610 · Amount · Required Min 1 Max 15 · Monetary amount SAC05 is the total amount for the service, promotion, allowance, or charge. If SAC05 is present with SAC07 or SAC08, then SAC05 takes precedence. · Usage notes This field should always be positive.

SAC-15 · 352 · Description · Required Min 1 Max 80 · A free-form description to clarify the related data elements and their content · Usage notes Required by 3M.

CTT

070

Transaction Totals

OptionalMax use 1

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

• Number of line items (CTT01) is the accumulation of the number of IT1 segments.
  If used, hash total (CTT02) is the sum of the value of quantities invoiced (IT102) for each IT1 segment.

CTT-01 · 354 · Number of Line Items · Required Min 1 Max 6 · Total number of line items in the transaction set

SE

080

Transaction Set Trailer

RequiredMax use 1

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

SE-01 · 96 · Number of Included Segments · Required Min 1 Max 10 · Total number of segments included in a transaction set including ST and SE segments

SE-02 · 329 · Transaction Set Control Number · Required Min 4 Max 9 · Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

GE

Functional Group Trailer

RequiredMax use 1

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

GE-01 · 97 · Number of Transaction Sets Included · Required Min 1 Max 6 · Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element

GE-02 · 28 · Group Control Number · Required Min 1 Max 9 · Assigned number originated and maintained by the sender

IEA

Interchange Control Trailer

RequiredMax use 1

To define the end of an interchange of zero or more functional groups and interchange-related control segments

IEA-01 · I16 · Number of Included Functional Groups · Required Min 1 Max 5 · A count of the number of functional groups included in an interchange

IEA-02 · I12 · Interchange Control Number · Required Min 9 Max 9 · A control number assigned by the interchange sender

EDI Samples

Transaction example from 3M

ISA*00*          *00*          *ZZ*IDSENDERID     *12*IDRECEIVERID   *150216*1720*U*00401*650000035*0*P*>
GS*IN* IDSENDERID * IDRECEIVERID *20150216*1720*650000035*X*004010 
ST*810*0496
BIG*20230404*INVOICENUMBER**3MPONUMBER***PR
CUR*BY*USD
N1*ST*3M LONDON*92*2001
N3*801 CLARKE ROAD
N4*LONDON ONTARIO*ON*N5V 3B1*CA 
N1*VN*SUPPLIER*92*0001234567 
N3*456 VENDOR ROAD
N4*ANYTOWN*MN*553031089*US 
N1*II*SUPPLIER*92*0001234567 
N3*456 VENDOR ROAD 
N4*ANYTOWN*MN*553031089*US 
N1*RE*SUPPLIER
N3*456 VENDOR ROAD
N4* ANYTOWN*MN*553031089 *US
N1*BT*3M CANADA COMPANY*92*2000~
N3*P.O. BOX 5840
N4*LONDON*ON*N6A 5S2*CA
ITD*05*3***0**60*****NET 60 DAYS
DTM*002*20150105
N9*L1*SEE COMMENTS
MSG*COMMENTS ENTERED IN THIS SEGMENT
IT1*00010*26030*EA*0.77090**BP*3M PART NUMBER*VP*VENDOR PART NUMBER*RP*REPLACE PART NUMBER
CTP**UCP*77.09*25200*EA*SEL*100
PID*F****LINE ITEM DESCRIPTION
TDS*2008653
TXI*OH*10.00**CD*MN****TAX ID NUMBER
SAC*C*D240***1000**********FREIGHT
CTT*27
SE*30*0496
GE*1*650000035
IEA*1*650000035