View: G/L Reference Integration

RotoID: AR0146
Table: ARGLREF
Protocol: Flat, Ordered revisions
DLL:ARGLREF

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