BalanceSheetDetail
Provides a detailed breakdown of the Balance Sheet, including individual account balances and changes over time.
Columns
| Name | Type | References | Description |
| Label | String | The label associated with each row in the BalanceSheetDetail report, providing descriptive information. | |
| Type | String | The type of entry represented in the BalanceSheetDetail report, such as account type or transaction type. | |
| Date | Date | The date of the transaction or entry in the BalanceSheetDetail report. | |
| Num | String | The reference or transaction number associated with the entry in the BalanceSheetDetail report. | |
| Name | String | The name associated with the entry, such as a customer, vendor, or employee. | |
| Memo | String | A memo or note providing additional details about the entry in the BalanceSheetDetail report. | |
| Class | String | The class assigned to the entry, used for categorization or tracking purposes. | |
| Clr | String | Indicates the cleared status of the transaction, often related to bank reconciliation. | |
| Split | String | Details of the account or accounts affected by the split transaction. | |
| Amount | Decimal | The monetary value of the transaction or entry in the BalanceSheetDetail report. | |
| Balance | Double | The running balance for the associated account at the time of the transaction. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ReportPeriod | String | Specifies the date range for the report in the format fromdate:todate. For example, to get a balance as of a specific date, set the todate as yyyy-MM-dd. | |
| ReportDateRangeMacro | String | A macro defining the date range for the report, such as 'LastMonth' or 'ThisFiscalYear'.
使用できる値は次のとおりです。ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR デフォルト値はTHISMONTHTODATEです。 | |
| AccountType | String | Filters the report to include only accounts of a specific type, such as Asset, Liability, or Income.
使用できる値は次のとおりです。NONE, ACCOUNTSPAYABLE, ACCOUNTSRECEIVABLE, ALLOWEDFOR1099, APANDSALESTAX, APORCREDITCARD, ARANDAP, ASSET, BALANCESHEET, BANK, BANKANDARANDAPANDUF, BANKANDUF, COSTOFSALES, CREDITCARD, CURRENTASSET, CURRENTASSETANDEXPENSE, CURRENTLIABILITY, EQUITY, EQUITYANDINCOMEANDEXPENSE, EXPENSEANDOTHEREXPENSE, FIXEDASSET, INCOMEANDEXPENSE, INCOMEANDOTHERINCOME, LIABILITY, LIABILITYANDEQUITY, LONGTERMLIABILITY, NONPOSTING, ORDINARYEXPENSE, ORDINARYINCOME, ORDINARYINCOMEANDCOGS, ORDINARYINCOMEANDEXPENSE, OTHERASSET, OTHERCURRENTASSET, OTHERCURRENTLIABILITY, OTHEREXPENSE, OTHERINCOME, OTHERINCOMEOREXPENSE | |
| AccountList | String | A comma-separated list of account names or IDs to include in the report. Requires AccountListType if specified. | |
| AccountListType | String | Determines the type of account list specified in AccountList, such as 'Name' or 'ID'.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| EntityType | String | Filters the report to include only entities of a specific type, such as Customer or Vendor.
使用できる値は次のとおりです。NONE, CUSTOMER, EMPLOYEE, OTHERNAME, VENDOR | |
| EntityList | String | A comma-separated list of entity names or IDs to include in the report. Requires EntityListType if specified. | |
| EntityListType | String | Determines the type of entity list specified in EntityList, such as 'Name' or 'ID'.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| ItemType | String | Filters the report to include only items of a specific type, such as Inventory or Non-Inventory.
使用できる値は次のとおりです。NONE, ALLEXCEPTFIXEDASSET, ASSEMBLY, DISCOUNT, FIXEDASSET, INVENTORY, INVENTORYANDASSEMBLY, NONINVENTORY, OTHERCHARGE, PAYMENT, SALES, SALESTAX, SERVICE | |
| ItemList | String | A comma-separated list of item names or IDs to include in the report. Requires ItemListType if specified. | |
| ItemListType | String | Determines the type of item list specified in ItemList, such as 'Name' or 'ID'.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| ClassList | String | A comma-separated list of class names or IDs to include in the report. Requires ClassListType if specified. | |
| ClassListType | String | Determines the type of class list specified in ClassList, such as 'Name' or 'ID'.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| TransactionTypes | String | A comma-separated list of transaction types to include in the report. Possible values include ALL, INVOICE, PAYMENT, and many more. | |
| ModifiedDateRange | String | Specifies a date range for modified entries in the format fromdate:todate. Supports open-ended ranges (for example, 2009-12-25:). | |
| ModifiedDateRangeMacro | String | A predefined macro defining the modified date range, such as 'LastMonth' or 'ThisQuarter'.
使用できる値は次のとおりです。ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR | |
| DetailLevel | String | Specifies the level of detail to include in the report, such as Summary or AllTransactions.
使用できる値は次のとおりです。ALL, ALLEXCEPTSUMMARY, SUMMARYONLY デフォルト値はALLです。 | |
| PostingStatus | String | Filters the report to include only posting transactions, nonposting transactions, or both.
使用できる値は次のとおりです。EITHER, NONPOSTING, POSTING デフォルト値はPOSTINGです。 | |
| IncludeAccounts | String | Indicates whether the report should include all accounts or only those currently in use.
使用できる値は次のとおりです。ALL, INUSE | |
| ReportBasis | String | Defines the accounting method for the report. Use 'Cash' for cash basis, 'Accrual' for accrual basis, or 'None' to use the default report basis. | |
| SummarizeRowsBy | String | Controls how rows are grouped and labeled in the report. For example, set to 'Account' to group rows by account type.
使用できる値は次のとおりです。NONE, ACCOUNT, BALANCESHEET, CLASS, CUSTOMER, CUSTOMERTYPE, DAY, EMPLOYEE, FOURWEEK, HALFMONTH, INCOMESTATEMENT, ITEMDETAIL, ITEMTYPE, MONTH, PAYEE, PAYMENTMETHOD, PAYROLLITEMDETAIL, QUARTER, SALESREP, SALESTAXCODE, SHIPMETHOD, TAXLINE, TERMS, TOTALONLY, TWOWEEK, VENDOR, VENDORTYPE, WEEK, YEAR |