CreateInventoryValuationDetailReport
Generates an Inventory Valuation Detail report schema file.
Input
| Name | Type | Description |
| ReportName | String | The name of the report.
デフォルト値はInventoryValuationDetailReportです。 |
| ReportDescription | String | A description for the report. If one is not specified, a description based on the ReportType will be selected. |
| Columns | String | Column types to be shown in the report. A comma separated list of one or more of the following: acct_num_with_extn,account_name,credit_amt,create_by,create_date,debt_amt,doc_num,due_date,is_ar_paid,is_ap_paid,item_name,journal_code_name,last_mod_by,last_mod_date,memo,name,neg_open_bal,paid_date,pmt_mthd,quantity,rate,tx_date,txn_num,txn_type. |
| DateMacro | String | A predefined date range. Use this if you want the report to cover a standard report date range. Otherwise, use the StartDate and EndDate to cover an explicit range.
使用できる値は次のとおりです。Today, Yesterday, This Week, This Week-to-date, Last Week, Last Week-to-date, Next Week, Next 4 Weeks, This Month, This Month-to-date, Last Month, Last Month-to-date, Next Month, This Fiscal Quarter, This Fiscal Year, This Fiscal Year-to-date, Last Fiscal Year, Last Fiscal Year-to-date, Next Fiscal Year |
| StartDate | String | The startdate of the report. StartDate must be less than EndDate. |
| EndDate | String | The enddate of the report. EndDate must be greater than StartDate. |
| SvcDateMacro | String | Predefined date range. Use if you want the report to cover a standard report date range; otherwise, use the SvcStartDate and SvcEndDate to cover an explicit report date range.
使用できる値は次のとおりです。Today, Yesterday, This Week, Last Week, This Week-to-date, Last Week-to-date, Next Week, Next 4 Weeks, This Month, Last Month, This Month-to-date, Last Month-to-date, Next Month, This Fiscal Quarter, Last Fiscal Quarter, This Fiscal Quarter-to-date, Last Fiscal Quarter-to-date, Next Fiscal Quarter, This Fiscal Year, Last Fiscal Year, This Fiscal Year-to-date, Last Fiscal Year-to-date, Next Fiscal Year |
| SvcStartDate | String | The startdate of the report. SvcStartDate must be less than SvcEndDate. |
| SvcEndDate | String | The enddate of the report. SvcEndDate must be greater than SvcStartDate. |
| GroupBy | String | The field in the transaction by which to group results.
使用できる値は次のとおりです。Name, Account, Transaction Type, Customer, Vendor, Employee, Location, Payment Method, Day, Week, Month, Quarter, Year, None |
| Indentation | String | Add spaces at the start of values to visually identify totals and group values. |
| WriteToFile | String | Whether to write to an output file or not. Defaults to true, must be set to false to write to FileStream or FileData. |
Result Set Columns
| Name | Type | Description |
| Result | String | Success or Failure. |
| SchemaFile | String | The generated schema file. |
| Columns | String | The number of columns found. |
| FileData | String | The BASE64 downloaded file content. Only returned if WriteToFile set to false and FileStream is not set. |