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 2008-May-01

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