1Geiz9AC

1CREATE TABLE mml.test_custom_view (id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,CUSTOM_VIEW_TITLE VARCHAR(255),app_user_id INTEGER REFERENCES mml.test_app_user (id),CREATED_ON timestamp DEFAULT CURRENT_TIMESTAMP,LAST_UPDATED timestamp DEFAULT CURRENT_TIMESTAMP,SAP_PLANT VARCHAR(4),deleted BOOLEAN DEFAULT false);
2INSERT INTO mml.test_custom_view (SAP_PLANT,CUSTOM_VIEW_TITLE) VALUES ('2820','MRO Operations');
3INSERT INTO mml.test_custom_view (SAP_PLANT,CUSTOM_VIEW_TITLE) VALUES ('2820','Customer Service Representative');
4INSERT INTO mml.test_custom_view (SAP_PLANT,CUSTOM_VIEW_TITLE) VALUES ('2820','Engineering');
5INSERT INTO mml.test_custom_view (SAP_PLANT,CUSTOM_VIEW_TITLE) VALUES ('2820','Parts Planners');
6INSERT INTO mml.test_custom_view (SAP_PLANT,CUSTOM_VIEW_TITLE) VALUES ('2820','Outside Repair');
7INSERT INTO mml.test_custom_view (SAP_PLANT,CUSTOM_VIEW_TITLE) VALUES ('2820','Shipping');
8CREATE TABLE mml.test_custom_view_column (id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,bods_name VARCHAR(255) NOT NULL,CUSTOM_COLUMN_TITLE VARCHAR(255) NOT NULL,CUSTOM_COLUMN_DESCRIPTION VARCHAR(255) NOT NULL,CUSTOM_COLUMN_CATEGORY VARCHAR(255) NOT NULL,CUSTOM_COLUMN_FILTER VARCHAR(25) NOT NULL,CUSTOM_COLUMN_ORDER_ASCENDING BOOLEAN DEFAULT false NOT NULL,CUSTOM_COL_USER_SELECTABLE BOOLEAN DEFAULT true NOT NULL,LOCKED_COLUMN BOOLEAN DEFAULT false NOT NULL,deleted BOOLEAN DEFAULT false);
9INSERT INTO mml.test_custom_view_column (bods_name,LOCKED_COLUMN,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('FINAL_PRIORITY_SCORE',true,'Priority driven by the unit Status and Urgency. Units should always have credible ESDs and comments, especially High and Medium scores','PRI','Status and Delivery','');
10INSERT INTO mml.test_custom_view_column (bods_name,LOCKED_COLUMN,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MML_GATE_STATUS',true,'Visualization of the unit Gate compared to time elapsed toward target; This relationship is a strong driver of priority','GATE STATUS','Status and Delivery','');
11INSERT INTO mml.test_custom_view_column (bods_name,LOCKED_COLUMN,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SO_DELIV_PRIORITY_DESCR',true,'"Delivery Priority" from line 1000 of the SO. Apply Expedite, Critical, or AOG priority to units to reflect special circumstances','URG','Status and Delivery','');
12INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('TAT','Turn-Around Time, aka Net days in house (NDIH). Total TAT less the number of accrued hold days. Contractual performance','TAT','Status and Delivery','');
13INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('TOTAL_TAT','Total Turn-Around Time (TTAT), aka Days in House (DIH). Accrues every day the unit is in house. Customer''s perception of our performance.','DIH','Status and Delivery','');
14INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('PARTS_SHORTAGE_RISK_SW','Part Shortage risk indicator. Highlights whether a part shortage exists on the order or not with a severity based on the Scheduled date(s) vs Need date','PRT','Alerts','');
15INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('TECH_HOLD_RISK_SW','Engineering/Technical risk. Severity based on Planned finish date vs Need date','ENG','Alerts','');
16INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('OUTSIDE_REPAIR_RISK_SW','Outside Repair risk. Severity based on PO Delivery date(s) vs Need date','ORP','Alerts','');
17INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MML_OPEN_TASKS','All Open Tasks/Holds on the unit notification','OPEN TASKS','Alerts','');
18INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MML_LAST_COMMENT_TEXT','Most recent comment associated with the order. Users can input comments from the Alerts flyout or order details','COMMENTS','Alerts','');
19INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SCHED_SHIP_DATE','Estimated ship date published to our customers. Must be accurate at all times, especially for AOG/Critical/Expedite units. You can edit this date in the Order details screen','ESD','Dates','');
20INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CUST_NAME','Sold to customer name from service notification','CUSTOMER','Customer Details','');
21INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MATL_IN','Part Number for the order. aka material number. Taken from the notification for end units or WO for other order types','PART #','Part Details','');
22INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CATEG_DESCR','Job category description from service notification','JOB CAT','Order Details','');
23INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('NOTIF_NO','Service Notification Number. Management of Tasks / Holds, findings, etc. are done on the notification','SNO #','Order Details','');
24INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SO_NO','Sales Order Number. Customer contracts, pricing, etc. are done with the SO','SO #','Order Details','');
25INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CUST_PO','Customer Purchase Order Number from Service Notification','CUST PO','Customer Details','');
26INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('WO_NO','Work Order Number. Operational activities like ordering parts are done with the WO','WO #','Order Details','');
27INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SERIAL_OUT','Serial number from the notification or Device Data if serial number is blank','SERIAL #','Part Details','');
28INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('USER_STATUS','aka User Status. Selected in IW32 to show a specific step in the repair process and/or unit location','WO STAT','Status and Delivery','');
29INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('DIST','SAP Distribution Channel of order','DCH','Order Details','');
30INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CUST_REQUIRED_DATE','Req. deliv. date in the SO. Populated based on customer contract, PSA or negotiation; This date does not move when TAT stopping holds are applied.','CU REQ DATE','Dates','');
31INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('REVISED_DUE_DATE','Cust Req Date + SAP TAT hold days. Usually representative of your contractual obligation for penalty purposes but may not align with customer expectations','REV DUE DATE','Dates','');
32INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SALES_OFFICE','Code representing the administrator (aka CAR, CAM, CSR) assigned to order','SALES OFFICE','Area and People','');
33INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('TAIL_NO','Aircraft Tail Number from service notification','TAIL #','Customer Details','');
34INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('NET_VALUE','Official sales order price','NET VALUE','Sales, Cost and Labor','');
35INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SO_CURRENCY','Currency for sales order price','DOC CUR','Sales, Cost and Labor','');
36INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('DELIVERY_BLOCK','Code from the sales order delivery block','DEL BLOCK','Alerts','');
37INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MATL_DESCR','Part Description for the order. Taken from the material master based on the Part #','PART DESCRIPTION','Part Details','');
38INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('EDI_FLG','Indicator that this unit is matched to an Aeroxchange or other business-to-business electronic data interchange (EDI) that automates many customer transactions','EDI FLAG','Order Details','');
39INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('BILLING_BLOCK','Code from the sales order Billing block','BIL BLOCK','Alerts','');
40INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('BASIC_FIN_DATE','Work order Basic finish date. Can be used for internal operational commits','BASIC FIN DATE','Dates','');
41INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('WARRANTY_REQUEST_SW','Warranty Requested checkbox on service notification. Indicates that the customer has requested warranty','WAR REQ','Alerts','');
42INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('WORK_SCOPE','Workscope of the order from service notification. Indicates level of repair and is often linked to pricing','WORKSCOPE','Order Details','');
43INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CURR_OP','Last operation number where labor was confirmed (labor started and stopped)','CUR OP','Status and Delivery','');
44INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MODEL_NUMBER','Model number of end item','MODEL','Part Details','');
45INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CONT_CONDITION','Customer shipping container description from Service Notification','CONT COND','Order Details','');
46INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CONT_DETAILS','Customer shipping container additional details from Service Notification','CONT DETAILS','Order Details','');
47INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('WORK_ORDER_TYPE','Work Order Type such as ZM03, ZSUB, ZRTB, ZINT, ZING, XSUB, ZBLD, or ZCHD','WO TYPE','Order Details','');
48INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SHIPTO_NO','Ship to customer number from service notification','SHIP TO #','Customer Details','');
49INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MAIN_WORK_CENTER','Mn.wrk.ctr from the WO. Area within a plant where similar units are worked. Often also known as a “cell”','MN WRK CTR','Area and People','');
50INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('PLANT','Plant number where order resides. Also known as site','PLANT','Area and People','');
51INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('QMDAT','Notification date on service notification. Aka Dock date. Used as receipt date until returns delivery is created','SNO NOTIF DATE','Dates','');
52INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SNO_CREATE_DATE','Date the notification was created','SNO CREATED ON','Dates','');
53INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SHIPTO_NAME','Ship to customer name from service notification','SHIP TO NAME','Customer Details','');
54INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('KDAUF','Customer contract number from service notification','CONTRACT #','Customer Details','');
55INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('KDPOS','Customer contract item from service notification','CONTRACT ITEM','Customer Details','');
56INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ZSTATUS','Status/Work code from the notification. Indicates work to be performed and is linked to release note disposition','STATUS/WORK','Order Details','');
57INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('EST_QUOTE','Estimated Quote Value from service notification. Manually populated by the site on an order by order basis','EST QUOTE','Sales, Cost and Labor','');
58INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CATEGORY','Job category from service notification indicating the type of order','JOB CAT #','Order Details','');
59INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('AC_SERIAL','Aircraft Serial Number from service notification','AC SERIAL #','Customer Details','');
60INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('WO_CREATE_DATE','Date on which the work order was created. Not always the same as core receipt date.','WO CREATE DATE','Dates','');
61INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MATL_OUT','Outgoing part number from service notification (Uses Part # if blank)','PART # OUT','Part Details','');
62INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MIL_CONTRACT','Military Contract Number','MIL CONTRACT #','Customer Details','');
63INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('TECHNICAL_COMPLETION_DATE','Date on which the work order was TECO''d','WO TECO DATE','Dates','');
64INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('COST_DESIG','Cost designator from the work order header','COST DESIG','Sales, Cost and Labor','');
65INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CORE_RECEIPT_DATE','Date physical unit is received. Should be back-dated to be the same as the incoming customer airway bill','CORE RECEIPT DATE','Dates','');
66INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('PERCENT_OVERDUE','calculation relating Current turn-around time / Target turn-around time','% OD','Status and Delivery','');
67INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ELAPSED_TAT','Current Turn-around time versus Target Turn-around time','ELAPSED RATIO','Status and Delivery','');
68INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('GATE_DESCR','Gate Desc. Calculated to show, at a high level, where a unit is in the process','GATE DESCRIPTION','Status and Delivery','');
69INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('GATE_NO','Gate Number. Calculated to show, at a high level, where a unit is in the process','GATE #','Status and Delivery','');
70INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CHILD_ORDER_RISK_SW','Child (ZSUB) Risk. Severity based on ZSUB WO Basic Finish date(s) vs Need date','ZSUB','Alerts','');
71INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('OTHER_RISK_SW','Other Administrative risk. Severity based on Planned finish date(s) vs Need date','OTH','Alerts','');
72INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('WORKABILITY_OVERRIDE','Indicates the calculated workability of the unit based on risks present and any orderrides applied','WORKABILITY','Status and Delivery','');
73INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('GATE_DESCR_SHORT','Short gate description used in Status visualization','GATE DESC SHORT','Status and Delivery','');
74INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('DAYS_TIL_DUE','Days until the published ESD. If less than 0, shows 0','DAYS TIL ESD','Status and Delivery','');
75INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('PRFT_CNTR','Profit center from the SO header','SO PROFIT CTR','Sales, Cost and Labor','');
76INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('CLIN','Contract CLIN from the SO Line item','CLIN','Customer Details','');
77INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('DPAS','US Military DPAS rating from the SO Header','DPAS RATING','Status and Delivery','');
78INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ORD_QTY','Order Quantity','ORD QTY','Order Details','');
79INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ACQUI_VAL','Acquisition value of the unit from the additional data B tab in the SO header','ACQUISITION VALUE','Sales, Cost and Labor','');
80INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MML_QUOTE_HOLD_START','Date that the most recent Quote hold (QUOT) was added to the notification','QUOT START','Dates','');
81INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('MML_QUOTE_HOLD_END','Date that the most recent Quote hold (QUOT) on the notification was completed','QUOT END','Dates','');
82INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ENGINE_DESC','Engine type description from the service notification','ENGINE TYPE DESC','Part Details','');
83INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SALES_OFFICE_DESC','Name of the Customer Service Representative associated with the Sales Office code on the order','SALES OFFICE NAME','Area and People','');
84INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ORDER_USER_STATUS_DESC','Status/Work Description from the notification. Indicates work to be performed and is linked to release note disposition','STATUS/WORK DESC','Order Details','');
85INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('SHIP_DATE','Actual ship date of order. Uses TECO date for orders “shipped“ to inventory (like exchange cores) or scrap','SHIP DATE','Dates','');
86INSERT INTO mml.test_custom_view_column (bods_name,CUSTOM_COLUMN_DESCRIPTION,CUSTOM_COLUMN_TITLE,CUSTOM_COLUMN_CATEGORY,CUSTOM_COLUMN_FILTER) VALUES ('ASSET_NO','Asset# / Inv# from the service notification','ASSET #','Status and Delivery','');
87CREATE TABLE mml.test_custom_view_column_order (id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,CUSTOM_VIEW_ID INTEGER NOT NULL REFERENCES mml.test_custom_view (id),CUSTOM_VIEW_COLUMN_ID INTEGER NOT NULL REFERENCES mml.test_custom_view_column (id),deleted BOOLEAN DEFAULT false);
88INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,1);
89INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,1);
90INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,1);
91INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,1);
92INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,1);
93INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,1);
94INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,1);
95INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (8,1);
96INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,1);
97INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,1);
98INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,1);
99INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,1);
100INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,1);
101INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (14,1);
102INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,1);
103INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (16,1);
104INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (17,1);
105INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,1);
106INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (19,1);
107INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,1);
108INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (21,1);
109INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (22,1);
110INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (23,1);
111INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,2);
112INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,2);
113INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,2);
114INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,2);
115INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,2);
116INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,2);
117INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,2);
118INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (8,2);
119INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,2);
120INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (28,2);
121INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,2);
122INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,2);
123INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (24,2);
124INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,2);
125INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (16,2);
126INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (17,2);
127INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (25,2);
128INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (26,2);
129INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (27,2);
130INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,2);
131INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (14,2);
132INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,2);
133INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (21,2);
134INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (31,2);
135INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (30,2);
136INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,3);
137INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,3);
138INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,3);
139INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,3);
140INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,3);
141INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,3);
142INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,3);
143INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,3);
144INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,3);
145INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (33,3);
146INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,3);
147INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,3);
148INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (19,3);
149INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,3);
150INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,3);
151INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (34,3);
152INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (35,3);
153INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,3);
154INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (36,3);
155INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (14,3);
156INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,3);
157INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,4);
158INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,4);
159INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,4);
160INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,4);
161INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,4);
162INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,4);
163INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,4);
164INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,4);
165INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,4);
166INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,4);
167INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,4);
168INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,4);
169INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,4);
170INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,4);
171INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (32,4);
172INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,5);
173INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,5);
174INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,5);
175INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,5);
176INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,5);
177INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,5);
178INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,5);
179INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (8,5);
180INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,5);
181INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,5);
182INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,5);
183INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,5);
184INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,5);
185INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,5);
186INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,5);
187INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,5);
188INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (21,5);
189INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (26,5);
190INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,5);
191INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,6);
192INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,6);
193INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,6);
194INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,6);
195INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,6);
196INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,6);
197INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (28,6);
198INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,6);
199INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,6);
200INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (37,6);
201INSERT INTO mml.test_custom_view_column_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (38,6);
202CREATE TABLE mml.test_custom_view_filter (id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,CUSTOM_VIEW_ID INTEGER REFERENCES mml.test_custom_view (id),CUSTOM_VIEW_COLUMN_ID INTEGER REFERENCES mml.test_custom_view_column (id),CONDITION VARCHAR(255),deleted BOOLEAN DEFAULT false);
203INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,1);
204INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,1);
205INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,1);
206INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,1);
207INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,1);
208INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,1);
209INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,1);
210INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (8,1);
211INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,1);
212INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,1);
213INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,1);
214INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,1);
215INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,1);
216INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (14,1);
217INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,1);
218INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (16,1);
219INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (17,1);
220INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,1);
221INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (19,1);
222INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,1);
223INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (21,1);
224INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (22,1);
225INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (23,1);
226INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,2);
227INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,2);
228INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,2);
229INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,2);
230INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,2);
231INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,2);
232INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,2);
233INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (8,2);
234INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID,CONDITION) VALUES (9,2,'ADMN,ESDX,CRDT,CSTE,CUSG,CUST,EXCG,EXCH,PRIC,QHRC,QUOG,QUOT,RTQT,RTQR,ADM,CACT,ORDE,EDI');
235INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (28,2);
236INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,2);
237INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,2);
238INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (28,2);
239INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,2);
240INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (16,2);
241INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (17,2);
242INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (25,2);
243INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (26,2);
244INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (27,2);
245INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,2);
246INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (14,2);
247INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,2);
248INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (21,2);
249INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (31,2);
250INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (30,2);
251INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,3);
252INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,3);
253INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,3);
254INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,3);
255INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,3);
256INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,3);
257INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID,CONDITION) VALUES (9,3,'ENGE,ENGR,EVAL,MRBH,OEMP,QENG,RENG,SENG,PEVL');
258INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,3);
259INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,3);
260INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (33,3);
261INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,3);
262INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,3);
263INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (19,3);
264INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,3);
265INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,3);
266INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (34,3);
267INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (35,3);
268INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,3);
269INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (36,3);
270INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (14,3);
271INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,3);
272INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,4);
273INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,4);
274INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,4);
275INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,4);
276INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,4);
277INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID,CONDITION) VALUES (6,4,'1,2,3,10,20,30,11,12,21,22,31,32');
278INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,4);
279INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,4);
280INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,4);
281INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,4);
282INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,4);
283INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,4);
284INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,4);
285INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,4);
286INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (32,4);
287INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,5);
288INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (2,5);
289INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,5);
290INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,5);
291INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,5);
292INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (6,5);
293INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (7,5);
294INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID,CONDITION) VALUES (8,5,'1,2,3,10,20,30,11,12,21,22,31,32');
295INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,5);
296INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,5);
297INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,5);
298INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (12,5);
299INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (18,5);
300INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (15,5);
301INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (13,5);
302INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (29,5);
303INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (21,5);
304INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (26,5);
305INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (20,5);
306INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (1,6);
307INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID,CONDITION) VALUES (2,6,'4');
308INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (3,6);
309INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (4,6);
310INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (5,6);
311INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (9,6);
312INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (28,6);
313INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (10,6);
314INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (11,6);
315INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (37,6);
316INSERT INTO mml.test_custom_view_filter (CUSTOM_VIEW_COLUMN_ID,CUSTOM_VIEW_ID) VALUES (38,6);
317CREATE TABLE mml.test_custom_view_order (id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,CUSTOM_VIEW_ID INTEGER REFERENCES mml.test_custom_view (id),CUSTOM_VIEW_COLUMN_ID INTEGER REFERENCES mml.test_custom_view_column (id),CUSTOM_COLUMN_WIDTH INTEGER,CUSTOM_COLUMN_SORT VARCHAR(255),CUSTOM_VIEW_COLUMN_ORDER INTEGER,ASCENDING BOOLEAN DEFAULT false,deleted BOOLEAN DEFAULT false);
318INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (1,53,1,1);
319INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (2,106,1,2);
320INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (3,55,1,3);
321INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (4,60,1,4);
322INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (5,60,1,5);
323INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (6,55,1,6);
324INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (7,55,1,7);
325INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (8,55,1,8);
326INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (9,102,1,9);
327INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (10,230,1,10);
328INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (11,110,1,11);
329INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (12,250,1,12);
330INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (13,100,1,13);
331INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (14,130,1,14);
332INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (15,90,1,15);
333INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (16,75,1,16);
334INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (17,100,1,17);
335INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (18,85,1,18);
336INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (19,100,1,19);
337INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (20,95,1,20);
338INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (21,60,1,21);
339INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (22,110,1,22);
340INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (23,114,1,23);
341INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (73,90,1,24);
342INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (1,53,2,1);
343INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (2,106,2,2);
344INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (3,55,2,3);
345INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (4,60,2,4);
346INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (5,60,2,5);
347INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (6,55,2,6);
348INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (7,55,2,7);
349INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (8,55,2,8);
350INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (9,102,2,9);
351INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (28,90,2,10);
352INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (10,230,2,11);
353INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (11,110,2,12);
354INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (24,90,2,13);
355INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (12,250,2,14);
356INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (16,75,2,15);
357INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (17,100,2,16);
358INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (25,90,2,17);
359INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (26,90,2,18);
360INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (27,90,2,19);
361INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (13,100,2,20);
362INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (14,130,2,21);
363INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (29,270,2,22);
364INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (21,60,2,23);
365INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (31,90,2,24);
366INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (30,90,2,25);
367INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (72,90,2,26);
368INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (73,90,2,27);
369INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (1,53,3,1);
370INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (2,106,3,2);
371INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (3,55,3,3);
372INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (4,60,3,4);
373INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (5,60,3,5);
374INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (7,55,3,6);
375INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (9,102,3,7);
376INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (10,230,3,8);
377INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (11,110,3,9);
378INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (33,90,3,10);
379INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (15,90,3,11);
380INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (18,85,3,12);
381INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (19,100,3,13);
382INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (13,100,3,14);
383INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (29,270,3,15);
384INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (34,90,3,16);
385INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (35,90,3,17);
386INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (20,95,3,18);
387INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (36,90,3,19);
388INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (14,130,3,20);
389INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (12,250,3,21);
390INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (1,53,4,1);
391INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (2,106,4,2);
392INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (3,55,4,3);
393INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (4,60,4,4);
394INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (5,60,4,5);
395INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (6,55,4,6);
396INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (9,102,4,7);
397INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (10,230,4,8);
398INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (11,110,4,9);
399INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (18,85,4,10);
400INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (15,90,4,11);
401INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (13,100,4,12);
402INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (29,270,4,13);
403INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (20,95,4,14);
404INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (32,90,4,15);
405INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (73,90,4,16);
406INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (1,53,5,1);
407INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (2,106,5,2);
408INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (3,55,5,3);
409INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (4,60,5,4);
410INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (5,60,5,5);
411INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (6,55,5,6);
412INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (7,55,5,7);
413INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (8,55,5,8);
414INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (9,102,5,9);
415INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (10,230,5,10);
416INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (11,110,5,11);
417INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (12,250,5,12);
418INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (18,85,5,13);
419INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (15,90,5,14);
420INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (13,100,5,15);
421INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (29,270,5,16);
422INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (21,60,5,17);
423INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (26,90,5,18);
424INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (20,95,5,19);
425INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (1,53,6,1);
426INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (2,106,6,2);
427INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (3,55,6,3);
428INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (4,60,6,4);
429INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (5,60,6,5);
430INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (9,102,6,6);
431INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (28,90,6,7);
432INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (10,230,6,8);
433INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (11,110,6,9);
434INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (37,90,6,10);
435INSERT INTO mml.test_custom_view_order (CUSTOM_VIEW_COLUMN_ID,CUSTOM_COLUMN_WIDTH,CUSTOM_VIEW_ID,CUSTOM_VIEW_COLUMN_ORDER) VALUES (38,90,6,11);
436CREATE TABLE mml.test_custom_view_work_centers (id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,CUSTOM_VIEW_ID INT REFERENCES mml.test_custom_view (id),SAP_MAIN_WORK_CENTER VARCHAR(10),deleted BOOLEAN DEFAULT false);