{"info":{"_postman_id":"622279bb-3fdf-4eab-8a87-3b4170b7d08c","name":"Sage 100 Contractor Cloud Connector","description":"

The Sage 100 Contractor Cloud Connector REST API (Cloud Connector) is a robust Restful Application Programming Interface (API) that provides a standardized framework for building custom applications and integrations with Sage 100 Contractor. It enables seamless communication between Sage 100 Contractor and other software platforms or tools.

By leveraging this API, you can:

Extend the core functionality of Sage 100 Contractor,
\n
Integrate with third-party systems and services,
\n
Utilize pre-built integrations developed by other Sage partners, or
\n
Develop your own tailored solutions to meet specific business needs.
\n

Whether you're connecting to ERP systems, automating data flows, or building entirely new apps, the Cloud Connector API gives you the flexibility and control to do so efficiently and securely.

Overview

The following documentation provides the necessary information to seamlessly connect external applications to Sage 100 Contractor. The Cloud Connector is a RESTFUL API and provides a standardized framework for creating and updating information into Sage 100 Contractor.

Enabling Communication Between Cloud Connector and Sage 100 Contractor SQL Database

Since Sage 100 Contractor is an on-premise accounting system, the Cloud Connector must be able to communicate directly with the SQL Server database to read and write data. However, for security reasons, most server environments block inbound traffic by default, especially traffic originating from external networks. To allow secure and reliable communication between the Cloud Connector and your SQL database, firewall and TCP port access must be explicitly granted as follows:

Cloud Connector IP Address:
Please setup an inbound rule within the Sage SQL Server's Firewall to allow traffic from The Cloud Connector to communicate with the server as follows:

Inbound Rule:
-------------------------------------
Source IP: 52.170.130.9
Destination Port: {SQL Port Number - see below}
Protocol: TCP

SQL Server Port Number:
Ensure that the SQL Port number is \"Static\" and the specified port is open to the Cloud Connector IP Address

\n
Dynamic vs Static Ports
By default, SQL Server listens on TCP port 1433, but this can vary—especially for named instances, which commonly use dynamic ports. In the case of Sage 100 Contractor, the software is typically installed against a named SQL Server instance, often named \"SAGE100CON\". As a result, in most environments, dynamic port assignment is enabled by default for this instance.
\n

If dynamic ports are enabled it is highly recommended that a static port be assigned to avoid having the port number change which can happen each time the SQL Server instance is restarted or the Server is rebooted.

The following steps can be used to identify if Dynamic Ports are enabled and how to update the port to be a static Port number which would then be the port that is opened within the firewall settings:

Identify the SQL Server Port:

1. On the server where Sage is installed, Open SQL Server Configuration Manager.

2. Go to SQL Server Network Configuration → Protocols for [_Sage_InstanceName_]. (Typically the [_SageInstanceName_] is \"SAGE100CON\")

3. Double-click TCP/IP, then go to the IP Addresses tab. Scroll down until you see the IPAll section:

Under IPAll, check the values for:

TCP Dynamic Ports (if set, it's using a dynamic port).

TCP Port (if set and dynamic is blank, this is the static port in use).

If the TCP Dynamic Ports is populated with a port number then Dynamic Ports is enabled and should be changed to a static port. To do this clear the value in the \"TCP Dynamic Ports\" field and enter a Port Number in the \"TCP Port\" field. You will need to choose a specific port number (e.g. 14330, 15000 or any available TCP port above 1024). It is not advised to use the Dynamic Port number that was entered in the Dynamic Port field.

\n\n

Company Connections

Company Connections are used to establish and manage communication with a Sage database. Each connection record contains essential information such as the server IP address, database name, and SQL login credentials—all of which are required to enable proper integration with the Sage system. The number of company connections is determined by your license and the number of connections that have been purchased.

To update or manage this information, follow the instructions below:

Login to the Cloud Connector
\n
Navigate to [Setup >> Companies]
\n
You should see a list of company connection(s) that are available as part of your license. (If you do not see any company connections listed or fewer than expected, contact support.)
\n
Click the link to edit the company you wish to update.
\n

Connection Information:

\n
Company Code: Short company code or acronym to identify the company connection
\n

\n
Description: Short name or description of the connection
\n

\n
SQL Server IP/Domain: The SQL Server Name generally will consist of a \"Public\" facing IP address or a Fully Qualified Domain Name of the Server where the Sage SQL Server Database is located. (If you are unsure of the correct IP address to enter, a simple method is to login to the server where the Sage SQL Server is installed, open a web browser, and search for \"What is my IP.\" Several sites will display the public IP address of that server.)
\n

\n
Port Number: Enter the \"static\" port number identified in the steps for enabling communication between the Sage Server and the Cloud Connector outlined above
\n

\n
SQL Database: The name of the Sage Database that this connection will communicate with
\n

\n
SQL User: The SQL Server username that the connection will use to login to the SQL Server. Note: Windows Authentication is not supported, this must be a SQL Server login. The user should also be designated as a \"SysAdmin\" in SQL Server.
\n

Note: SysAdmin Logins for Sage can be created using the \"Database Administration Utility\" that is installed on the same server where the Sage software is installed._

\n
SQL Password: The password for the SQL Username being used
\n

\n
Default: Denotes whether the connection is the default connection when more than one company connection exists. If there is only one company connection then it will always be the default.
\n

SQL Database Compatabillity

It is required that the compatability level for the Sage database be set to SQL Server 2017 or later.

To Determine which version of SQL you are running:

Launch Microsoft SQL Server Management Studio
Right Click on your Sage Company Database and select [Properties]
Navigate to the [Options] tab
Select the \"Compatibility Level\" Drop Down
Whatever the last option shown is the version of SQL Installed. In most cases the last option will be SQL Server 2014 (120) which means that SQL 2014 is installed and you need to upgrade your instance of SQL Server

\n\n

Authentication

Step 1: Generate an Authentication Token

All API requests to the Cloud Connector require an authentication token to authorize access. This token must be included in the headers of each API request.

Authentication tokens are created using the following process:

Login to the Cloud Connector
\n
Navigate to [System >> API Auth Token]
\n
Click the button to \"Add Token\"
\n
Generate the Token
\n

When generating an authentication token, you can control the level of access it provides—such as which companies and endpoints it can access and which tables it can retrieve data from.

There is no limit to the number of tokens that can be generated. This allows you to create separate tokens for different purposes or applications, ensuring that each token has access only to the specific data required for its intended use case. This helps maintain security and data integrity across multiple integrations.

Step 2: Using the Token in API Requests

Once a token has been generated it can then be used when making API requests. In order to make a request the following header information is required:

Required Header Elements:

Auth-Token: {Generated API Token}

Content-Type: application/json

customer: {CustomerID}

company: {Company Connection Code}

Security Note:

Treat authentication tokens like passwords—keep them secure and do not expose them in client-side code or expose them publicly
\n
It is recommended to set an expiration date on tokens to ensure that they are not indefinitely active, otherwise API tokens do not expire.
\n

Error/Response Codes

A json response is retruned with every request. Every response will have a \"response\" property which will either be \"ERROR\" or \"SUCCESS\".

{\"response\":\"SUCCESS\"}

If there is additional information to be provided on an error there will be a \"response\" property with more details.

{\"response\":\"ERROR\",\"message\":\"Invalid Request\"}

Rate limits

There are no rate limits. Since Sage 100 Contractor is an on premise accounting solution, there is a unique and separate version of our API installed along side each instance of Sage 100 Contractor. As such, the amount of traffic between our API and any interfacing applications is not monitored or restricted.

Synchronous vs Asynchronous

For highly available applications with multiple concurrent users, asynchronous processing is a common design principle for modern web applications. However, due to how Sage 100 Contractor generates key record identifiers, we do not recommend or support making asynchronous endpoint calls to any Accounting Transaction-related endpoints, such as: Accounts Receivable, Accounts Payable, Journal Transactions, Payroll Records etc.

We strongly recommend batching these records and processing them at one time, or structuring your application to ensure these endpoints are called synchronously to maintain data integrity.

For master table endpoints, such as Vendors, Employees, or Clients, asynchronous calls can be made. However, if you are processing a large number of updates simultaneously, it is highly advisable to send all updates in a single call using an \"Array\" to optimize performance and reduce server load.

Please Note: the ability to process large numbers of asynchornous requests may result in errors depending on the stability of the Sage server environment where the API is installed. There are many factors that can impact the stability of the API, including memory, available processors, firewalls, VPN, virus software installed, etc. Proper planning and testing are essential to ensure reliable API performance in your specific environment.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Overview","slug":"overview"},{"content":"Enabling Communication Between Cloud Connector and Sage 100 Contractor SQL Database","slug":"enabling-communication-between-cloud-connector-and-sage-100-contractor-sql-database"},{"content":"Company Connections","slug":"company-connections"},{"content":"SQL Database Compatabillity","slug":"sql-database-compatabillity"},{"content":"Authentication","slug":"authentication"},{"content":"Error/Response Codes","slug":"errorresponse-codes"},{"content":"Rate limits","slug":"rate-limits"},{"content":"Synchronous vs Asynchronous","slug":"synchronous-vs-asynchronous"}],"owner":"18727065","collectionId":"622279bb-3fdf-4eab-8a87-3b4170b7d08c","publishedId":"2sB2xBBpHh","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2025-06-19T15:53:20.000Z"},"item":[{"name":"1 - General Ledger","item":[{"name":"GL_ACCOUNT","id":"dbea17a9-b228-43b5-a304-aaa9ebb3d4b0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"[\r\n {\r\n \"recnum\": \"1001\",\r\n \"lngnme\": \"Cash Checking\",\r\n \"shtnme\": \"Cash Check\",\r\n \"acttyp\": 1,\r\n \"sumact\": null,\r\n \"subact\": 0,\r\n \"csttyp\": 0,\r\n \"jobsub\": 0,\r\n \"iscrcd\": 0,\r\n \"ntetxt\": \"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/GL_ACCOUNT","description":"

[GL 1-7 General Ledger Accounts] Create General Ledger Accounts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric			GL Account No
lngnme	Required	String (50)			GL Account Name
shtnme	Required	String (30)			GL Short Name
acttyp	Required **	Numeric		1-Cash Accounts; 2-Current Assets; 3-WIP Assets; 4-Other Assets; 5-Fixed Assets; 6-Depreciation; 7-Current Liab; 8-Long Term Liability; 9-Equity; 10-Owner's Drawing; 11-Operating Income; 12-Other Income; 13-Direct Expense; 14-Equip/Shop Exp; 15-Overhead Exp; 16-Admin Exp; 17-After Tax Inc Exp	Account Type
sumact	**	Numeric			Summary Account
subact	**	Numeric		0=None; 1=Subaccounts; 2=Departments	Subsidiary type (1)
csttyp	**	Numeric		0=None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-UserDef6; 7-UserDef7; 8-UserDef8; 9-UserDef9	Cost Type (2)
jobsub		Numeric		0=No; 1=Yes	Use Job No as subaccount
iscrcd		Numeric		0=No; 1=Yes	Is Credit Card
ntetxt		Text			Notes

\n\n

Required(I) - required for inserts only
** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor
(1) Only available [2-Current Assets, 3-WIP Assets, 4-Other Assets, 6-Depreciation, 8-Long Term Liability, 9-Equity, 11-Operating Income, 12-Other Income, 13-Direct Expense, 14-Equip/Shop Exp, 16-Admin Exp, 17-After Tax Inc Exp]
(2) Only available [3-WIP Assets, 13-Direct Expense, 14-Equip/Shop Exp]

\n","urlObject":{"protocol":"https","path":["API","GL_ACCOUNT"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"dbea17a9-b228-43b5-a304-aaa9ebb3d4b0"},{"name":"GL_JE_ENTRY","id":"055d028a-0004-40be-b16e-e412385c58c9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"trnnum\": \"JE1701\",\r\n \"trndte\": \"2017-01-05\",\r\n \"dscrpt\": \"Test Journal Entry\",\r\n \"status\": \"1\",\r\n \"pchord\": \"\",\r\n \"bnkcat\": \"0\",\r\n \"vndnum\": \"\",\r\n \"payee1\": \"\",\r\n \"payee2\": \"\",\r\n \"addrs1\": \"\",\r\n \"addrs2\": \"\",\r\n \"ctynme\": \"\",\r\n \"state_\": \"\",\r\n \"zipcde\": \"\",\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"ntetxt\": \"\",\r\n \"postprd\": \"\",\r\n \"gldetail\": [\r\n {\r\n \"lgract\": 1000,\r\n \"subact\": null,\r\n \"dscrpt\": \"Jan Rent Payment\",\r\n \"dbtamt\": null,\r\n \"crdamt\": \"1200\",\r\n \"usrdf1\": \"\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": null,\r\n \"phsnum\": null,\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": null,\r\n \"jccsttyp\": \"\",\r\n \"jcnotes\": \"\",\r\n \"eqpnum\": null,\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": null,\r\n \"eqcsttyp\": null,\r\n \"eqnotes\": \"\"\r\n },\r\n {\r\n \"lgract\": 6000,\r\n \"subact\": null,\r\n \"dscrpt\": \"Jan Rent Payment\",\r\n \"dbtamt\": 1200,\r\n \"crdamt\": null,\r\n \"usrdf1\": \"\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": null,\r\n \"phsnum\": null,\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": null,\r\n \"jccsttyp\": null,\r\n \"jcnotes\": \"\",\r\n \"eqpnum\": null,\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": null,\r\n \"eqcsttyp\": \"\",\r\n \"eqnotes\": \"\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/GL_JE_ENTRY","description":"

[GL 1-3 Journal Transactions] Creates a Journal Transaction

Note: [4-7-3 Enter Credit Card Receipts] Credit Card Receipts are Journal Transactions where the credit account is restricted to only Credit Card accounts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
trnnum	Required	String (20)		JE1901	Journal Number
trndte	Required	date		2018-01-05	Journal Accounting Date
dscrpt	Required	String (50)		Test Journal Entry	Journal Description
status	Required	Numeric		1=Open; 2=Cleared	Journal Status
pchord	**	String (20)			Purch Order No
bnkcat	**	Numeric		0=Adjust;1=Check;2=Dep	Bank Category
vndnum	**	Numeric			Vendor Recnum
payee1		String (50)			payee1
payee2		String (50)			payee2
addrs1		String (50)			addrs1
addrs2		String (50)			addrs2
ctynme		String (50)			ctynme
state_		String (2)			state_
zipcde		String (10)			zipcde
usrdf1		String (50)			usrdf1
usrdf2		String (50)			usrdf2
ntetxt		Text			Notes
postprd	(1)	Date
gldetail[]
lgract	Required **	Numeric			Ledger Acct Recnum
subact	**	Numeric			Sub Account Recnum
dscrpt		String (50)			Line Description
dbtamt		Numeric (9,2)			Debit Amount
crdamt		Numeric (9,2)			Credit Amount
usrdf1		String (50)			User Defined 1
wrkord		String (20)		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Work Order No
jobnum	**	Numeric		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Job No
phsnum	**	Numeric		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Phase No
jcdscrpt		String (50)		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Description
jccstcde	**	Numeric (15,3)		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Cost Code
jccsttyp	**	Numeric		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Cost Type
jcnotes		Text		WIP / Direct Exp \\\\\\\\\\\\\\\\*	Notes
eqpnum	**	Numeric		Equip Exp **	Equip No
eqdscrpt		String (50)		Equip Exp **	Description
eqcstcde	**	Numeric (15,3)		Equip Exp **	Cost Code
eqcsttyp	**	Numeric		Equip Exp **	Cost Type
eqnotes		Text		Equip Exp **	Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) If posting period is left blank then the Journal Accounting Date will be used as the posting period

WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type

Equip Exp** - Required if the lgract is assigned to [14 - Equip/Shop Expense] account type

\n","urlObject":{"protocol":"https","path":["API","GL_JE_ENTRY"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"055d028a-0004-40be-b16e-e412385c58c9"},{"name":"GL_CHECKS_BANK_CHARGES","id":"5a5b6a4a-9d31-421e-ac41-a6ec25a36469","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"trnnum\": \"13502\",\r\n \"trndte\": \"2021-12-12\",\r\n \"lgract\": \"1000\",\r\n \"dscrpt\": \"header description\",\r\n \"status\": \"2\",\r\n \"pchord\": \"PO 4\",\r\n \"vndnum\": \"231\",\r\n \"payee1\": \"Sample Company\",\r\n \"payee2\": \"\",\r\n \"addrs1\": \"1234 West State Road\",\r\n \"addrs2\": \"Suite #13\",\r\n \"ctynme\": \"Davie\",\r\n \"state_\": \"FL\",\r\n \"zipcde\": \"33324\",\r\n \"usrdf1\": \"user def 1\",\r\n \"usrdf2\": \"user def 2\",\r\n \"ntetxt\": \"notes\",\r\n \"gldetail\": [\r\n {\r\n \"lgract\": \"2250\",\r\n \"subact\": \"1156\",\r\n \"dscrpt\": \"detail description\",\r\n \"dbtamt\": \"123\",\r\n \"usrdf1\": \"detail user def 1\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"\",\r\n \"phsnum\": \"\",\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": \"\",\r\n \"jccsttyp\": \"\",\r\n \"jcnotes\": \"\",\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": \"\",\r\n \"eqnotes\": \"\"\r\n },\r\n {\r\n \"lgract\": \"1350\",\r\n \"subact\": \"\",\r\n \"dscrpt\": \"detail description jc\",\r\n \"dbtamt\": \"456\",\r\n \"usrdf1\": \"detail user def 2\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"2017503\",\r\n \"phsnum\": \"\",\r\n \"jcdscrpt\": \"jc description\",\r\n \"jccstcde\": \"5000\",\r\n \"jccsttyp\": \"1\",\r\n \"jcnotes\": \"jc notes\",\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": \"\",\r\n \"eqnotes\": \"\"\r\n },\r\n {\r\n \"lgract\": \"5602\",\r\n \"subact\": \"\",\r\n \"dscrpt\": \"detail description eq\",\r\n \"dbtamt\": \"789\",\r\n \"usrdf1\": \"detail user def 3\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"\",\r\n \"phsnum\": \"\",\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": \"\",\r\n \"jccsttyp\": \"\",\r\n \"jcnotes\": \"\",\r\n \"eqpnum\": \"1\",\r\n \"eqdscrpt\": \"eq description\",\r\n \"eqcstcde\": \"11000\",\r\n \"eqcsttyp\": \"3\",\r\n \"eqnotes\": \"eq notes\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/GL_CHECKS_BANK_CHARGES","description":"

[GL 1-1 Checks and Bank Charges] Creates a Check or Bank Charge

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
trnnum	Required	String (20)	Header	123456	Check Number
trndte	Required	date	Header	2023-01-05	Check Date
lgract	Required **	Numeric	Header	1000	Ledger Account Recnum
dscrpt	Required	String (50)	Header	Test Description	Description
status	Required	Numeric	Header	1=Open; 2=Cleared; 3=Void	Status
pchord	**	String (20)	Header		Purchase Order Number
vndnum	**	Numeric	Header		Vendor Recnum
payee1		String (50)	Header		Payee
payee2		String (50)	Header		Payee2
addrs1		String (50)	Header		Address 1
addrs2		String (50)	Header		Address 2
ctynme		String (50)	Header		City
state_		String (2)	Header		State
zipcde		String (10)	Header		Zip
usrdf1		String (50)	Header		User Defined 1
usrdf2		String (50)	Header		User Defined 2
ntetxt		Text	Header		Notes
gldetail[]
lgract	Required **	Numeric	Detail		Ledger Account Recnum
subact	**	Numeric	Detail		Sub Account Recnum
dscrpt		String (50)	Detail		Line Description
dbtamt		Numeric (12,2)	Detail		Debit Amount
usrdf1		String (50)	Detail		User Defined 1
wrkord		String (20)	WIP / Direct Exp \\\\\\\\*		Work Order Number
jobnum	**	Numeric	WIP / Direct Exp \\\\\\\\*		Job Number
phsnum	**	Numeric	WIP / Direct Exp \\\\\\\\*		Phase Number
jcdscrpt		String (50)	WIP / Direct Exp \\\\\\\\*		Description
jccstcde	**	Numeric (15,3)	WIP / Direct Exp \\\\\\\\*		Cost Code
jccsttyp	**	Numeric	WIP / Direct Exp \\\\\\\\*	1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9	Cost Type
jcnotes		Text	WIP / Direct Exp \\\\\\\\*		Notes
eqpnum	**	Numeric	Equip Exp **		Equipment Number
eqdscrpt		String (50)	Equip Exp **		Description
eqcstcde	**	Numeric (15,3)	Equip Exp **		Cost Code
eqcsttyp	**	Numeric	Equip Exp **	1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9	Cost Type
eqnotes		Text	Equip Exp **		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type

Equip Exp** - Required if the lgract is assigned to [14 - Equip/Shop Expense] account type

\n","urlObject":{"protocol":"https","path":["API","GL_CHECKS_BANK_CHARGES"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"5a5b6a4a-9d31-421e-ac41-a6ec25a36469"},{"name":"GL_DEPOSITS_INTEREST","id":"bc39e156-b908-4999-9965-8da636f93e47","protocolProfileBehavior":{"disableBodyPruning":true,"disabledSystemHeaders":{}},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"trnnum\": \"13502\",\r\n \"trndte\": \"2021-12-12\",\r\n \"lgract\": \"1000\",\r\n \"dscrpt\": \"header description\",\r\n \"status\": \"2\",\r\n \"usrdf1\": \"user def 1\",\r\n \"usrdf2\": \"user def 2\",\r\n \"ntetxt\": \"notes\",\r\n \"gldetail\": [\r\n {\r\n \"lgract\": \"2250\",\r\n \"subact\": \"1156\",\r\n \"dscrpt\": \"detail description\",\r\n \"crdamt\": \"123\",\r\n \"usrdf1\": \"detail user def 1\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"\",\r\n \"phsnum\": \"\",\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": \"\",\r\n \"jccsttyp\": \"\",\r\n \"jcnotes\": \"\",\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": \"\",\r\n \"eqnotes\": \"\"\r\n },\r\n {\r\n \"lgract\": \"1350\",\r\n \"subact\": \"\",\r\n \"dscrpt\": \"detail description\",\r\n \"crdamt\": \"456\",\r\n \"usrdf1\": \"detail user def 2\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"2017503\",\r\n \"phsnum\": \"\",\r\n \"jcdscrpt\": \"jc description\",\r\n \"jccstcde\": \"5000\",\r\n \"jccsttyp\": \"1\",\r\n \"jcnotes\": \"jc notes\",\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": \"\",\r\n \"eqnotes\": \"\"\r\n },\r\n {\r\n \"lgract\": \"5602\",\r\n \"subact\": \"\",\r\n \"dscrpt\": \"detail description\",\r\n \"crdamt\": \"789\",\r\n \"usrdf1\": \"detail user def 3\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"\",\r\n \"phsnum\": \"\",\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": \"\",\r\n \"jccsttyp\": \"\",\r\n \"jcnotes\": \"\",\r\n \"eqpnum\": \"1\",\r\n \"eqdscrpt\": \"eq description\",\r\n \"eqcstcde\": \"11000\",\r\n \"eqcsttyp\": \"3\",\r\n \"eqnotes\": \"eq notes\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/GL_DEPOSITS_INTEREST","description":"

[GL 1-2 Deposits and Interest] Creates a Deposit

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
trnnum	Required	String (20)	Header	123456	Deposit Number
trndte	Required	date	Header	2023-01-05	Transaction Date
lgract	Required **	Numeric	Header	1000	Ledger Account Recnum
dscrpt	Required	String (50)	Header	Test Description	Description
status	Required	Numeric	Header	1=Open; 2=Cleared	Status
usrdf1		String (50)	Header		User Defined 1
usrdf2		String (50)	Header		User Defined 2
ntetxt		Text	Header		Notes
gldetail[]
lgract	Required **	Numeric	Detail		Ledger Account Recnum
subact	**	Numeric	Detail		Sub Account Recnum
dscrpt		String (50)	Detail		Line Description
crdamt		Numeric (12,2)	Detail		Credit Amount
usrdf1		String (50)	Detail		User Defined 1
wrkord		String (20)	WIP / Direct Exp \\\\\\*		Work Order Number
jobnum	**	Numeric	WIP / Direct Exp \\\\\\*		Job Number
phsnum	**	Numeric	WIP / Direct Exp \\\\\\*		Phase Number
jcdscrpt		String (50)	WIP / Direct Exp \\\\\\*		Description
jccstcde	**	Numeric (15,3)	WIP / Direct Exp \\\\\\*		Cost Code
jccsttyp	**	Numeric	WIP / Direct Exp \\\\\\*	1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9	Cost Type
jcnotes		Text	WIP / Direct Exp \\\\\\*		Notes
eqpnum	**	Numeric	Equip Exp **		Equip Number
eqdscrpt		String (50)	Equip Exp **		Description
eqcstcde	**	Numeric (15,3)	Equip Exp **		Cost Code
eqcsttyp	**	Numeric	Equip Exp **	1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9	Cost Type
eqnotes		Text	Equip Exp **		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type

Equip Exp** - Required if the lgract is assigned to [14 - Equip/Shop Expense] account type

\n","urlObject":{"protocol":"https","path":["API","GL_DEPOSITS_INTEREST"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"bc39e156-b908-4999-9965-8da636f93e47"}],"id":"6b83cabe-8cfe-4809-aed5-d72635d19f69","auth":{"type":"noauth","isInherited":false},"event":[{"listen":"prerequest","script":{"id":"9663fa99-1f08-488f-bd44-07974e6471a8","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"d9a85c25-d831-4fc1-88dc-89fe39de3c2f","type":"text/javascript","exec":[""]}}],"_postman_id":"6b83cabe-8cfe-4809-aed5-d72635d19f69","description":""},{"name":"3 - Accounts Receivable","item":[{"name":"AR_CASH_RECEIPT","id":"197db8e2-3a04-4d3a-ab97-4cc59f69ec45","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"chkact\":\"1000\",\r\n \"chkdepno\":\"Dep120\",\r\n \"actgdte\":\"2021-01-01\",\r\n \"chkdte\":\"2021-01-01\",\r\n \"chkdscrpt\":\"check description\",\r\n \"invtype\":\"C\",\r\n \"jobclnnum\":4567,\r\n \"invnum\":\"123TestInv\",\r\n \"chknum\":\"\",\r\n \"pdamt\":\"50.00\",\r\n \"ovrpmt\":\"\",\r\n \"dsctkn\":\"\",\r\n \"er_pymt\":\"1\",\r\n \"er_refno\":\"abc123\",\r\n \"er_payor\":\"example payor\",\r\n \"er_paytyp\":\"3\",\r\n \"er_last4\":\"1234\"\r\n }\r\n \r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_CASH_RECEIPT","description":"

[AR 3-3-1 Cash Receipts / AR 3-3-2 Electronic Receipts] Create AR Cash Receipt and Electronic Receipts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
chkact	Required **	Numeric	Header		Deposit Bank Account
chkdepno	Required	String (20)	Header		Deposit Number
actgdte	Required	Date	Header	yyyy-mm-dd	Posting Date
chkdte	Required	Date	Header	yyyy-mm-dd	Cash Receipt Date
chkdscrpt	Required	String (50)	Header		Cash Receipt Description
invtype	Required **	String (1)	Header	C=Contract;S=Service	Invoice Type
jobclnnum	Required ** (1) (2)	Numeric			Job / Service Client No
invnum	Required ** (2)	String (20)			Invoice Number
chknum		String (20)			Check No
pdamt	Required	Numeric (9,2)			Check Paid Amount
ovrpmt		Numeric (9,2)			Check Overpayment Amount
dsctkn		Numeric (9,2)			Discount Amount
er_pymt		Numeric		1=yes;0=no	Electronic Pmt Flag
er_refno	(3)	String (16)			Electronic Pmt Ref No
er_payor	(3)	String (103)			Electronic Pmt Payor Name
er_paytyp	(3) **	String (1)		3-American Express; 4-Visa; 5-MasterCard; 6-Discover; C-ACH; O-Other	Electronic Pmt Type
er_last4	(3)	String (4)		Last 4 digits of credit card	Electronic Pmt Last 4 CC

\n\n

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

(1) Enter jobnum if invtype=\"C\" and clnnum if invtype=\"S\"

(2) Job / Service Client No and Invoice Number must be unique in Sage 100 Contractor

(3) If Electronic Payment Flag (er_pymt) = 1 then the field is required

\n","urlObject":{"protocol":"https","path":["API","AR_CASH_RECEIPT"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"197db8e2-3a04-4d3a-ab97-4cc59f69ec45"},{"name":"AR_CLIENT_CONTACT","id":"4992d1e9-95ee-4938-ae8b-23fd036dcde3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": 124,\r\n \"cntnme\": \"John Doe\",\r\n \"jobttl\": \"President\",\r\n \"phnnum\": \"5551234567\",\r\n \"phnext\": \"123\",\r\n \"e_mail\": \"jdoe@example.com\",\r\n \"cllphn\": \"5551234567\",\r\n \"faxnum\": \"5551234567\",\r\n \"othphn\": \"5551234567\",\r\n \"othdsc\": \"Description\",\r\n \"ntetxt\": \"Notes\",\r\n \"linnum\": \"1\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_CLIENT_CONTACT?action_type=I","description":"

[AR 3-6 Client Contacts] Create and Update Client Contacts

Query Parameters
action_type: I (1)

(1) If the param is not specified the default will be \"I\" for insert new records only. Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Contacts	President	Client No
cntnme	Required	String (50)	Contacts		Contact Name
jobttl		String (50)	Contacts	jdoe@gmail.com	Job Title
phnnum		String (14)	Contacts		Phone No
phnext		String (6)	Contacts		Phone Ext
e_mail		String (75)	Contacts		Email
cllphn		String (14)	Contacts		Cell Phone
faxnum		String (14)	Contacts		Fax No
othphn		String (14)	Contacts		Other Phone
othdsc		String (50)	Contacts		Other Description
ntetxt		Text	Contacts		Notes
linnum	(1)	Numeric	Contacts		Line No

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) If a line number is specified the record will either update the existing line number if it exists or it will be inserted as this line no. If no line number is specified then the record will be auto assigned a line number or the combination of the recnum and the contact name will be evaluated to determine if the record exists

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT_CONTACT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"4992d1e9-95ee-4938-ae8b-23fd036dcde3"},{"name":"AR_CLIENT","id":"8511b236-d25b-42b9-bc16-d232e022fecb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"k","value":"","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": \"1001\",\r\n \"clnnme\": \"ABC Company\",\r\n \"shtnme\": \"ABC Co\",\r\n \"status\": 1,\r\n \"clntyp\": null,\r\n \"addrs1\": \"\",\r\n \"addrs2\": \"\",\r\n \"ctynme\": \"\",\r\n \"state_\": \"\",\r\n \"zipcde\": \"\",\r\n \"taxdst\": null,\r\n \"duetrm\": \"\",\r\n \"dsctrm\": \"\",\r\n \"dscrte\": null,\r\n \"finrte\": null,\r\n \"crsstr\": \"\",\r\n \"maploc\": \"\",\r\n \"bilad1\": \"\",\r\n \"bilad2\": \"\",\r\n \"bilcty\": \"\",\r\n \"bilste\": \"\",\r\n \"bilzip\": \"\",\r\n \"shpad1\": \"\",\r\n \"shpad2\": \"\",\r\n \"shpcty\": \"\",\r\n \"shpste\": \"\",\r\n \"shpzip\": \"\",\r\n \"stmeml\": \"\",\r\n \"bilbas\": null,\r\n \"clndsc\": null,\r\n \"pchnum\": \"\",\r\n \"exmnum\": \"\",\r\n \"crdtyp\": \"\",\r\n \"crdnum\": \"\",\r\n \"crdnme\": \"\",\r\n \"expdte\": null,\r\n \"nvrvlt\": null,\r\n \"pchdte\": null,\r\n \"dtercv\": null,\r\n \"cllbck\": null,\r\n \"lstctc\": null,\r\n \"refdte\": null,\r\n \"grting\": \"\",\r\n \"lstmal\": \"\",\r\n \"lstdte\": null,\r\n \"prdnum\": null,\r\n \"ledsrc\": null,\r\n \"region\": null,\r\n \"cmpsze\": null,\r\n \"mallst\": null,\r\n \"mannum\": null,\r\n \"empnum\": null,\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"usrdf3\": \"\",\r\n \"usrdf4\": \"\",\r\n \"usrdf5\": \"\",\r\n \"usrdf6\": null,\r\n \"usrdf7\": null,\r\n \"usrdf8\": null,\r\n \"usrdf9\": null,\r\n \"ntetxt\": \"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_CLIENT?action_type=I","description":"

[AR 3-6 Clients] Create New Clients (can also be used to update clients)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); IA = Insert with Auto Numbering (2); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

(2) Recnum must be omitted from payload or set to blank

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Client Number
clnnme	Required(I)	String (75)	Header		Full Client Name
shtnme	Required(I)	String (30)	Header		Short Name
status	Required(I) **	Numeric	Header	1	Status
clntyp	**	Numeric	Header		Client Type
addrs1		String (50)	General		General Addr 1
addrs2		String (50)	General		General Addr 2
ctynme		String (50)	General		General City
state_		String (2)	General		General State
zipcde		String (10)	General		General Zip
taxdst	**	Numeric	General		Tax District
duetrm		String (5)	General	##DY,##TH or ##MO	Due Terms
dsctrm		String (5)	General	##DY,##TH or ##MO	Discount Terms
dscrte		Numeric (3,2)	General	2.00	Discount Rate
finrte		Numeric (3,2)	General	2.00	Finance Rate
crsstr		String (50)	General		Cross Street
maploc		String (10)	General		Map Location
bilad1		String (50)	Other		Billing Addr 1
bilad2		String (50)	Other		Billing Addr 2
bilcty		String (50)	Other		Billing City
bilste		String (2)	Other		Billing State
bilzip		String (10)	Other		Billing Zip
shpad1		String (50)	Other		Shipping Addr 1
shpad2		String (50)	Other		Shipping Addr 2
shpcty		String (50)	Other		Shipping City
shpste		String (2)	Other		Shipping State
shpzip		String (10)	Other		Shipping Zip
stmeml		String (75)	Other		Statement Email
bilbas	**	Numeric	Billing	1=Last Cost;2=Avg Cost;3=BillAmt	Billing Basis
clndsc		Numeric (4,2)	Billing		Discount
pchnum		String (30)	Billing		PO#
exmnum		String (15)	Billing		Sales Tax Exempt#
crdtyp		String (30)	Billing		Reference 1
crdnum	*\\\\\\\\\\\\\\\\\\\\	String (64)	Billing	[Encrypted Field]	Reference 2
crdnme		String (30)	Billing		Reference 3
expdte		Date	Billing		Reference Date
nvrvlt		Numeric	Billing	0=False;1=True	Never use Sage Exchange Vault
pchdte		Date	Sales	yyyy-mm-dd	Purchase Date
dtercv		Date	Sales	yyyy-mm-dd	Date Received
cllbck		Date	Sales	yyyy-mm-dd	Call Back
lstctc		Date	Sales	yyyy-mm-dd	Contact
refdte		Date	Sales	yyyy-mm-dd	Reference Date
grting		String (50)	Sales		Greeting
lstmal		String (30)	Sales		Mail Piece
lstdte		Date	Sales	yyyy-mm-dd	Date Mailed
prdnum	**	Numeric	Sales		Product Type
ledsrc	**	Numeric	Sales		Source
region	**	Numeric	Sales		Area
cmpsze	**	Numeric	Sales		Size
mallst	**	Numeric	Sales		Mail List
mannum	**	Numeric	Sales		Manager
empnum	**	Numeric	Sales		Salesperson
usrdf1		String (50)	Sales		User Def 1
usrdf2		String (50)	Sales		User Def 2
usrdf3		String (50)	Sales		User Def 3
usrdf4		String (50)	Sales		User Def 4
usrdf5		String (50)	Sales		User Def 5
usrdf6		Numeric	Sales	0=False;1=True	User Def 6 (Checkbox)
usrdf7		Numeric	Sales	0=False;1=True	User Def 7 (Checkbox)
usrdf8		Numeric	Sales	0=False;1=True	User Def 8 (Checkbox)
usrdf9		Numeric	Sales	0=False;1=True	User Def 9 (Checkbox)
ntetxt		Text	Header		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"8511b236-d25b-42b9-bc16-d232e022fecb"},{"name":"AR_CLIENT","id":"a2408c00-90c2-440d-b962-bdac0134b5bc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"k","value":"","type":"text"},{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AR 3-6 Clients] Updates Existing Clients

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Client Number
clnnme		String (75)	Header		Full Client Name
shtnme		String (30)	Header		Short Name
status	**	Numeric	Header	1	Status
clntyp	**	Numeric	Header		Client Type
addrs1		String (50)	General		General Addr 1
addrs2		String (50)	General		General Addr 2
ctynme		String (50)	General		General City
state_		String (2)	General		General State
zipcde		String (10)	General		General Zip
taxdst	**	Numeric	General		Tax District
duetrm		String (5)	General	##DY,##TH or ##MO	Due Terms
dsctrm		String (5)	General	##DY,##TH or ##MO	Discount Terms
dscrte		Numeric (3,2)	General	2.00	Discount Rate
finrte		Numeric (3,2)	General	2.00	Finance Rate
crsstr		String (50)	General		Cross Street
maploc		String (10)	General		Map Location
bilad1		String (50)	Other		Billing Addr 1
bilad2		String (50)	Other		Billing Addr 2
bilcty		String (50)	Other		Billing City
bilste		String (2)	Other		Billing State
bilzip		String (10)	Other		Billing Zip
shpad1		String (50)	Other		Shipping Addr 1
shpad2		String (50)	Other		Shipping Addr 2
shpcty		String (50)	Other		Shipping City
shpste		String (2)	Other		Shipping State
shpzip		String (10)	Other		Shipping Zip
stmeml		String (75)	Other		Statement Email
bilbas	**	Numeric	Billing	1=Last Cost;2=Avg Cost;3=BillAmt	Billing Basis
clndsc		Numeric (4,2)	Billing		Discount
pchnum		String (30)	Billing		PO#
exmnum		String (15)	Billing		Sales Tax Exempt#
crdtyp		String (30)	Billing		Reference 1
crdnum	*\\\\\\\\\\\\\\\\	String (64)	Billing	[Encrypted Field]	Reference 2
crdnme		String (30)	Billing		Reference 3
expdte		Date	Billing		Reference Date
nvrvlt		Numeric	Billing	0=False;1=True	Never use Sage Exchange Vault
pchdte		Date	Sales	yyyy-mm-dd	Purchase Date
dtercv		Date	Sales	yyyy-mm-dd	Date Received
cllbck		Date	Sales	yyyy-mm-dd	Call Back
lstctc		Date	Sales	yyyy-mm-dd	Contact
refdte		Date	Sales	yyyy-mm-dd	Reference Date
grting		String (50)	Sales		Greeting
lstmal		String (30)	Sales		Mail Piece
lstdte		Date	Sales	yyyy-mm-dd	Date Mailed
prdnum	**	Numeric	Sales		Product Type
ledsrc	**	Numeric	Sales		Source
region	**	Numeric	Sales		Area
cmpsze	**	Numeric	Sales		Size
mallst	**	Numeric	Sales		Mail List
mannum	**	Numeric	Sales		Manager
empnum	**	Numeric	Sales		Salesperson
usrdf1		String (50)	Sales		User Def 1
usrdf2		String (50)	Sales		User Def 2
usrdf3		String (50)	Sales		User Def 3
usrdf4		String (50)	Sales		User Def 4
usrdf5		String (50)	Sales		User Def 5
usrdf6		Numeric	Sales	0=False;1=True	User Def 6 (Checkbox)
usrdf7		Numeric	Sales	0=False;1=True	User Def 7 (Checkbox)
usrdf8		Numeric	Sales	0=False;1=True	User Def 8 (Checkbox)
usrdf9		Numeric	Sales	0=False;1=True	User Def 9 (Checkbox)
ntetxt		Text	Header		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"a2408c00-90c2-440d-b962-bdac0134b5bc"},{"name":"AR_CLIENT_EQUIPMENT","id":"4197669a-74ea-40e7-a3e2-bdb4b932b320","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\":\"123\",\r\n \"eqpnum\":\"1111\",\r\n \"eqpnme\":\"test Eq\",\r\n \"manfct\":\"\",\r\n \"eqpmdl\":\"\",\r\n \"sernum\":\"\",\r\n \"locnum\":null,\r\n \"sitloc\":\"\",\r\n \"istdte\":\"2021-12-09\",\r\n \"isvdte\":\"2021-12-10\",\r\n \"oemexp\":null,\r\n \"lstsrv\":null,\r\n \"srvtrm\":\"12MO\",\r\n \"nxtsrv\":null,\r\n \"usrdf1\":\"udf1\",\r\n \"ntetxt\":\"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_CLIENT_EQUIPMENT?action_type=I","description":"

[AR 3-6 Client Equipment] Create New Client Equipment (can also be used to update Equipment)

Query Parameters

action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required **	Numeric	Equipment		Client No
eqpnum		Numeric	Equipment		Equipment No
eqpnme	Required (I,B)	String (50)	Equipment		Equipment Description
manfct		String (50)	Equipment		Manufacturer Name
eqpmdl		String (50)	Equipment		Manufacturer Part No
sernum		String (30)	Equipment		Serial No
locnum	**	Numeric	Equipment		Client Location
sitloc		String (50)	Equipment		Site Location
istdte		Date	Equipment	yyyy-mm-dd	Installed Date
isvdte		Date	Equipment	yyyy-mm-dd	In Service Date
oemexp		Date	Equipment	yyyy-mm-dd	OEM Warranty Exp Date
lstsrv		Date	Equipment	yyyy-mm-dd	Last Service Date
srvtrm		String (5)	Equipment	##DY means due every ## days; ##MO means due every ## months; ##TH means due on the ##th day of each month	Service Cycle
nxtsrv		Date	Equipment	yyyy-mm-dd	Next Service Date
usrdf1		String (50)	Equipment		User Defined
ntetxt		Text	Equipment		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT_EQUIPMENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"4197669a-74ea-40e7-a3e2-bdb4b932b320"},{"name":"AR_CLIENT_EQUIPMENT","id":"7c3745c6-d46d-43ae-921f-319bbf90ace2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AR 3-6 Client Equipment] Update Existing Client Equipment

Query Parameters

None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required **	Numeric	Equipment		Client No
eqpnum		Numeric	Equipment		Equipment No
eqpnme	Required (I,B)	String (50)	Equipment		Equipment Description
manfct		String (50)	Equipment		Manufacturer Name
eqpmdl		String (50)	Equipment		Manufacturer Part No
sernum		String (30)	Equipment		Serial No
locnum	**	Numeric	Equipment		Client Location
sitloc		String (50)	Equipment		Site Location
istdte		Date	Equipment	yyyy-mm-dd	Installed Date
isvdte		Date	Equipment	yyyy-mm-dd	In Service Date
oemexp		Date	Equipment	yyyy-mm-dd	OEM Warranty Exp Date
lstsrv		Date	Equipment	yyyy-mm-dd	Last Service Date
srvtrm		String (5)	Equipment	##DY means due every ## days; ##MO means due every ## months; ##TH means due on the ##th day of each month	Service Cycle
nxtsrv		Date	Equipment	yyyy-mm-dd	Next Service Date
usrdf1		String (50)	Equipment		User Defined
ntetxt		Text	Equipment		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT_EQUIPMENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"7c3745c6-d46d-43ae-921f-319bbf90ace2"},{"name":"AR_CLIENT_LOCATION","id":"0a87ad97-01e2-4c9e-9424-c12e318c9bf3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\":\"123\",\r\n \"locnum\":11,\r\n \"locnme\":\"Loc #11\",\r\n \"addrs1\":\"abc\",\r\n \"addrs2\":\"\",\r\n \"ctynme\":\"My City\",\r\n \"state\":\"CA\",\r\n \"zipcde\":\"92260\",\r\n \"phnnum\":\"\",\r\n \"contct\":\"\",\r\n \"srvgeo\":\"\",\r\n \"maploc\":\"\",\r\n \"crsstr\":\"\",\r\n \"taxdst\":\"\",\r\n \"usrdf1\":\"\",\r\n \"ntetxt\":\"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_CLIENT_LOCATION?action_type=I","description":"

[AR 3-6 Client Locations] Create and Update Client Locations

Query Parameters

action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required **	Numeric	Locations	123	Client No
locnum	Required	Numeric	Locations		Location No
locnme	Required (I)	String (50)	Locations	jdoe@gmail.com	Location Name
addrs1		String (50)	Locations		Address 1
addrs2		String (50)	Locations		Address 2
ctynme		String (50)	Locations		City
state_		String (2)	Locations		State
zipcde		String (10)	Locations		Zipcode
phnnum		String (14)	Locations		Phone
contct		String (50)	Locations		Contact
srvgeo		Numeric	Locations		Service Area
maploc		String (10)	Locations		Map Location
crsstr		String (50)	Locations		Cross Street
taxdst		Numeric	Locations		Tax District
usrdf1		String (50)	Locations		User Defined
ntetxt		Text	Locations		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

Required(I) - required for Inserts only

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT_LOCATION"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"0a87ad97-01e2-4c9e-9424-c12e318c9bf3"},{"name":"AR_CLIENT_LOCATION","id":"48641e5c-ea9a-4a93-8ba0-dfbba531e520","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AR 3-6 Client Locations] Update Existing Client Locations

Query Parameters

action_type: I (1) (Optional)

(1) If the param is not specified the default will be \"I\" for instert new records only. Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required **	Numeric	Locations	123	Client No
locnum	Required	Numeric	Locations		Location No
		String (50)	Locations	jdoe@gmail.com	Location Name
addrs1		String (50)	Locations		Address 1
addrs2		String (50)	Locations		Address 2
ctynme		String (50)	Locations		City
state_		String (2)	Locations		State
zipcde		String (10)	Locations		Zipcode
phnnum		String (14)	Locations		Phone
contct		String (50)	Locations		Contact
srvgeo		Numeric	Locations		Service Area
maploc		String (10)	Locations		Map Location
crsstr		String (50)	Locations		Cross Street
taxdst		Numeric	Locations		Tax District
usrdf1		String (50)	Locations		User Defined
ntetxt		Text	Locations		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

Required(I) - required for Inserts only

\n","urlObject":{"protocol":"https","path":["API","AR_CLIENT_LOCATION"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"48641e5c-ea9a-4a93-8ba0-dfbba531e520"},{"name":"AR_JOB","id":"2c51a758-d471-4aa6-bbe1-f407c846cbe2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\"recnum\":\"2019001\",\r\n \"jobnme\":\"Newtown Apartments\",\r\n \"shtnme\":\"Newtown Apts\",\r\n \"status\":4,\r\n \"jobtyp\":null,\r\n \"clnnum\":\"\",\r\n \"addrs1\":\"\",\r\n \"addrs2\":\"\",\r\n \"ctynme\":\"\",\r\n \"state_\":\"\",\r\n \"zipcde\":\"\",\r\n \"slstax\":null,\r\n \"lcltax\":null,\r\n \"dscdte\":null,\r\n \"duedte\":null,\r\n \"dsccnt\":null,\r\n \"finchg\":null,\r\n \"retain\":null,\r\n \"cntrct\":null,\r\n \"lgract\":4000,\r\n \"dptmnt\":null,\r\n \"connum\":\"\",\r\n \"pchord\":\"\",\r\n \"pstwip\":0,\r\n \"crtfid\":0,\r\n \"fedsck\":0,\r\n \"achtct\":null,\r\n \"lender\":null,\r\n \"sprvsr\":null,\r\n \"slsemp\":null,\r\n \"estemp\":null,\r\n \"usrdf1\":\"\",\r\n \"usrdf2\":\"\",\r\n \"stmeml\":\"\",\r\n \"ncrtck\":0,\r\n \"biddte\":null,\r\n \"plnrcv\":\"\",\r\n \"actbid\":\"\",\r\n \"ctcdte\":null,\r\n \"prelen\":\"\",\r\n \"sttdte\":null,\r\n \"cmpdte\":null,\r\n \"lenfld\":null,\r\n \"lenrls\":null,\r\n \"lotclr\":\"\",\r\n \"lotprm\":null,\r\n \"plnprc\":null,\r\n \"actprc\":null,\r\n \"estdte\":null,\r\n \"actdte\":null,\r\n \"lotnum\":\"\",\r\n \"modnme\":\"\",\r\n \"sqarft\":null,\r\n \"ntetxt\":\"\"\r\n }\r\n]\r\n\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_JOB?action_type=I","description":"

[AR 3-5 Jobs] Create New Jobs (can also be used to update Jobs)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); IA = Insert with Auto Numbering (2); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

(2) Recnum must be omitted from payload or set to blank

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header	2019001	Job No
jobnme	Required(I)	String (75)	Header	Newtown Apartments	Job Name
shtnme	Required(I)	String (30)	Header	Newtown Apts	Short Name
status	Required(I)	Numeric	Header	1-Bid;2-Refused;3-Contract;4-Current;5-Complete;6-Closed	Job Status
jobtyp	**	Numeric	Header		Job Type No
clnnum	**	Numeric	General		Client No
addrs1		String (50)	General		Job Addr1
addrs2		String (50)	General		Job Addr2
ctynme		String (50)	General		Job City
state_		String (2)	General		Job State
zipcde		String (10)	General		Job Zip
slstax	**	Numeric	General		Sales Tax District
lcltax	**	Numeric	General		Payroll Locale
dscdte		String (6)	General		Discount Terms
duedte		String (6)	General		Due Terms
dsccnt		Numeric (3,2)	General		Discount Rate
finchg		Numeric (3,2)	General		Finance Rate
retain		Numeric (3,2)	General		Retainage Rate
cntrct		Numeric (10,2)	General		Contract Amount
lgract	**	Numeric	General	4000	Income Account
dptmnt	**	Numeric	General		Department
connum		String (30)	General		Contract No
pchord		String (30)	General		Client PO No
pstwip		Numeric	General	1=Yes;0=No	Post Expenses to WIP asset Account
crtfid		Numeric	General	1=Yes;0=No	Requires Certified Payroll Reporting
fedsck		Numeric	General	1=Yes;0=No	Requires Federal sick leave accrual
achtct	**	Numeric	Contacts		Architect
lender	**	Numeric	Contacts		Lender
sprvsr	**	Numeric	Contacts		Supervisor
slsemp	**	Numeric	Contacts		Salesperson
estemp	**	Numeric	Contacts		Estimator
usrdf1		String (50)	Contacts		User Def 1
usrdf2		String (50)	Contacts		User Def 2
stmeml		String (75)	Contacts		Statement Email
ncrtck		Numeric	Contacts	1=Yes;0=No	Do not check job for missing vendor certs
biddte		Date	Project Dates	yyyy-mm-dd	Bid Opening Date
plnrcv		Date	Project Dates	yyyy-mm-dd	Plan Received Date
actbid		Date	Project Dates	yyyy-mm-dd	Bid Completed Date
ctcdte		Date	Project Dates	yyyy-mm-dd	Contract Signed Date
prelen		Date	Project Dates	yyyy-mm-dd	Pre-Lien Filed Date
sttdte		Date	Project Dates	yyyy-mm-dd	Project Started Date
cmpdte		Date	Project Dates	yyyy-mm-dd	Project Completed Date
lenfld		Date	Project Dates	yyyy-mm-dd	Lien Filed Date
lenrls		Date	Project Dates	yyyy-mm-dd	Lien Released Date
lotclr		String (30)	Project Dates		Color Scheme
lotprm		Numeric (10,2)	Project Dates		Lot Premium
plnprc		Numeric (10,2)	Project Dates		Est Sales Price
actprc		Numeric (10,2)	Project Dates		Actual Sales Price
estdte		Date	Project Dates	yyyy-mm-dd	Estimated Closing Date
actdte		Date	Project Dates	yyyy-mm-dd	Actual Closing Date
lotnum		String (10)	Project Dates		Lot Number
modnme		String (30)	Project Dates		Model Name
sqarft		Numeric	Project Dates		Square Feet
ntetxt		Text	Header		Notes
county		String (50)	Certified Payroll		Project County
fednum		String (25)	Certified Payroll		Federal Project#
stenum		String (25)	Certified Payroll		State Project#
typwrk		String (50)	Certified Payroll		Type of Work
awddte		Date	Certified Payroll	yyyy-mm-dd	Award Date
strdte		Date	Certified Payroll	yyyy-mm-dd	First Payroll Ending Date
dtecmp		Date	Certified Payroll	yyyy-mm-dd	Completion Date
pctcmp		Numeric	Certified Payroll	0 - 100	Percent Complete
subcnt		Numeric	Certified Payroll	1=Yes;0=No	Working as Subcontractor
prmnme		String (50)	Certified Payroll		Prime Contractor Name
prmadd		String (50)	Certified Payroll		Prime Contractor Address
prmcty		String (50)	Certified Payroll		Prime Contractor City
prmste		String (2)	Certified Payroll		Prime Contractor State
prmzip		String (10)	Certified Payroll		Prime Contractor Zip
prmphn		String (14)	Certified Payroll		Prime Contractor Phone#
prmeml		String (75)	Certified Payroll		Prime Contractor Email
awdcnt		String (50)	Certified Payroll		Awarding Contractor
awdfnm		String (50)	Certified Payroll		Awarding Contractor First Name
awdlnm		String (50)	Certified Payroll		Awarding Contractor Last Name
awdadd		String (50)	Certified Payroll		Awarding Contractor Address
awdcty		String (50)	Certified Payroll		Awarding Contractor City
awdste		String (2)	Certified Payroll		Awarding Contractor State
awdzip		String (10)	Certified Payroll		Awarding Contractor Zip
awdphn		String (14)	Certified Payroll		Awarding Contractor Phone#
awdeml		String (75)	Certified Payroll		Awarding Contractor Email
inactv		Numeric	Menu	1=Yes;0=No	Inactive Record

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_JOB"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"2c51a758-d471-4aa6-bbe1-f407c846cbe2"},{"name":"AR_JOB","id":"a392946a-c393-4a98-952a-75e55cee2988","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AR 3-5 Jobs] Update Existing Jobs

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header	2019001	Job No
		String (75)	Header	Newtown Apartments	Job Name
shtnme		String (30)	Header	Newtown Apts	Short Name
status		Numeric	Header	1-Bid;2-Refused;3-Contract;4-Current;5-Complete;6-Closed	Job Status
jobtyp	**	Numeric	Header		Job Type No
clnnum	**	Numeric	General		Client No
addrs1		String (50)	General		Job Addr1
addrs2		String (50)	General		Job Addr2
ctynme		String (50)	General		Job City
state_		String (2)	General		Job State
zipcde		String (10)	General		Job Zip
slstax	**	Numeric	General		Sales Tax District
lcltax	**	Numeric	General		Payroll Locale
dscdte		String (6)	General		Discount Terms
duedte		String (6)	General		Due Terms
dsccnt		Numeric (3,2)	General		Discount Rate
finchg		Numeric (3,2)	General		Finance Rate
retain		Numeric (3,2)	General		Retainage Rate
cntrct		Numeric (10,2)	General		Contract Amount
lgract	**	Numeric	General	4000	Income Account
dptmnt	**	Numeric	General		Department
connum		String (30)	General		Contract No
pchord		String (30)	General		Client PO No
pstwip		Numeric	General	1=Yes;0=No	Post Expenses to WIP asset Account
crtfid		Numeric	General	1=Yes;0=No	Requires Certified Payroll Reporting
fedsck		Numeric	General	1=Yes;0=No	Requires Federal sick leave accrual
achtct	**	Numeric	Contacts		Architect
lender	**	Numeric	Contacts		Lender
sprvsr	**	Numeric	Contacts		Supervisor
slsemp	**	Numeric	Contacts		Salesperson
estemp	**	Numeric	Contacts		Estimator
usrdf1		String (50)	Contacts		User Def 1
usrdf2		String (50)	Contacts		User Def 2
stmeml		String (75)	Contacts		Statement Email
ncrtck		Numeric	Contacts	1=Yes;0=No	Do not check job for missing vendor certs
biddte		Date	Project Dates	yyyy-mm-dd	Bid Opening Date
plnrcv		Date	Project Dates	yyyy-mm-dd	Plan Received Date
actbid		Date	Project Dates	yyyy-mm-dd	Bid Completed Date
ctcdte		Date	Project Dates	yyyy-mm-dd	Contract Signed Date
prelen		Date	Project Dates	yyyy-mm-dd	Pre-Lien Filed Date
sttdte		Date	Project Dates	yyyy-mm-dd	Project Started Date
cmpdte		Date	Project Dates	yyyy-mm-dd	Project Completed Date
lenfld		Date	Project Dates	yyyy-mm-dd	Lien Filed Date
lenrls		Date	Project Dates	yyyy-mm-dd	Lien Released Date
lotclr		String (30)	Project Dates		Color Scheme
lotprm		Numeric (10,2)	Project Dates		Lot Premium
plnprc		Numeric (10,2)	Project Dates		Est Sales Price
actprc		Numeric (10,2)	Project Dates		Actual Sales Price
estdte		Date	Project Dates	yyyy-mm-dd	Estimated Closing Date
actdte		Date	Project Dates	yyyy-mm-dd	Actual Closing Date
lotnum		String (10)	Project Dates		Lot Number
modnme		String (30)	Project Dates		Model Name
sqarft		Numeric	Project Dates		Square Feet
ntetxt		Text	Header		Notes
county		String (50)	Certified Payroll		Project County
fednum		String (25)	Certified Payroll		Federal Project#
stenum		String (25)	Certified Payroll		State Project#
typwrk		String (50)	Certified Payroll		Type of Work
awddte		Date	Certified Payroll	yyyy-mm-dd	Award Date
strdte		Date	Certified Payroll	yyyy-mm-dd	First Payroll Ending Date
dtecmp		Date	Certified Payroll	yyyy-mm-dd	Completion Date
pctcmp		Numeric	Certified Payroll	0 - 100	Percent Complete
subcnt		Numeric	Certified Payroll	1=Yes;0=No	Working as Subcontractor
prmnme		String (50)	Certified Payroll		Prime Contractor Name
prmadd		String (50)	Certified Payroll		Prime Contractor Address
prmcty		String (50)	Certified Payroll		Prime Contractor City
prmste		String (2)	Certified Payroll		Prime Contractor State
prmzip		String (10)	Certified Payroll		Prime Contractor Zip
prmphn		String (14)	Certified Payroll		Prime Contractor Phone#
prmeml		String (75)	Certified Payroll		Prime Contractor Email
awdcnt		String (50)	Certified Payroll		Awarding Contractor
awdfnm		String (50)	Certified Payroll		Awarding Contractor First Name
awdlnm		String (50)	Certified Payroll		Awarding Contractor Last Name
awdadd		String (50)	Certified Payroll		Awarding Contractor Address
awdcty		String (50)	Certified Payroll		Awarding Contractor City
awdste		String (2)	Certified Payroll		Awarding Contractor State
awdzip		String (10)	Certified Payroll		Awarding Contractor Zip
awdphn		String (14)	Certified Payroll		Awarding Contractor Phone#
awdeml		String (75)	Certified Payroll		Awarding Contractor Email
inactv		Numeric	Menu	1=Yes;0=No	Inactive Record

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_JOB"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"a392946a-c393-4a98-952a-75e55cee2988"},{"name":"AR_JOB_CONTACT","id":"68f38013-b775-4cfa-820b-de49e5247ead","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\"recnum\":\"2017504\",\r\n \"cntnme\":\"John Dode\",\r\n \"jobttl\":\"President\",\r\n \"phnnum\":\"714-555-2587\",\r\n \"phnext\":\"\",\r\n \"e_mail\":\"jdoe@gmail.com\",\r\n \"cllphn\":\"\",\r\n \"faxnum\":\"\",\r\n \"othphn\":\"\",\r\n \"othdsc\":\"\",\r\n \"ntetxt\":\"\"\r\n }\r\n]\r\n\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_JOB_CONTACT?action_type=I","description":"

[AR 3-5 Job Contacts] Create New Job Contact's (can also use to update Job Contact's)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Contacts	2019021	Job No
cntnme	Required	String (50)	Contacts	John Doe	Contact Name
jobttl		String (50)	Contacts	President	Job Title
phnnum		String (14)	Contacts		Phone No
phnext		String (6)	Contacts		Phone Ext
e_mail		String (75)	Contacts	jdoe@gmail.com	Email
cllphn		String (14)	Contacts		Cell Phone
faxnum		String (14)	Contacts		Fax No
othphn		String (14)	Contacts		Other Phone
othdsc		String (50)	Contacts		Other Description
ntetxt		Text	Contacts		Notes
linnum	(1)	Numeric	Contacts		Line Number

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_JOB_CONTACT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"68f38013-b775-4cfa-820b-de49e5247ead"},{"name":"AR_JOB_CONTACT","id":"2b70f075-1acf-4ecc-a61d-c68990b6a56f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AR 3-5 Job Contacts] Create New Job Contact's (can also use to update Job Contact's)

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Contacts	2019021	Job No
cntnme	Required	String (50)	Contacts	John Doe	Contact Name
jobttl		String (50)	Contacts	President	Job Title
phnnum		String (14)	Contacts		Phone No
phnext		String (6)	Contacts		Phone Ext
e_mail		String (75)	Contacts	jdoe@gmail.com	Email
cllphn		String (14)	Contacts		Cell Phone
faxnum		String (14)	Contacts		Fax No
othphn		String (14)	Contacts		Other Phone
othdsc		String (50)	Contacts		Other Description
ntetxt		Text	Contacts		Notes
linnum	(1)	Numeric	Contacts		Line Number

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AR_JOB_CONTACT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"2b70f075-1acf-4ecc-a61d-c68990b6a56f"},{"name":"AR_RECEIVABLE_INVOICE","id":"5661deb2-a08a-4e75-a1b5-4e61eeb5537c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"invnum\": 123456789,\r\n \"jobnum\": 201,\r\n \"dscrpt\": \"This is a description.\",\r\n \"invdte\": \"2019-01-01\",\r\n \"duedte\": \"\",\r\n \"dscdte\": \"\",\r\n \"status\": 1,\r\n \"invtyp\": 1,\r\n \"phsnum\": \"\",\r\n \"taxdst\": \"\",\r\n \"pchord\": \"\",\r\n \"refnum\": \"\",\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"dscavl\": \"\",\r\n \"retain\": \"\",\r\n \"hotlst\": 1,\r\n \"ntetxt\": \"\",\r\n \"postprd\": \"\",\r\n \"invoice_detail\": [\r\n {\r\n \"dscrpt\": \"\",\r\n \"prtnum\": \"\",\r\n \"untdsc\": \"\",\r\n \"linqty\": \"\",\r\n \"linprc\": \"\",\r\n \"taxabl\": \"N\",\r\n \"lgract\": \"\",\r\n \"subact\": \"\",\r\n \"cstcde\": \"\",\r\n \"usrdf1\": \"\",\r\n \"ntetxt\": \"\"\r\n }\r\n ],\r\n \"direct_costs\": [\r\n {\r\n \"filetype\": \"ARINV\",\r\n \"linetype\": \"J\",\r\n \"invnum\": 123456789,\r\n \"invjobnum\": 201,\r\n \"jobnum\": \"\",\r\n \"wrkord\": \"\",\r\n \"dscrpt\": \"\",\r\n \"phsnum\": \"\",\r\n \"cstcde\": \"\",\r\n \"csttyp\": \"\",\r\n \"cstamt\": -10.00,\r\n \"ntetxt\": \"\"\r\n }\r\n ],\r\n \"equip_costs\": [\r\n {\r\n \"filetype\": \"ARINV\",\r\n \"linetype\": \"E\",\r\n \"invnum\": 123456789,\r\n \"invjobnum\": 201,\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": \"\",\r\n \"cstamt\": -10.00,\r\n \"eqnotes\": \"\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AR_RECEIVABLE_INVOICE","description":"

[AR 3-2 Receivable Invoices/Credits] Create Receivable Invoices/Credits

Query Parameters
None

Body Parameters:

Field Name	Reference	Data Type	Tab	Example	Description
invnum	Required	String (20)	Header		Invoice No
jobnum	Required **	Numeric	Header		Job Number
dscrpt	Required	String (50)	Header		Invoice Description
invdte	Required	Date	Header		Invoice Date
duedte	Required	Date	Header		Due Date
dscdte	Required	Date	Header		Discount Date
status	Required **	Numeric	Header	1-Open, 2-Review, 3-Dispute	Status
invtyp	Required **	Numeric	Header	1-Contract, 2-Memo	Invoice Type
phsnum	**	Numeric	Header		Phase No
taxdst	**	Numeric	Header		Tax District
pchord		String (20)	Header		Client PO#
refnum		String (20)	Header		Reference #
usrdf1		String (50)	Header		User Def1
usrdf2		String (50)	Header		User Def2
dscavl		Numeric (10,2)	Header		Discount Avail
retain		Numeric (10,2)	Header		Retention
hotlst		Numeric	Header	1=Yes; 0=No	Hot List
ntetxt		Text	Header		Notes
postprd	(1)	Date			Posting Period
invoice_detail[]
dscrpt	Required	String (75)	Detail		Line Description
prtnum		bigint	Detail		Part #
untdsc		String (10)	Detail		Unit Desc
linqty		Numeric (12,4)	Detail		Qty
linprc	(2)	Numeric (15,6)	Detail		Unit Price
taxabl	**	String (1)	Detail	Y=Yes; N=No	Taxable
lgract	Required **	Numeric	Detail		Account
subact	**	Numeric	Detail		Sub-Account
cstcde	**	Numeric (15,3)	Detail		Cost Code
usrdf1		String (50)	Detail		User Def 1
ntetxt		Text	Detail		Notes
hldrte	(3) (4)	Numeric (6,2)	Detail (Canadian Version)		Holdback Rate
hldtamt	(3) (4)	Numeric (12,2)	Detail (Canadian Version)		Holdback Amount
gstsbj	(3) **	String(1)	Detail (Canadian Version)	Y=Yes; N=No	Subject to GST
gstamt	(3)	Numeric (12,2)	Detail (Canadian Version)		GST Amount
pstsbj	(3) **	String(1)	Detail (Canadian Version)	Y=Yes; N=No	Subject to PST
pstamt	(3)	Numeric (12,2)	Detail (Canadian Version)		PST Amount
hstsbj	(3) **	String(1)	Detail (Canadian Version)	Y=Yes; N=No	Subject to HST
hstamt	(3)	Numeric (12,2)	Detail (Canadian Version)		HST Amount
direct_costs[]
jobnum	Required **	Numeric	Job Cost		Job No
wrkord	**	String (20)	Job Cost		Work Order Recnum
dscrpt	Required	String (50)	Job Cost		Description
phsnum	**	Numeric	Job Cost		Phase No
cstcde	Required **	Numeric (15,3)	Job Cost		Cost Code
csttyp	Required **	Numeric	Job Cost	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9	Cost Type
cstamt	Required	Numeric (12,2)	Job Cost	(Negative Amount)	Cost Amount
ntetxt		Text	Job Cost		Notes
equip_costs[]
eqpnum	Required **	Numeric	Equip Cost		Equip No
eqdscrpt	Required	String (50)	Equip Cost		Description
eqcstcde	Required **	Numeric (15,3)	Equip Cost		Cost Code
eqcsttyp	Required **	Numeric	Equip Cost	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9	Cost Type
cstamt	Required	Numeric (10,2)	Equip Cost	(Negative Amount)	Cost Amount
eqnotes		Text	Equip Cost		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

| (1) If posting period is left blank then the Invoice Date will be used as the posting period |
| (2) Price may not be a negative value. If the line amount is negative you must make the \"Quantity\" negative |
| (3) Canadian version ONLY. Leave blank if you are using the US version |
| (4) Only one needs to be provided but not both |

\n","urlObject":{"protocol":"https","path":["API","AR_RECEIVABLE_INVOICE"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"5661deb2-a08a-4e75-a1b5-4e61eeb5537c"}],"id":"fd7e3ae1-feaf-4535-a6f3-c32d06cf6b1a","auth":{"type":"noauth","isInherited":false},"event":[{"listen":"prerequest","script":{"id":"f8c573d7-9987-4e66-953c-7e561d1b7163","type":"text/javascript","packages":{},"exec":[""]}},{"listen":"test","script":{"id":"274a78b4-8748-4f8b-b184-2f975954191a","type":"text/javascript","packages":{},"exec":[""]}}],"_postman_id":"fd7e3ae1-feaf-4535-a6f3-c32d06cf6b1a","description":""},{"name":"4 - Accounts Payable","item":[{"name":"AP_CREDIT_CARD_RECEIPT","id":"3586f9e9-8e16-4ce1-92a9-f632ad03be77","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"trnnum\": \"ccr_123\",\r\n \"crlgract\": 2250,\r\n \"crsubact\": 1156,\r\n \"trndte\": \"2016-01-01\",\r\n \"dscrpt\": \"CC Transaction Desc\",\r\n \"payee1\": \"\",\r\n \"vndnum\": 2,\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"ntetxt\": \"\",\r\n \"postprd\": \"\",\r\n \"ccrdetail\": [\r\n {\r\n \"lgract\": 6001,\r\n \"subact\": \"\",\r\n \"dscrpt\": \"\",\r\n \"prtnum\": 123,\r\n \"untdsc\": \"\",\r\n \"linqty\": 1,\r\n \"linprc\": 12.34,\r\n \"dbtamt\": 0,\r\n \"usrdf1\": \"\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": null,\r\n \"phsnum\": null,\r\n \"jcdscrpt\": \"\",\r\n \"jccstcde\": null,\r\n \"jccsttyp\": null,\r\n \"jcnotes\": null,\r\n \"eqpnum\": null,\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": null,\r\n \"eqcsttyp\": null,\r\n \"eqnotes\": null\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AP_CREDIT_CARD_RECEIPT","description":"

[AP 4-7-3 Credit Card Receipts] Create Credit Card Receipts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
trnnum	Required (1)	String (20)	Header	123_abc	Transaction Reference
crlgract	Required **	Numeric	Header		Credit Card Account
crsubact	Required **	Numeric	Header		Credit Card Sub Account
trndte	Required	date	Header	YYYY-MM-DD	Transaction Date
dscrpt	Required	String (50)	Header	CC Transaction Desc	Transaction Description
payee1	Required (2)	String (50)	Header		Payee
vndnum	** (2) (3)	Numeric	Header	Invoice/Payment Created	Vendor Recnum
usrdf1		String (50)	Header		usrdf1
usrdf2		String (50)	Header		usrdf2
ntetxt		Text	Header		Notes
postprd	(4)	Date			Posting Period
ccrdetail[]
lgract	Required **	Numeric	Header		Ledger Acct Recnum
subact	**	Numeric	Detail		Sub Account Recnum
dscrpt		String (50)	Detail		Line Description
prtnum	** (5)	Numeric	Detail	(Vendor Recnum Required)	Part No
untdsc		String (10)	Detail		Unit of Measure
linqty		Numeric (10,2)	Detail		Quantity
linprc		Numeric (10,2)	Detail		Price
dbtamt	(6)	Numeric (9,2)	Detail	(Enter 0 or Blank if Qty and Price entered)	Total Amount
usrdf1		String (50)	Detail		User Defined 1
wrkord	**	String (20)	Detail	WIP / Direct Exp \\\\*	Work Order No
jobnum	**	Numeric	Detail	WIP / Direct Exp \\\\*	Job No
phsnum	**	Numeric	Detail	WIP / Direct Exp \\\\*	Phase No
jcdscrpt		String (50)	Detail	WIP / Direct Exp \\\\*	Description
jccstcde	**	Numeric (15,3)	Detail	WIP / Direct Exp \\\\*	Cost Code
jccsttyp	**	Numeric	Detail	WIP / Direct Exp \\\\*	Cost Type
jcnotes		Text	Detail	WIP / Direct Exp \\\\*	Notes
eqpnum	**	Numeric	Detail	Equip Exp **	Equip No
eqdscrpt		String (50)	Detail	Equip Exp **	Description
eqcstcde	**	Numeric (15,3)	Detail	Equip Exp **	Cost Code
eqcsttyp	**	Numeric	Detail	Equip Exp **	Cost Type
eqnotes		Text	Detail	Equip Exp **	Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) Transaction Reference must be unique for each line item.

(2) Payee should be left blank if a Vendor Recnum is entered and will default to the Vendor Name. If both a Payee and Vendor No are entered the Payee value will be ignored and defaulted to the Vendor Name.

(3) If you enter a vendor, a paid invoice is created. If you look in 1-3 Journal Transactions, you see that two journal transactions have been created. This is a typical journal transaction and a record of the payment (the paid invoice).

(4) If posting period is left blank then the Transaction Date will be used as the posting period.

(5) Part No is only allowed if a Vendor No is entered in the Header.

(6) The Total Amount field will be automatically calculated based on the Quantity and Price entered. If no quantity or price is entered then a value must be provided.

WIP / Direct Exp* - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type

Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type

\n","urlObject":{"protocol":"https","path":["API","AP_CREDIT_CARD_RECEIPT"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"3586f9e9-8e16-4ce1-92a9-f632ad03be77"},{"name":"AP_INVOICE","id":"1374b1f3-5ea5-47d9-b609-5f4b099c0eb3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"invnum\": 986312,\r\n \"vndnum\": 67,\r\n \"dscrpt\": \"This is a description\",\r\n \"invdte\": \"2019-01-01\",\r\n \"duedte\": \"2019-01-01\",\r\n \"dscdte\": \"2019-01-01\",\r\n \"status\": 1,\r\n \"invtyp\": 1,\r\n \"pchord\": \"\",\r\n \"ctcnum\": \"\",\r\n \"jobnum\": 222,\r\n \"phsnum\": 1,\r\n \"shpnum\": \"\",\r\n \"refnum\": \"\",\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"dscavl\": \"\",\r\n \"retain\": \"\",\r\n \"setpay\": \"\",\r\n \"hotlst\": 1,\r\n \"ntetxt\": \"\",\r\n \"poclose\":0,\r\n \"postprd\":\"\",\r\n \"invoice_detail\": [\r\n {\r\n \"prtdsc\": \"\",\r\n \"ctclinnum\": 1,\r\n \"prtnum\": \"\",\r\n \"untdsc\": \"\",\r\n \"linqty\": \"\",\r\n \"linprc\": \"\",\r\n \"actnum\": \"\",\r\n \"subact\": \"\",\r\n \"invloc\": \"\",\r\n \"sernum\": \"\",\r\n \"usrdf1\": \"\"\r\n }\r\n ],\r\n \"direct_costs\": [\r\n {\r\n \"jobnum\": \"\",\r\n \"wrkord\": \"\",\r\n \"dscrpt\": \"\",\r\n \"phsnum\": \"\",\r\n \"cstcde\": \"\",\r\n \"csttyp\": 1,\r\n \"cstamt\": \"\",\r\n \"ntetxt\": \"\"\r\n }\r\n ],\r\n \"equip_costs\": [\r\n {\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": 3,\r\n \"cstamt\": \"\",\r\n \"eqnotes\": \"\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AP_INVOICE","description":"

[AP 4-2 Payable Invoices/Credits] Create Payable Invoices/Credits

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
invnum	Required	String (20)	Header		Invoice No
vndnum	Required **	Numeric	Header		Vendor No
dscrpt	Required	String (50)	Header		Invoice Desc
invdte	Required	Date	Header	yyyy-mm-dd	Invoice Date
duedte	Required (1)	Date	Header	yyyy-mm-dd	Due Date
dscdte	Required (1)	Date	Header	yyyy-mm-dd	Discount Date
status	Required ** (2)	Numeric	Header	1-Open, 2-Review, 3-Dispute, 4-Paid	Status
invtyp	Required **	Numeric	Header	1-Contract,2-Memo	Invoice Type
pchord	** (3)	String (20)	Header		Purchase Order No
ctcnum	** (3)	String (20)	Header		Subcontract No
jobnum	** (4)	Numeric	Header		Job No
phsnum	** (4)	Numeric	Header		Phase No
shpnum		String (20)	Header		Ship No
refnum		String (20)	Header		Reference No
taxcde	Required ** (5)	Numeric	Header (Canadian Version)		Tax Code
usrdf1		String (50)	Header		User Def 1
usrdf2		String (50)	Header		User Def 2
usedst	** (6) (7)	Numeric	Header (US Version)		'Use Tax' District
usettl	(6) (7)	Numeric	Header (US Version)		Use Tax Amount
wrkcmp	(8)	String (1)	Header	Y=Yes; N=No; Blank=Vendor Setup	Workers' Comp
dscavl	(9)	Numeric (12,2)	Header		Discount Amt
retain	(6)	Numeric (12,2)	Header (US Version)		Retention Amt
setpay		Numeric (10,2)	Header		Set to Pay Amt
hotlst		Numeric	Header	1=Yes;0=No	Hot List
ntetxt		Text	Header		Notes
poclose	(10)	Numeric		Default=0; 1=Yes; 0=No	Auto close Purchase Order
postprd	(11)	Date			Posting Period
invoice_detail[]
prtdsc	Required	String (75)	Detail		Line Description
ctclinnum	(12)	Numeric	Detail		Contract\\PO Line No
prtnum	**	Numeric	Detail		Part No
untdsc		String (10)	Detail		Unit of Measure
linqty	Required	Numeric (12,4)	Detail		Quantity
linprc	Required (13)	Numeric (15, 6)	Detail		Price
hldamt	(5)	Numeric (12,2)	Detail (Canadian Version)		Holdback Amount
gstamt	(5)	Numeric (12,2)	Detail (Canadian Version)		GST Amount
pstamt	(5)	Numeric (12,2)	Detail (Canadian Version)		PST Amount
qstamt	(5)	Numeric (12,2)	Detail (Canadian Version)		QST Amount
hstamt	(5)	Numeric (12,2)	Detail (Canadian Version)		HST Amount
actnum	Required **	Numeric	Detail		Exp Account
subact	**	Numeric	Detail		Exp Sub Account
invloc	**	Numeric	Detail		Inventory Location
sernum		String (30)	Detail		Part Serial No
usrdf1		String (50)	Detail		User Def 1
direct_costs[]
jobnum	Required **	Numeric	Job Cost		Job No
wrkord	**	String (20)	Job Cost		Work Order Recnum
dscrpt	Required	String (50)	Job Cost		Description
phsnum	**	Numeric	Job Cost		Phase No
cstcde	Required **	Numeric (15,3)	Job Cost		Cost Code
csttyp	Required **	Numeric	Job Cost	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9	Cost Type
cstamt	Required	Numeric (12,2)	Job Cost		Cost Amount
ntetxt		Text	Job Cost		Notes
equip_costs[]
eqpnum	Required **	Numeric	Equip Cost		Equip No
eqdscrpt	Required	String (50)	Equip Cost		Description
eqcstcde	Required **	Numeric (15,3)	Equip Cost		Cost Code
eqcsttyp	Required **	Numeric	Equip Cost	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9	Cost Type
cstamt	Required	Numeric (12,2)	Equip Cost		Cost Amount
eqnotes		Text	Equip Cost		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) If the Due Date or Discount Date are left blank or omitted, then they will be derived from the terms in the Vendor Setup relative to the invoice date. However, if there are no terms in the Vendor Setup then they will be set to the Invoice Date.
(2) If a Status of 4-Paid is entered no ledger transactions will be created for the invoice
(3) Auto Detail: If no \"D\" records are passed into the file for the respective subcontract or purchase order then the detail line items will be automatically populated based on the existing line items for the PO or Subcontract
(4) If a contract or purchase order number are entered jobnum, phsnum should not be entered and will be ignored
(5) Canadian version ONLY. Leave blank or exclude if you are using the US version
(6) US version ONLY. Leave blank or exclude if you are using the US version
(7) If a 'Use Tax' District is provided and a Use Tax Amount is left blank or omitted, it will be calculated automatically. Otherwise providing a Use Tax Amount will override the automatic calculation
(8) If 'Y' is provided, the Vendor must have a Workers' Comp Rate. If left blank or omitted, the amount will be calculated automatically from the derived rate in the Vendor Setup if one exists
(9) If the Discount Amt is left blank or omitted, then it will be derived from the Vendor Setup and applied relative to the invoice amount. Please note if a value of 0 is desired then use 0, as using blank for 0 will not be handled the same
(10) If the Invoice is coded to a purchase order and the invoice causes the balance of the PO to be less than or equal to zero the purchase order status will be changed automatically to closed
(11) If posting period is left blank or omitted then the invoice date will be used as the posting period
(12) If a contract or purchase order number entered the contract line no is required for all lines
(13 Price may not be a negative value. If the line amount is negative you must make the \"Quantity\" negative

\n","urlObject":{"protocol":"https","path":["API","AP_INVOICE"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"1374b1f3-5ea5-47d9-b609-5f4b099c0eb3"},{"name":"AP_VENDOR","id":"e735f5a4-5055-4fbd-9cd1-6860593697c3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\":\"202001\",\r\n \"vndnme\":\"ABC Contractors\",\r\n \"shtnme\":\"ABC Cont\",\r\n \"vndtyp\":\"\",\r\n \"ownnme\":\"John Biggins\",\r\n \"addrs1\":\"\",\r\n \"addrs2\":\"\",\r\n \"ctynme\":\"\",\r\n \"state_\":\"\",\r\n \"zipcde\":\"\",\r\n \"minsts\":\"0\",\r\n \"taxdst\":\"\",\r\n \"usrdf1\":\"\",\r\n \"usrdf2\":\"\",\r\n \"fedidn\":\"\",\r\n \"steidn\":\"\",\r\n \"resnum\":\"\",\r\n \"actnum\":\"\",\r\n \"licnum\":\"\",\r\n \"intrnl\":\"0\",\r\n \"prt199\":\"0\",\r\n \"elc199\":\"0\",\r\n \"eml199\":\"\",\r\n \"dscrte\":\"\",\r\n \"dscdte\":\"\",\r\n \"duedte\":\"\",\r\n \"cmprte\":\"\",\r\n \"utxrte\":\"\",\r\n \"lgrdft\":\"\",\r\n \"cdedft\":\"\",\r\n \"typdft\":\"0\",\r\n \"stsdft\":\"0\",\r\n \"wrndft\":\"0\",\r\n \"utwarn\":\"0\",\r\n \"hotlst\":\"0\",\r\n \"dupchk\":\"0\",\r\n \"sepchk\":\"0\",\r\n \"rfptyp\":\"\",\r\n \"rfpdsc\":\"\",\r\n \"ordtyp\":\"\",\r\n \"orddsc\":\"\",\r\n \"contyp\":\"\",\r\n \"condsc\":\"\",\r\n \"dirdep\":\"0\",\r\n \"prente\":\"4\",\r\n \"acttyp\":\"1\",\r\n \"rtnmbr\":\"\",\r\n \"bnkact\":\"\",\r\n \"acheml\":\"\",\r\n \"ntetxt\":\"\"\r\n\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AP_VENDOR?action_type=I","description":"

[AR 4-4 Vendor Create] Create New Vendors (can also be used to update Vendors)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); IA = Insert with Auto Numbering (2); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

(2) Recnum must be omitted from payload or set to blank

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header	201701	Vendor No
vndnme	Required(I)	String (75)	Header	Capital Ventures	Vendor Name
shtnme	Required(I)	String (30)	Header	Cap Vent	Vendor Short Name
vndtyp	**	Numeric	Header		Vendor Type
ownnme		String (50)	General	John Biggins	Owner Name
addrs1		String (50)	General		Vendor Addr 1
addrs2		String (50)	General		Vendor Addr 2
ctynme		String (50)	General		Vendor City
state_		String (2)	General		Vendor State
zipcde		String (10)	General		Vendor Zip
minsts	**	Numeric	General	0=None;1=Minority Owned;2=Women Owned;3=Disabled Vet	Minority Type
taxdst	**	Numeric	General		Tax District
usrdf1		String (50)	General		User Def1
usrdf2		String (50)	General		User Def2
fedidn	*\\\\\\\\\\	String (64)	Financial	[Encrypted Field]	Federal ID No
steidn		String (20)	Financial		State ID No
resnum		String (30)	Financial		Resale No
actnum		String (30)	Financial		Account No
licnum		String (30)	Financial		License No
intrnl		Numeric	Financial	0-No;1=Yes	Internal Vendor
prt199	**	Numeric	Financial	US Edition: 0-Undetermined; 1-Nonemployee Comp; 2-Rent; 3-Attorney; 4-Interest; 5-Medical; 6-Dividends; 7-No 1099 Non-US: 0-Undetermined; 1-Nonemployee Comp; 2-Rent; 3-Attorney; 4-Interest; 5-No 1099	1099 Type
elc199		Numeric	Financial	0-No;1=Yes	Aatrix Electronic 1099 Consent
eml199		String (75)	Financial		Aatrix Email Recipient
dscrte		Numeric (3,2)	Invoice Defaults		Discount Rate
dscdte		String (6)	Invoice Defaults	##DY,##TH or ##MO	Discount Terms
duedte		String (6)	Invoice Defaults	##DY,##TH or ##MO	Due Terms
cmprte		Numeric (3,2)	Invoice Defaults		Work Comp Rate
utxrte		Numeric (3,2)	Invoice Defaults		Use Tax Rate
lgrdft	**	Numeric	Invoice Defaults		Ledger Account
cdedft	**	Numeric (12,3)	Invoice Defaults		Cost Code
typdft	**	Numeric	Invoice Defaults	0-None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Udf6; 7-Udf7; 8-Udf8; 9-Udf9	Cost Type
stsdft	**	Numeric	Invoice Defaults	0-None; 1-Open; 2-Review; 3-Dispute	Invoice Status
wrndft	**	Numeric	Invoice Defaults	0-None; 1-Warn if no PO; 2-Warn if no Subcontract; 4-Require PO; 5-Require Subcontract; 6-Require PO or Subcontract	PO Warning
utwarn	**	Numeric	Invoice Defaults	0-None; 1-Warn if no Use Tax; 2-Require Use Tax	Use Tax Warning
hotlst		Numeric	Invoice Defaults	0-No;1=Yes	Put on the Hot List
dupchk		Numeric	Invoice Defaults	0-No;1=Yes	Allow duplicate invoice no
sepchk		Numeric	Invoice Defaults	0-No;1=Yes	Separate check for each invoice
rfptyp	**	Numeric	Other Defaults		RFP Type
rfpdsc		String (50)	Other Defaults		RFP Description
ordtyp	**	Numeric	Other Defaults		Purchase Order Type
orddsc		String (50)	Other Defaults		Purchase Order Description
contyp	**	Numeric	Other Defaults		Subcontract Type
condsc		String (50)	Other Defaults		Subcontract Description
dirdep		Numeric	ACH Pmt	0-No;1=Yes	Enable ACH payment
prente	**	Numeric	ACH Pmt	1=Prenote;2=10 day wait;3=Active;4=Inactive	ACH Account Status
acttyp	**	Numeric	ACH Pmt	1=Checking;2=Savings	ACH Account Type
rtnmbr		String (9)	ACH Pmt		ACH Routing No
bnkact		String (64)	ACH Pmt		ACH Bank Account No
acheml		String (75)	ACH Pmt		ACH Email Rec To
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

*\\ Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF

Go To 7-1 Company Information
Click Options, then Database Security Encryption
Select \"OFF\"

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"e735f5a4-5055-4fbd-9cd1-6860593697c3"},{"name":"AP_VENDOR","id":"f4586a07-ab33-4d02-88d1-6d4056d4d84a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AR 4-4 Vendor Create] Update Existing Vendors

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header	201701	Vendor No
vndnme		String (75)	Header	Capital Ventures	Vendor Name
shtnme		String (30)	Header	Cap Vent	Vendor Short Name
vndtyp	**	Numeric	Header		Vendor Type
ownnme		String (50)	General	John Biggins	Owner Name
addrs1		String (50)	General		Vendor Addr 1
addrs2		String (50)	General		Vendor Addr 2
ctynme		String (50)	General		Vendor City
state_		String (2)	General		Vendor State
zipcde		String (10)	General		Vendor Zip
minsts	**	Numeric	General	0=None;1=Minority Owned;2=Women Owned;3=Disabled Vet	Minority Type
taxdst	**	Numeric	General		Tax District
usrdf1		String (50)	General		User Def1
usrdf2		String (50)	General		User Def2
fedidn	*\\\\\\\\\\	String (64)	Financial	[Encrypted Field]	Federal ID No
steidn		String (20)	Financial		State ID No
resnum		String (30)	Financial		Resale No
actnum		String (30)	Financial		Account No
licnum		String (30)	Financial		License No
intrnl		Numeric	Financial	0-No;1=Yes	Internal Vendor
prt199	**	Numeric	Financial	US Edition: 0-Undetermined; 1-Nonemployee Comp; 2-Rent; 3-Attorney; 4-Interest; 5-Medical; 6-Dividends; 7-No 1099 Non-US: 0-Undetermined; 1-Nonemployee Comp; 2-Rent; 3-Attorney; 4-Interest; 5-No 1099	1099 Type
elc199		Numeric	Financial	0-No;1=Yes	Aatrix Electronic 1099 Consent
eml199		String (75)	Financial		Aatrix Email Recipient
dscrte		Numeric (3,2)	Invoice Defaults		Discount Rate
dscdte		String (6)	Invoice Defaults	##DY,##TH or ##MO	Discount Terms
duedte		String (6)	Invoice Defaults	##DY,##TH or ##MO	Due Terms
cmprte		Numeric (3,2)	Invoice Defaults		Work Comp Rate
utxrte		Numeric (3,2)	Invoice Defaults		Use Tax Rate
lgrdft	**	Numeric	Invoice Defaults		Ledger Account
cdedft	**	Numeric (12,3)	Invoice Defaults		Cost Code
typdft	**	Numeric	Invoice Defaults	0-None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Udf6; 7-Udf7; 8-Udf8; 9-Udf9	Cost Type
stsdft	**	Numeric	Invoice Defaults	0-None; 1-Open; 2-Review; 3-Dispute	Invoice Status
wrndft	**	Numeric	Invoice Defaults	0-None; 1-Warn if no PO; 2-Warn if no Subcontract; 4-Require PO; 5-Require Subcontract; 6-Require PO or Subcontract	PO Warning
utwarn	**	Numeric	Invoice Defaults	0-None; 1-Warn if no Use Tax; 2-Require Use Tax	Use Tax Warning
hotlst		Numeric	Invoice Defaults	0-No;1=Yes	Put on the Hot List
dupchk		Numeric	Invoice Defaults	0-No;1=Yes	Allow duplicate invoice no
sepchk		Numeric	Invoice Defaults	0-No;1=Yes	Separate check for each invoice
rfptyp	**	Numeric	Other Defaults		RFP Type
rfpdsc		String (50)	Other Defaults		RFP Description
ordtyp	**	Numeric	Other Defaults		Purchase Order Type
orddsc		String (50)	Other Defaults		Purchase Order Description
contyp	**	Numeric	Other Defaults		Subcontract Type
condsc		String (50)	Other Defaults		Subcontract Description
dirdep		Numeric	ACH Pmt	0-No;1=Yes	Enable ACH payment
prente	**	Numeric	ACH Pmt	1=Prenote;2=10 day wait;3=Active;4=Inactive	ACH Account Status
acttyp	**	Numeric	ACH Pmt	1=Checking;2=Savings	ACH Account Type
rtnmbr		String (9)	ACH Pmt		ACH Routing No
bnkact		String (64)	ACH Pmt		ACH Bank Account No
acheml		String (75)	ACH Pmt		ACH Email Rec To
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

*\\ Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF

Go To 7-1 Company Information
Click Options, then Database Security Encryption
Select \"OFF\"

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"f4586a07-ab33-4d02-88d1-6d4056d4d84a"},{"name":"AP_VENDOR_CONTACT","id":"67b6a49a-6e64-4763-9b76-8f0ca4dc19b0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": 1,\r\n \"cntnme\": \"John Doe\",\r\n \"jobttl\": \"President\",\r\n \"phnnum\": \"5551234567\",\r\n \"phnext\": \"123\",\r\n \"e_mail\": \"jdoe@examle.com\",\r\n \"cllphn\": \"5551234567\",\r\n \"faxnum\": \"5551234567\",\r\n \"othphn\": \"5551234567\",\r\n \"othdsc\": \"5551234567\",\r\n \"ntetxt\": \"Notes\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AP_VENDOR_CONTACT?action_type=I","description":"

[AP 4-4 Vendor Contacts] Create New Vendor Contacts (can also be used to update Vendor Contacts)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Contacts	231	Vendor No
cntnme	Required	String (50)	Contacts	John Doe	Contact Name
jobttl		String (50)	Contacts	President	Job Title
phnnum		String (14)	Contacts		Phone No
phnext		String (6)	Contacts		Phone Ext
e_mail		String (75)	Contacts	jdoe@gmail.com	Email
cllphn		String (14)	Contacts		Cell Phone
faxnum		String (14)	Contacts		Fax No
othphn		String (14)	Contacts		Other Phone
othdsc		String (50)	Contacts		Other Description
ntetxt		Text	Contacts		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR_CONTACT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"67b6a49a-6e64-4763-9b76-8f0ca4dc19b0"},{"name":"AP_VENDOR_CONTACT","id":"e5f62af5-a6d4-4acf-ad33-7eabe78f478c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AP 4-4 Vendor Contacts] Update Existing Vendor Contacts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Contacts	231	Vendor No
cntnme	Required	String (50)	Contacts	John Doe	Contact Name
jobttl		String (50)	Contacts	President	Job Title
phnnum		String (14)	Contacts		Phone No
phnext		String (6)	Contacts		Phone Ext
e_mail		String (75)	Contacts	jdoe@gmail.com	Email
cllphn		String (14)	Contacts		Cell Phone
faxnum		String (14)	Contacts		Fax No
othphn		String (14)	Contacts		Other Phone
othdsc		String (50)	Contacts		Other Description
ntetxt		Text	Contacts		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR_CONTACT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"e5f62af5-a6d4-4acf-ad33-7eabe78f478c"},{"name":"AP_VENDOR_CERTIFICATE","id":"8f777545-f51d-41ed-a934-2bb4d8134a47","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": \"123\",\r\n \"dscrpt\": \"Certificate Description\",\r\n \"expdte\": \"2021-01-01\",\r\n \"jobnum\": \"1000\",\r\n \"dtercv\": \"\",\r\n \"cntwrn\": \"\",\r\n \"stppay\": \"\",\r\n \"ntetxt\": \"Notes\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AP_VENDOR_CERTIFICATE?action_type=I","description":"

[AP 4-4 Vendor Certificates] Create New Vendor Certificates (can also be used to update Vendor Certificates)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Reference	Data Type	Tab	Example	Description
recnum	Required	Numeric	Certificates	231	Vendor No
dscrpt	Required (1)	String (50)	Certificates	General Liability	Certificate Description
expdte	Required	Date	Certificates	YYYY-MM-DD	Expires
jobnum	**	Numeric	Certificates		Job No
dtercv		Date	Certificates	YYYY-MM-DD	Date Received
cntwrn		String (1)	Certificates	Y=Yes; N=No	Warning
stppay		String (1)	Certificates	Y=Yes; N=No	Stop Pay
ntetxt		Text	Certificates		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) The description field is treated as a key field and therefore considered to be unique and not used more than once. When updating records the \"Description\" is used in determining which row to update. If the description is not found then a new record will be created if \"Inserts\" are allowed

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR_CERTIFICATE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"8f777545-f51d-41ed-a934-2bb4d8134a47"},{"name":"AP_VENDOR_CERTIFICATE","id":"a4ebf901-2d1a-4a99-80b4-fa9974c66f55","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[AP 4-4 Vendor Certificates] Update Existing Vendor Certificates

Query Parameters
None

Body Parameters:

Field Name	Reference	Data Type	Tab	Example	Description
recnum	Required	Numeric	Certificates	231	Vendor No
dscrpt	Required (1)	String (50)	Certificates	General Liability	Certificate Description
expdte	Required	Date	Certificates	YYYY-MM-DD	Expires
jobnum	**	Numeric	Certificates		Job No
dtercv		Date	Certificates	YYYY-MM-DD	Date Received
cntwrn		String (1)	Certificates	Y=Yes; N=No	Warning
stppay		String (1)	Certificates	Y=Yes; N=No	Stop Pay
ntetxt		Text	Certificates		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR_CERTIFICATE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"a4ebf901-2d1a-4a99-80b4-fa9974c66f55"},{"name":"AP_VENDOR_PAYMENT","id":"68c6bdf8-34f2-4741-bfb2-67b81e830503","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"vndnum\":\"123\",\r\n \"invreftype\": \"1\",\r\n \"invrefno\":\"111\",\r\n \"amtpad\":\"20.00\",\r\n \"pmtdte\":\"2022-01-21\",\r\n \"pmttyp\":\"C\",\r\n \"chknum\":\"123\",\r\n \"lgract\":\"1000\",\r\n \"subact\":\"\",\r\n \"dsctkn\":\"\",\r\n \"postprd\":\"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/AP_VENDOR_PAYMENT","description":"

[AP 4-3 Vendor Payments] Vendor Payments

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Example	Description
filetype	Required	APVENDPMT	APVENDPMT	(File Type Code)
vndnum	Required **	Numeric	123	Vendor No
invreftype	Required (1)	Numeric	1=Recnum; 2=Invoice No	Invoice Ref Type
invrefno	Required **	String (20)		Invoice Ref No
amtpad	Required (2)	Numeric	800.00	Payment Amount
pmtdte	Required	Date	yyyy-mm-dd	Payment/Check Date
pmttyp	Required	String (2)	C = Check; CC = Credit Card; OB = Online Banking	Payment Type
chknum	Required (3)	String (20)	4857	Check No / Tran Ref No
lgract	Required ** (4)	Numeric		Cash Account / Credit Card Issuer
subact	** (5)	Numeric		Credit Card Account
dsctkn	(2)	Numeric		Discount Taken
postprd	(6)	Date	yyyy-mm-dd	Posting Period

\n\n

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

The Invoice Ref Type determines if the invoice number or the invoice recnum will be used to determine the correct invoice to pay. By default, Sage does not enforce a unique invoice number, so if the invoice number is going to be used then the invoice number for each each vendor must be unique
If Payment Type = 'OB' then Payment Amount and Discount Taken must be positive values
Must be unique across Vendor Numbers
If Payment Type = 'C' or 'OB' enter the bank account from which the cash should be credited, and if 'CC' then enter the Credit Card Issuer Account
Required if Payment Type = 'CC', otherwise it should be left blank
If posting period is left blank then the payment date will be used as the posting period

\n","urlObject":{"protocol":"https","path":["API","AP_VENDOR_PAYMENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"68c6bdf8-34f2-4741-bfb2-67b81e830503"}],"id":"84d8590f-a8a9-45f4-a626-05b110f1999a","_postman_id":"84d8590f-a8a9-45f4-a626-05b110f1999a","description":""},{"name":"5 - Payroll","item":[{"name":"PR_DAILY_PAYROLL","id":"a5e7d3eb-a3af-42b7-9063-f74bc843d8e8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\"paydte\":\"2019-10-15\",\r\n \"empnum\":\"11\",\r\n \"dscrpt\":\"work job 1\",\r\n \"wrkord\":\"\",\r\n \"jobnum\":\"2017008\",\r\n \"loctax\":\"\",\r\n \"crtfid\":\"N\",\r\n \"phsnum\":\"\",\r\n \"cstcde\":\"\",\r\n \"paytyp\":\"1\",\r\n \"paygrp\":\"\",\r\n \"payrte\":\"18\",\r\n \"payhrs\":\"4\",\r\n \"pcerte\":\"\",\r\n \"pieces\":\"\",\r\n \"cmpcde\":\"8810\",\r\n \"dptmnt\":\"\",\r\n \"eqpnum\":\"\",\r\n \"opreqp\":\"\",\r\n \"eqpunt\":\"\",\r\n \"oprhrs\":\"\",\r\n \"stdhrs\":\"\",\r\n \"idlhrs\":\"\",\r\n \"bllunt\":\"\",\r\n \"oprbll\":\"\",\r\n \"stdbll\":\"\",\r\n \"idlbll\":\"\",\r\n \"usrdf1\":\"\",\r\n \"absnce\":\"\",\r\n \"ntetxt\":\"\"\r\n },\r\n {\"paydte\":\"2019-10-15\",\r\n \"empnum\":\"11\",\r\n \"dscrpt\":\"work job 2\",\r\n \"wrkord\":\"\",\r\n \"jobnum\":\"2017009\",\r\n \"loctax\":\"\",\r\n \"crtfid\":\"N\",\r\n \"phsnum\":\"\",\r\n \"cstcde\":\"\",\r\n \"paytyp\":\"1\",\r\n \"paygrp\":\"\",\r\n \"payrte\":\"18\",\r\n \"payhrs\":\"4\",\r\n \"pcerte\":\"\",\r\n \"pieces\":\"\",\r\n \"cmpcde\":\"8810\",\r\n \"dptmnt\":\"\",\r\n \"eqpnum\":\"\",\r\n \"opreqp\":\"\",\r\n \"eqpunt\":\"\",\r\n \"oprhrs\":\"\",\r\n \"stdhrs\":\"\",\r\n \"idlhrs\":\"\",\r\n \"bllunt\":\"\",\r\n \"oprbll\":\"\",\r\n \"stdbll\":\"\",\r\n \"idlbll\":\"\",\r\n \"usrdf1\":\"\",\r\n \"absnce\":\"\",\r\n \"ntetxt\":\"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PR_DAILY_PAYROLL","description":"

[PR 5-5-1 Daily Payroll] Create Daily Payroll Records

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Example	Description
paydte		Date	yyyy-mm-dd	Time Entry Date
empnum	**	Numeric		Employee No
dscrpt		String (50)		Description
wrkord	**	String (20)		Service WO Recnum
jobnum	**	Numeric	Blank=derived from Service WO	Job No
loctax	**	Numeric		Local Payroll Tax
crtfid		String (1)	Y=yes;N=no;Blank=derived from Job	Certified Payroll
phsnum	**	Numeric		Phase No
cstcde	**	Numeric (12,3)	Blank=derived from Service WO type's corresponding Cost Code	Cost Code
paytyp	**	Numeric		Pay Type
paygrp	**	Numeric	Blank=derived from Employee	Pay Group
payrte		Numeric (6,4)	Blank=derived from Employee based on pay type	Pay Rate
payhrs		Numeric (5,2)		Pay Hours
pcerte		Numeric (6,4)		Pieces Rate
pieces		Numeric (8,2)		Pieces Units
cmpcde	**	Numeric	Blank=derived from Employee	Workers Comp Code
dptmnt	**	Numeric	Blank=derived from Job	Department
eqpnum	**	Numeric		Equip Repaired No
opreqp	**	Numeric		Operated Equipment
eqpunt		Numeric	1=Hours; 2=Days; 3=Weeks; 4=Months; 5=Miles	Equip Cost Unit Type
oprhrs		Numeric (5,2)		Equip Operated Cost Units
stdhrs		Numeric (5,2)		Equip Standby Cost Units
idlhrs		Numeric (5,2)		Equip Idle Cost Units
bllunt		Numeric	1=Hours; 2=Days; 3=Weeks; 4=Months; 5=Miles	Equip Rental Unit type
oprbll		Numeric (6,2)		Equip Operated Rental Units
stdbll		Numeric (6,2)		Equip Standby Rental Units
idlbll		Numeric (6,2)		Equip Idle Rental Units
usrdf1		String (50)		User Defined
absnce	**	Numeric		Absence
ntetxt		Text		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PR_DAILY_PAYROLL"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"a5e7d3eb-a3af-42b7-9063-f74bc843d8e8"},{"name":"PR_EMPLOYEE","id":"bf242a95-d148-43b0-9606-49265cf4192d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\":\"23\",\r\n \"fstnme\":\"Jack\",\r\n \"lstnme\":\"Kramer\",\r\n \"status\":1,\r\n \"emptyp\":1,\r\n \"gender\":1,\r\n \"wrkcmp\":8810,\r\n \"paypst\":1,\r\n \"taxste\":\"CA\",\r\n \"payprd\":1,\r\n \"midini\":\"\",\r\n \"addrs1\":\"\",\r\n \"addrs2\":\"\",\r\n \"ctynme\":\"\",\r\n \"state_\":\"\",\r\n \"zipcde\":\"\",\r\n \"phnnum\":\"\",\r\n \"pagnum\":\"\",\r\n \"faxnum\":\"\",\r\n \"cllphn\":\"\",\r\n \"homnum\":\"\",\r\n \"e_mail\":\"\",\r\n \"usrdf1\":\"\",\r\n \"usrdf2\":\"\",\r\n \"eqpnum\":null,\r\n \"mrtsts\":0,\r\n \"hertge\":1,\r\n \"empcmp\":1,\r\n \"uninum\":\"\",\r\n \"loctax\":null,\r\n \"locwrk\":null,\r\n \"socsec\":\"\",\r\n \"dtebth\":null,\r\n \"dtehre\":null,\r\n \"dteina\":null,\r\n \"lstrse\":null,\r\n \"i9verf\":0,\r\n \"crtrpt\":0,\r\n \"exmovr\":0,\r\n \"hiract\":0,\r\n \"eeoprx\":0,\r\n \"paycls\":1,\r\n \"paygrp\":null,\r\n \"payrt1\":null,\r\n \"payrt2\":null,\r\n \"payrt3\":null,\r\n \"salary\":null,\r\n \"comisn\":null,\r\n \"advdue\":null,\r\n \"accsck\":null,\r\n \"sckrte\":null,\r\n \"sckmth\":null,\r\n \"sckmax\":null,\r\n \"sckbeg\":null,\r\n \"accvac\":null,\r\n \"vacrte\":null,\r\n \"vacmth\":null,\r\n \"vacmax\":null,\r\n \"vacbeg\":null,\r\n \"retchk\":0,\r\n \"sckchk\":0,\r\n \"w_2elc\":0,\r\n \"dirdep\":0,\r\n \"prente\":0,\r\n \"acttyp\":1,\r\n \"rtnmbr\":\"\",\r\n \"actnum\":\"\",\r\n \"rtetyp\":0,\r\n \"depamt\":\"\",\r\n \"prent2\":0,\r\n \"acttp2\":1,\r\n \"rtnmb2\":\"\",\r\n \"actnm2\":\"\",\r\n \"rtetp2\":0,\r\n \"dp2amt\":\"\",\r\n \"prent3\":0,\r\n \"acttp3\":1,\r\n \"rtnmb3\":\"\",\r\n \"actnm3\":\"\",\r\n \"rtetp3\":0,\r\n \"dp3amt\":\"\",\r\n \"prent4\":0,\r\n \"acttp4\":1,\r\n \"rtnmb4\":\"\",\r\n \"actnm4\":\"\",\r\n \"rtetp4\":0,\r\n \"dp4amt\":\"\",\r\n \"pyreml\":\"\",\r\n \"w4_1_c\":null,\r\n \"w4_2_c\":null,\r\n \"w4_3__\":null,\r\n \"w4_4_a\":null,\r\n \"w4_4_b\":null,\r\n \"w4_4_c\":null,\r\n \"w4_dte\":null,\r\n \"ntetxt\":\"\"\r\n }\r\n]\r\n\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PR_EMPLOYEE?action_type=I","description":"

[PR 5-2-1 Employees] Create New Employees (can also be used to update Employees)

Query Parameters

action_type: I (1) (Optional)

Available Options [I=Insert Only (default); IA = Insert with Auto Numbering (2); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

(2) Recnum must be omitted from payload or set to blank

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Employee No
fstnme	Required(I)	String (50)	Header		First Name
lstnme	Required(I)	String (50)	Header		Last Name
status	Required(I) **	Numeric	Header	1=Current; 2=On leave; 3=Quit; 4=Laid off; 5=Terminated; 6=On probation; 7=Deceased; 8=Retired	Status
emptyp	Required(I) **	Numeric	Human Resources	1=Reg full-time; 2=Reg part-time; 3=Temp full-time; 4=Temp part-time	Employment Type
gender	Required(I) **	Numeric	Human Resources	1=Male;2=Female;3=Nonbinary	Gender
wrkcmp	Required(I) **	Numeric	Human Resources		Workers Comp Code
paypst	Required(I) **	Numeric	Human Resources		Position
taxste	Required(I) **	String (2)	Human Resources	CA	Tax State
payprd	Required(I) **	Numeric	Compensation	1=Weekly; 2=Bi-weekly; 3=Semi-monthly; 4=Monthly; 5=Quarterly; 6=Semi-annual; 7=Annual	Pay Period
ncknme		String (50)	Header		Nickname
midini		String (1)	Header		Middle Initial
admacs		Numeric		1=yes;0=No	Require Payroll Admin Access
addrs1		String (50)	General		Addr 1
addrs2		String (50)	General		Addr 2
ctynme		String (50)	General		City
state_		String (2)	General		State
zipcde		String (10)	General		Zip
phnnum		String (14)	General		Phone No
pagnum		String (14)	General		Pager No
faxnum		String (14)	General		Fax No
cllphn		String (14)	General		Cell No
homnum		String (14)	General		Home No
e_mail		String (75)	General		Email
usrdf1		String (50)	General		User Def 1
usrdf2		String (50)	General		User Def 2
eqpnum	**	Numeric	General		Equipment
mrtsts	**	Numeric	Human Resources	0=Unassigned; 1=Single; 2=Married; 3=Single with dependents; 4=Married with dependents	Benefit Status
hertge	**	Numeric	Human Resources	0=Decline to state; 1=White (not Hispanic/Latino); 2=Black/African American; 3=Hispanic/Latino (any race); 4=Asian; 5=American Indian/Alaska Native; 6=Native hawaiian/Pacific Islander; 7=Two or more races	Heritage
empcmp		Numeric	Human Resources	1=yes;0=No	Always use employee comp code
uninum	**	Numeric	Human Resources		Union
loctax	**	Numeric	Human Resources		Residence Locale Tax
locwrk	**	Numeric	Human Resources		Work Locale Tax
soccde	**	Numeric	Human Resources		Standard Occupation Classification code
socsec		String (44)	Human Resources	[Encrypted Field]	Social Security *\\\\\\\\\\
dtebth		Date	Human Resources	yyyy-mm-dd	Birth Date
dtehre		Date	Human Resources	yyyy-mm-dd	Hire Date
dteina		Date	Human Resources	yyyy-mm-dd	Inactive Date
lstrse		Date	Human Resources	yyyy-mm-dd	Last Raise
i9verf	**	Numeric	Human Resources	1=yes;0=No	I-9 verified
crtrpt	**	Numeric	Human Resources	1=yes;0=No	Exempt from certified reporting
exmovr	**	Numeric	Human Resources	1=yes;0=No	Exempt from overtime pay
hiract	**	Numeric	Human Resources	1=yes;0=No	Eligible under HIRE Act of 2010
eeoprx	**	Numeric	Human Resources	1=yes;0=No	Use proxy hours for EEO-1 reporting
paycls	**	Numeric	Compensation	0=Unassigned; 1=Hourly; 2=Shift; 3=Day; 4=Week; 5=Salary; 6=Piece; 7=Commission	Pay Classification
paygrp	**	Numeric	Compensation		Paygroup
payrt1		Numeric (6,4)	Compensation		Regular Hourly Rate
payrt2		Numeric (6,4)	Compensation		Overtime Hourly Rate
payrt3		Numeric (6,4)	Compensation		Premium Hourly Rate
salary		Numeric (10,2)	Compensation		Salary
comisn		Numeric (3,0)	Compensation		Commission %
advdue		Numeric (10,2)	Compensation		Advanced Due
accsck		Numeric (4,2)	Compensation		Sick Accrued
sckrte		Numeric (5,5)	Compensation		Sick Accrual Rate
sckmth	**	Numeric	Compensation	1-Per period; 2-Per hour	Sick Accrual Method
sckmax		Numeric (4,2)	Compensation		Sick Accrual Max
sckbeg		Numeric (10,0)	Compensation		Sick Last Yr Carry Forward
accvac		Numeric (4,2)	Compensation		Vacation Accrued
vacrte		Numeric (5,5)	Compensation		Vacation Accrual Rate
vacmth	**	Numeric	Compensation	1-Per period; 2-Per hour	Vacation Accrual Method
vacmax		Numeric (4,2)	Compensation		Vacation Accrual Max
vacbeg		Numeric (4,2)	Compensation		Vacation Last Yr Carry Forward
retchk		Numeric	Compensation	1=yes;0=No	Retirement Plan
sckchk		Numeric	Compensation	1=yes;0=No	Third-Party Sick Pay
w_2elc		Numeric	Compensation	1=yes;0=No	Consent for Electronic W-2
dirdep		Numeric	Direct Deposit	1=yes;0=No	Enable Direct Deposit
prente	**	Numeric	Direct Deposit	0=None;1=Prenote;2=10 day wait;3=Active;4=Inactive	Dir Dep - Status 1
acttyp	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 1
rtnmbr		String (9)	Direct Deposit		Dir Dep - Route No 1
actnum		String (64)	Direct Deposit		Dir Dep - Acct No 1
rtetyp	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 1
depamt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 1
prent2	**	Numeric	Direct Deposit	0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive	Dir Dep - Status 2
acttp2	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 2
rtnmb2		String (9)	Direct Deposit		Dir Dep - Route No 2
actnm2		String (64)	Direct Deposit		Dir Dep - Acct No 2
rtetp2	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 2
dp2amt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 2
prent3	**	Numeric	Direct Deposit	0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive	Dir Dep - Status 3
acttp3	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 3
rtnmb3		String (9)	Direct Deposit		Dir Dep - Route No 3
actnm3		String (64)	Direct Deposit		Dir Dep - Acct No 3
rtetp3	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 3
dp3amt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 3
prent4	**	Numeric	Direct Deposit	0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive	Dir Dep - Status 4
acttp4	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 4
rtnmb4		String (9)	Direct Deposit		Dir Dep - Route No 4
actnm4		String (64)	Direct Deposit		Dir Dep - Acct No 4
rtetp4	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 4
dp4amt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 4
pyreml		String (75)	Direct Deposit		Direct Deposit Email
w4_1_c	**	Numeric	W-4 Information	0-Not set up; 1-Single or Married Filing separately; 2-Married filing jointly (or Qualifying widow(er)); 3-Head of household	W-4 - Step 1 Personal Information
w4_2_c	**	Numeric	W-4 Information	1=yes;0=No	W-4 - Step 2 Multiple Jobs or Spouse Works
w4_3__		Numeric (10,2)	W-4 Information		W-4 - Step 3 Claim Dependants Total Amount
w4_4_a		Numeric (10,2)	W-4 Information		W-4 - Step 4(a) - Other Income
w4_4_b		Numeric (10,2)	W-4 Information		W-4 - Step 4(b) - Deductions
w4_4_c		Numeric (10,2)	W-4 Information		W-4 - Step 4(c) - Extra Witholding
w4_dte		Date	W-4 Information	yyyy-mm-dd	W-4 - Step 5 - Date Signed
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only
** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

*\\ Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF

Go To 7-1 Company Information
\n
Click Options, then Database Security Encryption
\n
Select \"OFF\"
\n

\n","urlObject":{"protocol":"https","path":["API","PR_EMPLOYEE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"bf242a95-d148-43b0-9606-49265cf4192d"},{"name":"PR_EMPLOYEE","id":"0d693bf2-b34c-4f4c-92df-6f9a048a74ee","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[PR 5-2-1 Employees] Update Existing Employee Records

Query Parameters

None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Employee No
fstnme		String (50)	Header		First Name
lstnme		String (50)	Header		Last Name
status	**	Numeric	Header	1=Current; 2=On leave; 3=Quit; 4=Laid off; 5=Terminated; 6=On probation; 7=Deceased; 8=Retired	Status
emptyp	**	Numeric	Human Resources	1=Reg full-time; 2=Reg part-time; 3=Temp full-time; 4=Temp part-time	Employment Type
gender	**	Numeric	Human Resources	1=Male;2=Female;3=Nonbinary	Gender
wrkcmp	**	Numeric	Human Resources		Workers Comp Code
paypst	**	Numeric	Human Resources		Position
taxste	**	String (2)	Human Resources	CA	Tax State
payprd	**	Numeric	Compensation	1=Weekly; 2=Bi-weekly; 3=Semi-monthly; 4=Monthly; 5=Quarterly; 6=Semi-annual; 7=Annual	Pay Period
ncknme		String (50)	Header		Nickname
midini		String (1)	Header		Middle Initial
admacs		Numeric		1=yes;0=No	Require Payroll Admin Access
addrs1		String (50)	General		Addr 1
addrs2		String (50)	General		Addr 2
ctynme		String (50)	General		City
state_		String (2)	General		State
zipcde		String (10)	General		Zip
phnnum		String (14)	General		Phone No
pagnum		String (14)	General		Pager No
faxnum		String (14)	General		Fax No
cllphn		String (14)	General		Cell No
homnum		String (14)	General		Home No
e_mail		String (75)	General		Email
usrdf1		String (50)	General		User Def 1
usrdf2		String (50)	General		User Def 2
eqpnum	**	Numeric	General		Equipment
mrtsts	**	Numeric	Human Resources	0=Unassigned; 1=Single; 2=Married; 3=Single with dependents; 4=Married with dependents	Benefit Status
hertge	**	Numeric	Human Resources	0=Decline to state; 1=White (not Hispanic/Latino); 2=Black/African American; 3=Hispanic/Latino (any race); 4=Asian; 5=American Indian/Alaska Native; 6=Native hawaiian/Pacific Islander; 7=Two or more races	Heritage
empcmp		Numeric	Human Resources	1=yes;0=No	Always use employee comp code
uninum	**	Numeric	Human Resources		Union
loctax	**	Numeric	Human Resources		Residence Locale Tax
locwrk	**	Numeric	Human Resources		Work Locale Tax
soccde	**	Numeric	Human Resources		Standard Occupation Classification code
socsec		String (44)	Human Resources	[Encrypted Field]	Social Security *\\\\\\
dtebth		Date	Human Resources	yyyy-mm-dd	Birth Date
dtehre		Date	Human Resources	yyyy-mm-dd	Hire Date
dteina		Date	Human Resources	yyyy-mm-dd	Inactive Date
lstrse		Date	Human Resources	yyyy-mm-dd	Last Raise
i9verf	**	Numeric	Human Resources	1=yes;0=No	I-9 verified
crtrpt	**	Numeric	Human Resources	1=yes;0=No	Exempt from certified reporting
exmovr	**	Numeric	Human Resources	1=yes;0=No	Exempt from overtime pay
hiract	**	Numeric	Human Resources	1=yes;0=No	Eligible under HIRE Act of 2010
eeoprx	**	Numeric	Human Resources	1=yes;0=No	Use proxy hours for EEO-1 reporting
paycls	**	Numeric	Compensation	0=Unassigned; 1=Hourly; 2=Shift; 3=Day; 4=Week; 5=Salary; 6=Piece; 7=Commission	Pay Classification
paygrp	**	Numeric	Compensation		Paygroup
payrt1		Numeric (6,4)	Compensation		Regular Hourly Rate
payrt2		Numeric (6,4)	Compensation		Overtime Hourly Rate
payrt3		Numeric (6,4)	Compensation		Premium Hourly Rate
salary		Numeric (10,2)	Compensation		Salary
comisn		Numeric (3,0)	Compensation		Commission %
advdue		Numeric (10,2)	Compensation		Advanced Due
accsck		Numeric (4,2)	Compensation		Sick Accrued
sckrte		Numeric (5,5)	Compensation		Sick Accrual Rate
sckmth	**	Numeric	Compensation	1-Per period; 2-Per hour	Sick Accrual Method
sckmax		Numeric (4,2)	Compensation		Sick Accrual Max
sckbeg		Numeric (10,0)	Compensation		Sick Last Yr Carry Forward
accvac		Numeric (4,2)	Compensation		Vacation Accrued
vacrte		Numeric (5,5)	Compensation		Vacation Accrual Rate
vacmth	**	Numeric	Compensation	1-Per period; 2-Per hour	Vacation Accrual Method
vacmax		Numeric (4,2)	Compensation		Vacation Accrual Max
vacbeg		Numeric (4,2)	Compensation		Vacation Last Yr Carry Forward
retchk		Numeric	Compensation	1=yes;0=No	Retirement Plan
sckchk		Numeric	Compensation	1=yes;0=No	Third-Party Sick Pay
w_2elc		Numeric	Compensation	1=yes;0=No	Consent for Electronic W-2
dirdep		Numeric	Direct Deposit	1=yes;0=No	Enable Direct Deposit
prente	**	Numeric	Direct Deposit	0=None;1=Prenote;2=10 day wait;3=Active;4=Inactive	Dir Dep - Status 1
acttyp	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 1
rtnmbr		String (9)	Direct Deposit		Dir Dep - Route No 1
actnum		String (64)	Direct Deposit		Dir Dep - Acct No 1
rtetyp	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 1
depamt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 1
prent2	**	Numeric	Direct Deposit	0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive	Dir Dep - Status 2
acttp2	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 2
rtnmb2		String (9)	Direct Deposit		Dir Dep - Route No 2
actnm2		String (64)	Direct Deposit		Dir Dep - Acct No 2
rtetp2	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 2
dp2amt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 2
prent3	**	Numeric	Direct Deposit	0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive	Dir Dep - Status 3
acttp3	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 3
rtnmb3		String (9)	Direct Deposit		Dir Dep - Route No 3
actnm3		String (64)	Direct Deposit		Dir Dep - Acct No 3
rtetp3	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 3
dp3amt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 3
prent4	**	Numeric	Direct Deposit	0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive	Dir Dep - Status 4
acttp4	**	Numeric	Direct Deposit	1=Checking;2=Savings	Dir Dep - Acct Type 4
rtnmb4		String (9)	Direct Deposit		Dir Dep - Route No 4
actnm4		String (64)	Direct Deposit		Dir Dep - Acct No 4
rtetp4	**	Numeric	Direct Deposit	0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check	Dir Dep - Rate Type 4
dp4amt		Numeric (3,0)	Direct Deposit		Dir Dep - Amount 4
pyreml		String (75)	Direct Deposit		Direct Deposit Email
w4_1_c	**	Numeric	W-4 Information	0-Not set up; 1-Single or Married Filing separately; 2-Married filing jointly (or Qualifying widow(er)); 3-Head of household	W-4 - Step 1 Personal Information
w4_2_c	**	Numeric	W-4 Information	1=yes;0=No	W-4 - Step 2 Multiple Jobs or Spouse Works
w4_3__		Numeric (10,2)	W-4 Information		W-4 - Step 3 Claim Dependants Total Amount
w4_4_a		Numeric (10,2)	W-4 Information		W-4 - Step 4(a) - Other Income
w4_4_b		Numeric (10,2)	W-4 Information		W-4 - Step 4(b) - Deductions
w4_4_c		Numeric (10,2)	W-4 Information		W-4 - Step 4(c) - Extra Witholding
w4_dte		Date	W-4 Information	yyyy-mm-dd	W-4 - Step 5 - Date Signed
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only
** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

*\\ Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF

Go To 7-1 Company Information
\n
Click Options, then Database Security Encryption
\n
Select \"OFF\"
\n

\n","urlObject":{"protocol":"https","path":["API","PR_EMPLOYEE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;IA=Insert with Auto Numbering;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"0d693bf2-b34c-4f4c-92df-6f9a048a74ee"},{"name":"PR_EMPLOYEE_CALC","id":"6156c440-aa88-48f8-a7ee-1c8f4ee5b4c0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n\t{\r\n \"recnum\":\"11\",\r\n \"clcnum\":\"26\",\r\n \"active\":\"Y\",\r\n \"dedrte\":\"25.50\",\r\n \"dedmax\":\"0\",\r\n \"mrtsts\":\"1\",\r\n \"allows\":\"0\",\r\n \"addall\":\"0\",\r\n \"tblnum\":\"0\",\r\n \"addste\":\"0\",\r\n \"offset\":\"0\"\r\n\t}\r\n]\r\n\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PR_EMPLOYEE_CALC_CREATE?action_type=I","description":"

[PR 5-2-1 Employee Calculations] Create New Employee Calculation Records (can also be used to update Employee Calculation Records)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required **	Numeric	Calculations		Employee No
clcnum	Required **	Numeric	Calculations		Payroll Calc No
active		String (1)	Calculations	Y=Yes;N=No (Default=Y)	Active
dedrte		Numeric (6,4)	Calculations		Rate
dedmax		Numeric (10,4)	Calculations		Maximum
mrtsts	**	Numeric	Calculations	1=Single; 2=Married; 3=Head of Household; 4=Married/Separate; 5=Married/Joint	Marital Status
allows		Numeric	Calculations		Standard Allowances
addall		Numeric	Calculations		Additional Allowances
tblnum		Numeric	Calculations	value between 1-99	Table#
addste		Numeric (5,2)	Calculations		Additional Withholdings
offset		Numeric (3,2)	Calculations		Offset

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PR_EMPLOYEE_CALC_CREATE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"6156c440-aa88-48f8-a7ee-1c8f4ee5b4c0"},{"name":"PR_EMPLOYEE_CALC","id":"49f1ccec-a41f-4715-9093-7451f483356b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[PR 5-2-1 Employee Calculations] Update Existing Employee Calculation Records

Query Parameters
action_type: I (1)

(1) If the param is not specified the default will be \"I\" for instert new records only. Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required **	Numeric	Calculations		Employee No
clcnum	Required **	Numeric	Calculations		Payroll Calc No
active		String (1)	Calculations	Y=Yes;N=No (Default=Y)	Active
dedrte		Numeric (6,4)	Calculations		Rate
dedmax		Numeric (10,4)	Calculations		Maximum
mrtsts	**	Numeric	Calculations	1=Single; 2=Married; 3=Head of Household; 4=Married/Separate; 5=Married/Joint	Marital Status
allows		Numeric	Calculations		Standard Allowances
addall		Numeric	Calculations		Additional Allowances
tblnum		Numeric	Calculations	value between 1-99	Table#
addste		Numeric (5,2)	Calculations		Additional Withholdings
offset		Numeric (3,2)	Calculations		Offset

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PR_EMPLOYEE_CALC_CREATE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"49f1ccec-a41f-4715-9093-7451f483356b"},{"name":"PR_PAYROLL_RECORD","id":"0438a264-cf4e-4cd3-8b3c-9cc0e6ffa93c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"empnum\": \"7\",\r\n \"strprd\": \"2019-10-07\",\r\n \"payprd\": \"2019-10-13\",\r\n \"chknum\": \"0000\",\r\n \"chkdte\": \"2019-10-13\",\r\n \"paytyp\": \"1\",\r\n \"qtrnum\": \"4\",\r\n \"taxste\": \"CA\",\r\n \"dirdep\": \"\",\r\n \"salary\": \"\",\r\n \"payrt1\": \"\",\r\n \"payrt2\": \"\",\r\n \"payrt3\": \"\",\r\n \"ntetxt\": \"\",\r\n \"prdetail\": [\r\n {\r\n \"dtewrk\": \"2019-10-15\",\r\n \"dscrpt\": \"job site framing\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"2017008\",\r\n \"eqpnum\": \"\",\r\n \"loctax\": \"\",\r\n \"crtfid\": \"\",\r\n \"phsnum\": \"\",\r\n \"cstcde\": \"2120.000\",\r\n \"paytyp\": \"1\",\r\n \"paygrp\": \"\",\r\n \"payrte\": \"\",\r\n \"hrswrk\": \"8\",\r\n \"pcerte\": \"\",\r\n \"pieces\": \"\",\r\n \"cmpcde\": \"8810\",\r\n \"dptmnt\": \"\",\r\n \"absnce\": \"\",\r\n \"usrdf1\": \"\",\r\n \"ntetxt\": \"\"\r\n },\r\n {\r\n \"dtewrk\": \"2019-10-16\",\r\n \"dscrpt\": \"general tasks\",\r\n \"wrkord\": \"\",\r\n \"jobnum\": \"\",\r\n \"eqpnum\": \"\",\r\n \"loctax\": \"\",\r\n \"crtfid\": \"\",\r\n \"phsnum\": \"\",\r\n \"cstcde\": \"\",\r\n \"paytyp\": \"1\",\r\n \"paygrp\": \"\",\r\n \"payrte\": \"24\",\r\n \"hrswrk\": \"8\",\r\n \"pcerte\": \"\",\r\n \"pieces\": \"\",\r\n \"cmpcde\": \"8810\",\r\n \"dptmnt\": \"\",\r\n \"absnce\": \"\",\r\n \"usrdf1\": \"\",\r\n \"ntetxt\": \"\"\r\n }\r\n ],\r\n \"calcdetail\": [\r\n {\r\n \"clcnum\": 12,\r\n \"amount\": 98\r\n },\r\n {\r\n \"clcnum\": 30,\r\n \"amount\": 25\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PR_PAYROLL_RECORD?allow_duplicates=N","description":"

[PR 5-2-2 Payroll Record] Creates a Payroll Record

Query Parameters

allow_duplicates: N (1)

(1) this is the parameter to control whether or not an error is thrown if duplicate pay period checks are being inserted. The default value is \"N\" if the param is not specified

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
empnum	Required (1) **	Numeric	Header		Employee No
strprd	Required	Date	Header	yyyy-mm-dd	Period Start
payprd	Required (1)	Date	Header	yyyy-mm-dd	Period End
chknum	Required (1)	String (20)	Header	If no check enter '0000'	Check No
chkdte	Required (1)	Date	Header	yyyy-mm-dd	Check Date
paytyp	Required **	Numeric	Header	1=Regular; 2=Bonus; 3=Hand Computed; 4=Startup; 5=Advance; 6=Third Party	Payroll Type
qtrnum	Required **	Numeric	Header	1,2,3 or 4	Quarter
taxste	Required	String (2)	Header	Blank = Emp Setup	State
dirdep	(2)	Numeric	Header	1=True;0=False;Blank=Emp Setup	Direct Deposit
salary		Numeric (10,2)	Header	Blank = Emp Setup	Salary
payrt1		Numeric (6,4)	Header	Blank = Emp Setup	Reg Hrly Rate
payrt2		Numeric (6,4)	Header	Blank = Emp Setup	OT Hrly Rate
payrt3		Numeric (6,4)	Header	Blank = Emp Setup	Premium Hrly Rate
ntetxt		Text	Header		Notes
prdetail[]
dtewrk	Required	Date	Timecard		Work Date
dscrpt		String (50)	Timecard		Line Description
wrkord	** (4)	String (20)	Timecard		Service WO No
jobnum	(3) (4) **	Numeric	Timecard	Blank = derived from Service Order No	Job No
eqpnum	(3) **	Numeric	Timecard		Equip Repaired No
loctax	**	Numeric	Timecard	Blank = derived from Employee	Local Payroll Tax
crtfid		String (1)	Timecard	Y=yes; N=no; Blank=derived from Job	Certified Payroll
phsnum	**	Numeric	Timecard		Phase No
cstcde	(4) **	Numeric (12,3)	Timecard	Blank = Derived from Service Order No type's corresponding Cost Code	Cost Code
paytyp	Required (5) (6) **	Numeric	Timecard		Pay Type
paygrp	**	Numeric	Timecard	Blank = derived from Employee	Pay Group
payrte		Numeric (6,4)	Timecard	Blank = derived from Pay Group first if exists, then Employee second, based on pay type	Pay Rate
hrswrk	(5)	Numeric (5,2)	Timecard	Required if System Pay Type is 1 through 6	Hours Worked
pcerte	(6)	Numeric (6,4)	Timecard	Required if System Pay Type = 7	Pieces Rate
pieces	(6)	Numeric (8,2)	Timecard	Required if System Pay Type = 7	Pieces Units
cmpcde	Required **	Numeric		Blank = derived from Cost Code first if Employee 'Always use employee comp code' is unchecked, otherwise derived from Employee	Workers Comp Code
dptmnt	**	Numeric		Blank = derived from Job first, Employee Position second	Department
absnce	**	Numeric	Timecard		Absence
usrdf1		String (50)	Timecard		Userdefined
ntetxt		Text	Timecard		Notes
calcdetail[]
clcnum	Required (7) **	Numeric	Calculations		Payroll Calc No
amount	Required	Numeric (10,2)	Calculations		Amount

\n\n

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

(1) Employee Number, Pay Period, Check Number and Check Date must be unique within a single file

(2) If marked as True then Direct Deposits must be activated for the respective employee, otherwise the entry will be rejected, If left \"Blank\" the direct deposit flag will be derived from the Employee Setup Record

(3) Either a Job No or Equip Repaired No may be entered but not both

(4) Cost Code is Required if a Job Number or Service Order is specified. If Service Order is specified and the cost code is blank the cost code will be derived from the Service Order

(5) Hours Worked is required if System Pay Type is 1 through 6

(6) Pieces Rate and Pieces Units are required if System Pay Type = 7

(7) Payroll Calc No must be unique across Employee No (empnum)

\n","urlObject":{"protocol":"https","path":["API","PR_PAYROLL_RECORD"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

Allows duplicate pay period checks

\n","type":"text/plain"},"key":"allow_duplicates","value":"N"}],"variable":[]}},"response":[],"_postman_id":"0438a264-cf4e-4cd3-8b3c-9cc0e6ffa93c"}],"id":"82d146ba-63b6-439a-ba05-5d3574e6ce4a","event":[{"listen":"prerequest","script":{"id":"5e55aebd-25d0-4a0f-8b46-45dbfae61125","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"6d61553e-c44e-4b0e-a3c7-0b66c6bc2c0f","type":"text/javascript","exec":[""]}}],"_postman_id":"82d146ba-63b6-439a-ba05-5d3574e6ce4a","description":""},{"name":"6 - Project Management","item":[{"name":"PJ_BUDGET","id":"36f82a38-409d-457f-83b8-21125484b7f1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"lckedt\": 0,\r\n \"setbdgt\": 0,\r\n \"recnum\": 2019001,\r\n \"phsnum\": 0,\r\n \"cstcde\": \"2010.000\",\r\n \"hrsbdg\": 1.00,\r\n \"matbdg\": 10.00,\r\n \"labbdg\": 10.00,\r\n \"eqpbdg\": 10.00,\r\n \"subbdg\": 10.00,\r\n \"othbdg\": 10.00,\r\n \"usrcs6\": 10.00,\r\n \"usrcs7\": 10.00,\r\n \"usrcs8\": 10.00,\r\n \"usrcs9\": 10.00,\r\n \"estunt\": 10.00,\r\n \"usrdf1\": \"User defined string\",\r\n \"ntetxt\": \"Notes\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_BUDGET","description":"

[PJ 6-2 Budgets] Create Budgets

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
lckedt	Required	Numeric		1=Yes;0=No (1)	Lock Edit
setbdgt	Required	Numeric		1=Yes;0=No (1)	Set Budget
recnum	Required **	Numeric			Job No
phsnum	**	Numeric			Phase No
cstcde	Required **	Numeric (9,3)			Cost Code
hrsbdg		Numeric (10,2)			Hours
matbdg		Numeric (10,2)			Material
labbdg		Numeric (10,2)			Labor
eqpbdg		Numeric (10,2)			Equipment
subbdg		Numeric (10,2)			Subcontract
othbdg		Numeric (10,2)			Other
usrcs6		Numeric (10,2)			User Def 6
usrcs7		Numeric (10,2)			User Def 7
usrcs8		Numeric (10,2)			User Def 8
usrcs9		Numeric (10,2)			User Def 9
estunt		Numeric (8,4)			No Units
usrdf1		String (50)			User Defined
ntetxt		Text			Notes

\n\n \n \n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PJ_BUDGET"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"36f82a38-409d-457f-83b8-21125484b7f1"},{"name":"PJ_COST_CODE","id":"21b90c7f-5fdd-4dbe-931f-c41bbf48175a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": \"2010.000\",\r\n \"cdenme\": \"Interior Demolition\",\r\n \"divnum\": 6,\r\n \"untdsc\": \"abc\",\r\n \"cmpcde\": 5645,\r\n \"maxwge\": 25.00,\r\n \"cmpcd2\": 5697,\r\n \"dptnum\": null,\r\n \"ntetxt\": \"Notes\",\r\n \"inactv\": \"N\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_COSTCODE","description":"

[PJ 6-5 Cost Codes] Create Cost Codes

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric(9,3)		2010.000	Cost Code
cdenme	Required	String (50)		Interior Demolition	Cost Code Name
divnum	Required **	Numeric			Division
untdsc		String (10)			Unit Desc
cmpcde	**	Numeric			Comp Code 1
maxwge		Numeric(3,2)			Max Wage
cmpcd2	**	Numeric			Comp Code 2
dptnum	**	Numeric			Department
ntetxt		TEXT			Notes
inactv		String (1)		Y=Yes;N=No	Inactive

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PJ_COSTCODE"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"21b90c7f-5fdd-4dbe-931f-c41bbf48175a"},{"name":"PJ_JOBCOST","id":"b67670a5-a8c3-4153-9e1f-3cfc38d496a2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"jobnum\": \"2015034\",\r\n \"trndte\": \"2020-10-10\",\r\n \"actgdte\": \"2020-10-10\",\r\n \"dscrpt\": \"test2\",\r\n \"trnnum\": \"1234a\",\r\n \"cstcde\": \"2050.000\",\r\n \"csttyp\": \"4\",\r\n \"cstamt\": \"6500.00\",\r\n \"phsnum\": \"0\",\r\n \"wrkord\": \"123\",\r\n \"empnum\": \"6\",\r\n \"paytyp\": \"1\",\r\n \"payrec\": \"193\",\r\n \"csthrs\": \"8.00\",\r\n \"pieces\": \"1.00\",\r\n \"grswge\": \"30.00\",\r\n \"vndnum\": \"231\",\r\n \"eqpnum\": \"19103\",\r\n \"eqptyp\": \"1\",\r\n \"eqpunt\": \"1\",\r\n \"eqpqty\": \"4.00\",\r\n \"bllsts\": \"1\",\r\n \"blgunt\": \"0\",\r\n \"blgqty\": \"4.00\",\r\n \"blgamt\": \"4444.00\",\r\n \"ovrrde\": \"1\",\r\n \"taxabl\": \"1\",\r\n \"ntetxt\": \"\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_JOBCOST","description":"

[PJ 6-3 Job Costs] Create Job Costs

Query Parameters
None

Body Parameters:

filetype	Required	PJJC	Header	PJJC	(File Type Code)
jobnum	Required [\\] *	Numeric	Header		Job Number
trndte	Required	Date	Header	yyyy-mm-dd	Transaction Date
actgdte	Required	Date	Header	yyyy-mm-dd	Accounting Posting Period
dscrpt	Required	String(50)	Header		Description
trnnum	Required [\\*]	String(20)	Header		Transaction Number
cstcde	Required **	Numeric	Header		Cost Code
csttyp	Required **	Numeric	Header	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=UDF6; 7=UDF7; 8=UDF8; 9=UDF9	Cost Type
cstamt		Numeric (9,2)	Header		Cost Amount
phsnum	[\\] *	Numeric	Header		Phase Number
wrkord	**	String(20)	Header		Work Order Number
empnum	**	Numeric	Employee / Vendor / Equipment		Employee Number
paytyp	**	Numeric	Employee / Vendor / Equipment		Pay Type
payrec	**	Numeric	Employee / Vendor / Equipment		Pay Record Number
csthrs		Numeric (5,2)	Employee / Vendor / Equipment		Hours
pieces		Numeric (9,2)	Employee / Vendor / Equipment		Pieces
grswge		Numeric (9,2)	Employee / Vendor / Equipment		Gross Wage
vndnum	**	Numeric	Employee / Vendor / Equipment		Vendor Number
eqpnum	**	Numeric	Employee / Vendor / Equipment		Equipment Number
eqptyp	**	Numeric	Employee / Vendor / Equipment	0-None;1-Operated;2-Standby;3-Idle	Equipment Type
eqpunt	**	Numeric	Employee / Vendor / Equipment	0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles	Equipment Unit
eqpqty		Numeric (5,2)	Employee / Vendor / Equipment		Equipment Quantity
bllsts	Required **	Numeric	Time and Materials Billing	1-Open;2-Not Billable;3-Billed	Billing Status
blgunt	**	Numeric	Time and Materials Billing	0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles;6-Mobilization;7-Not Billable	Billing Equipment Unit
blgqty		Numeric (5,2)	Time and Materials Billing		Billing Quantity
blgamt	(1)	Numeric (9,2)	Time and Materials Billing		Billing Amount
ovrrde		Numeric	Time and Materials Billing	1=Yes;0=No	Override Billing Amount
taxabl		Numeric	Time and Materials Billing	1=Yes;0=No	Subject to Sales Tax
ntetxt		Text	Header		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PJ_JOBCOST"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"b67670a5-a8c3-4153-9e1f-3cfc38d496a2"},{"name":"PJ_PURCHASE_ORDER","id":"dc7da983-dd27-47a7-a8a5-750c8fe3cb9b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"ordnum\":\"PO123\",\r\n \"vndnum\":\"302\",\r\n \"orddte\":\"2019-01-05\",\r\n \"dscrpt\":\"PO No 123\",\r\n \"status\":\"1\",\r\n \"ordtyp\":\"\",\r\n \"attion\":\"\",\r\n \"wrkord\":\"\",\r\n \"jobnum\":\"\",\r\n \"phsnum\":\"\",\r\n \"eqpmnt\":\"\",\r\n \"tsknum\":\"\",\r\n \"taxdst\":\"\",\r\n \"appdte\":\"\",\r\n \"schdte\":\"\",\r\n \"deldte\":\"\",\r\n \"delvia\":\"\",\r\n \"ordtrm\":\"30DY\",\r\n \"odrdby\":\"\",\r\n \"addrs1\":\"\",\r\n \"addrs2\":\"\",\r\n \"ctynme\":\"\",\r\n \"state_\":\"\",\r\n \"zipcde\":\"\",\r\n \"usrdf1\":\"\",\r\n \"usrdf2\":\"\",\r\n \"hotlst\":\"\",\r\n \"lckedt\":\"\",\r\n \"ntetxt\":\"\",\r\n \"podetail\":[\r\n {\r\n \"linnum\":\"1\",\r\n \"prtnum\":\"\",\r\n \"prtdsc\":\"Line 1 Desc\",\r\n \"untdsc\":\"\",\r\n \"linqty\":\"5\",\r\n \"linprc\":\"25\",\r\n \"currnt\":\"\",\r\n \"cancel\":\"\",\r\n \"cstcde\":\"\",\r\n \"csttyp\":\"\",\r\n \"invloc\":\"\",\r\n \"lgract\":\"\",\r\n \"subact\":\"\",\r\n \"usrdf1\":\"\",\r\n \"ntetxt\":\"\",\r\n \"taxabl\":\"Y\"\r\n },\r\n {\r\n \"linnum\":\"2\",\r\n \"prtnum\":\"\",\r\n \"prtdsc\":\"Line 2 Desc\",\r\n \"untdsc\":\"\",\r\n \"linqty\":\"10\",\r\n \"linprc\":\"50\",\r\n \"currnt\":\"\",\r\n \"cancel\":\"\",\r\n \"cstcde\":\"\",\r\n \"csttyp\":\"\",\r\n \"invloc\":\"\",\r\n \"lgract\":\"\",\r\n \"subact\":\"\",\r\n \"usrdf1\":\"\",\r\n \"ntetxt\":\"\",\r\n \"taxabl\":\"Y\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_PURCHASE_ORDER?action_type=I","description":"

[PJ 6-6-1 Purchase Order] Creates a Purchase Order Document

Query Parameters
action_type: I (1)

(1) If the param is not specified the default will be \"I\" for insert new records only. Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
ordnum	Required [\\\\\\*]	String (20)	Header		PO Number
vndnum	Required [\\\\\\] *	Numeric	Header		Vendor No
orddte	Required (I,B)	Date	Header	yyyy-mm-dd	PO Date
dscrpt	Required (I,B)	String (50)	Header		Description
status	Required (I,B) **	Numeric	Header	1-Open, 2-Review, 3-Dispute, 4-Closed, 5-Void, 6-Master	Status
ordtyp	** (1)	Numeric	Header		PO Type
attion		String (50)	Header		Attention
wrkord	** (2)	String (20)	Header		Work Order No
jobnum	** (2)	Numeric	Header		Job No
phsnum	**	Numeric	Header		Phase No
eqpmnt	**	Numeric	Header		Equipment No
tsknum		Numeric (11,3)	Header		Task No
taxdst		Numeric	Header		Tax District
appdte		Date	Header	yyyy-mm-dd	Approved Date
schdte		Date	Header	yyyy-mm-dd	Scheduled Date
deldte		Date	Header	yyyy-mm-dd	Delivery Date
delvia		String (60)	Header		Via
ordtrm		String (6)	Header	##DY,##TH or ##MO	Terms
odrdby	**	Numeric	Header		Ordered By
addrs1		String (50)	Header		Address 1
addrs2		String (50)	Header		Address 2
ctynme		String (50)	Header		City
state_		String (2)	Header		State
zipcde		String (10)	Header		Zip Code
usrdf1		String (50)	Header		User Def 1
usrdf2		String (50)	Header		User Def 2
hotlst		Numeric	Header		Hot List
lckedt		Numeric	Header		Lock Edit
ntetxt		Text	Header		Notes
podetail[]
linnum	[\\\\\\*] (3)	Numeric	Detail	1	Line No
prtnum	**	Numeric	Detail	0	Part No
prtdsc	Required (I,B)	String (75)	Detail		Line Description
untdsc		String (10)	Detail		Unit of Measure
linqty		Numeric (8,4)	Detail		Quantity
linprc		Numeric (9,6)	Detail		Price
rcvdte		Numeric (8,4)	Detail		To Date
currnt		Numeric (8,4)	Detail		Current
cancel		Numeric (8,4)	Detail		Canceled
cstcde	**	Numeric (12,3)	Detail		Cost Code
csttyp	**	Numeric	Detail		Cost Type
invloc	**	Numeric	Detail		Inventory Location
lgract	**	Numeric	Detail		Account
subact	**	Numeric	Detail		Subaccount
usrdf1		String (50)	Detail		User Defined
ntetxt		Text	Detail		Notes
taxabl		String (1)	Detail	Y-Yes, N-No or blank	Taxable

\n\n

Required(I,B) - required for Inserts and Both only

[*] Key Fields - the combination of theses fields must be unique

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor

(1) Leave blank for '0 - None'

(2) If a Work Order No is specified, Job No should be left blank as it will be derived from the Work Order

(3) Null/Empty = line no will be automatically derived; If specified line no must be unique based on the Key pair

\n","urlObject":{"protocol":"https","path":["API","PJ_PURCHASE_ORDER"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"dc7da983-dd27-47a7-a8a5-750c8fe3cb9b"},{"name":"PJ_PROPOSAL","id":"8c5ae158-b53e-48ee-9a6e-fb07b30158a0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"colshw\": 1,\r\n \"lckedt\": 0,\r\n \"hotlst\": 1,\r\n \"setprpsl\": 1,\r\n \"recnum\": 1,\r\n \"phsnum\": 0,\r\n \"cstcde\": \"1000.000\",\r\n \"dscrpt\": \"Description\",\r\n \"matprp\": 10.00,\r\n \"labprp\": 10.00,\r\n \"eqpprp\": 10.00,\r\n \"subprp\": 10.00,\r\n \"othprp\": 10.00,\r\n \"usrcs6\": 10.00,\r\n \"usrcs7\": 10.00,\r\n \"usrcs8\": 10.00,\r\n \"usrcs9\": 10.00,\r\n \"usrdf1\": \"User defined\",\r\n \"ntetxt\": \"Notes\"\r\n }\r\n]"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_PROPOSAL","description":"

[PJ 6-9 Proposals] Create Proposals

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
colshw	Required	Numeric		1=Cost Code;0=Bid Item (1)	Use Cost Code or Bid Item for proposal lines
lckedt	Required	Numeric		1=Yes;0=No (1)	Lock Edit
hotlst	Required	Numeric		1=Yes;0=No (1)	Hot List
setprpsl	Required	Numeric		1=Yes;0=No (1)	Set Proposal
recnum	Required **	Numeric			Job No
phsnum	**	Numeric			Phase No
cstcde	Required **	Numeric (9,3)			Cost Code
dscrpt		String (50)			Description
matprp		Numeric (10,2)			Material
labprp		Numeric (10,2)			Labor
eqpprp		Numeric (10,2)			Equipment
subprp		Numeric (10,2)			Subcontract
othprp		Numeric (10,2)			Other
usrcs6		Numeric (10,2)			User Def 6
usrcs7		Numeric (10,2)			User Def 7
usrcs8		Numeric (10,2)			User Def 8
usrcs9		Numeric (10,2)			User Def 9
usrdf1		String (50)			User Defined
ntetxt		Text			Notes

\n\n \n \n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PJ_PROPOSAL"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"8c5ae158-b53e-48ee-9a6e-fb07b30158a0"},{"name":"PJ_SUBCONTRACT","id":"1a792dfe-9760-4991-a4d6-b612482069a2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"ctcnum\": \"ABC123\",\r\n \"condte\": \"2019-01-01\",\r\n \"vndnum\": 111,\r\n \"jobnum\": 111,\r\n \"dscrpt\": \"Subcontract description\",\r\n \"phsnum\": 111,\r\n \"divnum\": 111,\r\n \"usrdf1\": \"User defined\",\r\n \"usrdf2\": \"User defined\",\r\n \"status\": 1,\r\n \"contyp\": 111,\r\n \"appdte\": \"2019-01-01\",\r\n \"orgstr\": \"2019-01-01\",\r\n \"orgfin\": \"2019-01-01\",\r\n \"strdte\": \"2019-01-01\",\r\n \"subcmp\": \"2019-01-01\",\r\n \"findte\": \"2019-01-01\",\r\n \"rtnrte\": 10.00,\r\n \"pmtbnd\": 10.00,\r\n \"prfbnd\": 10.00,\r\n \"hotlst\": 1,\r\n \"paysts\": 1,\r\n \"lckedt\": 1,\r\n \"ntetxt\": \"Notes\",\r\n \"lines\": [\r\n {\r\n \"ctcnum\": \"ABC123\",\r\n \"dscrpt\": \"Line description\",\r\n \"cstcde\": 111,\r\n \"csttyp\": 1,\r\n \"amount\": 10.00,\r\n \"gstsbj\": \"\",\r\n \"pstsbj\": \"\",\r\n \"hstsbj\": \"\",\r\n \"usrdf1\": \"User defined\",\r\n \"ntetxt\": \"Notes\"\r\n }\r\n ]\r\n }\r\n]"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_SUBCONTRACT","description":"

[PJ 6-7-1 Subcontracts] Create Subcontracts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Example	Description
ctcnum	Required	String (20)		Contract No
condte	Required	Date	yyyy-mm-dd	Subcontract Date
vndnum	Required **	Numeric		Vendor
jobnum	Required **	Numeric		Job No
dscrpt	Required	String (50)		Subcontract Description
phsnum	**	Numeric		Job Phase No
divnum	**	Numeric		Cost Division
usrdf1		String (50)		User Def 1
usrdf2		String (50)		User Def 2
status	**	Numeric	1-Bid;2-Refused;3-Contract;4-Current;5-Complete;6-Closed	Status
contyp	**	Numeric		Type
appdte		Date	yyyy-mm-dd	Approved Date
orgstr		Date	yyyy-mm-dd	Sched Start Date
orgfin		Date	yyyy-mm-dd	Sched End Date
strdte		Date	yyyy-mm-dd	Actual Start Date
subcmp		Date	yyyy-mm-dd	Subst Complete Date
findte		Date	yyyy-mm-dd	Actual Finish Date
rtnrte		Numeric (10,2)		Retention
pmtbnd		Numeric (10,2)		Bid Bond
prfbnd		Numeric (10,2)		Perf. Bond
hotlst		Numeric	1=Yes;0=No	Hot List
paysts		Numeric	1=Yes;0=No	Hold Payment
lckedt		Numeric	1=Yes;0=No	Lock Edit
ntetxt		Text		Notes
scdetail[]
dscrpt	Required	String (50)		Line Description
cstcde	Required **	Numeric(9,3)		Cost Code
csttyp	Required **	Numeric	1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf	Cost Type
amount		Numeric(10,2)		Line Amount
gstsbj		String (1)	Y or N for Canada; blank for US	Subject to GST (Canada)
pstsbj		String (1)	Y or N for Canada; blank for US	Subject to PST (Canada)
hstsbj		String (1)	Y or N for Canada; blank for US	Subject to HST (Canada)
usrdf1		String (50)		User Defined
ntetxt		Text		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","PJ_SUBCONTRACT"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"1a792dfe-9760-4991-a4d6-b612482069a2"},{"name":"PJ_CHANGE_ORDER","id":"79da90fa-3c43-4e98-9e2f-70b216bbe333","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"jobnum\": 2019009,\r\n \"chgnum\": \"CO-6\",\r\n \"chgdte\": \"2019-07-08\",\r\n \"dscrpt\": \"Test CO 3\",\r\n \"status\": 1,\r\n \"phsnum\": \"\",\r\n \"reason\": \"\",\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"pchord\": \"\",\r\n \"subdte\": \"2019-01-01\",\r\n \"aprdte\": \"2019-01-01\",\r\n \"invdte\": \"2019-01-01\",\r\n \"delreq\": \"\",\r\n \"dysdly\": \"\",\r\n \"chgtyp\": \"\",\r\n \"submto\": \"\",\r\n \"submby\": 4,\r\n \"hotlst\": 1,\r\n \"lckedt\": 1,\r\n \"upgrde\": 1,\r\n \"ntetxt\": \"\",\r\n \"prime_lines\": [\r\n {\r\n \"dscrpt\": \"prime line 1\",\r\n \"estamt\": \"100\",\r\n \"ovhmrk\": \"\",\r\n \"pftmrk\": \"\",\r\n \"reqprc\": \"100\",\r\n \"aprprc\": \"150\",\r\n \"cstcde\": \"2020.000\",\r\n \"csttyp\": \"4\",\r\n \"usrdf1\": \"\",\r\n \"ntetxt\": \"\"\r\n }],\r\n \"sub_lines\": [\r\n {\r\n \"dscrpt\": \"sub line 1\",\r\n \"chghrs\": \"\",\r\n \"chgunt\": \"\",\r\n \"bdgprc\": \"100\",\r\n \"vndnum\": \"231\",\r\n \"vndctc\": \"107\",\r\n \"ctclin\": \"1\",\r\n \"chgnum\": \"\",\r\n \"chgsts\": 1,\r\n \"chgdte\": \"\",\r\n \"cstcde\": \"2120.000\",\r\n \"csttyp\": \"4\",\r\n \"usrdf1\": \"\",\r\n \"ntetxt\": \"\"\r\n }]\r\n }\r\n]"},"url":"https://sage100cloudapi.eidynamics.com/API/PJ_CHANGE_ORDER","description":"

[PJ 6-4-1 Change Orders (Budget, Subcontract, Prime)] Create Change Orders (Budget, Subcontract, Prime)

Query Parameters
None

Body Parameters:

Field Name	Reference	Data Type	Tab	Example	Description
jobnum	Required **	Numeric	Header		Job No
chgnum	Required	String (20)	Header		CO Number
chgdte	Required	Date	Header	yyyy-mm-dd	CO Date
dscrpt	Required	String (50)	Header		CO Description
status	Required **	Numeric	Header	1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected	CO Status
phsnum	**	Numeric	Header		Job Phase No
reason		String (50)	Header		CO Reason
usrdf1		String (50)	Header		User Def 1
usrdf2		String (50)	Header		User Def 2
pchord		String (30)	Header		Client PO No
subdte		Date	Header	yyyy-mm-dd	Submitted Date
aprdte		Date	Header	yyyy-mm-dd	Approved Date
invdte		Date	Header	yyyy-mm-dd	Invoiced Date
delreq		Numeric	Header		Delay Request Days
dysdly		Numeric	Header		Delay Approved Days
chgtyp	**	Numeric	Header		Change Type
submto		String (50)	Header		Submitted To
submby	**	Numeric	Header		Submitted By
hotlst		Numeric	Header	1=Yes;0=No	Hot List
lckedt		Numeric	Header	1=Yes;0=No	Lock Edit
upgrde		Numeric	Header	1=Yes;0=No	Upgrade
ntetxt		Text	Header		Notes
prime_lines[]
dscrpt	Required	String (50)	Prime		Line Description
estamt		Numeric (10,2)	Prime		Estimated Amount
ovhmrk		Numeric (10,2)	Prime		O/H Rate
pftmrk		Numeric (10,2)	Prime		Profit Rate
reqprc	(1)	Numeric (10,2)	Prime		Requested
aprprc	Required	Numeric (10,2)	Prime		Approved Amount
cstcde	Required	Numeric(9,3)	Prime		Cost Code
csttyp	Required **	Numeric	Prime		Cost Type
usrdf1		String (50)	Prime		User Defined
ntetxt		Text	Prime		Notes
sub_lines[]
dscrpt	Required	String (50)	Subcontract		Line Description
chghrs		Numeric (6,2)	Subcontract		Budget Hours
chgunt		Numeric (8,4)	Subcontract		Budget Units
bdgprc		Numeric (8,4)	Subcontract		Budget Amount
vndnum	** (1)	Numeric	Subcontract		Vendor
vndctc	** (2)	Numeric	Subcontract		Subcontract
ctclin	** (3)	Numeric	Subcontract		Subcontract Line No
ctchgnum	(4)	String (20)	Subcontract		Change No
chgsts	** (5)	Numeric	Subcontract	1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected	Line Status
chgdte		Date	Subcontract		Line Change Date
cstcde	Required **	Numeric(9,3)	Subcontract		Cost Code
csttyp	Required **	Numeric	Subcontract		Cost Type
usrdf1		String (50)	Subcontract		User Defined
ntetxt		Text	Subcontract		Notes
ovhmrk		Numeric (5,2)	Subcontract		Overhead Rate

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

primes[]

(1) If O/H Rate or Profit Rate then Request Amt is Calced

subcontracts[]

(1) Vendor No is required if a subcontract is Entered

(2) Subcontract No is required if a vendor is Entered

(3) If a Subcontract No is entered and and a contract line is not entered a new line will be added to the contract

(4) Change No is required if a subcontract is Entered

(5) Change Status is required if a subcontract is Entered otherwise 0

\n","urlObject":{"protocol":"https","path":["API","PJ_CHANGE_ORDER"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"79da90fa-3c43-4e98-9e2f-70b216bbe333"}],"id":"bfff1cb7-68c4-45cf-976c-6e12757e7f81","_postman_id":"bfff1cb7-68c4-45cf-976c-6e12757e7f81","description":""},{"name":"8 - Equipment Management","item":[{"name":"EQ_EQUIPMENT_ALLOC","id":"ed8aab1d-8342-46d2-bf24-64ae66fb50fe","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"trnnum\": \"ABC123\",\r\n \"trndte\": \"2019-01-01\",\r\n \"actgdte\": \"2019-01-01\",\r\n \"dscrpt\": \"Description\",\r\n \"eqpnum\": 400,\r\n \"jobnum\": null,\r\n \"phsnum\": null,\r\n \"eqpmnt\": 1,\r\n \"cstcde\": \"1000.000\",\r\n \"cstoperqty\": 10.00,\r\n \"cstoperrt\": 10.00,\r\n \"cststdbyqty\": 10.00,\r\n \"cststdbyrt\": 10.00,\r\n \"cstidleqy\": 10.00,\r\n \"cstidlert\": 10.00,\r\n \"rntunittyp\": 1,\r\n \"rntoperqty\": 10.00,\r\n \"rntoperrt\": 10.00,\r\n \"rntstdbyqty\": 10.00,\r\n \"rntstdbyrt\": 10.00,\r\n \"rntidleqty\": 10.00,\r\n \"rntidlert\": 10.00\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/EQ_EQUIPMENT_ALLOC","description":"

[EQ 8-4 Equipment Allocations] Create Equipment Allocations

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Example	Description
trnnum	Required	String (20)		Transaction Jrnl No
trndte	Required	Date	yyyy-mm-dd	Transaction Date
actgdte	Required	Date	yyyy-mm-dd	Accounting Date
dscrpt	Required	String (50)		Transaction Desc
eqpnum	Required **	Numeric		Operated Equipment
jobnum	Required (1) **	Numeric		Job No
phsnum	**	Numeric		Phase No
eqpmnt	Required (1) (2) **	Numeric		Equip Repaired
cstcde	Required **	Numeric (9,3)		Cost Code
cstoperqty		Numeric (10,2)		Cost - 1 Operated Qty
cstoperrt	(3)	Numeric (10,2)		Cost - 1 Operated Unit Rate
cststdbyqty		Numeric (10,2)		Cost - 2 Standby Qty
cststdbyrt	(3)	Numeric (10,2)		Cost - 2 Standby Unit Rate
cstidleqy		Numeric (10,2)		Cost - 3 Idle Qty
cstidlert	(3)	Numeric (10,2)		Cost - 3 Idle Rate
rntunittyp	(3) **	Numeric (10,2)	1-Hours;2-Days;3-Weeks;4-Months;5-Miles	Rental - Unit Type
rntoperqty		Numeric (10,2)		Rental - Operated Qty
rntoperrt	(3)	Numeric (10,2)		Rental - Operated Rate
rntstdbyqty		Numeric (10,2)		Rental - Standby Qty
rntstdbyrt	(3)	Numeric (10,2)		Rental - Standby Rate
rntidleqty		Numeric (10,2)		Rental - Idle Qty
rntidlert	(3)	Numeric (10,2)		Rental - Idle Rate

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) Either Job or Equipment must be selected but not both

(2) If Equip Repaired is selected it can't be the same as the Operated Equipment

(3) If left blank or zero the rate will be derived from the equipment record

\n","urlObject":{"protocol":"https","path":["API","EQ_EQUIPMENT_ALLOC"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"ed8aab1d-8342-46d2-bf24-64ae66fb50fe"},{"name":"EQ_EQUIPMENT","id":"371a4c30-a759-417d-b1fd-89506d40753b","protocolProfileBehavior":{"disableBodyPruning":true,"disabledSystemHeaders":{"content-type":true}},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": 111,\r\n \"eqpnme\": \"Equipment description\",\r\n \"shtnme\": \"Equipment short name\",\r\n \"status\": 1,\r\n \"eqptyp\": 0,\r\n \"srlnum\": \"ABC123\",\r\n \"licnum\": \"ABC123\",\r\n \"pucnum\": \"ABC123\",\r\n \"usrdf1\": \"User defined\",\r\n \"usrdf2\": \"User defined\",\r\n \"lstloc\": \"Last location\",\r\n \"pchdte\": \"2019-01-01\",\r\n \"slddte\": \"2019-01-01\",\r\n \"orghrs\": 1.00,\r\n \"orgmls\": 1.00,\r\n \"ttlhrs\": 1.00,\r\n \"ttlmls\": 1.00,\r\n \"intact\": 6120,\r\n \"depact\": 6810,\r\n \"depmnt\": null,\r\n \"lontyp\": 0,\r\n \"lender\": 111,\r\n \"lonnum\": \"ABC123\",\r\n \"nxtpay\": \"2019-01-01\",\r\n \"intrte\": 10.00,\r\n \"paymnt\": 10.00,\r\n \"deprte\": 10.00,\r\n \"strdte\": \"2019-01-01\",\r\n \"enddte\": \"2019-01-01\",\r\n \"strval\": 10.00,\r\n \"endval\": 10.00,\r\n \"unttyp\": 1,\r\n \"estuse\": 10.00,\r\n \"insrnc\": 10.00,\r\n \"taxlic\": 10.00,\r\n \"inspct\": 10.00,\r\n \"storag\": 10.00,\r\n \"ovrhed\": 10.00,\r\n \"financ\": 10.00,\r\n \"cstcap\": 10.00,\r\n \"othcst\": 10.00,\r\n \"fuloil\": 10.00,\r\n \"oilchg\": 10.00,\r\n \"fluchg\": 10.00,\r\n \"mntcst\": 10.00,\r\n \"csttir\": 10.00,\r\n \"minrpr\": 10.00,\r\n \"othopr\": 10.00,\r\n \"oprcst\": 10.00,\r\n \"oprbll\": 10.00,\r\n \"dyopbl\": 10.00,\r\n \"wkopbl\": 10.00,\r\n \"mtopbl\": 10.00,\r\n \"idlcst\": 10.00,\r\n \"idlbll\": 10.00,\r\n \"dyidbl\": 10.00,\r\n \"wkidbl\": 10.00,\r\n \"mtidbl\": 10.00,\r\n \"stbcst\": 10.00,\r\n \"stbbll\": 10.00,\r\n \"dystbl\": 10.00,\r\n \"wkstbl\": 10.00,\r\n \"mtstbl\": 10.00,\r\n \"moblbl\": 10.00,\r\n \"ntetxt\": \"Notes\"\r\n }\r\n]"},"url":"https://sage100cloudapi.eidynamics.com/API/EQ_EQUIPMENT?action_type=I","description":"

[EQ 8-3 Equipment] Create New Equipment (can also be used to update Equipment)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Equip No
eqpnme	Required(I)	String (50)	Header		Equip Desc
shtnme	Required(I)	String (30)	Header		Equip Short Name
status	Required(I) **	Numeric	Header	1-Available;2-Under Repair;3-Out of Service;4-Sold	Status
eqptyp	**	Numeric	Header		Equip Type
srlnum		String (30)	General Info		Serial#
licnum		String (30)	General Info		License#
pucnum		String (30)	General Info		PUC#
usrdf1		String (50)	General Info		User Def1
usrdf2		String (50)	General Info		User Def2
lstloc		String (75)	General Info		Last Location
pchdte		Date	General Info	yyyy-mm-dd	Purchase Date
slddte		Date	General Info	yyyy-mm-dd	Sold Date
orghrs		Numeric (10,2)	General Info		Original Hours
orgmls		Numeric (10,2)	General Info		Original Miles
ttlhrs		Numeric (10,2)	General Info		Total Hours
ttlmls		Numeric (10,2)	General Info		Total Miles
intact	**	Numeric	Financial Info		Interest Exp Acct
depact	**	Numeric	Financial Info		Depreciation Exp Acct
depmnt	**	Numeric	Financial Info		Department
lontyp	**	Numeric	Financial Info	0-None;1-Amortized;2-Principal + Interest;3-Lease	Loan Type
lender	**	Numeric	Financial Info		Lender
lonnum		String (30)	Financial Info		Loan#
nxtpay		Date	Financial Info	yyyy-mm-dd	Loan Pay Date
intrte		Numeric (10,2)	Financial Info		Loan Interest Rate
paymnt		Numeric (10,2)	Financial Info		Loan Pmt Amt
deprte		Numeric (10,2)	Financial Info		Monthly Depreciation
strdte		Date	Cost Recov Wrksht	yyyy-mm-dd	Start Date
enddte		Date	Cost Recov Wrksht	yyyy-mm-dd	End Date
strval		Numeric (10,2)	Cost Recov Wrksht		Start Value
endval		Numeric (10,2)	Cost Recov Wrksht		Ending Value
unttyp	**	Numeric	Cost Recov Wrksht	1-Hours;2-Days;3-Weeks;4-Months;5-Miles	Est Use Unit type
estuse		Numeric (10,2)	Cost Recov Wrksht		Est Use Amount
insrnc		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Insurance
taxlic		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Tax and Lic
inspct		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Inspection
storag		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Storage
ovrhed		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Overhaul
financ		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Financing
cstcap		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Cost of Capital
othcst		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Other Costs
fuloil		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Fuel and Oil
oilchg		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Oil Change
fluchg		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Fluid Change
mntcst		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Maintenance
csttir		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Tires
minrpr		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Minor Repair
othopr		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Other Cost
oprcst		Numeric (10,2)	Cost and Bill Rates		Operated - Cost Rates
oprbll		Numeric (10,2)	Cost and Bill Rates		Operated - Bill Rates
dyopbl		Numeric (10,2)	Cost and Bill Rates		Operated - Daily
wkopbl		Numeric (10,2)	Cost and Bill Rates		Operated - Weekly
mtopbl		Numeric (10,2)	Cost and Bill Rates		Operated - Monthly
idlcst		Numeric (10,2)	Cost and Bill Rates		Idled - Cost Rates
idlbll		Numeric (10,2)	Cost and Bill Rates		Idled - Bill Rates
dyidbl		Numeric (10,2)	Cost and Bill Rates		Idled - Daily
wkidbl		Numeric (10,2)	Cost and Bill Rates		Idled - Weekly
mtidbl		Numeric (10,2)	Cost and Bill Rates		Idled - Monthly
stbcst		Numeric (10,2)	Cost and Bill Rates		Standby - Cost Rates
stbbll		Numeric (10,2)	Cost and Bill Rates		Standby - Bill Rates
dystbl		Numeric (10,2)	Cost and Bill Rates		Standby - Daily
wkstbl		Numeric (10,2)	Cost and Bill Rates		Standby - Weekly
mtstbl		Numeric (10,2)	Cost and Bill Rates		Standby - Monthly
moblbl		Numeric (10,2)	Cost and Bill Rates		Mobilization Billing Amt
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","EQ_EQUIPMENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"371a4c30-a759-417d-b1fd-89506d40753b"},{"name":"EQ_EQUIPMENT","id":"f3d0bd13-4a09-4f11-b7f7-aa5a845b3dd0","protocolProfileBehavior":{"disableBodyPruning":true,"disabledSystemHeaders":{"content-type":true}},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[EQ 8-3 Equipment] Update Existing Equipment

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Equip No
eqpnme		String (50)	Header		Equip Desc
shtnme		String (30)	Header		Equip Short Name
status	**	Numeric	Header	1-Available;2-Under Repair;3-Out of Service;4-Sold	Status
eqptyp	**	Numeric	Header		Equip Type
srlnum		String (30)	General Info		Serial#
licnum		String (30)	General Info		License#
pucnum		String (30)	General Info		PUC#
usrdf1		String (50)	General Info		User Def1
usrdf2		String (50)	General Info		User Def2
lstloc		String (75)	General Info		Last Location
pchdte		Date	General Info	yyyy-mm-dd	Purchase Date
slddte		Date	General Info	yyyy-mm-dd	Sold Date
orghrs		Numeric (10,2)	General Info		Original Hours
orgmls		Numeric (10,2)	General Info		Original Miles
ttlhrs		Numeric (10,2)	General Info		Total Hours
ttlmls		Numeric (10,2)	General Info		Total Miles
intact	**	Numeric	Financial Info		Interest Exp Acct
depact	**	Numeric	Financial Info		Depreciation Exp Acct
depmnt	**	Numeric	Financial Info		Department
lontyp	**	Numeric	Financial Info	0-None;1-Amortized;2-Principal + Interest;3-Lease	Loan Type
lender	**	Numeric	Financial Info		Lender
lonnum		String (30)	Financial Info		Loan#
nxtpay		Date	Financial Info	yyyy-mm-dd	Loan Pay Date
intrte		Numeric (10,2)	Financial Info		Loan Interest Rate
paymnt		Numeric (10,2)	Financial Info		Loan Pmt Amt
deprte		Numeric (10,2)	Financial Info		Monthly Depreciation
strdte		Date	Cost Recov Wrksht	yyyy-mm-dd	Start Date
enddte		Date	Cost Recov Wrksht	yyyy-mm-dd	End Date
strval		Numeric (10,2)	Cost Recov Wrksht		Start Value
endval		Numeric (10,2)	Cost Recov Wrksht		Ending Value
unttyp	**	Numeric	Cost Recov Wrksht	1-Hours;2-Days;3-Weeks;4-Months;5-Miles	Est Use Unit type
estuse		Numeric (10,2)	Cost Recov Wrksht		Est Use Amount
insrnc		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Insurance
taxlic		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Tax and Lic
inspct		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Inspection
storag		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Storage
ovrhed		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Overhaul
financ		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Financing
cstcap		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Cost of Capital
othcst		Numeric (10,2)	Cost Recov Wrksht		Cost of Own - Other Costs
fuloil		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Fuel and Oil
oilchg		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Oil Change
fluchg		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Fluid Change
mntcst		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Maintenance
csttir		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Tires
minrpr		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Minor Repair
othopr		Numeric (10,2)	Cost Recov Wrksht		Cost of Oper - Other Cost
oprcst		Numeric (10,2)	Cost and Bill Rates		Operated - Cost Rates
oprbll		Numeric (10,2)	Cost and Bill Rates		Operated - Bill Rates
dyopbl		Numeric (10,2)	Cost and Bill Rates		Operated - Daily
wkopbl		Numeric (10,2)	Cost and Bill Rates		Operated - Weekly
mtopbl		Numeric (10,2)	Cost and Bill Rates		Operated - Monthly
idlcst		Numeric (10,2)	Cost and Bill Rates		Idled - Cost Rates
idlbll		Numeric (10,2)	Cost and Bill Rates		Idled - Bill Rates
dyidbl		Numeric (10,2)	Cost and Bill Rates		Idled - Daily
wkidbl		Numeric (10,2)	Cost and Bill Rates		Idled - Weekly
mtidbl		Numeric (10,2)	Cost and Bill Rates		Idled - Monthly
stbcst		Numeric (10,2)	Cost and Bill Rates		Standby - Cost Rates
stbbll		Numeric (10,2)	Cost and Bill Rates		Standby - Bill Rates
dystbl		Numeric (10,2)	Cost and Bill Rates		Standby - Daily
wkstbl		Numeric (10,2)	Cost and Bill Rates		Standby - Weekly
mtstbl		Numeric (10,2)	Cost and Bill Rates		Standby - Monthly
moblbl		Numeric (10,2)	Cost and Bill Rates		Mobilization Billing Amt
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","EQ_EQUIPMENT"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"f3d0bd13-4a09-4f11-b7f7-aa5a845b3dd0"}],"id":"f1ef7094-9524-4cb1-a714-abd77c96975a","_postman_id":"f1ef7094-9524-4cb1-a714-abd77c96975a","description":""},{"name":"9 - Estimating","item":[{"name":"ES_PART","id":"ceefa84e-66ce-47cd-9668-1c12fa310760","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": 111,\r\n \"prtnme\": \"Part description\",\r\n \"prtunt\": \"ea\",\r\n \"alpnum\": \"ABC123\",\r\n \"prtcls\": 111,\r\n \"cstcde\": 111,\r\n \"csttyp\": 1,\r\n \"prttsk\": 111,\r\n \"mannme\": \"Manufacturer Name\",\r\n \"mannum\": \"ABC123\",\r\n \"msdsnm\": \"ABC123\",\r\n \"usrdf1\": \"User defined\",\r\n \"usrdf2\": \"User defined\",\r\n \"prtcst\": 10.00,\r\n \"lstupd\": \"2019-01-01\",\r\n \"mrkupr\": 1,\r\n \"prtbil\": 10.00,\r\n \"minord\": 1,\r\n \"pkgqty\": 1,\r\n \"prtwgt\": 1,\r\n \"labnum\": 111,\r\n \"labunt\": 1,\r\n \"stkitm\": 1,\r\n \"serinv\": 1,\r\n \"reqivt\": 1,\r\n \"dftloc\": 111,\r\n \"binnum\": \"ABC123\",\r\n \"reordr\": 1,\r\n \"srvprt\": 1,\r\n \"oemdur\": 1,\r\n \"ntetxt\": \"Notes\"\r\n }\r\n]"},"url":"https://sage100cloudapi.eidynamics.com/API/ES_PART?action_type=I","description":"

[EST 9-2 Parts] Create New Parts (can also be used to update Parts)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Part No
prtnme	Required(I)	String (75)	Header		Part Description
prtunt	Required(I)	String (10)	Header	i.e. ea, sf, lf, lb	Unit Type
alpnum		String (50)	Header		Alpha Part No
prtcls	**	Numeric	Header		Part Class
cstcde	**	Numeric (12,3)	Header		Cost Code
csttyp	**	Numeric	Header	1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf	Cost Type
prttsk	**	Numeric (11,3)	Header		Task No
mannme		String (50)	Header		Manufacturer
mannum		String (30)	Header		Manufacturer Part No
msdsnm		String (30)	Header		MSDS No
usrdf1		String (50)	Header		User Def1
usrdf2		String (50)	Header		User Def2
prtcst		Numeric (9,6)	Cost Bill Order		Default Cost
lstupd		Date	Cost Bill Order	yyyy-mm-dd	Last Updated
mrkupr		Numeric (4,2)	Cost Bill Order		Markup Pct
prtbil		Numeric (9,6)	Cost Bill Order		Billing Amount
minord		Numeric (10,2)	Cost Bill Order		Min Order Qty
pkgqty		Numeric (10,2)	Cost Bill Order		Package Qty
prtwgt		Numeric (10,2)	Cost Bill Order		Unit Weight
labnum	**	Numeric	Labor		Labor Part No
labunt		Numeric (9,6)	Labor		Labor Qty
stkitm		Numeric	Inventory	1=Yes;0=No	Stock Item
serinv		Numeric	Inventory	1=Yes;0=No	Serialized Item
reqivt		Numeric	Inventory	1=Yes;0=No	Required From Inv.
dftloc	**	Numeric	Inventory		Default Location No
binnum		String (10)	Inventory		Bin No
reordr		Numeric (10,2)	Inventory		Reorder Qty
srvprt		Numeric	Service Equip	1=Yes;0=No	Service Equip Item
oemdur		Numeric	Service Equip		OEM Warranty Duration
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","ES_PART"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"ceefa84e-66ce-47cd-9668-1c12fa310760"},{"name":"ES_PART","id":"27269bd8-021d-4e74-9af5-b20dc8b9a47d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[EST 9-2 Parts] Update Existing Parts

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required	Numeric	Header		Part No
prtnme		String (75)	Header		Part Description
prtunt		String (10)	Header	i.e. ea, sf, lf, lb	Unit Type
alpnum		String (50)	Header		Alpha Part No
prtcls	**	Numeric	Header		Part Class
cstcde	**	Numeric (12,3)	Header		Cost Code
csttyp	**	Numeric	Header	1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf	Cost Type
prttsk	**	Numeric (11,3)	Header		Task No
mannme		String (50)	Header		Manufacturer
mannum		String (30)	Header		Manufacturer Part No
msdsnm		String (30)	Header		MSDS No
usrdf1		String (50)	Header		User Def1
usrdf2		String (50)	Header		User Def2
prtcst		Numeric (9,6)	Cost Bill Order		Default Cost
lstupd		Date	Cost Bill Order	yyyy-mm-dd	Last Updated
mrkupr		Numeric (4,2)	Cost Bill Order		Markup Pct
prtbil		Numeric (9,6)	Cost Bill Order		Billing Amount
minord		Numeric (10,2)	Cost Bill Order		Min Order Qty
pkgqty		Numeric (10,2)	Cost Bill Order		Package Qty
prtwgt		Numeric (10,2)	Cost Bill Order		Unit Weight
labnum	**	Numeric	Labor		Labor Part No
labunt		Numeric (9,6)	Labor		Labor Qty
stkitm		Numeric	Inventory	1=Yes;0=No	Stock Item
serinv		Numeric	Inventory	1=Yes;0=No	Serialized Item
reqivt		Numeric	Inventory	1=Yes;0=No	Required From Inv.
dftloc	**	Numeric	Inventory		Default Location No
binnum		String (10)	Inventory		Bin No
reordr		Numeric (10,2)	Inventory		Reorder Qty
srvprt		Numeric	Service Equip	1=Yes;0=No	Service Equip Item
oemdur		Numeric	Service Equip		OEM Warranty Duration
ntetxt		Text	Header		Notes

\n\n

Required(I) - required for Inserts only

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","ES_PART"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"description":{"content":"

I=Insert Only;U=Update Only;B=Both

\n","type":"text/plain"},"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"27269bd8-021d-4e74-9af5-b20dc8b9a47d"},{"name":"ES_TAKEOFF","id":"43761ce3-bebf-455b-891f-c6d3adaf1ce3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"recnum\": 180,\r\n \"prtprc\": 0,\r\n \"itmnum\": 0,\r\n \"phsnum\": 0,\r\n \"lckedt\":1,\r\n \"asmnum\": 1,\r\n \"asmchk\": \"L\",\r\n \"prtnum\": 11,\r\n \"prtdsc\": \"Part description\",\r\n \"untdsc\": \"cm\",\r\n \"linqty\": 1,\r\n \"linprc\": 10.00,\r\n \"linlck\": \"L\",\r\n \"qtyfrm\": \"Quantity formula\",\r\n \"taxdst\": 111,\r\n \"ovhmrk\": 10.00,\r\n \"pftmrk\": 10.00,\r\n \"prmvnd\": 111,\r\n \"cstcde\": 2000.000,\r\n \"csttyp\": 1,\r\n \"tsknum\": 111.000,\r\n \"invloc\": 1,\r\n \"usrdf1\": \"User defined\",\r\n \"ntetxt\": \"Notes\",\r\n \"expnte\": \"Export notes\"\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/ES_TAKEOFF","description":"

[EST 9-5 Takeoffs] Create Takeoffs

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
recnum	Required (1)	Numeric	Header		Job No
prtprc	Required (1)	Numeric	Header	0=Default Cost;1=Billing Amt;2=Avg Cost;3=Lowest Vendor;4=Preferred Vendor	Part Cost Default
itmnum	**	Numeric	Details	Default 0 - None	Bid Item No
phsnum	**	Numeric	Details	Default 0 - None	Phase No
lckedt	(1)	Numeric	Details	0=No (default) 1=Yes	Lock Edit
asmnum	**	Numeric	Details		Assembly No
asmchk	**	String (1)	Details	L=Assembly;R=Assembly Labor;(Blank)= Part	Check Arrow Direction
prtnum	**	Numeric	Details		Part No
prtdsc		String (75)	Details		Part Description
untdsc		String (10)	Details		Unit of Measure
linqty		Numeric (10,4)	Details		Quantity
linprc		Numeric (9,6)	Details		Cost
linlck		String (1)	Details	L=Locked;(Blank)=Unlocked	Line Locked
qtyfrm		String (50)	Details		Quantity Formula
taxdst	**	Numeric	Details		Tax District
ovhmrk		Numeric (4,2)	Details		Overhead Rate
pftmrk		Numeric (4,2)	Details		Profit Rate
prmvnd	**	Numeric	Details		Vendor
cstcde	**	Numeric (11,3)	Details		Cost Code
csttyp	**	Numeric	Details	1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf	Cost Type
tsknum	**	Numeric (11,3)	Details		Scheduled Task No
invloc	**	Numeric	Details		Inventory Location
usrdf1		String (50)	Details		User Defined 1
ntetxt		Text	Details		Notes
expnte		Text	Details		Export Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

\n","urlObject":{"protocol":"https","path":["API","ES_TAKEOFF"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"43761ce3-bebf-455b-891f-c6d3adaf1ce3"}],"id":"8935207a-6d88-472b-b7c7-7f0d32a7f41e","_postman_id":"8935207a-6d88-472b-b7c7-7f0d32a7f41e","description":""},{"name":"11 - Service Receivables","item":[{"name":"SR_WORK_ORDER","id":"0c9c3e91-acc3-4c68-b045-c3a90e2e17f2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"clnnum\": \"220\",\r\n \"ordnum\": \"12345\",\r\n \"invnum\": \"abc-1\",\r\n \"orddte\": \"2019-05-15\",\r\n \"dscrpt\": \"service wo 12345\",\r\n \"status\": 7,\r\n \"invtyp\": 1,\r\n \"schdte\": \"2019-06-30\",\r\n \"jobnum\": null,\r\n \"lckedt\": 0,\r\n \"shpnte\": \"\",\r\n \"ntetxt\": \"\",\r\n \"dscavl\": null,\r\n \"depost\": null,\r\n \"locnum\": null,\r\n \"ctcnme\": \"\",\r\n \"phnnum\": \"\",\r\n \"addrs1\": \"\",\r\n \"addrs2\": \"\",\r\n \"ctynme\": \"\",\r\n \"state_\": \"\",\r\n \"zipcde\": \"\",\r\n \"srvgeo\": null,\r\n \"crsstr\": \"\",\r\n \"maploc\": \"\",\r\n \"rutnum\": null,\r\n \"usrdf1\": \"\",\r\n \"usrdf2\": \"\",\r\n \"clldte\": \"2019-01-01\",\r\n \"clltim\": \"12:34:56\",\r\n \"dspdte\": \"2019-01-01\",\r\n \"dsptim\": \"12:34:56\",\r\n \"schtim\": \"12:34:56\",\r\n \"schhrs\": \"\",\r\n \"strdte\": \"2019-01-01\",\r\n \"strtim\": \"12:34:56\",\r\n \"findte\": \"2019-01-01\",\r\n \"fintim\": \"12:34:56\",\r\n \"acthrs\": null,\r\n \"priort\": 5,\r\n \"empnum\": null,\r\n \"invdte\": \"2019-01-01\",\r\n \"duedte\": \"2019-01-01\",\r\n \"dscdte\": \"2019-01-01\",\r\n \"refnum\": \"\",\r\n \"invsrc\": null,\r\n \"pchord\": \"\",\r\n \"exmnum\": \"\",\r\n \"slspsn\": \"\",\r\n \"taxdst\": \"\",\r\n \"pmttyp\": 3,\r\n \"crdnum\": \"\",\r\n \"crdnme\": \"\",\r\n \"expdte\": \"2019-01-01\",\r\n \"constd\": \"2019-01-01\",\r\n \"conend\": \"2019-01-01\",\r\n \"bildte\": \"2019-01-01\",\r\n \"bilcyc\": 2,\r\n \"taxmrt\": null,\r\n \"txadmk\": null,\r\n \"taxovr\": null,\r\n \"taxlck\": 0,\r\n \"ntxmrt\": null,\r\n \"ntadmk\": null,\r\n \"ntxovr\": null,\r\n \"ntxlck\": 0,\r\n \"plcnum\": \"\",\r\n \"plcnme\": \"\",\r\n \"plcad1\": \"\",\r\n \"plcad2\": \"\",\r\n \"plccty\": \"\",\r\n \"plcphn\": \"\",\r\n \"plctyp\": \"\",\r\n \"dedabl\": null,\r\n \"cmpnme\": \"\",\r\n \"adjnme\": \"\",\r\n \"adjad1\": \"\",\r\n \"adjad2\": \"\",\r\n \"adjcty\": \"\",\r\n \"adjphn\": \"\",\r\n \"srvlin\": [\r\n {\r\n \"linnum\": null,\r\n \"asmnum\": null,\r\n \"asmchk\": \"L\",\r\n \"prtnum\": null,\r\n \"dscrpt\": \"item 1 desc\",\r\n \"untdsc\": \"\",\r\n \"prtqty\": 1,\r\n \"prtprc\": 100.00,\r\n \"tktnum\": null,\r\n \"curbll\": null,\r\n \"csttyp\": 1,\r\n \"slstax\": \"Y\",\r\n \"actnum\": \"5001\",\r\n \"subact\": null,\r\n \"invloc\": null,\r\n \"eqpnum\": null,\r\n \"usrdf1\": \"\",\r\n \"shpnte\": \"\",\r\n \"ntetxt\": \"\"\r\n }\r\n ],\r\n \"srvsch\": [\r\n {\r\n \"linnum\": null,\r\n \"empnum\": \"\",\r\n \"eqpnum\": \"\",\r\n \"vndnum\": \"\",\r\n \"priort\": 5,\r\n \"schdte\": \"2019-01-01\",\r\n \"schstr\": \"12:34:56\",\r\n \"schfin\": \"12:34:56\",\r\n \"esthrs\": \"\",\r\n \"tvltim\": \"\",\r\n \"actstr\": \"12:34:56\",\r\n \"findte\": \"2019-01-01\",\r\n \"actfin\": \"12:34:56\",\r\n \"acthrs\": \"\",\r\n \"bildte\": \"2019-01-01\",\r\n \"usrdf1\": \"\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/SR_WORK_ORDER?action_type=I","description":"

[SR 11-2 Service Work Order] Create New Service Work Orders (can also be used to update existing Service Work Orders)

Query Parameters
action_type: I (1) (Optional)

Available Options [I=Insert Only (default); U=Update Only; B=Both Insert and update]

(1) If the param is not specified the default will be \"I\" for inserting new records only.

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
clnnum	Required [\\\\\\] *	Numeric	Header		Client No
ordnum	Required [\\\\\\] *	String (20)	Header		Order No
invnum	Required(I)	String (20)	Header		Invoice No
orddte	Required(I)	Date	Header	yyyy-mm-dd	Order Date
dscrpt	Required(I)	String (75)	Header		Order Description
status	Required(I) ** (1)	Numeric	Header	6-Quote; 7-Work Order; 8-Completed; 9-Route; 10-Contact	Order Status
invtyp	Required(I) **	Numeric	Header		Order Type
schdte	Required(I)	Date	Dispatch	yyyy-mm-dd	Scheduled Date
jobnum	**	Numeric	Header		Job No
lckedt		Numeric	Header	0=No;1=Yes	Lock Edit
shpnte		Text	Header		Work Order Note
ntetxt		Text	Header		General Note
dscavl		Numeric (8,4)	Footer	25	Discount Available Percent
depost	(2)	Numeric (8,4)	Footer		Deposit Amount
locnum	**	Numeric	Location		Location No
ctcnme	(3)	String (50)	Location		Location Contact
phnnum	(3)	String (14)	Location		Location Phone
addrs1	(3)	String (50)	Location		Location Address 1
addrs2	(3)	String (50)	Location		Location Address 2
ctynme	(3)	String (50)	Location		Location City
state_	(3)	String (2)	Location		Location State
zipcde	(3)	String (10)	Location		Location Zip
srvgeo	**	Numeric	Location		Service Area
crsstr	(3)	String (50)	Location		Cross Street
maploc	(3)	String (10)	Location		Map Location
rutnum	(4) **	Numeric	Location		Service Route
usrdf1		String (50)	Location		User Def 1
usrdf2		String (50)	Location		User Def 2
clldte		Date	Dispatch	yyyy-mm-dd	Call Date
clltim		Time	Dispatch	hh:mm:ss	Call Time
dspdte		Date	Dispatch	yyyy-mm-dd	Dispatch Date
dsptim		Time	Dispatch	hh:mm:ss	Dispatch Time
schtim		Time	Dispatch	hh:mm:ss	Scheduled Time
schhrs		Numeric (5,2)	Dispatch		Estimated Hours
strdte		Date	Dispatch	yyyy-mm-dd	Start Date
strtim		Time	Dispatch	hh:mm:ss	Start Time
findte		Date	Dispatch	yyyy-mm-dd	Complete Date
fintim		Time	Dispatch	hh:mm:ss	Complete Time
acthrs		Numeric (5,2)	Dispatch		Actual Hours
priort	**	Numeric	Dispatch	[1-8]	Priority Level
empnum	**	Numeric	Dispatch		Technician
invdte		Date	Billing	yyyy-mm-dd	Invoice Date
duedte		Date	Billing	yyyy-mm-dd	Due Date
dscdte		Date	Billing	yyyy-mm-dd	Discount Date
refnum		String (20)	Billing		Reference No
invsrc	**	Numeric	Billing		Invoice Source
pchord		String (20)	Billing		Client PO No
exmnum		String (30)	Billing		Resale No
slspsn	**	Numeric	Billing		Salesperson
taxdst	**	Numeric	Billing	0=Default from Client; -1=Default from Client Location	Tax District
pmttyp	**	Numeric	Billing	1-Cash; 2-Check; 3-Credit Card; 4-Bill; 5-Insurance; 6-Other	Payment Type
crdnum	(5)	String (64)	Billing		Ref 1/ Credit Card No
crdnme		String (30)	Billing		Ref 2/Credit Card Name
expdte		Date	Billing	yyyy-mm-dd	Ref Date / Card Exp Date
constd	(6)	Date	Billing	yyyy-mm-dd	Route Contract Start Date
conend	(6)	Date	Billing	yyyy-mm-dd	Route Contract Exp Date
bildte	(6)(7)	Date	Billing	yyyy-mm-dd	Route Next Bill Date
bilcyc	(6)(7) **	Numeric	Billing	1-Weekly; 2-Bi-weekly; 3-Monthly; 4-Bi-monthly; 5-Quarterly; 6-Semi-annually; 7-Annually	Route Billing Cycle
taxmrt		decimal	Invoice Details		Taxable Markup %
txadmk		decimal	Invoice Details		Taxable Markup $
taxovr		decimal	Invoice Details		Taxable Billing Amount
taxlck		Numeric	Invoice Details	0=No;1=Yes	Taxable Locked
ntxmrt		Numeric (10,2)	Invoice Details		Non-Taxable Markup %
ntadmk		Numeric (10,2)	Invoice Details		Non-Taxable Markup $
ntxovr		Numeric (10,2)	Invoice Details		Non-Taxable Billing Amount
ntxlck		Numeric	Invoice Details	0=No;1=Yes	Non-Taxable Locked
plcnum		String (30)	Insurance		Policy No
plcnme		String (50)	Insurance		Policy Holder
plcad1		String (50)	Insurance		Policy Address 1
plcad2		String (50)	Insurance		Policy Address 2
plccty		String (60)	Insurance		Policy City,State, Zip
plcphn		String (30)	Insurance		Policy Phone
plctyp		String (50)	Insurance		Policy Type
dedabl		Numeric (10,2)	Insurance		Policy Deductible Amt
cmpnme		String (50)	Insurance		Policy Company Name
adjnme		String (50)	Insurance		Policy Adjuster Name
adjad1		String (50)	Insurance		Policy Adjuster Address 1
adjad2		String (50)	Insurance		Policy Adjuster Address 2
adjcty		String (60)	Insurance		Policy Adjuster City, State, Zip
adjphn		String (14)	Insurance		Policy Adjuster Phone
srvlin[]
linnum	[\\\\\\\\\\\\*] (8)	Numeric	Invoice Details	1	Line No
asmnum	** (9)	Numeric	Invoice Details		Assembly No
asmchk	** (10)	String (1)	Invoice Details	L=Assembly; R=Assembly Labor; P=Part; A=Assembly; or Blank	Assembly Checkmark
prtnum	** (9)	Numeric	Invoice Details		Part No
dscrpt	Required (11)	String (75)	Invoice Details		Item Description
untdsc	(11)	String (10)	Invoice Details		Unit of Measure
prtqty		Numeric (8,4)	Invoice Details		Quantity
prtprc	(11)	Numeric (9,6)	Invoice Details		Price
tktnum		String (20)	Invoice Details		Ticket No
curbll		Numeric (10,2)	Invoice Details		Current Billed Amount
csttyp	(11) **	Numeric	Invoice Details	1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Udf-6; 7-Udf-7; 8-Udf-8; 9-Udf-9	Cost Type
slstax	**	String (1)	Invoice Details	Y-Yes; N-No (Default = 'No')	Taxable
actnum	**	Numeric	Invoice Details		Account
subact	**	Numeric	Invoice Details		Subaccount
invloc	**	Numeric	Invoice Details	0 = Default Part Location	Inventory Location
eqpnum	**	Numeric	Invoice Details		Equipment
usrdf1		String (50)	Invoice Details		User Defined
shpnte		Text	Invoice Details		Shop Notes
ntetxt		Text	Invoice Details		Owner Notes
srvsch[]
linnum	[\\\\\\\\\\\\*] (8)	Numeric	Header	1	Line No
empnum	Required [\\\\\\\\\\\\] (12) *	Numeric	Dispatch		Employee No
eqpnum	Required (12) **	Numeric	Dispatch		Equipment No
vndnum	Required (12) **	Numeric	Dispatch		Vendor No
priort	Required **	Numeric	Dispatch	[1-8]	Priority
schdte		Date	Dispatch	yyyy-mm-dd	Scheduled Date
schstr		Time	Dispatch	hh:mm:ss	Scheduled Start
schfin		Time	Dispatch	hh:mm:ss	Scheduled Finish
esthrs		decimal (5,2)	Dispatch		Scheduled Hours
tvltim		String (4)	Dispatch		Travel Time
actstr		Time	Dispatch	hh:mm:ss	Actual Start Time
findte		Date	Dispatch	yyyy-mm-dd	Actual Finish Date
actfin		Time	Dispatch	hh:mm:ss	Actual Finish Time
acthrs		decimal (5,2)	Dispatch		Actual Hours
bildte		Date	Dispatch	yyyy-mm-dd	Billed Date
usrdf1		String (50)	Dispatch		User Defined

\n\n

Required(I,B) - required for Inserts and Both only

[*] Key Fields - the combination of theses fields must be unique

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) Updating to 'Void' status is only allowed when an order already exists in Sage and has a status of 6, 7 or 10

(2) Deposit Amount - creates a credit invoice

(3) If null or left out of header mapping the field will be derived from the [locnum] and if the [locnum] is blank then it will be derived from the [clientno]

(4) Service Route is only available and required when the Order Status is [9-Route]

(5) Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF

a) Go To 7-1 Company Information

b) Click Options, then Database Security Encryption

c) Select \"OFF\"

(6) Field is required when the Order Status [9-Route]

(7) Field is required when the Order Status is [10-Contract]

(8) Null/Empty = line no will be automatically derived; If specified line no must be unique based on the Key pair

(9) Assembly No must be blank if Part No is provided; Part No must be blank if Assembly No is provided

(10) Only P or A are allowed if an Assembly No is provided

(11) Null/Empty = If null or excluded from mapping and a Part No is entered, the field value will default from the Part No record

(12) Either an employee, equipment or vendor number must be specified

\n","urlObject":{"protocol":"https","path":["API","SR_WORK_ORDER"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"0c9c3e91-acc3-4c68-b045-c3a90e2e17f2"},{"name":"SR_WORK_ORDER","id":"b0075400-115d-4ebd-a32d-62396866659b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"PATCH","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

[SR 11-2 Service Work Order] Update Existing Service Work Orders

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
clnnum	Required [\\] *	Numeric	Header		Client No
ordnum	Required [\\] *	String (20)	Header		Order No
invnum		String (20)	Header		Invoice No
orddte		Date	Header	yyyy-mm-dd	Order Date
dscrpt		String (75)	Header		Order Description
status	** (1)	Numeric	Header	6-Quote; 7-Work Order; 8-Completed; 9-Route; 10-Contact	Order Status
invtyp	**	Numeric	Header		Order Type
schdte		Date	Dispatch	yyyy-mm-dd	Scheduled Date
jobnum	**	Numeric	Header		Job No
lckedt		Numeric	Header	0=No;1=Yes	Lock Edit
shpnte		Text	Header		Work Order Note
ntetxt		Text	Header		General Note
dscavl		Numeric (8,4)	Footer	25	Discount Available Percent
depost	(2)	Numeric (8,4)	Footer		Deposit Amount
locnum	**	Numeric	Location		Location No
ctcnme	(3)	String (50)	Location		Location Contact
phnnum	(3)	String (14)	Location		Location Phone
addrs1	(3)	String (50)	Location		Location Address 1
addrs2	(3)	String (50)	Location		Location Address 2
ctynme	(3)	String (50)	Location		Location City
state_	(3)	String (2)	Location		Location State
zipcde	(3)	String (10)	Location		Location Zip
srvgeo	**	Numeric	Location		Service Area
crsstr	(3)	String (50)	Location		Cross Street
maploc	(3)	String (10)	Location		Map Location
rutnum	(4) **	Numeric	Location		Service Route
usrdf1		String (50)	Location		User Def 1
usrdf2		String (50)	Location		User Def 2
clldte		Date	Dispatch	yyyy-mm-dd	Call Date
clltim		Time	Dispatch	hh:mm:ss	Call Time
dspdte		Date	Dispatch	yyyy-mm-dd	Dispatch Date
dsptim		Time	Dispatch	hh:mm:ss	Dispatch Time
schtim		Time	Dispatch	hh:mm:ss	Scheduled Time
schhrs		Numeric (5,2)	Dispatch		Estimated Hours
strdte		Date	Dispatch	yyyy-mm-dd	Start Date
strtim		Time	Dispatch	hh:mm:ss	Start Time
findte		Date	Dispatch	yyyy-mm-dd	Complete Date
fintim		Time	Dispatch	hh:mm:ss	Complete Time
acthrs		Numeric (5,2)	Dispatch		Actual Hours
priort	**	Numeric	Dispatch	[1-8]	Priority Level
empnum	**	Numeric	Dispatch		Technician
invdte		Date	Billing	yyyy-mm-dd	Invoice Date
duedte		Date	Billing	yyyy-mm-dd	Due Date
dscdte		Date	Billing	yyyy-mm-dd	Discount Date
refnum		String (20)	Billing		Reference No
invsrc	**	Numeric	Billing		Invoice Source
pchord		String (20)	Billing		Client PO No
exmnum		String (30)	Billing		Resale No
slspsn	**	Numeric	Billing		Salesperson
taxdst	**	Numeric	Billing	0=Default from Client; -1=Default from Client Location	Tax District
pmttyp	**	Numeric	Billing	1-Cash; 2-Check; 3-Credit Card; 4-Bill; 5-Insurance; 6-Other	Payment Type
crdnum	(5)	String (64)	Billing		Ref 1/ Credit Card No
crdnme		String (30)	Billing		Ref 2/Credit Card Name
expdte		Date	Billing	yyyy-mm-dd	Ref Date / Card Exp Date
constd	(6)	Date	Billing	yyyy-mm-dd	Route Contract Start Date
conend	(6)	Date	Billing	yyyy-mm-dd	Route Contract Exp Date
bildte	(6)(7)	Date	Billing	yyyy-mm-dd	Route Next Bill Date
bilcyc	(6)(7) **	Numeric	Billing	1-Weekly; 2-Bi-weekly; 3-Monthly; 4-Bi-monthly; 5-Quarterly; 6-Semi-annually; 7-Annually	Route Billing Cycle
taxmrt		decimal	Invoice Details		Taxable Markup %
txadmk		decimal	Invoice Details		Taxable Markup $
taxovr		decimal	Invoice Details		Taxable Billing Amount
taxlck		Numeric	Invoice Details	0=No;1=Yes	Taxable Locked
ntxmrt		Numeric (10,2)	Invoice Details		Non-Taxable Markup %
ntadmk		Numeric (10,2)	Invoice Details		Non-Taxable Markup $
ntxovr		Numeric (10,2)	Invoice Details		Non-Taxable Billing Amount
ntxlck		Numeric	Invoice Details	0=No;1=Yes	Non-Taxable Locked
plcnum		String (30)	Insurance		Policy No
plcnme		String (50)	Insurance		Policy Holder
plcad1		String (50)	Insurance		Policy Address 1
plcad2		String (50)	Insurance		Policy Address 2
plccty		String (60)	Insurance		Policy City,State, Zip
plcphn		String (30)	Insurance		Policy Phone
plctyp		String (50)	Insurance		Policy Type
dedabl		Numeric (10,2)	Insurance		Policy Deductible Amt
cmpnme		String (50)	Insurance		Policy Company Name
adjnme		String (50)	Insurance		Policy Adjuster Name
adjad1		String (50)	Insurance		Policy Adjuster Address 1
adjad2		String (50)	Insurance		Policy Adjuster Address 2
adjcty		String (60)	Insurance		Policy Adjuster City, State, Zip
adjphn		String (14)	Insurance		Policy Adjuster Phone
srvlin[]
linnum	[\\\\\\\\*] (8)	Numeric	Invoice Details	1	Line No
asmnum	** (9)	Numeric	Invoice Details		Assembly No
asmchk	** (10)	String (1)	Invoice Details	L=Assembly; R=Assembly Labor; P=Part; A=Assembly; or Blank	Assembly Checkmark
prtnum	** (9)	Numeric	Invoice Details		Part No
dscrpt	Required (11)	String (75)	Invoice Details		Item Description
untdsc	(11)	String (10)	Invoice Details		Unit of Measure
prtqty		Numeric (8,4)	Invoice Details		Quantity
prtprc	(11)	Numeric (9,6)	Invoice Details		Price
tktnum		String (20)	Invoice Details		Ticket No
curbll		Numeric (10,2)	Invoice Details		Current Billed Amount
csttyp	(11) **	Numeric	Invoice Details	1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Udf-6; 7-Udf-7; 8-Udf-8; 9-Udf-9	Cost Type
slstax	**	String (1)	Invoice Details	Y-Yes; N-No (Default = 'No')	Taxable
actnum	**	Numeric	Invoice Details		Account
subact	**	Numeric	Invoice Details		Subaccount
invloc	**	Numeric	Invoice Details	0 = Default Part Location	Inventory Location
eqpnum	**	Numeric	Invoice Details		Equipment
usrdf1		String (50)	Invoice Details		User Defined
shpnte		Text	Invoice Details		Shop Notes
ntetxt		Text	Invoice Details		Owner Notes
srvsch[]
linnum	[\\\\\\\\*] (8)	Numeric	Header	1	Line No
empnum	Required [\\\\\\\\] (12) *	Numeric	Dispatch		Employee No
eqpnum	Required (12) **	Numeric	Dispatch		Equipment No
vndnum	Required (12) **	Numeric	Dispatch		Vendor No
priort	Required **	Numeric	Dispatch	[1-8]	Priority
schdte		Date	Dispatch	yyyy-mm-dd	Scheduled Date
schstr		Time	Dispatch	hh:mm:ss	Scheduled Start
schfin		Time	Dispatch	hh:mm:ss	Scheduled Finish
esthrs		decimal (5,2)	Dispatch		Scheduled Hours
tvltim		String (4)	Dispatch		Travel Time
actstr		Time	Dispatch	hh:mm:ss	Actual Start Time
findte		Date	Dispatch	yyyy-mm-dd	Actual Finish Date
actfin		Time	Dispatch	hh:mm:ss	Actual Finish Time
acthrs		decimal (5,2)	Dispatch		Actual Hours
bildte		Date	Dispatch	yyyy-mm-dd	Billed Date
usrdf1		String (50)	Dispatch		User Defined

\n\n

Required(I,B) - required for Inserts and Both only

[*] Key Fields - the combination of theses fields must be unique

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) Updating to 'Void' status is only allowed when an order already exists in Sage and has a status of 6, 7 or 10

(2) Deposit Amount - creates a credit invoice

(3) If null or left out of header mapping the field will be derived from the [locnum] and if the [locnum] is blank then it will be derived from the [clientno]

(4) Service Route is only available and required when the Order Status is [9-Route]

(5) Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF

a) Go To 7-1 Company Information

b) Click Options, then Database Security Encryption

c) Select \"OFF\"

(6) Field is required when the Order Status [9-Route]

(7) Field is required when the Order Status is [10-Contract]

(8) Null/Empty = line no will be automatically derived; If specified line no must be unique based on the Key pair

(9) Assembly No must be blank if Part No is provided; Part No must be blank if Assembly No is provided

(10) Only P or A are allowed if an Assembly No is provided

(11) Null/Empty = If null or excluded from mapping and a Part No is entered, the field value will default from the Part No record

(12) Either an employee, equipment or vendor number must be specified

\n","urlObject":{"protocol":"https","path":["API","SR_WORK_ORDER"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"disabled":true,"key":"action_type","value":"I"}],"variable":[]}},"response":[],"_postman_id":"b0075400-115d-4ebd-a32d-62396866659b"}],"id":"c02a5005-9850-4880-a968-7746ab84cffd","_postman_id":"c02a5005-9850-4880-a968-7746ab84cffd","description":""},{"name":"12 - Inventory","item":[{"name":"IN_INVENTORY_ALLOC","id":"4fc14078-309b-4693-871b-2521b593b352","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"\r\n[\r\n {\r\n \"trnnum\": \"Inv-Startup\",\r\n \"entdte\": \"2025-04-30\",\r\n\t\t\"status\": 4, \r\n\t\t\"dscrpt\": \"Start up Inventory\",\r\n \"postprd\":\"2025-06-01\",\r\n \"allocation_detail\": [\r\n {\r\n \"prtnum\": \"201100\",\r\n\t\t\t\t\"prtdsc\": \"Roof Mounted Sign\",\r\n\t\t\t\t\"untdsc\": \"EA\",\r\n\t\t\t\t\"invqty\": 1,\r\n\t\t\t\t\"invcst\": 2218.60,\r\n\t\t\t\t\"serial\": \"728VA91Q\",\r\n\t\t\t\t\"invloc\": 100,\r\n\t\t\t\t\"dbtact\": 5001,\r\n\t\t\t\t\"dbtsub\": 2,\r\n\t\t\t\t\"dstloc\": \"\"\r\n }\r\n ],\r\n \"direct_costs\": [\r\n {\r\n \"jobnum\": 186,\r\n \"wrkord\": \"\",\r\n \"dscrpt\": \"Start up Inventory\",\r\n \"phsnum\": \"\",\r\n \"cstcde\": 1310,\r\n \"csttyp\": 1,\r\n \"cstamt\": 2218.60,\r\n \"ntetxt\": \"\"\r\n }\r\n ],\r\n \"equip_costs\": [\r\n {\r\n \"eqpnum\": \"\",\r\n \"eqdscrpt\": \"\",\r\n \"eqcstcde\": \"\",\r\n \"eqcsttyp\": 3,\r\n \"cstamt\": \"\",\r\n \"eqnotes\": \"\"\r\n }\r\n ]\r\n }\r\n]\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/IN_INVENTORY_ALLOC","description":"

[IN 12-2 Inventory Allocation] Create Inventory Allocations

Query Parameters
None

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
trnnum	Required	String (20)	Header	1	Ticket No
entdte	Required	Date	Header	yyyy-mm-dd	Entered Date
status	Required **	Numeric	Header	1-Open; 2-Review; 3-Hold Stock; 4-Shipped	Status
dscrpt	Required	String (50)	Header		Description
jobnum	**	Numeric	Header		Job No
phsnum	**	Numeric	Header		Phase No
aprdte		Date	Header	yyyy-mm-dd	Approved Date
deldte		Date		yyyy-mm-dd	Delivered Date
invdte		Date	Header	yyyy-mm-dd	Invoiced Date
addrs1		String (50)	Header		Address 1
addrs2		String (50)	Header		Address 2
cytnme		String (50)	Header		City
state_		String (2)	Header		State
zipcde		String (10)	Header		Zip
cstord		String (20)	Header		Order No
delvia		String (30)	Header		Delivery Via
usrdf1		String (50)	Header		User Def 1
usrdf2		String (50)	Header		User Def 2
ntetxt		Text	Header		Notes
postprd	(1)	Date		yyyy-mm-dd	Posting Period
allocation_detail[]
prtnum	Required (2) **	Numeric	Detail		Part No
prtdsc		String (75)	Detail		Description
untdsc		String (10)	Detail		Unit
invqty	Required	Numeric (12,4)	Detail		Quantity
invcst	(3)	Numeric (15, 6)	Detail		Cost
serial	(4)	String (30)	Detail		Serial No
invloc	(5) **	Numeric	Detail		Source
dbtact	(5) **	Numeric	Detail		Account
dbtsub	**	Numeric	Detail		Subaccount
dstloc	(5) **	Numeric	Detail		Destination
usrdf1		String (50)	Detail		User Defined
ntetxt		Text	Detail		Notes
direct_costs[]
jobnum	Required **	Numeric	Job Cost		Job No
wrkord	**	String (20)	Job Cost		Work Order Recnum
dscrpt	Required	String (50)	Job Cost		Description
phsnum	**	Numeric	Job Cost		Phase No
cstcde	Required **	Numeric (15,3)	Job Cost		Cost Code
csttyp	Required **	Numeric	Job Cost	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9	Cost Type
cstamt	Required	Numeric (12,2)	Job Cost		Cost Amount
ntetxt		Text	Job Cost		Notes
equip_costs[]
eqpnum	Required **	Numeric	Equip Cost		Equip No
eqdscrpt	Required	String (50)	Equip Cost		Description
eqcstcde	Required **	Numeric (15,3)	Equip Cost		Cost Code
eqcsttyp	Required **	Numeric	Equip Cost	1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9	Cost Type
cstamt	Required	Numeric (12,2)	Equip Cost		Cost Amount
eqnotes		Text	Equip Cost		Notes

\n\n

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

(1) If posting period is left blank or omitted then the Entered Date will be used as the posting period
(2) Part must be a 'Stock Item'. When 'Picking' a part, it is required to have an established average cost
(3) Only required when part is being 'Stocked' (i.e. when a Source (invloc) is being used), otherwise leave blank or omit to default to the part's average cost
(4) Only required when part is a 'Serialized Item', otherwise leave blank
(5) Exactly two of these three columns (Source, Account and Destination) must have an entry

\n","urlObject":{"protocol":"https","path":["API","IN_INVENTORY_ALLOC"],"host":["sage100cloudapi","eidynamics","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"4fc14078-309b-4693-871b-2521b593b352"}],"id":"caa5bc60-2944-4cd1-9b71-46cfaa15fea1","_postman_id":"caa5bc60-2944-4cd1-9b71-46cfaa15fea1","description":""},{"name":"GET_SAGE_TABLE","id":"d898ee82-9fc6-41cc-983a-a92568c0eecf","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"},{"key":"Auth-Token","value":"","description":"

Generated API Token

\n","type":"text"},{"key":"customer","value":"","description":"

Customer ID Associated with API Token

\n","type":"text"},{"key":"company","value":"","description":"

Company Connection Code

\n","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"fields\" : \"*\",\r\n\t\"criteria\": \"recnum = 1\"\r\n}\r\n\r\n"},"url":"https://sage100cloudapi.eidynamics.com/API/GET_SAGE_TABLE?tablename=actrec","description":"

Returns table data from any table in Sage 100 Contractor

Query Parameters
tablename: [any valid table name in Sage 100 Contractor]

max_per_page (optional): Integer between 1-1000 specifying the maximum records returned per request; behavior varies by table - some require it (default 1000), some enable pagination only when provided, others use it as a simple limit

next_page_token (optional): Base64-encoded string from previous response used to retrieve the next page; copy verbatim from response without modification, empty string indicates last page

Body Parameters:

Field Name	Required	Data Type	Tab	Example	Description
fields		String		recnum,field1,field2	Default value is \"\\*\" for all fields or specify a list of valid fieldnames spearated by a comma
criteria		String		field like '%abc%'	Leave blank for all records or pass in standard SQL where clause criteria

\n\n

Note: action keywords such as Select, Insert, Update, Delete, Create, Drop are not allowed in any of the query string or body parameters

In Sage, table names are often truncated, making it challenging to identify them by name alone. Fortunately, the SQL database includes helpful tables for identifying both tables and fields with full, readable names:

[dbo].[objlib]: This table provides a comprehensive list of all tables in the database, with each table identified by its full and descriptive name.
\n
[dbo].[fldlib]: This table contains all field names for each table, along with readable descriptions of each field, making it easier to identify the purpose of each field within a table.
\n

These resources can be invaluable for locating the correct tables and fields for your needs.

\n","urlObject":{"protocol":"https","path":["API","GET_SAGE_TABLE"],"host":["sage100cloudapi","eidynamics","com"],"query":[{"description":{"content":"

A valid tablename in Sage 100 Contractor database

\n","type":"text/plain"},"key":"tablename","value":"actrec"}],"variable":[]}},"response":[],"_postman_id":"d898ee82-9fc6-41cc-983a-a92568c0eecf"}],"event":[{"listen":"prerequest","script":{"id":"1ba413b1-d4be-42a6-8792-e4939a0c1a59","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"8ed097f2-94e9-40b9-8a1b-2d2ec9a7b67c","type":"text/javascript","exec":[""]}}]}