     IM1    I/M Inventory Master File (IM1_InventoryMasterfile)                      Level: 4.40
            Record Type: 1    Inventory Masterfile                                   08/28/2009

     File Type: Mkeyed   Key Size: 15   Rec Len: 765     Min Len: 521    Define: N

     Main Key (KNO=0)ItemNumber(1,15)
     2nd Key (KNO=1) ItemDescription(16,30)+ItemNumber(1,15)
     3rd Key (KNO=2) PrimaryVendorDivision(85,2)+PrimaryVendorNumber(87,7)+ItemNumber(1,15)
     4th Key (KNO=3) ProductLine(46,4)+ItemNumber(1,15)
     5th Key (KNO=4) Category1(145,10)+ItemNumber(1,15)
     6th Key (KNO=5) Category2(155,10)+ItemNumber(1,15)
     7th Key (KNO=6) Category3(165,10)+ItemNumber(1,15)
     8th Key (KNO=7) Category4(175,10)+ItemNumber(1,15)

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase   *(1,15)
     Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String      (16,30)
     Product Line. . . . . . . . . . . . . . ProductLine . . . . . . . . . Uppercase   (46,4)
     Prod Type  (F/R/D/K). . . . . . . . . . ProductType . . . . . . . . . Uppercase   (50,1)
       F=Finished Good, R=Raw material . . . . . . . . . . . . . . . . . . Memo
       D=Discontinued, K=Kit . . . . . . . . . . . . . . . . . . . . . . . Memo
     Valuation (1-6) . . . . . . . . . . . . Valuation . . . . . . . . . . String      (51,1)
       1=Standard,  2=Average, 3=FIFO. . . . . . . . . . . . . . . . . . . Memo
       4=LIFO, 5=Lot, 6=Serial . . . . . . . . . . . . . . . . . . . . . . Memo
     Pricing Code. . . . . . . . . . . . . . PriceCode . . . . . . . . . . Uppercase   (52,4)
     Backorders Allowed. . . . . . . . . . . BackordersAllowed . . . . . . Yes/No      (56,1)
     ITEnabled . . . . . . . . . . . . . . . IT_Enabled. . . . . . . . . . Yes/No      (57,1)
     Detail Sales History. . . . . . . . . . DetailSalesHistory. . . . . . Yes/No      (58,1)
     Commission (N/S/P/C/G). . . . . . . . . Comm. . . . . . . . . . . . . Uppercase   (59,1)
       N=None, S=Standard Comm.. . . . . . . . . . . . . . . . . . . . . . Memo
       P=% of Price, C=% of Cost . . . . . . . . . . . . . . . . . . . . . Memo
       G=% of Gross profit . . . . . . . . . . . . . . . . . . . . . . . . Memo
     Standard U/M. . . . . . . . . . . . . . StdUM . . . . . . . . . . . . Uppercase   (60,4)
     Purchase U/M. . . . . . . . . . . . . . PurchaseUM. . . . . . . . . . Uppercase   (64,4)
     Sales U/M . . . . . . . . . . . . . . . SalesUM . . . . . . . . . . . Uppercase   (68,4)
     Default Warehouse . . . . . . . . . . . DefaultWhse . . . . . . . . . Account     (72,3)
     Weight. . . . . . . . . . . . . . . . . Weight. . . . . . . . . . . . String      (75,10)
     Primary Division Number . . . . . . . . PrimaryVendorDivision . . . . Zero-Filled (85,2)
     Primary Vendor Number . . . . . . . . . PrimaryVendorNumber . . . . . Account     (87,7)
     Image File. . . . . . . . . . . . . . . ImageFile . . . . . . . . . . String      (94,30)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (124,9)
     Date Last Sold. . . . . . . . . . . . . DateLastSold. . . . . . . . . Date        (133,6)
     Date Last Receipt . . . . . . . . . . . DateLastRecpt . . . . . . . . Date        (139,6)
     Category 1. . . . . . . . . . . . . . . Category1 . . . . . . . . . . Uppercase   (145,10)
     Category 2. . . . . . . . . . . . . . . Category2 . . . . . . . . . . Uppercase   (155,10)
     Category 3. . . . . . . . . . . . . . . Category3 . . . . . . . . . . Uppercase   (165,10)
     Category 4. . . . . . . . . . . . . . . Category4 . . . . . . . . . . Uppercase   (175,10)
     Name Of Sale. . . . . . . . . . . . . . NameOfSale. . . . . . . . . . Uppercase   (185,10)
     Sale Starting Date. . . . . . . . . . . SaleStartingDate. . . . . . . Date        (195,6)
     Sale Ending Date. . . . . . . . . . . . SaleEndingDate. . . . . . . . Date        (201,6)
     S Type (Dp=Sales Discnt,Sale Price) . . SaleTypeDiscntSale. . . . . . Uppercase   (207,1)
     Alternate Items . . . . . . . . . . . . AlternateItems. . . . . . . . Yes/No      (208,1)
     Price By Item . . . . . . . . . . . . . PriceByItem . . . . . . . . . Yes/No      (209,1)
     Price By Customer Price Level . . . . . PriceByCustomerPriceLevel . . Yes/No      (210,1)
     Price By Customer Number. . . . . . . . PriceByCustomerNumber . . . . Yes/No      (211,1)
     Trade Discount. . . . . . . . . . . . . TradeDiscount . . . . . . . . Yes/No      (212,1)
     Explode Kit (Always, Never, Prompt) . . ExplodeKit. . . . . . . . . . Uppercase   (213,1)
     Returns Allowed . . . . . . . . . . . . ReturnsAllowed. . . . . . . . Yes/No      (214,1)
     Restocking Method . . . . . . . . . . . RestockingMethod. . . . . . . Uppercase   (215,1)
       N=None, F=Fixed, C=%of Cost . . . . . . . . . . . . . . . . . . . . Memo
       P=% of Price. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (216,3)
     Next Lot/Serial Number. . . . . . . . . NextLotSerialNumber . . . . . String      (219,15)
     Inventory Cycle . . . . . . . . . . . . InventoryCycle. . . . . . . . String      (234,1)
     Routing Number. . . . . . . . . . . . . RoutingNumber . . . . . . . . Uppercase   (235,20)
     Procurement Typ (Make, Buy, Subcnt) . . ProcureTypeBuyMakeSub . . . . Uppercase   (255,1)
     Planner Code. . . . . . . . . . . . . . PlannerCode . . . . . . . . . Uppercase   (256,3)
     Buyer Code. . . . . . . . . . . . . . . BuyerCode . . . . . . . . . . Uppercase   (259,3)
     Planned by MRP. . . . . . . . . . . . . PlannedByMrp. . . . . . . . . Yes/No      (262,1)
     Low Level Code. . . . . . . . . . . . . LowLevelCode. . . . . . . . . Zero-Filled (263,2)
     Print Receipt Labels. . . . . . . . . . PrntRecptLabels . . . . . . . Yes/No      (265,1)
     Extended Description. . . . . . . . . . ExtendedDescription . . . . . Yes/No      (266,1)
     Detail Receipt History. . . . . . . . . DetailReceiptHistory. . . . . Yes/No      (267,1)
     Allocate Landed Cost. . . . . . . . . . AllocateLandedCost. . . . . . Yes/No      (268,1)
     Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . String      (269,2)
     Allow Cost Override Rcpt Of Goods . . . AllowCostOverrideROG. . . . . Yes/No      (271,1)
     Warranty code . . . . . . . . . . . . . WarrantyCode. . . . . . . . . Uppercase   (272,10)
     Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (282,240)
     Commission Rate . . . . . . . . . . . . CommRate. . . . . . . . . . . Number      [0]       3.3
     Base Commission Amount. . . . . . . . . BaseCommAmount. . . . . . . . Number      [1]       7.2
     Purchase U/M Factor . . . . . . . . . . PurchaseUMFactor. . . . . . . Number      [2]       6.4
     Sales U/M Factor. . . . . . . . . . . . SalesUMFactor . . . . . . . . Number      [3]       6.4
     Suggested Retail Price. . . . . . . . . SuggestedRetailPrice. . . . . Number      [4]       6.3
     Standard Price. . . . . . . . . . . . . StdPrice. . . . . . . . . . . Number      [5]       6.3
     Standard Cost . . . . . . . . . . . . . StdCost . . . . . . . . . . . Number      [6]       6.3
     Last Cost . . . . . . . . . . . . . . . LastCost. . . . . . . . . . . Number      [7]       6.3
     Average Cost. . . . . . . . . . . . . . AveCost . . . . . . . . . . . Number      [8]       6.3
     Sale Price/Discount Percent . . . . . . SalePriceDiscountPct. . . . . Number      [9]       7.3
     Total Qty On Hand . . . . . . . . . . . TotalQtyOnHand. . . . . . . . Number      [10]      6.3
     Avg Back Order Fill Days. . . . . . . . AverageBackOrderFillDays. . . Number      [11]      3.0
     Last Allocated Cost . . . . . . . . . . LastAllocatedCost . . . . . . Number      [12]      6.3
     Volume. . . . . . . . . . . . . . . . . Volume. . . . . . . . . . . . Number      [13]      5.4
     Restocking Charge . . . . . . . . . . . RestockingCharge. . . . . . . Number      [14]      6.3
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [15]      0.
     Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [16]      0.
     Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [17]      0.
     Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [18]      0.
     Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [19]      0.
                                                                                       ________
                                                                          Total Bytes  702