CREATE TABLE gtg_ts_paymentformats (
    ETL_SEQUENCE_ID                   NUMBER(19, 0) ,
    ETL_VERSION_NUMBER                NUMBER(18, 0) ,
    DELETE_VERSION_NUMBER             NUMBER(18, 0) ,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    ASSIGNMENT_ENTITY_ID              VARCHAR2(120) ,
    CODE                              VARCHAR2(120) ,
    CODE_MAP_GROUP_CODE               VARCHAR2(120) ,
    FIELD_NAME_CODE                   VARCHAR2(120) ,
    FORMAT_CODE                       VARCHAR2(120) ,
    FORMAT_NAME                       VARCHAR2(1200),
    FORMAT_TEMPLATE_CODE              VARCHAR2(320) ,
    FORMAT_TYPE_CODE                  VARCHAR2(120) ,
    FROMDATE                          DATE          ,
    IBYFORMATSB_CB                    VARCHAR2(256) ,
    IBYFORMATSB_CD                    TIMESTAMP(6)  ,
    IBYFORMATSB_LUB                   VARCHAR2(256) ,
    IBYFORMATSB_LUD                   TIMESTAMP(6)  ,
    IBYFORMATSTL_CB                   VARCHAR2(256) ,
    IBYFORMATSTL_CD                   TIMESTAMP(6)  ,
    IBYFORMATSTL_LUB                  VARCHAR2(256) ,
    IBYFORMATSTL_LUD                  TIMESTAMP(6)  ,
    IBYVALASSIGNMENTS_CB              VARCHAR2(256) ,
    IBYVALASSIGNMENTS_CD              TIMESTAMP(6)  ,
    IBYVALASSIGNMENTS_LUB             VARCHAR2(256) ,
    IBYVALASSIGNMENTS_LUD             TIMESTAMP(6)  ,
    IBYVALIDATIONVALUES_CB            VARCHAR2(256) ,
    IBYVALIDATIONVALUES_CD            TIMESTAMP(6)  ,
    IBYVALIDATIONVALUES_LUB           VARCHAR2(256) ,
    IBYVALIDATIONVALUES_LUD           TIMESTAMP(6)  ,
    LANGUAGECOLUMN                    VARCHAR2(16)  ,
    PAYMENT_METHOD_CODE               VARCHAR2(120) ,
    SHREDDING_HANDLED_BY_PARSER       VARCHAR2(4)   ,
    TERRITORY_CODE                    VARCHAR2(8)   ,
    TODATE                            DATE          ,
    TRANSFORM_METHOD                  VARCHAR2(920) ,
    TRANSFORM_PROGRAM_TYPE            VARCHAR2(120) ,
    TRANSFORM_SRVC_INTERFACE_CLASS    VARCHAR2(920) ,
    VALIDATION_ASSIGNMENT_ID          NUMBER(18, 0) ,
    VALIDATION_PARAMETER_CODE         VARCHAR2(400) ,
    VAL_PARAM_DATE_VALUE              DATE          ,
    VAL_PARAM_NUMBER_VALUE            NUMBER        ,
    VAL_PARAM_VARCHAR2_VALUE          VARCHAR2(4000),
    VLDTNASSGNMNTID                   NUMBER(18, 0) ,
    VLDTNFROMDATE                     DATE          ,
    VLDTNPRMTRSETNAME                 VARCHAR2(120) ,
    VLDTNSETNAME                      VARCHAR2(120) ,
    VLDTNTODATE                       DATE          ,
    ETL_SEQUENCE_ID                   NUMBER(19, 0) ,
    ETL_VERSION_NUMBER                NUMBER(18, 0) ,
    DELETE_VERSION_NUMBER             NUMBER(18, 0) ,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    ASSIGNMENT_ENTITY_ID              VARCHAR2(120) ,
    CODE                              VARCHAR2(120) ,
    CODE_MAP_GROUP_CODE               VARCHAR2(120) ,
    FIELD_NAME_CODE                   VARCHAR2(120) ,
    FORMAT_CODE                       VARCHAR2(120) ,
    FORMAT_NAME                       VARCHAR2(1200),
    FORMAT_TEMPLATE_CODE              VARCHAR2(320) ,
    FORMAT_TYPE_CODE                  VARCHAR2(120) ,
    FROMDATE                          DATE          ,
    IBYFORMATSB_CB                    VARCHAR2(256) ,
    IBYFORMATSB_CD                    TIMESTAMP(6)  ,
    IBYFORMATSB_LUB                   VARCHAR2(256) ,
    IBYFORMATSB_LUD                   TIMESTAMP(6)  ,
    IBYFORMATSTL_CB                   VARCHAR2(256) ,
    IBYFORMATSTL_CD                   TIMESTAMP(6)  ,
    IBYFORMATSTL_LUB                  VARCHAR2(256) ,
    IBYFORMATSTL_LUD                  TIMESTAMP(6)  ,
    IBYVALASSIGNMENTS_CB              VARCHAR2(256) ,
    IBYVALASSIGNMENTS_CD              TIMESTAMP(6)  ,
    IBYVALASSIGNMENTS_LUB             VARCHAR2(256) ,
    IBYVALASSIGNMENTS_LUD             TIMESTAMP(6)  ,
    IBYVALIDATIONVALUES_CB            VARCHAR2(256) ,
    IBYVALIDATIONVALUES_CD            TIMESTAMP(6)  ,
    IBYVALIDATIONVALUES_LUB           VARCHAR2(256) ,
    IBYVALIDATIONVALUES_LUD           TIMESTAMP(6)  ,
    LANGUAGECOLUMN                    VARCHAR2(16)  ,
    LNG                               VARCHAR2(16)  ,
    PAYMENT_METHOD_CODE               VARCHAR2(120) ,
    SHREDDING_HANDLED_BY_PARSER       VARCHAR2(4)   ,
    TERRITORY_CODE                    VARCHAR2(8)   ,
    TODATE                            DATE          ,
    TRANSFORM_METHOD                  VARCHAR2(920) ,
    TRANSFORM_PROGRAM_TYPE            VARCHAR2(120) ,
    TRANSFORM_SRVC_INTERFACE_CLASS    VARCHAR2(920) ,
    VALIDATION_ASSIGNMENT_ID          NUMBER(18, 0) ,
    VALIDATION_PARAMETER_CODE         VARCHAR2(400) ,
    VAL_PARAM_DATE_VALUE              DATE          ,
    VAL_PARAM_NUMBER_VALUE            NUMBER        ,
    VAL_PARAM_VARCHAR2_VALUE          VARCHAR2(4000),
    VLDTNASSGNMNTID                   NUMBER(18, 0) ,
    VLDTNFROMDATE                     DATE          ,
    VLDTNPRMTRSETNAME                 VARCHAR2(120) ,
    VLDTNSETNAME                      VARCHAR2(120) ,
    VLDTNTODATE                       DATE          ,
    CONSTRAINT pk_gtg_ts_paymentformats PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
