Table Name:cycle_count
Table Number:5301
Group:Logistics
Description:Groups specific ABC Code classifications for a cycle count inventory rollup object
Flags: 
Baseline/Custom:Baseline
select * from table_cycle_count
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
ct_daysLONGsmallint   DIRECT Number of days in a cycle count for a location Search (2)
ct_end_dateCLK_TIMEdatetime    Cycle count end date Search (1)
ct_nameCHARvarchar 80  Unique name of the cycle count Search (4)
ct_start_dateCLK_TIMEdatetime1   Cycle count start date Search (1)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
dflt_abc_indLONGtinyint  0 DIRECT Indicates whether mod_level ABC code default will be used when determining stratification value parameters; i.e., 0=no, 1=yes, default=0 Search (2)
dflt_pct_indLONGtinyint  0 DIRECT Indicates whether system-wide ABC code default will be used when determining stratification value parameters; i.e., 0=no, 1=yes, default=0 Search (2)
dflt_turn_indLONGtinyint  0 DIRECT Indicates whether mod_level turn_ratio default will be used when determining stratification value parameters; i.e., 0=no, 1=yes, default=0 Search (2)
objidLONGint3  DIRECT Internal record number Search (4)
statusCHARvarchar 30  Cyle count status; i.e., Open, Calculated, Scheduled, Complete Search (1)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
ccount2biz_cal_hdrMTObiz_cal_hdrcal_hdr2cycle_countRelated business calendar header   Search (1)
ccount2count_setupOTMcount_setupsetup2cycle_countRelated counting days    
ccount2cycle_setupOTMcycle_setupcsetup2cycle_countRelated cycle count setups    
ccount2part_authOTMpart_authpart_auth2cycle_countRelated part authorizations    
ccount2rollupMTOrolluprollup2cycle_countRelated rollup (inventory locations) using cycle count parameters   Search (2)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
cycle_count_indct_nameUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
cycle_count_indct_namenonclustered, unique located on PRIMARY
ed5301ct_end_date, ccount2rollupnonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
sd5301ct_start_date, ct_end_date, ccount2rollupnonclustered located on PRIMARY
My Recent Objects
cycle_count      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user