SchemaSpy Analysis of idempiere11.adempiere - ColumnsData Replication Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:48 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 240 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_table accesslevel bpchar 1 Access Level required
ad_replication ad_client_id numeric 10 Tenant for this installation.
ad_replication_log ad_client_id numeric 10 Tenant for this installation.
ad_replication_run ad_client_id numeric 10 Tenant for this installation.
ad_replicationdocument ad_client_id numeric 10 Tenant for this installation.
ad_replicationstrategy ad_client_id numeric 10 Tenant for this installation.
ad_replicationtable ad_client_id numeric 10 Tenant for this installation.
ad_sequence ad_client_id numeric 10 Tenant for this installation.
ad_system ad_client_id numeric 10 Tenant for this installation.
ad_table ad_client_id numeric 10 Tenant for this installation.
c_doctype ad_client_id numeric 10 Tenant for this installation.
ad_replication ad_org_id numeric 10 Organizational entity within tenant
ad_replication_log ad_org_id numeric 10 Organizational entity within tenant
ad_replication_run ad_org_id numeric 10 Organizational entity within tenant
ad_replicationdocument ad_org_id numeric 10 Organizational entity within tenant
ad_replicationstrategy ad_org_id numeric 10 Organizational entity within tenant
ad_replicationtable ad_org_id numeric 10 Organizational entity within tenant
ad_sequence ad_org_id numeric 10 Organizational entity within tenant
ad_system ad_org_id numeric 10 Organizational entity within tenant
ad_table ad_org_id numeric 10 Organizational entity within tenant
c_doctype ad_org_id numeric 10 Organizational entity within tenant
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
ad_replication ad_replication_id numeric 10 Data Replication Target
ad_replication_run ad_replication_id numeric 10 Data Replication Target
ad_replication_log ad_replication_log_id numeric 10 Data Replication Log Details
ad_replication_log ad_replication_log_uu varchar 36  √  NULL::character varying AD_Replication_Log_UU
ad_replication_log ad_replication_run_id numeric 10 Data Replication Run
ad_replication_run ad_replication_run_id numeric 10 Data Replication Run
ad_replication_run ad_replication_run_uu varchar 36  √  NULL::character varying AD_Replication_Run_UU
ad_replication ad_replication_uu varchar 36  √  NULL::character varying AD_Replication_UU
ad_replicationdocument ad_replicationdocument_id numeric 10 Replication Document
ad_replicationdocument ad_replicationdocument_uu varchar 36  √  NULL::character varying AD_ReplicationDocument_UU
ad_replication ad_replicationstrategy_id numeric 10 Data Replication Strategy
ad_replicationdocument ad_replicationstrategy_id numeric 10 Data Replication Strategy
ad_replicationstrategy ad_replicationstrategy_id numeric 10 Data Replication Strategy
ad_replicationtable ad_replicationstrategy_id numeric 10 Data Replication Strategy
ad_replicationstrategy ad_replicationstrategy_uu varchar 36  √  NULL::character varying AD_ReplicationStrategy_UU
ad_replication_log ad_replicationtable_id numeric 10  √  null Data Replication Strategy Table Info
ad_replicationtable ad_replicationtable_id numeric 10 Data Replication Strategy Table Info
ad_replicationtable ad_replicationtable_uu varchar 36  √  NULL::character varying AD_ReplicationTable_UU
ad_sequence ad_sequence_id numeric 10 Document Sequence
ad_sequence ad_sequence_uu varchar 36  √  NULL::character varying AD_Sequence_UU
ad_system ad_system_id numeric 10 System Definition
ad_system ad_system_uu varchar 36  √  NULL::character varying AD_System_UU
ad_replicationdocument ad_table_id numeric 10 Database Table information
ad_replicationtable ad_table_id numeric 10 Database Table information
ad_table ad_table_id numeric 10 Database Table information
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_replicationdocument c_doctype_id numeric 10 Document type or rules
c_doctype c_doctype_id numeric 10 Document type or rules
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
c_doctype c_doctypedifference_id numeric 10  √  null Document type for generating in dispute Shipments
c_doctype c_doctypeinvoice_id numeric 10  √  null Document type used for invoices generated from this sales document
c_doctype c_doctypeproforma_id numeric 10  √  null Document type used for pro forma invoices generated from this sales document
c_doctype c_doctypeshipment_id numeric 10  √  null Document type used for shipments generated from this sales document
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
ad_replication created timestamp 29,6 now() Date this record was created
ad_replication_log created timestamp 29,6 now() Date this record was created
ad_replication_run created timestamp 29,6 now() Date this record was created
ad_replicationdocument created timestamp 29,6 statement_timestamp() Date this record was created
ad_replicationstrategy created timestamp 29,6 now() Date this record was created
ad_replicationtable created timestamp 29,6 now() Date this record was created
ad_sequence created timestamp 29,6 now() Date this record was created
ad_system created timestamp 29,6 now() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
c_doctype created timestamp 29,6 now() Date this record was created
ad_replication createdby numeric 10 User who created this records
ad_replication_log createdby numeric 10 User who created this records
ad_replication_run createdby numeric 10 User who created this records
ad_replicationdocument createdby numeric 10 User who created this records
ad_replicationstrategy createdby numeric 10 User who created this records
ad_replicationtable createdby numeric 10 User who created this records
ad_sequence createdby numeric 10 User who created this records
ad_system createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
c_doctype createdby numeric 10 User who created this records
ad_table createpartition bpchar 1  √  NULL::bpchar Process which create or update table partitions based on the table and column records
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_sequence currentnext numeric 10 The next number to be used
ad_sequence currentnextsys numeric 10 Next sequence for system use
ad_system customprefix varchar 60  √  null Prefix for Custom entities
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_sequence datecolumn varchar 60  √  null Fully qualified date column
ad_replication datelastrun timestamp 29,6  √  null Date the process was last run.
ad_system dbaddress varchar 255  √  null JDBC URL of the database server
ad_system dbinstance varchar 60  √  null Database Name
ad_sequence decimalpattern varchar 40  √  null Java Decimal Pattern
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
ad_replication description varchar 255  √  null Optional short description of the record
ad_replication_run description varchar 255  √  null Optional short description of the record
ad_replicationdocument description varchar 255  √  null Optional short description of the record
ad_replicationstrategy description varchar 255  √  null Optional short description of the record
ad_replicationtable description varchar 255  √  null Optional short description of the record
ad_sequence description varchar 255  √  null Optional short description of the record
ad_system description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
c_doctype description varchar 255  √  null Optional short description of the record
c_doctype docbasetype bpchar 3 Logical type of document
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
c_doctype documentcopies numeric 10 Number of copies to be printed
c_doctype documentnote varchar 2000  √  null Additional information for a Document
ad_system encryptionkey varchar 255  √  null Encryption Class used for securing data content
ad_replicationstrategy entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_replicationtable entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_replicationstrategy exp_processor_id numeric 10  √  null Export Processor
c_doctype gl_category_id numeric 10 General Ledger Category
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
ad_replication help varchar 2000  √  null Comment or Hint
ad_replicationstrategy help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
ad_replication hostaddress varchar 60 Host Address URL or DNS
ad_replication hostport numeric 10 Host Communication Port
ad_replication idrangeend numeric 0  √  null End if the ID Range used
ad_system idrangeend numeric 0  √  null End if the ID Range used
ad_replication idrangestart numeric 0  √  null Start of the ID Range used
ad_system idrangestart numeric 0  √  null Start of the ID Range used
ad_table importtable bpchar 1  √  null Import Table Columns from Database
ad_sequence incrementno numeric 10 The number to increment the last document number by
ad_system info varchar 255  √  null Information
ad_replication isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_replication_log isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_replication_run isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_replicationdocument isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_replicationstrategy isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_replicationtable isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_sequence isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_system isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctype isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_system isallowstatistics bpchar 1 'Y'::bpchar Maintain general statistics
ad_sequence isaudited bpchar 1  √  'N'::bpchar Activate Audit Trail of what numbers are generated
ad_system isautoerrorreport bpchar 1 'Y'::bpchar Automatically report Errors
ad_sequence isautosequence bpchar 1 'Y'::bpchar Automatically assign the next number
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
c_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
ad_system isfailonbuilddiffer bpchar 1 'N'::bpchar Fail if Build Differ
ad_system isfailonmissingmodelvalidator bpchar 1 'Y'::bpchar Fail on Missing Model Validator
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
ad_system isjustmigrated bpchar 1  √  'N'::bpchar Value set by Migration for post-Migration tasks.
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Price List
ad_sequence isorglevelsequence bpchar 1 'N'::bpchar This sequence can be defined for each organization
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
ad_table ispartition bpchar 1 'N'::bpchar This is a partitioned table
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
ad_replication_log isreplicated bpchar 1 'N'::bpchar The data is successfully replicated
ad_replication_run isreplicated bpchar 1 'N'::bpchar The data is successfully replicated
ad_replication isrmioverhttp bpchar 1 'Y'::bpchar Connect to Server via HTTP Tunnel
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
ad_table isshowindrilloptions bpchar 1  √  'Y'::bpchar This parameter enables the table to be displayed in Drill Assistant - Table tab
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
ad_sequence istableid bpchar 1  √  'N'::bpchar The document number will be used as the record key
ad_table isview bpchar 1 'N'::bpchar This is a view
ad_system lastbuildinfo varchar 255  √  null Last Build Info
ad_system lastmigrationscriptapplied varchar 255  √  NULL::character varying Register of the filename for the last migration script applied on this database
ad_system ldapdomain varchar 255  √  null Directory service domain name - e.g. idempiere.org
ad_system ldaphost varchar 60  √  null Connection String to LDAP server starting with ldap://
ad_table loadseq numeric 10  √  null Sequence
ad_replication name varchar 60 Alphanumeric identifier of the entity
ad_replication_run name varchar 60 Alphanumeric identifier of the entity
ad_replicationstrategy name varchar 60 Alphanumeric identifier of the entity
ad_sequence name varchar 60 Alphanumeric identifier of the entity
ad_system name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
c_doctype name varchar 60 Alphanumeric identifier of the entity
ad_system noprocessors numeric 10  √  null Number of Database Processors
ad_system oldname varchar 60  √  null Old Name
ad_sequence orgcolumn varchar 60  √  NULL::character varying Fully qualified Organization column (AD_Org_ID)
ad_replication_log p_msg varchar 2000  √  null Process Message
ad_system password varchar 20  √  null Password of any length (case sensitive)
ad_table po_window_id numeric 10  √  null Purchase Order Window
ad_replication prefix varchar 10  √  null Prefix before the sequence number
ad_sequence prefix varchar 255  √  null Prefix before the sequence number
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
ad_replication processing bpchar 1  √  null Process Now
ad_system processing bpchar 1  √  null Process Now
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_system profileinfo varchar 4000  √  null Information to help profiling the system for solving support issues
ad_system record_id numeric 10  √  null Direct internal record ID
ad_system releaseno varchar 10  √  null Internal Release Number
ad_replication remote_client_id numeric 10  √  null Remote Tenant to be used to replicate / synchronize data with.
ad_replication remote_org_id numeric 10  √  null Remote Organization to be used to replicate / synchronize data with.
ad_replicationdocument replicationtype bpchar 1 Type of Data Replication
ad_replicationtable replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_system replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_sequence startnewmonth bpchar 1 'N'::bpchar Restart sequence every month
ad_sequence startnewyear bpchar 1  √  'N'::bpchar Restart the sequence with Start on every 1/1
ad_sequence startno numeric 10 Starting number/position
ad_system statisticsinfo varchar 60  √  null Information to help profiling the system for solving support issues
ad_replication suffix varchar 10  √  null Suffix after the number
ad_sequence suffix varchar 255  √  null Suffix after the number
ad_system summary varchar 255  √  null Textual summary of this request
ad_system supportemail varchar 60  √  null EMail address to send support information and updates to
ad_system supportexpdate timestamp 29,6  √  null Date when the iDempiere support expires
ad_system supportunits numeric 10  √  null Number of Internal Users for iDempiere Support
ad_system systemstatus bpchar 1 'E'::bpchar Status of the system - Support priority depends on system status
ad_table tablename varchar 40 Name of the table in the database
ad_replication updated timestamp 29,6 now() Date this record was updated
ad_replication_log updated timestamp 29,6 now() Date this record was updated
ad_replication_run updated timestamp 29,6 now() Date this record was updated
ad_replicationdocument updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_replicationstrategy updated timestamp 29,6 now() Date this record was updated
ad_replicationtable updated timestamp 29,6 now() Date this record was updated
ad_sequence updated timestamp 29,6 now() Date this record was updated
ad_system updated timestamp 29,6 now() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
c_doctype updated timestamp 29,6 now() Date this record was updated
ad_replication updatedby numeric 10 User who updated this records
ad_replication_log updatedby numeric 10 User who updated this records
ad_replication_run updatedby numeric 10 User who updated this records
ad_replicationdocument updatedby numeric 10 User who updated this records
ad_replicationstrategy updatedby numeric 10 User who updated this records
ad_replicationtable updatedby numeric 10 User who updated this records
ad_sequence updatedby numeric 10 User who updated this records
ad_system updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
c_doctype updatedby numeric 10 User who updated this records
ad_system username varchar 60 User Name
ad_replicationstrategy value varchar 40  √  null Search key for the record in the format required - must be unique
ad_system version varchar 20  √  null Version of the table definition
ad_sequence vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"