このサンプルでは、テーブルシートを利用する場合のビューカスタマイズ、複数テーブルのリレーションシップ追加、指定フィールドのグループ化やフリーヘッダーの作成などの使い方を示しています。
フリーヘッダー領域：
四半期ごとに決済金額の合計を集計し、2022年~2023年の昨年対比をスパークラインで表示します。
集計結果はテーブルシートの値の更新によって随時反映されます。
テーブルシート領域：
支払い状態と取引日によってデータをグループ化し、決済金額を集計します。
仕訳情報テーブルと支払い情報、社員情報の複数のテーブルシートにリレーションシップを追加しています。
「相手方」列にドロップダウンリストを追加して参照先の社員情報を表示します。
「摘要」列に支払い方法と支払い状態フィールドを含むカスタムビューを追加します。
税区分の選択によって決済金額が更新され、集計データに反映されます。
貸方金額列にデータ検証を実装し、借方金額と異なる値を入力する場合にドッグイヤー表示で強調されます。
借方金額に条件付き書式を実装し、20000以上の場合に赤色で強調されます。
列ヘッダーのスタイルは複数行の設定や、ロックアイコンをカスタマイズしています。シート領域にホバースタイルや交互の行のスタイルを設定しています。
window.onload = function () {
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 0 });
initSpread(spread);
spread.setActiveSheet(1)
};
function initSpread(spread) {
spread.options.scrollbarMaxAlign = true;
spread.options.autoFitType = GC.Spread.Sheets.AutoFitType.cellWithHeader;
spread.options.highlightInvalidData = true;
spread.options.allowDynamicArray = true;
spread.options.dynamicReferences = false;
// データを追加
var dataManager = spread.dataManager();
// テーブルシート設定
initJournalDataTable(spread, dataManager);
}
function initJournalDataTable(spread, dataManager) {
spread.suspendPaint();
spread.clearSheets();
// 仕訳情報テーブルシートスキーマ設定
var journalTableSheet = spread.addSheetTab(
0,
'仕訳情報',
GC.Spread.Sheets.SheetType.tableSheet
);
journalTableSheet.options.allowAddNew = false;
var journalDataTable = dataManager.addTable('仕訳情報', {
data: journalData,
schema: {
columns: {
tradeDate: {
dataType: 'date',
},
counterParty: {
lookup: {
name: 'employee',
columns: [
{ value: 'id', caption: '社員ID', width: 50 },
{ value: 'name', caption: '名前', width: 50 },
{ value: 'mail', caption: 'メールアドレス', width: 180 },
{ value: 'apartment', caption: '部署', width: 120 },
],
},
},
taxDivision: {
dataMap: { 1: '対象外', 2: '8%', 3: '10%' },
lookup: ['対象外', '8%', '10%'],
},
},
},
});
// 支払い情報テーブルシートスキーマ設定
var paymentTableSheet = spread.addSheetTab(
1,
'支払い情報',
GC.Spread.Sheets.SheetType.tableSheet
);
paymentTableSheet.options.allowAddNew = false;
var paymentDataTable = dataManager.addTable('支払い情報', {
data: paymentData,
schema: {
columns: {
paymentStatus: {
lookup: ['取消', '保留中', '返金済み', '支払済み', '未払い'],
},
},
},
});
// 社員情報テーブルシートスキーマ設定
var employeeTableSheet = spread.addSheetTab(
2,
'社員情報',
GC.Spread.Sheets.SheetType.tableSheet
);
employeeTableSheet.options.allowAddNew = false;
var employeeDataTable = dataManager.addTable('社員情報', {
data: employeeData,
});
// リレーションシップを追加
dataManager.addRelationship(
journalDataTable,
'id',
'payment',
paymentDataTable,
'id',
'journal'
);
dataManager.addRelationship(
journalDataTable,
'counterParty',
'employee',
employeeDataTable,
'id',
'journal'
);
// テーブルシートテーマを設定する
journalTableSheet.applyTableTheme(
GC.Spread.Sheets.Tables.TableThemes.light12
);
paymentTableSheet.applyTableTheme(
GC.Spread.Sheets.Tables.TableThemes.medium12
);
employeeTableSheet.applyTableTheme(
GC.Spread.Sheets.Tables.TableThemes.medium19
);
setJournalView(journalTableSheet, journalDataTable);
setPaymentView(paymentTableSheet, paymentDataTable);
setEmployeeView(employeeTableSheet, employeeDataTable);
spread.resumePaint();
}
function setJournalView(journalTableSheet, journalDataTable) {
// 列ヘッダのカスタマイズ
var headerStyle = {
borderTop: {
color: '#c39143',
style: 'thin',
},
borderBottom: {
color: '#c39143',
style: 'thin',
},
};
// 列セルのカスタマイズ
var formulaRule = {
ruleType: 'formulaRule',
formula: '@>20000',
style: {
foreColor: 'red',
},
};
// 借方金額と同じ金額入力検証
var creditValidator = {
type: 'formula',
formula: '@=[@debitAmount]',
inputTitle: 'メモ:',
inputMessage: '借方金額と同じ額を入力してください。',
highlightStyle: {
type: 'dogEar',
color: '#d3381c',
position: GC.Spread.Sheets.CornerPosition.leftTop,
},
};
// カスタム交互行スタイル
journalTableSheet.options.alternatingRowOptions = {
step: [1, 4],
style: new GC.Spread.Sheets.Style('#ede4cd'),
};
// 摘要欄の表示内容
var paymentStyle = {
formatter:
'{{=CONCAT([@payment.paymentMethod], "：", [@payment.paymentStatus])}}',
backColor: '#dcdcdc'
};
// データ書式
var dataBarRule1 = {
ruleType: 'dataBarRule',
color: '#b44c97',
gradient: true,
};
// 行アクション
var rowActions = GC.Spread.Sheets.TableSheet.BuiltInRowActions;
let options = journalTableSheet.rowActionOptions();
options.push(rowActions.saveRow);
journalTableSheet.rowActionOptions(options);
// 仕訳情報テーブルシートに表示するビューを設定
var journalView = journalDataTable.addView('仕訳情報', [
{ value: 'id', caption: 'ID', width: 50, isPrimaryKey: true, },
{
value: 'tradeDate',
caption: '取引日',
style: {
formatter: 'yyyy年mm月dd日',
},
width: 150,
},
{
value:
'=[@debitAmount] + IFS([@taxDivision]=1, 0,[@taxDivision]=2,[@debitAmount]*0.08,[@taxDivision]=3,[@debitAmount]*0.1)',
caption: '決済金額',
headerStyle: headerStyle,
style: {
formatter: '#,##0',
backColor: '#dcdcdc'
},
conditionalFormats: [dataBarRule1],
width: 100,
},
{
value: 'debitAccount',
caption: ['借方', '借方科目'],
headerStyle: headerStyle,
width: 100,
},
{
value: 'debitAmount',
caption: ['借方', '借方金額'],
headerStyle: headerStyle,
style: {
formatter: '#,##0',
},
conditionalFormats: [formulaRule],
width: 100,
},
{
value: 'creditAccount',
caption: ['貸方', '貸方科目'],
headerStyle: headerStyle,
width: 100,
},
{
value: 'creditAmount',
caption: ['貸方', '貸方金額'],
headerStyle: headerStyle,
style: {
formatter: '#,##0',
},
validator: creditValidator,
width: 100,
},
{ value: 'taxDivision', caption: '税区分', width: 80, },
{
value:
'=IFS([@taxDivision]=1, 0,[@taxDivision]=2,[@debitAmount]*0.08,[@taxDivision]=3,[@debitAmount]*0.1)',
caption: '税額',
style: {
formatter: '#,##0',
backColor: '#dcdcdc'
},
width: 85,
},
{ caption: '相手方', value: 'employee.name', width: 80 },
{ caption: '相手方', value: 'counterParty', width: 30 },
{ value: '=[@]', caption: '摘要', style: paymentStyle, width: 200 },
{
caption: '四半期',
value: '=DATEPART([@tradeDate],"yyyyQQ")',
visible: false,
},
{ value: 'payment.paymentStatus', visible: false }
]);
// スタイルルールの追加
var hoverStyle = new GC.Spread.Sheets.Style();
hoverStyle.backColor = '#DDEDF5';
hoverStyle.foreColor = 'green';
journalView.addStyleRule('hoverStyle', hoverStyle, {
state: GC.Data.RowColumnStates.hover,
direction: GC.Data.StateRuleDirection.row,
});
var readonlyStyle = new GC.Spread.Sheets.Style();
readonlyStyle.decoration = {
icons: [{
src: "https://img.icons8.com/ios/50/lock--v1.png"
}]
};
journalView.addStyleRule("readonly", readonlyStyle, {
state: GC.Data.RowColumnStates.readonly,
direction: GC.Data.StateRuleDirection.column,
area: GC.Data.ViewArea.colHeader
});
journalView.fetch(true).then(function () {
customFreeHeader(journalTableSheet);
journalTableSheet.setDataView(journalView);
journalTableSheet.groupBy([
{
caption: '状態',
field: 'payment.paymentStatus',
width: 100,
},
{
caption: '年',
width: 120,
field: '=YEAR([@tradeDate])',
summaryFields: [
{
caption: '合計金額',
formula:
'=SUM([@debitAmount] + IFS([@taxDivision]=1, 0,[@taxDivision]=2,[@debitAmount]*0.08,[@taxDivision]=3,[@debitAmount]*0.1))',
width: 120,
style: { backColor: '#cee4ae', formatter: '#,##0' },
},
],
},
]);
});
}
function setPaymentView(paymentTableSheet, paymentDataTable) {
var radioButtonListStyle = new GC.Spread.Sheets.Style();
var cellTypeRadioButtonList =
new GC.Spread.Sheets.CellTypes.RadioButtonList();
cellTypeRadioButtonList.items([
{ text: '免税', value: 1 },
{ text: '課税', value: 0 },
]);
radioButtonListStyle.cellType = cellTypeRadioButtonList;
var paymentView = paymentDataTable.addView('支払い情報', [
{ value: 'id', caption: '支払いID', width: 120 },
{ value: 'paymentMethod', caption: '支払い方法', width: 150 },
{
value:
'=IFS([@journal.taxDivision]=1, 1,[@journal.taxDivision]=2,0,[@journal.taxDivision]=3,0)',
style: radioButtonListStyle,
caption: '免税',
width: 150,
},
{ value: 'paymentStatus', caption: 'ステータス', width: 120 },
]);
paymentView.fetch().then(function () {
paymentTableSheet.setDataView(paymentView);
});
}
function setEmployeeView(employeeTableSheet, employeeDataTable) {
var employeeView = employeeDataTable.addView('社員情報', [
{ value: 'id', caption: '社員ID', width: 120 },
{ value: 'name', caption: '名前', width: 150 },
{ value: 'mail', caption: 'メールアドレス', width: 250 },
{ value: 'apartment', caption: '部署', width: 120 },
]);
employeeView.fetch().then(function () {
employeeTableSheet.setDataView(employeeView);
});
}
function customFreeHeader(journalTableSheet) {
var templateSheet = new GC.Spread.Sheets.Worksheet();
templateSheet.options.keepUnknownFormulas = true;
var formatter = '¥ #,##0';
templateSheet.setRowCount(6);
templateSheet.setRowHeight(0, 50);
templateSheet.setValue(0, 0, '2022年 - 2023年取引集計');
templateSheet.addSpan(0, 0, 1, 15);
templateSheet.addSpan(1, 5, 5, 10);
var titleStyle = new GC.Spread.Sheets.Style();
titleStyle.backColor = 'white';
titleStyle.foreColor = '#895b8a';
titleStyle.font = 'bold 15pt メイリオ';
titleStyle.hAlign = GC.Spread.Sheets.HorizontalAlign.left;
templateSheet.setStyle(0, 0, titleStyle);
templateSheet.setStyle(1, 5, titleStyle);
var freeHeaderAreaStyle = new GC.Spread.Sheets.Style();
freeHeaderAreaStyle.backColor = '#fef263';
freeHeaderAreaStyle.foreColor = 'brown';
var freeHeaderAreaStyle2 = new GC.Spread.Sheets.Style();
freeHeaderAreaStyle2.backColor = 'white';
freeHeaderAreaStyle2.foreColor = 'black';
var freeHeaderAreaStyle3 = new GC.Spread.Sheets.Style();
freeHeaderAreaStyle3.foreColor = 'black';
freeHeaderAreaStyle3.backColor = '#ede4cd';
templateSheet.getRange('A2:A6').setStyle(freeHeaderAreaStyle);
templateSheet.getRange('B2:D2').setStyle(freeHeaderAreaStyle);
templateSheet.getRange('B3:D6').setStyle(freeHeaderAreaStyle2);
templateSheet.getRange('B4:D4').setStyle(freeHeaderAreaStyle3);
templateSheet.getRange('B6:D6').setStyle(freeHeaderAreaStyle3);
templateSheet.setValue(2, 0, 'Q1');
templateSheet.setValue(3, 0, 'Q2');
templateSheet.setValue(4, 0, 'Q3');
templateSheet.setValue(5, 0, 'Q4');
templateSheet.setValue(1, 1, '2022');
templateSheet.setValue(1, 2, '2023');
templateSheet.setValue(1, 3, '昨対比');
templateSheet.addSpan(1, 3, 1, 2);
templateSheet.setFormula(
2,
1,
'=SUMIF(仕訳情報[四半期], "202201",仕訳情報[決済金額])'
);
templateSheet
.getCell(2, 1)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.setFormula(
2,
2,
'=SUMIF(仕訳情報[四半期], "202301",仕訳情報[決済金額])'
);
templateSheet
.getCell(2, 2)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.addSpan(2, 3, 1, 2);
templateSheet.setFormula(
2,
3,
'=VARISPARKLINE(ROUND(($C$3-B3)/(B3),2),0,,,,,TRUE)'
);
templateSheet.setFormula(
3,
1,
'=SUMIF(仕訳情報[四半期], "202202",仕訳情報[決済金額])'
);
templateSheet
.getCell(3, 1)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.setFormula(
3,
2,
'=SUMIF(仕訳情報[四半期], "202302",仕訳情報[決済金額])'
);
templateSheet
.getCell(3, 2)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.addSpan(3, 3, 1, 2);
templateSheet.setFormula(
3,
3,
'=VARISPARKLINE(ROUND(($C$4-B4)/(B4),2),0,,,,,TRUE)'
);
templateSheet.setFormula(
4,
1,
'=SUMIF(仕訳情報[四半期], "202203",仕訳情報[決済金額])'
);
templateSheet
.getCell(4, 1)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.setFormula(
4,
2,
'=SUMIF(仕訳情報[四半期], "202303",仕訳情報[決済金額])'
);
templateSheet
.getCell(4, 2)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.addSpan(4, 3, 1, 2);
templateSheet.setFormula(
4,
3,
'=VARISPARKLINE(ROUND(($C$5-B5)/(B5),2),0,,,,,TRUE)'
);
templateSheet.setFormula(
5,
1,
'=SUMIF(仕訳情報[四半期], "202204",仕訳情報[決済金額])'
);
templateSheet
.getCell(5, 1)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.setFormula(
5,
2,
'=SUMIF(仕訳情報[四半期], "202304",仕訳情報[決済金額])'
);
templateSheet
.getCell(5, 2)
.hAlign(GC.Spread.Sheets.HorizontalAlign.right)
.formatter(formatter);
templateSheet.addSpan(5, 3, 1, 2);
templateSheet.setFormula(
5,
3,
'=VARISPARKLINE(ROUND(($C$6-B6)/(B6),2),0,,,,,TRUE)'
);
var contentBorderStyle = new GC.Spread.Sheets.Style();
contentBorderStyle.backColor = 'white';
contentBorderStyle.borderBottom = new GC.Spread.Sheets.LineBorder(
'#bc64a4',
GC.Spread.Sheets.LineStyle.thin
);
contentBorderStyle.borderTop = new GC.Spread.Sheets.LineBorder(
'#824880',
GC.Spread.Sheets.LineStyle.medium
);
templateSheet.setStyle(1, -1, contentBorderStyle);
let template = templateSheet.toJSON();
journalTableSheet.applyFreeHeaderArea(template);
}
<!doctype html>
<html style="height:100%;font-size:14px;">
<head>
<meta charset="utf-8" />
<meta name="spreadjs culture" content="ja-jp" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" type="text/css" href="$DEMOROOT$/ja/purejs/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css">
<!-- Promise Polyfill for IE, https://www.npmjs.com/package/promise-polyfill -->
<script src="https://cdn.jsdelivr.net/npm/promise-polyfill@8/dist/polyfill.min.js"></script>
<script src="$DEMOROOT$/ja/purejs/node_modules/@mescius/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script>
<script src="$DEMOROOT$/ja/purejs/node_modules/@mescius/spread-sheets-tablesheet/dist/gc.spread.sheets.tablesheet.min.js" type="text/javascript"></script>
<script src="$DEMOROOT$/ja/purejs/node_modules/@mescius/spread-sheets-resources-ja/dist/gc.spread.sheets.resources.ja.min.js" type="text/javascript"></script>
<script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script>
<script src="app.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="styles.css">
<script src="data.js" type="text/javascript"></script>
</head>
<body>
<div class="sample-tutorial">
<div id="ss" class="sample-spreadsheets"></div>
<div id="optionContainer" class="optionContainer">
</div>
</div>
</body>
</html>
var journalData = [
{
"id": 1,
"tradeDate": "2022/3/9",
"counterParty": 1,
"debitAccount": "現金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 11911,
"creditAccount": "雑収入",
"creditSubAccount": "",
"creditAmount": 11911,
"taxDivision": 3
},
{
"id": 2,
"tradeDate": "2023/11/1",
"counterParty": 2,
"debitAccount": "現金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 2565,
"creditAccount": "受取利息",
"creditSubAccount": "",
"creditAmount": 3333,
"taxDivision": 3
},
{
"id": 3,
"tradeDate": "2022/4/26",
"counterParty": 3,
"debitAccount": "商品",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 26227,
"creditAccount": "受取利息",
"creditSubAccount": "かめ銀行",
"creditAmount": 26227,
"taxDivision": 1
},
{
"id": 4,
"tradeDate": "2022/1/2",
"counterParty": 2,
"debitAccount": "仮払金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 19496,
"creditAccount": "雑収入",
"creditSubAccount": "やまびこ銀行",
"creditAmount": 19496,
"taxDivision": 1
},
{
"id": 5,
"tradeDate": "2023/2/11",
"counterParty": 4,
"debitAccount": "減価償却累計額",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 1532,
"creditAccount": "仮受金",
"creditSubAccount": "みどり銀行",
"creditAmount": 1532,
"taxDivision": 2
},
{
"id": 6,
"tradeDate": "2023/10/7",
"counterParty": 2,
"debitAccount": "減価償却累計額",
"debitSubAccount": "合同会社渡辺製作所",
"debitAmount": 5672,
"creditAccount": "仮受金",
"creditSubAccount": "ねこ銀行",
"creditAmount": 5672,
"taxDivision": 1
},
{
"id": 7,
"tradeDate": "2023/12/30",
"counterParty": 5,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 15354,
"creditAccount": "雑収入",
"creditSubAccount": "みどり銀行",
"creditAmount": 15354,
"taxDivision": 2
},
{
"id": 8,
"tradeDate": "2022/7/10",
"counterParty": 6,
"debitAccount": "減価償却累計額",
"debitSubAccount": "株式会社山田商事",
"debitAmount": 21776,
"creditAccount": "受取利息",
"creditSubAccount": "みどり銀行",
"creditAmount": 21776,
"taxDivision": 2
},
{
"id": 9,
"tradeDate": "2023/2/15",
"counterParty": 1,
"debitAccount": "売掛金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 19457,
"creditAccount": "仮受消費税",
"creditSubAccount": "みどり銀行",
"creditAmount": 4550,
"taxDivision": 1
},
{
"id": 10,
"tradeDate": "2023/11/9",
"counterParty": 1,
"debitAccount": "仮払金",
"debitSubAccount": "株式会社山田商事",
"debitAmount": 18025,
"creditAccount": "仮受金",
"creditSubAccount": "さくら銀行",
"creditAmount": 18025,
"taxDivision": 1
},
{
"id": 11,
"tradeDate": "2022/4/10",
"counterParty": 7,
"debitAccount": "減価償却累計額",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 10509,
"creditAccount": "買掛金",
"creditSubAccount": "さかな銀行",
"creditAmount": 10509,
"taxDivision": 1
},
{
"id": 12,
"tradeDate": "2023/5/18",
"counterParty": 8,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 12997,
"creditAccount": "仮受消費税",
"creditSubAccount": "いるか銀行",
"creditAmount": 12997,
"taxDivision": 1
},
{
"id": 13,
"tradeDate": "2022/2/15",
"counterParty": 9,
"debitAccount": "商品",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 29668,
"creditAccount": "雑収入",
"creditSubAccount": "ぞう銀行",
"creditAmount": 29668,
"taxDivision": 1
},
{
"id": 14,
"tradeDate": "2023/6/3",
"counterParty": 7,
"debitAccount": "立替金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 13789,
"creditAccount": "雑収入",
"creditSubAccount": "みどり銀行",
"creditAmount": 13789,
"taxDivision": 3
},
{
"id": 15,
"tradeDate": "2023/4/2",
"counterParty": 6,
"debitAccount": "現金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 26203,
"creditAccount": "受取利息",
"creditSubAccount": "",
"creditAmount": 26203,
"taxDivision": 2
},
{
"id": 16,
"tradeDate": "2023/6/9",
"counterParty": 3,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 22644,
"creditAccount": "雑収入",
"creditSubAccount": "らいおん銀行",
"creditAmount": 22644,
"taxDivision": 3
},
{
"id": 17,
"tradeDate": "2022/7/20",
"counterParty": 5,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 24360,
"creditAccount": "仮受金",
"creditSubAccount": "さくら銀行",
"creditAmount": 24360,
"taxDivision": 2
},
{
"id": 18,
"tradeDate": "2023/9/18",
"counterParty": 3,
"debitAccount": "売掛金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 30528,
"creditAccount": "買掛金",
"creditSubAccount": "いるか銀行",
"creditAmount": 30528,
"taxDivision": 1
},
{
"id": 19,
"tradeDate": "2023/5/4",
"counterParty": 2,
"debitAccount": "商品",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 29367,
"creditAccount": "未払金",
"creditSubAccount": "かめ銀行",
"creditAmount": 29367,
"taxDivision": 2
},
{
"id": 20,
"tradeDate": "2023/10/14",
"counterParty": 3,
"debitAccount": "売掛金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 4327,
"creditAccount": "受取利息",
"creditSubAccount": "かめ銀行",
"creditAmount": 4327,
"taxDivision": 3
},
{
"id": 21,
"tradeDate": "2023/8/16",
"counterParty": 9,
"debitAccount": "立替金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 16897,
"creditAccount": "未払金",
"creditSubAccount": "みどり銀行",
"creditAmount": 16897,
"taxDivision": 3
},
{
"id": 22,
"tradeDate": "2023/12/30",
"counterParty": 3,
"debitAccount": "売掛金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 8821,
"creditAccount": "未払金",
"creditSubAccount": "らいおん銀行",
"creditAmount": 8821,
"taxDivision": 1
},
{
"id": 23,
"tradeDate": "2022/3/5",
"counterParty": 7,
"debitAccount": "減価償却累計額",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 36170,
"creditAccount": "受取利息",
"creditSubAccount": "たんぽぽ銀行",
"creditAmount": 36170,
"taxDivision": 1
},
{
"id": 24,
"tradeDate": "2022/5/21",
"counterParty": 10,
"debitAccount": "現金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 34862,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 34862,
"taxDivision": 3
},
{
"id": 25,
"tradeDate": "2022/3/27",
"counterParty": 10,
"debitAccount": "仮払金",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 35655,
"creditAccount": "受取利息",
"creditSubAccount": "いぬ銀行",
"creditAmount": 35655,
"taxDivision": 1
},
{
"id": 26,
"tradeDate": "2023/4/6",
"counterParty": 1,
"debitAccount": "立替金",
"debitSubAccount": "株式会社山田商事",
"debitAmount": 28944,
"creditAccount": "買掛金",
"creditSubAccount": "ねこ銀行",
"creditAmount": 28944,
"taxDivision": 2
},
{
"id": 27,
"tradeDate": "2023/10/17",
"counterParty": 8,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 26437,
"creditAccount": "未払金",
"creditSubAccount": "らいおん銀行",
"creditAmount": 26437,
"taxDivision": 2
},
{
"id": 28,
"tradeDate": "2022/7/2",
"counterParty": 9,
"debitAccount": "減価償却累計額",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 12534,
"creditAccount": "買掛金",
"creditSubAccount": "さくら銀行",
"creditAmount": 12534,
"taxDivision": 3
},
{
"id": 29,
"tradeDate": "2022/2/18",
"counterParty": 6,
"debitAccount": "普通預金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 19037,
"creditAccount": "仮受消費税",
"creditSubAccount": "いるか銀行",
"creditAmount": 19037,
"taxDivision": 3
},
{
"id": 30,
"tradeDate": "2023/5/19",
"counterParty": 4,
"debitAccount": "商品",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 23930,
"creditAccount": "未払金",
"creditSubAccount": "いるか銀行",
"creditAmount": 23930,
"taxDivision": 2
},
{
"id": 31,
"tradeDate": "2023/4/10",
"counterParty": 6,
"debitAccount": "商品",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 6044,
"creditAccount": "買掛金",
"creditSubAccount": "らいおん銀行",
"creditAmount": 6044,
"taxDivision": 1
},
{
"id": 32,
"tradeDate": "2022/2/16",
"counterParty": 10,
"debitAccount": "普通預金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 33352,
"creditAccount": "受取利息",
"creditSubAccount": "さくら銀行",
"creditAmount": 33352,
"taxDivision": 2
},
{
"id": 33,
"tradeDate": "2022/5/14",
"counterParty": 9,
"debitAccount": "現金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 7958,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 7800,
"taxDivision": 2
},
{
"id": 34,
"tradeDate": "2023/3/29",
"counterParty": 9,
"debitAccount": "商品",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 7182,
"creditAccount": "未払金",
"creditSubAccount": "たんぽぽ銀行",
"creditAmount": 7182,
"taxDivision": 2
},
{
"id": 35,
"tradeDate": "2023/6/11",
"counterParty": 4,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 36258,
"creditAccount": "買掛金",
"creditSubAccount": "ねこ銀行",
"creditAmount": 36258,
"taxDivision": 1
},
{
"id": 36,
"tradeDate": "2023/9/8",
"counterParty": 6,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 4374,
"creditAccount": "買掛金",
"creditSubAccount": "さくら銀行",
"creditAmount": 4374,
"taxDivision": 1
},
{
"id": 37,
"tradeDate": "2023/11/14",
"counterParty": 10,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 5092,
"creditAccount": "雑収入",
"creditSubAccount": "やまびこ銀行",
"creditAmount": 5092,
"taxDivision": 2
},
{
"id": 38,
"tradeDate": "2022/8/17",
"counterParty": 10,
"debitAccount": "減価償却累計額",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 36077,
"creditAccount": "受取利息",
"creditSubAccount": "きりん銀行",
"creditAmount": 36077,
"taxDivision": 3
},
{
"id": 39,
"tradeDate": "2023/6/1",
"counterParty": 10,
"debitAccount": "現金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 3877,
"creditAccount": "雑収入",
"creditSubAccount": "",
"creditAmount": 3877,
"taxDivision": 2
},
{
"id": 40,
"tradeDate": "2023/3/28",
"counterParty": 7,
"debitAccount": "現金",
"debitSubAccount": "有限会社山口商事",
"debitAmount": 7834,
"creditAccount": "仮受消費税",
"creditSubAccount": "",
"creditAmount": 7834,
"taxDivision": 1
},
{
"id": 41,
"tradeDate": "2023/3/30",
"counterParty": 6,
"debitAccount": "現金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 8385,
"creditAccount": "未払金",
"creditSubAccount": "",
"creditAmount": 8385,
"taxDivision": 1
},
{
"id": 42,
"tradeDate": "2022/9/14",
"counterParty": 1,
"debitAccount": "普通預金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 18565,
"creditAccount": "雑収入",
"creditSubAccount": "いるか銀行",
"creditAmount": 18565,
"taxDivision": 2
},
{
"id": 43,
"tradeDate": "2022/9/17",
"counterParty": 9,
"debitAccount": "現金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 23578,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 23578,
"taxDivision": 2
},
{
"id": 44,
"tradeDate": "2022/6/17",
"counterParty": 5,
"debitAccount": "仮払金",
"debitSubAccount": "株式会社山田商事",
"debitAmount": 21135,
"creditAccount": "買掛金",
"creditSubAccount": "いぬ銀行",
"creditAmount": 21135,
"taxDivision": 2
},
{
"id": 45,
"tradeDate": "2023/8/8",
"counterParty": 3,
"debitAccount": "現金",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 26932,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 26932,
"taxDivision": 3
},
{
"id": 46,
"tradeDate": "2023/12/11",
"counterParty": 6,
"debitAccount": "立替金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 26276,
"creditAccount": "未払金",
"creditSubAccount": "きりん銀行",
"creditAmount": 26276,
"taxDivision": 2
},
{
"id": 47,
"tradeDate": "2023/1/4",
"counterParty": 1,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 31090,
"creditAccount": "仮受消費税",
"creditSubAccount": "ひつじ銀行",
"creditAmount": 31090,
"taxDivision": 3
},
{
"id": 48,
"tradeDate": "2023/1/29",
"counterParty": 9,
"debitAccount": "減価償却累計額",
"debitSubAccount": "合同会社渡辺製作所",
"debitAmount": 11426,
"creditAccount": "買掛金",
"creditSubAccount": "いぬ銀行",
"creditAmount": 11426,
"taxDivision": 3
},
{
"id": 49,
"tradeDate": "2023/1/7",
"counterParty": 2,
"debitAccount": "商品",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 31399,
"creditAccount": "仮受消費税",
"creditSubAccount": "あおぞら銀行",
"creditAmount": 31399,
"taxDivision": 3
},
{
"id": 50,
"tradeDate": "2023/9/4",
"counterParty": 2,
"debitAccount": "仮払金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 23999,
"creditAccount": "買掛金",
"creditSubAccount": "ねこ銀行",
"creditAmount": 23999,
"taxDivision": 1
},
{
"id": 51,
"tradeDate": "2022/4/14",
"counterParty": 5,
"debitAccount": "仮払金",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 7060,
"creditAccount": "仮受金",
"creditSubAccount": "うさぎ銀行",
"creditAmount": 7060,
"taxDivision": 3
},
{
"id": 52,
"tradeDate": "2023/5/4",
"counterParty": 4,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 26865,
"creditAccount": "受取利息",
"creditSubAccount": "ぞう銀行",
"creditAmount": 26865,
"taxDivision": 3
},
{
"id": 53,
"tradeDate": "2023/10/28",
"counterParty": 4,
"debitAccount": "仮払金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 28679,
"creditAccount": "未払金",
"creditSubAccount": "らいおん銀行",
"creditAmount": 28679,
"taxDivision": 1
},
{
"id": 54,
"tradeDate": "2022/6/23",
"counterParty": 1,
"debitAccount": "商品",
"debitSubAccount": "株式会社9商店",
"debitAmount": 4740,
"creditAccount": "仮受消費税",
"creditSubAccount": "いぬ銀行",
"creditAmount": 4740,
"taxDivision": 2
},
{
"id": 55,
"tradeDate": "2023/11/16",
"counterParty": 10,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 16691,
"creditAccount": "受取利息",
"creditSubAccount": "かめ銀行",
"creditAmount": 16691,
"taxDivision": 2
},
{
"id": 56,
"tradeDate": "2023/7/8",
"counterParty": 8,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 19709,
"creditAccount": "仮受消費税",
"creditSubAccount": "いぬ銀行",
"creditAmount": 19709,
"taxDivision": 3
},
{
"id": 57,
"tradeDate": "2023/2/27",
"counterParty": 7,
"debitAccount": "現金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 17341,
"creditAccount": "雑収入",
"creditSubAccount": "",
"creditAmount": 17341,
"taxDivision": 3
},
{
"id": 58,
"tradeDate": "2022/3/26",
"counterParty": 5,
"debitAccount": "現金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 11595,
"creditAccount": "仮受金",
"creditSubAccount": "",
"creditAmount": 11595,
"taxDivision": 3
},
{
"id": 59,
"tradeDate": "2023/1/16",
"counterParty": 6,
"debitAccount": "現金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 25057,
"creditAccount": "受取利息",
"creditSubAccount": "",
"creditAmount": 25057,
"taxDivision": 3
},
{
"id": 60,
"tradeDate": "2023/3/6",
"counterParty": 2,
"debitAccount": "普通預金",
"debitSubAccount": "有限会社山口商事",
"debitAmount": 1538,
"creditAccount": "未払金",
"creditSubAccount": "かめ銀行",
"creditAmount": 1538,
"taxDivision": 1
},
{
"id": 61,
"tradeDate": "2022/11/8",
"counterParty": 4,
"debitAccount": "立替金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 5453,
"creditAccount": "買掛金",
"creditSubAccount": "たんぽぽ銀行",
"creditAmount": 5453,
"taxDivision": 1
},
{
"id": 62,
"tradeDate": "2022/3/29",
"counterParty": 9,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 21784,
"creditAccount": "未払金",
"creditSubAccount": "いぬ銀行",
"creditAmount": 21784,
"taxDivision": 1
},
{
"id": 63,
"tradeDate": "2022/1/29",
"counterParty": 1,
"debitAccount": "商品",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 34340,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 34340,
"taxDivision": 3
},
{
"id": 64,
"tradeDate": "2022/7/6",
"counterParty": 9,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 30075,
"creditAccount": "買掛金",
"creditSubAccount": "いるか銀行",
"creditAmount": 30075,
"taxDivision": 2
},
{
"id": 65,
"tradeDate": "2022/8/29",
"counterParty": 2,
"debitAccount": "減価償却累計額",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 19102,
"creditAccount": "未払金",
"creditSubAccount": "きりん銀行",
"creditAmount": 19102,
"taxDivision": 2
},
{
"id": 66,
"tradeDate": "2023/4/12",
"counterParty": 10,
"debitAccount": "仮払金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 30310,
"creditAccount": "仮受金",
"creditSubAccount": "さかな銀行",
"creditAmount": 30310,
"taxDivision": 1
},
{
"id": 67,
"tradeDate": "2022/12/31",
"counterParty": 3,
"debitAccount": "売掛金",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 35338,
"creditAccount": "買掛金",
"creditSubAccount": "さかな銀行",
"creditAmount": 35338,
"taxDivision": 1
},
{
"id": 68,
"tradeDate": "2023/12/29",
"counterParty": 10,
"debitAccount": "売掛金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 18956,
"creditAccount": "買掛金",
"creditSubAccount": "さくら銀行",
"creditAmount": 18956,
"taxDivision": 2
},
{
"id": 69,
"tradeDate": "2023/5/17",
"counterParty": 1,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 11854,
"creditAccount": "買掛金",
"creditSubAccount": "たんぽぽ銀行",
"creditAmount": 11854,
"taxDivision": 2
},
{
"id": 70,
"tradeDate": "2022/4/14",
"counterParty": 10,
"debitAccount": "商品",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 20317,
"creditAccount": "買掛金",
"creditSubAccount": "たんぽぽ銀行",
"creditAmount": 20317,
"taxDivision": 2
},
{
"id": 71,
"tradeDate": "2023/8/6",
"counterParty": 3,
"debitAccount": "現金",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 6342,
"creditAccount": "未払金",
"creditSubAccount": "",
"creditAmount": 6342,
"taxDivision": 2
},
{
"id": 72,
"tradeDate": "2022/11/22",
"counterParty": 7,
"debitAccount": "普通預金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 16058,
"creditAccount": "雑収入",
"creditSubAccount": "いぬ銀行",
"creditAmount": 16058,
"taxDivision": 2
},
{
"id": 73,
"tradeDate": "2022/10/14",
"counterParty": 10,
"debitAccount": "普通預金",
"debitSubAccount": "合同会社渡辺製作所",
"debitAmount": 24050,
"creditAccount": "受取利息",
"creditSubAccount": "さかな銀行",
"creditAmount": 24050,
"taxDivision": 1
},
{
"id": 74,
"tradeDate": "2022/8/31",
"counterParty": 2,
"debitAccount": "売掛金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 24566,
"creditAccount": "未払金",
"creditSubAccount": "ひつじ銀行",
"creditAmount": 24566,
"taxDivision": 2
},
{
"id": 75,
"tradeDate": "2022/11/4",
"counterParty": 1,
"debitAccount": "立替金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 13828,
"creditAccount": "買掛金",
"creditSubAccount": "さくら銀行",
"creditAmount": 13828,
"taxDivision": 3
},
{
"id": 76,
"tradeDate": "2022/8/7",
"counterParty": 1,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社山口商事",
"debitAmount": 9654,
"creditAccount": "雑収入",
"creditSubAccount": "いるか銀行",
"creditAmount": 9654,
"taxDivision": 2
},
{
"id": 77,
"tradeDate": "2022/2/28",
"counterParty": 6,
"debitAccount": "立替金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 21865,
"creditAccount": "未払金",
"creditSubAccount": "さくら銀行",
"creditAmount": 21865,
"taxDivision": 1
},
{
"id": 78,
"tradeDate": "2023/10/17",
"counterParty": 4,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 29181,
"creditAccount": "雑収入",
"creditSubAccount": "あおぞら銀行",
"creditAmount": 29181,
"taxDivision": 2
},
{
"id": 79,
"tradeDate": "2022/4/21",
"counterParty": 1,
"debitAccount": "商品",
"debitSubAccount": "合同会社渡辺製作所",
"debitAmount": 11699,
"creditAccount": "仮受金",
"creditSubAccount": "",
"creditAmount": 11699,
"taxDivision": 3
},
{
"id": 80,
"tradeDate": "2022/1/22",
"counterParty": 5,
"debitAccount": "立替金",
"debitSubAccount": "株式会社9商店",
"debitAmount": 6661,
"creditAccount": "買掛金",
"creditSubAccount": "いるか銀行",
"creditAmount": 4500,
"taxDivision": 1
},
{
"id": 81,
"tradeDate": "2022/4/14",
"counterParty": 10,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 34159,
"creditAccount": "仮受金",
"creditSubAccount": "",
"creditAmount": 34159,
"taxDivision": 3
},
{
"id": 82,
"tradeDate": "2022/4/6",
"counterParty": 2,
"debitAccount": "売掛金",
"debitSubAccount": "株式会社9商店",
"debitAmount": 1673,
"creditAccount": "仮受消費税",
"creditSubAccount": "やまびこ銀行",
"creditAmount": 1673,
"taxDivision": 1
},
{
"id": 83,
"tradeDate": "2022/10/20",
"counterParty": 8,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 25929,
"creditAccount": "仮受金",
"creditSubAccount": "やまびこ銀行",
"creditAmount": 25929,
"taxDivision": 3
},
{
"id": 84,
"tradeDate": "2022/12/6",
"counterParty": 4,
"debitAccount": "売掛金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 12443,
"creditAccount": "買掛金",
"creditSubAccount": "いぬ銀行",
"creditAmount": 12443,
"taxDivision": 1
},
{
"id": 85,
"tradeDate": "2022/9/20",
"counterParty": 5,
"debitAccount": "立替金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 21238,
"creditAccount": "未払金",
"creditSubAccount": "あおぞら銀行",
"creditAmount": 21238,
"taxDivision": 2
},
{
"id": 86,
"tradeDate": "2023/8/25",
"counterParty": 5,
"debitAccount": "商品",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 1733,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 1733,
"taxDivision": 1
},
{
"id": 87,
"tradeDate": "2023/12/19",
"counterParty": 8,
"debitAccount": "減価償却累計額",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 7834,
"creditAccount": "仮受金",
"creditSubAccount": "ねこ銀行",
"creditAmount": 7834,
"taxDivision": 2
},
{
"id": 88,
"tradeDate": "2022/4/4",
"counterParty": 7,
"debitAccount": "仮払金",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 36250,
"creditAccount": "未払金",
"creditSubAccount": "ひつじ銀行",
"creditAmount": 36250,
"taxDivision": 3
},
{
"id": 89,
"tradeDate": "2022/11/11",
"counterParty": 6,
"debitAccount": "普通預金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 9688,
"creditAccount": "仮受金",
"creditSubAccount": "やまびこ銀行",
"creditAmount": 9688,
"taxDivision": 2
},
{
"id": 90,
"tradeDate": "2022/4/21",
"counterParty": 2,
"debitAccount": "現金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 13339,
"creditAccount": "仮受金",
"creditSubAccount": "",
"creditAmount": 13339,
"taxDivision": 3
},
{
"id": 91,
"tradeDate": "2022/6/7",
"counterParty": 6,
"debitAccount": "現金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 5622,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 5622,
"taxDivision": 2
},
{
"id": 92,
"tradeDate": "2022/4/15",
"counterParty": 7,
"debitAccount": "普通預金",
"debitSubAccount": "株式会社山田商事",
"debitAmount": 5792,
"creditAccount": "雑収入",
"creditSubAccount": "いるか銀行",
"creditAmount": 5792,
"taxDivision": 2
},
{
"id": 93,
"tradeDate": "2023/8/12",
"counterParty": 9,
"debitAccount": "立替金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 21625,
"creditAccount": "未払金",
"creditSubAccount": "かめ銀行",
"creditAmount": 21625,
"taxDivision": 3
},
{
"id": 94,
"tradeDate": "2022/12/16",
"counterParty": 3,
"debitAccount": "仮払金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 20433,
"creditAccount": "買掛金",
"creditSubAccount": "",
"creditAmount": 20433,
"taxDivision": 2
},
{
"id": 95,
"tradeDate": "2023/2/15",
"counterParty": 3,
"debitAccount": "立替金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 9299,
"creditAccount": "受取利息",
"creditSubAccount": "きりん銀行",
"creditAmount": 9299,
"taxDivision": 2
},
{
"id": 96,
"tradeDate": "2022/7/16",
"counterParty": 2,
"debitAccount": "普通預金",
"debitSubAccount": "株式会社田中商店",
"debitAmount": 25291,
"creditAccount": "買掛金",
"creditSubAccount": "きりん銀行",
"creditAmount": 25291,
"taxDivision": 1
},
{
"id": 97,
"tradeDate": "2022/10/26",
"counterParty": 3,
"debitAccount": "立替金",
"debitSubAccount": "合同会社双葉製品",
"debitAmount": 18393,
"creditAccount": "買掛金",
"creditSubAccount": "ぞう銀行",
"creditAmount": 18393,
"taxDivision": 3
},
{
"id": 98,
"tradeDate": "2023/1/21",
"counterParty": 2,
"debitAccount": "商品",
"debitSubAccount": "有限会社佐藤製作所",
"debitAmount": 31048,
"creditAccount": "買掛金",
"creditSubAccount": "いるか銀行",
"creditAmount": 31048,
"taxDivision": 1
},
{
"id": 99,
"tradeDate": "2023/11/19",
"counterParty": 3,
"debitAccount": "仮払金",
"debitSubAccount": "合同会社高橋商事",
"debitAmount": 1622,
"creditAccount": "仮受消費税",
"creditSubAccount": "かめ銀行",
"creditAmount": 1622,
"taxDivision": 2
},
{
"id": 100,
"tradeDate": "2023/8/30",
"counterParty": 8,
"debitAccount": "売掛金",
"debitSubAccount": "有限会社斉藤製品",
"debitAmount": 32906,
"creditAccount": "仮受金",
"creditSubAccount": "いるか銀行",
"creditAmount": 32906,
"taxDivision": 2
}
];
var paymentData = [
{
"id": 1,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 2,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 3,
"paymentMethod": "後払い",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 4,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 5,
"paymentMethod": "キャッシュ",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 6,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 7,
"paymentMethod": "モバイル決済",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 8,
"paymentMethod": "デビットカード",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 9,
"paymentMethod": "デビットカード",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 10,
"paymentMethod": "仮想通貨",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 11,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 12,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 13,
"paymentMethod": "モバイル決済",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 14,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 15,
"paymentMethod": "銀行振込",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 16,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 17,
"paymentMethod": "銀行振込",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 18,
"paymentMethod": "デビットカード",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 19,
"paymentMethod": "PayPal",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 20,
"paymentMethod": "コンビニ支払い",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 21,
"paymentMethod": "デビットカード",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 22,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 23,
"paymentMethod": "コンビニ支払い",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 24,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 25,
"paymentMethod": "モバイル決済",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 26,
"paymentMethod": "後払い",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 27,
"paymentMethod": "電子マネー",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 28,
"paymentMethod": "後払い",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 29,
"paymentMethod": "キャッシュ",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 30,
"paymentMethod": "コンビニ支払い",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 31,
"paymentMethod": "デビットカード",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 32,
"paymentMethod": "PayPal",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 33,
"paymentMethod": "仮想通貨",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 34,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 35,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 36,
"paymentMethod": "デビットカード",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 37,
"paymentMethod": "キャッシュ",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 38,
"paymentMethod": "電子マネー",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 39,
"paymentMethod": "電子マネー",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 40,
"paymentMethod": "クレジットカード",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 41,
"paymentMethod": "電子マネー",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 42,
"paymentMethod": "コンビニ支払い",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 43,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 44,
"paymentMethod": "PayPal",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 45,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 46,
"paymentMethod": "銀行振込",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 47,
"paymentMethod": "キャッシュ",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 48,
"paymentMethod": "デビットカード",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 49,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 50,
"paymentMethod": "後払い",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 51,
"paymentMethod": "PayPal",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 52,
"paymentMethod": "クレジットカード",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 53,
"paymentMethod": "仮想通貨",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 54,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 55,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 56,
"paymentMethod": "仮想通貨",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 57,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 58,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 59,
"paymentMethod": "PayPal",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 60,
"paymentMethod": "デビットカード",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 61,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 62,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 63,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 64,
"paymentMethod": "銀行振込",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 65,
"paymentMethod": "クレジットカード",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 66,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 67,
"paymentMethod": "クレジットカード",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 68,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 69,
"paymentMethod": "モバイル決済",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 70,
"paymentMethod": "クレジットカード",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 71,
"paymentMethod": "銀行振込",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 72,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 73,
"paymentMethod": "銀行振込",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 74,
"paymentMethod": "コンビニ支払い",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 75,
"paymentMethod": "PayPal",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 76,
"paymentMethod": "電子マネー",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 77,
"paymentMethod": "キャッシュ",
"taxFree": "TRUE",
"paymentStatus": "保留中"
},
{
"id": 78,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 79,
"paymentMethod": "キャッシュ",
"taxFree": "FALSE",
"paymentStatus": "支払済み"
},
{
"id": 80,
"paymentMethod": "電子マネー",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 81,
"paymentMethod": "モバイル決済",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 82,
"paymentMethod": "PayPal",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 83,
"paymentMethod": "クレジットカード",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 84,
"paymentMethod": "デビットカード",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 85,
"paymentMethod": "PayPal",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 86,
"paymentMethod": "後払い",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 87,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 88,
"paymentMethod": "コンビニ支払い",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 89,
"paymentMethod": "キャッシュ",
"taxFree": "FALSE",
"paymentStatus": "取消"
},
{
"id": 90,
"paymentMethod": "キャッシュ",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 91,
"paymentMethod": "PayPal",
"taxFree": "FALSE",
"paymentStatus": "返金済み"
},
{
"id": 92,
"paymentMethod": "銀行振込",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 93,
"paymentMethod": "仮想通貨",
"taxFree": "TRUE",
"paymentStatus": "支払済み"
},
{
"id": 94,
"paymentMethod": "モバイル決済",
"taxFree": "TRUE",
"paymentStatus": "未払い"
},
{
"id": 95,
"paymentMethod": "クレジットカード",
"taxFree": "TRUE",
"paymentStatus": "返金済み"
},
{
"id": 96,
"paymentMethod": "モバイル決済",
"taxFree": "TRUE",
"paymentStatus": "取消"
},
{
"id": 97,
"paymentMethod": "銀行振込",
"taxFree": "FALSE",
"paymentStatus": "未払い"
},
{
"id": 98,
"paymentMethod": "電子マネー",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 99,
"paymentMethod": "デビットカード",
"taxFree": "FALSE",
"paymentStatus": "保留中"
},
{
"id": 100,
"paymentMethod": "銀行振込",
"taxFree": "TRUE",
"paymentStatus": "保留中"
}
];
var employeeData = [
{
"id": 1,
"name": "渡辺",
"mail": "watanabe001@spreadsheet.com",
"apartment": "営業部"
},
{
"id": 2,
"name": "鈴木",
"mail": "suzuki002@spreadsheet.com",
"apartment": "人事部"
},
{
"id": 3,
"name": "伊藤",
"mail": "ito003@spreadsheet.com",
"apartment": "技術部"
},
{
"id": 4,
"name": "佐藤",
"mail": "sato004@spreadsheet.com",
"apartment": "営業部"
},
{
"id": 5,
"name": "山田",
"mail": "yamada005@spreadsheet.com",
"apartment": "人事部"
},
{
"id": 6,
"name": "田中",
"mail": "tanaka006@spreadsheet.com",
"apartment": "経理部"
},
{
"id": 7,
"name": "加藤",
"mail": "kato007@spreadsheet.com",
"apartment": "営業部"
},
{
"id": 8,
"name": "藤田",
"mail": "fujita008@spreadsheet.com",
"apartment": "技術部"
},
{
"id": 9,
"name": "高橋",
"mail": "takahashi009@spreadsheet.com",
"apartment": "技術部"
},
{
"id": 10,
"name": "中村",
"mail": "nakamura010@spreadsheet.com",
"apartment": "経理部"
}
];
.sample-tutorial {
position: relative;
height: 100%;
overflow: hidden;
}
body {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
}
.sample-spreadsheets {
width: 100%;
height: 100%;
overflow: hidden;
float: left;
}
