Table idempiere9.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 Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
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 CreatorContact
createddate varchar 50  √  null CreatedDate
updateddate varchar 50  √  null UpdatedDate
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 2021-12-25 14:57 +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