View: G/L Reference Integration

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

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: 19 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
1100=Reverse 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: 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  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  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  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  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

This page was generated on 2009-Nov-19

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