ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.utility/AD Dataset
Contents
|
AD_Dataset
Sets of data.
- Name:DataSet
- Classname:DataSet
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| ExportAllowed | N | CHAR(1) | This data set can be exported |
| AD_Dataset_ID | N | VARCHAR2(32) | Dataset |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| 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. |
| AD_Module_ID | N | VARCHAR2(32) | Module |
| Export | N | CHAR(1) | Export Reference Data to a XML file |
| Accesslevel | Y | VARCHAR2(60) | Indicates what type of data (in terms of AD_CLIENT and AD_ORG data columns) can be entered or viewed. |
| Checksum | Y | VARCHAR2(100) | Contains the checksum information of this dataset |
Other Info
Check constraints
These are the check constraints for this table:
- AD_DATASET_EXPORTALLOWED_CHK: EXPORTALLOWED IN ('Y', 'N')
- AD_DATASET_ISACTIVE_CHK: ISACTIVE 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_DATASET_KEY
Columns
Export allowed
This data set can be exported. There are datasets which are not meant to be exported, such as the AD dataset (which contains the set of tables which define the Application Dictionary), or the Client dataset. If the dataset needs to be exported via the Export Dataset functionality, this check should be marked. If it's going to be used for another purpose, and its data content doesn't need to be included inside the modules, then it should be unchecked.
- Physical column name: ExportAllowed
- Property Name: exportAllowed
- Reference: YesNo
- Default value: Y
Dataset
Indicates the dataset the element forms part of.
- Physical column name: AD_Dataset_ID
- Property Name: id
- Reference: 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@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_ORG_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Validation Rule AD_Org Security validation: Organizations of the Client with user acces rights. With the following code:
(@AD_Client_ID@='0' AND AD_Org.AD_Org_ID='0') OR (@AD_Client_ID@!='0' AND ((AD_Org.AD_Client_ID IN (@#User_Client@) AND AD_Org.AD_Org_ID IN (@#User_Org@)) OR AD_Org.AD_Org_ID='0' AND AD_Org.IsSummary='N'))
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
- Default value: SYSDATE
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Table
Foreign key column to AD_User table, (column: AD_User_ID)
Reference Table AD_User
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Table
Foreign key column to AD_User table, (column: AD_User_ID)
Reference Table AD_User
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
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
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
- Default value: 0
Foreign key column to AD_Module table, (column: AD_Module_ID)
Validation Rule Ad_Module_ID IsInDevelopment: AD_Module_ID IsInDevelopment. With the following code:
IsInDevelopment = 'Y' AND type != 'T'
Export
Export Reference Data to a XML file
- Physical column name: Export
- Property Name: export
- Reference: Button
- Default value: N
Data Access Level
Indicates what type of data (in terms of AD_CLIENT and AD_ORG data columns) can be entered or viewed. We can classify data in 4 major categories:
- System (AD_CLIENT_ID=0, AD_ORG_ID=0) - system data (such as metadata for window, tab and field definition)
- Organization (AD_CLIENT<>0, AD_ORG_ID<>0) - data particular to an organization (such as sales orders)
- Client/Organization (AD_CLIENT<>0, AD_ORG_ID=anything) - data particular to an organization or shared among all organizations within one client
- Client (AD_CLIENT<>0, AD_ORG_ID=0) - data that is specific to a client but can be used by all organizations within that client
or All (AD_CLIENT=anything, AD_ORG_ID=anything)
- Physical column name: Accesslevel
- Property Name: dataAccessLevel
- Reference: List
- Default value: 4
Validation Rule AD_DataSet access level: null. With the following code:
value<>'7'
List values: AD_Table Access Levels
The allowed values for this list are:
- 1 (Organization)
- 3 (Client/Organization)
- 4 (System only)
- 6 (System/Client)
- 7 (All)
Checksum
The checksum information is used to verify whether the version of the dataset which was imported in the database is up to date, or needs to be updated.
- Physical column name: Checksum
- Property Name: checksum
- Reference: String
Related tables
Tables that link this table: