EDI ORDER template, now with copies
authorBill Erickson <berick@esilibrary.com>
Fri, 27 Jul 2012 16:11:23 +0000 (12:11 -0400)
committerMike Rylander <mrylander@gmail.com>
Wed, 1 Aug 2012 19:15:24 +0000 (15:15 -0400)
commitab47e65292278af4213df9dc7a6afa020bc208e4
tree231e1a9b63723eebe1a730ed30b1e4acabe80bc7
parentd6bab7ae43feb872af795022106f6848f41f09ad
EDI ORDER template, now with copies

Adds a new "copies" structure to the stock JEDI ORDER template.  Copies
are ultimately mapped into one or more GIR segments in the outbound EDI.
This commit only adds the change to the stock template (seed data).  It
also adds entries to the environment for the stock template and existing
template 23 via upgrade script (to expedite local template editing).

With the current template, GIR segments look like so:

GIR+001+8:LCO+TESTFUND2:LFN+SYS1-BR1:LLO+FIC ROW 456:LSM+Stacks:LSQ'
GIR+002+9:LCO+TESTFUND2:LFN+SYS1-BR1:LLO+FIC ROW 456:LSM+Stacks:LSQ'
GIR+003+10:LCO+TESTFUND2:LFN+SYS1-BR1:LLO+FIC ROW 456:LSM+Stacks:LSQ'
GIR+004+11:LCO+TESTFUND2:LFN+SYS1-BR1:LLO+FIC ROW 456:LSM+Stacks:LSQ'
GIR+005+12:LCO+TESTFUND2:LFN+SYS1-BR1:LLO+FIC ROW 456:LSM+Stacks:LSQ'
GIR+006+13:LCO+TESTFUND2:LFN+SYS1-BR2:LLO+FIC ROW 456:LSM+Young Adult:LSQ'
GIR+007+14:LCO+TESTFUND2:LFN+SYS1-BR2:LLO+FIC ROW 456:LSM+Young Adult:LSQ'
GIR+008+15:LCO+TESTFUND2:LFN+SYS1-BR2:LLO+FIC ROW 456:LSM+Young Adult:LSQ'

LQT / quantity is also supported.

The current implementation is meant to cover all possible fields so that
users can remove/alter items on a vendor by vendor basis as needed.

Signed-off-by: Bill Erickson <berick@esilibrary.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.data.jedi_with_copies.sql [new file with mode: 0644]