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