•FBDI Name : Cash Management External Transactions Import
•Import Process : Import External Transactions
•Interface Table : CE_EXT_TRX_INTERFACE
1.Download XLSM template file
2.Fill in the data and generate zip file
3.Upload the file using : Load Interface File For Import and Select the import Process : Import External Transactions (this step will perform Load and Import)
•Sample Values :
| Colum Name | Value |
| *Bank Account | BofA-2869 |
| *Amount | 175.00 |
| *Date | 30-10-2026 |
| Transaction Type | ACH |
| Business Unit | US1 Business Unit |
| *Account Transaction | Y |
| Cash Account Segment 1 | 101 |
| Cash GL Account Segment 2 | 10 |
| Cash Account Segment 3 | 11101 |
| Cash Account Segment 4 | 000 |
| Cash Account Segment 5 | 000 |
| Cash Account Segment 6 | 000 |
| Offset Account Segment 1 | 101 |
| Offset Account Segment 2 | 10 |
| Offset Account Segment 3 | 22185 |
| Offset Account Segment 4 | 000 |
| Offset Account Segment 5 | 000 |
| Offset Account Segment 6 | 000 |
SQL Query : CE_EXTERNAL_TRANSACTIONS is the table that stores successfully created External Cash Transactions.
SELECT
EXTERNAL_TRANSACTION_ID,
TRANSACTION_ID, BANK_ACCOUNT_ID,
BUSINESS_UNIT_ID, TRANSACTION_DATE,
AMOUNT, CURRENCY_CODE,
TRANSACTION_TYPE, STATUS,
SOURCE, ASSET_CCID,
OFFSET_CCID, REFERENCE_TEXT,
DESCRIPTION
FROM CE_EXTERNAL_TRANSACTIONS
ORDER BY CREATION_DATE DESC
For Live Demonstration – Please Watch the Video