I'm sorry, I'm not sure what you mean by "accounting all tables." Can you please provide more information or clarify your question?
0
Google Gemini AI
Oct 30
Account Reconciliation
| Table Name | Description | |---|---| | Account | Stores the master list of accounts. | | Transaction | Stores the individual transactions that are posted to accounts. | | BankStatement | Stores the bank statement data that is used for reconciliation. | | Reconciliation | Stores the reconciliation data that is generated when accounts are reconciled. |
Accounts Payable
| Table Name | Description | |---|---| | Vendor | Stores the master list of vendors. | | Invoice | Stores the invoices that are received from vendors. | | Payment | Stores the payments that are made to vendors. | | GeneralLedger | Stores the general ledger transactions that are generated from accounts payable transactions. |
Accounts Receivable
| Table Name | Description | |---|---| | Customer | Stores the master list of customers. | | SalesOrder | Stores the sales orders that are received from customers. | | Invoice | Stores the invoices that are sent to customers. | | Payment | Stores the payments that are received from customers. | | GeneralLedger | Stores the general ledger transactions that are generated from accounts receivable transactions. |
Inventory
| Table Name | Description | |---|---| | Item | Stores the master list of inventory items. | | Location | Stores the locations where inventory is stored. | | Transaction | Stores the inventory transactions that occur. | | GeneralLedger | Stores the general ledger transactions that are generated from inventory transactions. |
Payroll
| Table Name | Description | |---|---| | Employee | Stores the master list of employees. | | Timecard | Stores the timecards that are submitted by employees. | | Payroll | Stores the payroll transactions that are generated. | | GeneralLedger | Stores the general ledger transactions that are generated from payroll transactions. |
Fixed Assets
| Table Name | Description | |---|---| | Asset | Stores the master list of fixed assets. | | Transaction | Stores the fixed asset transactions that occur. | | Depreciation | Stores the depreciation schedules for fixed assets. | | GeneralLedger | Stores the general ledger transactions that are generated from fixed asset transactions. |
Jobs
| Table Name | Description | |---|---| | Job | Stores the master list of jobs. | | Transaction | Stores the job transactions that occur. | | GeneralLedger | Stores the general ledger transactions that are generated from job transactions. |
Budgeting
| Table Name | Description | |---|---| | Budget | Stores the master list of budgets. | | Transaction | Stores the budget transactions that occur. | | GeneralLedger | Stores the general ledger transactions that are generated from budgeting transactions. |