📄 create table script.sql
字号:
-- Create table
create table SRC_DISCOUNT_KENAN_UPLOAD
(
CUST_ID VARCHAR2(360),
ACCT_NBR_97 VARCHAR2(360),
ACCT_NBR_BILL VARCHAR2(360),
SERV_ID VARCHAR2(420),
SERV_NUM VARCHAR2(420),
GROUP_NO VARCHAR2(360),
PROD_REF_NO NUMBER(10),
PROD_NAME VARCHAR2(360),
BILLING_TYPE_ID NUMBER(10),
BILLING_TYPE_NAME VARCHAR2(360),
DISCOUNT_ID NUMBER(10),
DISCOUNT_TYPE NUMBER(2),
DISCOUNT_NAME VARCHAR2(420),
DISCT_METHOD VARCHAR2(360),
X VARCHAR2(360),
Y VARCHAR2(360),
W VARCHAR2(360),
Z VARCHAR2(360),
V VARCHAR2(360),
START_DT DATE,
END_DT DATE,
SRC_ID VARCHAR2(390),
SRC_TAB VARCHAR2(360),
SRC_KEY1 VARCHAR2(420),
SRC_KEY2 VARCHAR2(420),
SRC_LAST_UPDATED DATE,
SRC_FILESET VARCHAR2(390),
SRC_UPDATE_COUNT NUMBER(6),
SERVER_ID NUMBER(10),
SERVER_SID VARCHAR2(390),
SERVER_USER VARCHAR2(360),
IS_PROCESSED VARCHAR2(33),
SIB_PROCESS_STATUS VARCHAR2(33),
KENAN_DISCOUNT_NAME VARCHAR2(420),
KENAN_DISCOUNT_ID VARCHAR2(390),
SIEBEL_PRODUCT_NAME VARCHAR2(4000),
SIEBEL_PRODUCT_ID VARCHAR2(390),
ROW_ID NUMBER(22),
KENAN_CPT_INST_ID NUMBER(20),
DISCOUNT_REF_NUM NUMBER(3),
DISCT_TRACKING_ID NUMBER(3),
ROW_ID_2 NUMBER(22),
KENAN_PKG_INST_ID NUMBER(38),
X6 VARCHAR2(360),
X7 VARCHAR2(360),
SRC_KEY3 VARCHAR2(420),
SIEBEL_PRODUCT_ID_2 VARCHAR2(390),
SEQUENCE_ID NUMBER(10),
SERV_PRODUCT_ID VARCHAR2(390),
PAR_SEQUENCE_ID NUMBER(10),
PROD_SERV_ID VARCHAR2(450),
IS_SBU NUMBER(1),
SBU_ACCT_NBR_97 VARCHAR2(360),
BILL_FLAG VARCHAR2(33),
X8 VARCHAR2(20 CHAR),
X9 VARCHAR2(20 CHAR)
)
-----src_discount_kenan
create table SRC_DISCOUNT_KENAN
(
CUST_ID VARCHAR2(20 CHAR),
ACCT_NBR_97 VARCHAR2(20 CHAR),
ACCT_NBR_BILL VARCHAR2(20 CHAR),
SERV_ID VARCHAR2(40 CHAR),
SERV_NUM VARCHAR2(40 CHAR),
GROUP_NO VARCHAR2(20 CHAR),
PROD_REF_NO NUMBER(10),
PROD_NAME VARCHAR2(20 CHAR),
BILLING_TYPE_ID NUMBER(10),
BILLING_TYPE_NAME VARCHAR2(20 CHAR),
DISCOUNT_ID NUMBER(10),
DISCOUNT_TYPE NUMBER(2),
DISCOUNT_NAME VARCHAR2(40 CHAR),
DISCT_METHOD VARCHAR2(20 CHAR),
X VARCHAR2(20 CHAR),
Y VARCHAR2(20 CHAR),
W VARCHAR2(20 CHAR),
Z VARCHAR2(20 CHAR),
V VARCHAR2(20 CHAR),
START_DT DATE,
END_DT DATE,
SRC_ID VARCHAR2(30 CHAR) not null,
SRC_TAB VARCHAR2(20 CHAR),
SRC_KEY1 VARCHAR2(40 CHAR),
SRC_KEY2 VARCHAR2(40 CHAR),
SRC_LAST_UPDATED DATE,
SRC_FILESET VARCHAR2(30 CHAR) not null,
SRC_UPDATE_COUNT NUMBER(6),
SERVER_ID NUMBER(10),
SERVER_SID VARCHAR2(30 CHAR),
SERVER_USER VARCHAR2(20 CHAR),
IS_PROCESSED VARCHAR2(1 CHAR),
SIB_PROCESS_STATUS VARCHAR2(1 CHAR),
KENAN_DISCOUNT_NAME VARCHAR2(40 CHAR),
KENAN_DISCOUNT_ID VARCHAR2(30 CHAR),
SIEBEL_PRODUCT_NAME VARCHAR2(500 CHAR),
SIEBEL_PRODUCT_ID VARCHAR2(30 CHAR),
ROW_ID NUMBER(22),
KENAN_CPT_INST_ID NUMBER(20),
DISCOUNT_REF_NUM NUMBER(3),
DISCT_TRACKING_ID NUMBER(3),
ROW_ID_2 NUMBER(22),
KENAN_PKG_INST_ID NUMBER(38),
X6 VARCHAR2(20 CHAR),
X7 VARCHAR2(20 CHAR),
SRC_KEY3 VARCHAR2(40 CHAR),
SIEBEL_PRODUCT_ID_2 VARCHAR2(30 CHAR),
SEQUENCE_ID NUMBER(10),
SERV_PRODUCT_ID VARCHAR2(30 CHAR),
PAR_SEQUENCE_ID NUMBER(10),
PROD_SERV_ID VARCHAR2(50 CHAR),
IS_SBU NUMBER(1),
SBU_ACCT_NBR_97 VARCHAR2(20 CHAR),
BILL_FLAG VARCHAR2(1 CHAR),
X8 VARCHAR2(20 CHAR),
X9 VARCHAR2(20 CHAR)
);
-----SRC_DISCOUNT_KENAN_ERR
create table SRC_DISCOUNT_KENAN_ERR
( ACCT_NBR_97 VARCHAR2(360),
ACCT_NBR_BILL VARCHAR2(360),
SERV_ID VARCHAR2(420),
GROUP_NO VARCHAR2(360),
PROD_REF_NO NUMBER(10),
PROD_NAME VARCHAR2(360),
BILLING_TYPE_NAME VARCHAR2(360),
DISCOUNT_NAME VARCHAR2(420),
IS_PROCESSED VARCHAR2(33),
KENAN_DISCOUNT_NAME VARCHAR2(420),
KENAN_DISCOUNT_ID VARCHAR2(390),
SIEBEL_PRODUCT_NAME VARCHAR2(4000),
SIEBEL_PRODUCT_ID VARCHAR2(390),
ROW_ID NUMBER(22)
)
========================
create table SRC_PROD_KENAN
(
ACCT_NBR_97 VARCHAR2(20 CHAR),
ACCT_NBR_BILL VARCHAR2(20 CHAR),
SERV_ID VARCHAR2(40 CHAR),
SERV_NUM VARCHAR2(100 CHAR),
PROD_REF_NO_BILL VARCHAR2(50 CHAR),
PROD_NAME_BILL VARCHAR2(40 CHAR),
RC_RATE VARCHAR2(10 CHAR),
UNITS NUMBER(10),
UNITS_TYPE NUMBER(6),
OPEN_ITEM_ID NUMBER(6),
START_DT DATE,
END_DT DATE,
SRC_ID VARCHAR2(30 CHAR) not null,
SRC_TAB VARCHAR2(20 CHAR),
SRC_KEY1 VARCHAR2(40 CHAR),
SRC_KEY2 VARCHAR2(40 CHAR),
SRC_LAST_UPDATED DATE,
SRC_FILESET VARCHAR2(30 CHAR) not null,
SRC_UPDATE_COUNT NUMBER(6),
SERVER_ID NUMBER(10),
SERVER_SID VARCHAR2(30 CHAR),
SERVER_USER VARCHAR2(20 CHAR),
IS_PROCESSED VARCHAR2(1 CHAR),
SIB_PROCESS_STATUS VARCHAR2(1 CHAR),
KENAN_PRODUCT_ID VARCHAR2(30 CHAR),
KENAN_PRODUCT_NAME VARCHAR2(40 CHAR),
SIEBEL_PRODUCT_ID VARCHAR2(30 CHAR),
SIEBEL_PRODUCT_NAME VARCHAR2(30 CHAR),
BILLED_THRU_DATE DATE,
NO_BILL NUMBER(1),
ROW_ID NUMBER(22),
IS_OVERRIDEN NUMBER(6),
ORDER_ITEM_CODE VARCHAR2(30 CHAR),
SEQUENCE_ID NUMBER(22),
PROD_TRACKING_ID NUMBER(6),
ROW_ID_2 NUMBER(22),
SRC_KEY3 VARCHAR2(40 CHAR),
IS_MAIN_ACCT NUMBER(1),
PROD_SERV_ID VARCHAR2(50 CHAR),
SERV_PRODUCT_ID VARCHAR2(30 CHAR),
PAR_SEQUENCE_ID NUMBER(10),
LAYER_ID NUMBER(10)
)
------
create table SRC_PROD_KENAN_ERR
(
ACCT_NBR_97 VARCHAR2(360),
SERV_ID VARCHAR2(420),
IS_PROCESSED VARCHAR2(33),
KENAN_PRODUCT_ID VARCHAR2(390),
SIEBEL_PRODUCT_ID VARCHAR2(390),
SRC_ID VARCHAR2(40 CHAR)
)
--
create table SRC_CONTRACT_ASSIGNMENT_HQ_UP
(
GROUP_ID VARCHAR2(360),
ACCT_NBR_97 VARCHAR2(390),
KENAN_DISCOUNT_ID VARCHAR2(390),
START_DT DATE,
END_DT DATE,
EXCLUDE NUMBER(1),
SRC_ID VARCHAR2(30 CHAR)
);
----create table SRC_CONTRACT_ASSIGNMENT_HQ
(
GROUP_ID VARCHAR2(20 CHAR) not null,
ACCT_NBR_97 VARCHAR2(30 CHAR) not null,
KENAN_DISCOUNT_ID VARCHAR2(30 CHAR) not null,
START_DT DATE not null,
END_DT DATE,
EXCLUDE NUMBER(1) not null,
SRC_ID VARCHAR2(30 CHAR)
);
---
create table SRC_CONTRACT_ASSIGNMENT_HQ_ERR
(
GROUP_ID VARCHAR2(360),
ACCT_NBR_97 VARCHAR2(390),
KENAN_DISCOUNT_ID VARCHAR2(390),
START_DT DATE,
END_DT DATE,
EXCLUDE NUMBER(1),
src_id varchar(30 char)
)
--
create table SRC_CAH_EXT_DATA_UPLOAD
(
GROUP_ID VARCHAR2(360),
ACCT_NBR_97 VARCHAR2(390),
SERV_ID VARCHAR2(360),
IS_SERVICE_EXCLUDE NUMBER(1),
SERVICE_START_DT DATE,
SERVICE_END_DT DATE,
KENAN_DISCOUNT_ID VARCHAR2(390),
src_id varchar(30 char)
);
-----
create table SRC_CAH_EXT_DATA
(
GROUP_ID VARCHAR2(20 CHAR) not null,
ACCT_NBR_97 VARCHAR2(30 CHAR) not null,
SERV_ID VARCHAR2(20 CHAR) not null,
IS_SERVICE_EXCLUDE NUMBER(1) not null,
SERVICE_START_DT DATE,
SERVICE_END_DT DATE,
KENAN_DISCOUNT_ID VARCHAR2(30 CHAR),
SRC_ID VARCHAR2(30 CHAR)
);
-----
create table SRC_CAH_EXT_DATA_PATCH_UPLOAD
(
GROUP_ID VARCHAR2(360),
ACCT_NBR_97 VARCHAR2(390),
SERV_ID VARCHAR2(360),
IS_SERVICE_EXCLUDE NUMBER(1),
SERVICE_START_DT DATE,
SERVICE_END_DT DATE,
KENAN_DISCOUNT_ID VARCHAR2(390),
src_id varchar(30 char)
);
----
create table SRC_CAH_EXT_DATA_PATCH
(
GROUP_ID VARCHAR2(60) not null,
ACCT_NBR_97 VARCHAR2(90) not null,
SERV_ID VARCHAR2(60) not null,
IS_SERVICE_EXCLUDE NUMBER(1) not null,
SERVICE_START_DT DATE,
SERVICE_END_DT DATE,
KENAN_DISCOUNT_ID VARCHAR2(90),
src_id varchar(30 char)
);
----
create table SRC_CAH_EXT_DATA_PATCH_ERR
(
GROUP_ID VARCHAR2(360),
ACCT_NBR_97 VARCHAR2(390),
SERV_ID VARCHAR2(360),
IS_SERVICE_EXCLUDE NUMBER(1),
SERVICE_START_DT DATE,
SERVICE_END_DT DATE,
KENAN_DISCOUNT_ID VARCHAR2(390),
src_id varchar(30 char)
);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -