CONTACTS Data Table Columns

REQ	SM	COLUMN NAME	TYPE	UC	VALIDATE	DEFAULT	JUST	NOTE
– – – – – – – – – – – – Keys & Associations
M	S	CONTACTTYPE	A	U	Contacts Type Codes		L4
M	S	CONTACT	A	U			L12
O	S	ACCOUNT	A	U	VT=ACCOUNTS		L12
– – – – – – – – – – – – Name and Address
M	S	NAME	A				L30
O	M	STREET	A				L30
O	S	CITY	A				L17
O	S	STATE	A	U	North American States Codes		L4
O	S	POSTALCODE	A	U			L12
O	S	COUNTRY	A	U	Country Codes
– – – – – – – – – – – – Contact Information
O	M	CONTACT	A				L20
O	M	SALUTATION	A				L20
O	M	POSITION	A				L15
O	M	EMAIL	A				L30
O	M	PHONE	A				L30
– – – – – – – – – – – – Shipping Information
O	S	FREIGHTPAY	A	U	Freight Payor Codes		L4
O	S	FOB	A	U	F.O.B. Location Codes		L2
O	S	COD	A	U	Collect Payment Codes		L2
O	S	LINK	A	U			L10
O	S	USERDATA	A	U			T20

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.