1. Tables and Views for Sales and Fusion Service
  2. HZ_IMP_ADDTNLPARTYIDS_T

HZ_IMP_ADDTNLPARTYIDS_T

The TCA import interface table, HZ_IMP_ADDTNLPARTYIDS_T, stores information for population into HZ_ADDTNL_PARTY_IDS in TCA.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Status
ADDTNLPARTYID_T_ID NUMBER 18 Unique identifier of the HZ_IMP_ADDTNLPARTYIDS_T interface record. Internal use only.
INTERFACE_ROW_ID NUMBER 18 Unique identifier of the HZ_IMP_ADDTNLPARTYIDS_T interface record. Internal use only.
BATCH_ID NUMBER 18 Yes Unique Identifier for a Batch Active
PARTY_ORIG_SYSTEM VARCHAR2 30 Original System ID for the Party Active
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 255 Original System Reference for the Party Active
IDENTIFIER_ORIG_SYSTEM VARCHAR2 30 Original System ID for the Party Identifier Active
IDENTIFIER_ORIG_SYSTEM_REF VARCHAR2 255 Original System Reference for the Party Identifier Active
INSERT_UPDATE_FLAG VARCHAR2 1 Indicates if a record should be explicitly inserted or updated Active
ACTION_FLAG VARCHAR2 1 Indicates the action of insert or update based on matching outcome. Active
PARTY_ID NUMBER 18 Party that owns the additional party name Active
PARTY_IDENTIFIER_ID NUMBER 18 Additional party identifier Id Active
PARTY_IDENTIFIER_TYPE VARCHAR2 30 Identifier type for this ID. Values are defined in TYPE_CODE of HZ_NAME_AND_ID_TYPE_B. The party type should be consistent with the party type that the PARTY_IDENTIFIER_TYPE can be applied to. Making the attribute to nullable. Active
PARTY_IDENTIFIER_VALUE VARCHAR2 60 Value of the Identifier for the Party. Making the attribute NULLABLE. Active
COUNTRY VARCHAR2 2 Foreign key to FND_TERRITORY. From UI, COUNTRY and STATE should be displayed based on geography setup. Used for certain types of identifiers such as Passports or Driving licenses. Active
STATE_PROVINCE VARCHAR2 60 From UI, COUNTRY and STATE should be displayed based on geography setup. Used for certain types of identifiers such as Passports or Driving licenses Active
ISSUING_AUTHORITY_NAME VARCHAR2 500 If ISSUING_AUTHORITY_PARTY_ID is not null, check foreign key. Otherwise, store ISSUING_AUTHORITY_NAME. Either of these should be populated Active
ISSUING_AUTHORITY_PARTY_ID NUMBER 18 If ISSUING_AUTHORITY_PARTY_ID is not null, check foreign key. Otherwise, store ISSUING_AUTHORITY_NAME. Either of these should be populated Active
ISSUE_DATE DATE Date in which the Identifier was issued. It may be NULL as it does not apply to all types of identifiers Active
EXPIRATION_DATE DATE Expiration date for the identifier. It may be NULL as it does not apply to all types of identifiers. Active
DESCRIPTION VARCHAR2 240 Free text comment/description. Active
INTERFACE_STATUS VARCHAR2 30 Status for the data in the interface table Active
ERROR_ID NUMBER 18 Foreign Key to the Error Table Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
FILE_RECORD_NUM NUMBER 10 This column is required by import wizard to related record in the interface table to the file row.
ACTION_CODE VARCHAR2 30 Indicates delete action entered by user
IMPORT_STATUS_CODE VARCHAR2 30 Status for the data in the interface table
FILE_NAME_SYSTASK_ID NUMBER 18 Stores systask id for each import csv file.
PARTY_NUMBER VARCHAR2 30 Unique identification number for this party

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_IMP_ADDTNLPARTYIDS_T hz_imp_batch_summary BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_IMP_ADDTNLPARTYIDS_T_N1 Non Unique Default BATCH_ID, ADDTNLPARTYID_T_ID
HZ_IMP_ADDTNLPARTYIDS_T_N2 Non Unique Default BATCH_ID, IDENTIFIER_ORIG_SYSTEM, IDENTIFIER_ORIG_SYSTEM_REF, INTERFACE_STATUS
HZ_IMP_ADDTNLPARTYIDS_T_N3 Non Unique Default BATCH_ID, FILE_RECORD_NUM, INTERFACE_STATUS
HZ_IMP_ADDTNLPARTYIDS_T_N4 Non Unique Default BATCH_ID, PARTY_IDENTIFIER_ID, INTERFACE_STATUS
HZ_IMP_ADDTNLPARTYIDS_T_N5 Non Unique Default BATCH_ID, PARTY_NUMBER
HZ_IMP_ADDTNLPARTYIDS_T_N6 Non Unique Default PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE
HZ_IMP_ADDTNLPARTYIDS_T_N7 Non Unique Default BATCH_ID, PARTY_ID
HZ_IMP_ADDTNLPARTYIDS_T_U1 Unique Default ADDTNLPARTYID_T_ID