https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759
--- Comment #5 from Kyle M Hall <[email protected]> --- Here is an updated query: INSERT INTO `edifact_messages` ( id, message_type, transfer_date, vendor_id, edi_acct, status, basketno, raw_msg, filename, deleted ) VALUES (9999,'INVOICE','2020-06-09',NULL,NULL,'new',NULL, 'UNA:+.? \'UNB+UNOA:2+1556150:31B+3504069:31B+200609:0311+428\'UNG+INVOIC+1556150:31B+3504069:31B+20200609:0311+428+UN+D:96A\'UNH+1210+INVOIC:0:96:UN\'BGM+380+2035199664+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+4++9780062912756:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158155\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780310357179:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:164038\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781984804938:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:163698\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+13++9780316477536:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:162817\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+44++9780062988904:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163717\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+18++9781250216991:EN\'QTY+47:1\'MOA+203:9.19\'PRI+AAB:8.99::SRP\'PRI+AAA:5.39::DPR\'RFF+LI:163691\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+23++9780062937728:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164156\'RFF+ON:11105 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+15++9781538715642:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:158933\'RFF+ON:10782 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157316\'RFF+ON:10670 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159550\'RFF+ON:10821 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780525539520:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:154348\'RFF+ON:AF20 10442\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+32++9780062953926:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158183\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+27++9781982136116:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:160430\'RFF+ON:10886 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+57++9780062993861:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:162861\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:15\'CNT+2:14\'MOA+86:258.12\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:57\'ALC+C++++TX\'MOA+124:0\'UNT+171+1210\'UNH+1211+INVOIC:0:96:UN\'BGM+380+2035200766+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+2++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:152771\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:154677\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+21++9780385544962:EN\'QTY+47:1\'MOA+203:20.6\'PRI+AAB:29.95::SRP\'PRI+AAA:16.8::DPR\'RFF+LI:159724\'RFF+ON:10835 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781524745202:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:152331\'RFF+ON:AF20 10307\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+24++9781250168962:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:163697\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062951663:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162164\'RFF+ON:10984 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+17++9781250210883:EN\'QTY+47:2\'MOA+203:37.88\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158168\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+16++9780735291027:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:163689\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9781984805997:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163524\'RFF+ON:11069 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+16++9781250261878:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:159061\'RFF+ON:10786 ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+19++9781420149975:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:163692\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525542353:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:160067\'RFF+ON:10863 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780316422130:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:158921\'RFF+ON:10782 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781982137977:EN\'QTY+47:3\'MOA+203:61.89\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:156872\'RFF+ON:10631 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+31++9781982137977:EN\'QTY+47:2\'MOA+203:41.26\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:161022\'RFF+ON:10920 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+10++9781501188589:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158161\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+22++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158173\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162750\'RFF+ON:11026 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157317\'RFF+ON:10670 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159183\'RFF+ON:10795 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:162324\'RFF+ON:10988 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780440000839:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158184\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9781250252203:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:163712\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9781538717820:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163707\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:160906\'RFF+ON:10913 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163118\'RFF+ON:11049 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781984802705:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:157214\'RFF+ON:10657 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9780593171592:EN\'QTY+47:1\'MOA+203:21.2\'PRI+AAB:29::SRP\'PRI+AAA:17.4::DPR\'RFF+LI:159768\'RFF+ON:10837 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781643852997:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162829\'RFF+ON:11032 AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+29++9781524760380:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:158180\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9780062966742:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158190\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+54++9780778310099:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158205\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+23++9780735223103:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158174\'RFF+ON:10734 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+6++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:153700\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+1++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:157636\'RFF+ON:10697 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+14++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:160990\'RFF+ON:10919 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+30++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:162637\'RFF+ON:11019 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+20++9781250302045:EN\'QTY+47:1\'MOA+203:18.38\'PRI+AAB:25.99::SRP\'PRI+AAA:14.58::DPR\'RFF+LI:163693\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:162385\'RFF+ON:10994 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:164412\'RFF+ON:11123 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:52\'CNT+2:40\'MOA+86:973.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:197.6\'ALC+C++++TX\'MOA+124:0\'UNT+457+1211\'UNH+1212+INVOIC:0:96:UN\'BGM+380+2035201654+9\'DTM+137:20200608:102\'NAD+DP+3504069 0059::31B\'NAD+BY+3504069 0059::91\'NAD+SU+1692100::31B\'LIN+15++9781644450178:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:159060\'RFF+ON:10786 ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161001\'RFF+ON:10920 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161761\'RFF+ON:10953 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:164422\'RFF+ON:11123 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9781472267474:EN\'QTY+47:1\'MOA+203:17.82\'PRI+AAB:24.99::SRP\'PRI+AAA:14.02::DPR\'RFF+LI:161591\'RFF+ON:10943 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+41++9780593129463:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:164046\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+43++9780525479123:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:163716\'RFF+ON:11073 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9780785233527:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164039\'RFF+ON:11100 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781538752111:EN\'QTY+47:2\'MOA+203:42.38\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:154404\'RFF+ON:LP 10446\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+2++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:160894\'RFF+ON:10911 LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:162714\'RFF+ON:11024 AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:12\'CNT+2:11\'MOA+86:233.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:45.6\'ALC+C++++TX\'MOA+124:0\'UNT+138+1212\'UNE+3+428\'UNZ+1+428\'','OUT149066162243.INT',0); -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
