GetAuxParams

GetAuxParams
Input XML Tags

XML Tag	Definition
comcorp	Five digit system number assigned to each corp.

Output XML Tags

XML Tag	Column Name	Data Type	Nullable	Definition
ap_corp	CORP	INT UNSIGNED	N	Five digit accounting corp number assigned to each corp
auxprmgroup				Beginning auxprmgroup delimiter
auxprm				Beginning auxprm delimiter
auxprm_field		CHAR(2)	N	Valid values: X1, X2, X3, Y1, Y2, Y3, Y6, Y7, C1, C2, C3, D1, D3, E1, E2, E3, E4, E5, E6, E8, E9, Z15
ap_edit	X1EDIT	SMALLINT SIGNED	N	Edit for auxiliary field, 1=alpha-num, 2=alpha-numrequired, 3=numeric, 4=numeric required. Valid Values: 1-4
ap_access	X1ACCESS	SMALLINT SIGNED	N	Auxiliary field use flag, 1=not using, 2=using OK to modify, 3=using do not allow modify. Valid Values: 1-3
ap_position	X1POSITION	SMALLINT SIGNED	N	Screen placement value for auxiliary fields 1-8 for house auxiliary fields, 9-22 for customer. Valid Values: 1-4
cd_username	USERNAME	CHAR(30)	N	User namelf data service subscription, user name for access. Valid Values: If data service subscription, alphanumeric character string
cd_description1	DESCRIPTION1	VARCHAR(50)	N	Description line 1. Valid Values:
cd_description2	DESCRIPTION2	VARCHAR(50)	N	Description line 2. Valid Values:
cd_validvalue1	VALIDVALUE1	VARCHAR(50)	N	Valid values line 1. Valid Values:
cd_validvalue2	VALIDVALUE2	VARCHAR(50)	N	Valid values line 2. Valid Values:
/auxprm				Ending auxprm delimiter
/auxprmgroup				Ending auxprmgroup delimiter

Source Tables

auxparams

Change Log

Usage

Associated XML Documents