Adempiere3.1.2/en/ManPageW AttributeSet olh
Window: Attribute Set
Description : Maintain Product Attribute Set
Help : Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking.
Tab: Attribute Set
Description : Maintain Product Attribute Set
Help : Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number and Guaragtee Date tracking. Note that the Guarantee Days here determine the Shelf Life of a product instance after manufacturing (the Guarantee Days on the product determines a Customer Service date after selling) If the Attribute Set is mandatory, a product instance needs to be selected/created before shipping.
Table Name : M_AttributeSet
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 |
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 |
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
CHAR(1) YesNo |
Lot | The product instances have a Lot Number | For individual products, you can define Lot Numbers | IsLot
CHAR(1) YesNo |
Mandatory Lot | The entry of Lot info is mandatory when creating a Product Instance | IsLotMandatory
CHAR(1) YesNo | |
Lot Control | Product Lot Control | Definition to create Lot numbers for Products | M_LotCtl_ID
NUMBER(10) TableDir |
Lot Char Start Overwrite | Lot/Batch Start Indicator overwrite - default « | If not defined, the default character « is used | LotCharSOverwrite
NCHAR String |
Lot Char End Overwrite | Lot/Batch End Indicator overwrite - default » | If not defined, the default character » is used | LotCharEOverwrite
NCHAR String |
Serial No | The product instances have Serial Numbers | For individual products, you can define Serial Numbers | IsSerNo
CHAR(1) YesNo |
Mandatory Serial No | The entry of a Serial No is mandatory when creating a Product Instance | IsSerNoMandatory
CHAR(1) YesNo | |
Serial No Control | Product Serial Number Control | Definition to create Serial numbers for Products | M_SerNoCtl_ID
NUMBER(10) TableDir |
SerNo Char Start Overwrite | Serial Number Start Indicator overwrite - default # | If not defined, the default character # is used | SerNoCharSOverwrite
NCHAR String |
SerNo Char End Overwrite | Serial Number End Indicator overwrite - default empty | If not defined, no character is used | SerNoCharEOverwrite
NCHAR String |
Guarantee Date | Product has Guarantee or Expiry Date | For individual products, you can define a guarantee or expiry date | IsGuaranteeDate
CHAR(1) YesNo |
Mandatory Guarantee Date | The entry of a Guarantee Date is mandatory when creating a Product Instance | IsGuaranteeDateMandatory
CHAR(1) YesNo | |
Guarantee Days | Number of days the product is guaranteed or available | If the value is 0, there is no limit to the availability or guarantee, otherwise the guarantee date is calculated by adding the days to the delivery date. | GuaranteeDays
NUMBER(10) Integer |
Mandatory Type | The specification of a Product Attribute Instance is mandatory | MandatoryType
CHAR(1) List |
Tab: Attribute Use
Description : Attributes Used for the Product Attribute Set
Help : Attributes and Attribute Values used for the product
Table Name : M_AttributeUse
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 |
Attribute Set | Product Attribute Set | Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. | M_AttributeSet_ID
NUMBER(10) TableDir |
Attribute | Product Attribute | Product Attribute like Color, Size | M_Attribute_ID
NUMBER(10) TableDir |
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 |
Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo
NUMBER(10) Integer |
Tab: Exclude
Description : Exclude the ability to enter Attribute Sets
Help : Create a record, if you want to exclude the ability to enter Product Attribute Set information. Note that the information is cached. To have effect you may have to re-login or reset cache.
Table Name : M_AttributeSetExclude
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 |
Attribute Set | Product Attribute Set | Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. | M_AttributeSet_ID
NUMBER(10) TableDir |
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 |
Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
Sales Transaction | This is a Sales Transaction | The Sales Transaction checkbox indicates if this item is a Sales Transaction. | IsSOTrx
CHAR(1) YesNo |