SchemaSpy Analysis of idempiere11.adempiere - Columns2Pack | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:57 +0100 |
| |||||
|
idempiere11.adempiere contains 215 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
ad_package_exp | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_exp | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_exp | ad_package_exp_id | numeric | 10 | Package Exp. | |||
ad_package_exp | ad_package_exp_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Exp_UU | |
ad_package_exp | ad_package_type | varchar | 1 | √ | null | Package Type | |
ad_package_exp | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_exp | createdby | numeric | 10 | User who created this records | |||
ad_package_exp | datefrom | timestamp | 29,6 | √ | null | Starting date for a range | |
ad_package_exp | description | varchar | 1000 | √ | null | Optional short description of the record | |
ad_package_exp | varchar | 30 | √ | null | Electronic Mail Address | ||
ad_package_exp | file_directory | varchar | 255 | √ | null | File_Directory | |
ad_package_exp | instructions | varchar | 1000 | √ | null | Instructions | |
ad_package_exp | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_exp | isexportdictionaryentity | bpchar | 1 | 'N'::bpchar | Export Dictionary Entity | ||
ad_package_exp | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_package_exp | pk_version | varchar | 20 | Package Version | |||
ad_package_exp | processed | bpchar | 1 | √ | null | The document has been processed | |
ad_package_exp | processing | bpchar | 1 | Process Now | |||
ad_package_exp | releaseno | varchar | 20 | √ | null | Internal Release Number | |
ad_package_exp | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_exp | updatedby | numeric | 10 | User who updated this records | |||
ad_package_exp | username | varchar | 30 | √ | null | User Name | |
ad_package_exp | version | varchar | 20 | √ | null | Version of the table definition | |
ad_package_exp_common | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_exp_common | ad_form_id | numeric | 10 | √ | null | Special Form | |
ad_package_exp_common | ad_impformat_id | numeric | 10 | √ | null | Import Format | |
ad_package_exp_common | ad_menu_id | numeric | 10 | √ | null | Identifies a Menu | |
ad_package_exp_common | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_exp_common | ad_package_exp_common_id | numeric | 10 | Common Package Exp. | |||
ad_package_exp_common | ad_package_exp_common_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Exp_Common_UU | |
ad_package_exp_common | ad_process_id | numeric | 10 | √ | null | Process or Report | |
ad_package_exp_common | ad_reportview_id | numeric | 10 | √ | null | View used to generate this report | |
ad_package_exp_common | ad_role_id | numeric | 10 | √ | null | Responsibility Role | |
ad_package_exp_common | ad_table_id | numeric | 10 | √ | null | Database Table information | |
ad_package_exp_common | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
ad_package_exp_common | ad_workbench_id | numeric | 10 | √ | null | Collection of windows, reports | |
ad_package_exp_common | ad_workflow_id | numeric | 10 | √ | null | Workflow or combination of tasks | |
ad_package_exp_common | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_exp_common | createdby | numeric | 10 | User who created this records | |||
ad_package_exp_common | dbtype | varchar | 22 | √ | null | DB Type | |
ad_package_exp_common | description | varchar | 1000 | √ | null | Optional short description of the record | |
ad_package_exp_common | destination_directory | varchar | 255 | √ | null | Destination_Directory | |
ad_package_exp_common | file_directory | varchar | 255 | √ | null | File_Directory | |
ad_package_exp_common | filename | varchar | 255 | √ | null | Name of the local file or URL | |
ad_package_exp_common | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_exp_common | line | numeric | 0 | √ | null | Unique line for this document | |
ad_package_exp_common | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
ad_package_exp_common | name2 | varchar | 60 | √ | null | Additional Name | |
ad_package_exp_common | processed | bpchar | 1 | √ | null | The document has been processed | |
ad_package_exp_common | processing | bpchar | 1 | √ | null | Process Now | |
ad_package_exp_common | sqlstatement | varchar | 255 | √ | null | SQL Expression/Statement | |
ad_package_exp_common | target_directory | varchar | 255 | √ | null | Target_Directory | |
ad_package_exp_common | type | varchar | 10 | √ | null | Type of Validation (SQL, Java Script, Java Language) | |
ad_package_exp_common | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_exp_common | updatedby | numeric | 10 | User who updated this records | |||
ad_package_exp_detail | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_exp_detail | ad_entitytype_id | numeric | 10 | √ | NULL::numeric | System Entity Type | |
ad_package_exp_detail | ad_form_id | numeric | 10 | √ | null | Special Form | |
ad_package_exp_detail | ad_impformat_id | numeric | 10 | √ | null | Import Format | |
ad_package_exp_detail | ad_infowindow_id | numeric | 10 | √ | NULL::numeric | Info and search/select Window | |
ad_package_exp_detail | ad_menu_id | numeric | 10 | √ | null | Identifies a Menu | |
ad_package_exp_detail | ad_message_id | numeric | 10 | √ | null | System Message | |
ad_package_exp_detail | ad_modelvalidator_id | numeric | 10 | √ | NULL::numeric | Model Validator | |
ad_package_exp_detail | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_exp_detail | ad_package_code_new | varchar | 2000 | √ | null | New Package Code | |
ad_package_exp_detail | ad_package_code_old | varchar | 2000 | √ | null | Old Package Code | |
ad_package_exp_detail | ad_package_exp_detail_id | numeric | 10 | Package Exp. Detail | |||
ad_package_exp_detail | ad_package_exp_detail_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Exp_Detail_UU | |
ad_package_exp_detail | ad_package_exp_id | numeric | 10 | Package Exp. | |||
ad_package_exp_detail | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
ad_package_exp_detail | ad_process_id | numeric | 10 | √ | null | Process or Report | |
ad_package_exp_detail | ad_reference_id | numeric | 10 | √ | null | System Reference and Validation | |
ad_package_exp_detail | ad_reportview_id | numeric | 10 | √ | null | View used to generate this report | |
ad_package_exp_detail | ad_role_id | numeric | 10 | √ | null | Responsibility Role | |
ad_package_exp_detail | ad_table_id | numeric | 10 | √ | null | Database Table information | |
ad_package_exp_detail | ad_val_rule_id | numeric | 10 | √ | null | Dynamic Validation Rule | |
ad_package_exp_detail | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
ad_package_exp_detail | ad_workbench_id | numeric | 10 | √ | null | Collection of windows, reports | |
ad_package_exp_detail | ad_workflow_id | numeric | 10 | √ | null | Workflow or combination of tasks | |
ad_package_exp_detail | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_exp_detail | createdby | numeric | 0 | User who created this records | |||
ad_package_exp_detail | dbtype | varchar | 22 | √ | null | DB Type | |
ad_package_exp_detail | description | varchar | 1000 | √ | null | Optional short description of the record | |
ad_package_exp_detail | destination_directory | varchar | 255 | √ | null | Destination_Directory | |
ad_package_exp_detail | destination_filename | varchar | 255 | √ | null | Destination_FileName | |
ad_package_exp_detail | execcode | text | 2147483647 | √ | null | Execution Code | |
ad_package_exp_detail | file_directory | varchar | 255 | √ | null | File_Directory | |
ad_package_exp_detail | filename | varchar | 255 | √ | null | Name of the local file or URL | |
ad_package_exp_detail | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_exp_detail | line | numeric | 0 | √ | null | Unique line for this document | |
ad_package_exp_detail | name2 | varchar | 60 | √ | null | Additional Name | |
ad_package_exp_detail | processed | bpchar | 1 | √ | null | The document has been processed | |
ad_package_exp_detail | processing | bpchar | 1 | Process Now | |||
ad_package_exp_detail | releaseno | varchar | 20 | √ | null | Internal Release Number | |
ad_package_exp_detail | sqlstatement | varchar | 4000 | √ | null | SQL Expression/Statement | |
ad_package_exp_detail | target_directory | varchar | 255 | √ | null | Target_Directory | |
ad_package_exp_detail | type | varchar | 10 | Type of Validation (SQL, Java Script, Java Language) | |||
ad_package_exp_detail | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_exp_detail | updatedby | numeric | 0 | User who updated this records | |||
ad_package_imp | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_imp | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_imp | ad_package_imp_id | numeric | 10 | Package Imp. | |||
ad_package_imp | ad_package_imp_proc_id | numeric | 10 | √ | NULL::numeric | Package Imp. Proc. | |
ad_package_imp | ad_package_imp_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Imp_UU | |
ad_package_imp | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_imp | createdby | numeric | 10 | User who created this records | |||
ad_package_imp | createddate | varchar | 25 | √ | null | Created Date | |
ad_package_imp | creator | varchar | 60 | √ | null | Creator | |
ad_package_imp | creatorcontact | varchar | 255 | √ | null | Creator Contact | |
ad_package_imp | description | varchar | 1000 | √ | null | Optional short description of the record | |
ad_package_imp | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_package_imp | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_imp | name | varchar | 500 | Alphanumeric identifier of the entity | |||
ad_package_imp | pk_status | varchar | 22 | √ | null | Package Status | |
ad_package_imp | pk_version | varchar | 20 | √ | null | Package Version | |
ad_package_imp | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
ad_package_imp | processing | bpchar | 1 | 'N'::bpchar | Process Now | ||
ad_package_imp | releaseno | varchar | 20 | √ | null | Internal Release Number | |
ad_package_imp | uninstall | bpchar | 1 | √ | null | Uninstall | |
ad_package_imp | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_imp | updatedby | numeric | 10 | User who updated this records | |||
ad_package_imp | updateddate | varchar | 25 | √ | null | Updated Date | |
ad_package_imp | version | varchar | 20 | √ | null | Version of the table definition | |
ad_package_imp_backup | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_imp_backup | ad_column_id | numeric | 10 | √ | null | Column in the table | |
ad_package_imp_backup | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_imp_backup | ad_package_imp_backup_id | numeric | 10 | Imp. Package Backup | |||
ad_package_imp_backup | ad_package_imp_backup_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Imp_Backup_UU | |
ad_package_imp_backup | ad_package_imp_bck_dir | varchar | 255 | √ | null | Package Imp. Bck. Directory | |
ad_package_imp_backup | ad_package_imp_detail_id | numeric | 10 | Imp. Package Detail | |||
ad_package_imp_backup | ad_package_imp_id | numeric | 10 | Package Imp. | |||
ad_package_imp_backup | ad_package_imp_org_dir | varchar | 255 | √ | null | Package Imp. Org. Dir. | |
ad_package_imp_backup | ad_reference_id | numeric | 10 | √ | null | System Reference and Validation | |
ad_package_imp_backup | ad_table_id | numeric | 10 | √ | null | Database Table information | |
ad_package_imp_backup | colvalue | varchar | 2000 | √ | null | Col Value | |
ad_package_imp_backup | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_imp_backup | createdby | numeric | 10 | User who created this records | |||
ad_package_imp_backup | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_imp_backup | uninstall | bpchar | 1 | √ | null | Uninstall | |
ad_package_imp_backup | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_imp_backup | updatedby | numeric | 10 | User who updated this records | |||
ad_package_imp_detail | action | varchar | 20 | √ | null | Indicates the Action to be performed | |
ad_package_imp_detail | ad_backup_id | numeric | 10 | √ | null | Backup | |
ad_package_imp_detail | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_imp_detail | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_imp_detail | ad_package_imp_detail_id | numeric | 10 | Imp. Package Detail | |||
ad_package_imp_detail | ad_package_imp_detail_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Imp_Detail_UU | |
ad_package_imp_detail | ad_package_imp_id | numeric | 10 | Package Imp. | |||
ad_package_imp_detail | ad_table_id | numeric | 10 | √ | null | Database Table information | |
ad_package_imp_detail | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_imp_detail | createdby | numeric | 10 | User who created this records | |||
ad_package_imp_detail | execcode | text | 2147483647 | √ | null | Execution Code | |
ad_package_imp_detail | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_imp_detail | name | varchar | 2000 | √ | null | Alphanumeric identifier of the entity | |
ad_package_imp_detail | record_id | numeric | 10 | Direct internal record ID | |||
ad_package_imp_detail | record_uu | varchar | 36 | √ | NULL::character varying | Record UUID | |
ad_package_imp_detail | result | text | 2147483647 | √ | null | Result of the action taken | |
ad_package_imp_detail | success | varchar | 20 | √ | null | Success | |
ad_package_imp_detail | tablename | varchar | 60 | √ | null | Name of the table in the database | |
ad_package_imp_detail | type | varchar | 60 | √ | null | Type of Validation (SQL, Java Script, Java Language) | |
ad_package_imp_detail | uninstall | bpchar | 1 | √ | null | Uninstall | |
ad_package_imp_detail | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_imp_detail | updatedby | numeric | 10 | User who updated this records | |||
ad_package_imp_inst | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
ad_package_imp_inst | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
ad_package_imp_inst | ad_package_imp_inst_id | numeric | 10 | Package Imp. Inst. | |||
ad_package_imp_inst | ad_package_imp_inst_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Imp_Inst_UU | |
ad_package_imp_inst | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_package_imp_inst | createdby | numeric | 10 | √ | null | User who created this records | |
ad_package_imp_inst | createddate | varchar | 50 | √ | null | Created Date | |
ad_package_imp_inst | creator | varchar | 120 | √ | null | Creator | |
ad_package_imp_inst | creatorcontact | varchar | 510 | √ | null | Creator Contact | |
ad_package_imp_inst | description | varchar | 2000 | √ | null | Optional short description of the record | |
ad_package_imp_inst | varchar | 120 | √ | null | Electronic Mail Address | ||
ad_package_imp_inst | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
ad_package_imp_inst | name | varchar | 240 | √ | null | Alphanumeric identifier of the entity | |
ad_package_imp_inst | pk_status | varchar | 44 | √ | null | Package Status | |
ad_package_imp_inst | pk_version | varchar | 40 | √ | null | Package Version | |
ad_package_imp_inst | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
ad_package_imp_inst | processing | bpchar | 1 | √ | 'N'::bpchar | Process Now | |
ad_package_imp_inst | releaseno | varchar | 40 | √ | null | Internal Release Number | |
ad_package_imp_inst | uninstall | bpchar | 1 | √ | null | Uninstall | |
ad_package_imp_inst | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
ad_package_imp_inst | updatedby | numeric | 10 | √ | null | User who updated this records | |
ad_package_imp_inst | updateddate | varchar | 50 | √ | null | Updated Date | |
ad_package_imp_inst | version | varchar | 40 | √ | null | Version of the table definition | |
ad_package_imp_proc | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_imp_proc | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_imp_proc | ad_override_dict | bpchar | 1 | √ | null | Update System Maintained Application Dictionary | |
ad_package_imp_proc | ad_package_dir | varchar | 255 | √ | null | Package directory, default to AdempiereHome/packages | |
ad_package_imp_proc | ad_package_imp_proc_id | numeric | 10 | Package Imp. Proc. | |||
ad_package_imp_proc | ad_package_imp_proc_uu | varchar | 36 | √ | NULL::character varying | AD_Package_Imp_Proc_UU | |
ad_package_imp_proc | ad_package_source | varchar | 255 | √ | null | Fully qualified package source file name | |
ad_package_imp_proc | ad_package_source_type | varchar | 10 | Type of package source - file, ftp, webservice etc | |||
ad_package_imp_proc | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_package_imp_proc | createdby | numeric | 10 | User who created this records | |||
ad_package_imp_proc | dateprocessed | timestamp | 29,6 | √ | null | Date Processed | |
ad_package_imp_proc | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_imp_proc | name | varchar | 500 | Alphanumeric identifier of the entity | |||
ad_package_imp_proc | p_msg | varchar | 2000 | √ | NULL::character varying | Process Message | |
ad_package_imp_proc | processing | bpchar | 1 | √ | null | Process Now | |
ad_package_imp_proc | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_package_imp_proc | updatedby | numeric | 10 | User who updated this records | |||
ad_package_uuid_map | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_package_uuid_map | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_package_uuid_map | ad_package_uuid_map_id | numeric | 10 | UUID Mapping between tenant | |||
ad_package_uuid_map | ad_package_uuid_map_uu | varchar | 36 | AD_Package_UUID_Map_UU | |||
ad_package_uuid_map | ad_table_id | numeric | 10 | Database Table information | |||
ad_package_uuid_map | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_package_uuid_map | createdby | numeric | 10 | User who created this records | |||
ad_package_uuid_map | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_package_uuid_map | source_uuid | varchar | 36 | UUID from the source tenant | |||
ad_package_uuid_map | target_uuid | varchar | 36 | New UUID created by the pack in tenant | |||
ad_package_uuid_map | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
ad_package_uuid_map | updatedby | numeric | 10 | User who updated this records |