House Keeping (Window ID-53063)
From iDempiere en
Window: House Keeping
Description:
Help:
Tab: House Keeping
Description:
Help:
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_HouseKeeping.AD_Client_ID numeric(10) Table Direct |
| 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_HouseKeeping.AD_Org_ID numeric(10) Table Direct |
| Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
AD_HouseKeeping.Value character varying(40) String |
| Name | 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. | AD_HouseKeeping.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | AD_HouseKeeping.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | AD_HouseKeeping.Help character varying(2000) Text |
| Table | Database Table information | The Database Table provides the information of the table definition | AD_HouseKeeping.AD_Table_ID numeric(10) Table Direct |
| DB Table Name | Name of the table in the database | The DB Table Name indicates the name of the table in database. | AD_HouseKeeping.TableName character varying(40) String |
| Sql WHERE | Fully qualified SQL WHERE clause | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". | AD_HouseKeeping.WhereClause character varying(255) String |
| Save In Historic | AD_HouseKeeping.IsSaveInHistoric character(1) Yes-No | ||
| Export XML Backup | AD_HouseKeeping.IsExportXMLBackup character(1) Yes-No | ||
| Backup Folder | Backup Folder | AD_HouseKeeping.BackupFolder character varying(255) FilePath | |
| House Keeping | AD_HouseKeeping.Processing character(1) Button | ||
| Last Run | AD_HouseKeeping.LastRun timestamp without time zone Date+Time | ||
| Last Deleted | AD_HouseKeeping.LastDeleted numeric(10) Integer | ||
| 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_HouseKeeping.IsActive character(1) Yes-No |
