Table Name:fcs_detail
Table Number:252
Group:obsolete
Description:Reserved; custom
Flags: 
Baseline/Custom:Baseline
select * from table_fcs_detail
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
confirm_dateCLK_TIMEdatetime    Reserved; custom  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
error_messageCHARvarchar 255  Reserved; custom  
exch_done_flagCHARvarchar 2  Reserved; custom  
exchange_codeCHARvarchar 2  Reserved; custom  
fail_codeCHARvarchar 4  Reserved; custom  
install_partCHARvarchar 20  Reserved; custom  
install_serialCHARvarchar 22  Reserved; custom  
inv_locationCHARvarchar 10  Reserved; custom  
line_closedCHARvarchar 2  Reserved; custom  
line_numberLONGint   DIRECT Reserved; custom  
log_dateCLK_TIMEdatetime    Reserved; custom  
objidLONGint3  DIRECT Reserved; custom  
priceCHARvarchar 8  Reserved; custom  
quantityCHARvarchar 2  Reserved; custom  
remove_partCHARvarchar 20  Reserved; custom  
remove_serialCHARvarchar 22  Reserved; custom  
req_originatorCHARvarchar 20  Reserved; custom  
req_statusCHARvarchar 23  Reserved; custom  
request_noteCHARvarchar 255  Reserved; custom  
request_numberCHARvarchar 10  Reserved; custom  
trans_statusLONGint   DIRECT Transaction status; i.e., -1=failed, 0=new, 1=done. Reserved; custom  
trans_typeLONGint   DIRECT Transaction type; i.e., 0=request; 1=consume; 2=exchange; 3=close. Reserved; custom  
use_codeCHARvarchar 2  Reserved; custom  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
used_by2caseMTOcasecase_info2fcs_detailReserved; custom    
fcs_detail2disptchfeOTOFdisptchfedisptchfe2fcs_detailReserved; custom    
fcs_detail2fcs_headerMTOfcs_headerfcs_header2fcs_detailReserved; custom    
install2part_modMTOmod_levelinstall2fcs_detailReserved; custom    
remove2part_modMTOmod_levelremove2fcs_detailReserved; custom    
used_by2subcaseMTOsubcasesubc_info2fcs_detailReserved; custom    
curr_owner2ownerMTOusercurr_owner2fcs_usedReserved; custom    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
fcs_detail      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user