View: G/L Reference Integration

RotoID: CP0057
Table: CPGLREF
Protocol: Flat, Ordered revisions
DLL: CPGLREF

Compositions: 0

Keys: 1

Title  Fields

Source Trans. Type, G/L Trans. F  SOURCE, GLDEST

Fields: 9

Field  Index  Type  Title  Attributes  Presentation

SOURCE  Integer  Source Transaction Type  E A K P R  List: 6 entries
0=System Cheques
1=System Cheques Detail
2=System Cheques PJC Detail
3=Manual Cheques
4=Manual Cheques Detail
5=Manual Cheques PJC Detail
GLDEST  Integer  G/L Transaction Field  E A K P R  List: 4 entries
0=G/L Entry Description
1=G/L Detail Reference
2=G/L Detail Description
3=G/L Detail Comment
SEPARATOR  Integer  Separator  E A P  List: 9 entries
0=* Asterisk
1=- Hyphen
2=/ Forward Slash
3=\ Back Slash
4=. Period
5={ Left Parenthesis
6=} Right Parenthesis
7=# Number Sign
8= Space
EXAMPLE  String*250  Example  E A   
SEGMENT1  Integer  Included Segment 1  E A P  List: 16 entries
0=None
1=Posting Sequence
2=Calculation Sequence
3=Employee Number
4=Employee Name
5=Cheque Number
6=Cheque Date
7=Posting Date
8=Pay Period Start Date
9=Pay Period End Date
10=Bank Code
11=Pay Frequency
12=Class 1 Value
13=Class 2 Value
14=Class 3 Value
15=Class 4 Value
SEGMENT2  Integer  Included Segment 2  E A P  List: 16 entries
0=None
1=Posting Sequence
2=Calculation Sequence
3=Employee Number
4=Employee Name
5=Cheque Number
6=Cheque Date
7=Posting Date
8=Pay Period Start Date
9=Pay Period End Date
10=Bank Code
11=Pay Frequency
12=Class 1 Value
13=Class 2 Value
14=Class 3 Value
15=Class 4 Value
SEGMENT3  Integer  Included Segment 3  E A P  List: 16 entries
0=None
1=Posting Sequence
2=Calculation Sequence
3=Employee Number
4=Employee Name
5=Cheque Number
6=Cheque Date
7=Posting Date
8=Pay Period Start Date
9=Pay Period End Date
10=Bank Code
11=Pay Frequency
12=Class 1 Value
13=Class 2 Value
14=Class 3 Value
15=Class 4 Value
SEGMENT4  Integer  Included Segment 4  E A P  List: 16 entries
0=None
1=Posting Sequence
2=Calculation Sequence
3=Employee Number
4=Employee Name
5=Cheque Number
6=Cheque Date
7=Posting Date
8=Pay Period Start Date
9=Pay Period End Date
10=Bank Code
11=Pay Frequency
12=Class 1 Value
13=Class 2 Value
14=Class 3 Value
15=Class 4 Value
SEGMENT5  Integer  Included Segment 5  E A P  List: 16 entries
0=None
1=Posting Sequence
2=Calculation Sequence
3=Employee Number
4=Employee Name
5=Cheque Number
6=Cheque Date
7=Posting Date
8=Pay Period Start Date
9=Pay Period End Date
10=Bank Code
11=Pay Frequency
12=Class 1 Value
13=Class 2 Value
14=Class 3 Value
15=Class 4 Value

This page was generated on 2009-Nov-19

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