SchemaSpy Analysis of idempiere9.adempiere - ColumnsCountry etc Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:47 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 263 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_currency emurate numeric 0  √  0 Official rate to the Euro
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
c_country allowcitiesoutoflist bpchar 1  √  'Y'::bpchar A flag to allow cities, currently not in the list, to be entered
c_country haspostal_add bpchar 1 'N'::bpchar Has Additional Postal Code
c_country hasregion bpchar 1 'N'::bpchar Country contains Regions
ad_language isactive bpchar 1 'N'::bpchar The record is active in the system
c_addresstransaction isactive bpchar 1 'Y'::bpchar The record is active in the system
c_addressvalidation isactive bpchar 1 'Y'::bpchar The record is active in the system
c_addressvalidationcfg isactive bpchar 1 'Y'::bpchar The record is active in the system
c_city isactive bpchar 1 'Y'::bpchar The record is active in the system
c_country isactive bpchar 1 'Y'::bpchar The record is active in the system
c_countrygroup isactive bpchar 1 'Y'::bpchar The record is active in the system
c_countrygroupcountry isactive bpchar 1 'Y'::bpchar The record is active in the system
c_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_region isactive bpchar 1 'Y'::bpchar The record is active in the system
m_locator isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse isactive bpchar 1 'Y'::bpchar The record is active in the system
c_country isaddresslineslocalreverse bpchar 1 'N'::bpchar Print Local Address in reverse Order
c_country isaddresslinesreverse bpchar 1 'N'::bpchar Print Address in reverse Order
ad_language isbaselanguage bpchar 1 'N'::bpchar The system information is maintained in this language
ad_language isdecimalpoint bpchar 1  √  null The number notation has a decimal point (no decimal comma)
c_region isdefault bpchar 1  √  'N'::bpchar Default value
m_locator isdefault bpchar 1 'N'::bpchar Default value
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
c_currency isemumember bpchar 1 'N'::bpchar This currency is member if the European Monetary Union
c_currency iseuro bpchar 1 'N'::bpchar This currency is the Euro
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
ad_language isloginlocale bpchar 1  √  'N'::bpchar Login Locale
c_country ispostcodelookup bpchar 1 'N'::bpchar Does this country have a post code web service
ad_language issystemlanguage bpchar 1 'N'::bpchar The screens, etc. are maintained in this Language
c_addresstransaction isvalid bpchar 1 'N'::bpchar Element is valid
c_location isvalid bpchar 1  √  'N'::bpchar Element is valid
c_addresstransaction processed bpchar 1 'N'::bpchar The document has been processed
ad_language processing bpchar 1  √  null Process Now
m_warehouse separator bpchar 1 Element Separator
c_location validateaddress bpchar 1  √  NULL::bpchar Validate Address
ad_language countrycode bpchar 2  √  null Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
c_country countrycode bpchar 2 Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_language languageiso bpchar 2  √  null Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
ad_language ad_language varchar 6 Language for this entity
c_country ad_language varchar 6  √  null Language for this entity
ad_language ad_client_id numeric 10 Client/Tenant for this installation.
c_addresstransaction ad_client_id numeric 10 Client/Tenant for this installation.
c_addressvalidation ad_client_id numeric 10 Client/Tenant for this installation.
c_addressvalidationcfg ad_client_id numeric 10 Client/Tenant for this installation.
c_city ad_client_id numeric 10 Client/Tenant for this installation.
c_country ad_client_id numeric 10 Client/Tenant for this installation.
c_countrygroup ad_client_id numeric 10 Client/Tenant for this installation.
c_countrygroupcountry ad_client_id numeric 10 Client/Tenant for this installation.
c_currency ad_client_id numeric 10 Client/Tenant for this installation.
c_location ad_client_id numeric 10 Client/Tenant for this installation.
c_region ad_client_id numeric 10 Client/Tenant for this installation.
m_locator ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
ad_language ad_language_id numeric 10 Language ID
ad_language ad_org_id numeric 10 Organizational entity within client
c_addresstransaction ad_org_id numeric 10 Organizational entity within client
c_addressvalidation ad_org_id numeric 10 Organizational entity within client
c_addressvalidationcfg ad_org_id numeric 10 Organizational entity within client
c_city ad_org_id numeric 10 Organizational entity within client
c_country ad_org_id numeric 10 Organizational entity within client
c_countrygroup ad_org_id numeric 10 Organizational entity within client
c_countrygroupcountry ad_org_id numeric 10 Organizational entity within client
c_currency ad_org_id numeric 10 Organizational entity within client
c_location ad_org_id numeric 10 Organizational entity within client
c_region ad_org_id numeric 10 Organizational entity within client
m_locator ad_org_id numeric 10 Organizational entity within client
m_warehouse ad_org_id numeric 10 Organizational entity within client
ad_language ad_printpaper_id numeric 10  √  NULL::numeric Printer paper definition
c_city areacode varchar 10  √  null Phone Area Code
c_addresstransaction c_addresstransaction_id numeric 10 Address Transaction
c_addresstransaction c_addressvalidation_id numeric 10 Address Validation
c_addressvalidation c_addressvalidation_id numeric 10 Address Validation
c_location c_addressvalidation_id numeric 10  √  NULL::numeric Address Validation
c_addressvalidation c_addressvalidationcfg_id numeric 10 Address Validation Configuration
c_addressvalidationcfg c_addressvalidationcfg_id numeric 10 Address Validation Configuration
c_city c_city_id numeric 10 City
c_location c_city_id numeric 10  √  null City
c_city c_country_id numeric 10  √  null Country
c_country c_country_id numeric 10 Country
c_countrygroupcountry c_country_id numeric 10  √  NULL::numeric Country
c_location c_country_id numeric 10 Country
c_region c_country_id numeric 10 Country
c_countrygroup c_countrygroup_id numeric 10 Country Group
c_countrygroupcountry c_countrygroup_id numeric 10  √  NULL::numeric Country Group
c_countrygroupcountry c_countrygroupcountry_id numeric 10 Country on Country Group
c_country c_currency_id numeric 10  √  null The Currency for this record
c_currency c_currency_id numeric 10 The Currency for this record
c_addresstransaction c_location_id numeric 10  √  NULL::numeric Location or Address
c_location c_location_id numeric 10 Location or Address
m_warehouse c_location_id numeric 10 Location or Address
c_city c_region_id numeric 10  √  null Identifies a geographical Region
c_location c_region_id numeric 10  √  null Identifies a geographical Region
c_region c_region_id numeric 10 Identifies a geographical Region
c_currency costingprecision numeric 10 Rounding used costing calculations
ad_language createdby numeric 10 User who created this records
c_addresstransaction createdby numeric 10 User who created this records
c_addressvalidation createdby numeric 10 User who created this records
c_addressvalidationcfg createdby numeric 10 User who created this records
c_city createdby numeric 10 User who created this records
c_country createdby numeric 10 User who created this records
c_countrygroup createdby numeric 10 User who created this records
c_countrygroupcountry createdby numeric 10 User who created this records
c_currency createdby numeric 10 User who created this records
c_location createdby numeric 10 User who created this records
c_region createdby numeric 10 User who created this records
m_locator createdby numeric 10 User who created this records
m_warehouse createdby numeric 10 User who created this records
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_addressvalidationcfg hostport numeric 10 Host Communication Port
c_city locode varchar 10  √  null Location code - UN/LOCODE
m_locator m_locator_id numeric 10 Warehouse Locator
m_locator m_locatortype_id numeric 10  √  NULL::numeric Locator Type
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
m_locator m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
c_addresstransaction postal varchar 10  √  NULL::character varying Postal code
c_city postal varchar 10  √  null Postal code
c_location postal varchar 10  √  null Postal code
c_location postal_add varchar 10  √  null Additional ZIP or Postal code
m_locator priorityno numeric 10 Where inventory should be picked from first
c_addressvalidationcfg proxyport numeric 10  √  NULL::numeric Port of your proxy server
c_addressvalidation seqno numeric 10 Method of ordering records; lowest number comes first
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
ad_language updatedby numeric 10 User who updated this records
c_addresstransaction updatedby numeric 10 User who updated this records
c_addressvalidation updatedby numeric 10 User who updated this records
c_addressvalidationcfg updatedby numeric 10 User who updated this records
c_city updatedby numeric 10 User who updated this records
c_country updatedby numeric 10 User who updated this records
c_countrygroup updatedby numeric 10 User who updated this records
c_countrygroupcountry updatedby numeric 10 User who updated this records
c_currency updatedby numeric 10 User who updated this records
c_location updatedby numeric 10 User who updated this records
c_region updatedby numeric 10 User who updated this records
m_locator updatedby numeric 10 User who updated this records
m_warehouse updatedby numeric 10 User who updated this records
c_city coordinates varchar 15  √  null Location coordinate
ad_language datepattern varchar 20  √  null Java Date Pattern
c_country displaysequence varchar 20 Format for printing this Address
c_country displaysequencelocal varchar 20  √  null Format for printing this Address locally
c_country expressionbankaccountno varchar 20  √  null Format of the Bank Account
c_country expressionbankroutingno varchar 20  √  null Format of the Bank Routing Number
c_country expressionphone varchar 20  √  null Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country expressionpostal varchar 20  √  null Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country expressionpostal_add varchar 20  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_language timepattern varchar 20  √  null Java Time Pattern
ad_language created timestamp 29,6 now() Date this record was created
c_addresstransaction created timestamp 29,6 statement_timestamp() Date this record was created
c_addressvalidation created timestamp 29,6 statement_timestamp() Date this record was created
c_addressvalidationcfg created timestamp 29,6 statement_timestamp() Date this record was created
c_city created timestamp 29,6 now() Date this record was created
c_country created timestamp 29,6 now() Date this record was created
c_countrygroup created timestamp 29,6 statement_timestamp() Date this record was created
c_countrygroupcountry created timestamp 29,6 statement_timestamp() Date this record was created
c_currency created timestamp 29,6 now() Date this record was created
c_location created timestamp 29,6 now() Date this record was created
c_region created timestamp 29,6 now() Date this record was created
m_locator created timestamp 29,6 now() Date this record was created
m_warehouse created timestamp 29,6 now() Date this record was created
c_countrygroup datefrom timestamp 29,6  √  null Starting date for a range
c_countrygroupcountry datefrom timestamp 29,6  √  null Starting date for a range
c_countrygroup dateto timestamp 29,6  √  null End date of a date range
c_countrygroupcountry dateto timestamp 29,6  √  null End date of a date range
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
ad_language updated timestamp 29,6 now() Date this record was updated
c_addresstransaction updated timestamp 29,6 statement_timestamp() Date this record was updated
c_addressvalidation updated timestamp 29,6 statement_timestamp() Date this record was updated
c_addressvalidationcfg updated timestamp 29,6 statement_timestamp() Date this record was updated
c_city updated timestamp 29,6 now() Date this record was updated
c_country updated timestamp 29,6 now() Date this record was updated
c_countrygroup updated timestamp 29,6 statement_timestamp() Date this record was updated
c_countrygroupcountry updated timestamp 29,6 statement_timestamp() Date this record was updated
c_currency updated timestamp 29,6 now() Date this record was updated
c_location updated timestamp 29,6 now() Date this record was updated
c_region updated timestamp 29,6 now() Date this record was updated
m_locator updated timestamp 29,6 now() Date this record was updated
m_warehouse updated timestamp 29,6 now() Date this record was updated
ad_language ad_language_uu varchar 36  √  NULL::character varying AD_Language_UU
c_addresstransaction c_addresstransaction_uu varchar 36  √  NULL::character varying C_AddressTransaction_UU
c_addressvalidation c_addressvalidation_uu varchar 36  √  NULL::character varying C_AddressValidation_UU
c_addressvalidationcfg c_addressvalidationcfg_uu varchar 36  √  NULL::character varying C_AddressValidationCfg_UU
c_city c_city_uu varchar 36  √  NULL::character varying C_City_UU
c_country c_country_uu varchar 36  √  NULL::character varying C_Country_UU
c_countrygroup c_countrygroup_uu varchar 36  √  NULL::character varying C_CountryGroup_UU
c_countrygroupcountry c_countrygroupcountry_uu varchar 36  √  NULL::character varying C_CountryGroupCountry_UU
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_location c_location_uu varchar 36  √  NULL::character varying C_Location_UU
c_region c_region_uu varchar 36  √  NULL::character varying C_Region_UU
m_locator m_locator_uu varchar 36  √  NULL::character varying M_Locator_UU
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
c_country mediasize varchar 40  √  null Java Media Size
c_location regionname varchar 40  √  null Name of the Region
c_addressvalidation shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
c_countrygroup value varchar 40 Search key for the record in the format required - must be unique
m_locator value varchar 40 Search key for the record in the format required - must be unique
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
c_country lookupclientid varchar 50  √  null The ClientID or Login submitted to the Lookup URL
c_country lookuppassword varchar 50  √  null The password submitted to the Lookup URL
c_addresstransaction address1 varchar 60  √  NULL::character varying Address line 1 for this location
c_location address1 varchar 60  √  null Address line 1 for this location
c_addresstransaction address2 varchar 60  √  NULL::character varying Address line 2 for this location
c_location address2 varchar 60  √  null Address line 2 for this location
c_addresstransaction address3 varchar 60  √  NULL::character varying Address Line 3 for the location
c_location address3 varchar 60  √  null Address Line 3 for the location
c_addresstransaction address4 varchar 60  √  NULL::character varying Address Line 4 for the location
c_location address4 varchar 60  √  null Address Line 4 for the location
c_addresstransaction address5 varchar 60  √  NULL::character varying Address Line 5 for the location
c_location address5 varchar 60  √  NULL::character varying Address Line 5 for the location
c_country capturesequence varchar 60  √  null Capture Sequence
c_addresstransaction city varchar 60  √  NULL::character varying Identifies a City
c_location city varchar 60  √  null Identifies a City
c_addressvalidation connectionkey varchar 60  √  NULL::character varying Connection Key
c_addressvalidation connectionpassword varchar 60 Connection Password
c_addresstransaction country varchar 60  √  NULL::character varying Country
c_addressvalidationcfg hostaddress varchar 60 Host Address URL or DNS
ad_language name varchar 60 Alphanumeric identifier of the entity
c_addressvalidation name varchar 60 Alphanumeric identifier of the entity
c_addressvalidationcfg name varchar 60 Alphanumeric identifier of the entity
c_city name varchar 60 Alphanumeric identifier of the entity
c_country name varchar 60 Alphanumeric identifier of the entity
c_countrygroup name varchar 60 Alphanumeric identifier of the entity
c_region name varchar 60 Alphanumeric identifier of the entity
m_warehouse name varchar 60 Alphanumeric identifier of the entity
ad_language printname varchar 60 NULL::character varying The label text to be printed on a document or correspondence.
c_addressvalidationcfg proxyaddress varchar 60  √  NULL::character varying Address of your proxy server
c_addressvalidationcfg proxylogon varchar 60  √  NULL::character varying Logon of your proxy server
c_addressvalidationcfg proxypassword varchar 60  √  NULL::character varying Password of your proxy server
c_addresstransaction region varchar 60  √  NULL::character varying Region
c_country regionname varchar 60  √  null Name of the Region
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
c_addressvalidationcfg servicepath varchar 60  √  NULL::character varying Service Path
c_addressvalidation userid varchar 60 User ID or account number
m_locator x varchar 60  √  null X dimension, e.g., Aisle
m_locator y varchar 60  √  null Y dimension, e.g., Bin
m_locator z varchar 60  √  null Z dimension, e.g., Level
c_addressvalidationcfg addressvalidationclass varchar 100  √  null Address Validation Class
c_country lookupurl varchar 100  √  null The URL of the web service that the plugin connects to in order to retrieve postcode data
c_addressvalidationcfg description varchar 255  √  NULL::character varying Optional short description of the record
c_country description varchar 255  √  null Optional short description of the record
c_countrygroup description varchar 255  √  NULL::character varying Optional short description of the record
c_currency description varchar 255 Optional short description of the record
c_region description varchar 255  √  null Optional short description of the record
m_warehouse description varchar 255  √  null Optional short description of the record
c_country lookupclassname varchar 255  √  null The class name of the postcode lookup plugin
c_country placeholderaddress1 varchar 255  √  NULL::character varying Placeholder for Address 1
c_country placeholderaddress2 varchar 255  √  NULL::character varying Placeholder for Address 2
c_country placeholderaddress3 varchar 255  √  NULL::character varying Placeholder for Address 3
c_country placeholderaddress4 varchar 255  √  NULL::character varying Placeholder for Address 4
c_country placeholderaddress5 varchar 255  √  NULL::character varying Placeholder for Address 5
c_country placeholdercity varchar 255  √  NULL::character varying Placeholder for city
c_country placeholdercomments varchar 255  √  NULL::character varying Placeholder for comments
c_country placeholderpostal varchar 255  √  NULL::character varying Placeholder for postal
c_country placeholderpostal_add varchar 255  √  NULL::character varying Placeholder for additional zip
c_addressvalidation shippermeter varchar 255  √  NULL::character varying Shipper Meter
c_addresstransaction comments varchar 2000  √  NULL::character varying Comments or additional information
c_location comments varchar 2000  √  NULL::character varying Comments or additional information
c_countrygroup help varchar 2000  √  NULL::character varying Comment or Hint
c_addresstransaction result varchar 2000  √  NULL::character varying Result of the action taken
c_location result varchar 2000  √  NULL::character varying Result of the action taken