View: Locations

RotoID: IC0370
Table: ICLOC
Protocol: Flat
DLL:ICLOC

Compositions: 2

RotoID Tables Title DLL
GL0021 GLASV Segment Codes GLASV
IC0290 ICILOC Location Details ICILOC

Keys: 1

Title Fields
Location LOCATION

Fields: 40

Field Index Type Title Attributes Presentation
LOCATION 1 String*6 Location E A K R  Mask: %-6N
DESC 2 String*60 Name E A 
ADDRESS1 3 String*60 Address Line 1 E A 
ADDRESS2 4 String*60 Address Line 2 E A 
ADDRESS3 5 String*60 Address Line 3 E A 
ADDRESS4 6 String*60 Address Line 4 E A 
CITY 7 String*30 City E A 
STATE 8 String*30 State E A 
ZIP 9 String*20 Zip/Postal Code E A  Mask: %-20C
COUNTRY 10 String*30 Country E A 
PHONE 11 String*30 Phone Number E A  Mask: (%-3C) %-3C-%-24C
FAX 12 String*30 Fax Number E A  Mask: (%-3C) %-3C-%-24C
CONTACT 13 String*60 Contact E A 
SEGOVERRD 14 Boolean Segment Override E A 
DATELASTMN 15 Date Date Last Maintained A C 
INACTIVE 16 Boolean Status E A  List:2 entries
0 = Active
1 = Inactive
DATEINACTV 17 Date Date Inactive A C 
SEGNUM1 18 String*6 Segment Number 1 E A 
SEGVAL1 19 String*15 Segment Value 1 E A  Mask: %-15N
SEGNUM2 20 String*6 Segment Number 2 E A 
SEGVAL2 21 String*15 Segment Value 2 E A  Mask: %-15N
SEGNUM3 22 String*6 Segment Number 3 E A 
SEGVAL3 23 String*15 Segment Value 3 E A  Mask: %-15N
SEGNUM4 24 String*6 Segment Number 4 E A 
SEGVAL4 25 String*15 Segment Value 4 E A  Mask: %-15N
SEGNUM5 26 String*6 Segment Number 5 E A 
SEGVAL5 27 String*15 Segment Value 5 E A  Mask: %-15N
SEGNUM6 28 String*6 Segment Number 6 E A 
SEGVAL6 29 String*15 Segment Value 6 E A  Mask: %-15N
SEGNUM7 30 String*6 Segment Number 7 E A 
SEGVAL7 31 String*15 Segment Value 7 E A  Mask: %-15N
SEGNUM8 32 String*6 Segment Number 8 E A 
SEGVAL8 33 String*15 Segment Value 8 E A  Mask: %-15N
SEGNUM9 34 String*6 Segment Number 9 E A 
SEGVAL9 35 String*15 Segment Value 9 E A  Mask: %-15N
EMAIL 36 String*50 Location E-mail E A 
PHONEC 37 String*30 Contact Phone E A  Mask: (%-3C) %-3C-%-24C
FAXC 38 String*30 Contact Fax E A  Mask: (%-3C) %-3C-%-24C
EMAILC 39 String*50 Contact E-mail E A 
LOCTYPE 40 Integer Location Type E A  List:2 entries
0 = Physical
1 = Logical

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).