--1、新建期间临时表，将需要保留的期间数据插入--------------------------------新建期间临时表------------------------------DROPTABLETEMPTIME;createtableTEMPTIMEasSELECTfid,fnumberFROMT_BD_PeriodWHEREfperiodyear>2020;--总账1CREATETABLECASHFLOWSPLITRECORDASselect*fromT_GL_CASHFLOWSPLITRECORDwhereFVOUCHERIDin(selectfidfromT_GL_Voucherwherefperiodidin(selectfidfromtemptime));--drop原表droptableT_GL_CASHFLOWSPLITRECORD;--重命名表ALTERTABLECASHFLOWSPLITRECORDRENAMETOT_GL_CASHFLOWSPLITRECORD;--总账2CREATETABLECASHFLOWRECORDASselectcfr.*fromT_GL_CASHFLOWRECORDcfrinnerjoinT_GL_Vouchervoucheroncfr.FVOUCHERID=voucher.FIDwherevoucher.fperiodidin(selectfidfromtemptime);--drop原表droptableT_GL_CASHFLOWRECORD;--重命名表ALTERTABLECASHFLOWRECORDRENAMETOT_GL_CASHFLOWRECORD;--总账3--创建备份表CREATETABLEACCTCUSSENTASSELECT*FROMT_GL_ACCTCUSSENTWHEREfperiodidin(selectfidfromtemptime);--drop原表droptableT_GL_ACCTCUSSENT;--重命名表ALTERTABLEACCTCUSSENTRENAMETOT_GL_ACCTCUSSENT;--总账4CREATETABLEACCTCUSSENTHISTORYASselect*fromT_GL_ACCTCUSSENTHISTORYrwhereexists(SELECTfidFROMT_GL_ACCTCUSSENTswheres.fid=r.FCUSSENTIDID);--drop原表droptableT_GL_ACCTCUSSENTHISTORY;--重命名表ALTERTABLEACCTCUSSENTHISTORYRENAMETOT_GL_ACCTCUSSENTHISTORY;--总账5--创建备份表CREATETABLEVOUCHERASSISTRECORDASSELECT*FROMT_GL_VOUCHERASSISTRECORDWHEREFBillIDIN(SELECTfidFROMT_GL_VoucherWHEREfperiodidIN(SELECTfidFROMtemptime));--drop原表droptableT_GL_VOUCHERASSISTRECORD;--重命名表ALTERTABLEVOUCHERASSISTRECORDRENAMETOT_GL_VOUCHERASSISTRECORD;--总账6CREATETABLEVOUCHERENTRYASSELECT*FROMT_GL_VOUCHERENTRYWHEREFBillIDIN(SELECTfidFROMT_GL_VoucherWHEREfperiodidIN(SELECTfidFROMtemptime));--drop原表droptableT_GL_VOUCHERENTRY;--重命名表ALTERTABLEVOUCHERENTRYRENAMETOT_GL_VOUCHERENTRY;--总账7CREATETABLEVOUCHERASSELECT*FROMT_GL_VOUCHERWHEREfperiodidIN(SELECTfidFROMtemptime);INSERTINTOVOUCHERSELECT*FROMT_GL_VOUCHERvWHEREEXISTS(SELECTfidFROMt_gl_voucherassistrecordvrWHEREvr.fbillid=v.fid)ANDfperiodidNOTIN(SELECTfidFROMtemptime);--drop原表droptableT_GL_VOUCHER;--重命名表ALTERTABLEVOUCHERRENAMETOT_GL_VOUCHER;--总账8.1--创建备份表CREATETABLEASSISTBALANCE_1FASSELECT*FROMT_GL_ASSISTBALANCE_1FWHEREfperiodIN(SELECTfnumberFROMtemptime);--drop原表droptableT_GL_ASSISTBALANCE_1F;--重命名表ALTERTABLEASSISTBALANCE_1FRENAMETOT_GL_ASSISTBALANCE_1F;--总账8.2--创建备份表CREATETABLEASSISTBALANCE_1LASSELECT*FROMT_GL_ASSISTBALANCE_1LWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ASSISTBALANCE_1L;--重命名表ALTERTABLEASSISTBALANCE_1LRENAMETOT_GL_ASSISTBALANCE_1L;--总账8.3--创建备份表CREATETABLEASSISTBALANCE_1RASSELECT*FROMT_GL_ASSISTBALANCE_1RWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ASSISTBALANCE_1R;--重命名表ALTERTABLEASSISTBALANCE_1RRENAMETOT_GL_ASSISTBALANCE_1R;--总账8.4--创建备份表CREATETABLEASSISTBALANCE_5FASSELECT*FROMT_GL_ASSISTBALANCE_5FWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ASSISTBALANCE_5F;--重命名表ALTERTABLEASSISTBALANCE_5FRENAMETOT_GL_ASSISTBALANCE_5F;--总账8.5--创建备份表CREATETABLEASSISTBALANCE_5LASSELECT*FROMT_GL_ASSISTBALANCE_5LWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ASSISTBALANCE_5L;--重命名表ALTERTABLEASSISTBALANCE_5LRENAMETOT_GL_ASSISTBALANCE_5L;--总账8.6--创建备份表CREATETABLEASSISTBALANCE_5RASSELECT*FROMT_GL_ASSISTBALANCE_5RWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ASSISTBALANCE_5R;--重命名表ALTERTABLEASSISTBALANCE_5RRENAMETOT_GL_ASSISTBALANCE_5R;--总账9.1CREATETABLEACCOUNTBALANCE_1FASSELECT*FROMT_GL_ACCOUNTBALANCE_1FWHEREfperiodIN(SELECTfnumberFROMtemptime);--drop原表droptableT_GL_ACCOUNTBALANCE_1F;--重命名表ALTERTABLEACCOUNTBALANCE_1FRENAMETOT_GL_ACCOUNTBALANCE_1F;--总账9.2--创建备份表CREATETABLEACCOUNTBALANCE_1LASSELECT*FROMT_GL_ACCOUNTBALANCE_1LWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ACCOUNTBALANCE_1L;--重命名表ALTERTABLEACCOUNTBALANCE_1LRENAMETOT_GL_ACCOUNTBALANCE_1L;--总账9.3--创建备份表CREATETABLEACCOUNTBALANCE_1RASSELECT*FROMT_GL_ACCOUNTBALANCE_1RWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ACCOUNTBALANCE_1R;--重命名表ALTERTABLEACCOUNTBALANCE_1RRENAMETOT_GL_ACCOUNTBALANCE_1R;--总账9.4--创建备份表CREATETABLEACCOUNTBALANCE_5FASSELECT*FROMT_GL_ACCOUNTBALANCE_5FWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ACCOUNTBALANCE_5F;--重命名表ALTERTABLEACCOUNTBALANCE_5FRENAMETOT_GL_ACCOUNTBALANCE_5F;--总账9.5--创建备份表CREATETABLEACCOUNTBALANCE_5LASSELECT*FROMT_GL_ACCOUNTBALANCE_5LWHEREfperiodin(selectfnumberfromtemptime);droptableT_GL_ACCOUNTBALANCE_5L;--重命名表ALTERTABLEACCOUNTBALANCE_5LRENAMETOT_GL_ACCOUNTBALANCE_5L;--总账9.6--创建备份表CREATETABLEACCOUNTBALANCE_5RASSELECT*FROMT_GL_ACCOUNTBALANCE_5RWHEREfperiodin(selectfnumberfromtemptime);--drop原表droptableT_GL_ACCOUNTBALANCE_5R;--重命名表ALTERTABLEACCOUNTBALANCE_5RRENAMETOT_GL_ACCOUNTBALANCE_5R;-----------------------------------------------------------------------------------------------------------------------资产1--创建备份表CREATETABLEFAMONASSTACTCOMPOSITASSELECTps.*FROMT_FA_FAMONASSTACTCOMPOSITpsinnerjoinT_FA_FAMONCOSTCENTERcoonco.fid=ps.FFAMONCOSTCENTERIDinnerjoinT_FA_FAMONCARDmonm.FID=co.FFAMONCARDIDWHEREm.ffaperiodidin(selectfidfromtemptime);--drop原表droptableT_FA_FAMONASSTACTCOMPOSIT;--修改表名ALTERTABLEFAMONASSTACTCOMPOSITRENAMETOT_FA_FAMONASSTACTCOMPOSIT;;--资产2--创建备份表CREATETABLEFAMONCOSTCENTERASSELECT*FROMT_FA_FAMONCOSTCENTERWHEREffamoncardidin(SELECTfidFROMT_FA_FAMONCARDWHEREffaperiodidin(selectfidfromtemptime));--drop原表droptableT_FA_FAMONCOSTCENTER;--修改表名ALTERTABLEFAMONCOSTCENTERRENAMETOT_FA_FAMONCOSTCENTER;--资产3--创建备份表CREATETABLEFAMONDEPARTMENTASSELECT*FROMT_FA_FAMONDEPARTMENTWHEREffamoncardidin(SELECTfidFROMT_FA_FAMONCARDWHEREffaperiodidin(selectfidfromtemptime));--drop原表droptableT_FA_FAMONDEPARTMENT;--修改表名ALTERTABLEFAMONDEPARTMENTRENAMETOT_FA_FAMONDEPARTMENT;--资产4--创建备份表CREATETABLEFAMONINITDATAASSELECT*FROMT_FA_FAMONINITDATAWHEREffamoncardidin(SELECTfidFROMT_FA_FAMONCARDWHEREffaperiodidin(selectfidfromtemptime));--drop原表droptableT_FA_FAMONINITDATA;--修改表名ALTERTABLEFAMONINITDATARENAMETOT_FA_FAMONINITDATA;--资产5--创建备份表CREATETABLEFAMONCARDASSELECT*FROMT_FA_FAMONCARDWHEREffaperiodidin(selectfidfromtemptime);--drop原表droptableT_FA_FAMONCARD;--修改表名ALTERTABLEFAMONCARDRENAMETOT_FA_FAMONCARD;--资产6--创建备份表CREATETABLEFAACCOUNTBALANCEASSELECT*FROMT_FA_FAACCOUNTBALANCEWHEREfperiodidin(selectfidfromtemptime);--drop原表droptableT_FA_FAACCOUNTBALANCE;--修改表名ALTERTABLEFAACCOUNTBALANCERENAMETOT_FA_FAACCOUNTBALANCE;-----------------------------------------------------------------------------------------------------------------------报表1--创建备份表createtableDataCheckageEntryasselect*FROMT_CSL_DataCheckageEntryWHEREFCheckageIDIN(SELECTFIDFROMT_CSL_InterDataCheckageWHEREFYear>=2021);--删除原表droptableT_CSL_DataCheckageEntry;--重命名表ALTERTABLEDATACHECKAGEENTRYRENAMETOT_CSL_DataCheckageEntry;--报表2--创建备份表CREATEtableINTERDATACHECKAGEASSELECT*FROMT_CSL_INTERDATACHECKAGEWHEREfyear>=2021;--删除原表droptableT_CSL_INTERDATACHECKAGE;--重命名表ALTERTABLEINTERDATACHECKAGERENAMETOT_CSL_INTERDATACHECKAGE;--报表3--创建备份表CREATEtableEXCHCHECKAGEENTRYASSELECT*FROMT_CSL_EXCHCHECKAGEENTRYWHEREfcheckageidIN(SELECTfidFROMt_csl_exchcheckageWHEREfyear>=2021);--删除原表droptableT_CSL_EXCHCHECKAGEENTRY;--重命名表ALTERTABLEEXCHCHECKAGEENTRYRENAMETOT_CSL_EXCHCHECKAGEENTRY;--报表4--创建备份表CREATEtableEXCHCHECKAGEASSELECT*FROMT_CSL_EXCHCHECKAGEWHEREfyear>=2021;--删除原表droptableT_CSL_EXCHCHECKAGE;--重命名表ALTERTABLEEXCHCHECKAGERENAMETOT_CSL_EXCHCHECKAGE;--新增默认值altertableT_CSL_DATACHECKAGEENTRYmodifyFDEBITdefault0;altertableT_CSL_DATACHECKAGEENTRYmodifyFCREDITdefault0;altertableT_CSL_DATACHECKAGEENTRYmodifyFVALIDEBITdefault0;altertableT_CSL_DATACHECKAGEENTRYmodifyFVALICREDITdefault0;altertableT_CSL_DATACHECKAGEENTRYmodifyFDATAELEMENTdefault4;altertableT_CSL_EXCHCHECKAGEmodifyFSINGLEDCdefault0;altertableT_CSL_EXCHCHECKAGEmodifyFDATACOLLECTNUMBERdefault'ACTUALDATA';altertableT_CSL_EXCHCHECKAGEmodifyFYEARdefault2050;altertableT_CSL_EXCHCHECKAGEmodifyFPERIODdefault1;altertableT_CSL_EXCHCHECKAGEmodifyFDIFFVALUEdefault1;altertableT_CSL_EXCHCHECKAGEmodifyFDIFFMODEdefault1;altertableT_CSL_EXCHCHECKAGEmodifyFPERIODTYPEdefault3;altertableT_CSL_EXCHCHECKAGEmodifyFCHECKEDSTATUSdefault1;altertableT_CSL_EXCHCHECKAGEmodifyFELIMSTATUSdefault1;altertableT_CSL_EXCHCHECKAGEmodifyFCONTROLUNITIDdefault'11111111-1111-1111-1111-111111111111CCE7AED4';altertableT_CSL_EXCHCHECKAGEENTRYmodifyFDEBITdefault0;altertableT_CSL_EXCHCHECKAGEENTRYmodifyFCREDITdefault0;altertableT_CSL_EXCHCHECKAGEENTRYmodifyFVALIDEBITdefault0;altertableT_CSL_EXCHCHECKAGEENTRYmodifyFVALICREDITdefault0;altertableT_CSL_INTERDATACHECKAGEmodifyFDIFFVALUEdefault1;altertableT_CSL_INTERDATACHECKAGEmodifyFDIFFMODEdefault1;altertableT_CSL_INTERDATACHECKAGEmodifyFPERIODTYPEdefault3;altertableT_CSL_INTERDATACHECKAGEmodifyFCHECKEDSTATUSdefault1;altertableT_CSL_INTERDATACHECKAGEmodifyFELIMSTATUSdefault1;altertableT_CSL_INTERDATACHECKAGEmodifyFCONTROLUNITIDdefault'11111111-1111-1111-1111-111111111111CCE7AED4';altertableT_CSL_INTERDATACHECKAGEmodifyFSINGLEDCdefault0;altertableT_CSL_INTERDATACHECKAGEmodifyFDATACOLLECTNUMBERdefault'ACTUALDATA';altertableT_CSL_INTERDATACHECKAGEmodifyFYEARdefault2050;altertableT_CSL_INTERDATACHECKAGEmodifyFPERIODdefault1;altertableT_FA_FAACCOUNTBALANCEmodifyFREALBEGINBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFREALDEBITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFREALCREDITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFREALENDBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDEPREBEGINBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDEPREDEBITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDEPRECREDITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDEPREENDBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFADDUPYEARDEPREdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDECVALUEBEGINBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDECVALUEDEBITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDECVALUECREDITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDECVALUEENDBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFEVALUEBEGINBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFEVALUEDEBITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFEVALUECREDITFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFEVALUEENDBALANCEFORdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFDEPRETERMdefault0;altertableT_FA_FAACCOUNTBALANCEmodifyFCONTROLUNITIDdefault'11111111-1111-1111-1111-111111111111CCE7AED4';altertableT_FA_FAMONCARDmodifyFASSETAMTdefault0;altertableT_FA_FAMONCARDmodifyFEXRATEdefault0;altertableT_FA_FAMONCARDmodifyFORIGINAMTdefault0;altertableT_FA_FAMONCARDmodifyFASSETVALUEdefault0;altertableT_FA_FAMONCARDmodifyFBUYVALUEdefault0;altertableT_FA_FAMONCARDmodifyFBUYACCUDEPRdefault0;altertableT_FA_FAMONCARDmodifyFDEPRTERMCOUNTdefault0;altertableT_FA_FAMONCARDmodifyFUSETERMCOUNTdefault0;altertableT_FA_FAMONCARDmodifyFLASTPERIODCHANGEdefault0;altertableT_FA_FAMONCARDmodifyFLATERPERIODDATAdefault0;altertableT_FA_FAMONCARDmodifyFINPUTTAXdefault0;altertableT_FA_FAMONCARDmodifyFLEFTYEARTWOdefault0;altertableT_FA_FAMONCARDmodifyFBARCODESTATUSdefault2;altertableT_FA_FAMONCARDmodifyFISREQUISITIONEDdefault0;altertableT_FA_FAMONCARDmodifyFISBORROWINGdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRTYEARdefault0;altertableT_FA_FAMONCARDmodifyFNEATREMVALUEdefault0;altertableT_FA_FAMONCARDmodifyFDECVALUEdefault0;altertableT_FA_FAMONCARDmodifyFNEATVALUEdefault0;altertableT_FA_FAMONCARDmodifyFNEATAMTdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRCHGdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRACCUCHGdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRACCUCLEANdefault0;altertableT_FA_FAMONCARDmodifyFDEPRTTERMdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRCHGTYEARdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRACCUCHGTYEARdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRACCUCLEANTYEARdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRALLdefault0;altertableT_FA_FAMONCARDmodifyFDECVALUECHGdefault0;altertableT_FA_FAMONCARDmodifyFDECVALUEACCUCHGdefault0;altertableT_FA_FAMONCARDmodifyFEVALLEFTPERIODdefault0;altertableT_FA_FAMONCARDmodifyFINITEVALVALUEdefault0;altertableT_FA_FAMONCARDmodifyFLASTEVALVALUEdefault0;altertableT_FA_FAMONCARDmodifyFORIGINDIFdefault0;altertableT_FA_FAMONCARDmodifyFORIGINACCUDIFdefault0;altertableT_FA_FAMONCARDmodifyFHASNEWdefault0;altertableT_FA_FAMONCARDmodifyFHASSPLITEDdefault0;altertableT_FA_FAMONCARDmodifyFISINITIALdefault0;altertableT_FA_FAMONCARDmodifyFACCUDEPRFORCALdefault0;altertableT_FA_FAMONCARDmodifyFLEFTYEARUPdefault0;altertableT_FA_FAMONCARDmodifyFDEPRCOUNTdefault0;altertableT_FA_FAMONCARDmodifyFLASTPERIODCOUNTdefault0;altertableT_FA_FAMONCARDmodifyFWELLDEPRVALUEdefault0;altertableT_FA_FAMONCARDmodifyFCONTROLUNITIDdefault'11111111-1111-1111-1111-111111111111CCE7AED4';altertableT_FA_FAMONCARDmodifyFTEMPDEPRTERMCOUNTdefault0;altertableT_FA_FAMONCARDmodifyFTEMPUSETERMCOUNTdefault0;altertableT_FA_FAMONCARDmodifyFISINITCHANGEdefault0;altertableT_FA_FAMONCARDmodifyFISEVALEDBEFOREdefault0;altertableT_FA_FAMONCARDmodifyFMONTHDEPRERATEdefault0;altertableT_FA_FAMONCARDmodifyFISOVERAGEDdefault0;altertableT_FA_FAMONCARDmodifyFFAIRVALUEdefault0;altertableT_FA_FAMONCARDmodifyFNEATLEFTRATEdefault0;altertableT_FA_FAMONCARDmodifyFADDONFAREdefault0;altertableT_FA_FAMONCARDmodifyFLEASESTATUSdefault0;altertableT_FA_FAMONCARDmodifyFGROUPNUMBERSTATUSdefault0;altertableT_FA_FAMONCOSTCENTERmodifyFAPPORTIONSCALEdefault0;altertableT_FA_FAMONINITDATAmodifyFASSETAMTDECQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFORIGINBEGINQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFORIGININCQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFORIGINDECQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFDEPRBEGINQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFDEPRINCQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFDEPRDECQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFDECVALUEBEGINQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFDECVALUEINCQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFDECVALUEDECQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFASSETAMTBEGINQTYdefault0;altertableT_FA_FAMONINITDATAmodifyFASSETAMTINCQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFBEGINBALANCEFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFDEBITFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFCREDITFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFENDBALANCEFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARDEBITFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARCREDITFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFENDBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFBEGINBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFENDBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFMONTHPNLFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARPNLFORdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFMONTHPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFMONTHPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFBEGINQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFENDQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFYEARCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1FmodifyFDETAILCOUNTdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFYEARCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFENDBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFYEARPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFMONTHPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFBEGINQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFYEARDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFYEARCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFENDQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFDETAILCOUNTdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1LmodifyFYEARDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFBEGINBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFYEARDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFYEARCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFENDBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFYEARPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFMONTHPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFBEGINQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFYEARDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFYEARCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFENDQTYdefault0;altertableT_GL_ACCOUNTBALANCE_1RmodifyFDETAILCOUNTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFBEGINBALANCEFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFDEBITFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFCREDITFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFENDBALANCEFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARDEBITFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARCREDITFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFENDBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFBEGINBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFENDBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFMONTHPNLFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARPNLFORdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFMONTHPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFMONTHPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFBEGINQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFENDQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFYEARCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5FmodifyFDETAILCOUNTdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFENDQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFDETAILCOUNTdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFYEARDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFYEARCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFDEBITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFCREDITLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFENDBALANCELOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFYEARPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFMONTHPNLLOCALdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFBEGINQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFYEARDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFYEARCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5LmodifyFDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFBEGINQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFYEARDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFYEARCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFDEBITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFCREDITQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFENDQTYdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFDETAILCOUNTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFBEGINBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFYEARDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFYEARCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFDEBITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFCREDITRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFENDBALANCERPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFYEARPNLRPTdefault0;altertableT_GL_ACCOUNTBALANCE_5RmodifyFMONTHPNLRPTdefault0;altertableT_GL_ACCTCUSSENTmodifyFSEQdefault1;altertableT_GL_ACCTCUSSENTmodifyFLOCALAMOUNTdefault0;altertableT_GL_ACCTCUSSENTmodifyFREPORTINGAMOUNTdefault0;altertableT_GL_ACCTCUSSENTmodifyFENTRYDCdefault0;altertableT_GL_ACCTCUSSENTmodifyFISINITdefault0;altertableT_GL_ACCTCUSSENTmodifyFISINITCLOSEDdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNVERIFIEDAMTFORdefault0;altertableT_GL_ACCTCUSSENTmodifyFORIGINALAMOUNTdefault0;altertableT_GL_ACCTCUSSENTmodifyFBOOKEDDATEdefaultTO_DATE('1970-01-01','YYYY-MM-DD');altertableT_GL_ACCTCUSSENTmodifyFISPOSTdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNVERIFIEDQTYdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNHOLDEDQTYdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNVERIFIEDSTDQTYdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNHOLDEDSTDQTYdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNHOLDEDAMTFORdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNVERIFIEDAMTLOCALdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNHOLDEDAMTLOCALdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNVERIFIEDAMTRPTdefault0;altertableT_GL_ACCTCUSSENTmodifyFUNHOLDEDAMTRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFBEGINBALANCEFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFDEBITFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFCREDITFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFENDBALANCEFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARDEBITFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARCREDITFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFDEBITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFCREDITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFENDBALANCELOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARDEBITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARCREDITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFBEGINBALANCERPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFDEBITRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFCREDITRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFENDBALANCERPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARDEBITRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARCREDITRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFMONTHPNLFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARPNLFORdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFMONTHPNLLOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARPNLLOCALdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFMONTHPNLRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARPNLRPTdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFBEGINQTYdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFDEBITQTYdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFCREDITQTYdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFENDQTYdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARDEBITQTYdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFYEARCREDITQTYdefault0;altertableT_GL_ASSISTBALANCE_1FmodifyFDETAILCOUNTdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFYEARDEBITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFYEARCREDITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFDEBITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFCREDITLOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFENDBALANCELOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFYEARPNLLOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFMONTHPNLLOCALdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFBEGINQTYdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFYEARDEBITQTYdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFYEARCREDITQTYdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFDEBITQTYdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFCREDITQTYdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFENDQTYdefault0;altertableT_GL_ASSISTBALANCE_1LmodifyFDETAILCOUNTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFYEARDEBITQTYdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFYEARCREDITQTYdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFDEBITQTYdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFCREDITQTYdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFENDQTYdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFDETAILCOUNTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFBEGINBALANCERPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFYEARDEBITRPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFYEARCREDITRPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFDEBITRPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFCREDITRPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFENDBALANCERPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFYEARPNLRPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFMONTHPNLRPTdefault0;altertableT_GL_ASSISTBALANCE_1RmodifyFBEGINQTYdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFBEGINBALANCEFORdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFDEBITFORdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFCREDITFORdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFENDBALANCEFORdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFYEARDEBITFORdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFYEARCREDITFORdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFBEGINBALANCELOCALdefault0;altertableT_GL_ASSISTBALANCE_5FmodifyFDEBITLOCALdefault0;altertableT_GL_ASSISTB...
