FUN_INTERFACE_HEADERS
Intercompany Transaction Headers interface.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
FUN_INTERFACE_HEADERS_PK |
TRX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRX_ID | NUMBER | 18 | Yes | Transaction identifier that is populated automatically for Oracle Cloud customers by the Load Interface File for Import program. Otherwise, use a positive integer. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Oracle Enterprise Scheduler: request identifier of the interface load job that created the row. | ||
| TRX_NUMBER | VARCHAR2 | 15 | Transaction number. Must be a unique, positive integer. | ||
| RECIPIENT_ID | NUMBER | 18 | Oracle internal use only. Recipient identifier. Use RECIPIENT_NAME instead. | ||
| RECIPIENT_NAME | VARCHAR2 | 360 | Recipient name. Use the Manage Intercompany Organizations task to identify valid values. | ||
| TO_LE_ID | NUMBER | 18 | Oracle internal use only. To legal entity identifier. Populated by Import Intercompany Transactions process, based on the RECIPIENT_NAME. | ||
| TO_LE_NAME | VARCHAR2 | 30 | To legal entity name. Use the Manage Intercompany Organizations task to identify valid values. Populated by the Import Intercompany Transactions process, based on the RECIPIENT_NAME. | ||
| TO_LEDGER_ID | NUMBER | 18 | To ledger identifier. Populated by the Import Intercompany Transactions process, based on the RECIPIENT_NAME. | ||
| BATCH_ID | NUMBER | 18 | Yes | Batch identifier that is populated automatically for Oracle Cloud customers. Otherwise, use a positive integer. | |
| INIT_AMOUNT_CR | NUMBER | Credit amount for the intercompany transaction. You cannot populate both INIT_AMOUNT_DR and INIT_AMOUNT_CR. They are mutually exclusive. | |||
| INIT_AMOUNT_DR | NUMBER | Debit amount for the intercompany transaction. You cannot populate both INIT_AMOUNT_DR and INIT_AMOUNT_CR. They are mutually exclusive. | |||
| INVOICING_RULE_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. Invoicing rule option. | |
| FROM_RECURRING_TRX_ID | NUMBER | 18 | Oracle internal use only. From recurring transaction identifier. | ||
| INITIATOR_INSTANCE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Initiator instance option. | ||
| RECIPIENT_INSTANCE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Recipient instance option. | ||
| DESCRIPTION | VARCHAR2 | 240 | Description of intercompany transaction. Free text field. Not validated. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Segment value: Intercompany Transaction Headers descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Intercompany Transaction Headers descriptive flexfield. Use the Manage Intercompany Descriptive Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE15 for segment values. | ||
| 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. | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 15 | Oracle internal use only. Import status code. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is increased every time 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. | |
| 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_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. | |||
| AR_INV_CM_TRX_TYPE_NAME | VARCHAR2 | 20 | Receivables transaction type for intercompany transactions that requires invoicing. Use the Manage Intercompany Receivables Assignment task to identify valid values. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Classification used by a tax authority to categorize a document associated with a transaction for a tax. Use the Manage Document Fiscal Classification Codes task to identify valid values. | ||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Product classification used by tax authority. Use Manage Product Fiscal Classification Type Group task to identify valid values. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Product fiscal classification that is used for tax purposes such as tax determination and reporting for non inventory items. Use the Manage Product Category Fiscal Classification Codes task to identify valid values. | ||
| PRODUCT_TYPE | VARCHAR2 | 240 | Product type. Valid values are GOODS and SERVICES. | ||
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Default tax classification code for this transaction. | ||
| LINE_INTENDED_USE | VARCHAR2 | 240 | Tax classification based upon the product purpose. Use the Manage Intended Use Fiscal Classification task to identify valid values. | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FUN_INTERFACE_HEADERS | fun_interface_batches | BATCH_ID |
| fun_interface_rejections | fun_interface_headers | TRX_ID |
| fun_interface_dist_lines | fun_interface_headers | TRX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_INTERFACE_HEADERS_N1 | Non Unique | Default | BATCH_ID |
| FUN_INTERFACE_HEADERS_U1 | Unique | Default | TRX_ID |