3 SELECT evergreen.upgrade_deps_block_check('1067', :eg_version);
5 INSERT INTO acq.edi_attr (key, label) VALUES
7 oils_i18n_gettext('INCLUDE_PO_NAME',
8 'Orders Include PO Name', 'aea', 'label')),
10 oils_i18n_gettext('INCLUDE_COPIES',
11 'Orders Include Copy Data', 'aea', 'label')),
13 oils_i18n_gettext('INCLUDE_FUND',
14 'Orders Include Copy Funds', 'aea', 'label')),
15 ('INCLUDE_CALL_NUMBER',
16 oils_i18n_gettext('INCLUDE_CALL_NUMBER',
17 'Orders Include Copy Call Numbers', 'aea', 'label')),
19 oils_i18n_gettext('INCLUDE_ITEM_TYPE',
20 'Orders Include Copy Item Types', 'aea', 'label')),
21 ('INCLUDE_ITEM_BARCODE',
22 oils_i18n_gettext('INCLUDE_ITEM_BARCODE',
23 'Orders Include Copy Barcodes', 'aea', 'label')),
25 oils_i18n_gettext('INCLUDE_LOCATION',
26 'Orders Include Copy Locations', 'aea', 'label')),
27 ('INCLUDE_COLLECTION_CODE',
28 oils_i18n_gettext('INCLUDE_COLLECTION_CODE',
29 'Orders Include Copy Collection Codes', 'aea', 'label')),
30 ('INCLUDE_OWNING_LIB',
31 oils_i18n_gettext('INCLUDE_OWNING_LIB',
32 'Orders Include Copy Owning Library', 'aea', 'label')),
33 ('USE_ID_FOR_OWNING_LIB',
34 oils_i18n_gettext('USE_ID_FOR_OWNING_LIB',
35 'Emit Owning Library ID Rather Than Short Name. Takes effect only if INCLUDE_OWNING_LIB is in use', 'aea', 'label')),
37 oils_i18n_gettext('INCLUDE_QUANTITY',
38 'Orders Include Copy Quantities', 'aea', 'label')),
40 oils_i18n_gettext('INCLUDE_COPY_ID',
41 'Orders Include Copy IDs', 'aea', 'label')),
42 ('BUYER_ID_INCLUDE_VENDCODE',
43 oils_i18n_gettext('BUYER_ID_INCLUDE_VENDCODE',
44 'Buyer ID Qualifier Includes Vendcode', 'aea', 'label')),
45 ('BUYER_ID_ONLY_VENDCODE',
46 oils_i18n_gettext('BUYER_ID_ONLY_VENDCODE',
47 'Buyer ID Qualifier Only Contains Vendcode', 'aea', 'label')),
48 ('INCLUDE_BIB_EDITION',
49 oils_i18n_gettext('INCLUDE_BIB_EDITION',
50 'Order Lineitems Include Edition Info', 'aea', 'label')),
51 ('INCLUDE_BIB_AUTHOR',
52 oils_i18n_gettext('INCLUDE_BIB_AUTHOR',
53 'Order Lineitems Include Author Info', 'aea', 'label')),
54 ('INCLUDE_BIB_PAGINATION',
55 oils_i18n_gettext('INCLUDE_BIB_PAGINATION',
56 'Order Lineitems Include Pagination Info', 'aea', 'label')),
58 oils_i18n_gettext('COPY_SPEC_CODES',
59 'Order Lineitem Notes Include Copy Spec Codes', 'aea', 'label')),
60 ('INCLUDE_EMPTY_IMD_VALUES',
61 oils_i18n_gettext('INCLUDE_EMPTY_IMD_VALUES',
62 'Lineitem Title, Author, etc. Fields Are Present Even if Empty', 'aea', 'label')),
63 ('INCLUDE_EMPTY_LI_NOTE',
64 oils_i18n_gettext('INCLUDE_EMPTY_LI_NOTE',
65 'Order Lineitem Notes Always Present (Even if Empty)', 'aea', 'label')),
66 ('INCLUDE_EMPTY_CALL_NUMBER',
67 oils_i18n_gettext('INCLUDE_EMPTY_CALL_NUMBER',
68 'Order Copies Always Include Call Number (Even if Empty)', 'aea', 'label')),
69 ('INCLUDE_EMPTY_ITEM_TYPE',
70 oils_i18n_gettext('INCLUDE_EMPTY_ITEM_TYPE',
71 'Order Copies Always Include Item Type (Even if Empty)', 'aea', 'label')),
72 ('INCLUDE_EMPTY_LOCATION',
73 oils_i18n_gettext('INCLUDE_EMPTY_LOCATION',
74 'Order Copies Always Include Location (Even if Empty)', 'aea', 'label')),
75 ('INCLUDE_EMPTY_COLLECTION_CODE',
76 oils_i18n_gettext('INCLUDE_EMPTY_COLLECTION_CODE',
77 'Order Copies Always Include Collection Code (Even if Empty)', 'aea', 'label')),
78 ('LINEITEM_IDENT_VENDOR_NUMBER',
79 oils_i18n_gettext('LINEITEM_IDENT_VENDOR_NUMBER',
80 'Lineitem Identifier Fields (LIN/PIA) Use Vendor-Encoded ID Value When Available', 'aea', 'label')),
81 ('LINEITEM_REF_ID_ONLY',
82 oils_i18n_gettext('LINEITEM_REF_ID_ONLY',
83 'Lineitem Reference Field (RFF) Uses Lineitem ID Only', 'aea', 'label'))
87 INSERT INTO acq.edi_attr_set (id, label) VALUES (1, 'Ingram Default');
88 INSERT INTO acq.edi_attr_set (id, label) VALUES (2, 'Baker & Taylor Default');
89 INSERT INTO acq.edi_attr_set (id, label) VALUES (3, 'Brodart Default');
90 INSERT INTO acq.edi_attr_set (id, label) VALUES (4, 'Midwest Tape Default');
91 INSERT INTO acq.edi_attr_set (id, label) VALUES (5, 'ULS Default');
92 INSERT INTO acq.edi_attr_set (id, label) VALUES (6, 'Recorded Books Default');
93 INSERT INTO acq.edi_attr_set (id, label) VALUES (7, 'Midwest Library Service');
95 -- carve out space for mucho defaults
96 SELECT SETVAL('acq.edi_attr_set_id_seq'::TEXT, 1000);
98 INSERT INTO acq.edi_attr_set_map (attr_set, attr) VALUES
101 (1, 'INCLUDE_PO_NAME'),
102 (1, 'INCLUDE_COPIES'),
103 (1, 'INCLUDE_ITEM_TYPE'),
104 (1, 'INCLUDE_COLLECTION_CODE'),
105 (1, 'INCLUDE_OWNING_LIB'),
106 (1, 'INCLUDE_QUANTITY'),
107 (1, 'INCLUDE_BIB_PAGINATION'),
110 (2, 'INCLUDE_COPIES'),
111 (2, 'INCLUDE_ITEM_TYPE'),
112 (2, 'INCLUDE_COLLECTION_CODE'),
113 (2, 'INCLUDE_CALL_NUMBER'),
114 (2, 'INCLUDE_OWNING_LIB'),
115 (2, 'INCLUDE_QUANTITY'),
116 (2, 'INCLUDE_BIB_PAGINATION'),
117 (2, 'BUYER_ID_INCLUDE_VENDCODE'),
118 (2, 'INCLUDE_EMPTY_LI_NOTE'),
119 (2, 'INCLUDE_EMPTY_CALL_NUMBER'),
120 (2, 'INCLUDE_EMPTY_ITEM_TYPE'),
121 (2, 'INCLUDE_EMPTY_COLLECTION_CODE'),
122 (2, 'INCLUDE_EMPTY_LOCATION'),
123 (2, 'LINEITEM_IDENT_VENDOR_NUMBER'),
124 (2, 'LINEITEM_REF_ID_ONLY'),
127 (3, 'INCLUDE_COPIES'),
129 (3, 'INCLUDE_ITEM_TYPE'),
130 (3, 'INCLUDE_COLLECTION_CODE'),
131 (3, 'INCLUDE_OWNING_LIB'),
132 (3, 'INCLUDE_QUANTITY'),
133 (3, 'INCLUDE_BIB_PAGINATION'),
134 (3, 'COPY_SPEC_CODES'),
137 (4, 'INCLUDE_COPIES'),
139 (4, 'INCLUDE_OWNING_LIB'),
140 (4, 'INCLUDE_QUANTITY'),
141 (4, 'INCLUDE_BIB_PAGINATION'),
144 (5, 'INCLUDE_COPIES'),
145 (5, 'INCLUDE_ITEM_TYPE'),
146 (5, 'INCLUDE_COLLECTION_CODE'),
147 (5, 'INCLUDE_OWNING_LIB'),
148 (5, 'INCLUDE_QUANTITY'),
149 (5, 'INCLUDE_BIB_AUTHOR'),
150 (5, 'INCLUDE_BIB_EDITION'),
151 (5, 'INCLUDE_EMPTY_LI_NOTE'),
154 (6, 'INCLUDE_COPIES'),
155 (6, 'INCLUDE_ITEM_TYPE'),
156 (6, 'INCLUDE_COLLECTION_CODE'),
157 (6, 'INCLUDE_OWNING_LIB'),
158 (6, 'INCLUDE_QUANTITY'),
159 (6, 'INCLUDE_BIB_PAGINATION'),
161 -- Midwest Library Service
162 (7, 'INCLUDE_BIB_AUTHOR'),
163 (7, 'INCLUDE_BIB_EDITION'),
164 (7, 'BUYER_ID_ONLY_VENDCODE'),
165 (7, 'INCLUDE_EMPTY_IMD_VALUES')