BalanceSheetDetail
Balance Sheet Detail Report.
Columns
| Name | Type | References | Description |
| Label | String | The Label column of the BalanceSheetDetail report. | |
| Type | String | The Type column of the BalanceSheetDetail report. | |
| Date | Date | The Date column of the BalanceSheetDetail report. | |
| Num | String | The Num column of the BalanceSheetDetail report. | |
| Name | String | The Name column of the BalanceSheetDetail report. | |
| Memo | String | The Memo column of the BalanceSheetDetail report. | |
| Class | String | The Class column of the BalanceSheetDetail report. | |
| Clr | String | The Clr column of the BalanceSheetDetail report. | |
| Split | String | The Split column of the BalanceSheetDetail report. | |
| Amount | Decimal | The Amount column of the BalanceSheetDetail report. | |
| Balance | Double | The Balance column of the BalanceSheetDetail report. |
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 | Report date range in the format fromdate:todate. Set the todate to get balance as of (e.g., :2017-12-25). Supported date format: yyyy-MM-dd. | |
| ReportDateRangeMacro | String | A macro that can be specified for the report date range.
使用できる値は次のとおりです。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 | The specific type of account to request in the report.
使用できる値は次のとおりです。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. Also specify a value for AccountListType if specifying a value for this input. | |
| AccountListType | String | Allows the user to query for specific list accounts.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| EntityType | String | The specific type of entity to request in the report.
使用できる値は次のとおりです。NONE, CUSTOMER, EMPLOYEE, OTHERNAME, VENDOR | |
| EntityList | String | A comma separated list of entity names or IDs. Also specify a value for EntityListType if specifying a value for this input. | |
| EntityListType | String | Allows the user to query for specific list of entities.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| ItemType | String | The specific type of item to request in the report.
使用できる値は次のとおりです。NONE, ALLEXCEPTFIXEDASSET, ASSEMBLY, DISCOUNT, FIXEDASSET, INVENTORY, INVENTORYANDASSEMBLY, NONINVENTORY, OTHERCHARGE, PAYMENT, SALES, SALESTAX, SERVICE | |
| ItemList | String | A comma separated list of item names or IDs. Also specify a value for ItemListType if specifying a value for this input. | |
| ItemListType | String | Allows the user to query for specific list of items.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| ClassList | String | A comma separated list of class names or IDs. Also specify a value for ClassListType if specifying a value for this input. | |
| ClassListType | String | Allows the user to query for specific list of classes.
使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN | |
| TransactionTypes | String | A comma separated list of the transaction types you want the report to cover. Values include ALL,ARREFUNDCREDITCARD,BILL,BILLPAYMENTCHECK,BILLPAYMENTCREDITCARD,BUILDASSEMBLY,CHARGE,CHECK,CREDITCARDCHARGE,CREDITCARDCREDIT,CREDITMEMO,DEPOSIT,ESTIMATE,INVENTORYADJUSTMENT,INVOICE,ITEMRECEIPT,JOURNALENTRY,LIABILITYADJUSTMENT,PAYCHECK,PAYROLLLIABILITYCHECK,PURCHASEORDER,RECEIVEPAYMENT,SALESORDER,SALESRECEIPT,SALESTAXPAYMENTCHECK,TRANSFER,VENDORCREDIT,YTDADJUSTMENT. | |
| ModifiedDateRange | String | Date modified range in the format fromdate:todate where either value may be omitted for an open-ended range (e.g., 2009-12-25:). Supported date format: yyyy-MM-dd. | |
| ModifiedDateRangeMacro | String | A predefined date modified range.
使用できる値は次のとおりです。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 | The level of detail to include in the report.
使用できる値は次のとおりです。ALL, ALLEXCEPTSUMMARY, SUMMARYONLY デフォルト値はALLです。 | |
| PostingStatus | String | Allows you to query for posting reports, nonposting reports, or reports that are either one.
使用できる値は次のとおりです。EITHER, NONPOSTING, POSTING デフォルト値はPOSTINGです。 | |
| IncludeAccounts | String | Indicates whether this report should include all accounts or just those that are currently in use.
使用できる値は次のとおりです。ALL, INUSE | |
| ReportBasis | String | If reportbasis is Cash, the report bases income and expenses on the dates when money changed hands. If Accrual, the report bases income on the dates when customers were invoiced and bases expenses on the dates when bills were entered. If None, the report uses the default report basis, which is either the QuickBooks preference setting or the QuickBooks default for a given type of report. In a report response, the SDK returns None for reports that do not support a report basis. (The 1099 report, for example, has its own basis for generation.) | |
| SummarizeRowsBy | String | Determines along with includecolumnlist, in most cases, what data is calculated for this report and controls how the rows are organized and labeled. For example, if you set the value to Account, the reports row labels might be Checking, Savings, and so on.
使用できる値は次のとおりです。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 |