This appendix covers the following topics:
This appendix describes the tables and columns of Intercompany Open Interface tables.
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. |
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. |
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. |
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.