Business Objects
This chapter provides overview and detail information about business objects and structures.
This chapter covers the following topics:
- Business Objects Overview
- Customer Account Business Object
- Customer Account Contact Business Object
- Customer Account Site Business Object
- EDI Business Object
- EFT Business Object
- E-Mail Business Object
- Organization Business Object
- Organization Contact Business Object
- Organization Customer Business Object
- Party Site Business Object
- Person Business Object
- Person Customer Business Object
- Phone Business Object
- SMS Business Object
- Telex Business Object
- Web Business Object
- Contact Person Information Business Structure
- Customer Account Site Use Business Structure
- Customer Profile Business Structure
- Employment History Business Structure
- Financial Report Business Structure
- Location Business Structure
Business Objects Overview
A business object is an abstract grouping of Oracle Trading Community Architecture (TCA) entities to form an operable, logical business unit. You perform operations and services, for example through APIs and business events, on the business object as a whole, abstracting away the underlying TCA data model.
This diagram provides an example of the hierarchical structure of business objects and their contents: attributes and embedded items. See:
Business Object Attributes
Each business object contains attributes that describe the business object at the root object level. Aside from object-specific attributes, all business objects have:
-
Object Identification Attributes: Uniquely identifies the business object, for example using columns such as PERSON_ID, or ORIG_SYSTEM and ORIG_SYSTEM_REFERENCE.
-
ACTION_TYPE: Defines operations performed on the business object. This attribute value is relevant to data hubs and only for event-specific extraction of data.
-
Parent Object Identification Attributes:
-
PARENT_OBJECT_TYPE: Indicates the type of the parent business object, if any, for example Organization, Person, or Organization Contact.
-
PARENT_OBJECT_ID: Uniquely identifies the parent object, if any.
These attributes are informational in nature and read only.
-
-
Internal Administrative Attributes: Provides administrative information regarding the business object, using, for example, CREATED_BY_NAME and LAST_UPDATE_DATE columns. These attributes are read only and internally maintained.
Business Object Embedded Items
Aside from object-level attributes, a business object can also contain any of these embedded items, which have their own attributes:
-
Other, embedded business objects: Which are considered atomic and logically abstracted as an entity within the parent business object. Items that exist within the embedded business object are packaged together and not exposed as items that can be viewed outside the context of the top level parent business object. An embedded business object can itself contain other embedded items.
-
Business structures: Which are essentially the same as business objects except that you cannot perform operations and services on them individually. A business structure itself can contain embedded structures and granular entities, but not business objects.
-
Embedded granular TCA entities: Which map to specific TCA tables. You can perform operations and services on these entities using granular APIs and business events. A granular entity within a business object is also known as an embedded entity.
With this paradigm, business objects allow logical and hierarchical representations of realistic business units. On the other hand, granular entities and the underlying TCA schema can be too detailed and complicated to relate directly to high-level conceptual business scenarios. The hierarchical nature of business objects lets you perform operations and services at the appropriate level, on specific objects.
Rules for Embedded Items
Business objects are flexible and unrestrictive, with different rules for including embedded items within the object. These rules are identified in the business object definition and enforced at the API level.
-
Requirement (Mandatory or Optional): Mandatory items must be embedded in a business object for the business object to be valid. If the API validates this rule, then you cannot create a business object without all its mandatory items.
-
Instance (Single or Multiple): Single instance embedded items can only exist once in a business object, while multiple instance items can exist more than once. Both types of item can be either mandatory or optional.
Seeded Business Objects
Oracle Trading Community Architecture provides a comprehensive set of business objects and structures that covers the entire TCA data model. These objects and structures have defined rules for their embedded items. See: Rules for Embedded Items.
This diagram shows the seeded business objects and structures, as well as the hierarchical manner in which they are embedded. For example, Person Customer and Organization Customer are the highest level business objects, each containing one or more Customer Account business objects, and one Person or Organization business object, respectively.
Note: Not shown in the diagram:
-
Granular entities are also embedded within the business objects.
-
The Party Site and Organization Contact business objects can also have embedded E-Mail, Phone, Telex, or Web business objects.
For details on each seeded business object and structure, including the listing of their embedded granular entities, see:
-
Person Customer Business Object; Organization Customer Business Object
-
Person Business Object; Organization Business Object
-
Contact Point Business Object
-
Customer Account Business Object
Integration Features
This table shows the seeded integration features for the Customer Account business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Customer Account Business Object API | HZ_CUST_SITE_USE_BO | HZ_CUST_SITE_USE_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Customer Account Site | Business Object | Optional | Multiple |
| Customer Account Contact | Business Object | Optional | Multiple |
| Customer Profile | Business Structure | Mandatory | Single |
| Customer Account Relationship | Granular Entity | Optional | Multiple |
| Bank Account Use | Entity (not TCA) | Optional | Multiple |
| Payment Method | Entity (not TCA) | Optional | Single |
| Customer Account Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| cust_acct_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| account_number | VARCHAR2(30) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| global_attribute_category | VARCHAR2(30) |
| global_attribute1 to global_attribute20 | VARCHAR2(150) |
| customer_type | VARCHAR2(30) |
| customer_class_code | VARCHAR2(30) |
| primary_salesrep_id | NUMBER |
| sales_channel_code | VARCHAR2(30) |
| order_type_id | NUMBER |
| price_list_id | NUMBER |
| tax_code | VARCHAR2(50) |
| fob_point | VARCHAR2(30) |
| freight_term | VARCHAR2(30) |
| ship_partial | VARCHAR2(1) |
| ship_via | VARCHAR2(30) |
| warehouse_id | NUMBER |
| tax_header_level_flag | VARCHAR2(1) |
| tax_rounding_rule | VARCHAR2(30) |
| coterminate_day_month | VARCHAR2(6) |
| primary_specialist_id | NUMBER |
| secondary_specialist_id | NUMBER |
| account_liable_flag | VARCHAR2(1) |
| current_balance | NUMBER |
| account_established_date | DATE |
| account_termination_date | DATE |
| account_activation_date | DATE |
| department | VARCHAR2(30) |
| held_bill_expiration_date | DATE |
| hold_bill_flag | VARCHAR2(1) |
| realtime_rate_flag | VARCHAR2(1) |
| acct_life_cycle_status | VARCHAR2(30) |
| account_name | VARCHAR2(240) |
| deposit_refund_method | VARCHAR2(20) |
| dormant_account_flag | VARCHAR2(1) |
| npa_number | VARCHAR2(60) |
| suspension_date | DATE |
| source_code | VARCHAR2(150) |
| comments | VARCHAR2(240) |
| dates_negative_tolerance | NUMBER |
| dates_positive_tolerance | NUMBER |
| date_type_preference | VARCHAR2(20) |
| over_shipment_tolerance | NUMBER |
| under_shipment_tolerance | NUMBER |
| over_return_tolerance | NUMBER |
| under_return_tolerance | NUMBER |
| item_cross_ref_pref | VARCHAR2(30) |
| ship_sets_include_lines_flag | VARCHAR2(1) |
| arrivalsets_include_lines_flag | VARCHAR2(1) |
| sched_date_push_flag | VARCHAR2(1) |
| invoice_quantity_rule | VARCHAR2(30) |
| pricing_event | VARCHAR2(30) |
| status_update_date | DATE |
| autopay_flag | VARCHAR2(1) |
| notify_flag | VARCHAR2(1) |
| last_batch_id | NUMBER |
| selling_party_id | NUMBER |
Related Topics
Customer Account Contact Business Object
Integration Features
This table shows the seeded integration features for the Customer Account Contact business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Customer Account Contact Business Object API | HZ_CUST_ACCT_CONTACT_BO | HZ_CUST_ACCT_CONTACT_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Account Contact Role | Granular Entity | Optional | Multiple |
| Relationship | Reference | Mandatory | Single |
| Customer Account Contact Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| cust_acct_contact_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| cust_acct_id | NUMBER |
| cust_acct_site_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| role_type | VARCHAR2(30) |
| source_code | VARCHAR2(150) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute25 | VARCHAR2(150) |
| relationship_id | NUMBER |
| contact_person_id | NUMBER |
| contact_person_orig_system | VARCHAR2(30) |
| contact_person_osr | VARCHAR2(255) |
| relationship_code | VARCHAR2(30) |
| relationship_type | VARCHAR2(30) |
| start_date | DATE |
Related Topics
Customer Account Site Business Object
Integration Features
This table shows the seeded integration features for the Customer Account Site business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Customer Account Site Business Object API | HZ_CUST_ACCT_SITE_BO | HZ_CUST_ACCT_SITE_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Customer Account Site Use | Business Structure | Optional | Multiple |
| Customer Account Contact | Business Object | Optional | Multiple |
| Party Site | Reference | ||
| Account Site Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| cust_acct_site_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| cust_acct_id | NUMBER |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| global_attribute_category | VARCHAR2(30) |
| global_attribute1 to global_attribute20 | VARCHAR2(150) |
| customer_category_code | VARCHAR2(30) |
| language | VARCHAR2(4) |
| key_account_flag | VARCHAR2(1) |
| tp_header_id | NUMBER |
| ece_tp_location_code | VARCHAR2(40) |
| primary_specialist_id | NUMBER |
| secondary_specialist_id | NUMBER |
| territory_id | NUMBER |
| territory | VARCHAR2(30) |
| translated_customer_name | VARCHAR2(50) |
| party_site_id | NUMBER |
| party_site_orig_system | VARCHAR2(30) |
| party_site_osr | VARCHAR2(255) |
| org_id | NUMBER |
Related Topics
EDI Business Object
Integration Features
This table shows the seeded integration features for the EDI business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | EDI Business Object API | HZ_EDI_CP_BO | HZ_EDI_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| edi_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| edi_transaction_handling | VARCHAR2(25) |
| edi_id_number | VARCHAR2(30) |
| edi_payment_method | VARCHAR2(30) |
| edi_payment_format | VARCHAR2(30) |
| edi_remittance_method | VARCHAR2(30) |
| edi_remittance_instruction | VARCHAR2(30) |
| edi_tp_header_id | NUMBER |
| edi_ece_tp_location_code | VARCHAR2(40) |
Related Topics
EFT Business Object
Integration Features
This table shows the seeded integration features for the EFT business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | EFT Business Object API | HZ_EFT_CP_BO | HZ_EFT_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| eft_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| eft_transmission_program_id | NUMBER |
| eft_printing_program_id | NUMBER |
| eft_user_number | VARCHAR2(30) |
| eft_swift_code | VARCHAR2(30) |
Related Topics
E-Mail Business Object
Integration Features
This table shows the seeded integration features for the E-Mail business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | E-Mail Business Object API | HZ_EMAIL_CP_BO | HZ_EMAIL_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| email_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| email_format | VARCHAR2(30) |
| email_address | VARCHAR2(2000) |
Related Topics
Organization Business Object
Integration Features
This table shows the seeded integration features for the Organization business object.
| Type | Name | Code | Procedures |
|---|---|---|---|
| Object | Organization Business Object API | HZ_ORGANIZATION_BO | HZ_ORGANIZATION_BO.create_object |
| Business Event |
|
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Extensible Attributes | Granular Entity | Optional | Multiple |
| Organization Contact | Business Object | Optional | Multiple |
| Party Site | Business Object | Optional | Multiple |
| Phone | Business Object | Optional | Multiple |
| Telex | Business Object | Optional | Multiple |
| Business Object | Optional | Multiple | |
| Web | Business Object | Optional | Multiple |
| EDI | Business Object | Optional | Multiple |
| EFT | Business Object | Optional | Multiple |
| Financial Report | Business Structure | Optional | Multiple |
| Preference | Granular Entity | Optional | Multiple |
| Relationship | Granular Entity | Optional | Multiple |
| Classification | Granular Entity | Optional | Multiple |
| Credit Rating | Granular Entity | Optional | Multiple |
| Certification | Granular Entity | Optional | Multiple |
| Financial Profile | Granular Entity | Optional | Multiple |
| Contact Preference | Granular Entity | Optional | Multiple |
| Organization Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| organization_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(1) |
| party_number | VARCHAR2(30) |
| validated_flag | VARCHAR2(1) |
| category_code | VARCHAR2(30) |
| salutation | VARCHAR2(60) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute24 | VARCHAR2(150) |
| organization_name | VARCHAR2(360) |
| duns_number_c | VARCHAR2(30) |
| enquiry_duns | VARCHAR2(15) |
| ceo_name | VARCHAR2(240) |
| ceo_title | VARCHAR2(240) |
| principal_name | VARCHAR2(240) |
| principal_title | VARCHAR2(240) |
| legal_status | VARCHAR2(30) |
| control_yr | NUMBER |
| employees_total | NUMBER |
| hq_branch_ind | VARCHAR2(30) |
| branch_flag | VARCHAR2(1) |
| oob_ind | VARCHAR2(30) |
| line_of_business | VARCHAR2(240) |
| cong_dist_code | VARCHAR2(2) |
| sic_code | VARCHAR2(30) |
| import_ind | VARCHAR2(30) |
| export_ind | VARCHAR2(30) |
| labor_surplus_ind | VARCHAR2(30) |
| debarment_ind | VARCHAR2(30) |
| minority_owned_ind | VARCHAR2(30) |
| minority_owned_type | VARCHAR2(30) |
| woman_owned_ind | VARCHAR2(30) |
| disadv_8a_ind | VARCHAR2(30) |
| small_bus_ind | VARCHAR2(30) |
| rent_own_ind | VARCHAR2(30) |
| debarments_count | NUMBER |
| debarments_date | DATE |
| failure_score | VARCHAR2(30) |
| failure_score_natnl_percentile | NUMBER |
| failure_score_override_code | VARCHAR2(30) |
| failure_score_commentary | VARCHAR2(30) |
| global_failure_score | VARCHAR2(5) |
| db_rating | VARCHAR2(5) |
| credit_score | VARCHAR2(30) |
| credit_score_commentary | VARCHAR2(30) |
| paydex_score | VARCHAR2(3) |
| paydex_three_months_ago | VARCHAR2(3) |
| paydex_norm | VARCHAR2(3) |
| best_time_contact_begin | DATE |
| best_time_contact_end | DATE |
| organization_name_phonetic | VARCHAR2(320) |
| tax_reference | VARCHAR2(50) |
| gsa_indicator_flag | VARCHAR2(1) |
| jgzz_fiscal_code | VARCHAR2(20) |
| analysis_fy | VARCHAR2(5) |
| fiscal_yearend_month | VARCHAR2(30) |
| curr_fy_potential_revenue | NUMBER |
| next_fy_potential_revenue | NUMBER |
| year_established | NUMBER |
| mission_statement | VARCHAR2(2000) |
| organization_type | VARCHAR2(30) |
| business_scope | VARCHAR2(20) |
| corporation_class | VARCHAR2(60) |
| known_as | VARCHAR2(240) |
| known_as2 to known_as5 | VARCHAR2(240) |
| local_bus_iden_type | VARCHAR2(30) |
| local_bus_identifier | VARCHAR2(60) |
| pref_functional_currency | VARCHAR2(30) |
| registration_type | VARCHAR2(30) |
| total_employees_text | VARCHAR2(60) |
| total_employees_ind | VARCHAR2(30) |
| total_emp_est_ind | VARCHAR2(30) |
| total_emp_min_ind | VARCHAR2(30) |
| parent_sub_ind | VARCHAR2(30) |
| incorp_year | NUMBER |
| sic_code_type | VARCHAR2(30) |
| public_private_ownership_flag | VARCHAR2(1) |
| internal_flag | VARCHAR2(30) |
| local_activity_code_type | VARCHAR2(30) |
| local_activity_code | VARCHAR2(30) |
| emp_at_primary_adr | VARCHAR2(10) |
| emp_at_primary_adr_text | VARCHAR2(12) |
| emp_at_primary_adr_est_ind | VARCHAR2(30) |
| emp_at_primary_adr_min_ind | VARCHAR2(30) |
| high_credit | NUMBER |
| avg_high_credit | NUMBER |
| total_payments | NUMBER |
| credit_score_class | NUMBER |
| credit_score_natl_percentile | NUMBER |
| credit_score_incd_default | NUMBER |
| credit_score_age | NUMBER |
| credit_score_date | DATE |
| credit_score_commentary2 to credit_score_commentary10 | VARCHAR2(30) |
| failure_score_class | NUMBER |
| failure_score_incd_default | NUMBER |
| failure_score_age | NUMBER |
| failure_score_date | DATE |
| failure_score_commentary2 to failure_score_commentary10 | VARCHAR2(30) |
| maximum_credit_recommendation | NUMBER |
| maximum_credit_currency_code | VARCHAR2(240) |
| displayed_duns_party_id | NUMBER |
| do_not_confuse_with | VARCHAR2(255) |
Related Topics
Organization Contact Business Object
Integration Features
This table shows the seeded integration features for the Organization Contact business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Organization Contact Business Object API | HZ_ORG_CONTACT_BO | HZ_ORG_CONTACT_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Person Information | Business Structure | Mandatory | Single |
| Contact Role | Granular Entity | Optional | Multiple |
| Party Site | Business Object | Optional | Multiple |
| Phone | Business Object | Optional | Multiple |
| Telex | Business Object | Optional | Multiple |
| Business Object | Optional | Multiple | |
| Web | Business Object | Optional | Multiple |
| SMS | Business Object | Optional | Multiple |
| Financial Report | Business Structure | Optional | Multiple |
| Contact Preference | Granular Entity | Optional | Multiple |
| Organization Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| org_contact_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| organization_id | NUMBER |
| comments | VARCHAR2(240) |
| contact_number | VARCHAR2(30) |
| department_code | VARCHAR2(30) |
| department | VARCHAR2(60) |
| title | VARCHAR2(30) |
| job_title | VARCHAR2(100) |
| decision_maker_flag | VARCHAR2(1) |
| job_title_code | VARCHAR2(30) |
| reference_use_flag | VARCHAR2(1) |
| rank | VARCHAR2(30) |
| party_site_id | NUMBER |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute24 | VARCHAR2(150) |
| relationship_code | VARCHAR2(30) |
| relationship_type | VARCHAR2(30) |
| relationship_comments | VARCHAR2(240) |
| start_date | DATE |
| end_date | DATE |
| relationship_status | VARCHAR2(1) |
Related Topics
Organization Customer Business Object
Integration Features
This table shows the seeded integration features for the Organization Customer business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Organization Customer Business Object API | HZ_ORG_CUST_BO | HZ_ORG_CUST_BO.create_object |
| Business Event |
|
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Organization | Business Object | Mandatory | Single |
| Customer Account | Business Object | Mandatory | Multiple |
Related Topics
Party Site Business Object
Integration Features
This table shows the seeded integration features for the Party Site business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Party Site Business Object API | HZ_PARTY_SITE_BO | HZ_PARTY_SITE_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Location | Business Structure | Mandatory | Single |
| Extensible Attributes – Party Site | Granular Entity | Optional | Multiple |
| Party Site Use | Granular Entity | Optional | Multiple |
| Phone | Business Object | Optional | Multiple |
| Telex | Business Object | Optional | Multiple |
| Business Object | Optional | Multiple | |
| Web | Business Object | Optional | Multiple |
| Contact Preference | Granular Entity | Optional | Multiple |
| Party Site Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| party_site_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(1) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| party_site_number | VARCHAR2(30) |
| mailstop | VARCHAR2(60) |
| identifying_address_flag | VARCHAR2(1) |
| party_site_name | VARCHAR2(240) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| language | VARCHAR2(4) |
| addressee | VARCHAR2(150) |
| global_location_number | VARCHAR2(40) |
Related Topics
Person Business Object
Integration Features
This table shows the seeded integration features for the Person business object.
| Type | Name | Code | Procedures |
|---|---|---|---|
| Object | Person Business Object API | HZ_PERSON_BO | HZ_PERSON_BO.create_object |
| Business Event |
|
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Extensible Attributes | Granular Entity | Optional | Multiple |
| Party Site | Business Object | Optional | Multiple |
| Phone | Business Object | Optional | Multiple |
| Business Object | Optional | Multiple | |
| Web | Business Object | Optional | Multiple |
| SMS | Business Object | Optional | Multiple |
| Employment History | Business Structure | Optional | Multiple |
| Preference | Granular Entity | Optional | Multiple |
| Relationship | Granular Entity | Optional | Multiple |
| Classification | Granular Entity | Optional | Multiple |
| Language | Granular Entity | Optional | Multiple |
| Education | Granular Entity | Optional | Multiple |
| Citizenship | Granular Entity | Optional | Multiple |
| Interest | Granular Entity | Optional | Multiple |
| Certification | Granular Entity | Optional | Multiple |
| Financial Profile | Granular Entity | Optional | Multiple |
| Contact Preference | Granular Entity | Optional | Multiple |
| Party Usage | Granular Entity | Optional | Multiple |
| Person Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| person_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(1) |
| party_number | VARCHAR2(30) |
| validated_flag | VARCHAR2(1) |
| category_code | VARCHAR2(30) |
| salutation | VARCHAR2(60) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute24 | VARCHAR2(150) |
| person_pre_name_adjunct | VARCHAR2(30) |
| person_first_name | VARCHAR2(150) |
| person_middle_name | VARCHAR2(60) |
| person_last_name | VARCHAR2(150) |
| person_name_suffix | VARCHAR2(30) |
| person_title | VARCHAR2(60) |
| person_academic_title | VARCHAR2(30) |
| person_previous_last_name | VARCHAR2(150) |
| person_initials | VARCHAR2(6) |
| known_as | VARCHAR2(240) |
| known_as2 | VARCHAR2(240) |
| known_as3 | VARCHAR2(240) |
| known_as4 | VARCHAR2(240) |
| known_as5 | VARCHAR2(240) |
| person_name_phonetic | VARCHAR2(320) |
| person_first_name_phonetic | VARCHAR2(60) |
| person_last_name_phonetic | VARCHAR2(60) |
| middle_name_phonetic | VARCHAR2(60) |
| tax_reference | VARCHAR2(50) |
| jgzz_fiscal_code | VARCHAR2(20) |
| person_iden_type | VARCHAR2(30) |
| person_identifier | VARCHAR2(60) |
| date_of_birth | DATE |
| place_of_birth | VARCHAR2(60) |
| date_of_death | DATE |
| deceased_flag | VARCHAR2(1) |
| gender | VARCHAR2(30) |
| declared_ethnicity | VARCHAR2(60) |
| marital_status | VARCHAR2(30) |
| marital_status_effective_date | DATE |
| personal_income | NUMBER |
| head_of_household_flag | VARCHAR2(1) |
| household_income | NUMBER |
| household_size | NUMBER |
| rent_own_ind | VARCHAR2(30) |
| last_known_gps | VARCHAR2(60) |
| internal_flag | VARCHAR2(2) |
Related Topics
Person Customer Business Object
Integration Features
This table shows the seeded integration features for the Person Customer business object.
| Type | Name | Code | Procedures |
|---|---|---|---|
| Object | Person Customer Business Object API | HZ_PERSON_CUST_BO | HZ_PERSON_CUST_BO.create_object |
| Business Event |
|
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Person | Business Object | Mandatory | Single |
| Customer Account | Business Object | Mandatory | Multiple |
Related Topics
Phone Business Object
Integration Features
This table shows the seeded integration features for the Phone business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Phone Business Object API | HZ_PHONE_CP_BO | HZ_PHONE_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| phone_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| phone_calling_calendar | VARCHAR2(30) |
| last_contact_dt_time | DATE |
| timezone_id | NUMBER |
| phone_area_code | VARCHAR2(10) |
| phone_country_code | VARCHAR2(10) |
| phone_number | VARCHAR2(40) |
| phone_extension | VARCHAR2(20) |
| phone_line_type | VARCHAR2(30) |
| raw_phone_number | VARCHAR2(60) |
Related Topics
SMS Business Object
Integration Features
This table shows the seeded integration features for the SMS business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | SMS Business Object API | HZ_SMS_CP_BO | HZ_SMS_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| sms_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| phone_calling_calendar | VARCHAR2(30) |
| last_contact_dt_time | DATE |
| timezone_id | NUMBER |
| phone_area_code | VARCHAR2(10) |
| phone_country_code | VARCHAR2(10) |
| phone_number | VARCHAR2(40) |
| phone_extension | VARCHAR2(20) |
| phone_line_type | VARCHAR2(30) |
| raw_phone_number | VARCHAR2(60) |
Related Topics
Telex Business Object
Integration Features
This table shows the seeded integration features for the Telex business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Telex Business Object API | HZ_TELEX_CP_BO | HZ_TELEX_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| telex_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| telex_number | VARCHAR2(50) |
Related Topics
Web Business Object
Integration Features
This table shows the seeded integration features for the Web business object.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Web Business Object API | HZ_WEB_CP_BO | HZ_WEB_CP_BO.create_object |
Embedded Items
This table shows the items embedded within the business object, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Contact Preference | Granular Entity | Optional | Multiple |
| Contact Point Source System Information | Optional | Multiple |
Attributes
The business object has attributes that describe the object at the root level, as well as attributes of embedded items. For the embedded business object attributes, see the documentation for the corresponding business objects. This table lists the root business object level attributes.
| Attribute | Data Type |
|---|---|
| web_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(30) |
| parent_object_type | VARCHAR2(30) |
| parent_object_id | NUMBER |
| primary_flag | VARCHAR2(1) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| contact_point_purpose | VARCHAR2(30) |
| primary_by_purpose | VARCHAR2(30) |
| web_type | VARCHAR2(60) |
| URL | VARCHAR2(2000) |
Related Topics
Contact Person Information Business Structure
Embedded Items
This table shows the items embedded within the business structure, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Extensible Attributes | Granular Entity | Optional | Multiple |
Attributes
The business structure has attributes that describe the structure at the root level, as well as attributes of embedded items. For the embedded business structure attributes, see the documentation for the corresponding business structures. This table lists the root business structure level attributes.
| Attribute | Data Type |
|---|---|
| person_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| party_number | VARCHAR2(30) |
| validated_flag | VARCHAR2(1) |
| status | VARCHAR2(1) |
| category_code | VARCHAR2(30) |
| salutation | VARCHAR2(60) |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute24 | VARCHAR2(150) |
| person_pre_name_adjunct | VARCHAR2(30) |
| person_first_name | VARCHAR2(150) |
| person_middle_name | VARCHAR2(60) |
| person_last_name | VARCHAR2(150) |
| person_name_suffix | VARCHAR2(30) |
| person_title | VARCHAR2(60) |
| person_academic_title | VARCHAR2(30) |
| person_previous_last_name | VARCHAR2(150) |
| person_initials | VARCHAR2(6) |
| known_as | VARCHAR2(240) |
| known_as2 | VARCHAR2(240) |
| known_as3 | VARCHAR2(240) |
| known_as4 | VARCHAR2(240) |
| known_as5 | VARCHAR2(240) |
| person_name_phonetic | VARCHAR2(320) |
| person_first_name_phonetic | VARCHAR2(60) |
| person_last_name_phonetic | VARCHAR2(60) |
| middle_name_phonetic | VARCHAR2(60) |
| tax_reference | VARCHAR2(50) |
| jgzz_fiscal_code | VARCHAR2(20) |
| person_iden_type | VARCHAR2(30) |
| person_identifier | VARCHAR2(60) |
| date_of_birth | DATE |
| place_of_birth | VARCHAR2(60) |
| date_of_death | DATE |
| deceased_flag | VARCHAR2(1) |
| gender | VARCHAR2(30) |
| declared_ethnicity | VARCHAR2(60) |
| marital_status | VARCHAR2(30) |
| marital_status_effective_date | DATE |
| personal_income | NUMBER |
| head_of_household_flag | VARCHAR2(1) |
| household_income | NUMBER |
| household_size | NUMBER |
| rent_own_ind | VARCHAR2(30) |
| last_known_gps | VARCHAR2(60) |
| internal_flag | VARCHAR2(2) |
Related Topics
Customer Account Site Use Business Structure
Integration Features
This table shows the seeded integration features for the Customer Account Site Use business structure.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Customer Account Site Use Business Structure Attributes | HZ_CUST_SITE_USE_BO | HZ_ACCT_SITE_USE_BO.create_object |
Embedded Items
This table shows the items embedded within the business structure, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Customer Profile | Business Structure | Optional | Single |
| Bank Account Use | Entity (not TCA) | Optional | Multiple |
| Payment Method | Entity (not TCA) | Optional | Single |
| Account Site Use Source System Information | Optional | Multiple |
Attributes
The business structure has attributes that describe the structure at the root level, as well as attributes of embedded items. For the embedded business structure attributes, see the documentation for the corresponding business structures. This table lists the root business structure level attributes.
| Attribute | Data Type |
|---|---|
| site_use_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| cust_acct_site_id | NUMBER |
| site_use_code | VARCHAR2(30) |
| primary_flag | VARCHAR2(1) |
| location | VARCHAR2(40) |
| bill_to_site_use_id | NUMBER |
| sic_code | VARCHAR2(30) |
| payment_term_id | NUMBER |
| gsa_indicator | VARCHAR2(1) |
| ship_partial | VARCHAR2(1) |
| ship_via | VARCHAR2(30) |
| fob_point | VARCHAR2(30) |
| order_type_id | NUMBER |
| price_list_id | NUMBER |
| freight_term | VARCHAR2(30) |
| warehouse_id | NUMBER |
| territory_id | NUMBER |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute25 | VARCHAR2(150) |
| tax_reference | VARCHAR2(50) |
| sort_priority | NUMBER |
| tax_code | VARCHAR2(50) |
| demand_class_code | VARCHAR2(30) |
| tax_header_level_flag | VARCHAR2(1) |
| tax_rounding_rule | VARCHAR2(30) |
| global_attribute1 to global_attribute20 | VARCHAR2(150) |
| global_attribute_category | VARCHAR2(30) |
| primary_salesrep_id | NUMBER |
| finchrg_receivables_trx_id | NUMBER |
| dates_negative_tolerance | NUMBER |
| dates_positive_tolerance | NUMBER |
| date_type_preference | VARCHAR2(20) |
| over_shipment_tolerance | NUMBER |
| under_shipment_tolerance | NUMBER |
| item_cross_ref_pref | VARCHAR2(30) |
| over_return_tolerance | NUMBER |
| under_return_tolerance | NUMBER |
| ship_sets_include_lines_flag | VARCHAR2(1) |
| arrivalsets_include_lines_flag | VARCHAR2(1) |
| sched_date_push_flag | VARCHAR2(1) |
| invoice_quantity_rule | VARCHAR2(30) |
| pricing_event | VARCHAR2(30) |
| gl_id_rec | NUMBER |
| gl_id_rev | NUMBER |
| gl_id_tax | NUMBER |
| gl_id_freight | NUMBER |
| gl_id_clearing | NUMBER |
| gl_id_unbilled | NUMBER |
| gl_id_unearned | NUMBER |
| gl_id_unpaid_rec | NUMBER |
| gl_id_remittance | NUMBER |
| gl_id_factor | NUMBER |
| tax_classification | VARCHAR2(30) |
| org_id | NUMBER |
Related Topics
Customer Profile Business Structure
Integration Features
This table shows the seeded integration features for the Customer Profile business structure.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Customer Profile Business Structure Attributes | HZ_CUSTOMER_PROFILE_BO | HZ_CUSTOMER_PROFILE_BO.create_object |
Embedded Items
This table shows the items embedded within the business structure, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Customer Profile Amount | Granular Entity | Optional | Multiple |
Attributes
The business structure has attributes that describe the structure at the root level, as well as attributes of embedded items. For the embedded business structure attributes, see the documentation for the corresponding business structures. This table lists the root business structure level attributes.
| Attribute | Data Type |
|---|---|
| cust_acct_profile_id | NUMBER |
| action_type | VARCHAR2(30) |
| last_update_date | DATE |
| common_obj_id | VARCHAR2(255) |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| cust_acct_id | NUMBER |
| collector_id | NUMBER |
| credit_analyst_id | NUMBER |
| credit_checking | VARCHAR2(1) |
| next_credit_review_date | DATE |
| tolerance | NUMBER |
| discount_terms | VARCHAR2(1) |
| dunning_letters | VARCHAR2(1) |
| interest_charges | VARCHAR2(1) |
| send_statements | VARCHAR2(1) |
| credit_balance_statements | VARCHAR2(1) |
| credit_hold | VARCHAR2(1) |
| profile_class_id | NUMBER |
| site_use_id | NUMBER |
| credit_rating | VARCHAR2(30) |
| risk_code | VARCHAR2(30) |
| standard_terms | NUMBER |
| override_terms | VARCHAR2(1) |
| interest_period_days | NUMBER |
| payment_grace_days | NUMBER |
| discount_grace_days | NUMBER |
| statement_cycle_id | NUMBER |
| account_status | VARCHAR2(30) |
| percent_collectable | NUMBER |
| autocash_hierarchy_id | NUMBER |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute15 | VARCHAR2(150) |
| auto_rec_incl_disputed_flag | VARCHAR2(1) |
| tax_printing_option | VARCHAR2(30) |
| charge_on_finance_charge_flag | VARCHAR2(1) |
| grouping_rule_id | NUMBER |
| clearing_days | NUMBER |
| jgzz_attribute_category | VARCHAR2(30) |
| jgzz_attribute1 to jgzz_attribute15 | VARCHAR2(150) |
| global_attribute1 to global_attribute20 | VARCHAR2(150) |
| global_attribute_category | VARCHAR2(30) |
| cons_inv_flag | VARCHAR2(1) |
| cons_inv_type | VARCHAR2(30) |
| autocash_hierarchy_id_for_adr | NUMBER |
| lockbox_matching_option | VARCHAR2(30) |
| review_cycle | VARCHAR2(30) |
| last_credit_review_date | DATE |
| credit_classification | VARCHAR2(30) |
| cons_bill_level | VARCHAR2(30) |
| late_charge_calculation_trx | VARCHAR2(30) |
| credit_items_flag | VARCHAR2(1) |
| disputed_transactions_flag | VARCHAR2(1) |
| late_charge_type | VARCHAR2(30) |
| late_charge_term_id | NUMBER |
| interest_calculation_period | VARCHAR2(30) |
| hold_charged_invoices_flag | VARCHAR2(1) |
| message_text_id | NUMBER |
| multiple_interest_rates_flag | VARCHAR2(1) |
| charge_begin_date | DATE |
Related Topics
Employment History Business Structure
Integration Features
This table shows the seeded integration features for the Employment History business structure.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Employment History Business Structure Attributes | HZ_EMPLOY_HIST_BO | HZ_EMPLOY_HIST_BO.create_object |
Embedded Items
This table shows the items embedded within the business structure, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Work Class | Granular Entity | Optional | Multiple |
Attributes
The business structure has attributes that describe the structure at the root level, as well as attributes of embedded items. For the embedded business structure attributes, see the documentation for the corresponding business structures. This table lists the root business structure level attributes.
| Attribute | Data Type |
|---|---|
| employment_history_id | NUMBER |
| action_type | VARCHAR2(30) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| status | VARCHAR2(1) |
| person_id | NUMBER |
| begin_date | DATE |
| end_date | DATE |
| employment_type_code | VARCHAR2(30) |
| employed_as_title_code | VARCHAR2(30) |
| employed_as_title | VARCHAR2(60) |
| employed_by_name_company | VARCHAR2(60) |
| employed_by_party_id | NUMBER |
| employed_by_division_name | VARCHAR2(60) |
| supervisor_name | VARCHAR2(60) |
| branch | VARCHAR2(80) |
| military_rank | VARCHAR2(240) |
| served | VARCHAR2(240) |
| station | VARCHAR2(240) |
| responsibility | VARCHAR2(240) |
| weekly_work_hours | NUMBER |
| reason_for_leaving | VARCHAR2(240) |
| faculty_position_flag | VARCHAR2(1) |
| tenure_code | VARCHAR2(30) |
| fraction_of_tenure | NUMBER |
| comments | VARCHAR2(2000) |
Related Topics
Financial Report Business Structure
Integration Features
This table shows the seeded integration features for the Financial Report Information business structure.
| Type | Name | Code | Procedure |
|---|---|---|---|
| API | Financial Report Business Structure Attributes | HZ_FINANCIAL_BO | HZ_FINANCIAL_BO.create_object |
Embedded Items
This table shows the items embedded within the business structure, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Financial Number | Granular Entity | Mandatory | Multiple |
Attributes
The business structure has attributes that describe the structure at the root level, as well as attributes of embedded items. For the embedded business structure attributes, see the documentation for the corresponding business structures. This table lists the root business structure level attributes.
| Attribute | Data Type |
|---|---|
| financial_report_id | NUMBER |
| action_type | VARCHAR2(30) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| status | VARCHAR2(1) |
| organization_id | NUMBER |
| type_of_financial_report | VARCHAR2(60) |
| document_reference | VARCHAR2(150) |
| date_report_issued | DATE |
| issued_period | VARCHAR2(60) |
| report_start_date | DATE |
| report_end_date | DATE |
| requiring_authority | VARCHAR2(60) |
| audit_ind | VARCHAR2(30) |
| consolidated_ind | VARCHAR2(30) |
| estimated_ind | VARCHAR2(30) |
| fiscal_ind | VARCHAR2(30) |
| final_ind | VARCHAR2(30) |
| forecast_ind | VARCHAR2(30) |
| opening_ind | VARCHAR2(30) |
| proforma_ind | VARCHAR2(30) |
| qualified_ind | VARCHAR2(30) |
| restated_ind | VARCHAR2(30) |
| signed_by_principals_ind | VARCHAR2(30) |
| trial_balance_ind | VARCHAR2(30) |
| unbalanced_ind | VARCHAR2(30) |
Related Topics
Location Business Structure
Integration Features
This table shows the seeded integration features for the Location business structure.
| Type | Name | Code | Procedure |
|---|---|---|---|
| Object | Location Business Structure Attributes | HZ_LOCATION_BO | HZ_LOCATION_BO.create_object |
Embedded Items
This table shows the items embedded within the business structure, as well as the defined rules for embedded items.
| Name | Embedded Type | Requirement | Instance |
|---|---|---|---|
| Extensible Attributes | Granular Entity | Optional | Multiple |
| Location Source System Information | Optional | Multiple |
Attributes
The business structure has attributes that describe the structure at the root level, as well as attributes of embedded items. For the embedded business structure attributes, see the documentation for the corresponding business structures. This table lists the root business structure level attributes.
| Attribute | Data Type |
|---|---|
| location_id | NUMBER |
| action_type | VARCHAR2(30) |
| orig_system | VARCHAR2(30) |
| orig_system_reference | VARCHAR2(255) |
| common_obj_id | VARCHAR2(255) |
| last_update_date | DATE |
| last_updated_by_name | VARCHAR2(100) |
| creation_date | DATE |
| created_by_name | VARCHAR2(100) |
| program_update_date | DATE |
| created_by_module | VARCHAR2(150) |
| actual_content_source | VARCHAR2(30) |
| country | VARCHAR2(60) |
| address1 | VARCHAR2(240) |
| address2 | VARCHAR2(240) |
| address3 | VARCHAR2(240) |
| address4 | VARCHAR2(240) |
| city | VARCHAR2(60) |
| postal_code | VARCHAR2(60) |
| state | VARCHAR2(60) |
| province | VARCHAR2(60) |
| county | VARCHAR2(60) |
| address_key | VARCHAR2(500) |
| address_style | VARCHAR2(30) |
| validated_flag | VARCHAR2(1) |
| address_lines_phonetic | VARCHAR2(560) |
| postal_plus4_code | VARCHAR2(10) |
| position | VARCHAR2(50) |
| location_directions | VARCHAR2(640) |
| address_effective_date | DATE |
| address_expiration_date | DATE |
| clli_code | VARCHAR2(60) |
| language | VARCHAR2(4) |
| short_description | VARCHAR2(240) |
| description | VARCHAR2(2000) |
| loc_hierarchy_id | NUMBER |
| sales_tax_geocode | VARCHAR2(30) |
| sales_tax_inside_city_limits | VARCHAR2(30) |
| fa_location_id | NUMBER |
| attribute_category | VARCHAR2(30) |
| attribute1 to attribute20 | VARCHAR2(150) |
| timezone_id | NUMBER |
| delivery_point_code | VARCHAR2(50) |
| geometry_status_code | VARCHAR2(30) |
| geometry | mdsys.sdo_geometry |
Related Topics