# View: G/L Reference Integration

RotoID: OE0272
Table: OEGLREF
Protocol: Flat, Ordered revisions
DLL: OEGLREF

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Source Trans. Type, G/L Trans. F | SOURCE, GLDEST

## Fields: 9

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SOURCE | 1 | Integer | Source Transaction Type | E A K P R | List: 6 entries
0 | = | Shipment
1 | = | Shipment Detail
2 | = | Invoice
3 | = | Invoice Detail
4 | = | Credit/Debit Note
5 | = | Credit/Debit Note Detail
GLDEST | 2 | Integer | G/L Transaction Field | E A K P R | List: 1 entries
0 | = | G/L Entry Description
SEPARATOR | 3 | 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 | 4 | String*250 | Example | E A |
SEGMENT1 | 5 | Integer | Included Segment 1 | E A P | List: 14 entries
0 | = | None
8 | = | Contact Name
7 | = | Customer Name
6 | = | Customer Number
1 | = | Day End Number
11 | = | Description
3 | = | Entry Number
9 | = | Order Number
12 | = | Reference
5 | = | Shipment Number
13 | = | Ship-To Location
14 | = | Ship-Via
15 | = | Ship-Via Description
2 | = | Source Code
SEGMENT2 | 6 | Integer | Included Segment 2 | E A P | List: 14 entries
0 | = | None
8 | = | Contact Name
7 | = | Customer Name
6 | = | Customer Number
1 | = | Day End Number
11 | = | Description
3 | = | Entry Number
9 | = | Order Number
12 | = | Reference
5 | = | Shipment Number
13 | = | Ship-To Location
14 | = | Ship-Via
15 | = | Ship-Via Description
2 | = | Source Code
SEGMENT3 | 7 | Integer | Included Segment 3 | E A P | List: 14 entries
0 | = | None
8 | = | Contact Name
7 | = | Customer Name
6 | = | Customer Number
1 | = | Day End Number
11 | = | Description
3 | = | Entry Number
9 | = | Order Number
12 | = | Reference
5 | = | Shipment Number
13 | = | Ship-To Location
14 | = | Ship-Via
15 | = | Ship-Via Description
2 | = | Source Code
SEGMENT4 | 8 | Integer | Included Segment 4 | E A P | List: 14 entries
0 | = | None
8 | = | Contact Name
7 | = | Customer Name
6 | = | Customer Number
1 | = | Day End Number
11 | = | Description
3 | = | Entry Number
9 | = | Order Number
12 | = | Reference
5 | = | Shipment Number
13 | = | Ship-To Location
14 | = | Ship-Via
15 | = | Ship-Via Description
2 | = | Source Code
SEGMENT5 | 9 | Integer | Included Segment 5 | E A P | List: 14 entries
0 | = | None
8 | = | Contact Name
7 | = | Customer Name
6 | = | Customer Number
1 | = | Day End Number
11 | = | Description
3 | = | Entry Number
9 | = | Order Number
12 | = | Reference
5 | = | Shipment Number
13 | = | Ship-To Location
14 | = | Ship-Via
15 | = | Ship-Via Description
2 | = | Source Code

This page was generated on 2009-Nov-19

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