Table: G/L Reference Integration

Table: POGLREF
View: PO0351
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: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 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:39 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
37 = Credit Note Number
9 = Day End Number
38 = Debit Note 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 Integer Included Segment 2 List:39 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
37 = Credit Note Number
9 = Day End Number
38 = Debit Note 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 Integer Included Segment 3 List:39 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
37 = Credit Note Number
9 = Day End Number
38 = Debit Note 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 Integer Included Segment 4 List:39 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
37 = Credit Note Number
9 = Day End Number
38 = Debit Note 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 Integer Included Segment 5 List:39 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
37 = Credit Note Number
9 = Day End Number
38 = Debit Note 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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).