SchemaSpy Analysis of idempiere11.adempiere - ColumnsCountry etc | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:48 +0100 |
| |||||
|
idempiere11.adempiere contains 263 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
c_country | ad_language | varchar | 6 | √ | null | Language for this entity | |
ad_language | ad_language_uu | varchar | 36 | √ | NULL::character varying | AD_Language_UU | |
ad_language | ad_printpaper_id | numeric | 10 | √ | NULL::numeric | Printer paper definition | |
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_addressvalidationcfg | addressvalidationclass | varchar | 100 | √ | null | Address Validation Class | |
c_country | allowcitiesoutoflist | bpchar | 1 | √ | 'Y'::bpchar | A flag to allow cities, currently not in the list, to be entered | |
c_city | areacode | varchar | 10 | √ | null | Phone Area Code | |
c_addresstransaction | c_addresstransaction_uu | varchar | 36 | √ | NULL::character varying | C_AddressTransaction_UU | |
c_location | c_addressvalidation_id | numeric | 10 | √ | NULL::numeric | Address Validation | |
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_location | c_city_id | numeric | 10 | √ | null | City | |
c_city | c_city_uu | varchar | 36 | √ | NULL::character varying | C_City_UU | |
c_city | c_country_id | numeric | 10 | √ | null | Country | |
c_countrygroupcountry | c_country_id | numeric | 10 | √ | NULL::numeric | Country | |
c_country | c_country_uu | varchar | 36 | √ | NULL::character varying | C_Country_UU | |
c_countrygroupcountry | c_countrygroup_id | numeric | 10 | √ | NULL::numeric | Country Group | |
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_country | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
c_currency | c_currency_uu | varchar | 36 | √ | NULL::character varying | C_Currency_UU | |
c_addresstransaction | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
c_location | c_location_uu | varchar | 36 | √ | NULL::character varying | C_Location_UU | |
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_uu | varchar | 36 | √ | NULL::character varying | C_Region_UU | |
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_addresstransaction | comments | varchar | 2000 | √ | NULL::character varying | Comments or additional information | |
c_location | comments | varchar | 2000 | √ | NULL::character varying | Comments or additional information | |
c_addressvalidation | connectionkey | varchar | 60 | √ | NULL::character varying | Connection Key | |
c_city | coordinates | varchar | 15 | √ | null | Location coordinate | |
c_addresstransaction | country | varchar | 60 | √ | NULL::character varying | Country | |
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_currency | cursymbol | varchar | 10 | √ | null | Symbol of the currency (opt used for printing only) | |
c_countrygroup | datefrom | timestamp | 29,6 | √ | null | Starting date for a range | |
c_countrygroupcountry | datefrom | timestamp | 29,6 | √ | null | Starting date for a range | |
ad_language | datepattern | varchar | 20 | √ | null | Java Date Pattern | |
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_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_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 | displaysequencelocal | varchar | 20 | √ | null | Format for printing this Address locally | |
c_currency | emuentrydate | timestamp | 29,6 | √ | null | Date when the currency joined / will join the EMU | |
c_currency | emurate | numeric | 0 | √ | 0 | Official rate to the Euro | |
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" | |
c_countrygroup | help | varchar | 2000 | √ | NULL::character varying | Comment or Hint | |
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_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | Movement is in transit | |
ad_language | isloginlocale | bpchar | 1 | √ | 'N'::bpchar | Login Locale | |
c_location | isvalid | bpchar | 1 | √ | 'N'::bpchar | Element is valid | |
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_city | locode | varchar | 10 | √ | null | Location code - UN/LOCODE | |
c_country | lookupclassname | varchar | 255 | √ | null | The class name of the postcode lookup plugin | |
c_country | lookupclientid | varchar | 50 | √ | null | The Client ID or Login submitted to the Lookup URL | |
c_country | lookuppassword | varchar | 50 | √ | null | The password submitted to the Lookup URL | |
c_country | lookupurl | varchar | 100 | √ | null | The URL of the web service that the plugin connects to in order to retrieve postcode data | |
m_locator | m_locator_uu | varchar | 36 | √ | NULL::character varying | M_Locator_UU | |
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_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | M_Warehouse_UU | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | Optional Warehouse to replenish from | |
c_country | mediasize | varchar | 40 | √ | null | Java Media Size | |
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_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 | |
ad_language | processing | bpchar | 1 | √ | null | Process Now | |
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_addressvalidationcfg | proxyport | numeric | 10 | √ | NULL::numeric | Port of your proxy server | |
c_addresstransaction | region | varchar | 60 | √ | NULL::character varying | Region | |
c_country | regionname | varchar | 60 | √ | null | Name of the Region | |
c_location | regionname | varchar | 40 | √ | null | Name of the Region | |
m_warehouse | replenishmentclass | varchar | 60 | √ | null | Custom class to calculate Quantity to Order | |
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 | |
c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment Amount | |
c_addressvalidationcfg | servicepath | varchar | 60 | √ | NULL::character varying | Service Path | |
c_addressvalidation | shipperaccount | varchar | 40 | √ | NULL::character varying | Shipper Account Number | |
c_addressvalidation | shippermeter | varchar | 255 | √ | NULL::character varying | Shipper Meter | |
ad_language | timepattern | varchar | 20 | √ | null | Java Time Pattern | |
c_location | validateaddress | bpchar | 1 | √ | NULL::bpchar | Validate Address | |
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 | |
ad_language | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_addresstransaction | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_addressvalidation | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_addressvalidationcfg | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_city | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_country | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_countrygroup | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_countrygroupcountry | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_currency | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_region | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_locator | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_warehouse | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_language | ad_language | varchar | 6 | Language for this entity | |||
ad_language | ad_language_id | numeric | 10 | Language ID | |||
ad_language | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_addresstransaction | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_addressvalidation | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_addressvalidationcfg | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_city | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_country | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_countrygroup | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_countrygroupcountry | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_currency | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_region | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_locator | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_warehouse | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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_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_country | c_country_id | numeric | 10 | 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_countrygroupcountry_id | numeric | 10 | Country on Country Group | |||
c_currency | c_currency_id | numeric | 10 | The Currency for this record | |||
c_location | c_location_id | numeric | 10 | Location or Address | |||
m_warehouse | c_location_id | numeric | 10 | Location or Address | |||
c_region | c_region_id | numeric | 10 | Identifies a geographical Region | |||
c_addressvalidation | connectionpassword | varchar | 60 | Connection Password | |||
c_currency | costingprecision | numeric | 10 | Rounding used costing calculations | |||
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 | 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 | ||
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 | description | varchar | 255 | Optional short description of the record | |||
c_country | displaysequence | varchar | 20 | Format for printing this Address | |||
c_country | haspostal_add | bpchar | 1 | 'N'::bpchar | Has Additional Postal Code | ||
c_country | hasregion | bpchar | 1 | 'N'::bpchar | Country contains Regions | ||
c_addressvalidationcfg | hostaddress | varchar | 60 | Host Address URL or DNS | |||
c_addressvalidationcfg | hostport | numeric | 10 | Host Communication Port | |||
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 | ||
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 | ||
c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
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 | ||
m_locator | m_locator_id | numeric | 10 | Warehouse Locator | |||
m_locator | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_warehouse | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
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. | ||
m_locator | priorityno | numeric | 10 | Where inventory should be picked from first | |||
c_addresstransaction | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_warehouse | separator | bpchar | 1 | Element Separator | |||
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 | 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 | 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_addressvalidation | userid | varchar | 60 | User ID or 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 |