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. |
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 |