# Table: Bank G/L Integration

Table: BKGLREF
View: BK0470
Record length: 292
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Bank G/L Integration Source |  | SOURCE, GLDIST

## Fields: 14

Field | Type | Title | Presentation
--- | --- | --- | ---
SOURCE | Integer | Source Transaction Type | List: 4 entries
1 | = | Transfers
2 | = | Bank Entry
3 | = | Bank Entry Detail
4 | = | Bank Reconciliation
GLDIST | Integer | G/L Transaction field | List: 4 entries
1 | = | G/L Entry Description
2 | = | G/L Detail Reference
3 | = | G/L Detail Description
4 | = | G/L Detail Comment
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
EXAMPLE | String*250 | Transaction Entry Description |
SEPARATOR | Integer | Separator | List: 9 entries
1 | = | * Asterisk
2 | = | - Hyphen
3 | = | / Forward Slash
4 | = | \ Back Slash
5 | = | . Period
6 | = | { Left Parenthesis
7 | = | } Right Parenthesis
8 | = | # Number Sign
9 | = | Space
SEGMENT1 | Integer | Included Segment 1 | List: 22 entries
0 | = | None
1 | = | Posting Sequence
2 | = | Reference
3 | = | Description
4 | = | Comment
5 | = | Withdrawal Number
6 | = | Payee ID
7 | = | Payee Name
8 | = | Batch Number
9 | = | Deposit Number
10 | = | Transfer Number
11 | = | From Bank
12 | = | To Bank
13 | = | Bank Code
14 | = | Distribution Code
15 | = | Entry Number
16 | = | Entry Description
17 | = | Bank Entry Type
18 | = | Reconciliation Description
19 | = | Reconciliation Status
20 | = | From Bank Account
21 | = | To Bank Account
SEGMENT2 | Integer | Included Segment 2 | List: 22 entries
0 | = | None
1 | = | Posting Sequence
2 | = | Reference
3 | = | Description
4 | = | Comment
5 | = | Withdrawal Number
6 | = | Payee ID
7 | = | Payee Name
8 | = | Batch Number
9 | = | Deposit Number
10 | = | Transfer Number
11 | = | From Bank
12 | = | To Bank
13 | = | Bank Code
14 | = | Distribution Code
15 | = | Entry Number
16 | = | Entry Description
17 | = | Bank Entry Type
18 | = | Reconciliation Description
19 | = | Reconciliation Status
20 | = | From Bank Account
21 | = | To Bank Account
SEGMENT3 | Integer | Included Segment 3 | List: 22 entries
0 | = | None
1 | = | Posting Sequence
2 | = | Reference
3 | = | Description
4 | = | Comment
5 | = | Withdrawal Number
6 | = | Payee ID
7 | = | Payee Name
8 | = | Batch Number
9 | = | Deposit Number
10 | = | Transfer Number
11 | = | From Bank
12 | = | To Bank
13 | = | Bank Code
14 | = | Distribution Code
15 | = | Entry Number
16 | = | Entry Description
17 | = | Bank Entry Type
18 | = | Reconciliation Description
19 | = | Reconciliation Status
20 | = | From Bank Account
21 | = | To Bank Account
SEGMENT4 | Integer | Included Segment 4 | List: 22 entries
0 | = | None
1 | = | Posting Sequence
2 | = | Reference
3 | = | Description
4 | = | Comment
5 | = | Withdrawal Number
6 | = | Payee ID
7 | = | Payee Name
8 | = | Batch Number
9 | = | Deposit Number
10 | = | Transfer Number
11 | = | From Bank
12 | = | To Bank
13 | = | Bank Code
14 | = | Distribution Code
15 | = | Entry Number
16 | = | Entry Description
17 | = | Bank Entry Type
18 | = | Reconciliation Description
19 | = | Reconciliation Status
20 | = | From Bank Account
21 | = | To Bank Account
SEGMENT5 | Integer | Included Segment 5 | List: 22 entries
0 | = | None
1 | = | Posting Sequence
2 | = | Reference
3 | = | Description
4 | = | Comment
5 | = | Withdrawal Number
6 | = | Payee ID
7 | = | Payee Name
8 | = | Batch Number
9 | = | Deposit Number
10 | = | Transfer Number
11 | = | From Bank
12 | = | To Bank
13 | = | Bank Code
14 | = | Distribution Code
15 | = | Entry Number
16 | = | Entry Description
17 | = | Bank Entry Type
18 | = | Reconciliation Description
19 | = | Reconciliation Status
20 | = | From Bank Account
21 | = | To Bank Account
SEGCOUNT | Integer | Segment Counter |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.