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

HZ_FINANCIAL_REPORTS

The HZ_FINANCIAL_REPORTS table stores information about the reports on the financial status of a party. This table does not contain numerical financial data. Detailed numerical data is available in the HZ_FINANCIAL_NUMBERS table. For example, the records in this table can indicate whether the numerical data in the HZ_FINANCIAL_NUMBERS table are actual, estimated, consolidated, and so on.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_FINANCIAL_REPORTS_PK

FINANCIAL_REPORT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
FINANCIAL_REPORT_ID NUMBER 18 Yes Unique identifier for a Financial report. Primary Key for the HZ_FINANCIAL_REPORTS table.
DATE_REPORT_ISSUED DATE The publication date of a financial report. Active
DOCUMENT_REFERENCE VARCHAR2 150 Any specific reference name or number. For example, a library identifier or publisher's identifier (ISBN) that uniquely identifies the document or publication. Active
ISSUED_PERIOD VARCHAR2 60 The period covered by the financial report. For example, fiscal year 1999, 1Q98, and so on. Active
REQUIRING_AUTHORITY VARCHAR2 60 Name of the primary organization that requires this financial report. For example, auditors, the Federal Trade Commission, and the Internal Revenue Service. Active
TYPE_OF_FINANCIAL_REPORT VARCHAR2 60 A name for the financial report. For example, 10K report, Annual Report, Shareholder's Special Report. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
WH_UDPATE_ID DATE Date when the record was entered or changed in a data warehouse Active
PARTY_ID NUMBER 18 Yes Party identifier. Foreign key to the HZ_PARTIES table
REPORT_START_DATE DATE May use report start and end dates instead of ISSUED_PERIOD. Active
REPORT_END_DATE DATE May use report start and end dates instead of ISSUED_PERIOD. Active
AUDIT_IND VARCHAR2 30 Indicates if the financial reports are audited. Y for audited, N for unaudited. Active
CONSOLIDATED_IND VARCHAR2 30 Indicates if the financial reports are consolidated. C for consolidated, N for unconsolidated. Active
ESTIMATED_IND VARCHAR2 30 Indicates if the financial reports provide estimated data. Y for estimated, N for actual or measured data. Active
FISCAL_IND VARCHAR2 30 Indicates if the financial reports cover a fiscal twelve-month accounting period. Y for a twelve-month fiscal period, N for anything other than a twelve-month fiscal period. Active
FINAL_IND VARCHAR2 30 Indicates if the financial reports are the final closing statements for a business that has ceased operations. Y for final closing statements, N for normal operations. Active
FORECAST_IND VARCHAR2 30 Indicates if the financial reports display forecasts or future projections. Y for forecast data, N for historical data. Active
OPENING_IND VARCHAR2 30 Indicates if the financial reports are the opening statements for a business. Y for opening statements, N for normal operations. Active
PROFORMA_IND VARCHAR2 30 Indicates if the financial reports are pro forma numbers. Y for pro forma numbers, N for normal numbers.
QUALIFIED_IND VARCHAR2 30 Indicates if the financial reports include qualifying remarks from auditors about the fairness and accuracy of the numbers. Y for reports qualified by auditors, N for reports that were not qualified. Active
RESTATED_IND VARCHAR2 30 Indicates if the financial reports include data that was corrected after the original financial reports. Y for restated, N for the original numbers. Active
SIGNED_BY_PRINCIPALS_IND VARCHAR2 30 Indicates if the financial reports were signed by the principals of the organization. Y for signed reports, N for unsigned reports. Active
TRIAL_BALANCE_IND VARCHAR2 30 Indicates if the financial reports include trial balance numbers. Y for trial balance numbers, N for normal numbers. Active
UNBALANCED_IND VARCHAR2 30 Indicates if the financial reports include balance sheet accounts that do not balance. Y for reports that include unbalanced balance sheet accounts. N for reports that only include balanced accounts. Active
STATUS VARCHAR2 1 Record status flag Active
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. Active
CREATED_BY_MODULE VARCHAR2 30 TCA Who column Active
ACTUAL_CONTENT_SOURCE VARCHAR2 30 Additional Content Source Type column for backward compatibility. Active
CONFLICT_ID NUMBER 18 Yes Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). Active
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). 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
CPDRF_VER_SOR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows.
CPDRF_VER_PILLAR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows
CPDRF_LAST_UPD VARCHAR2 15 Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_FINANCIAL_REPORTS hz_parties PARTY_ID
hz_financial_numbers hz_financial_reports FINANCIAL_REPORT_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_FINANCIAL_REPORTS_N1 Non Unique Default LAST_UPDATE_DATE, FINANCIAL_REPORT_ID
HZ_FINANCIAL_REPORTS_PK Unique Default FINANCIAL_REPORT_ID
HZ_FINANCIAL_REPORTS_U1 Unique Default PARTY_ID, TYPE_OF_FINANCIAL_REPORT, DOCUMENT_REFERENCE, DATE_REPORT_ISSUED, ISSUED_PERIOD, REPORT_START_DATE, REPORT_END_DATE, ACTUAL_CONTENT_SOURCE, CONFLICT_ID