14 lines
561 B
SQL
14 lines
561 B
SQL
--中信批量结果反馈文件
|
|
create GLOBAL TEMPORARY table PAYADM.CAPBATCITIC (
|
|
|
|
SEQ_NO VARCHAR2(10) default ' ' not null,
|
|
CRD_NO VARCHAR2(30) default ' ' not null,
|
|
TXN_AMT VARCHAR2(17) default ' ' not null,
|
|
CUS_NAM VARCHAR2(60) default ' ' not null,
|
|
TRSP_CD VARCHAR2(10) default ' ' not null,
|
|
TTXN_ST VARCHAR2(1) default ' ' not null,
|
|
TRSP_MSG VARCHAR2(120) default ' ' not null,
|
|
RMK VARCHAR2(120) default ' ' not null,
|
|
TM_SMP VARCHAR2(120) default ' ' not null
|
|
)
|
|
ON COMMIT PRESERVE ROWS; |