View: G/L Reference Integration

RotoID: UP0057
Table: UPGLREF
Protocol: Flat, Ordered revisions
DLL:UPGLREF

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 Checks
1 = System Checks Detail
2 = System Checks PJC Detail
3 = Manual Checks
4 = Manual Checks Detail
5 = Manual Checks 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 = Check Number
6 = Check 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 = Check Number
6 = Check 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 = Check Number
6 = Check 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 = Check Number
6 = Check 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 = Check Number
6 = Check 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