Table: G/L Reference Integration

Table: ARGLREF
View: AR0146
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:23 entries
100 = Invoice
101 = Invoice Detail
200 = Debit Note
201 = Debit Note Detail
300 = Credit Note
301 = Credit Note Detail
400 = Receipt
401 = Receipt Detail
402 = Receipt Advance Credit Claim
500 = Prepayment
600 = Unapplied Cash
700 = Apply Document
701 = Apply Document Detail
800 = Miscellaneous Receipt
801 = Miscellaneous Receipt Detail
900 = Miscellaneous Adjustment
901 = Miscellaneous Adjustment Detail
1000 = Adjustment
1001 = Adjustment Detail
1100 = Refund
1101 = Refund Detail
1200 = Revaluation
1300 = Return Customer 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:40 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 = Check/Receipt Number
11 = Comment
12 = Contract
13 = Customer Name
14 = Customer Number
15 = Customer Short Name
39 = Deposit Number
16 = Description
17 = Detail Description
18 = Detail Reference
19 = Distribution Code
20 = Document Number
21 = Document Type
22 = Entry Number
23 = Invoice Number
24 = Item Number/Distribution Code
25 = Order Number
26 = Payer
27 = Payment Code
28 = Payment Type
29 = Posting Sequence
30 = Project
31 = Purchase Order Number
32 = Reference
33 = Resource
34 = Reversal Date
35 = Reversal Description
36 = Ship-To Location
37 = Tax Group
38 = Transaction Type
SEGMENT2 Integer Included Segment 2 List:40 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 = Check/Receipt Number
11 = Comment
12 = Contract
13 = Customer Name
14 = Customer Number
15 = Customer Short Name
39 = Deposit Number
16 = Description
17 = Detail Description
18 = Detail Reference
19 = Distribution Code
20 = Document Number
21 = Document Type
22 = Entry Number
23 = Invoice Number
24 = Item Number/Distribution Code
25 = Order Number
26 = Payer
27 = Payment Code
28 = Payment Type
29 = Posting Sequence
30 = Project
31 = Purchase Order Number
32 = Reference
33 = Resource
34 = Reversal Date
35 = Reversal Description
36 = Ship-To Location
37 = Tax Group
38 = Transaction Type
SEGMENT3 Integer Included Segment 3 List:40 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 = Check/Receipt Number
11 = Comment
12 = Contract
13 = Customer Name
14 = Customer Number
15 = Customer Short Name
39 = Deposit Number
16 = Description
17 = Detail Description
18 = Detail Reference
19 = Distribution Code
20 = Document Number
21 = Document Type
22 = Entry Number
23 = Invoice Number
24 = Item Number/Distribution Code
25 = Order Number
26 = Payer
27 = Payment Code
28 = Payment Type
29 = Posting Sequence
30 = Project
31 = Purchase Order Number
32 = Reference
33 = Resource
34 = Reversal Date
35 = Reversal Description
36 = Ship-To Location
37 = Tax Group
38 = Transaction Type
SEGMENT4 Integer Included Segment 4 List:40 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 = Check/Receipt Number
11 = Comment
12 = Contract
13 = Customer Name
14 = Customer Number
15 = Customer Short Name
39 = Deposit Number
16 = Description
17 = Detail Description
18 = Detail Reference
19 = Distribution Code
20 = Document Number
21 = Document Type
22 = Entry Number
23 = Invoice Number
24 = Item Number/Distribution Code
25 = Order Number
26 = Payer
27 = Payment Code
28 = Payment Type
29 = Posting Sequence
30 = Project
31 = Purchase Order Number
32 = Reference
33 = Resource
34 = Reversal Date
35 = Reversal Description
36 = Ship-To Location
37 = Tax Group
38 = Transaction Type
SEGMENT5 Integer Included Segment 5 List:40 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 = Check/Receipt Number
11 = Comment
12 = Contract
13 = Customer Name
14 = Customer Number
15 = Customer Short Name
39 = Deposit Number
16 = Description
17 = Detail Description
18 = Detail Reference
19 = Distribution Code
20 = Document Number
21 = Document Type
22 = Entry Number
23 = Invoice Number
24 = Item Number/Distribution Code
25 = Order Number
26 = Payer
27 = Payment Code
28 = Payment Type
29 = Posting Sequence
30 = Project
31 = Purchase Order Number
32 = Reference
33 = Resource
34 = Reversal Date
35 = Reversal Description
36 = Ship-To Location
37 = Tax Group
38 = Transaction Type

This page was generated on 2021-Nov-24

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