vwiki

User Tools

Site Tools

Trace:
airs-903_ux_dimensions_in_a_new_tab_in_da

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
airs-903_ux_dimensions_in_a_new_tab_in_da [2018/10/02 11:06] – kalaschnikowairs-903_ux_dimensions_in_a_new_tab_in_da [2018/10/17 14:03] (current) – [AIRS-907 Switch on customer profile] kalaschnikow
Line 1: Line 1:
 +====== AIRS-903 UX Dimensions in a new tab in DA ======
 +
 +[[https://doc.supplyon.de/display/S10058/UX+Dimensions+in+a+new+tab+in+DA|UX Dimensions in a new tab in DA]] - Spec in Confluence
 +
 +[[https://tasks.supplyon.de/browse/AIRS-908|AIRS-908 Enhance PO and VMI demand messages]]\\ 
 +  * My tasks:
 +    * [[https://tasks.supplyon.de/browse/AIRS-952|AIRS-952 VMI Demand XSD update]]
 +    * [[https://tasks.supplyon.de/browse/AIRS-954|AIRS-954 Import flag for VMI Demand]]
 +
 +===== AIRS-952 VMI Demand XSD update =====
 +
 +Flag-Name: ''PackagingDetailsMandatoryFlag''
 +
 +Auf der Header-Ebene.
 +
 +Nützliche SQLs:
 +<code sql>
 +SELECT a.CPACKDETAILSREQUIRED, a.CBATCHNUMREQUIRED, a.* FROM TAIRDEMANDS a 
 +where CDEMANDMATERIALID=1582214 order by cHeaderId;
 +
 +-- 1582214 ist die ID von dem (Customer) Material Number VVK_VMI_REGR_C001 .
 +-- Die ID kann man damit herausfinden:
 +
 +SELECT * FROM TAIRMATERIAL where CCUSTOMERMATERIALNUMBER like '%VVK%';
 +
 +</code>
 +
 +===== AIRS-907 Switch on customer profile =====
 +
 +Nicht ganz klar was zu tun ist. Die Aufgabe wurde zu 50% im Rahmen von [[https://cust-projects.seeburger.de/redmine/issues/22147|rm22174]] gelöst.
 +Die zusätzliche Spalte ist keine gute Idee, da dafür eigentlich die Tabelle ''TAIRFIELDCONFIG'' geschaffen wurde. Das Problem daran ist, dass die Tabelle auf der CustomerCP-Ebene ist.
 +
 +Nutzliche SQL Statements:
 +<code sql>
 +SELECT a.CPROFILEID, a.* FROM TCONTROLPOINT_SCD a where CCPID=101883
 +
 +update TCPPROFILES_SCD set CENABLEUXDIMENSIONS = 0 where cProfileId=1 -- CENABLEUXDIMENSIONS 0 oder 1
 +</code>
 +
 +SQL zum Einchecken (eingecheckt am 17.10.2018):
 +<code sql>
 +-- create new column in tAirFieldConfig
 +ALTER TABLE TAIRFIELDCONFIG ADD CCUSTOMERCPPROFILEID NUMBER(*,0) DEFAULT -1 NOT NULL;
 +
 +ALTER TABLE TAIRFIELDCONFIG DROP CONSTRAINT PKFIELDC;
 +
 +DROP INDEX PKFIELDC;
 +
 +CREATE UNIQUE INDEX "PKFIELDC" ON "TAIRFIELDCONFIG" ("CCUSTOMERCPID", "CCUSTOMERCPPROFILEID", "CPROCESS", "CFIELDNAME") 
 +  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
 +  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 +  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
 +  BUFFER_POOL KEEP FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 +  TABLESPACE "SCM_32K" ;
 +
 +
 +ALTER TABLE "TAIRFIELDCONFIG" ADD CONSTRAINT "PKFIELDC" PRIMARY KEY ("CCUSTOMERCPID", "CCUSTOMERCPPROFILEID", "CPROCESS", "CFIELDNAME")
 +  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
 +  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 +  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
 +  BUFFER_POOL KEEP FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 +  TABLESPACE "SCM_32K"  ENABLE;
 +
 +
 +</code>