vwiki

User Tools

Site Tools

Trace:
rm23486

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
rm23486 [2017/11/23 14:37] – [NCRCleanupJob] kalaschnikowrm23486 [2018/04/23 15:57] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +====== rm#23486 CR21921: OrgID als Schlüsselwert für die Jobparametrisierung ======
  
 +https://cust-projects.seeburger.de/redmine/issues/23486 (CR -> https://cust-projects.seeburger.de/redmine/issues/21921)
 +
 +  * Zusätzlich zum Namen sollen bestimmte Jobs eine Möglichkeit bekommen eine ID zu konfigurieren
 +    * Bedeutet: momentan ist der Name ein MUSS-Feld, in Zukunft soll das ein KANN-Feld werden
 +    * Aber: die Klasse XYZJob/JobInfo muss dafür sorgen, dass entweder der eine oder der andere Parameter da ist. Wenn keiner -> Exception werfen
 +  * Manchmal werden Parameter als Filter weitergegeben (z.B. an DAOImpl), manchmal aber werden sie als Methodenparameter weitergegeben. In diesem Fall muss man dafür sorgen, dass sie bis zum Verbraucher richtig weitergereicht werden.
 + 
 +  * XYZJobInfo enhält die Liste der möglichen Parameter 
 +
 +  * Liste der Jobs:
 +    * com.seeburger.airsupply.alertmon.job.DeleteAlerts
 +    * com.seeburger.airsupply.asn.manager.job.ASNCleanupJob
 +    * com.seeburger.airsupply.asn.manager.job.LateDespatchAdviceJob
 +    * com.seeburger.airsupply.asn.manager.job.ASNErrorReportCleanupJob
 +    * com.seeburger.airsupply.archive.client.job.AbstractArchivingJob
 +    * com.seeburger.airsupply.md.material.job.MaterialDataReportJob
 +    * com.seeburger.airsupply.ncr.job.NCRCleanupJob
 +    * com.seeburger.airsupply.otd.job.OTDKPIM2MReportJob
 +    * com.seeburger.airsupply.otd.job.OTDKPIReorgJob
 +    * com.seeburger.airsupply.otd.job.OTDLinesReorgJob
 +    * com.seeburger.airsupply.otd.job.OTDLinesReportJob
 +    * com.seeburger.airsupply.po.client.job.POActivityTimeoutNotifierJob
 +    * com.seeburger.airsupply.po.client.job.POAutoCommitJob
 +    * com.seeburger.airsupply.po.client.job.PoCollabReportCRExporter
 +    * com.seeburger.airsupply.po.client.job.POCollabReportV4ExporterJob
 +    * com.seeburger.airsupply.po.client.job.POFinalizerJob
 +    * com.seeburger.airsupply.po.client.job.PONoReceptionAlertJob
 +    * com.seeburger.airsupply.po.client.job.POStatusHistoryExporterJob
 +    * com.seeburger.airsupply.edi.messagemonitor.job.MessageMonitorReorg
 +    * com.seeburger.smarti.custom.so.routing.job.NetworkLinkReorganizationJob
 +    * com.seeburger.smarti.custom.so.routing.job.NetworkLinkReportJob
 +    * com.seeburger.smarti.custom.so.routing.job.NetworkLinkReportV2Job
 +
 +
 +===== DeleteAlerts =====
 +
 +CORPORATE_GROUP (Name="TST_GBU_BCG2", Id="2017485")
 +
 +<code sql>
 +-- Sätze, die vom Test-Job gelöscht werden, neu anlegen
 +
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756661,6,1001,10010,1,1568421,-1,1176,1568421,597,'  $$NULL$$',0,0,0,0,1303980930098,1303980930098,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756662,6,1001,10010,1,1568422,-1,1176,1568422,597,'  $$NULL$$',0,0,0,0,1303980951176,1303980951176,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756663,6,1001,10010,1,1568423,-1,1176,1568423,597,'  $$NULL$$',0,0,0,0,1303980957566,1303980957566,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756664,6,1001,10010,1,1568424,-1,1176,1568424,598,'  $$NULL$$',0,0,0,0,1303980967238,1303980967238,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756665,6,1001,10010,1,1568425,-1,1176,1568425,597,'  $$NULL$$',0,0,0,0,1303980969941,1303980969941,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756666,6,1001,10010,1,1568426,-1,1176,1568426,597,'  $$NULL$$',0,0,0,0,1303980969973,1303980969973,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756667,6,1001,10010,1,1568427,-1,1176,1568427,597,'  $$NULL$$',0,0,0,0,1303980971004,1303980971004,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +INSERT INTO tAirAlert (CID,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES (21756668,6,1001,10010,1,1568428,-1,1176,1568428,597,'  $$NULL$$',0,0,0,0,1303980971051,1303980971051,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,'$$NOTSUPPORTED$$');
 +
 +-- for wildcard (don't forget to set date offset to 10000!)
 +INSERT INTO tAirAlert 
 +(CID     ,CCATID,CTYPEID,CSTATID,CPRIORITY,COBJECTREFERENCE,CSUBOBJECTREFERENCE,CRELATIONID,CMATERIALID,CREFORDERINGOFFICERID,CSUPPLANNERCODE_ALERT,CIGNOREDBYCUSTOMER,CIGNOREDBYSUPPLIER,CREADBYCUSTOMER,CREADBYSUPPLIER,CDATEOCCURENCE,CDATECREATION,CDATEINACTIVATION,CFREEDECIMAL01,CFREEDECIMAL02,CFREEDECIMAL03,CFREEDECIMAL04,CFREEDECIMAL05,CFREEDECIMAL06,CFREEDECIMAL07,CFREEDECIMAL08,CFREEDECIMAL09,CFREEDECIMAL10,CFREETEXT01,CFREETEXT02,CFREETEXT03,CFREETEXT04,CFREETEXT05,CFREETEXT06,CFREETEXT07,CFREETEXT08,CFREETEXT09,CFREETEXT10,CFREETEXT11,CFREETEXT12,CFREETEXT13,CFREETEXT14,CFREEDATE01,CFREEDATE02,CFREEDATE03,CISASYNC,CCREATIONHOST,CRAISEDBYUSERNAME,CRAISEDBYUSERID,CINACTIVATEDBYUSERNAME,CINACTIVATEDBYUSERID,CPURCHASINGGROUP_ALERT) VALUES
 +(18128575,1     ,110    ,1101   ,2        ,1499777         ,-1                 ,765        ,1499777    ,209                  ,'  $$NULL$$'         ,0                 ,0                 ,0              ,0              ,1295564400000 ,1            ,0                ,0             ,null          ,null          ,null          ,null          ,null          ,null          ,null          ,null          ,null          ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,null       ,0          ,0          ,0          ,null         ,null         ,null             ,null           ,null                  ,null                ,null                  )
 +;
 +
 +</code>
 +
 +===== ASNCleanupJob =====
 +Name=AIRBUS    Id=100011
 +
 +Einfach eine ASN für o.g. Corporate Group erstellen und unvollständig speichern. Dann den Job starten.
 +===== LateDespatchAdviceJob =====
 +Getestet wurde mit folgender Konfiguration: CORPORATE_GROUP_NAME='AIRBUS', CORPORATE_GROUP_ID=100011.
 +
 +Der Job legt nur Alerts an, d.h. es ist nicht notwendig nach einem Lauf irgendwas wiederherzustellen.
 +
 +===== ASNErrorReportCleanupJob =====
 +
 +<code sql>
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (42,283,-1,-1,'HONEY','807317','Honeywell R_Redmond','441','UX  No. has already been declared for another shipment UX or UE in the past. Each UE &#38; UX must be unique in the pool of both UX &#38; UE Numbers.',1473341519000,'B000058693800002','466',null,null,null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M',null,null,null,null,null,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (44,283,-1,-1,'Honeywell R','807317','Honeywell R','401','UE No. has already been declared for another shipment UX or UE in the past. Each UE &#38; UX must be unique in the pool of  both UX &#38; UE Numbers.',1473341519000,'B000058693800002','466','080731700000000042','080731700000000066',null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M','#21928-02','car01','815-5S85PSGTK','51503130',1,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (43,283,-1,-1,'Honeywell R','807317','Honeywell R','401','UE No. has already been declared for another shipment UX or UE in the past. Each UE &#38; UX must be unique in the pool of  both UX &#38; UE Numbers.',1473341519000,'B000058693800002','466','080731700000000042','080731700000000059',null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M','#21928-01','car01','815-5S85PSGTK','51503130',1,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (41,283,-1,-1,'HONEY','807317','Honeywell R_Redmond','441','UX  No. has already been declared for another shipment UX or UE in the past. Each UE &#38; UX must be unique in the pool of both UX &#38; UE Numbers.',1473341519000,'B000058693800002','466',null,null,null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M',null,null,null,null,null,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (46,283,-1,-1,'HONEY','807317','Honeywell R_Redmond','461','last digit of the No. The correct checksum value is 3.',1473341519000,'B000058693800002','466',null,null,null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M',null,null,null,null,null,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (45,283,-1,-1,'HONEY','807317','Honeywell R_Redmond','461','last digit of the No. The correct checksum value is 3.',1473341519000,'B000058693800002','466',null,null,null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M',null,null,null,null,null,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (48,283,-1,-1,'Honeywell R','807317','Honeywell R','461','last digit of the No. The correct checksum value is 7.',1473341519000,'B000058693800002','466','080731700000000072','080731700000000096',null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M','#21928-02','car01','815-5S85PSGTK','51503130',1,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (47,283,-1,-1,'Honeywell R','807317','Honeywell R','461','last digit of the No. The correct checksum value is 0.',1473341519000,'B000058693800002','466','080731700000000072','080731700000000089',null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M','#21928-01','car01','815-5S85PSGTK','51503130',1,'Honeywell Redmond','Redmond','US');
 +INSERT INTO TAIRASN_ERROR (CERRORID,CRELATIONID,CREFORDERINGOFFICERID,CREFMATID,CSUPPLIERNAME,CSUPPLIERNUMBER,CSUPPLIERSITE,CERRORCODE,CERRORTEXT,CERRORDATE,CAS2MESSAGEID,CDESPATCHADVICEID,CUXNUMBER,CUENUMBER,CDATYPE,CDACREATIONMODE,CSUPPLIERORGANISATION,CSUPPLIERGROUP,CCUSTOMERNAME,CCUSTOMERPLANTCODE,CSHIPTOADDRESSID,CFINALDELIVERYLOCATION,CPOVMIREFERENCE,CPOLINE,CSUPPLIERMATERIALNUMBER,CCUSTOMERMATERIALNUMBER,CSHIPPEDQUANTITY,CSHIPFROMNAME,CSHIPFROMCITY,CSHIPFROMCOUNTRYCODE) VALUES (49,283,-1,-1,'Honeywell R','807317','Honeywell R','461','last digit of the No. The correct checksum value is 0.',1473341519000,'B000058693800002','466','080731700000000073','080731700000000089',null,'U','HONEY','Honeywell Aerospace','AFR_FAL','FAL','AIRBUS USINE LOUIS BREGUET','SDD/DA030/MT80M','#21928-01','car01','815-5S85PSGTK','51503130',1,'Honeywell Redmond','Redmond','US');
 +</code>
 +
 +===== POSLArchiveFlagJob (Beispiel für AbstractArchivingJob) =====
 +
 +ID = 100011, Name = AIRBUS
 +
 +<code sql>
 +-- restore archivable flag on all PO schedules with archivable=true
 +update tAirPOSchedule set cArchivable=null where CARCHIVABLE=1;
 +</code>
 +
 +===== MaterialDataReportJob =====
 +
 +ID = 100011, Name = AIRBUS
 +
 +Hier wird nur ein Report erstellt. Also muss man nichts wiederherstellen.
 +
 +===== NCRCleanupJob =====
 +
 +CORPORATE_GROUP (Name=“Airsupply Industrial Group”, Id=“100023”)\\ 
 +CUSTOMER_ORG (Name=“Airsupply Industrial”, Id=“101710”)\\ 
 +SUPPLIER_GROUP (Name=“Honeywell Aerospace”, Id=“100031”)\\ 
 +
 +
 +<code sql>
 +INSERT INTO TAIRNCRHEADER (CNCRHEADERID,CREFRELATIONID,CREFOFFICERID,CREFMATID,CEDICREATIONDATE,CEDIRECEIVINGDATE,CEDIMESSAGEID,CEDIMESSAGETEXT,CEDISENDER,CEDIRECEIVER,CSUPPREFNO,CSUPPREV,CCUSTREFNO,CCUSTREV,CTITLE,CSTATUS,CDESCRIPTION1,CDESCRIPTION2,CMATTYPECODE,CCUSTPROGRAM,CREFPONUM,CREFPOLINENUM,CREFPOLINEQUANTSUM,CBATCHNUM,CAFFECTEDQUANTITY,CDETECTEDDURING,COBSERVATIONDATE,CRELATEDNCR,CROOTCAUSEDETAIL,CCORRECTIVEACTION,CPRODUCTCATEGORY,CSUPPRFDRFWREF,CCUSTRFDRFWREF,CSUPPCREATORNAME,CGRAVITY,CDISPOSITION,CCATEGORY,CCUSTTECHAPPRONAME,CCUSTTECHAPPROFUNC,CTECHAPPROVALDATE,CCUSTQUALAPPRONAME,CCUSTQUALAPPROFUNC,CQUALAPPROVALDATE,CADDCOMMENTS,CDOCREF,CDOCREFINDEX,CLIMITDESC,CDRAFTCREATIONDATE,CFIRSTSUBMITDATE,CLASTMODDATE,CCLOSUREDATE,CHFLEXFIELD1,CHFLEXFIELD2,CHFLEXFIELD3,CHFLEXFIELD4,CHFLEXFIELD5,CHFLEXFIELD6,CHFLEXFIELD7,CHFLEXFIELD8,CHFLEXFIELD9,CHFLEXFIELD10,CUSERID,CREFPOLINEID,CREFPORSNUM,CLASTDEFECTNUMBER,CREADBYCUST,CREADBYSUP) VALUES (704,1974,76,1571523,0,0,null,null,null,null,'HLI 009','HLI 009',null,null,'HLI 009','SCRAP','HLI 009',null,'M1','cus prog','$$NO_PO_AFFECTED$$',null,null,'batch',3,'detected',1380240000000,'rel ncr','root cause','corrective action',null,'supp rfd',null,'Joseph Hidalgo',null,null,null,null,null,0,null,null,0,null,'doc ref','03',null,1381325179356,1385030114731,1407165094284,0,null,null,null,null,null,null,null,null,0,0,'SMA0000NN11E',null,null,1,0,1);
 +INSERT INTO TAIRNCR_SERIALNO (CNCRHEADERID,CSNOPOSNR,CSERIALNO) VALUES (704,1,'abc');
 +</code>
 +
 +===== OTDKPIM2MReportJob =====
 +CUSTOMER_CORPORATE_GROUP (Name=“AIRBUS”, Id=“100011”)\\ 
 +CUSTOMER_ORG (Name=“Airbus France”, Id=“101700”)\\ 
 +
 +Hier wird nur ein Report erstellt. Man muss eigentlich nichts wiederherstellen.