About This Guide > cslm_mstr
  
cslm_mstr
Controlled Substance General License Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cslm__qadc01
 
 
x(8)
 
 
cslm_auth
Authority
Auth
x(8)
 
 
cslm_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
cslm_ctrl
Control Num / ECCN
 
x(20)
 
 
cslm_ctry_code
Country
Ctry
x(3)
 
 
cslm_curr
Currency
Cur
x(3)
 
 
cslm_domain
Domain
 
x(8)
 
 
cslm_end
End Date
End
99/99/99
 
 
cslm_group
Country Groups
 
x(60)
 
 
cslm_licen
License Number
 
x(30)
 
 
cslm_max_amt
Max Amount
 
>>>>,>>>,>>9.99<<<
10
 
cslm_max_qty
Max Quantity
 
>>>,>>>,>>9
 
 
cslm_start
Start Date
Start
99/99/99
 
 
cslm_tot_amt
Total Amount
 
>>>>,>>>,>>9.99<<<
10
 
cslm_tot_qty
Total Quantity
 
>>>,>>>,>>9
 
 
cslm_user1
Ufld1
 
x(8)
 
 
cslm_user2
Ufld2
 
x(8)
 
 
oid_cslm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cslm_ctrl_licen
no
cslm_domain
yes
no
 
 
 
cslm_ctrl
yes
no
 
 
 
cslm_licen
yes
no
cslm_ctry_auth
yes
cslm_domain
yes
no
 
 
 
cslm_ctry_code
yes
no
 
 
 
cslm_auth
yes
no
 
 
 
cslm_licen
yes
no
 
 
 
cslm_ctrl
yes
no
 
cslm_grp
no
cslm_domain
yes
no
 
 
 
cslm_group
yes
no
 
oid_cslm_mstr
yes
oid_cslm_mstr
yes
no