View: Bank G/L Integration

RotoID: BK0470
Table: BKGLREF
Protocol: Flat
DLL: BKGLREF

Compositions: 0

Keys: 1

Title  Fields

Bank G/L Integration Source  SOURCE, GLDIST

Fields: 10

Field  Index  Type  Title  Attributes  Presentation

SOURCE  Integer  Source Transaction Type  E A K P R  List: 4 entries
1=Transfers
2=Bank Entry
3=Bank Entry Detail
4=Bank Reconciliation
GLDIST  Integer  G/L Transaction field  E A K R  List: 4 entries
1=G/L Entry Description
2=G/L Detail Reference
3=G/L Detail Description
4=G/L Detail Comment
EXAMPLE  String*250  Transaction Entry Description  E A   
SEPARATOR  Integer  Separator  E A  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  E A  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  E A  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  E A  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  E A  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  E A  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  10  Integer  Segment Counter  E A   

This page was generated on 2009-Nov-19

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