Diagrams


Table

Config. Package Table

Fields

# Name Type
1 Package Code (Package Code) Code20
2 Table ID (Table ID) Integer NotBlank: Yes
3 Table Name (Table Name) Text250 Editable: No
FlowField
4 No. of Package Records (No. of Package Records) Integer Editable: No
FlowField
5 No. of Package Errors (No. of Package Errors) Integer Editable: No
FlowField
7 Imported Date and Time (Imported Date and Time) DateTime Editable: No
8 Exported Date and Time (Exported Date and Time) DateTime Editable: No
9 Comments (Comments) Text250
10 Created Date and Time (Created Date and Time) DateTime
11 Company Filter (Source Table) (Company Filter (Source Table)) Text30 FlowFilter
12 Table Caption (Table Caption) Text250 Editable: No
FlowField
13 Data Template (Data Template) Code10
14 Package Processing Order (Package Processing Order) Integer Editable: No
15 Page ID (Page ID) Integer
16 Processing Order (Processing Order) Integer
17 No. of Fields Included (No. of Fields Included) Integer Editable: No
FlowField
18 No. of Fields Available (No. of Fields Available) Integer Editable: No
FlowField
19 No. of Fields to Validate (No. of Fields to Validate) Integer Editable: No
FlowField
20 Package Caption (Package Caption) Text50 Editable: No
FlowField
21 Imported by User ID (Imported by User ID) Code50 Editable: No
22 Created by User ID (Created by User ID) Code50 Editable: No
24 Dimensions as Columns (Dimensions as Columns) Boolean
25 Filtered (Filtered) Boolean Editable: No
FlowField
26 Skip Table Triggers (Skip Table Triggers) Boolean
27 Delete Recs Before Processing (Delete Recs Before Processing) Boolean
28 Processing Report ID (Processing Report ID) Integer
29 Parent Table ID (Parent Table ID) Integer
30 Validated (Validated) Boolean

Keys

# Fields
0 Package Code,Table ID (Package Code,Table ID) Clustered: Yes
1 Package Processing Order,Processing Order (Package Processing Order,Processing Order)

Table Relations To Other Tables

Field Related Table Related Field
Processing Report ID (Processing Report ID) AllObjWithCaption Object ID (Object ID) 1..n
Company Filter (Source Table) (Company Filter (Source Table)) Company Name (Name) 1..n
Package Code (Package Code) Config. Package Code (Code) 1..n
Parent Table ID (Parent Table ID) Config. Package Table Table ID (Table ID) 1..n
Data Template (Data Template) Config. Template Header () 1..n
Created by User ID (Created by User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field
Config. Package Table Parent Table ID (Parent Table ID) 1..n