About This Guide > ccb_mstr
  
ccb_mstr
Cycle Count Batch
 
 
Field Name
Label
Col-Label
Format
Dec
 
ccb__qadc01
 
 
x(24)
 
 
ccb__qadc02
 
 
x(24)
 
 
ccb_amt_diff
Difference Amount
 
->>>,>>>,>>>,>>9.99
10
 
ccb_cc_status
State
 
>9
 
 
ccb_domain
Domain
 
x(8)
 
 
ccb_end_timestamp
End Date/Time
 
99/99/99 HH:MM:SS
 
 
ccb_loc
Location
 
x(8)
 
 
ccb_mod_date
Modified Date
Mod Date
99/99/99
 
 
ccb_mod_userid
User ID
 
x(8)
 
 
ccb_part
Item
 
x(18)
 
 
ccb_pct_qty_diff
Qty On Hand Variance
 
->>>,>>9.9<%
10
 
ccb_pct_qty_usage
Annual Usage Variance
 
->>>,>>9.9<%
10
 
ccb_qty_begin
Begin Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
ccb_qty_counted
Count Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
ccb_site
Site
 
x(8)
 
 
ccb_start_timestamp
State Date/Time
 
99/99/99 HH:MM:SS
 
 
ccb_type
Type
 
>9
 
 
ccb_user1
User Field Character 1
 
x(24)
 
 
ccb_user2
User Field Character 2
 
x(24)
 
 
oid_ccb_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ccb_site_loc_pt
yes
ccb_domain
yes
no
 
 
 
ccb_site
yes
no
 
 
 
ccb_loc
yes
no
 
 
 
ccb_part
yes
no
 
 
 
ccb_start_timestamp
yes
no
 
oid_ccb_mstr
yes
oid_ccb_mstr
yes
no