Adempiere3.1.2/en/ManPageW RequestStatus olh
Window: Request Status
Description : Maintain Request Status
Help : Status if the request (open, closed, investigating, ..)
Tab: Status Category
Description : Request Status Category
Help : Category of Request Status enables to maintain different set of Status for different Request Categories
Table Name : R_StatusCategory
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| 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
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
| 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. |
IsActive
CHAR(1) YesNo |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault
CHAR(1) YesNo |
Tab: Request Status
Description : Maintain Request Status
Help : Status if the request (open, closed, investigating, ..)
Table Name : R_Status
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| Status Category | Request Status Category | Category of Request Status enables to maintain different set of Status for different Request Categories | R_StatusCategory_ID
NUMBER(10) TableDir |
| Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo
NUMBER(10) Integer |
| 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
NVARCHAR2(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. | Name
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
| 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. |
IsActive
CHAR(1) YesNo |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault
CHAR(1) YesNo |
| Web Can Update | Entry can be updated from the Web | IsWebCanUpdate
CHAR(1) YesNo | |
| Update Status | Automatically change the status after entry from web | Change the status automatically after the entry was changed via the Web | Update_Status_ID
NUMBER(10) Table |
| Timeout in Days | Timeout in Days to change Status automatically | After the number of days of inactivity, the status is changed automatically to the Next Status. If no Next Status is defined, the status is not changed. | TimeoutDays
NUMBER(10) Integer |
| Next Status | Move to next status automatically after timeout | After the timeout, change the status automatically | Next_Status_ID
NUMBER(10) Table |
| Open Status | The status is closed | This allows to have the three generat situations of "not open" - "open" - "closed" | IsOpen
CHAR(1) YesNo |
| Closed Status | The status is closed | This allows to mave multiple closed status | IsClosed
CHAR(1) YesNo |
| Final Close | Entries with Final Close cannot be re-opened | IsFinalClose
CHAR(1) YesNo |
