House Keeping (Venster ID-53063)
Venster: House Keeping
Beschrijving: null
Help: null
TAB: House Keeping
Beschrijving: null
Help null
Bestand:House Keeping - House Keeping - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|---|---|---|---|
| Client | Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Search Key | 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). |
Value character varying(40) NOT NULL String |
| Name | 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. | Name character varying(60) NOT NULL String |
| Description | Beschrijving | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
| Comment/Help | Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
| Table | Tabel | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID numeric(10) NOT NULL Table Direct |
| Sql WHERE | 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". | WhereClause character varying(255) String |
| Save In Historic | Save In Historic | null | null | IsSaveInHistoric character(1) Yes-No |
| Export XML Backup | Export XML Backup | null | null | IsExportXMLBackup character(1) Yes-No |
| Backup Folder | Backup Folder | Backup Folder | null | BackupFolder character varying(255) FilePath |
| House Keeping | House Keeping | null | null | Processing character(1) Button |
| Last Run | Last Run | null | null | LastRun timestamp without time zone Date+Time |
| Last Deleted | Last Deleted | null | null | LastDeleted numeric(10) Integer |
| Active | Actief | 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 |
.png){kind=link}