View: G/L Reference Integration

RotoID: IC0281
Table: ICGLREF
Protocol: Flat, Ordered revisions
DLL: ICGLREF

Compositions: 0

Keys: 1

Title  Fields

Source Trans. Type, G/L Trans. F  SOURCE, GLDEST

Fields: 9

Field  Index  Type  Title  Attributes  Presentation

SOURCE  Integer  Source Transaction Type  E A K P R  List: 11 entries
100=Receipt
101=Receipt Detail
200=Shipment
201=Shipment Detail
300=Adjustment
301=Adjustment Detail
400=Transfer
401=Transfer Detail
500=Assemblies
600=Internal Usage
601=Internal Usage Detail
GLDEST  Integer  G/L Transaction Field  E A K P R  List: 4 entries
0=G/L Entry Description
1=G/L Detail Reference
2=G/L Detail Description
3=G/L Detail Comment
SEPARATOR  Integer  Separator  E A P  List: 9 entries
0=* Asterisk
1=- Hyphen
2=/ Forward Slash
3=\ Back Slash
4=. Period
5=( Left Parenthesis
6=) Right Parenthesis
7=# Number Sign
8= Space
EXAMPLE  String*250  Example  E A   
SEGMENT1  Integer  Included Segment 1  E A P  List: 40 entries
0=None
1=Adjustment Number
2=Adjustment Type
3=Assembly Number
4=BOM Number
5=Category
6=Comment
7=Contact Name
8=Contract
9=Customer Name
10=Customer Number
11=Day End Number
12=Description
13=Detail Description
34=Document Number
14=Document Type
15=Entry Number
16=Entry Type
17=From Location
18=From Location Name
19=GIT Location
20=GIT Location Name
21=Item Number
22=Location
23=Location Name
24=Manufacturer's Item Number
25=Purchase Order Number
26=Project
27=Receipt Number
28=Reference
29=Shipment Number
30=Source Code
31=To Location
32=To Location Name
33=Transaction Type
35=Unformatted Item Number
36=Vendor Name
37=Vendor Number
38=Category
39=Internal Usage Number
SEGMENT2  Integer  Included Segment 2  E A P  List: 40 entries
0=None
1=Adjustment Number
2=Adjustment Type
3=Assembly Number
4=BOM Number
5=Category
6=Comment
7=Contact Name
8=Contract
9=Customer Name
10=Customer Number
11=Day End Number
12=Description
13=Detail Description
34=Document Number
14=Document Type
15=Entry Number
16=Entry Type
17=From Location
18=From Location Name
19=GIT Location
20=GIT Location Name
21=Item Number
22=Location
23=Location Name
24=Manufacturer's Item Number
25=Purchase Order Number
26=Project
27=Receipt Number
28=Reference
29=Shipment Number
30=Source Code
31=To Location
32=To Location Name
33=Transaction Type
35=Unformatted Item Number
36=Vendor Name
37=Vendor Number
38=Category
39=Internal Usage Number
SEGMENT3  Integer  Included Segment 3  E A P  List: 40 entries
0=None
1=Adjustment Number
2=Adjustment Type
3=Assembly Number
4=BOM Number
5=Category
6=Comment
7=Contact Name
8=Contract
9=Customer Name
10=Customer Number
11=Day End Number
12=Description
13=Detail Description
34=Document Number
14=Document Type
15=Entry Number
16=Entry Type
17=From Location
18=From Location Name
19=GIT Location
20=GIT Location Name
21=Item Number
22=Location
23=Location Name
24=Manufacturer's Item Number
25=Purchase Order Number
26=Project
27=Receipt Number
28=Reference
29=Shipment Number
30=Source Code
31=To Location
32=To Location Name
33=Transaction Type
35=Unformatted Item Number
36=Vendor Name
37=Vendor Number
38=Category
39=Internal Usage Number
SEGMENT4  Integer  Included Segment 4  E A P  List: 40 entries
0=None
1=Adjustment Number
2=Adjustment Type
3=Assembly Number
4=BOM Number
5=Category
6=Comment
7=Contact Name
8=Contract
9=Customer Name
10=Customer Number
11=Day End Number
12=Description
13=Detail Description
34=Document Number
14=Document Type
15=Entry Number
16=Entry Type
17=From Location
18=From Location Name
19=GIT Location
20=GIT Location Name
21=Item Number
22=Location
23=Location Name
24=Manufacturer's Item Number
25=Purchase Order Number
26=Project
27=Receipt Number
28=Reference
29=Shipment Number
30=Source Code
31=To Location
32=To Location Name
33=Transaction Type
35=Unformatted Item Number
36=Vendor Name
37=Vendor Number
38=Category
39=Internal Usage Number
SEGMENT5  Integer  Included Segment 5  E A P  List: 40 entries
0=None
1=Adjustment Number
2=Adjustment Type
3=Assembly Number
4=BOM Number
5=Category
6=Comment
7=Contact Name
8=Contract
9=Customer Name
10=Customer Number
11=Day End Number
12=Description
13=Detail Description
34=Document Number
14=Document Type
15=Entry Number
16=Entry Type
17=From Location
18=From Location Name
19=GIT Location
20=GIT Location Name
21=Item Number
22=Location
23=Location Name
24=Manufacturer's Item Number
25=Purchase Order Number
26=Project
27=Receipt Number
28=Reference
29=Shipment Number
30=Source Code
31=To Location
32=To Location Name
33=Transaction Type
35=Unformatted Item Number
36=Vendor Name
37=Vendor Number
38=Category
39=Internal Usage Number

This page was generated on 2009-Nov-19

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