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=Deposits
2=Entries
3=Transfers
4=Withdrawals
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: 15 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
14=Transaction Type
SEGMENT2  Integer  Included Segment 2  List: 15 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
14=Transaction Type
SEGMENT3  Integer  Included Segment 3  List: 15 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
14=Transaction Type
SEGMENT4  Integer  Included Segment 4  List: 15 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
14=Transaction Type
SEGMENT5  Integer  Included Segment 5  List: 15 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
14=Transaction Type
SEGCOUNT  Integer  Segment Counter   

This page was generated on 2008-May-01

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