Best Buy 810 - Invoice Specifications

Modified on Tue, May 26 at 9:47 AM

**These specifications are a base model. All customers are responsible for ensuring their map or EDI is compliant with their trading partner's most current specifications.


X12 810 Invoice

X12 Release 4010

Revised February 28, 2024

Print

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

EDI samples

sample 1

sample 2

ISA

Interchange Control Header

RequiredMax use 1

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

Example

ISA*00*          *00*          *XX*XXXXXXXXXXXXXXX*XX*XXXXXXXXXXXXXXX*240717*0129*U*00401*000000000*X*X*>~

ISA-01

I01

Authorization Information Qualifier

Required

Identifier (ID)

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

String (AN)

Min 10Max 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

Identifier (ID)

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

String (AN)

Min 10Max 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

Identifier (ID)

Min 2Max 2

Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified

Codes

ISA-06

I06

Interchange Sender ID

Required

String (AN)

Min 15Max 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

Identifier (ID)

Min 2Max 2

Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified

Codes

ISA-08

I07

Interchange Receiver ID

Required

String (AN)

Min 15Max 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

Date (DT)

YYMMDD format

Date of the interchange

ISA-10

I09

Interchange Time

Required

Time (TM)

HHMM format

Time of the interchange

ISA-11

I10

Interchange Control Standards Identifier

Required

Identifier (ID)

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

Identifier (ID)

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

Numeric (N0)

Min 9Max 9

A control number assigned by the interchange sender

ISA-14

I13

Acknowledgment Requested

Required

Identifier (ID)

Min 1Max 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

Identifier (ID)

Min 1Max 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

String (AN)

Min 1Max 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

Example

GS*IN*XXXX*XX*20240717*0837*00000*X*004010~

GS-01

479

Functional Identifier Code

Required

Identifier (ID)

Code identifying a group of application related transaction sets

IN

Invoice Information (810,819)

GS-02

142

Application Sender's Code

Required

String (AN)

Min 2Max 15

Code identifying party sending transmission; codes agreed to by trading partners

GS-03

124

Application Receiver's Code

Required

String (AN)

Min 2Max 15

Code identifying party receiving transmission. Codes agreed to by trading partners

GS-04

373

Date

Required

Date (DT)

CCYYMMDD format

Date expressed as CCYYMMDD

GS-05

337

Time

Required

Time (TM)

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

Numeric (N0)

Min 1Max 9

Assigned number originated and maintained by the sender

GS-07

455

Responsible Agency Code

Required

Identifier (ID)

Min 1Max 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

String (AN)

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

Example

ST*810*0001~

ST-01

143

Transaction Set Identifier Code

Required

Identifier (ID)

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

Numeric (N)

Min 4Max 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

Example

BIG*20230327*XXX*20230327*XXXXXX***CR~

BIG-01

373

Date

Required

Date (DT)

CCYYMMDD format

Date expressed as CCYYMMDD

  • BIG01 is the invoice issue date.

BIG-02

76

Invoice Number

Required

String (AN)

Min 1Max 22

Identifying number assigned by issuer

BIG-03

373

Date

Required

Date (DT)

CCYYMMDD format

Date expressed as CCYYMMDD

  • BIG03 is the date assigned by the purchaser to purchase order.

BIG-04

324

Purchase Order Number

Optional

String (AN)

Min 1Max 22

Identifying number for Purchase Order assigned by the orderer/purchaser

BIG-07

640

Transaction Type Code

Optional

Identifier (ID)

Code specifying the type of transaction

  • BIG07 is used only to further define the type of invoice when needed.

CR

Credit Memo

DR

Debit Memo

NTE

030

Note/Special Instruction

OptionalMax use 100

To transmit information in a free-form format, if necessary, for comment or special instruction

Usage notes

This segment is used to supply any comments or special instructions pertaining to the invoice. This field is text only and currently has no impact on the Invoice amount or the invoice terms.

Example

NTE*INV*XXX~

NTE-01

363

Note Reference Code

Optional

Identifier (ID)

Code identifying the functional area or purpose for which the note applies

INV

Invoice Instruction

NTE-02

352

Description

Required

String (AN)

Min 1Max 80

A free-form description to clarify the related data elements and their content

CUR

040

Currency

RequiredMax use 1

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

Usage notes

This segment is used to supply any comments or special instructions pertaining to the invoice. This field is text only and currently has no impact on the Invoice amount or the invoice terms.

Example

CUR*INV*USD~

CUR-01

98

Entity Identifier Code

Required

Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

CQ

Corporate Office

INV

Investment Advisor

CUR-02

100

Currency Code

Required

Identifier (ID)

Code (Standard ISO) for country in whose currency the charges are specified

CAD

Canadian Dollar

USD

US Dollar

REF

050

Reference Identification

OptionalMax use 12

To specify identifying information

Usage notes

The following is a sample of typical uses for this REF segment:

  • GT – Goods and Services Tax Registration Number
  • VN – Vendor Order Number
  • BM – Bill of Lading Number
  • PK – Tracking Number

If Federal GST Tax is charged in the TXI segment, then the GST registration number MUST be reported in the REF segment (See Note 2 on Page 33).

BestBuy Canada would like to request that Vendors return a tracking number in the EDI 810 message. The tracking number can be a Packing Slip, Shipment number, etc. which uniquely identifies each shipment and will be recognized by the Vendor’s accounting department. This number should be unique for each shipment and hence unique for each Invoice.

Please use the qualifier “PK” to transmit the tracking number.

The tracking number is an optional data element

Example

REF*BM*X~

REF-01

128

Reference Identification Qualifier

Required

Identifier (ID)

Code qualifying the Reference Identification

BM

Bill of Lading Number

GT

Goods and Service Tax Registration Number

PK

Packing List Number

VN

Vendor Order Number

REF-02

127

Reference Identification

Optional

String (AN)

Min 1Max 30

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

N1 Bill To

RequiredMax 1

Variants (all may be used)

Remit ToShip To

N1

070

Name

RequiredMax use 1

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

Usage notes

Data elements N101 and N102 are paired elements. If one data element exists then the other MUST also be used.

All 3 occurrences of the N1 segment are Mandatory.

Example

N1*BT*X~

N1-01

98

Entity Identifier Code

Required

Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

BT

Bill-to-Party

N1-02

93

Name

Optional

String (AN)

Min 1Max 60

Free-form name

N3

090

Address Information

RequiredMax use 2

To specify the location of the named party

Example

N3*XXXX*XXXX~

N3-01

166

Address Information

Required

String (AN)

Min 1Max 55

Address information

N3-02

166

Address Information

Optional

String (AN)

Min 1Max 55

Address information

N4

100

Geographic Location

RequiredMax use 1

To specify the geographic place of the named party

Example

N4*XXXXXXX*XX*XXX*XXX~

N4-01

19

City Name

Optional

String (AN)

Min 2Max 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

Identifier (ID)

Min 2Max 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

Identifier (ID)

Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04

26

Country Code

Optional

Identifier (ID)

Min 2Max 3

Code identifying the country

PER

120

Administrative Communications Contact

OptionalMax use 3

To identify a person or office to whom administrative communications should be directed

Usage notes

If either PER 03 and PER 04 is present, then the other is required.

Example

PER*AA*XXXXXX*TE*XXXXX~

PER-01

366

Contact Function Code

Required

Identifier (ID)

Code identifying the major duty or responsibility of the person or group named

AA

Authorized Representative

PER-02

93

Name

Required

String (AN)

Min 1Max 60

Free-form name

PER-03

365

Communication Number Qualifier

Optional

Identifier (ID)

Code identifying the type of communication number

TE

Telephone

PER-04

364

Communication Number

Required

String (AN)

Min 1Max 80

Complete communications number including country or area code when applicable

N1 Remit To

RequiredMax 1

Variants (all may be used)

Bill ToShip To

N1

070

Name

RequiredMax use 1

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

Usage notes

Data elements N101 and N102 are paired elements. If one data element exists then the other MUST also be used.

All 3 occurrences of the N1 segment are Mandatory.

Example

N1*RI*X~

N1-01

98

Entity Identifier Code

Required

Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

RI

Remit To

N1-02

93

Name

Optional

String (AN)

Min 1Max 60

Free-form name

N3

090

Address Information

RequiredMax use 2

To specify the location of the named party

Example

N3*XX*X~

N3-01

166

Address Information

Required

String (AN)

Min 1Max 55

Address information

N3-02

166

Address Information

Optional

String (AN)

Min 1Max 55

Address information

N4

100

Geographic Location

RequiredMax use 1

To specify the geographic place of the named party

Example

N4*XXXXX*XX*XXXXXX*XX~

N4-01

19

City Name

Optional

String (AN)

Min 2Max 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

Identifier (ID)

Min 2Max 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

Identifier (ID)

Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04

26

Country Code

Optional

Identifier (ID)

Min 2Max 3

Code identifying the country

PER

120

Administrative Communications Contact

OptionalMax use 3

To identify a person or office to whom administrative communications should be directed

Usage notes

If either PER 03 and PER 04 is present, then the other is required.

Example

PER*AA*XXX*TE*X~

PER-01

366

Contact Function Code

Required

Identifier (ID)

Code identifying the major duty or responsibility of the person or group named

AA

Authorized Representative

PER-02

93

Name

Required

String (AN)

Min 1Max 60

Free-form name

PER-03

365

Communication Number Qualifier

Optional

Identifier (ID)

Code identifying the type of communication number

TE

Telephone

PER-04

364

Communication Number

Required

String (AN)

Min 1Max 80

Complete communications number including country or area code when applicable

N1 Ship To

RequiredMax 1

Variants (all may be used)

Bill ToRemit To

N1

070

Name

RequiredMax use 1

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

Usage notes

Data elements N101 and N102 are paired elements. If one data element exists then the other MUST also be used.

All 3 occurrences of the N1 segment are Mandatory.

Example

N1*ST*XXX~

N1-01

98

Entity Identifier Code

Required

Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

ST

Ship To

N1-02

93

Name

Optional

String (AN)

Min 1Max 60

Free-form name

N3

090

Address Information

RequiredMax use 2

To specify the location of the named party

Example

N3*XXXX*XXXX~

N3-01

166

Address Information

Required

String (AN)

Min 1Max 55

Address information

N3-02

166

Address Information

Optional

String (AN)

Min 1Max 55

Address information

N4

100

Geographic Location

RequiredMax use 1

To specify the geographic place of the named party

Example

N4*XXXXXX*XX*XXXXX*XXX~

N4-01

19

City Name

Optional

String (AN)

Min 2Max 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

Identifier (ID)

Min 2Max 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

Identifier (ID)

Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04

26

Country Code

Optional

Identifier (ID)

Min 2Max 3

Code identifying the country

PER

120

Administrative Communications Contact

OptionalMax use 3

To identify a person or office to whom administrative communications should be directed

Usage notes

If either PER 03 and PER 04 is present, then the other is required.

Example

PER*AA*XXXXXX*TE*XXXX~

PER-01

366

Contact Function Code

Required

Identifier (ID)

Code identifying the major duty or responsibility of the person or group named

AA

Authorized Representative

PER-02

93

Name

Required

String (AN)

Min 1Max 60

Free-form name

PER-03

365

Communication Number Qualifier

Optional

Identifier (ID)

Code identifying the type of communication number

TE

Telephone

PER-04

364

Communication Number

Required

String (AN)

Min 1Max 80

Complete communications number including country or area code when applicable

ITD

130

Terms of Sale/Deferred Terms of Sale

OptionalMax use >1

To specify terms of sale

Usage notes

If multiple types of terms are being applied to a single invoice, the ITD segment will repeat once for each set of terms.

The Terms Net Due date and Terms Discount due date should be explicit as opposed to a calculation of Due date minus Invoice date.

Examples:
 
ITD50326061~
 
ITD01310****61~

ITD50313031~
 
ITD0134****31~

ITD053*****45~

Example

ITD*50*3*0000*20230327*0*20230327*0~

ITD-01

336

Terms Type Code

Optional

Identifier (ID)

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.

Usage notes

Data ITD01 codes 01, 07, 08 and 22 are regarded by Best Buy Canada as traditional DFI (Deduct from Invoice).

ECD (Early Cash Discount) is another form of DFI but is excluded in the DFI definition since it relates to the timeliness of the invoice payment whereas all other codes or DFI types are not contingent on the timing of payment.

The percentage indicated in the DFI codes are deducted from the Gross Invoice Amount regardless of when payment is provided.

01

Basic

This code indicates a DFI (Deduct from Invoice) term.

05

Discount Not Applicable

06

Mixed

This code indicates a terms type that does not otherwise appear on BestBuy Canada’s implementation Guide Listing.

07

Extended

This code indicates a Co-op term, where the discounted monetary value is used towards advertising.

08

Basic Discount Offered

This code indicates a VIR (Volume Incentive Rebate) term.

22

Cash Discount Terms Apply

This code indicates an MA (Merchandising Allowance) term.

50

Discount with Advance Payment

This code indicates an ECD (Early Cash Discount) term.

ITD-02

333

Terms Basis Date Code

Optional

Identifier (ID)

Code identifying the beginning of the terms period

1

Ship Date

2

Delivery Date

3

Invoice Date

15

Receipt of Goods

ITD-03

338

Terms Discount Percent

Optional

Decimal number (R)

Min 1Max 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

Usage notes

Percentage Discount offered

ITD-04

370

Terms Discount Due Date

Optional

Date (DT)

CCYYMMDD format

Date payment is due if discount is to be earned expressed in format CCYYMMDD

ITD-05

351

Terms Discount Days Due

Optional

Numeric (N0)

Min 1Max 3

Number of days in the terms discount period by which payment is due if terms discount is earned

Usage notes

Number of days until discount is no longer available

ITD-06

446

Terms Net Due Date

Optional

Date (DT)

CCYYMMDD format

Date when total invoice amount becomes due expressed in format CCYYMMDD

ITD-07

386

Terms Net Days

Optional

Numeric (N0)

Min 1Max 3

Number of days until total invoice amount is due (discount not applicable)

DTM

140

Date/Time Reference

OptionalMax use 10

To specify pertinent dates and times

Usage notes

The DTM segment currently is not used by BestBuy Canada.

The DTM segment may be used in the future to capture dates that Best Buy Canada accounting department and Trading Partners feel are relevant to the Invoice.

Example

DTM*035*20230327*2130~

DTM-01

374

Date/Time Qualifier

Required

Identifier (ID)

Code specifying type of date or time, or both date and time

011

Shipped

035

Delivered

070

Scheduled for Delivery (After and Including)

DTM-02

373

Date

Optional

Date (DT)

CCYYMMDD format

Date expressed as CCYYMMDD

DTM-03

337

Time

Optional

Time (TM)

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)

Detail

IT1 Loop

RequiredMax >1

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

Example

IT1*XX*0*EA*000000000*XX*VP*XXXXX*UP*XXXXX*VP*X~

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

IT1-01

350

Assigned Identification

Optional

String (AN)

Min 1Max 20

Alphanumeric characters assigned for differentiation within a transaction set

  • IT101 is the purchase order line item identification.

IT1-02

358

Quantity Invoiced

Optional

Decimal number (R)

Min 1Max 10

Number of units invoiced (supplier units)

IT1-03

355

Unit or Basis for Measurement Code

Optional

Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

EA

Each

IT1-04

212

Unit Price

Optional

Decimal number (R)

Min 1Max 15

Price per unit of product, service, commodity, etc.

Usage notes

Item’s invoiced price

IT1-05

639

Basis of Unit Price Code

Optional

Identifier (ID)

Min 2Max 2

Code identifying the type of unit price for an item

IT1-06

235

Product/Service ID Qualifier

Optional

Identifier (ID)

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.

BP

Buyer's Part Number

UP

U.P.C. Consumer Package Code (1-5-5-1)

VP

Vendor's (Seller's) Part Number

IT1-07

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

Identifying number for a product or service

Usage notes

Best Buy Canada SKU #

IT1-08

235

Product/Service ID Qualifier

Optional

Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

BP

Buyer's Part Number

UP

U.P.C. Consumer Package Code (1-5-5-1)

VP

Vendor's (Seller's) Part Number

IT1-09

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

Identifying number for a product or service

Usage notes

Vendor Part Number

IT1-10

235

Product/Service ID Qualifier

Optional

Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

BP

Buyer's Part Number

UP

U.P.C. Consumer Package Code (1-5-5-1)

VP

Vendor's (Seller's) Part Number

IT1-11

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

Identifying number for a product or service

Usage notes

UPC Code

PID Loop

RequiredMax >1

PID

060

Product/Item Description

RequiredMax use 1

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

Example

PID*F****XXXX~

PID-01

349

Item Description Type

Required

Identifier (ID)

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

Optional

String (AN)

Min 1Max 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

Usage notes

The TDS01 element is used to list the Total monetary amount of the invoice AFTER Taxes and before Terms Discount or Rebates.
 
The amounts listed in the TDS 01 data element MUST be the same as the amounts listed on Account Statements sent by the trading partner to BestBuy Canada Accounting department.
 
The TDS02 element is used to list the Amount upon which terms discount is calculated. This is the amount BEFORE Taxes and without any consideration of discounts or rebates.

The calculated sum {Quantity [IT102] multiplied by Unit Price [IT104]} of all IT1 line items MUST equal the amount listed in TDS02 data element.

The amounts listed in TDS01 and TDS02 data elements have an implied decimal. For example, BestBuy Canada system will interpret the value 11400 as 114.00.

Example

TDS*000000*00~

TDS-01

610

Amount

Required

Numeric (N2)

Min 1Max 15

Monetary amount

  • TDS01 is the total amount of invoice (including charges, less allowances) before terms discount (if discount is applicable).

TDS-02

610

Amount

Optional

Numeric (N2)

Min 1Max 15

Monetary amount

  • TDS02 indicates the amount upon which the terms discount amount is calculated.
  • TDS02 is required if the dollar value subject to discount is not equal to the dollar value of TDS01.

TXI

020

Tax Information

RequiredMax use 10

To specify tax information

Usage notes

If GST Tax is charged and is transmitted in the TXI segment, then the GST Registration Number MUST be transmitted in the REF segment (See Note 2 on Page 21).

Trading Partners MUST transmit 0.00 in TXI 02 and use CG in TXI 01 if no GST is charged.

Trading Partners should not transmit PST tax for any Inventory Purchase Orders. If PST tax is received for Inventory Purchase Orders, the invoice will be rejected and an email notification will be sent to the email address provided during EDI setup.

Example

TXI*VA*000000000~

TXI-01

963

Tax Type Code

Required

Identifier (ID)

Code specifying the type of tax

CG

Federal Value-added Tax (GST) on Goods

SP

State/Provincial Tax

ST

State Sales Tax

VA

Value Added Tax

TXI-02

782

Monetary Amount

Optional

Decimal number (R)

Min 1Max 15

Monetary amount

  • TXI02 is the monetary amount of the tax.

CAD

030

Carrier Detail

OptionalMax use 1

To specify transportation details for the transaction

Example

CAD*XX***XXX*XXXXXX**XX*XXXXX~

At least one of Standard Carrier Alpha Code (CAD-04) or Routing (CAD-05) is required

If Reference Identification Qualifier (CAD-07) is present, then Reference Identification (CAD-08) is required

CAD-01

91

Transportation Method/Type Code

Optional

Identifier (ID)

Min 1Max 2

Code specifying the method or type of transportation for the shipment

CAD-04

140

Standard Carrier Alpha Code

Optional

Identifier (ID)

Min 2Max 4

Standard Carrier Alpha Code

CAD-05

387

Routing

Optional

String (AN)

Min 1Max 35

Free-form description of the routing or requested routing for shipment, or the originating carrier's identity

CAD-07

128

Reference Identification Qualifier

Optional

Identifier (ID)

Min 2Max 3

Code qualifying the Reference Identification

CAD-08

127

Reference Identification

Optional

String (AN)

Min 1Max 30

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

SAC Loop

OptionalMax >1

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

The SAC segment currently is not used by BestBuy Canada. If this segment is included in the invoice file, the full invoice will be rejected in EDI and an email notification will be sent by the system to the email id listed for the partner during the initial EDI setup.

The SAC segment may be used in the future to capture Service Charges that BestBuy Canada accounting department and Trading Partners feel are relevant to the Invoice.

Example

SAC*X*A172***000**********XXXXXX~

SAC-01

248

Allowance or Charge Indicator

Required

Identifier (ID)

Min 1Max 1

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.

SAC-02

1300

Service, Promotion, Allowance, or Charge Code

Optional

Identifier (ID)

Code identifying the service, promotion, allowance, or charge

A172

Administrative

SAC-05

610

Amount

Optional

Numeric (N2)

Min 1Max 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.

SAC-15

352

Description

Optional

String (AN)

Min 1Max 80

A free-form description to clarify the related data elements and their content

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.

Example

CTT*00*0~

CTT-01

354

Number of Line Items

Required

Numeric (N0)

Min 1Max 6

Total number of line items in the transaction set

CTT-02

347

Hash Total

Optional

Decimal number (R)

Min 1Max 10

Sum of values of the specified data element. All values in the data element will be summed without regard to decimal points (explicit or implicit) or signs. Truncation will occur on the left most digits if the sum is greater than the maximum size of the hash total of the data element.

## Example:
 
-.0018 First occurrence of value being hashed.
 
.18 Second occurrence of value being hashed.
 
1.8 Third occurrence of value being hashed.
 
18.01 Fourth occurrence of value being hashed.

1855 Hash total prior to truncation.
 
855 Hash total after truncation to three-digit field.

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)

Example

SE*0000000000*0001~

SE-01

96

Number of Included Segments

Required

Numeric (N0)

Min 1Max 10

Total number of segments included in a transaction set including ST and SE segments

SE-02

329

Transaction Set Control Number

Required

Numeric (N)

Min 4Max 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

Example

GE*000*00000000~

GE-01

97

Number of Transaction Sets Included

Required

Numeric (N0)

Min 1Max 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

Numeric (N0)

Min 1Max 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

Example

IEA*00*000000000~

IEA-01

I16

Number of Included Functional Groups

Required

Numeric (N0)

Min 1Max 5

A count of the number of functional groups included in an interchange

IEA-02

I12

Interchange Control Number

Required

Numeric (N0)

Min 9Max 9

A control number assigned by the interchange sender

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article