]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

4 registered users
 in last 24 hours

]po[ Office

The office object type is used to keep track of the various locations and differing branches of client companies involved in projects.

Office Fields

 

image:office_screenshot3.gif

  • Office Name:

    Human readable name of the particular office's name

  • Company Name:

        Human readable name of the parent company to which the particular office belongs.

  • Office Type:

        The office's function and rank within the parent company.

  • Office Path:

         This is the short name of the office which is the link between the office and the underlying filestorage system.  To view all the of

          the files belonging to the ABC Consulting Main Office, the pathname into the filestorage is abc_trans.

  • Status:
        Current state of the offices, whether they are active or not.
  • Contact Liaison:

        Employee Name who is responsible for relations between the project and the particular office.

  • City Name:

         Name of the city in which the office is located.

  • Phone Number:
        Format Recommendation: Client number is preceded by + and the country code. Ex. (USA)+0013096850627

 

Data-Model

 

Structure of the im_offices database table:

        Column        |          Type           |      Modifiers
----------------------+-------------------------+---------------------
 office_id            | integer                 | not null
 office_name          | character varying(1000) | not null
 office_path          | character varying(100)  | not null
 office_status_id     | integer                 | not null
 office_type_id       | integer                 | not null
 company_id           | integer                 |
 public_p             | character(1)            | default 'f'::bpchar
 phone                | character varying(50)   |
 fax                  | character varying(50)   |
 address_line1        | character varying(80)   |
 address_line2        | character varying(80)   |
 address_city         | character varying(80)   |
 address_state        | character varying(80)   |
 address_postal_code  | character varying(80)   |
 address_country_code | character(2)            |
 contact_person_id    | integer                 |
 landlord             | character varying(4000) |
 security             | character varying(4000) |
 note                 | character varying(4000) |

­ 


 

References

Related Object Types

 

      Abstract Super Type

  • [ Business Object]
    

Related Packages

Related Modules


Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy