About This Guide > kenb_det
  
kenb_det
Ending Inventory Balance and Cost by Location
 
 
Field Name
Label
Col-Label
Format
Dec
 
kenb__qadc01
QAD Character Field 1
 
x(24)
 
 
kenb__qadc02
QAD Character Field 2
 
x(24)
 
 
kenb__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
kenb__qadt01
QAD Date Field 1
 
99/99/99
 
 
kenb_domain
Domain
 
x(8)
 
 
kenb_end_bal
Ending Inventory Quantity
End Inv Qty
->>,>>>,>>9.9<<<<<<<<<
10
 
kenb_end_cst
Ending Cost
 
>>>>,>>>,>>9.99<<<
10
 
kenb_loc
Location
 
x(8)
 
 
kenb_mod_date
Modified Date
Mod Date
99/99/99
 
 
kenb_mod_userid
User ID
 
x(8)
 
 
kenb_month
Month
 
>9
 
 
kenb_part
Item Number
 
x(18)
 
 
kenb_period
Period
 
99/9999
 
 
kenb_site
Site
 
x(8)
 
 
kenb_user1
User Field Character 1
 
x(24)
 
 
kenb_user2
User Field Character 2
 
x(24)
 
 
kenb_year
Year
 
9999
 
 
oid_kenb_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
kenb_part
no
kenb_domain
yes
no
 
 
 
kenb_part
yes
no
 
 
 
kenb_site
yes
no
 
 
 
kenb_loc
yes
no
kenb_site_loc
yes
kenb_domain
yes
no
 
 
 
kenb_site
yes
no
 
 
 
kenb_loc
yes
no
 
 
 
kenb_part
yes
no
 
 
 
kenb_year
yes
no
 
 
 
kenb_month
yes
no
 
kenb_year_per
no
kenb_domain
yes
no
 
 
 
kenb_year
yes
no
 
 
 
kenb_month
yes
no
 
 
 
kenb_part
yes
no
 
 
 
kenb_site
yes
no
 
 
 
kenb_loc
yes
no
 
oid_kenb_det
yes
oid_kenb_det
yes
no