CSV_BUDGETLOAD_MONTHLY_AGENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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