HISTORY
Groups
HISTORY
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Â | Primary key |
2 | ACCOUNT_ID | NUMBER | 22 | Y | Â | Reference to ACCOUNT |
3 | TYPE | VARCHAR2 | 35 | Y | Â | Â |
4 | OBJECT_ID | NUMBER | 22 | Y | Â | Â |
5 | SOURCE_ID | VARCHAR2 | 100 | Y | Â | Â |
6 | CREATE_DATE | DATE | 7 | Y | Â | Â |
7 | COMMENTS | VARCHAR2 | 4000 | Y | Â | Â |
8 | CREATED_BY | VARCHAR2 | 50 | Y | Â | Â |
9 | TAG | VARCHAR2 | 512 | Y | Â | Â |
10 | TAG_PARAMETERS | VARCHAR2 | 4000 | Â | Â | Field added to enable localization of dynamic parameters such as Date, Amount etc. |
Log information about customer account changes
Â
Â