Impguide
Impguide
810 Invoice
Version: 4010
Table of Contents
810 Invoice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .<PH>
. . . 1
ISA Interchange Control Header . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .<PH>
. . . 3
GS Functional Group Header . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . . 5
ST Transaction Set Header . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . . 6
BIG Beginning Segment for Invoice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . . 7
NTE Note/Special Instruction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . . 8
CUR Currency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . . 9
N1 Name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 10
N3 Address Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 11
N4 Geographic Location . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 12
ITD Terms of Sale/Deferred Terms of Sale . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 13
DTM Date/Time Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 15
FOB F.O.B. Related Instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 16
IT1 Baseline Item Data (Invoice) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 17
PID Product/Item Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 19
TDS Total Monetary Value Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 21
TXI Tax Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 22
CAD Carrier Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 24
SAC Service, Promotion, Allowance, or Charge Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 25
ISS Invoice Shipment Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 27
CTT Transaction Totals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 28
SE Transaction Set Trailer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 29
GE Functional Group Trailer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 30
IEA Interchange Control Trailer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . <PH>
. . 31
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 1
810 Invoice
Functional Group= IN
Purpose: 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.
User Note 1:
These 810 guidelines include the Invoice data requirements for submitting invoices for both Stock and
SOS purchases orders shipped for Lowe’s.
The SOS Invoice should include the same SOS PO line items with any of the following charges, if
applicable. Lowe’s accepts only the following additional charge in the SAC segment; any other charge
will cause the invoice to reject in CommerceHub.
* Excise Tax for Hawaii and Alaska only
* California Carpet Stewardship Assessment Fees
* Environmental Protection Service
The vendor’s SOS item should have all charges built into the cost of goods as approved by Lowe’s
Merchandising Team. Upon receipt of a Lowe’s SOS PO, the vendor should ensure each line item on the
PO encompasses all costs before submitting an order status. If an additional charge is realized, the
vendor may contact the store to review the SOS PO or submit an Invalid Item data exception in the order
status. When a data exception is submitted, the original PO must be cancelled and a new PO released if
the additional costs are approved by the store/customer.
Heading:
Pos Id Segment Name Req Max Use Repeat Notes Usage
ISA Interchange Control Header M 1 Mandatory
GS Functional Group Header M 1 Mandatory
010 ST Transaction Set Header M 1 Mandatory
020 BIG Beginning Segment for M 1 Mandatory
Invoice
030 NTE Note/Special Instruction O 100 Optional
040 CUR Currency O 1 Mandatory
LOOP ID - N1 200
070 N1 Name O 1 Mandatory
090 N3 Address Information O 2 Optional
100 N4 Geographic Location O 1 Optional
130 ITD Terms of Sale/Deferred O >1 Mandatory
Terms of Sale
140 DTM Date/Time Reference O 10 Mandatory
150 FOB F.O.B. Related Instructions O 1 Mandatory
Detail:
Pos Id Segment Name Req Max Use Repeat Notes Usage
LOOP ID - IT1 200000
010 IT1 Baseline Item Data O 1 Mandatory
(Invoice)
LOOP ID - PID 1000
060 PID Product/Item Description O 1 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 2
Summary:
Pos Id Segment Name Req Max Use Repeat Notes Usage
010 TDS Total Monetary Value M 1 Mandatory
Summary
020 TXI Tax Information O 10 Conditional
030 CAD Carrier Detail O 1 Mandatory
LOOP ID - SAC 25
040 SAC Service, Promotion, O 1 Optional
Allowance, or Charge
Information
Not Defined:
Pos Id Segment Name Req Max Use Repeat Notes Usage
GE Functional Group Trailer M 1 Mandatory
IEA Interchange Control Trailer M 1 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 3
Pos: Max: 1
ISA Interchange Control Header Heading - Mandatory
Loop: N/A Elements: 16
User Note 1:
Example:
USA/CAN:
ISA*00* *00* 01*SENDER ID *01*006097142 *040702*1709*U*00400*000000133*0*P*>\
MEX:
ISA*00* *00* 01*SENDER ID *08*6135830008 *040702*1709*U*00400*000000133*0*P*>\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
ISA01 I01 Authorization Information Qualifier M ID 2/2 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 4
Code Name
00400 Standard Issued as ANSI X12.5-1997
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 5
Pos: Max: 1
GS Functional Group Header Heading - Mandatory
Loop: N/A Elements: 8
User Note 1:
Example:
USA/CAN:
GS*IN*SENDER ID*006097142*20040702*1709*304*X*004010\
MEX:
GS*IN*SENDER ID*6135830008*20040702*1709*304*X*004010\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
GS01 479 Functional Identifier Code M ID 2/2 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 6
User Note 1:
Example:
ST*810*2275\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
ST01 143 Transaction Set Identifier Code M ID 3/3 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 7
User Note 1:
Example:
BIG*20040701*257348*20040630*123456789***DR\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
BIG01 373 Date M DT 8/8 Mandatory
User Note 1: Lowe's Payables system can only handle a 10-digit invoice number. If
you send more than 10 digits the invoice number will be truncated.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 8
User Note 1:
Example:
NTE*GEN*1ZE445120311631005\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
NTE01 363 Note Reference Code O ID 3/3 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 9
User Note 1:
The currency code used is the three letter ISO 4217 international standard code (USD/CAD/MXN).
Example:
CUR*SE*USD\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
CUR01 98 Entity Identifier Code M ID 2/3 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 10
User Note 1:
Example:
N1*ST**92*960\
N1*MA**92*701\
N1*RI**94*12345\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
N101 98 Entity Identifier Code M ID 2/3 Mandatory
User Note 1: **Cross Dock Orders - Your incoming purchase order will reflect the
ship to store (ST) and the store that the goods are intended for (MA). On your 810
document to Lowe's, only send the N1 segment with the MA qualifier. If two N1
segments are transmitted (MA and ST), the N1 segment with the MA in N1-01 must be
the second in the sequence of N1's.
N1*ST**92*960 (ship to RDC)
N1*MA**92*701 (ultimate store destination)
***If transmitted with the ST last, our invoice will pick up store #960 and the invoice
will be kicked back for invalid store number.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 11
User Note 1:
Example:
N3*street address\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
N301 166 Address Information M AN 1/55 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 12
User Note 1:
If country code specified in N404 is CAN, then the Canadian Standard Postal Format must be used. The
postal code should be in upper case and expressed in the format of ANA NAN, where A = alpha and N =
numeric. It should have one space between the first three and last three positions.
The country code used is the three letter ISO 3166 international standard code (USA/CAN/MEX).
Example:
N4*city*state/province*postal code*country\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
N401 19 City Name O AN 2/30 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 13
User Note 1:
When providing discount terms, ITD01=08, ITD02=3, ITD03 must be given with a value greater than zero,
either ITD04 or ITD05 must be given, either ITD06 or ITD07 must be given, ITD08 must be given with a
value greater than zero, and ITD12 must be given.
When there are no discount terms, ITD01=05, ITD02=3, either ITD06 or ITD07 must be given, and ITD12
must be given.
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
ITD01 336 Terms Type Code O ID 2/2 Mandatory
User Note 1: If Lowe's receives a Terms discount, the Terms Discount Due Date
(ITD04) or Terms Discount Days (ITD05) must be used. Do not use both.
User Note 1: If Lowe's receives a Terms discount, use the number of days from
invoice date to discount due date. Terms Discount Due Date (ITD04) can be used
instead. Do not use both.
User Note 1: Use Terms Net Due Date (ITD06) or Terms Net Days Due (ITD07), Do not
use both. One of these elements MUST be present on ALL invoices.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 14
User Note 1: Use number of days from invoice date (BIG01) to due date. Terms Net
Due Date (ITD06) can be used instead. Do not use both.
User Note 1: Total amount of terms discount. If you offer Lowe's a terms discount,
the amount of the discount must be present.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 15
User Note 1:
Example:
DTM*011*20040701\
DTM*008*20040630\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
DTM01 374 Date/Time Qualifier M ID 3/3 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 16
User Note 1:
Example:
FOB*PC\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
FOB01 146 Shipment Method of Payment M ID 2/2 Mandatory
User Note 1: Code should match the code received on Lowe's PO. If 'PC' is used,
there must be a SAC segment containing the freight charges. Freight charges
CANNOT be transmitted to Lowe's as a line item. If 'CF' is used, there must be a SAC
segment containing the freight allowance.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 17
User Note 1:
Example:
IT1*1*20*EA*3.25**CB*40971***UK*00123456789012\
**Depending on the country you are shipping the product to, remember any one item number could have
multiple model numbers. Please remember to fill the order using your model number and invoice Lowe's
using Lowe's item number.
If you are not receiving any model numbers on your EDI POs, contact Lowe's EDI Analyst. If you have a
model number missing or incorrect, your salesperson should contact Lowe's Merchandising to get your
model number entered or corrected.**
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
IT101 350 Assigned Identification O AN 1/20 Mandatory
User Note 1: Unit of measure should match the unit of measure indicated on the
purchase order.
All valid standard codes are used. (Total Codes: 794)
User Note 1: Please be sure you understand pricing for your product before you
begin sending your production invoices.
User Note 1: Always use the Lowe's SKU that is provided on the Lowe's purchase
order.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 18
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 19
User Note 1:
The EDI 850 PID*F segment includes the Item Description and must be echoed back in the EDI 810 Invoice
(PID01=F).
PID*F****LIGHT BULBS\
An additional PID segment (PID01=X) is required for Environmental Protection Agency (EPA)
formaldehyde compliance reporting. The following are the options and PID syntax examples.
Non-Compliant
PID*X**VI*GM04COMPFE*0\
Phase 1 Compliant (California Air Resources Board (CARB) Act of 2009 - Phase 1)
PID*X**VI*GM04COMPFE*1\
Phase 2 Compliant (California Air Resources Board (CARB) Act of 2010 - Phase 2)
PID*X**VI*GM04COMPFE*2\
No Added Formaldehyde
PID*X**VI*GM04COMPFE*3\
TSCA (Toxic Substances Control Act) Title VI pertains to the Formaldehyde Standards for Composite
Wood Products Act
PID*X**VI*GM04COMPTS*5\
When a product is formaldehyde compliant for both CARB Act of 2010 - Phase 2 and TSCA EPA rulings,
send
PID*X**VI*GM04COMPTS*5\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
PID01 349 Item Description Type M ID 1/1 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 20
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 21
User Note 1:
Example:
TDS*7175\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
TDS01 610 Amount M N2 1/15 Mandatory
User Note 1: Total invoice amount due. This total should include any allowance or
charge amounts, but will not reflect any terms discounts given in the ITD (payment
terms) segment.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 22
User Note 1:
The TXI segment is used for Canada and Mexico tax.
Canada
When TXI01=CG, TXI02=Canada GST tax.
When TXI01=OH, TXI02=Quebec Canada QST tax.
When TXI01=PG, TXI02=Canada Provincial tax.
When TXI01=ZZ. TXI02=Canada HST tax.
Mexico
When TXI01=VA, TXI02=Mexico IVA (VAT tax).
The TXI-02 must be sent as no more than 18 whole number positions and up to 2 decimals.
These elements are only applicable for Canada: TXI03, TXI04, TXI05, and TXI09.
Example:
TXI*CG*3.90*5******123456789 - GST
TXI*OH*7.34*.25******1234567890 - QST
TXI*PG*1.84*7.6*VD*AB****123456789012345 - PST
TXI*ZZ*9.10*12.18******123456789 - HST
TXI*VA*8.35\ - VAT
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
TXI01 963 Tax Type Code M ID 2/2 Mandatory
User Note 1: TXI03 is only applicable for Canada. This field should include the tax
rate percent.
For example, a 5% tax should be expressed as 5 and 7.6% tax should be expressed
as 7.6.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 23
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 24
User Note 1:
Example:
CAD****ABCF\
CAD*****ABC FREIGHT LINES\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
CAD04 140 Standard Carrier Alpha Code X ID 2/4 Optional
User Note 1: Standard Carrier Alpha Code (4 letter alpha code assigned to all freight
carriers).
User Note 1: Name of carrier trucking company. Not necessary if SCAC code is
given in CAD04.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 25
Information
User Option (Usage): Optional
Purpose: To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for
the service, promotion, allowance, or charge
User Note 1:
Example:
SAC*C*D240***675*******06***FREIGHT CHARGE\
Additional Information:
SAC02=H850 conveys Excise Tax for Hawaii and Alaska only.
For Special Order Sales POs, only the following SAC codes are permitted for the Invoice. If other SAC
codes are submitted, the Invoice will reject.
* C680 Environmental Protection Service
* G090 California Carpet Stewardship Assessment Fee
* H850 Excise Tax for Hawaii and Alaska only
The vendor’s SOS item should have all charges built into the cost of goods as approved by Lowe’s
Merchandising Team. Upon receipt of a Lowe’s SOS PO, the vendor should ensure each line item on the
PO encompasses all costs before submitting an order status. If an additional charge is realized, the
vendor may contact the store to review the SOS PO or submit an Invalid Item data exception in the order
status. When a data exception is submitted, the original PO must be cancelled and a new PO released if
the additional costs are approved by the store/customer.
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
SAC01 248 Allowance or Charge Indicator M ID 1/1 Mandatory
User Note 1: An 'A' will indicate a reduction in the invoice amount. A 'C' will indicate
a charge, or an increase in the invoice amount.
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 26
Code Name
A720 Broken Package Charge
B940 Cutting Charge
C000 Defective Allowance
C680 Environmental Protection Service
D240 Freight
D270 Fuel Surcharge
D500 Handling
D530 Hazardous Cargo Charge
E740 New Store Allowance
F180 Pallet
G090 Recovery Fee
G470 Restocking Charge
G870 Shrink-Wrap Charge
H000 Special Allowance
H850 Tax
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 27
User Note 1:
Example:
ISS*1*PL\
ISS*2*CA\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
ISS01 382 Number of Units Shipped X R 1/10 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 28
User Note 1:
Example:
CTT*1\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
CTT01 354 Number of Line Items M N0 1/6 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 29
User Note 1:
Example:
SE*23*2275\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
SE01 96 Number of Included Segments M N0 1/10 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 30
Pos: Max: 1
GE Functional Group Trailer Not Defined - Mandatory
Loop: N/A Elements: 2
User Note 1:
Example:
GE*1*304\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
GE01 97 Number of Transaction Sets Included M N0 1/6 Mandatory
X12V4010 9/28/2018
Lowe's Companies, Inc. Invoice - 810 31
Pos: Max: 1
IEA Interchange Control Trailer Not Defined - Mandatory
Loop: N/A Elements: 2
User Note 1:
Example:
IEA*1*000000133\
Element Summary:
Ref Id Element Name Req Type Min/Max Usage
IEA01 I16 Number of Included Functional Groups M N0 1/5 Mandatory
X12V4010 9/28/2018