Index: branches/b_6_207/IDS14_scr/lib/pl_standard.sql
===================================================================
diff -u -r255977 -r256576
--- branches/b_6_207/IDS14_scr/lib/pl_standard.sql	(.../pl_standard.sql)	(revision 255977)
+++ branches/b_6_207/IDS14_scr/lib/pl_standard.sql	(.../pl_standard.sql)	(revision 256576)
@@ -1,3 +1,4 @@
+-- 2024-06-25 - CRM - MSAPP-1980 Inventory Query - Add DC_ONLY to available query fields
 -- 2023-08-15 - CRM - MSAPP-1723 Remove D_E records from MS_ATTRIBUTE
 -- 2023-08-03 - CRM - MSAPP-1700 Add new columns to MS_ATTRIBUTE for CUSTOMER table for TAMS Email Info tab and Customer Domain integration
 --db_release
@@ -3755,6 +3756,7 @@
 INSERT INTO ms_attribute VALUES('jif','class_cd','Y','Y','Y','Class','1998-03-11 09:25:35','informix','2008-08-12 12:14:04','root','Class','Y','CHARACTER','');
 INSERT INTO ms_attribute VALUES('jif','co_id','Y','Y','Y','Company','1998-03-11 09:25:34','informix','2008-08-12 12:14:04','root','Co','N','SMALLINT','');
 INSERT INTO ms_attribute VALUES('jif','env_chg_id','Y','Y','Y','Environmental Charge ID','1998-03-11 09:25:34','informix','2008-08-12 12:14:04','root','Env Chg ID','Y','SMALLINT','');
+INSERT INTO ms_attribute VALUES('jif','dc_only','Y','Y','Y','DC Only','2024-06-25 09:36:37','informix',NULL,NULL,'DC Only','N',NULL,NULL);
 INSERT INTO ms_attribute VALUES('jif','jif_add_chg','Y','Y','Y','Additional Charge','1998-03-11 09:25:35','informix','2008-08-12 12:14:04','root','Add Chg','Y','DECIMAL','');
 INSERT INTO ms_attribute VALUES('jif','jif_add_chg_cd','Y','Y','Y','Additional Charge Code','1998-03-11 09:25:35','informix','2008-08-12 12:14:04','root','Add Chg Cd','Y','CHARACTER','');
 INSERT INTO ms_attribute VALUES('jif','jif_add_chg_flag','Y','Y','Y','Additional Charge. Flag','1998-03-11 09:25:35','informix','2008-08-12 12:14:04','root','Add Chg Flag','Y','SMALLINT','');
@@ -5220,6 +5222,7 @@
 INSERT INTO query_field VALUES ('SI', 'jif', 'jif_ytd_lst_sls_qt', 'N');
 INSERT INTO query_field VALUES ('SI', 'jif', 'jif_ytd_sls_frq', 'N');
 INSERT INTO query_field VALUES ('SI', 'jif', 'jif_ytd_tot_sls', 'N');
+INSERT INTO query_field VALUES ('SI', 'jif', 'dc_only', 'N');
 INSERT INTO query_field VALUES ('SI', 'jif_price', 'jif_price_avg_cst', 'Y');
 INSERT INTO query_field VALUES ('SI', 'jif_price', 'jif_price_blue', 'Y');
 INSERT INTO query_field VALUES ('SI', 'jif_price', 'jif_price_core_chg', 'Y');