-
Notifications
You must be signed in to change notification settings - Fork 1
/
Book.al
75 lines (68 loc) · 1.31 KB
/
Book.al
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
table 50100 Book
{
LookupPageId = 50101;
fields
{
field(1; "No."; Code[20])
{
Caption = 'No.';
}
field(2; Title; Text[50])
{
Caption = 'Title';
}
field(3; Author; Text[50])
{
Caption = 'Author';
}
field(4; Hardcover; Boolean)
{
Caption = 'Hardcover';
}
field(5; "Page Count"; Integer)
{
Caption = 'Page Count';
}
field(6; Publisher; Text[50])
{
Caption = 'Publisher';
}
field(7; "Publishing Date"; Date)
{
Caption = 'Publishing Date';
}
field(8; Genre; Text[50])
{
Caption = 'Genre';
}
field(9; ISBN; Text[30])
{
Caption = 'ISBN';
}
field(10; Category; Text[50])
{
}
field(11; Shelf; Code[20]) { }
field(12; "Sales Price"; Decimal) { }
field(13; "Royalty Amount"; Decimal) { }
}
keys
{
key(PK; "No.")
{
Clustered = true;
}
}
trigger OnInsert()
begin
end;
trigger OnModify()
begin
end;
trigger OnDelete()
begin
end;
trigger OnRename()
begin
end;
}