Level 3 Line Item Detail

What is Level 3 Line Item Detail?

 Level 3 data is similar to a point-of-sale receipt. The

detail provided includes:      

unit cost, quantities, total item cost, product codes, product descriptions, other transaction data.

Vendors Providing Level 3 Data  Most Popular: 

   

Amazon/Amazon Marketplace Office Depot Staples Best Buy Publix

 Hardware Suppliers:  

Lowes Home Depot

 Auto Parts:  

Advance Auto Parts AutoZone

 Industrial Suppliers:    

WW Grainger Bob Barker Company Fisher Science Henry Schein

PCLNITEM IW table FIELD

DESCRIPTION

BUSN_NM (A44) CHRG_ID (A23) COMMODITY_CD (A4)

Business line 1 name. Uniquely identifies a particular charge. A code identifying the category of a particular commodity item. (Ex: 0425 – Office Furniture; 0620 – Erasers, inks, leads, pens, pencils, etc.) Discount amount – The amount of the discount to be applied if paid within the discount time period. Invoice Line Number - The identifying information assigned to identify the line on an invoice. This could be alpha or numeric character. An identifier assigned by the transaction vendor or the submitting agency to identify the invoice. A code assigned by the vendor that identifies a specific product item. (Ex: SWI38101 Staple Remover) A description of the commodity item(s) that was charged to a State Purchasing Card. The quantity of a particular commodity item that was charged to a State Purchasing Card. The date that the row was added to the Information Warehouse. Organization level at which an agency maintains independent fiscal records. Sales tax amount for the charge. The percentage of sales tax due for a particular item(s). The total dollar amount of a particular commodity item(s) charged to a State Purchasing Card. A sequence number assigned to identify a Purchasing Card transaction. The dollar amount of a particular commodity item (the amount per item). Refers to the measurement focus of life for a property item. Values are: 1 = Months 2 = Hours 3 = Miles 4 = Other

DISCOUNT_AMT (D13.2) INVOICE_LINE_NBR (A3) INVOICE_NBR (A7) ITEM_CD (A12) ITEM_DESC (A26) ITEM_QTY (D13.4) IW_DT (YYYY-MM-DD) OLO (A6) SALES_TAX_AMT (D13.2) SALES_TAX_RATE (A4) TOTAL_ITEM_AMT (D13.2) TRN_SEQ_NBR (A13) UNIT_ITEM_AMT (D13.4) UNITS_OF_MEASURE (A12)

Query Results

group GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A GROUP A

person ID 10010010 10010010 10010010 10010010 10010010 10010010 10010010 10010010 10010010 10010010 10010010 10010010 10010010

cardholder JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE JANE DOE

invoice # 2221369 2221369 2221369 2221369 2221369 2221369 2221369 2221369 2221369 2221369 2221369 2221369 2221369

vendor PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782 PUBLIX #782

chg date chg amt 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51 11/15/2010 $130.51

total item unit item amt item amt qty item cd item description $7.79 $7.79 1. 29033400000 ITALIAN WHL SUB CB $7.79 $7.79 1. 29032700000 SPR CBN WHL SUB CM $6.49 $6.49 1. 29016200000 EGG SLD 1/2SUB CMB $6.99 $6.99 1. 29033200000 VEGGIE WHL SUB CMB $7.89 $7.89 1. 29073600000 BH PHILLY HF COMBO $6.49 $6.49 1. 29016500000 HAM SLD 1/2SUB CMB $25.96 $6.49 4. 29017000000 ULTM 1/2 SUB COMBO $6.49 $6.49 1. 29017200000 TUNA 1/2 SUB COMBO $6.99 $6.99 1. 21360000000 BH SPEC ORD 1/2 CB $7.39 $7.39 1. 29050400000 CHIX TNDR 1/2 CMBO $25.96 $6.49 4. 29017500000 TRKY 1/2 SUB COMBO $7.79 $7.79 1. 29032100000 ULTIMTE WHL SUB CB $6.49 $6.49 1. 29017400000 RST BF 1/2 SUB CMB

Query Results group GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B GROUP B

person ID 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020 20020020

cardholder JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE JOHN DOE

invoice # 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947 0150947

vendor chg date OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010 OFFICE DEPOT #1165 11/12/2010

chg amt $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69 $962.69

total item unit item item amt amt qty item cd $0.91 $0.91 1. 199856 $14.04 $4.68 3. 160064 $15.44 $7.72 2. 315515 $16.72 $8.36 2. 790761 $16.72 $8.36 2. 790801 $25.80 $2.15 12. 729525 $26.70 $4.45 6. 729640 $65.72 $32.86 2. 108729 $81.88 $40.94 2. 438950 $13.52 $6.76 2. 504808 $11.99 $11.99 1. 564070 $9.40 $4.70 2. 420994 $2.70 $2.70 1. 825182 $4.12 $1.03 4. 369275 $5.22 $5.22 1. 203349 $5.28 $5.28 1. 345686 $5.28 $5.28 1. 478156 $5.34 $5.34 1. 825190 $5.78 $5.78 1. 848564 $8.36 $8.36 1. 790781 $9.40 $9.40 1. 753313 $206.64 $206.64 1. 975384

item description IDEAL CLAMPS,#2,SMALL,BX FLAGS,POST-IT(R),SMALL S FOLDER,LTR,1/3CUT,100BX, PEN,RETRACT,G-2,BK,FN PEN,RETRACT,G-2,FN,BLUE BINDER,VUE,3RG,11X8.5,1" BINDER,VUE,3RG,11X8.5,3" INK,HP 94,TWIN PACK,2PK, INK,HP 95,2/PK,COLOR NOTE,PST-IT,SSTCKY,4X6,5 TYLENOL,EXTRA-STRENGTH,5 NOTE,OD,3" X 3",18/PK,YE CLIP,BINDER,SM,3/4IN,144 OD,DIV,INSERT,5TAB,CLR,6 MARKER,SHARPIE,FINE,DZ,B PAPER,COPY,8.5X11,GRD,5M PAPER,COPY,500-CT,8.5X11 CLIP,BINDER,MED,1.25IN,1 CALC INKROLL PR-42 2-PAC PEN,ROLLER,GELINK,G-2,XLABEL,SHIPPING,RL,2.5X4 CARTRIDGE,LASER,HP Q5942

Level 3 Line Item Detail

Questions? If you have questions or need the notes version of this presentation, please call Michelle Oliver at 850.413.5451.