Aturan Validasi (tetingkap ID-103)
tetingkap: Aturan Validasi
Huraian: Maintain dynamic Validation Rules for columns and fields
Bantuan: The Validation Rules Window defines all dynamic rules used when entering and maintaining columns and fields. This window is for System Admin use only.
TAB: Validation
Huraian: Aturan Validasi
Bantuan The Validation Rules Tab defines all dynamic rules used when entering and maintaining columns and fields.
Fail:Aturan Validasi - Validation - tetingkap (iDempiere 1.0.0).png
Nama | Nama | Huraian | Bantuan | spesifikasi |
---|---|---|---|---|
Dynamic Validation | Pengesahan Dinamik | Dynamic Validation Rule | These rules define how an entry is determined to valid. You can use variables for dynamic (context sensitive) validation. | AD_Val_Rule_ID numeric(10) NOT NULL ID |
Client | Klien | Klien/Pengguna untuk terjemahan ini | Klien/Penghuni adalah syarikat atau pihak yang sah. Anda tidak boleh berkongsi maklumat antara Klien. Penghuni adalah sama erti dengan Klien. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organisasi | Organizational entity within client | Organisasi adalah unit pelanggan atau entiti sah - contonnya kedai, Jabatan. Data boleh dikongsi antara organisasi. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Name | Nama | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name character varying(60) NOT NULL String |
Description | Perihal | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Aktif | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
Entity Type | Jenis Entiti | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten.
For customizations, copy the entity and select "User"! |
EntityType character varying(40) NOT NULL Table |
Type | Jenis | Type of Validation (SQL, Java Script, Java Language) | The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language. | Type character(1) List |
Validation code | Kod Pengesahan | Validation Code | The Validation Code displays the date, time and message of the error. | Code character varying(2000) Text |
TAB: Used in Column
Huraian: Used in Column
Bantuan null
Fail:Aturan Validasi - Used in Column - tetingkap (iDempiere 1.0.0).png
Nama | Nama | Huraian | Bantuan | spesifikasi |
---|---|---|---|---|
Client | Klien | Klien/Pengguna untuk terjemahan ini | Klien/Penghuni adalah syarikat atau pihak yang sah. Anda tidak boleh berkongsi maklumat antara Klien. Penghuni adalah sama erti dengan Klien. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organisasi | Organizational entity within client | Organisasi adalah unit pelanggan atau entiti sah - contonnya kedai, Jabatan. Data boleh dikongsi antara organisasi. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Table | Jadual | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID numeric(10) NOT NULL Table Direct |
DB Column Name | Nama Lajur Pengkalan Data | Name of the column in the database | The Column Name indicates the name of a column on a table as defined in the database. | ColumnName character varying(30) NOT NULL String |
System Element | Elemen Sistem | System Element enables the central maintenance of column description and help. | The System Element allows for the central maintenance of help, descriptions and terminology for a database column. | AD_Element_ID numeric(10) Search |
Name | Nama | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name character varying(60) NOT NULL String |
Description | Perihal | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Comment/Help | Komen/Bantuan | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
Active | Aktif | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
Length | Panjangnya | Length of the column in the database | The Length indicates the length of a column as defined in the database. | FieldLength numeric(10) Integer |
Reference | Rujukan | System Reference and Validation | The Reference could be a display type, list or table validation. | AD_Reference_ID numeric(10) NOT NULL Table |
Reference Key | Kunci Rujukan | Required to specify, if data type is Table or List | The Reference Value indicates where the reference values are stored. It must be specified if the data type is Table or List. | AD_Reference_Value_ID numeric(10) Table |
Dynamic Validation | Pengesahan Dinamik | Dynamic Validation Rule | These rules define how an entry is determined to valid. You can use variables for dynamic (context sensitive) validation. | AD_Val_Rule_ID numeric(10) Table Direct |