rm#23486 CR21921: OrgID als Schlüsselwert für die Jobparametrisierung

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

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

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

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

POSLArchiveFlagJob (Beispiel für AbstractArchivingJob)

ID = 100011, Name = AIRBUS

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

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

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

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.

Table of Contents