Table idempiere9.adempiere.m_attributeset
Product Attribute Set

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
m_attributeset_id numeric 10
m_attributesetexclude.m_attributeset_id mattributeset_masexclude R
m_attributesetinstance.m_attributeset_id mattributeset_mattribsetinst R
m_attributeuse.m_attributeset_id mattributeset_mattributeuse R
m_product.m_attributeset_id mattributeset_mproduct C
qm_specification.m_attributeset_id mattributeset_qmspecification R
Product Attribute Set
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
isserno bpchar 1 'Y'::bpchar The product instances have Serial Numbers
m_sernoctl_id numeric 10  √  null
m_sernoctl.m_sernoctl_id msernoctl_attributeset R
Product Serial Number Control
islot bpchar 1 'Y'::bpchar The product instances have a Lot Number
m_lotctl_id numeric 10  √  null
m_lotctl.m_lotctl_id mlotctl_mattributeset R
Product Lot Control
isguaranteedate bpchar 1 'N'::bpchar Product has Guarantee or Expiry Date
guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
isinstanceattribute bpchar 1 'N'::bpchar The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date)
mandatorytype bpchar 1 'N'::bpchar The specification of a Product Attribute Instance is mandatory
isguaranteedatemandatory bpchar 1 'N'::bpchar The entry of a Guarantee Date is mandatory when creating a Product Instance
islotmandatory bpchar 1 'N'::bpchar The entry of Lot info is mandatory when creating a Product Instance
issernomandatory bpchar 1 'N'::bpchar The entry of a Serial No is mandatory when creating a Product Instance
sernocharsoverwrite bpchar 1  √  null Serial Number Start Indicator overwrite - default #
lotcharsoverwrite bpchar 1  √  null Lot/Batch Start Indicator overwrite - default «
lotchareoverwrite bpchar 1  √  null Lot/Batch End Indicator overwrite - default »
sernochareoverwrite bpchar 1  √  null Serial Number End Indicator overwrite - default empty
m_attributeset_uu varchar 36  √  NULL::character varying M_AttributeSet_UU
useguaranteedateformpolicy bpchar 1  √  'N'::bpchar Use Guarantee Date for Material Policy
isautogeneratelot bpchar 1  √  'N'::bpchar IsAutoGenerateLot
m_attributeset_type varchar 3  √  'MMS'::character varying AttributeSet Type

Table contained 4 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
m_attributeset_id Primary key Asc m_attributeset_pkey
m_attributeset_uu Must be unique Asc m_attributeset_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.