ODBC Driver for QuickBooks

Build 24.0.9062

ProfitAndLossStandard

Profit & Loss YTD Comparison Report.

Columns

Name Type References Description
Label String The Label column of the ProfitAndLossStandard report.
Amount Double The Amount column of the ProfitAndLossStandard report.
RowType String The type of data in the row. For example, Text, Data, Subtotal, or Total.

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 where either value may be omitted for an open-ended range (e.g., 2009-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

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

PostingStatus String Allows you to query for posting reports, nonposting reports, or reports that are either one.

使用できる値は次のとおりです。EITHER, NONPOSTING, POSTING

ReportAsOf String The report will return open balance information up to the reportopenbalanceasof date.

使用できる値は次のとおりです。REPORTENDDATE, TODAY

SummarizeColumnsBy String Determines which data the report calculates and how the columns will be labeled across the top of the report.

使用できる値は次のとおりです。NONE, ACCOUNT, BALANCESHEET, CLASS, CUSTOMER, CUSTOMERTYPE, DAY, EMPLOYEE, FOURWEEK, HALFMONTH, INCOMESTATEMENT, ITEMDETAIL, ITEMTYPE, MONTH, PAYEE, PAYMENTMETHOD, PAYROLLITEMDETAIL, QUARTER, SALESREP, SALESTAXCODE, SHIPMETHOD, TERMS, TOTALONLY, TWOWEEK, VENDOR, VENDORTYPE, WEEK, YEAR

IncludeSubColumns String A boolean indicating if subcolumns should be included.
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.)
ReturnColumns String Specifies whether you want the report to include only columns with active information, only columns with nonzero values, or all columns regardless of their content or active status.

使用できる値は次のとおりです。NONE, ACTIVEONLY, NONZERO, All

ReturnRows String Specifies whether you want the report to include only rows with active information, only rows with nonzero values, or all rows regardless of their content or active status.

使用できる値は次のとおりです。NONE, ACTIVEONLY, NONZERO, All

ReportCalendar String Specifies the type of year that will be used for this report.

使用できる値は次のとおりです。NONE, CALENDARYEAR, FISCALYEAR, TAXYEAR

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062