TABLE_STRUCTURE
NON-PARTIONED TABLE  PRTN_STL_BKUP_26JAN2018
  CREATE TABLE PRTN_STL_BKUP_26JAN2018
   (	"BRANCH" VARCHAR2(3 CHAR) NOT NULL ENABLE, 
	"INTERNAL_REF_NUM" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"VERSION" NUMBER NOT NULL ENABLE, 
	"REFERENCE" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"CPLINK" NUMBER(1,0), 
	"STPFLAG" NUMBER(1,0), 
	"CLSELIGIBLEFLAG" NUMBER(1,0), 
	"FLEXPPSENDFLAG" NUMBER(1,0), 
	"SUPPRESSCONF" NUMBER(1,0), 
	"SUPPRESSPAY" NUMBER(1,0), 
	"SUPPRESSRN" NUMBER(1,0), 
	"SUPPRESSRD" NUMBER(1,0), 
	"THIRDPARTYFLAG" NUMBER(1,0), 
	"GENERATEMTN99" NUMBER(1,0), 
	"PAYFUNDREF" VARCHAR2(20 CHAR), 
	"RECVFUNDREF" VARCHAR2(20 CHAR), 
	"IRREPARABLE" NUMBER(1,0), 
	"SETTLEMENTDIFF" NUMBER(1,0), 
	"PAYDIFF" NUMBER(22,3), 
	"RECVDIFF" NUMBER(22,3), 
	"CREDITAPPROVAL_REMARKS" VARCHAR2(2000 CHAR), 
	"PAY_SITYPE" VARCHAR2(1 CHAR), 
	"PAY_INSTR_STATUS" NUMBER(1,0), 
	"RECV_SITYPE" VARCHAR2(1 CHAR), 
	"RECV_INSTR_STATUS" NUMBER(1,0), 
	"CHARGETYPE" VARCHAR2(1 CHAR), 
	"CONTRACTSTATUS" VARCHAR2(1 CHAR), 
	"PP_INDICATOR" VARCHAR2(1 CHAR), 
	"PP_BRANCH" VARCHAR2(3 CHAR), 
	"PP_ACCOUNTNO" VARCHAR2(20 CHAR), 
	"PP_CLEARINGNETWORK" VARCHAR2(2 CHAR), 
	"PP_PAYMENTTYPE" NUMBER(3,0), 
	"PP_GENERATEMESSAGE" NUMBER(1,0), 
	"PP_COVERREQUIRED" NUMBER(1,0), 
	"PP_RELATED_CUSTOMER" VARCHAR2(12 CHAR), 
	"PP_AMOUNT" NUMBER(22,3), 
	"PP_RTGS_PYMT" NUMBER(1,0), 
	"PP_CHEQ_PYMT" NUMBER(1,0), 
	"TR_PYMTID" VARCHAR2(35 CHAR), 
	"TR_PYMTCODE" VARCHAR2(35 CHAR), 
	"TR_LINE1" VARCHAR2(35 CHAR), 
	"TR_LINE2" VARCHAR2(35 CHAR), 
	"TR_LINE3" VARCHAR2(35 CHAR), 
	"TR_LINE4" VARCHAR2(35 CHAR), 
	"TR_LINE5" VARCHAR2(35 CHAR), 
	"TRAGT_PYMTID" VARCHAR2(35 CHAR), 
	"TRAGT_PYMTCODE" VARCHAR2(35 CHAR), 
	"TRAGT_LINE1" VARCHAR2(35 CHAR), 
	"TRAGT_LINE2" VARCHAR2(35 CHAR), 
	"TRAGT_LINE3" VARCHAR2(35 CHAR), 
	"TRAGT_LINE4" VARCHAR2(35 CHAR), 
	"TRAGT_LINE5" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE1" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE2" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE3" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE4" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE5" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE6" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_PYMTID" VARCHAR2(10 CHAR), 
	"BENEFICIARYDETAILS_PYMTCODE" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE5" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_PYMTID" VARCHAR2(10 CHAR), 
	"ORDERINGDETAILS_PYMTCODE" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE5" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE1" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE2" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE3" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE4" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE5" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE6" VARCHAR2(35 CHAR), 
	"PRMYRECEIVE_INDICATOR" VARCHAR2(1 CHAR), 
	"PRMYRECEIVE_BRANCH" VARCHAR2(3 CHAR), 
	"PRMYRECEIVE_ACCOUNTNO" VARCHAR2(20 CHAR), 
	"PRMYRECEIVE_OURRECVACC" VARCHAR2(35 CHAR), 
	"PRMYRECEIVE_RELATED_CUSTOMER" VARCHAR2(12 CHAR), 
	"PRMYRECEIVE_AMOUNT" NUMBER(22,3), 
	"PRMYRECEIVE_GENERATE_DD" NUMBER(1,0), 
	"THEIRPAYAGT_PYMTID" VARCHAR2(10 CHAR), 
	"THEIRPAYAGT_PYMTCODE" VARCHAR2(35 CHAR), 
	"DEBTOR_PYMTID" VARCHAR2(10 CHAR), 
	"DEBTOR_PYMTCODE" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE1" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE2" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE3" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE4" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE5" VARCHAR2(35 CHAR), 
	"REMITTER_PYMTID" VARCHAR2(35 CHAR), 
	"REMITTER_PYMTCODE" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_PYMTID" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_PYMTCODE" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE1" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE2" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE3" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE4" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE5" VARCHAR2(35 CHAR), 
	"AFFIRM_TYPE" VARCHAR2(1 CHAR), 
	"AFFIRM_TYPE_DESC" VARCHAR2(35 CHAR), 
	"AFFIRM_REFERENCE_NO" VARCHAR2(35 CHAR), 
	"AFFIRM_REMARKS" VARCHAR2(4000 CHAR), 
	"AFFIRM_STATUS" VARCHAR2(1 CHAR), 
	"AUTH_STATUS" VARCHAR2(1 CHAR), 
	"CASUAL_NETTER_FLAG" NUMBER(1,0), 
	"SUNDRYFLAG" NUMBER(1,0), 
	"SUNDRYTYPE" NUMBER(1,0), 
	"SUPPSRA" NUMBER(1,0), 
	"SUPPSSPA" NUMBER(1,0), 
	"SUNDRYLREF" VARCHAR2(20 CHAR), 
	"SUNDRYSTATUS" VARCHAR2(1 CHAR), 
	"CONFSTATUS" VARCHAR2(1 CHAR), 
	"CCSTATUS" VARCHAR2(1 CHAR), 
	"CPLINKSTATUS" VARCHAR2(1 CHAR), 
	"CSR_CODE" VARCHAR2(35 CHAR), 
	"BUY_CUTOFF_DATETIME" DATE, 
	"SELL_CUTOFF_DATETIME" DATE, 
	"PAY_FUNDING_CUTOFF" DATE, 
	"RECV_FUNDING_CUTOFF" DATE, 
	"CUST_NAME" VARCHAR2(255 CHAR), 
	"CUST_SHORT_NAME" VARCHAR2(255 CHAR), 
	"GCSS_DEAL" NUMBER(1,0), 
	"GCSS_DEAL_ACK_STATUS" VARCHAR2(1 CHAR), 
	"NETTING_TYPE" NUMBER(1,0), 
	"SPLIT_TYPE" NUMBER(1,0), 
	"LIQ_STATUS" VARCHAR2(1 CHAR), 
	"CLS_STATUS" VARCHAR2(5 CHAR), 
	"PAYMENT_MSG_STATUS" NUMBER, 
	"CREDIT_APPROVAL_REQUIRED" NUMBER(1,0), 
	"REJECT_REASON" VARCHAR2(2000 CHAR), 
	"SNDR_TO_RECV_INFO_ON" VARCHAR2(1 CHAR), 
	"REPAIR" NUMBER(1,0), 
	"AMEND" NUMBER(1,0), 
	"SPECIALHANDLING" NUMBER(1,0), 
	"VERIFICATION" NUMBER(1,0), 
	"CREDITCHECK" NUMBER(1,0), 
	"ENRICHMENT" NUMBER(1,0), 
	"UNCONFIRM" NUMBER(1,0), 
	"UNREIMBURSED_SUNDRY" NUMBER(1,0), 
	"WFDO" NUMBER(1,0), 
	"QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"REPAIR_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"AMEND_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"SPECIAL_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"VERIFICATION_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"CREDIT_CHECK_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"ENRICHMENT_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"UNCONFIRM_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"UNREMBRSD_SUNDRY_REASON" VARCHAR2(2000 CHAR), 
	"WFDO_REASON" VARCHAR2(2000 CHAR), 
	"USUAL_AFFIRM_METHOD" VARCHAR2(1 CHAR), 
	"UNUSUAL_AFFIRMATION" NUMBER(1,0), 
	"DUAL_KEY_VERIFIER" VARCHAR2(300 CHAR), 
	"ALLOW_OPS_PROCESSING" NUMBER(1,0), 
	"BOOKING_LOCATION" VARCHAR2(15 CHAR), 
	"SALES_PERSON_ID" VARCHAR2(20 CHAR), 
	"COVER_REQD" NUMBER(1,0), 
	"NEW_VALUE_DATE" DATE, 
	"SETTLE_RISK_GRP" VARCHAR2(16 CHAR), 
	"SI_CHANGED" NUMBER(1,0), 
	"CLS_CHANGED" NUMBER(1,0), 
	"DUAL_KEYING_COMPLETED" NUMBER(1,0), 
	"MARKER_AUTO_CLS_GROSS" NUMBER(1,0), 
	"BOOK" NUMBER(1,0), 
	"DEFER_ARCHIVAL" NUMBER(1,0), 
	"ARCHIVAL_REASON" VARCHAR2(255 CHAR), 
	"ARCHIVAL_DAYS" NUMBER, 
	"CONFIRMATION_BY" VARCHAR2(15 CHAR), 
	"CONFIRMATION_METHOD" VARCHAR2(16 CHAR), 
	"CUSTOMER_REF_NO" VARCHAR2(20 CHAR), 
	"RECEIVE_MSG_STATUS" NUMBER, 
	"CUST_NUM" VARCHAR2(12 CHAR), 
	"VALUEDATE" DATE, 
	"USRDFE_COL1" VARCHAR2(20 CHAR), 
	"USRDFE_COL2" VARCHAR2(20 CHAR), 
	"USRDFE_COL3" VARCHAR2(20 CHAR), 
	"USRDFE_COL4" VARCHAR2(100 CHAR), 
	"USRDFE_COL5" VARCHAR2(50 CHAR), 
	"INTERNIDENTITY" NUMBER(10,0), 
	"INTERNINSTID" NUMBER(10,0), 
	"INTERNVERSION" NUMBER(10,0), 
	"INTERNTIMESTAMP" DATE, 
	"INTERNRECTYPE" NUMBER(10,0), 
	"RECEIVE_NOTICE_STATUS" NUMBER, 
	"FREE_FORMAT_STATUS" NUMBER, 
	"NARRATIVE_OPS" VARCHAR2(2000 CHAR), 
	"TRACER_DATE" DATE, 
	"PAY_GI_STATUS" NUMBER, 
	"RECEIVE_GI_STATUS" NUMBER, 
	"USRDFE_COL7" VARCHAR2(100 CHAR), 
	"USRDFE_COL8" VARCHAR2(100 CHAR), 
	"USRDFE_COL9" VARCHAR2(100 CHAR), 
	"USRDFE_COL10" VARCHAR2(100 CHAR), 
	"MCA_STATUS" VARCHAR2(1 CHAR), 
	"RECEIVEDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"RECEIVEDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"RECEIVEDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"RECEIVEDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"CHARGE_DETAILS" VARCHAR2(3 CHAR), 
	"INSTRUCTION_DETAILS" VARCHAR2(35 CHAR), 
	"THEIR_UTI" VARCHAR2(100 CHAR), 
	"PREF" VARCHAR2(20 CHAR), 
	"USRDFE_COL6" VARCHAR2(100 CHAR), 
	"PROOF_CODE" VARCHAR2(50 CHAR), 
	"USRDFE_COL11" VARCHAR2(100 CHAR), 
	"USRDFE_COL12" VARCHAR2(100 CHAR), 
	"USRDFE_COL13" VARCHAR2(100 CHAR), 
	"USRDFE_COL14" VARCHAR2(100 CHAR), 
	"USRDFE_COL15" VARCHAR2(100 CHAR), 
	"CITI_CHECKIN_STATUS" VARCHAR2(1 CHAR), 
	"GCSS_PAYMENT_REASON" VARCHAR2(50 CHAR), 
	"GCSS_PAYMENT_REMARKS" VARCHAR2(256 CHAR), 
	"INTERNAL_USI" VARCHAR2(100 CHAR), 
	"INCOMING_SOURCE" VARCHAR2(3 CHAR), 
	"SR_QUEUE" NUMBER(1,0) NOT NULL ENABLE, 
	"SR_QUEUE_REASON" VARCHAR2(100 CHAR), 
	"CMS_NONSWIFT_ACK_STATUS" NUMBER(1,0), 
	"OUTCONFIRM_QUEUE" NUMBER(1,0), 
	"SETTLEMENT_QUEUE" NUMBER(1,0), 
	"OUTCONFIRM_QUEUE_REASON" VARCHAR2(100 CHAR), 
	"SETTLEMENT_QUEUE_REASON" VARCHAR2(100 CHAR), 
	"OBC_RTA_STATUS" VARCHAR2(10 CHAR), 
	"OBC_RTA_NACKREASON" VARCHAR2(2000 CHAR), 
	"ACCOUNT_MSGTYPE" VARCHAR2(10 CHAR), 
	"DVP" NUMBER(1,0), 
	"DVP_REASON" VARCHAR2(200 CHAR), 
	"CUSTOMER_DEBIT_TAX" NUMBER(1,0), 
	"SUPPRESS_CUST_DEBIT_TAX" NUMBER(1,0), 
	"DVP_OBC_RTA" NUMBER(1,0), 
	"SUPPRESS_ITR" NUMBER(1,0) NOT NULL ENABLE, 
	"RTGS_ELIGIBLE" NUMBER(1,0), 
	"UDF_RTGS" NUMBER(5,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" ;


PARTITIONED TABLE 
  
  CREATE TABLE STL
   (	"BRANCH" VARCHAR2(3 CHAR) NOT NULL ENABLE, 
	"INTERNAL_REF_NUM" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"VERSION" NUMBER NOT NULL ENABLE, 
	"REFERENCE" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"CPLINK" NUMBER(1,0), 
	"STPFLAG" NUMBER(1,0), 
	"CLSELIGIBLEFLAG" NUMBER(1,0), 
	"FLEXPPSENDFLAG" NUMBER(1,0), 
	"SUPPRESSCONF" NUMBER(1,0), 
	"SUPPRESSPAY" NUMBER(1,0), 
	"SUPPRESSRN" NUMBER(1,0), 
	"SUPPRESSRD" NUMBER(1,0), 
	"THIRDPARTYFLAG" NUMBER(1,0), 
	"GENERATEMTN99" NUMBER(1,0), 
	"PAYFUNDREF" VARCHAR2(20 CHAR), 
	"RECVFUNDREF" VARCHAR2(20 CHAR), 
	"IRREPARABLE" NUMBER(1,0), 
	"SETTLEMENTDIFF" NUMBER(1,0), 
	"PAYDIFF" NUMBER(22,3), 
	"RECVDIFF" NUMBER(22,3), 
	"CREDITAPPROVAL_REMARKS" VARCHAR2(2000 CHAR), 
	"PAY_SITYPE" VARCHAR2(1 CHAR), 
	"PAY_INSTR_STATUS" NUMBER(1,0), 
	"RECV_SITYPE" VARCHAR2(1 CHAR), 
	"RECV_INSTR_STATUS" NUMBER(1,0), 
	"CHARGETYPE" VARCHAR2(1 CHAR), 
	"CONTRACTSTATUS" VARCHAR2(1 CHAR), 
	"PP_INDICATOR" VARCHAR2(1 CHAR), 
	"PP_BRANCH" VARCHAR2(3 CHAR), 
	"PP_ACCOUNTNO" VARCHAR2(20 CHAR), 
	"PP_CLEARINGNETWORK" VARCHAR2(2 CHAR), 
	"PP_PAYMENTTYPE" NUMBER(3,0), 
	"PP_GENERATEMESSAGE" NUMBER(1,0), 
	"PP_COVERREQUIRED" NUMBER(1,0), 
	"PP_RELATED_CUSTOMER" VARCHAR2(12 CHAR), 
	"PP_AMOUNT" NUMBER(22,3), 
	"PP_RTGS_PYMT" NUMBER(1,0), 
	"PP_CHEQ_PYMT" NUMBER(1,0), 
	"TR_PYMTID" VARCHAR2(35 CHAR), 
	"TR_PYMTCODE" VARCHAR2(35 CHAR), 
	"TR_LINE1" VARCHAR2(35 CHAR), 
	"TR_LINE2" VARCHAR2(35 CHAR), 
	"TR_LINE3" VARCHAR2(35 CHAR), 
	"TR_LINE4" VARCHAR2(35 CHAR), 
	"TR_LINE5" VARCHAR2(35 CHAR), 
	"TRAGT_PYMTID" VARCHAR2(35 CHAR), 
	"TRAGT_PYMTCODE" VARCHAR2(35 CHAR), 
	"TRAGT_LINE1" VARCHAR2(35 CHAR), 
	"TRAGT_LINE2" VARCHAR2(35 CHAR), 
	"TRAGT_LINE3" VARCHAR2(35 CHAR), 
	"TRAGT_LINE4" VARCHAR2(35 CHAR), 
	"TRAGT_LINE5" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE1" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE2" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE3" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE4" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE5" VARCHAR2(35 CHAR), 
	"SNDR_TORECV_INFO_LINE6" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_PYMTID" VARCHAR2(10 CHAR), 
	"BENEFICIARYDETAILS_PYMTCODE" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"BENEFICIARYDETAILS_LINE5" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_PYMTID" VARCHAR2(10 CHAR), 
	"ORDERINGDETAILS_PYMTCODE" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"ORDERINGDETAILS_LINE5" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"PAYMENTDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE1" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE2" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE3" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE4" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE5" VARCHAR2(35 CHAR), 
	"COVERSTRECVINFO_LINE6" VARCHAR2(35 CHAR), 
	"PRMYRECEIVE_INDICATOR" VARCHAR2(1 CHAR), 
	"PRMYRECEIVE_BRANCH" VARCHAR2(3 CHAR), 
	"PRMYRECEIVE_ACCOUNTNO" VARCHAR2(20 CHAR), 
	"PRMYRECEIVE_OURRECVACC" VARCHAR2(35 CHAR), 
	"PRMYRECEIVE_RELATED_CUSTOMER" VARCHAR2(12 CHAR), 
	"PRMYRECEIVE_AMOUNT" NUMBER(22,3), 
	"PRMYRECEIVE_GENERATE_DD" NUMBER(1,0), 
	"THEIRPAYAGT_PYMTID" VARCHAR2(10 CHAR), 
	"THEIRPAYAGT_PYMTCODE" VARCHAR2(35 CHAR), 
	"DEBTOR_PYMTID" VARCHAR2(10 CHAR), 
	"DEBTOR_PYMTCODE" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE1" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE2" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE3" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE4" VARCHAR2(35 CHAR), 
	"DEBTOR_LINE5" VARCHAR2(35 CHAR), 
	"REMITTER_PYMTID" VARCHAR2(35 CHAR), 
	"REMITTER_PYMTCODE" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_PYMTID" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_PYMTCODE" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE1" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE2" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE3" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE4" VARCHAR2(35 CHAR), 
	"OURRECVAGTAGT_LINE5" VARCHAR2(35 CHAR), 
	"AFFIRM_TYPE" VARCHAR2(1 CHAR), 
	"AFFIRM_TYPE_DESC" VARCHAR2(35 CHAR), 
	"AFFIRM_REFERENCE_NO" VARCHAR2(35 CHAR), 
	"AFFIRM_REMARKS" VARCHAR2(4000 CHAR), 
	"AFFIRM_STATUS" VARCHAR2(1 CHAR), 
	"AUTH_STATUS" VARCHAR2(1 CHAR), 
	"CASUAL_NETTER_FLAG" NUMBER(1,0), 
	"SUNDRYFLAG" NUMBER(1,0), 
	"SUNDRYTYPE" NUMBER(1,0), 
	"SUPPSRA" NUMBER(1,0), 
	"SUPPSSPA" NUMBER(1,0), 
	"SUNDRYLREF" VARCHAR2(20 CHAR), 
	"SUNDRYSTATUS" VARCHAR2(1 CHAR), 
	"CONFSTATUS" VARCHAR2(1 CHAR), 
	"CCSTATUS" VARCHAR2(1 CHAR), 
	"CPLINKSTATUS" VARCHAR2(1 CHAR), 
	"CSR_CODE" VARCHAR2(35 CHAR), 
	"BUY_CUTOFF_DATETIME" DATE, 
	"SELL_CUTOFF_DATETIME" DATE, 
	"PAY_FUNDING_CUTOFF" DATE, 
	"RECV_FUNDING_CUTOFF" DATE, 
	"CUST_NAME" VARCHAR2(255 CHAR), 
	"CUST_SHORT_NAME" VARCHAR2(255 CHAR), 
	"GCSS_DEAL" NUMBER(1,0), 
	"GCSS_DEAL_ACK_STATUS" VARCHAR2(1 CHAR), 
	"NETTING_TYPE" NUMBER(1,0), 
	"SPLIT_TYPE" NUMBER(1,0), 
	"LIQ_STATUS" VARCHAR2(1 CHAR), 
	"CLS_STATUS" VARCHAR2(5 CHAR), 
	"PAYMENT_MSG_STATUS" NUMBER, 
	"CREDIT_APPROVAL_REQUIRED" NUMBER(1,0), 
	"REJECT_REASON" VARCHAR2(2000 CHAR), 
	"SNDR_TO_RECV_INFO_ON" VARCHAR2(1 CHAR), 
	"REPAIR" NUMBER(1,0), 
	"AMEND" NUMBER(1,0), 
	"SPECIALHANDLING" NUMBER(1,0), 
	"VERIFICATION" NUMBER(1,0), 
	"CREDITCHECK" NUMBER(1,0), 
	"ENRICHMENT" NUMBER(1,0), 
	"UNCONFIRM" NUMBER(1,0), 
	"UNREIMBURSED_SUNDRY" NUMBER(1,0), 
	"WFDO" NUMBER(1,0), 
	"QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"REPAIR_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"AMEND_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"SPECIAL_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"VERIFICATION_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"CREDIT_CHECK_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"ENRICHMENT_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"UNCONFIRM_QUEUE_REASON" VARCHAR2(2000 CHAR), 
	"UNREMBRSD_SUNDRY_REASON" VARCHAR2(2000 CHAR), 
	"WFDO_REASON" VARCHAR2(2000 CHAR), 
	"USUAL_AFFIRM_METHOD" VARCHAR2(1 CHAR), 
	"UNUSUAL_AFFIRMATION" NUMBER(1,0), 
	"DUAL_KEY_VERIFIER" VARCHAR2(300 CHAR), 
	"ALLOW_OPS_PROCESSING" NUMBER(1,0), 
	"BOOKING_LOCATION" VARCHAR2(15 CHAR), 
	"SALES_PERSON_ID" VARCHAR2(20 CHAR), 
	"COVER_REQD" NUMBER(1,0), 
	"NEW_VALUE_DATE" DATE, 
	"SETTLE_RISK_GRP" VARCHAR2(16 CHAR), 
	"SI_CHANGED" NUMBER(1,0), 
	"CLS_CHANGED" NUMBER(1,0), 
	"DUAL_KEYING_COMPLETED" NUMBER(1,0), 
	"MARKER_AUTO_CLS_GROSS" NUMBER(1,0), 
	"BOOK" NUMBER(1,0), 
	"DEFER_ARCHIVAL" NUMBER(1,0), 
	"ARCHIVAL_REASON" VARCHAR2(255 CHAR), 
	"ARCHIVAL_DAYS" NUMBER, 
	"CONFIRMATION_BY" VARCHAR2(15 CHAR), 
	"CONFIRMATION_METHOD" VARCHAR2(16 CHAR), 
	"CUSTOMER_REF_NO" VARCHAR2(20 CHAR), 
	"RECEIVE_MSG_STATUS" NUMBER, 
	"CUST_NUM" VARCHAR2(12 CHAR), 
	"VALUEDATE" DATE, 
	"USRDFE_COL1" VARCHAR2(20 CHAR), 
	"USRDFE_COL2" VARCHAR2(20 CHAR), 
	"USRDFE_COL3" VARCHAR2(20 CHAR), 
	"USRDFE_COL4" VARCHAR2(100 CHAR), 
	"USRDFE_COL5" VARCHAR2(50 CHAR), 
	"INTERNIDENTITY" NUMBER(10,0), 
	"INTERNINSTID" NUMBER(10,0), 
	"INTERNVERSION" NUMBER(10,0), 
	"INTERNTIMESTAMP" DATE, 
	"INTERNRECTYPE" NUMBER(10,0), 
	"RECEIVE_NOTICE_STATUS" NUMBER, 
	"FREE_FORMAT_STATUS" NUMBER, 
	"NARRATIVE_OPS" VARCHAR2(2000 CHAR), 
	"TRACER_DATE" DATE, 
	"PAY_GI_STATUS" NUMBER DEFAULT -2, 
	"RECEIVE_GI_STATUS" NUMBER DEFAULT -2, 
	"USRDFE_COL7" VARCHAR2(100 CHAR), 
	"USRDFE_COL8" VARCHAR2(100 CHAR), 
	"USRDFE_COL9" VARCHAR2(100 CHAR), 
	"USRDFE_COL10" VARCHAR2(100 CHAR), 
	"MCA_STATUS" VARCHAR2(1 CHAR), 
	"RECEIVEDETAILS_LINE1" VARCHAR2(35 CHAR), 
	"RECEIVEDETAILS_LINE2" VARCHAR2(35 CHAR), 
	"RECEIVEDETAILS_LINE3" VARCHAR2(35 CHAR), 
	"RECEIVEDETAILS_LINE4" VARCHAR2(35 CHAR), 
	"CHARGE_DETAILS" VARCHAR2(3 CHAR), 
	"INSTRUCTION_DETAILS" VARCHAR2(35 CHAR), 
	"THEIR_UTI" VARCHAR2(100 CHAR), 
	"PREF" VARCHAR2(20 CHAR), 
	"USRDFE_COL6" VARCHAR2(100 CHAR), 
	"PROOF_CODE" VARCHAR2(50 CHAR), 
	"USRDFE_COL11" VARCHAR2(100 CHAR), 
	"USRDFE_COL12" VARCHAR2(100 CHAR), 
	"USRDFE_COL13" VARCHAR2(100 CHAR), 
	"USRDFE_COL14" VARCHAR2(100 CHAR), 
	"USRDFE_COL15" VARCHAR2(100 CHAR), 
	"CITI_CHECKIN_STATUS" VARCHAR2(1 CHAR) DEFAULT 'N', 
	"GCSS_PAYMENT_REASON" VARCHAR2(50 CHAR), 
	"GCSS_PAYMENT_REMARKS" VARCHAR2(256 CHAR), 
	"INTERNAL_USI" VARCHAR2(100 CHAR), 
	"INCOMING_SOURCE" VARCHAR2(3 CHAR) DEFAULT NULL, 
	"SR_QUEUE" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, 
	"SR_QUEUE_REASON" VARCHAR2(100 CHAR), 
	"CMS_NONSWIFT_ACK_STATUS" NUMBER(1,0), 
	"OUTCONFIRM_QUEUE" NUMBER(1,0), 
	"SETTLEMENT_QUEUE" NUMBER(1,0), 
	"OUTCONFIRM_QUEUE_REASON" VARCHAR2(100 CHAR), 
	"SETTLEMENT_QUEUE_REASON" VARCHAR2(100 CHAR), 
	"OBC_RTA_STATUS" VARCHAR2(10 CHAR), 
	"OBC_RTA_NACKREASON" VARCHAR2(2000 CHAR), 
	"ACCOUNT_MSGTYPE" VARCHAR2(10 CHAR), 
	"DVP" NUMBER(1,0), 
	"DVP_REASON" VARCHAR2(200 CHAR), 
	"CUSTOMER_DEBIT_TAX" NUMBER(1,0), 
	"SUPPRESS_CUST_DEBIT_TAX" NUMBER(1,0), 
	"DVP_OBC_RTA" NUMBER(1,0), 
	"SUPPRESS_ITR" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, 
	"RTGS_ELIGIBLE" NUMBER(1,0), 
	"UDF_RTGS" NUMBER(5,0), 
	 CONSTRAINT "PK_TRXNENRICH" PRIMARY KEY ("BRANCH", "INTERNAL_REF_NUM", "VERSION") DISABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255  NOLOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CMASTER" 
  PARTITION BY RANGE ("VALUEDATE") 
 (PARTITION "S_26JAN2018"  VALUES LESS THAN (TO_DATE(' 2018-01-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_29JAN2018"  VALUES LESS THAN (TO_DATE(' 2018-01-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_30JAN2018"  VALUES LESS THAN (TO_DATE(' 2018-01-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_31JAN2018"  VALUES LESS THAN (TO_DATE(' 2018-01-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_01FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_02FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_05FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_06FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_07FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_08FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_09FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_12FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_13FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_14FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_15FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_16FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_19FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_20FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_21FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_22FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_23FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_26FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_27FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_28FEB2018"  VALUES LESS THAN (TO_DATE(' 2018-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_01MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_02MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_05MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_06MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_07MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_08MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_09MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_12MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_13MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_14MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_15MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_16MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_19MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_20MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_21MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_22MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_23MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_26MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_27MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_28MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_29MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_30MAR2018"  VALUES LESS THAN (TO_DATE(' 2018-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_02APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_03APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_04APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_05APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_06APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_09APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_10APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_11APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_12APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_13APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_16APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_17APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_18APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_19APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_20APR2018"  VALUES LESS THAN (TO_DATE(' 2018-04-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" , 
 PARTITION "S_MV"  VALUES LESS THAN (MAXVALUE) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS NOLOGGING 
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_CPARTITION" ) 
  PARALLEL 16 

OUTPUT 

NON-PARTIONED TABLE  PRTN_STL_BKUP_26JAN2018(STP_BP) Hard  coded to another value as length is more 
STP_BP	BRANCH	VARCHAR2		12			C	N	NO	NO
STP_BP	INTERNAL_REF_NUM	VARCHAR2		80			C	N	NO	NO
STP_BP	QFXVERSION	NUMBER		22				N	NO	NO
STP_BP	QFXREFERENCE	VARCHAR2		80			C	N	NO	NO
STP_BP	CPLINK	NUMBER		22	1	0		Y	NO	NO
STP_BP	STPFLAG	NUMBER		22	1	0		Y	NO	NO
STP_BP	CLSELIGIBLEFLAG	NUMBER		22	1	0		Y	NO	NO
STP_BP	FLEXPPSENDFLAG	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPRESSCONF	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPRESSPAY	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPRESSRN	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPRESSRD	NUMBER		22	1	0		Y	NO	NO
STP_BP	THIRDPARTYFLAG	NUMBER		22	1	0		Y	NO	NO
STP_BP	GENERATEMTN99	NUMBER		22	1	0		Y	NO	NO
STP_BP	PAYFUNDREF	VARCHAR2		80			C	Y	NO	NO
STP_BP	RECVFUNDREF	VARCHAR2		80			C	Y	NO	NO
STP_BP	IRREPARABLE	NUMBER		22	1	0		Y	NO	NO
STP_BP	SETTLEMENTDIFF	NUMBER		22	1	0		Y	NO	NO
STP_BP	PAYDIFF	NUMBER		22	22	3		Y	NO	NO
STP_BP	RECVDIFF	NUMBER		22	22	3		Y	NO	NO
STP_BP	CREDITAPPROVAL_REMARKS	VARCHAR2		4000			C	Y	NO	NO
STP_BP	PAY_SITYPE	VARCHAR2		4			C	Y	NO	NO
STP_BP	PAY_INSTR_STATUS	NUMBER		22	1	0		Y	NO	NO
STP_BP	RECV_SITYPE	VARCHAR2		4			C	Y	NO	NO
STP_BP	RECV_INSTR_STATUS	NUMBER		22	1	0		Y	NO	NO
STP_BP	CHARGETYPE	VARCHAR2		4			C	Y	NO	NO
STP_BP	CONTRACTSTATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	PP_INDICATOR	VARCHAR2		4			C	Y	NO	NO
STP_BP	PP_BRANCH	VARCHAR2		12			C	Y	NO	NO
STP_BP	PP_ACCOUNTNO	VARCHAR2		80			C	Y	NO	NO
STP_BP	PP_CLEARINGNETWORK	VARCHAR2		8			C	Y	NO	NO
STP_BP	PP_PAYMENTTYPE	NUMBER		22	3	0		Y	NO	NO
STP_BP	PP_GENERATEMESSAGE	NUMBER		22	1	0		Y	NO	NO
STP_BP	PP_COVERREQUIRED	NUMBER		22	1	0		Y	NO	NO
STP_BP	PP_RELATED_CUSTOMER	VARCHAR2		48			C	Y	NO	NO
STP_BP	PP_AMOUNT	NUMBER		22	22	3		Y	NO	NO
STP_BP	PP_RTGS_PYMT	NUMBER		22	1	0		Y	NO	NO
STP_BP	PP_CHEQ_PYMT	NUMBER		22	1	0		Y	NO	NO
STP_BP	TR_PYMTID	VARCHAR2		140			C	Y	NO	NO
STP_BP	TR_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	TR_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	TR_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	TR_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	TR_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	TR_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_PYMTID	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	TRAGT_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	SNDR_TORECV_INFO_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	SNDR_TORECV_INFO_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	SNDR_TORECV_INFO_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	SNDR_TORECV_INFO_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	SNDR_TORECV_INFO_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	SNDR_TORECV_INFO_LINE6	VARCHAR2		140			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_PYMTID	VARCHAR2		40			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	BENEFICIARYDETAILS_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_PYMTID	VARCHAR2		40			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	ORDERINGDETAILS_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	PAYMENTDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	PAYMENTDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	PAYMENTDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	PAYMENTDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	COVERSTRECVINFO_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	COVERSTRECVINFO_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	COVERSTRECVINFO_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	COVERSTRECVINFO_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	COVERSTRECVINFO_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	COVERSTRECVINFO_LINE6	VARCHAR2		140			C	Y	NO	NO
STP_BP	PRMYRECEIVE_INDICATOR	VARCHAR2		4			C	Y	NO	NO
STP_BP	PRMYRECEIVE_BRANCH	VARCHAR2		12			C	Y	NO	NO
STP_BP	PRMYRECEIVE_ACCOUNTNO	VARCHAR2		80			C	Y	NO	NO
STP_BP	PRMYRECEIVE_OURRECVACC	VARCHAR2		140			C	Y	NO	NO
STP_BP	PRMYRECEIVE_RELATED_CUSTOMER	VARCHAR2		48			C	Y	NO	NO
STP_BP	PRMYRECEIVE_AMOUNT	NUMBER		22	22	3		Y	NO	NO
STP_BP	PRMYRECEIVE_GENERATE_DD	NUMBER		22	1	0		Y	NO	NO
STP_BP	THEIRPAYAGT_PYMTID	VARCHAR2		40			C	Y	NO	NO
STP_BP	THEIRPAYAGT_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	DEBTOR_PYMTID	VARCHAR2		40			C	Y	NO	NO
STP_BP	DEBTOR_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	DEBTOR_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	DEBTOR_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	DEBTOR_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	DEBTOR_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	DEBTOR_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	REMITTER_PYMTID	VARCHAR2		140			C	Y	NO	NO
STP_BP	REMITTER_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_PYMTID	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	OURRECVAGTAGT_LINE5	VARCHAR2		140			C	Y	NO	NO
STP_BP	AFFIRM_TYPE	VARCHAR2		4			C	Y	NO	NO
STP_BP	AFFIRM_TYPE_DESC	VARCHAR2		140			C	Y	NO	NO
STP_BP	AFFIRM_REFERENCE_NO	VARCHAR2		140			C	Y	NO	NO
STP_BP	AFFIRM_REMARKS	VARCHAR2		4000			C	Y	NO	NO
STP_BP	AFFIRM_STATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	AUTH_STATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	CASUAL_NETTER_FLAG	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUNDRYFLAG	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUNDRYTYPE	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPSRA	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPSSPA	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUNDRYLREF	VARCHAR2		80			C	Y	NO	NO
STP_BP	SUNDRYSTATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	CONFSTATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	CCSTATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	CPLINKSTATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	CSR_CODE	VARCHAR2		140			C	Y	NO	NO
STP_BP	BUY_CUTOFF_DATETIME	DATE		7				Y	NO	NO
STP_BP	SELL_CUTOFF_DATETIME	DATE		7				Y	NO	NO
STP_BP	PAY_FUNDING_CUTOFF	DATE		7				Y	NO	NO
STP_BP	RECV_FUNDING_CUTOFF	DATE		7				Y	NO	NO
STP_BP	CUST_NAME	VARCHAR2		1020			C	Y	NO	NO
STP_BP	CUST_SHORT_NAME	VARCHAR2		1020			C	Y	NO	NO
STP_BP	GCSS_DEAL	NUMBER		22	1	0		Y	NO	NO
STP_BP	GCSS_DEAL_ACK_STATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	NETTING_TYPE	NUMBER		22	1	0		Y	NO	NO
STP_BP	SPLIT_TYPE	NUMBER		22	1	0		Y	NO	NO
STP_BP	LIQ_STATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	CLS_STATUS	VARCHAR2		20			C	Y	NO	NO
STP_BP	PAYMENT_MSG_STATUS	NUMBER		22				Y	NO	NO
STP_BP	CREDIT_APPROVAL_REQUIRED	NUMBER		22	1	0		Y	NO	NO
STP_BP	REJECT_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	SNDR_TO_RECV_INFO_ON	VARCHAR2		4			C	Y	NO	NO
STP_BP	REPAIR	NUMBER		22	1	0		Y	NO	NO
STP_BP	AMEND	NUMBER		22	1	0		Y	NO	NO
STP_BP	SPECIALHANDLING	NUMBER		22	1	0		Y	NO	NO
STP_BP	VERIFICATION	NUMBER		22	1	0		Y	NO	NO
STP_BP	CREDITCHECK	NUMBER		22	1	0		Y	NO	NO
STP_BP	ENRICHMENT	NUMBER		22	1	0		Y	NO	NO
STP_BP	UNCONFIRM	NUMBER		22	1	0		Y	NO	NO
STP_BP	UNREIMBURSED_SUNDRY	NUMBER		22	1	0		Y	NO	NO
STP_BP	WFDO	NUMBER		22	1	0		Y	NO	NO
STP_BP	QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	REPAIR_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	AMEND_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	SPECIAL_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	VERIFICATION_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	CREDIT_CHECK_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	ENRICHMENT_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	UNCONFIRM_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	UNREMBRSD_SUNDRY_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	WFDO_REASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	USUAL_AFFIRM_METHOD	VARCHAR2		4			C	Y	NO	NO
STP_BP	UNUSUAL_AFFIRMATION	NUMBER		22	1	0		Y	NO	NO
STP_BP	DUAL_KEY_VERIFIER	VARCHAR2		1200			C	Y	NO	NO
STP_BP	ALLOW_OPS_PROCESSING	NUMBER		22	1	0		Y	NO	NO
STP_BP	BOOKING_LOCATION	VARCHAR2		60			C	Y	NO	NO
STP_BP	SALES_PERSON_ID	VARCHAR2		80			C	Y	NO	NO
STP_BP	COVER_REQD	NUMBER		22	1	0		Y	NO	NO
STP_BP	NEW_VALUE_DATE	DATE		7				Y	NO	NO
STP_BP	SETTLE_RISK_GRP	VARCHAR2		64			C	Y	NO	NO
STP_BP	SI_CHANGED	NUMBER		22	1	0		Y	NO	NO
STP_BP	CLS_CHANGED	NUMBER		22	1	0		Y	NO	NO
STP_BP	DUAL_KEYING_COMPLETED	NUMBER		22	1	0		Y	NO	NO
STP_BP	MARKER_AUTO_CLS_GROSS	NUMBER		22	1	0		Y	NO	NO
STP_BP	BOOK	NUMBER		22	1	0		Y	NO	NO
STP_BP	DEFER_ARCHIVAL	NUMBER		22	1	0		Y	NO	NO
STP_BP	ARCHIVAL_REASON	VARCHAR2		1020			C	Y	NO	NO
STP_BP	ARCHIVAL_DAYS	NUMBER		22				Y	NO	NO
STP_BP	CONFIRMATION_BY	VARCHAR2		60			C	Y	NO	NO
STP_BP	CONFIRMATION_METHOD	VARCHAR2		64			C	Y	NO	NO
STP_BP	CUSTOMER_REF_NO	VARCHAR2		80			C	Y	NO	NO
STP_BP	RECEIVE_MSG_STATUS	NUMBER		22				Y	NO	NO
STP_BP	CUST_NUM	VARCHAR2		48			C	Y	NO	NO
STP_BP	VALUEDATE	DATE		7				Y	NO	NO
STP_BP	USRDFE_COL1	VARCHAR2		80			C	Y	NO	NO
STP_BP	USRDFE_COL2	VARCHAR2		80			C	Y	NO	NO
STP_BP	USRDFE_COL3	VARCHAR2		80			C	Y	NO	NO
STP_BP	USRDFE_COL4	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL5	VARCHAR2		200			C	Y	NO	NO
STP_BP	INTERNIDENTITY	NUMBER		22	10	0		Y	NO	NO
STP_BP	INTERNINSTID	NUMBER		22	10	0		Y	NO	NO
STP_BP	INTERNVERSION	NUMBER		22	10	0		Y	NO	NO
STP_BP	INTERNTIMESTAMP	DATE		7				Y	NO	NO
STP_BP	INTERNRECTYPE	NUMBER		22	10	0		Y	NO	NO
STP_BP	RECEIVE_NOTICE_STATUS	NUMBER		22				Y	NO	NO
STP_BP	FREE_FORMAT_STATUS	NUMBER		22				Y	NO	NO
STP_BP	NARRATIVE_OPS	VARCHAR2		4000			C	Y	NO	NO
STP_BP	TRACER_DATE	DATE		7				Y	NO	NO
STP_BP	PAY_GI_STATUS	NUMBER		22				Y	NO	NO
STP_BP	RECEIVE_GI_STATUS	NUMBER		22				Y	NO	NO
STP_BP	USRDFE_COL7	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL8	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL9	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL10	VARCHAR2		400			C	Y	NO	NO
STP_BP	MCA_STATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	RECEIVEDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STP_BP	RECEIVEDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STP_BP	RECEIVEDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STP_BP	RECEIVEDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STP_BP	CHARGE_DETAILS	VARCHAR2		12			C	Y	NO	NO
STP_BP	INSTRUCTION_DETAILS	VARCHAR2		140			C	Y	NO	NO
STP_BP	THEIR_UTI	VARCHAR2		400			C	Y	NO	NO
STP_BP	PREF	VARCHAR2		80			C	Y	NO	NO
STP_BP	USRDFE_COL6	VARCHAR2		400			C	Y	NO	NO
STP_BP	PROOF_CODE	VARCHAR2		200			C	Y	NO	NO
STP_BP	USRDFE_COL11	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL12	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL13	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL14	VARCHAR2		400			C	Y	NO	NO
STP_BP	USRDFE_COL15	VARCHAR2		400			C	Y	NO	NO
STP_BP	CITI_CHECKIN_STATUS	VARCHAR2		4			C	Y	NO	NO
STP_BP	GCSS_PAYMENT_REASON	VARCHAR2		200			C	Y	NO	NO
STP_BP	GCSS_PAYMENT_REMARKS	VARCHAR2		1024			C	Y	NO	NO
STP_BP	INTERNAL_USI	VARCHAR2		400			C	Y	NO	NO
STP_BP	INCOMING_SOURCE	VARCHAR2		12			C	Y	NO	NO
STP_BP	SR_QUEUE	NUMBER		22	1	0		N	NO	NO
STP_BP	SR_QUEUE_REASON	VARCHAR2		400			C	Y	NO	NO
STP_BP	CMS_NONSWIFT_ACK_STATUS	NUMBER		22	1	0		Y	NO	NO
STP_BP	OUTCONFIRM_QUEUE	NUMBER		22	1	0		Y	NO	NO
STP_BP	SETTLEMENT_QUEUE	NUMBER		22	1	0		Y	NO	NO
STP_BP	OUTCONFIRM_QUEUE_REASON	VARCHAR2		400			C	Y	NO	NO
STP_BP	SETTLEMENT_QUEUE_REASON	VARCHAR2		400			C	Y	NO	NO
STP_BP	OBC_RTA_STATUS	VARCHAR2		40			C	Y	NO	NO
STP_BP	OBC_RTA_NACKREASON	VARCHAR2		4000			C	Y	NO	NO
STP_BP	ACCOUNT_MSGTYPE	VARCHAR2		40			C	Y	NO	NO
STP_BP	DVP	NUMBER		22	1	0		Y	NO	NO
STP_BP	DVP_REASON	VARCHAR2		800			C	Y	NO	NO
STP_BP	CUSTOMER_DEBIT_TAX	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPRESS_CUST_DEBIT_TAX	NUMBER		22	1	0		Y	NO	NO
STP_BP	DVP_OBC_RTA	NUMBER		22	1	0		Y	NO	NO
STP_BP	SUPPRESS_ITR	NUMBER		22	1	0		N	NO	NO
STP_BP	RTGS_ELIGIBLE	NUMBER		22	1	0		Y	NO	NO
STP_BP	UDF_RTGS	NUMBER		22	5	0		Y	NO	NO

***************************************************************************************************************88
Partitioned tbale 

STL	BRANCH	VARCHAR2		12			C	N	NO	NO
STL	INTERNAL_REF_NUM	VARCHAR2		80			C	N	NO	NO
STL	QFXVERSION	NUMBER		22				N	NO	NO
STL	QFXREFERENCE	VARCHAR2		80			C	N	NO	NO
STL	CPLINK	NUMBER		22	1	0		Y	NO	NO
STL	STPFLAG	NUMBER		22	1	0		Y	NO	NO
STL	CLSELIGIBLEFLAG	NUMBER		22	1	0		Y	NO	NO
STL	FLEXPPSENDFLAG	NUMBER		22	1	0		Y	NO	NO
STL	SUPPRESSCONF	NUMBER		22	1	0		Y	NO	NO
STL	SUPPRESSPAY	NUMBER		22	1	0		Y	NO	NO
STL	SUPPRESSRN	NUMBER		22	1	0		Y	NO	NO
STL	SUPPRESSRD	NUMBER		22	1	0		Y	NO	NO
STL	THIRDPARTYFLAG	NUMBER		22	1	0		Y	NO	NO
STL	GENERATEMTN99	NUMBER		22	1	0		Y	NO	NO
STL	PAYFUNDREF	VARCHAR2		80			C	Y	NO	NO
STL	RECVFUNDREF	VARCHAR2		80			C	Y	NO	NO
STL	IRREPARABLE	NUMBER		22	1	0		Y	NO	NO
STL	SETTLEMENTDIFF	NUMBER		22	1	0		Y	NO	NO
STL	PAYDIFF	NUMBER		22	22	3		Y	NO	NO
STL	RECVDIFF	NUMBER		22	22	3		Y	NO	NO
STL	CREDITAPPROVAL_REMARKS	VARCHAR2		4000			C	Y	NO	NO
STL	PAY_SITYPE	VARCHAR2		4			C	Y	NO	NO
STL	PAY_INSTR_STATUS	NUMBER		22	1	0		Y	NO	NO
STL	RECV_SITYPE	VARCHAR2		4			C	Y	NO	NO
STL	RECV_INSTR_STATUS	NUMBER		22	1	0		Y	NO	NO
STL	CHARGETYPE	VARCHAR2		4			C	Y	NO	NO
STL	CONTRACTSTATUS	VARCHAR2		4			C	Y	NO	NO
STL	PP_INDICATOR	VARCHAR2		4			C	Y	NO	NO
STL	PP_BRANCH	VARCHAR2		12			C	Y	NO	NO
STL	PP_ACCOUNTNO	VARCHAR2		80			C	Y	NO	NO
STL	PP_CLEARINGNETWORK	VARCHAR2		8			C	Y	NO	NO
STL	PP_PAYMENTTYPE	NUMBER		22	3	0		Y	NO	NO
STL	PP_GENERATEMESSAGE	NUMBER		22	1	0		Y	NO	NO
STL	PP_COVERREQUIRED	NUMBER		22	1	0		Y	NO	NO
STL	PP_RELATED_CUSTOMER	VARCHAR2		48			C	Y	NO	NO
STL	PP_AMOUNT	NUMBER		22	22	3		Y	NO	NO
STL	PP_RTGS_PYMT	NUMBER		22	1	0		Y	NO	NO
STL	PP_CHEQ_PYMT	NUMBER		22	1	0		Y	NO	NO
STL	TR_PYMTID	VARCHAR2		140			C	Y	NO	NO
STL	TR_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	TR_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	TR_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	TR_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	TR_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	TR_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_PYMTID	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	TRAGT_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	SNDR_TORECV_INFO_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	SNDR_TORECV_INFO_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	SNDR_TORECV_INFO_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	SNDR_TORECV_INFO_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	SNDR_TORECV_INFO_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	SNDR_TORECV_INFO_LINE6	VARCHAR2		140			C	Y	NO	NO
STL	BENEFICIARYDETAILS_PYMTID	VARCHAR2		40			C	Y	NO	NO
STL	BENEFICIARYDETAILS_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	BENEFICIARYDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	BENEFICIARYDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	BENEFICIARYDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	BENEFICIARYDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	BENEFICIARYDETAILS_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	ORDERINGDETAILS_PYMTID	VARCHAR2		40			C	Y	NO	NO
STL	ORDERINGDETAILS_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	ORDERINGDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	ORDERINGDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	ORDERINGDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	ORDERINGDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	ORDERINGDETAILS_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	PAYMENTDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	PAYMENTDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	PAYMENTDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	PAYMENTDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	COVERSTRECVINFO_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	COVERSTRECVINFO_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	COVERSTRECVINFO_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	COVERSTRECVINFO_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	COVERSTRECVINFO_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	COVERSTRECVINFO_LINE6	VARCHAR2		140			C	Y	NO	NO
STL	PRMYRECEIVE_INDICATOR	VARCHAR2		4			C	Y	NO	NO
STL	PRMYRECEIVE_BRANCH	VARCHAR2		12			C	Y	NO	NO
STL	PRMYRECEIVE_ACCOUNTNO	VARCHAR2		80			C	Y	NO	NO
STL	PRMYRECEIVE_OURRECVACC	VARCHAR2		140			C	Y	NO	NO
STL	PRMYRECEIVE_RELATED_CUSTOMER	VARCHAR2		48			C	Y	NO	NO
STL	PRMYRECEIVE_AMOUNT	NUMBER		22	22	3		Y	NO	NO
STL	PRMYRECEIVE_GENERATE_DD	NUMBER		22	1	0		Y	NO	NO
STL	THEIRPAYAGT_PYMTID	VARCHAR2		40			C	Y	NO	NO
STL	THEIRPAYAGT_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	DEBTOR_PYMTID	VARCHAR2		40			C	Y	NO	NO
STL	DEBTOR_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	DEBTOR_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	DEBTOR_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	DEBTOR_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	DEBTOR_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	DEBTOR_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	REMITTER_PYMTID	VARCHAR2		140			C	Y	NO	NO
STL	REMITTER_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_PYMTID	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_PYMTCODE	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	OURRECVAGTAGT_LINE5	VARCHAR2		140			C	Y	NO	NO
STL	AFFIRM_TYPE	VARCHAR2		4			C	Y	NO	NO
STL	AFFIRM_TYPE_DESC	VARCHAR2		140			C	Y	NO	NO
STL	AFFIRM_REFERENCE_NO	VARCHAR2		140			C	Y	NO	NO
STL	AFFIRM_REMARKS	VARCHAR2		4000			C	Y	NO	NO
STL	AFFIRM_STATUS	VARCHAR2		4			C	Y	NO	NO
STL	AUTH_STATUS	VARCHAR2		4			C	Y	NO	NO
STL	CASUAL_NETTER_FLAG	NUMBER		22	1	0		Y	NO	NO
STL	SUNDRYFLAG	NUMBER		22	1	0		Y	NO	NO
STL	SUNDRYTYPE	NUMBER		22	1	0		Y	NO	NO
STL	SUPPSRA	NUMBER		22	1	0		Y	NO	NO
STL	SUPPSSPA	NUMBER		22	1	0		Y	NO	NO
STL	SUNDRYLREF	VARCHAR2		80			C	Y	NO	NO
STL	SUNDRYSTATUS	VARCHAR2		4			C	Y	NO	NO
STL	CONFSTATUS	VARCHAR2		4			C	Y	NO	NO
STL	CCSTATUS	VARCHAR2		4			C	Y	NO	NO
STL	CPLINKSTATUS	VARCHAR2		4			C	Y	NO	NO
STL	CSR_CODE	VARCHAR2		140			C	Y	NO	NO
STL	BUY_CUTOFF_DATETIME	DATE		7				Y	NO	NO
STL	SELL_CUTOFF_DATETIME	DATE		7				Y	NO	NO
STL	PAY_FUNDING_CUTOFF	DATE		7				Y	NO	NO
STL	RECV_FUNDING_CUTOFF	DATE		7				Y	NO	NO
STL	CUST_NAME	VARCHAR2		1020			C	Y	NO	NO
STL	CUST_SHORT_NAME	VARCHAR2		1020			C	Y	NO	NO
STL	GCSS_DEAL	NUMBER		22	1	0		Y	NO	NO
STL	GCSS_DEAL_ACK_STATUS	VARCHAR2		4			C	Y	NO	NO
STL	NETTING_TYPE	NUMBER		22	1	0		Y	NO	NO
STL	SPLIT_TYPE	NUMBER		22	1	0		Y	NO	NO
STL	LIQ_STATUS	VARCHAR2		4			C	Y	NO	NO
STL	CLS_STATUS	VARCHAR2		20			C	Y	NO	NO
STL	PAYMENT_MSG_STATUS	NUMBER		22				Y	NO	NO
STL	CREDIT_APPROVAL_REQUIRED	NUMBER		22	1	0		Y	NO	NO
STL	REJECT_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	SNDR_TO_RECV_INFO_ON	VARCHAR2		4			C	Y	NO	NO
STL	REPAIR	NUMBER		22	1	0		Y	NO	NO
STL	AMEND	NUMBER		22	1	0		Y	NO	NO
STL	SPECIALHANDLING	NUMBER		22	1	0		Y	NO	NO
STL	VERIFICATION	NUMBER		22	1	0		Y	NO	NO
STL	CREDITCHECK	NUMBER		22	1	0		Y	NO	NO
STL	ENRICHMENT	NUMBER		22	1	0		Y	NO	NO
STL	UNCONFIRM	NUMBER		22	1	0		Y	NO	NO
STL	UNREIMBURSED_SUNDRY	NUMBER		22	1	0		Y	NO	NO
STL	WFDO	NUMBER		22	1	0		Y	NO	NO
STL	QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	REPAIR_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	AMEND_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	SPECIAL_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	VERIFICATION_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	CREDIT_CHECK_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	ENRICHMENT_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	UNCONFIRM_QUEUE_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	UNREMBRSD_SUNDRY_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	WFDO_REASON	VARCHAR2		4000			C	Y	NO	NO
STL	USUAL_AFFIRM_METHOD	VARCHAR2		4			C	Y	NO	NO
STL	UNUSUAL_AFFIRMATION	NUMBER		22	1	0		Y	NO	NO
STL	DUAL_KEY_VERIFIER	VARCHAR2		1200			C	Y	NO	NO
STL	ALLOW_OPS_PROCESSING	NUMBER		22	1	0		Y	NO	NO
STL	BOOKING_LOCATION	VARCHAR2		60			C	Y	NO	NO
STL	SALES_PERSON_ID	VARCHAR2		80			C	Y	NO	NO
STL	COVER_REQD	NUMBER		22	1	0		Y	NO	NO
STL	NEW_VALUE_DATE	DATE		7				Y	NO	NO
STL	SETTLE_RISK_GRP	VARCHAR2		64			C	Y	NO	NO
STL	SI_CHANGED	NUMBER		22	1	0		Y	NO	NO
STL	CLS_CHANGED	NUMBER		22	1	0		Y	NO	NO
STL	DUAL_KEYING_COMPLETED	NUMBER		22	1	0		Y	NO	NO
STL	MARKER_AUTO_CLS_GROSS	NUMBER		22	1	0		Y	NO	NO
STL	BOOK	NUMBER		22	1	0		Y	NO	NO
STL	DEFER_ARCHIVAL	NUMBER		22	1	0		Y	NO	NO
STL	ARCHIVAL_REASON	VARCHAR2		1020			C	Y	NO	NO
STL	ARCHIVAL_DAYS	NUMBER		22				Y	NO	NO
STL	CONFIRMATION_BY	VARCHAR2		60			C	Y	NO	NO
STL	CONFIRMATION_METHOD	VARCHAR2		64			C	Y	NO	NO
STL	CUSTOMER_REF_NO	VARCHAR2		80			C	Y	NO	NO
STL	RECEIVE_MSG_STATUS	NUMBER		22				Y	NO	NO
STL	CUST_NUM	VARCHAR2		48			C	Y	NO	NO
STL	VALUEDATE	DATE		7				Y	NO	NO
STL	USRDFE_COL1	VARCHAR2		80			C	Y	NO	NO
STL	USRDFE_COL2	VARCHAR2		80			C	Y	NO	NO
STL	USRDFE_COL3	VARCHAR2		80			C	Y	NO	NO
STL	USRDFE_COL4	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL5	VARCHAR2		200			C	Y	NO	NO
STL	INTERNIDENTITY	NUMBER		22	10	0		Y	NO	NO
STL	INTERNINSTID	NUMBER		22	10	0		Y	NO	NO
STL	INTERNVERSION	NUMBER		22	10	0		Y	NO	NO
STL	INTERNTIMESTAMP	DATE		7				Y	NO	NO
STL	INTERNRECTYPE	NUMBER		22	10	0		Y	NO	NO
STL	RECEIVE_NOTICE_STATUS	NUMBER		22				Y	NO	NO
STL	FREE_FORMAT_STATUS	NUMBER		22				Y	NO	NO
STL	NARRATIVE_OPS	VARCHAR2		4000			C	Y	NO	NO
STL	TRACER_DATE	DATE		7				Y	NO	NO
STL	PAY_GI_STATUS	NUMBER		22				Y	NO	NO
STL	RECEIVE_GI_STATUS	NUMBER		22				Y	NO	NO
STL	USRDFE_COL7	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL8	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL9	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL10	VARCHAR2		400			C	Y	NO	NO
STL	MCA_STATUS	VARCHAR2		4			C	Y	NO	NO
STL	RECEIVEDETAILS_LINE1	VARCHAR2		140			C	Y	NO	NO
STL	RECEIVEDETAILS_LINE2	VARCHAR2		140			C	Y	NO	NO
STL	RECEIVEDETAILS_LINE3	VARCHAR2		140			C	Y	NO	NO
STL	RECEIVEDETAILS_LINE4	VARCHAR2		140			C	Y	NO	NO
STL	CHARGE_DETAILS	VARCHAR2		12			C	Y	NO	NO
STL	INSTRUCTION_DETAILS	VARCHAR2		140			C	Y	NO	NO
STL	THEIR_UTI	VARCHAR2		400			C	Y	NO	NO
STL	PREF	VARCHAR2		80			C	Y	NO	NO
STL	USRDFE_COL6	VARCHAR2		400			C	Y	NO	NO
STL	PROOF_CODE	VARCHAR2		200			C	Y	NO	NO
STL	USRDFE_COL11	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL12	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL13	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL14	VARCHAR2		400			C	Y	NO	NO
STL	USRDFE_COL15	VARCHAR2		400			C	Y	NO	NO
STL	CITI_CHECKIN_STATUS	VARCHAR2		4			C	Y	NO	NO
STL	GCSS_PAYMENT_REASON	VARCHAR2		200			C	Y	NO	NO
STL	GCSS_PAYMENT_REMARKS	VARCHAR2		1024			C	Y	NO	NO
STL	INTERNAL_USI	VARCHAR2		400			C	Y	NO	NO
STL	INCOMING_SOURCE	VARCHAR2		12			C	Y	NO	NO
STL	SR_QUEUE	NUMBER		22	1	0		N	NO	NO
STL	SR_QUEUE_REASON	VARCHAR2		400			C	Y	NO	NO
STL	CMS_NONSWIFT_ACK_STATUS	NUMBER		22	1	0		Y	NO	NO
STL	OUTCONFIRM_QUEUE	NUMBER		22	1	0		Y	NO	NO
STL	SETTLEMENT_QUEUE	NUMBER		22	1	0		Y	NO	NO
STL	OUTCONFIRM_QUEUE_REASON	VARCHAR2		400			C	Y	NO	NO
STL	SETTLEMENT_QUEUE_REASON	VARCHAR2		400			C	Y	NO	NO
STL	OBC_RTA_STATUS	VARCHAR2		40			C	Y	NO	NO
STL	OBC_RTA_NACKREASON	VARCHAR2		4000			C	Y	NO	NO
STL	ACCOUNT_MSGTYPE	VARCHAR2		40			C	Y	NO	NO
STL	DVP	NUMBER		22	1	0		Y	NO	NO
STL	DVP_REASON	VARCHAR2		800			C	Y	NO	NO
STL	CUSTOMER_DEBIT_TAX	NUMBER		22	1	0		Y	NO	NO
STL	SUPPRESS_CUST_DEBIT_TAX	NUMBER		22	1	0		Y	NO	NO
STL	DVP_OBC_RTA	NUMBER		22	1	0		Y	NO	NO
STL	SUPPRESS_ITR	NUMBER		22	1	0		N	NO	NO
STL	RTGS_ELIGIBLE	NUMBER		22	1	0		Y	NO	NO
STL	UDF_RTGS	NUMBER		22	5	0		Y	NO	NO