{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["EDI Interchange HeaderFooters","Inventory Vendor EDI Translatio","Vendor Shipment EDI Translation","Cancel Order-Vendor EDI Transla","Vendor Invoice EDI Translation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EDI Interchange HeaderFooters","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,6,27,6],[28,6,29,6],[0,2,0,6],[2,0,17,0],[2,6,17,6],[18,0,25,0],[18,6,25,6],[26,0,27,0],[28,0,29,0]]}
["Inventory-Vendor EDI Translation"]
[null,"Element ID","Element Number","Name","Length ","Comment","EDI Example"]
["ISA Interchange Header","ISA01",{"$f":"CONCATENATE(LEFT(B3,1),RIGHT(B3,LEN(B3) - 3))","v":"I01"},"Authorization Information Qualifier",2.0," '00' for No authorization information present.","ISA*00*          *00*          *ZZ*EDIA214        *ZZ*DSCO           *180329*1214*U*00401*000000007*0*P*>"]
[null,"ISA02","I02","Authorization Information",10.0,"Not Used"]
[null,"ISA03","I03","Security Information Qualifier",2.0," '00' for No security information present."]
[null,"ISA04","I04","Security Information Qualifier",10.0,"Not Used"]
[null,"ISA05","I05","Interchange ID Qualifier",2.0," 'ZZ' for Mutually defined '01' for DUNS Number"]
[null,"ISA06","I06","Interchange Sender ID",15.0,"Sender ID"]
[null,"ISA07","I07","Interchange ID Qualifier",2.0," 'ZZ' for Mutually defined"]
[null,"ISA08","I08","Interchange Receiver ID",15.0,"Receiver ID"]
[null,"ISA09","I09","Date",6.0,"Date envelope was generated. (YYMMDD)"]
[null,"ISA10","I10","Time",4.0,"Time Envelope was generated. (HHMM)"]
[null,"ISA11","I11","Interchange Standards Identifier for 4010, Repeat Separator for 5010. ",1.0," 'U' for 4010, '<' for 5010"]
[null,"ISA12","I12","Interchange Version ID",5.0," '00401' for 4010 and '00501' for 5010"]
[null,"ISA13","I13","Interchange Control Number",9.0,"Sender assigned sequential number incremented by 1 for each transmission. "]
[null,"ISA14","I14","Acknowledgment Requested",1.0," '0' for No Interchange Acknowledgment and '1' if requested."]
[null,"ISA15","I15","Test Indicator",1.0," 'P' for Production data 'T' for Test data"]
[null,"ISA16","I16","Sub-element Separator",1.0," '>'"]
["GS Group Header","GS01",479.0,"Functional ID",2.0,"Functional Identification Code","GS*IB*EDIA214*DSCO*20180329*1214*7*X*004010"]
[null,"GS02",142.0,"Application Sender's Code","2021-02-15","Sender's ID"]
[null,"GS03",124.0,"Application Receiver's Code","2021-02-15","Receiver's ID"]
[null,"GS04",29.0,"Data Interchange Date",8.0,"Date Group was generated. (CCYYMMDD)"]
[null,"GS05",30.0,"Data Interchange Time",4.0,"Time Group was generated. (HHMM)"]
[null,"GS06",28.0,"Data Interchange Control Number","2021-01-09","Control number incremented by 1 for each group generated. "]
[null,"GS07",455.0,"Responsible Agency Code","2021-01-02","X' for Accredited Standards Committee X12."]
[null,"GS08",480.0,"Version","2021-01-12","004010VICS' for 4010 and '005010' for 5010"]
["GE Group Trailer","GE01",97.0,"Number of Included Transaction Sets","2021-01-06","Number of ST segments within the group.","GE*1*7"]
[null,"GE02",28.0,"Data Interchange Control Number","2021-02-09","Must match GS06."]
["IEA Interchange Tralier","IEA01",116.0,"Number of Included Groups",5.0,"Number of GS segments within the transmission.","IEA*1* 000000007"]
[null,"IEA02",112.0,"Interchange Control Number",9.0,"Must match ISA13."]

{"sheet":"Inventory Vendor EDI Translatio","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,8,0],[2,1,3,1],[2,2,8,2],[2,6,3,6],[4,1,8,1],[4,6,8,6],[13,0,14,0],[13,1,14,1],[15,1,16,1],[15,2,16,2],[17,0,18,0],[17,1,18,1],[19,1,21,1],[19,2,21,2],[19,6,21,6],[22,6,24,6],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,6,18,6],[11,1,12,1],[11,2,12,2],[13,2,14,2],[17,2,18,2],[25,1,27,1],[25,2,27,2],[25,6,27,6],[28,0,29,0],[28,1,29,1],[28,2,29,2],[28,6,29,6],[11,0,12,0],[15,0,16,0],[19,0,21,0],[22,0,24,0],[22,1,24,1],[22,2,24,2],[25,0,27,0]]}
["Inventory-Vendor EDI Translation"]
["Business Name","Description","Business Example","Element","Name","Comment","EDI Example"]
[null,"Transaction Set Header",null,"ST01","Transaction Set Identifier Code"," '846'","ST*846*123456789~"]
[null,null,null,"ST02","Transaction Set Control Number","Unique number that is incremented by 1 for each transaction set sent. (Maximum of 9 digits)"]
[null,"Beginning Segment for Inventory Inquiry",null,"BIA01","\nTransaction Set Purpose Code"," '00' for Original","BIA*00*MM*20210115*135000~"]
[null,null,null,"BIA02","\nReport Type Code"," 'MM' Manufacturers Inventory Report"]
[null,null,null,"BIA03","\nReference Identification","Sequential Reference Number"]
[null,null,null,"BIA04","Date","Date (CCYYMMDD format)"]
[null,null,null,"BIA05","Time","Time (HHMMSS format)"]
["SKU","The SKU of the item. A limit of 70 characters is enforced. NOTE:  JD Finish Line requires this to be the UPC",8.84942723438E11,"LIN02","\nProduct ID Qualifier"," 'SK' for SKU","LIN**S​K*884942723438*UP* 884942723438*MG*1234-BLK*UK*14141414141414*BL*Great Shoes USA~"]
[null,null,null,"LIN03","Product ID","The SKU of the item. A limit of 70 characters is enforced. A SKU is required. If a SKU is not available you may duplicate the UPC or EAN to this field."]
["UPC","The Universal Product Code (UPC). UPC Format Enforced. Field Limitations - UPC = 12 (UPC-A) digits.",8.84942723438E11,"LIN04","\nProduct ID Qualifier"," 'UP' for UPC"]
[null,null,null,"LIN05","Product ID","When the qualifier is 'UP': Universal Product Code (UPC)"]
["MPN","The Manufacturer Part Number (MPN).  NOTE:  JD Finish Line requires this field to be style-nrfcolor","style-NRFcolor","LIN06","\nProduct ID Qualifier"," 'MG' for Manufacturer's Part Number (MPN)"]
[null,null,null,"LIN07","Product ID","When the qualierifier is 'MG': Manufacturer's Part Number (MPN)"]
["GTIN","The Global Trade Item Number (GTIN). Field Limitations - GTIN = 8, 12, 13 or 14 digits.",1.2345678905E10,"LIN08","\nProduct ID Qualifier"," 'UK' for Global Trade Number (GTIN)"]
[null,null,null,"LIN09","Product ID","\nWhen the qualierifier is 'UK': Global Trade Item Number (GTIN)"]
["Brand","The name of the brand.","Great Shoes","LIN10","\nProduct ID Qualifier"," 'BL' for Brand/Label"]
[null,null,null,"LIN11","Product ID","When the qualierifier is 'BL': Brand/Manufacturer"]
["Title","The description of the item. ","Courmayeur Valley 6in w Shearling WP \nCourmayeur Valley 6in w Shearling WP WIDE\nW NSW ESSNTL HOODY PO FLC PLUS","PID01","Item Description Code"," 'F' for Free-form","PID*F*08***Courmayeur Valley 6in w Shearling WP~"]
[null,null,null,"PID02","Product/Process Characteristic Code"," '08' for Product Title"]
[null,null,null,"PID05","Description","The title of the SKU. A common practice is to concatenate this data with other fields (such as manufacturer and brand) to end up with a more complete title (e.g. 'Lenovo Thinkpad T410 Notebook')."]
["Quantity Available","The quantity available for order. The amount in the warehouse ready for shipment. If the exact quantity isn't known, use a value such as 100.",45.0,"QTY01","Quantity Qualifier"," '33' for Quantity Available for Sale (stock quantity).","QTY*33*10*EA~ "]
[null,null,null,"QTY02","Quantity  ","Numeric value of Quantity that is available for sale. If quantity is 0 or less than 0 than the status"]
[null,null,null,"QTY03","Composite Unit of Measure"," 'EA' for Each"]
["Status","The status of the given SKU. Options allowed are 'in-stock', 'out-of-stock' or 'discontinued'. If 'in-stock' is provided the quantity_available must be greater than 0. If no status is available then we will infer the status from the 'quantity_available' field. Status is required when updating an item to/from a discontinued status. The status of the item will not change to/from discontinued if this field is not included in the upload.","in-stock","REF01","Reference Identification Qualifier"," 'ZZ' for Mutually Defined","REF*ZZ*in-stock*status~"]
[null,null,null,"REF02","Reference Identification  ","The status of the given SKU. Options allowed are ‘in-stock’, ‘out-of- stock’, ‘discontinued’, ‘hidden’. If ‘in-stock’ is provided the quantity available (QTY 02) must be greater than 0. If no status is available then the status will be inferred from the quantity available (QTY 02)"]
[null,null,null,"REF03","Description"," 'status'"]
[null,"Transaction Set Trailer",null,"SE01","Number of Included Segments","Number of segments in transaction set including ST and SE.","SE*17*0001~"]
[null,null,null,"SE02","Transaction Set Control Number","Must match value in ST02."]

{"sheet":"Vendor Shipment EDI Translation","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,11,0],[2,1,3,1],[2,2,11,2],[2,6,3,6],[4,1,8,1],[12,0,15,0],[12,2,15,2],[9,1,11,1],[12,1,18,1],[17,0,18,0],[17,2,18,2],[19,0,20,0],[19,2,20,2],[21,0,22,0],[21,2,22,2],[19,1,20,1],[21,1,23,1],[24,0,26,0],[24,1,26,1],[24,2,26,2],[28,1,30,1],[28,2,30,2],[36,0,38,0],[37,1,38,1],[39,0,40,0],[39,1,40,1],[39,2,40,2],[28,0,30,0],[31,0,32,0],[31,1,32,1],[31,2,32,2],[33,0,34,0],[33,1,34,1],[33,2,34,2],[31,6,35,6],[37,6,38,6],[39,6,40,6],[4,6,8,6],[9,6,11,6],[12,6,18,6],[19,6,20,6],[21,6,23,6],[24,6,26,6],[28,6,30,6]]}
["Vendor Shipment EDI Translation-Vendor to Provide"]
["Business/Dsco Name","Description","Business Example","Element","Name","Comment","EDI Example"]
[null,"Transaction Header Set",null,"ST01","Transaction Set Identifier Code"," '856'","ST*856*123000000~"]
[null,null,null,"ST02","Transaction Set Control Number","Unique number that is incremented by 1 for each transaction set sent. (Maximum of 9 digits)"]
[null,"Beginning Segment for Ship Notice",null,"BSN01","\nTransaction Set Purpose Code"," '00' Original","BSN*00*004773*20210119*1300*0004~"]
[null,null,null,"BSN02","Shipment Identification","Unique control number assigned by Supplier to identify a specific shipment"]
[null,null,null,"BSN03","Date","Date. Format: CCYYMMDD"]
[null,null,null,"BSN04","Time","Time. Format: HHMM"]
[null,null,null,"BSN05","Hierarchical Structure Code"," '0004' for Shipment, Order, Item"]
[null,"Shipment Hierarchical Level",null,"HL01","Hierarchical ID Number"," '1'","HL*1**S~"]
[null,null,null,"HL02","\nHierarchical Parent ID Number","Empty"]
[null,null,null,"HL03","Hierarchical Level Code "," 'S' for Shipment"]
["Carrier","Carrier Details","UPS, FedEx, USPS","TD501","Qualifier"," 'Z' for Mutually Defined","TD5*Z*ZZ*UPS*ZZ*Ground**ZZ*UPCG~"]
[null,null,null,"TD502","Qualifier"," 'ZZ' for Mutually Defined"]
[null,null,null,"TD503","Code","Ship Carrier"]
[null,null,null,"TD504","Qualifier"," 'ZZ' for Mutually Defined"]
["Method",null,"Ground, Overnight, Smartpost, etc.","TD505","Code","Ship Method"]
["Shipping Service Level Code",null,"UPCG","TD507","Location Qualifier"," 'ZZ' for Mutually Defined"]
[null,null,null,"TD508","Location Identifier","Shipping Service Level Code"]
["Package Tracking Number","The tracking number of the package as assigned by the carrier.","1Z505EW1YW00061827","REF01","Reference Qualifier"," 'CN' for Package Tracking Number","REF*CN*1z9999999999999999~"]
[null,null,null,"REF02","Reference Identification","Package Tracking Number"]
["Package Ship Date","The date and time that the given package shipped.",2.0200124E7,"DTM01","Date/Time Qualifier"," '011' for Shipped Date","DTM*011*20200124*1400~"]
[null,null,null,"DTM02","Date","Date Shipped in format CCYYMMDD"]
["Package Ship Time",null,1400.0,"DTM03","Time","Time Shipped in format HHMM"]
[null,"Order Hierarchical Level",null,"HL01","Hierarchical ID Number","A unique number assigned by the sender to identify a particular data segment in a hierarchical structure.\nFor example: '2'","HL*2*1*O~"]
[null,null,null,"HL02","\nHierarchical Parent ID Number","Identification number of the next hierarchical data segment that the data segment being described is subordinate to.\nFor example: '1' (Parent is the shipment hierarchy)"]
[null,null,null,"HL03","Hierarchical Level Code "," 'O' for Order"]
["Purchase Order Number","The unique order identifier generated by the retailer's ordering system.",1.00403656E8,"PRF01","Purchase Order Number","PO number (as found in the BEG segment of the 850 transaction)","PRF*100403656~"]
[null,"Item Hierarchical Level",null,"HL01","Hierarchical ID Number","A unique number assigned by the sender to identify a particular data segment in a hierarchical structure. For example: '3'","HL*3*2*I~"]
[null,null,null,"HL02","\nHierarchical Parent ID Number","Identification number of the next hierarchical data segment that the data segment being described is subordinate to.\nFor example: '2' (Parent in the order hierarchy)"]
[null,null,null,"HL03","Hierarchical Level Code "," 'I' for Item"]
["Line Item Number","The number of the line item","01","LIN01","Assigned ID","Line Item Number on the PO","LIN*01*SK*884942723438*UP*884942723438~"]
[null,null,null,"LIN02","Product ID Qualifier"," 'SK' for SKU"]
["Line Item SKU","The SKU of the line item.  NOTE:  Finish Line requires the UPC in this field",8.84942723438E11,"LIN03","Product ID","The SKU of the item."]
[null,null,null,"LIN04","Product ID Qualifier"," 'UP' for UPC"]
["Line Item UPC","The UPC of the line item.",8.84942723438E11,"LIN05","Product ID","When the Qualifier is 'UP': Universal Product Code (UPC)"]
["Line Item Tracking Number","The tracking number of the package that included this specific line_item_sku.","1Z123456789"]
[null,"Shipment Item Detail",15.0,"SN102","Number of Units Shipped","Number of Units Shipped","SN1**1*EA~"]
[null,null,null,"SN103","Units or Basis for Measurement"," 'EA' for Each"]
[null,"Transaction Set Trailer",null,"SE01","Number of Included Segments","Number of segments in transaction set including ST and SE.","SE*19*123000000~"]
[null,null,null,"SE02","Transaction Set Control Number","Must match value in ST02"]

{"sheet":"Cancel Order-Vendor EDI Transla","index":3,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,6,7,6],[8,6,10,6],[12,6,14,6],[15,6,17,6],[18,6,25,6],[26,6,28,6],[0,1,0,6],[2,0,10,0],[2,1,3,1],[2,2,10,2],[2,6,3,6],[4,1,7,1],[8,1,10,1],[15,2,17,2],[18,2,23,2],[24,0,25,0],[24,2,25,2],[26,0,28,0],[26,1,28,1],[26,2,28,2],[12,0,14,0],[12,1,14,1],[12,2,14,2],[15,0,17,0],[15,1,17,1],[18,0,23,0],[18,1,25,1]]}
["Cancel Order EDI Translation-Vendor To Provide"]
["Business Name","Description","Business Example","Element","Name","Comment","EDI Example"]
[null,"Transaction Set Header",null,"ST01","Transaction Set Identifier Code"," '870'","ST*870*123456789~"]
[null,null,null,"ST02","Transaction Set Control Number","Unique number that is incremented by 1 for each transaction set sent. (Maximum of 9 digits)"]
[null,"Beginning Segment for Order Status Report",null,"BSR01","Status Report Code","2' - Prearranged Schedule","BSR*2*PP*411111*20210214~"]
[null,null,null,"BSR02","Order/Item Code"," 'PP' - Selected Orders - Selected Items"]
[null,null,null,"BSR03","Reference Identification","Vendor's reference number"]
[null,null,null,"BSR04","Date","Date (CCYYMMDD format)"]
[null,"Order Hierarchical Level",null,"HL01","Hierarchical ID Number"," '1' for the first order then sequential for each subsequent HL segment.","HL*1**O~"]
[null,null,null,"HL02","Parent Hierarchical ID Number"," '0'"]
[null,null,null,"HL03","Hierarchical Level Code"," 'O' for Order"]
["PO Number","The unique order identifier generated by the retailer's ordering system.",1.00403656E8,"PRF01","Purchase Order Number","PO Number","PRF*100403656~"]
["Cancel Reason","The reason the line_item has been cancelled. This could include reasons why the SKU was rejected, such as 'out-of-stock', 'restricted', 'duplicate' or it could indicate that the SKU is on backorder and will be shipped when new inventory is received. See below for Line Item Status Reasons.","Out of Stock","REF01","Reference Identification Qualifier"," 'TD' for Reason for Change","REF*TD*Out of stock*order_cancel_reason~"]
[null,null,null,"REF02","Reference Identification","The cancellation reason for the order assigned by the Supplier. For example: ‘Out of stock’"]
[null,null,null,"REF03","Description"," 'order_cancel_reason'"]
[null,"Order Hierarchical Level",null,"HL01","Hierarchical ID Number","A unique number assigned by the sender to identify a particular data segment in a hierarchical structure. For example: '2'","HL*2*1*I~"]
[null,null,null,"HL02","Parent Hierarchical ID Number","Identification number of the next hierarchical data segment that the data segment being described is subordinate to. For example: '1' (Parent is the order hierarchy)"]
[null,null,null,"HL03","Hierarchical Level Code"," 'I' - Item"]
["Line Item SKU","Baseline Item Data  NOTE:  JD Finish Line requires the SKU field and UPC field to be the UPC",8.84942723438E11,"PO101","Assigned Identification","Line item number on the PO","PO1*1*1*EA*5.5**SK*884942723438*UP*884942723438~"]
[null,null,null,"PO102","Quantity","Quantity being cancelled"]
[null,null,null,"PO103","\nUnit or Basis for Measurement"," 'EA' for Each"]
[null,null,null,"PO104","Unit Price","The expected cost of the item being ordered. Max with format: 9999.99. Attention: The decimal place must be included."]
[null,null,null,"PO106","Product ID Qualifier"," 'SK' for SKU"]
[null,null,null,"PO107","Product ID","The SKU of the item. A limit of 70 characters is enforced. A SKU is required. If a SKU is not available you may duplicate the UPC or EAN to this field."]
["Line Item UPC",null,8.84942723438E11,"PO108","Product ID Qualifier"," 'UP' for UPC"]
[null,null,null,"PO109","Product ID","When the Qualifier is 'UP': Universal Product Code (UPC)"]
["Cancel Code","Indicates the reason code for why the order line-item is being cancelled. Refer to Dsco's Order Cancel Mapping settings to customize the values you may use or view the current list of allowed codes.","CXSS","ISR01","Orders Status Code"," 'IC' for Item Cancelled","ISR*IC*20210214*W01~"]
[null,null,null,"ISR02","Date","Cancellation Date CCYYMMDD"]
[null,null,null,"ISR03","Status Reason Code","W01 - Out of Stock\nW13 - Not Enough Stock\nA83 - Discontinued Item\nA03 - Incorrect Address\n051 - Invalid Ship Instructions\nD50 - Can’t Ship on Time\nABN - Cancelled at Retailer Request \nA13 - Other"]

{"sheet":"Vendor Invoice EDI Translation","index":4,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,6,3,6],[4,1,7,1],[4,6,7,6],[8,0,10,0],[8,1,10,1],[8,2,10,2],[8,6,10,6],[11,0,13,0],[11,2,13,2],[11,6,13,6],[24,0,25,0],[24,1,25,1],[24,2,25,2],[24,6,25,6],[26,0,28,0],[26,1,28,1],[27,2,28,2],[27,6,28,6],[11,1,13,1],[14,1,22,1],[14,6,22,6],[19,0,20,0],[19,2,20,2],[21,0,22,0],[21,2,22,2]]}
["Vendor Invoice EDI Translation -Vendor to Provide"]
["Business Name","Description","Business Example","Element","Name","Comment","EDI Example"]
[null,"Transaction Set Header",null,"ST01","Transaction Set Identifier Code"," '810'","ST*810*000020001~"]
[null,null,null,"ST02","Transaction Set Control Number","Unique number that is incremented by 1 for each transaction set sent. (Maximum of 9 digits)"]
["Invoice Date","Beginning Segment for Invoice","20210114 (Jan 14, 2021)","BIG01","Invoice Date","Date invoice was generated. Format: CCYYMMDD. Future dates are not valid. Should be the same as the shipment date.","BIG*20210114* 6152543178*20210112*100403656 ~"]
["Invoice ID",null,6.152543178E9,"BIG02","Invoice Number","Assigned by sender"]
[null,null,"20210112 (Jan 12, 2021)","BIG03","PO Date","PO Date in format CCYYMMDD"]
["PO Number",null,1.00403656E8,"BIG04","PO Number","PO Number"]
["Supplier Order Number","Supplier's internal Order number\nNOTE:  This is used for the UI only.",1.2341234E7,"REF01","Reference Number Qualifier"," 'IL' for Internal Order Number","REF*IL*12341234*supplier_order_number~"]
[null,null,null,"REF02","Reference Number","Unique order identifier as provided by the supplier."]
[null,null,null,"REF03","Description","‘supplier_order_number’"]
["Ship Date","The date that the package shipped.","20210113 (Jan 13, 2021)","DTM01","Date/Time Qualifier"," '011' for Shipped Date","DTM*011*20210113*0200~"]
[null,null,null,"DTM02","Date ","Shipped date. Format: CCYYMMDD."]
[null,null,null,"DTM03","Time","Time Shipped in Format HHMM"]
[null,"Baseline Item Data",null,"IT101","Assigned Identifier","Invoice Line Number","IT1*1*1*EA*5.5*QT*SK*884942723438*UP* 884942723438 ~"]
["Quantity",null,15.0,"IT102","Quantity Invoiced","Units shipped per line item"]
["Unit of Measure",null,null,"IT103","Unit of Measurement Code"," 'EA' for Each"]
["Price",null,"100.00","IT104","Unit Price - R 1/17","Price per unit. Format: 999.99. Attention: The decimal place must be included."]
["Basis of Unit Price",null,null,"IT105","Basis of Unit Price"," 'QT' for Quoted (Default)\n'LE' for Catalog Price per Each"]
["Line Item SKU",null,8.84942723438E11,"IT106","\nProduct ID Qualifier"," 'SK' for SKU"]
[null,null,null,"IT107","Product ID","The SKU of the item. A limit of 70 characters is enforced."]
["Line Item UPC",null,8.84942723438E11,"IT108","\nProduct ID Qualifier"," 'UP' for UPC"]
[null,null,null,"IT109","Product ID","When the Qualifier is 'UP': Universal Product Code (UPC)"]
["Invoice Total Amount","The grand total of the invoice. This is the amount that the supplier expects the retailer to pay for this specific invoice unless a terms are provided which specifies that a discount is available if paid by a certain date. NOTE:  Required to display on UI only.","150.00","TDS01","Total Invoice Amount","Total amount of the invoice plus all charges minus all allowances. Format: 999.99\nAttention: The decimal place must be included.","TDS*57.5~"]
["Invoice Handling Amount","Used for any shipping cost or other fees associated with the order","13.00","AMT01","Amount Qualifier"," 'OH' for Handling Charges","AMT*OH*4.5~"]
[null,null,null,"AMT02","Amount","Handling Charge Amount in format: 999.99\nAttention: The decimal place must be included."]
[null,null,"2","CTT01","Number of Line Items","Number of line items in transaction set.","CTT*2~"]
[null,null,null,"SE01","Number of Included Segments","Number of segments in transaction set including ST and SE.","SE*17*000020001~"]
[null,null,null,"SE02","Transaction Set Control Number","Must match value in ST02."]