Table: G/L Reference Integration

Table: POGLREF
View: PO0351
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: 14 entries
0=Receipt
1=Receipt Detail
2=Receipt Expensed Additional Cost Detail
3=Invoice
4=Invoice Detail
5=Invoice Expensed Additional Cost Detail
6=Return
7=Return Detail
8=Credit Note
9=Credit Note Detail
10=Credit Note Expensed Additional Cost Detail
11=Debit Note
12=Debit Note Detail
13=Debit Note Expensed Additional Cost Detail
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=Additional Cost
2=Additional Cost Description
3=Bill-To Description
4=Bill-To Location
5=Category
6=Comments
7=Contact Name
8=Contract
9=Day End Number
10=Description
11=Detail Description
12=Document Number
13=Document Type
14=Entry Number
15=From Document
16=Invoice Number
17=Item Number
18=Location
19=Location Name
20=Manufacturer's Item Number
21=Order Number
22=Project
23=Purchase Order Number
24=Receipt Number
25=Reference
26=Remit-To Location
27=Return Number
28=Return/Invoice Number
29=Ship-To Location
30=Ship-Via
31=Ship-Via Description
32=Source Code
33=Unformatted Item Number
34=Vendor Item Number
35=Vendor Name
36=Vendor Number
SEGMENT2  Integer  Included Segment 2  List: 37 entries
0=None
1=Additional Cost
2=Additional Cost Description
3=Bill-To Description
4=Bill-To Location
5=Category
6=Comments
7=Contact Name
8=Contract
9=Day End Number
10=Description
11=Detail Description
12=Document Number
13=Document Type
14=Entry Number
15=From Document
16=Invoice Number
17=Item Number
18=Location
19=Location Name
20=Manufacturer's Item Number
21=Order Number
22=Project
23=Purchase Order Number
24=Receipt Number
25=Reference
26=Remit-To Location
27=Return Number
28=Return/Invoice Number
29=Ship-To Location
30=Ship-Via
31=Ship-Via Description
32=Source Code
33=Unformatted Item Number
34=Vendor Item Number
35=Vendor Name
36=Vendor Number
SEGMENT3  Integer  Included Segment 3  List: 37 entries
0=None
1=Additional Cost
2=Additional Cost Description
3=Bill-To Description
4=Bill-To Location
5=Category
6=Comments
7=Contact Name
8=Contract
9=Day End Number
10=Description
11=Detail Description
12=Document Number
13=Document Type
14=Entry Number
15=From Document
16=Invoice Number
17=Item Number
18=Location
19=Location Name
20=Manufacturer's Item Number
21=Order Number
22=Project
23=Purchase Order Number
24=Receipt Number
25=Reference
26=Remit-To Location
27=Return Number
28=Return/Invoice Number
29=Ship-To Location
30=Ship-Via
31=Ship-Via Description
32=Source Code
33=Unformatted Item Number
34=Vendor Item Number
35=Vendor Name
36=Vendor Number
SEGMENT4  Integer  Included Segment 4  List: 37 entries
0=None
1=Additional Cost
2=Additional Cost Description
3=Bill-To Description
4=Bill-To Location
5=Category
6=Comments
7=Contact Name
8=Contract
9=Day End Number
10=Description
11=Detail Description
12=Document Number
13=Document Type
14=Entry Number
15=From Document
16=Invoice Number
17=Item Number
18=Location
19=Location Name
20=Manufacturer's Item Number
21=Order Number
22=Project
23=Purchase Order Number
24=Receipt Number
25=Reference
26=Remit-To Location
27=Return Number
28=Return/Invoice Number
29=Ship-To Location
30=Ship-Via
31=Ship-Via Description
32=Source Code
33=Unformatted Item Number
34=Vendor Item Number
35=Vendor Name
36=Vendor Number
SEGMENT5  Integer  Included Segment 5  List: 37 entries
0=None
1=Additional Cost
2=Additional Cost Description
3=Bill-To Description
4=Bill-To Location
5=Category
6=Comments
7=Contact Name
8=Contract
9=Day End Number
10=Description
11=Detail Description
12=Document Number
13=Document Type
14=Entry Number
15=From Document
16=Invoice Number
17=Item Number
18=Location
19=Location Name
20=Manufacturer's Item Number
21=Order Number
22=Project
23=Purchase Order Number
24=Receipt Number
25=Reference
26=Remit-To Location
27=Return Number
28=Return/Invoice Number
29=Ship-To Location
30=Ship-Via
31=Ship-Via Description
32=Source Code
33=Unformatted Item Number
34=Vendor Item Number
35=Vendor Name
36=Vendor Number

This page was generated on 2009-Nov-19

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