BM_ProductionLabelsWrk BM Production Labels Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_ProductionLabelPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_ProductionLabelsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 3 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 4 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 5 SequenceNo. . . . . . . . . . 5 SNN Sequence Number . . . . . . . . 6 ProductionNo. . . . . . . . . 7 SNN Production Number . . . . . . . 7 ProductionDate. . . . . . . . 8 SNN Production Date . . . . . . . .DATE 8 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 9 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 10 ProductionWarehouseCode . . . 3 SNN Production Warehouse Code . . . 11 BillOption1 . . . . . . . . . 2 SNN Bill Option Code 1. . . . . . . 12 BillOption2 . . . . . . . . . 2 SNN Bill Option Code 2. . . . . . . 13 BillOption3 . . . . . . . . . 2 SNN Bill Option Code 3. . . . . . . 14 BillOption4 . . . . . . . . . 2 SNN Bill Option Code 4. . . . . . . 15 BillOption5 . . . . . . . . . 2 SNN Bill Option Code 5. . . . . . . 16 BillOption6 . . . . . . . . . 2 SNN Bill Option Code 6. . . . . . . 17 BillOption7 . . . . . . . . . 2 SNN Bill Option Code 7. . . . . . . 18 BillOption8 . . . . . . . . . 2 SNN Bill Option Code 8. . . . . . . 19 BillOption9 . . . . . . . . . 2 SNN Bill Option Code 9. . . . . . . 20 PriceCode . . . . . . . . . . 4 SNN Price Code. . . . . . . . . . . 21 PriceCodeDesc . . . . . . . . 25 SNN Price Code Description. . . . . 22 AllowTradeDiscount. . . . . . 1 SNN Allow Trade Discount. . . . . . 23 SalesUnitOfMeasure. . . . . . 4 SNN Sales Unit Of Measure . . . . . 24 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit Of Measure. . . . 25 StandardUnitOfMeasure . . . . 4 SNN Standard Unit Of Measure. . . . 26 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 27 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 28 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 29 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 30 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 31 DefaultWarehouseCode. . . . . 3 SNN Default Warehouse Code. . . . . 32 DefaultWarehouseDesc. . . . . 30 SNN Default Warehouse Description . 33 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 34 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 35 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 36 PrimaryVendorAliasItemNo. . . 30 SNN Primary Vendor Alias Item Numbe 37 NextAPDivisionNo. . . . . . . 2 SNN Next AP Division Number . . . . 38 NextVendorNo. . . . . . . . . 7 SNN Next Vendor Number. . . . . . . 39 NextVendorName. . . . . . . . 30 SNN Next Vendor Name. . . . . . . . 40 NextVendorAliasItemNo . . . . 30 SNN Next Vendor Alias Item Number . 41 LastSoldDate. . . . . . . . . 8 SNN Last Sold Date. . . . . . . . .DATE 42 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE 43 Category1Desc . . . . . . . . 15 SNN Category 1 Description. . . . . 44 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 45 Category2Desc . . . . . . . . 15 SNN Category 2 Description. . . . . 46 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 47 Category3Desc . . . . . . . . 15 SNN Category 3 Description. . . . . 48 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 49 Category4Desc . . . . . . . . 15 SNN Category 4 Description. . . . . 50 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 51 ShipWeight. . . . . . . . . . 10 SNN Ship Weight . . . . . . . . . . 52 AllowBackOrders . . . . . . . 1 SNN Allow Back Orders . . . . . . . 53 NextLotSerialNo . . . . . . . 15 SNN Next Lot Serial Number. . . . . 54 InventoryCycle. . . . . . . . 1 SNN Inventory Cycle . . . . . . . . 55 RoutingNo . . . . . . . . . . 20 SNN Routing Number. . . . . . . . . 56 ProcurementType . . . . . . . 1 SNN Procurement Type. . . . . . . . 57 ReorderMethod . . . . . . . . 1 SNN Reorder Method. . . . . . . . . 58 Quantity. . . . . . . . . . . 16.6 NNN Quantity. . . . . . . . . . . . 59 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . . 60 StandardUnitPrice . . . . . . 16.6 NNN Standard Unit Price . . . . . . 61 LastTotalUnitCost . . . . . . 16.6 NNN Last Total Unit Cost. . . . . . 62 AverageUnitCost . . . . . . . 16.6 NNN Average Unit Cost . . . . . . . 63 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . . 64 PurchaseUMConvFctr. . . . . . 12.4 NNN Purchase Unit of Measure Conver 65 SalesUMConvFctr . . . . . . . 12.4 NNN Sales Unit of Measure Conversio 66 Volume. . . . . . . . . . . . 11.4 NNN Volume. . . . . . . . . . . . . 67 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . . 68 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . . 69 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . . 70 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . . 71 PrimaryVendorStandardLeadTime 6.0 NNN Primary Vendor Standard Lead Ti 72 NextVendorStandardLeadTime. . 6.0 NNN Next Vendor Standard Lead Time.