Transaction Extract Settings

This function enables changing/updating values specific to the Inventory Transaction Extract to other systems. This sent via a REST API with the JSON layout shown below. Note that to enable this feature an extract Job Schedule needs to be setup.

	Primary Locations
	A comma delimited set of primary locations. Only transactions within these location hierarchies will be included in the extract.

	Action Type Filter
	A comma delimited set of transaction types. Only these transaction types will be included in the extract. Note: only positive transactions are included.

	Endpoint Server
	The server where the extracts will be posted in JSON format.

	Endpoint URL
	The URL that will be appended to the Endpoint Server above.

	Endpoint Timeout (ms)
	The timeout value in milliseconds when posting to the endpoint server

	Enable Basic Auth?
	If enabled, basic authentication will be used when posting to the endpoint.

	Username
	The user name used for basic authentication.

	Password
	The password used for basic authentication.

	Time Offset (Hours)
	The time offset of your TagNet Server's time zone. This will calculate UTC time below

	Send UTC Time
	Converts time to UTC before sending out based on the offset above.

	Send Email on Error?
	If enabled, sends out email as a result of any errors posting to endpoint.

	Email Alert Group
	Enter the Email Group as setup in General Settings

	Save Extract to File?
	When enabled, saves the JSON extract to this folder \TagNet Extension Framework\EF Web\saved-extracts. Note: when using the 'AdHoc' Job Type feature the JSON is saved here \TagNet Extension Framework\EF Service\saved-extracts.

	Process After Time
	This is an optional filter to only process transaction events after a specified time. This is typically used upon startup as to note post every previous transaction.

Shown below is the JSON Extract Layout

Group

JSON Extract

xxx.json

[{

"TransactionTime": "11/15/2019 11:24:49 AM",

"TransactionUser": "TAGNETUSER",

"TransactionType": "IMOVETRANS",

"TagID": "000000000000000000001234",

"ItemID": "A12345",

"BinID": "",

"PartNumberID": "A12345",

"AssetID": "A12345",

"AssetSerialNo": "A12345",

"TagQuantity": "1.00",

"LocationLevel1": "??",

"LocationLevel2": "??",

"LocationLevel3": "??",

"LocationLevel4": "??",

"LocationLevel5": "??",

"LocationTranslation": "",

"LotNumber": "ABC100",

"LotStatus": "A",

"TransactionReference": "??"

{

"TransactionTime": "11/15/2019 11:24:49 AM",

"TransactionUser": "TAGNETUSER",

"TransactionType": "IMOVETRANS",

"TagID": "000000000000000000001234",

"ItemID": "A12345",

"BinID": "",

"PartNumberID": "A12345",

"AssetID": "A12345",

"AssetSerialNo": "A12345",

"TagQuantity": "1.00",

"LocationLevel1": "??",

"LocationLevel2": "??",

"LocationLevel3": "??",

"LocationLevel4": "??",

"LocationLevel5": "??",

"LocationTranslation": "",

"LotNumber": "ABC100",

"LotStatus": "A",

"TransactionReference": "??"

}]

Shown below is an actual JSON Extract sent to customers endpoint.

Proposed modification for Nextera extract

Group

JSON Extract

xxx.json

[{

"TransactionTime": "11/15/2019 11:24:49 AM",

"TransactionUser": "TAGNETUSER",

"TransactionType": "IMOVETRANS",

"TagID": "000000000000000000001234",

"ItemID": "A12345",

"BinID": "",

"PartNumberID": "A12345",

"AssetID": "A12345",

"AssetSerialNo": "A12345",

"TagQuantity": "1.00",

"LocationLevel1": "??",

"LocationLevel2": "??",

"LocationLevel3": "??",

"LocationLevel4": "??",

"LocationLevel5": "??",

"LocationTranslation": "",

"LotNumber": "ABC100",

"LotStatus": "A",

"TransactionReference": "??"

"UDA_WorkOrderNo": "??"

"UDA_M&SItemNmber": "??"

{

"TransactionTime": "11/15/2019 11:24:49 AM",

"TransactionUser": "TAGNETUSER",

"TransactionType": "IMOVETRANS",

"TagID": "000000000000000000001234",

"ItemID": "A12345",

"BinID": "",

"PartNumberID": "A12345",

"AssetID": "A12345",

"AssetSerialNo": "A12345",

"TagQuantity": "1.00",

"LocationLevel1": "??",

"LocationLevel2": "??",

"LocationLevel3": "??",

"LocationLevel4": "??",

"LocationLevel5": "??",

"LocationTranslation": "",

"LotNumber": "ABC100",

"LotStatus": "A",

"TransactionReference": "??"

}]