BALANCES Data Table Columns

REQ	SM	COLUMN NAME	TYPE	UC	VALIDATE	DEFAULT	JUST	NOTE
– – – – – – – – – – – – Key Entry
M	S	ACCOUNT	A	U	VT=ACCOUNTS		L10
M	S	PRODUCT	AN	U			L20
M	S	VARIETY	AN	U		null	L10
O	S	CONTROL	AN	U			L20
O	S	CONDITION	AN	U	Unit Condition Codes	G	L4
– – – – – – – – – – – – Unit Entries
M	S	UNITUOM	LC	U	Units of Measure	PL	L4
O	S	UNITONHAND	N.0		(MD0)		R8
O	S	UNITRESERVED	N.0		(MD0)		R8
O	S	UNITAVAILABLE	N.0		(MD0)		R8
– – – – – – – – – – – – Content Entries
M	S	PACKAGEUOM	LC	U	Units of Measure	CA	L4
O	S	PACKAGECOUNT	N.0		(MD0)		R8
O	S	PACKAGEONHAND	N.0		(MD0)		R10
O	S	PACKAGERESERVED	N.0		(MD0)		R10
0	S	PACKAGEAVAILABLE	N.0		(MD0)		R10
– – – – – – – – – – – – Inner Entries
O	S	INNERUOM	LC	U	Units of Measure		L4
O	S	INNERCOUNT	N.0		(MD0)		R8
O	S	INNERONHAND	N.0		(MD0)		R12
O	S	INNERRESERVED	N.0		(MD0)		R12
O	S	INNERAVAILABLE	N.0		(MD0)		R12

LEGEND:

REQ	O = optional M = mandatory P = pair required C = conditional
SM	S = single valued M = multiple values A = associated (array member)
COLUMN NAME	(not case specific)
TYPE	A = alpha N.n = numeric with decimals B = boolean D = datetime U = UUID LC = list of codes SK = key sequence S = sequence
U	Key values and codes are uppercase
VALIDATE	links refer to code validation lists Tablenames (uppercase) refer to verifiles (‘values’) list allowed entries
DEFAULT	a value default
JUST	Justify (L)eft, (C)enter, (R)ight, (T)ext n = characters to show

Note

1. Entries of type list code (TYPE=LC) are validated against the associated linked code option list.
2. Entries with a paired requirement (REQ=P) are required when the associated paired entry or code is specified.

Warning

Classic DOS WARES optionally includes unit information, but it tracks product quantity exclusively by lot control (tracking=’C’). In DOS WARES lot balances are stored in the lot transaction details table, Product balances are written in the PRODUCT_POST table.