HZ_IMP_FINREPORTS_T
The interface table HZ_IMP_FINREPORTS_T stores information for population into HZ_FINANCIAL_REPORTS table.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FINREPORT_T_ID | NUMBER | 18 | Unique identifier of the HZ_IMP_FINREPORTS_T interface record. Internal use only. | ||
| INTERFACE_ROW_ID | NUMBER | 18 | Unique identifier of the HZ_IMP_FINREPORTS_T interface record. Internal use only. | ||
| BATCH_ID | NUMBER | 18 | Yes | Unique Identifier for a Batch | |
| PARTY_ORIG_SYSTEM | VARCHAR2 | 30 | Original System ID for the Party | ||
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original System Reference for the Party | ||
| FINREPORT_ORIG_SYSTEM | VARCHAR2 | 30 | Original System ID for the Financial Report | ||
| FINREPORT_ORIG_SYSTEM_REF | VARCHAR2 | 240 | Original System Reference for the Financial Report | ||
| FINANCIAL_REPORT_ID | NUMBER | 18 | Unique Identifier of the Financial Report | ||
| TYPE_OF_FINANCIAL_REPORT | VARCHAR2 | 60 | A name for the financial report. For example, 10K report, Annual Report, Shareholder's Special Report. | ||
| 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 | ||
| DATE_REPORT_ISSUED | DATE | The publication date of a financial report | |||
| ISSUED_PERIOD | VARCHAR2 | 60 | The period covered by the financial report. For example, fiscal year 1999, 1Q98, and so on. | ||
| REPORT_START_DATE | DATE | May use report start and end dates instead of ISSUED_PERIOD | |||
| REPORT_END_DATE | DATE | May use report start and end dates instead of ISSUED_PERIOD | |||
| INSERT_UPDATE_FLAG | VARCHAR2 | 1 | Indicates if a record should be explicitly inserted or updated | ||
| ACTION_FLAG | VARCHAR2 | 1 | Indicates the action of insert or update based on matching outcome. | ||
| PARTY_ID | NUMBER | 18 | Party that owns the financial report | ||
| AUDIT_IND | VARCHAR2 | 30 | Indicates if the financial reports are audited. Y for audited, N for unaudited. | ||
| CONSOLIDATED_IND | VARCHAR2 | 30 | Indicates if the financial reports are consolidated. Y for consolidated, N for unconsolidated | ||
| ESTIMATED_IND | VARCHAR2 | 30 | Indicates if the financial reports provide estimated data. Y for estimated, N for actual or measured data. | ||
| 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. | ||
| 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. | ||
| FORECAST_IND | VARCHAR2 | 30 | Indicates if the financial reports display forecasts or future projections. Y for forecast data, N for historical data | ||
| OPENING_IND | VARCHAR2 | 30 | Indicates if the financial reports are the opening statements for a business. Y for opening statements, N for normal operations | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| TRIAL_BALANCE_IND | VARCHAR2 | 30 | Indicates if the financial reports include trial balance numbers. Y for trial balance numbers, N for normal numbers. | ||
| 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. | ||
| INTERFACE_STATUS | VARCHAR2 | 30 | Status for the data in the interface table | ||
| ERROR_ID | NUMBER | 18 | Foreign Key to the Error Table | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 255 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | |||
| 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_FINREPORTS_T | hz_imp_batch_summary | BATCH_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_IMP_FINREPORTS_T_N1 | Non Unique | Default | BATCH_ID, FINANCIAL_REPORT_ID, INTERFACE_STATUS |
| HZ_IMP_FINREPORTS_T_N2 | Non Unique | Default | BATCH_ID, FINREPORT_ORIG_SYSTEM, FINREPORT_ORIG_SYSTEM_REF, INTERFACE_STATUS |
| HZ_IMP_FINREPORTS_T_N3 | Non Unique | Default | BATCH_ID, FILE_RECORD_NUM, INTERFACE_STATUS |
| HZ_IMP_FINREPORTS_T_N4 | Non Unique | Default | BATCH_ID, PARTY_NUMBER |
| HZ_IMP_FINREPORTS_T_N5 | Non Unique | Default | PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE |
| HZ_IMP_FINREPORTS_T_U1 | Unique | Default | FINREPORT_T_ID |