ZRNCC2005WYDJD/zjcmp_cd/cd/script/template/96H10119/sql002/001.sql

INSERT INTO bd_billtype (
        pk_billtypeid,
        accountclass,
        billcoderule,
        billstyle,
        billtypename,
        canextendtransaction,
        checkclassname,
        classname,
        comp,
        component,
        datafinderclz,
        def1,
        def2,
        def3,
        dr,
        emendenumclass,
        forwardbilltype,
        isaccount,
        isapprovebill,
        isbizflowbill,
        iseditableproperty,
        isenablebutton,
        isenabletranstypebcr,
        islightbill,
        islock,
        isrejectuneditableproperty,
        isroot,
        issupportmobile,
        istransaction,
        isworkflowcanautoapprove,
        ncbrcode,
        nodecode,
        parentbilltype,
        pk_billtypecode,
        pk_group,
        pk_org,
        referclassname,
        systemcode,
        transtype_class,
        ts,
        webnodecode,
        wherestring
)
VALUES
        (
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                NULL,
                '网银登记',
                'Y',
                NULL,
                NULL,
                NULL,
                'onlineregon',
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                'Y',
                'Y',
                'N',
                'N',
                'N',
                'N',
                'Y',
                NULL,
                NULL,
                'N',
                'Y',
                'N',
                'N',
                '~',
                '96H10119',
                '~',
                'DJSK',
                '~',
                'GLOBLE00000000000000',
                NULL,
                'ZJCMP_CD',
                NULL,
                '2021-11-03 17:33:36',
                '~',
                NULL
        );

go

INSERT INTO pub_billaction (
        pk_billaction,
        action_type,
        actionnote,
        actionstyle,
        actionstyleremark,
        actiontype,
        constrictflag,
        controlflag,
        dr,
        finishflag,
        pk_billtype,
        pk_billtypeid,
        pushflag,
        showhint,
        ts
)
VALUES
        (
                '0001ZZZZD99CD3F89569',
                11,
                '~',
                '2',
                NULL,
                'APPROVE',
                'N',
                'N',
                NULL,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                '2021-11-03 17:33:36'
        );
go

INSERT INTO pub_billaction (
        pk_billaction,
        action_type,
        actionnote,
        actionstyle,
        actionstyleremark,
        actiontype,
        constrictflag,
        controlflag,
        dr,
        finishflag,
        pk_billtype,
        pk_billtypeid,
        pushflag,
        showhint,
        ts
)
VALUES
        (
                '0001ZZZZE7750DE27F77',
                30,
                '~',
                '3',
                NULL,
                'DELETE',
                'N',
                'N',
                NULL,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_billaction (
        pk_billaction,
        action_type,
        actionnote,
        actionstyle,
        actionstyleremark,
        actiontype,
        constrictflag,
        controlflag,
        dr,
        finishflag,
        pk_billtype,
        pk_billtypeid,
        pushflag,
        showhint,
        ts
)
VALUES
        (
                '0001ZZZZAD4C567DC50A',
                10,
                '~',
                '1',
                NULL,
                'SAVE',
                'N',
                'N',
                NULL,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_billaction (
        pk_billaction,
        action_type,
        actionnote,
        actionstyle,
        actionstyleremark,
        actiontype,
        constrictflag,
        controlflag,
        dr,
        finishflag,
        pk_billtype,
        pk_billtypeid,
        pushflag,
        showhint,
        ts
)
VALUES
        (
                '0001ZZZZE8617BF8FA21',
                31,
                '~',
                '1',
                NULL,
                'SAVEBASE',
                'Y',
                'N',
                NULL,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO PUB_BILLACTION (
        PK_BILLACTION,
        ACTION_TYPE,
        ACTIONNOTE,
        ACTIONSTYLE,
        ACTIONSTYLEREMARK,
        ACTIONTYPE,
        CONSTRICTFLAG,
        CONTROLFLAG,
        DR,
        FINISHFLAG,
        PK_BILLTYPE,
        PK_BILLTYPEID,
        PUSHFLAG,
        SHOWHINT,
        TS
)
VALUES
        (
                '0001ZZZZAEF5907874C1',
                12,
                '~',
                '3',
                NULL,
                'UNAPPROVE',
                'N',
                'N',
                NULL,
                'Y',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO PUB_BILLACTION (
        PK_BILLACTION,
        ACTION_TYPE,
        ACTIONNOTE,
        ACTIONSTYLE,
        ACTIONSTYLEREMARK,
        ACTIONTYPE,
        CONSTRICTFLAG,
        CONTROLFLAG,
        DR,
        FINISHFLAG,
        PK_BILLTYPE,
        PK_BILLTYPEID,
        PUSHFLAG,
        SHOWHINT,
        TS
)
VALUES
        (
                '0001ZZZZF67ADF2BBDCC',
                13,
                '~',
                '3',
                NULL,
                'UNSAVEBILL',
                'N',
                'Y',
                NULL,
                'Y',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                NULL,
                '~',
                '2021-11-03 17:33:36'
        );


go

INSERT INTO pub_busiclass (
        pk_busiclass,
        actiontype,
        classname,
        dr,
        isbefore,
        pk_billtype,
        pk_billtypeid,
        pk_businesstype,
        pk_group,
        ts
)
VALUES
        (
                '0001ZZZZE86E359B48F7',
                'SAVE',
                'N_DJSK_SAVE',
                0,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                '~',
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_busiclass (
        pk_busiclass,
        actiontype,
        classname,
        dr,
        isbefore,
        pk_billtype,
        pk_billtypeid,
        pk_businesstype,
        pk_group,
        ts
)
VALUES
        (
                '0001ZZZZDE97134E7153',
                'APPROVE',
                'N_DJSK_APPROVE',
                0,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                '~',
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_busiclass (
        pk_busiclass,
        actiontype,
        classname,
        dr,
        isbefore,
        pk_billtype,
        pk_billtypeid,
        pk_businesstype,
        pk_group,
        ts
)
VALUES
        (
                '0001ZZZZ22DFF3D6C87E',
                'UNSAVEBILL',
                'N_DJSK_UNSAVEBILL',
                0,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                '~',
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_busiclass (
        pk_busiclass,
        actiontype,
        classname,
        dr,
        isbefore,
        pk_billtype,
        pk_billtypeid,
        pk_businesstype,
        pk_group,
        ts
)
VALUES
        (
                '0001ZZZZ3DA452292B69',
                'UNAPPROVE',
                'N_DJSK_UNAPPROVE',
                0,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                '~',
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_busiclass (
        pk_busiclass,
        actiontype,
        classname,
        dr,
        isbefore,
        pk_billtype,
        pk_billtypeid,
        pk_businesstype,
        pk_group,
        ts
)
VALUES
        (
                '0001ZZZZE01F87BD7D24',
                'DELETE',
                'N_DJSK_DELETE',
                0,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                '~',
                '~',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO PUB_BUSICLASS (
        PK_BUSICLASS,
        ACTIONTYPE,
        CLASSNAME,
        DR,
        ISBEFORE,
        PK_BILLTYPE,
        PK_BILLTYPEID,
        PK_BUSINESSTYPE,
        PK_GROUP,
        TS
)
VALUES
        (
                '0001ZZZZE61BDD919472',
                'SAVEBASE',
                'N_DJSK_SAVEBASE',
                0,
                'N',
                'DJSK',
                '0001ZZZZF9AB74F307A3',
                '~',
                '~',
                '2021-11-03 17:33:36'
        );
go


insert into pub_workitemconfig (
        pk_workitemconfig,
        dr,
        item,
        itemindex,
        itemtype,
        pk_billtype,
        resourceid,
        ts,
        isdefault,
        ismp
)
values
(
        '0001ZZZZEC017191EF67',
        0,
        'DJSKT',
        null,
        null,
        '0001ZZZZF9AB74F307A3',
        null,
        '2021-11-03 17:33:36',
        'Y',
        'Y'
);
go