# View: G/L Reference Integration

RotoID: PO0351
Table: POGLREF
Protocol: Flat, Ordered revisions
DLL: POGLREF

## 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: 14 entries
0 | = | Receipt
1 | = | Receipt Detail
2 | = | Receipt Expensed Additional Cost Detail
3 | = | Invoice
4 | = | Invoice Detail
5 | = | Invoice Expensed Additional Cost Detail
6 | = | Return
7 | = | Return Detail
8 | = | Credit Note
9 | = | Credit Note Detail
10 | = | Credit Note Expensed Additional Cost Detail
11 | = | Debit Note
12 | = | Debit Note Detail
13 | = | Debit Note Expensed Additional Cost Detail
GLDEST | 2 | 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 | 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: 37 entries
0 | = | None
1 | = | Additional Cost
2 | = | Additional Cost Description
3 | = | Bill-To Description
4 | = | Bill-To Location
5 | = | Category
6 | = | Comments
7 | = | Contact Name
8 | = | Contract
9 | = | Day End Number
10 | = | Description
11 | = | Detail Description
12 | = | Document Number
13 | = | Document Type
14 | = | Entry Number
15 | = | From Document
16 | = | Invoice Number
17 | = | Item Number
18 | = | Location
19 | = | Location Name
20 | = | Manufacturer's Item Number
21 | = | Order Number
22 | = | Project
23 | = | Purchase Order Number
24 | = | Receipt Number
25 | = | Reference
26 | = | Remit-To Location
27 | = | Return Number
28 | = | Return/Invoice Number
29 | = | Ship-To Location
30 | = | Ship-Via
31 | = | Ship-Via Description
32 | = | Source Code
33 | = | Unformatted Item Number
34 | = | Vendor Item Number
35 | = | Vendor Name
36 | = | Vendor Number
SEGMENT2 | 6 | Integer | Included Segment 2 | E A P | List: 37 entries
0 | = | None
1 | = | Additional Cost
2 | = | Additional Cost Description
3 | = | Bill-To Description
4 | = | Bill-To Location
5 | = | Category
6 | = | Comments
7 | = | Contact Name
8 | = | Contract
9 | = | Day End Number
10 | = | Description
11 | = | Detail Description
12 | = | Document Number
13 | = | Document Type
14 | = | Entry Number
15 | = | From Document
16 | = | Invoice Number
17 | = | Item Number
18 | = | Location
19 | = | Location Name
20 | = | Manufacturer's Item Number
21 | = | Order Number
22 | = | Project
23 | = | Purchase Order Number
24 | = | Receipt Number
25 | = | Reference
26 | = | Remit-To Location
27 | = | Return Number
28 | = | Return/Invoice Number
29 | = | Ship-To Location
30 | = | Ship-Via
31 | = | Ship-Via Description
32 | = | Source Code
33 | = | Unformatted Item Number
34 | = | Vendor Item Number
35 | = | Vendor Name
36 | = | Vendor Number
SEGMENT3 | 7 | Integer | Included Segment 3 | E A P | List: 37 entries
0 | = | None
1 | = | Additional Cost
2 | = | Additional Cost Description
3 | = | Bill-To Description
4 | = | Bill-To Location
5 | = | Category
6 | = | Comments
7 | = | Contact Name
8 | = | Contract
9 | = | Day End Number
10 | = | Description
11 | = | Detail Description
12 | = | Document Number
13 | = | Document Type
14 | = | Entry Number
15 | = | From Document
16 | = | Invoice Number
17 | = | Item Number
18 | = | Location
19 | = | Location Name
20 | = | Manufacturer's Item Number
21 | = | Order Number
22 | = | Project
23 | = | Purchase Order Number
24 | = | Receipt Number
25 | = | Reference
26 | = | Remit-To Location
27 | = | Return Number
28 | = | Return/Invoice Number
29 | = | Ship-To Location
30 | = | Ship-Via
31 | = | Ship-Via Description
32 | = | Source Code
33 | = | Unformatted Item Number
34 | = | Vendor Item Number
35 | = | Vendor Name
36 | = | Vendor Number
SEGMENT4 | 8 | Integer | Included Segment 4 | E A P | List: 37 entries
0 | = | None
1 | = | Additional Cost
2 | = | Additional Cost Description
3 | = | Bill-To Description
4 | = | Bill-To Location
5 | = | Category
6 | = | Comments
7 | = | Contact Name
8 | = | Contract
9 | = | Day End Number
10 | = | Description
11 | = | Detail Description
12 | = | Document Number
13 | = | Document Type
14 | = | Entry Number
15 | = | From Document
16 | = | Invoice Number
17 | = | Item Number
18 | = | Location
19 | = | Location Name
20 | = | Manufacturer's Item Number
21 | = | Order Number
22 | = | Project
23 | = | Purchase Order Number
24 | = | Receipt Number
25 | = | Reference
26 | = | Remit-To Location
27 | = | Return Number
28 | = | Return/Invoice Number
29 | = | Ship-To Location
30 | = | Ship-Via
31 | = | Ship-Via Description
32 | = | Source Code
33 | = | Unformatted Item Number
34 | = | Vendor Item Number
35 | = | Vendor Name
36 | = | Vendor Number
SEGMENT5 | 9 | Integer | Included Segment 5 | E A P | List: 37 entries
0 | = | None
1 | = | Additional Cost
2 | = | Additional Cost Description
3 | = | Bill-To Description
4 | = | Bill-To Location
5 | = | Category
6 | = | Comments
7 | = | Contact Name
8 | = | Contract
9 | = | Day End Number
10 | = | Description
11 | = | Detail Description
12 | = | Document Number
13 | = | Document Type
14 | = | Entry Number
15 | = | From Document
16 | = | Invoice Number
17 | = | Item Number
18 | = | Location
19 | = | Location Name
20 | = | Manufacturer's Item Number
21 | = | Order Number
22 | = | Project
23 | = | Purchase Order Number
24 | = | Receipt Number
25 | = | Reference
26 | = | Remit-To Location
27 | = | Return Number
28 | = | Return/Invoice Number
29 | = | Ship-To Location
30 | = | Ship-Via
31 | = | Ship-Via Description
32 | = | Source Code
33 | = | Unformatted Item Number
34 | = | Vendor Item Number
35 | = | Vendor Name
36 | = | Vendor Number

This page was generated on 2009-Nov-19

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