BM_DisassemblyHeader BM Disassembly Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_Disassembly_bus,BC_CommonImport SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_DisassemblyHeader.M4T"
KPRIMARY: DisassemblyNo KBILL: BillNo+DisassemblyNo
Fld Column Name M/L TUR Description/Notes Class
1 DisassemblyNo . . . . . . . . 7 SYY Diassembly Entry Number . . . .BMDISASSEMBLYNO FmtType:CHARNUM Notes: {BML$(1,7)} 2 DisassemblyDate . . . . . . . 8 SYY Disassembly Date. . . . . . . .DATE Notes: {BML$(8,6)} 3 BillNo. . . . . . . . . . . . 30 SYY Bill Number . . . . . . . . . .BILLNO ValGroup:LinesExist Notes: {BML$(14,20)} 4 Revision. . . . . . . . . . . 3 SYN Bill Revision Code. . . . . . .REVISION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired.Bi llRevisions,LinesExist Notes: {BML$(34,3)} 5 BillOption1 . . . . . . . . . 2 SYN Bill Option Code 1. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(37,2)} 6 BillOption2 . . . . . . . . . 2 SYN Bill Option Code 2. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(39,2)} 7 BillOption3 . . . . . . . . . 2 SYN Bill Option Code 3. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(41,2)} 8 BillOption4 . . . . . . . . . 2 SYN Bill Option Code 4. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(43,2)} 9 BillOption5 . . . . . . . . . 2 SYN Bill Option Code 5. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(45,2)} 10 BillOption6 . . . . . . . . . 2 SYN Bill Option Code 6. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(47,2)} 11 BillOption7 . . . . . . . . . 2 SYN Bill Option Code 7. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(49,2)} 12 BillOption8 . . . . . . . . . 2 SYN Bill Option Code 8. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(51,2)} 13 BillOption9 . . . . . . . . . 2 SYN Bill Option Code 9. . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BillNoRequired, BillOptions,LinesExist Notes: {BML$(53,2)} 14 EffectiveDate . . . . . . . . 8 SYN Effective Date. . . . . . . . .DATE ValGroup:EngineeringChangeCon trol,LinesExist Notes: {BML$(55,6)} 15 ParentWarehouseCode . . . . . 3 SYY Parent Warehouse Code . . . . .WAREHOUSE FmtType:CHARNUM ValGroup:Mult iWarehouse Notes: {BML$(61, 3)} 16 DefaultComponentWhseCode. . . 3 SYY Default Component Warehouse CodWAREHOUSE FmtType:CHARNUM ValGroup:Mult iWarehouse Notes: {BML$(64, 3)} 17 LotSerialLinesExist . . . . . 1 SYY Lot Serial Lines Exist. . . . .YESNO DfltVal:N Valid:Y,N Notes: {BML$(67,1)} 18 DisassemblyType . . . . . . . 1 SYY Disassembly Type. . . . . . . . DfltVal:1 Valid:1,2,3 Notes: 1=Disassembly of Produced Item, 2=Disassembly of Purchased Item, 3=Reversal of Production Entry{BML$(68, 1)} 19 BillValuation . . . . . . . . 1 SYY Bill Valuation. . . . . . . . . Read Only:Y Valid:1,2,3,4,5, 6 Notes: 1=Standard, 2=Average, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial 20 ExplodeSubassemblies. . . . . 1 SYY Explode Subassemblies . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:LinesExist Notes: {BML$(70,1)} 21 DisassemblyQuantity . . . . . 16.6 NNN Disassembly Quantity. . . . . .QUANTITY Mask:##,###,###.000000 ValGroup:LinesExist Notes: {BML[1]} 22 BillCalcUnitCost. . . . . . . 16.6 NNN Bill Calculated Unit Cost . . . 23 TotalIMCost . . . . . . . . . 13.2 NNN Total I/M Cost. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: Calc in Pre-Update {BML[2]} 24 ParentExtendedCost. . . . . . 12.2 NNN Parent Extended Cost. . . . . . 25 ParentExtendedNegQtyAdj . . . 12.2 NNN Parent Extended Negative Quanti 26 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 27 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . Read Only:Y 28 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 29 DateUpdated . . . . . . . . . 8 SNN Last Date Updated . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 30 TimeUpdated . . . . . . . . . 8 SNN Last Time Updated . . . . . . . Read Only:Y 31 UserUpdatedKey. . . . . . . . 10 SNN Last User Updated . . . . . . .USER Read Only:Y Mask:0000000000