zOs/TX/WK951DDL
SET CURRENT SQLID='S100447';
SET CURRENT SCHEMA='$creator';
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","$creator" ;
drop TABLESPACE $db.A951A ;
drop TABLESPACE $db.A951B ;
commit;
$@[ if $phase > 0 then $@=[
CREATE TABLESPACE A951A
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
DSSIZE 4 G
NUMPARTS 3
BUFFERPOOL BP2
LOCKSIZE ROW
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
CREATE TABLESPACE A951B
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
DSSIZE 4 G
NUMPARTS 3
BUFFERPOOL BP2
LOCKSIZE ROW
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
CREATE TABLE $creator.TWK951A1
(WK95101 INTEGER NOT NULL,
WK95102 CHAR(16) FOR SBCS DATA NOT NULL,
WK95103 DATE NOT NULL,
WK95104 INTEGER NOT NULL,
WK95105 CHAR(4) FOR SBCS DATA NOT NULL,
WK95106 CHAR(5) FOR SBCS DATA NOT NULL,
WK95107 CHAR(1) FOR SBCS DATA NOT NULL,
WK95108 CHAR(1) FOR SBCS DATA NOT NULL,
WK95109 CHAR(48) FOR SBCS DATA NOT NULL,
WK95110 CHAR(1) FOR SBCS DATA NOT NULL,
WK95111 DATE NOT NULL,
WK95112 DATE NOT NULL,
WK95113 DATE NOT NULL,
WK95114 CHAR(4) FOR SBCS DATA NOT NULL,
WK95115 CHAR(1) FOR SBCS DATA NOT NULL,
WK95116 SMALLINT NOT NULL,
WK95117 CHAR(4) FOR SBCS DATA NOT NULL,
WK95118 CHAR(32) FOR SBCS DATA NOT NULL,
WK95119 CHAR(32) FOR SBCS DATA NOT NULL,
WK95120 CHAR(4) FOR SBCS DATA NOT NULL,
WK95121 CHAR(4) FOR SBCS DATA NOT NULL,
WK95122 CHAR(4) FOR SBCS DATA NOT NULL,
WK95123 CHAR(8) FOR SBCS DATA NOT NULL,
WK95124 TIMESTAMP NOT NULL,
WK95125 TIMESTAMP NOT NULL,
WK95126 DATE NOT NULL,
WK95127 TIME NOT NULL,
WK95128 FLOAT NOT NULL,
WK95129 DECIMAL(31, 8) NOT NULL,
WK95130 DECIMAL(31, 8) NOT NULL,
WK95131 DECIMAL(31, 8) NOT NULL,
WK95132 DECIMAL(31, 8) NOT NULL,
WK95133 DECIMAL(31, 8) NOT NULL,
WK95134 CHAR(15) FOR SBCS DATA NOT NULL,
WK95135 CHAR(1) FOR SBCS DATA NOT NULL,
WK95136 DATE NOT NULL,
WK95137 CHAR(10) FOR SBCS DATA NOT NULL,
WK95138 CHAR(12) FOR SBCS DATA NOT NULL,
WK95139 CHAR(3) FOR SBCS DATA NOT NULL,
WK95140 CHAR(3) FOR SBCS DATA NOT NULL,
WK95141 CHAR(3) FOR SBCS DATA NOT NULL,
WK95142 CHAR(3) FOR SBCS DATA NOT NULL,
WK95143 CHAR(4) FOR SBCS DATA NOT NULL,
WK95144 CHAR(4) FOR SBCS DATA NOT NULL,
WK95145 DATE NOT NULL,
WK95146 CHAR(8) FOR SBCS DATA NOT NULL,
WK95147 TIMESTAMP NOT NULL WITH DEFAULT,
WK95148 DECIMAL(31, 8) NOT NULL,
WK95149 CHAR(1) FOR SBCS DATA NOT NULL,
WK95150 CHAR(1) FOR SBCS DATA NOT NULL,
WK95151 CHAR(1) FOR SBCS DATA NOT NULL,
$@[ if $phase >= 2 then $@=[
WK95152 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WK95153 SMALLINT NOT NULL WITH DEFAULT,
WK95154 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WK95155 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WK95156 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WK95157 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
$]
$]
CONSTRAINT WK95101
PRIMARY KEY (WK95101,
WK95102,
WK95103,
WK95104))
IN $db.A951A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
$*(
--
LABEL ON TABLE $creator.TWK951A1 IS 'ABS';
--
COMMENT ON TABLE $creator.TWK951A1 IS 'Abschluss';
--
LABEL ON $creator.TWK951A1
(
$@[ if $phase >= 2 then $@=[
WK95157 IS 'OE-Kundenverantwortung',
WK95156 IS 'Segmentcode',
WK95155 IS 'Converting BUID',
WK95154 IS 'Auftragsnummer',
WK95153 IS 'Rundunsposition BWhrg',
WK95152 IS 'Rundungsart BWhrg',
$]
$]
WK95151 IS 'Pflegedatum',
WK95150 IS 'Pflegestufe',
WK95149 IS 'Pflegestatus',
WK95148 IS 'Sprache',
WK95147 IS 'Startsaldo KWHRG',
WK95146 IS 'Mutationstimestamp',
WK95145 IS 'Mutations PID',
WK95144 IS 'GAAPID',
WK95143 IS 'BUID',
WK95142 IS 'KAS',
WK95141 IS 'Nationalität',
WK95140 IS 'Domizil',
WK95139 IS 'Kundenart',
WK95138 IS 'CIFNR',
WK95137 IS 'Nachvollzugshauptbuch',
WK95136 IS 'Zinsausweiss Datum',
WK95135 IS 'Ind. ZAW erstellt',
WK95134 IS 'Ind. DB2 Tabelle',
WK95133 IS 'Total AS-Rechnung',
WK95132 IS 'Valutasaldo nach AS',
WK95131 IS 'Valutasaldo KWHRG',
WK95130 IS 'Saldo AS-Buchung BWHRG',
WK95129 IS 'Saldo AS-Buchung KWHRG',
WK95128 IS 'Kurs ',
WK95127 IS 'Kurszeit',
WK95126 IS 'Kursdatum',
WK95125 IS 'AS Erstellung Geldbew.',
WK95124 IS 'AS Erstellung Geldbew.',
WK95123 IS 'Auslöser',
WK95122 IS 'ST Fehlern ',
WK95121 IS 'ST Warnungen',
WK95120 IS 'ST Informationen',
WK95119 IS 'AS Warnungen',
WK95118 IS 'AS Informationen',
WK95117 IS 'Bwhrg',
WK95116 IS 'Rundungsposition',
WK95115 IS 'Rundungsart',
WK95114 IS 'Kwhrg',
WK95113 IS 'AS Valutadatum Von',
WK95112 IS 'Buchungsdatum Bis',
WK95111 IS 'Buchungsdatum Von',
WK95110 IS 'Abgrenzung',
WK95109 IS 'AS Flag',
WK95108 IS 'AS Status',
WK95107 IS 'Storno Info',
WK95106 IS 'AS Art',
WK95105 IS 'Release',
WK95104 IS 'AS Lfnr',
WK95103 IS 'AS Valutadatum Bis',
WK95102 IS 'Techbez',
WK95101 IS 'ProcBase');
$*)
CREATE UNIQUE INDEX $creator.IWK951A1
ON $creator.TWK951A1
(WK95101 ASC,
WK95102 ASC,
WK95103 ASC,
WK95104 ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(800),
PART 2 VALUES(1600)
,PART 3 VALUES(2400)
$*(
,PART 4 VALUES(3200),
PART 5 VALUES(4000),
PART 6 VALUES(4800),
PART 7 VALUES(5600),
PART 8 VALUES(6400),
PART 9 VALUES(7200),
PART 10 VALUES(8000),
PART 11 VALUES(8800),
PART 12 VALUES(9600),
PART 13 VALUES(10400),
PART 14 VALUES(11200),
PART 15 VALUES(12000),
PART 16 VALUES(12800),
PART 17 VALUES(13600),
PART 18 VALUES(14400),
PART 19 VALUES(15200),
PART 20 VALUES(16000),
PART 21 VALUES(16800),
PART 22 VALUES(17600),
PART 23 VALUES(18400),
PART 24 VALUES(19200),
PART 25 VALUES(20000),
PART 26 VALUES(20800),
PART 27 VALUES(21600),
PART 28 VALUES(22400),
PART 29 VALUES(23200),
PART 30 VALUES(24000),
PART 31 VALUES(24800),
PART 32 VALUES(25600)
$*)
)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
CREATE TABLE $creator.TWK951B1
(WK951001 INTEGER NOT NULL,
WK951002 CHAR(16) FOR SBCS DATA NOT NULL,
WK951003 DATE NOT NULL,
WK951004 INTEGER NOT NULL,
WK951005 DATE NOT NULL,
WK951006 CHAR(1) FOR SBCS DATA NOT NULL,
WK951007 CHAR(4) FOR SBCS DATA NOT NULL,
WK951008 DECIMAL(5, 0) NOT NULL,
WK951009 DATE NOT NULL,
WK951010 CHAR(1) FOR SBCS DATA NOT NULL,
WK951011 CHAR(1) FOR SBCS DATA NOT NULL,
WK951012 CHAR(4) FOR SBCS DATA NOT NULL,
WK951013 CHAR(20) FOR SBCS DATA NOT NULL,
WK951014 CHAR(1) FOR SBCS DATA NOT NULL,
WK951015 FLOAT NOT NULL,
WK951016 FLOAT NOT NULL,
WK951017 FLOAT NOT NULL,
WK951018 FLOAT NOT NULL,
WK951019 FLOAT NOT NULL,
WK951020 FLOAT NOT NULL,
WK951021 FLOAT NOT NULL,
WK951022 FLOAT NOT NULL,
WK951023 FLOAT NOT NULL,
WK951024 FLOAT NOT NULL,
WK951025 DECIMAL(31, 8) NOT NULL,
WK951026 DECIMAL(31, 8) NOT NULL,
WK951027 DECIMAL(31, 8) NOT NULL,
WK951028 DECIMAL(31, 8) NOT NULL,
WK951029 DECIMAL(31, 8) NOT NULL,
WK951030 DECIMAL(31, 8) NOT NULL,
WK951031 DECIMAL(31, 8) NOT NULL,
WK951032 DECIMAL(31, 8) NOT NULL,
WK951033 DECIMAL(31, 8) NOT NULL,
WK951034 DECIMAL(31, 8) NOT NULL,
WK951035 CHAR(1) FOR SBCS DATA NOT NULL,
WK951036 CHAR(1) FOR SBCS DATA NOT NULL,
WK951037 CHAR(1) FOR SBCS DATA NOT NULL,
WK951038 FLOAT NOT NULL,
WK951039 FLOAT NOT NULL,
WK951040 FLOAT NOT NULL,
WK951041 FLOAT NOT NULL,
WK951042 FLOAT NOT NULL,
WK951043 FLOAT NOT NULL,
WK951044 FLOAT NOT NULL,
WK951045 FLOAT NOT NULL,
WK951046 FLOAT NOT NULL,
WK951047 FLOAT NOT NULL,
WK951048 DECIMAL(31, 8) NOT NULL,
WK951049 DECIMAL(31, 8) NOT NULL,
WK951050 DECIMAL(31, 8) NOT NULL,
WK951051 DECIMAL(31, 8) NOT NULL,
WK951052 DECIMAL(31, 8) NOT NULL,
WK951053 DECIMAL(31, 8) NOT NULL,
WK951054 DECIMAL(31, 8) NOT NULL,
WK951055 DECIMAL(31, 8) NOT NULL,
WK951056 DECIMAL(31, 8) NOT NULL,
WK951057 DECIMAL(31, 8) NOT NULL,
WK951058 DECIMAL(31, 8) NOT NULL,
WK951059 CHAR(1) FOR SBCS DATA NOT NULL,
WK951060 CHAR(1) FOR SBCS DATA NOT NULL,
WK951061 FLOAT NOT NULL,
WK951062 FLOAT NOT NULL,
WK951063 CHAR(1) FOR SBCS DATA NOT NULL,
WK951064 CHAR(1) FOR SBCS DATA NOT NULL,
WK951065 CHAR(1) FOR SBCS DATA NOT NULL,
WK951066 FLOAT NOT NULL,
WK951067 FLOAT NOT NULL,
WK951068 FLOAT NOT NULL,
WK951069 FLOAT NOT NULL,
WK951070 FLOAT NOT NULL,
WK951071 DECIMAL(31, 8) NOT NULL,
WK951072 DECIMAL(31, 8) NOT NULL,
WK951073 DECIMAL(31, 8) NOT NULL,
WK951074 DECIMAL(31, 8) NOT NULL,
WK951075 CHAR(1) FOR SBCS DATA NOT NULL,
WK951076 CHAR(1) FOR SBCS DATA NOT NULL,
WK951077 FLOAT NOT NULL,
WK951078 CHAR(1) FOR SBCS DATA NOT NULL,
WK951079 CHAR(1) FOR SBCS DATA NOT NULL,
WK951080 FLOAT NOT NULL,
WK951081 DECIMAL(31, 8) NOT NULL,
WK951082 CHAR(1) FOR SBCS DATA NOT NULL,
WK951083 CHAR(1) FOR SBCS DATA NOT NULL,
WK951084 FLOAT NOT NULL,
WK951085 DECIMAL(31, 8) NOT NULL,
WK951086 CHAR(1) FOR SBCS DATA NOT NULL,
WK951087 CHAR(1) FOR SBCS DATA NOT NULL,
WK951088 CHAR(1) FOR SBCS DATA NOT NULL,
WK951089 FLOAT NOT NULL,
WK951090 DECIMAL(31, 8) NOT NULL,
WK951091 DECIMAL(31, 8) NOT NULL,
WK951092 FLOAT NOT NULL,
WK951093 CHAR(8) FOR SBCS DATA NOT NULL,
WK951094 TIMESTAMP NOT NULL WITH DEFAULT,
$@[ if $phase >= 2 then $@=[
WK951095 DATE NOT NULL WITH DEFAULT,
$]
$]
CONSTRAINT WK951001
PRIMARY KEY (WK951001,
WK951002,
WK951003,
WK951004,
WK951005))
IN $db.A951B
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
$*(
LABEL ON TABLE $creator.TWK951B1 IS 'kos';
COMMENT ON TABLE $creator.TWK951B1 IS 'kos';
LABEL ON $creator.TWK951B1
(
$@[ if $phase >= 2 then $@=[
WK951095 IS 'Buchungsdatum bis',
$]
$]
WK951094 IS 'Mutations Timestamp',
WK951093 IS 'Mutations PID',
WK951092 IS 'Verrechnungssteuersatz',
WK951091 IS 'Verrechnungssteuer freier Betr',
WK951090 IS 'Mind.Metallkontokom',
WK951089 IS 'Metallkontokom.Satz',
WK951088 IS 'Ber.verfahren Metallkontokom',
WK951087 IS 'Periodiz. Mind.Metallkontokom',
WK951086 IS 'Periodiz. Metallkontokom',
WK951085 IS 'Abgrenz.limite Über.Komm',
WK951084 IS 'Überschreit.kom.Satz',
WK951083 IS 'Ber.verfahren Überschreit.kom',
WK951082 IS 'Periodiz.Überschreit.kom',
WK951081 IS 'Abgrenz.limite Bereitst.kom',
WK951080 IS 'Bereitstellungskom.Satz',
WK951079 IS 'Ber.verfahren Bereitst.kom.',
WK951078 IS 'Periodiz.Bereitst.kom.',
WK951077 IS 'Treuhandkom.Satz',
WK951076 IS 'Ber.verfahren Treuhandkom.',
WK951075 IS 'Periodiz.Treuhandkomm.Satz',
WK951074 IS 'Mind.Kreditkom.',
WK951073 IS 'Abgrenzungslimite 3',
WK951072 IS 'Abgrenzungslimite 2',
WK951071 IS 'Abgrenzungslimite 1',
WK951070 IS 'Obere Grenze Kreditkom.',
WK951069 IS 'Kreditkom.Satz 4',
WK951068 IS 'Kreditkom.Satz 3',
WK951067 IS 'Kreditkom.Satz 2',
WK951066 IS 'Kreditkom.Satz 1',
WK951065 IS 'Ber.verfahren Kreditkom',
WK951064 IS 'Periodiz.mind.Kreditkom',
WK951063 IS 'Periodiz.Kreditkomm.satz',
WK951062 IS 'Referenzzinssatz Soll',
WK951061 IS 'Referenzzinssatz Haben',
WK951060 IS 'SZ-Limitenart',
WK951059 IS 'SZ-Verzinsungsart',
WK951058 IS 'Sollzinsminimum',
WK951057 IS 'Verz.limite 10 SZ',
WK951056 IS 'Verz.limite 9 SZ',
WK951055 IS 'Verz.limite 8 SZ',
WK951054 IS 'Verz.limite 7 SZ',
WK951053 IS 'Verz.limite 6 SZ',
WK951052 IS 'Verz.limite 5 SZ',
WK951051 IS 'Verz.limite 4 SZ',
WK951050 IS 'Verz.limite 3 SZ',
WK951049 IS 'Verz.limite 2 SZ',
WK951048 IS 'Verz.limite 1 SZ',
WK951047 IS 'Sollzinsatz 10',
WK951046 IS 'Sollzinsatz 9',
WK951045 IS 'Sollzinsatz 8',
WK951044 IS 'Sollzinsatz 7',
WK951043 IS 'Sollzinsatz 6',
WK951042 IS 'Sollzinsatz 5',
WK951041 IS 'Sollzinsatz 4',
WK951040 IS 'Sollzinsatz 3',
WK951039 IS 'Sollzinsatz 2',
WK951038 IS 'Sollzinsatz 1',
WK951037 IS 'Periodiz. SZ-Satz',
WK951036 IS 'HZ-Verzinsungsart',
WK951035 IS 'HZ-Limitenart',
WK951034 IS 'Verz.limite 10 HZ',
WK951033 IS 'Verz.limite 9 HZ',
WK951032 IS 'Verz.limite 8 HZ',
WK951031 IS 'Verz.limite 7 HZ',
WK951030 IS 'Verz.limite 6 HZ',
WK951029 IS 'Verz.limite 5 HZ',
WK951028 IS 'Verz.limite 4 HZ',
WK951027 IS 'Verz.limite 3 HZ',
WK951026 IS 'Verz.limite 2 HZ',
WK951025 IS 'Verz.limite 1 HZ',
WK951024 IS 'Habenzinsatz 10',
WK951023 IS 'Habenzinsatz 9',
WK951022 IS 'Habenzinsatz 8',
WK951021 IS 'Habenzinsatz 7',
WK951020 IS 'Habenzinsatz 6',
WK951019 IS 'Habenzinsatz 5',
WK951018 IS 'Habenzinsatz 4',
WK951017 IS 'Habenzinsatz 3',
WK951016 IS 'Habenzinsatz 2',
WK951015 IS 'Habenzinsatz 1',
WK951014 IS 'Periodiz. HZ Satz',
WK951013 IS 'KOS Ind.',
WK951012 IS 'KOS WHRG',
WK951011 IS 'Akt.ZSK Stuffe',
WK951010 IS 'Kalenderusanz',
WK951009 IS 'Datum von KOS',
WK951008 IS 'DefaultNr',
WK951007 IS 'Release',
WK951006 IS 'AS Status',
WK951005 IS 'Datum bis KOS',
WK951004 IS 'AS Laufnr',
WK951003 IS 'AS valutadatum bis',
WK951002 IS 'Techbez',
WK951001 IS 'ProcBase');
$*)
CREATE UNIQUE INDEX $creator.IWK951B1
ON $creator.TWK951B1
(WK951001 ASC,
WK951002 ASC,
WK951003 ASC,
WK951004 ASC,
WK951005 ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(800),
PART 2 VALUES(1600)
,PART 3 VALUES(2400)
$*(
,PART 4 VALUES(3200),
PART 5 VALUES(4000),
PART 6 VALUES(4800),
PART 7 VALUES(5600),
PART 8 VALUES(6400),
PART 9 VALUES(7200),
PART 10 VALUES(8000),
PART 11 VALUES(8800),
PART 12 VALUES(9600),
PART 13 VALUES(10400),
PART 14 VALUES(11200),
PART 15 VALUES(12000),
PART 16 VALUES(12800),
PART 17 VALUES(13600),
PART 18 VALUES(14400),
PART 19 VALUES(15200),
PART 20 VALUES(16000),
PART 21 VALUES(16800),
PART 22 VALUES(17600),
PART 23 VALUES(18400),
PART 24 VALUES(19200),
PART 25 VALUES(20000),
PART 26 VALUES(20800),
PART 27 VALUES(21600),
PART 28 VALUES(22400),
PART 29 VALUES(23200),
PART 30 VALUES(24000),
PART 31 VALUES(24800),
PART 32 VALUES(25600)
$*)
)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
$*(
$@[ if $phase <= 1 then $@=[
CREATE VIEW $creator.VWK951A1
(PROCBASE, TECHBEZ, AS_VDAT_BIS, AS_LFNR,
REL_NR, AS_ART, STORNO_INFO, AS_STATUS, AS_FLAG, ABGRENZUNG,
AS_BDAT_VON, AS_BDAT_BIS, AS_VDAT_VON, KWHRG, KWHRG_RUND_ART,
KWHRG_RUND_POS, BWHRG, AS_INFO, AS_WARNUNG, ST_INFO, ST_WARNUNG,
ST_FEHLER, AUSLOESER, AS_ERST_GB_VON, AS_ERST_GB_BIS, KURS_DAT,
KURS_ZEIT, KURS, AS_BEW_KWHRG, AS_BEW_BWHRG, VSALDO_KWHRG,
VSALDO_KWHRG_N_AS, TOT_ABS_RECH_KWHRG, IND_TAB, ZAW_ERST,
ZAW_DAT, NVZ_HB, CIFNR, KUART, DOMIZIL, NATION, KAS, BUID,
GAAPID, PFLEGE_DAT, MUT_PID, MUT_TMSTP, START_VSALDO_KWHRG,
SPRACHE, PFLEGE_STATUS, PFLEGE_STUFE) AS
SELECT *
FROM $creator.TWK951A1 ;
$] else $@=[
CREATE VIEW $creator.VWK951A1(PROCBASE, TECHBEZ, AS_VDAT_BIS,
AS_LFNR, REL_NR, AS_ART, STORNO_INFO, AS_STATUS, AS_FLAG,
ABGRENZUNG, AS_BDAT_VON, AS_BDAT_BIS, AS_VDAT_VON, KWHRG,
KWHRG_RUND_ART, KWHRG_RUND_POS, BWHRG, BWHRG_RUND_ART,
BWHRG_RUND_POS, AS_INFO, AS_WARNUNG, ST_INFO, ST_WARNUNG,
ST_FEHLER, AUSLOESER, AS_ERST_GB_VON, AS_ERST_GB_BIS, KURS_DAT,
KURS_ZEIT, KURS, AS_BEW_KWHRG, AS_BEW_BWHRG, VSALDO_KWHRG,
START_VSALDO_KWHRG, VSALDO_KWHRG_N_AS, TOT_ABS_RECH_KWHRG,
IND_TAB, ZAW_ERST, ZAW_DAT, AUFTRAGSNR, NVZ_HB, CIFNR, KUART,
DOMIZIL, NATION, KAS, SEGM_CD, OE_KV, BUID, CONV_BUID_CNBX1,
GAAPID, SPRACHE, PFLEGE_DAT, PFLEGE_STATUS, PFLEGE_STUFE,
MUT_PID, MUT_TMSTP) AS
SELECT WK95101, WK95102, WK95103, WK95104, WK95105, WK95106,
WK95107, WK95108, WK95109, WK95110, WK95111, WK95112,
WK95113, WK95114, WK95115, WK95116, WK95117, WK95151,
WK95152, WK95118, WK95119, WK95120, WK95121, WK95122,
WK95123, WK95124, WK95125, WK95126, WK95127, WK95128,
WK95129, WK95130, WK95131, WK95148, WK95132, WK95133,
WK95134, WK95135, WK95136, WK95154, WK95137, WK95138,
WK95139, WK95140, WK95141, WK95142, WK95156, WK95157,
WK95143, WK95155, WK95144, WK95149, WK95145, WK95150,
WK95151, WK95146, WK95147
FROM $creator.TWK951A1 ;
$]
$]
LABEL ON TABLE $creator.VWK951A1 IS 'view abs';
COMMENT ON TABLE $creator.VWK951A1 IS 'view abs';
$*)
$*(
COMMIT;
CREATE VIEW $creator.VWK951B1(PROCBASE, TECHBEZ, AS_VDAT_BIS,
AS_LFNR, KOS_DAT_BIS, AS_BDAT_BIS, AS_STATUS, REL_NR,
DEFAULT_NR, KOS_DAT_VON, KAL_USANZ, ZSKAKT, KOS_WHRG, KOS_IND,
HZ_SATZ_PERIOD, HZ_SATZ01, HZ_SATZ02, HZ_SATZ03, HZ_SATZ04,
HZ_SATZ05, HZ_SATZ06, HZ_SATZ07, HZ_SATZ08, HZ_SATZ09,
HZ_SATZ10, HZ_VERZLIM01, HZ_VERZLIM02, HZ_VERZLIM03,
HZ_VERZLIM04, HZ_VERZLIM05, HZ_VERZLIM06, HZ_VERZLIM07,
HZ_VERZLIM08, HZ_VERZLIM09, HZ_VERZLIM10, HZ_LIM_ART,
HZ_VERZ_ART, SZ_SATZ_PERIOD, SZ_SATZ01, SZ_SATZ02, SZ_SATZ03,
SZ_SATZ04, SZ_SATZ05, SZ_SATZ06, SZ_SATZ07, SZ_SATZ08,
SZ_SATZ09, SZ_SATZ10, SZ_VERZLIM01, SZ_VERZLIM02, SZ_VERZLIM03,
SZ_VERZLIM04, SZ_VERZLIM05, SZ_VERZLIM06, SZ_VERZLIM07,
SZ_VERZLIM08, SZ_VERZLIM09, SZ_VERZLIM10, SZ_MIN, SZ_LIM_ART,
SZ_VERZ_ART, RSS_SATZ_H, RSS_SATZ_S, KKRE_SATZ_PERIOD,
KKRE_MINKOM_PERIOD, KKRE_BER_VERF, KKRE_SATZ01, KKRE_SATZ02,
KKRE_SATZ03, KKRE_SATZ04, KKRE_OBERGR, KKRE_ABGRLIM01,
KKRE_ABGRLIM02, KKRE_ABGRLIM03, KKRE_MINKOM, KTRE_SATZ_PERIOD,
KTRE_BER_VERF, KTRE_SATZ, KBER_SATZ_PERIOD, KBER_BER_VERF,
KBER_SATZ, KBER_ABGRLIM, KUEB_SATZ_PERIOD, KUEB_BER_VERF,
KUEB_SATZ, KUEB_ABGRLIM, KMET_SATZ_PERIOD, KMET_MINKOM_PERIOD,
KMET_BER_VERF, KMET_SATZ, KMET_MIN_KOM, VST_FREIBETR, VST_SATZ,
MUT_PID, MUT_TMSTP) AS
SELECT WK951001, WK951002, WK951003, WK951004, WK951005, WK951095,
WK951006, WK951007, WK951008, WK951009, WK951010, WK951011,
WK951012, WK951013, WK951014, WK951015, WK951016, WK951017,
WK951018, WK951019, WK951020, WK951021, WK951022, WK951023,
WK951024, WK951025, WK951026, WK951027, WK951028, WK951029,
WK951030, WK951031, WK951032, WK951033, WK951034, WK951035,
WK951036, WK951037, WK951038, WK951039, WK951040, WK951041,
WK951042, WK951043, WK951044, WK951045, WK951046, WK951047,
WK951048, WK951049, WK951050, WK951051, WK951052, WK951053,
WK951054, WK951055, WK951056, WK951057, WK951058, WK951059,
WK951060, WK951061, WK951062, WK951063, WK951064, WK951065,
WK951066, WK951067, WK951068, WK951069, WK951070, WK951071,
WK951072, WK951073, WK951074, WK951075, WK951076, WK951077,
WK951078, WK951079, WK951080, WK951081, WK951082, WK951083,
WK951084, WK951085, WK951086, WK951087, WK951088, WK951089,
WK951090, WK951091, WK951092, WK951093, WK951094
FROM $creator.TWK951B1 ;
--
LABEL ON TABLE $creator.VWK951B1 IS 'VIEW KOS';
--
COMMENT ON TABLE $creator.VWK951B1 IS 'VIEW KOS';
--
LABEL ON $creator.VWK951B1
(MUT_TMSTP IS 'Mutations Timestamp',
MUT_PID IS 'Mutations PID',
VST_SATZ IS 'Verrechnungssteuersatz',
VST_FREIBETR IS 'Verrechnungssteuer freier Betr',
KMET_MIN_KOM IS 'Mind.Metallkontokom',
KMET_SATZ IS 'Metallkontokom.Satz',
KMET_BER_VERF IS 'Ber.verfahren Metallkontokom',
KMET_MINKOM_PERIOD IS 'Periodiz. Mind.Metallkontokom',
KMET_SATZ_PERIOD IS 'Periodiz. Metallkontokom',
KUEB_ABGRLIM IS 'Abgrenz.limite Über.Komm',
KUEB_SATZ IS 'Überschreit.kom.Satz',
KUEB_BER_VERF IS 'Ber.verfahren Überschreit.kom',
KUEB_SATZ_PERIOD IS 'Periodiz.Überschreit.kom',
KBER_ABGRLIM IS 'Abgrenz.limite Bereitst.kom',
KBER_SATZ IS 'Bereitstellungskom.Satz',
KBER_BER_VERF IS 'Ber.verfahren Bereitst.kom.',
KBER_SATZ_PERIOD IS 'Periodiz.Bereitst.kom.',
KTRE_SATZ IS 'Treuhandkom.Satz',
KTRE_BER_VERF IS 'Ber.verfahren Treuhandkom.',
KTRE_SATZ_PERIOD IS 'Periodiz.Treuhandkomm.Satz',
KKRE_MINKOM IS 'Mind.Kreditkom.',
KKRE_ABGRLIM03 IS 'Abgrenzungslimite 3',
KKRE_ABGRLIM02 IS 'Abgrenzungslimite 2',
KKRE_ABGRLIM01 IS 'Abgrenzungslimite 1',
KKRE_OBERGR IS 'Obere Grenze Kreditkom.',
KKRE_SATZ04 IS 'Kreditkom.Satz 4',
KKRE_SATZ03 IS 'Kreditkom.Satz 3',
KKRE_SATZ02 IS 'Kreditkom.Satz 2',
KKRE_SATZ01 IS 'Kreditkom.Satz 1',
KKRE_BER_VERF IS 'Ber.verfahren Kreditkom',
KKRE_MINKOM_PERIOD IS 'Periodiz.mind.Kreditkom',
KKRE_SATZ_PERIOD IS 'Periodiz.Kreditkomm.satz',
RSS_SATZ_S IS 'Referenzzinssatz Soll',
RSS_SATZ_H IS 'Referenzzinssatz Haben',
SZ_VERZ_ART IS 'SZ-Verzinsungsart',
SZ_LIM_ART IS 'SZ-Limitenart',
SZ_MIN IS 'Sollzinsminimum',
SZ_VERZLIM10 IS 'Verz.limite 10 SZ',
SZ_VERZLIM09 IS 'Verz.limite 9 SZ',
SZ_VERZLIM08 IS 'Verz.limite 8 SZ',
SZ_VERZLIM07 IS 'Verz.limite 7 SZ',
SZ_VERZLIM06 IS 'Verz.limite 6 SZ',
SZ_VERZLIM05 IS 'Verz.limite 5 SZ',
SZ_VERZLIM04 IS 'Verz.limite 4 SZ',
SZ_VERZLIM03 IS 'Verz.limite 3 SZ',
SZ_VERZLIM02 IS 'Verz.limite 2 SZ',
SZ_VERZLIM01 IS 'Verz.limite 1 SZ',
SZ_SATZ10 IS 'Sollzinsatz 10',
SZ_SATZ09 IS 'Sollzinsatz 9',
SZ_SATZ08 IS 'Sollzinsatz 8',
SZ_SATZ07 IS 'Sollzinsatz 7',
SZ_SATZ06 IS 'Sollzinsatz 6',
SZ_SATZ05 IS 'Sollzinsatz 5',
SZ_SATZ04 IS 'Sollzinsatz 4',
SZ_SATZ03 IS 'Sollzinsatz 3',
SZ_SATZ02 IS 'Sollzinsatz 2',
SZ_SATZ01 IS 'Sollzinsatz 1',
SZ_SATZ_PERIOD IS 'Periodiz. SZ-Satz',
HZ_VERZ_ART IS 'HZ-Verzinsungsart',
HZ_LIM_ART IS 'HZ-Limitenart',
HZ_VERZLIM10 IS 'Verz.limite 10 HZ',
HZ_VERZLIM09 IS 'Verz.limite 9 HZ',
HZ_VERZLIM08 IS 'Verz.limite 8 HZ',
HZ_VERZLIM07 IS 'Verz.limite 7 HZ',
HZ_VERZLIM06 IS 'Verz.limite 6 HZ',
HZ_VERZLIM05 IS 'Verz.limite 5 HZ',
HZ_VERZLIM04 IS 'Verz.limite 4 HZ',
HZ_VERZLIM03 IS 'Verz.limite 3 HZ',
HZ_VERZLIM02 IS 'Verz.limite 2 HZ',
HZ_VERZLIM01 IS 'Verz.limite 1 HZ',
HZ_SATZ10 IS 'Habenzinsatz 10',
HZ_SATZ09 IS 'Habenzinsatz 9',
HZ_SATZ08 IS 'Habenzinsatz 8',
HZ_SATZ07 IS 'Habenzinsatz 7',
HZ_SATZ06 IS 'Habenzinsatz 6',
HZ_SATZ05 IS 'Habenzinsatz 5',
HZ_SATZ04 IS 'Habenzinsatz 4',
HZ_SATZ03 IS 'Habenzinsatz 3',
HZ_SATZ02 IS 'Habenzinsatz 2',
HZ_SATZ01 IS 'Habenzinsatz 1',
HZ_SATZ_PERIOD IS 'Periodiz. HZ Satz',
KOS_IND IS 'KOS Ind.',
KOS_WHRG IS 'KOS WHRG',
ZSKAKT IS 'Akt.ZSK Stuffe',
KAL_USANZ IS 'Kalenderusanz',
KOS_DAT_VON IS 'Datum von KOS',
DEFAULT_NR IS 'DefaultNr',
REL_NR IS 'Release',
AS_STATUS IS 'AS Status',
AS_BDAT_BIS IS 'Buchungsdatum bis',
KOS_DAT_BIS IS 'Datum bis KOS',
AS_LFNR IS 'AS Laufnr',
AS_VDAT_BIS IS 'AS valutadatum bis',
TECHBEZ IS 'Techbez',
PROCBASE IS 'ProcBase');
COMMIT;
$*)
$]
$]