
第2å æ§é åCSVãšã¯äœã
Ledger Explorer ã¯ããªãæ§é åCSVããææ¬¡åž³ç°¿ãèšç®ã§ããã®ã
Ledger Explorer ã¯ããªãæ§é åCSVããææ¬¡åž³ç°¿ãèšç®ã§ããã®ã§ããããããã®éµã«ãªãã®ãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§æ£èŠåãããè€æ°ã®è¡šããéå±€æ§é ãä¿ã£ããŸãŸãéè€ãå¢ãããã«1æã®CSVãšããŠè¡šããšããèãæ¹ã§ãã
ãã®èšäºã§ã¯ãä»èš³çªå·ãæ¥ä»ãæã€äŒç¥šããããšãæèŠãåæ¹ã貞æ¹ãè£å©ç§ç®ãéšéãªã©ãæã€æçްè¡ãšã®é¢ä¿ããã©ã®ããã«1ã€ã®ããŒã¿ãšããŠè¡šããã®ããæŽçããªãããæ§é åCSVã®åºæ¬çãªèãæ¹ãšãLedger Explorer ããããã©ã®ããã«äŒèšåž³ç°¿ã®èšç®ã«äœ¿ã£ãŠããã®ããåããããã説æããŸãã
ããã§ããæ§é åCSVã¯ãåã«é ç®ã暪ã«äžŠã¹ãCSVã§ã¯ãããŸããããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§æ£èŠåãããè€æ°ã®è¡šãããã®è«ççãªé¢ä¿ãšéå±€æ§é ãä¿ã£ããŸãŸãéè€ãå¢ãããã«1æã®CSVãšããŠè¡šãããã®ã§ããèšãæããã°ãæ§é åCSVã¯ãæ°ãã圢åŒã®æ£èŠå衚ã ãšæããããšãã§ããŸãã
äŒèšããŒã¿ã¯ããªãã1æã®æ§é åCSVãã§æãŠãã®ã
äŒèšããŒã¿ãæ±ããšããå€ãã®äººããŸãæãæµ®ãã¹ãã®ã¯ãããŒã¿ããŒã¹ã«æ£èŠåããŠä¿åããå¿ èŠãªãšãã«è¡šã©ããã察å¿ã¥ããŠäœ¿ãæ¹æ³ã§ã¯ãªãã§ãããããå®éã20äžçŽåŸåã«ã³ããå士ãæå±ãããªã¬ãŒã·ã§ãã«ã¢ãã«ãšããããæ¯ããæ£èŠåã®èãæ¹ã¯ãããŒã¿ããŒã¹ã®æ®åã«å€§ããè²¢ç®ããŸãããæ¥ã ã®æ¥ååŠçã«ãããŠãéè€ãæžãããäžè²«æ§ãä¿ã¡ãæ€çŽ¢ãæŽæ°ãããããããããã§ããã®èãæ¹ã¯ä»ã§ãéèŠã§ãã
ãã ããããã§èª€è§£ããŠã¯ãªããªãã®ã¯ãæ§é åCSVã¯ããã®æ£èŠåã®èãæ¹ãæšãŠããã®ã§ã¯ãªããšããããšã§ãããããéã§ãæ§é åCSVã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§æ£èŠåãããè€æ°ã®è¡šã®è«çæ§é ãããã®é¢ä¿ãä¿ã£ããŸãŸã1æã®CSVãšããŠè¡šãããšãããã®ã§ãã
ã€ãŸããããããæçްãè£å©ç§ç®ãéšéãçšåºåãšãã£ãæ å ±ããåçŽã«æšªã«äžŠã¹ãŠéè€ãããããã¿ãªCSVãã§ã¯ãããŸãããããŒã¿ã®éè€ãå¢ããããããããã©ã®æçްãã©ã®äŒç¥šã«å±ããã©ã®è£å©æ å ±ãã©ã®æçްã«å¯Ÿå¿ããããåããããã«ãéå±€æ§é ãä¿ã£ããŸãŸ1æã®CSVã«åããŠããã®ã§ãã
éèŠãªã®ã¯ãæ§é åCSVãæ£èŠåã®èãæ¹ãå£ããŠããã®ã§ã¯ãªãããšããç¹ã§ãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ã¯ãä»èš³ããããä»èš³æçްãè£å©ç§ç®ãéšéãçšåºåãšãã£ãæ å ±ãè€æ°ã®è¡šã«åããŠä¿æããŸããæ§é åCSVã§ã¯ãããããç©ççã«å¥è¡šãšããŠåãã代ããã«ã1æã®CSVã®äžã«éå±€æ§é ãšããŠåã蟌ã¿ããã®é¢ä¿ããã£ã¡ã³ã·ã§ã³åã§è¡šããŸããã€ãŸããè€æ°ã®æ£èŠå衚ããè«çæ§é ãä¿ã£ããŸãŸ1æã«æããããã ãã®ã ãšèšããŸãã
ãã®ç¹ããéåžžã®ãã©ãããªCSVãšããããŒã¿ããŒã¹ã®è€æ°è¡šãšãç°ãªããæ§é åCSVã®ãã¡ã°ã倧äºãªç¹åŸŽã§ãã
äŒèšå®åã«ãšã£ãŠããªãéèŠã
äŒèšå£«ã»çšç士ã®ç«å ŽããèŠããšãããã®æ¹åŒã®æçŸ©ã¯æç¢ºã§ãã
第äžã«ããã®æç¹ã®æå³ãä¿ã£ããŸãŸããŒã¿ãä¿åãããããããåŸããå
容ã確èªããããããšã§ãã
第äºã«ãäŒèšãœããã®å€æŽãããŒãžã§ã³æŽæ°ããã£ãŠããããŒã¿ã®æå³ã倱ãã«ããããšã§ãã
第äžã«ãç£æ»ãçšå調æ»ãé»å垳簿ä¿åæ³å¯Ÿå¿ãšãã£ãå Žé¢ã§ãåãªãç»é¢åºåã§ã¯ãªããåèšç®å¯èœãªåæ¬ããŒã¿ãšããŠæ±ããããããšã§ãã
æ§é åCSVã¯ãåãªã亀æçšã®CSVã§ã¯ãªããäŒèšããŒã¿ã®åæ¬ã®æã¡æ¹ãã®ãã®ãèŠçŽãææ¡ã ãšèšããŸãã
åŸæ¥ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®æ£èŠåã§ã¯ãã©ãèããã
ç§ã®ããã°èšäºãTidy dataãšXBRL-CSVã®æé¶Žã¢ãã«ãã§ãè§Šããããã«ãéåžžããããããŒã¿ãæŽçããã«ã¯ãCoddåå£«ã®æ£èŠåãè¡ããŸãã
ããšãã°ã1ã€ã®ä»èš³ã®äžã«ã次ã®ãããªæ å ±ãå«ãŸããŠãããšããŸãã
ä»èš³çªå·
æ¥ä»
æèŠ
æçްè¡
åæ¹éé¡
貞æ¹éé¡
ç§ç®
éšé
çšåºå
ã«ãŒãäŒç€Ÿ
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§æ±ããªãããããã¯æ®éãæå³ããšã«å¥ã ã®è¡šãžåè§£ãããŸããããšãã°ãä»èš³ããããä»èš³æçްãéšéãæ¶è²»çšãã«ãŒãæ å ±ãšãã£ãå ·åã§ãããããŠãå¿ èŠãªåž³ç¥šãäœããšãã«ã¯ããããã®è¡šãä»èš³çªå·ãè¡çªå·ã§å¯Ÿå¿ã¥ããŠãå ã®æå³ã埩å ããŸãã
ãã®æ¹åŒã®åŒ·ã¿ã¯æç¢ºã§ããæŽæ°ã«åŒ·ããæŽåæ§ãä¿ã¡ããããå€äººæ°ã§åæã«æ±ãæ¥åã·ã¹ãã ã«ã¯åããŠããŸãã
ãããã匱ç¹ããããŸããã³ãŒãã®æå³ãå¥ã®ãã¹ã¿ãŒè¡šã«æãããããšãå€ããããé廿ç¹ã®æå³ãããã®ããŒã¿åç¬ã§ã¯ç¢ºèªãã«ããã®ã§ãã
ããšãã°ãçšåºåã³ãŒããéšéã³ãŒãã®æå³ãåŸããå€ãã£ãå ŽåãçŸåšã®ãã¹ã¿ãŒè¡šã§éå»ããŒã¿ãèªãã§ããŸããšããã®åœæã®æå³ã倱ããããããããããŸããæ¥ã ã®æ¥ååŠçã§ã¯äŸ¿å©ã§ããç£æ»ãé·æä¿åãåå©çšã®èгç¹ã§ã¯ãããã倧ããªèª²é¡ã«ãªããŸãã
Ledger Explorer ã¯ãä¿å圢åŒã®åæãå€ããŠãã
Ledger Explorer ã®èãæ¹ã¯ãããã§å€§ããæ¹åãå€ããŸãã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®ããã«ãæåãã衚ãåããŠä¿åããããšã§å¯Ÿå¿ã¥ããŠæå³ã埩å ããã®ã§ã¯ãããŸãããäŒç¥šãæçްãè£å©ç§ç®ãéšéãçšåºåãªã©ã®é¢ä¿ããæ£èŠåãããè€æ°è¡šã®è«çæ§é ãä¿ã£ããŸãŸã1ã€ã®æ§é åCSVã®äžã«éå±€ãšããŠä¿æããã®ã§ãã
ã€ãŸããä¿åæç¹ã§æå³ã®ãŸãšãŸããå£ããªããããããéè€ãã§ããã ãå¢ãããªãããã®ããã§ãå¿ èŠãªãšãã«ããã®éå±€ã垳簿衚瀺çšã«å±éãããããã Ledger Explorer ã®åºæ¬å§¿å¢ã§ãã
ããã§éèŠãªã®ã¯ãLedger Explorer ãã衚ã©ããã®å¯Ÿå¿ã¥ãããŸã£ãã䜿ããªãããšããæå³ã§ã¯ãªãããšã§ããå®éã«ã¯ãPythonãšããããã°ã©ã èšèªã§äœ¿ãããã衚圢åŒãæ°å€ããŒã¿ãæ±ãããã®ã©ã€ãã©ãªã§ãã pandas ãçšããŠãäŒç¥šãããã®å€ãæçްã«è£ã£ãããè£å©ç§ç®ãéšéã®æ å ±ãæçްè¡ã«æ»ããããããäžæçãªèšç®ãè¡ã£ãŠããŸãã
ãã ããããã¯ä¿å圢åŒãšããŠæåããè€æ°ã®è¡šãåæã«ããŠããã®ã§ã¯ãããŸãããæ§é åCSVã«ä¿æãããéå±€ãæèãã垳簿衚瀺ã®ããã«å±éããŠããåŠçã§ãã
ããã¯ãå¹³ããªçŽã«ãããããæãç·ã瀺ãããŠããŠããã®æãç·ã«æ²¿ã£ãŠæãããšã§æé¶Žãšããç«äœã圢ã¥ããã®ã«äŒŒãŠããŸããæ§é åCSVãåãããã«ã1æã®ããŒã¿ã®äžã«æå³ã®é¢ä¿ãä¿ã£ããŸãŸæã£ãŠããããã®é¢ä¿ã¯ãã£ã¡ã³ã·ã§ã³åã«ãã£ãŠç€ºãããŠããŸããå¿ èŠãªãšãã«ã¯ããã®æãç·ã«æ²¿ã£ãŠå±éããããšã§ãä»èš³åž³ãç·åå®å åž³ãšãã£ãäŒèšåž³ç°¿ã®éå±€æ§é ãåçŸã§ããã®ã§ãã
ãããã£ãŠãæ¬è³ªçãªéãã¯ãä¿å圢åŒã®åæããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®è€æ°è¡šã§ã¯ãªããšããç¹ã«ãããŸããLedger Explorer ã«ãããŠããŒã¿ã®åºç€è¡šçŸã¯ããããŸã§æ§é åCSVã§ãã垳簿衚瀺ã®ããã«è¡ã£ãŠããã®ã¯ãé¢é£ããæ å ±ãæçްãžè£ã£ããã衚çŸããããåœ¢ã«æŽãããããäžæçãªèšç®ã«ãããŸããã
æ§é åCSVã¯ãåçŽãªæšªäžŠã³CSVã§ã¯ãªã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã«æ £ãã人ããèŠããšãæ§é åCSVã¯äžèŠãããšãæ£èŠåããŠããªãCSVãã«èŠãããããããŸãããããã Ledger Explorer ãæ±ãæ§é åCSVã¯ãåçŽã«é ç®ã暪䞊ã³ã«ãããã©ãããã¡ã€ã«ã§ã¯ãããŸããã
ãããããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ãããšããã®ã
ä»èš³ããã
ä»èš³æçް
è£å©ç§ç®
éšé
çšåºå
ååŒå
åå®ç§ç®äœç³»
ãšãã£ãè€æ°ã®è«ç衚ããç©ççã«å¥ãã¡ã€ã«ãå¥ããŒãã«ãžåå²ãã代ããã«ã1ã€ã®CSVã®äžã«éå±€æ§é ãšããŠè¡šããŠãããšèããæ¹ãæ£ç¢ºã§ãã
ã€ãŸãéãã¯ããè«çæ§é ãæã€ãæããªãããã§ã¯ãããŸãããéãã¯ããã®è«çæ§é ãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®è€æ°ããŒãã«ãšããŠä¿åããã®ããæ§é åCSVã®éå±€ãšããŠä¿åããã®ãã«ãããŸãã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ã¯ãä¿åæã«è¡šãåããŸãããããŠåž³ç¥šãäœããšãã«ãäž»ããŒãå€éšããŒã䜿ã£ãŠè¡šã察å¿ã¥ããŸãã
äžæ¹ãLedger Explorer ã§ã¯ãä¿åæã«ã¯äŒç¥šã»æçްã»è£å©æ å ±ã®é¢ä¿ãCSVå ã«ä¿ã¡ãŸãããããŠåž³ç¥šãäœããšãã«ãäŒç¥šçªå·ãæçްè¡çªå·ãåã³ãŒããæãããã«ã垳簿衚瀺çšã®è¡šãžå±éããŸãã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ ããã°ã©ãã®èšèã§èšãã°ãLedger Explorer ã®ä»èš³åž³çæã¯ãæ£èŠåããŒãã«ãããã¥ãŒãäœãåŠçã«è¿ããã®ã§ãããã ãããã®ãã¥ãŒã®å ã«ãªã忬ã¯è€æ°ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ ããŒãã«ã§ã¯ãªãã1æã®æ§é åCSVã§ãã
ãæé¶Žã¢ãã«ããšããŠèŠããšåããããã
ç§ã®ããã°èšäºãTidy dataãšXBRL-CSVã®æé¶Žã¢ãã«ãã§ã¯ãTidy data ã xBRL-CSV ããæãããããšå ã®åœ¢ã«åŸ©å ã§ãããšããæ¯å©ã§èª¬æããŸããã
ãã®æ¯å©ã¯ãLedger Explorer ãçè§£ããããã§ãéåžžã«æå¹ã§ãã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®æ£èŠåã¯ãç«äœãéšåããšã«åè§£ããŠãå¥ã ã®ç®±ã«å ¥ããããšã§çµã¿ç«ãŠçŽãæ¹åŒã«è¿ããšèšããŸããããã«å¯ŸããŠæ§é åCSVã¯ãæãçŽã®å±éå³ã®ããã«ã1æã®å¹³é¢ã®äžã«æãç®ãšæå³ã®é¢ä¿ãæ®ããå¿ èŠã«å¿ããŠå¥ã®åœ¢ã«æãæ»ããæ¹åŒã§ãã
Ledger Explorer ã¯ããã®ãæãæ»ãããå®è£ ããŠããããŒã«ã§ããæ§é åCSVãèªã¿èŸŒã¿ãããã«å«ãŸããŠããéå±€é¢ä¿ããã©ã£ãŠãä»èš³åž³ãç·åå®å åž³ã詊ç®è¡šãBS/PL ãšãã£ã衚çŸãžå€æããŠãããŸãã
ãŸãä»èš³åž³ã¯ãã©ãäœãããã®ã
ã§ã¯å®éã«ãæ§é åCSVã«ä¿æãããéå±€æ§é ããLedger Explorer ã®äžã§ã©ã®ããã«åž³ç°¿ãžå±éãããã®ãããä»èš³åž³ããé ã«èŠãŠãããŸãã
ããšãã°ã2021幎4æã®äŒç¥š6ãäŸã«ããŸããæ§é åCSVã®äžã§ã¯ããã®äŒç¥šã¯æŠã次ã®ãããªéå±€ãšããŠè¡šãããŠããŸãã

æ§é åCSV äŒç¥š 6
äŒç¥š 6
æ¥ä»ïŒ2021-04-02
äŒç¥šçªå·ïŒ142
æçް1ïŒé«é代
åæ¹ïŒè»äž¡è²» 2,458å
貞æ¹ïŒçŸéåã³é é 13,384å
æçް2ïŒé§è»ä»£
åæ¹ïŒè»äž¡è²» 591å
æçް3ïŒã¬ãœãªã³ä»£
åæ¹ïŒè»äž¡è²» 4,620å
æçް4ïŒæŽè»åžä»£
åæ¹ïŒè»äž¡è²» 5,715å
åæ¹ã®åèšã¯ã
2,458 + 591 + 4,620 + 5,715 = 13,384
ãšãªãã貞æ¹ã®çŸéåã³é é 13,384åãšäžèŽããŸãã
ããã§æ³šç®ãã¹ãã¯ãæ¥ä»ãäŒç¥šçªå·ã¯äŒç¥šãããè¡ã«äžåºŠã ãæžãããŠãããåæçްè¡ã«ã¯ç¹°ãè¿ãæžãããŠããªãããšã§ãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãªãããããè¡šãšæçŽ°è¡šãããšã§å¯Ÿå¿ã¥ããŠäœ¿ããšããã§ãããLedger Explorer ã§ã¯ããã®éå±€æ§é ãèªãã§ãä»èš³åž³è¡šç€ºçšã«å¿ èŠãªå€ãåæçްãžè£å®ããŸãã
ãã®çµæãä»èš³åž³ãšããŠã¯æ¬¡ã®ãããªåœ¢ã«å±éãããŸãã

ä»èš³åž³ äŒç¥š 6
äŒç¥š6 / æçް1 / 2021-04-02 / 142 / é«é代 / åæ¹ïŒè»äž¡è²» 2,458 / 貞æ¹ïŒçŸéåã³é é 13,384
äŒç¥š6 / æçް2 / 2021-04-02 / 142 / é§è»ä»£ / åæ¹ïŒè»äž¡è²» 591
äŒç¥š6 / æçް3 / 2021-04-02 / 142 / ã¬ãœãªã³ä»£ / åæ¹ïŒè»äž¡è²» 4,620
äŒç¥š6 / æçް4 / 2021-04-02 / 142 / æŽè»åžä»£ / åæ¹ïŒè»äž¡è²» 5,715
ã€ãŸããLedger Explorer ã®ä»èš³åž³çæã¯ããCSVããã®ãŸãŸèŠããŠãããããã§ã¯ãããŸãããæ§é åCSVã®äžã«ããäŒç¥šããããæçްãè£å©æ å ±ãšãã£ãéå±€ãèªã¿åããäŒèšåž³ç°¿ãšããŠèŠããã1æçް1è¡ã®è¡šã«å€æããŠããã®ã§ãã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ããã°ããã®åŠçã¯ããããæ¬¡ã®ãããªå¯Ÿå¿ã¥ããšããŠæžãããŸãã
ä»èš³ãããã `journal_entry`
ä»èš³æçްã `journal_line`
è£å©ç§ç®ã `subaccount`
éšéã `department`
ãšããŠã`entry_id` ãš `line_id` ã§å¯Ÿå¿ã¥ããä»èš³åž³ãã¥ãŒãäœãããšããèšèšã§ãã
Ledger Explorer ã§ãããã£ãŠããããšã®æå³ã¯äŒŒãŠããŸããäŒç¥šãããè¡ããæ¥ä»ãšäŒç¥šçªå·ãåãåºããåãäŒç¥šIDãæã€æçްè¡ãžè£å®ããŸããè£å©ç§ç®ãéšéãå¥è¡ã«ããå Žåã¯ãåã `äŒç¥š + æçްè¡` ãããŒã«ããŠæçŽ°ãžæ»ããŸããéãã®ã¯ããã®å¯Ÿå¿ã¥ãã®å ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®å¥ããŒãã«ã§ã¯ãªããæ§é åCSVå ã®éå±€è¡ã ãšããç¹ã§ãããããã£ãŠãLedger Explorer ã®åŠçã¯ãJOINãäžèŠããšãããããJOINã®ããã«ããŒã¿ãããŒã¿ããŒã¹ãžåè§£ããŠä¿åããªããŠããCSVå ã®æ§é ãã垳簿ãã¥ãŒãåæ§æã§ãããšè¡šçŸããæ¹ãæ£ç¢ºã§ãã
ç·åå®å åž³ã¯ãã©ãäœãããã®ã
次ã«ãç·åå®å åž³ã§ãã
ä»èš³åž³ã¯äŒç¥šããšãæçްããšã«äžŠãã§ããŸãããç·åå®å åž³ã§ã¯ãåå®ç§ç®ããšã«ããã®æã®åããšæ®é«ã远ããããš ãéèŠã«ãªããŸããLedger Explorer ã¯ãæ§é åCSVãã埩å ããä»èš³åž³ã®æçްè¡ãããšã«ããããç·åå®å åž³ã®åœ¢ãžäžŠã¹æ¿ããŠãããŸãã
åºçºç¹ã¯ãä»èš³åž³ãšããŠåŸ©å ãããæçްè¡
ããšãã°ãä»èš³åž³ã«ã¯æ¬¡ã®ãããªæçŽ°ã䞊ãã§ãããšããŸãã
äŒç¥š6 / æçް1
æ¥ä»ïŒ2021-04-02
æèŠïŒé«é代
åæ¹ïŒè»äž¡è²» 2,458å
貞æ¹ïŒçŸéåã³é é 13,384å
äŒç¥š6 / æçް2
æ¥ä»ïŒ2021-04-02
æèŠïŒé§è»ä»£
åæ¹ïŒè»äž¡è²» 591å
äŒç¥š6 / æçް3
æ¥ä»ïŒ2021-04-02
æèŠïŒã¬ãœãªã³ä»£
åæ¹ïŒè»äž¡è²» 4,620å
äŒç¥š6 / æçް4
æ¥ä»ïŒ2021-04-02
æèŠïŒæŽè»åžä»£
åæ¹ïŒè»äž¡è²» 5,715å
ç·åå®å åž³ã§ã¯ãåå®ç§ç®ããšã«èŠçŽã
ããã§ã¯ãäŒç¥šé ã§ã¯ãªããåå®ç§ç®ããšã«ååŒãéãã ããšãè¡ãããŸãã
ããšãã°ãè»äž¡è²»ãã®ç·åå®å åž³ãèŠããšã
2021-04-02 / é«é代 / åæ¹ 2,458å
2021-04-02 / é§è»ä»£ / åæ¹ 591å
2021-04-02 / ã¬ãœãªã³ä»£ / åæ¹ 4,620å
2021-04-02 / æŽè»åžä»£ / åæ¹ 5,715å
ã®ããã«ãåãåå®ç§ç®ã«é¢ä¿ããæçްã ãã䞊ã³ãŸãã
äžæ¹ããçŸéåã³é éãã®ç·åå®å åž³ãèŠããšã
2021-04-02 / é«é代ã»ã / è²žæ¹ 13,384å
ãšãã圢ã§ãå察åŽã®åå®ç§ç®ãšããŠèšé²ãããŸãã
Ledger Explorer ãããŠããããš
ä»èš³åž³ãšããŠåŸ©å ããæçްè¡ãèªã¿åã
åæ¹ãšè²žæ¹ããããããåå®ç§ç®ããšã«æŽçãã
åãåå®ç§ç®ã®ååŒãæç³»åã«äžŠã¹ã
æåæ®é«ããé ã«å æžããŠãæ®é«ãèšç®ãã
ã€ãŸããäœãèµ·ããŠããã®ã
æ§é åCSV â ä»èš³åž³ã埩å ãã
ä»èš³åž³ â åå®ç§ç®ããšã«äžŠã¹æ¿ãã
äžŠã¹æ¿ããçµæ â ç·åå®å åž³ã«ãªã
ã€ãŸããç·åå®å
åž³ã¯å¥ã®å
ããŒã¿ããäœã£ãŠããã®ã§ã¯ãããŸããã
åãæ§é åCSVãã埩å
ããä»èš³åž³ã®æçްããåå®ç§ç®ããšã«èŠçŽããŠäœã£ãŠãã ã®ã§ãã
詊ç®è¡šã¯ãã©ãäœãããã®ã
次ã«ã詊ç®è¡šã§ãã
詊ç®è¡šã§ã¯ãåã ã®æçŽ°ããã®ãŸãŸè¿œãã®ã§ã¯ãªããæããšã»åå®ç§ç®ããšã«åæ¹ãšè²žæ¹ãéèšããææ«æç¹ã®æ®é«ã確èªã§ããããš ãéèŠã«ãªããŸããLedger Explorer ã¯ãæ§é åCSVãã埩å ãã垳簿è¡ãããšã«ããã®éèšãè¡ã£ãŠããŸãã
åºçºç¹ã¯ãç·åå®å åž³ãä»èš³åž³ã®ããšã«ãªã£ã垳簿è¡
ããã§ãå
ã«ãªãã®ã¯ãæ§é åCSVããèªã¿åã£ãäŒèšæçްã§ãã
ããšãã°ãè»äž¡è²»ãã«ã€ããŠã4æäžã«æ¬¡ã®åæ¹èšäžããã£ããšããŸãã
é«é代ïŒ2,458å
é§è»ä»£ïŒ591å
ã¬ãœãªã³ä»£ïŒ4,620å
æŽè»åžä»£ïŒ5,715å
ãã®å Žåã4æã®è»äž¡è²»ã¯ã
åæ¹åèšïŒ13,384å
貞æ¹åèšïŒ0å
ãšããŠéèšãããŸãã
詊ç®è¡šã§ã¯ãæããšã«åèšãã
詊ç®è¡šã§ã¯ãååå®ç§ç®ã«ã€ããŠã
åœæã®åæ¹åèš
åœæã®è²žæ¹åèš
åæããã®ç¹°è¶æ®é«
åœææ«æ®é«
ãæŽçããŸãã
ããšãã°ãè»äž¡è²»ãã§ããã°ã
æåæ®é«ïŒ0å
åœæåæ¹ïŒ13,384å
åœæè²žæ¹ïŒ0å
ææ«æ®é«ïŒ13,384å
ã®ãããªåœ¢ã«ãªããŸãã
ããã§å€§äºãªç¹
æ®é«ã®å¢ãæ¹ã¯ãåå®ç§ç®ã®æ§è³ªã«ãã£ãŠå€ãããŸãã
è³ç£ã»è²»çšïŒåæ¹ãå¢ãã
è² åµã»çŽè³ç£ã»åçïŒè²žæ¹ãå¢ãã
Ledger Explorer ã¯ããã®äŒèšäžã®æ§è³ªã«å¿ããŠãææ«æ®é«ã®èšç®æ¹åãåãæ¿ããŠããŸãã
Ledger Explorer ãããŠããããš
æ§é åCSVãã埩å ãã垳簿è¡ãèªã
æããšãåå®ç§ç®ããšã«åæ¹ã»è²žæ¹ãåèšãã
åææ«æ®é«ãç¿ææåãžç¹°ãè¶ã
åå®ç§ç®ã®æ§è³ªã«å¿ããŠææ«æ®é«ãèšç®ãã
ã€ãŸããäœãèµ·ããŠããã®ã
æ§é åCSV â 垳簿è¡ã埩å ãã
åž³ç°¿è¡ â æããšã»åå®ç§ç®ããšã«éèšãã
éèšçµæ â 詊ç®è¡šã«ãªã
ã€ãŸã詊ç®è¡šããå¥ã®å
¥åãæã£ãŠããã®ã§ã¯ãããŸããã
åãæ§é åCSVãããä»èš³åž³ãç·åå®å
åž³ã«ç¶ããŠãããã«éèšã®åœ¢ãžå±éãããã® ãªã®ã§ãã
ä»èš³åž³ã»ç·åå®å åž³ã»è©Šç®è¡šã®é¢ä¿ããŸãšãããš
æ§é åCSV
äŒç¥šãæçްãè£å©æ å ±ã®é¢ä¿ããéå±€æ§é ãä¿ã£ããŸãŸæã€ä»èš³åž³
æ§é åCSVãèªã¿åãã1æçް1è¡ã®åœ¢ã«å±éããç·åå®å åž³
ä»èš³åž³ã®æçްããåå®ç§ç®ããšã«äžŠã¹æ¿ããŠæ®é«ã远ãã圢ã«ãã詊ç®è¡š
ãã®åž³ç°¿è¡ããæããšã»åå®ç§ç®ããšã«éèšããæ®é«ããŸãšãã
ã€ãŸããLedger Explorer ã¯å¥ã ã®åæ¬ãæã£ãŠããã®ã§ã¯ãªãã1ã€ã®æ§é åCSVããå¿ èŠã«å¿ããŠåž³ç°¿ãéèšè¡šãžæãæ»ããŠãã ã®ã§ãã
貞åå¯Ÿç §è¡šã»æçèšç®æžã¯ãéå±€ãã³ãã¬ãŒãã«æ²¿ã£ãŠç©ã¿äžãã
ããã«ã貞åå¯Ÿç §è¡šãæçèšç®æžã«ãªããšãåå¥æçŽ°ãã財å諞衚ãžã®å€æãå¿ èŠã«ãªããŸããLedger Explorer ã§ã¯ãBS/PLçšã®ãã³ãã¬ãŒããå¥ã«æã¡ãåå®ç§ç®ã³ãŒããéå±€ã¬ãã«ã芪åé¢ä¿ã«æ²¿ã£ãŠãäžäœç§ç®ããäžäœé ç®ãžéé¡ãç©ã¿äžããŠãããŸããã€ãŸããä»èš³åž³ãç·åå®å åž³ãã垳簿ãèŠããæ®µéã ãšããã°ãBS/PLã¯ã垳簿ã財å諞衚ã®åœ¢ã«ç³ã¿çŽããæ®µéã§ãã
ããã§ããåºç€ããŒã¿ã¯æ§é åCSVã§ããä»èš³åž³ãç·åå®å åž³ã詊ç®è¡šãBS/PL ã¯ãããããå¥ã®å ããŒã¿ãæã£ãŠããã®ã§ã¯ãªããåãæ§é åCSVããå°ãããå¥ã ã®è¡šçŸã«ãããŸããã
äŒèšããŒã¿ãæã€2ã€ã®èãæ¹
éããç°¡åã«èšããšãæåããè€æ°ã®è¡šã«åããŠæã€ããæ£èŠåãããè€æ°è¡šã®é¢ä¿ãä¿ã£ããŸãŸ1ã€ã®ããŒã¿ãšããŠæã€ãã§ãã
åŸæ¥ã®ããŒã¿ããŒã¹åãš Ledger Explorer ã®éã
å ã®ããŒã¿
åŸæ¥ã®ããŒã¿ããŒã¹åã§ã¯ãæ å ±ãè€æ°ã®è¡šã«åããŠä¿åããŸãã
ããã«å¯Ÿã㊠Ledger Explorer ã§ã¯ãæå³ã®ã€ãªãããä¿ã£ããŸãŸãæ§é åCSVãšããŠä¿åããŸãã
æ å ±ã©ããã®é¢ä¿
åŸæ¥ã®ããŒã¿ããŒã¹åã§ã¯ãå¿ èŠãªãšãã«å¥ã ã®è¡šã察å¿ã¥ããŠå ã®æå³ããã©ããŸãã
ããã«å¯Ÿã㊠Ledger Explorer ã§ã¯ã1æã®ããŒã¿ã®äžã«ãéå±€ã察å¿é¢ä¿ãä¿ã£ããŸãŸæã¡ãŸãã
èšç®ãéèš
åŸæ¥ã®ããŒã¿ããŒã¹åã§ã¯ãããŒã¿ããŒã¹ã®æ©èœã䜿ã£ãŠèšç®ãéèšãè¡ããŸãã
ããã«å¯Ÿã㊠Ledger Explorer ã§ã¯ãæ§é åCSVã®æ§é ãèªã¿åããªããã垳簿ãéèšè¡šãäœããŸãã
é åžãå ¬é
åŸæ¥ã®ããŒã¿ããŒã¹åã§ã¯ãé åžãå ¬éã«ããŒã¿ããŒã¹ããµãŒãã®ä»çµã¿ãå¿ èŠã§ãã
ããã«å¯Ÿã㊠Ledger Explorer ã§ã¯ãCSVãã¡ã€ã«ãšããŠããã®ãŸãŸæã¡éãã ãå ¬éãããããããšãå¯èœã§ãã
ç£æ»ãéå»ç¢ºèª
åŸæ¥ã®ããŒã¿ããŒã¹åã§ã¯ãåœæã®ç¶æ ãæ£ç¢ºã«æ®ãããã«ãå¥ã®èšé²ã管çãå¿ èŠã§ãã
ããã«å¯Ÿã㊠Ledger Explorer ã§ã¯ãCSVèªäœãããã®æç¹ã®åæ¬ã蚌跡ãšããŠæ±ãããããªããŸãã
åããŠããããš
åŸæ¥ã®ããŒã¿ããŒã¹åã¯ãæ¥ã ã®æŽæ°ãæ€çŽ¢ãå€äººæ°ã§ã®åæå©çšã«åããŠããŸãã
ããã«å¯Ÿã㊠Ledger Explorer ã¯ãé·æä¿åãããŒã¿äº€æãåèšç®ãéçå ¬éãç£æ»å¯Ÿå¿ã«åããŠããŸãã
ããã§å€§åãªã®ã¯ãLedger Explorer ãåŸæ¥ã®ããŒã¿ããŒã¹ãåŠå®ããŠããããã§ã¯ãªãããšããç¹ã§ããæ¥ã ã®æ¥ååŠçããå€äººæ°ã§ã®æŽæ°ã«ã¯ãåŸæ¥ã®ããŒã¿ããŒã¹åã®ããæ¹ãé©ããŠããŸãã
äžæ¹ã§ãç£æ»ã亀æãé·æä¿åãå ¬éãåèšç®ãšãã£ã芳ç¹ã§ã¯ããã®ããŒã¿ã ãã§åœæã®æå³ããã©ããããæ§é åCSVãæå¹ã§ããLedger Explorer ã¯ããã®äŸ¡å€ãå®éã«åã圢ã§ç€ºããŠããŸãã
ãããã£ãŠãäž¡è ã¯ç«¶äºçžæãšãããããç®çã«å¿ããŠäœ¿ãåããã¹ããåŸæåéã®ç°ãªãããŒã¿ã®æã¡æ¹ã ãšèããã®ãèªç¶ã§ãã
Ledger Explorer ã瀺ããŠãããã®
Ledger Explorer ã®æ¬è³ªã¯ãåã«CSVãèªãã§åž³ç¥šã衚瀺ããããŒã«ãšããããšã§ã¯ãããŸããã
ããã¯ãäŒèšããŒã¿ãããŒã¿ããŒã¹ã«éã蟌ããã®ã§ã¯ãªããæ£èŠåãããè€æ°è¡šã®è«çæ§é ãä¿ã£ãæ§é åCSVãšããŠå€ã«åºãããã®CSVãã垳簿ã»è©Šç®è¡šã»BS/PLãåèšç®ã§ããããã«ãã詊ã¿ã§ãã
ãããããã®åºçºç¹ã¯ãè€æ°ã®è¡šãããšãã察å¿ã¥ããŠæå³ã埩å ããããšãã§ã¯ãããŸãããæåããæå³ã®ãŸãšãŸããšéå±€æ§é ãä¿ã£ããŸãŸããããéè€ãå¢ãããã«ã1æã®CSVãšããŠæã€ããããŠå¿ èŠã«å¿ããŠãä»èš³åž³ãç·åå®å åž³ã詊ç®è¡šã貞åå¯Ÿç §è¡šãæçèšç®æžãžæãæ»ãã®ã§ãã
ã€ãŸããLedger Explorer ã瀺ããŠããã®ã¯ãCSVã䜿ã£ã垳祚衚瀺ã®å·¥å€«ã§ã¯ãããŸãããäŒèšããŒã¿ã®åæ¬ããå°æ¥ã«ããã£ãŠæå³ã倱ãããåèšç®å¯èœãªåœ¢ã§ä¿æããããã®ãæ°ããæã¡æ¹ã§ãã
ãã®èãæ¹ã¯ãä»åŸã®äŒèšããŒã¿ã®ä¿åã亀æãç£æ»ãAI掻çšãèããããã§ãéåžžã«éèŠãªç€ºåãæã£ãŠãããšæããŸãã
ãã®é£èŒã«ã€ããŠ
第1åããªãä»ãæ§é åCSVãå¿
èŠãªã®ã
https://note.com/pont_soleil/n/n851330bcc027
é»å垳簿ä¿åæ³ãšAIæä»£ãæ±ããæšæºããŒã¿åœ¢åŒ
é»å垳簿ä¿åæ³ãžã®å¯Ÿå¿ããœããæŽæ°åŸã®éå»ããŒã¿ç¢ºèªããããŠAIã«ãã倧éããŒã¿åŠçãèžãŸãããªããæå³ãä¿ã£ããŸãŸä¿åã»äº€æã»åå©çšã§ããããŒã¿åœ¢åŒããå¿
èŠãªã®ããæŽçããŸãã
第2åãæ§é åCSVãšã¯äœã
https://note.com/pont_soleil/n/n308fd640cdd2
1æã®CSVã§éå±€æ§é ã衚ãèãæ¹
éåžžã®CSVããããããŒè¡šã»æçŽ°è¡šã»çšè¡šã«åãããæ£èŠåCSVãšäœãéãã®ããæŽçããæ§é åCSVã®åºæ¬çãªèãæ¹ãå
·äœäŸã§èª¬æããŸãã
第2å è¿œå æ
å ±ãOpenAI ã®å€§èŠæš¡èšèªã¢ãã«ãåºç€ãšããã³ãŒãã£ã³ã°ã»ããŒã¿åææ¯æŽãšãŒãžã§ã³ã Codex ã«ããä»èš³ããŒã¿æ€æ»
https://note.com/pont_soleil/n/n63699199aeb5
æ§é åCSVã§æŽçããä»èš³ããŒã¿ããOpenAI ã® Codex ãã©ã®çšåºŠèªã¿åããæ€æ»ãåæã«æŽ»çšã§ãããã詊ããèšäºã§ããAIæä»£ã«ãããæ§é åCSVã®å®çšæ§ãè£è¶³çã«ç€ºããŸãã
第3åãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšããŠã®æ§é åCSV
https://note.com/pont_soleil/n/n77810ca32953
æ¢åEDIãšããã«ã®æ©æž¡ã
æ§é åCSVããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšããŠäœçœ®ã¥ããæ¢åEDIãæ¥çEDIãERPãäŒèšãããã«/JP PINT ãã€ãªãå
±éããŒã¿åœ¢åŒãšããŠèããŸãã
第4åãæ§æçµå衚ã§å€æãå€åºããã
https://note.com/pont_soleil/n/nf39f0cf81df7
æå³ã®å¯Ÿå¿é¢ä¿ãšæ§æã®å¯Ÿå¿é¢ä¿ãåããŠå®çŸ©ããèãæ¹
ããŒã¿é
ç®ã®æå³ãšãXMLãCSVãªã©å奿§æãžã®å¯Ÿå¿ãåããŠå®çŸ©ããããšã§ã倿ãããã°ã©ã ã«åã蟌ãŸããæè»ã«ç®¡çããæ¹æ³ã説æããŸãã
第5åãæ§æçµå衚ã§å®çŸããæ§é åCSVãš JP PINT UBL ã®çžäºå€æïŒPythonïŒ
https://note.com/pont_soleil/n/ndca04f96d1fc
æ§é åCSVãæ§æçµå衚ãPythonããã°ã©ã ãçšããŠãæ§é åCSVãš JP PINT UBL ã®çžäºå€æãè¡ãå
·äœäŸã玹ä»ããŸãã
第6åãæ§é åCSVã¯äœãå€ããã®ã
https://note.com/pont_soleil/n/n1c00252ce0cb
ä¿åã亀æãç£æ»ãAI掻çšãã€ãªãåºç€ãžæ§é åCSVããåãªã亀æåœ¢åŒã§ã¯ãªããé·æä¿åãæ¥å飿ºãç£æ»ãåæãAI掻çšãæ¯ããå
±éåºç€ã«ãªãåŸãããšãæŽçããŸãã
第7åãXBRL GL ãš XBRL GL Next
https://note.com/pont_soleil/n/na110d4600fa8
æ§é åCSVãæ¯ããåœéæšæºã®æµã
XBRL GL ãæ
ã£ãŠãã圹å²ãšãxBRL-CSV ãæ¡çšãã XBRL GL Next ã®æ€èšç¶æ³ãéããŠãæ§é åCSVã®åœéçãªäœçœ®ã¥ãã瀺ããŸãã