Table: G/L Reference Integration

Table: ICGLREF
View: IC0281
Record length: 40
Flags: A R 

Keys: 1

Title  Flags  Fields

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

Fields: 12

Field  Type  Title  Presentation 

SOURCE  Integer  Source Transaction Type  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  List: 4 entries
0=G/L Entry Description
1=G/L Detail Reference
2=G/L Detail Description
3=G/L Detail Comment
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SEPARATOR  Integer  Separator  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
SEGMENT1  Integer  Included Segment 1  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  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  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  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  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 2008-May-01

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