CREATE TABLE DocumentNumber
(
DocumentNumber varchar2(20) NOT NULL
);

CREATE TABLE BCILookupTable
(
Request_Id varchar(30),
DataSourceName varchar(30)
);

CREATE TABLE ControlRecord
(
TABNAM  varchar2(10),
MANDT   varchar2(3),
DOCNUM  varchar2(16),
DOCREL  varchar2(4),
STATUS  varchar2(2),
DIRECT  varchar2(1),
OUTMOD  varchar2(1),
EXPRSS  varchar2(1),
TEST    varchar2(1),
IDOCTYP varchar2(30),
CIMTYP  varchar2(30),
MESTYP  varchar2(30),
MESCOD  varchar2(3),
MESFCT  varchar2(3),
STD     varchar2(1),
STDVRS  varchar2(6),
STDMES  varchar2(6),
SNDPOR  varchar2(10),
SNDPRT  varchar2(2),
SNDPFC  varchar2(2),
SNDPRN  varchar2(10),
SNDSAD  varchar2(21),
SNDLAD  varchar2(70),
RCVPOR  varchar2(10),
RCVPRT  varchar2(2),
RCVPFC  varchar2(2),
RCVPRN  varchar2(10),
RCVSAD  varchar2(21),
RCVLAD  varchar2(70),
CREDAT  date,
CRETIM  date,
REFINT  varchar2(14),
REFGRP  varchar2(14),
REFMES  varchar2(14),
ARCKEY  varchar2(70),
SERIAL  varchar2(20)
);

CREATE TABLE Indicator
(
UKey       varchar2(30),
Identifier varchar2(30),
Status     char(30)
);

CREATE TABLE RSINFOStaging
(
BasicIDocType    varchar2(30),
ExtendedIDocType varchar2(30),
IDocRecord       varchar2(1100),
DocumentNumber   varchar2(16),
DataSourceType   varchar2(4),
RequestID        varchar2(30)
);

CREATE TABLE Source_For_BCI
(
BasicIDocType    varchar2(30),
ExtendedIDocType varchar2(30),
IDocRecord       varchar2(1100) NOT NULL,
DocumentNumber   varchar2(16),
DataSourceType   varchar2(4),
RequestID        varchar2(30)
);