View: G/L Reference Integration

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

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: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 6 Integer Included Segment 2 E A P  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 7 Integer Included Segment 3 E A P  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 8 Integer Included Segment 4 E A P  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 9 Integer Included Segment 5 E A P  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 2022-Aug-18

© 2021 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).