Diagrams


Table

Import G/L Transaction

Fields

# Name Type
1 App ID (App ID) GUID Editable: No
2 External Account (External Account) Code50
3 G/L Account (G/L Account) Code20
4 G/L Account Name (G/L Account Name) Text30 Editable: No
FlowField
5 Entry No. (Entry No.) Integer AutoIncrement: Yes
10 Transaction Date (Transaction Date) Date
12 Amount (Amount) Decimal
13 Description (Description) Text50

Keys

# Fields
0 App ID,Entry No. (App ID,Entry No.)
1 App ID,External Account,Transaction Date (App ID,External Account,Transaction Date) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
G/L Account (G/L Account) G/L Account () 1..n

Table Relations From Other Tables

From Table From Field