| 1 | CREATE TABLE CARDDEMO.AUTHFRDS |
| 2 | (CARD_NUM CHAR(16) NOT NULL, |
| 3 | AUTH_TS TIMESTAMP NOT NULL, |
| 4 | AUTH_TYPE CHAR(4) , |
| 5 | CARD_EXPIRY_DATE CHAR(4) , |
| 6 | MESSAGE_TYPE CHAR(6) , |
| 7 | MESSAGE_SOURCE CHAR(6) , |
| 8 | AUTH_ID_CODE CHAR(6) , |
| 9 | AUTH_RESP_CODE CHAR(2) , |
| 10 | AUTH_RESP_REASON CHAR(4) , |
| 11 | PROCESSING_CODE CHAR(6) , |
| 12 | TRANSACTION_AMT DECIMAL(12,2) , |
| 13 | APPROVED_AMT DECIMAL(12,2) , |
| 14 | MERCHANT_CATAGORY_CODE CHAR(4) , |
| 15 | ACQR_COUNTRY_CODE CHAR(3) , |
| 16 | POS_ENTRY_MODE SMALLINT , |
| 17 | MERCHANT_ID CHAR(15) , |
| 18 | MERCHANT_NAME VARCHAR(22) , |
| 19 | MERCHANT_CITY CHAR(13) , |
| 20 | MERCHANT_STATE CHAR(02) , |
| 21 | MERCHANT_ZIP CHAR(09) , |
| 22 | TRANSACTION_ID CHAR(15) , |
| 23 | MATCH_STATUS CHAR(1) , |
| 24 | AUTH_FRAUD CHAR(1) , |
| 25 | FRAUD_RPT_DATE DATE , |
| 26 | ACCT_ID DECIMAL(11) , |
| 27 | CUST_ID DECIMAL(9) , |
| 28 | PRIMARY KEY(CARD_NUM,AUTH_TS ) ); |