BM_CostedMaterialsWrk BM Costed Materials Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_CostedMaterialsReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_CostedMaterialsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 18 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 BillType. . . . . . . . . . . 1 SNN Bill Type . . . . . . . . . . . 47 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 48 BillDesc1 . . . . . . . . . . 30 SNN Bill Description 1. . . . . . . 49 BillDesc2 . . . . . . . . . . 30 SNN Bill Description 2. . . . . . . 50 OptionDesc1 . . . . . . . . . 30 SNN Option Description 1. . . . . . 51 OptionDesc2 . . . . . . . . . 30 SNN Option Description 2. . . . . . 52 LevelPrefix . . . . . . . . . 9 SNN Level Prefix. . . . . . . . . . 53 LevelNo . . . . . . . . . . . 2 SNN Level Number. . . . . . . . . . 54 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 55 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 56 ComponentItemCode . . . . . . 30 SNN Component Item Code . . . . . . 57 ComponentRevision . . . . . . 3 SNN Component Revision. . . . . . . 58 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 59 ComponentDesc . . . . . . . . 30 SNN Component Description . . . . . 60 ComponentBillType . . . . . . 1 SNN Component Bill Type . . . . . . 61 ComponentBillDesc1. . . . . . 30 SNN Component Bill Description 1. . 62 ComponentBillDesc2. . . . . . 30 SNN Component Bill Description 2. . 63 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 64 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 65 QuantityRequired. . . . . . . 16.6 NNN Quantity Required . . . . . . . 66 YieldPercent. . . . . . . . . 9.3 NNN Yield Percent . . . . . . . . . 67 QuantityToProduce . . . . . . 16.6 NNN Quantity To Produce . . . . . . 68 ComponentQuantityPerBill. . . 16.6 NNN Component Quantity Per Bill . . 69 ComponentQuantityRequired . . 16.6 NNN Component Quantity Required . . 70 ScrapPercent. . . . . . . . . 9.3 NNN Scrap Percent . . . . . . . . . 71 ComponentUnitCost . . . . . . 16.6 NNN Component Unit Cost . . . . . . 72 ComponentCostOfBill . . . . . 16.6 NNN Component Cost of Bill. . . . . 73 ExtendedCost. . . . . . . . . 16.6 NNN Extended Cost . . . . . . . . .