| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Amount | The amount of revenue authorized for the agreement. | External Cash Transactions.Amount | AMOUNT | AMOUNT | 115861 |
| Bank Account Name | | External Cash Transactions.Bank Account Name | BANK_ACCOUNT_NAME | BANK_ACCOUNT_NAME | 119027 |
| Bank Account Number | | External Cash Transactions.Bank Account Number | BANK_ACCOUNT_NUMBER | BANK_ACCOUNT_NUMBER | 119043 |
| Charges | Any charges applicable to this external transaction. | External Cash Transactions.Charges | CHARGES | CHARGES | 121906 |
| Cleared Amount | Payment cleared amount. | External Cash Transactions.Cleared Amount | CLEARED_AMOUNT | CLEARED_AMOUNT | 122139 |
| Created By | Standard WHO column. | External Cash Transactions.Created By | CREATED_BY | CREATED_BY | 124573 |
| Created Date | Standard WHO column. | External Cash Transactions.Created Date | CREATED_DATE | CREATED_DATE | 125372 |
| Currency Code | Currency code for pricelist; FK to gl_curr_mst. | External Cash Transactions.Currency Code | CURRENCY_CODE | CURRENCY_CODE | 126998 |
| Exchange Rate | Currency exchange rate used for converting the source transactionamount to the forecast currency amount for the 'User' exchange ratetype. | External Cash Transactions.Exchange Rate | EXCHANGE_RATE | EXCHANGE_RATE | 133788 |
| Exchange Rate Date | Currency exchange rate date used for converting the transaction amountto the functional amount. | External Cash Transactions.Exchange Rate Date | EXCHANGE_RATE_DATE | EXCHANGE_RATE_DATE | 133794 |
| Exchange Rate Type | Currency exchange rate type used for converting the sourcetransaction amount to the forecast currency amount. | External Cash Transactions.Exchange Rate Type | EXCHANGE_RATE_TYPE | EXCHANGE_RATE_TYPE | 133804 |
| GL Date | GL accounting date used for distribution entries created for theexternal transaction. | External Cash Transactions.GL Date | GL_DATE | GL_DATE | 135217 |
| GL Date - Day | | External Cash Transactions.GL Date | | GL_DATE_DAY | 180869 |
| GL Date - Month | | External Cash Transactions.GL Date | | GL_DATE_MONTH | 180879 |
| GL Date - Quarter | | External Cash Transactions.GL Date | | GL_DATE_QUARTER | 180889 |
| GL Date - Year | | External Cash Transactions.GL Date | | GL_DATE_YEAR | 180899 |
| Last Updated By | Standard WHO column. | External Cash Transactions.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139199 |
| Last Updated Date | Standard WHO column. | External Cash Transactions.Last Updated Date | LAST_UPDATED_DATE | LAST_UPDATED_DATE | 139949 |
| Status | Status of the external cash transaction. | External Cash Transactions.Status | STATUS | STATUS | 163491 |
| Transaction Date | | External Cash Transactions.Transaction Date | TRANSACTION_DATE | TRANSACTION_DATE | 165640 |
| Transaction Date - Day | | External Cash Transactions.Transaction Date | | TRANSACTION_DATE_DAY | 192321 |
| Transaction Date - Month | | External Cash Transactions.Transaction Date | | TRANSACTION_DATE_MONTH | 192375 |
| Transaction Date - Quarter | | External Cash Transactions.Transaction Date | | TRANSACTION_DATE_QUARTER | 192429 |
| Transaction Date - Year | | External Cash Transactions.Transaction Date | | TRANSACTION_DATE_YEAR | 192483 |
| Transaction Id | External payment/receipt identifier. | External Cash Transactions.Transaction Id | TRANSACTION_ID | TRANSACTION_ID | 165689 |
| Transaction Number | | External Cash Transactions.Transaction Number | TRANSACTION_NUMBER | TRANSACTION_NUMBER | 165761 |
| Transaction Type | Type of the external cash transaction, either payment or receipt. | External Cash Transactions.Transaction Type | TRANSACTION_TYPE | TRANSACTION_TYPE | 165840 |