About This Guide > cil_mstr
  
cil_mstr
Correction Invoice Link Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cil__qadc01
 
 
x(24)
 
 
cil__qadc02
 
 
x(24)
 
 
cil_cor_inv
Correction Invoice Number
 
x(22)
 
 
cil_cor_rsn
Reason For Correction
 
x(8)
 
 
cil_cor_so_nbr
Correction Invoice Sales Order
 
x(8)
 
 
cil_domain
Domain
 
x(8)
 
 
cil_mod_date
Modified Date
Mod Date
99/99/99
 
 
cil_mod_userid
User ID
 
x(8)
 
 
cil_mstr_inv
Original Invoice
 
x(8)
 
 
cil_prev_inv
Corrected Invoice
 
x(22)
 
 
cil_prev_so_nbr
Corrected Invoice Sales Order
 
x(8)
 
 
cil_user1
User Field Character 1
 
x(24)
 
 
cil_user2
User Field Character 2
 
x(24)
 
 
oid_cil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cil_cor_inv
yes
cil_domain
yes
no
 
 
 
cil_cor_inv
yes
no
 
 
 
cil_cor_so_nbr
yes
no
 
cil_cor_nbr
no
cil_domain
yes
no
 
 
 
cil_cor_so_nbr
yes
no
 
cil_mstr_inv
no
cil_domain
yes
no
 
 
 
cil_mstr_inv
yes
no
 
cil_prev_inv
no
cil_domain
yes
no
 
 
 
cil_prev_inv
yes
no
 
 
 
cil_prev_so_nbr
yes
no
 
oid_cil_mstr
yes
oid_cil_mstr
yes
no