Table: G/L Reference Integration

Table: APGLREF
View: AP0121
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:20 entries
100 = Invoice
101 = Invoice Detail
200 = Debit Note
201 = Debit Note Detail
300 = Credit Note
301 = Credit Note Detail
400 = Payment
401 = Payment Detail
402 = Payment Advance Credit Claim
500 = Prepayment
600 = Apply Document
601 = Apply Document Detail
700 = Miscellaneous Payment
701 = Miscellaneous Payment Detail
800 = Miscellaneous Adjustment
801 = Miscellaneous Adjustment Detail
900 = Adjustment
901 = Adjustment Detail
1000 = Revaluation
1100 = Reverse Check
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:37 entries
0 = None
1 = Adjustment Number
2 = Apply By Document Type
3 = Apply-To Document Number
4 = Bank Code
5 = Batch Number
6 = Batch Type
7 = Category
8 = Check Date
9 = Check Number
10 = Comment
11 = Contract
12 = Description
13 = Detail Description
14 = Detail Reference
15 = Distribution Code
16 = Document Number
17 = Document Type
18 = Entry Number
19 = Invoice Number
20 = Order Number
21 = Payee
22 = Payment Code
23 = Posting Sequence
24 = Project
25 = Purchase Order Number
26 = Reference
27 = Remit To
28 = Remit-To Location
29 = Resource
30 = Reversal Date
31 = Reversal Description
32 = Tax Group
33 = Transaction Type
34 = Vendor Name
35 = Vendor Number
36 = Vendor Short Name
SEGMENT2 Integer Included Segment 2 List:37 entries
0 = None
1 = Adjustment Number
2 = Apply By Document Type
3 = Apply-To Document Number
4 = Bank Code
5 = Batch Number
6 = Batch Type
7 = Category
8 = Check Date
9 = Check Number
10 = Comment
11 = Contract
12 = Description
13 = Detail Description
14 = Detail Reference
15 = Distribution Code
16 = Document Number
17 = Document Type
18 = Entry Number
19 = Invoice Number
20 = Order Number
21 = Payee
22 = Payment Code
23 = Posting Sequence
24 = Project
25 = Purchase Order Number
26 = Reference
27 = Remit To
28 = Remit-To Location
29 = Resource
30 = Reversal Date
31 = Reversal Description
32 = Tax Group
33 = Transaction Type
34 = Vendor Name
35 = Vendor Number
36 = Vendor Short Name
SEGMENT3 Integer Included Segment 3 List:37 entries
0 = None
1 = Adjustment Number
2 = Apply By Document Type
3 = Apply-To Document Number
4 = Bank Code
5 = Batch Number
6 = Batch Type
7 = Category
8 = Check Date
9 = Check Number
10 = Comment
11 = Contract
12 = Description
13 = Detail Description
14 = Detail Reference
15 = Distribution Code
16 = Document Number
17 = Document Type
18 = Entry Number
19 = Invoice Number
20 = Order Number
21 = Payee
22 = Payment Code
23 = Posting Sequence
24 = Project
25 = Purchase Order Number
26 = Reference
27 = Remit To
28 = Remit-To Location
29 = Resource
30 = Reversal Date
31 = Reversal Description
32 = Tax Group
33 = Transaction Type
34 = Vendor Name
35 = Vendor Number
36 = Vendor Short Name
SEGMENT4 Integer Included Segment 4 List:37 entries
0 = None
1 = Adjustment Number
2 = Apply By Document Type
3 = Apply-To Document Number
4 = Bank Code
5 = Batch Number
6 = Batch Type
7 = Category
8 = Check Date
9 = Check Number
10 = Comment
11 = Contract
12 = Description
13 = Detail Description
14 = Detail Reference
15 = Distribution Code
16 = Document Number
17 = Document Type
18 = Entry Number
19 = Invoice Number
20 = Order Number
21 = Payee
22 = Payment Code
23 = Posting Sequence
24 = Project
25 = Purchase Order Number
26 = Reference
27 = Remit To
28 = Remit-To Location
29 = Resource
30 = Reversal Date
31 = Reversal Description
32 = Tax Group
33 = Transaction Type
34 = Vendor Name
35 = Vendor Number
36 = Vendor Short Name
SEGMENT5 Integer Included Segment 5 List:37 entries
0 = None
1 = Adjustment Number
2 = Apply By Document Type
3 = Apply-To Document Number
4 = Bank Code
5 = Batch Number
6 = Batch Type
7 = Category
8 = Check Date
9 = Check Number
10 = Comment
11 = Contract
12 = Description
13 = Detail Description
14 = Detail Reference
15 = Distribution Code
16 = Document Number
17 = Document Type
18 = Entry Number
19 = Invoice Number
20 = Order Number
21 = Payee
22 = Payment Code
23 = Posting Sequence
24 = Project
25 = Purchase Order Number
26 = Reference
27 = Remit To
28 = Remit-To Location
29 = Resource
30 = Reversal Date
31 = Reversal Description
32 = Tax Group
33 = Transaction Type
34 = Vendor Name
35 = Vendor Number
36 = Vendor Short Name

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