属性 (窗口 ID-260)
窗口: 属性
描述: 产品属性
幫助: Product Attribute like Color, Size, etc.
TAB: 属性
描述: 产品属性
幫助 Product Attribute like Color, Size, etc.
File:属性 - 属性 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 |
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 | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | 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 |
Attribute Value Type | Attribute Value Type | Type of Attribute Value | The Attribute Value type deternines the data/validation type | AttributeValueType character(1) NOT NULL List |
Mandatory | 强制性的 | Data entry is required in this column | The Mandatory checkbox indicates if the field is required for a record to be save to the database. | IsMandatory character(1) NOT NULL Yes-No |
Attribute Search | 属性搜寻 | 通常的搜寻属性 | Attributes are specific to a Product Attribute Set (e.g. Size for T-Shirts: S,M,L). If you have multiple attributes and want to search under a common sttribute, you define a search sttribute. Example: have one Size search attribute combining the values of all different sizes (Size for Dress Shirt XL,L,M,S,XS). The Attribute Search allows you to have all values available for selection. This eases the maintenance of the individual product attribute. | M_AttributeSearch_ID numeric(10) Table Direct |
Instance Attribute | 实例属性 | The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date) | If selected, the individual instance of the product has this attribute - like the individual Serial or Lot Numbers or Guarantee Date of a product instance. If not selected, all instances of the product share the attribute (e.g. color=green). | IsInstanceAttribute character(1) NOT NULL Yes-No |
TAB: 属性值
描述: 产品属性值
幫助 Individual value of a product attribute (e.g. green, large, ..)
File:属性 - 属性值 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Attribute Value | 属性值 | 产品属性值 | Individual value of a product attribute (e.g. green, large, ..) | M_AttributeValue_ID numeric(10) NOT NULL ID |
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 |
Attribute | 属性 | 产品属性 | Product Attribute like Color, Size | M_Attribute_ID numeric(10) NOT NULL Table Direct |
Search Key | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | 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 | 名称 | 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 | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | 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 |