1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
DEFAULT_VALUE;SHORT_DATE_TIME;Now()
DEFAULT_VALUE;NUMERIC;0
FIELD_VALIDATOR;DOUBLE;<=1 And >=0
FIELD_VALIDATOR;SHORT_DATE_TIME;>=#1/1/1900#
DEFAULT_VALUE;BOOLEAN;No
DEFAULT_VALUE;SHORT_DATE_TIME;Null
DEFAULT_VALUE;TEXT;NEW
DEFAULT_VALUE;LONG;0.0
DEFAULT_VALUE;LONG;1
DEFAULT_VALUE;DOUBLE;1.0
DEFAULT_VALUE;LONG;3
DEFAULT_VALUE;LONG;-1
DEFAULT_VALUE;GUID;GenGUID()
FIELD_VALIDATOR;TEXT;Like "http://*"
DEFAULT_VALUE;BOOLEAN;True
DEFAULT_VALUE;SHORT_DATE_TIME;Date()
DEFAULT_VALUE;TEXT;""
DEFAULT_VALUE;BOOLEAN;False
DEFAULT_VALUE;LONG;524287
DEFAULT_VALUE;LONG;5
DEFAULT_VALUE;LONG;10
DEFAULT_VALUE;TEXT;' '
EXPRESSION;MONEY;[UnitPrice]*[Quantity]
DEFAULT_VALUE;TEXT;"UTC"
EXPRESSION;BIG_INT;[BigNum]+10
EXPRESSION;TEXT;IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[FirstName] & " " & [LastName]))
EXPRESSION;TEXT;IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[LastName] & ", " & [FirstName]))
RECORD_VALIDATOR;null;Not IsNull([Email] & [FullName] & [Login])
DEFAULT_VALUE;DOUBLE;=0
EXPRESSION;DOUBLE;[InitialLevel]+[Received]-[Shipped]-[Waste]
EXPRESSION;DOUBLE;[OnHand]-[Allocated]
EXPRESSION;DOUBLE;[Available]+[OnOrder]-[BackOrdered]
EXPRESSION;DOUBLE;IIf([TargetLevel]-[CurrentLevel]>0,[TargetLevel]-[CurrentLevel],0)
EXPRESSION;DOUBLE;IIf([BelowTargetLevel]>0,IIf([BelowTargetLevel]<[MinimumReorderQuantity],[MinimumReorderQuantity],[BelowTargetLevel]),0)
EXPRESSION;MONEY;[SubTotal]+[Tax]+[Shipping]
EXPRESSION;MONEY;[UnitPrice]*[Quantity]*(1-[Discount])
DEFAULT_VALUE;TEXT;="None"
EXPRESSION;BOOLEAN;([StatusID]=10)
EXPRESSION;BOOLEAN;([StatusID]>=30)
EXPRESSION;BOOLEAN;[StatusID]>=40
EXPRESSION;BOOLEAN;[StatusID]>50
EXPRESSION;BOOLEAN;([StatusID]=20)
DEFAULT_VALUE;SHORT_DATE_TIME;=Date()
EXPRESSION;DOUBLE;Month([OrderDate])
EXPRESSION;DOUBLE;Year([OrderDate])
EXPRESSION;MONEY;[OrderSubTotal]+[Tax]+[ShippingFee]
EXPRESSION;DOUBLE;IIf([OrderMonth]<=3,1,IIf([OrderMonth]<=6,2,IIf([OrderMonth]<=9,3,4)))
EXPRESSION;BOOLEAN;([StatusID]=0)
EXPRESSION;BOOLEAN;([StatusID]=30) And (Not IsNull([ClosedDate]))
EXPRESSION;BOOLEAN;([StatusID]>=20) And (Not IsNull([ShippedDate]))
EXPRESSION;BOOLEAN;([StatusID]>=10)
EXPRESSION;BOOLEAN;Not [IsCompleted]
EXPRESSION;DOUBLE;[Quantity]*[UnitCost]
DEFAULT_VALUE;BOOLEAN;=False
EXPRESSION;MONEY;[OrderSubTotal]+[ShippingFee]+[Taxes]
EXPRESSION;BOOLEAN;Not IsNull([ClosedDate])
EXPRESSION;BOOLEAN;Not IsNull([SubmittedDate])
EXPRESSION;BOOLEAN;Not [IsSubmitted]
DEFAULT_VALUE;SHORT_DATE_TIME;=Now()
DEFAULT_VALUE;LONG;=Int(13)
FIELD_VALIDATOR;SHORT_DATE_TIME;<Date()
FIELD_VALIDATOR;MONEY;>=0
FIELD_VALIDATOR;INT;>0
FIELD_VALIDATOR;FLOAT;Between 0 And 1
DEFAULT_VALUE;BOOLEAN;=No
EXPRESSION;TEXT;[LastName] & ", " & [FirstName]
EXPRESSION;LONG;Len([LastFirst])
EXPRESSION;MONEY;[Salary]/12
EXPRESSION;BOOLEAN;[Salary]>100000
EXPRESSION;MEMO;[LastName] & ", " & [FirstName] & "=" & [LastFirst]
EXPRESSION;NUMERIC;[Salary]/52
EXPRESSION;MONEY;[Salary]
EXPRESSION;BOOLEAN;True
EXPRESSION;NUMERIC;[Popularity]
EXPRESSION;FLOAT;[Salary]*0.13/[DecimalTest]
EXPRESSION;NUMERIC;([Salary]*[MonthlySalary]/[DecimalTest])*34.12342134
DEFAULT_VALUE;COMPLEX_TYPE;"data4"
EXPRESSION;DOUBLE;NPer(1,2,3,4,5)
EXPRESSION;DOUBLE;[Time Field]
DEFAULT_VALUE;TEXT;=Rnd(25)
DEFAULT_VALUE;TEXT;=Rnd(13)
DEFAULT_VALUE;TEXT;=Rnd(-1)
DEFAULT_VALUE;TEXT;=Rnd(-2)
DEFAULT_VALUE;TEXT;=Rnd()
RECORD_VALIDATOR;null;[Field4]>10
EXPRESSION;DOUBLE;[Field6]+3
EXPRESSION;DOUBLE;[Table4].[Field1]+4
EXPRESSION;LONG;[Field5]+5
DEFAULT_VALUE;LONG;134217727
DEFAULT_VALUE;TEXT;'+P-E'
FIELD_VALIDATOR;TEXT;Is Not Null
|
