1. Tables and Views for Financials
  2. FUN_TRX_HEADERS

FUN_TRX_HEADERS

This tables contains the transactions that make up an intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, and BATCH_ID together form a unique key. Each transaction is meant for one recipient however a batch can contain multiple transactions.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

FUN_TRX_HEADERS_PK

TRX_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
TRX_ID NUMBER 18 Yes Transaction identifier of the intercompany transaction.
TRX_NUMBER NUMBER Transaction number of the intercompany transaction.
INITIATOR_ID NUMBER 18 Yes Provider identifier of the intercompany transaction.
RECIPIENT_ID NUMBER 18 Yes Receiver identifier of the intercompany transaction.
TO_LE_ID NUMBER 18 Yes Receiver legal entity identifier.
TO_LEDGER_ID NUMBER 18 Intercompany receiver ledger identifier.
BATCH_ID NUMBER 18 Yes Identifier of the intercompany batch.
STATUS VARCHAR2 30 Yes Import status code of the intercompany interface distribution.
INIT_AMOUNT_CR NUMBER Intercompany provider credit amount.
INIT_AMOUNT_DR NUMBER Intercompany provider debit amount.
RECI_AMOUNT_CR NUMBER Intercompany receiver credit amount.
RECI_AMOUNT_DR NUMBER Intercompany receiver debit amount.
AR_INVOICE_NUMBER VARCHAR2 50 Receivables invoice number for the intercompany transaction.
INVOICE_FLAG VARCHAR2 1 Yes Invoice flag for the intercompany transaction.
APPROVER_ID NUMBER 18 Approver identifier for the intercompany transaction.
APPROVAL_DATE DATE Approval date of the intercompany transaction.
ORIGINAL_TRX_ID NUMBER 18 Original intercompany transaction identifier.
REVERSED_TRX_ID NUMBER 18 Reversed intercompany transaction identifier.
FROM_RECURRING_TRX_ID NUMBER 18 From recurring transaction identifier.
INITIATOR_INSTANCE_FLAG VARCHAR2 1 Provider organization instance flag.
RECIPIENT_INSTANCE_FLAG VARCHAR2 1 Receiver organization instance flag.
REJECT_REASON VARCHAR2 240 Rejection reason for the intercompany transaction.
DESCRIPTION VARCHAR2 240 Intercompany header description
INIT_WF_KEY VARCHAR2 240 Intercompany provider workflow key.
RECI_WF_KEY VARCHAR2 240 Intercompany receiver workflow key.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Intercompany Transaction Headers (FUN_TRX_HEADERS)
ERROR_REASON VARCHAR2 2000 Intercompany transaction error reason.
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.
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.
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_ID NUMBER 18 Receivables transaction type or credit memo type identifier.
INTERCO_TRX_NUMBER VARCHAR2 30 Transaction number of multitier intercompany transaction.
TRANSACTION_DATE DATE Transaction date of multitier intercompany transaction.
TRANSACTION_AMOUNT NUMBER Transaction amount of multitier intercompany transaction.
ACCOUNTING_DATE DATE Accounting date of multitier intercompany transaction.
TRANSACTION_CURRENCY_CODE VARCHAR2 15 Currency of multitier intercompany transaction. This is the currency in which the transaction is initiated.
EXCHANGE_RATE_TYPE VARCHAR2 30 Currency conversion type to convert transaction currency to the currency in which funds are received by the receiver organization.
EXCHANGE_RATE_DATE DATE Date of currency conversion from transaction currency to the currency in which funds are received by the receiver organization.
EXCHANGE_RATE NUMBER Rate of currency conversion from transaction currency to the currency in which funds are received by the receiver organization.
MASTER_INTERCO_TXN_FLAG VARCHAR2 1 Identifies whether the transaction originated from multitier master transaction flow.
DUE_TO_FROM_CURR_BASIS_CODE VARCHAR2 30 Basis for currency conversion from transaction currency defined for master document.
DUE_TO_FROM_CURR_CODE VARCHAR2 15 Currency in which an intercompany transaction is received by the receiver.
DUE_TO_FROM_AMOUNT NUMBER Transaction amount in due to or due from currency. This is the amount received by the receiver organization.
ROUTE_TYPE_CODE VARCHAR2 30 Identifies the stage of multitier transaction route based on intercompany organizations involved.
PREDECESSOR_TRX_NUMBER VARCHAR2 30 Transaction number of the preceding multitier intercompany transaction for a transaction route.
BILL_TO_LOCATION_ID NUMBER 18 Bill to customer site identifier.
SUPPLIER_SITE_ID NUMBER 18 Physical location of the intercompany supplier.
AR_CUSTOMER_TRX_ID NUMBER 18 Unique identifier for customer invoice.
AP_INVOICE_ID NUMBER 18 Unique identifier for supplier invoice.
PROVIDER_JE_HEADER_ID NUMBER 18 Journal entry header identifier of the provider.
RECEIVER_JE_HEADER_ID NUMBER 18 Journal entry header identifier of the receiver.
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_TRX_HEADERS fun_trx_batches BATCH_ID
FUN_TRX_HEADERS fun_interco_organizations INITIATOR_ID
FUN_TRX_HEADERS fun_interco_organizations RECIPIENT_ID
FUN_TRX_HEADERS gl_ledgers TO_LEDGER_ID
FUN_TRX_HEADERS xle_entity_profiles TO_LE_ID
FUN_TRX_HEADERS hz_cust_acct_sites_all BILL_TO_LOCATION_ID
FUN_TRX_HEADERS poz_supplier_sites_all_m SUPPLIER_SITE_ID
FUN_TRX_HEADERS ra_customer_trx_all AR_CUSTOMER_TRX_ID
FUN_TRX_HEADERS ap_invoices_all AP_INVOICE_ID
FUN_TRX_HEADERS gl_je_headers PROVIDER_JE_HEADER_ID
FUN_TRX_HEADERS gl_je_headers RECEIVER_JE_HEADER_ID
fun_trx_lines fun_trx_headers TRX_ID
fun_dist_lines fun_trx_headers TRX_ID

Indexes

Index Uniqueness Tablespace Columns Status
FUN_TRX_HEADERS_N1 Non Unique Default BATCH_ID Obsolete
FUN_TRX_HEADERS_N3 Non Unique Default RECIPIENT_ID
FUN_TRX_HEADERS_N4 Non Unique Default INITIATOR_ID
FUN_TRX_HEADERS_N5 Non Unique Default STATUS
FUN_TRX_HEADERS_N6 Non Unique Default INTERCO_TRX_NUMBER
FUN_TRX_HEADERS_N7 Non Unique Default PROVIDER_JE_HEADER_ID
FUN_TRX_HEADERS_N8 Non Unique Default RECEIVER_JE_HEADER_ID
FUN_TRX_HEADERS_N9 Non Unique Default AR_CUSTOMER_TRX_ID
FUN_TRX_HEADERS_N10 Non Unique Default AP_INVOICE_ID
FUN_TRX_HEADERS_U1 Unique Default TRX_ID
FUN_TRX_HEADERS_U2 Unique Default BATCH_ID, TRX_NUMBER