# View: G/L Integration

RotoID: PM0600
Table: PMGLIT
Protocol: Flat, Ordered revisions
DLL: PMGLIT

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Key | TRANSTYPE, FLDTYPE

## Fields: 9

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
TRANSTYPE | 1 | Integer | Transaction Type | E A K R | List: 12 entries
1 | = | Adjustments
2 | = | Adjustments Detail
3 | = | Costs
4 | = | Costs Detail
5 | = | Equipment Usage
6 | = | Equipment Usage Detail
7 | = | Reopen Closed Projects Worksheet
8 | = | Reopen Closed Projects Worksheet Detail
9 | = | Revenue Recognition
10 | = | Revenue Recognition Detail
11 | = | Timecard
12 | = | Timecard Detail
FLDTYPE | 2 | Integer | G/L Transaction Field | E A K P R | List: 4 entries
1 | = | G/L Entry Description
2 | = | G/L Detail Reference
3 | = | G/L Detail Description
4 | = | G/L Detail Comment
SEPARATOR | 3 | Integer | Segment Separator | E A | List: 9 entries
1 | = | * Asterisk
2 | = | - Hyphen
3 | = | / Forward slash
4 | = | \ Back slash
5 | = | . Period
6 | = | { Left Parenthesis
7 | = | } Right Parenthesis
8 | = | # Number sign
9 | = | Space
SEGMENT1 | 4 | Integer | Segment 1 | E A P | List: 31 entries
1 | = | Posting Sequence
2 | = | Source Code
3 | = | Description
4 | = | Reference
5 | = | Worksheet Number
6 | = | Equipment Code
7 | = | Equipment Usage Number
8 | = | Revenue Recognition Number
9 | = | Timecard Number
10 | = | Employee Number
11 | = | Adjustment Number
12 | = | Contract Number
13 | = | Contract Description
14 | = | Contract Manager
15 | = | Purchase Order Number
16 | = | Project
17 | = | Category
18 | = | Resource
19 | = | Comments
20 | = | Adjustment Type
21 | = | Document Number
22 | = | Document Type
23 | = | Project Type
24 | = | Accounting Method
25 | = | Project Description
26 | = | Category Description
27 | = | Resource Description
28 | = | Cost Number
29 | = | Equipment Code Description
26 | = | Category Description
30 | = | Employee Name
SEGMENT2 | 5 | Integer | Segment 2 | E A P | List: 31 entries
1 | = | Posting Sequence
2 | = | Source Code
3 | = | Description
4 | = | Reference
5 | = | Worksheet Number
6 | = | Equipment Code
7 | = | Equipment Usage Number
8 | = | Revenue Recognition Number
9 | = | Timecard Number
10 | = | Employee Number
11 | = | Adjustment Number
12 | = | Contract Number
13 | = | Contract Description
14 | = | Contract Manager
15 | = | Purchase Order Number
16 | = | Project
17 | = | Category
18 | = | Resource
19 | = | Comments
20 | = | Adjustment Type
21 | = | Document Number
22 | = | Document Type
23 | = | Project Type
24 | = | Accounting Method
25 | = | Project Description
26 | = | Category Description
27 | = | Resource Description
28 | = | Cost Number
29 | = | Equipment Code Description
26 | = | Category Description
30 | = | Employee Name
SEGMENT3 | 6 | Integer | Segment 3 | E A P | List: 31 entries
1 | = | Posting Sequence
2 | = | Source Code
3 | = | Description
4 | = | Reference
5 | = | Worksheet Number
6 | = | Equipment Code
7 | = | Equipment Usage Number
8 | = | Revenue Recognition Number
9 | = | Timecard Number
10 | = | Employee Number
11 | = | Adjustment Number
12 | = | Contract Number
13 | = | Contract Description
14 | = | Contract Manager
15 | = | Purchase Order Number
16 | = | Project
17 | = | Category
18 | = | Resource
19 | = | Comments
20 | = | Adjustment Type
21 | = | Document Number
22 | = | Document Type
23 | = | Project Type
24 | = | Accounting Method
25 | = | Project Description
26 | = | Category Description
27 | = | Resource Description
28 | = | Cost Number
29 | = | Equipment Code Description
26 | = | Category Description
30 | = | Employee Name
SEGMENT4 | 7 | Integer | Segment 4 | E A P | List: 31 entries
1 | = | Posting Sequence
2 | = | Source Code
3 | = | Description
4 | = | Reference
5 | = | Worksheet Number
6 | = | Equipment Code
7 | = | Equipment Usage Number
8 | = | Revenue Recognition Number
9 | = | Timecard Number
10 | = | Employee Number
11 | = | Adjustment Number
12 | = | Contract Number
13 | = | Contract Description
14 | = | Contract Manager
15 | = | Purchase Order Number
16 | = | Project
17 | = | Category
18 | = | Resource
19 | = | Comments
20 | = | Adjustment Type
21 | = | Document Number
22 | = | Document Type
23 | = | Project Type
24 | = | Accounting Method
25 | = | Project Description
26 | = | Category Description
27 | = | Resource Description
28 | = | Cost Number
29 | = | Equipment Code Description
26 | = | Category Description
30 | = | Employee Name
SEGMENT5 | 8 | Integer | Segment 5 | E A P | List: 31 entries
1 | = | Posting Sequence
2 | = | Source Code
3 | = | Description
4 | = | Reference
5 | = | Worksheet Number
6 | = | Equipment Code
7 | = | Equipment Usage Number
8 | = | Revenue Recognition Number
9 | = | Timecard Number
10 | = | Employee Number
11 | = | Adjustment Number
12 | = | Contract Number
13 | = | Contract Description
14 | = | Contract Manager
15 | = | Purchase Order Number
16 | = | Project
17 | = | Category
18 | = | Resource
19 | = | Comments
20 | = | Adjustment Type
21 | = | Document Number
22 | = | Document Type
23 | = | Project Type
24 | = | Accounting Method
25 | = | Project Description
26 | = | Category Description
27 | = | Resource Description
28 | = | Cost Number
29 | = | Equipment Code Description
26 | = | Category Description
30 | = | Employee Name
EXAMPLE | 20 | String*250 | Example | E A |

This page was generated on 2008-May-01

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