Table Statistics Report
Library: HD1100PD   Short Text: Line Item YTD Transaction                         
FileName: OEPTOLY    Records in Table: 25,704,277
Library Index Name Short Description Rank IX Recs Last Use Elapsed Days
Column Seq  Dir Data Type Len  Scle Column Description NU Keys Abs Sel
 
HD1100PD   OEPTOLY    Line Item YTD Transaction                          0.000 25,704,277 6/29/2006 0
HD1100PD   OELCOLYM   By Our Item#  ** Custom **                   3.513 25,704,277 6/28/2006 1
IVNO07     1 A DECIMAL  6 0 Our Item Number 74,444 345.28
HD1100PD   OELCTLYA   By Branch No, Item No, OrdDT, OrdNo                9.393 25,704,277 6/29/2006 0
OENO16     1 A DECIMAL  3 0 Ship from Branch Number 230 111,757.72
IVNO07     2 A DECIMAL  6 0 Our Item Number 988,989 25.99
OECC08     3 A DECIMAL  2 0 Century Of Sales Period 995,659 25.81
OEYR08     4 A DECIMAL  2 0 Year Of Sales Period 2,399,450 10.71
OEMO08     5 A DECIMAL  2 0 Month of Sales Period 0 0.00
OENO01     6 A DECIMAL  7 0 Order Number 0 0.00
HD1100PD   OELCTOLY   By Customer, Branch, EntDate: Oeptoly              6.441 25,704,277 6/29/2006 0
ARNO01     1 A DECIMAL  6 0 Customer Number 57,024 450.76
OENO08     2 A DECIMAL  3 0 Branch Number 128,144 200.58
OECC03     3 A DECIMAL  2 0 Century Entered 128,304 200.33
OEYR03     4 A DECIMAL  2 0 Year Entered 289,365 88.82
OEMO03     5 A DECIMAL  2 0 Month Order Entered 0 0.00
OEDY03     6 A DECIMAL  2 0 Day Order Entered 0 0.00
HD1100PD   OELTOLX1   By Sales period(CC,YY,MM), Cust #                  0.441 25,371,259 12/21/2005 190
OECC08     1 A DECIMAL  2 0 Century Of Sales Period 2 12,852,138.50
OEYR08     2 A DECIMAL  2 0 Year Of Sales Period 11 2,336,752.45
OEMO08     3 A DECIMAL  2 0 Month of Sales Period 117 219,694.67
ARNO01     4 A DECIMAL  6 0 Customer Number 887,902 28.94
HD1100PD   OELTOLYA   By Branch, Item, Sales Period                      9.393 25,704,277 6/9/2006 20
OENO16     1 A DECIMAL  3 0 Ship from Branch Number 230 111,757.72
IVNO07     2 A DECIMAL  6 0 Our Item Number 988,989 25.99
OECC08     3 A DECIMAL  2 0 Century Of Sales Period 995,659 25.81
OEYR08     4 A DECIMAL  2 0 Year Of Sales Period 2,399,450 10.71
OEMO08     5 A DECIMAL  2 0 Month of Sales Period 0 0.00
HD1100PD   OELTOLYG   By Purchase Order Number, OEPTOL,OEPTOLY           40.184 25,704,277 6/29/2006 0
OECC08     1 A DECIMAL  2 0 Century Of Sales Period 2 12,852,138.50
OEYR08     2 A DECIMAL  2 0 Year Of Sales Period 11 2,336,752.45
OEMO08     3 A DECIMAL  2 0 Month of Sales Period 117 219,694.67
ARNO15     4 A DECIMAL  3 0 Company Number 124 207,292.55
OECC26     5 D DECIMAL  2 0 Order Process Century 0 0.00
OEYR26     6 D DECIMAL  2 0 Order Process Year 0 0.00
OEMO26     7 D DECIMAL  2 0 Order Process Month 0 0.00
OEDY26     8 D DECIMAL  2 0 Order Process Day 0 0.00
OETM09     9 D DECIMAL  6 0 Order Process Time 0 0.00
HD1100PD   OELTOLYN   By Order Number, Our Item Number                   2.818 25,704,277 6/29/2006 0
OENO01     1 A DECIMAL  7 0 Order Number 7,687,893 3.34
IVNO07     2 A DECIMAL  6 0 Our Item Number 25,397,744 1.01
HD1100PD   OELTOLYP   By Our Item#, Sales yr/mm  Omit                    0.000 24,990,634 8/13/2005 320
IVNO07     1 A DECIMAL  6 0 Our Item Number 74,042 347.15
OECC08     2 A DECIMAL  2 0 Century Of Sales Period 77,068 333.52
OEYR08     3 A DECIMAL  2 0 Year Of Sales Period 252,510 101.79
OEMO08     4 A DECIMAL  2 0 Month of Sales Period 1,309,069 19.63
HD1100PD   OELTOLYR   By Prod #, Order #, Line Ctl#                      0.188 25,704,277 6/29/2006 0
IVNO04     1 A CHAR     17 Our Product Number 396,482 64.83
OENO01     2 A DECIMAL  7 0 Order Number 25,448,388 1.01
OENO22     3 A DECIMAL  3 0 Line Item Tag Control Number 25,704,211 1.00
HD1100PD   OELTOLYV   By invoice control #                               0.000 25,704,277 6/29/2006 0
PONO24     1 A DECIMAL  7 0 Invoice Control Number 24,600 1,044.88
HD1100PD   OELTOLYW   By Company/Selling Branch w/omits        (OEPTOLY) 0.000 3,588 8/13/2005 320
ARNO15     1 A DECIMAL  3 0 Company Number 1 25,704,277.00
OENO08     2 A DECIMAL  3 0 Branch Number 189 136,001.46
HD1100PD   OELTOLYX   By Company, Sales Yr/Mo, Customer, Item            2.638 25,704,277 6/29/2006 0
ARNO15     1 A DECIMAL  3 0 Company Number 3 8,568,092.33
OECC08     2 A DECIMAL  2 0 Century Of Sales Period 4 6,426,069.25
OEYR08     3 A DECIMAL  2 0 Year Of Sales Period 14 1,836,019.78
OEMO08     4 A DECIMAL  2 0 Month of Sales Period 124 207,292.55
ARNO01     5 A DECIMAL  6 0 Customer Number 0 0.00
IVNO07     6 A DECIMAL  6 0 Our Item Number 0 0.00
HD1100PD   OELTOLYY   By Order, Line Control #                           6.055 25,704,277 6/29/2006 0
OENO01     1 A DECIMAL  7 0 Order Number 7,687,893 3.34
OENO22     2 A DECIMAL  3 0 Line Item Tag Control Number 25,703,082 1.00
HD1100PD   OELTOLY1   By Order Number, Line Sequence Number              12.963 25,704,277 6/29/2006 0
OENO01     1 A DECIMAL  7 0 Order Number 7,687,893 3.34
OENO09     2 A DECIMAL  3 0 Line Item Sequence Number 25,704,276 1.00
HD1100PD   OELTOLY2   By Customer, Our Item Number, Company              2.559 25,704,277 6/29/2006 0
ARNO01     1 A DECIMAL  6 0 Customer Number 57,024 450.76
IVNO07     2 A DECIMAL  6 0 Our Item Number 7,059,341 3.64
ARNO15     3 A DECIMAL  3 0 Company Number 7,059,378 3.64
HD1100PD   OELTOLY3   By Our Item Number, Branch Number, OMIT(Non-stock) 0.000 25,363,588 6/22/2006 7
IVNO07     1 A DECIMAL  6 0 Our Item Number 74,439 345.30
OENO16     2 A DECIMAL  3 0 Ship from Branch Number 988,975 25.99
ARCC06     3 A DECIMAL  2 0 Order Century Shipped 995,781 25.81
ARYR06     4 A DECIMAL  2 0 Order Year Shipped 2,400,925 10.70
ARMO06     5 A DECIMAL  2 0 Order Month Shipped 0 0.00
ARDY06     6 A DECIMAL  2 0 Order Day Shipped 0 0.00
HD1100PD   OELTOLY5   By Branch, Item, Void Yr/Mo, (Voided & Stock)      0.454 42,346 6/1/2006 28
OENO16     1 A DECIMAL  3 0 Ship from Branch Number 206 124,778.04
IVNO07     2 A DECIMAL  6 0 Our Item Number 31,306 821.06
OECC09     3 A DECIMAL  2 0 History Backorder Void Century 31,315 820.82
OEYR09     4 A DECIMAL  2 0 History Backorder Void Year 35,654 720.93
OEMO09     5 A DECIMAL  2 0 History Backorder Void Month 0 0.00
HD1100PD   OELTOLY7   By Item Number, (Non-stock Only)                   2.331 340,689 6/26/2006 3
IVNO07     1 A DECIMAL  6 0 Our Item Number 7 3,672,039.57
HD1100PD   OELTOL32   OEPTOLY by Br, Prod No.                   SEL/OMIT 0.013 340,689 6/29/2006 0
OENO16     1 A DECIMAL  3 0 Ship from Branch Number 222 115,785.03
IVNO04     2 A CHAR     17 Our Product Number 317,733 80.89
HD1100PD   TLL00008   OE/FIX/TEMP OEPTOLY by cust,order,line  0680000404 0.608 3,588 6/29/2006 0
ARNO01     1 A DECIMAL  6 0 Customer Number 1,736 14,806.61
OENO01     2 A DECIMAL  7 0 Order Number 2,864 8,974.95
OENO09     3 A DECIMAL  3 0 Line Item Sequence Number 3,588 7,163.95
HD1100PD   TLL00045   OEPTOLY by Br,Prod,Date ship c/y/m/d    8000009084 0.000 310,498 8/13/2005 320
OENO16     1 A DECIMAL  3 0 Ship from Branch Number 221 116,308.94
IVNO04     2 A CHAR     17 Our Product Number 291,304 88.23
ARCC06     3 A DECIMAL  2 0 Order Century Shipped 291,306 88.23
ARYR06     4 A DECIMAL  2 0 Order Year Shipped 292,007 88.02
ARMO06     5 A DECIMAL  2 0 Order Month Shipped 0 0.00
ARDY06     6 A DECIMAL  2 0 Order Day Shipped 0 0.00