View: G/L Reference Integration

RotoID: AP0121
Table: APGLREF
Protocol: Flat, Ordered revisions
DLL:APGLREF

Keys: 1

Title Fields

Source Trans. Type, G/L Trans. F SOURCEGLDEST

Fields: 9

Field Index Type Title Attributes Presentation

SOURCE 1 Integer Source Transaction Type E A K P R  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 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: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 6 Integer Included Segment 2 E A P  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 7 Integer Included Segment 3 E A P  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 8 Integer Included Segment 4 E A P  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 9 Integer Included Segment 5 E A P  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