RA_ReturnTierDistribution RA Return Tier Distribution Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_ReturnTierDistribution_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReturnTierDistribution.M4T"
KPRIMARY: RMANo+LineKey+LotSerialNo KLOTSERIAL: LotSerialNo+TierType+RMANo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYY RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {RA3$(1,7)} 2 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {RA2 - Packed) (RA3$(8,5)} 3 TierType. . . . . . . . . . . 1 SYN Tier Type . . . . . . . . . . . Valid:3,4 Notes: {3=Lot, 4=Serial) (RA3$(28,1)} 4 LotSerialNo . . . . . . . . . 15 SYN Lot Serial Number . . . . . . .LOTSERIALNO Notes: {RA3$(13,15)} 5 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE Notes: From RA_ReturnDetail 6 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: From RA_ReturnDetail 7 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {RA3[0]} 8 TierUnitCost. . . . . . . . . 16.6 NNN Tier Unit Cost. . . . . . . . .COST Mask:##,###,###.000000- Notes: {@ std U/M) (RA3[1]} 9 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion Fact Mask:#####0.0000 Notes: From RA_ReturnDetail