1. REST API for Oracle CX Sales and B2B ServiceREST API for Sales and Fusion Service in Oracle Fusion Cloud Customer Experience
  2. Reference
  3. Lists of Values
  4. Accounts: Lists of Values

Accounts: Lists of Values

The lookup resource of a lookup determines where the lookup value is stored. However, these lookup resources contain all the lookup values. You must use a finder specifying a lookup type to get the lookup values that you require. The finder is a query statement that selects a specific list of values from the table.

For example, the lookup resource fndStaticLookups contains the list of values specifying the Account statuses. You can use the finder LookupTypeIsActiveEnabledFinder, the finder variable BindLookupType, and the lookup type ZCA_SALES_ACCOUNT_STATUS, to get all the values in ZCA_SALES_ACCOUNT_STATUS.

The following is the format of the resource URL.

https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/fndStaticLookups?finder=LookupTypeIsActiveEnabledFinder;BindLookupType=ZCA_SALES_ACCOUNT_STATUS

The following is an example of the response body in JSON format.

{
    "items": [
        {
            "LookupType": "ZCA_SALES_ACCOUNT_STATUS",
            "LookupCode": "ACTIVE",
            "Meaning": "Active",
            "Description": "Active status.",
            "EnabledFlag": "Y",
            "StartDateActive": "2012-12-11",
            "EndDateActive": null,
            "DisplaySequence": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2013-03-24T06:49:22.472+00:00",
            "LastUpdateDate": "2018-05-16T02:26:14.623+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "Tag": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/fndStaticLookups/0002000000185A43415F53414C45535F4143434F554E545F53544154555300000006414354495645",
                    "name": "fndStaticLookups",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/fndStaticLookups/0002000000185A43415F53414C45535F4143434F554E545F53544154555300000006414354495645",
                    "name": "fndStaticLookups",
                    "kind": "item"
                }
            ]
        },
        {
            "LookupType": "ZCA_SALES_ACCOUNT_STATUS",
            "LookupCode": "INACTIVE",
            "Meaning": "Inactive",
            "Description": "Inactive status.",
            "EnabledFlag": "Y",
            "StartDateActive": "2012-12-11",
            "EndDateActive": null,
            "DisplaySequence": null,
            "CreatedBy": "SEED_DATA_FROM_APPLICATION",
            "CreationDate": "2013-03-24T06:49:22.500+00:00",
            "LastUpdateDate": "2018-05-16T02:26:14.623+00:00",
            "LastUpdateLogin": "-1",
            "LastUpdatedBy": "SEED_DATA_FROM_APPLICATION",
            "Tag": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/fndStaticLookups/0002000000185A43415F53414C45535F4143434F554E545F53544154555300000008494E414354495645",
                    "name": "fndStaticLookups",
                    "kind": "item"
                },
                {
                    "rel": "canonical",
                    "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/fndStaticLookups/0002000000185A43415F53414C45535F4143434F554E545F53544154555300000008494E414354495645",
                    "name": "fndStaticLookups",
                    "kind": "item"
                }
            ]
        }
    ],
    "count": 2,
    "hasMore": false,
    "limit": 25,
    "offset": 0,
    "links": [
        {
            "rel": "self",
            "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/fndStaticLookups",
            "name": "fndStaticLookups",
            "kind": "collection"
        }
    ]
}

Accounts LOVs

The table lists the LOVs included in the Accounts resource.

Lookup Type LOV Name and Path Sample Lookup Codes and Values
ZCA_ACCOUNT_TYPE SalesProfileTypeLookupLOV

/crmRestApi/resources/11.13.18.05/fndStaticLookups?finder=LookupTypeIsActiveEnabledFinder;BindLookupType=ZCA_ACCOUNT_TYPE
  • ZCA_CUSTOMER - Customer
  • ZCA_PROSPECT - Prospect
ZCA_SALES_ACCOUNT_STATUS SalesProfileStatusLookupLOV

/crmRestApi/resources/11.13.18.05/fndStaticLookups?finder=LookupTypeIsActiveEnabledFinder;BindLookupType= ZCA_SALES_ACCOUNT_STATUS
  • ACTIVE - Active
  • INACTIVE - Inactive
1987 SIC IndustryCodeVA

/crmRestApi/resources/11.13.18.05/classCodes?finder=ClassCategoryFinder;BindClassCategory= 1987%20SIC
  • 01 - Agricultural production-crops
  • 011 - Cash grains
  • 0111 - Wheat farm
MONTH FiscalYearendMonthLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= MONTH
  • 01 - January
  • 02 - February
  • 03 - March
NA FiscalYearendMonthLookupLOV

crmRestApi/resources/11.13.18.05/fndCurrencies
  • PKR - Pakistan Rupee
  • PTE - Portuguese Escudo
  • SEK - Swedish Krona
HZ_PARTY_CERT_LEVEL CertificationLevelLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HZ_PARTY_CERT_LEVEL
  • !00 - Highest
  • 200 - Minimum
  • 300 - Not met
HZ_PARTY_CERT_REASON CertificationReasonCodeLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HZ_PARTY_CERT_REASON
  • MANUAL - Manual
  • THIRD_PARTY - Third party content
OWN_RENT_IND RentOwnIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= OWN_RENT_IND
  • O - Owns
  • R - Rents
  • E - Co-owns
HQ_BRANCH_IND HQBranchIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HQ_BRANCH_IND
  • HQ - Headquarters
  • BR - Branch
  • DIV - Division
EMP_AT_PRIMARY_ADR_EST_IND EmployeeAtPrimaryAdrEstIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= EMP_AT_PRIMARY_ADR_EST_IND
  • N - Actual
  • Y - Estimated
EMP_AT_PRIMARY_ADR_MIN_IND EmployeeAtPrimaryAdrMinimumIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= EMP_AT_PRIMARY_ADR_MIN_IND
  • C - Average
  • B - Maximum
  • A - Minimum
TOTAL_EMP_EST_IND TotalEmployeeEstIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= TOTAL_EMP_EST_IND
  • N - Actual
  • Y - Estimated
TOTAL_EMPLOYEES_INDICATOR TotalEmployeesIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= TOTAL_EMPLOYEES_INDICATOR
  • B - Includes Subsidiaries
  • A - Subsidiaries not included
TOTAL_EMP_MIN_IND TotalEmployeeMinimumIndLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= TOTAL_EMP_MIN_IND
  • C - Average
  • B - Maximum
  • A - Minimum
HZ_ORGANIZATION_SIZE OrgSizeLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HZ_ORGANIZATION_SIZE
  • LARGE - Large
  • MEDIUM - Medium
  • SMALL - Small
LEGAL_STATUS LegalStatusLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= LEGAL_STATUS
  • LSC/3060 - Accountant
  • LSC/983 - Administrative organizationMEDIUM - Medium
  • LSC/220 - Agricultural collective interest company
REGISTRATION_TYPE RegistrationTypeLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= REGISTRATION_TYPE
  • RTC/1 - Cooperative
  • RTC/2 - Federally chartered
  • RTC/6 - Nonprofit
NA TerritoriesLOV

/crmRestApi/resources/11.13.18.05/fndTerritories
  • AE - United Arab Emirates
  • AF - Afghanistan
  • BH - Bahrain
LOCAL_BUS_IDEN_TYPE LocalBusIdenTypeLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= LOCAL_BUS_IDEN_TYPE
  • AID - Agency identification
  • ABP - Bankruptcy procedure number
  • ZV - Block number
NA RatedCurrenciesLOV

/crmRestApi/resources/11.13.18.05/ratedCurrencies
  • BRL - Brazilian Real
  • NO_MATCH - Unable to enrich because there no matches
  • MULTIPLE_MATCHES - Unable to enrich because there are multiple matches
DATA_CLOUD_STATUS DataCloudStatusLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= DATA_CLOUD_STATUS
  • MATCHED - Matched
  • NO_MATCH - Unable to enrich because there no matches
  • MULTIPLE_MATCHES - Unable to enrich because there are multiple matches
HZ_STATUS StatusLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HZ_STATUS
  • A - Active
  • I - Inactive
HZ_PREFERRED_CONTACT_METHOD PreferredContactMethodLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HZ_PREFERRED_CONTACT_METHOD
  • PHONE - Phone
  • EMAIL - E-mail
  • MAIL - Mail
NA PhoneCountryCodeLOV

/crmRestApi/resources/11.13.18.05/countryCodes
  • 93 - Afghanistan
  • 358 - Aland Islands
  • 1 - American Samoa
NA FaxCountryCodeLOV

/crmRestApi/resources/11.13.18.05/countryCodes
  • 93 - Afghanistan
  • 358 - Aland Islands
  • 1 - American Samoa
YES_NO FavoriteAccountFlagLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= YES_NO
  • N - No
  • Y - Yes
HZ_HOUSE_TYPE HouseTypeLookupLOV

/crmRestApi/resources/11.13.18.05/hzLookups?finder=ActiveLookupForTypeFinder;BindLookupType= HZ_HOUSE_TYPE
  • TRAILER - Trailer
  • HOUSE BOAT - House boat
ZCA_RESOURCE_FUNCTION MemberFunctionLOV

/crmRestApi/resources/11.13.18.05/fndStaticLookups?finder=LookupTypeIsActiveEnabledFinder;BindLookupType= ZCA_RESOURCE_FUNCTION
  • ACCOUNT MANAGER - Account manager
  • CHANNEL_MGR - Channel manager
  • ENGINEERING_OWNER - Engineering owner
ZCA_ACCESS_LEVEL AccessLevelLOV

/crmRestApi/resources/11.13.18.05/fndStaticLookups?finder=LookupTypeIsActiveEnabledFinder;BindLookupType= ZCA_ACCESS_LEVEL
  • 200 - Edit
  • 300 - Full
  • 100 - View only access