MYOB Exo Business CRM
List of attributes
Attribute details
Column nameTableKeyData typeNot NULLComment
ABSENTSTAFFCHAR(1)YesThis field is set to 'Y' if the staff member is currently absent, i.e. if their Absent flag is ticked in EXO Business Configurator.
ACCGROUPCRM_BUDGET_LINEFKINTEGERNoThe ID number of the Account Group that the line applies to (if there is one).
ACCGROUPCRM_BUDGET_EXCLUDED_ACCGROUP2SFKINTEGERYesThe Alternate Account Group ID to be excluded when generating budgets.
ACCGROUPCRM_BUDGET_EXCLUDED_ACCGROUPSFKINTEGERYesThe Account Group ID to be excluded when generating budgets.
ACCGROUP2CRM_BUDGET_LINEFKINTEGERNoThe ID number of the Alternate Account Group that the line applies to (if there is one).
ACCGROUP2_EXPANSIONCRM_BUDGET_LINEBITNo
ACCGROUP_EXPANSIONCRM_BUDGET_LINEBITNo
ACCNOCRM_BUDGET_LINEFKINTEGERNoThe ID number of the Debtor account that the line applies to (if there is one).
ACCNOCRM_BUDGET_EXCLUDED_DR_ACCSFKINTEGERYesThe Debtor account ID to be excluded when generating budgets.
ACCNO_EXPANSIONCRM_BUDGET_LINEBITNo
ACCOUNT_STATUSSTAFFINTEGERYesThe staff member's account status. Will be one of:
0 = Account OK
1 = Account Locked
2 = Password Expired
ACTIVITY_TYPETASKSINTEGERYesThe field contains 0 if the activity is an appointment, or 1 if it is a task.
ACTUALCRM_BUDGET_LINEDECIMAL(19, 4)NoActuals for the budget line.
ACTUALFINISHTASKSDATETIMENoThe actual datetime stamp when the activity was finished.
ACTUALSTARTTASKSDATETIMENoThe actual datetime stamp when the activity was started. For recurring events it contains the start date of the first occurrence.
ACTUAL_PERIOD_STATUS_SEQNOCRM_BUDGETFKINTEGERNoThe ID number of the corresponding period in the current year, as set up in EXO Business Config (links to PERIOD_STATUS.SEQNO).
ACTUAL_UNITCOSTOPPORTUNITY_QUOTEFLOAT(53)NoThe unit cost for the Stock item on the quote line.
ADDRESS1CONTACTSVARCHAR(30)NoPostal address line 1.
ADDRESS2CONTACTSVARCHAR(30)NoPostal address line 2.
ADDRESS3CONTACTSVARCHAR(30)NoPostal address line 3.
ADDRESS4CONTACTSVARCHAR(30)NoPostal address line 4.
ADDRESS5CONTACTSVARCHAR(30)NoPostal address line 5. This line is only available on the Contacts window if the Additional Postal Address Row profile setting is enabled.
ADMIN_STATCAMPAIGN_STAGECHAR(1)YesIf this field is set to 'Y', the campaign stage does not allow the entry of new transactions.
ADMIN_STATOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage prevents entry of new transactions.
ADVERTSOURCECONTACTSFKINTEGERNoThe Contact's Advertising Source - corresponds to the SEQNO of the type in the ADVERT_TYPES table.
AGEPERIOD_STATUSINTEGERYesThe age of the period. The current period has an age of 0.
ALINENOOPPORTUNITY_QUOTEINTEGERNoA unique line number.
AMOUNTOPPORTUNITYFLOAT(53)NoThe quote value for the Opportunity.
ANALYSISOPPORTUNITY_QUOTEINTEGERNo
API_ACCESSSTAFFCHAR(1)NoThis field contains 'Y' if the staff member is authorised to use the EXO API.
APP_PASSWORDSTAFFVARCHAR(30)NoThe staff member's password, used when logging in to the EXO Business system. Passwords are stored in an encrypted format.
ASSIGNED_BYTASKSFKINTEGERNoThe ID number of the staff member who assigned the activity.
ASSIGNED_BYOPPORTUNITYINTEGERNoThe ID of the staff member who assigned the Opportunity.
ASSIGNED_TOOPPORTUNITYINTEGERNoThe ID of the staff member to whom the Opportunity has been assigned.
ASSIGNED_TOTASKSFKINTEGERNoThe ID number of the staff member who the activity has been assigned to.
AUTH_AMTSTAFFFLOAT(53)NoThe staff member's Credit Invoice Authorisation Limit.
BAD_LOGIN_COUNTSTAFFINTEGERYesThe number of times the staff member has attempted to log in but failed.
BANKFEED_REFRESHTOKENSTAFFVARCHAR(500)NoEncrypted OAuth refresh token used for Bank Feeds.
BOMPRICINGOPPORTUNITY_QUOTECHAR(1)NoHow the Bill of Materials is priced. Will be one of:
C = pricing by Component
T = Pricing by total
BOMTYPEOPPORTUNITY_QUOTECHAR(1)NoThe type of Bill of Materials that the line relates to:
N = Normal stock item
B = Build
K = Kit
L = Lookup
BRANCHNOCRM_BUDGET_LINEFKINTEGERNoThe ID number of the branch that the line applies to (if there is one).
BRANCHNOOPPORTUNITY_QUOTEINTEGERNoThe ID number of the branch used on this line.
BRANCHNOCRM_BUDGET_EXCLUDED_BRANCHESFKINTEGERYesThe branch ID to be excluded when generating budgets.
BRANCHNO_EXPANSIONCRM_BUDGET_LINEBITNo
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_STOCK_GROUPSFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_STOCK_GROUP2SFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_DR_ACCSFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_STOCK_ITEMSFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_BRANCHESFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_ACCGROUPSFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_ACCGROUP2SFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_EXCLUDED_STAFFFKINTEGERYesThe ID number of the budget (Links to CRM_BUDGET.SEQNO).
BUDGET_SEQNOCRM_BUDGET_LINEFKINTEGERYesThe ID number of the budget that the line record belongs to.
CALENDARMANREP_PERIODCHAR(1)No
CAMPAIGN_SEQNOCAMPAIGN_CONTACT_LISTSFKINTEGERYesThe ID number of the campaign that the contact list is assigned to.
CAMPAIGN_SEQNOCAMPAIGN_WAVEFKINTEGERYesThe ID number of the campaign that the campaign wave is part of.
CAMPAIGN_SEQNOCAMPAIGN_HISTFKINTEGERYesThe ID number of the campaign that the History Note is attached to.
CAMPAIGN_SEQNOTASKSFKINTEGERNoThe ID number of the campaign the activity relates to (links to CAMPAIGN.SEQNO).
CAMPAIGN_STAGECAMPAIGNFKINTEGERNoThe ID number of the Stage specified for the campaign, from the CAMPAIGN_STAGE table.
CAMPAIGN_TYPECAMPAIGNFKINTEGERYesThe ID number of the Type specified for the campaign, from the CAMPAIGN_TYPE table.
CAMPAIGN_WAVE_SEQNOCAMPAIGN_WAVE_CONTACT_LISTSFKINTEGERYesThe ID number of the campaign wave that uses the list.
CAMPAIGN_WAVE_SEQNOCAMPAIGN_WAVE_AUDITFKINTEGERYesThe ID number of the campaign wave.
CAMPAIGN_WAVE_SEQNOCONTACTSFKINTEGERNoIf the Contact is included in a campaign wave (EXO Business CRM), the wave's ID number is stored here.
CAMPAIGN_WAVE_SEQNOOPPORTUNITYFKINTEGERNoIf the Opportunity is associated with a campaign wave (EXO Business CRM), the wave's ID number is stored here.
CAMPAIGN_WAVE_SEQNOTASKSFKINTEGERNoThe ID number of the campaign wave the activity relates to (links to CAMPAIGN_WAVE.SEQNO).
CLOSED_VALUEOPPORTUNITYFLOAT(53)YesThe total value of all closed lines on the Opportunity.
CLOSE_DATEOPPORTUNITYDATETIMENoThe date and time when the Opportunity was changed to Closed status.
COMMUNICATION_METHODCAMPAIGN_WAVEINTEGERNoThis field specifies the Communication Method selected for the campaign wave. Will be one of:
0 = no Communication Method selected
1 = Mailshot Process
2 = Bulk Activity Creation
3 = Execute SQL
4 = Social Media Post
5 = Export List
6 = Execute External Program
COMMUNICATION_METHODCAMPAIGN_WAVE_AUDITINTEGERNoThe campaign wave's communication method. Will be one of:
0 = no Communication Method selected
1 = Mailshot Process
2 = Bulk Activity Creation
3 = Execute SQL
4 = Social Media Post
5 = Export List
6 = Execute External Program
COMPANYIDTASKSVARCHAR(50)NoThe ID number of the company the activity relates to. Will be the ACCNO preceded by a letter:
D = Debtor account
C = Creditor account
P = Prospect (Non Account)
COMPANYIDOPPORTUNITYVARCHAR(50)NoThe ID number of the company (Debtor, Creditor or Non Account) that the Opportunity is assigned to.
COMPANY_ACCNOCONTACTSINTEGERNoIf the Contact is associated with a company (Debtor, Creditor or Non Account) the company's ID number is recorded here.
COMPANY_ACCTYPECONTACTSINTEGERNoIf the Contact is associated with a company (Debtor, Creditor or Non Account) the type of company account is recorded here:
1 = Debtor account
2 = Creditor account
3 = Non Account
COMPLETECAMPAIGN_WAVECHAR(1)NoThis field is set to 'Y' if the campaign wave's Complete flag is ticked.
COMPLETEDTASKSCHAR(1)YesThis field contains "Y" if the activity has been completed.
COMPLETED_DATETIMETASKSDATETIMENoThe date and time when the activity was completed.
COMPLETED_PERCENTTASKSFLOAT(53)YesThe percentage completion amount for the activity (only used for tasks).
CONTACTSEQNOOPPORTUNITYINTEGERNoThe ID number of the Contact that the Opportunity is assigned to.
CONTACTSEQNOTASKSFKINTEGERNoThe ID number of the contact the activity is linked to.
CONTACT_LIST_SEQNOCAMPAIGN_CONTACT_LISTSFKINTEGERYesThe ID number of the contact list that is assigned to the campaign.
CONTACT_LIST_SEQNOCAMPAIGN_WAVE_CONTACT_LISTSFKINTEGERYesThe ID number of the contact list that is used by the campaign wave.
CONTACT_LIST_TYPECONTACT_LISTFKINTEGERNoThe ID number of the contact list's List Type, taken from CONTACT_LIST_TYPE.
CONTACT_SEQNOCAMPAIGN_WAVE_AUDITFKINTEGERYesThe ID number of the Contact that the wave was sent to.
COST_CENTREOPPORTUNITY_QUOTEINTEGERNoThe Cost Type on the quote line.
COST_CENTRE2OPPORTUNITY_QUOTEINTEGERNoThe Cost Group on the quote line.
CREATEDATEOPPORTUNITYDATETIMENoThe date and time that the Opportunity was created.
CREATEDATECAMPAIGNDATETIMENoThe date the campaign was created on.
CREATEDATETASKSDATETIMEYesThe date and time when the activity was created.
CREATEDATECONTACT_LISTDATETIMEYesThe date when the contact list was created.
CREATEDBYOPPORTUNITYINTEGERNoThe ID number of the staff member who created the Opportunity.
CREATEDBYTASKSFKINTEGERNoThe ID number of the staff member who created the activity.
CREATED_BYCONTACT_LISTFKINTEGERYesThe ID number of the staff member who created the contact list.
CURRENCYNOOPPORTUNITYINTEGERNoThe ID number of the currency that the Sales Order is in.
CURRENCYNOOPPORTUNITY_QUOTEFKINTEGERNoThe ID number of the currency that the Sales Order is in.
DEF_PROBABILITYOPPORTUNITY_STAGEINTEGERNoThe default probability percentage for the stage.
DELADDR1CONTACTSVARCHAR(30)NoDelivery address line 1.
DELADDR2CONTACTSVARCHAR(30)NoDelivery address line 2.
DELADDR3CONTACTSVARCHAR(30)NoDelivery address line 3.
DELADDR4CONTACTSVARCHAR(30)NoDelivery address line 4.
DELADDR5CONTACTSVARCHAR(30)NoDelivery address line 5.
DELADDR6CONTACTSVARCHAR(30)NoDelivery address line 6.
DELETED_FLAGTASKSCHAR(1)YesThis field contains "Y" if the activity has been deleted.
DESCRIPTCONTACT_LIST_TYPEVARCHAR(60)NoThe name/description of the type.
DESCRIPTCAMPAIGN_WAVEVARCHAR(50)NoA short written description of the campaign wave.
DESCRIPTCAMPAIGNVARCHAR(5000)NoAny notes entered for the campaign.
DESCRIPTCAMPAIGN_TYPEVARCHAR(60)NoThe campaign type's name/description.
DESCRIPTCONTACT_LISTVARCHAR(1000)NoThe text entered into the contact list's Notes field.
DESCRIPTCAMPAIGN_STAGEVARCHAR(60)NoThe stage's name/description.
DESCRIPTIONOPPORTUNITY_TYPEVARCHAR(60)NoThe name/description of the Opportunity Type.
DESCRIPTIONOPPORTUNITY_LINESVARCHAR(40)Yes
DESCRIPTIONOPPORTUNITY_STAGE_CONSTRAINTVARCHAR(50)YesA description of the constraint.
DESCRIPTIONCAMPAIGN_STAGE_CONSTRAINTVARCHAR(50)YesA description of the constraint.
DESCRIPTIONOPPORTUNITY_STAGEVARCHAR(60)NoA description of the stage.
DESCRIPTIONOPPORTUNITYVARCHAR(60)NoDescription text for the Opportunity.
DESCRIPTIONOPPORTUNITY_QUOTEVARCHAR(60)NoThe description of the stock item on this line.
DESCRIPTIONTASK_TYPESVARCHAR(60)NoThe type's name/description.
DESCRIPTIONTASK_STATUSESVARCHAR(60)NoThe name/description of the status.
DESCRIPTIONOPPORTUNITY_LEADVARCHAR(60)NoThe Lead Source's name/description.
DETAILSTASKSVARCHAR(5500)NoDetails relating to the activity.
DETAILSOPPORTUNITYVARCHAR(4096)NoAny details or notes entered for the Opportunity.
DIM_DEPTHOPPORTUNITY_QUOTEFLOAT(53)YesThe Depth value specified for the quote line.
DIM_LENGTHOPPORTUNITY_QUOTEFLOAT(53)YesThe Length value specified for the quote line.
DIM_WIDTHOPPORTUNITY_QUOTEFLOAT(53)YesThe Width value specified for the quote line.
DIRECTFAXCONTACTSVARCHAR(30)NoThe Contact's fax number.
DIRECTPHONECONTACTSVARCHAR(30)NoThe Contact's direct telephone number.
DISCOUNTOPPORTUNITY_QUOTEFLOAT(53)NoThe percentage discount on the quote line.
DISCOUNTOPPORTUNITY_LINESFLOAT(53)No
DISCOUNTRATESTAFFFLOAT(53)YesThe staff member's Discount Rate Limit.
DOC_BATCH_HDR_SEQNOCAMPAIGN_WAVEINTEGERNoFor campaign waves with the "Mailshot Process " Communication Method that include email attachments, this field contains the ID number of the documentation batch in the DOC_BATCH_HDR table that relates to the attachments.
DUE_DATEOPPORTUNITYDATETIMENoThe due date for the Opportunity.
EMAILCONTACTSVARCHAR(60)NoThe Contact's email address.
EMAIL_ADDRESSSTAFFVARCHAR(50)NoThe staff member's email address.
EMPLOYEE_CODESTAFFINTEGERYesThis field is used by the payroll integration functionality.
ENDDATECRM_BUDGETDATETIMENoThe end date of the period.
ENDDATEMANREP_PERIODDATETIMENo
ENDDATECAMPAIGNDATETIMENoThe End Date specified for the campaign.
ENDDATECAMPAIGN_WAVEDATETIMENoThe end date for the period that the campaign wave runs over.
END_DATETIMETASKSDATETIMENoThe date and time when the activity ends.
ESTIMATEOPPORTUNITYFLOAT(53)YesThe estimated value entered for the Opportunity.
EST_COSTCAMPAIGNFLOAT(53)NoThe Estimated Cost entered for the campaign.
EST_RESPONSECAMPAIGNFLOAT(53)NoThe Estimated Response entered for the campaign.
EST_REVENUECAMPAIGNFLOAT(53)NoThe Estimated Revenue amount entered for the campaign.
EVENTTYPETASKSINTEGERNoA number indicating the type of event, where 0 is for a normal activity and all other numbers are used for recurring events.
EXCHRATEOPPORTUNITYFLOAT(53)NoThe exchange rate for the currency that the Opportunity is in.
EXCHRATEOPPORTUNITY_QUOTEFLOAT(53)NoThe currency exchange rate used for the quote.
EXECUTE_TYPECAMPAIGN_WAVE_AUDITVARCHAR(15)NoHow communication was sent to the contact - "EMAILED" or "PRINTED".
EXTENSIONSTAFFVARCHAR(12)NoThe staff member's telephone extension.
FACEBOOKCONTACTSVARCHAR(500)NoThe Contact's Facebook username or ID number.
FACEBOOK_ACCESS_TOKENSTAFFVARCHAR(max)NoIf the staff member uses their own Facebook account when using the EXO Business social media functions, their encrypted access token is stored here.
FACEBOOK_POST_IDCAMPAIGN_WAVEVARCHAR(100)NoFor campaign waves with the "Social Media Post" Communication Method, this field contains the ID number of the Facebook post.
FIN_QTRPERIOD_STATUSINTEGERYesThe financial quarter that the period belongs to.
FIRSTNAMECONTACTSVARCHAR(30)NoThe Contact's first name.
FROMLOCOPPORTUNITY_QUOTEINTEGERNoThe ID number of the location that the Stock item on this line is being supplied from.
FROM_STATUSCAMPAIGN_STAGE_CONSTRAINTCHAR(1)NoThe source stage for the constraint.
FROM_STATUSOPPORTUNITY_STAGE_CONSTRAINTCHAR(1)NoThe source stage for the constraint.
FULLNAMECONTACTSASNoThe Contact's full name, formed by joining the FIRSTNAME and LASTNAME fields.
GEOCODE_STATUSCONTACTSINTEGERNoResult of the geocode lookup. Will be one of:
Null or -1 - lookup not yet attempted
0 - lookup successful
>0 - lookup failed
GLCODEOPPORTUNITY_QUOTEFKINTEGERNoThe GL account on this quote line.
GROUPNOCRM_BUDGET_EXCLUDED_STOCK_GROUP2SFKINTEGERYesThe Alternate Stock Group ID to be excluded when generating budgets.
GROUPNOCRM_BUDGET_EXCLUDED_STOCK_GROUPSFKINTEGERYesThe Stock Group ID to be excluded when generating budgets.
HAS_BUDGETSSTAFFCHAR(1)NoThis field is set to 'Y' if the staff member has been assigned a Sales Team Budget, i.e. if their Has Budget flag is ticked in EXO Business Configurator.
HDR_SEQNOOPPORTUNITY_QUOTE_OPTIONSFKINTEGERNoThe ID number of the Opportunity that this option applies to.
HDR_SEQNOOPPORTUNITY_LINESINTEGERYes
HDR_SEQNOOPPORTUNITY_QUOTEFKINTEGERYesThe ID number of the Opportunity that this line relates to (OPPORTUNITY.SEQNO).
HDR_SEQNOCONTACT_LIST_ITEMFKINTEGERYesThe ID number of the contact list (CONTACT_LIST.SEQNO).
HEADER_SEQNOCRM_BUDGETFKINTEGERYesThe ID number of the budget this line belongs to (links to CRM_BUDGET_HDR.SEQNO)
HIDDEN_COSTOPPORTUNITY_QUOTEFLOAT(53)YesThis field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell costs. For builds that use individual stocklines, this fields stores the lines' real costs.
HIDDEN_LINETOTALOPPORTUNITY_QUOTEFLOAT(53)Yes
HIDDEN_SELLOPPORTUNITY_QUOTEFLOAT(53)YesThis field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell prices. For builds that use individual stocklines, this fields stores the lines' real prices.
HOMEPHONECONTACTSVARCHAR(30)NoThe Contact's home phone number.
HOMEPHONESTAFFVARCHAR(30)NoThe staff member's home telephone number.
ISACTIVECONTACTSCHAR(1)NoWhether the Contact is active (Y) or inactive (N).
ISACTIVECAMPAIGN_STAGE_CONSTRAINTCHAR(1)YesIf this field contains 'Y', the constraint applies, so that users are permitted to change a campaign from the stage specified by the FROM_STATUS to the stage specified by the TO_STATUS.
ISACTIVECRM_BUDGET_HDRBITYesThis field is set to 1 if the budget is active or 0 if it is inactive.
ISACTIVECAMPAIGN_STAGECHAR(1)YesIf this field is set to 'Y', campaigns at this stage are active.
ISACTIVEOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage causes the Opportunity to be marked as Active.
ISACTIVESTAFFCHAR(1)NoThis field is set to 'Y' if the staff member is currently active, i.e. if their Active flag is ticked in EXO Business Configurator.
ISACTIVEOPPORTUNITY_STAGE_CONSTRAINTCHAR(1)YesIf this field contains 'Y', the constraint applies, so that users are permitted to change an Opportunity from the stage specified by the FROM_STATUS to the stage specified by the TO_STATUS.
ISARCHIVEDCAMPAIGN_STAGECHAR(1)YesIf this field is set to 'Y', campaigns at this stage will be archived.
ISARCHIVEDOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage causes the Opportunity to be archived.
ISCOMPLETECAMPAIGN_STAGECHAR(1)YesIf this field is set to 'Y', campaigns at this stage are complete.
ISCOMPLETEOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage causes the Opportunity to be marked as Complete.
ISINVOICEREADYOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage causes the Opportunity to be marked as Ready for Invoice.
ISLOCKQUOTEOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage causes quotations on the Opportunity to be read-only.
ISPRIMARYCRM_BUDGET_HDRBITYesThis field is set to 1 if the budget is a primary budget; 0 otherwise.
IS_ACTIVECONTACT_LISTCHAR(1)NoThis field contains 'Y' if the contact list is active.
IS_CLOSEOPPORTUNITYASNoSet to 'Y' if the Opportunity has been changed to Closed status.
IS_PRIVATECONTACT_LISTCHAR(1)NoThis field contains 'Y' if the contact list is private, i.e. only available to its owner (see the OWNER field).
IS_SUPERVISORSTAFFCHAR(1)YesThis field is set to 'Y' if the staff member is designated as a supervisor, i.e. if their Has supervisory override authority flag is ticked.
ITEM_SEQNOCONTACT_LIST_ITEMFKINTEGERNoThe item's ID number. For contacts, this is CONTACTS.SEQNO.
ITEM_TYPECONTACT_LIST_ITEMINTEGERYesThe type of item.
1 = Contact
JOBNOTASKSFKINTEGERYesThe ID number of the job the activity relates to (links to JOBCOST_HDR.JOBNO).
JOBTITLESTAFFVARCHAR(30)NoThe staff member's job title.
JOB_LINKCAMPAIGNINTEGERNoIf campaign costs are being tracked by linking the campaign to a job in the EXO Job Costing system, the linked job's ID number is recorded here.
KITCODEOPPORTUNITY_QUOTEVARCHAR(23)NoThe Bill of Materials code, if the line is part of a BOM.
KITSEQNOOPPORTUNITY_QUOTEINTEGERYesA Bill of Materials SEQNO used to group BOM lines together.
LABELCOLORTASKSINTEGERNoThe colour value for the colour used to highlight the activity on calendars.
LANDING_SITECAMPAIGN_WAVEVARCHAR(150)NoFor campaign waves with the "Mailshot Process" Communication Method, this field contains any text entered into the Landing site field.
LASTNAMECONTACTSVARCHAR(30)NoThe Contact's last/family name.
LAST_BAD_LOGINSTAFFDATETIMENoThe date and time when the staff member last attempted to log in but failed.
LAST_LOGINSTAFFDATETIMENoThe date and time when the staff member last successfully logged in.
LAST_MODIFIEDCONTACT_LISTDATETIMEYesThe date when the contact list was last edited.
LAST_UPDATEDCONTACTSDATETIMENoThe date and time when the Contact record was last updated.
LAST_UPDATEDCAMPAIGNDATETIMENoThe date that the campaign was last edited on.
LATITUDECONTACTSFLOAT(53)NoThe Contact's latitude.
LEDGERPERIOD_STATUSCHAR(1)YesThe ledger for a specific age.
LEVEL_ACCGROUPCRM_BUDGETBITYesThis field contains 1 if the budget applies at the Account Group level; 0 otherwise.
LEVEL_ACCGROUP2CRM_BUDGETBITYesThis field contains 1 if the budget applies at the Alternate Account Group level; 0 otherwise.
LEVEL_ACCNOCRM_BUDGETBITYesThis field contains 1 if the budget applies at the Debtor account level; 0 otherwise.
LEVEL_BRANCHCRM_BUDGETBITYesThis field contains 1 if the budget applies at the Branch level; 0 otherwise.
LEVEL_STAFFCRM_BUDGETBITYesThis field contains 1 if the budget applies at the staff member level; 0 otherwise.
LEVEL_STOCKCODECRM_BUDGETBITYesThis field contains 1 if the budget applies at the Stock item level; 0 otherwise.
LEVEL_STOCKGROUPCRM_BUDGETBITYesThis field contains 1 if the budget applies at the Stock Group level; 0 otherwise.
LEVEL_STOCKGROUP2CRM_BUDGETBITYesThis field contains 1 if the budget applies at the Alternate Stock Group level; 0 otherwise.
LINETAX_OVERRIDDENOPPORTUNITY_QUOTECHAR(1)YesSet to 'Y' if the tax on the line was overridden.
LINETAX_OVERRIDEOPPORTUNITY_QUOTEFLOAT(53)YesIf the tax on the line was manually overridden, this field contains the new value.
LINETOTALOPPORTUNITY_QUOTEASNoA computed field showing the line total.
LINETOTAL_INCTAXOPPORTUNITY_QUOTEASNoThe line total including tax.
LINETOTAL_TAXOPPORTUNITY_QUOTEFLOAT(53)YesThe total amount of tax on the quote line.
LINETYPEOPPORTUNITY_QUOTEINTEGERYesThe type of the line. Will be one of:
0 = Not part of a BOM.
1 = Header line of a BOM.
2 = Line of a BOM.
LINE_STATUSOPPORTUNITY_QUOTEVARCHAR(30)No
LINE_TAXOPPORTUNITY_QUOTEFLOAT(53)YesThe amount of tax on the quote line.
LINKEDINCONTACTSVARCHAR(20)NoThe Contact's LinkedIn account ID.
LINKEDIN_POST_DATECAMPAIGN_WAVEDATETIMENoFor campaign waves with the "Social Media Post" Communication Method, this field contains the date of the LinkedIn post.
LINKEDIN_TOKEN_KEYSTAFFVARCHAR(max)NoIf the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token key is stored here.
LINKEDIN_TOKEN_SECRETSTAFFVARCHAR(max)NoIf the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token secret is stored here.
LINKEDSTATUSOPPORTUNITY_QUOTECHAR(1)NoThe linked status of the Stock line. Will be one of:
S = Stocked
L = Lookup
N = Not applicable
LINKED_QTYOPPORTUNITY_QUOTEFLOAT(53)NoThe linked quantity, if applicable.
LINKED_STOCKCODEOPPORTUNITY_QUOTEVARCHAR(23)NoThe linked Stock code, if applicable.
LISTPRICEOPPORTUNITY_QUOTEFLOAT(53)NoThe original sell price of the Stock item on this line.
LOCKEDPERIOD_STATUSCHAR(1)NoIf set to 'Y', the period is locked, implying that this age in a specific ledger is closed and no more transactions should take place
LOCK_CAMPAIGNCAMPAIGN_STAGECHAR(1)YesIf this field is set to 'Y', the campaign stage makes campaigns locked, i.e. read-only.
LOCK_JOBOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', the stage makes the Opportunity read-only.
LOGDATETIMECAMPAIGN_WAVE_AUDITDATETIMEYesThe date and time that the campaign wave was sent.
LOGINIDSTAFFVARCHAR(30)YesThe staff member's login ID. This is the ID used to log in to the EXO Business system.
LONGITUDECONTACTSFLOAT(53)NoThe Contact's longitude.
LOST_VALUEOPPORTUNITYFLOAT(53)YesThe total value of all lost lines on the Opportunity.
LYACTUALCRM_BUDGET_LINEDECIMAL(19, 4)NoLast year actuals for the budget line.
LYACTUAL_PERIOD_STATUS_SEQNOCRM_BUDGETFKINTEGERNoThe ID number of the corresponding period last year, as set up in EXO Business Config (links to PERIOD_STATUS.SEQNO).
MANREP_PERIOD_SEQNOCRM_BUDGETFKINTEGERYesThe ID number of the period as set up in EXO Business Analytics (links to MANREP_PERIOD.PERIOD_SEQNO).
MANREP_PERIOD_SEQNOCRM_BUDGET_HDRFKINTEGERYesThe ID number of the Sales Year that the budget belongs to (Sales Years are set up using the EXO Business Analytics module).
MENU_NOSTAFFFKINTEGERNoThe ID number of the Menu Definition specified for the staff member. Corresponds to the menu's SEQNO field in the MENU_COLLECTION table.
MINGLSEQNOPERIOD_STATUSINTEGERNoThe first transaction for the period found in the GLTRANS table.
MINORDLINESEQNOPERIOD_STATUSINTEGERNoFor the Debtors ledger, this specifies the first transaction for the period found in the SALESORD_LINES table.
For the Creditors ledger, this specifies the first transaction for the period found in the PURCHORD_LINES table.
MINORDSEQNOPERIOD_STATUSINTEGERNoFor the Debtors ledger, this specifies the first transaction for the period found in the SALESORD_HDR table.
For the Creditors ledger, this specifies the first transaction for the period found in the PURCHORD_HDR table.
MINSTOCKSEQNOPERIOD_STATUSINTEGERNoThe first transaction for the period found in the Stock ledger.
MINTRANLINESEQNOPERIOD_STATUSINTEGERNoFor the Debtors ledger, this specifies the first transaction for the period found in the DR_INVLINES table.
For the Creditors ledger, this specifies the first transaction for the period found in the CR_INVLINES table.
MINTRANSEQNOPERIOD_STATUSINTEGERNoFor the Debtors ledger, this specifies the first transaction for the period found in the DR_TRANS table.
For the Creditors ledger, this specifies the first transaction for the period found in the CR_TRANS table.
MOBILECONTACTSVARCHAR(30)NoThe Contact's mobile phone number.
MOBILE_ACCESSSTAFFCHAR(1)YesThis field contains 'Y' if the staff member is authorised to use the EXO OnTheGo mobile app.
MODIFIEDBYOPPORTUNITYINTEGERNoThe ID number of the staff member who most recently modified the Opportunity.
MODIFIEDBYTASKSFKINTEGERNoThe ID number of the staff member who last modified the activity.
MODIFIEDDATETASKSDATETIMENoThe date and time when the activity was last edited.
MODIFIEDDATEOPPORTUNITYDATETIMENoThe date and time that the Opportunity was most recently modified.
MSN_IDCONTACTSVARCHAR(45)NoThe Contact's MSN ID number.
NAMESTAFFVARCHAR(30)NoThe staff member's full name.
NAMECRM_BUDGETVARCHAR(1024)YesThe period name.
NAMECRM_BUDGET_HDRVARCHAR(1024)YesThe budget's name.
NARRATIVEOPPORTUNITY_QUOTEVARCHAR(1)NoSet to 'Y' if there is a narrative on this line.
NARRATIVE_SEQNOOPPORTUNITY_LINESINTEGERNo
NARRATIVE_SEQNOOPPORTUNITY_QUOTEFKINTEGERNoThe ID number of the narrative on this line.
NICKNAMESTAFFVARCHAR(15)NoA short nickname for the employee.
NON_STOCK_AUTH_AMTSTAFFFLOAT(53)NoThe staff member's Non-Stock Purchase Order Authorisation Limit.
NOTECAMPAIGN_HISTVARCHAR(4096)NoThe body of the History Note.
NOTEOPPORTUNITY_HISTVARCHAR(4096)NoThe body of the History Note.
NOTESCONTACTSVARCHAR(4096)NoAll notes entered for the Contact on the Notes tab.
NUNITPROPPORTUNITY_QUOTEASNoA computed field showing the line total including GST.
OPPLINEIDOPPORTUNITY_QUOTEINTEGERNoA unique ID number for the line.
OPPORTUNITYSEQNOTASKSFKINTEGERNoThe ID number of the Opportunity the activity is linked to.
OPPORTUNITY_LEADOPPORTUNITYFKINTEGERNoThe Opportunity's lead source, taken from OPPORTUNITY_LEAD.SEQNO.
OPPORTUNITY_SEQNOOPPORTUNITY_HISTFKINTEGERYesThe ID number of the Opportunity that the History Note is attached to.
OPPORTUNITY_STAGEOPPORTUNITYFKINTEGERNoThe Opportunity's stage, taken from OPPORTUNITY_STAGE.SEQNO.
OPPORTUNITY_TYPEOPPORTUNITYFKINTEGERNoThe Opportunity's type, taken from OPPORTUNITY_TYPE.SEQNO.
OPTIONSTASKSINTEGERNo2 = All day event
3 = Not an all day event
6 = Not an all day event with reminder
7 = All day event with reminder
OPTION_NAMEOPPORTUNITY_QUOTE_OPTIONSVARCHAR(30)NoThe option's name.
OPTION_NOOPPORTUNITY_QUOTE_OPTIONSINTEGERNoAn Opportunity-specific ID number for the option.
OPTION_NOOPPORTUNITY_QUOTEFKINTEGERYesThe option number of the Quote Option on this line (OPPORTUNITY_QUOTE_OPTION.OPTION_NO).
OPTION_NO_SEQNOOPPORTUNITY_QUOTEFKINTEGERNoThe ID number of the Quote Option on this line (OPPORTUNITY_QUOTE_OPTION.SEQNO).
OPTION_SELECTEDOPPORTUNITY_QUOTE_OPTIONSCHAR(1)YesThis field contains 'Y' if the option is currently selected for the Opportunity.
OPTOUT_EMARKETINGCONTACTSCHAR(1)NoThis field is set to 'Y' if the Contact's Opt-Out eMarketing flag is ticked. Contacts who have opted out of eMarketing will not be included in campaign waves for campaigns whose Campaign Type is set to "Marketing" (EXO Business CRM).
OPT_IN_URLCAMPAIGN_WAVEVARCHAR(150)NoFor campaign waves with the "Mailshot Process" Communication Method, this field contains any text entered into the Opt in URL field.
OPT_OUT_URLCAMPAIGN_WAVEVARCHAR(150)NoFor campaign waves with the "Mailshot Process" Communication Method, this field contains any text entered into the Opt out URL field.
OUTLOOKENTRYIDTASKSVARCHAR(255)NoIf the activity has been synched to MS Outlook, this field contains the ID number of the corresponding task or appointment in Outlook.
OUTLOOK_LINKCAMPAIGN_HISTVARCHAR(40)NoIf the History Note was emailed, this field contains a link to the email in MS Outlook.
OUTLOOK_LINKOPPORTUNITY_HISTVARCHAR(40)NoIf the History Note was emailed, this field contains a link to the email in MS Outlook.
OWNERCONTACT_LISTFKINTEGERYesThe ID number of the staff member who is designated as the contact list's owner.
OWNERCAMPAIGNFKINTEGERNoThe ID number of the staff member who is assigned as the campaign's owner.
PARENTSEQNOTASKSINTEGERNoIdentifies the activity that is the ancestor in a chain of recurrences.
PARENT_PERIOD_SEQNOMANREP_PERIODINTEGERNo
PASSWORD_CHANGEDSTAFFDATETIMEYesThe date and time when the staff member's password was last changed.
PAYROLL_IDSTAFFVARCHAR(15)NoThe staff member's Employee ID (Payroll) number. This field is used when EXO Business is integrating with an external payroll system, e.g. MYOB EXO Payroll. It must contain the employee's corresponding ID number in the payroll system.
PERIODNAMEPERIOD_STATUSVARCHAR(20)NoThe name/description for the period.
PERIOD_NAMEMANREP_PERIODVARCHAR(20)No
PERIOD_SEQNOMANREP_PERIODPKINTEGERYes
PERIOD_SEQNOPERIOD_STATUSINTEGERYesThe period's sequence number within fiscal year.
PERIOD_SHORTNAMEPERIOD_STATUSVARCHAR(8)NoA short name for the period.
PHONESTAFFVARCHAR(30)NoThe staff member's work telephone number.
POST_CODECONTACTSVARCHAR(12)NoThe Contact's post code.
PO_SEQNOTASKSFKINTEGERNoThe ID number of the Purchase Order the activity relates to (links to PURCHORD_HDR.SEQNO).
PRICE_OVERRIDDENOPPORTUNITY_QUOTECHAR(1)YesSet to 'Y' if the price has been overridden.
PRIORITYTASKSVARCHAR(20)NoThe priority given to the activity. Can be "Low", "Normal" or "High".
PROBABILITYOPPORTUNITYINTEGERNoThe Probability value entered for the Opportunity.
PROCESSEDCAMPAIGN_WAVECHAR(1)NoThis field is set to 'Y' if the campaign wave's Processed flag is ticked.
QUANTITYOPPORTUNITY_LINESFLOAT(53)No
QUERY_INSERTEDCONTACT_LIST_ITEMCHAR(1)NoThis field contains 'Y' if the item was added to the list using a query on the List Building Criteria tab of the Contact Lists window; it contains 'N' if the item was added manually.
QUOTE_QTYOPPORTUNITY_QUOTEFLOAT(53)NoThe quantity on the quote line.
QUOTE_UNITPROPPORTUNITY_QUOTEFLOAT(53)NoThe sell price for the Stock item on the quote line.
RECALC_LASTRUNCRM_BUDGETDATETIMENoThe date and time when the budget was last calculated.
RECURRENCEINDEXTASKSINTEGERNoSpecifies which one of the activity's recurrences this is.
RECURRENCEINFOTASKSIMAGENoContains information about the recurrences of the activity.
REFERENCECAMPAIGNVARCHAR(15)NoA short, user-defined reference code for the campaign.
REMINDERDATETASKSDATETIMENoThe date and time when a reminder for the activity should be displayed.
REMINDERMINUTESTASKSINTEGERNoWhen the reminder should be displayed, specified as the number of minutes before the start of the activity.
REPORTCODEPERIOD_STATUSVARCHAR(8)NoA code used for reporting purposes.
REPORTS_TO_STAFFNOSTAFFINTEGERNoThe ID number of the staff member that this staff member reports to.
RESOURCEALLOC_SEQNOTASKSFKINTEGERNoThe number ID of the resource allocation the activity has been created for (links to JOB_RESOURCE_ALLOCATION.SEQNO)
SALESNOCRM_BUDGET_LINEFKINTEGERNoThe ID number of the staff member that the line applies to (if there is one).
SALESNOCONTACTSFKINTEGERNoThe STAFFNO of staff member who is set as the Sales person for the Contact.
SALESNOCAMPAIGN_HISTFKINTEGERNoThe ID number of the staff member who entered the History Note.
SALESNOOPPORTUNITY_HISTFKINTEGERNoThe ID number of the staff member who entered the History Note.
SALESNO_EXPANSIONCRM_BUDGET_LINEBITNo
SALUTATIONCONTACTSVARCHAR(4)NoThe Contact's preferred salutation, e.g. Mr, Mrs.
SBR_REFRESHTOKENSTAFFVARCHAR(1024)NoThe refresh token used for SBR authentication.
SECTIONOPPORTUNITY_QUOTEINTEGERNo
SECURITYPROFILEIDSTAFFINTEGERYesThe ID number of the staff member's Security profile. Corresponds to the profile's ID field in the PROFILE table.
SEQNOTASK_TYPESPKINTEGERYesA unique ID number for the type.
SEQNOTASKSPKINTEGERYesA unique ID number for the activity.
SEQNOCONTACTSPKINTEGERYesA unique identifier for the Contact record.
SEQNOPERIOD_STATUSPKINTEGERYesA unique ID number for the period.
SEQNOOPPORTUNITY_TYPEPKINTEGERYesA unique ID number for the Opportunity Type.
SEQNOCAMPAIGN_STAGEPKINTEGERYesA unique ID number for the campaign stage.
SEQNOCAMPAIGN_TYPEINTEGERYesA unique ID number for the campaign type.
SEQNOOPPORTUNITY_LEADPKINTEGERYesA unique ID number for the Lead Source.
SEQNOCONTACT_LIST_ITEMPKINTEGERYesA unique ID number for the record.
SEQNOOPPORTUNITY_QUOTEPKINTEGERYesA unique identifier for the quote line.
SEQNOCONTACT_LIST_TYPEINTEGERYesA unique ID number for the type.
SEQNOOPPORTUNITYPKINTEGERYesA unique ID number for the Opportunity.
SEQNOCAMPAIGN_WAVEPKINTEGERYesA unique ID number for the campaign wave.
SEQNOCAMPAIGNPKINTEGERYesA unique ID number for the campaign.
SEQNOCAMPAIGN_HISTPKINTEGERYesA unique ID number for the History Note.
SEQNOOPPORTUNITY_QUOTE_OPTIONSPKINTEGERYesA unique ID number for the Quote Option.
SEQNOCRM_BUDGET_LINEPKINTEGERYesA unique ID number for the budget line record.
SEQNOOPPORTUNITY_HISTPKINTEGERYesA unique ID number for the History Note.
SEQNOOPPORTUNITY_STAGEPKINTEGERYesA unique ID number for the Opportunity Stage.
SEQNOCAMPAIGN_STAGE_CONSTRAINTPKINTEGERYesA unique ID number for the constraint.
SEQNOCONTACT_LISTPKINTEGERYesA unique ID number for the contact list.
SEQNOCRM_BUDGET_HDRPKINTEGERYesA unique ID number for the budget record.
SEQNOCAMPAIGN_WAVE_AUDITINTEGERYesA unique ID number for the audit line.
SEQNOCRM_BUDGETPKINTEGERYesThe ID number of the budget record.
SEQNOCAMPAIGN_CONTACT_LISTSINTEGERYesA unique ID number for the record.
SEQNOTASK_STATUSESPKINTEGERYesA unique ID number for the status.
SEQNOOPPORTUNITY_STAGE_CONSTRAINTPKINTEGERYesA unique ID number for the workflow constraint.
SEQNOOPPORTUNITY_LINESPKINTEGERYes
SEQNOCAMPAIGN_WAVE_CONTACT_LISTSINTEGERYesA unique ID number for the record.
SETTINGSCONTACT_LISTVARCHAR(max)NoSQL settings used by the contact list.
SETTINGSCAMPAIGN_WAVEVARCHAR(4096)NoThis field is used by campaign waves where the Communication Method is "Execute SQL" or "Execute External Program".
SHORTDESCOPPORTUNITY_STAGE_CONSTRAINTVARCHAR(5)YesA short code (5 characters max) for the constraint.
SHORTDESCCAMPAIGN_STAGE_CONSTRAINTVARCHAR(5)YesA short code (5 characters max) for the constraint.
SHOWLINEOPPORTUNITY_QUOTECHAR(1)NoSet to 'Y' if the line should be printed on Clarity reports.
SHOW_ON_INVOICEOPPORTUNITY_QUOTECHAR(1)NoSet to 'Y' if this line should appear on invoices.
SKYPE_IDCONTACTSVARCHAR(45)NoThe Contact's Skype ID number.
SMTP_SEQNOSTAFFINTEGERNoWhere emails are sent via SMTP using the EXO Business Email Sender, this field contains the ID of the SMTP settings that apply to the staff member (SMTP_ACCOUNT.SEQNO). Set up via the SMTP Server Settings window.
SOCIAL_MEDIA_TEXTCAMPAIGN_WAVEVARCHAR(500)NoFor campaign waves with the "Social Media Post" Communication Method, this field contains the text that is posted to the social media network(s).
SOURCEIDTASKSINTEGERNoFor recurring events, this is the ID number of the master/source event.
SO_SEQNOTASKSFKINTEGERNoThe ID number of the Sales Order the activity relates to (links to SALESORD_HDR.SEQNO).
SPREADVALUEOPPORTUNITY_QUOTECHAR(1)YesSet to 'Y' if totals can be spread.
STAFFNOCRM_BUDGET_EXCLUDED_STAFFFKINTEGERYesThe staff member ID to be excluded when generating budgets.
STAFFNOSTAFFPKINTEGERYesA unique identifier for the staff record.
STARTDATEPERIOD_STATUSDATETIMENoThe start date for the period.
STARTDATEMANREP_PERIODDATETIMENo
STARTDATECRM_BUDGETDATETIMENoThe start date of the period.
STARTDATECAMPAIGNDATETIMENoThe Start Date specified for the campaign.
STARTDATECAMPAIGN_WAVEDATETIMENoThe start date for the period that the campaign wave runs over.
START_DATEOPPORTUNITYDATETIMENoThe start date of the Opportunity.
START_DATETIMETASKSDATETIMENoThe date and time when the activity starts.
STATETASKSINTEGERNoThe availability status to be displayed while the activity is active. Will be one of:
0 = Free
1 = Tentative
2 = Busy
3 = Out of office
STATUSTASKSFKINTEGERNoThe ID number of the activity's status (links to TASK_STATUSES).
STATUSKEYCAMPAIGN_STAGECHAR(1)NoA one-character code for the stage.
STATUSKEYOPPORTUNITY_STAGECHAR(1)NoA unique, one-character short code for the stage.
STOCKCODEOPPORTUNITY_QUOTEFKVARCHAR(23)NoThe ID code of the stock item on this line.
STOCKCODECRM_BUDGET_EXCLUDED_STOCK_ITEMSFKVARCHAR(23)YesThe Stock item ID to be excluded when generating budgets.
STOCKCODECRM_BUDGET_LINEFKVARCHAR(23)NoThe ID number of the Stock item that the line applies to (if there is one).
STOCKCODEOPPORTUNITY_LINESVARCHAR(23)Yes
STOCKCODE_EXPANSIONCRM_BUDGET_LINEBITNo
STOCK_AUTH_AMTSTAFFFLOAT(53)NoThe staff member's Stock Purchase Order Authorisation Limit.
STOCK_GROUPNOCRM_BUDGET_LINEFKINTEGERNoThe ID number of the Stock Group that the line applies to (if there is one).
STOCK_GROUPNO2CRM_BUDGET_LINEFKINTEGERNoThe ID number of the Alternate Stock Group that the line applies to (if there is one).
STOCK_GROUPNO2_EXPANSIONCRM_BUDGET_LINEBITNo
STOCK_GROUPNO_EXPANSIONCRM_BUDGET_LINEBITNo
STOPDATEPERIOD_STATUSDATETIMENoThe end date for the period.
SUB1CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 1 is ticked on the Marketing tab.
SUB10CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 10 is ticked on the Marketing tab.
SUB11CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 11 is ticked on the Marketing tab.
SUB12CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 12 is ticked on the Marketing tab.
SUB13CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 13 is ticked on the Marketing tab.
SUB14CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 14 is ticked on the Marketing tab.
SUB15CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 15 is ticked on the Marketing tab.
SUB16CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 16 is ticked on the Marketing tab.
SUB17CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 17 is ticked on the Marketing tab.
SUB18CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 18 is ticked on the Marketing tab.
SUB19CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 19 is ticked on the Marketing tab.
SUB2CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 2 is ticked on the Marketing tab.
SUB20CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 20 is ticked on the Marketing tab.
SUB21CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 21 is ticked on the Marketing tab.
SUB22CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 22 is ticked on the Marketing tab.
SUB23CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 23 is ticked on the Marketing tab.
SUB24CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 24 is ticked on the Marketing tab.
SUB25CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 25 is ticked on the Marketing tab.
SUB26CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 26 is ticked on the Marketing tab.
SUB3CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 3 is ticked on the Marketing tab.
SUB4CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 4 is ticked on the Marketing tab.
SUB5CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 5 is ticked on the Marketing tab.
SUB6CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 6 is ticked on the Marketing tab.
SUB7CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 7 is ticked on the Marketing tab.
SUB8CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 8 is ticked on the Marketing tab.
SUB9CONTACTSCHAR(1)NoThis field is set to 'Y' if Marketing Class number 9 is ticked on the Marketing tab.
SUBCODEOPPORTUNITY_QUOTEINTEGERNoThe GL sub-account on this quote line.
SUBJECTCAMPAIGN_HISTVARCHAR(80)NoThe subject line of the History Note.
SUBJECTOPPORTUNITY_HISTVARCHAR(80)NoThe subject line of the History Note.
SUBJECTTASKSVARCHAR(60)NoThe subject of the activity.
SUBS_HDR_SEQNOTASKSFKINTEGERYesThe ID number of the subscription the activity relates to (links to SUBS_HDR.SEQNO)
SUPPLIERNOOPPORTUNITY_QUOTEINTEGERNoThe ID number of the supplier for the Stock item on this quote line.
SU_SEQNOTASKSFKINTEGERYesThe ID number of the serviceable unit the activity relates to (links to SU_MAIN.SEQNO).
SYNC_ACTIVITYTASKSCHAR(1)YesThis field contains "Y" if the activity will be synced to MS Outlook.
SYNC_CONTACTSCONTACTSCHAR(1)YesThis field is set to 'Y' if the Contact is set to sync with Microsoft Outlook.
TAXNOOPPORTUNITY_QUOTEFKINTEGERNoThe ID number of the tax rate used on this line.
TAXRATEOPPORTUNITY_QUOTEFLOAT(53)YesThe percentage tax rate on the quote line.
TAXRATEOPPORTUNITY_LINESFLOAT(53)No
TAXRATE_NOOPPORTUNITY_LINESINTEGERNo
TAXROUNDINGOPPORTUNITYFLOAT(53)YesThe difference between the tax on the header and the sum of the tax on the individual lines.
TAXTOTALOPPORTUNITYFLOAT(53)YesThe total tax amount on the Opportunity.
TITLECONTACTSVARCHAR(30)NoThe Contact's job title.
TITLECAMPAIGNVARCHAR(60)NoA title/description for the campaign.
TITLECONTACT_LISTVARCHAR(60)NoThe contact list's name.
TOTAL_QUANTITYOPPORTUNITY_QUOTEASNoThe total quantity on the quote line.
TO_STATUSOPPORTUNITY_STAGE_CONSTRAINTCHAR(1)NoThe destination stage for the constraint.
TO_STATUSCAMPAIGN_STAGE_CONSTRAINTCHAR(1)NoThe destination stage for the constraint.
TRACKER_KEYCAMPAIGN_WAVEVARCHAR(150)NoFor campaign waves with the "Mailshot Process" Communication Method, this field contains any text entered into the Tracker ID field.
TRACKEVENTOPPORTUNITY_STAGE_CONSTRAINTCHAR(1)NoIf this field contains 'Y', when an Opportunity is changed from the FROM_STATUS to the TO_STATUS, the stage change is recorded in the Event Log.
TRACKEVENTCAMPAIGN_STAGE_CONSTRAINTCHAR(1)NoIf this field contains 'Y', when a campaign is changed from the FROM_STATUS to the TO_STATUS, the stage change is recorded in the Event Log.
TRANSDATECAMPAIGN_HISTDATETIMENoThe date and time that the History Note was created on.
TRANSDATEOPPORTUNITY_HISTDATETIMENoThe date and time of the History Notes.
TRANSDATEOPPORTUNITY_QUOTEDATETIMENoThe date and time of the transaction.
TWITTERCONTACTSVARCHAR(500)NoThe Contact's Twitter username.
TWITTER_POST_IDCAMPAIGN_WAVEVARCHAR(100)NoFor campaign waves with the "Social Media Post" Communication Method, this field contains the ID number of the Twitter post.
TWITTER_TOKEN_KEYSTAFFVARCHAR(max)NoIf the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token key is stored here.
TWITTER_TOKEN_SECRETSTAFFVARCHAR(max)NoIf the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token secret is stored here.
TYPETASKSFKINTEGERNoThe ID number of the activity's type (links to TASK_TYPES).
UNITPRICEOPPORTUNITY_LINESFLOAT(53)No
UNITPRICE_INCTAXOPPORTUNITY_QUOTEFLOAT(53)NoThe sell price of the Stock item on the quote line, including tax.
USERPROFILEIDSTAFFINTEGERYesThe ID number of the staff member's User profile. Corresponds to the profile's ID field in the PROFILE table.
VALUECRM_BUDGET_LINEDECIMAL(19, 4)YesThe budget value.
WAVE_NOCAMPAIGN_WAVEINTEGERNoAn ID number that uniquely identifies the campaign wave within the campaign.
WEIGHTED_ESTIMATEOPPORTUNITYASNoThe Opportunity's weighted estimate.
WEIGHTED_VALUEOPPORTUNITYASNoThe Opportunity's weighted value.
WORKFLOW_CONSTRAINEDCAMPAIGN_STAGECHAR(1)YesIf this field is set to 'Y', workflow constraints (defined in the CAMPAIGN_STAGE_CONSTRAINT) apply to the campaign stage.
WORKFLOW_CONSTRAINEDOPPORTUNITY_STAGECHAR(1)YesIf this field contains 'Y', workflow constraints (defined in the OPPORTUNITY_STAGE_CONSTRAINT table) apply to the stage.
YAHOO_IDCONTACTSVARCHAR(45)NoThe Contact's Yahoo! ID number.
YEARAGEPERIOD_STATUSINTEGERYesThe ageing of the year that the period falls in. The current year has an age of 0.