View source for Template:House Keeping (Window ID-53063 V1.0.0)

= Window: House Keeping =

'''Description:''' 

'''Help:''' 

== Tab: House Keeping ==
'''Description:''' 

'''Help:''' 

[[Image:House_Keeping_-_House_Keeping_-_Window_(iDempiere_1.0.0).png|border]]

{| border="1" cellpadding="5" cellspacing="0" align="center"
|+'''Fields'''
!style="background:#efefef;" width="100"|Name
!style="background:#efefef;" width="150"|Description
!style="background:#efefef;" width="300"|Help
!style="background:#efefef;" width="100"|<small>Technical Data</small>
|-valign="top"
|Tenant
|Tenant for this installation.
|A Tenant is a company or a legal entity. You cannot share data between Tenants.
|<small>AD_HouseKeeping.AD_Client_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|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.
|<small>AD_HouseKeeping.AD_Org_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|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).
|<small>AD_HouseKeeping.Value<br>character varying(40)<br>String</small>
|-valign="top"
|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.
|<small>AD_HouseKeeping.Name<br>character varying(60)<br>String</small>
|-valign="top"
|Description
|Optional short description of the record
|A description is limited to 255 characters.
|<small>AD_HouseKeeping.Description<br>character varying(255)<br>String</small>
|-valign="top"
|Comment/Help
|Comment or Hint
|The Help field contains a hint, comment or help about the use of this item.
|<small>AD_HouseKeeping.Help<br>character varying(2000)<br>Text</small>
|-valign="top"
|Table
|Database Table information
|The Database Table provides the information of the table definition
|<small>AD_HouseKeeping.AD_Table_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|DB Table Name
|Name of the table in the database
|The DB Table Name indicates the name of the table in database.
|<small>AD_HouseKeeping.TableName<br>character varying(60)<br>String</small>
|-valign="top"
|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".
|<small>AD_HouseKeeping.WhereClause<br>character varying(255)<br>String</small>
|-valign="top"
|Save In Historic
|
|
|<small>AD_HouseKeeping.IsSaveInHistoric<br>character(1)<br>Yes-No</small>
|-valign="top"
|Export XML Backup
|
|
|<small>AD_HouseKeeping.IsExportXMLBackup<br>character(1)<br>Yes-No</small>
|-valign="top"
|Backup Folder
|Backup Folder
|
|<small>AD_HouseKeeping.BackupFolder<br>character varying(255)<br>FilePath</small>
|-valign="top"
|House Keeping
|
|
|<small>AD_HouseKeeping.Processing<br>character(1)<br>Button</small>
|-valign="top"
|Last Run
|
|
|<small>AD_HouseKeeping.LastRun<br>timestamp without time zone<br>Date+Time</small>
|-valign="top"
|Last Deleted
|
|
|<small>AD_HouseKeeping.LastDeleted<br>numeric(10)<br>Integer</small>
|-valign="top"
|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.
|<small>AD_HouseKeeping.IsActive<br>character(1)<br>Yes-No</small>
|}