Field Naming Rules

Rules

• Field names must start with an alphabetic character.
• Field names can contain only alphabetic characters (A-Z), numeric characters (0-9), and underscores (_)
• Field names cannot be one of the Reserved Words
• Field names must be unique within the object. (They cannot duplicate the name of any other field defined for that object.)

Reserved Words

These words are used within the platform internally, and cannot be used for names.

See also: Reserved Words by Group

A ABSTRACT ACCESSIBLE ACTIVITIES ADD AFFILIATE_ID ALL ALTER ANALYZE AND APPOINTMENTS AS ASC ASENSITIVE ASSERT AUTO_INCREMENT BDB BEFORE BETWEEN BIGINT BINARY BLOB BOOLEAN BOTH BREAK BTREE BY BYTE CALL CAMPAIGNS CASCADE CASE CASES CATCH CEIL CHANGE CHAR CHARACTER CHECK CLASS COFF COLLATE COLUMN COLUMNS COMMENTS CONCAT CONDITION CONNECTION CONST CONSTRAINT contact_email contact_fax contact_first_name contact_last_name contact_mobile_phone contact_phone contact_title CONTACTS CONTAINS CONTINUE CONTRACTS CONVERT CREATE CREATED_ID CREATOR CRITERIA CROSS CUBE             CUME_DIST         CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CUSTOMER_ID DATABASE DATABASES DATE DATE_CREATED DATE_MODIFIED DATEADD DATECOMP DATESUB DATEVALUE DAY DAY_HOUR DAY_MICROSECOND DAY_MINUTE DAY_SECOND DEC DECIMAL DECLARE DEFAULT DELAYED DELETE DENSE_RANK         DESC DESCRIBE DETERMINISTIC DISTINCT DISTINCTROW DIV DO DOCUMENTS DONE DOUBLE DROP DUAL EACH ELSE ELSEIF EMAIL_ACTIVITIES EMPTY             ENCLOSED ENDSWITH ENUM ERRORS ESCAPED EXCEPT             EXISTS EXIT EXP EXPLAIN EXTENDS FALSE FETCH FIELDS FINAL FINALLY FIND FIRST_NAME FIRST_VALUE         FLOAT FLOAT4 FLOAT8 FLOOR FOR FORCE FOREIGN FROM FULLTEXT FUNCTION GENERAL GENERATED         GEOMETRY GET                 GOTO

GROUP GRANT GROUPING         GROUPS             HASH HAVING HELP HIGH_PRIORITY HISTORY HOUR HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND ID IF IGNORE IGNORE_SERVER_IDS IMPLEMENTS IMPORT IN INDEX INFILE INNER INNODB INOUT INSENSITIVE INSERT INSTANCEOF INT INT1 INT2 INT3 INT4 INT8 INTEGER INTERFACE INTERSECT         INTERVAL INTO IO_AFTER_GTIDS     IO_BEFORE_GTIDS     IS ISCHANGED ISNEW ISNULL ITERATE JOIN JSON_TABLE         KEY KEYS KILL LABEL LAG                 LAST_MODIFIED_TIMESTAMP LAST_NAME LAST_VALUE         LATERAL             LEAD             LEADING LEAVE LEFT LEN LIFECYCLE LIKE LIMIT LINEAR LINES LN LOAD LOCALTIME LOCALTIMESTAMP LOCK LOG LONG LONGBLOB LONGTEXT LOOP LOW_PRIORITY LOWER MASTER_BIND         MASTER_HEAERBEAT_PERIOD MASTER_SERVER_ID MASTER_SSL_VERIFY_SERVER_CERT MATCH MAX MAXVALUE MAXVALUE         MEDIUMBLOB MEDIUMINT MEDIUMTEXT MIDDLEINT MIN MINUTE MINUTE_MICROSECOND MINUTE_SECOND MOD MODIFIED_ID MODIFIER MODIFIES MONTH MRG_MYISAM NAME NATIVE NATURAL NEW NO_WRITE_TO_BINLOG NOT NOW NTH_VALUE         NTILE             NULL NUMERIC OBJECT_ID OF                 ON OPPORTUNITIES OPTIMIZE OPTIMIZER_COSTS     OPTION OPTIONALLY OR ORDER OUT OUTER OUTFILE OVER             OWNER OWNER_ID OWNER_TEAM_ID P_KEYWORD PACKAGE PARTITION         PERCENT_RANK     PLANS POW PRECISION PRICELIST PRIMARY PRIOR_NAME PRIORVALUE PRIVATE PRIVILEGES PROCEDURE PRODUCTS PROTECTED PUBLIC PURGE PURPOSE_ACCOUNT

GROUP PURPOSE_CASE PURPOSE_CONTACT PURPOSE_CONTRACT PURPOSE_LEAD PURPOSE_OPPORTUNITY_V2 PURPOSE_PRICE_BOOK PURPOSE_PRODUCT PURPOSE_PROJECT RANGE RANK             READ READ_ONLY READ_WRITE READS REAL RECORD RECURSIVE         REFERENCES RELEASE RENAME REPEAT REPLACE REQUIRE RESIGNAL RESIGNAL         RESTRICT RETURN RETURNS REVOKE RIGHT RLIKE ROUND ROW                 ROW_NUMBER         ROWS             RTREE S SCHEMA SCHEMAS SEARCH_STRING SECOND SECOND_MICROSECOND SELECT SENSITIVE SEPARATOR SET SHORT SHOW SHOW_LAYOUT SIGN_HASH_ACCOUNT SIGN_HASH_CASE SIGN_HASH_CONTACT SIGN_HASH_CONTRACT SIGN_HASH_LEAD SIGN_HASH_OPPORTUNITY_V2 SIGN_HASH_PRICE_BOOK SIGN_HASH_PRODUCT SIGN_HASH_PROJECT SIGNAL SIGNAL             SIGNED_BY_ACCOUNT SIGNED_BY_CASE SIGNED_BY_CONTACT SIGNED_BY_CONTRACT SIGNED_BY_DATE_ACCOUNT SIGNED_BY_DATE_CASE SIGNED_BY_DATE_CONTACT SIGNED_BY_DATE_CONTRACT SIGNED_BY_DATE_LEAD SIGNED_BY_DATE_OPPORTUNITY_V2 SIGNED_BY_DATE_PRICE_BOOK SIGNED_BY_DATE_PRODUCT SIGNED_BY_DATE_PROJECT SIGNED_BY_LEAD SIGNED_BY_OPPORTUNITY_V2 SIGNED_BY_PRICE_BOOK SIGNED_BY_PRODUCT SIGNED_BY_PROJECT SLOW SMALLINT SOME SONAME SOURCEPAGE SPATIAL SPECIFIC SPENDING SQL SQL_BIG_RESULT SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT SQLEXCEPTION SQLSTATE SQLWARNING SQRT SSL STARTING STARTSWITH STATIC STORED             STRAIGHT_JOIN STRICTFP STRIPED SUBSTRING SUPER SWITCH SYNCHRONIZED SYSTEM             T TABLE TABLES TAGLIST TARGETPAGE TERMINATED TEXT THEN THIS THROW THROWS TIME TIMEVALUE TINYBLOB TINYINT TINYTEXT TO TODAY TOP_TAB TRAILING TRANSIENT TRIGGER TRIM TRUE TRY TYPES UNDO UNION UNIQUE UNLOCK UNSIGNED UPDATE UPGRADE UPPER USAGE USE USER USER_RESOURCES USERID USERPRIMARYTEAMID

GROUP USING UTC_DATE UTC_TIME UTC_TIMESTAMP VALUE VALUES VARBINARY VARCHAR VARCHARACTER VARYING VIRTUAL             VOID VOLATILE WARNINGS WEEKDAY WHEN WHERE WHILE WINDOW  WITH WORKFLOW_HISTORY WRITE XOR YEAR YEAR_MONTH ZEROFILL