LOWE'S EDI - 1 EDI Source

Transcription

LOWE'S EDI846 Inventory Inquiry/AdviceVersion: 6010Author:Modified:Lowe's Companies, Inc.8/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 8462Table of Contents846 Inventory Inquiry/Advice . 3ISAInterchange Control Header . 5GSFunctional Group Header . 7STTransaction Set Header . 8BIA Beginning Segment for Inventory Inquiry/Advice . 9REF Reference Information . 10N1Party Identification . 11LINItem Identification . 12PIDProduct/Item Description. 13CTP Pricing Information . 14QTY Quantity Information . 15CTT Transaction Totals. 16SETransaction Set Trailer . 17GEFunctional Group Trailer . 18IEAInterchange Control Trailer . 19X12V60108/4/2016

Lowe's Companies, Inc.846Inventory Inquiry/Advice - 8463Inventory Inquiry/AdviceFunctional Group IBPurpose: This document includes the 846 Inventory Inquiry/Advice Transaction Set data requirements for reporting weekly consignmentinventory within our Flatbed Distribution Centers (FDCs) for an assigned Lowe's vendor number. The EDI 846 transaction should be usedfor informational purposes only by Lowe's consignment vendors.It also provides our consignment vendors with an assigned Lowe's purchase order number to be used for invoicing the items shipped asincluded in this weekly transaction. The purchase order number included in this transaction should not be used to ship product to Lowe'sfacilities. It is for invoicing purposes only.The consignment item detail in this transaction is reported by vendor number by FDC by item and includes these data fields:Lowe's item number and descriptionOld Balance Quantity - Amount of inventory on-hand at the beginning of the previous buy-over week (the beginning inventory balance).Item Cost - For Commodity Consignment PO, per thousand cost per item. For Non-Commodity Consignment PO, per piece cost foreach item. The per piece cost for the received cost per item is included for all PO Types.Received Quantity - Amount of product received for during the previous buy-over week.Shipped Quantity - Amount of product shipped during the previous buy-over week which should be used for invoicing.Adjustment Quantity - Amount of adjustments that occurred during the previous buy-over week.New Balance Quantity - Amount of inventory on-hand as of the buy-over week ending date (the ending inventory balance).This transaction will be sent to Lowe's consignment vendors with our last outbound schedule each Friday. The data included in thistransaction represents the inventory activity by vendor number by consignment item that occurred from Friday through Thursday for eachFDC.An EDI 997 Functional Acknowledgment is required from our trading partners to confirm receipt of each 846 transaction.For technical EDI questions, please use this document to identify Lowe's EDI Coordinator that handles your s/EDI QUICK REFERENCE.pdfFor questions related to the actual data contents, please contact the specific FDC.ADDITIONAL NOTESAll usages under the label "Req" denote X12 usages. All usages under the label "Usage" denote Lowe's usages.Heading:Pos01000200IdISAGSSTBIA0600REFLOOP ID - N10800N1Segment NameInterchange Control HeaderFunctional Group HeaderTransaction Set HeaderBeginning Segment for InventoryInquiry/AdviceReference InformationReqMMMMMax oryMandatoryMandatory5Party IdentificationO1ReqMax UseItem IdentificationProduct/Item DescriptionPricing InformationMOO120025Quantity InformationO1MandatoryDetail:PosIdLOOP ID - LIN0100LIN0300PID1100CTPLOOP ID - QTY3200QTYSegment NameRepeat ummary:X12V60108/4/2016

Lowe's Companies, Inc.Pos01000200Inventory Inquiry/Advice - 8464IdCTTSESegment NameTransaction TotalsTransaction Set TrailerReqOMMax IEASegment NameFunctional Group TrailerInterchange Control TrailerReqMMMax X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 8465Pos:Max: 1Heading - MandatoryLoop: N/AElements: 16Interchange Control HeaderISAUser Option (Usage): MandatoryPurpose: To start and identify an interchange of zero or more functional groups and interchange-related control segmentsElement Summary:RefISA01IdI01Element NameAuthorization Information eList Summary (Total Codes: 9, Included: 1)CodeName00No Authorization Information Present (No Meaningful Information in I02)ISA02I02Authorization e Note: This element should be filledwith spaces.ISA03I03Security Information QualifierCodeList Summary (Total Codes: 2, Included: 1)CodeName00No Security Information Present (No Meaningful Information in I04)ISA04I04Security InformationMAN10/10Mandatory1Please Note: This element should be filledwith spaces.ISA05I05Interchange ID Qualifier for Lowe'sMID2/2Mandatory1ISA06I06Interchange Sender ID for Lowe'sMAN15/15Mandatory1ISA07I05Interchange ID Qualifier for ReceiverMID2/2Mandatory1All valid X12 codes are used. (TotalCodes: 41)ISA08I07Interchange Receiver IDMAN15/15Mandatory1ISA09I08Interchange DateMDT6/6Mandatory1ISA10I09Interchange TimeMTM4/4Mandatory1ISA11I65Repetition SeparatorMAN1/1Mandatory1MID5/5Mandatory1Please Note: The ISA11 has a type codeof ‘AN’ which is not currently applicable tothis field. It will include a (caret) symbol;hex value for EBCDIC is 5F or ASCII is 5E.ISA12I11Interchange Control Version NumberCodeList Summary (Total Codes: 27, Included: 1)CodeName00600ASC X12 Standards Issued by ANSI in 2008ISA13I12Interchange Control NumberMN09/9Mandatory1ISA14I13Acknowledgment RequestedMID1/1Mandatory11/1Mandatory1CodeList Summary (Total Codes: 2, Included: 1)CodeName0No Interchange Acknowledgment RequestedISA15I14Interchange Usage IndicatorMX12V6010ID8/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 8466CodeList Summary (Total Codes: 3, Included: 2)CodeNamePProduction DataTTest DataISA16I15Component Element 1*006097142*01*receiver's id *110826*1700* *00600*000000001*0*P* \ (see note above onX12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 8467Pos:Max: 1Heading - MandatoryLoop: N/AElements: 8Functional Group HeaderGSUser Option (Usage): MandatoryPurpose: To indicate the beginning of a functional group and to provide control informationElement Summary:RefGS01Id479Element NameFunctional Identifier CodeReqMTypeIDMin/Max2/2UsageMandatoryRep1CodeList Summary (Total Codes: 260, Included: 1)CodeNameIBInventory Inquiry/Advice (846)GS02142Application Sender's Code for Lowe'sMAN2/15Mandatory1GS03124Application Receiver's 05337TimeMTM4/8Mandatory1GS0628Group Control NumberMN01/9Mandatory1GS07455Responsible Agency CodeMID1/2Mandatory1AN1/12Mandatory1CodeList Summary (Total Codes: 2, Included: 1)CodeNameXAccredited Standards Committee X12GS08480Version / Release / Industry IdentifierCodeMCodeList Summary (Total Codes: 71, Included: 1)CodeName006010Standards Approved for Publication by ASC X12 Procedures Review Board through October2008Example:GS*IB*006097142*receiver's 16

Lowe's Companies, Inc.Inventory Inquiry/Advice - 8468Pos: 0100Max: 1Heading - MandatoryLoop: N/AElements: 2Transaction Set HeaderSTUser Option (Usage): MandatoryPurpose: To indicate the start of a transaction set and to assign a control numberElement Summary:RefST01Id143Element NameTransaction Set Identifier datory1CodeList Summary (Total Codes: 319, Included: 1)CodeName846Inventory Inquiry/AdviceST02329Transaction Set Control NumberMExample:ST*846*000000001\X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 8469Beginning Segment for InventoryInquiry/AdviceBIAPos: 0200Max: 1Heading - MandatoryLoop: N/AElements: 4User Option (Usage): MandatoryPurpose: To indicate the beginning of an Inventory Inquiry/Advice Transaction SetElement Summary:RefBIA01Id353Element NameTransaction Set Purpose datory1MAN1/80Mandatory1MDT8/8Mandatory1CodeList Summary (Total Codes: 67, Included: 1)CodeName22Information CopyBIA02755Report Type CodeMCodeList Summary (Total Codes: 553, Included: 1)CodeNameSISeller Inventory ReportBIA03127Reference IdentificationPlease Note: This field will include a valueof WEEKLY.This will assist to identify the 846represents weekly consignment reporting.BIA04373DatePlease Note: This data field includes theWeek Ending Date; format 08/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84610Pos: 0600Max: 12Heading - OptionalLoop: N/AElements: 2Reference InformationREFUser Option (Usage): MandatoryPurpose: To specify identifying informationElement Summary:RefREF01Id128Element NameReference Identification /80Mandatory1CodeList Summary (Total Codes: 1795, Included: 3)CodeNameIAInternal Vendor NumberPOPurchase Order NumberRERelease NumberREF02127Reference IdentificationXPlease Note:For each 846, there should be three REF segments.When REF01 IA, REF02 Lowe's assigned consignment vendor number.When REF01 PO, REF02 Purchase Order Number to be used for Invoicing purposes for items shipped during the previous buy-overweek. The purchase order number included in this transaction should not be used to ship product to Lowe's facilities. It is for invoicingpurposes only. When there are no items shipped during the previous buy-over week (QTY01 94 and QTY02 0 ), the purchase ordernumber should not be used for invoicingWhen REF01 RE, REF02 Purchase Order RR (Release) Number. The RR Number may be greater than 1 when a Purchase Order hasbeen adjusted. Always use the highest RR Number when processing this transaction for a specific vendor number and specific FDC.810 TURN AROUND INFORMATION:The Purchase Order transmitted in the REF02 of the 846 must be returned in the BIG04 field of the 810 invoice.Example:Lowe's assigned Consignment Vendor NumberREF*IA*99999Purchase Order NumberREF*PO*999999999Purchase Order RR (Release) NumberREF*RE*1X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84611Pos: 0800Max: 1Heading - OptionalLoop: N1Elements: 4Party IdentificationN1User Option (Usage): MandatoryPurpose: To identify a party by type of organization, name, and codeElement Summary:RefN101Id98Element NameEntity Identifier onditional1XID1/2Conditional1Conditional1CodeList Summary (Total Codes: 1521, Included: 2)CodeNameSFShip FromSTShip ToN10293NamePlease Note: When N101 SF, N102 willinclude the Lowe's assigned consignmentvendor name.N10366Identification Code QualifierCodeList Summary (Total Codes: 251, Included: 1)CodeName93Code assigned by the organization originating the transaction setN10467Identification CodeXAN2/80Please Note:For each 846, there should be two N1 segments.When the N101 ST, the N102 is blank, the N103 93, and the N104 includes the Lowe's FDC location number. Its value is currently aminimum of two-digits and a maximum of five-digits. It is also zero-suppressed.When the N101 SF, the N102 includes the Lowe's assigned consignment vendor name, and the N103 and N104 are not included.810 TURN AROUND INFORMATION:You must return the N1-01 and N1-04 element of the 846 in the N1-01 and N1-04 of the 810 invoice. However, the N1-03 will havedifferent qualifiers sent in the 810 invoice than what was received in the 846.Example:FDC location numberN1*ST**93*9999\Ship From Lowe's assigned consignment vendor nameN1*SF*vendor name\X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84612Pos: 0100Max: 1Detail - MandatoryLoop: LINElements: 2Item IdentificationLINUser Option (Usage): MandatoryPurpose: To specify basic item identification dataElement Summary:RefLIN02Id235Element NameProduct/Service ID /80Mandatory1CodeList Summary (Total Codes: 518, Included: 1)CodeNameCBBuyer's Catalog NumberLIN03234Product/Service IDMPlease Note:The segment includes Lowe's item number. The item number may be up to 9-digits in length. This field is zero-suppressed.810 TURN AROUND INFORMATION:When an item has a shipped quantity (QTY01 94) greater than zero (QTY02), include the same amount for the invoice quantity along withthe same item details in the LIN segment of the 846 in the IT1 segment of the 810.Example:6-digit item number.LIN**CB*999999\3-digit item numberLIN**CB*999\X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84613Pos: 0300Max: 200Detail - OptionalLoop: LINElements: 2Product/Item DescriptionPIDUser Option (Usage): MandatoryPurpose: To describe a product or process in coded or free-form formatElement Summary:RefPID01Id349Element NameItem Description ndatory1CodeList Summary (Total Codes: 3, Included: 1)CodeNameFFree-formPID05352DescriptionXPlease Note:810 TURN AROUND INFORMATION:Please return the PID segment the same as received in the 846, in the PID segment of the 810 invoice.Example:PID*F****1 QT PERENNIALS\X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84614Pos: 1100Max: 25Detail - OptionalLoop: LINElements: 2Pricing InformationCTPUser Option (Usage): MandatoryPurpose: To specify pricing informationElement Summary:RefCTP02Id236Element NamePrice Identifier datory1CodeList Summary (Total Codes: 168, Included: 2)CodeNameCONContract PriceUCPUnit cost priceCTP03212Unit PriceXPlease Note:Two CTP segments are included for each line item.Commodity Consignment POsWhen CTP02 CON, CTP03 includes a per thousand cost per item.When CTP02 UCP, CTP03 includes the per piece cost for the received cost per item.Non-Commodity Consignment POsThe same value will be included in these two fields per item for Non-Commodity Consignment POs.When CTP02 CON, CTP03 includes a per piece cost for each item.When CTP02 UCP, CTP03 includes the per piece cost for the received cost per item.Example:Commodity Consignment y Consignment 16

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84615Pos: 3200Max: 1Detail - OptionalLoop: QTYElements: 2Quantity InformationQTYUser Option (Usage): MandatoryPurpose: To specify quantity informationElement Summary:RefQTY01Id673Element NameQuantity 5Mandatory1CodeList Summary (Total Codes: 1135, Included: 5)CodeName18Previous Week Quantity87Quantity Received94Billable QuantityDescription: Number of billable units usedA5Adjusted QuantityV2Available QuantityQTY02380QuantityXRPlease Note:For each item, a total of five QTY segments should be included.QTY02 may contain a negative value. If there are questions on the quantity, please contact the specific FDC.If there is a zero amount for one of the QTY segments, the QTY02 will include a value of 0 (zero).When QTY01 18, QTY02 the amount of inventory on-hand (the beginning inventory balance) at the FDC at the beginning of the previousbuy-over week (Old Balance Quantity).When QTY01 87, QTY02 the amount of product received for the item during the previous buy-over week at the FDC (ReceivedQuantity).When QTY01 94, QTY02 the amount of product shipped during the previous buy-over week from the FDC to Lowe's stores and theamount to be invoiced for the item (Shipped Quantity).When QTY01 A5, QTY02 the item adjustments that occurred during the previous buy-over week (Adjustment Quantity).When QTY01 V2, QTY02 the amount of inventory on-hand (the ending inventory balance) at the FDC as of the buy-over week endingdate (New Balance Quantity).Example:Amount of inventory on-hand (the beginning inventory balance) at the FDC at the beginning of the previous buy-over week for an itemQTY*18*9999Amount of product received for the item during the previous buy-over weekQTY*87*9999Amount of product shipped during the previous buy-over week from the FDC to Lowe's stores and the amount to be invoiced for the itemQTY*94*9999Amount of adjustments applied to an item during the previous buy-over weekQTY*A5*9999Amount of inventory on-hand (the ending inventory balance) at the FDC as of the buy-over week ending date for an itemQTY*V2*9999X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84616Pos: 0100Max: 1Summary - OptionalLoop: N/AElements: 1Transaction TotalsCTTUser Option (Usage): MandatoryPurpose: To transmit a hash total for a specific element in the transaction setElement Summary:RefCTT01Id354Element NameNumber of Line ItemsReqMTypeN0Min/Max1/6UsageMandatoryRep1Please Note:This segment includes the number of LIN segments included in the 846.X12V60108/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84617Pos: 0200Max: 1Summary - MandatoryLoop: N/AElements: 2Transaction Set TrailerSEUser Option (Usage): MandatoryPurpose: To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) andending (SE) segments)Element Summary:RefSE01Id96Element NameNumber of Included SegmentsSE02329Transaction Set Control ep1MAN4/9Mandatory18/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84618Pos:Max: 1Heading - MandatoryLoop: N/AElements: 2Functional Group TrailerGEUser Option (Usage): MandatoryPurpose: To indicate the end of a functional group and to provide control informationElement Summary:RefGE01Id97Element NameNumber of Transaction Sets IncludedGE0228Group Control p1MN01/9Mandatory18/4/2016

Lowe's Companies, Inc.Inventory Inquiry/Advice - 84619Pos:Max: 1Heading - MandatoryLoop: N/AElements: 2Interchange Control TrailerIEAUser Option (Usage): MandatoryPurpose: To define the end of an interchange of zero or more functional groups and interchange-related control segmentsElement Summary:RefIEA01IdI16Element NameNumber of Included Functional GroupsIEA02I12Interchange Control p1MN09/9Mandatory18/4/2016

Lowe's Companies, Inc. Inventory Inquiry/Advice - 846 3 X12V6010 8/4/2016 846 Inventory Inquiry/Advice Functional Group IB This document includes the 846 Inventory Inquiry/Advice TransacPurpose: tion Set data requirements for reporting weekly consignment inventory within our Flatbed Distribution Centers (FDCs) for an assigned Lowe's vendor number.