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