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