>> >>showddl reptemp ; CREATE TABLE TRAFODION.OSSDBA.REPTEMP ( LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL ) ; --- SQL operation complete. >>showddl backlog_hdr; CREATE TABLE TRAFODION.OSSDBA.BACKLOG_HDR ( VERSION VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HASH VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , REF_DOCU_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOURCE VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , SALES_ORG VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , DISTRIB_CHANNEL VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SO_NO VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NO VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NO_KEY VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , NCRF_L2 VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NO_TYPE VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NAME VARCHAR(160 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_ORDER VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SIEBEL_CUST_ID VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SIEBEL_AGENT_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDERER_NAME VARCHAR(35 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDERER_REF VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDERER_TEL VARCHAR(16 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CONSOLIDATED_STATI VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_VIA_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DC_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_CONDITIONS VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CD_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CD06_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COMPLETE_DELIVERY VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INDIRECT_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_TYPE VARCHAR(8 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_REASON VARCHAR(5 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_TYPE_DESCR VARCHAR(25 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CLAIM_TYPE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PURCH_ORDER_TYPE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QUICKSHIP_CLASS VARCHAR(32 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ON_HOLD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FIELD_OWNED VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FACTORY_WAIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FACTORY_ACT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_ACK VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_BUILD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_SHIP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_OFFICE VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_GROUP VARCHAR(3 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRODUCT_LINES VARCHAR(150 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUSINESS_UNIT VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_FORCE VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COUNTRY_ID NUMERIC(18, 0) DEFAULT NULL , MAJOR_PL NUMERIC(18, 0) DEFAULT NULL , TOTAL_NET_VALUE NUMERIC(126, 0) DEFAULT NULL , TOTAL_NET_PRICE NUMERIC(126, 0) DEFAULT NULL , DLR_TOT_NET_PRICE NUMERIC(126, 0) DEFAULT NULL , NUM_DECIMAL NUMERIC(18, 0) DEFAULT NULL , CURRENCY VARCHAR(5 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRICING_STRUCTURE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CASH_DISCOUNT NUMERIC(126, 0) DEFAULT NULL , SPECIAL_CODES VARCHAR(32 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_COORD VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FACTORY_COORD VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PURCH_AGENT VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_1 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_2 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_3 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_4 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_5 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_6 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ATTN VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_PARTY VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ADDR_1 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ADDR_2 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ADDR_3 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ADDR_4 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ADDR_5 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ATTN VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_PARTY VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_ADDR_1 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_ADDR_2 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_ADDR_3 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_ADDR_4 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_ADDR_5 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HP_RECEIVE_DATE TIMESTAMP(0) DEFAULT NULL , HEART_VAL_DATE TIMESTAMP(0) DEFAULT NULL , ORDER_LOAD_DATE TIMESTAMP(0) DEFAULT NULL , CUSTOMER_REQ_DATE TIMESTAMP(0) DEFAULT NULL , OMS_CRD TIMESTAMP(0) DEFAULT NULL , PURCHASE_ORDER_NO VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PURCH_ORDER_DATE TIMESTAMP(0) DEFAULT NULL , PURCH_AGREE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , "PARTIAL" VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PROMISE_DATE TIMESTAMP(0) DEFAULT NULL , MPF NUMERIC(18, 0) DEFAULT NULL , SHIP_TO_WCC VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_ZONE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO VARCHAR(17 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_FAMILY_NO VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ITGN VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TYPE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_ENTRY_DATE TIMESTAMP(0) DEFAULT NULL , OP_RECEIVE_DATE TIMESTAMP(0) DEFAULT NULL , LOCAL_1 VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LOCAL_2 VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TICKLER_1 VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TICKLER_2 VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TERMS_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LANGUAGE_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PROJECT_CODE VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SYSTEM_HANDLE VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CA_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QUOTE_NO VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QUOTE_DATE TIMESTAMP(0) DEFAULT NULL , ORDER_CLASS VARCHAR(8 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_REP VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPORT_CONTACT VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPP_CONTACT_TEL VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OP_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , WAREHOUSE_INSTR VARCHAR(250 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DIVISION_INSTR VARCHAR(500 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ALIGNED_DELV VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELV_BLOCK_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELIVERY_BLOCK VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BILLING_BLOCK VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIGIN VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DATA_SOURCE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_STATUS VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_STATUS VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_CLOSE_DATE TIMESTAMP(0) DEFAULT NULL , MCC_ID VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MCC_DISC NUMERIC(126, 0) DEFAULT NULL , BILL_STAT VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BILL_STAT_DATE TIMESTAMP(0) DEFAULT NULL , TAX_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EID VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CSR_CODE VARCHAR(3 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FCSR_CODE VARCHAR(3 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SYSTEM_MANAGER VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SYS_MGR_PHONE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUSINESS_TEAM VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SRO VARCHAR(5 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CTCO_DATE TIMESTAMP(0) DEFAULT NULL , REPORTING_CODES VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OMS_COMMENT VARCHAR(250 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EV_NOT_CHANGE TIMESTAMP(0) DEFAULT NULL , SANDRO_CHANGE TIMESTAMP(0) DEFAULT NULL , LAST_UPDATE TIMESTAMP(0) DEFAULT NULL , LAST_CHECK TIMESTAMP(0) DEFAULT NULL , TEAM_ID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NAME_ID NUMERIC(18, 0) DEFAULT NULL , BIG_DEAL_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OPG_CODE VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_OVERALL_STATUS VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_STATUS VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_ENTRY_ORIGINATOR VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRESALES_ID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRESALES_SOURCE VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_SEGMENT VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INDUSTRY_VERTICAL VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CRS_IDS VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CID_COMPANY_ID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CLEAN_ORDER_DATE TIMESTAMP(0) DEFAULT NULL , COMPL_LANDED_DATE TIMESTAMP(0) DEFAULT NULL , TAX_VALUE NUMERIC(126, 0) DEFAULT NULL , FREIGHT_CHARGE NUMERIC(126, 0) DEFAULT NULL , U_CUSTOMER_NAME VARCHAR(160 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GTM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUSINESS_TYPE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_DESK_DATE TIMESTAMP(0) DEFAULT NULL , END_CUSTOMER_NO_KEY VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUSTOMER_SOLD_TO VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , RESELLER_ORDER VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OSS_LOAD_DATE TIMESTAMP(0) DEFAULT NULL , END_CUST_ADDR_NO NUMERIC(18, 0) DEFAULT NULL , E_CERTIFICATE_EMAIL VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , IS_VALID VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CLEAN_HDR_DATE TIMESTAMP(0) DEFAULT NULL , SO4 VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIGIN_ENTITY VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_PHONE VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_EMAIL VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_FAX VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_PHONE VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_EMAIL VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_FAX VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_PHONE VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_EMAIL VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_FAX VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_ATTN VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , WEB_ORDER_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , B2BIS_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ODESK_AGENT_ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ODESK_AGENT_NAME VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TELEW_AGENT_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TELEW_AGENT_NAME VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ASSISTED VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EV_NOT_EMAIL VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_WCC VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_REGION VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CONFIG_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CREDIT_APPROVAL_DATE TIMESTAMP(0) DEFAULT NULL , CORPORATE_SEG VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INDUSTRY_SEGMENT VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PROCUREMENT_AGENT VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INFLUENCER_ID1 VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INFLUENCER_ID2 VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_REGION VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CREDIT_STATUS VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EPRIME_USER VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TOTAL_OPEN_NET_PRICE NUMERIC(126, 0) DEFAULT NULL , DLR_TOT_OP_NET_PRICE NUMERIC(126, 0) DEFAULT NULL , CAREPACK_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CLAIM_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OM_REGION VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OFFER_ID VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SINGLE_INV_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EST_TAX NUMERIC(126, 0) DEFAULT NULL , PRICE_SOURCE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CHG_ORDER_RC VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUBMISSION_METHOD VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OM_SYSTEM VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SC_SYSTEM VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PROGRAM_TYPE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , NEAREST_ACTION_DATE TIMESTAMP(0) DEFAULT NULL , WORK_NOTE_ATTRIBS VARCHAR(500 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_INFORMED VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIGINATING_SYSTEM VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ADDRESS_OVERRIDE VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GVT_CONTRACT_NUMBER VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DOD_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , RFID_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYMENT_TERMS VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TAX_STATUS VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INCO_TERMS VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYMENT_TERMS_DESCR VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TAX_STATUS_DESCR VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SAL_NUMBER VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CORRELATION_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SIEBEL_INSTANCE_ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_WCC VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MSM VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_GROUP VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_CITY VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_TO_REGION VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PERSONAL_FIRST_NAME VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PERSONAL_LAST_NAME VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PERSONAL_EMAIL VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , WEB_ORDER_CREATION_DT TIMESTAMP(0) DEFAULT NULL , ACCOUNT_ID VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CAMPAIGN_CODE VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PARTNER_DIRECT_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PARTNER_AGENT_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FUNNEL_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ENGAGEMENT_MODEL VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TIER_1_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYMENT_METHOD VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LEGACY_ORDER_TYPE VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CATALOG_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_TAX_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_TAX_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_TAX_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_GRP_4 VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACCOUNT_NAME VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QUOTE_CREATION_DATE TIMESTAMP(0) DEFAULT NULL , SHIP_TO_TAX_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , RESELLER_TAX_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BANK_ZONE VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BANK_BRANCH VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHOW_PRICES VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BANK_LOAN NUMERIC(126, 0) DEFAULT NULL , OL_IDOC_NO VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYMENT_RECEIVE_DATE TIMESTAMP(0) DEFAULT NULL , CANCELED_BY VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COMMUNITY_ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CATALOG_NAME VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_APPROVER VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_SUB_SEGMENT VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYMENT_METHOD_DESCR VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CARD_ISSUER VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FULFILLMENT_SITE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SF_STATUS VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FRAUD_APPROVED_DATE TIMESTAMP(0) DEFAULT NULL , SALES_DISC NUMERIC(126, 0) DEFAULT NULL , ECOUPON_DISC NUMERIC(126, 0) DEFAULT NULL , CANCELATION_REASON VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DOC_LANGUAGE VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FULFILLMENT_SYSTEM VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , POINT_OF_SPLIT VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , AFFILIATE_ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COMMERCIALITY_CODE VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , WISMO VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , B2BGW_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TOTAL_PRICE NUMERIC(126, 0) DEFAULT NULL , DLR_TOTAL_PRICE NUMERIC(126, 0) DEFAULT NULL , DLR_TAX_VALUE NUMERIC(126, 0) DEFAULT NULL , PARTNER_REF NUMERIC(18, 0) DEFAULT NULL , HAD_ESCALATION_ACTIVITY VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , RESELLER_ADDR_NO NUMERIC(18, 0) DEFAULT NULL , EOP_ID NUMERIC(18, 0) DEFAULT NULL , ORIG_CUST_SHIP_TO_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIG_CUST_INV_TO_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIG_CUST_SOLD_TO_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIG_CUST_SUPPLIER_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIG_CUST_PAYER_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELIVERY_TYPE VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OPPORTUNITY_ID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , REBATE_REQUEST_ID VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DROPSHIP_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FORWARDER_ADDR_NO NUMERIC(18, 0) DEFAULT NULL , LSP_IDENTIFIER_COUNT NUMERIC(18, 0) DEFAULT NULL , CUSTOMER_INTENT_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HEART_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYER_ADDR_NO NUMERIC(18, 0) DEFAULT NULL , B2B_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CONTRACT_START_DATE TIMESTAMP(0) DEFAULT NULL , CONTRACT_END_DATE TIMESTAMP(0) DEFAULT NULL , SOLD_TO_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYER_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SAID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , RESELLER_ATTN_NO NUMERIC(18, 0) DEFAULT NULL , INFLUENCER_ADDR_NO NUMERIC(18, 0) DEFAULT NULL , PRIMARY KEY (LEGACY_ORDER_NO ASC) ) SALT USING 16 PARTITIONS HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY' ) ; CREATE INDEX BACKLOG_HDR_INDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( PURCHASE_ORDER_NO ASC , SOURCE ASC , ORDER_TYPE ASC , HP_RECEIVE_DATE ASC , DATA_SOURCE ASC ) ; CREATE INDEX BACKLOG_HDR_PAYER_ADDR_NO ON TRAFODION.OSSDBA.BACKLOG_HDR ( PAYER_ADDR_NO ASC ) ; CREATE INDEX BACKLOG_HDR_PROGTYPE_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( PROGRAM_TYPE ASC ) ; CREATE INDEX BACKLOG_HDR_RESELLER_ADDR_NO ON TRAFODION.OSSDBA.BACKLOG_HDR ( RESELLER_ADDR_NO ASC ) ; CREATE INDEX BACKLOG_HDR_SUBMETH_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( SUBMISSION_METHOD ASC ) ; CREATE INDEX BH_END_CUST_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( END_CUST_ORG_ID ASC ) ; CREATE INDEX BH_INV_TO_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( INV_TO_ORG_ID ASC ) ; CREATE INDEX BH_PAYER_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( PAYER_ORG_ID ASC ) ; CREATE INDEX BH_SHIP_TO_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( SHIP_TO_ORG_ID ASC ) ; CREATE INDEX BH_SOLD_TO_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_HDR ( SOLD_TO_ORG_ID ASC ) ; CREATE INDEX BLMON_HI5 ON TRAFODION.OSSDBA.BACKLOG_HDR ( PURCHASE_ORDER_NO ASC ) ; CREATE INDEX BLMON_HIX1 ON TRAFODION.OSSDBA.BACKLOG_HDR ( SO_NO ASC ) ; CREATE INDEX BLMON_HIX10 ON TRAFODION.OSSDBA.BACKLOG_HDR ( SALES_COORD ASC ) ; CREATE INDEX BLMON_HIX11 ON TRAFODION.OSSDBA.BACKLOG_HDR ( PURCH_AGREE ASC ) ; CREATE INDEX BLMON_HIX13 ON TRAFODION.OSSDBA.BACKLOG_HDR ( ORDER_NO ASC ) ; CREATE INDEX BLMON_HIX14 ON TRAFODION.OSSDBA.BACKLOG_HDR ( SALES_ORG ASC ) ; CREATE INDEX BLMON_HIX15 ON TRAFODION.OSSDBA.BACKLOG_HDR ( REF_DOCU_NO ASC ) ; CREATE INDEX BLMON_HIX16 ON TRAFODION.OSSDBA.BACKLOG_HDR ( DC_CODE ASC ) ; CREATE INDEX BLMON_HIX19 ON TRAFODION.OSSDBA.BACKLOG_HDR ( CUSTOMER_NO_KEY ASC ) ; CREATE INDEX BLMON_HIX2 ON TRAFODION.OSSDBA.BACKLOG_HDR ( LAST_UPDATE ASC ) ; CREATE INDEX BLMON_HIX20 ON TRAFODION.OSSDBA.BACKLOG_HDR ( HASH ASC ) ; CREATE INDEX BLMON_HIX21 ON TRAFODION.OSSDBA.BACKLOG_HDR ( EID ASC ) ; CREATE INDEX BLMON_HIX22 ON TRAFODION.OSSDBA.BACKLOG_HDR ( OPG_CODE ASC ) ; CREATE INDEX BLMON_HIX23 ON TRAFODION.OSSDBA.BACKLOG_HDR ( U_CUSTOMER_NAME ASC ) ; CREATE INDEX BLMON_HIX24 ON TRAFODION.OSSDBA.BACKLOG_HDR ( PURCH_ORDER_DATE ASC ) ; CREATE INDEX BLMON_HIX25 ON TRAFODION.OSSDBA.BACKLOG_HDR ( OSS_LOAD_DATE ASC ) ; CREATE INDEX BLMON_HIX26 ON TRAFODION.OSSDBA.BACKLOG_HDR ( TEAM_ID ASC ) ; CREATE INDEX BLMON_HIX27 ON TRAFODION.OSSDBA.BACKLOG_HDR ( B2BIS_ID ASC ) ; CREATE INDEX BLMON_HIX28 ON TRAFODION.OSSDBA.BACKLOG_HDR ( CLAIM_NO ASC ) ; CREATE INDEX BLMON_HIX29 ON TRAFODION.OSSDBA.BACKLOG_HDR ( BIG_DEAL_ID ASC ) ; CREATE INDEX BLMON_HIX3 ON TRAFODION.OSSDBA.BACKLOG_HDR ( LAST_CHECK ASC ) ; CREATE INDEX BLMON_HIX30 ON TRAFODION.OSSDBA.BACKLOG_HDR ( WEB_ORDER_NO ASC ) ; CREATE INDEX BLMON_HIX31 ON TRAFODION.OSSDBA.BACKLOG_HDR ( GVT_CONTRACT_NUMBER ASC ) ; CREATE INDEX BLMON_HIX32 ON TRAFODION.OSSDBA.BACKLOG_HDR ( DOD_FLAG ASC ) ; CREATE INDEX BLMON_HIX33 ON TRAFODION.OSSDBA.BACKLOG_HDR ( RFID_FLAG ASC ) ; CREATE INDEX BLMON_HIX34 ON TRAFODION.OSSDBA.BACKLOG_HDR ( SIEBEL_AGENT_ID ASC ) ; CREATE INDEX BLMON_HIX35 ON TRAFODION.OSSDBA.BACKLOG_HDR ( SAL_NUMBER ASC ) ; CREATE INDEX BLMON_HIX36 ON TRAFODION.OSSDBA.BACKLOG_HDR ( ORIGINATING_SYSTEM ASC ) ; CREATE INDEX BLMON_HIX37 ON TRAFODION.OSSDBA.BACKLOG_HDR ( COMMERCIALITY_CODE ASC ) ; CREATE INDEX BLMON_HIX38 ON TRAFODION.OSSDBA.BACKLOG_HDR ( CORRELATION_ID ASC ) ; CREATE INDEX BLMON_HIX4 ON TRAFODION.OSSDBA.BACKLOG_HDR ( CUSTOMER_NO ASC ) ; CREATE INDEX BLMON_HIX40 ON TRAFODION.OSSDBA.BACKLOG_HDR ( EOP_ID ASC ) ; CREATE INDEX BLMON_HIX41 ON TRAFODION.OSSDBA.BACKLOG_HDR ( B2BGW_ID ASC ) ; CREATE INDEX BLMON_HIX42 ON TRAFODION.OSSDBA.BACKLOG_HDR ( END_CUST_ADDR_NO ASC ) ; CREATE INDEX BLMON_HIX7 ON TRAFODION.OSSDBA.BACKLOG_HDR ( ORDER_TYPE_DESCR ASC ) ; CREATE INDEX BLMON_HIX8 ON TRAFODION.OSSDBA.BACKLOG_HDR ( QUOTE_NO ASC ) ; CREATE INDEX BLMON_HIX9 ON TRAFODION.OSSDBA.BACKLOG_HDR ( ORDER_LOAD_DATE ASC ) ; CREATE INDEX BLMON_HIX_DROPSHIPFLAG ON TRAFODION.OSSDBA.BACKLOG_HDR ( DROPSHIP_FLAG ASC ) ; CREATE INDEX BLMON_HIX_FORWARDERADDRNO ON TRAFODION.OSSDBA.BACKLOG_HDR ( FORWARDER_ADDR_NO ASC ) ; CREATE INDEX BLMON_HIX_REBATEREQUESTID ON TRAFODION.OSSDBA.BACKLOG_HDR ( REBATE_REQUEST_ID ASC ) ; CREATE INDEX INFLUENCER_ADDR_NO_IDX1 ON TRAFODION.OSSDBA.BACKLOG_HDR ( INFLUENCER_ADDR_NO ASC ) ; CREATE INDEX OPPORTUNITY_ID_IDX1 ON TRAFODION.OSSDBA.BACKLOG_HDR ( OPPORTUNITY_ID ASC ) ; CREATE INDEX RESELLER_ATTN_NO_IDX1 ON TRAFODION.OSSDBA.BACKLOG_HDR ( RESELLER_ATTN_NO ASC ) ; CREATE INDEX TEST1 ON TRAFODION.OSSDBA.BACKLOG_HDR ( ORDER_TYPE_DESCR ASC , HP_RECEIVE_DATE ASC ) ; CREATE INDEX TEST2 ON TRAFODION.OSSDBA.BACKLOG_HDR ( OM_SYSTEM ASC , ORDER_TYPE_DESCR ASC , ORDER_LOAD_DATE ASC ) ; CREATE INDEX TEST3 ON TRAFODION.OSSDBA.BACKLOG_HDR ( CUSTOMER_ORDER ASC , ORDER_ENTRY_DATE ASC ) ; CREATE INDEX TEST7 ON TRAFODION.OSSDBA.BACKLOG_HDR ( HP_RECEIVE_DATE ASC ) ; --- SQL operation complete. >>showddl end_customer_address_details; CREATE VIEW TRAFODION.OSSDBA.END_CUSTOMER_ADDRESS_DETAILS ("REFERENCE_NO", "NAME1", "NAME2", "NAME3", "NAME4", "STREET", "CITY", "POSTAL_CODE", "COUNTRY", "REGION", "TELEPHONE", "EMAIL_ADDRESS") AS SELECT DISTINCT A.REFERENCE_NO, A.NAME1, A.NAME2, A.NAME3, A.NAME4, A.STREET, A.CITY, A.POSTAL_CODE, A.COUNTRY, A.REGION, A.TELEPHONE, A.EMAIL_ADDRESS FROM TRAFODION.OSSDBA.BACKLOG_HDR H, TRAFODION.OSSDBA.ADDRESS_DETAILS A WHERE H.END_CUST_ADDR_NO = A.REFERENCE_NO ; --- SQL operation complete. >>showddl v_country; CREATE VIEW TRAFODION.OSSDBA.V_COUNTRY ("COUNTRY_NAME", "ISO_CODE", "HP_CODE", "REGION", "SUBREGION", "IN_BACKLOG_SHIP", "ISO3_CODE", "HP_REGION") AS SELECT TRAFODION.OSSDBA.COUNTRY.COUNTRY_NAME, TRAFODION.OSSDBA.COUNTRY.ISO_CODE, TRAFODION.OSSDBA.COUNTRY.HP_CODE, TRAFODION.OSSDBA.COUNTRY.REGION, TRAFODION.OSSDBA.COUNTRY.SUBREGION, TRAFODION.OSSDBA.COUNTRY.IN_BACKLOG_SHIP, TRAFODION.OSSDBA.COUNTRY.ISO3_CODE, TRAFODION.OSSDBA.COUNTRY.HP_REGION FROM TRAFODION.OSSDBA.COUNTRY ; --- SQL operation complete. >>showddl backlog_item; CREATE TABLE TRAFODION.OSSDBA.BACKLOG_ITEM ( DELIVERY_GROUP VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , ITEM_SOURCE VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SYSTEM VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FACT_DELV_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_DELV_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIPMENT_NO VARCHAR(35 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FACT_BOL_NO VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_BOL_NO VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SO_NO VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ITEM_SLN VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , SO_ITEM_NO VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ITEM_SUBITEM VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HIGHER_LEVEL VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MERGING_GROUP VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SO_LINE_ITEM_QTY NUMERIC(18, 0) DEFAULT NULL , SCHED_LINE_QTY NUMERIC(18, 0) DEFAULT NULL , SCHED_LINE_NO VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , ENTRY_KEY VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MATERIAL_NO VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRODUCT_DESCR VARCHAR(240 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MATERIAL_TYPE VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_PRODUCT_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUNDLE_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HL_BUNDLE_ID VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MODEL_ID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CONFIG_ID VARCHAR(22 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , UPC_NO VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPP_PROD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QUICKSHIP_CLASS VARCHAR(32 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QS_CLASS_PRIO NUMERIC(18, 0) DEFAULT NULL , GOAL_FCT NUMERIC(18, 0) DEFAULT NULL , PROD_HIERARCHY VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELIVERY_PRIO VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , IPT NUMERIC(18, 0) DEFAULT NULL , NET_VALUE NUMERIC(126, 0) DEFAULT NULL , NET_PRICE NUMERIC(126, 0) DEFAULT NULL , DLR_NET_PRICE NUMERIC(126, 0) DEFAULT NULL , BUNDLE_PRICE NUMERIC(126, 0) DEFAULT NULL , BUNDLE_DLR_PRICE NUMERIC(126, 0) DEFAULT NULL , CURRENCY VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , STATI VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , STATUS VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PARTIAL_ALLOWED VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GROUPED_DELIVERY VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EXT_SDD_DATE TIMESTAMP(0) DEFAULT NULL , EXT_SDD_COMMENT VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ON_HOLD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FIELD_OWNED VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FACTORY_WAIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FACTORY_ACT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_ACK VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_BUILD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_SHIP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ROUTE VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_FORCE VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRODUCT_LINE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUSINESS_UNIT VARCHAR(5 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EARL_ARR_DATE TIMESTAMP(0) DEFAULT NULL , EAD_STT TIMESTAMP(0) DEFAULT NULL , LATEST_ARR_DATE TIMESTAMP(0) DEFAULT NULL , LAD_STT TIMESTAMP(0) DEFAULT NULL , FIRST_TBA_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_TBA_SENT TIMESTAMP(0) DEFAULT NULL , FIRST_ACK_NONTBA TIMESTAMP(0) DEFAULT NULL , FIACK_NONTBA_SENT TIMESTAMP(0) DEFAULT NULL , LACK_TBA_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_ACK_DATE TIMESTAMP(0) DEFAULT NULL , LAST_ACK_SENT TIMESTAMP(0) DEFAULT NULL , LAST_ACK_REASON VARCHAR(72 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , L_ACK_REASON_TEXT VARCHAR(1000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PLO_START_DATE TIMESTAMP(0) DEFAULT NULL , MAT_AVAIL_DATE TIMESTAMP(0) DEFAULT NULL , NR_REACKS NUMERIC(18, 0) DEFAULT NULL , NR_NONTBA_REACKS NUMERIC(18, 0) DEFAULT NULL , LAST_CHANGE_ORDER TIMESTAMP(0) DEFAULT NULL , CUSTOMER_REQ_DATE TIMESTAMP(0) DEFAULT NULL , ASAP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CURRENT_FCT NUMERIC(18, 0) DEFAULT NULL , LAST_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_HEART_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_PO_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_SAP_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_PO_RC_USER VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_SAP_RC_USER VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_ROOT_MATERIAL VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ROOT_MATERIAL_PL VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_PI_PO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OTD_VIOLATION_FPO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , KPL_STATUS VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , KPL_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , WARRANTY_CODE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_ACTUAL TIMESTAMP(0) DEFAULT NULL , BT_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , BT_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , BT_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_LAD_OPT TIMESTAMP(0) DEFAULT NULL , BT_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , BT_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_FACK_OPT TIMESTAMP(0) DEFAULT NULL , BT_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , BT_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_LACK_OPT TIMESTAMP(0) DEFAULT NULL , BT_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , BT_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_ACTUAL TIMESTAMP(0) DEFAULT NULL , PD_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , PD_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , PD_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_LAD_OPT TIMESTAMP(0) DEFAULT NULL , PD_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , PD_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_FACK_OPT TIMESTAMP(0) DEFAULT NULL , PD_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , PD_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_LACK_OPT TIMESTAMP(0) DEFAULT NULL , PD_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , PD_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , DG_ACTUAL TIMESTAMP(0) DEFAULT NULL , PGI_ACTUAL TIMESTAMP(0) DEFAULT NULL , PLANNED_PGI_DATE TIMESTAMP(0) DEFAULT NULL , ERCV_ACTUAL TIMESTAMP(0) DEFAULT NULL , ESHP_ACTUAL TIMESTAMP(0) DEFAULT NULL , POD_ACTUAL TIMESTAMP(0) DEFAULT NULL , INVO_ACTUAL TIMESTAMP(0) DEFAULT NULL , DELIVERY_BLOCK VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_UPDATE TIMESTAMP(0) DEFAULT NULL , CREDIT_STATUS VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PLANT_CODE VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_FROM VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIPMENT_HOLD VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OPEN_QTY NUMERIC(18, 0) DEFAULT NULL , SHIPPED_QTY NUMERIC(18, 0) DEFAULT NULL , BIG_DEAL_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_ITEM_NO VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FDA_ACTUAL TIMESTAMP(0) DEFAULT NULL , CANCELED_AT TIMESTAMP(0) DEFAULT NULL , CANCEL_TYPE VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SAP_DELV_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , IS_VALID VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_ORG VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER_SDD TIMESTAMP(0) DEFAULT NULL , CLEAN_DATE TIMESTAMP(0) DEFAULT NULL , RESELLER_ORDER VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NO VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PURCH_ORDER_DATE TIMESTAMP(0) DEFAULT NULL , BUNDLE_NAME VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUNDLE_DESCR VARCHAR(120 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRICING_BUNDLE_ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRICING_BUNDLE_NAME VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CAREPACK_ITEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , AUTOREG_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , REG_CONTACT_ADD_NO NUMERIC(18, 0) DEFAULT NULL , INVOICE_ITEM_NO VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TAX_AMOUNT NUMERIC(126, 0) DEFAULT NULL , TAXABLE_AMOUNT NUMERIC(126, 0) DEFAULT NULL , HIDDEN_ACK_DATE TIMESTAMP(0) DEFAULT NULL , ACK_DATE_HIS VARCHAR(4000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SDD_HIS VARCHAR(4000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER_SDD_HIS VARCHAR(4000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SSD_HIS VARCHAR(4000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , NUM_OF_ACKS NUMERIC(18, 0) DEFAULT NULL , NUM_OF_HIDDEN_ACKS NUMERIC(18, 0) DEFAULT NULL , NUM_OF_SDDS NUMERIC(18, 0) DEFAULT NULL , NUM_OF_SSDS NUMERIC(18, 0) DEFAULT NULL , EXT_SSD_DATE TIMESTAMP(0) DEFAULT NULL , HIDDEN_ACK_DATE_HIS VARCHAR(4000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FULL_INVOICE_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRICE_SOURCE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BENCH_HOLD_RC VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACK_DATE_COMMENT VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MATERIAL_CAT VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GATP_ACK TIMESTAMP(0) DEFAULT NULL , GATP_ACK_SENT TIMESTAMP(0) DEFAULT NULL , EXT_SUP_ACK TIMESTAMP(0) DEFAULT NULL , EXT_SUP_ACK_SENT TIMESTAMP(0) DEFAULT NULL , STORAGE_LOCATION VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYMENT_TERMS VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TAX_STATUS VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INCO_TERMS VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COMPLEX_IN TIMESTAMP(0) DEFAULT NULL , COMPLEX_OUT TIMESTAMP(0) DEFAULT NULL , PAYMENT_TERMS_DESCR VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TAX_STATUS_DESCR VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MFG_PART_NUMBER VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_SLA VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PENALTY_FLAG VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GPLS_LINE_ASSOC VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SPEZ_SERVICE_LINE_ASSOC VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EXT_MAT_GROUP VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LOGISTICS_CODES VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OFSC_NAME VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OFSC_PHONE VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , APO_HL_ITEM_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BACKORDERED_QTY NUMERIC(18, 0) DEFAULT NULL , HUB_DELV_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HW2CP_ASSOC VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CTO_ID VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CAMPAIGN_CODE VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADD_NO NUMERIC(18, 0) DEFAULT NULL , CATALOG_ID VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COMMISSION_AMOUNT NUMERIC(126, 0) DEFAULT NULL , COMMISSION_RAT NUMERIC(126, 0) DEFAULT NULL , PRICE_REF_1 NUMERIC(126, 0) DEFAULT NULL , PRICE_REF_2 NUMERIC(126, 0) DEFAULT NULL , PRICE_REF_3 NUMERIC(126, 0) DEFAULT NULL , PRICE_REF_4 NUMERIC(126, 0) DEFAULT NULL , SHOW_PRICES VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SAP_DELV_GRP VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_FACING_ITEM VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ETA NUMERIC(18, 0) DEFAULT NULL , LEAD_TIME NUMERIC(18, 0) DEFAULT NULL , AVAILABILITY_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_LINE_PRICE NUMERIC(126, 0) DEFAULT NULL , INV_DLR_LINE_PRICE NUMERIC(126, 0) DEFAULT NULL , INV_UNIT_PRICE NUMERIC(126, 0) DEFAULT NULL , MASTER_CONTRACT_ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ITEM_CATEGORY VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_DLR_UNIT_PRICE NUMERIC(126, 0) DEFAULT NULL , MANUAL_ACK_USED VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PARTNER_REF NUMERIC(18, 0) DEFAULT NULL , GTIN13_NO VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , TELCO_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CONFIG_UID VARCHAR(14 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COO_EXCLUSION_FLAG VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HAS_POA_PROBLEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HAS_POR_PROBLEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HAS_OSR_PROBLEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HAS_ASN_PROBLEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HAS_SBN_PROBLEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HAS_INV_PROBLEM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EOP_ITEM_NO NUMERIC(18, 0) DEFAULT NULL , SHIP_TO_ID VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , NUM_OF_SUPPLIER_SDDS NUMERIC(18, 0) DEFAULT NULL , SCHEDULED_SHIP_DATE TIMESTAMP(0) DEFAULT NULL , SCHEDULED_DELIVERY_DATE TIMESTAMP(0) DEFAULT NULL , SOFT_COMMIT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SC_COMMIT_SOURCE VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SC_COMMIT_DATE TIMESTAMP(0) DEFAULT NULL , SC_COMMIT_HIS VARCHAR(4000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SC_COMMIT_SENT TIMESTAMP(0) DEFAULT NULL , NUM_OF_SC_COMMIT NUMERIC(18, 0) DEFAULT NULL , DELIVERY_STATUS VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ISLOGISTICALSKU VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LSP_NAME VARCHAR(255 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FF_PO_NO VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CPB VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CANCELLATION_REASON VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_FROM_ORIG VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER_ORIG VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PLANT_CODE_ORIG VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , REL2FF_DATE TIMESTAMP(0) DEFAULT NULL , B2B_FLAG VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_FROM_MFGSO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER_MFGSO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PLANT_CODE_MFGSO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , VENDOR_PO_ORG_SO VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ROUTE_ORIG VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SYSTEM_MFGSO VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SO_ITEM_NO_MFGSO VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SO_NO_MFGSO VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_NO_MFGSO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ENTITLEMENT_ID VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BILLING_PLAN VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_PRICE_DATE TIMESTAMP(0) DEFAULT NULL , BILLING_COMPLETE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRIMARY KEY (LEGACY_ORDER_NO ASC, ITEM_SLN ASC) ) SALT USING 16 PARTITIONS HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY' ) ; CREATE INDEX BACKLOG_ITEM_FF_PO_NO_IDX ON TRAFODION.OSSDBA.BACKLOG_ITEM ( FF_PO_NO ASC ) ; CREATE INDEX BACKLOG_ITEM_INVOICE_NO_IDX ON TRAFODION.OSSDBA.BACKLOG_ITEM ( INVOICE_NO ASC ) ; CREATE INDEX BACKLOG_ITEM_PLANT_MFG_SO_IDX ON TRAFODION.OSSDBA.BACKLOG_ITEM ( PLANT_CODE_MFGSO ASC ) ; CREATE INDEX BACKLOG_ITEM_SUPP_MFG_SO_IDX ON TRAFODION.OSSDBA.BACKLOG_ITEM ( SUPPLIER_MFGSO ASC ) ; CREATE INDEX BACKLOG_ITEM_VEN_PO_ORG_SO_IDX ON TRAFODION.OSSDBA.BACKLOG_ITEM ( VENDOR_PO_ORG_SO ASC ) ; CREATE INDEX BLMON_IIX1 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( SO_NO ASC ) ; CREATE INDEX BLMON_IIX10 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( ESHP_ACTUAL ASC ) ; CREATE INDEX BLMON_IIX11 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( CUST_PRODUCT_NO ASC ) ; CREATE INDEX BLMON_IIX12 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( MASTER_CONTRACT_ID ASC ) ; CREATE INDEX BLMON_IIX2 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( DELIVERY_GROUP ASC ) ; CREATE INDEX BLMON_IIX3 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( LEGACY_ORDER_NO ASC ) ; CREATE INDEX BLMON_IIX5 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( MATERIAL_NO ASC ) ; CREATE INDEX BLMON_IIX7 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( BIG_DEAL_ID ASC ) ; CREATE INDEX BLMON_IIX8 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( CUSTOMER_NO ASC ) ; CREATE INDEX BLMON_IIX9 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( PURCH_ORDER_DATE ASC ) ; CREATE INDEX BLMON_IIX_ISVALID ON TRAFODION.OSSDBA.BACKLOG_ITEM ( IS_VALID ASC ) ; CREATE INDEX BLMON_IIX_PL ON TRAFODION.OSSDBA.BACKLOG_ITEM ( PRODUCT_LINE ASC ) ; CREATE INDEX BLMON_IIX_PLANT_CODE ON TRAFODION.OSSDBA.BACKLOG_ITEM ( PLANT_CODE ASC ) ; CREATE INDEX BLMON_IIX_SHIP_FROM ON TRAFODION.OSSDBA.BACKLOG_ITEM ( SHIP_FROM ASC ) ; CREATE INDEX BLMON_IIX_SHIP_FROM_MFGSO ON TRAFODION.OSSDBA.BACKLOG_ITEM ( SHIP_FROM_MFGSO ASC ) ; CREATE INDEX TEST10 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( LEGACY_ORDER_NO ASC , ITEM_SUBITEM ASC ) ; CREATE INDEX TEST4 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( LEGACY_ORDER_NO ASC , SHIPMENT_NO ASC ) ; CREATE INDEX TEST5 ON TRAFODION.OSSDBA.BACKLOG_ITEM ( PRODUCT_LINE ASC , IS_VALID ASC ) ; --- SQL operation complete. >>showddl detail_techinfo; CREATE TABLE TRAFODION.OSSDBA.DETAIL_TECHINFO ( DELIVERY_GROUP VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , ITEM_SUBITEM VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SERIAL_NUMBER VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ASSET_TAG VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRIMARY_MAC_ADDR VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , "UUID" VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DEAL_ID VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SYSTEM_INFO VARCHAR(3000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BOX_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , IMEI VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL ) STORE BY (DELIVERY_GROUP ASC) SALT USING 16 PARTITIONS HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY' ) ; CREATE INDEX DETAIL_TECHINFO_ASSET_TAG_IDX ON TRAFODION.OSSDBA.DETAIL_TECHINFO ( ASSET_TAG ASC , DELIVERY_GROUP ASC ) ; CREATE INDEX DTECHINF_IX1 ON TRAFODION.OSSDBA.DETAIL_TECHINFO ( DELIVERY_GROUP ASC , DELIVERY_GROUP ASC ) ; CREATE INDEX DTECHINF_IX2 ON TRAFODION.OSSDBA.DETAIL_TECHINFO ( SERIAL_NUMBER ASC , DELIVERY_GROUP ASC ) ; CREATE INDEX DTECHINF_IX3 ON TRAFODION.OSSDBA.DETAIL_TECHINFO ( IMEI ASC , DELIVERY_GROUP ASC ) ; --- SQL operation complete. >>showddl pl_dim; CREATE TABLE TRAFODION.OSSDBA.PL_DIM ( GROUP_NAME VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GROUP_NAME_ID VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GROUP_NAME_SHORT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GROUP_CODE VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , GROUP_CODE_ID VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CATEGORY_NAME VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CATEGORY_ID VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CATEGORY_SHORT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LINE VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , LINE_NAME VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRIO NUMERIC(18, 0) DEFAULT NULL , PRIMARY KEY (LINE ASC) ) SALT USING 16 PARTITIONS ; --- SQL operation complete. >>showddl backlog_ids; CREATE TABLE TRAFODION.OSSDBA.BACKLOG_IDS ( LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , CUSTOMER_ORDER VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHOW_EXTERN VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_NO_KEY VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUSTOMER_BASE_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PURCH_AGREE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_L1 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_L2 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_L3 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_L4 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_L1 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_L2 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_L3 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_L4 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_L1 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_L2 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_L3 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_L4 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUSTOMER_NO_KEY VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUSTOMER_SOLD_TO VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_SOLD_TO_L1 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_SOLD_TO_L2 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_SOLD_TO_L3 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_SOLD_TO_L4 VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SALES_ORG VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PORTAL_USERID VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SOLD_TO_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INV_TO_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PAYER_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , END_CUST_ORG_ID VARCHAR(18 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL ) STORE BY (LEGACY_ORDER_NO ASC) SALT USING 16 PARTITIONS ; CREATE INDEX BACKIDS_IX1 ON TRAFODION.OSSDBA.BACKLOG_IDS ( LEGACY_ORDER_NO ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX10 ON TRAFODION.OSSDBA.BACKLOG_IDS ( SHIP_TO_L4 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX11 ON TRAFODION.OSSDBA.BACKLOG_IDS ( INV_TO_L2 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX12 ON TRAFODION.OSSDBA.BACKLOG_IDS ( INV_TO_L4 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX13 ON TRAFODION.OSSDBA.BACKLOG_IDS ( CUSTOMER_NO_KEY ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX17 ON TRAFODION.OSSDBA.BACKLOG_IDS ( END_CUSTOMER_NO_KEY ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX18 ON TRAFODION.OSSDBA.BACKLOG_IDS ( END_CUSTOMER_SOLD_TO ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX19 ON TRAFODION.OSSDBA.BACKLOG_IDS ( END_CUST_SOLD_TO_L2 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX2 ON TRAFODION.OSSDBA.BACKLOG_IDS ( CUSTOMER_BASE_NO ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX20 ON TRAFODION.OSSDBA.BACKLOG_IDS ( END_CUST_SOLD_TO_L4 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX21 ON TRAFODION.OSSDBA.BACKLOG_IDS ( PORTAL_USERID ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX4 ON TRAFODION.OSSDBA.BACKLOG_IDS ( SOLD_TO ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX5 ON TRAFODION.OSSDBA.BACKLOG_IDS ( SHIP_TO ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX6 ON TRAFODION.OSSDBA.BACKLOG_IDS ( INV_TO ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX7 ON TRAFODION.OSSDBA.BACKLOG_IDS ( SOLD_TO_L2 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX8 ON TRAFODION.OSSDBA.BACKLOG_IDS ( SOLD_TO_L4 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BACKIDS_IX9 ON TRAFODION.OSSDBA.BACKLOG_IDS ( SHIP_TO_L2 ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BIDS_END_CUST_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_IDS ( END_CUST_ORG_ID ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BIDS_INV_TO_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_IDS ( INV_TO_ORG_ID ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BIDS_PAYER_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_IDS ( PAYER_ORG_ID ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BIDS_SHIP_TO_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_IDS ( SHIP_TO_ORG_ID ASC , LEGACY_ORDER_NO ASC ) ; CREATE INDEX BIDS_SOLD_TO_ORG_ID_IDX ON TRAFODION.OSSDBA.BACKLOG_IDS ( SOLD_TO_ORG_ID ASC , LEGACY_ORDER_NO ASC ) ; --- SQL operation complete. >>showddl ship_ncrf_l2; CREATE VIEW TRAFODION.OSSDBA.SHIP_NCRF_L2 ("ID", "NAME") AS SELECT L.ID, L.NAME FROM TRAFODION.OSSDBA.NCRF_LEVELS L WHERE L.NLEVEL = '2' ; --- SQL operation complete. >>showddl backlog_ship,; *** ERROR[15001] A syntax error occurred at or before: showddl backlog_ship,; ^ (29 characters from start of SQL statement) *** ERROR[8822] The statement was not prepared. >>showddl country,; *** ERROR[15001] A syntax error occurred at or before: showddl country,; ^ (24 characters from start of SQL statement) *** ERROR[8822] The statement was not prepared. >>showddl backlog_delv; CREATE TABLE TRAFODION.OSSDBA.BACKLOG_DELV ( LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , SOURCE VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , SALES_ORG VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , DELIVERY_GROUP VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , SHIPMENT_GROUP VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIPMENT_NO VARCHAR(35 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ALT_SHIPMENT_NO VARCHAR(35 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , REF_SHIPMENT_NO VARCHAR(35 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO VARCHAR(17 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_FROM VARCHAR(17 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FACT_DELV_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_DELV_NO VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FACT_BOL_NO VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUST_BOL_NO VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SO_NO VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MERGING_GROUP VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELIVERY_PRIO VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ASAP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRODUCT_LINES VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUSINESS_UNIT VARCHAR(5 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , NET_VALUE NUMERIC(126, 0) DEFAULT NULL , NET_PRICE NUMERIC(126, 0) DEFAULT NULL , DLR_NET_PRICE NUMERIC(126, 0) DEFAULT NULL , CURRENCY VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , INVOICE_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ID_CODE VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , STATUS VARCHAR(16 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_STATUS VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELIVERY_STATUS VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , STATUS_REF_TIME TIMESTAMP(0) DEFAULT NULL , USER_STATI VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QUICKSHIP_CLASS VARCHAR(32 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , QS_CLASS_PRIO NUMERIC(18, 0) DEFAULT NULL , GOAL_FCT NUMERIC(18, 0) DEFAULT NULL , CURRENT_FCT NUMERIC(18, 0) DEFAULT NULL , IPT NUMERIC(18, 0) DEFAULT NULL , LAST_PROBLEM VARCHAR(16 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ON_HOLD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CUM_HOLD_TIME NUMERIC(18, 0) DEFAULT NULL , ON_HOLD_SINCE TIMESTAMP(0) DEFAULT NULL , HOLD_FIELD_OWNED VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FACTORY_WAIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , HOLD_FACTORY_ACT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIPMENT_HOLD VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DELIVERY_BLOCK VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_ACK VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_BUILD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PREVENTS_SHIP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , CAP_CONSTRAINT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , MAT_CONSTRAINT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SPECIAL_CODES VARCHAR(32 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_1 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_2 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_3 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_4 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_5 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ADDR_6 VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_ATTN VARCHAR(220 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_WCC VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_ZONE VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORDER_LOAD_DATE TIMESTAMP(0) DEFAULT NULL , CUSTOMER_REQ_DATE TIMESTAMP(0) DEFAULT NULL , HP_RECEIVE_DATE TIMESTAMP(0) DEFAULT NULL , NR_PUSH_OUTS NUMERIC(18, 0) DEFAULT NULL , NR_PULL_INS NUMERIC(18, 0) DEFAULT NULL , LAST_CO_REASON VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_CHANGE_ORDER TIMESTAMP(0) DEFAULT NULL , HEART_VAL_DATE TIMESTAMP(0) DEFAULT NULL , PLO_START_DATE TIMESTAMP(0) DEFAULT NULL , MAT_AVAIL_DATE TIMESTAMP(0) DEFAULT NULL , GOAL_SHIP_DATE TIMESTAMP(0) DEFAULT NULL , PLANNED_PGI_DATE TIMESTAMP(0) DEFAULT NULL , LAST_REACK_REASON VARCHAR(16 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_TBA_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_TBA_SENT TIMESTAMP(0) DEFAULT NULL , FIRST_ACK_NONTBA TIMESTAMP(0) DEFAULT NULL , FIACK_NONTBA_SENT TIMESTAMP(0) DEFAULT NULL , LACK_TBA_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_ACK_DATE TIMESTAMP(0) DEFAULT NULL , LAST_ACK_SENT TIMESTAMP(0) DEFAULT NULL , LAST_ACK_REASON VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ORIG_SCHED_DELV_DT TIMESTAMP(0) DEFAULT NULL , SCHED_DELV_DATE TIMESTAMP(0) DEFAULT NULL , TBA_FLAG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SDD_COMMENT VARCHAR(60 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EARL_ARR_DATE TIMESTAMP(0) DEFAULT NULL , EAD_STT TIMESTAMP(0) DEFAULT NULL , LATEST_ARR_DATE TIMESTAMP(0) DEFAULT NULL , LAD_STT TIMESTAMP(0) DEFAULT NULL , NR_REACKS NUMERIC(18, 0) DEFAULT NULL , NR_NONTBA_REACKS NUMERIC(18, 0) DEFAULT NULL , LAST_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_HEART_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_PO_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_SAP_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FIRST_PO_RC_USER VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_SAP_RC_USER VARCHAR(12 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_ROOT_MATERIAL VARCHAR(20 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ROOT_MATERIAL_PL VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , LAST_PI_PO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , OTD_VIOLATION_FPO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , KPL_STATUS VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , KPL_RC VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACTIVE_EVENT VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACTUAL_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACTUAL_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , ACTUAL_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACTUAL_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , ACTUAL_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACTUAL_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , ACTUAL_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACTUAL_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_ACTUAL TIMESTAMP(0) DEFAULT NULL , BT_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , BT_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , BT_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_LAD_OPT TIMESTAMP(0) DEFAULT NULL , BT_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , BT_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_FACK_OPT TIMESTAMP(0) DEFAULT NULL , BT_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , BT_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , BT_LACK_OPT TIMESTAMP(0) DEFAULT NULL , BT_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , BT_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BT_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_ACTUAL TIMESTAMP(0) DEFAULT NULL , PD_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , PD_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , PD_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_LAD_OPT TIMESTAMP(0) DEFAULT NULL , PD_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , PD_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_FACK_OPT TIMESTAMP(0) DEFAULT NULL , PD_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , PD_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , PD_LACK_OPT TIMESTAMP(0) DEFAULT NULL , PD_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , PD_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PD_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , DG_ACTUAL TIMESTAMP(0) DEFAULT NULL , DG_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , DG_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , DG_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DG_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , DG_LAD_OPT TIMESTAMP(0) DEFAULT NULL , DG_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , DG_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DG_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , DG_FACK_OPT TIMESTAMP(0) DEFAULT NULL , DG_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , DG_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DG_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , DG_LACK_OPT TIMESTAMP(0) DEFAULT NULL , DG_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , DG_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , DG_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , PGI_ACTUAL TIMESTAMP(0) DEFAULT NULL , PGI_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , PGI_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , PGI_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PGI_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , PGI_LAD_OPT TIMESTAMP(0) DEFAULT NULL , PGI_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , PGI_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PGI_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , PGI_FACK_OPT TIMESTAMP(0) DEFAULT NULL , PGI_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , PGI_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PGI_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , PGI_LACK_OPT TIMESTAMP(0) DEFAULT NULL , PGI_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , PGI_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PGI_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , ERCV_ACTUAL TIMESTAMP(0) DEFAULT NULL , ERCV_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , ERCV_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , ERCV_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ERCV_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , ERCV_LAD_OPT TIMESTAMP(0) DEFAULT NULL , ERCV_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , ERCV_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ERCV_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , ERCV_FACK_OPT TIMESTAMP(0) DEFAULT NULL , ERCV_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , ERCV_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ERCV_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , ERCV_LACK_OPT TIMESTAMP(0) DEFAULT NULL , ERCV_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , ERCV_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ERCV_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , ESHP_ACTUAL TIMESTAMP(0) DEFAULT NULL , ESHP_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , ESHP_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , ESHP_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ESHP_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , ESHP_LAD_OPT TIMESTAMP(0) DEFAULT NULL , ESHP_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , ESHP_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ESHP_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , ESHP_FACK_OPT TIMESTAMP(0) DEFAULT NULL , ESHP_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , ESHP_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ESHP_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , ESHP_LACK_OPT TIMESTAMP(0) DEFAULT NULL , ESHP_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , ESHP_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ESHP_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , POD_ACTUAL TIMESTAMP(0) DEFAULT NULL , POD_GOAL_OPT TIMESTAMP(0) DEFAULT NULL , POD_GOAL_LATEST TIMESTAMP(0) DEFAULT NULL , POD_GOAL_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , POD_GOAL_VALUE NUMERIC(18, 0) DEFAULT NULL , POD_LAD_OPT TIMESTAMP(0) DEFAULT NULL , POD_LAD_LATEST TIMESTAMP(0) DEFAULT NULL , POD_LAD_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , POD_LAD_VALUE NUMERIC(18, 0) DEFAULT NULL , POD_FACK_OPT TIMESTAMP(0) DEFAULT NULL , POD_FACK_LATEST TIMESTAMP(0) DEFAULT NULL , POD_FACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , POD_FACK_VALUE NUMERIC(18, 0) DEFAULT NULL , POD_LACK_OPT TIMESTAMP(0) DEFAULT NULL , POD_LACK_LATEST TIMESTAMP(0) DEFAULT NULL , POD_LACK_CRIT VARCHAR(10 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , POD_LACK_VALUE NUMERIC(18, 0) DEFAULT NULL , INVO_ACTUAL TIMESTAMP(0) DEFAULT NULL , LAST_UPDATE TIMESTAMP(0) DEFAULT NULL , CREDIT_STATUS VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FDA_ACTUAL TIMESTAMP(0) DEFAULT NULL , IS_VALID VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , EXT_SHIPMENT_HOLD VARCHAR(200 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SUPPLIER_SDD TIMESTAMP(0) DEFAULT NULL , STT NUMERIC(18, 0) DEFAULT NULL , SAT NUMERIC(18, 0) DEFAULT NULL , FTT NUMERIC(18, 0) DEFAULT NULL , TT_COMMENT VARCHAR(50 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , RESELLER_ORDER VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SCHED_SHIP_DATE TIMESTAMP(0) DEFAULT NULL , CARRIER_ID NUMERIC(18, 0) DEFAULT NULL , BLOCK_OE_CR VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_CFG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_DOC VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_INFO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_OTH VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_CFG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_DOC VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_MAT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_CAN VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_CHG VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_UNS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_OTH VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_SHIP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_BILL VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_CONDITIONS VARCHAR(40 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_REGION VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ROUTE VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_CONS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_PRI VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_PRO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_SHIP_TRA VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_BILL_INV VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ACK_HISTORY VARCHAR(1000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SSHIP_HISTORY VARCHAR(1000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , FULL_INVOICE_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_EXP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_STAX VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_ACC VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_SHIP_MER VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FO_SAP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FO_OIS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SHIP_TO_CITY VARCHAR(100 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , COMPL_LANDED_DATE TIMESTAMP(0) DEFAULT NULL , BLOCK_CAN VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_BILL_PART VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_ALLI VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_ALLOC VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_CRED VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_ESC1 VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_ESC2 VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_ESC3 VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_FACT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_EXP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_NPI VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_OBS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_PLANT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_PROD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_SHIPM VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_FF_TBA VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_BITF VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_CONT VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_CUST VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_CINS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_CMOV VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_CRP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_DATA VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_DEAL VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_DPRI VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_DUPO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_EORD VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_FULCR VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_LEAS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_LIC VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_MAN VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_OIS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_OEE VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_PAY VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_RES VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_SO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_SERV VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_SHIP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_SHTO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_SKEL VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_SUPP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_OE_VDPS VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_SHIP_FO VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_SHIP_SCH VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_ST_AWCF VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_ST_AWCR VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_ST_AWRP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_ST_FFW VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_ST_OEW VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BLOCK_ST_SHW VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , NET_INVOICE_PRICE NUMERIC(126, 0) DEFAULT NULL , NET_DLR_INVOICE_PRICE NUMERIC(126, 0) DEFAULT NULL , PARTNER_REF NUMERIC(18, 0) DEFAULT NULL , ROUTE_ORIG VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , REL2FF_DATE TIMESTAMP(0) DEFAULT NULL , INV_CURRENCY VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BILLING_COMPLETE VARCHAR(2 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , PRIMARY KEY (DELIVERY_GROUP ASC) ) SALT USING 16 PARTITIONS HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY' ) ; CREATE INDEX BLMON_DIX10 ON TRAFODION.OSSDBA.BACKLOG_DELV ( ORDER_NO ASC ) ; CREATE INDEX BLMON_DIX11 ON TRAFODION.OSSDBA.BACKLOG_DELV ( PGI_ACTUAL ASC ) ; CREATE INDEX BLMON_DIX12 ON TRAFODION.OSSDBA.BACKLOG_DELV ( POD_ACTUAL ASC ) ; CREATE INDEX BLMON_DIX13 ON TRAFODION.OSSDBA.BACKLOG_DELV ( SCHED_DELV_DATE ASC ) ; CREATE INDEX BLMON_DIX14 ON TRAFODION.OSSDBA.BACKLOG_DELV ( ESHP_ACTUAL ASC ) ; CREATE INDEX BLMON_DIX15 ON TRAFODION.OSSDBA.BACKLOG_DELV ( SUPPLIER ASC ) ; CREATE INDEX BLMON_DIX16 ON TRAFODION.OSSDBA.BACKLOG_DELV ( SHIPMENT_GROUP ASC ) ; CREATE INDEX BLMON_DIX17 ON TRAFODION.OSSDBA.BACKLOG_DELV ( INVOICE_NO ASC ) ; CREATE INDEX BLMON_DIX18 ON TRAFODION.OSSDBA.BACKLOG_DELV ( SHIP_ZONE ASC ) ; CREATE INDEX BLMON_DIX2 ON TRAFODION.OSSDBA.BACKLOG_DELV ( LEGACY_ORDER_NO ASC ) ; CREATE INDEX BLMON_DIX3 ON TRAFODION.OSSDBA.BACKLOG_DELV ( LAST_UPDATE ASC ) ; CREATE INDEX BLMON_DIX4 ON TRAFODION.OSSDBA.BACKLOG_DELV ( ORDER_LOAD_DATE ASC ) ; CREATE INDEX BLMON_DIX5 ON TRAFODION.OSSDBA.BACKLOG_DELV ( LAST_ACK_DATE ASC ) ; CREATE INDEX BLMON_DIX6 ON TRAFODION.OSSDBA.BACKLOG_DELV ( FACT_DELV_NO ASC ) ; CREATE INDEX BLMON_DIX7 ON TRAFODION.OSSDBA.BACKLOG_DELV ( CUST_DELV_NO ASC ) ; CREATE INDEX BLMON_DIX8 ON TRAFODION.OSSDBA.BACKLOG_DELV ( SHIPMENT_HOLD ASC ) ; CREATE INDEX BLMON_DIX9 ON TRAFODION.OSSDBA.BACKLOG_DELV ( SHIPMENT_NO ASC ) ; --- SQL operation complete. >>showddl measure; CREATE TABLE TRAFODION.OSSDBA.MEASURE ( LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , MLEVEL VARCHAR(4 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , ID VARCHAR(80 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , REQUEST_TAT NUMERIC(18, 0) DEFAULT NULL , SCHEDULED_TAT NUMERIC(18, 0) DEFAULT NULL , TAT_DELTA NUMERIC(18, 0) DEFAULT NULL , SA_TAT NUMERIC(18, 0) DEFAULT NULL , GLOBAL_TAT NUMERIC(18, 0) DEFAULT NULL , CSA_TAT NUMERIC(18, 0) DEFAULT NULL , MANUFACT_TAT NUMERIC(18, 0) DEFAULT NULL , CONSOLID_TAT NUMERIC(18, 0) DEFAULT NULL , LOGISTIC_TAT NUMERIC(18, 0) DEFAULT NULL , SLA_TO_SHIP NUMERIC(18, 0) DEFAULT NULL , SLA_TO_DELV NUMERIC(18, 0) DEFAULT NULL , SLA_VS_GLOBAL_TAT NUMERIC(18, 0) DEFAULT NULL , SLA_MATCHED VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , SLA_DATE TIMESTAMP(0) DEFAULT NULL , SLA_SHIP_DATE TIMESTAMP(0) DEFAULT NULL , SLAOTD_DELTA NUMERIC(18, 0) DEFAULT NULL , SLAOTS_DELTA NUMERIC(18, 0) DEFAULT NULL , LAST_CHECK TIMESTAMP(0) DEFAULT NULL , LAST_UPDATE TIMESTAMP(0) DEFAULT NULL , SHIP_TAT NUMERIC(18, 0) DEFAULT NULL , FRONT_TAT NUMERIC(18, 0) DEFAULT NULL , STT NUMERIC(18, 0) DEFAULT NULL , SAT NUMERIC(18, 0) DEFAULT NULL , POT_SLA_MATCHED VARCHAR(6 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL , BUILD_TAT NUMERIC(18, 0) DEFAULT NULL , PACKING_TAT NUMERIC(18, 0) DEFAULT NULL , WAIT_TAT NUMERIC(18, 0) DEFAULT NULL , PA_TAT NUMERIC(18, 0) DEFAULT NULL , QUOTE_CONV_TAT NUMERIC(18, 0) DEFAULT NULL , PRIMARY KEY (MLEVEL ASC, ID ASC) ) SALT USING 16 PARTITIONS ; CREATE INDEX IDX_MEASURE_ID ON TRAFODION.OSSDBA.MEASURE ( ID ASC ) ; CREATE INDEX MEASURE_X1 ON TRAFODION.OSSDBA.MEASURE ( LEGACY_ORDER_NO ASC ) ; --- SQL operation complete. >>exit; End of MXCI Session