
第3å æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšããŠã®æ§é åCSVïŒæ¢åEDIãšããã«ã®æ©æž¡ãïŒ
1 åé¡æèµ·ïŒãªãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãå¿ èŠã
1.1 ãã®èšäºã®äž»åŒµ
æ¥æ¬åœå ã«ã¯ãæµéBMSãäžå°äŒæ¥å ±éEDIãæ¥çEDIãWeb-EDIã賌買ãã©ãããã©ãŒã ãERPã販売管çãäŒèšãªã©ãå€ãã®é»åååŒã®ä»çµã¿ããããŸãããããã¯ãããããã®æ¥çãååŒæ £è¡ã«åãããŠçºå±ããŠããŸãããããããå®åäžã®å€§ããªèª²é¡ã¯ãåã«ãæšæºãã©ãŒãããããããã©ãããã§ã¯ãããŸããã
æ¬åœã«éèŠãªã®ã¯ã次ã®ç¹ã§ãã
ã©ããäžã€ã®ãããã€ãã«ã€ãªãã£ãŠããã°ã åœå ã®ã©ã®ãããã€ãã®å©çšè ãšãã ããã«äžçäžã®ããã«å©çšè ãšãã ã¡ãã»ãŒãžäº€æã§ããããã«ããããšã
ãã®äžçãå®çŸããéµã¯ãäºã€ãããŸãã
é éã»å°éæ§ã®å ±éå
ââ ããã«ã®4ã³ãŒããŒã¢ãã«ã䜿ãåœå EDIã»æ¥åã·ã¹ãã éã®æå³å€æã®å ±éå
ââ æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒã䜿ã
ããã«ã¯ãçžæã® ISO 6523 ã«åºã¥ã Participant IDãããªãã¡ããã«IDãåããã°ãçžæãã©ã®ã¢ã¯ã»ã¹ãã€ã³ãåã¯ãããã€ãã䜿ã£ãŠããããçºèŠããã¡ãã»ãŒãžãå±ããããšãã§ãããããã¯ãŒã¯ã§ãã
äžæ¹ãæ¥æ¬åœå ã®æ¢åEDIã§ã¯ããããã€ããçºè¡ããç¬èªIDã䜿ã3ã³ãŒããŒã¢ãã«ãå€ã䜿ãããŠããŸããããã®ãããç°ãªããããã€ãéã§é£æºããå Žåã«ã¯ãçžæå ãããã€ãåŽã®IDãšã®å¯Ÿå¿ããã¡ã€ã«åœ¢åŒã®å€æãéä¿¡æ¡ä»¶ã®èª¿æŽãªã©ããåå¥ã«è¡ãå¿ èŠããããŸãããã®ãåå¥å¯Ÿå¿ããåçžæå ããšã«ç¶ãããšãæ¥ç¶å ãå¢ããã»ã©ç¶æç®¡çãèšãã¿ãŸãã
ããã°ã3ã³ãŒããŒã¢ãã«ã«ãçžæå ããšã®ã+1ããè¶³ãç¶ããæ§é ã§ãã

ãã®ã+1ããçžæå ããšããããã€ãããšãæ¥çEDIããšã«äœãç¶ãããšãå®åäžã¯ n+â ã®ããã«èŠããç¶æç®¡çè² æ ã«ãªããŸãã
ããã§ã+1 ã®å¯Ÿå¿å ããçžæããšã®åå¥ä»æ§ã§ã¯ãªããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã«åºå®ããŸããããã«ãããæ¢åã®åœå EDIãæ¥çEDIãERPã販売管çãäŒèšãJP PINTããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãä»ããŠæ¥ç¶ã§ããŸãããããŠããããã€ããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšããã«IDãšã®å¯Ÿå¿ãæäŸããã°ãåœå ã®ç°ãªãEDIéã§ããããã«åã®å°éæ§ãå©çšããçžäºæ¥ç¶ãå¯èœã«ãªããŸãã
ãããããã®èšäºã®äž»åŒµã§ãã
1.2 åŒçšã»åç §å
æ¬çš¿ã¯ã次ã®2æ¬ã®èšäºãåæã«ããŠããŸãã
åç §èšäº 1
äžåäžæè¡å£«äºåæ
ãããã«æä»£ã®åœå
æ¢åEDI飿ºã𿥿¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒã
ãã®èšäºã§ã¯ãããã«ãåœå
å€ã®ååŒå
ãžææžãå±ããçžäºæ¥ç¶ãããã¯ãŒã¯ãšããŠäœçœ®ã¥ããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒããJP PINTãæ¢åEDIãWeb-EDIãERPãäŒèšã販売管çãã€ãªãåæéèš³ã¢ãã«ãšããŠæŽçããŸããã
åç §èšäº 2
äžåäžæè¡å£«äºåæ
ãæ§æçµå衚CSVã§ã€ããæ§é åCSVãšJP PINTã®çžäºå€æããã°ã©ã ã
ãã®èšäºã§ã¯ãæ§é åCSVãšJP PINT UBL XMLããSemanticPath ãš XPath ã®æ§æçµå衚ã«åºã¥ããŠçžäºå€æããPythonããã°ã©ã ã玹ä»ããŸããã
ããŠã³ããŒããã¡ã€ã«
ãµã³ãã«ããã°ã©ã äžåŒã¯ã次ã®ZIPãã¡ã€ã«ã§ããsyntax_binding_revised_package.zip
ZIPãã¡ã€ã«ã«ã¯ã次ã®3ãã¡ã€ã«ãå«ãŸããŸãã
*ã invoice.csv
ããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãè¡šãæ§é åCSV
*ã bindings.csv
ããæ§é åCSVåŽã® SemanticPath ãš JP PINT UBLåŽã® XPath ã察å¿ä»ããæ§æçµå衚
*ã syntax_binding.py
ããæ§é åCSVãšæ§æçµå衚CSVãèªã¿èŸŒã¿ã JP PINT UBL XMLãçæãã ããã«XMLããæ§é åCSVãžæ»ããµã³ãã«ããã°ã©ã
1.3 ããã«ã¯ãäžçãšã€ãªãã4ã³ãŒããŒãããã¯ãŒã¯ã§ãã
ããã«ã®ç¹åŸŽã¯ã4ã³ãŒããŒã¢ãã«ã§ãã

éä¿¡è ãšåä¿¡è ããããããèªåã®ã¢ã¯ã»ã¹ãã€ã³ããéžã³ãã¢ã¯ã»ã¹ãã€ã³ãéãæšæºçã«çžäºæ¥ç¶ãããŸãã
ãã®ã¢ãã«ã§ã¯ãéä¿¡è ã¯ãåä¿¡è ãã©ã®ã¢ã¯ã»ã¹ãã€ã³ãã䜿ã£ãŠããããåå¥ã«æèããå¿ èŠããããŸãããåä¿¡è ã®ããã«IDãããªãã¡ISO 6523ã«åºã¥ãParticipant IDåã¯JP PINTã§äœ¿ãããEndpointIDçã«å¯Ÿå¿ããèå¥åãåããã°ãå®å ãçºèŠããçžæã®ã¢ã¯ã»ã¹ãã€ã³ããžã¡ãã»ãŒãžãå±ããããšãã§ããŸããããããããã«ã®æ¬è³ªçãªåŒ·ã¿ã§ãã
ããã«ã§éèŠãªããš
éä¿¡è ã¯èªåã®ã¢ã¯ã»ã¹ãã€ã³ããéžã¹ã
åä¿¡è ãèªåã®ã¢ã¯ã»ã¹ãã€ã³ããéžã¹ã
ã¢ã¯ã»ã¹ãã€ã³ãéã¯æšæºçã«çžäºæ¥ç¶ããã
å®å ã¯ããã«IDã«ãã解決ããã
æè¡çéä¿¡è ã§ã¯ãªããæ¥åäžã®éä¿¡è ã»åä¿¡è ãèå¥ãã
ãããã£ãŠãããã«ã¯åãªãXMLéä¿¡ææ®µã§ã¯ãããŸãããæ¥æ¬å šåœãå§ããšããŠãå šäžçã®ååŒå ãšã€ãªããããã®çžäºæ¥ç¶ãããã¯ãŒã¯ã§ãã
1.4 åœå æ¢åEDIã®å€ãã¯ã3ã³ãŒããŒã¢ãã«ãåæãšããŠãã
ããã«å¯ŸããŠãæ¥æ¬åœå
ã®æ¢åEDIã§ã¯ããããã€ããå©çšè
IDãçºè¡ãããã®ãããã€ãã®ãµãŒãã¹å
ã§ååŒå
ãšæ¥ç¶ããã¢ãã«ãå€ãèŠãããŸãã

ãã®ã¢ãã«ã§ã¯ãåããããã€ãã®äžã§ååŒãå®çµããå Žåã«ã¯å€§ããªåé¡ã¯ãããŸããã
ããããçžæå
ãå¥ã®ãããã€ãã䜿ã£ãŠããå Žåã«ã¯ã次ã®ãããªåé¡ãçºçããŸãã
ãããã€ãXã®å©çšè
A
ããâ
ããâŒ
ãããã€ãX
ããâ
ããâ å奿¥ç¶
ããâ åå¥ID察å¿
ããâ åå¥ãã¡ã€ã«å€æ
ããâ åå¥éçšèª¿æŽ
ããâŒ
ãããã€ãY
ããâ
ããâŒ
ãããã€ãYã®å©çšè
B
äžèŠãããšããããã€ã鿥ç¶ãããããã«èŠããŸãããããå®éã«ã¯ããããã€ãXãšãããã€ãYã®éã§ã次ã®ãããªåå¥å¯Ÿå¿ãå¿ èŠã«ãªããŸãã
3+1ã§çºçããåå¥å¯Ÿå¿
çžæå ãããã€ããçºè¡ããå©çšè IDãšã®å¯Ÿå¿
èªç€Ÿãããã€ãå ã®å©çšè IDãšã®å¯Ÿå¿
çžæå EDIã®ãã¡ã€ã«åœ¢åŒãžã®å€æ
ã³ãŒãäœç³»ã®å€æ
éä¿¡æ¹åŒã»éçšã«ãŒã«ã®èª¿æŽ
ãšã©ãŒåŠçã»åéã»åæ¶ã»èšæ£ã®åãæ±ºã
ããã¯ã20äžçŽã®BBSåãããã¯ãŒã¯ã«è¿ãæ§é ã§ããããããã®BBSã®å éšã§ã¯å©çšã§ããŸãããé£ã®BBSãžã¡ãã»ãŒãžãå±ããã«ã¯ãåå¥ã®ã²ãŒããŠã§ã€ãå¿ èŠã«ãªããŸãã
åœå EDIã§åãããšãç¶ãããšãæšæºãã©ãŒãããããã£ãŠããååŒå ããšã®æ¥ç¶è² æ ã¯æ®ããŸãã
1.5 3+1ãçžæããšã«ç¶ãããšãn+âã«ãªã
åé¡ã¯ã3+1ã¢ãã«ãã®ãã®ãäžã€ããããšã§ã¯ãããŸããã
åé¡ã¯ããã®ã+1ããçžæããšã«äœãç¶ããããšã§ãã
å³1ã¯ãäžå°äŒæ¥å ±éEDIã¢ã¯ã»ã¹ãã€ã³ããå©çšããéä¿¡è CããJP PINTãäžå°äŒæ¥å ±éEDIãæµéBMSãæ¥çEDIãERPïŒäŒèšïŒè²©å£²ç®¡çãªã©ãç°ãªãæ¥ç¶å ãžã¡ãã»ãŒãžãéãå Žåã瀺ããŠããŸãã

éä¿¡è
C
ãâ
äžå°äŒæ¥å
±éEDIã¢ã¯ã»ã¹ãã€ã³ã
ãããã€ããŒS
ãâ
æ¥ç¶å
ããšã®éä¿¡å€æã»åä¿¡å€æ
ãâ
JP PINTã¢ã¯ã»ã¹ãã€ã³ã
äžå°äŒæ¥å
±éEDIã¢ã¯ã»ã¹ãã€ã³ã
æµéBMSã¢ã¯ã»ã¹ãã€ã³ã
æ¥çEDIã¢ã¯ã»ã¹ãã€ã³ã
ERPïŒäŒèšïŒè²©å£²ç®¡ç
ãã®å³ã§ã¯ãéä¿¡è CããèŠããšãæ¥ç¶å ããšã«æ¬¡ã®ãããªåå¥å€æãå¿ èŠã«ãªããŸãã
éä¿¡å€æ C-A â åä¿¡å€æ C-A
éä¿¡å€æ C-D â åä¿¡å€æ C-D
éä¿¡å€æ C-E â åä¿¡å€æ C-E
éä¿¡å€æ C-F â åä¿¡å€æ C-F
ã€ãŸããéä¿¡è Cãäžå°äŒæ¥å ±éEDIã¢ã¯ã»ã¹ãã€ã³ãã«ã€ãªãã£ãŠããŠããçžæå ãJP PINTãæµéBMSãæ¥çEDIãERPïŒäŒèšïŒè²©å£²ç®¡çãªã©ç°ãªãæ¹åŒã䜿ã£ãŠããå Žåã«ã¯ãçžæå ããšã«å€æä»æ§ãçšæããå¿ èŠããããŸãã
åãããšã¯ãåä¿¡åŽã§ãçºçããŸãã
å³2ã¯ãåä¿¡è Cãäžå°äŒæ¥å ±éEDIã¢ã¯ã»ã¹ãã€ã³ããå©çšããŠããå Žåã«ãJP PINTãæµéBMSãæ¥çEDIãERPïŒäŒèšïŒè²©å£²ç®¡çãªã©ãç°ãªãéä¿¡å ããã¡ãã»ãŒãžãåãåãå Žåã瀺ããŠããŸãã

JP PINTã¢ã¯ã»ã¹ãã€ã³ã
æµéBMSã¢ã¯ã»ã¹ãã€ã³ã
æ¥çEDIã¢ã¯ã»ã¹ãã€ã³ã
ERPïŒäŒèšïŒè²©å£²ç®¡ç
ãâ
éä¿¡å
ããšã®éä¿¡å€æã»åä¿¡å€æ
ãâ
äžå°äŒæ¥å
±éEDIã¢ã¯ã»ã¹ãã€ã³ã
ãããã€ããŒS
ãâ
åä¿¡è
C
ãã®å³ã§ã¯ãåä¿¡è CããèŠããšãéä¿¡å ããšã«æ¬¡ã®ãããªåå¥å€æãå¿ èŠã«ãªããŸãã
éä¿¡å€æ A-C â åä¿¡å€æ A-C
éä¿¡å€æ D-C â åä¿¡å€æ D-C
éä¿¡å€æ E-C â åä¿¡å€æ E-C
éä¿¡å€æ F-C â åä¿¡å€æ F-C
...
ãã®ããã«ãéä¿¡åŽã§ãåä¿¡åŽã§ããçžæå åã¯éä¿¡å ããšã«åå¥å€æãäœãç¶ããæ§é ã«ãªããŸããæ¥ç¶å ãå¢ãããã³ã«ã次ã®ç¶æç®¡çãçºçããŸãã
çžæå ããšã®ç¶æç®¡ç
ID察å¿è¡š
ãã¡ã€ã«å€æä»æ§
ã³ãŒã察å¿è¡š
æ¥åã«ãŒã«
ãšã©ãŒåŠç
ãã¹ãããŒã¿
ããŒãžã§ã³æ¹èšå¯Ÿå¿
åãåãã察å¿
ãããã£ãŠãå®åæèŠãšããŠã¯ãåãªã n 察å¿ã§ã¯ãããŸããã
çžæå ãå¢ãããã³ã«ã倿仿§ãID察å¿ãã³ãŒã察å¿ãæ€èšŒãéçšèª¿æŽãããŒãžã§ã³æ¹èšãç©ã¿äžãã£ãŠãããããn+â ã«è¿ãç¶æç®¡çè² æ ã«ãªããŸãã
2 解決ã¢ãã«ïŒ+1 ã®æ¥ç¶å ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã«ãã
2.1 +1 ã®æ¥ç¶å ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã«ãã
ããã§ãåœç¶ã次ã®ãããªææãèããããŸãã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã«å¯Ÿå¿ããå Žåã§ãã
æåã«åEDIãåERPãåäŒèšãœãããšã®å¯Ÿå¿ãå¿
èŠã«ãªãã®ã§ã¯ãªããã
ãã®ææã«å¯Ÿããçãã¯ã次ã®ãšããã§ãã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹æ¹åŒã§ããäœãããªããŠããããã§ã¯ãããŸããã
ããããçžæå ããšã«åå¥å¯Ÿå¿ããã®ã§ã¯ãªããåæ¹åŒãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã«å¯Ÿã㊠+1 察å¿ããã°æžã¿ãŸãã
ã€ãŸããåãããã€ããŒåã¯åæ¥åã·ã¹ãã ã¯ãèªåã®åœ¢åŒã𿥿¬çã³ã¢ã€ã³ãã€ã¹ãšã®å¯Ÿå¿ãäžã€å®çŸ©ããŸãã
äžå°äŒæ¥å
±éEDI â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
æµéBMS â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
æ¥çEDI â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
ERP â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
äŒèšãœãã â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
JP PINT UBL â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
ããã¯ãçžæå ããšã® +n 察å¿ã§ã¯ãããŸãããåæ¹åŒããèŠãã°ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãžã® +1 察å¿ã§ãã
å³3ã¯ããã®èãæ¹ã瀺ããŠããŸãã

éä¿¡åŽã®åæ¹åŒ
ãâ
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒ
ãâ
åä¿¡åŽã®æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒ
ãâ
åä¿¡åŽã®åæ¹åŒ
ãã®æ§æã§ã¯ãéä¿¡è AãCãDãEãFããããããç°ãªãæ¹åŒã䜿ã£ãŠããŠãããŸãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãžå€æããŸããåä¿¡åŽã§ããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãããåä¿¡è AãCãDãEãFãå©çšããæ¹åŒãžå€æããŸãã
éä¿¡åŽ
ãåæ¹åŒ â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
åä¿¡åŽ
ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ â åæ¹åŒ
ãã®ãšããåæ¹åŒã¯ãä»ã®ãã¹ãŠã®æ¹åŒãçŽæ¥ç¥ãå¿ èŠããããŸããã
æµéBMSãäžå°äŒæ¥å ±éEDIãæ¥çEDIãERPãäŒèšãœãããJP PINTã®ãã¹ãŠã«åå¥å¯Ÿå¿ããå¿ èŠã¯ãããŸãããæµéBMSã¯ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšã®å¯Ÿå¿ãå®çŸ©ããã°ããã®ã§ãã
åæ§ã«ãäžå°äŒæ¥å ±éEDIããæ¥çEDIããERPããäŒèšãœããããJP PINTããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšã®å¯Ÿå¿ãå®çŸ©ããŸãã
ããã«ãããçžäºæ¥ç¶ã®æ§é ã¯æ¬¡ã®ããã«å€ãããŸãã
åŸæ¥åã®çžæå å¥å¯Ÿå¿
A â B
A â C
A â D
A â E
B â C
B â D
B â E
C â D
C â E
...
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹æ¹åŒ
A â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
B â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
C â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
D â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
E â æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
...
ããã§éèŠãªã®ã¯ãåã«åæå¯Ÿå¿ã®æ°ãæžãããšã ãã§ã¯ãããŸããããã倧ããªã¡ãªããã¯ãéä¿¡å åã¯éä¿¡å ã®ä»æ§ã倿Žããããšãã®å¯Ÿå¿æ¹æ³ãå€ããããšã§ãã
åŸæ¥åã§ã¯ãçžæå ããšã®åå¥å€æããã°ã©ã ãä¿®æ£ããå¿ èŠããããŸãã
åŸæ¥å
çžæå
仿§å€æŽ
ãâ
åå¥å€æããã°ã©ã ãä¿®æ£
ãâ
çžæå
ããšã«ãã¹ã
ãâ
çžæå
ããšã«ãªãªãŒã¹
ãâ
çžæå
ããšã«éçšç¢ºèª
ããã«å¯ŸããŠãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹æ¹åŒã§ã¯ãéä¿¡å åã¯éä¿¡å ã®ä»æ§å€æŽããã§ããã ãæ§æçµå衚ã®å€æŽãšããŠæ±ããŸãã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹æ¹åŒ
éä¿¡å
åã¯éä¿¡å
ã®ä»æ§å€æŽ
ãâ
æ§æçµå衚ãå·®ãæ¿ãã
ãâ
æ±çšå€æããã°ã©ã ã§åŠçãã
ãâ
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã«åºã¥ããŠæ€èšŒãã
ããšãã°ãJP PINT UBLãšã®å¯Ÿå¿ã§ã¯ãæ§é åCSVåŽã® SemanticPath ãšãUBL XMLåŽã® XPath ãæ§æçµå衚ã§å¯Ÿå¿ä»ããŸãã
æ§é åCSVåŽ
$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyName
JP PINT UBLåŽ
/Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name
ãã®å¯Ÿå¿ãããã°ã©ã æ¬äœã«åã蟌ãã®ã§ã¯ãªããæ§æçµå衚ãšããŠå€éšåããŸãã
ãã®ãããéä¿¡å åã¯éä¿¡å ã®ä»æ§å€æŽããã£ãå Žåã§ããæå³æ§é ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã®ç¯å²ã§åžåã§ããéããããã°ã©ã æ¬äœãä¿®æ£ããã«ãæ§æçµå衚ã®å·®ãæ¿ãåã¯æ¹èšã§å¯Ÿå¿ã§ããŸãã
åŸæ¥å
ã倿仿§ãããã°ã©ã ã«åã蟌ã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹æ¹åŒ
ã倿仿§ãæ§æçµå衚ãšããŠå€éšå®çŸ©ãã
ãã¡ãããæ°ããç¹°è¿ãæ§é ãæ°ããæ¥åæèãæ°ããæ€èšŒèŠåã远å ãããå Žåã«ã¯ãå ±é倿åŠçåŽã®æ¡åŒµãå¿ èŠã«ãªãããšããããŸãã
ããããé ç®å¯Ÿå¿ãXPath倿ŽãCSVåå倿Žãã³ãŒã察å¿ãID察å¿ã®ãããªå€ãã®å€æŽã¯ãããã°ã©ã ä¿®æ£ã§ã¯ãªããæ§æçµå衚ãã³ãŒã察å¿è¡šãID察å¿è¡šã®å·®ãæ¿ãã§å¯Ÿå¿ã§ããããã«ãªããŸãã
ãã®éããæ±ºå®çã§ãã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹æ¹åŒã§ã¯ãçžæå ããšã« +n ã®åå¥å€æãäœãç¶ããã®ã§ã¯ãããŸããã
åæ¹åŒãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã« +1 察å¿ããŸãã
ãããŠããã® +1 察å¿ãæ§æçµå衚ãšããŠå€éšåããããšã§ã仿§å€æŽæã®ç¶æç®¡çããåå¥ããã°ã©ã æ¹ä¿®ããå®çŸ©è¡šã®å·®ãæ¿ããžç§»ãããšãã§ããŸãã
ãã®æ§é ãå®çŸããå ±éã®æå³ã¢ãã«ããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã§ãã
2.2 æ§é åCSVã¯ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã®å®è£ 圢åŒã§ãã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã¯ãåãªãCSVãã¡ã€ã«ã§ã¯ãããŸãããè«æ±æžãšããŠã®æå³æ§é ãæã€å ±éè«çã¢ãã«ã§ãããã®æšæºå®è£ 圢åŒãšããŠãæ§é åCSVã䜿ããŸãã
è«æ±æžã«ã¯ã次ã®ãããªéå±€ããããŸãã
è«æ±æž
ââ è«æ±æžããããŒ
ââ 売æ
ââ è²·æ
ââ åç
§ææž
ââ æ¯ææ
å ±
ââ çšçå¥å
èš³
ââ è«æ±æçް
éåžžã®æ£èŠåããŒã¿ããŒã¹ã§ã¯ãããããè€æ°ã®è¡šã«åããŸãã
invoice.csv
party.csv
document_reference.csv
payment.csv
tax_breakdown.csv
invoice_line.csv
ããããæ§é åCSVã§ã¯ããããã1æã®CSVã«æ ŒçŽããŸãã
è«æ±æž
ãââ 売æ
ãââ è²·æ
ãââ çšçå¥å
èš³
ãââ æ¯ææ
å ±
ãââ åç
§ææž
ãââ è«æ±æçް
ãããââ åç®
ãããââ æ°éã»å䟡ã»éé¡
ãããââ æçŽ°çšæ
å ±
ãã®ãšãã`dInvoiceParty`ã`dDocumentReference`ã`dPayment`ã`dTaxBreakdown`ã`dInvoiceLine` ãªã©ã®ãã£ã¡ã³ã·ã§ã³åã«ããããã®è¡ãã©ã®éå±€åã¯ç¹°è¿ãæ§é ã«å±ãããã瀺ããŸãã
ããã«ãããXMLã®éå±€æ§é ãä¿ã¡ãªãããExcelãCSVåŠçã§æ±ãã1æã®è¡šãšããŠè¡šçŸã§ããŸãã
3 å®è£ äŸïŒãµã³ãã«ããã°ã©ã ã§æ§é åCSVã確èªãã
3.1 äŸé¡ããŒã¿
ããããã¯ãå®éã®ãµã³ãã«ããã°ã©ã ã§äœ¿ã `invoice.csv` ãèŠãŸãã
dInvoice,dInvoiceParty,dDocumentReference,dPayment,dTaxBreakdown,dInvoiceLine,invoiceNumber,issueDate,invoiceTypeCode,currencyCode,totalAmount,partyRole,partyName,partyTaxID,referenceType,referenceID,paymentDueDate,paymentMeansCode,paymentReference,taxCategoryCode,taxRate,taxableAmount,taxAmount,lineID,itemName,lineTaxCategoryCode,lineTaxRate,invoicedQuantity,unitCode,unitPriceAmount,lineExtensionAmount
1,,,,,,INV-26-861,2026-06-20,380,JPY,16802,,,,,,,,,,,,,,,,,,,,
1,1,,,,,,,,,,Seller,å£²ææ ªåŒäŒç€Ÿ,T1234567890123,,,,,,,,,,,,,,,,,
1,2,,,,,,,,,,Buyer,è²·ææ ªåŒäŒç€Ÿ,,,,,,,,,,,,,,,,,,
1,,1,,,,,,,,,,,,Order,PO-2026-0001,,,,,,,,,,,,,,,
1,,2,,,,,,,,,,,,Delivery,DN-2026-0001,,,,,,,,,,,,,,,
1,,,1,,,,,,,,,,,,,2026-07-31,30,INV-2026-0001,,,,,,,,,,,,
1,,,,1,,,,,,,,,,,,,,,S,10,12320,1232,,,,,,,,
1,,,,1,,,,,,,,,,,,,,,AA,8,3010,240,,,,,,,,
1,,,,,1,,,,,,,,,,,,,,,,,,INV-26-861-1,ååA,S,10,10,EA,1000,10000
1,,,,,2,,,,,,,,,,,,,,,,,,INV-26-861-2,ååB,S,10,4,EA,580,2320
1,,,,,3,,,,,,,,,,,,,,,,,,INV-26-861-3,é£åC,AA,8,7,EA,430,3010ãã®CSVã«ã¯ãæ¬¡ã®æ å ±ã1æã®CSVã«å ¥ã£ãŠããŸãã
è«æ±æžããããŒ
è«æ±æžçªå·: INV-26-861
çºè¡æ¥: 2026-06-20
ææžçš®å¥ã³ãŒã: 380
é貚: JPY
åèšéé¡: 16802
売æ
partyRole: Seller
partyName: å£²ææ ªåŒäŒç€Ÿ
partyTaxID: T1234567890123
è²·æ
partyRole: Buyer
partyName: è²·ææ ªåŒäŒç€Ÿ
åç
§ææž
Order: PO-2026-0001
Delivery: DN-2026-0001
æ¯ææ
å ±
paymentDueDate: 2026-07-31
paymentMeansCode: 30
paymentReference: INV-2026-0001
çšçå¥å
èš³
S 10% 課çšå¯Ÿè±¡é¡ 12320 çšé¡ 1232
AA 8% 課çšå¯Ÿè±¡é¡ 3010 çšé¡ 240
è«æ±æçް
INV-26-861-1 ååA S 10% 10 EA å䟡1000 éé¡10000
INV-26-861-2 ååB S 10% 4 EA å䟡580 éé¡2320
INV-26-861-3 é£åC AA 8% 7 EA å䟡430 éé¡3010ããã§éèŠãªã®ã¯ãããããŒãåœäºè ãåç §ææžãæ¯ææ å ±ãçšçå¥å èš³ãæçްãããã¹ãŠ1æã®CSVã«ããããšã§ãã
è€æ°ã®CSVãJOINããå¿ èŠã¯ãããŸããã
3.2 è¡ã®æå³ã¯ããã£ã¡ã³ã·ã§ã³åã§å€å®ã§ãã
ãã®CSVã§ã¯ãåè¡ã®æå³ã¯ãã£ã¡ã³ã·ã§ã³åã§å€å®ã§ããŸãã
dInvoiceParty ãå
¥ã£ãŠããè¡
ãââ 売æåã¯è²·æãªã©ã®åœäºè
è¡
dDocumentReference ãå
¥ã£ãŠããè¡
ãââ æ³šææžçªå·åã¯çŽåæžçªå·ãªã©ã®åç
§ææžè¡
dPayment ãå
¥ã£ãŠããè¡
ãââ æ¯ææ¡ä»¶è¡
dTaxBreakdown ãå
¥ã£ãŠããè¡
ãââ çšçå¥å
èš³è¡
dInvoiceLine ãå
¥ã£ãŠããè¡
ãââ è«æ±æçްè¡
ããšãã°ã売æè¡ã¯æ¬¡ã®è¡ã§ãã
1,1,,,,,,,,,,Seller,å£²ææ ªåŒäŒç€Ÿ,T1234567890123,,,,,,,,,,,,,,,,,ãã®è¡ã§ã¯ã`dInvoiceParty` ã« `1` ãå ¥ãã`partyRole` ã« `Seller` ãå ¥ã£ãŠããŸãããããã£ãŠããã®è¡ã¯ãè«æ±æžåœäºè ã®ãã¡ã売æã衚ãè¡ããšè§£éã§ããŸãã
è²·æè¡ã¯æ¬¡ã®è¡ã§ãã
1,2,,,,,,,,,,Buyer,è²·ææ ªåŒäŒç€Ÿ,,,,,,,,,,,,,,,,,,ãã®è¡ã§ã¯ã`dInvoiceParty` ã« `2` ãå ¥ãã`partyRole` ã« `Buyer` ãå ¥ã£ãŠããŸãããããã£ãŠããã®è¡ã¯ãè«æ±æžåœäºè ã®ãã¡ãè²·æã衚ãè¡ããšè§£éã§ããŸãã
ãã®ããã«ãæ§é åCSVã§ã¯ãXMLã®éå±€ãçŽæ¥èŠãªããŠããè¡ãšåã®çµåãã§æå³ãå€å®ã§ããŸãã
3.3 ãµã³ãã«ããã°ã©ã ã®å®è¡
ããŠã³ããŒãããZIPãã¡ã€ã«ãå±éãããšã次ã®3ãã¡ã€ã«ããããŸãã
invoice.csv
bindings.csv
syntax_binding.py
å®è¡äŸã¯ã次ã®ãšããã§ãã
python3 syntax_binding.py \
--input-csv invoice.csv \
--bindings-csv bindings.csv \
--xml-out invoice.xml \
--roundtrip-csv roundtrip.csv \
--print-xmlWindows PowerShellã§1è¡ã§å®è¡ããå Žåã¯ã次ã®ããã«ãªããŸãã
python syntax_binding.py --input-csv invoice.csv --bindings-csv bindings.csv --xml-out invoice.xml --roundtrip-csv roundtrip.csv --print-xmlãã®å®è¡ã«ãããæ¬¡ã®2ã€ã®ãã¡ã€ã«ãçæãããŸãã
invoice.xml
ãæ§é åCSVããçæãã JP PINT UBL subset XML
roundtrip.csv
ãçæããXMLãèªã¿æ»ããŠåæ§æããæ§é åCSV
ããã§æ³šæãã¹ãç¹ããããŸãããã®ãµã³ãã«ããã°ã©ã ã¯ãJP PINT UBLã®å®å šå®è£ ã§ã¯ãããŸããã
ç®çã¯ã次ã®èãæ¹ã確èªããããšã§ãã
æ§é åCSVãèªã
æ§æçµå衚CSVãèªã
SemanticPathã§CSVåŽã®å€ãååŸãã
XPathã«åŸã£ãŠXMLèŠçŽ ãäœã
XMLã«å€ãèšå®ãã
éæ¹åã§ã¯XMLããCSVè¡ãåæ§æãã
ã€ãŸããJP PINTã®å šé ç®ãå®è£ ããããšã§ã¯ãªããæ§æçµå衚ã«åºã¥ãæ±çšå€æã®èãæ¹ã宿ããããšãç®çã§ãã
3.4 æ§æçµå衚ã§ãããã°ã©ã ãã倿仿§ã远ãåºã
ãµã³ãã«ã§ã¯ã`bindings.csv` ã«ãããæ§é åCSVåŽã® SemanticPath ãšãJP PINT UBLåŽã® XPath ã察å¿ä»ããŠããŸãã
æ§æçµå衚ã®äŸã¯ã次ã®ãšããã§ãã
semantic_path,xpath
$.Invoice.invoiceNumber,/Invoice/cbc:ID
$.Invoice.issueDate,/Invoice/cbc:IssueDate
$.Invoice.invoiceTypeCode,/Invoice/cbc:InvoiceTypeCode
$.Invoice.currencyCode,/Invoice/cbc:DocumentCurrencyCode
$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyName,/Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name
$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyTaxID,/Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyTaxScheme/cbc:CompanyID
$.Invoice.dInvoiceParty[?@.partyRole=Buyer].partyName,/Invoice/cac:AccountingCustomerParty/cac:Party/cac:PartyName/cbc:Name
$.Invoice.dInvoiceParty[?@.partyRole=Buyer].partyTaxID,/Invoice/cac:AccountingCustomerParty/cac:Party/cac:PartyTaxScheme/cbc:CompanyID
$.Invoice.dDocumentReference[?@.referenceType=Order].referenceID,/Invoice/cac:OrderReference/cbc:ID
$.Invoice.dDocumentReference[?@.referenceType=Delivery].referenceID,/Invoice/cac:DespatchDocumentReference/cbc:ID
$.Invoice.paymentDueDate,/Invoice/cbc:DueDate
$.Invoice.paymentReference,/Invoice/cac:PaymentMeans/cbc:PaymentIDããšãã°ã売æåç§°ã¯ãæ§é åCSVåŽã§ã¯æ¬¡ã® SemanticPath ã§æå®ããŸãã
$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyNameããã¯ãæ¬¡ã®æå³ã§ãã
dInvoiceParty ã®è¡ã®ãã¡ã
partyRole ã Seller ã§ããè¡ãéžæãã
ãã®è¡ã® partyName ãååŸããããã®å€ããJP PINT UBLåŽã®æ¬¡ã®XPathã«èšå®ããŸãã
/Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Nameããã§éèŠãªã®ã¯ãããã°ã©ã ãã売æåç§°ã¯ãã®XMLèŠçŽ ã«å ¥ããããšçŽæ¥ç¥ã£ãŠããããã§ã¯ãªãããšã§ããããã°ã©ã ã¯ãæ§æçµå衚ãèªã¿ãSemanticPathãšXPathã®å¯Ÿå¿ã«åŸã£ãŠåŠçããŸãã
3.5 ããã°ã©ã æ¬äœã¯ãæ±çšåŠçã«éäžãã
åŸæ¥ã®å€æããã°ã©ã ã§ã¯ã倿å é ç®ãšå€æå é ç®ãããã°ã©ã å ã«çŽæ¥æžã蟌ãããšãå€ããããŸãã
åŸæ¥å
if CSVã®åã partyName ã§ role ã Seller ãªãã
/Invoice/cac:AccountingSupplierParty/.../cbc:Name ã«èšå®ãããã®æ¹åŒã§ã¯ã倿å ã®ä»æ§ãå€ãããã³ã«ããã°ã©ã ä¿®æ£ãå¿ èŠã«ãªããŸããããã«å¯ŸããŠãæ§æçµå衚æ¹åŒã§ã¯ãããã°ã©ã æ¬äœã¯æ¬¡ã®æ±çšåŠçã«éäžããŸãã
æ§æçµå衚æ¹åŒ
binding ã1è¡èªã
semantic_path ãè©äŸ¡ããŠCSVããå€ãåã
xpath ã«åŸã£ãŠXMLèŠçŽ ãäœã
å€ãèšå®ãã
ããã°ã©ã äžã¯ãæŠå¿µçã«ã¯æ¬¡ã®ãããªåŠçã«ãªããŸãã
for semantic_path, xpath in bindings:
value = query_semantic_path(rows, semantic_path)
set_text(invoice_xml, xpath, value)ãã¡ãããå®éã«ã¯XMLåå空éãç¹°è¿ãæ§é ãéé¡å±æ§ãçšçå¥å èš³ãæçްè¡ãªã©ã®åŠçãå¿ èŠã§ããããããåºæ¬çãªèãæ¹ã¯ã倿仿§ãããã°ã©ã ã®äžã§ã¯ãªããæ§æçµå衚ãšããŠå€éšåããããšã§ããããã«ããã察å¿å ããšã®ããã°ã©ã éçºãæ¹èšãæžããããšãã§ããŸãã
æ§æçµå衚ã§ã¯ãXMLææžäžã®åèŠçŽ ã XPath ã§äžæã«æå®ãããããæ§é åCSVäžã®å¯Ÿå¿ããè¡åã¯é ç®ã«çµã³ä»ããŸããXMLã¯éå±€æ§é ãæã¡ãŸãããXPathã䜿ãã°åèŠçŽ ã®äœçœ®ãæç¢ºã«è¡šãããããæ§é åCSVãšXMLææžã®å¯Ÿå¿é¢ä¿ãæ©æ¢°çã«å®çŸ©ã§ããŸãã
3.6 æ§é åCSVã§ãçšçå¥å èš³ãæ€èšŒ
æ§é åCSVã®ã¡ãªããã¯ãXMLã«å€æã§ããããšã ãã§ã¯ãããŸããã
è«æ±æžããããŒãçšçå¥å èš³ãè«æ±æçްã1æã®CSVã«å«ãŸããŠãããããæçްè¡ã®éé¡ãçšåºåã»çšçå¥ã«éèšããè«æ±æžã«èšèŒãããçšçå¥å èš³ãšæ¯èŒã§ããŸãã
ããã§ã¯ã次ã®èšäºã§ç޹ä»ããã5. è«æ±æžã®æ§é åCSVãã®æ€èšŒåŠçãç°¡æœã«æŽçããŸãã
ãããã«æä»£ã®åœå
æ¢åEDI飿ºã𿥿¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒã
ä»åã®ãµã³ãã«ã§ã¯ãçšçå¥å 蚳㯠`dTaxBreakdown` ãæã€è¡ãšããŠèšé²ãããè«æ±æçŽ°ã¯ `dInvoiceLine` ãæã€è¡ãšããŠèšé²ãããŠããŸãã
ãããã£ãŠãæ€èšŒåŠçã¯æ¬¡ã®æµãã«ãªããŸãã
æ§é åCSVã1æèªã¿èŸŒã
dTaxBreakdown ã空ã§ãªãè¡ãã
çšçå¥å èš³ãšããŠæœåºããdInvoiceLine ã空ã§ãªãã
lineID ã空ã§ãªãè¡ãã
è«æ±æçްãšããŠæœåºããè«æ±æçްãã
dInvoiceãçšåºåãçšçããšã«éèšããéèšããæçްåèš lineTotal ãšã
çšçå¥å 蚳㮠taxableAmount ãæ¯èŒããlineTotal à taxRate / 100 ã§çšé¡ãèšç®ãã
taxAmount ãåæšãŠã»åäžãã»åæšäºå ¥ã®
ããããã«äžèŽããã確èªãã
ä»åã®ãµã³ãã«ã§ã¯ãæçްè¡ã¯æ¬¡ã®3è¡ã§ãã
1,,,,,1,,,,,,,,,,,,,,,,,,INV-26-861-1,ååA,S,10,10,EA,1000,10000
1,,,,,2,,,,,,,,,,,,,,,,,,INV-26-861-2,ååB,S,10,4,EA,580,2320
1,,,,,3,,,,,,,,,,,,,,,,,,INV-26-861-3,é£åC,AA,8,7,EA,430,3010çšçå¥å èš³ã¯ã次ã®2è¡ã§ãã
1,,,,1,,,,,,,,,,,,,,,S,10,12320,1232,,,,,,,,
1,,,,1,,,,,,,,,,,,,,,AA,8,3010,240,,,,,,,,æçްè¡ãçšåºåã»çšçå¥ã«éèšãããšã次ã®ããã«ãªããŸãã
S 10%
ååA 10000
ååB 2320
åèš 12320
AA 8%
é£åC 3010
åèš 3010ããã¯ãçšçå¥å 蚳㮠`taxableAmount` ãšäžèŽããŸãã
S 10% taxableAmount 12320
AA 8% taxableAmount 3010次ã«ãçšé¡ã確èªããŸãã
S 10%
lineTotal 12320 Ã 10% = 1232
taxAmount = 1232
OK
AA 8%
lineTotal 3010 Ã 8% = 240.8
taxAmount = 240
åæšãŠã®å Žåã«äžèŽãããã OKãã®ããã«ãæ§é åCSVã§ããã°ãæçްè¡ãšçšçå¥å èš³ãå¥ã ã®CSVããJOINããŠåŸ©å ããå¿ èŠã¯ãããŸããã
1æã®CSVããã`dInvoiceLine` ãæã€è¡ãš `dTaxBreakdown` ãæã€è¡ãæœåºããçšåºåã»çšçå¥ã«éèšããŠæ¯èŒããã°ããã®ã§ãã
å®è£ äžã¯ã次ã®ãããªåŠçã«ãªããŸãã
line_total = (
lines.groupby(
["dInvoice", "lineTaxCategoryCode", "lineTaxRate"],
as_index=False
)
.agg(lineTotal=("lineExtensionAmount", "sum"))
.rename(
columns={
"lineTaxCategoryCode": "taxCategoryCode",
"lineTaxRate": "taxRate"
}
)
)
reported = tax_breakdown[
["dInvoice", "taxCategoryCode", "taxRate", "taxableAmount", "taxAmount"]
]
check = line_total.merge(
reported,
on=["dInvoice", "taxCategoryCode", "taxRate"],
how="outer"
)ããã§äœ¿ã£ãŠãã `groupby().agg()` ã¯ãPandas ã®æšæºçãªéèšæäœã§ãã
èãæ¹ã¯ãExcel ã®ããããããŒãã«ããSQL ã® `GROUP BY` ã«è¿ããã®ã§ãã
ä»åã®ç®çã¯ãè«æ±æçްè¡ããè«æ±æžåäœãçšåºåãçšçããšã«ãŸãšãããã®éé¡åèšãæ±ããããšã§ãã
line_total = (
lines.groupby(
["dInvoice", "lineTaxCategoryCode", "lineTaxRate"],
as_index=False
)
.agg(lineTotal=("lineExtensionAmount", "sum"))
.rename(
columns={
"lineTaxCategoryCode": "taxCategoryCode",
"lineTaxRate": "taxRate"
}
)
)ãŸããæ¬¡ã®éšåã§ãè«æ±æçް `lines` ãã°ã«ãŒãåããŸãã
lines.groupby(
["dInvoice", "lineTaxCategoryCode", "lineTaxRate"],
as_index=False
)ã°ã«ãŒãåã®ããŒã¯ã次ã®3ã€ã§ãã
dInvoice
è«æ±æžåäœ
lineTaxCategoryCode
æçްè¡ã®çšåºå
lineTaxRate
æçްè¡ã®çšçä»åã®ãµã³ãã«ã§ã¯ãæçްè¡ã¯æ¬¡ã®ããã«åãããŸãã
dInvoice = 1, lineTaxCategoryCode = S, lineTaxRate = 10
ååA 10000
ååB 2320
dInvoice = 1, lineTaxCategoryCode = AA, lineTaxRate = 8
é£åC 3010次ã«ã`.agg()` ã§éèšããŸãã
.agg(lineTotal=("lineExtensionAmount", "sum"))ããã¯ã`lineExtensionAmount` åãåèšãããã®çµæã `lineTotal` ãšããååã§åºåããããšããæå³ã§ãã
ãããã£ãŠãéèšçµæã¯æ¬¡ã®ããã«ãªããŸãã
dInvoice lineTaxCategoryCode lineTaxRate lineTotal
1 S 10 12320
1 AA 8 3010æåŸã«ã`.rename()` ã§ååã倿ŽããŠããŸãã
.rename(
columns={
"lineTaxCategoryCode": "taxCategoryCode",
"lineTaxRate": "taxRate"
}
)ããã¯ãæçްè¡åŽã®ååããçšçå¥å èš³åŽã®ååã«åãããããã§ãã
æçްè¡ã§ã¯ãçšåºåãšçšçãæ¬¡ã®åã§æã£ãŠããŸãã
lineTaxCategoryCode
lineTaxRateäžæ¹ãçšçå¥å èš³ã§ã¯ã次ã®ååã§ãã
taxCategoryCode
taxRateãã®ãŸãŸã§ã¯ååãç°ãªããããåŸç¶ã® `merge()` ã§æ¯èŒãã«ãããªããŸãã
ããã§ãæçްè¡åŽã®éèšçµæã®ååããçšçå¥å èš³åŽã«åãããŸãã
lineTaxCategoryCode â taxCategoryCode
lineTaxRate â taxRateãã®çµæãæçްè¡ã®éèšçµæãšãçšçå¥å èš³ããæ¬¡ã®å ±éããŒã§çµåã§ããŸãã
dInvoice
taxCategoryCode
taxRateãã®çµååŠçããæ¬¡ã® `merge()` ã§ãã
check = line_total.merge(
reported,
on=["dInvoice", "taxCategoryCode", "taxRate"],
how="outer"
)`merge()` ã¯ãPandas ã®è¡šçµåæäœã§ããããã§ã¯ãæçްè¡ããèšç®ããéèšçµæ `line_total` ãšãè«æ±æžã«èšèŒãããŠããçšçå¥å èš³ `reported` ããåã `dInvoice`ã`taxCategoryCode`ã`taxRate` ã®çµåãã§çªãåãããŠããŸãã`how="outer"` ãšããŠããã®ã¯ãã©ã¡ããäžæ¹ã«ããååšããªãçµåããæ€åºããããã§ããããšãã°ã次ã®ãããªäžäžèŽãèŠã€ããããšãã§ããŸãã
æçްè¡ã«ã¯ S 10% ããããã
çšçå¥å
蚳㫠S 10% ããªã
çšçå¥å
èš³ã«ã¯ AA 8% ããããã
æçްè¡ã« AA 8% ããªã
æçްåèšãš taxableAmount ãäžèŽããªã
taxAmount ãã
lineTotal à taxRate / 100 ã®çµæãšæŽåããªããã® `check` ã«å¯ŸããŠã次ã®2ã€ã確èªããŸãã
taxableOK
lineTotal ãš taxableAmount ãäžèŽããŠããããš
taxOK
taxAmount ãã
lineTotal à taxRate / 100 ã®
åæšãŠã»åäžãã»åæšäºå
¥ã®
ããããã«äžèŽããŠããããšã€ãŸããå€å®æ¡ä»¶ã¯æ¬¡ã®ããã«æŽçã§ããŸãã
OK = taxableOK ã〠taxOKXMLãçŽæ¥åŠçããå Žåãåå空éä»ãã®XMLèŠçŽ ããã©ããè«æ±æçްãçšåºåãçšçãçšçå¥å èš³ãååŸããå¿ èŠããããŸãã
æ§é åCSVã§ã¯ãåãæ€èšŒããCSVè¡ã®æœåºãã°ã«ãŒãåãéèšãçµåãæ¯èŒãšããŠèšè¿°ã§ããŸãã
æ§é åCSVãèªã
ãâ
dInvoiceLine è¡ãæœåºãã
ãâ
groupby().agg() ã§çšåºåã»çšçå¥ã«éèšãã
ãâ
dTaxBreakdown è¡ãš merge() ã§çªãåããã
ãâ
taxableAmount ãš taxAmount ãæ€èšŒãã
ãã®ç¹ããäŒèšãçšåãç£æ»ãã·ã¹ãã éçšã®èгç¹ã§å€§ããªã¡ãªããã§ãã
4 å¹æïŒæ¢åEDIã»äŒèšã»çšåã»ç£æ»ãžåºãã
4.1 æ¢åEDIã眮ãæããã®ã§ã¯ãªããã€ãªã
ããã§éèŠãªã®ã¯ãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãæ¢åEDIã眮ãæãããã®ã§ã¯ãªãããšããç¹ã§ããæµéBMSã«ã¯ãåçºæ³šãåºè·ãåé ãè¿åãæ€åãªã©ãæµéæ¥åã«æ ¹ããã圹å²ããããŸããäžå°äŒæ¥å ±éEDIã«ã¯ãäžå°äŒæ¥ã倿§ãªååŒå ãšé»åçã«åçºæ³šçãè¡ãããã®ä»çµã¿ããããŸããæ¥çEDIãWeb-EDIã«ããããããã®ååŒæ £è¡ã«åããã圹å²ããããŸãã
ãããã£ãŠãçŸå®çãªæ¹éã¯ãæ¢åEDIããã¹ãŠå»æ¢ããŠJP PINTã«çœ®ãæããããšã§ã¯ãããŸããã
ããããæ¢åEDIãæŽ»ãããªãããè«æ±æžãä»å ¥æçްæžãæ¯æéç¥ãæ¶èŸŒåç §ãªã©ã®é åã§ãããã«/JP PINTãšæ¥ç¶ã§ããããã«ããããšã§ãã
圹å²åæ
æµéBMS
ãåçºæ³šãåºè·ãåé ãè¿åãæ€åç
äžå°äŒæ¥å
±éEDI
ãäžå°äŒæ¥éã®åçºæ³šãçŽåãè«æ±ç
ERPã»è²©å£²ç®¡ç
ãåæ³šã売äžãè«æ±ãå
¥éãåšåº«ãåŸæå
管ç
äŒèš
ãä»èš³ã嵿š©åµåãæ¶èŸŒãçšåãç£æ»èšŒè·¡
JP PINT
ãããã«äžã§é
éããé»åã€ã³ãã€ã¹æ§æ
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹
ãããããè«æ±æžãšããŠã®å
±éæå³ã«å¯Ÿå¿ä»ãã
ãã®ããã«èãããšãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã¯ãæ¢åEDIãšããã«ã®æ©æž¡ãã«ãªããŸãã
4.2 ç£æ»ã»çšåã»æ¶èŸŒã«ãã€ãªãã
æ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšããŠæ§é åCSVãå®çŸ©ããããšã«ã¯ãããäžã€éèŠãªæå³ããããŸãã
è«æ±æžã¯ãåç¬ã§ååšããŠããããã§ã¯ãããŸããã
泚æãçŽåãæ€åãè«æ±ãæ¯æãå ¥éãæ¶èŸŒãä»èš³ãçšåãç£æ»èšŒè·¡ãšã€ãªãã£ãŠããŸãã
æ§é åCSVã®äžã«ã泚æçªå·ãçŽåæžçªå·ãæ€åçªå·ãæ¯æåç §ãååŒå IDãæçްIDãªã©ãä¿æã§ããã°ãè«æ±æžãä»ã®æ¥åããŒã¿ãšé¢é£ä»ããããšãã§ããŸãã
ä»åã®ãµã³ãã«CSVã§ããæ³šææžçªå·ãšçŽåæžçªå·ãå«ãŸããŠããŸãã
1,,1,,,,,,,,,,,,Order,PO-2026-0001,,,,,,,,,,,,,,,
1,,2,,,,,,,,,,,,Delivery,DN-2026-0001,,,,,,,,,,,,,,,æ¯æåç §ãå«ãŸããŠããŸãã
1,,,1,,,,,,,,,,,,,2026-07-31,30,INV-2026-0001,,,,,,,,,,,,ãã®ãããªåç §ãä¿æããããšã§ãè«æ±æžããŒã¿ã¯ãæ¯æãå ¥éæ¶èŸŒãä»èš³ãç£æ»èšŒè·¡ãžæ¥ç¶ã§ããŸãã
ã€ãŸããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ã¯ãåãªãé»åã€ã³ãã€ã¹äº€æã«ãšã©ãŸããŸãããå°æ¥çã«ã¯ãäŒèšããŒã¿ãç£æ»ããŒã¿ãçšåå ±åãæ¯æã»æ¶èŸŒããŒã¿ãšã®é£æºåºç€ã«ãªããŸãã
4.3 ãã®ãµã³ãã«ã§å®æããŠã»ããããš
ä»åã®ãµã³ãã«ããã°ã©ã ã§å®æããŠã»ããããšã¯ã次ã®ç¹ã§ãã
æ§é åCSVã¯ãæ®éã®CSVãšããŠèªãã
ââ invoice.csv ã csv.DictReader ã§èªãã1æã®CSVã«è«æ±æžå šäœãä¿æã§ãã
ââ ããããŒã売æãè²·æãåç §ææžãæ¯æãçšå èš³ãæçŽ°ãæ ŒçŽã§ããè¡ã®æå³ããã£ã¡ã³ã·ã§ã³åã§å€å®ã§ãã
ââ dInvoicePartyãdTaxBreakdownãdInvoiceLine ãªã©ãèŠãSemanticPathã§CSVåŽã®å€ãæå®ã§ãã
ââ $.Invoice.dInvoiceParty[?@.partyRole=Seller].partyNameXPathã§JP PINT UBLåŽã®èŠçŽ ãæå®ã§ãã
ââ /Invoice/cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Nameæ§æçµå衚ãå€éšåã§ãã
ââ bindings.csv ã倿Žããããšã§å¯Ÿå¿é¢ä¿ã倿Žã§ããCSVããXMLãçæããXMLããCSVãžæ»ãã
ââ invoice.xml ãš roundtrip.csv ãçæã§ãã
ä»åã®ãµã³ãã«ããã°ã©ã ã¯ãåœå æ¢åEDIãšããã«ãã€ãªããšãã«å¿ èŠãšãªããåºæ¬çãªèšèšææ³ã瀺ããŠããŸãã
ãŸãšã
æ¬çš¿ã®äž»åŒµã¯ã次ã®ãšããã§ãã
ããã«ã¯ãæ¥æ¬å šåœãå§ããšããŠå šäžçãšã€ãªããããã®çžäºæ¥ç¶ãããã¯ãŒã¯ã§ããçžæã®ããã«IDãåããã°ãã©ã®ãããã€ãåã¯ã¢ã¯ã»ã¹ãã€ã³ãçµç±ã§ã¡ãã»ãŒãžãå±ããããããçºèŠã§ããŸãã
äžæ¹ãæ¥æ¬åœå ã®æ¢åEDIã®å€ãã¯ããããã€ããçºè¡ããIDã䜿ã3ã³ãŒããŒã¢ãã«ãåæãšããŠããŸããä»ã®ãããã€ããšé£æºããå Žåã«ã¯ãçžæå ãããã€ãã«ç»é²ãããIDãšã®ãããã³ã°ããã¡ã€ã«åœ¢åŒã®å€æãåå¥éçšèª¿æŽãå¿ èŠã«ãªããŸãã
ãã®3+1ã®ã+1ããçžæããšã«äœãç¶ãããšãn+â ã®ããã«ç¶æç®¡çãèšãã¿ãŸããããã§ã+1 ã®å¯Ÿå¿å ããæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ïŒæ§é åCSVïŒã«åºå®ããŸãã
ããã«ããããã€ãããåœå EDIå©çšè IDãšããã«IDãšã®å€æãæäŸããã°ãåœå ã®ç°ãªãEDIãããã€ãéã§ããæ¬æ¥ã®æå³ã§ãã©ããäžã€ã®ãããã€ãã«ã€ãªãã£ãŠããããã°ãåœå ã®ã©ã®ãããã€ãã®å©çšè ãšãã¡ãã»ãŒãžäº€æãå¯èœãªäžçã«è¿ã¥ããŸãã
æ§æçµåã®ä»çµã¿ãæ¡çšããã°ã察å¿å ããšã®ããã°ã©ã éçºãæ¹èšããã§ããã ãçµå衚ã®å®çŸ©å€æŽã«ç§»ãããšãã§ããŸãããã®çµæãã·ã¹ãã ã®ç¶æç®¡çã¯å®¹æã«ãªããŸãã
ä»åã®ãµã³ãã«ããã°ã©ã ã¯ããã®èãæ¹ã宿ããããã®ãã®ã§ãããã² `syntax_binding_revised_package.zip` ãããŠã³ããŒããã`invoice.csv`ã`bindings.csv`ã`syntax_binding.py` ã確èªããŠãã ããã
æ§é åCSVããåãªãCSVã§ã¯ãªããæ¢åEDIãERPãäŒèšãJP PINTãããã«ãã€ãªãæ¥æ¬çã³ã¢ã€ã³ãã€ã¹ãšããŠæ©èœããããšããå®éã®ããã°ã©ã åŠçãšããŠç¢ºèªã§ããŸãã
ãã®é£èŒã«ã€ããŠ
第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ã®åœéçãªäœçœ®ã¥ãã瀺ããŸãã