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 |