Table: Locations

Table: ICLOC
View: IC0370
Record Length: 925

Flags: A R 

Keys: 1

Title Flags Fields
Location LOCATION

Fields: 44

Field Type Title Presentation
LOCATION String*6 Location Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DESC String*60 Name
ADDRESS1 String*60 Address Line 1
ADDRESS2 String*60 Address Line 2
ADDRESS3 String*60 Address Line 3
ADDRESS4 String*60 Address Line 4
CITY String*30 City
STATE String*30 State
ZIP String*20 Zip/Postal Code Mask: %-20C
COUNTRY String*30 Country
PHONE String*30 Phone Number Mask: (%-3C) %-3C-%-24C
FAX String*30 Fax Number Mask: (%-3C) %-3C-%-24C
CONTACT String*60 Contact
SEGOVERRD Boolean Segment Override
DATELASTMN Date Date Last Maintained
INACTIVE Boolean Status List:2 entries
0 = Active
1 = Inactive
DATEINACTV Date Date Inactive
SEGNUM1 String*6 Segment Number 1
SEGVAL1 String*15 Segment Value 1 Mask: %-15N
SEGNUM2 String*6 Segment Number 2
SEGVAL2 String*15 Segment Value 2 Mask: %-15N
SEGNUM3 String*6 Segment Number 3
SEGVAL3 String*15 Segment Value 3 Mask: %-15N
SEGNUM4 String*6 Segment Number 4
SEGVAL4 String*15 Segment Value 4 Mask: %-15N
SEGNUM5 String*6 Segment Number 5
SEGVAL5 String*15 Segment Value 5 Mask: %-15N
SEGNUM6 String*6 Segment Number 6
SEGVAL6 String*15 Segment Value 6 Mask: %-15N
SEGNUM7 String*6 Segment Number 7
SEGVAL7 String*15 Segment Value 7 Mask: %-15N
SEGNUM8 String*6 Segment Number 8
SEGVAL8 String*15 Segment Value 8 Mask: %-15N
SEGNUM9 String*6 Segment Number 9
SEGVAL9 String*15 Segment Value 9 Mask: %-15N
EMAIL String*50 Location E-mail
PHONEC String*30 Contact Phone Mask: (%-3C) %-3C-%-24C
FAXC String*30 Contact Fax Mask: (%-3C) %-3C-%-24C
EMAILC String*50 Contact E-mail
LOCTYPE Integer Location Type 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).