Sheets で使えるFreshBooksのテーブル
Sheets はお使いの FreshBooks のビジネスを16個のテーブルとして読み取ります。1つをデータソースとしてスプレッドシートに追加すると、その列が関数で使える名前になります。
Sales
InvoicesID, Invoice no., PO number, Date, Due date…Invoice linesDocument ID, Invoice no., Date, Client, Client ID…EstimatesID, Estimate no., PO number, Date, Client…Credit notesID, Credit note no., Date, Client, Client ID…PaymentsID, Date, Amount, Currency, Method…Other incomeID, Date, Amount, Currency, Category…
Expenses
ExpensesID, Date, Vendor, Category, Category ID…BillsID, Bill no., Date, Due date, Vendor…Bill paymentsID, Date, Amount, Currency, Method…VendorsID, Name, First name, Last name, E-mail…Expense categoriesID, Name, Parent ID, Cost of goods sold, Editable…
Time
ProjectsID, Title, Description, Client, Client ID…Time entriesID, Started at, Date, Hours, Duration (seconds)…