CSV_BUDGETLOAD_WEEKLY_AGENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_ACCOUNTING_YEAR_LABEL CHARACTER VARYING(13) 13
2 TRANSACTION_WEEK_ENDING CHARACTER VARYING(13) 13
3 SCHEME_LICENCE_STATE CHARACTER VARYING(30) 30
4 PRODUCT_STRUCT6 CHARACTER VARYING(50) 50
5 BRAND_NAME CHARACTER VARYING(60) 60
6 DISTRIBUTION_CHANNEL_NAME CHARACTER VARYING(100) 100
7 AGENT_NAME_BDM CHARACTER VARYING(100) 100
8 AGENT_NAME CHARACTER VARYING(100) 100
9 POLICY_STAGE_LEVEL2 CHARACTER VARYING(30) 30
10 BUDGET_TOTAL_PAID_POLICY_PREMIUM NUMERIC(11,2) 19
11 BUDGET_TOTAL_PAID_POLICY_COUNT INTEGER 4
12 BUDGET_ISSUED_QUOTE_COUNT INTEGER 4