dev | LONG | int | 151 | | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | |
N_CustomerCompanyName | CHAR | varchar | | 80 | | ALLOW_NULL | The name of the customer's company | |
N_CustomerContactFirstName | CHAR | varchar | | 30 | | ALLOW_NULL | The first name of your contact at the company | |
N_CustomerContactLastName | CHAR | varchar | | 30 | | ALLOW_NULL | The last name of your contact at the company | |
N_CustomerOmsID | CHAR | varchar | | 24 | | ALLOW_NULL | Unique customer ID number | |
N_CustomerPO | CHAR | varchar | | 24 | | ALLOW_NULL | The customer's zip/postal code | |
N_EstimatedMarketValue | DECIMAL | decimal (19,4) | | | | ALLOW_NULL, CURRENCY | The value of the job | |
N_FileSavePath | CHAR | varchar | | 250 | | ALLOW_NULL | The location in which this file is saved | |
N_JobCreationDate | CLK_TIME | datetime | | | | ALLOW_NULL | The date on which the job was created | |
N_JobDescription | CHAR | varchar | | 80 | | ALLOW_NULL | A short description of the job | |
N_JobExpiresDate | CLK_TIME | datetime | | | | ALLOW_NULL | The date the proposal expires | |
N_JobLastModDate | CLK_TIME | datetime | | | | ALLOW_NULL | The last time the job was modified | |
N_JobObject | CHAR | text | | | | ALLOW_NULL | The job object | |
N_JobProposalDate | CLK_TIME | datetime | | | | ALLOW_NULL | The date of the proposal | |
N_JobStatus | CHAR | varchar | | 12 | | ALLOW_NULL | The status of the job; e.g., active, won, lost, etc | |
N_JobTotalDollars | DECIMAL | decimal (19,4) | | | | ALLOW_NULL, CURRENCY | The total amount of the job quote | |
N_JobUNCPath | CHAR | varchar | | 250 | | ALLOW_NULL | The UNC path of the job | |
N_JobUploadStatus | CHAR | varchar | | 20 | | ALLOW_NULL | A marker showing whether or not the job is marked for upload, Unsent, or Sent | |
N_QuoteNumber | CHAR | varchar | | 24 | | ALLOW_NULL | The quote number | |
N_SalesMechanixID | CHAR | varchar | | 39 | | | The GUID of the job (N_JobSummary) object. This is unique for every job | |
objid | LONG | int | 3 | | | DIRECT | Internal record number | |