{
	"internalid": "21156",
	"recordtype": "transferorder",
	"tranid": "",
	"mc_user": "Cadet.Stimpy@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Updated from REST"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"subrecordname":"inventorydetail",
		"lines": [{
			"line": "1",
			"remove": "",
			"nvpair": [{
				"columnid": "quantity",
				"newvalue": "4"
			}],
			"inventorydetail": {
				"item":"",
				"location":"",
				"tolocation":"",
				"quantity": "4",
				"unit": "",
				"inventoryassignment":	[{
					"line": "1",
					"binnumber": "",
					"binid": "",
					"tobinnumber": "",
					"tobinid": "",
					"quantity": "2",
					"inventorynumber": "L-Alpha1",
			  "inventorynumberid": "",
					"expirationdate":""
				},{
					"line": "2",
					"binnumber": "",
					"binid": "",
					"tobinnumber": "",
					"tobinid": "",
					"quantity": "2",
					"inventorynumber": "L-Alpha2",
					"inventorynumberid": "",
					"expirationdate":"8/20/2017"
				}]
			}
		}]
	}]
}

{
	"recordtype": "itemfulfillment",
	"searchcolumns": [{
		"join": "item",
		"inventorynumber":"CSA0000000001",
		"inventorynumberid":"835"
	}]
}

{
	"searchtype": "transaction",
	"loadrecords":"T",
	"searchfilters": [{
		"fieldid": "inventorynumber",
		"searchvalue": "CSA0000000003",
		"join": "itemnumber"
	},{
		"fieldid": "recordtype",
		"searchvalue": "itemfulfillment"
	}],
	"searchcolumns": []
} 

{
	"searchtype": "inventorynumber"
	"searchfilters": [{
		"fieldid": "item",
		"operator": "anyof",
		"searchvalue": "2022"
	},{
		"fieldid": "location",
		"searchvalue": "2"
	}],
	"searchcolumns": [{
		"fieldid": "location"
	},{
		"fieldid": "inventorynumber"
	},{
		"fieldid": "quantityavailable"
	},{
		"fieldid": "quantityonhand"
	},{
		"fieldid": "quantityintransit"
	}]
}

{
	"recordtype": "inventorynumber",
	"searchfields": [{
		"fieldid": "inventorynumber"
		"searchvalue": "CSA0000000003"
	}]
}

{
	"searchtype": "inventorynumber",
	"searchfilters": [{
		"fieldid": "inventorynumber",
		"operator": "is",
		"searchvalue": "CSA0000000003"
	}],
        "searchcolumns": [{
		"fieldid": "item"
	},{
		"fieldid": "location"
	},{
		"fieldid": "quantityavailable"
	},{
		"fieldid": "quantityonhand"
	},{
		"fieldid": "quantityintransit"
	}]
}

{
	"recordtype": "assemblyunbuild",
	"includeinactive": "",
	"searchfields": [{
		"operator": "",
		"inventorydetail": {
			"binnumber": "",
			"inventorynumber": "CGSP00001"
		}
	}]
}	   

{
	"searchtype": "transaction",
	"sortedbyinternalid":"",
	"loadrecords":"T",
	"searchfilters": [{
		"fieldid": "inventorynumber",
		"operator": "is",
		"searchvalue": "CGSP00001",
		"join": "itemnumber"
	},{
		"fieldid": "mainline",
		"operator": "",
		"searchvalue": "T"
	},{
		"fieldid": "recordtype",
	        "operator": "",
		"searchvalue": "assemblyunbuild"
	}],
	"searchcolumns": [{
		"fieldid": "tranid",
		"join": ""
	}]
}	   

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "dagwood.bumstead@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autoreorderpoint",
		"newvalue": "T"
	},{
		"fieldid": "reordermultiple",
		"newvalue": "25"
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "julius.dithers@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autoreorderpoint",
		"newvalue": "F"
	},{
		"fieldid": "reordermultiple",
		"newvalue": "25"
	}],
	"updatecolumns": [{
		"sublistid": "locations",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"remove": "",
			"nvpair": [{
				"columnid": "reorderpoint",
				"newvalue": "100"
			}]
		},{
			"line": "4",
			"remove": "",
			"nvpair": [{
				"columnid": "reorderpoint",
				"newvalue": "50"
			}]
		}]
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "cora.dithers @dsiglobal.com",
	"updatefields": [{
		"fieldid": "autoreorderpoint",
		"newvalue": "F"
	},{
		"fieldid": "reorderpoint",
		"newvalue": "100"
	},{
		"fieldid": "reordermultiple",
		"newvalue": "25"
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "herb.woodley@dsiglobal.com",
	"updatefields": [{
		"fieldid": "safetystocklevel",
		"newvalue": "10"
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "daisy.bumstead@dsiglobal.com",
	"updatefields": [{
		"fieldid": "safetystockleveldays",
		"newvalue": "30"
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "tootsie.woodley@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autopreferredstocklevel",
		"newvalue": "T"
	},{
		"fieldid": "preferredstockleveldays",
		"newvalue": "14"
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "cookie.bumstead@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autopreferredstocklevel",
		"newvalue": "F"
	},{
		"fieldid": "preferredstockleveldays",
		"newvalue": ""
	}],
	"updatecolumns": [{
		"sublistid": "locations",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"remove": "",
			"nvpair": [{
				"columnid": "preferredstocklevel",
				"newvalue": "20"
			}]
		},{
			"line": "4",
			"remove": "",
			"nvpair": [{
				"columnid": "preferredstocklevel",
				"newvalue": "5"
			}]
		}]
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "blondie.boopadoop@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autopreferredstocklevel",
		"newvalue": "F"
	},{
		"fieldid": "preferredstockleveldays",
		"newvalue": ""
	},{
		"fieldid": "preferredstocklevel",
		"newvalue": "25"
	}]
}

• If there are multiple receipts for the item against the same purchase order, the calculation is made using the difference between the purchase order and the last receipt (the receipt that fully receives the order).
• Lead time calculation is not weighted by number of units received.
• More recent purchase orders without receipts are ignored.

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "alexander.bumstead@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autoleadtime",
		"newvalue": "T"
	}]
}

{
	"internalid": "98",
	"recordtype": "inventoryitem",
	"mc_user": "blondie.bumstead@dsiglobal.com",
	"updatefields": [{
		"fieldid": "autoleadtime",
		"newvalue": "F"
	},{
		"fieldid": "leadtime",
		"newvalue": "25"
	}]
}

{
	"transform": [{
		"mc_user": "quckdraw.mcgraw@dsiglobal.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "33691",
		"torecordtype": "assemblybuild",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Built 4, 8 more to go."
		}],
		"targetfields": [{
			"fieldid": "quantity",
			"value": "4"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Daphne.Blake@dsiglobal.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "1743",
		"torecordtype": "assemblybuild",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Built by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "quantity",
			"value": "1"
		},{
			"fieldid": "binnumbers",
			"value": "Beta-1(1)"
		}],
		"sublists": [{
			"sublistid": "component",
			"subrecordname":"",
			"lines": [{
				"linenum": "1",
				"item": "105",
				"qty": "1",
				"binnumbers": "Beta-2(1)",
				"serialnumbers": "",
				"refnum":"",
				"nvpair": [{
					"columnid": "",
					"value": ""
				}]
			},{
				"linenum": "2",
				"item": "106",
				"qty": "1",
				"binnumbers": "Alpha-1(1)",
				"serialnumbers": "",
				"refnum":"",
				"nvpair": [{
					"columnid": "",
					"value": ""
				}]
			}]
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "I.R.Babboon@dsiglobal.com",
		"recordtype": "assemblybuild",
		"location": "2",
		"subsidiary":"1",
		"targetfields": [{
			"fieldid": "item",
			"value": "950"
		},{
			"fieldid": "quantity",
			"value": "2"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "I.R.Babboon@dsiglobal.com",
		"recordtype": "assemblyunbuild",
		"location": "2",
		"subsidiary":"1",
		"targetfields": [{
			"fieldid": "item",
			"value": "950"
		},{
			"fieldid": "quantity",
			"value": "2"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "octo.octavius@dsiglobal.com",
		"recordtype": "assemblyunbuild",

		"sublists": [{
			"sublistid": "",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "",
					"newvalue": ""
				}],
				"inventorydetail": {
					"location":"",
					"tolocation":"",
					"quantity": "",
					"unit": "",
					"inventoryassignment":	[{
						"line": "",
						"binnumber": "",
						"binid": "",
						"tobinnumber": "",
						"tobinid": "",
						"quantity": "",
						"inventorynumber": "",
						"inventorynumberid": "",
						"expirationdate":""
					}]
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "quantity",
			"value": "2"
		},{
			"fieldid": "item",
			"value": "2022"
		},{
			"fieldid": "",
			"value": "",
			"inventorydetail": {
				"item":"2022",
				"unit": "",
				"inventoryassignment": [{
					"line": "NEW",
					"binnumber": "",
					"binid": "",
					"quantity": "1",
					"inventorynumber": "CGSP00001",
					"inventorynumberid": ""
				},{
					"line": "NEW",
					"binnumber": "",
					"binid": "",
					"quantity": "1",
					"inventorynumber": "CGSP00002",
					"inventorynumberid": ""
				}]
			}
		}]
	}]
}

{
	"transform": [{
		"mc_user": "wile.e.coyote@dsiglobal.com",
		"fromrecordtype": "assemblybuild",
		"fromrecordid": "26949",
		"torecordtype": "assemblyunbuild",
		"tolocation": "2"
	}]
}

{
	"childtype": "customrecord_dsi_bol",
	"childid": "303",
	"parenttype": "customrecord_dsi_bol",
	"parentid": "302",
	"mc_user": "Sulu@Enterprise.com",
	"role": "",
	"field": "custrecord_dsi_bol_childbol",
	"detach": ""
}		   

{
	"childtype": "customrecord_dsi_bol",
	"childid": "303",
	"parenttype": "customrecord_dsi_bol",
	"parentid": "302",
	"mc_user": "Scotty@Enterprise.com",
	"role": "",
	"field": "custrecord_dsi_bol_childbol",
	"detach": "T"
}

{
	"recordcategory": "custom",
	"create": [{
		"mc_user": "Hamfast.Gamgee@HobbitonGardeners.com",
		"recordtype": "customrecord_dsi_bol",
		"targetfields": [{
			"fieldid": "name",
			"value": "7/29/1954JRRT",
			"text": ""
		}, {
			"fieldid": "custrecord_dsi_bol_shipfrom",
			"value": "No. 3 Bagshot Row, The Hill, Hobbition",
			"text": ""
		}, {
			"fieldid": "custrecord_dsi_bol_shipto",
			"value": "The Inn of the Prancing Pony, Bree",
			"text": ""
		}, {
			"fieldid": "custrecord_dsi_bol_trailer",
			"value": "Bill The Pony",
			"text": ""
		}, {
			"fieldid": "custrecord_dsi_bol_carrier",
			"value": "Rohirrim Riders",
			"text": ""
		}, {
			"fieldid": "custrecord_dsi_bol_billto",
			"value": "Gandalf The Gray",
			"text": ""
		}, {
			"fieldid": "custrecord_dsi_bol_freight_terms",
			"value": "2",
			"text": ""
		}]
	}]
}		   

{
	"recordcategory": "custom",
	"create": [{
		"mc_user": "Saruman.Of.Many.Colors@Isengard.com",
		"recordtype": "customrecord_dsi_bol_order",
		"tranid": "",
		"itemid": "",
		"entityid": "",
		"location": "",
	   	"transferlocation": "",
		"account": "",
		"subsidiary": "",
		"targetfields": [{
			"fieldid": "custrecord_dsi_bol_order_parent",
			"value": "102"
		}, {
			"fieldid": "custrecord_dsi_bol_order_so",
			"value": "4071"
		}, {
			"fieldid": "custrecord_dsi_bol_order_numpackage",
			"value": "7"
		}, {
			"fieldid": "custrecord_dsi_bol_order_weight",
			"value": "622"
		}]
	}]
}

{
	"recordcategory": "custom",
	"create": [{
		"mc_user": "Saruman.Of.Many.Colors@Isengard.com",
		"recordtype": "customrecord_dsi_bol_product",
		"targetfields": [{
			"fieldid": "custrecord_dsi_bol_product_parent",
			"value": "102"
		}, {
			"fieldid": "custrecord_dsi_bol_product_unitqty",
			"value": "4"
		}, {
			"fieldid": "custrecord_dsi_bol_product_unittype",
			"value": "pallet"
		}, {
			"fieldid": "custrecord_dsi_bol_product_packageqty",
			"value": "7"
		}, {
			"fieldid": "custrecord_dsi_bol_product_packagetype",
			"value": "crate"
		}, {
			"fieldid": "custrecord_dsi_bol_product_weight",
			"value": "622"
		}, {
			"fieldid": "custrecord_dsi_bol_product_commodity",
			"value": "Furniture"
		}]
	}]
}	   

{
  "internalid": "",
  "recordtype": "customrecord_dsi_bol",
  "filterexpression":"",
  "searchfields": [{
    "fieldid": "name",
    "operator": "is",
    "searchvalue": "123456789"
  }]
}

{
  "searchtype": "customrecord_dsi_bol",
  "loadrecords":"",
  "filterexpression":"",
  "searchfilters": [{
    "fieldid": "name",
    "operator": "is",
    "searchvalue": "123456789",
    "searchvalue2": "",
    "join": ""
  }],
  "searchcolumns": [{
    "fieldid": "name"
  },{
    "fieldid": "custrecord_dsi_bol_order_number",
    "join": "custrecord_dsi_bol_order_parent"
  },{
    "fieldid": "custrecord_dsi_bol_order_so",
    "join": "custrecord_dsi_bol_order_parent"
  },{
    "fieldid": "custrecord_dsi_bol_product_weight",
    "join": "custrecord_dsi_bol_product_parent"
  }]
}	   

{
  "searchtype": "customrecord_dsi_bol_product",
  "loadrecords":"",
  "filterexpression":"",
  "searchfilters": [{
    "fieldid": "custrecord_dsi_bol_product_parent",
    "operator": "anyof",
    "searchvalue": "1",
    "searchvalue2": "",
    "join": ""
  }],
  "searchcolumns": [{
    "fieldid": "custrecord_dsi_bol_product_parent"
  },{
    "fieldid": "custrecord_dsi_bol_product_packageqty"
  },{
    "fieldid": "custrecord_dsi_bol_product_packagetype"
  },{
    "fieldid": "custrecord_dsi_bol_product_weight"
  }]
}	   

{
  "searchtype": "customrecord_dsi_bol_order",
  "loadrecords":"",
  "filterexpression":"",
  "searchfilters": [{
    "fieldid": "custrecord_dsi_bol_order_parent",
    "operator": "anyof",
    "searchvalue": "1",
    "join": ""
  }],
  "searchcolumns": [{
    "fieldid": "custrecord_dsi_bol_order_number"
  },{
    "fieldid": "custrecord_dsi_bol_order_weight"
  }]
}	   

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "charles.koch@dsiglobal.com",
		"recordtype": "billingschedule",
		"initvalues": [{
			"fieldid": "schedtype",
			"value": "STD"
		}],
		"targetfields": [{
			"fieldid": "name",
			"value": "STDrecord1",
			"text":""
		},{
			"fieldid": "frequency",
			"value": "MONTHLY",
			"text":""
		},{
			"fieldid": "initialamount",
			"value": "10%",
			"text":""
		},{
			"fieldid": "subsidiary",
			"value": "1",
			"text":""
		},{
			"fieldid": "billingentity",
			"value": "4371",
			"text":""
		},{
			"fieldid": "numberremaining",
			"value": "4",
			"text":""
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "mark.zuckerberg@dsiglobal.com",
		"recordtype": "billingschedule",
		"sublists": [{
			"sublistid": "",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "",
					"newvalue": ""
				}]
			}]
		}],
		"initvalues": [{
			"fieldid": "schedtype",
			"value": "CB"
		}],
		"targetfields": [{
			"fieldid": "name",
			"value": "CBrecord1",
			"text":""
		},{
			"fieldid": "frequency",
			"value": "DAILY",
			"text":""
		},{
			"fieldid": "dayperiod",
			"value": "3",
			"text":""
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "leona.helmsley@dsiglobal.com",
		"recordtype": "billingschedule",
		"initvalues": [{
			"fieldid": "schedtype",
			"value": "FBI"
		}],
		"targetfields": [{
			"fieldid": "name",
			"value": "FBI schedule",
			"text":""
		},{
			"fieldid": "initialamount",
			"value": "10%",
			"text":""
		},{
			"fieldid": "frequency",
			"value": "WEEKLY",
			"text":""
		},{
			"fieldid": "repeatevery",
			"value": "2",
			"text":""
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "larry.page@dsiglobal.com",
		"recordtype": "billingschedule",
		"sublists": [{
			"sublistid": "milestone",
			"lines": [{
				"nvpair": [{
					"columnid": "milestoneamount",
					"newvalue": "10%"
				},{
					"columnid": "milestonedate",
					"newvalue": "2/7/2017"
				},{
					"columnid": "projecttask",
					"newvalue": "103314"
				}]
			},{
				"nvpair": [{
					"columnid": "milestoneamount",
					"newvalue": "80%"
				},{
					"columnid": "milestonedate",
					"newvalue": "2/21/2017"
				},{
					"columnid": "projecttask",
					"newvalue": "103315"
				}]
			}]
		}],
		"initvalues": [{
			"fieldid": "project",
			"value": "3759",
			"text":""
		},{
			"fieldid": "schedtype",
			"value": "FBM"
		}],
		"targetfields": [{
			"fieldid": "name",
			"value": "FBM schedule",
			"text":""
		},{
			"fieldid": "initialamount",
			"value": "10%",
			"text":""
		}]
	}]
}

{
	"internalid": "3759",
	"recordtype": "job",
	"mc_user": "nelson.rockefeller@dsiglobal.com",
	"updatefields": [{
		"fieldid": "jobbillingtype",
		"newvalue": "FBM"
	},{
		"fieldid": "billingschedule",
		"newvalue": "13"
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "warren.buffett@dsiglobal.com",
		"recordtype": "billingschedule",
		"initvalues": [{
			"fieldid": "schedtype",
			"value": "TM"
		}],
		"targetfields": [{
			"fieldid": "name",
			"value": "TM schedule",
			"text":""
		},{
			"fieldid": "frequency",
			"value": "HOURLY",
			"text":""
		},{
			"fieldid": "repeatevery",
			"value": "1",
			"text":""
		}]
	}]
}

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "Leo.Davinci@dsiglobal.com",
		"recordtype": "bin",
		"location": "1",
		"subsidiary": "1",
		"targetfields": [{
			"fieldid": "binnumber",
			"value": "Beta-2"
		},{
			"fieldid": "location",
			"value": "2"
		}]
	}]
}

{
	"recordcategory": "item",
	"create": [{
		"mc_user": "William.Parmenter@fortcourage.gov",
		"recordtype": "inventoryitem",
		"itemid": "F Tent",
		"location": "1",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "binnumber",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "binnumber",
					"newvalue": "217"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "usebins",
			"value": "T"
		}],
		"pricematrix": [{
			"row": "1",
			"column": "1",
			"currencyid": "1",
			"newprice": "29.95"
		}]
	}]
}

{
	"mc_user": "rob@dsiglobal.com",
	"internalid": "1314",
	"recordtype": "inventoryitem",
	"itemid": "",
	"location": "1",
	"subsidiary": "1",
	"updatefields": [{
		"fieldid": "usebins",
		"newvalue": "T"
	}],
	"updatecolumns": [{
		"sublistid": "binnumber",
		"lines": [{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "binnumber",
				"newvalue": "117"
			}]
		},{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "binnumber",
				"newvalue": "118"
			}]
		}]
	}]
}

{
	"mc_user": "rob@dsiglobal.com",
	"internalid": "1314",
	"recordtype": "inventoryitem",
	"itemid": "",
	"location": "1",
	"subsidiary": "1",
	"updatefields": [{
		"fieldid": "",
		"newvalue": ""
	}],
	"updatecolumns": [{
		"sublistid": "binnumber",
		"lines": [{
			"line": "2",
			"remove": "T",
			"nvpair": [{
				"columnid": "",
				"newvalue": ""
			}]
		}]
	}]
}

{
	"recordtype": "inventoryitem",
	"location": "",
	"subsidiary": "",
	"searchcolumns": [{
		"join": "binnumber",
		"fieldid": "binnumber",
		"searchvalue": "Beta-1"
	}]
}

{
	"searchtype": "item",
	"searchfilters": [{
		"fieldid": "binnumber",
		"operator": "is",
		"searchvalue": "Beta-2"
	}],
	"searchcolumns": [{
		"fieldid": "itemid"
	},{
		"fieldid": "salesdescription"
	},{
		"fieldid": "inventorynumber",
		"join":"inventorydetail"
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "Charles.Babbage@dsiglobal.com",
		"recordtype": "bintransfer",
		"location": "",
		"subsidiary": "",
		"sublists": [{
			"sublistid": "inventory",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "105"
				},{
					"columnid": "quantity",
					"newvalue": "5"
				},{
					"columnid": "frombins",
					"newvalue": "Beta-1"
				},{
					"columnid": "tobins",
					"newvalue": "Beta-2"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Bin Transfer by Advanced Inventory"
		}]
	}]
}

• Location is required, subsidiary is not required.
• Each member of the lines array has a new sub-array called inventorydetails. One or more is required.
• The inventory number, from bin, and to bin can be specified either by value or internalid (internalid is always faster).
• The quantity in the lines array must be the total of the quantities of all the inventory details.

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "Charles.Babbage@dsiglobal.com",
		"recordtype": "bintransfer",
		"location": "2",
		"sublists": [{
			"sublistid": "inventory",
			"subrecordname":"inventorydetails",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "678"
				}, {
					"columnid": "quantity",
					"newvalue": "125"
				}],
				"inventorydetail": [{
					"binnumber": "Alpha-1",
					"binid": "117",
					"tobinnumber": "Alpha-2",
					"tobinid": "118",
					"quantity": "25",
					"inventorynumber": "L-Alpha1",
					"inventorynumberid": "622",
					"location":"2"
				},{
					"binnumber": "Alpha-1",
					"binid": "117",
					"tobinnumber": "2001",
					"tobinid": "",
					"quantity": "100",
					"inventorynumber": "L-Alpha1",
					"inventorynumberid": "622",
					"location":"2"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "",
			"value": ""
		}]
	}]
}

{
	"lookup":"T",
	"location":"2" 
}

{
	"lookup":"",
	"location":"2",
	"trandate":"",
	"memo":"12345678901234567890",
	"lines":[{
		"item":"1314",
		"bins":[{
			"binnumber":"",
			"binid":"117",
			"quantity":"1" ,
			"inventorynumber":"", 
			"inventorynumberid":""

		},{
			"binnumber":"Alpha-2",
			"binid":"",
			"quantity":"1" ,
			"inventorynumber":"", 
			"inventorynumberid":""

		}]
	},{
		"item":"942",
		"bins":[{
			"binnumber":"Alpha-3",
			"binid":"",
			"quantity":"1" ,
			"inventorynumber":"", 
			"inventorynumberid":""

		}]
	}]
}

{
	"transform": [{
		"mc_user": "Bubba.Gump@dsiglobal.com",
		"fromrecordtype": "purchaseorder",
		"fromrecordid": "21179",
		"torecordtype": "itemreceipt",
		"tolocation": "2",
		"location": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "I did this"
		}],
		"lines": [{
			"item": "678",
			"qty": "20",
			"inventorydetail": {
			    "tolocation":"2",
			    "quantity": "20",
			    "unit": "",
			    "inventoryassignment":[{
			        "line": "",
    				"binnumber": "",
    				"binid": "117",
    				"quantity": "10",
    				"inventorynumber": "NewLot002",
    				"inventorynumberid": "",
    				"expirationdate":""
    			},{
			        "line": "",
    				"binnumber": "Alpha-2",
    				"binid": “",
    				"quantity": "10",
    				"inventorynumber": "",
    				"inventorynumberid": "734",
    				"expirationdate":""
    			}]
		    }]
	}]
}

{
	"transform": [{
		"mc_user": "Bubba.Smith@dsiglobal.com",
		"fromrecordtype": "purchaseorder",
		"fromrecordid": "21992",
		"torecordtype": "itemreceipt",
		"tolocation": "1",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Bins but no inventory number"
		}],
		"lines": [{
			"item": "1314",
			"qty": "10",
			"inventorydetail": {
			    "tolocation":"1",
			    "quantity": "10",
			    "unit": "",
			    "inventoryassignment": [{
			        "line": "",
    				"binnumber": "Beta-1",
    				"binid": "",
    				"quantity": "10"
    			}]
		    }
		}]
	}]
}

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "j.jonah.jameson.jr@dsiglobal.com",
		"recordtype": "calendarevent",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "attendee",
			"lines": [{
				"nvpair": [{
					"columnid": "attendee",
					"newvalue": "1644"
				},{
					"columnid": "sendemail",
					"newvalue": "T"
				}]
		    },{
				"nvpair": [{
					"columnid": "attendee",
					"newvalue": "1647"
				}]
		    }]
		},{
			"sublistid": "resource",
			"lines": [{
				"nvpair": [{
					"columnid": "resource",
					"newvalue": "5"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "title",
			"value": "Service Mrs. Douglas' Tent"
		},{
			"fieldid": "organizer",
			"value": "1647"
		},{
			"fieldid": "owner",
			"value": "1647"
		},{
			"fieldid": "startdate",
			"value": "10/25/2016"
		},{
			"fieldid": "starttime",
			"value": "11:00 AM"
		},{
			"fieldid": "enddate",
			"value": "10/25/2016"
		},{
			"fieldid": "endtime",
			"value": "12:00 PM"
		},{
			"fieldid": "timedevent",
			"value": "T"
		},{
			"fieldid": "company",
			"value": "2956"
		},{
			"fieldid": "contact",
			"value": "2655"
		},{
			"fieldid": "supportcase",
			"value": "101696"
		},{
			"fieldid": "status",
			"value": "TENTATIVE"
		}]
	}]
}

{
	"internalid": "102804",
	"recordtype": "calendarevent"
}

{
	"internalid": "103004",
	"recordtype": "calendarevent",
	"mc_user": "pepper.potts@dsiglobal.com",
	"updatefields": [{
		"fieldid": "status",
		"newvalue": "CONFIRMED"
	},{
		"fieldid": "accesslevel",
		"newvalue": "PUBLIC"
	}],
	"updatecolumns": [{
		"sublistid": "attendee",
		"lines": [{
			"line": "ALL",
			"nvpair": [{
				"columnid": "response",
				"newvalue": "ACCEPTED"
			}]
		},{
			"line": "1",
			"remove": "T"
		}]
	}]
}

{
	"internalid": "103004",
	"recordtype": "calendarevent",
	"mc_user": "pepper.potts@dsiglobal.com",
	"updatefields": [{
		"fieldid": "status",
		"newvalue": "COMPLETE"
	}],
	"updatecolumns": [{
		"sublistid": "timeitem",
		"lines": [{
			"line": "NEW",
			"nvpair": [{
				"columnid": "employee",
				"newvalue": "1644"
			},{
				"columnid": "hours",
				"newvalue": "1:45"
			},{
				"columnid": "location",
				"newvalue": "2"
			},{
				"columnid": "customer",
				"newvalue": "4062"
			},{
				"columnid": "item",
				"newvalue": "2024"
			}]
		},{
			"line": "NEW",
			"nvpair": [{
				"columnid": "employee",
				"newvalue": "1647"
			},{
				"columnid": "hours",
				"newvalue": "2:05"
			},{
				"columnid": "location",
				"newvalue": "2"
			},{
				"columnid": "customer",
				"newvalue": "2956"
			},{
				"columnid": "item",
				"newvalue": "2024"
			},{
				"columnid": "rate",
				"newvalue": "20.35"
			}]
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "roudolph.r.deer@dsiglobal.com",
		"recordtype": "workcalendar",
		"location": "2",
		"subsidiary":"1",
		"targetfields": [{
			"fieldid": "name",
			"value": "Half Day"
		},{
			"fieldid": "workhoursperday",
			"value": "8"
		},{
			"fieldid": "starthour",
			"value": "1:00 pm"
		},{
			"fieldid": "sunday",
			"value": "F"
		},{
			"fieldid": "monday",
			"value": "T"
		},{
			"fieldid": "tuesday",
			"value": "T"
		},{
			"fieldid": "wednesday",
			"value": "T"
		},{
			"fieldid": "thursday",
			"value": "T"
		},{
			"fieldid": "friday",
			"value": "T"
		},{
			"fieldid": "saturday",
			"value": "F"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "josey.pussycats@dsiglobal.com",
		"fromrecordtype": "cashsale",
		"fromrecordid": "25648",
		"torecordtype": "cashrefund",
		"tolocation": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "refunded by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "created by Advanced Inventory"
		}],
		"lines": [{
			"item": "1314",
			"qty": "1"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "jem@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"fromrecordid": "30071",
		"torecordtype": "cashrefund",
		"tolocation": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "refunded by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Truly, truly outrageous"
		},{
			"fieldid": "account",
			"value": "1"
		}],
		"lines": [{
			"item": "1314",
			"qty": "1"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "h.k.phooey@dsiglobal.com",
		"recordtype": "cashrefund",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "customer",
			"value": "2956"
		},{
			"fieldid": "account",
			"value": "1"
		}]
	}]
}

• Subsidiary
• Location
• Entity (customer)
• One or more item lines with item and quantity

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "I.M.Weasel@dsiglobal.com",
		"recordtype": "cashsale",
		"location": "2",
		"subsidiary":"1",
		"entityid":"2956",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				}],
    			"inventorydetail": {
    			    "item":"1314",
    			    "location":"2",
    			    "quantity": "2",
    			    "unit": "",
    			    "inventoryassignment":	[{
    			        "line": "",
        				"binnumber": "Alpha-1",
        				"binid": "",
        				"quantity": "2",
        				"inventorynumber": "",
        				"inventorynumberid": ""
        			}]
    		    }
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1008"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1009"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Cash sale created by Advanced Inventory"
		},{
			"fieldid": "entity",
			"value": "2956"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "I.R.Babboon@dsiglobal.com",
		"fromrecordtype": "salesorder",
		"tranid": "",
		"fromrecordid": "22707",
		"torecordtype": "cashsale",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Processed by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Cash Sale Created by Advanced Inventory"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Nyota.Uhura@dsiglobal.com",
		"fromrecordtype": "customer",
		"tranid": "",
		"fromrecordid": "2956",
		"torecordtype": "cashsale",
		"tolocation": "2",
		"location": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Transformed by Advanced Inventory"
		}
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "2",
			"binnumbers": "",
			"serialnumbers": "",
			"inventorydetail": {
				"item": "1314",
				"tolocation": "2",
						"unit": "",
				"inventoryassignment": [{
					"line": "",
					"binnumber": "Alpha-2",
					"binid": "",
					"quantity": "2",
					"inventorynumber": "",
					"inventorynumberid": "",
					"expirationdate": ""
				}]
			}
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Nyota.Uhura@dsiglobal.com",
		"fromrecordtype": "estimate",
		"tranid": "",
		"fromrecordid": "25330",
		"torecordtype": "cashsale",
		"tolocation": "2",
		"location": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Cash Sale by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Hailing frequency open"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "1",
			"binnumbers": "",
			"serialnumbers": "",
			"nvpair": [{
				"columnid": "taxcode",
				"value": "638"
			}],
			"inventorydetail": {
				"item": "1314",
				"tolocation": "2",
				"quantity": "1",
				"unit": "",
				"inventoryassignment": [{
					"binnumber": "Alpha-1",
					"binid": "",
					"quantity": "1",
					"inventorynumber": "",
					"inventorynumberid": ""
				}]
			}
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Harold.Wormser@dsiglobal.com",
		"fromrecordtype": "opportunity",
		"tranid": "",
		"fromrecordid": "22913",
		"torecordtype": "cashsale",
		"tolocation": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Processed by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Cash Sale Created by Advanced Inventory"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "5",
			"inventorydetail": {
				"item": "1314",
				"quantity": "5",
				"unit": "",
				"inventoryassignment": [{
					"binnumber": "Alpha-1",
					"binid": "",
					"tobinnumber": "",
					"tobinid": "",
					"quantity": "5",
					"inventorynumber": "",
					"inventorynumberid": "",
					"expirationdate": ""
				}]
			}
		}]
	}]
}

{
	"internalid": "22813",
	"recordtype": "cashsale",
	"tranid": "",
	"mc_user": "Booger.Dawson@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "ALL",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"internalid": "22813",
	"recordtype": "cashsale",
	"tranid": "",
	"mc_user": "Lamar.Latrell@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Line 1 closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "William.Gates@dsiglobal.com",
		"recordtype": "contact",
		"location": "",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "addressbook",
			"lines": [{
				"nvpair": [{
					"columnid": "addr1",
					"newvalue": "1 Haney Place"
				},{
					"columnid": "city",
					"newvalue": "Hooterville"
				},{
					"columnid": "state",
					"newvalue": "IL"
				}],
				"inventorydetail": {
				}
			}]
		}],
		"targetfields": [ {
			"fieldid": "entityid",
			"value": "Oliver W Douglas"
		}, {
			"fieldid": "firstname",
			"value": "Oliver"
		}, {
			"fieldid": "middlename",
			"value": "Wendell"
		},  {
			"fieldid": "lastname",
			"value": "Douglas"
		}, {
			"fieldid": "salutation",
			"value": "Mr."
		}, {
			"fieldid": "title",
			"value": "Owner"
		}, {
			"fieldid": "comments",
			"value": "Sucker, will buy anything"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "arthur.pendragon@dsiglobal.com",
		"fromrecordtype": "invoice",
		"fromrecordid": "25634",
		"torecordtype": "creditmemo",
		"location": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Credit Memo created by Advanced Inventory"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "arthur.pendragon@dsiglobal.com",
		"fromrecordtype": "invoice",
		"fromrecordid": "25634",
		"torecordtype": "creditmemo",
		"location": "2",
		"sourcefields": [{
			"fieldid": "credited by Arthur",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
		}],
		"sublists": [{
			"sublistid": "apply",
			"subrecordname":"",
			"lines": [{
				"linenum": "1",
				"serialnumbers": "",
				"nvpair": [{
					"columnid": "amount",
					"value": "12.99"
				},{
					"columnid": "linenum",
					"value": "1"
				}]
			}]
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Merlin.Ambrosius@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"fromrecordid": "30071",
		"torecordtype": "creditmemo",
		"location": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
			}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "h.k.phooey@dsiglobal.com",
		"recordtype": "creditmemo",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1008"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				},{
					"columnid": "rate",
					"newvalue": "125.50"
				}],
			}]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "credit for 1 Spacely Sprocket"
		}]
	}]
}

{
	"internalid": "32777",
	"recordtype": "creditmemo",
	"tranid": "",
	"mc_user": "guinevere.pendragon@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Applied to INV10000006"
	}],
	"updatecolumns": [{
		"sublistid": "apply",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "apply",
				"newvalue": "T"
			},{
				"columnid": "amount",
				"newvalue": "24.50"
			}]
		},{
			"line": "2",
			"nvpair": [{
				"columnid": "apply",
				"newvalue": "T"
			},{
				"columnid": "amount",
				"newvalue": "75.50"
			}]
		}]
	}]
}

{
	"mapping": "16",
	"csvString": "external ID,Date,Customer,Location,Order No,Expected Ship Date,item,qty,customform~DSI20170320-5,3/21/2017,2956,2,,6/12/2017,95,1,174~DSI20170320-5,3/21/2017,2956,2,,6/12/2017,113,1,174~DSI20170320-5,3/21/2017,2956,2,,6/12/2017,123,2,174",
	"jobName": "Thursday Import"
}

{
	"mapping": "16",
	"csvFileid": "17717",
	"jobName": ""
}

{
	"internalid": "2956",
	"recordtype": "customer",
	"mc_user": "Bill.Gates@dsiglobal.com",
	"entityid": "",
	"updatefields": [{
		"fieldid": "contact",
		"newvalue": "2555"
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "William.Gates@dsiglobal.com",
		"recordtype": "customer",
		"entityid": "",
		"location": "",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "addressbook",
			"subrecordname":"inventorydetails",
			"lines": [{
				"nvpair": [{
					"columnid": "addr1",
					"newvalue": "1 Haney Place"
				}, {
					"columnid": "city",
					"newvalue": "Hooterville"
				}, {
					"columnid": "state",
					"newvalue": "IL"
				}],
				"inventorydetail": {
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "companyname",
			"value": "Douglas Farm"
		}, {
			"fieldid": "isperson",
			"value": "F"
		}, {
			"fieldid": "email",
			"value": "lovefarming421@douglasfarm.com"
		}, {
			"fieldid": "title",
			"value": "Mr."
		}, {
			"fieldid": "contact",
			"value": "2555"
		}, {
			"fieldid": "contact",
			"value": "2655"
		}, {
			"fieldid": "comments",
			"value": "Sucker, will buy anything"
		}]
	}]
}

• Apply full payment
• Apply partial payment

{
	"transform": [{
		"mc_user": "nobody@dsiglobal.com",
		"fromrecordtype": "customer",
		"fromrecordid": "2956",
		"torecordtype": "customerpayment",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "payment processed by Advanced Inventory"
		}],
		"targetfields": [{
				"fieldid": "approvalstatus",
				"value": "2"
		}],
		"sublists": [{
			"sublistid": "apply",
			"subrecordname":"",
			"lines": [{
				"linenum": "",
				"refnum":"INV10000006",
				"nvpair": [{
					"columnid": "amount",
					"value": "24.03"
				}]
			}]
		}]
	}]
}

{
	"transform": [{
		"mc_user": "everybody@dsiglobal.com",
		"fromrecordtype": "customer",
		"fromrecordid": "2956",
		"torecordtype": "customerpayment",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "payment processed by Advanced Inventory"
		}],
		"targetfields": [{
				"fieldid": "payment",
				"value": "24.03"
			},{
				"fieldid": "approvalstatus",
				"value": "2"
		}]
	}]
}

{
	"internalid": "32077",
	"recordtype": "customerpayment",
	"tranid": "",
	"mc_user": "guy.smiley@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Applied to INV10000006"
	}],
	"updatecolumns": [{
		"sublistid": "apply",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "apply",
				"newvalue": "T"
			},{
				"columnid": "amount",
				"newvalue": "24.03"
			}]
		}]
	}]
}

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "Arnold.Poindexter@dsiglobal.com",
		"recordtype": "message",
		"sublists": [{
		 "sublistid": "mediaitem",
			"lines": [{
				"nvpair": [{
					"columnid": "mediaitem",
					"newvalue": "6858"
				}]
		    }]
		}],
		"targetfields": [
			"fieldid": "recipient",
			"value": "1647"
		},{
			"fieldid": "recipientemail",
			"value": "rob.grier@dsiglobal.com"
		},{
			"fieldid": "author",
			"value": "1648"
		},{
			"fieldid": "authoremail",
			"value": "dsi_rest@dsiglobal.com"
		},{
			"fieldid": "subject",
			"value": "Notice"
		},{
			"fieldid": "message",
			"value":"<HTML><HEAD><meta http-equiv='Content-Type' content='text/html;charset=UTF-8'><HEAD><BODY>This is a notification. Picture attached.</BODY></HTML>"
		},{
			"fieldid": "cc",
			"value": "Lewis.Skolnick@trilambda.com,Gilbert.Lowell@trilambda.com,Judy.Lowell@OmegaMu.com"
		},{
			"fieldid": "bcc",
			"value": "Ogre.Palowakski@AlphaBeta.com,Stan.Gable@AlphaBeta.com,Betty.Childs@PiDeltaPi.com"
		}]
	}]
}

• name
• addunsubscribelink (must be “T” per NetSuite Anit-spam policy for email marketing campaign)

• addcompanyadress
• subject
• content
• recordtype - the associated record type for Freemarker tag insertion

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "dewey.duck@dsiblobal.com",
		"recordtype": "emailtemplate",
		"targetfields": [{
			"fieldid": "name",
			"value": "Tent Sale Blast"
		},{
			"fieldid": "recordtype",
			"value": "ENTITY"
		},{
			"fieldid": "addunsubscribelink",
			"value": "T"
		},{
			"fieldid": "addcompanyaddress",
			"value": "T"
		},{
			"fieldid": "subject",
			"value": "New Customer Discount"
		},{
			"fieldid": "content",
			"value": "<p style='font-face:verdana'>Welcome new customers. Use the promo code BOGO for a special discount.</p><p='font-face:verdana'>Looking forward to working with you!<br>Welcome aboard,</br>${salesRep.MESSAGE_SIGNATURE}</p>"
		}]
	}]
}

{
	"internalid": "17",
	"recordtype": "emailtemplate"
}

{
	"internalid": "17",
	"recordtype": "emailtemplate",
	"mc_user": "daisy.duck@dsiglobal.com",
	"updatefields": [{
		"fieldid": "subject",
		"newvalue": "January Customer Appreciation Invitation"
	}]
}

{
	"internalid": "2796",
	"recordtype": "timebill",
	"mc_user": "jp.morgan@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Updated by Advanced Inventory"
	},{
		"fieldid": "hours",
		"newvalue": "2:45"
	}]
}

{
	"internalid": "1652",
	"recordtype": "employee",
	"entityid": "",
	"mc_user": "howard.hughes@dsiglobal.com",
	"updatefields": [{
		"fieldid": "firstname",
		"newvalue": "Kirk"
	},{
		"fieldid": "lastname",
		"newvalue": "Hasenzahl"
	},{
		"fieldid": "phone",
		"newvalue": "(816)416-5200"
	},{
		"fieldid": "officephone",
		"newvalue": "(816)416-5201"
	},{
		"fieldid": "mobilephone",
		"newvalue": "(816)416-5202"
	},{
		"fieldid": "homephone",
		"newvalue": "(816)416-5203"
	},{
		"fieldid": "fax",
		"newvalue": "(816)416-5204"
	}],
	"updatecolumns": [{
		"sublistid": "addressbook",
		"subrecordname":"addressbookaddress",
		"lines": [{
			"line": "1",
			"remove": "",
			"nvpair": [{
				"columnid": "defaultshipping",
				"newvalue": "T"
			},{
				"columnid": "defaultbilling",
				"newvalue": "T"
			},{
				"columnid": "label",
				"newvalue": "Main Address"
			},{
				"columnid": "isresidential",
				"newvalue": "T"
			}],
			"subrecorddetail": {
				"nvpair": [{
					"columnid": "country",
					"newvalue": "US"
				},{
					"columnid": "attention",
					"newvalue": "Kirk"
				},{
					"columnid": "addressee",
					"newvalue": "Kirk Hasenzahl"
				},{
					"columnid": "addrphone",
					"newvalue": "(816)416-5205"
				},{
					"columnid": "addr1",
					"newvalue": "501 N. Main"
				},{
					"columnid": "addr2",
					"newvalue": "Ste. 202"
				},{
					"columnid": "addr3",
					"newvalue": ""
				},{
					"columnid": "city",
					"newvalue": "Wichita"
				},{
					"columnid": "dropdownstate",
					"newvalue": "KS"
				},{
					"columnid": "zip",
					"newvalue": "67201"
				}]
			}
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "upton.sinclair@dsiglobal.com",
		"recordtype": "expensereport",
		"location": "",
		"account":"",
		"subsidiary":"",
		"targetfields": [{
			"fieldid": "entity",
			"value": "1652"
		},{
			"fieldid": "status",
			"value": "F"
		},{
			"fieldid": "memo",
			"value": "Client Lunch"
		}],
		"sublists": [{
			"sublistid": "expense",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "expensedate",
					"newvalue": "11/22/2016"
				},{
					"columnid": "category",
					"newvalue": "2"
				},{
					"columnid": "currency",
					"newvalue": "1"
				},{
					"columnid": "amount",
					"newvalue": "173.59"
				},{
					"columnid": "receipt",
					"newvalue": "T"
				},{
					"columnid": "memo",
					"newvalue": "Wine and Dine"
				}]
			},{
				"nvpair": [{
					"columnid": "expensedate",
					"newvalue": "11/22/2016"
				},{
					"columnid": "category",
					"newvalue": "3"
				},{
					"columnid": "currency",
					"newvalue": "1"
				},{
					"columnid": "amount",
					"newvalue": "44.63"
				},{
					"columnid": "receipt",
					"newvalue": "T"
				},{
					"columnid": "memo",
					"newvalue": "Drive to Wichita"
				}]
			}]
		}]
	}]
}

{
	"internalid": "37238",
	"recordtype": "expensereport",
	"mc_user": "dougie.howser@dsiglobal.com",
	"updatefields": [{
		"fieldid": "trandate",
		"newvalue": "11/30/2016"
	}],
	"updatecolumns": [{
		"sublistid": "expense",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"remove": "",
			"nvpair": [{
				"columnid": "expensedate",
				"newvalue": "12/02/2016"
			}]
		},{
			"line": "2",
			"remove": "",
			"nvpair": [{
				"columnid": "memo",
				"newvalue": "207 miles to Wichita"
			}]
		}]
	}]
}

• grouptype
• dynamic

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "junior.samples@dsiglobal.com",
		"recordtype": "entitygroup",
		"initvalues": [{
			"fieldid": "grouptype",
			"value": "CustJob"
		},{
			"fieldid": "dynamic",
			"value": "T"
		}],
		"targetfields": [{
			"fieldid": "groupowner",
			"value": "1647"
		},{
			"fieldid": "entitygrouptype",
			"value": "Customer"
		},{
			"fieldid": "comments",
			"value": "Sample Sales"
		},{
			"fieldid": "groupname",
			"value": "BR549"
		},{
			"fieldid": "savedsearch",
			"value": "10"
		},{
			"fieldid": "billinggroup",
			"value": "T"
		}]
	}]
}

{
	"internalid": "5473",
	"recordtype": "entitygroup",
	"mc_user": "grandps.jones@dsiglobal.com",
	"updatefields": [{
		"fieldid": "comments",
		"newvalue": "call BR-549"
	},{
		"fieldid": "billinggroup",
		"newvalue": "F"
	}],
	"updatecolumns": [{
		"sublistid": "",
		"lines": [{
			"line": "",
			"remove": "",
			"nvpair": [{
				"columnid": "",
				"newvalue": ""
			}]
		}]
	}]
}

• subsidiary
• location
• entityid (customer)
• One or more item lines with item and quantity
• Probability

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "Kelly.Garrett@dsiglobal.com",
		"recordtype": "estimate",
		"tranid": "",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "113"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				}]
			},{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "124"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				},{
					"columnid": "rate",
					"newvalue": "409.00"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "probability",
			"value": "50"
		},{
			"fieldid": "expectedclosedate",
			"value": "11/15/2016"
		},{
			"fieldid": "leadsource",
			"value": "100026"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Jill.Munroe@dsiglobal.com",
		"fromrecordtype": "opportunity",
		"tranid": "",
		"fromrecordid": "22913",
		"torecordtype": "estimate",
		"tolocation": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Processed by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Quote Created by Advanced Inventory"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "5"
		}]
	}]
}

{
	"internalid": "29467",
	"recordtype": "estimate",
	"tranid": "QUO00001141"
}

{
	"internalid": "29367",
	"recordtype": "estimate",
	"tranid": "QUO00001140",
	"mc_user": "Sabrina.Duncan@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "updated by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "quantity",
				"newvalue": "3"
			}],
		}]
	}]
}

{
	"internalid": "29467",
	"recordtype": "estimate",
	"tranid": "QUO00001141"
}

{
	"mc_user": "bruce.banner@dsiglobal.com",
	"filename": "Broken Part",
	"filetype": "JPGIMAGE",
	"filefolder": "-4",
	"attachto": "2956",
	"attachtype": "customer",
	"description": "This is a drawing of the ends of asparagus",
	"requirelogin": "",
	"data": "[TEXT or BASE 64 ENCODED]"
}

{
	"mc_user": "b4ugogo@dsiglobal.com",
	"fileid": "6860",
	"attachto": "2956",
	"attachtype": "customer"
}

{
	"fileid": "8370"
}

{
  "recordcategory": "custom",
  "create": [{
    "mc_user": "River.Tamm@dsiglobal.com",
    "recordtype": "customrecord_ncfar_assettype",
    "targetfields": [{
      "fieldid": "name",
      "value": "Atmosphere"
    },{
      "fieldid": "custrecord_assettypedescription",
      "value": "Air"
    },{
      "fieldid": "custrecord_assettypeaccmethod",
      "value": "2"
    },{
      "fieldid": "custrecord_assettyperesidperc",
      "value": "50"
    },{
      "fieldid": "custrecord_assettypelifetime",
      "value": "12"
    },{
      "fieldid": "custrecord_assettypedepractive",
      "value": "2"
    },{
      "fieldid": "custrecord_assettyperevisionrules",
      "value": "2"
    },{
      "fieldid": "custrecord_assettypedeprrules",
      "value": "1"
    },{
      "fieldid": "custrecord_assettypedeprperiod",
      "value": "1"
    }]
  }]
}

{
  "recordcategory": "custom",
  "create": [{
    "mc_user": "Kaylee.Frye@dsiglobal.com",
    "recordtype": "customrecord_ncfar_asset",
    "targetfields": [{
      "fieldid": "altname",
      "value": "Nitrogen"
    },{
      "fieldid": "custrecord_assettype",
      "value": "6"
    },{
      "fieldid": "custrecord_assetdescr",
      "value": "78% of atmosphere"
    },{
      "fieldid": "custrecord_assetdeprperiod",
      "value": "1"
    },{
      "fieldid": "custrecord_assetcost",
      "value": "500"
    },{
      "fieldid": "custrecord_assetresidualvalue",
      "value": "250"
    },{
      "fieldid": "custrecord_assetaccmethod",
      "value": "3"
    },{
      "fieldid": "custrecord_assettyperevisionrules",
      "value": "2"
    },{
      "fieldid": "custrecord_assetlifetime",
      "value": "60"
    }]
  }]
}

{
  "recordcategory": "custom",
  "create": [{
    "mc_user": "Malcolm.Reynolds@dsiglobal.com",
    "recordtype": "customrecord_ncfar_assetproposal",
    "targetfields": [{
      "fieldid": "altname",
      "value": "Nitrogen"
    },{
      "fieldid": "custrecord_propassettype",
      "value": "6"
    },{
      "fieldid": "custrecord_propstatus",
      "value": "1"
    },{
      "fieldid": "custrecord_propassetdescr",
      "value": "Office Air"
    },{
      "fieldid": "custrecord_propassetlifetime",
      "value": "60"
    },{
      "fieldid": "custrecord_assetresidualvalue",
      "value": "250"
    },{
      "fieldid": "custrecord_propsubsidiary",
      "value": "3"
    },{
      "fieldid": "custrecord_proplocation",
      "value": "6"
    },{
      "fieldid": "custrecord_propdeprperiod",
      "value": "1"
    },{
      "fieldid": "custrecord_assetlifetime",
      "value": "60"
    },{
      "fieldid": "custrecord_proppurchaseorder",
      "value": "40651"
    },{
      "fieldid": "custrecord_propmainacc",
      "value": "16"
    },{
      "fieldid": "custrecord_propdepracc",
      "value": "19"
    }]
  }]
}

{
  "internalid": "155",
  "recordtype": "customrecord_ncfar_asset",
  "mc_user": "Zoe.Washburne@dsiglobal.com",
  "updatefields": [{
    "fieldid": "custrecord_assetdescr",
    "newvalue": "77.95% of atmosphere"
  },{
    "fieldid": "custrecord_assetcost",
    "newvalue": "555.95"
  }]
}   

{
  "internalid": "158",
  "recordtype": "customrecord_ncfar_asset",
  "mc_user": "Simon.Tamm@dsiglobal.com",
  "updatefields": [{
    "fieldid": "custrecord_ncfar_quantity",
    "newvalue": "8"
  }]
}   

{
  "recordcategory": "custom",
  "create": [{
    "mc_user": "Simon.Tamm@dsiglobal.com",
    "recordtype": "customrecord_ncfar_asset",
    "targetfields": [{
      "fieldid": "altname",
      "value": "Carbon Dioxide 2"
    },{
      "fieldid": "custrecord_ncfar_quantity",
      "value": "2"
    },{
      "fieldid": "custrecord_assettype",
      "value": "6"
    },{
      "fieldid": "custrecord_assetdescr",
      "value": "0.1% of atmosphere"
    },{
      "fieldid": "custrecord_assetdeprperiod",
      "value": "1"
    },{
      "fieldid": "custrecord_assetcost",
      "value": "0.72"
    },{
      "fieldid": "custrecord_assetresidualvalue",
      "value": "0"
    },{
      "fieldid": "custrecord_assetaccmethod",
      "value": "2"
    },{
      "fieldid": "custrecord_assetlifetime",
      "value": "600"
    }]
  }]
}   

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "I.M.Weasel@dsiglobal.com",
		"recordtype": "inventoryadjustment",
		"entityid": "",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "inventory",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "adjustqtyby",
					"newvalue": "2"
				}],
    			"inventorydetail": {
    			    "item":"1314",
    			    "unit": "",
    			    "inventoryassignment":	[{
    			        "line": "",
        				"binnumber": "Alpha-2",
        				"binid": "",
        				"quantity": "2",
        				"inventorynumber": "",
        				"inventorynumberid": ""
        			}]
    		    }
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1009"
				},{
					"columnid": "adjustqtyby",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Adjustment created by Advanced Inventory"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "stimpson.j.cat@dsiglobal.com",
		"recordtype": "inventoryadjustment",
		"tranid": "",
		"location": "2",
		"account": "133",
		"subsidiary": "",
		"sublists": [{
			"sublistid": "inventory",
			"subrecordname": "",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "3524"
				}, {
					"columnid": "adjustqtyby",
					"newvalue": "-10"
				}, {
					"columnid": "memo",
					"newvalue": "Adjustment line created by Advanced Inventory"
				}, {
					"columnid": "location",
					"newvalue": "2"
				}, {
					"columnid": "binnumbers",
					"newvalue": "RECEIVING-H(10)"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Created by Advanced Inventory"
		}]
	}]
}

• The subsidiary and location are required.
• If no Default Inventory Count Account has been set up, the account field (internal id) is required.
• If counting an item in more than one bin, each bin must be on a separate line.

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "michael.mouse@dsiglobal.com",
		"recordtype": "inventorycount",
		"tranid": "",
		"location": "2",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
			    "junk": "Bug work-around for App Studio",
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"
				}]
			},{
			    "junk": " Bug work-around for App Studio",
				"nvpair": [{
					"columnid": "item",
					"newvalue": "678"
				},{
					"columnid": "binnumber",
					"newvalue": "117"
				}]
			},{
			    "junk": " Bug work-around for App Studio",
				"nvpair": [{
					"columnid": "item",
					"newvalue": "678"
				},{
					"columnid": "binnumber",
					"newvalue": "118"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "sortrowsbybin",
			"value": "T"
		},{
			"fieldid": "countbinswithzeroqty",
			"value": "T"
		},{
			"fieldid": "invcountstartdate",
			"value": ""
		},{
			"fieldid": "invcountenddate",
			"value": ""
		},{
			"fieldid": "transactionnumber",
			"value": ""
		},{
			"fieldid": "memo",
			"value": "RESTlet did this"
		}]
	}]
}

{
	"internalid": "",
	"recordtype": "inventorycount",
	"tranid": ""
}

{
	"internalid": "21056",
	"recordtype": "inventorycount",
	"tranid": "",
	"mc_user": "Bill.Gates@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Updated by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "3",
			"nvpair": [{
				"columnid": "countquantity",
				"newvalue": "12"
			}]
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "shaggy.rogers@dsiglobal.com",
		"recordtype": "invoice",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "950"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				},{
					"columnid": "createdfrom",
					"newvalue": "26547"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "e.scrooge@dsiglobal.com",
		"fromrecordtype": "salesorder",
		"fromrecordid": "26547",
		"torecordtype": "invoice" ,
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "bob.cratchet@dsiglobal.com",
		"fromrecordtype": "salesorder",
		"fromrecordid": "28956",
		"torecordtype": "invoice",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "invoiced line 1 and qty 1 of 10 line 3"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "partial invoice from SLS00000664"
		},{
			"fieldid": "approvalstatus",
			"value": "2"
		}],
		"sublists": [{
			"sublistid": "item",
			"subrecordname":"",
			"lines": [{
				"linenum": "1",
				"item": "2022",
				"qty": "1",
				"nvpair": [{
					"columnid": "",
					"value": ""
				}]
			},{
				"linenum": "3",
				"item": "505",
				"qty": "1",
				"nvpair": [{
					"columnid": "class",
					"value": "3"
				}]
			}]
		}]
	}]
}

{
	"transform": [{
		"mc_user": "nobody@dsiglobal.com",
		"fromrecordtype": "invoice",
		"fromrecordid": "30976",
		"torecordtype": "customerpayment",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "payment processed by Advanced Inventory"
		}],
		"targetfields": [{
				"fieldid": "approvalstatus",
				"value": "2"
			}
		}],
		"sublists": [{
			"sublistid": "apply",
			"lines": [{
				"refnum":"INV10000012",
				"nvpair": [{
					"columnid": "amount",
					"value": "100.00"
				}]
			}]
		}]
	}]
}

{
	"recordcategory": "item",
	"create": [{
		"mc_user": "Charles.Babbage@dsiglobal.com",
		"recordtype": "inventoryitem",
		"itemid": "My Other Restful Item",
		"location": "2",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "",
					"newvalue": ""
				}],
				"inventorydetail": {
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "displayname",
			"value": "Other Item of Restful Goodness"
		},{
			"fieldid": "featureddescription",
			"value": "Other Item of Restful Goodness: So there!"
		},{
			"fieldid": "salesdescription",
			"value": "Other Item of Restful Goodness: Buy it, it's restful."
		},{
			"fieldid": "isonline",
			"value": "T"
		}],
    	"pricematrix": [{
    		"row": "1",
    		"column": "1",
    		"currencyid": "1",
    		"newprice": "24.95"
    	},{
    		"row": "1",
    		"column": "1",
    		"currencyid": "2",
    		"newprice": "10.00"
    	}]
	}]
}

{
	"recordcategory": "item",
	"create": [{
		"mc_user": "Charles.Babbage@dsiglobal.com",
		"recordtype": "assemblyitem",
		"itemid": "My Restful Assembly",
		"location": "2",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "member",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				}],
				"inventorydetail": {
				}
			},{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "displayname",
			"value": "Assembly Item of Restful Goodness"
		},{
			"fieldid": "featureddescription",
			"value": "Assembly Item of Restful Goodness: So there!"
		},{
			"fieldid": "salesdescription",
			"value": "Assembly Item of Restful Goodness: Buy it, it's restful and good."
		},{
			"fieldid": "taxschedule",
			"value": "1"
		}]
	}]
}

• Body

  • item
  • subsidiary (required if One World account)
  • location (required if Multilocation is enabled)
• Order Sublist

  • orderdate
  • ordertype
  • quantity
  • receiptdate (cannot be earlier than the orderdate)
  • sourcelocation (required if ordertype is TrnfrOrd)

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "bruce.banner@dsiglobal.com",
		"recordtype": "itemsupplyplan",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "order",
			"lines": [{
				"junk":"MEP bug work around",
				"nvpair": [{
					"columnid": "orderdate",
					"newvalue": "12/14/2016"
				},{
					"columnid": "ordertype",
					"newvalue": "WorkOrd"
				},{
					"columnid": "quantity",
					"newvalue": "10"
				},{
					"columnid": "receiptdate",
					"newvalue": "12/15/2016"
				},{
					"columnid": "sourcelocation",
					"newvalue": ""
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "item",
			"value": "993"
		},{
			"fieldid": "units",
			"value": ""
		},{
			"fieldid": "memo",
			"value": "Created by Advanced Inventory"
		}]
	}]
}

{
	"internalid": "155",
	"recordtype": "itemsupplyplan",
	"mc_user": "david.banner@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Updated by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "order",
		"lines": [{
			"line": "1",
			"remove": "",
			"nvpair": [{
				"columnid": "ordertype",
				"newvalue": "TrnfrOrd"
			},{
				"columnid": "sourcelocation",
				"newvalue": "1"
			}]
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "patros.chronos@dsiglobal.com",
		"recordtype": "lead",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "addressbook",
			"subrecordname":"inventorydetails",
			"lines": [{
				"nvpair": [{
					"columnid": "addr1",
					"newvalue": "1201 Boardwalk"
				}, {
					"columnid": "city",
					"newvalue": "Monopolyville"
				}, {
					"columnid": "state",
					"newvalue": "NJ"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "companyname",
			"value": "The Dude Abides Inc."
		},{
			"fieldid": "email",
			"value": "dude@abides.com"
		},{
			"fieldid": "phone",
			"value": "(913) 555-1212"
		},{
			"fieldid": "salesrep",
			"value": "4066"
		}]
	}]
}

{
	"internalid": "",
	"recordtype": "lead",
	"searchfields": [{
		"fieldid": "email",
		"operator": "startswith",
		"searchvalue": "dude"
	}]
}

{
	"searchtype": "lead",
	"searchfilters": [{
		"fieldid": "entityid",
		"operator": "startswith",
		"searchvalue": "The Dude Abides",
		"searchvalue2": "",
		"join": ""
	}],
	"searchcolumns": [{
		"fieldid": "email"
	},{
		"fieldid": "phone"
	}]
}

{
	"internalid": "4268",
	"recordtype": "lead",
	"entityid": "",
	"updatefields": [{
		"fieldid": "altemail",
		"newvalue": "dudette@abides.com"
	}]
}

• title
• startdate

• owner (filter manager) - manager in charge of this campaign (internal ID of employee record)
• enddate
• keyword and the associated searchengine and family (internal ID of campaign family record)
• landing page url
• category (internal ID of campaign category record)
• audience (internal ID of campaign audience record)
• vertical (internal ID of campaign vertical record)
• promotioncode and an array of item to which it applies

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "scrooge.mcduck@dsiglobal.com",
		"recordtype": "campaign",
		"targetfields": [{
			"fieldid": "title",
			"value": "Hatchling's Tent Campaign"
		},{
			"fieldid": "owner",
			"value": "4066"
		},{
			"fieldid": "startdate",
			"value": "1/9/2017"
		},{
			"fieldid": "enddate",
			"value": "1/13/2017"
		},{
			"fieldid": "item",
			"value": ["1314","1920"]
		},{
			"fieldid": "keyword",
			"value": "TENT"
		},{
			"fieldid": "category",
			"value": "-11"
		},{
			"fieldid": "promotioncode",
			"value": "15"
		},{
			"fieldid": "url",
			"value": "http://www.tentbogo.com"
		},{
			"fieldid": "basecost",
			"value": "10000"
		},{
			"fieldid": "vertical",
			"value": "2"
		},{
			"fieldid": "audience",
			"value": "1"
		}]
	}]
}

{
	"internalid": "",
	"recordtype": "campaign",
	"searchfields": [{
		"fieldid": "manager",
		"operator": "anyof",
		"searchvalue": "4066"
	}]
}

{
	"searchtype": "campaign",
	"searchfilters": [{
		"fieldid": "enddate",
		"operator": "onorafter",
		"searchvalue": "daysago0",
		"searchvalue2": "",
		"join": ""
	}],
	"searchcolumns": [{
		"fieldid": "title"
	},{
		"fieldid": "campaignid"
	},{
		"fieldid": "owner"
	},{
		"fieldid": "enddate"
	}]
}

{
	"internalid": "103213",
	"recordtype": "campaign",
	"mc_user": "hewey.duck@dsiglobal.com",
	"updatefields": [{
		"fieldid": "owner",
		"newvalue": "1647"
	}]
}

{
	"recordtype": "campaign",
	"mc_user": "louis.duck@dsiblogal.com",
	"includeinactive": "",
	"filterexpression":"",
	"searchfields": [{
		"fieldid": "manager",
		"operator": "anyof",
		"searchvalue": "1647"
	},{
		"fieldid": "enddate",
		"operator": "onorafter",
		"searchvalue": "daysago0"
	}],
	"updatefields": [{
		"fieldid": "owner",
		"newvalue": "4066"
	}]
}

{
	"internalid": "103213",
	"recordtype": "campaign",
	"mc_user": "dewy.duck@dsiglobal.com",
	"updatefields": [{
		"fieldid": "message",
		"newvalue": "March Email Blast"
	}],
	"updatecolumns": [{
		"sublistid": "campaignemail",
		"lines": [{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "campaigngroup",
				"newvalue": "4370"
			},{
				"columnid": "channel",
				"newvalue": "-2"
			},{
				"columnid": "datescheduled",
				"newvalue": "3/1/2017"
			},{
				"columnid": "description",
				"newvalue": "New Customer Blast"
			},{
				"columnid": "subscription",
				"newvalue": "1"
			},{
				"columnid": "template",
				"newvalue": "320"
			},{
				"columnid": "cost",
				"newvalue": "5000"
			},{
				"columnid": "promocode",
				"newvalue": "5"
			},{
				"columnid": "timescheduled",
				"newvalue": "9:00 am"
			},{
				"columnid": "testcell",
				"newvalue": ""
			}]
		}]
	}]
}

{
	"internalid": "103213",
	"recordtype": "campaign",
	"mc_user": "howard.duck@dsiglobal.com",
	"updatefields": [{
		"fieldid": "message",
		"newvalue": "Email drip to leads and prospects"
	}],
	"updatecolumns": [{
		"sublistid": "campaigndrip",
		"lines": [{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "channel",
				"newvalue": "-7"
			},{
				"columnid": "datescheduled",
				"newvalue": "3/1/2017"
			},{
				"columnid": "description",
				"newvalue": "New Customer Promotion"
			},{
				"columnid": "subscription",
				"newvalue": "1"
			},{
				"columnid": "template",
				"newvalue": "12"
			},{
				"columnid": "cost",
				"newvalue": "400"
			},{
				"columnid": "promocode",
				"newvalue": "2"
			}]
		}]
	}]
}

{
	"internalid": "103313",
	"recordtype": "campaign",
	"mc_user": "daffy.duck@dsiglobal.com",
	"updatefields": [{
		"fieldid": "message",
		"newvalue": "Direct Mail to leads and prospects"
	}],
	"updatecolumns": [{
		"sublistid": "campaigndirectmail",
		"lines": [{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "campaigngroup",
				"newvalue": "4370"
			},{
				"columnid": "channel",
				"newvalue": "-3"
			},{
				"columnid": "datescheduled",
				"newvalue": "2/1/2017"
			},{
				"columnid": "description",
				"newvalue": "New Customer Junk Mail"
			},{
				"columnid": "subscription",
				"newvalue": "1"
			},{
				"columnid": "cost",
				"newvalue": "4000"
			},{
				"columnid": "promocode",
				"newvalue": "2"
			}]
		}]
	}]
}

{
	"internalid": "103313",
	"recordtype": "campaign",
	"mc_user": "daffy.duck@dsiglobal.com",
	"updatefields": [{
		"fieldid": "message",
		"newvalue": "Use the Call Center"
	}],
	"updatecolumns": [{
		"sublistid": "campaignevent",
		"lines": [{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "campaigngroup",
				"newvalue": "4370"
			},{
				"columnid": "channel",
				"newvalue": "-4"
			},{
				"columnid": "datescheduled",
				"newvalue": "2/1/2017"
			},{
				"columnid": "description",
				"newvalue": "Phone Prospects"
			},{
				"columnid": "subscription",
				"newvalue": "1"
			},{
				"columnid": "cost",
				"newvalue": "4000"
			},{
				"columnid": "promocode",
				"newvalue": "2"
			}]
		}]
	}]
}

• subsidiary
• location
• entityid (customer)
• One or more item lines with item and quantity
• probability

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "Charles.Townsend@dsiglobal.com",
		"recordtype": "opportunity",
		"tranid": "",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "113"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				}
			},{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "124"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				},{
					"columnid": "rate",
					"newvalue": "409.00"
				}]
			},{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "123"
				},{
					"columnid": "quantity",
					"newvalue": "5"
				},{
					"columnid": "rate",
					"newvalue": "299.00"
				}]
			}]
		    }
		}],
		"targetfields": [{
			"fieldid": "probability",
			"value": "25"
		},{
			"fieldid": "title",
			"value": "Wheel Chair Assortment"
		},{
			"fieldid": "expectedclosedate",
			"value": "11/1/2016"
		},{
			"fieldid": "salesreadiness",
			"value": "3"
		},{
			"fieldid": "leadsource",
			"value": "100026"
		}]
	}]
}

{
	"internalid": "25329",
	"recordtype": "opportunity",
	"tranid": "QUO00001139"
}

{
	"internalid": "25329",
	"recordtype": "opportunity",
	"tranid": "QUO00001139",
	"mc_user": "Sabrina.Duncan@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "updated by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "quantity",
				"newvalue": "3"
			}],
		}]
	}]
}

{
	"internalid": "25329",
	"recordtype": "opportunity",
	"tranid": "QUO00001139"
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "William.Gates@dsiglobal.com",
		"recordtype": "partner",
		"entityid": "",
		"location": "",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "addressbook",
			""subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "addr1",
					"newvalue": "101 Main St."
				}, {
					"columnid": "city",
					"newvalue": "Hooterville"
				}, {
					"columnid": "state",
					"newvalue": "IL"
				}],
				"inventorydetail": {
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "companyname",
			"value": "Drucker General Store"
		}, {
			"fieldid": "isperson",
			"value": "F"
		}, {
			"fieldid": "email",
			"value": "sam@drucker.com"
		}, {
			"fieldid": "comments",
			"value": "Retail, Newspaper, Constable, Justice of the Peace, Post Office "
		}]
	}]
}

{
	"internalid": "25636",
	"type": "TRANSACTION",
	"tranid": "",
	"recordtype": "",
	"formnumber": "98"
}
or
{
	"internalid": "",
	"type": "TRANSACTION",
	"tranid": "SLS00000672",
	"recordtype": "salesorder",
	"formnumber": ""
}

{
	"internalid": "28955",
	"type": "PACKINGSLIP",
	"tranid": "",
	"recordtype": "",
	"formnumber": "82"
}
or
{
	"internalid": "",
	"type": "PACKINGSLIP",
	"tranid": "SLS00000672",
	"recordtype": "salesorder",
	"formnumber": "82"
}

{
	"internalid": "28953",
	"type": "PICKINGTICKET",
	"tranid": "",
	"recordtype": "",
	"formnumber": "83",
	"pickingticket": {
		"shipgroup": "",
		"location": ""
	}
}
or
{
	"internalid": "",
	"type": "PICKINGTICKET",
	"tranid": "SHI00000414",
	"recordtype": "itemfulfillment",
	"formnumber": "83",
	"pickingticket": {
		"shipgroup": "5",
		"location": "2"
	}
}

{
	"internalid": "34324",
	"type": "BILLOFMATERIAL",
	"tranid": "",
	"recordtype": "",
	"formnumber": "62"
}
or
{
	"internalid": "",
	"type": "BILLOFMATERIAL",
	"tranid": "WRK00000302",
	"recordtype": "workorder",
	"formnumber": "62"
}

{
	"internalid": "2956",
	"type": "STATEMENT",
	"formnumber": "81",
	"statement": {
		"startdate": "",
		"statementdate": "",
		"openonly": ""
	}
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "Freddy.Jones@dsiglobal.com",
		"recordtype": "job",
		"entityid": "",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "jobresources",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "jobresource",
					"newvalue": "114"
				},{
					"columnid": "role",
					"newvalue": "-2"
				}]
			},{
				"nvpair": [{
					"columnid": "jobresource",
					"newvalue": "117"
				},{
					"columnid": "role",
					"newvalue": "-3"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "parent",
			"value": "14"
		},{
			"fieldid": "companyname",
			"value": "KC Tents: Weekend Camp"
		},{
			"fieldid": "allowtime",
			"value": "T"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "jay.garrick@dsiglobal.com",
		"recordtype": "estimate",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "job",
			"value": "4062"
		},{
			"fieldid": "title",
			"value": "Sell stuff from project"
		},{
			"fieldid": "opportunity",
			"value": "33382"
		}]
	}]
}

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "lana.lang@dsiglobal.com",
		"recordtype": "projecttask",
		"tranid": "RESTlet Task",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
		"sublistid": "assignee",
			"lines": [{
				"nvpair": [{
					"columnid": "resource",
					"newvalue": "1626"
				},{
					"columnid": "serviceitem",
					"newvalue": "2024"
				},{
					"columnid": "estimatedwork",
					"newvalue": "16"
				},{
					"columnid": "unitcost",
					"newvalue": "15.00"
				}]
		    },{
				"nvpair": [{
					"columnid": "resource",
					"newvalue": "1644"
				},{
					"columnid": "serviceitem",
					"newvalue": "2024"
				},{
					"columnid": "estimatedwork",
					"newvalue": "4"
				},{
					"columnid": "unitcost",
					"newvalue": "65.00"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "title",
			"value": "RESTlet Task"
		},{
			"fieldid": "company",
			"value": "4062"
		},{
			"fieldid": "finishbydate",
			"value": "10/26/2016"
		}]
	}]
}

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "lana.lang@dsiglobal.com",
		"recordtype": "projecttask",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "assignee",
				"lines": [{
					"nvpair": [{
						"columnid": "resource",
						"newvalue": "1626"
					},{
						"columnid": "serviceitem",
						"newvalue": "2024"
					},{
						"columnid": "estimatedwork",
						"newvalue": "8"
					},{
						"columnid": "unitcost",
						"newvalue": "15.00"
					}]
				}]
		},{
			"sublistid": "predecessor",
				"lines": [{
					"nvpair": [{
						"columnid": "task",
						"newvalue": "101901"
					},{
						"columnid": "type",
						"newvalue": "SS"
					},{
						"columnid": "startdate",
						"newvalue": "10/24/2016"
					}]
				}]
		}],
		"targetfields": [{
			"fieldid": "title",
			"value": "RESTlet SubTask"
		},{
			"fieldid": "company",
			"value": "4062"
		},{
			"fieldid": "finishbydate",
			"value": "10/26/2016"
		}]
	}]
}

• Projects and Time and Materials Billing - Bill customers for actual project expenses, such as resource time and materials.
• Fixed Bid, Interval Billing Schedules - Bill customers for work completed at predefined intervals.
• Fixed Bid, Milestone Billing Schedules - Bill customers based on percent of work completed, or preset milestones.
• Charge-Based Project Billing - If you use the Charge-Based Billing feature, you can create charge rules that provide added flexibility for calculating billable value on projects.

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "quincy.magoo@dsiglobal.com",
		"recordtype": "billingschedule",
		"targetfields": [{
			"fieldid": "name",
			"value": "Continuing Service for Douglas Farm"
		},{
			"fieldid": "frequency",
			"value": "MONTHLY"
		},{
			"fieldid": "inarrears",
			"value": "T"
		},{
			"fieldid": "initialamount",
			"value": "0"
		},{
			"fieldid": "numberremaining",
			"value": "6"
		},{
			"fieldid": "repeatevery",
			"value": "1"
		},{
			"fieldid": "public",
			"value": "F"
		}]
	}]
}

{
	"internalid": "102302",
	"recordtype": "task",
	"mc_user": "fats.domino@dsiglobal.com",
	"updatefields": [{
		"fieldid": "percentcomplete",
		"newvalue": "100"
	}],
	"updatecolumns": [{
		"sublistid": "timeitem",
		"lines": [{
			"line": "NEW",
			"remove": "",
			"nvpair": [{
				"columnid": "customer",
				"newvalue": "4062"
			},{
				"columnid": "employee",
				"newvalue": "1626"
			},{
				"columnid": "hours",
				"newvalue": "3:45"
			},{
				"columnid": "item",
				"newvalue": "2024"
			},{
				"columnid": "location",
				"newvalue": "2"
			},{
				"columnid": "isbillable",
				"newvalue": "T"
			},{
				"columnid": "timetype",
				"newvalue": "A"
			},{
				"columnid": "memo",
				"newvalue": "working a client site"
			}]
		}]
	}]
}

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "lana.lang@dsiglobal.com",
		"recordtype": "projecttask",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "predecessor",
			"lines": [{
				"nvpair": [{
					"columnid": "task",
					"newvalue": "101901"
				},{
					"columnid": "type",
					"newvalue": "SS"
				},{
					"columnid": "startdate",
					"newvalue": "10/24/2016"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "title",
			"value": "RESTlet SubTask - Day 1"
		},{
			"fieldid": "company",
			"value": "4062"
		},{
			"fieldid": "ismilestone",
			"value": "T"
		},{
			"fieldid": "enddate",
			"value": "10/24/2016"
		},{
			"fieldid": "message",
			"value": "Completed Day 1"
		}]
	}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "santa.claus@dsiglobal.com",
		"recordtype": "genericresource",
		"location": "2",
		"subsidiary":"1",
		"targetfields": [{
			"fieldid": "entityid",
			"value": "Assembly Worker"
		},{
			"fieldid": "laborcost",
			"value": "12.65"
		},{
			"fieldid": "workcalendar",
			"value": "1"
		}]
	}]
}

• 1. Labor
• 4. Expense
• 6. Supplier
• 8. Other

{
	"internalid": "4062",
	"recordtype": "job",
	"entityid": "",	
	"mc_user": "wile.coyote@dsiglobal.com",
	"updatefields": [{
		"fieldid": "cbudgetusecalculatedvalues",
		"newvalue": "F"
	}],
	"updatecolumns": [{
		"sublistid": "cbudget",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "1000"
			}]
		},{
			"line": "4",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "100"
			}]
		},{
			"line": "6",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "12395.41"
			}]
		},{
			"line": "8",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "9.95"
			}]
		}]
	}]
}

• 1. Labor
• 3. Expense
• 5. Supplier
• 7. Other

{
	"internalid": "4062",
	"recordtype": "job",
	"entityid": "",	
	"mc_user": "wile.coyote@dsiglobal.com",
	"updatefields": [{
		"fieldid": "bbudgetusecalculatedvalues",
		"newvalue": "F"
	}],
	"updatecolumns": [{
		"sublistid": "bbudget",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "1000"
			}]
		},{
			"line": "3",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "100"
			}]
		},{
			"line": "5",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "12395.41"
			}]
		},{
			"line": "7",
			"nvpair": [{
				"columnid": "totalamount",
				"newvalue": "9.95"
			}]
		}]
	}]
}

• recordcategory: "transaction”

  In each member of the create array:

  • recordtype: “purchaseorder”
  • mc_user: name/userid of user logged into mobile client
  • subsidiary: internal id of the subsidiary (one world only, req)
  • location: internal id of the location (multi location only, req)
  • tranid: a string to override the tranid of the new record (optional)
  • entityid: internal id of the vendor (required)
  • targetfields array member (repeatable for additional body fields as desired)

    • fieldid
    • value

• sublists: one member for each sublist, item sublist required
• lines array: (repeatable for all items desired, at least one required)

  • nvpair: repeatable, one for each field on the line

    • columnid item: newvalue internal id of item to purchase
    • columnid qty: newvalue integer quantity to purchase
  • inventorydetail: repeatable, see the inventory detail section

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "bulwinkle.j.moose@dsiglobal.com",
		"recordtype": "purchaseorder",
		"tranid": "",
		"entityid": "",
		"location": "",
		"subsidiary":"",
		"sublists": [{
			"sublistid": "",
			"subrecordname":"inventorydetails",
			"lines": [{
				"nvpair": [{
					"columnid": "",
					"newvalue": ""
				}],
				"inventorydetail": {
					"item": "",
					"location": "",
					"tolocation": "",
					"quantity": "",
					"unit": "",
					"inventoryassignment": [{
						"line": "",
						"binnumber": "",
						"binid": "",
						"tobinnumber": "",
						"tobinid": "",
						"quantity": "",
						"inventorynumber": "",
						"inventorynumberid": "",
						"expirationdate": ""
					}]
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": ""
		}]
	}]
}

{
                "internalid": "",
                "recordtype": "purchaseorder",
                "tranid": "",
                "updatefields": [{
                                "fieldid": "approvalstatus",
                                "newvalue": "2"
                }]
}

{
	"transform": [{
		"mc_user": "",
		"fromrecordtype": "purchaseorder",
		"tranid": "",
		"fromrecordid": "",
		"torecordtype": "itemreceipt",
		"tolocation": "",
		"pps": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Created from Mobile Client"
		}],
		"lines": [{
			"linenum": "",
			"item": "",
			"qty": ""
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "",
		"recordtype": "purchaseorder",
		"tranid": "",
		"entityid": "",
		"location": "",
		"subsidiary":"",
		"sublists": [{
			"sublistid": "",
			"subrecordname":"inventorydetails",
			"lines": [{
				"nvpair": [{
					"columnid": "",
					"newvalue": ""
				}],
				"inventorydetail": {
					"item": "",
					"location": "",
					"tolocation": "",
					"quantity": "",
					"unit": "",
					"inventoryassignment": [{
						"line": "",
						"binnumber": "",
						"binid": "",
						"tobinnumber": "",
						"tobinid": "",
						"quantity": "",
						"inventorynumber": "",
						"inventorynumberid": "",
						"expirationdate": ""
					}]
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "supervisorapproval",
			"value": "1"
		},{
			"fieldid": "employee",
			"value": ""
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Logan.Howlett@dsiglobal.com",
		"fromrecordtype": "cashsale",
		"tranid": "",
		"fromrecordid": "22813",
		"torecordtype": "returnauthorization",
		"location": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Refunded by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "orderstatus",
			"value": "B"
		},{
			"fieldid": "memo",
			"value": "I did this, bub."
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "Charles.Xavier@dsiglobal.com",
		"recordtype": "returnauthorization",
		"tranid": "",
		"entityid": "2956",
		"subsidiary":"1",
		"location": "2",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"	
				},{
					"columnid": "quantity",
					"newvalue": "2"
				},{
					"columnid": "rate",
					"newvalue": "18.95"
				}]
			},{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1818"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "customform",
			"value": "85"
		},{
			"fieldid": "orderstatus",
			"value": "A"
		}]
	}]
}

{
	"internalid": "",
	"recordtype": "returnauthorization",
	"tranid": "RMA00000028",
	"mc_user": "Scott.Summers@dsiglobal.com",
	"updatefields": [{
		"fieldid": "orderstatus",
		"newvalue": "B"
	}]
}

{
	"internalid": "24726",
	"recordtype": "returnauthorization",
	"tranid": "",
	"mc_user": "Jean.Grey@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "ALL",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"mc_user": "Hank.McCoy@dsiglobal.com",
	"tranid":"",
	"internalid": "24726",
	"recordtype": "returnauthorization",
}

{
	"transform": [{
		"mc_user": "Ororo.Monroe@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"tranid": "",
		"fromrecordid": "24726",
		"torecordtype": "itemreceipt",
		"tolocation": "2",
		"location": "",
		"pps": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Storm did this"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1214",
			"qty": "2",
			"binnumbers": "",
			"serialnumbers": "",
			"nvpair": [{
				"columnid": "",
				"newvalue": ""
			}],
			"inventorydetail": {
				"item": "",
				"barcode": "",
				"location": "",
				"tolocation": "",
				"quantity": "",
				"unit": "",
				"inventoryassignment": [{
					"line": "",
					"binnumber": "",
					"binid": "",
					"tobinnumber": "",
					"tobinid": "",
					"quantity": "",
					"inventorynumber": "",
					"inventorynumberid": "",
					"expirationdate": ""
				}]
			}
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Magnus.Eisenhardt@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"tranid": "",
		"fromrecordid": "24726",
		"torecordtype": "itemreceipt",
		"tolocation": "2",
		"location": "",
		"pps": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Magneto did this"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Remy.LeBeau@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"tranid": "",
		"fromrecordid": "24726",
		"torecordtype": "creditmemo",
		"tolocation": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Gambit did this"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1214",
			"qty": "2",
			"binnumbers": "",
			"serialnumbers": "",
			"nvpair": [{
				"columnid": "",
				"newvalue": ""
			}],
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Tony.Stark@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"tranid": "",
		"fromrecordid": "24726",
		"torecordtype": "cashrefund",
		"tolocation": "2",
		"location": "",
		"pps": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Received by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "account",
			"value": "1"
		},{
			"fieldid": "memo",
			"value": "Iron Man did this"
		}]
	}]
}

{
	"searchtype": "customer",
	"searchid": "customsearch_dsi_walmart",
	"sortedbyinternalid":"F"
}
Or
{
	"searchtype": "customer",
	"searchid": "1263",
	"sortedbyinternalid":"F"
}

{
	"searchtype": "customer",
	"searchid": "customsearch_dsi_walmart",
	"sortedbyinternalid":"",
	"searchfilters": [{
		"fieldid": "entityid",
		"operator": "startswith",
		"searchvalue": "James"
	}],
	"searchcolumns": [{
		"fieldid": "phone"
	}]
}

{
	"searchtype": "transaction",
	"searchid": "",
	"sortedbyinternalid":"T",
	"searchfilters": [{
		"fieldid": "lastmodifieddate",
		"operator": "within",
		"searchvalue": "4/6/2016",
		"searchvalue2": "10/6/2016",
		"join": ""
	},{
		"fieldid": "internalid",
		"operator": "",
		"searchvalue": "1314",
		"searchvalue2": "",
		"join": "item"
	},{
		"fieldid": "type",
		"operator": "anyof",
		"searchvalue": "PurchOrd",
		"searchvalue2": "",
		"join": ""
	}],
	"searchcolumns": [{
		"fieldid": "quantity",
		"join": ""
	},{
		"fieldid": "amount",
		"join": ""
	},{
		"fieldid": "location",
		"join": ""
	},{
		"fieldid": "displayname",
		"join": "item"
	}]
}

{
	"searchtype": "item",
	"searchid": "",
	"loadrecords":"",
	"containsjson":"",
	"filetype":"",
	"savefile":"",
	"filename":"",
	"folderid":"",
	"filterexpression":"[[['name','startswith','ACC'],'OR',['name','startswith','HDW']], 'AND',['type','noneof',['Assembly','Group','Kit']],'AND',['formulanumeric: CASE WHEN {quantityonhand} > {quantitycommitted} THEN 1 ELSE 0 END','equalto','1']]",
	"searchcolumns": [{
		"fieldid": "itemid",
		"join": "",
		"text":""	
	}]
}

{
	"searchtype": "item",
	"sortedbyinternalid":"F",
	"searchfilters": [{
		"fieldid": "internalid",
		"operator": "anyof",
		"searchvalue": "678"
	}],
	"searchcolumns": [{
		"fieldid": "binnumber",
		"join": "inventorynumberbinonhand",
		"summary":"GROUP"
	},{
		"fieldid": "inventorynumber",
		"join": "inventorynumberbinonhand",
		"summary":"GROUP"
	},{
		"fieldid": "quantityonhand",
		"join": "inventorynumberbinonhand",
		"summary":"GROUP"
	},{
		"fieldid": "quantityavailable",
		"join": "inventoryNumberBinOnHand",
		"summary":"GROUP"
	}]
}

{
	"searchtype": "item",
	"searchid": "",
	"sortedbyinternalid":"",
	"filetype":"csv",
	"savefile":"T",
	"filename":"savethis",
	"folderid":"695",
	"searchfilters": [{
		"fieldid": "created",
		"operator": "onorafter",
		"searchvalue": "1/1/2016",
		"searchvalue2": "",
		"join": ""
	}],
	"searchcolumns": [{
		"fieldid": "itemid",
		"join": "",
		"text":""
	},{
		"fieldid": "description",
		"join": "",
		"text":""
	},{
		"fieldid": "storedisplayimage",
		"join": "",
		"text":""
	},{
		"fieldid": "storedisplayimage",
		"join": "",
		"text":"T"
	}]
}

{
  "RESULTS": [
    {
      "file": {
        "fileid": 12385,
        "filename": "savethis.csv",
        "filesize": "911",
        "folderid": "-14",
        "encoding": "UTF-8",
        "isonline": "false"
      },
      "csvdata": "BASE 64 ENCODED STRING”
    }
  ]
}

• Optional: To return the name of a field that normally returns an internal id, set the text field in that searchcolumns to ‘T'.
• Optional: Set the savefile field to ‘T' to save the pdf file to the file cabinet.
• Optional: Provide a filename (without extension) for the saved file.
• Optional: Provide a folder (by internal id) for the saved file with folderid. Defaults to Attachments Sent folder.

{
	"searchtype": "item",
	"searchid": "",
	"sortedbyinternalid":"",
	"filetype":"pdf",
	"savefile":"T",
	"filename":"itemsThatStartWithACC",
	"folderid":"",
	"filterexpression":"",
	"searchfilters": [{
		"fieldid": "itemid",
		"operator": "startswith",
		"searchvalue": "ACC",
		"searchvalue2": "",
		"join": ""
	}],
	"searchcolumns": [{
		"fieldid": "itemid",
		"join": "",
		"text":""
	},{
		"fieldid": "displayname",
		"join": "",
		"text":""
	},{
		"fieldid": "storedisplayimage",
		"join": "",
		"text":"T"
	}]
}

{
  "RESULTS": [
    {
      "file": {
        "fileid": 12185,
        "filename": "itemsThatStartWithACC.pdf",
        "filesize": "3596",
        "folderid": "-14",
        "encoding": "UTF-8",
        "isonline": "false"
      },
      "pdfdata": "BASE 64 ENCODED STRING”
    }
  ]
}

• Subsidiary
• Location
• Entity
• One or more item lines with item and quantity

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "Stimpson.Cat@dsiglobal.com",
		"recordtype": "salesorder",
		"tranid": "",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
		"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				}]
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1008"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1009"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "orderstatus",
			"value": "A"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Red.Guy@dsiglobal.com",
		"fromrecordtype": "estimate",
		"tranid": "",
		"fromrecordid": "25330",
		"torecordtype": "salesorder",
		"location": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Cash Sale by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Mama had a chicken. Mama had a cow. "
		}],
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "1",
			"nvpair": [{
				"columnid": "taxcode",
				"value": "638"
			}]
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Nyota.Uhura@dsiglobal.com",
		"fromrecordtype": "customer",
		"tranid": "",
		"fromrecordid": "2956",
		"torecordtype": "salesorder",
		"tolocation": "2",
		"location": "2",
		"sourcefields": [{
			"fieldid": "comments",
			"value": "This sucker will buy anything."
		}],
		"targetfields": [{
			"fieldid": "otherrefnum",
			"value": "PO123456"
		},{
			"fieldid": "orderstatus",
			"value": "B"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "1"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Loula.Belle@dsiglobal.com",
		"fromrecordtype": "opportunity",
		"tranid": "",
		"fromrecordid": "22913",
		"torecordtype": "salesorder",
		"tolocation": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Processed by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Sales Order Created by Advanced Inventory"
		}],
		"lines": [{
			"linenum": "1",
			"item": "1314",
			"qty": "5"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "rose.tylor@dsiglobal.com",
		"recordtype": "salesorder",
		"tranid": "",
		"itemid": "",
		"entityid": "2956",
		"location": "2",
		"transferlocation": "",
		"account":"",
		"subsidiary":"1",
		"sublists": [{
		"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				},{
    				"columnid": "createpo",
    				"newvalue": "DropShip"
			}]
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1818"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "customform",
			"value": "103"
		},{
			"fieldid": "orderstatus",
			"value": "B"
		}]
	}]
}

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "rose.tylor@dsiglobal.com",
		"recordtype": "salesorder",
		"tranid": "",
		"itemid": "",
		"entityid": "2956",
		"location": "2",
		"transferlocation": "",
		"account":"",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				},{
    				"columnid": "createpo",
    				"newvalue": "DropShip"
			}]
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1818"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "customform",
			"value": "103"
		},{
			"fieldid": "orderstatus",
			"value": "B"
		}]
	}]
}

{
	"internalid": "",
	"recordtype": "salesorder",
	"tranid": "SLS00000620",
	"mc_user": "Ren.Hoek@dsiglobal.com",
	"updatefields": [{
		"fieldid": "orderstatus",
		"newvalue": "B"
	}]
}

{
	"internalid": "22707",
	"recordtype": "salesorder",
	"tranid": "",
	"mc_user": "Haggis.McHaggis@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "ALL",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"internalid": "22707",
	"recordtype": "salesorder",
	"tranid": "",
	"mc_user": "Haggis.McHaggis@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Line 1 closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"mc_user": "Hewey.Lewis@dsiglobal.com",
	"tranid":"SLS00000625",
	"internalid": "",
	"recordtype": "salesorder"
}

{
	"transform": [{
		"mc_user": "Sven.Hoek@dsiglobal.com",
		"fromrecordtype": "salesorder",
		"tranid": "",
		"fromrecordid": "21166",
		"torecordtype": "itemfulfillment",
		"tolocation": "2",
		"location": "2",
		"pps": "picked",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Fulfilled by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Created by Advanced Inventory"
		}],
		"sublists": [{
			"sublistid": "item",
			"subrecordname":"",
			"lines": [{
				"linenum": "",
				"item": "678",
				"qty": "100",
				"binnumbers": "",
				"serialnumbers": "",
				"refnum":"",
				"nvpair": [{
					"columnid": "",
					"value": ""
				}],
				"inventorydetail": {
					"item": "678",
					"barcode": "",
					"location": "",
					"tolocation": "2",
					"quantity": "100",
					"unit": "",
					"inventoryassignment": [{
						"binnumber": " Alpha-1",
						"binid": "",
						"tobinnumber": "",
						"tobinid": "",
						"quantity": "100",
						"inventorynumber": "L-Alpha1",
						"inventorynumberid": "",
						"expirationdate": ""
					}]
				}
			}]
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Bubba.Gump@dsiglobal.com",
		"fromrecordtype": "salesorder",
		"tranid": "",
		"fromrecordid": "23922",
		"torecordtype": "itemfulfillment",
		"tolocation": "2",
		"pps": "picked",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "This Order Fulfilled by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "This Item Fulfillment created by Advanced Inventory"
		}]
	}]
}

• Subsidiary
• Company
• Title

{
	"recordcategory": "event",
	"create": [{
		"mc_user": "happy.gilmore@dsiglobal.com",
		"recordtype": "supportcase",
,
		"subsidiary": "1",
		"targetfields": [{
			"fieldid": "company",
			"value": "2956"
		}, {
			"fieldid": "title",
			"value": "It wont work"
		}, {
			"fieldid": "assigned",
			"value": "1646"
		}, {
			"fieldid": "incomingmessage",
			"value": "The pig didn't like it. We want a refund."
		}]
	}]
}

{
	"internalid": "101287",
	"recordtype": "supportcase",
	"mc_user": "sleeper.awakened@dsiglobal.com",
	"updatefields": [{
			"fieldid": "status",
			"newvalue": "2"
		}]
}

{
	"internalid": "101287",
	"recordtype": "supportcase",
	"mc_user": "kwisatx.haderach@dsiglobal.com",
	"updatefields": [{
			"fieldid": "status",
			"newvalue": "3"
		},{
			"fieldid": "escalationmessage",
			"newvalue": "I don't know how to fix this. The Boss said you should do it."
		}],
	"updatecolumns": [{
		"sublistid": "escalateto",
		"subrecordname":"",
		"lines": [{
			"line": "NEW",
			"nvpair": [{
				"columnid": "escalatee",
				"newvalue": "1626"
			}]
		}]
	}]
}

{
	"internalid": "101287",
	"recordtype": "supportcase",
	"mc_user": "sleeper.awakened@dsiglobal.com",
	"updatefields": [{
			"fieldid": "messagenew",
			"newvalue": "T"
		},{
			"fieldid": "incomingmessage",
			"newvalue": "Thank you for contacting support.  Unfortunately, our product is not meant to be consumed by pigs. Closing this case."
		},{
			"fieldid": "status",
			"newvalue": "5"
		}]
}

{
	"recordcategory": "entity",
	"create": [{
		"mc_user": "William.Gates@dsiglobal.com",
		"recordtype": "vendor",
		"entityid": "",
		"location": "",
		"subsidiary": "1",
		"sublists": [{
			"sublistid": "currency",
"subrecordname":"inventorydetails",
			"lines": [{
				"nvpair": [{
					"columnid": "currency",
					"newvalue": "2"
				}],
				"inventorydetail": {
				}
			},{
				"nvpair": [{
					"columnid": "currency",
					"newvalue": "1"
				}],
				"inventorydetail": {
				}
			}]
		}],
		"targetfields": [{
			"fieldid": "firstname",
			"value": "Arnold"
		}, {
			"fieldid": "lastname",
			"value": "Ziffel"
		}, {
			"fieldid": "companyname",
			"value": "Ziffel Farm"
		}, {
			"fieldid": "isperson",
			"value": "T"
		}, {
			"fieldid": "email",
			"value": "arnold@ziffelfarm.com"
		}, {
			"fieldid": "title",
			"value": "Mr."
		}, {
			"fieldid": "comments",
			"value": "Never mention pork products!"
		}]
	}]
}

• Subsidiary
• Location
• Entityid (vendor)
• One or more item lines with item and quantity (rate optional)
• Inventory details if the item is serialized or lot numbered

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "snidely.whiplash@dsiglobal.com",
		"recordtype": "vendorreturnauthorization",
		"entityid": "3658",
		"subsidiary":"1",
		"sublists": [{
		"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1818"
				},{
					"columnid": "quantity",
					"newvalue": "6"
				}]
			},{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1214"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				},{
					"columnid": "rate",
					"newvalue": "5.00"
				}]
			}]
		}],
		"targetfields": [{
			"fieldid": "orderstatus",
			"value": "A"
		},{
			"fieldid": "memo",
			"value": "Dented cans"
		}]
	}]
}

{
	"internalid": "",
	"recordtype": "vendorreturnauthorization",
	"tranid": "VRMA00000003",
	"mc_user": "Penelope.Pitstop@dsiglobal.com",
	"updatefields": [{
		"fieldid": "orderstatus",
		"newvalue": "B"
	}]
}

{
	"internalid": "24426",
	"recordtype": "vendorreturnauthorization",
	"tranid": "",
	"mc_user": "Boris.Badenov@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "ALL",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"internalid": "24426",
	"recordtype": "vendorreturnauthorization",
	"tranid": "",
	"mc_user": "Natasha.Fatale@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Line 2 closed by Advanced Inventory"
	}],
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "2",
			"nvpair": [{
				"columnid": "isclosed",
				"newvalue": "T"
			}]
		}]
	}]
}

{
	"mc_user": "Felonious.Gru@dsiglobal.com",
	"tranid":"VRMA00000003",
	"internalid": "",
	"recordtype": "vendorreturnauthorization",
}

{
	"transform": [{
		"mc_user": "Commander.McBragg@dsiglobal.com",
		"fromrecordtype": "vendorreturnauthorization",
		"tranid": "",
		"fromrecordid": "24426",
		"torecordtype": "itemfulfillment",
		"tolocation": "",
		"location": "2",
		"pps": "picked",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Fulfilled by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Created by Advanced Inventory"
		}],
		"lines": [{
			"linenum": "1",
			"item": "678",
			"qty": "100",
"binnumbers":"",
  		"serialnumbers":"",
			"inventorydetail": {
			    "item":"678",
			    "barcode":"",
			    "location":"2",
			    "tolocation":"",
			    "quantity": "6",
			    "unit": "",
			    "inventoryassignment":	[{
			        "line": "",
    				"binnumber": "Alpha-1",
    				"binid": "",
    				"tobinnumber": "",
    				"tobinid": "",
    				"quantity": "6",
    				"inventorynumber": "L-Alpha1",
    				"inventorynumberid": "",
    				"expirationdate":""
    			}]
		    }
		}]
	}]
}

{
	"transform": [{
		"mc_user": "B.Fearless.Leader@dsiglobal.com",
		"fromrecordtype": "vendorreturnauthorization",
		"tranid": "",
		"fromrecordid": "24426",
		"torecordtype": "itemfulfillment",
		"tolocation": "",
		"location": "2",
		"pps": "shipped",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Shipped to Vendor by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Advanced Inventory did this"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Dudley.DoRight@dsiglobal.com",
		"fromrecordtype": "vendorreturnauthorization",
		"tranid": "",
		"fromrecordid": "24426",
		"torecordtype": "vendorcredit",
		"tolocation": "",
		"location": "2",
		"pps": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "Vendor Bill Credit created by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Advanced Inventory did this"
		}]
	}]
}

1. Create the work order, either stand alone or from a sales order.
2. Release the work order.
3. Build the work order using an assembly build.

1. Create the work order, either stand alone or from a sales order with the iswip checkbox checked.
2. Release the work order.
3. Optional: Create work order Issue.
4. Create work order completion (with backflush if work order issue was skipped).
5. Create work order close.

{
	"internalid": "26547",
	"recordtype": "salesorder",
	"mc_user": "kelly.quit@dsiglobal.com",
	"updatecolumns": [{
		"sublistid": "item",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "createwo",
				"newvalue": "T"
			}]
		}]
	}],
	"updatefields": [{
		"fieldid": "revision",
		"newvalue": "8"
	}]
}

• entity must be the first field in the targetfields array.
• assemblyitem is required.
• location must be in the targetfields array, not the usual location field.
• job is the internalid of a project/job, optional

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "I.R.Babboon@dsiglobal.com",
		"recordtype": "workorder",
		"subsidiary":"1",
		"targetfields": [{
			"fieldid": "entity",
			"value": "2956"
		},{
			"fieldid": "assemblyitem",
			"value": "646"
		},{
			"fieldid": "location",
			"value": "2"
		},{
			"fieldid": "orderstatus",
			"value": "A"
		},{
			"fieldid": "firmed",
			"value": "T"
		},{
			"fieldid": "iswip",
			"value": "T"
		},{
			"fieldid": "quantity",
			"value": "6"
		},{
			"fieldid": "job",
			"value": "3759"
		}]
	}]
}

{
	"internalid": "26344",
	"recordtype": "workorder",
	"mc_user": "johnny.quest@dsiglobal.com",
	"updatefields": [{
		"fieldid": "orderstatus",
		"newvalue": "B"
	}]
}

• Assembly build - Refer to Assembly.
• Assembly unbuild - Refer to Assembly.
• Assembly unbuild to undo a specific build - Refer to Assembly.

• The Manufacturing Work in Process (WIP) feature must be enabled.
• The Work Order must be released and the WIP check box must be checked (iswip = T).

{
	"transform": [{
		"mc_user": "John.Koenig@dsiglobal.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "27454",
		"torecordtype": "workorderissue",
		"tolocation": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "I did this"
		}],
		"lines": [{
			"linenum": "1",
			"item": "128",
			"qty": "3"
		},{
			"linenum": "2",
			"item": "230",
			"qty": "3"
		},{
			"linenum": "3",
			"item": "479",
			"qty": "0"
		},{
			"linenum": "4",
			"item": "252",
			"qty": "0"
		},{
			"linenum": "5",
			"item": "152",
			"qty": "0"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "Helena.Russel@dsiglobal.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "27454",
		"torecordtype": "workorderissue",
		"tolocation": "2",
		"targetfields": [{
			"fieldid": "memo",
			"value": "I did this"
		}]
	}]
}

• The Manufacturing Work in Process (WIP) feature must be enabled.
• The Work Order must be released and the WIP check box must be checked (iswip = T).
• In the Accounting Preferences, the setting “Check Completed In Prior Operations During Operation Completion” must be set to "No Validation".

{
	"transform": [{
		"mc_user": "bob.t.builder@dsiglobal.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "27454",
		"torecordtype": "workordercompletion",
		"tolocation": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "quantity",
			"value": "1"
		},{
			"fieldid": "isbackflush",
			"value": "F"
		},{
			"fieldid": "startoperation",
			"value": "101692"
		},{
			"fieldid": "endoperation",
			"value": "101695"
		}]
	}]
}

{
	"transform": [{
		"mc_user": "sue.storm@dsiglobal.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "34326",
		"torecordtype": "workordercompletion",
		"location": "2",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "completed by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "isbackflush",
			"value": "T"
		},{
			"fieldid": "quantity",
			"value": "2"
		},{
			"fieldid": "memo",
			"value": "my serialized completion"
		},{
			"fieldid": "",
			"value": "",
			"inventorydetail": {
			    "item":"2022",
			    "unit": "",
			    "inventoryassignment": [{
			        "line": "NEW",
					"binnumber": "",
					"binid": "",
					"quantity": "1",
					"inventorynumber": "CGSP00001",
					"inventorynumberid": ""
				},{
			        "line": "NEW",
					"binnumber": "",
					"binid": "",
					"quantity": "1",
					"inventorynumber": "CGSP00002",
					"inventorynumberid": ""
				}]
		    }
		}]
	}]
}

{
	"transform": [{
		"mc_user": "rita.repulsa@moonpalace.com",
		"fromrecordtype": "workorder",
		"fromrecordid": "27454",
		"torecordtype": "workorderclose",
		"tolocation": "2"
	}]
}