RDM_CTP_NAT_PROTECT_AGENTS

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AGENT_GROUP_NAME CHARACTER VARYING(100) 100
2 AGENT_GROUP_NUMBER CHARACTER VARYING(100) 100
3 AGENT_NUMBER CHARACTER VARYING(100) 100
4 AGENT_TRADING_NAME CHARACTER VARYING(100) 100
5 BUSINESS_TYPE_CODE CHARACTER VARYING(250) 250
6 BUSINESS_TYPE_ID INTEGER 4
7 BUSINESS_TYPE_NAME CHARACTER VARYING(250) 250
8 CHANGETRACKINGMASK INTEGER 4
9 CODE CHARACTER VARYING(250) 250
10 COMSCALE_CODE CHARACTER VARYING(250) 250
11 COMSCALE_ID INTEGER 4
12 COMSCALE_NAME CHARACTER VARYING(250) 250
13 CREATEDATE CHARACTER VARYING(100) 100
14 DISTRIBUTION_CHANNEL_LEVEL1_ID_CODE CHARACTER VARYING(250) 250
15 DISTRIBUTION_CHANNEL_LEVEL1_ID_ID INTEGER 4
16 DISTRIBUTION_CHANNEL_LEVEL1_ID_NAME CHARACTER VARYING(250) 250
17 EFFECTDTE CHARACTER VARYING(100) 100
18 ENTERDATETIME TIMESTAMP 8
19 ENTERUSERNAME CHARACTER VARYING(100) 100
20 ENTERVERSIONNUMBER INTEGER 4
21 ID INTEGER 4
22 IST_CHANNEL_LVL1_CODE CHARACTER VARYING(250) 250
23 IST_CHANNEL_LVL1_ID INTEGER 4
24 IST_CHANNEL_LVL1_NAME CHARACTER VARYING(250) 250
25 IST_CHANNEL_LVL2_CODE CHARACTER VARYING(250) 250
26 IST_CHANNEL_LVL2_ID INTEGER 4
27 IST_CHANNEL_LVL2_NAME CHARACTER VARYING(250) 250
28 LASTCHGDATETIME TIMESTAMP 8
29 LASTCHGUSERNAME CHARACTER VARYING(100) 100
30 LASTCHGVERSIONNUMBER INTEGER 4
31 MUID CHARACTER VARYING(256) 256
32 NAME CHARACTER VARYING(250) 250
33 PAYMENT_TERMS_CODE CHARACTER VARYING(250) 250
34 PAYMENT_TERMS_ID INTEGER 4
35 PAYMENT_TERMS_NAME CHARACTER VARYING(250) 250
36 PROTECT_COMMISSION_FLAG CHARACTER VARYING(100) 100
37 REP_CODE_BDM CHARACTER VARYING(100) 100
38 SCHEME_BRAND_CODE CHARACTER VARYING(250) 250
39 SCHEME_BRAND_ID INTEGER 4
40 SCHEME_BRAND_NAME CHARACTER VARYING(250) 250
41 SCHEME_STATE_CODE CHARACTER VARYING(250) 250
42 SCHEME_STATE_ID INTEGER 4
43 SCHEME_STATE_NAME CHARACTER VARYING(250) 250
44 SIRA_DISTRIBUTION_CHANNEL_CODE CHARACTER VARYING(250) 250
45 SIRA_DISTRIBUTION_CHANNEL_ID INTEGER 4
46 SIRA_DISTRIBUTION_CHANNEL_NAME CHARACTER VARYING(250) 250
47 TERMDATE CHARACTER VARYING(100) 100
48 VALIDATIONSTATUS CHARACTER VARYING(250) 250
49 VERSIONFLAG CHARACTER VARYING(50) 50
50 VERSIONNAME CHARACTER VARYING(50) 50
51 VERSIONNUMBER INTEGER 4
52 ROW_RANK INTEGER 4