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

INSERT INTO pub_bcr_nbcr (
        pk_nbcr,
        code,
        codelenth,
        codescope,
        codestyle,
        comp,
        dr,
        metaid,
        name,
        orgtype,
        ts
)
VALUES
        (
                '0001ZZZZF7B914A6F791',
                'DJSK',
                40,
                'global',
                'after',
                NULL,
                0,
                '6d9dc62b-1387-4e1c-bfb4-fcce3c8a5d20',
                '网银登记',
                'GLOBLE00000000000000',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_bcr_rulebase (
        pk_billcodebase,
        codemode,
        codescope,
        dataoriginflag,
        dr,
        format,
        isautofill,
        isdefault,
        iseditable,
        isgetpk,
        islenvar,
        isused,
        nbcrcode,
        pk_group,
        rulecode,
        rulename,
        ts
)
VALUES
        (
                '0001ZZZZEAC6697D58B6',
                'after',
                'g',
                0,
                0,
                'yyyyMMdd',
                'Y',
                'N',
                'N',
                'N',
                'Y',
                'Y',
                'DJSK',
                'GLOBLE00000000000000',
                'DJSK',
                '网银登记',
                '2021-11-03 17:33:36'
        );

go

INSERT INTO pub_bcr_elem (
        pk_billcodeelem,
        dataoriginflag,
        dr,
        elemlenth,
        elemtype,
        elemvalue,
        eorder,
        fillsign,
        fillstyle,
        isrefer,
        pk_billcodebase,
        pk_billcodeentity,
        ts
)
VALUES
        (
                '0001ZZZZFF7F71ABEBDB',
                NULL,
                0,
                4,
                0,
                'DJSK',
                0,
                NULL,
                0,
                0,
                '0001ZZZZEAC6697D58B6',
                '~',
                '2021-11-03 17:33:36'
        );
go
INSERT INTO pub_bcr_elem (
        pk_billcodeelem,
        dataoriginflag,
        dr,
        elemlenth,
        elemtype,
        elemvalue,
        eorder,
        fillsign,
        fillstyle,
        isrefer,
        pk_billcodebase,
        pk_billcodeentity,
        ts
)
VALUES
        (
                '0001ZZZZ1D9D345D8238',
                NULL,
                0,
                8,
                2,
                'billdate',
                1,
                NULL,
                0,
                0,
                '0001ZZZZEAC6697D58B6',
                '~',
                '2021-11-03 17:33:36'
        );
go
INSERT INTO pub_bcr_elem (
        pk_billcodeelem,
        dataoriginflag,
        dr,
        elemlenth,
        elemtype,
        elemvalue,
        eorder,
        fillsign,
        fillstyle,
        isrefer,
        pk_billcodebase,
        pk_billcodeentity,
        ts
)
VALUES
        (
                '0001ZZZZA35BB1FAFFC1',
                NULL,
                0,
                8,
                3,
                'nc.pub.billcode.BillCodePureDigitalSNGenerator',
                2,
                NULL,
                0,
                0,
                '0001ZZZZEAC6697D58B6',
                '~',
                '2021-11-03 17:33:36'
        );
go