Database Script | Description |
wm_install_into_bankstmt.sql | Runs all the scripts listed below, except the uninstall script. |
wm_into_bankstmt_pkg.sql | Installs WM_CE_BANK_IMP_HANDLER_PKG. WM_HANDLE_CEBANK, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT procedure to submit the bank statement process. |
wm_drop_into_bankstmt.sql | Uninstalls all components created by wm_install_into_bankstmt.sql. |
Field Name | Maps to Column | Description |
BANK_NAME | BANK_NAME | |
BRANCH_NAME | BANK_BRANCH_ NAME | Required. |
STATEMENT_ NUMBER | STATEMENT_ NUMBER | Required. |
STATEMENT_DATE | STATEMENT_DATE | Required. |
BANK_ACCOUNT_ NUM | BANK_ACCOUNT_ NUM | Required. Bank account number. |
CONTROL_BEGIN_ BALANCE | CONTROL_BEGIN_ BALANCE | Control beginning balance. |
CONTROL_END_ BALANCE | CONTROL_END_ BALANCE | |
CONTROL_TOTAL_ DR | CONTROL_TOTAL_ DR | Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purposes. |
CONTROL_TOTAL_ CR | CONTROL_TOTAL_ CR | Total payment amount of the bank statement that can be compared to the actual payment entry totals for control. |
CONTROL_DR_ LINE_COUNT | 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 | CONTROL_CR_ LINE_COUNT | Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes. |
CONTROL_LINE_ COUNT | 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 | RECORD_STATUS_ FLAG | Statement upload status lookup type HEADER_INTERFACE_STATUS. Use: C for Corrected. E for Error. N for New. T for Transferred. |
CURRENCY_CODE | CURRENCY_CODE | Bank statement currency code. |
ORG_NAME | ORG_ID | Derived from organization definitions. |
CHECK_DIGITS | CHECK_DIGITS | Holds any check digits that result from bank account number validation in FBS. |
ONE_DAY_FLOAT | ONE_DAY_FLOAT | |
TWO_DAY_FLOAT | TWO_DAY_FLOAT |
Field Name | Maps to Column | Description |
LINE_NUMBER | LINE_NUMBER | Required. |
TRX_DATE | TRX_DATE | Required. Line transaction date that updates AP check’s cleared date and AR receipt’s cleared date if EFFECTIVE_DATE is null. |
TRX_CODE | TRX_CODE | Bank transaction code. |
EFFECTIVE_DATE | EFFECTIVE_DATE | Statement line effective date. |
TRX_TEXT | TRX_TEXT | Statement line description. |
INVOICE_TEXT | INVOICE_TEXT | Invoice number for finding available receipts by invoice. |
AMOUNT | AMOUNT | Statement line amount. |
CURRENCY_CODE | CURRENCY_CODE | Statement line currency code. |
EXCHANGE_RATE | EXCHANGE_RATE | |
BANK_TRX_NUMBER | BANK_TRX_NUMBER | Transaction number that identifies the transaction to be matched against the statement line. |
CUSTOMER_TEXT | ACCOUNT_NUMBER | |
USER_EXCHANGE_ RATE_TYPE | USER_EXCHANGE_ RATE_TYPE | Currency conversion rate type. |
EXCHANGE_RATE_ DATE | EXCHANGE_RATE_ DATE | |
ORIGINAL_AMOUNT | ORIGINAL_AMOUNT | Statement line amount in currency code. |
CHARGES_AMOUNT | CHARGES_AMOUNT | Bank charges amount. |
BANK_ACCOUNT_TEXT | BANK_ACCOUNT_TEXT | Supplier or customer bank account number. |