Diagrams


Table

Cost Budget Register

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 No. Integer Editable: No
2 Source Option Editable: No
3 Description Text50 Editable: No
4 From Budget Entry No. Integer BlankZero: Yes
Editable: No
5 To Budget Entry No. Integer BlankZero: Yes
Editable: No
6 From Cost Budget Entry No. Integer BlankZero: Yes
Editable: No
7 To Cost Budget Entry No. Integer BlankZero: Yes
Editable: No
8 No. of Entries Integer Editable: No
15 Amount Decimal BlankZero: Yes
Editable: No
20 Processed Date Date Editable: No
21 Posting Date Date Editable: No
23 Closed Boolean
25 Level Integer BlankZero: Yes
Editable: No
31 User ID Code50 Editable: No
32 Journal Batch Name Code10 Editable: No
33 Cost Budget Name Code10 Editable: No

Keys

# Fields
0 No. Clustered: Yes
1 Source
2 Cost Budget Name
3 From Cost Budget Entry No.,To Cost Budget Entry No.
4 Closed

Table Relations To Other Tables

Field Related Table Related Field
To Cost Budget Entry No. Cost Budget Entry Entry No. 1..n
Cost Budget Name Cost Budget Name Name 1..n
Journal Batch Name Cost Journal Template Name 1..n
To Budget Entry No. G/L Budget Entry Entry No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field