# 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 |  | SOURCE, GLDEST

## 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

This page was generated on 2008-May-02

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