API Reference Manual: Difference between revisions
Line 32: | Line 32: | ||
! '''Application entity''' | ! '''Application entity''' | ||
! '''Table name''' | ! '''Table name''' | ||
! '''Code''' | ! '''Programming Code''' | ||
! '''XML Data Kind Name''' | |||
|- | |- | ||
| Accounts | | Accounts | ||
| Cards | | Cards | ||
| 10 | | 10 | ||
| ACCOUNT | |||
|- | |- | ||
| Opportunities | | Opportunities | ||
| Opps | | Opps | ||
| 20 | | 20 | ||
| OPPORTUNITY | |||
|- | |- | ||
| Documents | | Documents | ||
| Docs | | Docs | ||
| 30 | | 30 | ||
| | | DOCUMENT | ||
|- | |- | ||
| Charges | | Charges | ||
| Slips | | Slips | ||
| 40 | | 40 | ||
| CHARGE | |||
|- | |- | ||
| Appointments/Tasks | | Appointments/Tasks | ||
| Events | | Events | ||
| 50 | | 50 | ||
| APPOINTMENT-OR-TASK | |||
|- | |- | ||
| History Notes | | History Notes | ||
| Notebook | | Notebook | ||
| 60 | | 60 | ||
| HISTORY-NOTE | |||
|- | |- | ||
| Tickets | | Tickets | ||
| Tickets | | Tickets | ||
| 70 | | 70 | ||
| TICKET | |||
|- | |- | ||
| Items | | Items | ||
| Items | | Items | ||
| 80 | | 80 | ||
| ITEM | |||
|- | |- | ||
| Assets | | Assets | ||
| Assets | | Assets | ||
| 90 | | 90 | ||
| ASSET | |||
|- | |- | ||
| Knowledge Base | | Knowledge Base | ||
| KBArticles | | KBArticles | ||
| 100 | | 100 | ||
| KBARTICLE | |||
|} | |} | ||
You can find examples of adding and updating records in the database by using the database field in the [[API Code Samples]] section. | You can find examples of adding and updating records in the database by using the database field in the [[API Code Samples]] section. |
Revision as of 10:39, 20 August 2009
Intorduction
Following is a detailed listing of fields per entity which can be added/updated using the API. The API parameters are the same when using the Programming API or the XML API.
The API allows you to add/update the following entities:
- Accounts
- Tickets
- Charges (and Contract-price Charges)
- Items
- History Notes
- Assets
- Calender
- Opportunities
- Documents
- Knowledge Base Articles
All API functions may return error codes. You can find the possible error codes in:
In the following section you will find a detailed listing of the database fields. Each table includes the fields Display name (as shows in the application), the Database Field Name (internal database field identifier) and comments.
Note that when using XML formatted messages, the database field name refers to the name to be provided within the XML token. For example, when the field name is FLDSLPQUANTITY, the XML token should look like this: <FLDSLPQUANTITY>10</FLDSLPQUANTITY>
The following table shows the data kind code when using XML or when using the API functions:
Application entity | Table name | Programming Code | XML Data Kind Name |
---|---|---|---|
Accounts | Cards | 10 | ACCOUNT |
Opportunities | Opps | 20 | OPPORTUNITY |
Documents | Docs | 30 | DOCUMENT |
Charges | Slips | 40 | CHARGE |
Appointments/Tasks | Events | 50 | APPOINTMENT-OR-TASK |
History Notes | Notebook | 60 | HISTORY-NOTE |
Tickets | Tickets | 70 | TICKET |
Items | Items | 80 | ITEM |
Assets | Assets | 90 | ASSET |
Knowledge Base | KBArticles | 100 | KBARTICLE |
You can find examples of adding and updating records in the database by using the database field in the API Code Samples section.
Account Fields
The following table lists the most important parameters for adding/updating Account records. Note slight differences when adding a main account vs. adding a secondary contact.
Field Name | Database Field Name | Comment |
---|---|---|
Account REC ID | FLDTKTCARDID | The Account record ID (20 chars). The Account Rec ID can be taken from:
|
Address: Line1 | FLDCRDADDRESS1 | |
Address: Line2 | FLDCRDADDRESS2 | |
Address: Line3 | FLDCRDADDRESS3 | |
Account Manager | FLDCRDASSIGNCARDID | This field has two roles:
This field should contain the ID of the main Account to which the secondary contacted is added. |
Assistant | FLDCRDASSISTANT | |
Contract | FLDCRDBCRECID | The default Contract for this Account (not required) |
Account Number | FLDCRDCARDID2 | |
ID | FLDCRDCARDID3 | |
Popup Message | FLDCRDCARDMESSAGE | |
Address: City | FLDCRDCITY | |
Address: Zip | FLDCRDZIP | |
Company name | FLDCRDCOMPANY | |
Contact: First & Last Name | FLDCRDCONTACT | |
Address: State | FLDCRDCOUNTRY | |
Creation Date | FLDCRDCREATEDATE | Any date format, such as DD/MM/YYYY |
Created by User | FLDCRDCREATEUSERID | Foreign Software Name which created the account |
Dear | FLDCRDDEAR | |
Department | FLDCRDDEPARTMENT | |
Documents Store Directory | FLDCRDDOCSFOLDER | |
E-Mail Address 1 | FLDCRDEMAIL1 | |
E-Mail Address 2 | FLDCRDEMAIL2 | |
Account Type | FLDCRDENTITYKIND | When adding a Main Account = 1 When adding a secondary contact = 5 |
Fax Number | FLDCRDFAX1 | |
Fax Number Extension | FLDCRDFAXDESC1 | |
File as | FLDCRDFULLNAME | |
Type | FLDCRDKIND | |
Last Name | FLDCRDLASTNAME | |
Notes | FLDCRDNOTES | |
Field | FLDCRDPERSONID | |
Phone 1 Ext. | FLDCRDPHNDESC1 | |
Phone 2 Ext. | FLDCRDPHNDESC2 | |
Phone 3 Ext. | FLDCRDPHNDESC3 | |
Phone 4 Ext. | FLDCRDPHNDESC4 | |
Phone 1 | FLDCRDPHONE1 | |
Phone 2 | FLDCRDPHONE2 | |
Phone 3 | FLDCRDPHONE3 | |
Phone 4 | FLDCRDPHONE4 | |
Region | Region FLDCRDREGIONCODE | |
Popup Message: Display Indication | FLDCRDSHOWMESSAGE | |
Address: Country | FLDCRDSTATE | |
Sub-Contact Code | FLDCRDSUBCODE | |
Salutation | FLDCRDSUFFIX | |
Tax1 | FLDCRDTAXCODE1 | |
Tax2 | FLDCRDTAXCODE2 | |
Notes | FLDCRDNOTES | |
Title | FLDCRDTITLE | |
Last Updated by | FLDCRDUPDATEUSERID | When performing updates on existing Account - pass the Foreign Software Name which performs the update. |
Web Address 1 | FLDCRDURL1 | |
Web Address 2 | FLDCRDURL2 | |
Status | FLDCRDUSER1 | |
Field1 | FLDCRDUSER2 | |
Field2 | FLDCRDUSER3 | |
Field3 | FLDCRDUSER4 | |
Field4 | FLDCRDUSER5 |
Ticket Fields
The table below lists the most important Ticket parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Account REC ID | FLDTKTCARDID | The Account record ID (20 chars). The Account Rec ID can be taken from:
|
Contact REC ID | FLDTKTCONTACTID | The Contact for this Account. If not provided, the main Contact for the Account is taken. |
Contract REC ID | FLDTKTBCRECID | The Contract ID. If not supplied, will be taken from the Account's default contract. |
Emp. REC ID | FLDTKTWORKERID | The worker ID to be linked to the Ticket. Must be an active employee. This is an optional parameter. If not passed, the system default will be used. |
Priority | FLDTKTPRIORITY | The ticket priority. If not passed in the transaction, the default value for new Tickets will be used.
Immediate = 10 |
Ticket Number | FLDTKTTICKETNO | The Ticket number. If passed, must be an existing Ticket, and this will update the Ticket with the details in the transaction. |
Description | FLDTKTPROBLEM | This is the Ticket Description. This is a mandatory field, which must contain text. |
Ticket Type | FLDTKTKIND | Ticket Type (optional). The Ticket Type string should be passed. If not provided, default is used. |
Source | FLDTKTSOURCE | |
Estimated Duration Time | FLDTKTSCHEDLENESTIM | Estimated duration time for the Ticket in minutes. |
Show Ticket in Dispatcher | FLDTKTFORDISPATCH | Possible values: Yes/No |
Status | FLDTKTSTATUS | The Ticket Status (optional). Possible values: |
Created by User | FLDTKTCREATEUSER | Should contain the external software name which created the Ticket |
Due Date | FLDTKTDUEDATETIME | Due date for the Ticket. Should be passed in date format. e.g. MM/DD/YYYY |
Resolution | FLDTKTSOLUTION | Ticket resolution text |
Charge Fields
The table below lists the most important Charge parameters and behavior.
Contract-price Charges have some special characteristics (see comments marked by * in the table below):
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDSLPRECID | The Charge record ID. If provided, the existing Charge will be updated. Otherwise, this will be
added as a new Charge. |
Charge Source | FLDSLPSOURCERECID | The Charge source is the entity for which the charge is created. Possible values:
|
Account REC ID | FLDSLPCARDID | The Account record ID (20 chars). The Account REC ID can be taken from:
|
Employee REC ID | FLDSLPWORKERID | The worker record ID to be linked to the Charge. Must be an active employee. This is an optional parameter. If not passed, the system default will be used. |
Charged Item | FLDSLPITEMID | The Item Record ID to be linked to the Charge. This is a mandatory field.
|
Contract REC ID | FLDSLPBCRECID | The contract record ID (must be a Contract of the Account) |
Ticket REC ID | FLDSLPTICKETID | The Ticket ID to be linked to the Charge.
|
Date | FLDSLPSLIPDATE | The date for the Charge. This is an optional parameter. If not provided, the current date will
be used. Should be passed in date format. e.g. MM/DD/YYYY |
Description | FLDSLPDESC | The Charge Description. If not provided, will be taken from the Item's description. |
Units/Hours | FLDSLPQUANTITY | This is the quantity of hours/units |
Adjust Amount | FLDSLPADJUSTAMOUNT | Discount/Markup amount. Positive number means Markup, negative number means Discount. |
Adjust Percent | FLDSLPADJUSTPERCENT | Discount/Markup in percentage, must be between (-100) - 100. Positive number means Markup, negative number means Discount. |
From Time | FLDSLPSTARTTIME | From time for labor Charges e.g. 12:06
|
To Time | FLDSLPENDTIME | From time for labor Charges e.g. 14:50
|
Price/Rate | FLDSLPPRICE | If not provided, the price is taken from the Item. |
Billable | FLDSLPBILLKIND | B - Billable N - Not Billable |
Billed | FLDSLPSTAGE | D - Draft
B - Billed |
Field1 | FLDSLPUSER1 | User defined field |
Create User | FLDSLPCREATEUSER | External software name which created the Charge |
Item Fields
The table below lists the most important Item parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDSLPRECID | The Item record ID. If provided, the existing item will be updated. Otherwise, this will be added as a new item. |
Item Group | FLDITMITEMTYPEGROUP | The Item Group to be linked to the Charge. This is a mandatory field: F - Labor (Fee) |
Item Code | FLDITMITEMNO | The item code is a mandatory field |
Item Name | FLDITMNAME | The item name is a mandatory field |
Price Source | FLDITMPRICESOURCE | F - Fixed Price W - by Employee Rate |
Price per Hour/Unit | FLDITMUNITISHOUR | This field indicated whether the price is unitbased or hours-based. Y - by Hours |
Price | FLDITMUNITPRICE | Must be a valid numeric value |
Cost | FLDITMSTANDARDCOST | The date for the Charge. This is an optional parameter. If not provided, the current date will
be used. Should be passed in date format. e.g. MM/DD/YYYY |
Taxes | FLDITMTAXCODE1 FLDITMTAXCODE2 |
You can pass up to 3 different tax codes. |
Description by Name | FLDITMDESCBYNAME | Y - take the description from the name field N - take the description from the Description field |
Description | FLDITMDESC | If not provided, the description is taken from the name. |
Suspend | FLDITMSUSPENDED | Indicated whether this item is currently suspended: Y - yes |
Notes | FLDITMNOTES | |
Field1 | FLDSLPUSER1 | User defined field |
Create User | FLDSLPCREATEUSER | External software name which created the Charge |
Created by User | FLDTKTCREATEUSER | Should contain the external software name which created the Ticket |
History Note Fields
The table below lists the most important History Note parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDHISRECID | The History Note record ID. If provided, the existing History Note will be updated. otherwise, this will be added as a new History Note. |
Date | FLDHISNOTEDATETIME | Any date format, such as DD/MM/YYYY |
Description | FLDHISDESCRIPTION | The Description text |
Opportunity/Ticket/Contract | FLDHISLINKRECID | Link to Opportunity or Ticket or Contract |
Field | FLDHISUSER1 | User defined field |
About | FLDHISKIND | Optional field |
Employee | FLDHISWORKERID | The worker ID to be linked to the Ticket. Must be an active employee. This is an optional parameter. If not passed, the system default will be used. |
Account | FLDHISCARDID | The Account record ID (20 chars). The Account Rec ID can be taken from:
|
Contact | FLDHISCONTACTID | The Contact for this Account. If not provided, the main Contact for the Account is taken. |
Document | FLDHISDOCID | Linked Document ID, can be taken from the Document Properties window (right-click RecID and use Copy), or using the ODBC to pull information from the database. |
Created by User | FLDHISCREATEUSER | Name of the external software which created this History Note |
Asset Fields
The table below lists the most important Asset parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Asset Code | FLDASTASSETCODE | If an existing Asset Code is provided, then existing Asset is updated. Otherwise a new Asset is added. |
Asset Type | FLDASTASSETTYPE | The Type field is mandatory: Hardware = H |
Asset Name | FLDASTNAME | |
Status | FLDASTSTATUS | Mandatory field. Active = A |
Record ID | FLDASTRECID | If provided, must exist in the database. Ignored if empty |
Serial No. | FLDASTSERIALNO | |
Account | FLDASTACCRECID | The Account which is linked to the Asset |
Contact | FLDASTCONTACTRECID | The Contact for this Account. If not provided, the main Contact for the Account is taken. |
Created by user | FLDASTCREATEUSER | Name of external software which created this Asset |
Purchase Date | FLDASTCUSTPURDATE | Any date format, such as DD/MM/YYYY |
Purchased From Us | FLDASTCUSTPURFROMUS | Possible values: Y/N. If not provided, default value Y is used. |
Purchase Invoice # | FLDASTCUSTPUROURINV | |
Customer PO | FLDASTCUSTPURPO | |
Purchase Price | FLDASTCUSTPURPRICE | |
Delivered Date | FLDASTDELIVEDATE | |
Description | FLDASTDESC | |
Installed By | FLDASTINSTALBY | |
Installed Date | FLDASTINSTALDATE | |
License Codes | FLDASTLICENSECODE | |
License Keys | FLDASTLICENSEKEY | |
License Notes | FLDASTLICENSENOTES | |
Location | FLDASTLOCATION | |
Manufacturer | FLDASTMANUFACTURER | |
Mnf Serial No. | FLDASTMNFSERIALNO | |
Model | FLDASTMODEL | |
Notes | FLDASTNOTES | |
Quantity | FLDASTQUANTITY | If not provided, default value of 1 is used. |
Last Update By | FLDASTUPDATEUSER | Name of externals software which performed the update |
Field1 | FLDASTUSER1 | User defined field |
Field2 | FLDASTUSER2 | User defined field |
Field3 | FLDASTUSER3 | User defined field |
Field4 | FLDASTUSER4 | User defined field |
Field5 | FLDASTUSER5 | User defined field |
Date1 | FLDASTUSERDATE1 | User defined field |
Number1 | FLDASTUSERNUMBER1 | User defined field |
Vendor Purchased Date | FLDASTVENDORDATEPURC | |
Vendor Invoice # | FLDASTVENDORINVNO | |
Vendor PO | FLDASTVENDOROURPO | |
Vendor Price | FLDASTVENDORPRICE | |
Vendor | FLDASTVENDORRECID | |
Vendor Serial No. | FLDASTVENDORSERNO | |
Vendor Warranty Exp. Date | FLDASTVENDORWARREXP | Any date format, such as DD/MM/YYYY |
Version | FLDASTVERSION | |
Warranty/License Exp. | FLDASTWARREXPDATE | Any date format, such as DD/MM/YYYY |
Date |
Calendar Fields
The table below lists the most important Calendar parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDEVTRECID | The Appointment/Task record ID. If provided, the existing entity will be updated. Otherwise, this
will be added as a new Appointment/Task. |
Event Type | FLDEVTWRITETOID | The Event type is a mandatory field. Appointment = 1 |
Employee | FLDEVTWORKERID | The Task/Appointment owner (for private events) |
Private: User | FLDEVTPRIVATEID | Possible values: Y/N If an Employee was set, this field must be Y |
Account | FLDEVTCARDID | The Account record ID (20 chars). The Account REC ID can be taken from:
the REC ID field and selecting Copy
new Account with the API |
Contact | FLDEVTCONTACTID | The Contact for this Account. If not provided, the main Contact for the Account is taken. |
Document | FLDEVTDOCID | Linked Document ID, can be taken from the Document Properties window (right-click RecID and use Copy), or using the ODBC to pull information from the database. |
Done Indication | FLDEVTDONE | Possible values: Y/N |
Date | FLDEVTEVENTDATE | The Appointment/Task date is a mandatory field of Any date format, such as DD/MM/YYYY. If not
provided, the current date will be used. |
Description | FLDEVTFREETEXT | |
Time: Start | FLDEVTFROMTIME | Mandatory field |
Time: End | FLDEVTTOTIME | Relevant only for Appointments. If this parameter is not provided, 30 min. interval from Start Time is used. |
Opportunity/Ticket | FLDEVTLINKRECID | Linked Ticket/Opportunity/Contract/Asset |
Field1 | FLDEVTFAMILY | User Defined field |
Field2 | FLDEVTACTION | User Defined field |
Field3 | FLDEVTPLACE | User Defined field |
Field4 | FLDEVTPLACE1 | User Defined field |
Field5 | FLDEVTPLACE2 | User Defined field |
Created by User | FLDEVTCREATEUSERID | Name of external software which created the event |
Last Update: By User | FLDEVTUPDATEUSER | Name of external software which updated the
event |
Opportunity Fields
The table below lists the most important Opportunity parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDOPPRECID | The Opportunity record ID. If provided, the existing Opportunity will be updated. Otherwise, this will be added as a new Opportunity. |
Opportunity Name | FLDOPPNAME | Mandatory field. |
Opportunity ID | FLDOPPUSERID | Optional (Oppty ID) |
Account | FLDOPPCARDID | The Account record ID (20 chars). The Account REC ID can be taken from:
|
Contact | FLDEVTCONTACTID | The Contact for this Account. If not provided, the main Contact for the Account is taken. |
Source | FLDOPPSOURCE | |
Document | FLDEVTDOCID | Linked Document ID, can be taken from the Document Properties window (right-click RecID and use Copy), or using the ODBC to pull information from the database. |
Done Indication | FLDEVTDONE | Possible values: Y/N |
Close Date | FLDOPPCLOSEDATE | |
Manager | FLDOPPWORKERID | The Manager's REC ID |
Open Date | FLDOPPOPENDATE | |
Close By Date | FLDOPPESTDATE | Opportunity must be closed by this date |
Amount | FLDOPPAMOUNT | |
Probability % | FLDOPPPROBABILITY | |
Stage | FLDOPPSTAGE | |
Status | FLDOPPSTATUS | |
Closing Amount | FLDOPPCLOSEAMOUNT | |
Description | FLDOPPDESCRIPTION | |
Opportunity Type | FLDOPPKIND | |
Opportunity Reason | FLDOPPREASON | |
Note | FLDOPPNOTES | |
Territory | FLDOPPREGION | |
Field1 | FLDEVTFAMILY | User Defined field |
Field2 | FLDEVTACTION | User Defined field |
Field3 | FLDEVTPLACE | User Defined field |
Created by User | FLDEVTCREATEUSERID | Name of external software which created the event |
Last Update: By User | FLDEVTUPDATEUSER | Name of external software which updated the event |
Document Fields
The table below lists the Document parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDDOCRECID | The Document record ID. If provided, the existing Document will be updated. Otherwise, this will be added as a new Document. |
Document Date | FLDDOCDOCDATE | The date for the Document. This is an optional parameter. If not provided, or if the value is illegal, the current date will be used. Should be passed in date format. e.g. MM/DD/YYYY |
Subject | FLDOPPUSERID | |
Linked Record | FLDDOCLINKRECID | The RECID of a linked object. Each Document can be linked to one of the following objects:
The Record ID (20 chars) can be taken from:
|
Account Rec ID | CARDID | The Account record ID (20 chars). The Account REC ID can be taken from:
|
Contact REC ID | FLDDOCCONTACTID | The Contact for this Account. If not provided, the main Contact for the Account is taken. |
Field1 | FLDDOCTRANSPORT | User Defined field |
Field2 | FLDDOCFOLDER | User Defined field |
Field3 | FLDDOCUMENTPLACE | User Defined field |
File Path + File name | FLDDOCDOCUMENTNAME | The Document path |
Category | FLDDOCTREEID | The category record ID should be taken from the database table called TreeTbl which contains the Category tree |
Employee REC ID | FLDDOCWORKERID | The worker record ID to be linked to the Document. Must be an active employee. This is an optional parameter. If not passed, the system default will be used. |
Created by User | FLDDOCCREATEUSER | Name of external software which created the document |
Last Update: By User | FLDDOCUPDATEUSER | Name of external software which updated the document |
Knowledge Base Article Fields
The table below lists the Knowledge Base Article parameters and behavior:
Field Name | Database Field Name | Comment |
---|---|---|
Record ID | FLDKBARECID | The Article record ID. If provided, the existing Article will be updated. Otherwise, this will be added as a new Article. |
Document Date | FLDKBACREATEDATE | The date for the Document. This is an optional parameter. If not provided, or if the value is illegal, the current date will be used. Should be passed in date format. e.g. MM/DD/YYYY |
Title | FLDKBATITLE | |
Problem | FLDKBAPROBLEM | |
Solution | FLDKBASOLUTION | |
Status | FLDKBASTATUS | Possible values:
|
Category | FLDKBACATEGORY | |
Public | FLDKBAISPUBLIC | Is the Document public. Possible values:
|
Created by User | FLDDOCCREATEUSER | Name of external software which created the document |
Last Update: By User | FLDDOCUPDATEUSER | Name of external software which updated the document |
Error Codes Description
These error codes are returned when calling the CmtGetDescriptionByStatus function:
1000 CmtDbEng.dll not found.
1001 Invalid value for the Data Kind value.
1002 Invalid DATA buffer received. Make sure you have allocated the buffer correctly and
that you have passed the correct buffer length.
1003 Invalid MAP buffer received. Make sure you have allocated the buffer correctly and
that you have passed the correct buffer length.
1004 Invalid REC ID buffer received. Make sure you have allocated the buffer correctly
and that you have passed the correct buffer length.
1005 Invalid LOG buffer received. Make sure you've allocated the buffer correctly and
that you've passed the correct buffer length.
1006 Invalid REC ID buffer received. It should be at least 20 characters.
1007 Invalid external software name received. Specify a unique name that identifies your
software.
1008 Cannot process the transaction. Make sure to call the INIT procedure at least once
prior to sending transactions for processing.
1009 Path specified for Commit DB folder not found.
1010 Path specified for Commit DB folder found, but its contents do not reflect a valid DB
folder.
1011 The RED ID received for the employee/user was not found in Commit, is invalid or is
related to an inactive employee record.
1012 Error registering software.
1013 Software name is missing. Make sure you specify a name that identifies your
software.
1014 Software name is less than 3 characters long. Make sure you enter a software name
that has 3 to 15 characters.
1015 Software name is too long. Make sure your software name has 3 to 15 characters.
1100 Database access error.
General error codes, returned when calling the functions CmtGetDescriptionByCode:
50000 The data is not correct for its type.
50001 The field value has been truncated due to the field length in the database.
50002 The insert operation Failed because the REC ID already existed in the database.
50003 Failed to update Record since it is being updated by another user.
50103 Illegal REC ID.
50104 REC ID Creation failed.
50105 Illegal Sub-Contact REC ID.
50106 Illegal Contract REC ID.
50107 Illegal Employee REC ID.
50108 Illegal Ticket REC ID.
50109 Illegal Account REC ID.
50110 Illegal data for that Contract.
50111 This Employee is not active.
50112 Illegal Document REC ID.
50113 Illegal linked object REC ID.
50114 Employee not found.
50115 Some mandatory fields have no values.
51000 Illegal kind of Account entity.
51001 Account Manager not found.
51002 The REC ID of the Account Manager is illegal.
51003 Illegal tax code.
51004 This code does not exist in Commit.
52000 Illegal kind of event.
52001 Illegal start time.
52002 Illegal end time.
52003 Illegal event date.
52004 The field Reminder1 has Illegal Value.
52005 The amount in the field has an illegal value.
52006 The Field Remider1:Units has Illegal Value.
52007 The Field Remider2:Active has Illegal Value.
52008 The Field Remider2:Amount has Illegal Value.
52009 The Field Remider2:Units has Illegal Value.
52010 Illegal employee REC ID.
52011 Error occurred while updating the Task/Appointment employee field.
54000 Illegal Ticket open date.
54001 Illegal Ticket close date.
54002 Illegal Ticket code area.
54004 Illegal Ticket priority.
54005 Illegal Ticket status.
54006 The Ticket Account was not found in the database.
54007 The Ticket Account Manager was not ound in the database.
54008 This code does not exist in Commit.
54009 This code does not exist in Commit.
54010 This code does not exist in Commit.
54011 This code does not exist in Commit.
54012 This code does not exist in Commit.
55000 Illegal charge date.
55001 Illegal charge REC ID.
55002 Illegal start date.
55003 Illegal start time.
55004 Illegal amount entered for hours.
55005 Illegal quantity.
55006 Illegal price.
55007 Illegal total.
55008 Illegal value in the Adjust Amount field.
55009 Illegal value in the Adjust Percent.
55010 The Discount/Markup field has an illegal value.
55011 Illegal value in the Adjust Kind field.
55012 Illegal bill total.
55013 You can not create a charge for a suspended item.
55014 Item was not found in Commit.
55015 This code does not exist in Commit.
55016 This code does not exists in Commit.
55017 This Code does not exist in Commit.
55018 This Code does not exist in Commit.
55019 This Code does not exist in Commit.
55020 This Code does not exist in Commit.
55021 This Code does not exist in Commit.
56000 Illegal item code.
56001 The field that indicates the item group type has an illegal value.
56002 The field that indicates if the Item is suspended has an illegal value.
56003 Illegal value of The field that indicate if the item is suspended.
56004 Mismatch found between the fields price and price source.
56005 Illegal cost.
56006 Mismatch found between the fields cost and item group type.
56007 The field that indicates if the charge is by unit or by hours has an illegal value.
56008 Illegal value in the Description.
56009 The field that indicates the item type has an illegal value.
57000 This Code does not exist in Commit.
58000 Illegal date time.
58001 The Description field was not found.
58002 The field kind was not found.
58003 The Account member was not found.
59000 This code does not exists in Commit.
59001 This Code does not exist in Commit.
59002 This Code does not exist in Commit.
59003 This Code does not exist in Commit.
59004 This Code does not exist in Commit.
59005 This Code does not exist in Commit.
60000 Invalid web user record ID number.
60001 This customer web user is not active.
60002 This user is not a customer.
See Also