BM_ProductionTierDistribution BM Production Tier DistributionRel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_ProductionTierDistribution_bus,BC_CommonImport SQL Def: N SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_ProductionTierDistribution.M4T"
KPRIMARY: ProductionNo+LineKey+LotSerialNo KLOTSERIAL: LotSerialNo+TierType+ProductionNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 ProductionNo. . . . . . . . . 7 SYY Production Entry Number . . . .BMPRODUCTIONNO FmtType:CHARNUM DepVal:REQUIR ED 2 LineKey . . . . . . . . . . . 6 SNN Production Entry Line Key . . . DfltVal:000000 FmtType:ZEROFI LL DepVal:REQUIRED 3 LotSerialNo . . . . . . . . . 15 SYY Lot Serial Number . . . . . . .LOTSERIALNO DepVal:REQUIRED 4 TierType. . . . . . . . . . . 1 SYY Tier Type . . . . . . . . . . . Valid:3,4 DepVal:REQUIRED Notes: 3=Lot, 4=Serial 5 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE DepVal:REQUIRED 6 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED 7 Quantity. . . . . . . . . . . 16.6 NNN Quantity. . . . . . . . . . . .QUANTITY Mask:##,###,###.000000- 8 TierUnitCost. . . . . . . . . 16.6 NNN Tier Unit Cost. . . . . . . . .COST Mask:##,###,###.000000- Notes: (@ std U/M) 9 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion Fact Mask:#####0.0000