Table idempiere11.adempiere.ad_package_imp_inst
Package Imp. Inst.

 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
ad_package_imp_inst_id numeric 10 Package Imp. Inst.
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
name varchar 240  √  null Alphanumeric identifier of the entity
pk_status varchar 44  √  null Package Status
releaseno varchar 40  √  null Internal Release Number
pk_version varchar 40  √  null Package Version
version varchar 40  √  null Version of the table definition
description varchar 2000  √  null Optional short description of the record
email varchar 120  √  null Electronic Mail Address
processed bpchar 1  √  'N'::bpchar The document has been processed
processing bpchar 1  √  'N'::bpchar Process Now
creator varchar 120  √  null Creator
creatorcontact varchar 510  √  null Creator Contact
createddate varchar 50  √  null Created Date
updateddate varchar 50  √  null Updated Date
uninstall bpchar 1  √  null Uninstall
ad_package_imp_inst_uu varchar 36  √  NULL::character varying AD_Package_Imp_Inst_UU

Table contained 0 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_package_imp_inst_id Primary key Asc ad_package_imp_inst_pkey
ad_package_imp_inst_uu Must be unique Asc ad_package_imp_inst_uu_idx