Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Authorization Group | X_infac360sap_authorizationGroup | Lookup | NA | infac360sap_AuthorizationGroup | Authorization group with access to specific data. |
BP Type | X_infac360sap_bpType | Lookup | NA | infac360sap_BPType | Type of business partner. For example, employee, broker, or manager. |
Company Type | companyType | Lookup | NA | CompanyType | Type of company. |
Country Of Incorporation | countryOfIncorporation | Lookup | NA | Country | Country of incorporation of an organization. |
Company Logo | imageUrl | Text | 255 | NA | URL of the image for an organization. |
Customer Classification | X_infac360sap_customerClassification | Lookup | NA | infac360sap_CustomerClassification | Classification of the customers. |
Date of Incorporation | dateOfIncorporation | Date Time | NA | NA | Date of incorporation of an organization. |
Name | name | Text | 255 | NA | Name of an organization. |
Nielsen Indicator | X_infac360sap_nielsenIndicator | Lookup | NA | infac360sap_NielsenIndicator | Indicator to predict the consumer behavior of an organization. |
Number Of Employees | numberOfEmployees | Integer | NA | NA | Total number of employees in an organization. |
Sales Division | X_infac360sap_salesDivision | Text | 255 | NA | Deprecated division of a sales organization. Note: If you are yet to deploy the extension, you can use a field group or a business entity for the sales details and update the Cloud Data Integration assets accordingly. |
Sales Distribution Channel | X_infac360sap_salesDistributionchannel | Text | 255 | NA | Deprecated channel through which salable materials or services of an organization reach its customers, such as wholesale, retail, or direct sales. Note: If you are yet to deploy the extension, you can use a field group or a business entity for the sales details and update the Cloud Data Integration assets accordingly. |
Sales Org | X_infac360sap_salesOrg | Text | 255 | NA | Deprecated unit of an organization that handles sales. Note: If you are yet to deploy the extension, you can use a field group or a business entity for the sales details and update the Cloud Data Integration assets accordingly. |
State of Incorporation | stateOfIncorporation | Lookup | NA | State | State of incorporation of the organization. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Address Line 1 | addressLine1 | Text | 200 | NA | Line 1 of the address. |
Address Line 2 | addressLine2 | Text | 200 | NA | Line 2 of the address. |
Address Line 3 | addressLine3 | Text | 200 | NA | Line 3 of the address. |
Address Status | addressStatus | Lookup | NA | AddressStatus | Status of the address. For example, active, current, old address, or changed. |
Address Type | addressType | Lookup | NA | AddressType | Type of address. For example, organization, high-rise building, or home. |
City | city | Text | 50 | NA | City of postal address. |
Coordinate System | coordinateSystem | Text | 100 | NA | Coordinate system used to determine the location of the address. |
Country | country | Lookup | NA | Country | Country code of postal address. For example, Australia or United States. |
County | county | Text | 50 | NA | County of postal address. |
Default Indicator | defaultIndicator | Boolean | NA | NA | Indicates whether the address is the default address. |
End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of the address. |
Enriched Indicator | enrichedIndicator | Lookup | NA | AddressEnrichedIndicator | Validation status of the address. For example, error, valid, or not validated. |
Latitude | latitude | Text | 20 | NA | Latitude for the address. |
Location Coordinate Description | locationCoordinateDesc | Text | 50 | NA | Location of the address using the geocode coordinates system. |
Longitude | longitude | Text | 20 | NA | Longitude of the address. |
Postal Code | postalCode | Text | 10 | NA | Postal code of the address. |
Postal Code Extension | postalCodeExtension | Text | 10 | NA | Postal code extension of the address. |
Start Date | effectiveStartDate | Date Time | NA | NA | Start date from when the address is active. |
State | state | Lookup | NA | State | State of postal address. For example, if the country is United States, the state can be California or Florida. |
Usage Type | usageType | Lookup | NA | AddressUsageType | Usage type. For example, business or personal. |
Verification Message | statusMessage | Text | 255 | NA | Validation message that the address verification service returns. |
Verification Status Code | statusCode | Text | 10 | NA | Validation status that the address verification service returns. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Alternate Name | name | Text | 255 | NA | An alternative name for an organization. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of the alternate name. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date from when the alternate name is valid. |
Name Type | nameType | Lookup | NA | AlternateNameType | Alternate name type. For example, business name, company name, or marketing name. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Customer Type | X_infac360sap_custTyp | Lookup | NA | infac360sap_CustomerType | Type of customer. For example, sales partner or competitor. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Document Link | documentLink | Text | 255 | NA | URL to access the document. |
Document Name | documentName | Text | 255 | NA | Name of the document. |
Document Type | documentType | Lookup | NA | DocumentType | Type of the document. For example, application form, claim form, or policy. |
File Name | fileName | Text | 255 | NA | Physical name of the file. |
Valid From | validFrom | Date | NA | NA | Date from when the document becomes valid. |
Valid To | validTo | Date | NA | NA | Date until when the document is valid. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Default Indicator | defaultIndicator | Boolean | NA | NA | Indicates whether the electronic address is primary or default. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date for the electronic address. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date for the electronic address. |
Electronic Address | electronicAddress | Text | 255 | NA | Actual electronic address of an organization. |
Electronic Address Status | electronicAddressStatus | Lookup | NA | ElectronicAddressStatus | Status of the electronic address. For example, active, blocked, or not in use. |
Enriched Indicator | enrichedIndicator | Boolean | NA | NA | Validation status of the electronic address. For example, error, valid, or not validated. |
Hygiene Status | hygieneStatus | Text | 50 | NA | Hygiene status for the electronic address. For example, safe to send, invalid, or former trap. |
Net Protect Code | netProtectCode | Text | 50 | NA | Net protect codes identify which service or appliance is monitoring a given network. |
Usage Type | usageType | Lookup | NA | ElectronicAddressUsageType | Intended use of the communication preference that an organization shared. For example, business or personal. |
Verification Message | validateMessage | Text | 50 | NA | Message that the electronic address validation service generates to indicate how valid and trusted the electronic address is. |
Verification Status Code | validationStatusCode | Text | 50 | NA | Validation status code that the email address validation service returns. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Amount | amount | Double | 20 | NA | Total value of the physical assets that an organization owns. |
Currency | currency | Lookup | NA | Currency | Currency used for transactions. For example, United States dollar or United Kingdom pound. |
Finance Info Type | financeInfoType | Lookup | NA | FinanceInfoType | Type of financial information. For example, total equity, annual revenue, or debt. |
Finance Reliability | financeReliability | Lookup | NA | FinanceReliability | Reliability of the financial data, if the data is actual or an estimate. |
Time Period | timePeriod | Text | 255 | NA | Finance period for which the data is collected. |
Time Period Type | financeTimePeriodType | Lookup | NA | TimePeriodType | Type of the finance period. For example, quarterly or annual. |
Unit | financialUnit | Lookup | NA | FinancialUnit | Unit for the amount. For example, thousand, million, or billion. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
City | X_infac360sap_city | Text | 255 | NA | City of an organization. |
Country | X_infac360sap_country | Lookup | NA | Country | Country of an organization. |
Description | X_infac360sap_description | Text | 255 | NA | Description of an organization. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of the identifier. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Issued date of the identifier. |
Identifier Type | idType | Lookup | NA | AlternateIdType | Type of alternate identifier. For example, D&B ID or Federal Employer Identification Number. |
Identifier Value | altIdValue | Text | 50 | NA | Value of alternate identifier, such as employee ID or tax ID number. |
Issuing Authority | issuingAuthority | Lookup | NA | IssuingAuthority | Authority that has issued the identifier to an organization. For example, Dun & Bradstreet or government agency. |
Issued Date | X_infac360sap_issuedDate | Date | NA | NA | Issue date of the identifier. |
Region | X_infac360sap_region | Lookup | NA | State | State region of the issuing country. |
Status | identifierStatus | Lookup | NA | IdentifierStatus | Code to indicate the status of the alternate identifier. For example, effective, disqualified, expired, or temporary. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Indicator Type | X_infac360sap_indicatorType | Lookup | NA | IndicatorType | Indicates the type of an organization, such as minority-owned, women-owned, and small business. |
Indicator Value | X_infac360sap_indicatorValue | Text | 255 | NA | Actual value of the indicator. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Industry Code | X_infac360sap_industryCode | Lookup | NA | infac360sap_IndustryCode | Code of the industry the organization belongs to. |
Industry Value | X_infac360sap_industryValue | Text | 255 | NA | Industry identifier or name of the industry. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Currency | currency | Lookup | NA | Currency | Currency for the premium payment and claim settlement. |
Effective End Date | effectiveEndDate | Date | NA | NA | Expiry date of the insurance. |
Effective Start Date | effectiveStartDate | Date | NA | NA | Start date of the insurance. |
Insurance Holder | insuranceHolder | Text | 255 | NA | Name of the insurance holder. |
Insurance Provider | insuranceProvider | Text | 255 | NA | Company that provides the insurance. |
Insurance Sub Type | insuranceSubType | Lookup | NA | InsuranceSubType | Insurance subtype. For example, if the insurance type is lenders mortgage, the subtype might be extended lenders mortgage. |
Insurance Type | insuranceType | Lookup | NA | InsuranceType | Type of the insurance, such as commercial auto, lenders mortgage, or shipping. |
Insurance Value | insuranceValue | Double | NA | NA | Amount insured. |
Policy Number | insurancePolicyNumber | Text | 100 | NA | Insurance policy number. |
Status | insuranceStatus | Text | 255 | insuranceStatus | Status of the insurance. For example, active or expired. |
Unit | unit | Lookup | NA | FinancialUnit | Specifies the unit for the amount. For example, thousands, millions, ot billions. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Designation | designation | Text | 255 | NA | Designation of the key executive. |
Executive Type | executiveType | Lookup | NA | ExecutiveType | Executive type. For example, executive chairman, non-executive chairman, or chief executive officer. |
Name | name | Text | 255 | NA | Name of the executive. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Language | X_infac360sap_language | Lookup | NA | infac360sap_Language | The organizational language. |
Primary Indicator | X_infac360sap_primaryIndicator | Boolean | NA | NA | Indicates whether the language is the primary language of the organization. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Cell Prefix | cellPrefix | Text | 255 | NA | Dialing prefix that must prepend the National Significant Number for inbound international calls. |
Default Indicator | defaultIndicator | Boolean | NA | NA | Flag to indicate whether the phone number is the default number. |
Do Not Call Indicator | doNotCallIndicator | Boolean | NA | NA | Flag to indicate whether an organization is willing to receive unsolicited phone calls from marketers. |
Effective End Date | effectiveEndDate | DateTime | NA | NA | Date until when the phone number was active or will be active. |
Effective Start Date | effectiveStartDate | DateTime | NA | NA | Date from when the phone number is active. |
Enriched Indicator | enrichedIndicator | Boolean | NA | NA | Validation status of the phone number. For example, error, valid, or not validated. |
ISO | iso | Text | 2 | NA | ISO country code. |
International Format | internationalFormat | Text | 50 | NA | International format for the phone number. |
International Prefix | internationalPrefix | Text | 255 | NA | Prefix used to select an international telephone circuit. |
National Destination Code | nationalDestinationCode | Text | 255 | NA | Code that identifies a numbering area within a country or a group of countries. |
National Destination Code Indicator | nationalDestinationCodeIndicator | Boolean | NA | NA | Indicates whether a country defines geographic area codes in the National Numbering Plan. |
National Format | nationalFormat | Text | 50 | NA | National format for the phone number. |
National Prefix | nationalPrefix | Text | 255 | NA | Digit or combination of digits that must be dialed before an area or city code. |
Phone Number | phoneNumber | Text | 255 | NA | Organization phone number. |
Phone Number Extension | phoneNumberExtension | Text | 255 | NA | Extension number. |
Phone Type | phoneType | Lookup | NA | PhoneType | Type of phone. For example, landline, mobile, or fax. |
Phone Usage Type | phoneUsageType | Lookup | NA | PhoneUsageType | Usage type of the phone. For example, personal, business, or home. |
Prefix Number | prefixNumber | Text | 255 | NA | Country dialing code. |
Status | status | Lookup | NA | PhoneStatus | Status of the phone number, such as publicly unavailable or the contact point is active. |
Verification Message | validationMessage | Text | 255 | NA | Validation message that the phone number validation service returns. |
Verification Status Code | validationStatusCode | Text | 255 | NA | Validation status code that the phone number validation service returns. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Company Postal Code | X_infac360sap_companyPostalCode | Number | NA | NA | Postal code for a large organization. |
Delivery Number | X_infac360sap_deliveryNumber | Number | NA | NA | Delivery service number. |
Delivery Service | X_infac360sap_deliveryService | Lookup | NA | infac360sap_DeliveryService | Type of delivery service. For example, counter delivery or general delivery. |
Postal Code | X_infac360sap_postalCode | Number | NA | NA | Postal code of the address. |
PO Box | X_infac360sap_poBox | Text | 255 | NA | PO box number. |
PO Box Without Number | X_infac360sap_poBoxWoNo | Boolean | NA | NA | Indicates whether the PO box is without number. |
PO Box Lobby | X_infac360sap_poBoxLobby | Text | 255 | NA | Name of the PO box lobby. |
Other City | X_infac360sap_otherCity | Text | 255 | NA | Different PO box city. |
Other Country | X_infac360sap_otherCountry | Lookup | NA | Country | Different PO box country. |
Other Region | X_infac360sap_otherRegion | Lookup | NA | State | Different PO box region. |
Undeliverable | X_infac360sap_undeliverable | Lookup | NA | infac360sap_Undeliverable | Undelivered status. For example, deceased or illegible address. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Role | X_infac360sap_bpRole | Lookup | NA | infac360sap_OrgRoleType | Roles assigned to a business partner. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Segment Type | segmentType | Lookup | NA | SegmentType | Type of segment. For example, age or income. |
Segment Value | segmentValue | Lookup | NA | SegmentValue | Name of the category or segment. For example, if the segment type is age, then segment value can be 0-18 years. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Social Media Handle | socialMediaHandle | Text | 255 | NA | Social media contact details. |
Social Media Type | socialHandleType | Lookup | NA | SocialHandleType | Type of social media contact details. For example, Facebook, Linkedin, or Pinterest. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Status Type | statusType | Lookup | NA | OrgStatusType | Status type of an organization, such as onboarding or primary status. |
Status Value | statusValue | Lookup | NA | OrgStatusValue | Status value of an organization, such as active, accepted, or rejected. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Country | country | Lookup | NA | Country | Country in which the stock exchange is located. |
Stock Exchange | stockExchangeName | Text | 255 | NA | Name of the stock exchange that trades the shares. |
Ticker Symbol | tickerSymbol | Text | 255 | NA | Abbreviation used to identify the publicly traded shares of an organization. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Country | country | Lookup | NA | Country | Country of taxation. |
Currency | currency | Lookup | NA | Currency | Currency in which the tax is paid. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date of the tax period. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date of the tax period. |
State | state | Lookup | NA | State | State within the country of the taxation. |
Tax Authority | taxAuthority | Lookup | NA | TaxAuthority | Tax authority. For example, Internal Revenue Service (IRS), HM Revenue and Customs (HMRC), and Inland Revenue Department. |
Tax Number | taxNumber | Text | 50 | NA | Unique number that identifies an organization for tax purposes. |
Tax Number Type | taxNumberType | Lookup | NA | TaxNumberType | Type of the tax number. Tax number can be Individual Taxpayer Identification Number (ITIN), (EIN), Inland Revenue Department (IRD) number, and Permanent Account Number (PAN). |
Tax Paid | taxPaid | Text | 50 | NA | Tax amount that an organization has paid. |
Tax Payer Type | taxPayerType | Lookup | NA | TaxPayerType | Type of tax payer. For example, company, partnership, or trust. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Authorization Group | X_infac360sap_authorizationGroup | Lookup | NA | infac360sap_AuthorizationGroup | Authorization group with access to specific data. For example, unrestricted, restricted, or very restricted. |
Birth Country | X_infac360sap_birthCountry | Lookup | NA | Country | The country of birth for a person. |
Birth Date | birthDate | Date Time | NA | NA | Date of birth of the person. |
Birth Place | birthPlace | Text | 255 | NA | Place of birth of a person. |
BP Type | X_infac360sap_bpType | Lookup | NA | infac360sap_BPType | Type of business partner. For example, employee, broker, or manager. |
Children | X_infac360sap_children | Integer | 2 | NA | Number of children. |
Designation | designation | Text | 255 | NA | Designation or position of a person. |
First Name | firstName | Text | 255 | NA | First name of a person. |
Full Name | fullName | Text | 255 | NA | Full name of a person. |
Gender | gender | Lookup | NA | Gender | Gender of a person. |
Household Members | X_infac360sap_houseHoldMembers | Integer | 2 | NA | Number of household members. |
Image | imageUrl | Text | 255 | NA | URL of the image of a person. |
Last Name | lastName | Text | 255 | NA | Last name of a person. |
Marital Status | maritalStatus | Lookup | NA | MaritalStatus | Marital status of the person. For example, single, married, or divorced. |
Middle Name | middleName | Text | 255 | NA | Middle name of a person. |
Occupation | X_infac360sap_occupation | Lookup | NA | infac360sap_Occupation | Occupation of a person. |
Prefix Name | prefixName | Lookup | NA | PrefixName | Prefix for the name of a person. For example, Dr, Mr, or Mrs. |
Sales Division | X_infac360sap_salesDivision | Text | 255 | NA | Deprecated division of a sales organization that a person is associated with. Note: If you are yet to deploy the extension, you can use a field group or a business entity for the sales details and update the Cloud Data Integration assets accordingly. |
Sales Distribution Channel | X_infac360sap_salesDistributionchannel | Text | 255 | NA | Deprecated channel, such as wholesale, retail, or direct sales, that an organization uses to sell materials or services to a person. Note: If you are yet to deploy the extension, you can use a field group or a business entity for the sales details and update the Cloud Data Integration assets accordingly. |
Sales Org | X_infac360sap_salesOrg | Text | 255 | NA | Deprecated sales unit of an organization that a person is associated with. Note: If you are yet to deploy the extension, you can use a field group or a business entity for the sales details and update the Cloud Data Integration assets accordingly. |
Salutation | X_infac360sap_salutation | Text | 255 | NA | Salutation for a person. |
Suffix Name | suffixName | Lookup | NA | SuffixName | Suffix name of a person. For example, Sr, Jr, II, or III. |
Title | title | Text | 255 | NA | Title associated with a person's name. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Address Line 1 | addressLine1 | Text | 200 | NA | Line 1 of the address. |
Address Line 2 | addressLine2 | Text | 200 | NA | Line 2 of the address. |
Address Line 3 | addressLine3 | Text | 200 | NA | Line 3 of the address. |
Address Status | addressStatus | Lookup | NA | AddressStatus | Status of the address. For example, active, current, old address, or changed. |
Address Type | addressType | Lookup | NA | AddressType | Type of address. For example, high-rise building, or home. |
City | city | Text | 50 | NA | City of postal address. |
Coordinate System | coordinateSystem | Text | 100 | NA | Coordinate system used to determine the location of the address. |
Country | country | Lookup | NA | Country | Country code of postal address. For example, Australia or United States. |
County | county | Text | 50 | NA | County of postal address. |
Default Indicator | defaultIndicator | Boolean | NA | NA | Indicates whether the address is the default address. |
End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of the address. |
Enriched Indicator | enrichedIndicator | Lookup | NA | AddressEnrichedIndicator | Validation status of the address. For example, error, valid, or not validated. |
Latitude | latitude | Text | 20 | NA | Latitude for the address. |
Location Coordinate Description | locationCoordinateDesc | Text | 50 | NA | Location of the address using the geocode coordinates system. |
Longitude | longitude | Text | 20 | NA | Longitude of the address. |
Postal Code | postalCode | Text | 10 | NA | Postal code of the address. |
Postal Code Extension | postalCodeExtension | Text | 10 | NA | Postal code extension of the address. |
Start Date | effectiveStartDate | Date Time | NA | NA | Start date from when the address is active. |
State | state | Lookup | NA | State | State of postal address. For example, if the country is United States, the state can be California or Florida. |
Usage Type | usageType | Lookup | NA | AddressUsageType | Usage type. For example, business or personal. |
Verification Message | statusMessage | Text | 255 | NA | Validation message that the address verification service returns. |
Verification Status Code | statusCode | Text | 10 | NA | Validation status that the address verification service returns. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Alternate Name | AlternateName | Text | 255 | NA | An alternative name of a person. |
Alternate Name Type | alternateNameType | Lookup | NA | AlternateNameType | Type of alternate name. For example, alias, maiden name, or married name. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of the alternate name. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date from when the alternate name is valid. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Citizen of Country | citizenOfCountry | Lookup | NA | Country | Country to which a person belongs. |
Citizenship Status | citizenshipStatus | Text | 255 | NA | Status of the citizenship. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of citizenship. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date from when the citizenship is valid. |
Supporting Document Name | supportingDocumentName | Text | 255 | NA | Name of the supporting document that proves the citizenship. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Customer Type | X_infac360sap_customerType | Lookup | NA | infac360sap_CustomerType | Type of customer. For example, consumer or competitor. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Demographic Type | demographicType | Lookup | NA | DemographicType | Type of demographic factors. For example, ethnicity, income level, age, and profession. |
Demographic Value | demographicValue | Lookup | NA | DemographicValue | Demographic values for a demographic type. For example, if ethnicity is a demographic type, then Hispanic and Asian are demographic values. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Document Link | documentLink | Text | 255 | NA | URL to access the document. |
Document Name | documentName | Text | 255 | NA | Name of the document. |
Document Type | documentType | Lookup | NA | DocumentType | Type of the document. For example, application form, claim form, or policy. |
File Name | fileName | Text | 255 | NA | Physical name of the file. |
Valid From | validFrom | Date | NA | NA | Date from when the document becomes valid. |
Valid To | validTo | Date | NA | NA | Date until when the document is valid. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Address Line 1 | addressLine1 | Text | 255 | NA | Line 1 of the address of the educational institution. |
Address Line 2 | addressLine2 | Text | 255 | NA | Line 2 of the address of the educational institution. |
City | city | Text | 255 | NA | City in which the institution is located. |
Country | country | Lookup | NA | Country | Country in which the institution is located. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date of the qualification. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date of the qualification. |
Institution Name | institutionName | Text | 255 | NA | Name of the institution. |
Qualification Name | qualificationName | Text | 255 | NA | Name of the qualification. |
Qualification Status | qualificationStatus | Lookup | NA | QualificationStatus | Status of the qualification. |
Qualification Type | qualificationType | Lookup | NA | QualificationType | Type of qualification, such as illiterate, certification, diploma, bachelor, master, or doctoral. |
Postal Code | postalCode | Text | 255 | NA | Postal code of the address. |
Postal Code Extension | postalCodeExtension | Text | 255 | NA | Postal code extension of the address. |
State | state | Lookup | NA | State | State in which the institution is located. |
Student Number | studentNumber | Text | 255 | NA | Student number in the institution. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Default Indicator | defaultIndicator | Boolean | NA | NA | Indicates whether the electronic address is primary or default. |
Electronic Address | electronicAddress | Text | 255 | NA | Actual electronic address of a person. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date for the electronic address. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date for the electronic address. |
Electronic Address Status | electronicAddressStatus | Lookup | NA | ElectronicAddressStatus | Status of the electronic address. For example, active, blocked, or not in use. |
Enriched Indicator | enrichedIndicator | Boolean | NA | NA | Validation status of the electronic address. For example, error, valid, or not validated. |
Hygiene Status | hygieneStatus | Text | 50 | NA | Hygiene status for the electronic address. For example, safe to send, invalid, or former trap. |
Net Protect Code | netProtectCode | Text | 50 | NA | Net protect codes identify which service or appliance is monitoring a given network. |
Usage Type | usageType | Lookup | NA | ElectronicAddressUsageType | Intended use of the communication preference that a person shared. For example, business or personal. |
Verification Message | validateMessage | Text | 50 | NA | Message that the electronic address validation service generates to indicate how valid and trusted the electronic address is. |
Verification Status Code | validationStatusCode | Text | 50 | NA | Validation status code that the email address validation service returns. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Designation | designation | Text | 255 | NA | Designation of a person. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date of employment. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date of employment. |
Employee | X_infac360sap_employee | Boolean | NA | NA | Indicates whether a person is an employee. |
Employer Name | employerName | Text | 255 | NA | Name of the employer. |
Employment Status | employmentStatus | Lookup | NA | EmploymentStatus | Status of employment, such as active, inactive, or resigned. |
Employment Type | employmentType | Lookup | NA | EmploymentType | Type of employment, such as fixed term, contract, or self-employed. |
Line of Business | lineOfBusiness | Text | 255 | NA | Line of business, such as retail or mortgage. |
Location | location | Text | 255 | NA | Location of the employer. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Amount | amount | Double | 20 | NA | Total value of the physical assets that a person owns. |
Currency | currency | Lookup | NA | Currency | Currency used for transactions. For example, United States dollar or United Kingdom pound. |
Finance Info Type | financeInfoType | Lookup | NA | FinanceInfoType | Type of financial information. For example, total asset or annual income. |
Finance Reliability | financeReliability | Lookup | NA | FinanceReliability | Reliability of the financial data, if the data is actual or an estimate. |
Time Period | timePeriod | Text | 255 | NA | Finance period for which the data is collected. |
Time Period Type | financeTimePeriodType | Lookup | NA | TimePeriodType | Type of the finance period. For example, quarterly or annual. |
Unit | financialUnit | Lookup | NA | FinancialUnit | Unit for the amount. For example, thousand, million, or billion. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Country | X_infac360sap_country | Lookup | NA | Country | Country that issued the identifier. |
Identification Type | alternateIdentifierType | Lookup | NA | AlternateIdType | Type of alternative identifier. For example, D&B ID or Federal Employer Identification Number. |
Identification Value | alternateIdentifierValue | Text | 50 | NA | Value of alternative identifier, such as employee ID or tax ID number. |
Issuing Authority | issuingAuthority | Lookup | NA | IssuingAuthority | Authority that has issued the identifier to an organization. For example, Dun & Bradstreet or government agency. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | Expiry date of the identifier. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Issued date of the identifier. |
Issued Date | X_infac360sap_issuedDate | Date | NA | NA | Date of issue of the identifier. |
Region | X_infac360sap_region | Lookup | NA | State | State region of the issuing country. |
Status | identifierStatus | Lookup | NA | IdentifierStatus | Code to indicate the status of the alternate identifier. For example, effective, disqualified, expired, or temporary. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Indicator Type | X_infac360sap_indicatorType | Lookup | NA | infac360sap_IndicatorType | Indicates the type of person. |
Indicator Value | X_infac360sap_indicatorValue | Text | 255 | NA | Actual value of the indicator. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Currency | currency | Lookup | NA | Currency | Currency for the premium payment and claim settlement. |
Effective End Date | effectiveEndDate | Date | NA | NA | Expiry date of the insurance. |
Effective Start Date | effectiveStartDate | Date | NA | NA | Start date of the insurance. |
Insurance Holder | insuranceHolder | Text | 255 | NA | Name of the insurance holder. |
Insurance Provider | insuranceProvider | Text | 255 | NA | Company that provides the insurance. |
Insurance Sub Type | insuranceSubType | Lookup | NA | InsuranceSubType | Insurance subtype. For example, if the insurance type is travel, the subtype might be platinum travel. |
Insurance Type | insuranceType | Lookup | NA | InsuranceType | Type of the insurance, such as life, health, or travel. |
Policy Number | insurancePolicyNumber | Text | 100 | NA | Insurance policy number. |
Insurance Status | insuranceStatus | Text | 255 | insuranceStatus | Status of the insurance. For example, active or expired. |
Unit | unit | Lookup | NA | FinancialUnit | Specifies the unit for the amount. For example, thousands, millions, ot billions. |
Insurance Value | insuranceValue | Double | NA | NA | Amount insured. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Language | X_infac360sap_language | Lookup | NA | infac360sap_Language | Language in which a person has proficiency. |
Primary Indicator | X_infac360sap_primaryIndicator | Boolean | NA | NA | Indicates whether the language is the primary language of a person. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Lifestyle Type | lifestyleType | Lookup | NA | LifestyleType | Type of lifestyle. For example, alcohol consumption or tobacco consumption. |
Lifestyle Value | lifestyleValue | Text | 255 | NA | Frequency of a lifestyle. For example, frequent, moderate, or never. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Account Number | AccountNumber | Text | 255 | NA | Loyalty account number. |
Account Status | accountStatus | Lookup | NA | LoyaltyAccountStatus | Status of the account. For example, active or inactive. |
Account Type | accountType | Lookup | NA | LoyaltyAccountType | Type of loyalty accounts. For example, silver, gold, or platinum. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date of the loyalty account. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date of the loyalty account. |
Redemption Preferences | redemptionPreferences | Lookup | NA | RedemptionPreferences | Preference for the redemption of loyalty points. For example, cash back or credit. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Cell Prefix | cellPrefix | Text | 255 | NA | Dialing prefix that must prepend the National Significant Number for inbound international calls. |
Default Indicator | defaultIndicator | Boolean | NA | NA | Flag to indicate whether the phone number is the default number. |
Do Not Call Indicator | doNotCallIndicator | Boolean | NA | NA | Flag to indicate whether the person is willing to receive unsolicited phone calls from marketers. |
Effective End Date | effectiveEndDate | DateTime | NA | NA | Date until when the phone number was active or will be active. |
Effective Start Date | effectiveStartDate | DateTime | NA | NA | Date from when the phone number is active. |
Enriched Indicator | enrichedIndicator | Boolean | NA | NA | Validation status of the phone number. For example, error, valid, or not validated. |
International Format | internationalFormat | Text | 50 | NA | International format for the phone number. |
International Prefix | internationalPrefix | Text | 255 | NA | Prefix used to select an international telephone circuit. |
International Format | internationalFormat | Text | 50 | NA | International format for the phone number. |
ISO | iso | Text | 2 | NA | ISO country code. |
National Destination Code | nationalDestinationCode | Text | 255 | NA | Code that identifies a numbering area within a country or a group of countries. |
National Format | nationalFormat | Text | 50 | NA | National format for the phone number. |
National Prefix | nationalPrefix | Text | 255 | NA | Digit or combination of digits that must be dialed before an area or city code. |
National Destination Code Indicator | nationalDestinationCodeIndicator | Boolean | NA | NA | Indicates whether a country defines geographic area codes in the National Numbering Plan. |
Phone Number | phoneNumber | Text | 255 | NA | Person phone number. |
Phone Number Extension | phoneNumberExtension | Text | 255 | NA | Extension number. |
Phone Type | phoneType | Lookup | NA | PhoneType | Type of phone. For example, landline, mobile, or fax. |
Phone Usage Type | phoneUsageType | Lookup | NA | PhoneUsageType | Usage type of the phone. For example, personal, business, or home. |
Prefix Number | prefixNumber | Text | 255 | NA | Country dialing code. |
Status | status | Lookup | NA | PhoneStatus | Status of the phone number, such as publicly unavailable or the contact point is active. |
Verification Message | validationMessage | Text | 255 | NA | Validation message that the phone number validation service returns. |
Verification Status Code | validationStatusCode | Text | 255 | NA | Validation status code that the phone number validation service returns. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
PO Box | X_infac360sap_poBox | Text | 255 | NA | PO box number. |
Postal Code | X_infac360sap_postalCode | Number | NA | NA | Postal code of the address. |
Company Postal Code | X_infac360sap_companyPostalCode | Number | NA | NA | Postal code for a large organization. |
PO Box Without Number | X_infac360sap_poBoxWoNo | Boolean | NA | NA | Indicates whether the PO box is without number. |
PO Box Lobby | X_infac360sap_poBoxLobby | Text | 255 | NA | Name of the PO box lobby . |
Delivery Service | X_infac360sap_deliveryService | Lookup | NA | infac360sap_DeliveryService | Type of delivery service. For example, counter delivery or general delivery. |
Delivery Number | X_infac360sap_deliveryNumber | Number | NA | NA | Delivery service number. |
Other City | X_infac360sap_otherCity | Text | 255 | NA | Different PO box city. |
Other Country | X_infac360sap_otherCountry | Lookup | NA | Country | Different PO box country. |
Other Region | X_infac360sap_otherRegion | Lookup | NA | State | Different PO box region. |
Undeliverable | X_infac360sap_undeliverable | Lookup | NA | infac360sap_Undeliverable | Undelivered status. For example, deceased or illegible address. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Role | X_infac360sap_Role | Lookup | NA | infac360sap_Role | Roles assigned to a business partner. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Segment Type | segmentType | Lookup | NA | SegmentType | Type of segment, such as income. |
Segment Value | segmentValue | Lookup | NA | SegmentValue | Name of the category or segment. For example, lower middle class, upper high class, and upper middle class. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Social Media Handle | socialMediaValue | Text | 255 | NA | Social media contact details. |
Social Media Type | socialHandleType | Lookup | NA | SocialHandleType | Type of social media contact details. For example, Facebook, Linkedin, or Pinterest. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Specialty Type | specialtyType | Lookup | NA | SpecialityType | Specialty type. For example, construction, educational services, and finance and insurance. |
Specialty | speciality | Text | 255 | NA | Name of specialty. |
Board Certification Flag | boardCertificationFlag | Boolean | NA | NA | Indicates whether the board certification is active or not. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Status Type | statusType | Lookup | NA | PersonStatusType | Status type of a person, such as onboarding or primary status. |
Status Value | statusValue | Lookup | NA | PersonStatusValue | Status value of a person, such as active, accepted, or rejected. |
Display Name | Internal ID | Field Type | Length | Reference Data | Description |
---|---|---|---|---|---|
Country | country | Lookup | NA | Country | Country of taxation. |
Currency | currency | Lookup | NA | Currency | Currency in which the tax is paid. |
Effective End Date | effectiveEndDate | Date Time | NA | NA | End date of the tax period. |
Effective Start Date | effectiveStartDate | Date Time | NA | NA | Start date of the tax period. |
State | state | Lookup | NA | State | State within the country of the taxation. |
Tax Authority | taxAuthority | Lookup | NA | TaxAuthority | Tax authority. For example, Internal Revenue Service (IRS), HM Revenue and Customs (HMRC), and Inland Revenue Department. |
Tax Number | taxNumber | Text Field | 255 | NA | Unique number that identifies a person for tax purposes. |
Tax Number Type | taxNumberType | Lookup | NA | TaxNumberType | Type of the tax number. Tax number can be Individual Taxpayer Identification Number (ITIN), Employer Identification Number (EIN), Inland Revenue Department (IRD) number, and Permanent Account Number (PAN). |
Taxpayer Type | taxPayerType | Lookup | NA | TaxPayerType | Type of tax payer. For example, individual, company, partnership, or trust. |
Tax Paid | taxPaid | Text Field | 255 | NA | Tax amount that a person has paid. |