Country Code

Added On:  09/29/14 

SQL Table:  IAPP_COUNTRY_CODE 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  CountryCode 

Entity that represents information about country codes available in the system.

Available Fields:

• Amount Format
• Code
• Code Extended
• Currency Code

• Name
• Numeric Code
• Position
• Region

• Regional Country Code List
• Tax Id Validation Pattern
• Vat Number Validation Pattern
• Weekend Day

Amount Format

Added On:  06/14/23

SQL Column:  AMOUNT_FORMAT

Java Field:  amountFormat

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Code

Added On:  09/29/14

SQL Column:  CODE

Java Field:  code

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Code Extended

Added On:  01/15/16

SQL Column:  CODE_EXTENDED

Java Field:  codeExtended

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

The three-letter code of the country.

Currency Code

Added On:  08/16/16

SQL Column:  CURRENCY_CODE

Java Field:  currencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Currency code of the country.

Name

Added On:  09/29/14

SQL Column:  NAME

Java Field:  name

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Name of the country that the code belongs to.

Numeric Code

Added On:  09/29/14

SQL Column:  NUMERIC_CODE

Java Field:  numericCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Numeric code of the country.

Position

Added On:  08/12/20

SQL Column:  POSITION

Java Field:  position

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Region

Added On:  10/27/16

SQL Column:  REGION

Java Field:  region

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Code of the country's region.

Regional Country Code List

Added On:  12/05/23

SQL Column:  REGIONAL_COUNTRY_CODE_LIST

Java Field:  regionalCountryCodeList

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Tax Id Validation Pattern

Added On:  10/18/23

SQL Column:  TAX_ID_VALIDATION_PATTERN

Java Field:  taxIdValidationPattern

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Pattern:   ALPHANUMERIC

Vat Number Validation Pattern

Added On:  12/04/23

SQL Column:  VAT_NUMBER_VALIDATION_PATTERN

Java Field:  vatNumberValidationPattern

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Weekend Day

Added On:  08/17/23

SQL Column:  WEEKEND_DAY

Java Field:  weekendDay

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes: