ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData SSIS Components for FreshBooks ビュー
Name | Description |
AccountsAgingReport | The Account Aging Report shows details regarding overdue invoices from clients. |
BillsLineItems | Bill lines are used to determine the amount of a bill. |
BillVendorsTaxDefaults | FreshBooks allows you to store your previously used taxes to re-apply conveniently. |
EstimatesLineItems | Estimate lines are used to determine the amount of an estimate. |
ExpenseCategories | FreshBooks supplies Expense Categories to group expenses together to aid in expense tracking. |
ExpensesReport | The Expenses Report shows all the information involving your Expenses. |
Gateways | Gateways are also referred to as payment processors. The information returned by these endpoints specifies what payment processors are enabled for your businesses. |
IdentityInfo | You can find ids for the Businesses and Accounts a user can interact with by querying the IdentityInfo view. |
InvoicesLineItems | Invoice lines are used to determine the amount of an invoice, in addition to being able to tie the invoice to rebilled expenses. |
InvoicesReport | The Invoice Details Report shows all the information involving your invoices. |
OtherIncomesTaxes | Other Income is for recording income that doesn’t require an invoice and is received through other means. |
PaymentsCollectedReport | The Payments Collected Report shows details regarding collected payments made to your business. |
ProfitLossReport | The Profit/Loss Report shows all the information involving both your Profits and Losses. |
Systems | An Accounting System represents an entity that can send invoices. It is the central point of association between all of a single Administrator of a single Business, Invoices, Clients, Staff, Expenses, and Reports. |
Tasks | Tasks in Freshbooks represent services that your business offers to clients. Tasks are used to keep track of details of the service such as name and hourly rate. |
TaxSummaryReport | The Tax Summary Report that outlines the taxes involved with your sales. |
TimeEntries | Time Entries represent time spent working for a client or project. |