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

CORPORATE_GROUP (Name=“TST_GBU_BCG2”, Id=“2017485”)

-- 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                  )
;

Name=AIRBUS Id=100011

Einfach eine ASN für o.g. Corporate Group erstellen und unvollständig speichern. Dann den Job starten.

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.

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 & UX must be unique in the pool of both UX & 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 & UX must be unique in the pool of  both UX & 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 & UX must be unique in the pool of  both UX & 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 & UX must be unique in the pool of both UX & 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');

ID = 100011, Name = AIRBUS

-- restore archivable flag on all PO schedules with archivable=true
UPDATE tAirPOSchedule SET cArchivable=NULL WHERE CARCHIVABLE=1;

ID = 100011, Name = AIRBUS

Hier wird nur ein Report erstellt. Also muss man nichts wiederherstellen.

CORPORATE_GROUP (Name=“Airsupply Industrial Group”, Id=“100023”)
CUSTOMER_ORG (Name=“Airsupply Industrial”, Id=“101710”)
SUPPLIER_GROUP (Name=“Honeywell Aerospace”, Id=“100031”)

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');

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.