21 lines
591 B
SQL
21 lines
591 B
SQL
DROP TABLE MPSHSTFMT;
|
|
|
|
CREATE TABLE MPSHSTFMT
|
|
(
|
|
SEQ_NO CHAR(08) NOT NULL,
|
|
TXN_TYP CHAR(02),
|
|
AC CHAR(20),
|
|
MEC_ID CHAR(15),
|
|
TRM_ID CHAR(08),
|
|
TRM_SR CHAR(16),
|
|
TXN_DT CHAR(08),
|
|
TXN_TM CHAR(06),
|
|
BAT_NO CHAR(06),
|
|
POS_JRN CHAR(06),
|
|
OL_JRN CHAR(12),
|
|
TXN_AMT CHAR(12),
|
|
FEE CHAR(08),
|
|
AGT CHAR(08),
|
|
PROC_FLAG CHAR(02),
|
|
PRIMARY KEY(SEQ_NO,MEC_ID,TRM_ID,BAT_NO,POS_JRN)
|
|
); |