IM_SalesPromotion IM Sales Promotion Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_SalesPromotion_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_SalesPromotion.M4T"
KPRIMARY: SalesPromotionCode
Fld Column Name M/L TUR Description/Notes Class
1 SalesPromotionCode. . . . . . 10 SYY Sales Promotion Code. . . . . .SALESPROMOCODE Notes: {IMF$(1,10)} 2 SaleStartingDate. . . . . . . 8 SNN Sale Starting Date. . . . . . .DATE Notes: {IMF$(11,6)} 3 SaleEndingDate. . . . . . . . 8 SNN Sale Ending Date. . . . . . . .DATE Notes: {IMF$(17,6)} 4 SaleMethod. . . . . . . . . . 1 SYY Sale Method . . . . . . . . . . DfltVal:D Valid:D,P Notes: {IMF$(23,1)}D=Discount percentage, P=sale Price 5 SalePrice . . . . . . . . . . 16.6 NNN Sale Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- Notes: {IMF[0]} 6 DiscountPercentage. . . . . . 11.3 NNN Discount Percentage . . . . . . Mask:#####0.000 Notes: {IMF[0]} 7 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 8 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 9 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 10 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 11 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 12 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL