Table Name:N_JobSummary
Table Number:5413
Group:Configuration
Description:Created when a job is first saved and updated with each additional File-Save operation, this object includes the job filename as well as numerous other job parameters that are used by applications outside ClearConfigurator
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
N_CustomerCompanyNameCHARvarchar 80 ALLOW_NULL The name of the customer's company  
N_CustomerContactFirstNameCHARvarchar 30 ALLOW_NULL The first name of your contact at the company  
N_CustomerContactLastNameCHARvarchar 30 ALLOW_NULL The last name of your contact at the company  
N_CustomerOmsIDCHARvarchar 24 ALLOW_NULL Unique customer ID number  
N_CustomerPOCHARvarchar 24 ALLOW_NULL The customer's zip/postal code  
N_EstimatedMarketValueDECIMALdecimal (19,4)   ALLOW_NULL, CURRENCY The value of the job  
N_FileSavePathCHARvarchar 250 ALLOW_NULL The location in which this file is saved  
N_JobCreationDateCLK_TIMEdatetime   ALLOW_NULL The date on which the job was created  
N_JobDescriptionCHARvarchar 80 ALLOW_NULL A short description of the job  
N_JobExpiresDateCLK_TIMEdatetime   ALLOW_NULL The date the proposal expires  
N_JobLastModDateCLK_TIMEdatetime   ALLOW_NULL The last time the job was modified  
N_JobObjectCHARtext   ALLOW_NULL The job object  
N_JobProposalDateCLK_TIMEdatetime   ALLOW_NULL The date of the proposal  
N_JobStatusCHARvarchar 12 ALLOW_NULL The status of the job; e.g., active, won, lost, etc  
N_JobTotalDollarsDECIMALdecimal (19,4)   ALLOW_NULL, CURRENCY The total amount of the job quote  
N_JobUNCPathCHARvarchar 250 ALLOW_NULL The UNC path of the job  
N_JobUploadStatusCHARvarchar 20 ALLOW_NULL A marker showing whether or not the job is marked for upload, Unsent, or Sent  
N_QuoteNumberCHARvarchar 24 ALLOW_NULL The quote number  
N_SalesMechanixIDCHARvarchar 39  The GUID of the job (N_JobSummary) object. This is unique for every job  
objidLONGint3  DIRECT Internal record number  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
N_JobSummary2scheduleOTOPcontr_scheduleschedule2N_JobSummaryAssociated contr_schedule    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5413N_SalesMechanixIDUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
I5413N_SalesMechanixIDnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
N_JobSummary