You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
350 B
Plaintext
15 lines
350 B
Plaintext
create table epay_hj_table
|
|
(
|
|
BILLDATE date,
|
|
AREANO NUMBER(8),
|
|
ROADNO number(8),
|
|
STANO number(8),
|
|
HJ_INCASH number(8),
|
|
HJ_REFUNFCASH number(8),
|
|
EP_INCASH number(8),
|
|
EP_CASH number(8),
|
|
EP_REFUNFCASH number(8),
|
|
primary key(BILLDATE,ROADNO,STANO)
|
|
)
|
|
|
|
alter table EPAY_HJ_TABLE add (TRANDATE date,TRANNO number(10),DATEMARK date) |