3 -- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 INSERT INTO acq.edi_attr (key, label) VALUES
7 oils_i18n_gettext('INCLUDE_PO_NAME',
8 'Oders 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')),
34 oils_i18n_gettext('INCLUDE_QUANTITY',
35 'Orders Include Copy Quantities', 'aea', 'label')),
37 oils_i18n_gettext('INCLUDE_COPY_ID',
38 'Orders Include Copy IDs', 'aea', 'label')),
39 ('BUYER_ID_INCLUDE_VENDCODE',
40 oils_i18n_gettext('BUYER_ID_INCLUDE_VENDCODE',
41 'Buyer ID Qualifier Includes Vendcode', 'aea', 'label')),
42 ('INCLUDE_BIB_EDITION',
43 oils_i18n_gettext('INCLUDE_BIB_EDITION',
44 'Order Lineitems Include Edition Info', 'aea', 'label')),
45 ('INCLUDE_BIB_AUTHOR',
46 oils_i18n_gettext('INCLUDE_BIB_AUTHOR',
47 'Order Lineitems Include Author Info', 'aea', 'label')),
48 ('INCLUDE_BIB_PAGINATION',
49 oils_i18n_gettext('INCLUDE_BIB_PAGINATION',
50 'Order Lineitems Include Pagination Info', 'aea', 'label')),
52 oils_i18n_gettext('COPY_SPEC_CODES',
53 'Order Lineitem Notes Include Copy Spec Codes', 'aea', 'label')),
54 ('INCLUDE_EMPTY_LI_NOTE',
55 oils_i18n_gettext('INCLUDE_EMPTY_LI_NOTE',
56 'Order Lineitem Notes Always Present (Even if Empty)', 'aea', 'label')),
57 ('INCLUDE_EMPTY_CALL_NUMBER',
58 oils_i18n_gettext('INCLUDE_EMPTY_CALL_NUMBER',
59 'Order Copies Always Include Call Number (Even if Empty)', 'aea', 'label')),
60 ('INCLUDE_EMPTY_ITEM_TYPE',
61 oils_i18n_gettext('INCLUDE_EMPTY_ITEM_TYPE',
62 'Order Copies Always Include Item Type (Even if Empty)', 'aea', 'label')),
63 ('INCLUDE_EMPTY_LOCATION',
64 oils_i18n_gettext('INCLUDE_EMPTY_LOCATION',
65 'Order Copies Always Include Location (Even if Empty)', 'aea', 'label')),
66 ('INCLUDE_EMPTY_COLLECTION_CODE',
67 oils_i18n_gettext('INCLUDE_EMPTY_COLLECTION_CODE',
68 'Order Copies Always Include Collection Code (Even if Empty)', 'aea', 'label')),
69 ('LINEITEM_IDENT_VENDOR_NUMBER',
70 oils_i18n_gettext('LINEITEM_IDENT_VENDOR_NUMBER',
71 'Lineitem Identifier Fields (LIN/PIA) Use Vendor-Encoded ID Value When Available', 'aea', 'label')),
72 ('LINEITEM_REF_ID_ONLY',
73 oils_i18n_gettext('LINEITEM_REF_ID_ONLY',
74 'Lineitem Reference Feld (RFF) Uses Lineitem ID Only', 'aea', 'label'))
78 INSERT INTO acq.edi_attr_set (id, label) VALUES (1, 'Ingram Default');
79 INSERT INTO acq.edi_attr_set (id, label) VALUES (2, 'Baker & Taylor Default');
80 INSERT INTO acq.edi_attr_set (id, label) VALUES (3, 'Brodart Default');
81 INSERT INTO acq.edi_attr_set (id, label) VALUES (4, 'Midwest Tape Default');
82 INSERT INTO acq.edi_attr_set (id, label) VALUES (5, 'ULS Default');
83 INSERT INTO acq.edi_attr_set (id, label) VALUES (6, 'Recorded Books Default');
85 -- carve out space for mucho defaults
86 SELECT SETVAL('acq.edi_attr_set_id_seq'::TEXT, 1000);
88 INSERT INTO acq.edi_attr_set_map (attr_set, attr) VALUES
91 (1, 'INCLUDE_PO_NAME'),
92 (1, 'INCLUDE_COPIES'),
93 (1, 'INCLUDE_ITEM_TYPE'),
94 (1, 'INCLUDE_COLLECTION_CODE'),
95 (1, 'INCLUDE_OWNING_LIB'),
96 (1, 'INCLUDE_QUANTITY'),
97 (1, 'INCLUDE_BIB_PAGINATION'),
100 (2, 'INCLUDE_COPIES'),
101 (2, 'INCLUDE_ITEM_TYPE'),
102 (2, 'INCLUDE_COLLECTION_CODE'),
103 (2, 'INCLUDE_CALL_NUMBER'),
104 (2, 'INCLUDE_OWNING_LIB'),
105 (2, 'INCLUDE_QUANTITY'),
106 (2, 'INCLUDE_BIB_PAGINATION'),
107 (2, 'BUYER_ID_INCLUDE_VENDCODE'),
108 (2, 'INCLUDE_EMPTY_LI_NOTE'),
109 (2, 'INCLUDE_EMPTY_CALL_NUMBER'),
110 (2, 'INCLUDE_EMPTY_ITEM_TYPE'),
111 (2, 'INCLUDE_EMPTY_COLLECTION_CODE'),
112 (2, 'INCLUDE_EMPTY_LOCATION'),
113 (2, 'LINEITEM_IDENT_VENDOR_NUMBER'),
114 (2, 'LINEITEM_REF_ID_ONLY'),
117 (3, 'INCLUDE_COPIES'),
119 (3, 'INCLUDE_ITEM_TYPE'),
120 (3, 'INCLUDE_COLLECTION_CODE'),
121 (3, 'INCLUDE_OWNING_LIB'),
122 (3, 'INCLUDE_QUANTITY'),
123 (3, 'INCLUDE_BIB_PAGINATION'),
124 (3, 'COPY_SPEC_CODES'),
127 (4, 'INCLUDE_COPIES'),
129 (4, 'INCLUDE_OWNING_LIB'),
130 (4, 'INCLUDE_QUANTITY'),
131 (4, 'INCLUDE_BIB_PAGINATION'),
134 (5, 'INCLUDE_COPIES'),
135 (5, 'INCLUDE_ITEM_TYPE'),
136 (5, 'INCLUDE_COLLECTION_CODE'),
137 (5, 'INCLUDE_OWNING_LIB'),
138 (5, 'INCLUDE_QUANTITY'),
139 (5, 'INCLUDE_BIB_AUTHOR'),
140 (5, 'INCLUDE_BIB_EDITION'),
141 (5, 'INCLUDE_EMPTY_LI_NOTE'),
144 (6, 'INCLUDE_COPIES'),
145 (6, 'INCLUDE_ITEM_TYPE'),
146 (6, 'INCLUDE_COLLECTION_CODE'),
147 (6, 'INCLUDE_OWNING_LIB'),
148 (6, 'INCLUDE_QUANTITY'),
149 (6, 'INCLUDE_BIB_PAGINATION')