Table: G/L Reference Integration

Table: UPGLREF
View: UP0057
Record Length: 40

Flags: A R 

Keys: 1

Title Flags Fields

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

Fields: 12

Field Type Title Presentation

SOURCE Integer Source Transaction Type 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 Integer G/L Transaction Field List:4 entries
0 = G/L Entry Description
1 = G/L Detail Reference
2 = G/L Detail Description
3 = G/L Detail Comment
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
SEPARATOR Integer Separator 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
SEGMENT1 Integer Included Segment 1 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 Integer Included Segment 2 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 Integer Included Segment 3 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 Integer Included Segment 4 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 Integer Included Segment 5 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