ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.domain/AD Preference
AD_Preference
- Name:AD_Preference
- Classname:ADPreference
This table contains the following columns:
Name | Nullable | Data Type | Description
|
IsActive | No | CHAR (1) | 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. |
Attribute | Yes | NVARCHAR (60) | A defined characteristic of a specific product. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
Inherited_From | Yes | VARCHAR (32) | The role from which a permission has been inherited. If a permission has this field set it means that this is an inherited permission, an therefore that the role owner of the permission is able to access it because it inherits from the role defined in this field. |
AD_Module_ID | Yes | VARCHAR (32) | Indicates the module the element forms part of. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
AD_Preference_ID | No | VARCHAR (32) | Personal Preference, a default value that will be used by a user. |
Property | Yes | VARCHAR (60) | It is the "Configuration Property" this record sets value to.
Configuration Properties are defined by modules with the purpose other modules are capable to assign them values. |
IsPropertyList | No | CHAR (1) | When this field is checked, the preference is defined by Property which is a selectable value from a drop down list. Properties are defined by modules.
In case the field is not checked, the preference is defined by Attribute, which is a free text name. |
Value | Yes | CLOB | 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. |
Selected | Yes | CHAR (1) | In case of conflict (multiple values for a single property), this field must be checked for one of them in order to pick this one over the rest. |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
AD_User_ID | Yes | VARCHAR (32) | The User identifies a unique user in the system. This could be an internal user or a business partner contact |
VisibleAt_Client_ID | Yes | VARCHAR (32) | Defines which is the preference's visibility at client level. If this value is empty the preference will be visible from all Clients. |
VisibleAt_Org_ID | Yes | VARCHAR (32) | Defines which is the preference's visibility at Organization level. The preference will be visible from all organizations in the tree bellow this one. If this value is empty the preference will be visible from all Organizations. |
VisibleAt_Role_ID | Yes | VARCHAR (32) | Defines which is the preference's visibility at Role level. If this value is empty the preference will be visible from all Roles. |
AD_Window_ID | Yes | VARCHAR (32) | The Window field identifies a unique Window in the system. |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Attribute
- Physical column name: Attribute
- Property Name: attribute
- Reference: String
- This column is part of the table's identifier
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Inherited_From
- Physical column name: Inherited_From
- Property Name: inheritedFrom
- Reference: Table
Foreign key column to AD_Role table, (column: AD_Role_ID)
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
Foreign key column to AD_Module table, (column: AD_Module_ID)
It has a validation "Ad_Module_ID IsInDevelopment", with the following code
IsInDevelopment = 'Y' and type != 'T'
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Preference
- Physical column name: AD_Preference_ID
- Property Name: id
- Reference: ID
Property
- Physical column name: Property
- Property Name: property
- Reference: List
- This column is part of the table's identifier
List values: Property Configuration
The allowed values for this list are:
- OBUIAPP_DefaultSavedView (Default View Setting): The id of the default view for the user
- AllowAttachment (Allow Attachment)
- LogoutRedirectURL (Logout Redirect URL)
- DisableNotesForReadOnlyTabs (Disable Notes For Read-Only tabs)
- InvoicePaidStatus (Allow to use invoice paid status control): Allow to use invoice paid status control
- NotAllowChangeExchange (Not allow to change exchange rate and amount): Not allow to change exchange rate and amount
- ExportToCsv (Export to CSV)
- UomManagement (Enable UOM Management): Enable UOM Management
- DoNotSyncDateDelivered (Do not syncronize date delivered based on header info)
- FinancialManagement (Implements an alternative Financial Management)
- AGING_ShowVoidCheckbox (Enable void documents filter in Aging Reports)
- StartPage (Startpage of the user): The page to which the user is redirected after logging in.
- UnitaryCost (Allow to persist Unit Cost): Allow to persist Unit Cost for each Product
- SaveAttachmentsOldWay (Save Attachments in old way): Saves the attachments using the earlier folder structure
- WriteOffLimitPreference (Write-off limit): Write-off limit
- ExcelExportFormat (Excel Export Format): Default format (xls or xlsx) to be used when exporting Excel reports
- CancelAndReplaceAssociateShipmentToNewTicket (Cancel and Replace - Associate shipment lines to new order): Cancelled Sales Order Shipment lines are associated to new Sales Order
- AllowNotApplyingWhereClauseToChildNodes (AllowNotApplyingWhereClauseToChildNodes)
- ForcedLoginURL (Forced Login URL): If this property is set and the Openbravo login page is accessed using a different URL, it will be redirected to this one. Value for this property should be assigned at system level.
- enableNegativeStockCorrections (Enable Negative Stock Corrections)
- AllowPartialShipment (Allow Partial Shipment): If the value is Y it allows a partial shipment on Booking process in case of do not have enough stock
- PaymentMonitor (Implements Payment Monitor management): Disables core's background process and button on invoice's header that manage the Payment Monitor
- EnableScreenReader (Enable Screen Reader): This preference improves the accessibility for visual impaired people enabling the screen reader.
- FilterByDocumentsProcessedSinceNDaysAgo (Filter by documents processed since N days ago): Filter by documents processed since N days ago
- ApplyPasswordPolicyInUserWindow (Apply Password Policy in User Window)
- LeaveDeliveryQtyAsZeroWhenCancelLayaway (Leave delivered quantity as 0 when canceling layaways)
- AddLastLevelChildrenInAddButton (Add Last Level Children in Add button)
- enableAutomaticPriceCorrectionTrxs (Enable automatic Price Difference Corrections)
- ShowAuditTrailUserFilter (Show Audit Trail User filter): If set to 'N', user list in audit trail filter won't be shown, else it will be shown
- EnableCanceAndReplace (Enable Cancel and Replace)
- ShowProductCharacteristicsParents (Show Product Characteristics Parents)
- AttachByDefault (Attach By Default): This preference allows to hide the standard attachments confirm dialog
- AGING_ShowReversedCheckbox (Enable reversed payment documents filter in Aging Reports)
- localTimeZoneID (Local Timezone ID): To check the list of all available timezone ids, see http://www.java2s.com/Tutorial/Java/0120__Development/GettingallthetimezonesIDs.htm
- DirectPrint (Direct Print): This property allows to show directly the standard printers dialog of the web browser
- CCU (Implements customer Credit Used calculation): Avoid the C_BP_SOCREDITUSED_REFRESH function calculation.
- DoNotSyncWarehouse (DoNotSyncWarehouse): If true then ,It will not synchronize warehouse field
- HierarchicalPriceList (Enable Hierarchical Price List): Enable hierarchical product price calcutation in price list
- ShowVoidCheckboxSalesInvoiceDimensionalReport (Enable void documents for Sales Invoice Dimensional Report)
- StockReservations (Enable Stock Reservations): Enables the Stock Reservations in the system
- GETPRODUCTTAXCATEGORY (Get Product Tax Category impementation)
- DoNotSyncDateOrdered (Do not syncronize date ordered based on header info)
- AllowMultiTab (Allow Multiple Tabs of a Window): Allow Open Multiple Tabs of the same window
- AllowDelete (Allow Delete Records)
- RMAllowOprhanLine (RM Allow Orphan Line)
- InvoiceProcessButton (Implements an alternative Invoice Process button): This only affects the process button on Purchase and Sales invoice windows. All other processes that complete invoices will still use the c_invoice_post procedure.
- BypassAccessLevelEntityCheck (Bypass Access Level Entity Check): When its value is Y, entity access level check will not be performed.
- PortalContactEmail (Portal Contact Email)
- PortalURL (Portal URL)
- CancelAndReplaceCreateNetShipment (Cancel and Replace - Create netting goods shipment)
- IsActiveNewChValueProd (Active new chValue in Product)
- PaymentPriority (Implements Payment Priority): Implements Payment Priority feature
- SecuredProcess (Secured Process): Generated UI processes called from buttons within tabs can be secured by setting this property to 'Y'. If this property is not set, they can be executed without giving explicit access by all roles with access to that window.
- isUpgrading (Upgrading from 2.50): The instance is in the process of upgrade from 2.50
- showMRPandProductionFields (Show MRP and Production Fileds): If the value is "Y", all related fields will be shown
- dataPageSize (Lines quantity to count per Window): With this property you will be able to change the quantity of lines to count per Window.
- APRM_MATCHSTATEMENT_HIDE_PARTIALMATCH_POPUP (Match Statement: hide partial match confirmation popup)
- APRM_AutoDistributeAmt (Add Payment: Automatically distribute amounts): If set as 'N' then auto distribution is not done
- APRM_ShowNoDistributeMsg (Show No Distribute Amount Message): If not 'N', shows a message when the APRM distribution is not done due to having too many records
- OBUIAPP_ProcessFileUploadMaxSize (Maximum Process file upload size (MB) ): Maximum file size allowed to upload in a Process in MB
- OBUIAPP_KeyboardShortcuts (Keyboard Shortcuts (OBUIAPP))
- OBUIAPP_MaxReportThreads (Max number of concurrent threads to create reports.)
- UINAVBA_MenuRecentList (Recent choices by the user in the application menu): The property stores the recent choices by the user in the application menu
- OBUIAPP_DisableLinkedItemsSection (Disable Linked Items Section): This property allows to disable the Linked Items section
- OBUIAPP_ShowSingleRecordFilterMsg (Show Single Record Filter Message): If true, shows a message when single record filter is applied
- OBUIAPP_ShowImportStoreStockButton (Show Import Store Stock Button): Show Import Store Stock Button
- OBUIAPP_DefaultDBPoolForReports (Default DB pool used by reports): Defines the database pool used to generate reports. Can be either "DEFAULT" for the default pool and "RO" for the read-only pool.
- UINAVBA_RecentListSize (Size of the recent list in quick launch and quick create)
- UINAVBA_RecentLaunchList (The recent choices of the user in the quick launch widget.): Keeps the recent choices by a user in the quick launch
- UINAVBA_KeyboardShortcuts (Keyboard Shortcuts (UINAVBA))
- OBUIAPP_GroupingEnabled (Grouping Enabled): Defines if grouping should be enabled for a window
- UINAVBA_RecentCreateList (The recent choices of the user in the quick create widget.): Keeps the recent choices of a user in the quick create
- OBUIAPP_RefreshAfterDeletion (Refresh After Deletion): This property allows the user to refresh the tab when a record is deleted.
- OBUIAPP_GroupingMaxRecords (Maximum Number of Records for Grouping): Maximum number of records for grouping to be enabled.
- OBUIAPP_ShowNewRecordFilterMsg (Show New Record Filter Message): If true, shows a message when newly created record filter is applied
- OBUIAPP_GridConfiguration (Grid Configuration): Contains the configuration of the grid for a particular window
- OBUIAPP_UseClassicMode (Use Classic UI Mode): If set to Y then the classic user interface mode is shown
- OBUIAPP_RecentViewList (Recent views shown in the workspace): Recent views shown in the workspace
- OBUIAPP_RecentDocumentsList (Recent Documents List Setting): Recent documents opened by the user
- OBUIAPP_ShowImplicitFilterMsg (Show Implicit Filter Message): If true, shows a message when implicit filter is applied
- OBUIAPP_WindowPersonalization_Override (Allow Window Personalization by User): Allow a user to change the window personalization, will only be considered if explicitly set to N or false
- OBSERDS_AllowUnsecuredDatasourceRequest (Allow Unsecured Datasource Request): This property allows to use unsecured DataSource request.
- OBSERDS_AllowWhereParameter (Allow Where Parameter): This preference allows to include the '_where' parameter in the datasource requests. If this preference is set to true the datasource will take into account the '_where' request parameter, if not it will be ignored.
- OBSERDS_CSVExportTranslateYesNoReference (Translate Yes/No Reference in Export To CSV): This preference allows the user to translate Yes/No references when uses export to CSV. If this preference is set to true the Yes/No references will translate when export to CSV.
- OBSERDS_CSVFooterMessage (CSV Footer Message): This property allows the user to set a message's search key or a plain text. Either the translated message or the plain text (if not message is found) will be included as the CSV footer.
- OBSERDS_CSVHeaderMessage (CSV Header Message): This property allows the user to set a message's search key or a plain text. Either the translated message or the plain text (if not message is found) will be included as the CSV header.
- OBSERDS_CSVFieldSeparator (CSV Field Separator): This property allows the user to set the character which will be used as field separator on generated CSV files. If it's not set, the comma will be used
- OBSERDS_CSVDecimalSeparator (CSV Decimal Separator): This property allows the user to set the decimal separator that will be used on the generated CSV files. If it is not set, the decimal separator defined in the Format.xml file will be used
- OBSERDS_CSVTextEncoding (CSV Text Encoding): This property allows the user to configure the Text Encoding of the generated CSV files. Valid values are for example 'iso-8859-1', or 'UTF-8'
- OBJSON_AllowUnpagedDatasourceManualRequest (Allow Unpaged Datasource In Manual Request)
Property List
- Physical column name: IsPropertyList
- Property Name: propertyList
- Reference: YesNo
- Default value: N
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: Text
Selected
- Physical column name: Selected
- Property Name: selected
- Reference: YesNo
- Default value: N
Callout: SL_Preference
This column has a callout associated. Checks there is only one selected preference for the current visibility. It is implemented by [1] Java Class.
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
User/Contact
- Physical column name: AD_User_ID
- Property Name: userContact
- Reference: TableDir
Foreign key column to AD_User table, (column: AD_User_ID)
It has a validation "System user if module", with the following code
@AD_Module_ID@ is null
or (@AD_Module_ID@ is not null and AD_User_ID = '0')
Visible at Client
- Physical column name: VisibleAt_Client_ID
- Property Name: visibleAtClient
- Reference: Table
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "System client if module", with the following code
@AD_Module_ID@ is null
or (@AD_Module_ID@ is not null and AD_Client_ID = '0')
Visible at Organization
- Physical column name: VisibleAt_Org_ID
- Property Name: visibleAtOrganization
- Reference: Table
Foreign key column to AD_Org table, (column: AD_Org_ID)
It has a validation "System org if module", with the following code
@AD_Module_ID@ is null
or (@AD_Module_ID@ is not null and AD_Org_ID = '0')
Visible at Role
- Physical column name: VisibleAt_Role_ID
- Property Name: visibleAtRole
- Reference: Table
Foreign key column to AD_Role table, (column: AD_Role_ID)
It has a validation "System role if module", with the following code
@AD_Module_ID@ is null
or (@AD_Module_ID@ is not null and AD_Role_ID='0')
Window
- Physical column name: AD_Window_ID
- Property Name: window
- Reference: TableDir
Foreign key column to AD_Window table, (column: AD_Window_ID)
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- AD_PREFERENCE_ATTR_IDX Not Unique. Columns:
- ATTRIBUTE
- AD_PREFERENCE_LIST_IDX Not Unique. Columns:
- PROPERTY
Check Constraints
These are the check constraints for this table:
- AD_PREFERENCE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- AD_PREFERENCE_LIST_CHECK: ISPROPERTYLIST = 'Y' AND PROPERTY IS NOT NULL AND ATTRIBUTE IS NULL OR ISPROPERTYLIST = 'N' AND ATTRIBUTE IS NOT NULL AND PROPERTY IS NULL
- AD_PREFERENCE_SELECTED_CHECK: SELECTED IN ('Y', 'N')
![]() | Back to org.openbravo.model.ad.domain |