Table: G/L Reference Integration

Table: APGLREF
View: AP0121
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: 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  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: 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  Integer  Included Segment 2  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  Integer  Included Segment 3  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  Integer  Included Segment 4  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  Integer  Included Segment 5  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

This page was generated on 2008-May-01

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