ACCOUNTS Data Table Columns

REQ	SM	COLUMN NAME	TYPE	UC	VALIDATE	DEFAULT	JUST	NOTE
– – – – – – – – – – – – Keys and Descriptions
M	S	ACCOUNT	A	U	VT=CONTACTS		L10
M	S	NAME	AN				L30
– – – – – – – – – – – – Addresses
M	M	ADDRESSCODE	AN	U	A	null	L4
P	M	ADDRESS	AN	U	VT=CONTACTS	null	L10
P	M	ADDRESSCODE	AN	U	ST	null	L4
P	M	ADDRESS	AN	U	VT=CONTACTS	null	L10
P	M	ADDRESSCODE	AN	U	BT	null	L4
P	M	ADDRESS	AN	U	VT=CONTACTS	null	L10
P	M	ADDRESSCODE	AN	U	PF	null	L4
P	M	ADDRESS	AN	U	VT=CONTACTS	null	L10
– – – – – – – – – – – – Billing & Storage Terms
M	S	TERMS	AN	U	Account Invoicing Terms Codes	null	L10
M	S	INVOICING	AN	U	Invoicing Control Codes	null	L2
M	S	PONUMBER	AN	U		null	L2
O	S	DEFERHANDLING	N.4	U		null	R2
M	S	RECEIVING	AN	U	Receiving Billing Codes	null	L2
M	S	RECURRING	AN	U	Recurring Method Codes	null	L2
O	S	FREEDAYS	N.0	U		null	R2
O	S	GRACEDAYS	N.0	U		null	R2
M	S	VALUEDECLARED	N.2	U		null	L10
M	S	VALUEPER	AN	U	Rating and Value Per Unit	null	L2
– – – – – – – – – – – – Documents
O	S	FREIGHTPAY	N.0	U		null	R2
O	S	UNIQUECHECK	N.2	U		null	R10
– – – – – – – – – – – – Notes and Messages Entries
P	MA	NOTECODE	LC	U	Note & Message Codes		L4
P	MA	NOTE	T		paired: NOTECODE		L80
CO	MA	NOTEAPPLY	LC	U	Note Application Codes		L4

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.