# 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: 9 entries
100 | = | Receipt
101 | = | Receipt Detail
200 | = | Shipment
201 | = | Shipment Detail
300 | = | Adjustment
301 | = | Adjustment Detail
400 | = | Transfer
401 | = | Transfer Detail
500 | = | Assemblies
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: 38 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 | = | Custmer 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
SEGMENT2 | Integer | Included Segment 2 | List: 38 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 | = | Custmer 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
SEGMENT3 | Integer | Included Segment 3 | List: 38 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 | = | Custmer 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
SEGMENT4 | Integer | Included Segment 4 | List: 38 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 | = | Custmer 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
SEGMENT5 | Integer | Included Segment 5 | List: 38 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 | = | Custmer 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

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.