PAYMENT_LOG
Groups
PAYMENT_LOG
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Â | Primary key |
2 | REFERENCE | VARCHAR2 | 100 | Y | Â | Â |
3 | SENT_DATE | DATE | 7 | Y | Â | Â |
4 | RECEIVE_DATE | DATE | 7 | Y | Â | Â |
5 | STATUS_ID | NUMBER | 22 | Y | Â | Â |
6 | MESSAGE | VARCHAR2 | 4000 | Y | Â | Â |
7 | AMOUNT | NUMBER | 22 | Y | Â | Â |
8 | TRANSACTION_NUMBER | VARCHAR2 | 20 | Y | Â | Â |
9 | ACCOUNT_ID | NUMBER | 22 | Y | Â | Â |
10 | BILLING_GROUP_ID | NUMBER | 22 | Y | Â | Â |
11 | CARD_TYPE | VARCHAR2 | 20 | Y | Â | Â |
12 | IP_ADDRESS | VARCHAR2 | 20 | Y | Â | Â |
13 | APPROVAL_CODE | VARCHAR2 | 80 | Y | Â | Â |
14 | RESPONSE_CODE | VARCHAR2 | 200 | Y | Â | Â |
15 | REQUEST | CLOB | 4000 | Y | Â | Â |
16 | RESPONSE | CLOB | 4000 | Y | Â | Â |
Â
Â