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.