Log in / create account

View source | Discuss this page | Page history | Printable version

Toolbox

What links here

Help

Search

Participate

Talk to us now!

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.enterprise/AD Org

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.enterprise

AD_Org

The Organization Tab is used to define an Organization. Each Organization has a Key and Name and optionally a Description. When adding a new organization, you must re-login to be able to access the new organization.
Please note that you will not be able to create new entities in this window if you have not set defaults for all mandatory values!

Name:Organization
Classname:Organization

This table contains the following columns:

Name	Nullable	Data Type	Description
AD_Org_ID	N	VARCHAR2(32)	Organizational entity within client
AD_Client_ID	N	VARCHAR2(32)	Client for this installation.
IsActive	N	CHAR(1)	A flag indicating whether this record is available for use or de-activated.
Created	N	DATE	The date that this record is completed.
CreatedBy	N	VARCHAR2(32)	User who created this records
Updated	N	DATE	x not implemented
UpdatedBy	N	VARCHAR2(32)	User who updated this records
Value	N	NVARCHAR2(40)	A fast method for finding a particular record.
Name	N	NVARCHAR2(60)	A non-unique identifier for a record/document often used as a search tool.
Description	Y	NVARCHAR2(255)	A space to write additional related information.
IsSummary	N	CHAR(1)	A means of grouping fields in order to view or hide additional information.
AD_Orgtype_ID	N	VARCHAR2(32)	Defines the Organization Type
IsPeriodControlAllowed	N	CHAR(1)	Specifies if the organization can open and close a period control
C_Calendar_ID	Y	VARCHAR2(32)	A table showing the days of the week for each month of the year.
IsReady	N	CHAR(1)	Flag to check if the organization is ready for usage

Other Info

Check constraints

These are the check constraints for this table:

AD_ORG_CALENDAR_CHECK: ((ISPERIODCONTROLALLOWED = 'Y') AND (C_CALENDAR_ID IS NOT NULL)) OR (C_CALENDAR_ID IS NULL)
AD_ORG_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
AD_ORG_ISPERIODCONTROL_CHECK: ISPERIODCONTROLALLOWED IN ('Y', 'N')
AD_ORG_ISREADY_CHECK: ISREADY IN ('Y', 'N')

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

AD_ORG_KEY
- AD_Org_ID
AD_ORG_VALUE
- AD_Client_ID
- Value

Columns

Organization

An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.

Physical column name: AD_Org_ID
Property Name: id
Reference: ID
Default value: @AD_Org_ID@

Client

Physical column name: AD_Client_ID
Property Name: client
Reference: TableDir
Default value: @AD_CLIENT_ID@

Foreign key column to AD_Client table, (column: AD_Client_ID)

Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

Physical column name: IsActive
Property Name: active
Reference: YesNo
Default value: Y

Creation Date

The Created field indicates the date that this record was created.

Physical column name: Created
Property Name: creationDate
Reference: DateTime

Created By

Physical column name: CreatedBy
Property Name: createdBy
Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

Updated

The Updated field indicates the date that this record was updated.

Physical column name: Updated
Property Name: updated
Reference: DateTime

Updated By

Physical column name: UpdatedBy
Property Name: updatedBy
Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

Search Key

A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).

Usually, company's internal identifiers for various records (products, customers, etc) are stored here.

Physical column name: Value
Property Name: searchKey
Reference: String

Callout: SL_Organization_Info

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Organization_Info Java class.

Name

A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

Physical column name: Name
Property Name: name
Reference: String
This column is part of the table's identifier

Description

A description is limited to 255 characters.

Physical column name: Description
Property Name: description
Reference: String

Summary Level

A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.

Physical column name: IsSummary
Property Name: summaryLevel
Reference: YesNo

Organization Type

Physical column name: AD_Orgtype_ID
Property Name: organizationType
Reference: TableDir

Foreign key column to AD_Orgtype table, (column: AD_Orgtype_ID)

Callout: SE_Period_Control

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SE_Period_Control Java class.

Allow Period Control

An organization that is checked as business unit or as a legal entity can open and close a period control.

Physical column name: IsPeriodControlAllowed
Property Name: allowPeriodControl
Reference: YesNo
Default value: N

Calendar

Physical column name: C_Calendar_ID
Property Name: calendar
Reference: TableDir

Foreign key column to C_Calendar table, (column: C_Calendar_ID)

Ready

While the organization is not ready, it can be moved inside the organization's tree. A not ready organization can not execute transactions.

Physical column name: IsReady
Property Name: ready
Reference: Button
Default value: N

Related tables

Tables that link this table:

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.common.enterprise/AD_Org"

This page has been accessed 3,202 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.