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 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).