| 1 |
ID |
INTEGER |
4 |
| 2 |
VERSIONNAME |
CHARACTER VARYING(100) |
100 |
| 3 |
VERSIONNUMBER |
INTEGER |
4 |
| 4 |
VERSIONFLAG |
CHARACTER VARYING(100) |
100 |
| 5 |
NAME |
CHARACTER VARYING(500) |
500 |
| 6 |
CODE |
CHARACTER VARYING(500) |
500 |
| 7 |
CHANGETRACKINGMASK |
INTEGER |
4 |
| 8 |
TRANSACTION_ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 9 |
TRANSACTION_WEEK_ENDING |
CHARACTER VARYING(13) |
13 |
| 10 |
SCHEME_LICENCE_STATE |
CHARACTER VARYING(30) |
30 |
| 11 |
PRODUCT_STRUCT6 |
CHARACTER VARYING(50) |
50 |
| 12 |
BRAND_NAME |
CHARACTER VARYING(60) |
60 |
| 13 |
DISTRIBUTION_CHANNEL_NAME |
CHARACTER VARYING(100) |
100 |
| 14 |
AGENT_NAME_BDM |
CHARACTER VARYING(100) |
100 |
| 15 |
AGENT_NAME |
CHARACTER VARYING(100) |
100 |
| 16 |
POLICY_STAGE_LEVEL2 |
CHARACTER VARYING(30) |
30 |
| 17 |
BUDGET_TOTAL_PAID_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 18 |
BUDGET_TOTAL_PAID_POLICY_COUNT |
INTEGER |
4 |
| 19 |
BUDGET_ISSUED_QUOTE_COUNT |
INTEGER |
4 |
| 20 |
ENTERDATETIME |
TIMESTAMP |
8 |
| 21 |
ENTERUSERNAME |
CHARACTER VARYING(200) |
200 |
| 22 |
ENTERVERSIONNUMBER |
INTEGER |
4 |
| 23 |
LASTCHGDATETIME |
TIMESTAMP |
8 |
| 24 |
LASTCHGUSERNAME |
CHARACTER VARYING(200) |
200 |
| 25 |
LASTCHGVERSIONNUMBER |
INTEGER |
4 |
| 26 |
VALIDATIONSTATUS |
CHARACTER VARYING(500) |
500 |