单据模板修改脚本

最新推荐文章于 2023-12-15 17:19:39 发布

marc-sam

最新推荐文章于 2023-12-15 17:19:39 发布

阅读量649

点赞数

分类专栏： Uap Nc

本文链接：https://blog.csdn.net/u010890857/article/details/51236688

版权

这篇博客的内容是一系列的SQL插入语句，用于创建和填充名为`pub_billtemplet`及其子表的数据库表格。这些表格似乎与一个名为'办理入住'的业务流程相关，涉及多个字段如'pk_livein'、'pk_project'、'pk_house'等，可能是为了定义和管理入住流程中的不同步骤和关联数据。

摘要由CSDN通过智能技术生成

INSERT INTO pub_billtemplet (ts, BILL_TEMPLETCAPTION, BILL_TEMPLETNAME, NODECODE, PK_BILLTEMPLET, PK_BILLTYPECODE, PK_CORP, METADATACLASS, MODULECODE, LAYER ) VALUES ('2014-12-01 11:50:32', '办理入住', 'SYSTEM', 'H30100242', '0001Y7100000003K77FG', 'H30100242', '@@@@', 'fdcps.LiveinHVO', 'H301', 0 );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_livein', 'N', 1, 'N', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FH', 0, 'N', 'N', 0, 1, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_livein', 'pk_livein', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_project', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FI', 0, 'N', 'N', 1, 2, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_project', 'pk_project', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_house', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FJ', 0, 'N', 'N', 1, 3, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_house', 'pk_house', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_customer1', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FK', 0, 'N', 'N', 1, 4, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_customer1', 'pk_customer1', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_customer2', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FL', 0, 'N', 'N', 1, 5, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_customer2', 'pk_customer2', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_customer3', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FM', 0, 'N', 'N', 1, 6, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_customer3', 'pk_customer3', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_customer4', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FN', 0, 'N', 'N', 1, 7, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_customer4', 'pk_customer4', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_customer5', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FO', 0, 'N', 'N', 1, 8, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_customer5', 'pk_customer5', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'vcustomername', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FP', 0, 'N', 'N', 1, 9, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.vcustomername', 'vcustomername', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, TABLE_NAME, TOTALFLAG, USERDEFFLAG, USEREDITFLAG, USERFLAG, USERSHOWFLAG, WIDTH, METADATAPROPERTY, METADATAPATH, HYPERLINKFLAG, LISTHYPERLINKFLAG ) VALUES ('2014-12-01 11:50:32', 1, -1, 1, -1, -1, 'pk_trade', 'N', 1, 'Y', 0, 'N', 0, '0001Y7100000003K77FG', '0001Y7100000003K77FQ', 0, 'N', 'N', 1, 10, 'LiveinHVO', '办理入住', 0, 'N', 1, 1, 1, 1, 'fdcps.LiveinHVO.pk_trade', 'pk_trade', 'N', 'N' );
INSERT INTO pub_billtemplet_b (ts, CARDFLAG, DATATYPE, EDITFLAG, FOREGROUND, INPUTLENGTH, ITEMKEY, LEAFFLAG, LISTFLAG, LISTSHOWFLAG, LOCKFLAG, NEWLINEFLAG, NULLFLAG, PK_BILLTEMPLET, PK_BILLTEMPLET_B, POS, REVISEFLAG, USERREVISEFLAG, SHOWFLAG, SHOWORDER, TABLE_CODE, T