- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
What are the tables being used in the FACTS module?
Answer:
There are only a few tables in the FACTS module. These hold the data created from the autobuild initial funds value process and the monthly reconciliation cycles:
f-pool-balance:
Pool Balances for each cycle are in this table
Pool > Balance tab
f-account-balance
Accounts Balances for each cycle are in this table
Account > Balance tab
Reconciliation History report will display more values
f-fund-balance
Funds Balances for each cycle are in this table
Pool > select a pool > click the balance tab
Unitization History reports display this content
Pool:
Pool super tab and the Pool and GL Accounts tab.
Investacct:
Accounts\Account tab and GL accounts ( not used) tab.
This table is also used for the checking account and is seen in the reconciliation module on the account tab
Recontran:
This is the transaction record and usually has the same doc number as journal number.
These are transactions that belong to a cycle that hasn't been posted.
Transactions are viewed on the transaction tab for the account
Recontranhis:
These are the posted recontran records.
When a cycle is posted the recontran records move to the recontranhis table
f-pool-balance:
Pool Balances for each cycle are in this table
Pool > Balance tab
f-account-balance
Accounts Balances for each cycle are in this table
Account > Balance tab
Reconciliation History report will display more values
f-fund-balance
Funds Balances for each cycle are in this table
Pool > select a pool > click the balance tab
Unitization History reports display this content
Pool:
Pool super tab and the Pool and GL Accounts tab.
Investacct:
Accounts\Account tab and GL accounts ( not used) tab.
This table is also used for the checking account and is seen in the reconciliation module on the account tab
Recontran:
This is the transaction record and usually has the same doc number as journal number.
These are transactions that belong to a cycle that hasn't been posted.
Transactions are viewed on the transaction tab for the account
Recontranhis:
These are the posted recontran records.
When a cycle is posted the recontran records move to the recontranhis table
Was this article helpful?