Tables in Cash Management R12

By
Advertisement
CE_BANK_ACCOUNTS:

CE_BANK_ACCOUNTS contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch. 

CE_BANK_ACCT_USES_ALL:

CE_BANK_ACCT_USES_ALL stores Operating Unit level bank account use information.

CE_GL_ACCOUNTS_CCID:

CE_GL_ACCOUNTS_CCID stores information about code combination ids per your bank account uses

 CE_INTEREST_RATES:

This table stores interest rate information 

CE_INTEREST_SCHEDULES:

This table stores interest schedule information

 CE_BANK_ACCT_BALANCES:

This table stores the internal bank account balances.

CE_PROJECTED_BALANCES:

This table stores the projected balances of internal bank accounts.

CE_CASHFLOWS:

Table for storing Cashflows

CE_PAYMENT_TRANSACTIONS:

Table for storing Bank Account Transfer


CE_PAYMENT_TEMPLATES:

Table for storing payment templates


CE_TRXNS_SUBTYPE_CODES:

Table for storing transaction subtype codes


CE_CONTACT_ASSIGNMENTS:

This table contains the information about which level  (bank, branch, account) the contact is assigned to.

CE_AP_PM_DOC_CATEGORIES:

This table stores payment document categories and payment methods for bank account uses

CE_PAYMENT_DOCUMENTS:

This table stores payment document information.

CE_SECURITY_PROFILES_GT:

CE.CE_SECURITY_PROFILES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

CE_AVAILABLE_TRANSACTIONS_TMP:

CE.CE_AVAILABLE_TRANSACTIONS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

CE_CHECKBOOKS:

This table stores payment check book information.

CE_STATEMENT_RECONCILS_ALL:

The CE_STATEMENT_RECONCILS_ALL table stores information about reconciliation history or audit trail. Each row represents an action performed against a statement line.


CE_ARCH_RECONCILIATIONS_ALL:

The CE_ARCH_RECONCILIATIONS_ALL table stores information about archived statement reconciliation details. A row in this table corresponds to an archived CE_STATEMENT_RECONCILES_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive.


CE_ARCH_HEADERS:

The CE_ARCH_HEADERS_ALL table stores archived statement header information. Each row in this table corresponds to an archived CE_STATEMENT_HEADERS_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive.

CE_ARCH_INTRA_HEADERS:

The CE_ARCH_INTRA_HEADERS_ALL table stores archived intra-day statement header
information. Each row in this table corresponds to an archived CE_INTRA_STMT_HEADERS_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive.

CE_ARCH_INTERFACE_HEADERS:

The CE_ARCH_INTERFACE_HEADERS_ALL table stores archived statement interface information. Each row in this table corresponds to an archived CE_STATEMENT_HEADERS_INT_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive, or by the AutoReconciliation program once you enable your system options to automatically purge and archive statement interface tables.


CE_INTRA_STMT_HEADERS:

The CE_INTRA_STMT_HEADERS_ALL table stores intra-day bank statement header information. Each row in this table contains the statement date, statement number, bank account identifier, and other information about the intra-day statement.

CE_STATEMENT_HEADERS:

The CE_STATEMENT_HEADERS_ALL table stores bank statements. Each row in this table contains the statement name, statement date, GL date, bank account identifier, and other information about the statement. This table corresponds to the Bank Statement window of the Bank Statements form.
Once you have marked your statement as complete, the STATEMENT_COMPLETE_FLAG is set to Y, and you can no longer modify or update the statement.
AUTO_LOADED_FLAG is set to Y when your statement is uploaded from the interface table using the Bank Statement Import program.


CE_CASHPOOLS:

This table stores header information about the cash pool


CE_STATEMENT_LINES:

The CE_STATEMENT_LINES table stores information about bank statement lines. Each row in this table stores the statement header identifier, statement line number, associated transaction type, and transaction amount associated with the statement line.
This table corresponds to the Bank Statement Lines window of the Bank Statements form.








6 comments:


  1. BEST WAY TO HAVE GOOD AMOUNT TO START A GOOD BUSINESS or TO START LIVING A GOOD LIFE….. Hack and take money directly from any ATM Machine Vault with the use of ATM Programmed Card which runs in automatic mode. email (williamshackers@hotmail.com) for how to get it and its cost . ………. EXPLANATION OF HOW THESE CARD WORKS………. You just slot in these card into any ATM Machine and it will automatically bring up a MENU of 1st VAULT $1,000, 2nd VAULT $2,000, RE-PROGRAMMED, EXIT, CANCEL. Just click on either of the VAULTS, and it will take you to another SUB-MENU of ALL, OTHERS, EXIT, CANCEL. Just click on others and type in the amount you wish to withdraw from the ATM and you have it cashed instantly… Done. ***NOTE: DON’T EVER MAKE THE MISTAKE OF CLICKING THE “ALL” OPTION. BECAUSE IT WILL TAKE OUT ALL THE AMOUNT OF THE SELECTED VAULT. email (williamshackers@hotmail.com) We are located in USA.

    ReplyDelete
  2. I got my already programmed and blanked ATM card to withdraw the maximum of $1,000 daily for a maximum of 20 days. I am so happy about this because i got mine last week and I have used it to get $20,000. Mike Fisher Hackers is giving out the card just to help the poor and needy though it is illegal but it is something nice and he is not like other scam pretending to have the blank ATM cards. And no one gets caught when using the card. get yours from Mike Fisher Hackers today! *email cyberhackingcompany@gmail.com


    ReplyDelete
  3. Awesome mate, It's very informative. Visit to the following dynamic netsoft site for Treasury Management System

    ReplyDelete
  4. Do you Need Instant Loan from $2,000 to $50,000,000.00 with no collateral required and receive a no obligation loan approval.We welcome the opportunity to show you how effective we are at helping our clients obtain the money they need to succeed. Our professional staff is available for a Free Consultation.At Patiala legitimate company Pvt , contact us now 2% interest rate, both long and short term cash reply to us (Whats App) number: +919394133968 patialalegitimate515@gmail.com 
    Mr Jeffery

    ReplyDelete
  5. Thanks for sharing. Contact Dynamic Netsoft Technologies for Treasury Management Solution We're a Certified Microsoft Gold Partner.

    ReplyDelete
  6. URGENT LOAN IS AVAILABLE NOW

    TODAY I GOT MY DESIRED LOAN AMOUNT $760K FROM A RELIABLE,TRUSTED AND REGISTERED PRIVATE LOAN COMPANY LAST WEEK,BUSINESS/HOME/COMPANY/PROJECT/PERSONAL LOAN? ARE NOW AFFORDABLE HERE FOR YOU TODAY CONTACT Email profdorothyinvestments@gmail.com WhatsApp Number +1(541)279-1406

    Hello, I'm here to testify of how i got my real estate business loan from PROF. MRS.DOROTHY JEAN INVESTMENTS (profdorothyinvestments@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan Ranging from $5,000.00 to $2,000,000.00USD with a low interest rate of 2% and loan duration of 1 to 33 years to pay back the loan secure and unsecured. Are you losing sleep at nights worrying how to get a Legit Loan Lender?
    MRS.DOROTHY JEAN holds all of the information about how to obtain money quickly and painlessly without cost/stress via Contacts WhatsApp Number +1(541)279-1406 Email profdorothyinvestments@gmail.com

    ReplyDelete