View: G/L Reference Integration

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

Compositions: 0

Keys: 1

Title  Fields

Source Trans. Type, G/L Trans. F  SOURCE, GLDEST

Fields: 9

Field  Index  Type  Title  Attributes  Presentation

SOURCE  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  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  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  String*250  Example  E A   
SEGMENT1  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  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  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  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  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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.