HojoZanReport
Query the Supplementary Account Balance (Hojo Zan) report. Returns balance details by supplementary account for a given account subject and date range.
Columns
| Name | Type | Description |
| Type | String | Record type (0=detail, 2=subtotal, 5=total) |
| HojoId | Int | Supplementary account ID |
| BEVersion | Int | API version |
| ZenZan | Decimal | Previous balance |
| DrMoney | Decimal | Debit amount |
| CrMoney | Decimal | Credit amount |
| Zan | Decimal | Balance |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| CalcDateFrom | String | Calculation start date (YYYYMMDD) |
| CalcDateTo | String | Calculation end date (YYYYMMDD) |
| JournalClassFrom | Int | Journal class from (e.g., 11) |
| JournalClassTo | Int | Journal class to (e.g., 33) |
| ManageClassType | Int | Manage class type |
| KmkId | Int | Account subject ID (Kamoku ID) |
| BuId | Int | Department ID |
| IsInTax | Bool | Include tax flag |
| Is0Yen | Bool | Include 0 yen records |
| IsZan | Bool | Balance flag |
| ZanReportType | Int | Report type: 0=Supplementary account (default), 1=Trading partner (hyper only) |
| FlagFormat | String | Flag format: Number or String
使用できる値は次のとおりです。String, Number |