Skip to main content

Window: Drill Rule

[Created: 08/07/2022 - Updated: 08/07/2022 ]
Description:
Help:

Tab: Drill Rule

[Created: 08/07/2022 - Updated: 08/07/2022 ]
Description:
Help:
Tab Level: 0

Table 10: Drill Rule - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_process_drillrule.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_process_drillrule.AD_Org_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe 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.ad_process_drillrule.Name character varying(255)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_process_drillrule.Description character varying(255)
String
ProcessProcess or ReportThe Process field identifies a unique Process or Report in the system.ad_process_drillrule.AD_Process_ID numeric(10)
Table Direct
Show Helpad_process_drillrule.ShowHelp character(1)
List
TableDatabase Table informationThe Database Table provides the information of the table definitionad_process_drillrule.AD_Table_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere 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_process_drillrule.IsActive character(1)
Yes-No
Report ViewView used to generate this reportThe Report View indicates the view used to generate this report.ad_process_drillrule.AD_ReportView_ID numeric(10)
Table Direct
ValidElement is validThe element passed the validation checkad_process_drillrule.IsValid character(1)
Yes-No
Print FormatData Print FormatThe print format determines how data is rendered for print.ad_process_drillrule.AD_PrintFormat_ID numeric(10)
Table Direct
Process Parameterad_process_drillrule.AD_Process_Para_ID numeric(10)
Table Direct

Tab: Drill Rule Parameter

[Created: 08/07/2022 - Updated: 15/03/2023 ]
Description:
Help:
Tab Level: 1

Table 20: Drill Rule Parameter - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_process_drillrule_para.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_process_drillrule_para.AD_Org_ID numeric(10)
Table Direct
Process Parameterad_process_drillrule_para.AD_Process_Para_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere 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_process_drillrule_para.IsActive character(1)
Yes-No
Default ParameterDefault value of the parameterThe default value can be a variable like @#Date@ad_process_drillrule_para.ParameterDefault character varying(255)
String
Default To ParameterDefault value of the to parameterThe default value can be a variable like @#Date@ad_process_drillrule_para.ParameterToDefault character varying(255)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_process_drillrule_para.Description character varying(255)
String

Tab: Drill Rule Translation

[Created: 08/07/2022 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1

Table 30: Drill Rule Translation - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_process_drillrule_trl.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_process_drillrule_trl.AD_Org_ID numeric(10)
Table Direct
Drill Rulead_process_drillrule_trl.AD_Process_DrillRule_ID numeric(10)
Search
NameAlphanumeric identifier of the entityThe 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.ad_process_drillrule_trl.Name character varying(255)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_process_drillrule_trl.Description character varying(255)
String
LanguageLanguage for this entityThe Language identifies the language to use for display and formattingad_process_drillrule_trl.AD_Language character varying(6)
Table
TranslatedThis column is translatedThe Translated checkbox indicates if this column is translated.ad_process_drillrule_trl.IsTranslated character(1)
Yes-No
ActiveThe record is active in the systemThere 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_process_drillrule_trl.IsActive character(1)
Yes-No