table.ddl

j2ee源码

   COMMISSION_RATE NUMBER(12, 2) NULL,
   SPECIAL_CONDITION VARCHAR2(4000) NULL,
   VALIDITY_DATE DATE NULL,
   CONTAINER_SIZE VARCHAR2(20) NULL,
   IS_LC_TYPE VARCHAR2(1) NULL,
   BANK_ID VARCHAR2(50) NULL,
   QTY_TOLERANCE_PERCENT NUMBER(5, 2) NULL,
   PARTIAL_SHIP VARCHAR2(1) NULL,
   TRANS_SHIP VARCHAR2(1) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   PAPER_CAT_ID VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   DOCUMENT_FEE NUMBER(13, 5) NULL,
   TON_PER_CONTAINER NUMBER(12, 3) NULL,
   SALESPERSON_ID VARCHAR2(15) NULL,
   ESTIMATE_SHIP_DATE DATE NULL,
   END_CUSTOMER_ID NUMBER(8, 0) NULL,
   INSURANCE_RATE NUMBER(12, 2) NULL,
   EXTRA_OTHER_COST1 NUMBER(12, 2) NULL,
   EXTRA_OTHER_DESC1 VARCHAR2(30) NULL,
   EXTRA_OTHER_COST2 NUMBER(12, 2) NULL,
   EXTRA_OTHER_DESC2 VARCHAR2(30) NULL,
   EXTRA_OTHER_COST3 NUMBER(12, 2) NULL,
   EXTRA_OTHER_DESC3 VARCHAR2(30) NULL,
   EXTRA_OTHER_COST4 NUMBER(12, 2) NULL,
   EXTRA_OTHER_DESC4 VARCHAR2(30) NULL,
   EXTRA_OTHER_COST5 NUMBER(12, 2) NULL,
   EXTRA_OTHER_DESC5 VARCHAR2(30) NULL,
   EXTRA_OTHER_COST6 NUMBER(12, 2) NULL,
   EXTRA_OTHER_DESC6 VARCHAR2(30) NULL);

ALTER TABLE WKEXS.QUOTATION_HDR
  ADD CONSTRAINT QUOTATION_HDR_PK PRIMARY KEY (COMPANY_ID, QUOTATION_TXN_NO);

CREATE TABLE WKEXS.QUOTATION_UPRI_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   QUOTATION_TXN_NO VARCHAR2(16) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   STD_PRICE_CURRENCY_ID VARCHAR2(3) NULL,
   STD_PRICE_EXCHG_RATE NUMBER(13, 7) NULL,
   STD_PRICE_PER_TON NUMBER(13, 5) NULL,
   INLAND_CURRENCY_ID VARCHAR2(3) NULL,
   INLAND_EXCHG_RATE NUMBER(13, 7) NULL,
   EIR NUMBER(13, 5) NULL,
   HAULAGE_CHARGE NUMBER(13, 5) NULL,
   AMS NUMBER(13, 5) NULL,
   THC NUMBER(13, 5) NULL,
   HANDLING_CHARGE NUMBER(13, 5) NULL,
   BOOKING_CHARGE NUMBER(13, 5) NULL,
   CUSTOMS_CLEAR_FREE NUMBER(13, 5) NULL,
   I_OTHER_CHARGE NUMBER(13, 5) NULL,
   FREIGHT_CURRENCY_ID VARCHAR2(3) NULL,
   FREIGHT_EXCHG_RATE NUMBER(13, 7) NULL,
   OCEAN_FREIGHT NUMBER(13, 5) NULL,
   BAF NUMBER(13, 5) NULL,
   CAF NUMBER(13, 5) NULL,
   FAF NUMBER(13, 5) NULL,
   GRI NUMBER(13, 5) NULL,
   PSS NUMBER(13, 5) NULL,
   WRS NUMBER(13, 5) NULL,
   ISPS NUMBER(13, 5) NULL,
   F_OTHER_CHARGE NUMBER(13, 5) NULL);

ALTER TABLE WKEXS.QUOTATION_UPRI_DTL
  ADD CONSTRAINT QUOTATION_UPRI_DTL_PK PRIMARY KEY (COMPANY_ID, QUOTATION_TXN_NO, PAPER_TYPE_ID);

CREATE TABLE WKEXS.REASON
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   REASON_CODE VARCHAR2(10) NOT NULL,
   DESCRIPTION VARCHAR2(800) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.REASON
  ADD CONSTRAINT REASON_PK PRIMARY KEY (COMPANY_ID, REASON_CODE);

CREATE TABLE WKEXS.ROLE_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   ROLE_ID VARCHAR2(5) NOT NULL,
   PROGRAM_ID VARCHAR2(20) NOT NULL,
   PRIV_ID VARCHAR2(3) NOT NULL,
   ACTIVE VARCHAR2(1) NULL);

ALTER TABLE WKEXS.ROLE_DTL
  ADD CONSTRAINT ROLE_DTL_PK PRIMARY KEY (COMPANY_ID, ROLE_ID, PROGRAM_ID, PRIV_ID);

CREATE TABLE WKEXS.ROLE_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   ROLE_ID VARCHAR2(5) NOT NULL,
   ROLE_NAME VARCHAR2(120) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.ROLE_HDR
  ADD CONSTRAINT ROLE_HDR_PK PRIMARY KEY (COMPANY_ID, ROLE_ID);

CREATE TABLE WKEXS.RUNNING_NUMBER
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   RUNNING_TYPE VARCHAR2(10) NOT NULL,
   RUNNING_YEAR VARCHAR2(4) NOT NULL,
   LAST_USED_NO NUMBER(10, 0) NULL,
   MIN_VALUE NUMBER(10, 0) NULL,
   MAX_VALUE NUMBER(10, 0) NULL,
   RECYCLE VARCHAR2(1) NULL,
   INCREMENT_BY NUMBER(10, 0) NULL,
   RUNNING_DESC VARCHAR2(100) NULL);

ALTER TABLE WKEXS.RUNNING_NUMBER
  ADD CONSTRAINT RUNNING_NUMBER_PK PRIMARY KEY (COMPANY_ID, RUNNING_TYPE, RUNNING_YEAR);

CREATE TABLE WKEXS.SC_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   SC_NO VARCHAR2(17) NULL,
   QUOTATION_TXN_NO VARCHAR2(16) NULL,
   QUOTATION_NO VARCHAR2(16) NULL,
   CONTRACT_DATE DATE NULL,
   CUSTOMER_PO_NO VARCHAR2(70) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   SUPPLIER_ID NUMBER(8, 0) NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   TRADE_TERMS_ID VARCHAR2(5) NULL,
   TRADE_TERMS_REMARK VARCHAR2(400) NULL,
   PAY_TERMS_ID VARCHAR2(8) NULL,
   PAY_DTL_ID VARCHAR2(8) NULL,
   SHIP_LINE_ID VARCHAR2(20) NULL,
   PARTIAL_SHIP VARCHAR2(1) NULL,
   TRANS_SHIP VARCHAR2(1) NULL,
   LOADING_PORT_ID VARCHAR2(10) NULL,
   DISCHARGE_PORT_ID VARCHAR2(10) NULL,
   AGENT_ID NUMBER(8, 0) NULL,
   COMMISSION_RATE NUMBER(12, 2) NULL,
   SPECIAL_CONDITION VARCHAR2(4000) NULL,
   LATEST_SHIP_DATE DATE NULL,
   SHIPPING_MARK VARCHAR2(2000) NULL,
   COUNTRY_OF_ORIGIN VARCHAR2(5) NULL,
   QTY_TOLERANCE_PERCENT NUMBER(5, 2) NULL,
   DEPOSIT_REQUIRED VARCHAR2(1) NULL,
   DEPOSIT_AMT NUMBER(12, 2) NULL,
   USED_DEPOSIT_AMT NUMBER(12, 2) NULL,
   DEPOSIT_PERCENT NUMBER(5, 2) NULL,
   DEPOSIT_CREDIT_DAYS NUMBER(3, 0) NULL,
   STATUS VARCHAR2(1) NULL,
   IS_LC_TYPE VARCHAR2(1) NULL,
   IS_SHIPMENT_ISSUED VARCHAR2(1) NULL,
   GENERATE_PSO_SO VARCHAR2(1) NULL,
   SDMS_PSO_NO VARCHAR2(80) NULL,
   SDMS_SO_NO VARCHAR2(80) NULL,
   BANK_ID VARCHAR2(50) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   GEN_PSO_SO_DTTM DATE NULL,
   GEN_PSO_SO_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   PAPER_CAT_ID VARCHAR2(15) NULL,
   LC_AMT NUMBER(12, 2) NULL,
   LC_RESV_AMT NUMBER(12, 2) NULL,
   LC_CFM_AMT NUMBER(12, 2) NULL,
   DOCUMENT_FEE NUMBER(13, 5) NULL,
   TON_PER_CONTAINER NUMBER(12, 3) NULL,
   CONTAINER_SIZE VARCHAR2(20) NULL,
   SALESPERSON_ID VARCHAR2(15) NULL,
   TTL_AMT NUMBER(14, 2) NULL,
   RECV_DEPOSIT_AMT NUMBER(12, 2) NULL,
   LATEST_LC_ISSUE_DATE DATE NULL,
   LC_EXPIRY_DATE DATE NULL,
   LC_TERM VARCHAR2(400) NULL,
   LC_TYPE VARCHAR2(1) NULL,
   END_CUSTOMER_ID NUMBER(8, 0) NULL,
   ACTUAL_PROD_DATE DATE NULL,
   SDMS_UNIT_PRICE NUMBER(12, 2) NULL,
   INSURANCE_RATE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.SC_HDR
  ADD CONSTRAINT SC_HDR_PK PRIMARY KEY (COMPANY_ID, SC_TXN_NO);

CREATE TABLE WKEXS.SC_PAPER_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   DESCRIPTION VARCHAR2(200) NULL,
   PAPER_SIZE_ID NUMBER(11, 2) NOT NULL,
   UOM VARCHAR2(2) NULL,
   UNIT_PRICE NUMBER(16, 5) NULL,
   QTY NUMBER(12, 3) NULL,
   AMT NUMBER(12, 2) NULL,
   PN_QTY NUMBER(12, 3) NULL,
   SHIPPED_QTY NUMBER(12, 3) NULL,
   SHIP_RESV_QTY NUMBER(12, 3) NULL,
   PN_RESV_QTY NUMBER(12, 3) NULL,
   EX_FACTORY_PRICE NUMBER(13, 5) NULL,
   PROFIT_RATE NUMBER(12, 2) NULL,
   DIAMETER NUMBER(10, 0) NULL);

ALTER TABLE WKEXS.SC_PAPER_DTL
  ADD CONSTRAINT SC_PAPER_DTL_PK PRIMARY KEY (COMPANY_ID, SC_TXN_NO, PAPER_TYPE_ID, PAPER_SIZE_ID);

CREATE TABLE WKEXS.SDMS_DEL_NOTE
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DEL_NOTE_NO VARCHAR2(15) NOT NULL,
   DEL_NOTICE_NO VARCHAR2(11) NULL,
   SO_NO VARCHAR2(30) NULL,
   LOADING_DATETIME DATE NULL,
   STATUS VARCHAR2(1) NULL,
   REMARK VARCHAR2(800) NULL,
   ISSUE_DATETIME DATE NULL,
   ISSUE_BY VARCHAR2(15) NULL,
   SO_TYPE VARCHAR2(20) NULL,
   CUSTOMER_ID VARCHAR2(7) NULL,
   TTL_DEL_QTY NUMBER(10, 0) NULL,
   TTL_DEL_WEIGHT NUMBER(12, 4) NULL,
   DAYEND_FLAG VARCHAR2(1) NULL,
   FACTORY_ID VARCHAR2(20) NOT NULL,
   CNTR_NO VARCHAR2(25) NULL,
   SEAL_NO VARCHAR2(25) NULL,
   CNTR_SIZE VARCHAR2(15) NULL);

ALTER TABLE WKEXS.SDMS_DEL_NOTE
  ADD CONSTRAINT DEL_NOTE_PK PRIMARY KEY (COMPANY_ID, DEL_NOTE_NO, FACTORY_ID);

CREATE TABLE WKEXS.SDMS_DEL_NOTE_ITEM
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   DEL_NOTE_NO VARCHAR2(15) NOT NULL,
   ITEM_NO NUMBER(4, 0) NOT NULL,
   ROLL_NO VARCHAR2(15) NULL,
   IS_REFUND VARCHAR2(1) NULL,
   PAPER_CATEGORY VARCHAR2(15) NULL,
   PAPER_TYPE VARCHAR2(15) NULL,
   PAPER_SIZE NUMBER(10, 2) NULL,
   UOM VARCHAR2(2) NULL,
   UNIT_PRICE NUMBER(12, 2) NULL,
   IS_ROLL_REFUND VARCHAR2(1) NULL,
   REFUND_NO VARCHAR2(15) NULL,
   PAPER_TYPE_REF VARCHAR2(15) NULL,
   IS_REFUND_DAMAGE VARCHAR2(1) NULL,
   DEL_WEIGHT NUMBER(12, 4) NULL,
   FACTORY_ID VARCHAR2(20) NOT NULL);

ALTER TABLE WKEXS.SDMS_DEL_NOTE_ITEM
  ADD CONSTRAINT DEL_NOTE_ITEM_PK PRIMARY KEY (COMPANY_ID, DEL_NOTE_NO, ITEM_NO, FACTORY_ID);

CREATE TABLE WKEXS.SHIPMENT_ACTUAL_COST
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   INLAND_CURRENCY_ID VARCHAR2(3) NULL,
   INLAND_EXCHG_RATE NUMBER(13, 7) NULL,
   EIR NUMBER(13, 5) NULL,
   HAULAGE_CHARGE NUMBER(13, 5) NULL,
   FREIGHT_CURRENCY_ID VARCHAR2(3) NULL,
   FREIGHT_EXCHG_RATE NUMBER(13, 7) NULL,
   OCEAN_FREIGHT NUMBER(13, 5) NULL,
   THC NUMBER(13, 5) NULL,
   BAF NUMBER(13, 5) NULL,
   CAF NUMBER(13, 5) NULL,
   FAF NUMBER(13, 5) NULL,
   GRI NUMBER(13, 5) NULL,
   PSS NUMBER(13, 5) NULL,
   WRS NUMBER(13, 5) NULL,
   ISPS NUMBER(13, 5) NULL,
   AMS NUMBER(13, 5) NULL,
   HANDLING_CHARGE NUMBER(13, 5) NULL,
   F_OTHER_CHARGE NUMBER(13, 5) NULL,
   BOOKING_CHARGE NUMBER(13, 5) NULL,
   I_OTHER_CHARGE NUMBER(13, 5) NULL,
   CUSTOMS_CLEAR_FREE NUMBER(13, 5) NULL,
   DOC_FEE NUMBER(13, 5) NULL,
   TTL_FREIGHT_COST NUMBER(16, 5) NULL,
   TTL_INLAND_COST NUMBER(16, 5) NULL,
   INSURANCE_RATE NUMBER(12, 2) NULL,
   CNTR_STUFFING_CHARGE NUMBER(12, 2) NULL,
   D_O_FEE NUMBER(12, 2) NULL,
   SECURITY_SUR_CHARGE NUMBER(12, 2) NULL,
   HARBOR_CHARGE NUMBER(12, 2) NULL,
   TALLY_FEE NUMBER(12, 2) NULL,
   INSPECTION_SERVICE_FEE NUMBER(12, 2) NULL,
   CUSTOM_CLEARANCE_FEE NUMBER(12, 2) NULL,
   GATE_FEE NUMBER(12, 2) NULL,
   CARTAGE_FEE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.SHIPMENT_ACTUAL_COST
  ADD CONSTRAINT SHIPMENT_ACTUAL_COST_PK PRIMARY KEY (COMPANY_ID, SHIPMENT_NO);

CREATE TABLE WKEXS.SHIPMENT_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   ISSUE_DATE DATE NULL,
   STATUS VARCHAR2(5) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   CONSIGNEE VARCHAR2(400) NULL,
   CONSIGNEE_ADDR VARCHAR2(800) NULL,
   DELY_ADDR_ID VARCHAR2(5) NULL,
   TRANSPORT_TYPE VARCHAR2(20) NULL,
   SHIP_LINE_ID VARCHAR2(20) NULL,
   VESSEL_NAME VARCHAR2(800) NULL,
   COUNTRY_ID VARCHAR2(5) NULL,
   DISTRICT_ID VARCHAR2(5) NULL,
   LOADING_PORT_ID VARCHAR2(10) NULL,
   DISCHARGE_PORT_ID VARCHAR2(10) NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   CUTOFF_DATE DATE NULL,
   ETD DATE NULL,
   ETA DATE NULL,
   SAILING_DATE DATE NULL,
   BL_NO VARCHAR2(200) NULL,
   BL_INSTRUCTION_DATE DATE NULL,
   LATEST_BL_PRESENT_DATE DATE NULL,
   PACKING_REMARKS VARCHAR2(4000) NULL,
   CCIC_REMARKS VARCHAR2(1200) NULL,
   SHIPPING_MARKS VARCHAR2(4000) NULL,
   INVOICE_REMARKS VARCHAR2(4000) NULL,
   CUSTOM_INV_REMARKS VARCHAR2(2000) NULL,
   DOC_RECV_DATE DATE NULL,
   INSURANCE_POLICY VARCHAR2(50) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   COST_POSTING_DTTM DATE NULL,
   COST_POSTING_BY VARCHAR2(15) NULL,
   INVOICE_POSTING_DTTM DATE NULL,
   INVOICE_POSTING_BY VARCHAR2(15) NULL,
   RUC_NO VARCHAR2(13) NULL,
   TRADE_TERMS_REMARK VARCHAR2(1200) NULL,
   ACTUAL_SHIPMENT_COST VARCHAR2(1) NULL,
   CNTR_LOADING_DATE DATE NULL,
   INVOICE_NO VARCHAR2(20) NULL,
   INVOICE_DATE DATE NULL,
   PAY_TERMS_REMARK VARCHAR2(1200) NULL,
   BPCS_INVOICE_DATE DATE NULL,
   BPCS_DUE_DATE DATE NULL,
   DUE_DATE DATE NULL,
   BANK_CHARGES NUMBER(12, 2) NULL,
   BANK_CHARGES_CURR VARCHAR2(3) NULL,
   CUSTOM_CONTRACT_NO VARCHAR2(25) NULL,
   HS_CODE VARCHAR2(25) NULL,
   CUSTOM_GOODS VARCHAR2(300) NULL,
   TTL_MACHINING_CHARGE NUMBER(12, 2) NULL,
   TTL_MATERIAL_CHARGE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.SHIPMENT_HDR
  ADD CONSTRAINT SHIPMENT_HDR_PK PRIMARY KEY (COMPANY_ID, SHIPMENT_NO);

CREATE TABLE WKEXS.SHIPMENT_SC
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   SC_NO VARCHAR2(17) NULL,
   TRADE_TERMS_ID VARCHAR2(5) NULL,
   PAY_TERMS_ID VARCHAR2(8) NULL,
   PAY_DTL_ID VARCHAR2(8) NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   SUPPLIER_ID NUMBER(8, 0) NULL,
   TTL_QTY NUMBER(12, 0) NULL,
   TTL_WT NUMBER(12, 3) NULL,
   TTL_AMT NUMBER(17, 2) NULL,
   SC_BILLS_TYPE VARCHAR2(1) NULL,
   IS_SC_BILLS_ISSUED VARCHAR2(1) NULL,
   TTL_CNTR NUMBER(12, 0) NULL,
   IS_LAST_SHIPMENT VARCHAR2(1) NULL,
   USED_DEPOSIT_AMT NUMBER(17, 2) NULL);

ALTER TABLE WKEXS.SHIPMENT_SC
  ADD CONSTRAINT SHIPMENT_SC_PK PRIMARY KEY (COMPANY_ID, SHIPMENT_NO, SC_TXN_NO);

CREATE TABLE WKEXS.SHIPMENT_SC_CNTR_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   CNTR_NO VARCHAR2(80) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   PAPER_SIZE_ID NUMBER(11, 2) NOT NULL,
   ROLL_NO VARCHAR2(100) NOT NULL,
   WEIGHT NUMBER(17, 3) NULL,
   SUPPLIER_ID NUMBER(8, 0) NULL,
   SDMS_DEL_NOTE_NO VARCHAR2(30) NULL,
   SDMS_SO_NO VARCHAR2(30) NULL);

ALTER TABLE WKEXS.SHIPMENT_SC_CNTR_DTL
  ADD CONSTRAINT SHIPMENT_SC_CNTR_DTL_PK PRIMARY KEY (COMPANY_ID, SHIPMENT_NO, SC_TXN_NO, CNTR_NO, PAPER_TYPE_ID, PAPER_SIZE_ID, ROLL_NO);

CREATE TABLE WKEXS.SHIPMENT_SC_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SHIPMENT_NO VARCHAR2(20) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   CNTR_NO VARCHAR2(80) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   PAPER_SIZE_ID NUMBER(11, 2) NOT NULL,
   DESCRIPTION VARCHAR2(400) NULL,
   UOM VARCHAR2(5) NULL,
   UNIT_PRICE NUMBER(16, 5) NULL,
   TTL_QTY NUMBER(12, 0) NULL,
   TTL_WT NUMBER(12, 3) NULL,
   SEAL_NO VARCHAR2(120) NULL,
   SC_UNIT_PRICE NUMBER(16, 5) NULL,
   CONTAINER_SIZE VARCHAR2(20) NULL,
   EX_FACTORY_PRICE NUMBER(13, 5) NULL,
   COMMISSION_RATE NUMBER(17, 2) NULL,
   PROFIT_RATE NUMBER(17, 2) NULL,
   AVG_FREIGHT_COST NUMBER(17, 2) NULL,
   INSURANCE_RATE NUMBER(12, 2) NULL,
   MACHINING_CHARGE NUMBER(12, 2) NULL,
   MATERIAL_CHARGE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.SHIPMENT_SC_DTL
  ADD CONSTRAINT SHIPMENT_SC_DTL_PK PRIMARY KEY (COMPANY_ID, SHIPMENT_NO, SC_TXN_NO, CNTR_NO, PAPER_TYPE_ID, PAP