My Cash Management Table Descriptions hand book (I have big hands)

Cash Management - CE_STATEMENT_HEADERS_ALL	Bank statements
Column Name	Descritpion
STATEMENT_HEADER_ID	Statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	Organization identifier
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Document number
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
STATEMENT_DATE	Statement date
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_STATEMENT_LINES	Bank statement lines
Column Name	Descritpion
STATEMENT_LINE_ID	System-assigned statement line identifier
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
TRX_CODE_ID	Bank transaction code identifier
EFFECTIVE_DATE	Statement line effective date, used to update AR receipt's clearing date
BANK_TRX_NUMBER	Transaction number that identifies the transaction to be matched against the statement line
CE_STATEMENT_LINES	No Longer Used
TRX_TEXT	Statement line description
CUSTOMER_TEXT	Customer number for finding available transactions by customer numbers
INVOICE_TEXT	Invoice number for finding available transactions by invoice number
BANK_ACCOUNT_TEXT	Supplier/customer bank account number for finding available transactions by supplier/customer numbers
CURRENCY_CODE	Statement line currency code
EXCHANGE_RATE_TYPE	Currency conversion rate type
EXCHANGE_RATE	Currency conversion rate
EXCHANGE_RATE_DATE	Date used in determining the currency exchange rate
STATEMENT_HEADER_ID	Statement header identifier
ORIGINAL_AMOUNT	Statement line amount in currency code
CHARGES_AMOUNT	Bank charges amount
LAST_UPDATE_LOGIN	Standard WHO column
RECONCILE_TO_STATEMENT_FLAG	Flag to indicate whether this statement line is reconciled to another statement line, Y or Null
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
LINE_NUMBER	Statement line number
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
JE_STATUS_FLAG	Flag to indicate the status of the journal entry forthis statement line. (C-JE Created S-Success E-Error)
ACCOUNTING_DATE	The accounting date as entered in the JE that is created by the statement line
GL_ACCOUNT_CCID	The CCID of the GL account for which this statement line has created a journal entry
REFERENCE_TXT	The reference string as populated for the JE.
TRX_CODE	Transaction Code
TRX_DATE	Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
CASHFLOW_ID	Cashflow Identifier
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
TRX_TYPE	Transaction type, lookup type BANK_TRX_TYPE
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
AMOUNT	Statement line amount
STATUS	Statement line status, lookup type STATEMENT_LINE_STATUS
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Cash Management - CE_STATEMENT_RECONCILS_ALL	Statement reconciliation details
Column Name	Descritpion
STATEMENT_LINE_ID	Statement line identifier
STATUS_FLAG	Reconciliation status flag, M for matched or U for unmatched
ACTION_FLAG	No longer used
CURRENT_RECORD_FLAG	Flag to indicate whether this record is for the latest reconciliation action or not, Y or N
AUTO_RECONCILED_FLAG	Flag to indicate whether the reconciliation action was performed by an Autoreconciliation process or not, Y or N
AMOUNT	Actual reconciled amount for the statement line
REQUEST_ID	Standard WHO column
PROGRAM_APPLICATION_ID	Standard WHO column
PROGRAM_ID	Standard WHO column
PROGRAM_UPDATE_DATE	Standard WHO column
LEGAL_ENTITY_ID	Legal Entity Identifier
REFERENCE_TYPE	Specifies transaction type to be matched, either PAYMENT, RECEIPT, JE_LINE, or STATEMENT
REFERENCE_ID	Reference identifier; AP_CHECKS_ALL.check_id, AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id, GL_JE_LINES.je_line, or CE_STATEMENT_LINES.statement_line_id
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
JE_HEADER_ID	Journal entry header identifier
ORG_ID	Organization identifier
REFERENCE_STATUS	Latest status of the referenced transaction

Cash Management - CE_SYSTEM_PARAMETERS_ALL	System options
Column Name	Descritpion
SET_OF_BOOKS_ID	Set of books identifier
RECEIVABLES_TRX_ID	Receivable transaction identifier
DIFFERENCES_ACCOUNT	Code to indicate how to handle any amount differences between statement line and AP transaction during the automatic reconciliation process, lookup type DIFFERENCE_ACCOUNT
FOREIGN_DIFFERENCE_HANDLING	Code to indicate how to handle amount differencesdue to currency exchange rate changes duringthe automatic reconciliation process, G for treatin them as currency gain or loss, C for handling themas errors or charges, N for no action
LINES_PER_COMMIT	Number of statement lines to be automatically reconciled before a commit is issued
ORG_ID	Organization identifier
AP_MATCHING_ORDER	Order of matching statement lines to AP transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX
AR_MATCHING_ORDER	Order of matching statement lines to AR transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX
LAST_UPDATE_LOGIN	Standard WHO column
FLOAT_HANDLING_FLAG	Flag to indicate how to handle statement lines with effective date being later than today; E for error or I for ignore
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
CASHBOOK_BEGIN_DATE	Date from which to show transactions
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
CREATED_BY	Standard WHO column
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
SHOW_VOID_PAYMENT_FLAG	Flag to specify whether or not to display void payment as available for reconciliation.
OPEN_INTERFACE_MATCHING_CODE	Open interface transactions matching code, T for matching by transaction number, D for matching by date and amount.
EXCHANGE_RATE_TYPE	Exchange rate type defaulted for foreign currency bank.
EXCHANGE_RATE_DATE	Exchange rate date defaulted for foreign currency bank.
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
SHOW_CLEARED_FLAG	Flag to specify whether or not to include cleared but not reconciled transactions as available transactions for matching, Y or N
INTERFACE_PURGE_FLAG	Flag to indicate whether or not to purge data from the interface tables after a successful import of the data into the blank statement tables
INTERFACE_ARCHIVE_FLAG	Flag to indicate whether or not to archive data from the interface tables while purging them after a successful import of the data into the statement tables, Y or N
LINE_AUTOCREATION_FLAG	Flag to indicate whether or not to allow addition of statement lines when statements are created automatically, Y or N
ENABLE_OPEN_INTERFACE_FLAG	Flag to indicate whether to allow reconciliation of statement lines to open interface transactions, Y or N
OPEN_INTERFACE_FLOAT_STATUS	Code to specify the float status for open interface transactions
OPEN_INTERFACE_CLEAR_STATUS	Code to specify cleared status for open interface transactions
AMOUNT_TOLERANCE	Tolerance amount limit to be used during the automatic reconciliation
PERCENT_TOLERANCE	Tolerance percent to be used during the automatic reconciliation

Cash Management - CE_TRANSACTION_CODES	Bank transaction codes
Column Name	Descritpion
TRANSACTION_CODE_ID	System-assigned transaction code identifier
RECEIVABLES_TRX_ID	Receivables activity identifier
RECEIPT_METHOD_ID	Receipt class payment method identifier
CREATE_MISC_TRX_FLAG	Flag to indicate whether miscellaneous transactions can be created for this transaction code, Y or N
RECONCILE_FLAG	No longer used
FLOAT_DAYS	Number of days that it will take to clear transactions by bank
MATCHING_AGAINST	Matching order against miscellaneous transactions and/or statement line, lookup type CORRECTION_MATCHING
CORRECTION_METHOD	Correction method reversal or adjustment, lookup type CORRECTION_METHOD
START_DATE	Date the bank transaction code becomes effective
END_DATE	Last date the bank transaction code stays effective
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
LAST_UPDATE_LOGIN	Standard WHO column
TRX_CODE	Transaction code issued by the bank
PAYROLL_PAYMENT_FORMAT_ID	Payroll Payment Format Identifier
RECONCILIATION_SEQUENCE	Reconciliation Sequence
REQUEST_ID	Concurrent Program Request Id which poplulated the transaction code
TRX_TYPE	Transaction type, lookup type BANK_TRX_TYPE
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
DESCRIPTION	Description

Cash Management - CE_HEADER_INTERFACE_ERRORS	CE_STATEMENT_HEADERS_INT_ALL validation errors
Column Name	Descritpion
STATEMENT_NUMBER	Statement number
BANK_ACCOUNT_NUM	Bank account number
MESSAGE_NAME	Message name
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
APPLICATION_SHORT_NAME	Application short name, CE

Cash Management - CE_LINE_INTERFACE_ERRORS	CE_STATEMENT_LINES_INTERFACE validation errors
Column Name	Descritpion
STATEMENT_NUMBER	Statement number
BANK_ACCOUNT_NUM	Bank account number
LINE_NUMBER	Statement line number
MESSAGE_NAME	Message name
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
APPLICATION_SHORT_NAME	Application short name, CE

Cash Management - CE_RECONCILIATION_ERRORS	CE_STATEMENT_LINES validation and reconciliation errors
Column Name	Descritpion
STATEMENT_LINE_ID	Statement line identifier
MESSAGE_NAME	Message name
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
APPLICATION_SHORT_NAME	Application short name, CE
STATEMENT_HEADER_ID	Statement header identifier

Cash Management - CE_STATEMENT_HEADERS_INT_ALL	Open interface for bank statements
Column Name	Descritpion
STATEMENT_NUMBER	Statement number
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CONTROL_LINE_COUNT	Total line count of the statement that can be compared to the actual number of lines entered for control purposes
RECORD_STATUS_FLAG	Statement upload status, lookup type HEADER_INTERFACE_STATUS
CURRENCY_CODE	Bank statement currency code
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
BANK_ACCOUNT_NUM	Bank account number
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
STATEMENT_DATE	Statement date
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ORG_ID	Organization identifier
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
INTRA_DAY_FLAG	Flag to indicate whether this statement is an Intra-Day statement or not
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
BANK_NAME	Bank name
BANK_BRANCH_NAME	Bank branch name
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purposes
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purposes
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purposes
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)

Cash Management - CE_STATEMENT_LINES_INTERFACE	Open interface for bank statement lines
Column Name	Descritpion
BANK_ACCOUNT_NUM	Bank account number
CURRENCY_CODE	Statement line currency code
USER_EXCHANGE_RATE_TYPE	Currency conversion rate type
EXCHANGE_RATE_DATE	Statement line effective date, used to update AR receipt's clearing date
EXCHANGE_RATE	Currency conversion rate
ORIGINAL_AMOUNT	Statement line amount in currency code
CHARGES_AMOUNT	Bank charges amount
BANK_TRX_NUMBER	Transaction number that identifies the transaction to be matched against the statement line
CUSTOMER_TEXT	Customer number for finding available transactions by customer numbers
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
LINE_NUMBER	Statement line number
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
TRX_DATE	Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
TRX_CODE	Bank transaction code
EFFECTIVE_DATE	Statement line effective date, used to update AR receipt's clearing date
TRX_TEXT	Statement line description
INVOICE_TEXT	Invoice number for finding available transactions by invoice numbers
BANK_ACCOUNT_TEXT	Supplier/customer bank account number for finding available transactions by supplier/customer bank account numbers
AMOUNT	Statement line amount

Cash Management - CE_ARCH_RECON_ERRORS	Archived CE_RECONCILIATION_ERRORS records
Column Name	Descritpion
STATEMENT_LINE_ID	Statement line identifier
MESSAGE_NAME	Message name
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
APPLICATION_SHORT_NAME	Application short name, CE
STATEMENT_HEADER_ID	Statement header identifier

Cash Management - CE_ARCH_RECONCILIATIONS_ALL	Archived CE_STATEMENT_RECONCILS_ALL records
Column Name	Descritpion
STATEMENT_LINE_ID	Statement line identifier
STATUS_FLAG	Reconciliation status flag, M for matched or U for unmatched
ACTION_FLAG	No longer used
CURRENT_RECORD_FLAG	Flag to indicate whether this record is for the latest reconciliation action or not, Y or N
AUTO_RECONCILED_FLAG	Flag to indicate whether the reconciliation action was performed by an Autoreconciliation process or not, Y or N
REQUEST_ID	Standard WHO column
PROGRAM_APPLICATION_ID	Standard WHO column
PROGRAM_ID	Standard WHO column
PROGRAM_UPDATE_DATE	Standard WHO column
AMOUNT	Actual reconciled amount for the statement line
LEGAL_ENTITY_ID	Legal Entity Identifier
REFERENCE_TYPE	Specifies transaction type being matched, either PAYMENT, RECEIPT, JE_LINE, or STATEMENT
REFERENCE_ID	Reference identifier; AP_CHECKS_ALL.check_id, AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id, CE_STATEMENT_LINES.statement_line_id, or GL_JE_LINES.je_line_num depending on the REFERENCE_TYPE
JE_HEADER_ID	Journal entry header identifier
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ORG_ID	Organization identifier
REFERENCE_STATUS	Latest status of referenced transaction

Cash Management - CE_ARCH_INTERFACE_HEADERS_ALL	Archived CE_STATEMENT_HEADERS_INT_ALL records
Column Name	Descritpion
STATEMENT_NUMBER	Statement number
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CONTROL_LINE_COUNT	Total line count of the statement that can be compared to the actual number of lines entered for control purposes
RECORD_STATUS_FLAG	Statement upload status, lookup type HEADER_INTERFACE_STATUS
CURRENCY_CODE	Bank statement currency code
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
BANK_ACCOUNT_NUM	Bank account number
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
STATEMENT_DATE	Statement date
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ORG_ID	Organization identifier
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
INTRA_DAY_FLAG	Flag to indicate whether this statement is an Intra-Day statement or not
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
BANK_NAME	Bank name
BANK_BRANCH_NAME	Bank branch name
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purposes
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purposes
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purposes
CONTROL_END_BALANCE	Ending balance of the statement for control purposes (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)

Cash Management - CE_ARCH_LINES	Archived CE_STATEMENT_LINES records
Column Name	Descritpion
STATEMENT_LINE_ID	Statement line identifier
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
TRX_CODE_ID	Bank transaction code identifier
EFFECTIVE_DATE	Statement line effective date, used to update AR receipt's clearing date
BANK_TRX_NUMBER	Transaction number that identifies the transaction to be matched against the statement line
TRX_TEXT	Statement line description
CUSTOMER_TEXT	Customer number for finding available transactions by customer number
INVOICE_TEXT	Invoice number for finding available transactions by invoice numbers
BANK_ACCOUNT_TEXT	Supplier/Customer/Payroll bank account number for finding available transactions by supplier/customer/payroll bank accounts
CURRENCY_CODE	Statement line currency code
EXCHANGE_RATE_TYPE	Currency conversion rate type
EXCHANGE_RATE	Currency conversion rate
EXCHANGE_RATE_DATE	Date used in determining the currency exchange rate
STATEMENT_HEADER_ID	Statement header identifier
ORIGINAL_AMOUNT	Statement line amount in currency code
CHARGES_AMOUNT	Bank charges amount
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
LINE_NUMBER	Statement line number
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
RECONCILE_TO_STATEMENT_FLAG	Flag to indicate whether this statement line is reconciled to another statement line, Y or Null
TRX_DATE	Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
TRX_TYPE	Transaction type, lookup type BANK_TRX_TYPE
AMOUNT	Statement line amount
STATUS	Statement line status, lookup type STATEMENT_LINE_STATUS
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Cash Management - CE_ARCH_INTERFACE_LINES	Archived CE_STATEMENT_LINES_INTERFACE records
Column Name	Descritpion
BANK_ACCOUNT_NUM	Bank account number
CURRENCY_CODE	Statement line currency code
USER_EXCHANGE_RATE_TYPE	Currency conversion rate type
EXCHANGE_RATE_DATE	Date used in determining the currency exchange rate
EXCHANGE_RATE	Currency conversion rate
ORIGINAL_AMOUNT	Statement line amount in currency code
CHARGES_AMOUNT	Bank charges amount
BANK_TRX_NUMBER	Transaction number that identifies the transaction to be matched against the statement line
CUSTOMER_TEXT	Customer number for finding available transactions by customer numbers
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
LINE_NUMBER	Statement line number
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
TRX_DATE	Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
TRX_CODE	Bank transaction code
EFFECTIVE_DATE	Statement line effective date, used to update AR receipt's clearing date
TRX_TEXT	Interface line description
INVOICE_TEXT	Invoice number for finding available transactions by invoice numbers
BANK_ACCOUNT_TEXT	Supplier/customer bank account number for finding available transactions by supplier/customer bank accounts
AMOUNT	Statement line amount

Cash Management - CE_ARCH_HEADERS_ALL	Archived CE_STATEMENT_HEADERS_ALL records
Column Name	Descritpion
STATEMENT_HEADER_ID	System-assigned statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purposes
CONTROL_TOTAL_CR	Total receipt amount of the statement that can be compared to the total receipt entry amount for control purposes
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	Organization identifier
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Document number
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
STATEMENT_DATE	Statement date
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_FORECASTS	Forecasts
Column Name	Descritpion
FORECAST_ID	System-assigned forecast identifier
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
FORECAST_HEADER_ID	Forecast template identifier
DESCRIPTION	Description of the forecast
START_DATE	Forecast start date, only applicable when AGING_TYPE in the corresponding CE_FORECAST_HEADERS record is D
START_PERIOD	Starting GL account period of the forecast, only applicable when AGING_TYPE in the corresponding CE_FORECAST_HEADER record is A
PERIOD_SET_NAME	Calendar name of the starting period
SOURCE_CURRENCY	Currency code of the source transactions to select for forecasting
ERROR_STATUS	Status of forecast run (S for successful run, W for warning, and E for error)
AMOUNT_THRESHOLD	A forecast submission option used to select transactions that have amounts greater than this threshold amount
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
NAME	User-assigned unique name for the forecast
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
FORECAST_CURRENCY	Currency in which the forecast is generated
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
PROJECT_ID	Project number for Project-Related source types
DRILLDOWN_FLAG	Flag to indicate whether this forecast supports drill-down functionality or not
BANK_BALANCE_TYPE	Lookup type BANK_ACC_BAL_TYPEL: Ledger Balance;C: Cash Flow Balance;I: Interest Calculated Balance
FLOAT_TYPE	Lookup type FLOAT_TYPENONE: None;ADD1: Add 1 Day FloatADD2: Add 2 Day Float SUB1: Subtract 1 Day Float SUB2: Subtract 2 Day Float
VIEW_BY	Lookup type OPENING_BAL_TYPE BANK or GLCP
INCLUDE_SUB_ACCOUNT	Flag to indicate whether to include subsidiary bank account balance in the forecast results
FACTOR	Factor used for forecast results
REQUEST_ID	Concurrent program request id
CURRENCY_TYPE	Type of currency code to select transactions by, lookup type FORECAST_CURRENCY_TYPE
EXCHANGE_RATE_TYPE	Currency exchange rate type to be used for translating forecast amount
EXCHANGE_DATE	Date to determine exchange rate for translating forecast amounts
EXCHANGE_RATE	Exchange rate for 'User' rate type
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Cash Management - CE_FORECAST_CELLS	Forecast amounts
Column Name	Descritpion
FORECAST_CELL_ID	System-assigned forecast cell identifier
FORECAST_ROW_ID	Forecast template row identifier
FORECAST_COLUMN_ID	Forecast template column identifier
FORECAST_ID	Forecast identifier
AMOUNT	Forecast amount
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
FORECAST_HEADER_ID	Obsolete column

Cash Management - CE_FORECAST_COLUMNS	Forecast template columns - forecast periods
Column Name	Descritpion
FORECAST_COLUMN_ID	System-assigned forecast template column identifier
LAST_UPDATE_LOGIN	Standard WHO column
DEVELOPER_COLUMN_NUM	System-assigned sequential column number based on COLUMN_NUMBER
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
FORECAST_HEADER_ID	Forecast Template header identifier
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
COLUMN_NUMBER	User-assigned number to specify the sequence of template columns
DAYS_FROM	The lower range of forecast periods
DAYS_TO	The upper range of forecast periods
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Cash Management - CE_FORECAST_HEADERS	Forecast template headers
Column Name	Descritpion
FORECAST_HEADER_ID	System-assigned forecast template identifier
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
NAME	User-assigned forecast template name
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
START_PROJECT_ID	Start Project Number for Project-Related source types
END_PROJECT_ID	End Project Number for Project-Related source types
TREASURY_TEMPLATE	The flag to indicate treasury forecast template
COLUMN_SETUP	Flag to indicate whether the column setup for this forecast template is Automatic ('A') or Manual ('M')
AGING_TYPE	Specifies forecast periods, lookup type FORECAST_AGING_TYPE
OVERDUE_TRANSACTIONS	A flag to indicate whether to include or exclude overdue transactions, lookup type FORECAST_OVERDUE_TRX
CUTOFF_PERIOD	Number of days or accounting periods for cutoff periods for including overdue transactions
TRANSACTION_CALENDAR_ID	Transaction or Business Calendar identifier
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
DESCRIPTION	Forecast template description

Cash Management - CE_FORECAST_ROWS	Forecast template rows - forecast sources
Column Name	Descritpion
FORECAST_ROW_ID	System-assigned forecast template row identifier
LEAD_TIME	Amount of time added to the transaction date to project cash date
FORECAST_METHOD	Method of forecast (P for selecting historical transactions and C for selecting current transactions), only applicable when TRX_TYPE is APP or ARR, always P for TRX_TYPE of PAY
RECEIPT_METHOD_ID	AR's receipt class payment method, only applicable when TRX_TYPE is ARR
BANK_ACCOUNT_ID	Bank account ID, only applicable when TRX_ID is APP, ARR, or PAY
PAYMENT_METHOD	Payment method of AP payments, only applicable when TRX_TYPE is APP
PAY_GROUP	Payment group of AP payments, only applicable when TRX_TYPE is APP
VENDOR_TYPE	Vendor type of AP invoices or purchase orders, only applicable when TRX_TYPE is API or POP
PAYMENT_PRIORITY	Priority of generating AP payments, only applicable when TRX_TYPE is API or POP
ROLL_FORWARD_TYPE	Type of periods to roll forward when forecasting, only applicable when FORECAST_METHOD is P and TRX_TYPE is APP, ARR, or PAY, lookup type FORECAST_ROLL_FORWARD_TYPE
ROLL_FORWARD_PERIOD	Number of periods to roll forward, only applicable when FORECAST_METHOD is P and TRX_TYPE is APP, ARR, or PAY
DISCOUNT_OPTION	Option to include or exclude discount amounts for AP invoices and purchase orders, only applicable when TRX_TYPE is API or POP (X for largest discount, M for minimum discount, and N for no discount)
FORECAST_HEADER_ID	Template header identifier
INCLUDE_FLOAT_FLAG	Flag to indicate whether to include any AR receipts in transit, only applicable when TRX_TYPE is ARR
INCLUDE_DISPUTE_FLAG	Flag to indicate whether to include any dispute amounts, only applicable when TRX_TYPE is ARI
CUSTOMER_PROFILE_CLASS_ID	Customer profile class identifier for AR invoices, only applicable when TRX_TYPE is ARI
ORDER_STATUS	Status of sales orders, only applicable when TRX_TYPE is OEO, lookup type FORECAST_ORDER_STATUS
ORDER_DATE_TYPE	Date type of sales orders to base the projection of cash receipt date. Only applicable when TRX_TYPE is OEO, lookup type FORECAST_ORDER_DATE_TYPE
SALES_STAGE_ID	Sales stage identifier. Only applicable when TRX_TYPE is ASF
CHANNEL_CODE	Sales channel for the lead item. Only applicable when TRX_TYPE is ASF
WIN_PROBABILITY	Probability that this item will be sold. Only applicable when TRX_TYPE is ASF. A probability of 10 will select all sales leads with a probability of 10% or more
SALES_FORECAST_STATUS	Sales lead status. Only applicable when TRX_TYPE is ASF
CODE_COMBINATION_ID	GL account code for GL transactions, only applicable when TRX_TYPE is GLB, GLC, or GLE
SET_OF_BOOKS_ID	Set of books identifier for source transaction
ORG_ID	Organization identifier of the source transaction, -1 for all organizations
CHART_OF_ACCOUNTS_ID	Chart of accounts identifier of the source transaction, only applicable when TRX_TYPE is GLB, GLC, or GLE
ROW_NUMBER	User-assigned number to specify the sequence of template rows
BUDGET_NAME	Name of the GL budgets, only applicable when TRX_TYPE is GLB
BUDGET_VERSION_ID	Version identifier of the budgets, only applicable when TRX_TYPE is GLB
ENCUMBRANCE_TYPE_ID	Encumbrance type identifier of encumbrances, only applicable when TRX_TYPE is GLE
AUTHORIZATION_STATUS	Authorization status of purchase orders or requisitions, only applicable when TRX_TYPE is POP or POR
ORG_PAYMENT_METHOD_ID	Payment method identifier for TRX_TYPE of PAY
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
TRX_TYPE	Type of source transactions, lookup type FORECAST_TRX_TYPE
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
PAYROLL_ID	Payroll identifier for TRX_TYPE of PAY
EXTERNAL_SOURCE_TYPE	External source type name for TRX_TYPE of OII or OIO
CRITERIA_CATEGORY	Structure defining column for the external source type flexfields, only applicable when TRX_TYPE is OII or OIO
CRITERIA1	External source type descriptive flexfield segment
CRITERIA2	External source type descriptive flexfield segment
CRITERIA3	External source type descriptive flexfield segment
CRITERIA4	External source type descriptive flexfield segment
CRITERIA5	External source type descriptive flexfield segment
CRITERIA6	External source type descriptive flexfield segment
CREATED_BY	Standard WHO column
CRITERIA7	External source type descriptive flexfield segment
CRITERIA8	External source type descriptive flexfield segment
CRITERIA9	External source type descriptive flexfield segment
CRITERIA10	External source type descriptive flexfield segment
CRITERIA11	External source type descriptive flexfield segment
CRITERIA12	External source type descriptive flexfield segment
CRITERIA13	External source type descriptive flexfield segment
CRITERIA14	External source type descriptive flexfield segment
CRITERIA15	External source type descriptive flexfield segment
TYPE	Project Transaction Type
BUDGET_TYPE	The status of the budget
BUDGET_VERSION	The version of the budget type selected
INCLUDE_HOLD_FLAG	The flag that determines whether the expense reports on hold should be included in the forecast
INCLUDE_NET_CASH_FLAG	The flag that determines whether the budget amounts should be included in the net cash calculation
COMPANY_CODE	Applicable when TRX_TYPE is XTR
EXCLUDE_INDIC_EXP	Flag to indicate whether to include indicative transactions. Only applicable when TRX_TYPE is XTR and TYPE is Exposure.
XTR_BANK_ACCOUNT	Bank Account. Only applicable when TRX_TYPE is XTR.
USE_AVERAGE_PAYMENT_DAYS	Flag to indicate whether to use average payment days to decide the cash activity date.
PERIOD	Number of periods to use for calculating average payment days.
USE_PAYMENT_TERMS	Flag to indicate whether to use payment terms to decide the cash activity date for sales orders and purchase orders.
ORDER_TYPE_ID	Order type identifier for a sales order
LEGAL_ENTITY_ID	Legal entity identifier
INCLUDE_TEMP_LABOR_FLAG	Include temporary labor identifier
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
DESCRIPTION	Description of the template row

Cash Management - CE_FORECAST_ERRORS	Forecast run errors
Column Name	Descritpion
FORECAST_HEADER_ID	Forecast template header identifier
FORECAST_ID	Forecast identifier
MESSAGE_NAME	Error message name used to retrieve message texts
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
FORECAST_ROW_ID	Forecast template row identifier
APPLICATION_SHORT_NAME	Application short name, CE
FORECAST_RUN_NAME	Forecast run name assigned by the user at the time of submission
APPLICATION_ID	Application ID, 260
MESSAGE_TEXT	Error message text

Cash Management - CE_FORECAST_EXT_VIEWS	External sources for forecasting
Column Name	Descritpion
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
EXTERNAL_SOURCE_TYPE	Name of the external source type
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
EXTERNAL_SOURCE_VIEW	View name of the external source for forecasting
DB_LINK_NAME	Database link name if the external source is located in a remote database.

Cash Management - CE_DOC_SEQUENCE_AUDIT	Document sequencing audit table
Column Name	Descritpion
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Document number
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
DOC_SEQUENCE_ASSIGNMENT_ID	Document sequence assignment identifier

Cash Management - CE_FORECAST_EXT_TEMP
Column Name	Descritpion
FORECAST_COLUMN_ID
FROM_CURRENCY_CODE
CONVERSION_RATE
FORECAST_REQUEST_ID
CONTEXT_VALUE
START_DATE
END_DATE

Cash Management - CE_CURRENCY_RATES_TEMP	Forecast currency amount staging table
Column Name	Descritpion
FORECAST_REQUEST_ID
CURRENCY_CODE
EXCHANGE_RATE
TO_CURRENCY

Cash Management - CE_BANK_STMT_INT_MAP	Bank Statement Mapping
Column Name	Descritpion
MAP_ID	Unique Identifier
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	Descriptive Flexfield Segment Column
ATTRIBUTE2	Descriptive Flexfield Segment Column
ATTRIBUTE3	Descriptive Flexfield Segment Column
ATTRIBUTE4	Descriptive Flexfield Segment Column
ATTRIBUTE5	Descriptive Flexfield Segment Column
FORMAT_NAME	Mapping Rule Name
ATTRIBUTE6	Descriptive Flexfield Segment Column
ATTRIBUTE7	Descriptive Flexfield Segment Column
ATTRIBUTE8	Descriptive Flexfield Segment Column
ATTRIBUTE9	Descriptive Flexfield Segment Column
ATTRIBUTE10	Descriptive Flexfield Segment Column
ATTRIBUTE11	Descriptive Flexfield Segment Column
ATTRIBUTE12	Descriptive Flexfield Segment Column
ATTRIBUTE13	Descriptive Flexfield Segment Column
ATTRIBUTE14	Descriptive Flexfield Segment Column
ATTRIBUTE15	Descriptive Flexfield Segment Column
TIMESTAMP_FORMAT	Timestamp Format
DESCRIPTION	Description
FORMAT_TYPE	Bank File Format Type
CONTROL_FILE_NAME	SQL*Loader Control File Name
PRECISION	The Number of Floating Point Digits in Amount notation.
DATE_FORMAT	Date Format
ENABLED	Enabled Flag 'Y' or 'N'
CREATED_BY	Standard Who Column

Cash Management - CE_BANK_STMT_MAP_HDR	Bank Statement Mapping
Column Name	Descritpion
MAP_HEADER_ID	Unique Identfier
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	Descriptive Flexfield Segment Column
ATTRIBUTE2	Descriptive Flexfield Segment Column
ATTRIBUTE3	Descriptive Flexfield Segment Column
ATTRIBUTE4	Descriptive Flexfield Segment Column
ATTRIBUTE5	Descriptive Flexfield Segment Column
ATTRIBUTE6	Descriptive Flexfield Segment Column
MAP_ID	Mapping Rule Identifier
ATTRIBUTE7	Descriptive Flexfield Segment Column
ATTRIBUTE8	Descriptive Flexfield Segment Column
ATTRIBUTE9	Descriptive Flexfield Segment Column
ATTRIBUTE10	Descriptive Flexfield Segment Column
ATTRIBUTE11	Descriptive Flexfield Segment Column
ATTRIBUTE12	Descriptive Flexfield Segment Column
ATTRIBUTE13	Descriptive Flexfield Segment Column
ATTRIBUTE14	Descriptive Flexfield Segment Column
ATTRIBUTE15	Descriptive Flexfield Segment Column
CONCATENATE_FORMAT_FLAG	Concatenate Format Flag. 'Y' or 'N'
COLUMN_NAME	Column Name
REC_ID_NO	Record Identifier Number
POSITION	The Position of the Data in Bank File Record
FORMAT	The Pre-defined Format of the Target data
INCLUDE_FORMAT_IND	Include Format Indicator Flag. 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Cash Management - CE_BANK_STMT_MAP_LINE	Bank Statement Mapping
Column Name	Descritpion
MAP_LINE_ID	Unique Identifier
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	Descriptive Flexfield Segment Column
ATTRIBUTE2	Descriptive Flexfield Segment Column
ATTRIBUTE3	Descriptive Flexfield Segment Column
ATTRIBUTE4	Descriptive Flexfield Segment Column
ATTRIBUTE5	Descriptive Flexfield Segment Column
ATTRIBUTE6	Descriptive Flexfield Segment Column
MAP_ID	Mapping Rule Identifier
ATTRIBUTE7	Descriptive Flexfield Segment Column
ATTRIBUTE8	Descriptive Flexfield Segment Column
ATTRIBUTE9	Descriptive Flexfield Segment Column
ATTRIBUTE10	Descriptive Flexfield Segment Column
ATTRIBUTE11	Descriptive Flexfield Segment Column
ATTRIBUTE12	Descriptive Flexfield Segment Column
ATTRIBUTE13	Descriptive Flexfield Segment Column
ATTRIBUTE14	Descriptive Flexfield Segment Column
ATTRIBUTE15	Descriptive Flexfield Segment Column
CONCATENATE_FORMAT_FLAG	Concatenate Format Flag. 'Y' or 'N'
COLUMN_NAME	Column Name
REC_ID_NO	Record Identifier Number
POSITION	The Position of the Data in Bank File Record
FORMAT	The Pre-defined Format of the Target data
INCLUDE_FORMAT_IND	Include Format Indicator Flag. 'Y' or 'N'
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Cash Management - CE_SQLLDR_ERRORS	Bank Statement Loader
Column Name	Descritpion
STATEMENT_NUMBER	Bank Statement Number
LAST_UPDATE_LOGIN	Standard Who Column
BANK_ACCOUNT_NUM	Bank Account Number
REC_NO	Record Number. If it's general message this column contain 0. Otherwise, it's a record specific message.
MESSAGE_TEXT	Message Text
STATUS	Message Severity. 'E' for Error and 'W' or Warning.
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column

Cash Management - CE_STMT_INT_TMP	Bank Statement Loader
Column Name	Descritpion
REC_NO	Record Number. Unique Identifier.
COLUMN8	Column8
COLUMN9	Column9
COLUMN10	Column10
COLUMN11	Column11
COLUMN12	Column12
COLUMN13	Column13
COLUMN14	Column14
COLUMN15	Column15
COLUMN16	Column16
COLUMN17	Column17
REC_ID_NO	Record Identifier Number
COLUMN18	Column18
COLUMN19	Column19
COLUMN20	Column20
COLUMN21	Column21
COLUMN22	Column22
COLUMN23	Column23
COLUMN24	Column24
COLUMN25	Column25
COLUMN26	Column26
COLUMN27	Column27
COLUMN1	Column1
COLUMN28	Column28
COLUMN29	Column29
COLUMN30	Column30
COLUMN31	Column31
COLUMN32	Column32
COLUMN33	Column33
COLUMN34	Column34
COLUMN35	Column35
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
COLUMN2	Column2
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COLUMN3	Column3
COLUMN4	Column4
COLUMN5	Column5
COLUMN6	Column6
COLUMN7	Column7

Cash Management - CE_INTRA_STMT_HEADERS_ALL	Bank statements
Column Name	Descritpion
STATEMENT_HEADER_ID	Statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	Organization identifier
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Interest Calculated Balance
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
STATEMENT_DATE	Statement date
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_INTRA_STMT_LINES	Bank Statement lines
Column Name	Descritpion
STATEMENT_LINE_ID	System-assigned statement line identifier
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
TRX_CODE_ID	Bank transaction code identifier
EFFECTIVE_DATE	Statement line effective date, used to update AR receipt's clearing date
BANK_TRX_NUMBER	Transaction number that identifies the transaction to be matched against the statement line
TRX_TEXT	Statement line description
CUSTOMER_TEXT	Customer number for finding available transactions by customer numbers
INVOICE_TEXT	Invoice number for finding available transactions by invoice number
BANK_ACCOUNT_TEXT	Supplier/customer bank account number for finding available transactions by supplier/customer numbers
CURRENCY_CODE	Statement line currency code
STATEMENT_HEADER_ID	Statement header identifier
EXCHANGE_RATE_TYPE	Currency conversion rate type
EXCHANGE_RATE	Currency conversion rate
EXCHANGE_RATE_DATE	Date used in determining the currency exchange rate
ORIGINAL_AMOUNT	Statement line amount in currency code
CHARGES_AMOUNT	Bank charges amount
LAST_UPDATE_LOGIN	Standard WHO column
RECONCILE_TO_STATEMENT_FLAG	Flag to indicate whether this statement line is reconciled to another statement line, Y or Null
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
LINE_NUMBER	Statement line number
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
TRX_DATE	Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
TRX_TYPE	Transaction type, lookup type BANK_TRX_TYPE
AMOUNT	Statement line amount
STATUS	Statement line status, lookup type STATEMENT_LINE_STATUS
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Cash Management - CE_ARCH_INTRA_HEADERS_ALL	Bank statements
Column Name	Descritpion
STATEMENT_HEADER_ID	Statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	Organization identifier
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Interest Calculated Balance
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
STATEMENT_DATE	Statement date
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_ARCH_INTRA_LINES	Bank Statement lines
Column Name	Descritpion
STATEMENT_LINE_ID	System-assigned statement line identifier
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
TRX_CODE_ID	Bank transaction code identifier
EFFECTIVE_DATE	Statement line effective date, used to update AR receipt's clearing date
BANK_TRX_NUMBER	Transaction number that identifies the transaction to be matched against the statement line
TRX_TEXT	Statement line description
CUSTOMER_TEXT	Customer number for finding available transactions by customer numbers
INVOICE_TEXT	Invoice number for finding available transactions by invoice number
BANK_ACCOUNT_TEXT	Supplier/customer bank account number for finding available transactions by supplier/customer numbers
CURRENCY_CODE	Statement line currency code
STATEMENT_HEADER_ID	Statement header identifier
EXCHANGE_RATE_TYPE	Currency conversion rate type
EXCHANGE_RATE	Currency conversion rate
EXCHANGE_RATE_DATE	Date used in determining the currency exchange rate
ORIGINAL_AMOUNT	Statement line amount in currency code
CHARGES_AMOUNT	Bank charges amount
LAST_UPDATE_LOGIN	Standard WHO column
RECONCILE_TO_STATEMENT_FLAG	Flag to indicate whether this statement line is reconciled to another statement line, Y or Null
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
LINE_NUMBER	Statement line number
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
TRX_DATE	Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
TRX_TYPE	Transaction type, lookup type BANK_TRX_TYPE
AMOUNT	Statement line amount
STATUS	Statement line status, lookup type STATEMENT_LINE_STATUS
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Cash Management - CE_BANK_ACCOUNTS	This table contains bank account information. Each bank account must be affiliated with one bank branch.
Column Name	Descritpion
BANK_ACCOUNT_ID	Bank Account Identifier
BANK_ID	Bank Identifier
CURRENCY_CODE	Currency Code
DESCRIPTION	Description
ATTRIBUTE_CATEGORY	Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	Descriptive Flexfield Segment Column
ATTRIBUTE2	Descriptive Flexfield Segment Column
ATTRIBUTE3	Descriptive Flexfield Segment Column
ATTRIBUTE4	Descriptive Flexfield Segment Column
ATTRIBUTE5	Descriptive Flexfield Segment Column
ATTRIBUTE6	Descriptive Flexfield Segment Column
BANK_ACCOUNT_NAME	Bank Account Name
ATTRIBUTE7	Descriptive Flexfield Segment Column
ATTRIBUTE8	Descriptive Flexfield Segment Column
ATTRIBUTE9	Descriptive Flexfield Segment Column
ATTRIBUTE10	Descriptive Flexfield Segment Column
ATTRIBUTE11	Descriptive Flexfield Segment Column
ATTRIBUTE12	Descriptive Flexfield Segment Column
ATTRIBUTE13	Descriptive Flexfield Segment Column
ATTRIBUTE14	Descriptive Flexfield Segment Column
ATTRIBUTE15	Descriptive Flexfield Segment Column
REQUEST_ID	Concurrent Who Column
LAST_UPDATE_DATE	Standard Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
BANK_ACCOUNT_NAME_ALT	Alternate Bank Account Name
ACCOUNT_HOLDER_ID	Account Holder Identifier
EFT_REQUESTER_IDENTIFIER	EFT Requester Identifier
SECONDARY_ACCOUNT_REFERENCE	Account Number Reference, Such As Building Society Roll Number
ACCOUNT_SUFFIX	Account Suffix
DESCRIPTION_CODE1	Description Code 1
LAST_UPDATED_BY	Standard Who Column
DESCRIPTION_CODE2	Description Code 2
IBAN_NUMBER	IBAN Number
SHORT_ACCOUNT_NAME	Legal Account Name
ACCOUNT_OWNER_PARTY_ID	Bank Account Owner Party_Id in TCA
ACCOUNT_OWNER_ORG_ID	Bank Account Owner Org_Id in HR
ACCOUNT_CLASSIFICATION	Account Classification (INTERNAL, EXTERNAL)
AP_USE_ALLOWED_FLAG	Flag to indicate if the account use for AP is allowed
AR_USE_ALLOWED_FLAG	Flag to indicate if the account use for AR is allowed
XTR_USE_ALLOWED_FLAG	Flag to indicate if the account use for XTR(Treasury) is allowed
PAY_USE_ALLOWED_FLAG	Flag to indicate if the account use for Payroll is allowed
LAST_UPDATE_LOGIN	Standard Who Column
MULTI_CURRENCY_ALLOWED_FLAG	Flag to indicate if the multiple currency is allowed
PAYMENT_MULTI_CURRENCY_FLAG	Flag to indicate if the payment multiple currency is enabled
RECEIPT_MULTI_CURRENCY_FLAG	Flag to indicate if the receipt multiple currency is enabled
ZERO_AMOUNT_ALLOWED	Indicator for allowing or disallowing zero amount
MAX_OUTLAY	Maximum payment batch
MAX_CHECK_AMOUNT	Default maximum payment amount allowed for bank account in a payment batch
MIN_CHECK_AMOUNT	Default minimum payment amount allowed for bank account in a payment batch
AP_AMOUNT_TOLERANCE	Tolerance amount limit to be used for AP payments during automatic reconciliation
AR_AMOUNT_TOLERANCE	Tolerance amount limit to be used for AR receipts during automatic reconciliation
XTR_AMOUNT_TOLERANCE	Tolerance amount limit to be used for XTR transactions during automatic reconciliation
CREATION_DATE	Standard Who Column
PAY_AMOUNT_TOLERANCE	Tolerance amount limit to be used for Payroll transactions during automatic reconciliation
AP_PERCENT_TOLERANCE	Tolerance percent to be used for AP payments during automatic reconciliation
AR_PERCENT_TOLERANCE	Tolerance percent to be used for AR receipts during automatic reconciliation
XTR_PERCENT_TOLERANCE	Tolerance percent to be used for XTR transactions during automatic reconciliation
PAY_PERCENT_TOLERANCE	Tolerance percent to be used for Payroll transactions during automatic reconciliation
BANK_ACCOUNT_TYPE	Bank account type code (sub account type)
AGENCY_LOCATION_CODE	Agency Location Code used by federal agencies
START_DATE	Start Date
END_DATE	End Date
ACCOUNT_HOLDER_NAME_ALT	Account holder alternate name
ACCOUNT_HOLDER_NAME	Account holder name
CASHFLOW_DISPLAY_ORDER	Cashflow display order
CREATED_BY	Standard Who Column
POOLED_FLAG	POOLED_FLAG
MIN_TARGET_BALANCE	MIN_TARGET_BALANCE
MAX_TARGET_BALANCE	MAX_TARGET_BALANCE
EFT_USER_NUM	EFT_USER_NUM
MASKED_ACCOUNT_NUM	MASKED_ACCOUNT_NUM
MASKED_IBAN	MASKED_IBAN
INTEREST_SCHEDULE_ID	Interest schedule identifier
CASHPOOL_MIN_PAYMENT_AMT	Cash pool minimum payment amount
CASHPOOL_MIN_RECEIPT_AMT	Cash pool minimum receipt amount
CASHPOOL_ROUND_FACTOR	Cash pool rounding factor
CASHPOOL_ROUND_RULE	Cash pool rounding rule
CE_AMOUNT_TOLERANCE	Amount tolerance
CE_PERCENT_TOLERANCE	Percent tolerance
ASSET_CODE_COMBINATION_ID	Asset code combination id
CASH_CLEARING_CCID	Cash clearing ccid
BANK_CHARGES_CCID	Bank charges ccid
BANK_ERRORS_CCID	Bank errors ccid
OBJECT_VERSION_NUMBER	Object Version Number
NETTING_ACCT_FLAG	Netting Bank Account Indicator
POOL_PAYMENT_METHOD_CODE	Cash pool payment method code
BANK_ACCOUNT_NUM	Bank Account Number
POOL_BANK_CHARGE_BEARER_CODE	Cash pool bank charge bearer code
POOL_PAYMENT_REASON_CODE	Cash pool payment reason code
POOL_PAYMENT_REASON_COMMENTS	Cash pool payment reason comments
POOL_REMITTANCE_MESSAGE1	Cash pool remittance message 1
POOL_REMITTANCE_MESSAGE2	Cash pool remittance message 2
POOL_REMITTANCE_MESSAGE3	Cash pool remittance message 3
FX_CHARGE_CCID	CCID of Foreign Exchange Charge GL Account
BANK_ACCOUNT_NUM_ELECTRONIC	Bank account number in electronic transmission format.
STMT_LINE_FLOAT_HANDLING_FLAG	Flag to indicate how to handle statement lines with effective date being later than today; Lookup type: FLOAT_HANDLING E for error or I for ignore.
AUTORECON_AP_MATCHING_ORDER	Order of matching statement lines to AP transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX
AUTORECON_AR_MATCHING_ORDER	Order of matching statement lines to AR transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX
RECON_FOREIGN_BANK_XRATE_TYPE	Exchange rate type defaulted for foreign currency bank.
RECON_FOR_BANK_XRATE_DATE_TYPE	Exchange rate date defaulted for foreign currency bank, lookup type EXCHANGE_RATE_DATE_TYPE
RECON_ENABLE_OI_FLAG	Flag to indicate whether to allow reconciliation of statement lines to open interface transactions, Y or N
RECON_OI_FLOAT_STATUS	Code to specify the float status for open interface transactions
RECON_OI_CLEARED_STATUS	Code to specify cleared status for open interface transactions
RECON_OI_MATCHING_CODE	Open interface transactions matching code, T for matching by transaction number, D for matching by date and amount. Lookup type: OI_MATCHING_CRITERIA
RECON_OI_AMOUNT_TOLERANCE	Tolerance amount limit to be used during the automatic reconciliation for open interface transactions
RECON_OI_PERCENT_TOLERANCE	Tolerance percent to be used during the automatic reconciliation for open interface transactions
MANUAL_RECON_AMOUNT_TOLERANCE	Tolerance amount limit to be used during manual reconciliation
BANK_BRANCH_ID	Bank Branch Identifier
MANUAL_RECON_PERCENT_TOLERANCE	Tolerance percent to be used during manual reconciliation
RECON_AP_FOREIGN_DIFF_HANDLING	Code to indicate how to handle amount differences for AP payments due to currency exchange rate changes during the automatic reconciliation process, G for treating them as currency gain or loss, C for handling them as errors or charges, N f
RECON_AR_FOREIGN_DIFF_HANDLING	Code to indicate how to handle amount differences for AR receipts due to currency exchange rate changes during the automatic reconciliation process, G for treating them as currency gain or loss, C for handling them as errors or charges, N
RECON_CE_FOREIGN_DIFF_HANDLING	Code to indicate how to handle amount differences for CE cashflows due to currency exchange rate changes during the automatic reconciliation process, CH for handling them as charges, E for handling them as errors, FX for handling them as fo
RECON_AP_TOLERANCE_DIFF_ACCT	Code to indicate how to handle any amount differences between statement line and AP transaction during the automatic reconciliation process, lookup type TOLERANCE_DIFFERENCES
RECON_CE_TOLERANCE_DIFF_ACCT	Code to indicate how to handle any amount differences between statement line and CE transaction during the automatic reconciliation process, lookup type TOLERANCE_DIFFERENCES
XTR_BANK_ACCOUNT_REFERENCE	xtr bank account reference
AUTORECON_AP_MATCHING_ORDER2	Order of matching statement lines to AP transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX_OR_GROUP
GAIN_CODE_COMBINATION_ID	Gain Code Combination Id
LOSS_CODE_COMBINATION_ID	Loss Code Combination Id

Cash Management - CE_BANK_ACCT_USES_ALL	This table stores information about your bank account uses.
Column Name	Descritpion
BANK_ACCT_USE_ID	Uniquely identifies the bank account uses
ATTRIBUTE1	Descriptive Flexfield Segment Column
ATTRIBUTE2	Descriptive Flexfield Segment Column
ATTRIBUTE3	Descriptive Flexfield Segment Column
ATTRIBUTE4	Descriptive Flexfield Segment Column
ATTRIBUTE5	Descriptive Flexfield Segment Column
ATTRIBUTE6	Descriptive Flexfield Segment Column
ATTRIBUTE7	Descriptive Flexfield Segment Column
ATTRIBUTE8	Descriptive Flexfield Segment Column
ATTRIBUTE9	Descriptive Flexfield Segment Column
ATTRIBUTE10	Descriptive Flexfield Segment Column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE11	Descriptive Flexfield Segment Column
ATTRIBUTE12	Descriptive Flexfield Segment Column
ATTRIBUTE13	Descriptive Flexfield Segment Column
ATTRIBUTE14	Descriptive Flexfield Segment Column
ATTRIBUTE15	Descriptive Flexfield Segment Column
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
ORG_ID	Organization identifier in HR
LAST_UPDATE_DATE	Standard Who Column
ORG_PARTY_ID	Party_id of the organization in TCA
AP_USE_ENABLE_FLAG	Flag to indicate if the account use for AP is enabled
AR_USE_ENABLE_FLAG	Flag to indicate if the account use for AR is enabled
XTR_USE_ENABLE_FLAG	Flag to indicate if the account use for XTR is enabled
PAY_USE_ENABLE_FLAG	Flag to indicate if the account use for Payroll is enabled
EDISC_RECEIVABLES_TRX_ID	Earned discounts receivable activity
UNEDISC_RECEIVABLES_TRX_ID	Unearned discounts receivable activity
POOLED_FLAG	Pooled or non-pooled account indicator
END_DATE	End date
BR_STD_RECEIVABLES_TRX_ID	Receivables activity identifier used for short term debt definition for transaction type of Bills Receivable Remittance
LEGAL_ENTITY_ID	Legal Entity Identifier
INVESTMENT_LIMIT_CODE	Investment limit code
LAST_UPDATED_BY	Standard Who Column
FUNDING_LIMIT_CODE	Funding limit code
AP_DEFAULT_SETTLEMENT_FLAG	Payable default settlement flag
XTR_DEFAULT_SETTLEMENT_FLAG	Treasury default settlement flag
PAYROLL_BANK_ACCOUNT_ID	Payroll bank account identifier
PRICING_MODEL	Pricing model
AUTHORIZED_FLAG	Authorized flag
EFT_SCRIPT_NAME	EFT script name
PORTFOLIO_CODE	Portfolio code
DEFAULT_ACCOUNT_FLAG	Default account flag
OBJECT_VERSION_NUMBER	Object Version Number
AR_CLAIM_INV_ACT_ID	Claim Investigation Activity
NEW_AR_RCPTS_RECEIVABLE_TRX_ID	Receivable transaction identifier
PAYMENT_DOC_CATEGORY	Payment document category
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PRIMARY_FLAG	Flag to identify if the bank account use is primary
ATTRIBUTE_CATEGORY	Descriptive Flexfield Structure Defining Column

Cash Management - CE_GL_ACCOUNTS_CCID	This table stores information about code combination ids per your bank account uses.
Column Name	Descritpion
BANK_ACCT_USE_ID	Bank Account Use Identifier
ON_ACCOUNT_CCID	Accounting flexfield identifier for the on account account
UNAPPLIED_CCID	Accounting flexfield identifier for the unapplied account
UNIDENTIFIED_CCID	Accounting flexfield identifier for the unidentified account
FACTOR_CCID	Accounting flexfield identifier for the factor account
RECEIPT_CLEARING_CCID	Accounting flexfield identifier for the receipt confirmation account
REMITTANCE_CCID	Accounting flexfield identifier for the remittance account
AR_SHORT_TERM_DEPOSIT_CCID	Accounting flexfield identifier for the AR short term deposit account
BR_SHORT_TERM_DEPOSIT_CCID	Accounting flexfield identifier for the BR short term deposit account
FUTURE_DATED_PAYMENT_CCID	Accounting flexfield identifier for the future dated payment account
LAST_UPDATE_DATE	Standard Who Column
ASSET_CODE_COMBINATION_ID	Accounting flexfield identifier for the cash account of the bank account
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
BR_REMITTANCE_CCID	Accounting Flexfield identifier for the Bills Receivable Remittance Account
BR_FACTOR_CCID	Accounting Flexfield identifier for the Bills Receivable Factoring Account
BANK_INTEREST_EXPENSE_CCID	Accounting flexfield identifier for the bank interest expense account
BANK_INTEREST_INCOME_CCID	Accounting flexfield identifier for the bank interest income account
XTR_ASSET_CCID	Accounting flexfield identifier for the Treasury cash account
OBJECT_VERSION_NUMBER	Object Version Number
AR_BANK_CHARGES_CCID	accounting Flexfield identifier for the Receivables Bank Charges Account
AP_ASSET_CCID	Accounting flexfield identifier for the AP cash account
AR_ASSET_CCID	Accounting flexfield identifier for the AR cash account
CASH_CLEARING_CCID	Accounting flexfield identifier for the cash clearing account
BANK_CHARGES_CCID	Accounting flexfield identifier for the bank charges account
BANK_ERRORS_CCID	Accounting flexfield identifier for the bank errors account
GAIN_CODE_COMBINATION_ID	Accounting flexfield identifier for the account that posts the realized exchange rate gains
LOSS_CODE_COMBINATION_ID	Accounting flexfield identifier for the account that posts the realized exchange rate losses

Cash Management - CE_XML_STATEMENT_LIST	Internal table to store the XML Bank Statements received via the XML Gateway Interface
Column Name	Descritpion
STATEMENT_NUMBER	Statement number for the XML bank statement.
TRADING_PARTNER	Trading partner (sender) of the XML bank statement.
BANK_ACCOUNT_NUM	Bank account number for the XML bank statement.
ITEM_KEY	Unique item key to specify for Workflow process.

Cash Management - CE_FORECAST_TRX_CELLS	This table stores transaction level forecast data
Column Name	Descritpion
FORECAST_CELL_ID	System-assigned forecast cell identifier
FORECAST_ROW_ID	Forecast template row identifier
FORECAST_COLUMN_ID	Forecast template column identifier
REFERENCE_ID	Unique transaction identifier
CURRENCY_CODE	Currency Code
ORG_ID	Organization identifier, Legal Entity identifier
INCLUDE_FLAG	This is N if this row has been manually excluded from the forecast results
TRX_DATE	Cash Activity Date
BANK_ACCOUNT_ID	Bank Account identifier
CODE_COMBINATION_ID	Accounting Flexfield identifier for GL Cash Account associated with bank account
TRX_AMOUNT	Forecast Amount in Transaction Currency
FORECAST_ID	Forecast identifier
AMOUNT	Forecast Amount per individual transaction
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FORECAST_HEADER_ID	Forecast header identifier

Cash Management - CE_BANK_UPGRADE_ERRORS	This table stores errors that occurred when upgrading a bank, a bank branch, or a bank account.
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
LAST_UPDATE_LOGIN	Standard who column
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
KEY_ERROR_FLAG	Flag to indicate if this error is a unique key column validation error.
APPLICATION_ID	Application identifier
MESSAGE_NAME	Error message name
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column

Cash Management - CE_UPGA_BANK_ACCOUNTS	This table is an audit table of CE_UPG_BANK_ACCOUNTS
Column Name	Descritpion
CE_BANK_ACCOUNT_ID	CE bank account identifier
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BANK_ACCOUNT_NUM	Bank account number
BRANCH_PARTY_ID	Bank party identifier
BANK_PARTY_ID	Bank branch party identifier
CURRENCY_CODE	Currency code
DESCRIPTION	Description
CE_UPGRADE_ID	CE upgrade identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descripitive flexfield segment column
ATTRIBUTE2	Descripitive flexfield segment column
ATTRIBUTE3	Descripitive flexfield segment column
ATTRIBUTE4	Descripitive flexfield segment column
ATTRIBUTE5	Descripitive flexfield segment column
ATTRIBUTE6	Descripitive flexfield segment column
ATTRIBUTE7	Descripitive flexfield segment column
ATTRIBUTE8	Descripitive flexfield segment column
ATTRIBUTE9	Descripitive flexfield segment column
PARENT_UPGRADE_ID	Parent CE upgrade identifier
ATTRIBUTE10	Descripitive flexfield segment column
ATTRIBUTE11	Descripitive flexfield segment column
ATTRIBUTE12	Descripitive flexfield segment column
ATTRIBUTE13	Descripitive flexfield segment column
ATTRIBUTE14	Descripitive flexfield segment column
ATTRIBUTE15	Descripitive flexfield segment column
REQUEST_ID	Concurrent who column
PROGRAM_APPLICATION_ID	Concurrent who column
PROGRAM_ID	Concurrent who column
PROGRAM_UPDATE_DATE	Concurrent who column
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
BANK_ACCOUNT_NAME_ALT	Alternate bank account name
ACCOUNT_HOLDER_NAME	Account holder name
ACCOUNT_HOLDER_NAME_ALT	Alternate account holder name
EFT_REQUESTER_IDENTIFIER	EFT requester identifier
SECONDARY_ACCOUNT_REFERENCE	Account number reference, such as building society roll number
ACCOUNT_SUFFIX	Account suffix
DESCRIPTION_CODE1	Description code 1
DESCRIPTION_CODE2	Description code 2
IBAN_NUM	IBAN number
PRIMARY_ACCT_FLAG	Flag to indicate if this record is the primary record of the bank account group
SHORT_ACCOUNT_NAME	No longer used
ACCOUNT_OWNER_PARTY_ID	Bank account owner party identifier in TCA
ACCOUNT_OWNER_ORG_ID	Bank account owner organization identifier in HR
ACCOUNT_CLASSIFICATION	Account classification (INTERNAL, EXTERNAL)
AP_USE_ALLOWED_FLAG	Flag to indicate if the account use for AP is allowed
AR_USE_ALLOWED_FLAG	Flag to indicate if the account use for AR is allowed
XTR_USE_ALLOWED_FLAG	Flag to indicate if the account use for XTR is allowed
PAY_USE_ALLOWED_FLAG	Flag to indicate if the account use for PAY is allowed
MULTI_CURRENCY_ALLOWED_FLAG	Flag to indicate if the multiple currency is allowed
PAYMENT_MULTI_CURRENCY_FLAG	Flag to indicate if the payment multiple currency is enabled
SECONDARY_ACCT_FLAG	Flag to indicate if this record is the secondary record of the bank account group
RECEIPT_MULTI_CURRENCY_FLAG	Flag to indicate if the receipt multiple currency is enabled
ZERO_AMOUNT_ALLOWED_FLAG	Indicator for allowing or disallowing zero amount
MAX_OUTLAY	Maximum payment batch
MAX_CHECK_AMOUNT	Default maximum payment amount allowed for bank account in a payment batch
MIN_CHECK_AMOUNT	Default minimum payment amount allowed for bank account in a payment batch
AP_AMOUNT_TOLERANCE	Tolerance amount limit to be used for AP transactions during automatic reconciliation
AP_PERCENT_TOLERANCE	Tolerance percent to be used for AP transactions during automatic reconciliation
AR_AMOUNT_TOLERANCE	Tolerance amount limit to be used for AR transactions during automatic reconciliation
AR_PERCENT_TOLERANCE	Tolerance percent to be used for AR transactions during automatic reconciliation
XTR_AMOUNT_TOLERANCE	Tolerance amount limit to be used for XTR transactions during automatic reconciliation
GROUP_ID	Bank account group identifier
XTR_PERCENT_TOLERANCE	Tolerance percent to be used for XTR transactions during automatic reconciliation
PAY_AMOUNT_TOLERANCE	Tolerance amount limit to be used for PAY transactions during automatic reconciliation
PAY_PERCENT_TOLERANCE	Tolerance percent to be used for PAY transactions during automatic reconciliation
BANK_ACCOUNT_TYPE	Bank account type code (sub account type)
AGENCY_LOCATION_CODE	Agency Location Code used by federal agencies
START_DATE	Start date
END_DATE	End date
YEAR_CALC_TYPE	Day count basis which defines the way in which interest accrues over time
INTEREST_CALCULATION_BASIS	Interest calculation basis (STEP or FLAT)
DAY_COUNT_TYPE_FLAG	Interest includes
BANK_ACCOUNT_NAME	Bank account name
ROUNDING_TYPE_FLAG	Interest rounding
CASHFLOW_DISPLAY_ORDER	Cashflow display order
TARGET_BALANCE	Target bank account balance
EFT_USER_NUM	EFT user number
BANK_CODE	Bank code
COMM_AGREEMENT_IDENTIFIER	Communication agreement identifier
LEGAL_ACCOUNT_NAME	Legal account name
CREATED_BY_MODULE	Created by module

Cash Management - CE_UPGA_BA_USES_ALL	This table is an audit table of CE_UPG_BA_USES_ALL
Column Name	Descritpion
CE_BANK_ACCT_USE_ID	CE bank account use identifier
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
PRIMARY_FLAG	Flag to identify if the bank account use is primary
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descripitive flexfield segment column
ATTRIBUTE2	Descripitive flexfield segment column
ATTRIBUTE3	Descripitive flexfield segment column
ATTRIBUTE4	Descripitive flexfield segment column
CE_UPGRADE_ID	CE upgrade identifier
ATTRIBUTE5	Descripitive flexfield segment column
ATTRIBUTE6	Descripitive flexfield segment column
ATTRIBUTE7	Descripitive flexfield segment column
ATTRIBUTE8	Descripitive flexfield segment column
ATTRIBUTE9	Descripitive flexfield segment column
ATTRIBUTE10	Descripitive flexfield segment column
ATTRIBUTE11	Descripitive flexfield segment column
ATTRIBUTE12	Descripitive flexfield segment column
ATTRIBUTE13	Descripitive flexfield segment column
ATTRIBUTE14	Descripitive flexfield segment column
PARENT_UPGRADE_ID	Parent CE upgrade identifier
ATTRIBUTE15	Descripitive flexfield segment column
REQUEST_ID	Concurrent who column
PROGRAM_APPLICATION_ID	Concurrent who column
PROGRAM_ID	Concurrent who column
PROGRAM_UPDATE_DATE	Concurrent who column
ORG_ID	Organization identifier in HR
ORG_PARTY_ID	Party identifier of the organization in TCA
AP_USE_ENABLE_FLAG	Flag to indicate if the account use for AP is enabled
AR_USE_ENABLE_FLAG	Flag to indicate if the account use for AR is enabled
XTR_USE_ENABLE_FLAG	Flag to indicate if the account use for XTR is enabled
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
PAY_USE_ENABLE_FLAG	Flag to indicate if the account use for PAY is enabled
EDISC_RECEIVABLES_TRX_ID	Earned discounts receivable activity
UNEDISC_RECEIVABLES_TRX_ID	Unearned discounts receivable activity
BR_STD_RECEIVABLES_TRX_ID	Short term debit receivable activity for BR transaction type
POOLED_FLAG	Pooled or non-pooled account indicator
END_DATE	End date
DIRECT_DEBIT_AUTH_FLAG	Flag to indicate if the acccount use is direct debit authorized
PRIMARY_ACCT_USE_FLAG	Flag to indicate if this record is the primary record of the bank account use group
SECONDARY_ACCT_USE_FLAG	Flag to indicate if this record is the secondary record of the bank account use group
GROUP_ID	Bank account use group identifier
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column

Cash Management - CE_UPGA_GL_ACCTS_CCID	This table is an audit table of CE_UPG_GL_ACCOUNTS_CCID
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
GAIN_CODE_COMBINATION_ID	Accounting flexfield identifier for the account that posts the realized exchange rate gains
LOSS_CODE_COMBINATION_ID	Accounting flexfield identifier for the account that posts the realized exchange rate losses
ON_ACCOUNT_CCID	Accounting flexfield identifier for the on account account
UNAPPLIED_CCID	Accounting flexfield identifier for the unappliedaccount
UNIDENTIFIED_CCID	Accounting flexfield identifier for the unidentified account
FACTOR_CCID	Accounting flexfield identifier for the factor account
RECEIPT_CLEARING_CCID	Accounting flexfield identifier for the receipt confirmation account
EARNED_CCID	Accounting flexfield identifier for the earned account
UNEARNED_CCID	Accounting flexfield identifier for the unearned account
REMITTANCE_CCID	Accounting flexfield identifier for the remittance account
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
AR_SHORT_TERM_DEPOSIT_CCID	Accounting flexfield identifier for the AR short term deposit account
BR_SHORT_TERM_DEPOSIT_CCID	Accounting flexfield identifier for the BR short term deposit account
FUTURE_DATED_PAYMENT_CCID	Accounting flexfield identifier for the future dated payment account
BR_REMITTANCE_CCID	Accounting flexfield identifier for the BR remittance account
BR_FACTOR_CCID	Accounting flexfield identifier for the BR factor account
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
ASSET_CODE_COMBINATION_ID	Accounting flexfield identifier for the cash account of the bank account
LAST_UPDATE_LOGIN	Standard who column
AP_ASSET_CCID	Accounting flexfield identifier for the AP cash account
AR_ASSET_CCID	Accounting flexfield identifier for the AR cash account
XTR_ASSET_CCID	Accounting flexfield identifier for the XTR cash account
CASH_CLEARING_CCID	Accounting flexfield identifier for the cash clearing account
BANK_CHARGES_CCID	Accounting flexfield identifier for the bank charges account
BANK_ERRORS_CCID	Accounting flexfield identifier for the bank errors account

Cash Management - CE_UPGA_PERSON_REC	This table is an audit table of CE_UPG_PERSON_REC
Column Name	Descritpion
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CE_UPGRADE_ID	CE upgrade identifier
PERSON_PARTY_ID	TCA person party identifier
PERSON_FIRST_NAME	First name of the person
PERSON_MIDDLE_NAME	Middle name of the person
PERSON_LAST_NAME	Last name of the person
PERSON_PRE_NAME_ADJUNCT	Salutary introduction, such as Mr.
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column

Cash Management - CE_UPG_AP_ACCTS_TMP	This table stores AP purged bank account details
Column Name	Descritpion
BANK_ACCOUNT_ID	Bank account identifier
SET_OF_BOOKS_ID	Set of books identifier
BR_REMITTANCE_CCID	Accounting Flexfield identifier for the Bills Receivable Remittance account
BR_FACTOR_CCID	Accounting Flexfield identifier for the Bills Receivable Factoring account
BR_STD_RECEIVABLES_TRX_ID	Receivables activity identifier used for short term debt definition for transaction type of Bills Receivable Remittance
ALLOW_MULTI_ASSIGNMENTS_FLAG	Allows a bank to be assigned to more than one supplier
AGENCY_LOCATION_CODE	Agency Location code assigned by US Treasury
IBAN_NUMBER	International bank account number. Used internaionally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN
CURRENCY_CODE	Currency code
DESCRIPTION	Description
CONTACT_FIRST_NAME	First name of bank contact person
CONTACT_MIDDLE_NAME	Middle name of bank contact person
CONTACT_LAST_NAME	Last name of bank contact person
CONTACT_PREFIX	Prefix of bank contact person (Ms., Mr., Mrs., Miss, etc.)
CONTACT_TITLE	Title of bank contact person
CONTACT_AREA_CODE	Area code for phone number of bank contact person
CONTACT_PHONE	Phone number of bank contact person
BANK_ACCOUNT_NAME	Bank account name
MAX_CHECK_AMOUNT	Default maximum payment amount allowed for bank account in a payment batch
MIN_CHECK_AMOUNT	Default minimum payment amount allowed for bank account in a payment batch
ONE_SIGNATURE_MAX_FLAG	No longer used
INACTIVE_DATE	Inactive date
AVG_FLOAT_DAYS	No longer used
ASSET_CODE_COMBINATION_ID	Accounting Flexfield identifier for cash account associated with bank account
GAIN_CODE_COMBINATION_ID	Accounting Flexfield identifier for account to which you post realized exchange rate gains
LOSS_CODE_COMBINATION_ID	Accounting Flexfield identifier for account to which you post realized exchange rate losses
BANK_ACCOUNT_TYPE	Bank account type code
VALIDATION_NUMBER	No longer used
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
MAX_OUTLAY	Maximum payment batch outlay for bank account
MULTI_CURRENCY_FLAG	Multiple currency bank account indicator (Y or N)
ACCOUNT_TYPE	Bank account type code. Possible values are: INTERNAL or SUPPLIER for banks defined for Oracle Payables, INTERNAL or EXTERNAL for banks defined for Oracle Receivables and PAYROLL for banks defined for Payroll
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
POOLED_FLAG	Pooled or non-pooled account indicator
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZERO_AMOUNTS_ALLOWED	Indicator for allowing or disallowing zero amount payments for bank account
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
RECEIPT_MULTI_CURRENCY_FLAG	Supports integration with Oracle Cash Management
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
ORG_ID	Organization identifier
CASH_CLEARING_CCID	Accounting Flexfield identifier for the Cash Clearing Account
BANK_CHARGES_CCID	Accounting Flexfield identifier for the Bank Charges Account
CREATION_DATE	Standard who column - date when this row was created
BANK_ERRORS_CCID	Accounting Flexfield identifier for the Bank Errors Account
EARNED_CCID	Accounting Flexfield identifier for the Earned Account
UNEARNED_CCID	Accounting Flexfield identifier for the Unearned Account
ON_ACCOUNT_CCID	Accounting Flexfield identifier for the On Account Account
UNAPPLIED_CCID	Accounting Flexfield identifier for the Unapplied Account
UNIDENTIFIED_CCID	Accounting Flexfield identifier for the Unidentified Account
FACTOR_CCID	Accounting Flexfield identifier for the Factor Account
RECEIPT_CLEARING_CCID	Accounting Flexfield identifier for the Receipt Confirmation Account
REMITTANCE_CCID	Accounting Flexfield identifier for the Remittance Account
SHORT_TERM_DEPOSIT_CCID	Accounting Flexfield identifier for the Short Term Deposit Account
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
BANK_ACCOUNT_NUM	Bank account number
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
BANK_BRANCH_ID	Bank branch identifier
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
BANK_ACCOUNT_NAME_ALT	Alternate bank account name
ACCOUNT_HOLDER_NAME	Account holder name
ACCOUNT_HOLDER_NAME_ALT	Alternate account holder name
EFT_REQUESTER_ID	EFT requester identifier
EFT_USER_NUMBER	The number that identifies you as a user of electronic funds transfer services to your bank or clearing organization
PAYROLL_BANK_ACCOUNT_ID	Bank account identifier for payroll bank accounts
FUTURE_DATED_PAYMENT_CCID	Accounting Flexfield identifier for the future dated payment account
EDISC_RECEIVABLES_TRX_ID	Earned Discounts Activity
UNEDISC_RECEIVABLES_TRX_ID	Unearned Discounts Activity

Cash Management - CE_UPG_PAY_ACCTS_TMP	This table stores PAY purged bank account details
Column Name	Descritpion
EXTERNAL_ACCOUNT_ID	System-generated primary key column.
SEGMENT2	Key flexfield segment
SEGMENT3	Key flexfield segment
SEGMENT4	Key flexfield segment
SEGMENT5	Key flexfield segment
SEGMENT6	Key flexfield segment
SEGMENT7	Key flexfield segment
SEGMENT8	Key flexfield segment
SEGMENT9	Key flexfield segment
SEGMENT10	Key flexfield segment
SEGMENT11	Key flexfield segment
TERRITORY_CODE	Foreign key to FND_TERRITORIES.
SEGMENT12	Key flexfield segment
SEGMENT13	Key flexfield segment
SEGMENT14	Key flexfield segment
SEGMENT15	Key flexfield segment
SEGMENT16	Key flexfield segment
SEGMENT17	Key flexfield segment
SEGMENT18	Key flexfield segment
SEGMENT19	Key flexfield segment
SEGMENT20	Key flexfield segment
SEGMENT21	Key flexfield segment column.
PRENOTE_DATE	Date on which a prenote for this account was sent.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ID_FLEX_NUM	Key flexfield structure foreign key.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
SUMMARY_FLAG	Key flexfield summary flag.
ENABLED_FLAG	Key flexfield enabled flag.
START_DATE_ACTIVE	Date before which key flexfield combination is invalid.
END_DATE_ACTIVE	Date after which key flexfield combination is invalid.
SEGMENT1	Key flexfield segment

Cash Management - CE_UPG_LOC_REC	This table stores addresses for bank branches including primary address flag
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
ADDRESS_STYLE	Address style
CITY	City
STATE	State
PROVINCE	Province
COUNTY	County
POSTAL_CODE	Postal code
ADDRESS_LINE_PHONETIC	Alternate address line
LOCATION_ID	Location identifier
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
IDENTIFYING_ADDRESS_FLAG	Flag to identify if this is the primary address
COUNTRY	Country
ADDRESS1	Address line 1
ADDRESS2	Address line 2
ADDRESS3	Address line 3
ADDRESS4	Address line 4

Cash Management - CE_UPG_GL_ACCOUNTS_CCID	This table stores CCID information of bank account uses for bank upgrade purpose
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
GAIN_CODE_COMBINATION_ID	Accounting flexfield identifier for the account that posts the realized exchange rate gains
LOSS_CODE_COMBINATION_ID	Accounting flexfield identifier for the account that posts the realized exchange rate losses
ON_ACCOUNT_CCID	Accounting flexfield identifier for the on account account
UNAPPLIED_CCID	Accounting flexfield identifier for the unappliedaccount
UNIDENTIFIED_CCID	Accounting flexfield identifier for the unidentified account
FACTOR_CCID	Accounting flexfield identifier for the factor account
RECEIPT_CLEARING_CCID	Accounting flexfield identifier for the receipt confirmation account
EARNED_CCID	Accounting flexfield identifier for the earned account
UNEARNED_CCID	Accounting flexfield identifier for the unearned account
REMITTANCE_CCID	Accounting flexfield identifier for the remittance account
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
AR_SHORT_TERM_DEPOSIT_CCID	Accounting flexfield identifier for the AR short term deposit account
BR_SHORT_TERM_DEPOSIT_CCID	Accounting flexfield identifier for the BR short term deposit account
FUTURE_DATED_PAYMENT_CCID	Accounting flexfield identifier for the future dated payment account
BR_REMITTANCE_CCID	Accounting flexfield identifier for the BR remittance account
BR_FACTOR_CCID	Accounting flexfield identifier for the BR factor account
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
ASSET_CODE_COMBINATION_ID	Accounting flexfield identifier for the cash account of the bank account
LAST_UPDATE_LOGIN	Standard who column
AP_ASSET_CCID	Accounting flexfield identifier for the AP cash account
AR_ASSET_CCID	Accounting flexfield identifier for the AR cash account
XTR_ASSET_CCID	Accounting flexfield identifier for the XTR cash account
CASH_CLEARING_CCID	Accounting flexfield identifier for the cash clearing account
BANK_CHARGES_CCID	Accounting flexfield identifier for the bank charges account
BANK_ERRORS_CCID	Accounting flexfield identifier for the bank errors account

Cash Management - CE_UPG_CONT_POINT_REC	This table stores contact points information for bank EDI, email, bank branch EFT, contact phone and fax
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
EDI_TP_HEADER_ID	EDI trading partner header identifier
EDI_ECE_TP_LOCATION_CODE	EDI trading partner location code
EFT_TRANSMISSION_PROGRAM_ID	Trasmission program identifier
EFT_PRINTING_PROGRAM_ID	Printing program identifier
EFT_SWIFT_CODE	EFT swift code
PHONE_AREA_CODE	The area code within a country code
PHONE_NUMBER	Phone number
ORG_PRIMARY_PHONE_FLAG	Organization primary phone line flag (Y or N)
EMAIL_ADDRESS	E-mail address of the contact point
CONTACT_POINT_ID	TCA contact point identifier
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
EFT_USER_NUM	Eft user number
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CONTACT_POINT_TYPE	Contact point type
PHONE_LINE_TYPE	Lookup code for the type of phone line
OWNER_TABLE_NAME	Table that stores the owner of the contact point
OWNER_TABLE_ID	Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point
CREATED_BY_MODULE	Created by module
EDI_ID_NUMBER	EDI trading partner number

Cash Management - CE_UPG_BA_USES_ALL	This table stores new CE bank account uses information for bank upgrade purpose
Column Name	Descritpion
CE_BANK_ACCT_USE_ID	CE bank account use identifier
SECONDARY_ACCT_USE_FLAG	Flag to indicate if this record is the secondary record of the bank account use group
GROUP_ID	Bank account use group identifier
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
PRIMARY_FLAG	Flag to identify if the bank account use is primary
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
SOURCE_APPLICATION_ID	Source application identifier
ATTRIBUTE1	Descripitive flexfield segment column
ATTRIBUTE2	Descripitive flexfield segment column
ATTRIBUTE3	Descripitive flexfield segment column
ATTRIBUTE4	Descripitive flexfield segment column
ATTRIBUTE5	Descripitive flexfield segment column
ATTRIBUTE6	Descripitive flexfield segment column
ATTRIBUTE7	Descripitive flexfield segment column
ATTRIBUTE8	Descripitive flexfield segment column
ATTRIBUTE9	Descripitive flexfield segment column
ATTRIBUTE10	Descripitive flexfield segment column
CE_UPGRADE_ID	CE upgrade identifier
ATTRIBUTE11	Descripitive flexfield segment column
ATTRIBUTE12	Descripitive flexfield segment column
ATTRIBUTE13	Descripitive flexfield segment column
ATTRIBUTE14	Descripitive flexfield segment column
ATTRIBUTE15	Descripitive flexfield segment column
REQUEST_ID	Concurrent who column
PROGRAM_APPLICATION_ID	Concurrent who column
PROGRAM_ID	Concurrent who column
PROGRAM_UPDATE_DATE	Concurrent who column
ORG_ID	Organization identifier in HR
PARENT_UPGRADE_ID	Parent CE upgrade identifier
ORG_PARTY_ID	Party identifier of the organization in TCA
AP_USE_ENABLE_FLAG	Flag to indicate if the account use for AP is enabled
AR_USE_ENABLE_FLAG	Flag to indicate if the account use for AR is enabled
XTR_USE_ENABLE_FLAG	Flag to indicate if the account use for XTR is enabled
PAY_USE_ENABLE_FLAG	Flag to indicate if the account use for PAY is enabled
EDISC_RECEIVABLES_TRX_ID	Earned discounts receivable activity
UNEDISC_RECEIVABLES_TRX_ID	Unearned discounts receivable activity
BR_STD_RECEIVABLES_TRX_ID	Short term debit receivable activity for BR transaction type
POOLED_FLAG	Pooled or non-pooled account indicator
END_DATE	End date
SOURCE_PK_ID	Source primary key identifier
DIRECT_DEBIT_AUTH_FLAG	Flag to indicate if the acccount use is direct debit authorized
PAYROLL_BANK_ACCOUNT_ID	Payroll bank account identifier
CE_USE_ENABLE_FLAG	Flag to indicate if the account use for CE is enabled
LEGAL_ENTITY_ID	Legal entity identifier
PARTY_CODE	XTR party code
ACCOUNT_NUMBER	XTR account number
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
PRIMARY_ACCT_USE_FLAG	Flag to indicate if this record is the primary record of the bank account use group

Cash Management - CE_UPG_BANK_REC	This table stores organization party information for banks, clearinghouses, bank branches, and clearinghouse branches
Column Name	Descritpion
PARTY_ID	TCA party identifier
PRIMARY_FLAG	Flag to indicate if this record is the primary record of the bank or bank branch group
SECONDARY_FLAG	Flag to indicate if this record is the secondary record of the bank or bank branch group
GROUP_ID	Bank or bank branch group identifier
BANK_OR_BRANCH_NUMBER	Bank number, bank branch number, clearinghouse number, or clearinghouse branch number
BANK_CODE	Bank code
BRANCH_CODE	Branch code
INSTITUTION_TYPE	Institution type
COUNTRY	Country
BRANCH_TYPE	Bank branch type
RFC_CODE	RFC identifier
SOURCE_APPLICATION_ID	Source application identifier
CREATED_BY_MODULE	Created by module
ORGANIZATION_NAME	Organization name
ORGANIZATION_NAME_PHONETIC	Alternate organization name
KNOWN_AS	Bank or bank branch short name
JGZZ_FISCAL_CODE	Taxpayer identifier
MISSION_STATEMENT	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descripitive flexfield segment column
ATTRIBUTE2	Descripitive flexfield segment column
ATTRIBUTE3	Descripitive flexfield segment column
CE_UPGRADE_ID	CE upgrade identifier
ATTRIBUTE4	Descripitive flexfield segment column
ATTRIBUTE5	Descripitive flexfield segment column
ATTRIBUTE6	Descripitive flexfield segment column
ATTRIBUTE7	Descripitive flexfield segment column
ATTRIBUTE8	Descripitive flexfield segment column
ATTRIBUTE9	Descripitive flexfield segment column
ATTRIBUTE10	Descripitive flexfield segment column
ATTRIBUTE11	Descripitive flexfield segment column
ATTRIBUTE12	Descripitive flexfield segment column
ATTRIBUTE13	Descripitive flexfield segment column
PARENT_UPGRADE_ID	Parent CE upgrade identifier
ATTRIBUTE14	Descripitive flexfield segment column
ATTRIBUTE15	Descripitive flexfield segment column
START_DATE_ACTIVE	Start date
END_DATE_ACTIVE	End date
EFT_USER_NUM	EFT user number
CLEARING_HOUSE_ID	Clearinghouse identifier
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
SOURCE_PK_ID	Source primary key identifier
LAST_UPDATE_LOGIN	Standard who column
PARTY_CODE	XTR party code
ACCOUNT_NUMBER	XTR account number
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID

Cash Management - CE_UPG_BANK_DEPENDS	This table stores a list of bank dependent product list and product impact information for bank upgrade purpose.
Column Name	Descritpion
DEPENDENT_PRODUCT_ID	Application identifier for dependent products
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
DEPENDENT_PRODUCT_NAME	Application short name for dependent products
AP_BANK_IN_USE_FLAG	Flag to indicate if AP bank branches are in use in this product
AP_ACCT_IN_USE_FLAG	Flag to indicate if AP bank accounts are in use in this product
PAY_ACCT_IN_USE_FLAG	Flag to indicate if PAY external accounts are in use in this product
UPGRADE_PHASE_NUM	Bank upgrade phase number that this product has completed
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column

Cash Management - CE_UPG_BANK_ACCOUNTS	This table stores new CE bank account information for bank upgrade purpose
Column Name	Descritpion
CE_BANK_ACCOUNT_ID	CE bank account identifier
SECONDARY_ACCT_FLAG	Flag to indicate if this record is the secondary record of the bank account group
GROUP_ID	Bank account group identifier
BANK_ACCOUNT_NAME	Bank account name
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BANK_ACCOUNT_NUM	Bank account number
SOURCE_APPLICATION_ID	Source application identifier
BRANCH_PARTY_ID	Bank party identifier
BANK_PARTY_ID	Bank branch party identifier
CURRENCY_CODE	Currency code
DESCRIPTION	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descripitive flexfield segment column
ATTRIBUTE2	Descripitive flexfield segment column
ATTRIBUTE3	Descripitive flexfield segment column
ATTRIBUTE4	Descripitive flexfield segment column
ATTRIBUTE5	Descripitive flexfield segment column
CE_UPGRADE_ID	CE upgrade identifier
ATTRIBUTE6	Descripitive flexfield segment column
ATTRIBUTE7	Descripitive flexfield segment column
ATTRIBUTE8	Descripitive flexfield segment column
ATTRIBUTE9	Descripitive flexfield segment column
ATTRIBUTE10	Descripitive flexfield segment column
ATTRIBUTE11	Descripitive flexfield segment column
ATTRIBUTE12	Descripitive flexfield segment column
ATTRIBUTE13	Descripitive flexfield segment column
ATTRIBUTE14	Descripitive flexfield segment column
ATTRIBUTE15	Descripitive flexfield segment column
PARENT_UPGRADE_ID	Parent CE upgrade identifier
REQUEST_ID	Concurrent who column
PROGRAM_APPLICATION_ID	Concurrent who column
PROGRAM_ID	Concurrent who column
PROGRAM_UPDATE_DATE	Concurrent who column
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
BANK_ACCOUNT_NAME_ALT	Alternate bank account name
ACCOUNT_HOLDER_NAME	Account holder name
ACCOUNT_HOLDER_NAME_ALT	Alternate account holder name
EFT_REQUESTER_IDENTIFIER	EFT requester identifier
SECONDARY_ACCOUNT_REFERENCE	Account number reference, such as building society roll number
SOURCE_PK_ID	Source primary key identifier
ACCOUNT_SUFFIX	Account suffix
DESCRIPTION_CODE1	Description code 1
DESCRIPTION_CODE2	Description code 2
IBAN_NUM	IBAN number
SHORT_ACCOUNT_NAME	No longer used
ACCOUNT_OWNER_PARTY_ID	Bank account owner party identifier in TCA
ACCOUNT_OWNER_ORG_ID	Bank account owner organization identifier in HR
ACCOUNT_CLASSIFICATION	Account classification (INTERNAL, EXTERNAL)
AP_USE_ALLOWED_FLAG	Flag to indicate if the account use for AP is allowed
AR_USE_ALLOWED_FLAG	Flag to indicate if the account use for AR is allowed
PARTY_CODE	XTR party code
XTR_USE_ALLOWED_FLAG	Flag to indicate if the account use for XTR is allowed
PAY_USE_ALLOWED_FLAG	Flag to indicate if the account use for PAY is allowed
MULTI_CURRENCY_ALLOWED_FLAG	Flag to indicate if the multiple currency is allowed
PAYMENT_MULTI_CURRENCY_FLAG	Flag to indicate if the payment multiple currency is enabled
RECEIPT_MULTI_CURRENCY_FLAG	Flag to indicate if the receipt multiple currency is enabled
ZERO_AMOUNT_ALLOWED_FLAG	Indicator for allowing or disallowing zero amount
MAX_OUTLAY	Maximum payment batch
MAX_CHECK_AMOUNT	Default maximum payment amount allowed for bank account in a payment batch
MIN_CHECK_AMOUNT	Default minimum payment amount allowed for bank account in a payment batch
AP_AMOUNT_TOLERANCE	Tolerance amount limit to be used for AP transactions during automatic reconciliation
ACCOUNT_NUMBER	XTR account number
AP_PERCENT_TOLERANCE	Tolerance percent to be used for AP transactions during automatic reconciliation
AR_AMOUNT_TOLERANCE	Tolerance amount limit to be used for AR transactions during automatic reconciliation
AR_PERCENT_TOLERANCE	Tolerance percent to be used for AR transactions during automatic reconciliation
XTR_AMOUNT_TOLERANCE	Tolerance amount limit to be used for XTR transactions during automatic reconciliation
XTR_PERCENT_TOLERANCE	Tolerance percent to be used for XTR transactions during automatic reconciliation
PAY_AMOUNT_TOLERANCE	Tolerance amount limit to be used for PAY transactions during automatic reconciliation
PAY_PERCENT_TOLERANCE	Tolerance percent to be used for PAY transactions during automatic reconciliation
BANK_ACCOUNT_TYPE	Bank account type code (sub account type)
AGENCY_LOCATION_CODE	Agency Location Code used by federal agencies
START_DATE	Start date
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
END_DATE	End date
YEAR_CALC_TYPE	Day count basis which defines the way in which interest accrues over time
INTEREST_CALCULATION_BASIS	Interest calculation basis (STEP or FLAT)
DAY_COUNT_TYPE_FLAG	Interest includes
ROUNDING_TYPE_FLAG	Interest rounding
CASHFLOW_DISPLAY_ORDER	Cashflow display order
TARGET_BALANCE	Target bank account balance
EFT_USER_NUM	EFT user number
BANK_CODE	Bank code
COMM_AGREEMENT_IDENTIFIER	Communication agreement identifier
LEGAL_ACCOUNT_NAME	Legal account name
PRIMARY_ACCT_FLAG	Flag to indicate if this record is the primary record of the bank account group
XTR_BANK_ACCOUNT_NUM	Treasury bank account number
AUTHORIZED_FLAG	Treasury Authorized flag
SUBSIDIARY_ACCOUNT_FLAG	Flag to indicate if the account is a subsidiary bank
CE_USE_ALLOWED_FLAG	Flag to indicate if the account use for CE is allowed

Cash Management - CE_UPG_AP_BANKS_TMP	This table stores AP purged bank branch details
Column Name	Descritpion
BANK_BRANCH_ID	Bank branch identifier
CITY	City
STATE	State or province
ZIP	Zip code
PROVINCE	No longer used
COUNTRY	Country
AREA_CODE	Area code
PHONE	Phone number
CONTACT_FIRST_NAME	First name of branch contact person
CONTACT_MIDDLE_NAME	Middle name of branch contact person
CONTACT_LAST_NAME	Last name of branch contact person
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CONTACT_PREFIX	Prefix of branch contact person (Ms., Mr., Mrs., Miss, etc.)
CONTACT_TITLE	Title of branch contact person
BANK_NUM	Branch number
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INSTITUTION_TYPE	Not used by Oracle Payables applications
CLEARING_HOUSE_ID	Not used by Oracle Payables applications
TRANSMISSION_PROGRAM_ID	Not used by Oracle Payables applications
PRINTING_PROGRAM_ID	Not used by Oracle Payables applications
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
BANK_NAME	Bank name
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
BANK_BRANCH_NAME	Bank branch name
ADDRESS_STYLE	Used as context field for FAF desc flex. Do not populate. Join with FND_TERRITORIES where COUNTRY=TERRITORY_CODE
BANK_NUMBER	Bank number. Added for Flexible Bank Structure functionality. Holds the number used by some countries to identify bank
ADDRESS_LINE4	Fourth address line. Used for flexible address formatting
COUNTY	Added for Flexible Address Format functionality
EFT_USER_NUMBER	The number that identifies you as a user of electronic funds transfer services to your bank or clearing organization
EFT_SWIFT_CODE	EFT swift code
END_DATE	End date
EDI_ID_NUMBER	EDI trading partner number for the Bank Branch
BANK_BRANCH_TYPE	Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT and OTHER
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
DESCRIPTION	Description
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
ADDRESS_LINE1	First address line
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
ADDRESS_LINE2	Second address line
BANK_NAME_ALT	Alternate bank name
BANK_BRANCH_NAME_ALT	Alternate bank branch name
ADDRESS_LINES_ALT	Alternate address lines
ACTIVE_DATE	Active date
TP_HEADER_ID	Trading partner header identifier
ECE_TP_LOCATION_CODE	Trading partner location code
PAYROLL_BANK_ACCOUNT_ID	Bank account identifier for payroll bank accounts
RFC_IDENTIFIER	Regional Finance Center Identifier used only to identify a branch of the United States Treasury bank.
BANK_ADMIN_EMAIL	E-mail address for XML messages administrator at the bank
ADDRESS_LINE3	Third address line

Cash Management - CE_UPG_RELATIONSHIP_REC	This table stores relationship information for bank, bank branch, and bank account contact including job title
Column Name	Descritpion
PARTY_ID	TCA party identifier
OBJECT_ID	Object identifier of the relationship
START_DATE	Date relationship begins
END_DATE	Date relationship ends
CREATED_BY_MODULE	Created by module
RELATIONSHIP_ID	Relationship identifier
RELATIONSHIP_TYPE	Relationship type
RELATIONSHIP_CODE	Relationship code
JOB_TITLE	Contact job title
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
CE_UPGRADE_ID	CE upgrade identifier
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
SUBJECT_TYPE	Subject type of the relationship
SUBJECT_TABLE_NAME	Source table name for the subject
SUBJECT_ID	Subject identifier of the relationship
OBJECT_TYPE	Object type of the relationship
OBJECT_TABLE_NAME	Source table name for the object

Cash Management - CE_UPG_PURGE_PAY_ACCTS	This table records all processed PAY external account results for Bank Upgrade Purging program
Column Name	Descritpion
EXTERNAL_ACCOUNT_ID	PAY external account identifier
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
ACCOUNT_NUMBER	PAY bank account number
BANK_NAME	Bank name
BRANCH_NAME	Bank branch name
COUNTRY	Country name
COUNTRY_CODE	Country code
DELETE_FLAG	Flag to indicate if the bank account is deletable (Y or N)
REQUEST_ID	Concurrent request identifier
CREATION_DATE	Standard who column

Cash Management - CE_UPG_PURGE_AP_BANKS	This table records all processed AP bank branch results for Bank Upgrade Purging program
Column Name	Descritpion
BANK_BRANCH_ID	AP bank branch identifier
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
COUNTRY	Country name
BANK_NAME	Bank name
BANK_BRANCH_NAME	Bank branch name
BANK_NUMBER	Bank number
BRANCH_NUMBER	Bank branch number
DELETE_FLAG	Flag to indicate if the bank branch is deletable (Y or N)
REQUEST_ID	Concurrent request identifier
CREATION_DATE	Standard who column

Cash Management - CE_UPG_PURGE_AP_ACCTS	This table records all processed AP bank account results for Bank Upgrade Purging program
Column Name	Descritpion
BANK_ACCOUNT_ID	AP bank account identifier
DELETE_FLAG	Flag to indicate if the bank account is deletable (Y or N)
REQUEST_ID	Concurrent request identifier
BANK_BRANCH_ID	AP Bank branch identifier
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BANK_ACCOUNT_NAME	Bank account name
BANK_ACCOUNT_NUM	Bank account number
COUNTRY	Country name
BANK_NAME	Bank name
BANK_BRANCH_NAME	Bank branch name
CURRENCY_CODE	Currency code
ORGANIZATION_NAME	Organization name
ACCOUNT_TYPE	Account type

Cash Management - CE_UPG_PERSON_REC	This table stores person party information for bank branch contact or bank account contact
Column Name	Descritpion
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CE_UPGRADE_ID	CE upgrade identifier
PERSON_PARTY_ID	TCA person party identifier
PERSON_FIRST_NAME	First name of the person
PERSON_MIDDLE_NAME	Middle name of the person
PERSON_LAST_NAME	Last name of the person
PERSON_PRE_NAME_ADJUNCT	Salutary introduction, such as Mr.
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column

Cash Management - CE_UPGA_RELATION_REC	This table is an audit table of CE_UPG_RELATIONSHIP_REC
Column Name	Descritpion
PARTY_ID	TCA party identifier
OBJECT_ID	Object identifier of the relationship
START_DATE	Date relationship begins
END_DATE	Date relationship ends
CREATED_BY_MODULE	Created by module
RELATIONSHIP_ID	Relationship identifier
RELATIONSHIP_TYPE	Relationship type
RELATIONSHIP_CODE	Relationship code
JOB_TITLE	Contact job title
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
CE_UPGRADE_ID	CE upgrade identifier
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
SUBJECT_TYPE	Subject type of the relationship
SUBJECT_TABLE_NAME	Source table name for the subject
SUBJECT_ID	Subject identifier of the relationship
OBJECT_TYPE	Object type of the relationship
OBJECT_TABLE_NAME	Source table name for the object

Cash Management - CE_UPGA_LOC_REC	This table is an audit table of CE_UPG_LOC_REC
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
ADDRESS_STYLE	Address style
CITY	City
STATE	State
PROVINCE	Province
COUNTY	County
POSTAL_CODE	Postal code
ADDRESS_LINE_PHONETIC	Alternate address line
LOCATION_ID	Location identifier
CREATED_BY_MODULE	Created by module
CREATION_DATE	Standard who column
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
IDENTIFYING_ADDRESS_FLAG	Flag to identify if this is the primary address
COUNTRY	Country
ADDRESS1	Address line 1
ADDRESS2	Address line 2
ADDRESS3	Address line 3
ADDRESS4	Address line 4

Cash Management - CE_UPGA_CONT_POINT_REC	This table is an audit table of CE_UPG_CONT_POINT_REC
Column Name	Descritpion
CE_UPGRADE_ID	CE upgrade identifier
EDI_TP_HEADER_ID	EDI trading partner header identifier
EDI_ECE_TP_LOCATION_CODE	EDI trading partner location code
EFT_TRANSMISSION_PROGRAM_ID	Trasmission program identifier
EFT_PRINTING_PROGRAM_ID	Printing program identifier
EFT_SWIFT_CODE	EFT swift code
PHONE_AREA_CODE	The area code within a country code
PHONE_NUMBER	Phone number
ORG_PRIMARY_PHONE_FLAG	Organization primary phone line flag (Y or N)
EMAIL_ADDRESS	E-mail address of the contact point
CONTACT_POINT_ID	TCA contact point identifier
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CONTACT_POINT_TYPE	Contact point type
PHONE_LINE_TYPE	Lookup code for the type of phone line
OWNER_TABLE_NAME	Table that stores the owner of the contact point
OWNER_TABLE_ID	Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point
CREATED_BY_MODULE	Created by module
EDI_ID_NUMBER	EDI trading partner number

Cash Management - CE_UPGA_BANK_REC	This table is an audit table of CE_UPG_BANK_REC
Column Name	Descritpion
PARTY_ID	TCA party identifier
BANK_CODE	Bank code
BRANCH_CODE	Branch code
INSTITUTION_TYPE	Institution type
COUNTRY	Country
BRANCH_TYPE	Bank branch type
RFC_CODE	RFC identifier
CREATED_BY_MODULE	Created by module
ORGANIZATION_NAME	Organization name
ORGANIZATION_NAME_PHONETIC	Alternate organization name
KNOWN_AS	Bank or bank branch short name
CE_UPGRADE_ID	CE upgrade identifier
JGZZ_FISCAL_CODE	Taxpayer identifier
MISSION_STATEMENT	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descripitive flexfield segment column
ATTRIBUTE2	Descripitive flexfield segment column
ATTRIBUTE3	Descripitive flexfield segment column
ATTRIBUTE4	Descripitive flexfield segment column
ATTRIBUTE5	Descripitive flexfield segment column
ATTRIBUTE6	Descripitive flexfield segment column
ATTRIBUTE7	Descripitive flexfield segment column
PARENT_UPGRADE_ID	Parent CE upgrade identifier
ATTRIBUTE8	Descripitive flexfield segment column
ATTRIBUTE9	Descripitive flexfield segment column
ATTRIBUTE10	Descripitive flexfield segment column
ATTRIBUTE11	Descripitive flexfield segment column
ATTRIBUTE12	Descripitive flexfield segment column
ATTRIBUTE13	Descripitive flexfield segment column
ATTRIBUTE14	Descripitive flexfield segment column
ATTRIBUTE15	Descripitive flexfield segment column
START_DATE_ACTIVE	Start date
END_DATE_ACTIVE	End date
BANK_ENTITY_TYPE	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
EFT_USER_NUM	EFT user number
CLEARING_HOUSE_ID	Clearinghouse identifier
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
UPGRADE_STATUS	Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
PRIMARY_FLAG	Flag to indicate if this record is the primary record of the bank or bank branch group
SECONDARY_FLAG	Flag to indicate if this record is the secondary record of the bank or bank branch group
GROUP_ID	Bank or bank branch group identifier
BANK_OR_BRANCH_NUMBER	Bank number, bank branch number, clearinghouse number, or clearinghouse branch number

Cash Management - CE_BANK_UPGRADE_MODES	This table stores the bank upgrade mode of each bank entity for source products that current bank tables reside in.
Column Name	Descritpion
SOURCE_PRODUCT_NAME	Source product name. Possible values are AP, XTR, PAY, and ALL.
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BANK_UPGRADE_MODE	Bank upgrade mode. Possible values are PRE_GROUP, GROUPED, and FROZEN.
BRANCH_UPGRADE_MODE	Bank branch upgrade mode. Possible values are PRE_GROUP, GROUPED, and FROZEN.
ACCOUNT_UPGRADE_MODE	Bank account upgrade mode. Possible values are PRE_GROUP, GROUPED, and FROZEN.
LAST_BANK_UPG_ID	Last group frozen bank upgrade identifier
LAST_ACCOUNT_UPG_ID	Last group frozen account upgrade identifier
LAST_ACCT_USE_UPG_ID	Last group frozen account use upgrade identifier
CREATION_DATE	Standard who column
CREATED_BY	Standard who column

Cash Management - CE_FORECAST_OPENING_BAL	This table stores the opening bank balance or GL cash account balance for a particular Start Date pertaining to a set of forecast results
Column Name	Descritpion
BALANCE_ID	Balance identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FORECAST_ID	Forecast identifier
BALANCE_TYPE	Balance type - Bank Account or GL Cash Account
BANK_ACCOUNT_ID	Bank Account identifier
CODE_COMBINATION_ID	Accounting Flexfield identifier for GL Cash Account associated with bank account
OPENING_BALANCE	Opening balance
BALANCE_DATE	Balance date
PRIOR_DAY_CFLOW	Prior-day cashflow
LEGAL_ENTITY_ID	Legal entity identifier

Cash Management - CE_FORECAST_PERIODS	This table stores new column setup information defined by the Automatic Column Setup
Column Name	Descritpion
FORECAST_PERIOD_ID	System-assigned forecast period identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FORECAST_HEADER_ID	Forecast header identifier
LEVEL_OF_SUMMARY	Level of summary, lookup type FORECAST_SUMMARY_LEVEL
PERIOD_NUMBER	Period sequence identifier
LENGTH_OF_PERIOD	Length of period
LENGTH_TYPE	Length type, lookup type FORECAST_LENGTH_TYPE
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Cash Management - CE_CP_TRX_EXCLUDED	This table temporarily stores the transactions being excluded in a cash position result
Column Name	Descritpion
WORKSHEET_HEADER_ID	Cash Position worksheet header identifier
CREATED_BY	Standard Who column
BANK_ACCOUNT_ID	Bank Account Id of the excluded transaction
CURRENCY	Currency of the excluded transaction
AS_OF_DATE	Cash Position result as of date
TRX_TYPE	Transaction type
REFERENCE_ID	Reference identifier
EXCLUDE_FLAG	Exclude flag, always E
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATION_DATE	Standard Who column

Cash Management - CE_CP_WORKSHEET_HEADERS	This table stores the Cash Position worksheet header definitions
Column Name	Descritpion
WORKSHEET_HEADER_ID	Cash Position worksheet header identifier
WORKSHEET_NAME	Cash Position worksheet name
COLUMNS_DISPLAYED	Number of columns displayed in the Cash Position results
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
PD_FLAG	Use Summary Prior Day Cash Flow and Overdue Transactions?

Cash Management - CE_CP_WORKSHEET_LINES	This table stores the Cash Position worksheet details
Column Name	Descritpion
WORKSHEET_HEADER_ID	Cash Position worksheet header identifier
FLOAT_TYPE	Float type, CE lookup type FLOAT_TYPE
TRX_TYPE	Transaction type
PAYMENT_METHOD	Payment method for APP and PAY
RECEIPT_METHOD_ID	Payment method for ARR
CLEARED_TRX_FLAG	Include cleared transactions? (Y/N)
OVERDUE_TRX_FLAG	Include overdue transactions? (Y/N)
CUT_OFF_DAYS	Cut off days
EXT_SOURCE_TYPE	External source type for open interface
AMOUNT	Amount for user-defined transactions
PAYROLL_ID	Payroll identifier
WORKSHEET_LINE_ID	Cash Position worksheet line identifier
INDICATIVE_FLAG	Include indicative exposures for XTR? (Y/N)
CRITERIA_CATEGORY	External source type descriptive flexfield structure definition column
CRITERIA1	External source type descriptive flexfield segment
CRITERIA2	External source type descriptive flexfield segment
CRITERIA3	External source type descriptive flexfield segment
CRITERIA4	External source type descriptive flexfield segment
CRITERIA5	External source type descriptive flexfield segment
CRITERIA6	External source type descriptive flexfield segment
CRITERIA7	External source type descriptive flexfield segment
CRITERIA8	External source type descriptive flexfield segment
SOURCE_TYPE	Transaction source type
CRITERIA9	External source type descriptive flexfield segment
CRITERIA10	External source type descriptive flexfield segment
CRITERIA11	External source type descriptive flexfield segment
CRITERIA12	External source type descriptive flexfield segment
CRITERIA13	External source type descriptive flexfield segment
CRITERIA14	External source type descriptive flexfield segment
CRITERIA15	External source type descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INCLUDE_FLAG	Flag to show if the line should be included in the Cash Position result
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
CASHPOOL_ID	Cash pool identifier
TRXN_SUBTYPE_CODE_ID	Transaction subtype for Cash Management infows and outflows
DESCRIPTION	Description
LEGAL_ENTITY_ID	Legal entity identifier
BANK_NAME	Bank name
BANK_ACCOUNT_ID	Bank account identifier
BALANCE_TYPE	Balance type, CE lookup type BANK_ACC_BAL_TYPE

Cash Management - CE_CP_PRIORDAY_BALANCES	This table stores the summarized data for transaction sources
Column Name	Descritpion
WORKSHEET_HEADER_ID	Worksheet header identifier
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
AS_OF_DATE	As of date
BANK_ACCOUNT_ID	Bank account identifier
BALANCE_DATE	Balance date
SOURCE_TYPE	Source type
BALANCE	Balance
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Cash Management - CE_AVAILABLE_TRANSACTIONS_TMP
Column Name	Descritpion
ROW_ID
TYPE_MEANING
TRX_NUMBER
CHECK_NUMBER
CURRENCY_CODE
AMOUNT
BANK_ACCOUNT_AMOUNT
AMOUNT_CLEARED
GL_DATE
STATUS_DSP
STATUS
MULTI_SELECT
DESCRIPTION
TRX_DATE
CLEARED_DATE
MATURITY_DATE
EXCHANGE_RATE_DATE
EXCHANGE_RATE_TYPE
USER_EXCHANGE_RATE_TYPE
EXCHANGE_RATE
BANK_CHARGES
BANK_ERRORS
BANK_ACCOUNT_ID
BATCH_NAME
BATCH_ID
AGENT_NAME
CUSTOMER_NAME
PAYMENT_METHOD
VENDOR_NAME
CUSTOMER_ID
SUPPLIER_ID
REFERENCE_TYPE_DSP
REFERENCE_TYPE
BANK_ACCOUNT_NAME
REFERENCE_ID
ACTUAL_AMOUNT_CLEARED
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
REMITTANCE_NUMBER
CASH_RECEIPT_ID
APPLICATION_ID
COUNT_CLEARED
BANK_ACCOUNT_NUM
BANK_CURRENCY_CODE
TRX_CURRENCY_TYPE
CODE_COMBINATION_ID
PERIOD_NAME
JOURNAL_ENTRY_NAME
DOCUMENT_NUMBER
JOURNAL_ENTRY_LINE_NUMBER
CLEARING_TRX_TYPE
JOURNAL_CATEGORY
BASE_AMOUNT
BANK_NAME
RECEIPT_CLASS_ID
RECEIPT_METHOD_ID
RECEIPT_CLASS_NAME
DEPOSIT_DATE
VALUE_DATE
REVERSED_RECEIPT_FLAG
LEGAL_ENTITY_ID
ORG_ID
INVOICE_TEXT
BANK_ACCOUNT_TEXT
BANK_BRANCH_NAME
CUSTOMER_TEXT
COUNTERPARTY
TRXN_SUBTYPE
CE_BANK_ACCT_USE_ID
RECONCILED_STATUS_FLAG
SEQ_ID
TRX_ID
TRX_TYPE

Cash Management - CE_PROJECTED_BALANCES	This table stores the projected balances of internal bank accounts.
Column Name	Descritpion
BANK_ACCOUNT_ID	Bank account identifier
BALANCE_DATE	Balance date
PROJECTED_BALANCE	Projected balance
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
PROJECTED_BALANCE_ID	Projected balance identifier
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_BA_SIGNATORY_HIST_H	This table stores the history information bank account signatory for a bank account
Column Name	Descritpion
SIGNATORY_HISTORY_ID	Unique identifier for signatory history record
LAST_UPDATED_BY	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
SIGNATORY_ID	Signatory_id from ce_ba_signatories table
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
APPROVER_PERSON_ID	Person id of the approver or requestor from HR person data
ACTION	Approver's notification responses: CREATED, UPDATED, DELETED, APPROVED, or REJECTED
CURRENT_RECORD_FLAG	Y or N. Y indicates that this is the latest history record
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Cash Management - CE_BANK_ACCT_BALANCES	This table stores the internal bank account balances
Column Name	Descritpion
BANK_ACCOUNT_ID	Bank account identifier
BALANCE_DATE	Balance date
LEDGER_BALANCE	Ledger balance
AVAILABLE_BALANCE	Available balance
VALUE_DATED_BALANCE	Value dated balance. This balance is used to calculate cash pool balance
ONE_DAY_FLOAT	One day float balance
TWO_DAY_FLOAT	Two day float balance
AVERAGE_CLOSE_LEDGER_MTD	Average closing ledger MTD
BANK_ACCT_BALANCE_ID	Bank Account Balance Identifier
AVERAGE_CLOSE_LEDGER_YTD	Average closing ledger YTD
AVERAGE_CLOSE_AVAILABLE_MTD	Average closing available MTD
AVERAGE_CLOSE_AVAILABLE_YTD	Average closing available YTD
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_BA_SIGNATORIES	This table stores the Bank Account Signatory information for a bank account
Column Name	Descritpion
BANK_ACCOUNT_ID	Unique identifier of the bank account from
STATUS	Indicates approval status for this signatory as APPROVED, PENDING, or REJECTED
APPROVAL_TYPE_FLAG	M or W. M indicates manually approved. W indicates approval using Oracle Workflow.
DELETED_FLAG	Y or N. Y indicates the record is soft-deleted and cannot be used . Default is N.
REQUESTER_ID	Person_id of the user submitting the workflow request. employee_id derived from the FND_USER table
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column
SIGNATORY_ID	Unique identifier for each row in this table
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
PERSON_ID	Person_id of the person added as a bank account
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SINGLE_LIMIT_AMOUNT	Single limit amount
JOINT_LIMIT_AMOUNT	Joint limit amount
SIGNER_GROUP	Person belongs to this group signatories
OTHER_LIMITS	Other limitations
START_DATE	Start date of the bank account signatory
END_DATE	End date

Cash Management - CE_CASHFLOWS	This table stores the cashflows
Column Name	Descritpion
CASHFLOW_ID	Unique cashflow reference number created by the system
DESCRIPTION	Free text description
CASHFLOW_EXCHANGE_RATE	Cashflow exchange rate
CASHFLOW_EXCHANGE_DATE	Cashflow exchange date
CASHFLOW_EXCHANGE_RATE_TYPE	Cashflow exchange rate type
TRXN_REFERENCE_NUMBER	Payment transaction identifier
BANK_TRXN_NUMBER	Bank Transaction Number to be used in reconciliation match
SOURCE_TRXN_TYPE	Source Transaction Type
SOURCE_TRXN_SUBTYPE_CODE_ID	Transaction sub-type code identifier
STATEMENT_LINE_ID	Statement Line ID required for reconciliation of JEC and ZBA flows
ACTUAL_VALUE_DATE	The actual value date on which the cashflow is settled by the bank. Populated upon clearing or reconciliation.
CASHFLOW_LEDGER_ID	Ledger ID of cashflow
COUNTERPARTY_PARTY_ID	TCA HZ identifier of counterparty
COUNTERPARTY_BANK_ACCOUNT_ID	Identifier of the counter party''s bank account.Links to the internal and external bank accounts table
OFFSET_CCID	CCID of non-cash GL account used in seeded accounting definition for clearing event
CASHFLOW_STATUS_CODE	Value include Created, Cleared, Reconciled, Canceled
CLEARED_DATE	Date on which the cashflow was cleared by the bank
CLEARED_AMOUNT	Cash flow amount (in bank account currency) as returned from the bank upon clearing or reconciliation
CLEARED_EXCHANGE_RATE	Exchange rate used to calculate cleared base amount(functional currency) from cleared amount (bank account currency)
CLEARED_EXCHANGE_DATE	Exchange date used to calculate cleared base amount (functional currency) from cleared amount (bank account currency).
CLEARED_EXCHANGE_RATE_TYPE	Exchange rate type used to calculate cleared base amount (functional currency) from cleared amount (bank account currency)
CLEARING_CHARGES_AMOUNT	Charges amount in bank account currency as returned from bank upon clearing or reconciliation
CASHFLOW_LEGAL_ENTITY_ID	Legal Entity identifier of cashflow owner
CLEARING_ERROR_AMOUNT	Clearing error amount in bank account currency as returned from bank upon clearing or reconciliation
CLEARED_BY_FLAG	Flag to include whether cashflow is cleared by Manual Clearing or Reconciliation Values : M, R
REFERENCE_TEXT	Reference Text
BANK_ACCOUNT_TEXT	Bank Account Text
CUSTOMER_TEXT	Customer Text
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CASHFLOW_BANK_ACCOUNT_ID	Identifier of the bank account that owns the cashflow. Links to the internal bank accounts table
OBJECT_VERSION_NUMBER	Standard Who column
CASHFLOW_DIRECTION	Values Include: PAYMENT and RECEIPT (Payment and Receipt)
CASHFLOW_CURRENCY_CODE	Payment Currency Code
CASHFLOW_DATE	Cashflow date
CASHFLOW_AMOUNT	Cashflow amount in cashflow trx currency
BASE_AMOUNT	Cashflow Amount in functional currency

Cash Management - CE_CASHFLOW_ACCT_H	This table stores the history of cashflows
Column Name	Descritpion
CASHFLOW_ID	Foreign key to ce_cashflows table
CLEARED_EXCHANGE_DATE	Exchange date used to calculate cleared base amount(functional currency) from cleared amount (bank account currency)
CLEARED_EXCHANGE_RATE_TYPE	Exchange rate type used to calculate cleared base amount(functional currency) from cleared amount (bank account currency)
CLEARING_CHARGES_AMOUNT	Charges amount in bank account currency as returned from bank upon clearing or reconciliation
CLEARING_ERROR_AMOUNT	Clearing error amount in bank account currency as returned from bank upon clearing or reconciliation
REVERSAL_INDICATOR_FLAG	Reversal Indicator flag
REVERSAL_FIRST_DIST_ID	Reversal First id
REVERSAL_SECOND_DIST_NUM	Reversal Second id
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
EVENT_ID	Accounting Event ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column
EVENT_TYPE	Accounting Event Type
ACCOUNTING_DATE	Accounting Date
STATUS_CODE	Indicates the accounting status: UNACCOUNTED,ACCOUNTED,ACCOUNTING_ERROR,NOT_APPLICABLE
CURRENT_RECORD_FLAG	Current Record Flag
CLEARED_DATE	Date on which the cashflow was cleared by the bank
CLEARED_AMOUNT	Cash flow amount (in bank account currency) as returned from the bank upon clearing or reconciliation
CLEARED_EXCHANGE_RATE	Exchange rate used to calculate cleared base amount(functional currency) from cleared amount (bank account currency)

Cash Management - CE_TRXNS_SUBTYPE_CODES	Transaction Subtype Codes
Column Name	Descritpion
TRXN_SUBTYPE_CODE_ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object Version Number
TRANSACTION_SUB_TYPE_NAME
PARENT_SUBTYPE_CODE_ID
TRXN_SUBTYPE_SHORT_NAME
TRXN_SUBTYPE_DESCRIPTION
TRXN_SUBTYPE_DEFAULT_FLAG
TRXN_TYPE
TRXN_SUBTYPE_STATUS
END_DATE

Cash Management - CE_PAYMENT_TEMPLATES	This table stores payment template information.
Column Name	Descritpion
PAYTEMPLATE_REFERENCE_NUMBER	Uniquely identifies the payment template
PAYMENT_CURRENCY_CODE	payment currency code, specifies the currency in which the payee expects to receive the payment
PAYMENT_AMOUNT	amount to be paid in payment currency, needs to be positive
SOURCE_BANK_ACCOUNT_ID	Identifier of the source party bank account that will be used to process this transaction
SOURCE_LEGAL_ENTITY_ID	Legal Entity identifier of source party
SOURCE_BANK_BRANCH_ID
SOURCE_BANK_ID
DESTINATION_LEGAL_ENTITY_ID	Legal Entity identifier of desination party. Polulated only if the destination party is an internal legal entity
DESTINATION_BANK_ACCOUNT_ID	Identifier of the destination party bank account that will be used to process this transaction
DESTINATION_BANK_BRANCH_ID
DESTINATION_BANK_ID
PAYMENT_TEMPLATE_CODE	unique template reference code, created by the user
DESTINATION_PARTY_SITE_USE_ID	TCA HZ identifier of destination party site use. The identifier will be used to derive address information if required by the payment method
PAYMENT_METHOD_CODE
BANK_CHARGE_BEARER	Bearer of bank charge cost
PAYMENT_REASON_CODE	Payment reason code
PAYMENT_REASON_COMMENTS	free text field available for entering a reason for the payment
REPETITIVE_CODE
TEMPLATE_STATUS
END_DATE
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column
ATTRIBUTE1
SETTLE_BY_SYSTEM_FLAG	Y/N flag used to indicate whether the transaction will be settled by the system or not
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
AUTHORIZE_FLAG	Y/N flag used to indicate whether the transaction will require authorization
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object Version Number
TRANSACTION_TYPE	transaction type
PAYTEMPLATE_SUBTYPE_CODE_ID	Transaction sub type.
ANTICIPATED_VALUE_DAYS	anticipated value days
TRANSACTION_DESCRIPTION	free text description
TRANSACTION_COMMENTS	transaction comments

Cash Management - CE_PAYMENT_TRANSACTIONS	This table stores the bank account transfers
Column Name	Descritpion
TRXN_REFERENCE_NUMBER	Payment Transaction Identifier
SOURCE_PARTY_ID	TCA HZ identifier of source party
SOURCE_LEGAL_ENTITY_ID	Legal Entity identifier of source party
SOURCE_BANK_ACCOUNT_ID	Identifier of the source partys bank account that will be used to process this transaction. Links to the internal bank accounts table
DESTINATION_PARTY_ID	TCA HZ identifier of destination party
DESTINATION_LEGAL_ENTITY_ID	Legal Entity identifier of destination party.Populated only if the destination party is an internal legal entity.
DESTINATION_BANK_ACCOUNT_ID	Identifier of the destination partys bank account that will be used to process this transaction. Links to the internal bank accounts table
DESTINATION_PARTY_SITE_ID	TCA HZ identifier of destination party site use.This identifier will be used to derive address information if required by the payment method
REPETITIVE_PAYMENT_CODE	Repetitive code used in wire transfers
TRXN_STATUS_CODE	Transaction status. Indicates whether the transaction has been
PAYMENT_METHOD_CODE	Payment method identifier
SETTLE_BY_SYSTEM_FLAG	Valued Include Y/N
AUTHORIZE_FLAG	Authorize flag
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER
PAYMENT_REASON_CODE	Payment reason code
PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment
REMITTANCE_MESSAGE1	Remittance message for use in payment processing
REMITTANCE_MESSAGE2	Remittance message for use in payment processing
REMITTANCE_MESSAGE3	Remittance message for use in payment processing
CREATED_FROM_DIR	Statement Line type. Either PAYMENT or RECEIPT.
CREATE_FROM_STMTLINE_ID	Statement Line Identifier
BANK_TRXN_NUMBER	Bank Transaction Number
TRANSACTION_TYPE	Transaction Type
PAYMENT_REQUEST_NUMBER	Payment request number
PAPER_DOCUMENT_NUMBER	Payment document number, if a printed payment.Generated by Oracle Payments if payment is printed by system. Recorded by user otherwise
DOC_SEQUENCE_ID	Transaction sequence id
DOC_SEQUENCE_VALUE	Transaction sequence value
DOC_CATEGORY_CODE	Transaction category code
PAYMENT_OFFSET_CCID	CCID of non-cash GL account used in seeded accounting definition for clearing event
RECEIPT_OFFSET_CCID	CCID of non-cash GL account used in seeded accounting definition for clearing event
CASHPOOL_ID	Cash pool id
EXT_BANK_ACCOUNT_ID	External Bank Account ID
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column
TRXN_SUBTYPE_CODE_ID	Transaction sub type code identifier
ATTRIBUTE1	Attribute1
ATTRIBUTE2	Attribute2
ATTRIBUTE3	Attribute3
ATTRIBUTE4	Attribute4
ATTRIBUTE5	Attribute5
ATTRIBUTE6	Attribute6
ATTRIBUTE7	Attribute7
ATTRIBUTE8	Attribute8
ATTRIBUTE9	Attribute9
ATTRIBUTE10	Attribute10
TRANSACTION_DATE	Transaction date
ATTRIBUTE11	Attribute11
ATTRIBUTE12	Attribute12
ATTRIBUTE13	Attribute13
ATTRIBUTE14	Attribute14
ATTRIBUTE15	Attribute15
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ANTICIPATED_VALUE_DATE	Anticipated value date
OBJECT_VERSION_NUMBER	Object Version Number
TRANSACTION_DESCRIPTION	Free text description
PAYMENT_CURRENCY_CODE	Payment Currency Code
PAYMENT_AMOUNT	Amount to be paid in payment currency

Cash Management - CE_CE_TRANSACTION_CODES	This table is a backup of the ce_transaction_codes table before the bank account foreign key upgrade.
Column Name	Descritpion
TRANSACTION_CODE_ID	Uniquely identifies the transaction code
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_STATEMENT_HEADERS	This table is a backup of the ce_statement_headers table before the bank_account_id foreign key upgrade.
Column Name	Descritpion
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number
STATEMENT_HEADER_ID	Uniquely identifies the bank statement

Cash Management - CE_CE_CP_WORKSHEET_LINES	This table is a backup of the ce_cp_worksheet_lines table before the bank account foreign key upgrade.
Column Name	Descritpion
WORKSHEET_LINE_ID	Uniquely identifies the worksheet line
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_INTRA_STMT_HEADERS	This table is a backup of the ce_intra_stmt_headers table before the bank account foreign key upgrade.
Column Name	Descritpion
STATEMENT_HEADER_ID	Uniquely identifies the bank statement
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_FORECAST_TRX_CELLS	This table is a backup of the ce_forecast_trx_cells table before the bank account foreign key upgrade.
Column Name	Descritpion
FORECAST_CELL_ID	Uniquely identifies the forecast cell
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_CASHPOOL_SUB_ACCTS	This table is a backup of the ce_cashpool_sub_accts table before the bank account foreign key upgrade.
Column Name	Descritpion
CASHPOOL_SUB_ACCT_ID	Uniquely identifies the cashpool
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number
CONC_ACCOUNT_ID	Concentration bank account identifier
INV_CONC_ACCOUNT_ID	Investment concentration bank account identifier
FUND_CONC_ACCOUNT_ID	Funding concentration bank account identifier
ACCOUNT_ID	Bank account identifier or child cash pool identifier
TYPE	Type of sub account (ACCT: Bank Account, POOL: Cash Pool, CONC: Normal concentration account, INV: Investment concentration account, FUND: Funding concentration account, NEST: Bank Account from a nested cash pool)
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Cash Management - CE_CE_BA_SIGNATORIES	This table is a backup of the ce_ba_signatories table before the bank account foreign key upgrade.
Column Name	Descritpion
SIGNATORY_ID	Uniquely identifies the bank statement
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_ARCH_INTRA_HEADERS	This table is a backup of the ce_arch_intra_headers table before the bank account foreign key upgrade.
Column Name	Descritpion
STATEMENT_HEADER_ID	Uniquely identifies the bank statement
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_FORECAST_ROWS	This table is a backup of the ce_forecast_rows table before the bank account foreign key upgrade.
Column Name	Descritpion
FORECAST_ROW_ID	Uniquely identifies the forecast row
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_FC_OPENING_BAL	This table is a backup of the ce_fc_opening_bal table before the bank account foreign key upgrade.
Column Name	Descritpion
BALANCE_ID	Uniquely identifies the forecast opening balance
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_ARCH_HEADERS	This table is a backup of the ce_arch_headers table before the bank_account_id foreign key upgrade.
Column Name	Descritpion
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number
STATEMENT_HEADER_ID	Uniquely identifies the bank statement

Cash Management - CE_CE_JE_MAPPINGS	This table is a backup of the ce_je_mappings table before the bank account foreign key upgrade.
Column Name	Descritpion
JE_MAPPING_ID	Uniquely identifies the bank statement
BANK_ACCOUNT_ID	Uniquely identifies the bank account
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number

Cash Management - CE_CE_CP_PD_BALANCES	This table is a backup of the ce_cp_priorday_balances table before the bank account foreign key upgrade.
Column Name	Descritpion
WORKSHEET_HEADER_ID	Uniquely identifies the balance
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number
CE_BANK_ACCOUNT_ID	Bank Account Identifier
AS_OF_DATE
BANK_ACCOUNT_ID	Uniquely identifies the bank account
SOURCE_TYPE
ROWID_VAR
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Cash Management - CE_CE_CASHPOOLS	This table is a backup of the ce_cashpools table before the bank account foreign key upgrade.
Column Name	Descritpion
CASHPOOL_ID	Uniquely identifies the cashpool
OBJECT_VERSION_NUMBER	Object version number
CONC_ACCOUNT_ID	Concentration bank account identifier
INV_CONC_ACCOUNT_ID	Investment concentration bank account identifier
FUND_CONC_ACCOUNT_ID	Funding concentration bank account identifier
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Cash Management - CE_CONTACT_ASSIGNMENTS	This table contains the information about which level (bank, branch, account) the contact is assigned to.
Column Name	Descritpion
CONTACT_ASSIGNMENT_ID	Contact Assignment Identifier
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
ASSIGNMENT_TYPE	Type of the assignment. BANK, BRANCH, or ACCOUNT
RELATIONSHIP_ID	Relationship Identifier
BANK_PARTY_ID	Bank Party Identifier
BRANCH_PARTY_ID	Bank Branch Party Identifier
BANK_ACCOUNT_ID	Bank account identifier
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Cash Management - CE_CASHPOOLS	This table stores header information about the cash pool
Column Name	Descritpion
CASHPOOL_ID	System-assigned cash pool identifier
EFFECTIVE_DATE_FROM	Cash Pool effective date from
EFFECTIVE_DATE_TO	Cash Pool effective date to
SWEEPS_FLAG	Flag to indicate whether the cash pool is set up for bank-initiated sweeps
PARENT_CASHPOOL_ID	Parent cash pool identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LEGAL_ENTITY_ID	Legal entity identifier
TRXN_SUBTYPE_CODE_ID	Transaction Subtype Code identifier
AUTHORIZATION_BAT	Flag to indicate whether Bank Account Transfer Authorization is required or not
NAME	Cash Pool name
CURRENCY_CODE	Cash Pool currency
TYPE	Cash Pool type: NOTIONAL or PHYSICAL
CONC_ACCOUNT_ID	Concentration bank account identifier
INV_CONC_ACCOUNT_ID	Investment concentration bank account identifier
FUND_CONC_ACCOUNT_ID	Funding concentration bank account identifier
SINGLE_CONC_ACCOUNT_FLAG	Flag to indicate whether the cash pool has only one concentration account
PARTY_CODE	Cash Pool company party code

Cash Management - CE_AP_PM_DOC_CATEGORIES	This table stores payment document categories and payment methods for bank account uses
Column Name	Descritpion
AP_PM_DOC_CATEGORY_ID	Uniquely identifies the payment document category
OBJECT_VERSION_NUMBER	Object version number
BANK_ACCT_USE_ID	Uniquely identifies the bank account use
PAYMENT_METHOD_CODE	Payment method code
PAYMENT_DOC_CATEGORY	Payment document category
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Cash Management - CE_PROPOSED_TRANSFERS	This table stores information about proposed cash leveling transfers. This table will be purged after all Cash Leveling fund transfers (from a particular Cash Leveling Proposal) are complete
Column Name	Descritpion
PROPOSED_TRANSFER_ID	System-assigned proposed transfer identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUB_ACCOUNT_ID	Sub account identifier
CONC_ACCOUNT_ID	Concentration bank account identifier
CLOSING_BALANCE	Closing Balance
TRANSFER_AMOUNT	Transfer amount
CASHPOOL_ID	Cash pool identifier
STATUS	Transfer status: PROPOSED or SUBMITTED
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Cash Management - CE_LEVELING_MESSAGES	This tables stores the errors generated as a result of the cash leveling process as well as the information about the deals generated as a result of the cash leveling process
Column Name	Descritpion
LEVELING_MESSAGE_ID	System-assigned cash leveling message identifier
TRX_NUMBER	Transaction number
OFFSET_DEAL_NO	Offsetting deal number
OFFSET_TRX_NUMBER	Offsetting transaction number
SUCCESS_FLAG	Flag to indicate whether this record represents a successful deal or an error message
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CASHPOOL_ID	Cash pool identifier
REQUEST_ID	Request identifier of the Generate Cash Leveling Fund Transfers concurrent request
SUB_ACCOUNT_ID	Sub account identifier
CONC_ACCOUNT_ID	Concentration bank account identifier
TRANSFER_AMOUNT	Transfer amount
MESSAGE_NAME	Error message name
MESSAGE_TEXT	Error message text
DEAL_TYPE	Deal type
DEAL_NO	Deal number

Cash Management - CE_CASHPOOL_SUB_ACCTS	This table stores cash pool sub account information
Column Name	Descritpion
CASHPOOL_SUB_ACCT_ID	System-assigned cash pool sub account identifier
SINGLE_CONC_ACCOUNT_FLAG	Flag to indicate whether the child cash pool has only one concentration account
NESTED_PARENT_POOL_ID	Cash pool identifier of the nested cash pool, if any, that contains this bank account as a sub account (null if this sub account is an immediate child)
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CASHPOOL_ID	Parent cash pool identifier
TYPE	Type of sub account (ACCT: Bank Account, POOL: Cash Pool, CONC: Normal concentration account, INV: Investment concentration account, FUND: Funding concentration account, NEST: Bank Account from a nested cash pool)
ACCOUNT_ID	Bank account identifier or child cash pool identifier
CONC_ACCOUNT_ID	Child cash pool concentration bank account identifier
INV_CONC_ACCOUNT_ID	Child cash pool investment concentration bank account identifier
FUND_CONC_ACCOUNT_ID	Child cash pool funding concentration bank account identifier
PARTY_CODE	Sub account company party code
LEGAL_ENTITY_ID	Legal entity identifier

Cash Management - CE_INTRA_STMT_HEADERS	Bank statements
Column Name	Descritpion
STATEMENT_HEADER_ID	Statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	No Longer Used
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Interest Calculated Balance
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
STATEMENT_DATE	Statement date
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_INTEREST_BAL_RANGES	This table stores interest balance range information.
Column Name	Descritpion
BALANCE_RANGE_ID	Uniquely identifies the interest schedule balance range
INTEREST_SCHEDULE_ID	Uniquely identifies the interest schedule
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
FROM_BALANCE_AMOUNT	From Balance Amount
TO_BALANCE_AMOUNT	To Balance Amount
OBJECT_VERSION_NUMBER	Object Version Number

Cash Management - CE_INTEREST_SCHEDULES	This table stores interest rate schedule information.
Column Name	Descritpion
INTEREST_SCHEDULE_ID	Uniquely identifies the interest schedule
INTEREST_INCLUDES	Interest Includes
INTEREST_ROUNDING	Interest Rounding
BASIS	Basis
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
SCHEDULE_NAME	Schedule name
CURRENCY_CODE	Currency code
DAY_COUNT_BASIS	Day Count Basis

Cash Management - CE_INTEREST_RATES	This table stores interest rate information.
Column Name	Descritpion
INTEREST_RATE_ID	Uniquely identifies the interest rate
BALANCE_RANGE_ID	Uniquely identifies the balance range
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
INTEREST_RATE	Interest Rate
EFFECTIVE_DATE	Effective Date
OBJECT_VERSION_NUMBER	Object Version Number

Cash Management - CE_JE_MESSAGES	Table to store the errors occurred during the Journal Entry Creation program execution.
Column Name	Descritpion
STATEMENT_HEADER_ID	Bank Statement header identifier
REQUEST_ID	Request ID of the Journal Entry Creation program
STATEMENT_LINE_ID	Bank Statement line identifier
MESSAGE_NAME	Error message name
APPLICATION_SHORT_NAME	Application Short Name, CE
CREATED_BY	Standard Who column
CREATION_DATE	Standad Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Cash Management - CE_JE_MAPPINGS	The CE_JE_MAPPINGS table stores the journal entry mappings information for a bank account.
Column Name	Descritpion
JE_MAPPING_ID	Unique identifier for the Journal Entry Mapping
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standad Who column
TRXN_SUBTYPE_CODE_ID	Transaction Sub Type Code ID
BANK_ACCOUNT_ID	Bank Account identifier
TRX_CODE_ID	Transaction code identifier
SEARCH_STRING_TXT	Free-text search string
GL_ACCOUNT_CCID	The mapped GL account code combination id
REFERENCE_TXT	Free-text reference string
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Cash Management - CE_PAYMENT_DOCUMENTS	This table stores payment document information
Column Name	Descritpion
PAYMENT_DOCUMENT_ID	Uniquely identifies the payment document
FIRST_AVAILABLE_DOCUMENT_NUM	First payment number available on a payment document
LAST_AVAILABLE_DOCUMENT_NUMBER	Last payment number available on a payment document
LAST_ISSUED_DOCUMENT_NUMBER	Last payment number used on a payment document to pay invoices
MANUAL_PAYMENTS_ONLY_FLAG	Manual Payments only flag
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
PAYMENT_DOC_CATEGORY	Payment document category
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
PAYMENT_DOCUMENT_NAME	Payment Document Name
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
PAYMENT_INSTRUCTION_ID	Payment Instruction Identifier
INACTIVE_DATE	Inactive Date
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number
INTERNAL_BANK_ACCOUNT_ID	Bank Account Indentifier
PAPER_STOCK_TYPE	Paper Stock Type
ATTACHED_REMITTANCE_STUB_FLAG	Attached Remittance Stub flag
NUMBER_OF_LINES_PER_REMIT_STUB	Number of Lines per Remittance Stub
NUMBER_OF_SETUP_DOCUMENTS	Number of documents printed at the beginning of each automatic payment batch
FORMAT_CODE	Payment Format Code

Cash Management - CE_CHECKBOOKS	This table stores payment check book information
Column Name	Descritpion
CHECKBOOK_ID	Uniquely identifies the checkbook
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object version number
PAYMENT_DOCUMENT_ID	Payment Document Identifier
CHECKBOOK_NAME	Checkbook Name
PREFIX	Prefix
START_NUMBER	Checkbook Start Number
END_NUMBER	Checkbook End Number
DATE_RECEIVED	Date that checkbook is received
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Cash Management - CE_STATEMENT_HEADERS_INT	Open interface for bank statements
Column Name	Descritpion
STATEMENT_NUMBER	Statement number
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CONTROL_LINE_COUNT	Total line count of the statement that can be compared to the actual number of lines entered for control purposes
RECORD_STATUS_FLAG	Statement upload status, lookup type HEADER_INTERFACE_STATUS
CURRENCY_CODE	Bank statement currency code
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
BANK_ACCOUNT_NUM	Bank account number
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
STATEMENT_DATE	Statement date
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ORG_ID	No Longer used.
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
INTRA_DAY_FLAG	Flag to indicate whether this statement is an Intra-Day statement or not
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
AVERAGE_CLOSE_LEDGER_MTD	Average closing ledger month to date balance
AVERAGE_CLOSE_LEDGER_YTD	Average closing ledger year to date balance
BANK_NAME	Bank name
AVERAGE_CLOSE_AVAILABLE_MTD	Average closing available month to date balance
AVERAGE_CLOSE_AVAILABLE_YTD	Average closing available year to date balance
SUBSIDIARY_FLAG	Flag to indicate whether this is a subsidiarys bank account statement
BANK_BRANCH_NAME	Bank branch name
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purposes
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purposes
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purposes
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)

Cash Management - CE_SYSTEM_PARAMETERS	System options
Column Name	Descritpion
SET_OF_BOOKS_ID	Set of books identifier
RECEIVABLES_TRX_ID_OLD	No Longer Used
DIFFERENCES_ACCOUNT_OLD	No Longer Used
FX_DIFFERENCE_HANDLING_OLD	No longer used
LINES_PER_COMMIT	Number of statement lines to be automatically reconciled before a commit is issued
ORG_ID_OLD	No Longer Used
AP_MATCHING_ORDER_OLD	No longer used
AR_MATCHING_ORDER_OLD	No longer used
LAST_UPDATE_LOGIN	Standard WHO column
FLOAT_HANDLING_FLAG_OLD	No Longer Used
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
CASHBOOK_BEGIN_DATE	Date from which to show transactions
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
CREATED_BY	Standard WHO column
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
SHOW_VOID_PAYMENT_FLAG	Flag to specify whether or not to display void payment as available for reconciliation.
OI_MATCHING_CODE_OLD	No longer used
EXCHANGE_RATE_TYPE_OLD	No Longer Used
EXCHANGE_RATE_DATE_OLD	No Longer Used
SIGNING_AUTHORITY_APPR_FLAG	Flag to indicate whether the Signing Authority is approved Manually or through Workflow.
LEGAL_ENTITY_ID	Legal Entity Identifier
CE_DIFFERENCES_ACCOUNT_OLD	No Longer Used
AUTHORIZATION_BAT	Authorization
CASHFLOW_EXCHANGE_RATE_TYPE	Cashflow Exchange Rate Type
BSC_EXCHANGE_DATE_TYPE	Bank Statement Cashflow Exchange Rate Date
BAT_EXCHANGE_DATE_TYPE	Bank Account Transfer Exchange Rate Date
MANUAL_AMOUNT_TOLERANCE_OLD	No longer used
CREATION_DATE	Standard WHO column
MANUAL_PERCENT_TOLERANCE_OLD	No longer used
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
SHOW_CLEARED_FLAG	Flag to specify whether or not to include cleared but not reconciled transactions as available transactions for matching, Y or N
INTERFACE_PURGE_FLAG	Flag to indicate whether or not to purge data from the interface tables after a successful import of the data into the blank statement tables
INTERFACE_ARCHIVE_FLAG	Flag to indicate whether or not to archive data from the interface tables while purging them after a successful import of the data into the statement tables, Y or N
LINE_AUTOCREATION_FLAG	Flag to indicate whether or not to allow addition of statement lines when statements are created automatically, Y or N
ENABLE_OPEN_INTERFACE_FLAG_OLD	No longer used
OI_FLOAT_STATUS_OLD	No longer used
OI_CLEAR_STATUS_OLD	No longer used
AMOUNT_TOLERANCE_OLD	No longer used
PERCENT_TOLERANCE_OLD	No Longer Used

Cash Management - CE_ZBA_DEAL_MESSAGES	This table stores the error or warning messages from ZBA deal creation process
Column Name	Descritpion
STATEMENT_LINE_ID	Statement line identifier
OFFSET_DEAL_NUM	Offsetting deal number
OFFSET_TRANSACTION_NUM	Offsetting transaction number
DEAL_STATUS_FLAG	Deal creation status flag
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CASHPOOL_ID	Cash pool identifier
CASHFLOWS_CREATED_FLAG	Flag to indicate whether cash flows have been created or not
MESSAGE_NAME	Message name
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
APPLICATION_SHORT_NAME	Appliction short name, CE
STATEMENT_HEADER_ID	Statement header identifier
DEAL_TYPE	Deal type
DEAL_NUM	Deal number
TRANSACTION_NUM	Transaction number

Cash Management - CE_ARCH_HEADERS	Archived CE_STATEMENT_HEADERS_ALL records
Column Name	Descritpion
STATEMENT_HEADER_ID	System-assigned statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purposes
CONTROL_TOTAL_CR	Total receipt amount of the statement that can be compared to the total receipt entry amount for control purposes
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	No longer used
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Document number
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
STATEMENT_DATE	Statement date
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_ARCH_INTERFACE_HEADERS	Archived CE_STATEMENT_HEADERS_INT_ALL records
Column Name	Descritpion
STATEMENT_NUMBER	Statement number
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CONTROL_LINE_COUNT	Total line count of the statement that can be compared to the actual number of lines entered for control purposes
RECORD_STATUS_FLAG	Statement upload status, lookup type HEADER_INTERFACE_STATUS
CURRENCY_CODE	Bank statement currency code
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
BANK_ACCOUNT_NUM	Bank account number
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
STATEMENT_DATE	Statement date
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
ORG_ID	No Longer used.
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
INTRA_DAY_FLAG	Flag to indicate whether this statement is an Intra-Day statement or not
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
AVERAGE_CLOSE_LEDGER_MTD	Average closing ledger month to date balance
AVERAGE_CLOSE_LEDGER_YTD	Average closing ledger year to date balance
BANK_NAME	Bank name
AVERAGE_CLOSE_AVAILABLE_MTD	Average closing available month to date balance
AVERAGE_CLOSE_AVAILABLE_YTD	Average closing available year to date balance
BANK_BRANCH_NAME	Bank branch name
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purposes
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purposes
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purposes
CONTROL_END_BALANCE	Ending balance of the statement for control purposes (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)

Cash Management - CE_ARCH_INTRA_HEADERS	Bank statements
Column Name	Descritpion
STATEMENT_HEADER_ID	Statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	No longer Used.
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Interest Calculated Balance
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
STATEMENT_DATE	Statement date
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
TWO_DAY_FLOAT	Two-day float balance
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_STATEMENT_HEADERS	Bank statements
Column Name	Descritpion
STATEMENT_HEADER_ID	Statement header identifier
GL_DATE	Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE	Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR	Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR	Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE	Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT	Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT	Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
CURRENCY_CODE	Bank statement currency code
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
BANK_ACCOUNT_ID	Bank account identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
STATEMENT_NUMBER	Statement number
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG	Flag to indicate whether the statement is complete or not, Y or N
ORG_ID	No Longer used.
DOC_SEQUENCE_ID	Document sequence identifier
DOC_SEQUENCE_VALUE	Document number
CHECK_DIGITS	Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE	Cashflow Balance
INT_CALC_BALANCE	Interest Calculated Balance
ONE_DAY_FLOAT	One-day float balance
STATEMENT_DATE	Statement date
TWO_DAY_FLOAT	Two-day float balance
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
CREATED_BY	Standard WHO column
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
AUTO_LOADED_FLAG	Flag to indicate whether the statement was loaded automatically via open interface, Y or N

Cash Management - CE_TRX_CODES_UTIL_GT
Column Name	Descritpion
REQUEST_ID
BANK_ACCOUNT_ID
TRX_CODE_ID
TRX_CODE
TRX_TYPE
RECONCILE_FLAG
RECONCILIATION_SEQUENCE
DESCRIPTION
STATUS

Cash Management - CE_UK_VAL_MODULUS_WEIGHTS	The CE_UK_VAL_MODULUS_WEIGHTS table stores the modulus weights used for UK Domestic Account Number validations.
Column Name	Descritpion
MODULUS_CHECK_ID	Modulus Check Identifier.
WEIGHT_Z	Modulus weight for digit 6 of sort code.
WEIGHT_A	Modulus weight for digit 1 of account number.
WEIGHT_B	Modulus weight for digit 2 of account number.
WEIGHT_C	Modulus weight for digit 3 of account number.
WEIGHT_D	Modulus weight for digit 4 of account number.
WEIGHT_E	Modulus weight for digit 5 of account number.
WEIGHT_F	Modulus weight for digit 6 of account number.
WEIGHT_G	Modulus weight for digit 7 of account number.
WEIGHT_H	Modulus weight for digit 8 of account number.
EXCEPTION_CODE	Exception to be applied.
FROM_SORT_CODE	Start of range for sort code.
REQUEST_ID	ID of Concurrent request which created the data.
CREATED_BY	Standard WHO Column.
CREATION_DATE	Standard WHO Column.
LAST_UPDATED_BY	Standard WHO Column.
LAST_UPDATE_DATE	Standard WHO Column.
LAST_UPDATE_LOGIN	Standard WHO Column.
TO_SORT_CODE	End of range for sort code.
CHECK_TYPE	The modulus algorithm which has to be applied.
WEIGHT_U	Modulus weight for digit 1 of sort code.
WEIGHT_V	Modulus weight for digit 2 of sort code.
WEIGHT_W	Modulus weight for digit 3 of sort code.
WEIGHT_X	Modulus weight for digit 4 of sort code.
WEIGHT_Y	Modulus weight for digit 5 of sort code.

Cash Management - CE_UK_VALIDATIONS_INTERFACE	The CE_UK_VALIDATIONS_INTERFACE table is the loader target for data from text files provided by Vocalink for UK Domestic Account Validations.
Column Name	Descritpion
INTERFACE_LINE_ID	Record Number. Unique Identifier.
SOURCE_VALUE9	Value from column 9 of validation data file.
SOURCE_VALUE10	Value from column 10 of validation data file.
SOURCE_VALUE11	Value from column 11 of validation data file.
SOURCE_VALUE12	Value from column 12 of validation data file.
SOURCE_VALUE13	Value from column 13 of validation data file.
SOURCE_VALUE14	Value from column 14 of validation data file.
SOURCE_VALUE15	Value from column 15 of validation data file.
SOURCE_VALUE16	Value from column 16 of validation data file.
SOURCE_VALUE17	Value from column 17 of validation data file.
SOURCE_VALUE18	Value from column 18 of validation data file.
SOURCE_VALUE1	Value from column 1 of validation data file.
SOURCE_VALUE2	Value from column 2 of validation data file.
SOURCE_VALUE3	Value from column 3 of validation data file.
SOURCE_VALUE4	Value from column 4 of validation data file.
SOURCE_VALUE5	Value from column 5 of validation data file.
SOURCE_VALUE6	Value from column 6 of validation data file.
SOURCE_VALUE7	Value from column 7 of validation data file.
SOURCE_VALUE8	Value from column 8 of validation data file.

Cash Management - CE_UK_VAL_SUBS_CODES	The CE_UK_VAL_SUBS_CODES table stores the substitute sorting codes used for UK Domestic Account Number validations.
Column Name	Descritpion
SUBSTITUTION_ID	Substitution Code Identifier.
ORIG_SORT_CODE	Original Sort Code.
SUBS_SORT_CODE	Substitution Sort Code.
REQUEST_ID	ID of Concurrent request which created the data.
CREATED_BY	Standard WHO Column.
CREATION_DATE	Standard WHO Column.
LAST_UPDATED_BY	Standard WHO Column.
LAST_UPDATE_DATE	Standard WHO Column.
LAST_UPDATE_LOGIN	Standard WHO Column.