Dynamics 365 Business Central开发系列课程-第六课(表字段-Field)

字段触发：Field triggers

每个字段都有两个事件：triggers, the  OnValidate()  and the  OnLookup() trigger

字段编号：Field numbering

我们在标准表中新增字段时：字段编号必须是从50,000 到 99,999 ，新建表时字段编号： 1 to 999,999,999.

字段命名：Field and variable naming

1.不区分大小写

2.字段长度：30-character length

3. A to Z (upper or lowercase) or an underscore ( _ , ASCII value 95)

属性：DateFormula

DateFormula is a combination of the following:
Numeric multipliers (for example, 1, 2, 3, 4, and so on)
Alpha time units (all must be uppercase)
D for a day
W for a week
WD for the day of the week, that is, day 1 through day 7 (either in the
future or in the past, not today); Monday is day 1, and Sunday is day 7
M for calendar month
Y for year
CM for current month, CY for current year, and CW for current week
Math symbols interpretation: + (plus), that is, CM + 10D means the current
month end plus 10 days (in other words, the 10 th of next month), and -
(minus), that is, (-WD3), which means the date of the previous Wednesday
(the third day of the past week)
Positional notation (D15 means the 15 th day of the month and 15D means
15 days)