Window: Dynamic Validation per Table
[Created: 25/01/2024 - Updated: 25/01/2024 ]
Description:
Help:
Tab: Dynamic Validation per Table
[Created: 25/01/2024 - Updated: 25/01/2024 ]
Description:
Help:
Tab Level: 0
Table 10: Dynamic Validation per Table - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_tablevalrule.AD_Client_ID numeric(10) Search |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_tablevalrule.AD_Org_ID numeric(10) Table Direct |
| Table | Database Table information | The Database Table provides the information of the table definition | ad_tablevalrule.AD_Table_ID numeric(10) Table Direct |
| Active | 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. | ad_tablevalrule.IsActive character(1) Yes-No |
| Role | Responsibility Role | The Role determines security and access a user who has this Role will have in the System. | ad_tablevalrule.AD_Role_ID numeric(10) Table Direct |
| User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | ad_tablevalrule.AD_User_ID numeric(10) Search |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_tablevalrule.Description character varying(255) String |
| SQL Filter | SQL Filter | Enter a valid WHERE SQL fully qualified clause. The WHERE is not needed, the code will be surrounded within parenthesis before applied | ad_tablevalrule.Code character varying(4000) String |