BM_ComponentReqrmntWrk BM Component Requirement Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_ComponentReqrmntReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_ComponentReqrmntWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 21 SNN GroupField. . . . . . . . . . . 3 BillNo. . . . . . . . . . . . 30 SNN Bill Number . . . . . . . . . . 4 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 5 BillOption1 . . . . . . . . . 2 SNN Bill Option Code 1. . . . . . . 6 BillOptionCategory1Desc . . . 30 SNN Bill Option Category 1 Descript 7 BillOption1OptionDesc1. . . . 30 SNN Bill Option 1 Option Descriptio 8 BillOption1OptionDesc2. . . . 30 SNN Bill Option 1 Option Descriptio 9 BillOption2 . . . . . . . . . 2 SNN Bill Option Code 2. . . . . . . 10 BillOptionCategory2Desc . . . 30 SNN Bill Option Category 2 Descript 11 BillOption2OptionDesc1. . . . 30 SNN Bill Option 2 Option Descriptio 12 BillOption2OptionDesc2. . . . 30 SNN Bill Option 2 Option Descriptio 13 BillOption3 . . . . . . . . . 2 SNN Bill Option Code 3. . . . . . . 14 BillOptionCategory3Desc . . . 30 SNN Bill Option Category 3 Descript 15 BillOption3OptionDesc1. . . . 30 SNN Bill Option 3 Option Descriptio 16 BillOption3OptionDesc2. . . . 30 SNN Bill Option 3 Option Descriptio 17 BillOption4 . . . . . . . . . 2 SNN Bill Option Code 4. . . . . . . 18 BillOptionCategory4Desc . . . 30 SNN Bill Option Category 4 Descript 19 BillOption4OptionDesc1. . . . 30 SNN Bill Option 4 Option Descriptio 20 BillOption4OptionDesc2. . . . 30 SNN Bill Option 4 Option Descriptio 21 BillOption5 . . . . . . . . . 2 SNN Bill Option Code 5. . . . . . . 22 BillOptionCategory5Desc . . . 30 SNN Bill Option Category 5 Descript 23 BillOption5OptionDesc1. . . . 30 SNN Bill Option 5 Option Descriptio 24 BillOption5OptionDesc2. . . . 30 SNN Bill Option 5 Option Descriptio 25 BillOption6 . . . . . . . . . 2 SNN Bill Option Code 6. . . . . . . 26 BillOptionCategory6Desc . . . 30 SNN Bill Option Category 6 Descript 27 BillOption6OptionDesc1. . . . 30 SNN Bill Option 6 Option Descriptio 28 BillOption6OptionDesc2. . . . 30 SNN Bill Option 6 Option Descriptio 29 BillOption7 . . . . . . . . . 2 SNN Bill Option Code 7. . . . . . . 30 BillOptionCategory7Desc . . . 30 SNN Bill Option Category 7 Descript 31 BillOption7OptionDesc1. . . . 30 SNN Bill Option 7 Option Descriptio 32 BillOption7OptionDesc2. . . . 30 SNN Bill Option 7 Option Descriptio 33 BillOption8 . . . . . . . . . 2 SNN Bill Option Code 8. . . . . . . 34 BillOptionCategory8Desc . . . 30 SNN Bill Option Category 8 Descript 35 BillOption8OptionDesc1. . . . 30 SNN Bill Option 8 Option Descriptio 36 BillOption8OptionDesc2. . . . 30 SNN Bill Option 8 Option Descriptio 37 BillOption9 . . . . . . . . . 2 SNN Bill Option Code 9. . . . . . . 38 BillOptionCategory9Desc . . . 30 SNN Bill Option Category 9 Descript 39 BillOption9OptionDesc1. . . . 30 SNN Bill Option 9 Option Descriptio 40 BillOption9OptionDesc2. . . . 30 SNN Bill Option 9 Option Descriptio 41 EffectiveDate . . . . . . . . 8 SNN Effective Date. . . . . . . . .DATE 42 ComponentWarehouseCode. . . . 3 SNN Component Warehouse Code. . . . 43 BillOptionCategory. . . . . . 1 SNN Bill Option Category. . . . . . 44 BillOption. . . . . . . . . . 2 SNN Bill Option . . . . . . . . . . 45 SequenceNo. . . . . . . . . . 10 SNN Sequence Number . . . . . . . . 46 BillFormat. . . . . . . . . . 1 SNN Bill Format . . . . . . . . . . 47 BillType. . . . . . . . . . . 1 SNN Bill Type . . . . . . . . . . . 48 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 49 BillDesc1 . . . . . . . . . . 30 SNN Bill Description 1. . . . . . . 50 BillDesc2 . . . . . . . . . . 30 SNN Bill Description 2. . . . . . . 51 OptionDesc1 . . . . . . . . . 30 SNN Option Description 1. . . . . . 52 OptionDesc2 . . . . . . . . . 30 SNN Option Description 2. . . . . . 53 LevelPrefix . . . . . . . . . 9 SNN Level Prefix. . . . . . . . . . 54 LevelNo . . . . . . . . . . . 2 SNN Level Number. . . . . . . . . . 55 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 56 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 57 ComponentItemCode . . . . . . 30 SNN Component Item Code . . . . . . 58 ComponentRevision . . . . . . 3 SNN Component Revision. . . . . . . 59 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 60 ComponentDesc . . . . . . . . 30 SNN Component Description . . . . . 61 ComponentBillType . . . . . . 1 SNN Component Bill Type . . . . . . 62 ComponentBillDesc1. . . . . . 30 SNN Component Bill Description 1. . 63 ComponentBillDesc2. . . . . . 30 SNN Component Bill Description 2. . 64 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 65 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 66 QuantityRequired. . . . . . . 16.6 NNN Quantity Required . . . . . . . 67 YieldPercent. . . . . . . . . 9.3 NNN Yield Percent . . . . . . . . . 68 QuantityToProduce . . . . . . 16.6 NNN Quantity To Produce . . . . . . 69 ComponentQuantityPerBill. . . 16.6 NNN Component Quantity Per Bill . . 70 ComponentQuantityRequired . . 16.6 NNN Component Quantity Required . . 71 ScrapPercent. . . . . . . . . 9.3 NNN Scrap Percent . . . . . . . . . 72 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . . 73 QuantityOnPurchaseOrder . . . 16.6 NNN Quantity On Purchase Order. . . 74 QuantityOnSalesOrder. . . . . 16.6 NNN Quantity On Sales Order . . . . 75 QuantityOnBackOrder . . . . . 16.6 NNN Quantity On Back Order. . . . . 76 QuantityOnWorkOrder . . . . . 16.6 NNN Quantity On Work Order. . . . . 77 QuantityRequiredForWO . . . . 16.6 NNN Quantity Required for Work Orde 78 QuantityAvailable . . . . . . 16.6 NNN Quantity Available. . . . . . . 79 QuantityShort . . . . . . . . 16.6 NNN Quantity Short. . . . . . . . . 80 OccurrenceCount . . . . . . . 16.6 NNN Occurrence Count. . . . . . . .