JSON DETAILS Export

The DOS WARES export utility writes lot details in sequentially numbered JSON transaction files. The export definition with JSON names and corresponding WARES dictionary columns which provide data conversion between record layouts in DOS WARES and webWARES are documented in the following table.

Note

Column F/S/J indicates if a WARES data field (F), a synthetic field (S), or a synthetic column specific to the JSON export (J). Column S/M indicates whether a column is single-valued (S) or array multivalue (M). Column A/N refers to whether the data will be quoted string (A) or unquoted numeric (N).

DETAILS

F/S/J	JSON NAME	M/S	A/N	DICTIONARY (“value”)	COMMANDS
N/A	uniqueKey
F	account	S	A	ACCOUNT
F	product	S	A	PRODUCT
N/A	variety	S	A	“null”
F	control	S	A	CONTROL
N/A	documentType	S	A	“IB”
F	document	S	A	@ID
N/A	revision	S	A	“00”
F	postDate	S	A	DATE	(D-JS)
J	controlCode	S	A	CONTROLCODE (“NA”)
F	description	T	A	DESCRIPTION
	dimensions
J	unitUom	S	A	UOM_STORE (“PL”)
J	unitNet	S	N	PROD_WT_NET (“null”)	(MD2L)
J	unitTare	S	N	PROD_WT_TARE (“null”)	(MD2L)
J	unitSize	S	N	PROD_SIZE (“null”)	(MD42L)
J	unitStack	S	N	FACT_STACK (“null”)	(MD0)
J	packageUom	S	A	UOM_PIECE (“EA”)
F	packageCount	S	N	FACT_STORE (“null”)	(MD0)
F	packageNet	S	N	FACT_WEIGHT (“null”)	(MD42L)
J	packageTare	S	N	FACT_TARE (“null”)	(MD42L)
J	packageSize	S	N	FACT_VOLUME (“null”)	(MD42L)
J	innerUom	S	A	UOM_INNER (“null”)
J	innerCount	S	N	PROD_PACK (“null”)	(MD0)
J	innerWeight	S	N	INNERS_WEIGHT “null”	(MD42L)
J	innerSize	S	N	INNERS_SIZE (“null”)	(MD42L)

TRANSACTION LINES

F/S/J	JSON NAME	M/S	A/N	DICTIONARY (“value”)	COMMANDS
N/A	detail
J	sequenceKey	M	A	SERIAL_LIST (null)	<,,1>
J	unitIdentifier	M	A	SERIAL_LIST (null)	<,,2>
J	transactionType	M	A	SERIAL_LIST (null)	<,,3>
J	transaction	M	A	SERIAL_LIST (null)	<,,4>
J	lineKey	M	A	SERIAL_LIST (null)	<,,5>
J	status	M	A	SERIAL_LIST (null)	<,,6>
J	postDate	M	A	SERIAL_LIST (null)	<,,7> (D-JS)
J	location	M	A	SERIAL_LIST (null)	<,,8>
F	account	S	A	ACCOUNT
F	product	S	A	PRODUCT
N/A	variety	S	A	“null”
F	control	S	A	CONTROL
J	condition	M	A	SERIAL_LIST (“G”)	<,,13>
J	description	M	A	SERIAL_LIST (null)	<,,14>
J	unitUom	M	A	SERIAL_LIST (null)	<,,15>
J	unitNet	M	N	SERIAL_LIST (null)	<,,16> (MD2L)
J	unitTare	M	N	SERIAL_LIST (null)	<,,17> (MD2L)
J	unitSize	M	N	SERIAL_LIST (null)	<,,18> (MD42L)
J	unitStack	M	N	SERIAL_LIST (null)	<,,19> (MD0)
J	packageUom	M	A	SERIAL_LIST (null)	<,,20>
J	packageCount	M	N	SERIAL_LIST (null)	<,,21> (MD0)
J	packageOnHand	M	N	SERIAL_LIST (null)	<,,22> (MD0)
J	packageReserve	M	N	SERIAL_LIST (null)	<,,23> (MD0)
J	packageNet	M	N	SERIAL_LIST (null)	<,,24> (MD42L)
J	packageTare	M	N	SERIAL_LIST (null)	<,,25> (MD42L)
J	packageSize	M	N	SERIAL_LIST (null)	<,,26> (MD42L)
J	overShort	M	N	SERIAL_LIST (null)	<,,27> (MD0)
J	innerUom	M	A	SERIAL_LIST (null)	<,,28>
J	innerCount	M	N	SERIAL_LIST (null)	<,,29> (MD0)
J	innerOnHand	M	N	SERIAL_LIST (null)	<,,30> (MD0)
J	innerReserve	M	N	SERIAL_LIST (null)	<,,31> (MD0)
J	innerWeight	M	N	SERIAL_LIST (null)	<,,32> (MD42L)
J	innerSize	M	N	SERIAL_LIST (null)	<,,33> (MD42L)

Note

Transaction line detail is directly posted from transaction documents in receipts, shipments, and adjustments.