About This Guide > csld_det
  
csld_det
Controlled Substance Individual License Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
csld__qadc01
 
 
x(8)
 
 
csld_auth
Authority
Auth
x(8)
 
 
csld_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csld_ctry_code
Country
Ctry
x(3)
 
 
csld_curr
Currency
Cur
x(3)
 
 
csld_domain
Domain
 
x(8)
 
 
csld_licen
License Number
 
x(30)
 
 
csld_max_amt
Max Amount
 
>>>,>>>,>>9.99<<<
10
 
csld_max_qty
Max Quantity
 
>>>,>>>,>>9
 
 
csld_part
Item Number
 
x(18)
 
 
csld_tot_amt
Total Amount
 
>>>>,>>>,>>9.99<<<
10
 
csld_tot_qty
Total Quantity
 
>>>,>>>,>>9
 
 
csld_user1
Ufld1
 
x(8)
 
 
csld_user2
Ufld2
 
x(8)
 
 
oid_csld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
csld_ctry_auth
yes
csld_domain
yes
no
 
 
 
csld_ctry_code
yes
no
 
 
 
csld_auth
yes
no
 
 
 
csld_licen
yes
no
 
 
 
csld_part
yes
no
 
csld_licen_part
no
csld_domain
yes
no
 
 
 
csld_licen
yes
no
 
 
 
csld_part
yes
no
 
csld_part_licen
no
csld_domain
yes
no
 
 
 
csld_part
yes
no
 
 
 
csld_licen
yes
no
 
oid_csld_det
yes
oid_csld_det
yes
no