BM_PickingSheetWrk BM Picking Sheet Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_PickingSheetPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_PickingSheetWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 BillNo. . . . . . . . . . . . 30 SNN Bill Number . . . . . . . . . . 3 Revision. . . . . . . . . . . 3 SNN Revision. . . . . . . . . . . . 4 BillDesc1 . . . . . . . . . . 30 SNN Bill Description 1. . . . . . . 5 BillDesc2 . . . . . . . . . . 30 SNN Bill Description 2. . . . . . . 6 BillType. . . . . . . . . . . 1 SNN Bill Type . . . . . . . . . . . 7 BillOption1 . . . . . . . . . 2 SNN Bill Option Code 1. . . . . . . 8 BillOptionCategory1Desc . . . 30 SNN Bill Option Category 1 Descript 9 BillOption2 . . . . . . . . . 2 SNN Bill Option Code 2. . . . . . . 10 BillOptionCategory2Desc . . . 30 SNN Bill Option Category 2 Descript 11 BillOption3 . . . . . . . . . 2 SNN Bill Option Code 3. . . . . . . 12 BillOptionCategory3Desc . . . 30 SNN Bill Option Category 3 Descript 13 BillOption4 . . . . . . . . . 2 SNN Bill Option Code 4. . . . . . . 14 BillOptionCategory4Desc . . . 30 SNN Bill Option Category 4 Descript 15 BillOption5 . . . . . . . . . 2 SNN Bill Option Code 5. . . . . . . 16 BillOptionCategory5Desc . . . 30 SNN Bill Option Category 5 Descript 17 BillOption6 . . . . . . . . . 2 SNN Bill Option Code 6. . . . . . . 18 BillOptionCategory6Desc . . . 30 SNN Bill Option Category 6 Descript 19 BillOption7 . . . . . . . . . 2 SNN Bill Option Code 7. . . . . . . 20 BillOptionCategory7Desc . . . 30 SNN Bill Option Category 7 Descript 21 BillOption8 . . . . . . . . . 2 SNN Bill Option Code 8. . . . . . . 22 BillOptionCategory8Desc . . . 30 SNN Bill Option Category 8 Descript 23 BillOption9 . . . . . . . . . 2 SNN Bill Option Code 9. . . . . . . 24 BillOptionCategory9Desc . . . 30 SNN Bill Option Category 9 Descript 25 EffectiveDate . . . . . . . . 8 SNN Effective Date. . . . . . . . .DATE 26 ComponentWarehouseCode. . . . 3 SNN Component Warehouse Code. . . . 27 ComponentWarehouseCodeDesc. . 30 SNN Component Warehouse Code Descri 28 DrawingNo . . . . . . . . . . 20 SNN Drawing Number. . . . . . . . . 29 DrawingRevision . . . . . . . 3 SNN Drawing Revision. . . . . . . . 30 DateLastUsed. . . . . . . . . 8 SNN Date Last Used. . . . . . . . .DATE 31 RoutingNo . . . . . . . . . . 20 SNN Routing Number. . . . . . . . . 32 CurrentBillRevision . . . . . 3 SNN Current Bill Revision . . . . . 33 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 34 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 35 PickingSheetLineNumber. . . . 14 SNN Picking Sheet Line Number . . . 36 ComponentItemCode . . . . . . 30 SNN Component Item Code . . . . . . 37 ComponentRevision . . . . . . 3 SNN Component Revision. . . . . . . 38 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 39 ComponentDesc . . . . . . . . 30 SNN Component Description . . . . . 40 ComponentExtendedDescription. 4096 SNN Component Extended Description. 41 EngineeringDrawingFindNo. . . 5 SNN Engineering Drawing Find Number 42 WorkOrderStepNo . . . . . . . 4 SNN Work Order Step Number. . . . . 43 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 44 PhantomFlag . . . . . . . . . 1 SNN Phantom Flag. . . . . . . . . . 45 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 46 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 47 LotSerialSeqNo. . . . . . . . 14 SNN Lot Serial Sequence Number. . . 48 QuantityRequired. . . . . . . 16.6 NNN Quantity Required . . . . . . . 49 MaximumLotSize. . . . . . . . 5.0 NNN Maximum Lot Size. . . . . . . . 50 YieldPercent. . . . . . . . . 9.3 NNN Yield Percent . . . . . . . . . 51 ExtendedQuantityRequired. . . 16.6 NNN Extended Quantity Required. . . 52 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . . 53 ScrapPercent. . . . . . . . . 9.3 NNN Scrap Percent . . . . . . . . . 54 QuantityPerBillWithScrap. . . 16.6 NNN Quantity Per Bill With Scrap. . 55 ExtendedComponentQuantity . . 16.6 NNN Extended Component Quantity . .