View: G/L Reference Integration

RotoID: OE0272
Table: OEGLREF
Protocol: Flat, Ordered revisions
DLL: OEGLREF

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: 6 entries
0=Shipment
1=Shipment Detail
2=Invoice
3=Invoice Detail
4=Credit/Debit Note
5=Credit/Debit Note Detail
GLDEST  Integer  G/L Transaction Field  E A K P R  List: 1 entries
0=G/L Entry Description
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: 14 entries
0=None
8=Contact Name
7=Customer Name
6=Customer Number
1=Day End Number
11=Description
3=Entry Number
9=Order Number
12=Reference
5=Shipment Number
13=Ship-To Location
14=Ship-Via
15=Ship-Via Description
2=Source Code
SEGMENT2  Integer  Included Segment 2  E A P  List: 14 entries
0=None
8=Contact Name
7=Customer Name
6=Customer Number
1=Day End Number
11=Description
3=Entry Number
9=Order Number
12=Reference
5=Shipment Number
13=Ship-To Location
14=Ship-Via
15=Ship-Via Description
2=Source Code
SEGMENT3  Integer  Included Segment 3  E A P  List: 14 entries
0=None
8=Contact Name
7=Customer Name
6=Customer Number
1=Day End Number
11=Description
3=Entry Number
9=Order Number
12=Reference
5=Shipment Number
13=Ship-To Location
14=Ship-Via
15=Ship-Via Description
2=Source Code
SEGMENT4  Integer  Included Segment 4  E A P  List: 14 entries
0=None
8=Contact Name
7=Customer Name
6=Customer Number
1=Day End Number
11=Description
3=Entry Number
9=Order Number
12=Reference
5=Shipment Number
13=Ship-To Location
14=Ship-Via
15=Ship-Via Description
2=Source Code
SEGMENT5  Integer  Included Segment 5  E A P  List: 14 entries
0=None
8=Contact Name
7=Customer Name
6=Customer Number
1=Day End Number
11=Description
3=Entry Number
9=Order Number
12=Reference
5=Shipment Number
13=Ship-To Location
14=Ship-Via
15=Ship-Via Description
2=Source Code

This page was generated on 2009-Nov-19

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