View: G/L Reference Integration

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

Keys: 1

Title Fields

Source Trans. Type, G/L Trans. F SOURCEGLDEST

Fields: 9

Field Index Type Title Attributes Presentation

SOURCE 1 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 2 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 3 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 4 String*250 Example E A 
SEGMENT1 5 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 6 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 7 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 8 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 9 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