Skip Headers

Oracle Advanced Global Intercompany System User's Guide
Release 12.1
Part Number E12794-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Intercompany Open Interface Tables

This appendix covers the following topics:

Open Interface Tables

This appendix describes the tables and columns of Intercompany Open Interface tables.

FUN_INTERFACE_CONTROLS Table

The following table describes selected fields in the FUN_ INTERFACE_CONTROLS table.

Column Name Description
Group_id Based on the sequence fun_interface_controls_s.
Source Free text to identify the source of the external system from which records are imported.

Note: Source and Group_ID form the unique key.

Request_id Updated by the Import process.
Date_Processed Updated by the Import process.

FUN_INTERFACE_BATCHES Table

The following table describes selected fields in the FUN_INTERFACE_BATCHES table.

Column Name Description
Source Enter text to identify the external system source from which records are imported. This value must match with the Source column in the fun_interface_controls table.
Group_id Logical grouping of the batches. This value must match with the Group_id column in the fun_interface_controls table.
Batch_id Based on the sequence fun_trx_batches_s.
Batch_Number Unique for an initiator.
Initiator_id The ID of the intercompany organization that initiated the batch. You must provide either the initiator ID or the initiator name.
Initiator_Name The name of the party. You must provide either the initiator ID or the initiator name.
From_Le_id The initiator legal entity. If you do not enter a value, the From_Le_id is derived from the initiator_id column by the Import process.
From_Le_Name The name of the initiator legal entity. If you do not enter a value, the From_Le_Name is derived from the initiator_id column by the Import process.
From_Ledger_Id If you do not enter a value, the From_Ledger_id is derived from the From_Le_Id by the Import process.
Control_Total Enter an amount to indicate the amount the batch total should be.

Note: This column is used as a placeholder and it is NOT the total of all the transaction amounts in the batch.

Running_Total_Cr The sum of all the transaction credit amounts in the batch.

Note: A batch must have all credits or all debit amounts. It cannot have both.

Running_Total_Dr The sum of all the transaction credit amounts in the batch.

Note: A batch must have all credits or all debit amounts. It cannot have both.

Currency_Code The batch currency. Transactions in a batch must be in the same currency.
Exchange_Rate_Type Enter the exchange rate if the batch is not in the currency specified by the initiator.
Description The description that is passed to the general ledger or receivables of the initiator as the journal or invoice description.
Trx_Type_Id The transaction type of this batch. All transactions in a batch must be the same.
You must enter a value for either the trx_type_id or trx_type_name or trx_type_code.
Trx_Type_Name Name of the transaction.
You must enter a value for either the trx_type_id or trx_type_name or trx_type_code.
Trx_Type_Code Transaction type code of this batch. All transactions in a batch must be of the same type.
You must enter a value for either the trx_type_id or trx_type_name or trx_type_code.
Gl_Date The General Ledger date of the batch.
Batch_Date The date the batch is entered.
Reject_Allow_Flag Indicates whether the transactions in this batch can be rejected.
From_recurring_batch_id Used for transactions upgraded from Global Intercompany System.
Import_Status_Code The import program populates the import status. The status is Accepted or Rejected.

FUN_INTERFACE_HEADERS Table

The following table describes selected fields in the FUN_INTERFACE_HEADERS table.

Field Description
Trx_id Based on the sequence FUN_TRX_HEADERS_S.
Trx_Number Unique transaction number.
Recipient_id The ID of the intercompany organization that is the recipient of this transaction.
You must either provide the recipient_id or recipient_name.
Recipient_Name The name of the party.
You must either provide the recipient_id or recipient_name.
To_Le_id The recipient legal entity. If you do not enter a value, the To_Le_id is derived from the Recipient_id by the Import process.
To_Ledger_Id The recipient ledger ID. If you do not enter a value, the To_Ledger_Id is derived from the To_Le_id by the Import process.
To_Le_Name The name of the recipient legal entity.
Batch_id The batch ID.
Invoicing_Rule_Flag Y indicates an invoice is required for the transaction. N indicates that the transaction must be sent to General Ledger. This field is validated and derived by the import process based on the setup.
From_Recurring_Trx_Id Used for transactions upgraded from the Global Intercompany System.
Initiator_Instance_Flag Validates if the initiator is present in the same instance.
Recipient_Instance_Flag Validates if the recipient is present in the same instance.
Description The description that is used for the recipient's General Ledger transactions and Payables invoices.
Import_Status_Code The import program populates the import status. The status is Accepted or Rejected.

FUN_INTERFACE_DIST_LINES Table

The following table describes selected fields in the FUN_INTERFACE_DIST_LINES table.

Field Description
Trx_id The Trx_Id from fun_interface_headers.
Dist_id Based on the sequence FUN_INTERFACE_DIST_LINES_S.
Party_id The initiator or recipient ID.
Party_Type_Flag The initiator distributions will have party_type_flag as I and the recipient distributions will have party_type_flag as R.
Dist_Type_Flag Must have the value L.
Import_Status_Code The import program populates the import status. The status is Accepted or Rejected.

Note: The initiator distributions will have party_type_flag as I, and the dist_type_flag as L and the recipient distributions will have party_type_flag as R, and the dist_type_flag as L.