vwiki

Edit the page and hit Save. See syntax for Wiki syntax. Please edit the page only if you can improve it. If you want to test some things, learn to make your first steps on the playground.

====== 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>

Edit summary

Note: By editing this page you agree to license your content under the following license: CC Attribution-Share Alike 4.0 International