ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

SupplierRegistrationPhoneCountryCodes

Enumerates valid country dialing codes for supplier phone numbers, aligning registration data with international standards.

Columns

Name Type Description
PhoneCountryCodeId [KEY] Long A unique identifier for the phone country code. This ID links each specific country code to the supplier registration process.
PhoneCountryCode String The international phone country code that corresponds to the supplier's location. It is used to format and validate phone numbers entered during registration. For example, '1' for the United States or '44' for the United Kingdom.
TerritoryShortName String A short name or abbreviation representing the territory or country associated with the phone country code. For instance, 'US' for the United States or 'UK' for the United Kingdom.
TerritoryCode String A longer code representing the territory or country associated with the phone country code. This could be an official country code such as 'USA' for the United States or 'GBR' for the United Kingdom.
PhoneLength Decimal The standard length of phone numbers, excluding the area code, for the specified territory. This value helps in validating phone numbers and ensuring they meet local standards.
AreaCodeLength Decimal The length of the area code for phone numbers in the specified territory. It is important for validating whether the area code provided by the supplier matches the expected format.
TrunkPrefix String The trunk prefix used for dialing within the country. For instance, in the United States, the trunk prefix is '1', while in other countries, it may vary.
IntlPrefix String The international dialing prefix used to make international calls from the specified country. For example, the international dialing prefix is '011' in the United States and '00' in many European countries.
ValidationProc String The validation procedure or algorithm used to verify the phone number format. This field specifies how the system checks if a phone number is valid for the given territory, including rules for length and structure.
TimezoneId Long A unique identifier for the time zone associated with the phone country code. This is used to ensure that business hours and other time-sensitive details are properly aligned with the supplier's time zone.
FndTerritoryCode String An additional code used to represent the country or territory in other systems or processes. This could be a code used internally within the organization or a region-specific code.
Finder String A search term or keyword used to locate a specific phone country code entry. This can help quickly identify and retrieve the correct phone code configuration for a given territory.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175