1. Tables and Views for Financials
  2. AR_UPD_CONTACTS

AR_UPD_CONTACTS

AR_UPD_CONTACTS contains customer contact interface data entered into a simplified customer spreadsheet template for upload.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

AR_UPD_CONTACTS_PK

CONTACT_UPLOAD_ID

Columns

Name Datatype Length Precision Not-null Comments
CONTACT_UPLOAD_ID NUMBER 18 Yes Unique identifier for a customer upload record.
BATCH_ID NUMBER 18 Unique identifier for a customer import batch process.
CUST_ORIG_SYSTEM VARCHAR2 30 Yes Original system identifier for the customer account.
ORIG_SOURCE_SYSTEM_NAME VARCHAR2 80 Name of the source system used to load data into the TCA registry.
ACCOUNT_NUMBER VARCHAR2 30 Number of the customer account.
PARTY_SITE_NUMBER VARCHAR2 30 Number of the party site. This number indicates unique reference of the addresses associated to a party.
CUST_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Yes Original system reference for the customer account.
CUST_SITE_ORIG_SYS_REF VARCHAR2 240 Original system reference for the customer account site.
CUST_CONTACT_ORIG_SYS_REF VARCHAR2 240 Original system reference for the customer account contact.
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the contact party.
SITE_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the party site.
REL_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the party relationship.
CP_ORIG_SYS_REF_PH_MOB VARCHAR2 240 Original system reference for the mobile phone contact point.
CP_ORIG_SYS_REF_PH_GEN VARCHAR2 240 Original system reference for the phone contact point.
CP_ORIG_SYS_REF_EMAIL VARCHAR2 240 Original system reference for the e-mail address contact point.
CP_ORIG_SYS_REF_WEB VARCHAR2 240 Original system reference for the website contact point.
CP_ORIG_SYS_REF_SOCIAL VARCHAR2 240 Original system reference for the social network contact point.
CONTACT_ROLE_ORIG_SYS_REF VARCHAR2 240 Original system reference for the organization contact role.
SUB_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer who is the subject of the relationship.
OBJ_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer who is the object of the relationship.
ROLE_RESP_ORIG_SYS_REF VARCHAR2 240 Original system reference for the customer account contact role responsibility.
CONTACT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTS_T interface table.
EMAIL_CONTACTPT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTPTS_T interface table for CONTACT_POINT_TYPE of e-mail.
WEB_CONTACTPT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTPTS_T interface table for CONTACT_POINT_TYPE of web site.
SOCIAL_CONTACTPT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTPTS_T interface table for CONTACT_POINT_TYPE of instant messaging.
PH_CONTACTPT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTPTS_T interface table for CONTACT_POINT_TYPE of phone number.
MOBPH_CONTACTPT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTPTS_T interface table for CONTACT_POINT_TYPE of mobile phone number.
ACCTCONTACT_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_ACCTCONTACTS_T interface table.
PARTY_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_PARTIES_T interface table.
CONTACTROLES_INT_ROW_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_CONTACTROLES interface table.
RELSHIP_T_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_RELSHIPS_T interface table.
ROLERESP_INT_ROW_ID NUMBER 18 Reference to the unique identifier of the HZ_IMP_ROLERESP interface table.
EMAIL_CONTACTPT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTS_T interface table for CONTACT_POINT_TYPE of e-mail.
WEB_CONTACTPT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTS_T interface table for CONTACT_POINT_TYPE of web site.
SOCIAL_CONTACTPT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTS_T interface table for CONTACT_POINT_TYPE of instant messaging.
PH_CONTACTPT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTS_T interface table for CONTACT_POINT_TYPE of phone number.
MOBPH_CONTACTPT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTS_T interface table for CONTACT_POINT_TYPE of mobile phone number.
CONTACT_INT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTS_T interface table.
ACCTCONTACT_INT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_ACCTCONTACTS_T interface table.
PARTY_INT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_PARTIES_T interface table for the contact party.
CONTACTROLE_INT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_CONTACTROLES interface table.
RELSHIP_INT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_RELSHIPS_T interface table.
ROLERESP_INT_STATUS VARCHAR2 30 Status of the data in the HZ_IMP_ROLERESP interface table.
PERSON_NUMBER VARCHAR2 30 Unique identifier of the contact person.
SALUTARY_INTRODUCTION VARCHAR2 30 Salutary name of the contact person. Value is validated against the CONTACT_TITLE lookup.
PERSON_FIRST_NAME VARCHAR2 150 Yes First name of the contact person.
PERSON_MIDDLE_NAME VARCHAR2 60 Middle name of the contact person.
PERSON_LAST_NAME VARCHAR2 150 Yes Last or surname of the contact person.
PERSON_LAST_NAME_PREFIX VARCHAR2 60 Last or surname prefix for the contact person, such as De or Von.
PERSON_NAME_SUFFIX VARCHAR2 30 Last or surname suffix for the contact person, such as Jr or III.
PERSON_PREVIOUS_LAST_NAME VARCHAR2 150 Previous last or surname of the contact person.
PERSON_ACADEMIC_TITLE VARCHAR2 30 Academic title of the contact person, such as Dr.
PERSON_TITLE VARCHAR2 60 Professional or family title of the contact person, such as Don, The Right Honorable, Sir, or Dame.
PERSON_INITIALS VARCHAR2 6 Initials of the name of the contact person.
PRIMARY_CONTACT_INDICATOR VARCHAR2 1 Indicates whether this is the primary contact person for this account or account site. Valid values are Y or N.
DEPARTMENT VARCHAR2 60 Name of the department for which the contact person works.
JOB_TITLE VARCHAR2 100 Job title of the contact person.
RESPONSIBILITY_TYPE VARCHAR2 30 Responsibility type of the contact person, based on the CONTACT_ROLE_TYPE lookup.
PRIMARY_RESP_INDICATOR VARCHAR2 1 Indicates whether this is the primary role responsibility of the contact person for this account or account site. Valid values are Y or N.
PHONE_COUNTRY_CODE VARCHAR2 10 International country code of the contact person phone number.
PHONE_AREA_CODE VARCHAR2 10 Area code of the contact person phone number.
PHONE_NUMBER VARCHAR2 40 Phone number for a contact person.
PHONE_EXTENSION VARCHAR2 20 Extension of the phone number of the contact person.
PHONE_LINE_TYPE VARCHAR2 30 Type of phone line of the phone number of the contact person, such as general, mobile, voice mail, fax, inbound, or outbound. Validated against the PHONE_LINE_TYPE lookup.
PRIMARY_PHONE_INDICATOR VARCHAR2 1 Indicates whether this is the primary phone for the contact person. Valid values are Y or N. Either the Primary Phone Indicator or the Primary Mobile Phone Indicator can have the value Y, but not both.
PHONE_PURPOSE VARCHAR2 30 Type of phone purpose of the phone number of the contact person, such as business or personal. Validated against the CONTACT_POINT_PURPOSE lookup.
UNFORMATTED_PH_NUMBER VARCHAR2 60 Unformatted telephone number of the contact person. If the value of the CONTACT_POINT_TYPE lookup is PHONE, then either the Phone Number or the Unformatted Phone Number must have a valid value, but not both.
PHONE_TIMEZONE_CODE VARCHAR2 64 Code identifying the time zone of the phone number of the contact person.
MOBILE_PHONE_COUNTRY_CODE VARCHAR2 10 International country code of the contact person mobile phone number.
MOBILE_PHONE_AREA_CODE VARCHAR2 10 Area code of the contact person mobile phone number.
MOBILE_PHONE_NUMBER VARCHAR2 40 Contact person mobile phone number.
PRIMARY_MOBILE_PHONE_IND VARCHAR2 1 Indicates whether this is the primary mobile phone for the contact person. Valid values are Y or N. Either the Primary Phone Indicator or the Primary Mobile Phone Indicator can have the value Y, but not both.
MOBILE_PHONE_PURPOSE VARCHAR2 30 Type of phone purpose of the mobile phone number of the contact person, such as business or personal. Validated against the CONTACT_POINT_PURPOSE lookup.
UNFORMATTED_MOB_PH_NUM VARCHAR2 60 Unformatted mobile phone number of the contact person. If the value of the CONTACT_POINT_TYPE lookup is PHONE and the value of the PHONE_LINE_TYPE lookup is MOBILE, then the Mobile Phone Number or the Unformatted Mobile Phone Number must have a valid value, but not both.
MOBILE_PHONE_TIMEZONE_CODE VARCHAR2 64 Code identifying the time zone of the mobile phone number of the contact person.
EMAIL_ADDRESS VARCHAR2 320 E-mail address for the contact person.
PRIMARY_EMAIL_INDICATOR VARCHAR2 1 Indicates whether this is the primary e-mail address for the contact person.
EMAIL_PURPOSE VARCHAR2 30 E-mail purpose, such as business or personal. Validated against the CONTACT_POINT_PURPOSE lookup.
INSTANT_MESSAGING_ADDRESS VARCHAR2 200 Social network instant message address of the contact person.
INSTANT_MESSENGER_TYPE VARCHAR2 30 Name of the social network of the instant message address of the contact person, such as Facebook or Google+.
PRIMARY_SN_INDICATOR VARCHAR2 1 Indicates whether this is the primary social network instant message address of the contact person. Valid values are Y or N.
SOCIAL_NETWORK_PURPOSE VARCHAR2 30 Purpose of the social network instant message address of the contact person, such as business or personal. Validated against the CONTACT_POINT_PURPOSE lookup.
WEB_URL VARCHAR2 1000 Uniform resource locator of the web site of the contact person.
PRIMARY_URL_INDICATOR VARCHAR2 1 Indicates whehter this is the primary web site of the contact person.
WEB_URL_PURPOSE VARCHAR2 30 Purpose of the web site of the contact person, such as business or personal. Validated against the CONTACT_POINT_PURPOSE lookup.
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
UPLOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the parent job that processes this record.
UPLOAD_STATUS VARCHAR2 30 Indicates the upload status of this record.
FILE_RECORD_NUM NUMBER 10 This column is used by the import wizard to relate a record in the interface table to the file row.

Indexes

Index Uniqueness Tablespace Columns
AR_UPD_CONTACTS_N1 Non Unique Default BATCH_ID, UPLOAD_STATUS, FILE_RECORD_NUM
AR_UPD_CONTACTS_N2 Non Unique Default LOAD_REQUEST_ID
AR_UPD_CONTACTS_U1 Unique Default CONTACT_UPLOAD_ID