View: G/L Integration

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

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 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).