# Table: G/L Integration

Table: PMGLIT
View: PM0600
Record length: 40
Flags: A R

## Keys: 1

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

## Fields: 12

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

This page was generated on 2009-Nov-19

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