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