General Field Info and Restrictions

Ord	eConnectNode	GPName	DataType	Length	Required	Default	TGPName	PossibleValues
1	A A Trx Dim Code Maint	aaTrxDim	string	30	Y	Not applicable
2	A A Trx Dim Code Maint	aaTrxDimCode	string	30	Y	Not applicable	AA Transaction Dimension Code String reference to the desired transaction dimension code. It can exist to be updated or can be created on the fly
3	A A Trx Dim Code Maint	NOTETEXT	string	8000	N		Create, update, or remove notes for the specified dimension code
4	A A Trx Dim Code Maint	INACTIVE	i4	2	N	0	0 = Active, 1 = inactive New codes default to Active unless otherwise specified. Existing codes can be updated to either active or inactive based on the value (0 or 1) - If the Transaction Dimension / Transaction Dimension Code combination is setup as an owner of another it cannot be updated to inactive.
5	A A Trx Dim Code Maint	aaTrxDimCodeDescr	string	50	N		Transaction Dimension Code Description. Required for new codes. Existing description 1 string can be changed, but cannot be left blank
6	A A Trx Dim Code Maint	aaTrxDimCodeDescr2	string	50	N		Transaction Dimension Code Description 2. Optional for both new created codes and existing code updates
7	A A Trx Dim Code Maint	aaNode	string	50	N		Required for new codes and can be changed using update logic. Node must exist and be already be linked to the Transaction Dimension. The Node and the Node Link cannot be created on the fly
8	A A Trx Dim Code Maint	aaOwnedBy	string	30	N		Transaction Dimension Code Owner. Required for new codes that have a transaction dimension owned by another transaction dimension. This is available only if the transaction dimension selected is owned by another transaction dimension and both are of the alphanumeric type
9	A A Trx Dim Code Maint	aaUDFText1	string	31	N		User-defined text1
10	A A Trx Dim Code Maint	aaUDFText2	string	31	N		User-defined text2
11	A A Trx Dim Code Maint	aaUDFText3	string	31	N		User-defined text3
12	A A Trx Dim Code Maint	aaUDFText4	string	31	N		User-defined text4
13	A A Trx Dim Code Maint	aaUDFText5	string	31	N		User-defined text5
14	A A Trx Dim Code Maint	aaUDFDate1	datetime	8	N		User-defined date1
15	A A Trx Dim Code Maint	aaUDFDate2	datetime	8	N		User-defined date2
16	A A Trx Dim Code Maint	aaUDFDate3	datetime	8	N		User-defined date3
17	A A Trx Dim Code Maint	aaUDFDate4	datetime	8	N		User-defined date4
18	A A Trx Dim Code Maint	aaUDFDate5	datetime	8	N		User-defined date5
19	A A Trx Dim Code Maint	aaUDFNumeric1	number	12	N		User-defined numeric1
20	A A Trx Dim Code Maint	aaUDFNumeric2	number	12	N		User-defined numeric2
21	A A Trx Dim Code Maint	aaUDFNumeric3	number	12	N		User-defined numeric3
22	A A Trx Dim Code Maint	aaUDFNumeric4	number	12	N		User-defined numeric4
23	A A Trx Dim Code Maint	aaUDFNumeric5	number	12	N		User-defined numeric5
24	A A Trx Dim Code Maint	aaUDFBoolean1	i4	2	N		User-defined boolean1
25	A A Trx Dim Code Maint	aaUDFBoolean2	i4	2	N		User-defined boolean2
26	A A Trx Dim Code Maint	aaUDFBoolean3	i4	2	N		User-defined boolean3
27	A A Trx Dim Code Maint	aaUDFBoolean4	i4	2	N		User-defined boolean4
28	A A Trx Dim Code Maint	aaUDFBoolean5	i4	2	N		User-defined boolean5
29	A A Trx Dim Code Maint	UpdateIfExists	i4	2	N	1	Flag that specifies whether to update the data if it exists	0 = Create only (returns an error if the transaction dimension code already exists); 1 = Update if e
30	A A Trx Dim Code Maint	RequesterTrx	i4	2	N	0	Requester transaction	0 = False; 1 = True (if True, the Requester shadow table is populated) (Not Used)
1	Account Category	ACCATDSC	string	50	Y	Not applicable	Account category description
2	Account Category	Requester_trx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Account Currencies	Account_Number	string	75	Y	Not applicable	Account number
2	Account Currencies	CURNCYID	string	15	Y	Not applicable	Currency ID
3	Account Currencies	REVALUE	i4	1	N	0	Revalue	0=False; 1=True
4	Account Currencies	REVLUHOW	i4	2	N	0	Revalue how	0=Net change; 1=Period balance
5	Account Currencies	Post_ Results _To	i4	2	N	0	Post results to	0=Account; 1=Financial offset
1	Account Group	ACCTGRPID	string	15	Y	Not applicable	Account group ID
2	Account Group	ACCTGRPDESC	string	30	N		Account group description
3	Account Group	DEPREXPACCT	string	75	N		Depreciation expense account
4	Account Group	DEPRRESACCT	string	75	N		Depreciation reserve account
5	Account Group	PRIORYRDEPRACCT	string	75	N		Prior year depreciation account
6	Account Group	ASSETCOSTACCT	string	75	N		Asset cost account
7	Account Group	PROCEEDSACCT	string	75	N		Proceeds account
8	Account Group	RECOGGAINLOSSACCT	string	75	N		Recognized gain/loss account
9	Account Group	NONRECOGGAINLOSSACCT	string	75	N		Non-recognized gain/loss account
10	Account Group	CLEARINGACCT	string	75	N		Clearing account
11	Account Group	LASTMNTDDATE	datetime	8	N	Default from setup	Create date
12	Account Group	LASTMNTDUSERID	string	15	N		User ID
1	Analytics Distribution	DOCNMBR	string	50	Y	Not applicable	The document number. Specify the same number as the document that includes the analytical accounting distribution. Refer to the next table for additional information.
2	Analytics Distribution	DOCTYPE	i4	2	Y	0	The document type. The possible value of the document type is determined by the source of the document number. Refer to the next table to view the document types for each document.
3	Analytics Distribution	AMOUNT	number	21	N		When you need to change the assigned percentages, supply only the amount or percentage. No other elements should be included. You do not need to supply a dimension value.
4	Analytics Distribution	aaAssignedPercent	number	9	N		When you need to change the assigned percentages, supply only the amount or percentage. No other elements should be included. You do not need to supply a dimension value.
5	Analytics Distribution	DistSequence	i4	2	N		The GL distribution sequence number. If you have duplicate accounts in a transaction, associate them using sequence number values.
6	Analytics Distribution	ACTNUMST	string	75	N		Account number
7	Analytics Distribution	ACTINDX	i4	2	N		Account index
8	Analytics Distribution	DistRef	string	31	N		Distribution reference
9	Analytics Distribution	NOTETEXT	string	8000	N		Notes field
10	Analytics Distribution	aaTrxDim	string	31	N		Transaction dimension
11	Analytics Distribution	aaTrxDimCode	string	31	N		The transaction dimension alphanumeric code. If you update only the dimension code value, do not update the amount, assigned percentage, or other elements.
12	Analytics Distribution	aaTrxDimCodeNum	number	21	N		Transaction dimension numeric
13	Analytics Distribution	aaTrxDimCodeBool	i4	2	N		Transaction dimension yes/no
14	Analytics Distribution	aaTrxDimCodeDate	datetime	8	N		Transaction dimension date
15	Analytics Distribution	aaTrxDimID	i4	2	N		Transaction dimension ID
16	Analytics Distribution	aaTrxCodeID	i4	2	N		Transaction dimension code ID
17	Analytics Distribution	aaSubLedgerHdrID	i4	2	N		Subledger header lookup
18	Analytics Distribution	aaSubLedgerDistID	i4	2	N		Subledger distribution lookup
19	Analytics Distribution	aaSubLedgerAssignID	i4	2	N	1	The subledger assign lookup ID. To add new distribution lines, use this element and increment its value by 1 for each assignment.
20	Analytics Distribution	UpdateIfExists	i4	2	N	1	Flag that specifies whether to update the data if it exists	0 = Do not update; 1 = Update if record exists
21	Analytics Distribution	RequesterTrx	i4	2	N	0	Requester transaction	0 = False; 1 = True (if True, the Requester shadow table is populated)
1	Applicant	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant	APPLYDATE_I	datetime	8	Y	Not applicable	Application date
4	Applicant	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant number - Optional/Required - Required if Updating a duplicate Last /First Name combination
5	Applicant	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Line Sequence Number - Null = create or update if single line for the Applicant. Not Null = update
6	Applicant	MIDLNAME	string	15	N		Middle name
7	Applicant	SSN_I	string	15	N		Social security number
8	Applicant	ADDRESS1	string	61	N		Address information
9	Applicant	ADDRESS2	string	61	N		Address information
10	Applicant	CITY	string	35	N		Address city
11	Applicant	STATE	string	29	N		Address state
12	Applicant	ZIPCODE_I	string	11	N		Postal code
13	Applicant	COUNTRY	string	61	N		Country
14	Applicant	HOMEPHONE	string	21	N		Phone 1
15	Applicant	WORKPHONE	string	21	N		Phone 2
16	Applicant	EXT_I	string	5	N		Telephone extension
17	Applicant	REQUISITIONNUMBER_I	i4	4	N	0	Requisition number
18	Applicant	COMPANYCODE_I	string	5	Y	Not applicable	Company ID
19	Applicant	DIVISIONCODE_I	string	7	N		Division
20	Applicant	DEPARTMENTCODE_I	string	7	N		Department
21	Applicant	POSITIONCODE_I	string	7	N		Position
22	Applicant	LOCATNID	string	15	N		Location
23	Applicant	STATUS0_I	i4	2	N	0	Status 0 = Blank, 1 = Active, 2 = Open, 3 = Rejected, 4 = Hired 5 = Other
24	Applicant	REJECTREASON_I	i4	2	N		Reject Reason 1 = Testing, 2 = Interview, 3 = References, 4 = Experience, 5 = Education 6 = Other
25	Applicant	DSCRIPTN	string	31	N		Rejection comments
26	Applicant	RELOCATION_I	i4	2	N		Relocation 0 = Yes 1 = No
27	Applicant	REPLYLETTERSENT_I	i4	1	N		Reply Letter Sent 0 = False 1 = True
28	Applicant	COLORCODE_I	i4	2	N		Color Code 1 = Blue, 2 = Green, 3 = Yellow, 4 = Red, 5 = N/A
29	Applicant	REFSOURCEDDL_I	i4	2	N		Referral Source 0 = None, 1 = Word of Mouth, 2 = Referred by Employee, 3 = Referred by an Agency, 4 = Newspaper, 5 = Other, 6 = Internet
30	Applicant	REFERENCESOURCE_I	string	31	N		Referral Source Description
31	Applicant	GENDERGB_I	i4	2	N		Gender 0 = Male, 1 = Female 2 = Unknown
32	Applicant	EEOETHNICORIGIN_I	i4	2	N		Ethic Origin 1 = White, 2 = American Indian or Alaskan Native, 3 = Black or African American, 4 = Asian, 5 = Hispanic or Latino, 6 = Two or More Races, 7 = N/A 8 = Native Hawaiian or Pacific Islander
33	Applicant	EEOAGE_I	i4	2	N		Age 1 = 18 to 25, 2 = 26 to 35, 3 = 36 to 45, 4 = 46 to 55, 5 = 56 +, 6 = Unknown 7 = 00 to 17
34	Applicant	HANDICAPPED	i4	1	N		Handicapped 0 = False 1 = True
35	Applicant	VETERAN	i4	1	N		Veteran 0 = False 1 = True
36	Applicant	DISABLEDVETERAN	i4	1	N		Disabled Veterans 0 = False 1 = True
37	Applicant	VIETNAMVETERAN	i4	1	N		Vietnam Veterans 0 = False 1 = True
38	Applicant	OTHERVET	i4	1	N		Other Veterans 0 = False 1 = True
39	Applicant	CHANGEBY_I	string	15	N		Changed by
40	Applicant	DATE1_I	datetime	8	N		Date 1 For extra date fields
41	Applicant	DATE2_I	datetime	8	N		Date 2 For extra date fields
42	Applicant	DATE3_I	datetime	8	N		Date 3 For extra date fields
43	Applicant	DATE4_I	datetime	8	N		Date 4 For extra date fields
44	Applicant	DATE5_I	datetime	8	N		Date 5 For extra date fields
45	Applicant	STRINGS_I_1	string	31	N		String 1 For extra fields
46	Applicant	STRINGS_I_2	string	31	N		String 2 For extra fields
47	Applicant	STRINGS_I_3	string	31	N		String 3 For extra fields
48	Applicant	STRINGS_I_4	string	31	N		String 4 For extra fields
49	Applicant	STRINGS_I_5	string	31	N		String 5 For extra fields
50	Applicant	NUMERICEXTRA_1	i4	4	N		Alpha/Numeric 1 For extra number fields
51	Applicant	NUMERICEXTRA_2	i4	4	N		Alpha/Numeric 2 For extra number fields
52	Applicant	NUMERICEXTRA_3	i4	4	N		Alpha/Numeric 3 For extra number fields
53	Applicant	NUMERICEXTRA_4	i4	4	N		Alpha/Numeric 4 For extra number fields
54	Applicant	NUMERICEXTRA_5	i4	4	N		Alpha/Numeric 5 For extra number fields
55	Applicant	DOLLARS_I_1	number	21	N		Currency 1 For extra currency fields
56	Applicant	DOLLARS_I_2	number	21	N		Currency 2 For extra currency fields
57	Applicant	DOLLARS_I_3	number	21	N		Currency 3 For extra currency fields
58	Applicant	DOLLARS_I_4	number	21	N		Currency 4 For extra currency fields
59	Applicant	DOLLARS_I_5	number	21	N		Currency 5 For extra currency fields
60	Applicant	CHECKBOXES_I_1	i4	1	N		Checkboxes 1 For extra checkbox fields
61	Applicant	CHECKBOXES_I_2	i4	1	N		Checkboxes 2 For extra checkbox fields
62	Applicant	CHECKBOXES_I_3	i4	1	N		Checkboxes 3 For extra checkbox fields
63	Applicant	CHECKBOXES_I_4	i4	1	N		Checkboxes 4 For extra checkbox fields
64	Applicant	CHECKBOXES_I_5	i4	1	N		Checkboxes 5 For extra checkbox fields
65	Applicant	UpdateIfExists	i4	1	N	1	Flag to allow Applicant data to be updated if it exists. 0=no, 1=yes
66	Applicant	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true if true then populates Requester shadow table
1	Applicant Education	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant Education	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant Education	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant number Required if you have multiple applicants with the same name combination or if not passing First and Last Name
4	Applicant Education	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence number Required on an update if the applicant has more then one educational record.
5	Applicant Education	UNIVERSITY	string	31	N		School
6	Applicant Education	DEGREE	string	31	N		Degree
7	Applicant Education	MAJOR	string	31	N		Major
8	Applicant Education	GPA	string	5	N		Grade point average
9	Applicant Education	GPABASE	string	3	N		GPA base
10	Applicant Education	GRADUATIONYEAR	string	5	N		Graduation year
11	Applicant Education	NOTE	string	8000	N		Notes
12	Applicant Education	CHANGEBY_I	string	15	N		Changed by
13	Applicant Education	UpdateIfExists	i4	1	N	1	Flag to allow Education data to be updated if it exists. 0=no, 1=yes
14	Applicant Education	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true if true then populates Requester shadow table
1	Applicant Interview Insert	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant Interview Insert	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant Interview Insert	APPLYDATE_I	datetime	8	Y	Not applicable	Interview date
4	Applicant Interview Insert	APPINTTYPESTR_I	string	21	Y	Not applicable	Interview type
5	Applicant Interview Insert	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you want to pass the Applicant Number instead of the LASTNAME and FIRSTNAME
6	Applicant Interview Insert	COMPANYCODE_I	string	5	Y	Not applicable	Company ID
7	Applicant Interview Insert	POSITIONCODE_I	string	7	N		Position
8	Applicant Interview Insert	UpdateIfExists	i4	1	N	0	Flag to allow Interview data to be updated if it exists. 0=no, 1=yes
9	Applicant Interview Insert	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Applicant Interview Update	LLASTNAME_I	string	21	Y		Last Name
2	Applicant Interview Update	FFIRSTNAME_I	string	15	Y		First Name
3	Applicant Interview Update	APPLYDATE_I	datetime	8	Y	Not applicable	Interview Date
4	Applicant Interview Update	APPINTTYPESTR_I	string	21	Y	Not applicable	Interview Type
5	Applicant Interview Update	CATEGORY_I	string	31	Y	Not applicable	Category
6	Applicant Interview Update	APPLICANTNUMBER_I	number	21	Y	0	Applicant Number - Required only if you have multiple applicants with the same name combination OR if you are going to pass the Applicant Number and not the LASTNAME and FIRSTNAME
7	Applicant Interview Update	COMPANYCODE_I	string	5	Y	Not applicable	Company ID
8	Applicant Interview Update	REVIEWSCORE_I	number	21	N	0	Score
9	Applicant Interview Update	POSITIONCODE_I	string	7	N		Score
10	Applicant Interview Update	NOTE	string	8000	N		Note
11	Applicant Interview Update	CHANGEBY_I	string	15	N		Changed by
12	Applicant Interview Update	UpdateIfExists	i4	1	N	1	Flag to allow Interview data to be updated if it exists. 0=no, 1=yes
13	Applicant Interview Update	RequesterTrx	i4	2	N	0	Requester Transaction Optional - 0=false,1=true - if true than populates Requester shadow table
1	Applicant References	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant References	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant References	REFERENCENAME_I	string	61	Y	Not applicable	Reference name
4	Applicant References	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you want to pass Applicant Number and not pass LASTNAME and FIRSTNAME combination
5	Applicant References	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence Number Required on an update if the applicant has more then one reference record
6	Applicant References	REFRELATIONSHIP_I	string	15	N		Reference relationship
7	Applicant References	COMPANY_I	string	65	N		Company
8	Applicant References	ADDRESS1	string	61	N		Address
9	Applicant References	CITY	string	35	N		City
10	Applicant References	STATE	string	29	N		State
11	Applicant References	ZIPCODE_I	string	11	N		Postal code
12	Applicant References	WORKPHONE	string	21	N		Phone
13	Applicant References	NOTE	string	8000	N		Notes
14	Applicant References	CHANGEBY_I	string	15	N		Changed by
15	Applicant References	UpdateIfExists	i4	1	N	1	Flag to allow Applicant References data to be updated if it exists 0=no, 1=yes
16	Applicant References	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Applicant Skills	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant Skills	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant Skills	SKILL	string	31	Y	Not applicable	Skill
4	Applicant Skills	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you are going to pass Applicant Number and not LASTNAME FIRSTNAME
5	Applicant Skills	COMMENT20_I	string	21	N		Comment
6	Applicant Skills	POINTS_I	i4	4	N		Proficiency 0 to 9999 are valid values
7	Applicant Skills	UpdateIfExists	i4	1	N	1	Flag to allow Applicant Test Skill data to be updated if it exists 0 = Delete Line, 1 = Insert 2 = Update
8	Applicant Skills	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Applicant Tests	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant Tests	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant Tests	TESTCODE_I	string	7	Y	Not applicable	Test code
4	Applicant Tests	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you want to pass Applicant Number and not FIRSTNAME and LASTNAME combination
5	Applicant Tests	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence Number Required on an update if the Applicant has more then one educational record
6	Applicant Tests	STRTDATE	datetime	8	N		Start date
7	Applicant Tests	TESTSCORE_I	string	21	N		Test score
8	Applicant Tests	NOTE	string	8000	N		Notes
9	Applicant Tests	CHANGEBY_I	string	15	N		Changed by
10	Applicant Tests	UpdateIfExists	i4	1	N	0	Flag to allow Applicant Test data to be updated if it exists. 0=no, 1=yes
11	Applicant Tests	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Applicant Work History	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Applicant Work History	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Applicant Work History	NAME	string	31	Y	Not applicable	Employer name
4	Applicant Work History	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you are passing Applicant Number instead of FIRSTNAME LASTNAME combination
5	Applicant Work History	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence Number Required on an update if the Applicant has more then one Work/History record
6	Applicant Work History	WAGE_I	number	21	N		Wage
7	Applicant Work History	COMPENSATIONPERIOD_I	i4	2	N		Compensation Period 1=Hourly, 2=Weekly, 3=BiWeekly, 4=Semimonthly, 5=Monthly, 6=Quarterly, 7=Semiannually, 8=Annually 9=Daily/Miscellaneous
8	Applicant Work History	POSITION_I	string	31	N		Position
9	Applicant Work History	STRTDATE	datetime	8	N		Start date
10	Applicant Work History	ENDDATE	datetime	8	N		End date
11	Applicant Work History	YEARSOFEXP_I	string	3	N		Years of experience
12	Applicant Work History	NOTE	string	8000	N		Notes
13	Applicant Work History	CHANGEBY_I	string	15	N		Changed by
14	Applicant Work History	UpdateIfExists	i4	1	N	1	Flag to allow Education data to be updated if it exists. 0=no, 1=yes
15	Applicant Work History	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Asset Book	ASSETID	string	15	Y	Not applicable	Asset ID
2	Asset Book	ASSETIDSUF	i4	2	N	1	Asset suffix ID
3	Asset Book	BOOKID	string	15	Y	Not applicable	Book ID
4	Asset Book	PLINSERVDATE	datetime	8	N		Place In service date
5	Asset Book	DATEADDED	datetime	8	N		Date added
6	Asset Book	DEPRTODATE	datetime	8	N		Depreciate to date
7	Asset Book	COSTBASIS	number	21	N		Cost basis
8	Asset Book	SALVAGEVALUE	number	21	N		Salvage value
9	Asset Book	YTDDEPRAMT	number	21	Y	Not applicable	YTD depreciation
10	Asset Book	LTDDEPRAMT	number	21	Y	Not applicable	LTD depreciation
11	Asset Book	DEPRECIATIONMETHOD	i4	2	N		Depreciation method	1=Straight-line orig. life; 2=Straight-line rem. life; 3=125%DB; 4=150% DB; 5=175% DB; 6=200% DB; 7=
12	Asset Book	AVERAGINGCONV	i4	2	N		Averaging convention	1=Half-year; 2=Modified half-year; 3=Mid-month (1st); 4=Mid-month (15th); 5=Mid-quarter; 6=Next mont
13	Asset Book	SWITCHOVER	i4	2	N		Switch over	1=No switch; 2=Straight-line
14	Asset Book	ORIGINALLIFEYEARS	i4	2	N		Original life years
15	Asset Book	ORIGINALLIFEDAYS	i4	2	N		Original life days
16	Asset Book	AMORTIZATIONCODE	i4	2	N		Amortization code	0=None; 1=Daily; 2=Weekly; 3=Monthly; 4=Quarterly; 5=Yearly; 6=Percentage; 7=Rate
17	Asset Book	AMORTIZATIONAMOUNT	number	21	N		Amortization amount/percentage
18	Asset Book	Initial_Allowance_Perc	number	21	N		Initial allowance percentage
19	Asset Book	SPECDEPRALLOW	i4	2	N		Special depreciation allowance	1=False; 2=True
20	Asset Book	SPECDEPRALLOWPCT	number	21	N		Special depreciation allowance percentage
21	Asset Book	LUXAUTOIND	i4	2	N		Luxury auto	1=False; 2=True
22	Asset Book	LUXVANTRUCK	i4	1	N		Luxury van or truck	0=False; 1=True
23	Asset Book	LUXELAUTO	i4	1	N		Luxury electric auto	0=False; 1=True
24	Asset Book	USERID	string	15	N		ID of user who entered
25	Asset Book	UpdateIfExists	i4	1	N	0	Flag to allow data to be updated if it exists	0=No; 1=Yes Do not use 1. taCreateAssetBook does not currently support updates. Update functionality
1	Asset Book I T C	ASSETID	string	15	Y	Not applicable	Asset ID
2	Asset Book I T C	ASSETIDSUF	i4	2	N	1	Asset suffix ID
3	Asset Book I T C	BOOKID	string	15	Y	Not applicable	Book ID
4	Asset Book I T C	ORGCOSTBASIS	number	21	N		Original cost basis
5	Asset Book I T C	SECT179EXPDED	number	21	N		Section 179 expense deduction
6	Asset Book I T C	ITCCODEREDAMT	number	21	N		ITC cost reduction amount
7	Asset Book I T C	MISCCOSTADJ	number	21	N		Miscellaneous cost adjustment
8	Asset Book I T C	TEFRAFLAG	i4	2	N		TEFRA flag	1=None; 2=Full credit reduce cost by 50% 3=Full credit reduce cost by 100% 4=Reduce ITC % by 2 point
9	Asset Book I T C	ITCAMTTAKEN	number	21	N		ITC amount taken
10	Asset Book I T C	ITCAMTALLOWED	number	21	N		ITC amount allowed
11	Asset Book I T C	ITCRECAPTURE	number	21	N		ITC recapture
12	Asset Book I T C	USERWHOENTERED	string	15	N		User who entered
13	Asset Book I T C	UpdateIfExists	i4	1	N	0	Flag to allow data to be updated if it exists	0=No; 1=Yes Do not use 1. taCreateAssetBookITC does not currently support updates. Update functional
1	Asset Class I D	ASSETCLASSID	string	15	Y	Not applicable	Asset class ID
2	Asset Class I D	ASSETCLASSIDDESCR	string	30	N		Asset class description
3	Asset Class I D	ACCTGRPID	string	15	N		Account group ID
4	Asset Class I D	INSCLASSID	string	15	N		Insurance class ID
1	Asset I D	ASSETID	string	15	Y	Not applicable	Asset ID
2	Asset I D	ASSETIDSUF	i4	2	N	1	Asset suffix ID
3	Asset I D	SHRTNAME	string	15	N	Default from setup	Short name
4	Asset I D	ASSETDESC	string	40	Y	Not applicable	Asset description
5	Asset I D	EXTASSETDESC	string	40	N	Default from setup	Extended description
6	Asset I D	Master_Asset_ID	string	19	N	Default from setup	Master asset ID
7	Asset I D	STRUCTUREID	string	30	N	Default from setup	Structure ID
8	Asset I D	ASSETCLASSID	string	15	Y	Not applicable	Asset class ID
9	Asset I D	LOCATNID	string	15	N	Default from setup	Location ID
10	Asset I D	ACQDATE	datetime	8	Y	Not applicable	Acquisition date
11	Asset I D	Acquisition_Cost	number	21	N	Default from setup	Acquisition cost
12	Asset I D	ASSETTYPE	i4	2	N	Default from setup	Asset type	1=New; 2=Used; 3=Leased
13	Asset I D	ASSETSTATUS	i4	2	N	Default from setup	Asset status	1=Active; 2=Deleted; 3=Partial open; 4=Retired
14	Asset I D	PROPTYPE	i4	2	N	Default from setup	Property type	1=Personal; 2=Personal, listed; 3=Real; 4=Real, listed; 5=Real, conservation; 6=Real, energy; 7=Real
15	Asset I D	ASSETQTY	i4	4	N	Default from setup	Quantity
16	Asset I D	ASSETBEGQTY	i4	4	N	Default from setup	Beginning quantity
17	Asset I D	ASSETCURRMAINT	number	21	N	Default from setup	Current year maintenance
18	Asset I D	ASSETYTDMAINT	number	21	N	Default from setup	YTD maintenance
19	Asset I D	ASSETLTDMAINT	number	21	N	Default from setup	LTD maintenance
20	Asset I D	LASTMAINTDATE	datetime	8	N	Default from setup	Last maintenance date
21	Asset I D	ASSESSEDVALUE	number	21	N	Default from setup	Assessed value
22	Asset I D	MFGRNAME	string	25	N	Default from setup	Manufacturers name
23	Asset I D	SERLNMBR	string	20	N	Default from setup	Serial number
24	Asset I D	MODELNUMBER	string	20	N	Default from setup	Model number
25	Asset I D	WARRENTYDATE	datetime	8	N	Default from setup	Warranty date
26	Asset I D	CUSTODIAN	string	25	N	Default from setup	Custodian
27	Asset I D	DATEADDED	datetime	8	N	Default from setup	Date added
28	Asset I D	DELETEDATE	datetime	8	N	Default from setup	Date deleted
29	Asset I D	Physical_Location_ID	string	15	N	Default from setup	Physical location ID
30	Asset I D	Asset_Label	string	19	N	Default from setup	Asset label
31	Asset I D	Verified_Date	datetime	8	N	Default from setup	Verified date
32	Asset I D	PIN	string	15	N	Default from setup	PIN
33	Asset I D	ACCTGRPID	string	15	N	Default from setup	Account group ID
34	Asset I D	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated, if it exists	0=No; 1=Yes
1	Asset Insurance	ASSETID	string	15	Y	Not applicable	Asset ID
2	Asset Insurance	ASSETIDSUF	i4	2	N	1	Asset suffix ID
3	Asset Insurance	INSURANCECLASS	string	15	Y	Not applicable	Insurance class ID
4	Asset Insurance	INSURANCEYEAR	i4	2	N	0	Insurance year
5	Asset Insurance	INSURANCEVALUE	number	21	N	0	Insurance value
6	Asset Insurance	REPLACEMENTCOST	number	21	N	0	Replacement cost
7	Asset Insurance	REPROCOST	number	21	N	0	Reproduction cost
8	Asset Insurance	DEPRREPROCOST	number	21	N	0	Depreciation reduction cost
9	Asset Insurance	EXCLUSIONAMT	number	21	N	0	Exclusion amount
10	Asset Insurance	EXCLUSIONTYPE	string	15	N		Exclusion type
1	Asset Lease	ASSETID	string	15	Y	Not applicable	Asset ID
2	Asset Lease	ASSETIDSUF	i4	2	N	1	Asset suffix ID
3	Asset Lease	LEASECOMPID	string	15	N		Lease company ID
4	Asset Lease	LEASETYPE	i4	2	N	0	Lease type	1=Capital; 2=Operating
5	Asset Lease	LEASECONTRACTID	string	15	N		Contract ID
6	Asset Lease	LEASEPAYMENT	number	21	N	0	Lease payment
7	Asset Lease	LEASEINTRATE	number	21	N	0	Interest rate
8	Asset Lease	LEASEENDDATE	datetime	8	N		End date
1	Asset Purchase	ASSETID	string	15	Y	Not Applicable	Asset ID
2	Asset Purchase	ASSETIDSUF	i4	2	Y	1	Asset suffix ID
3	Asset Purchase	PURCHLINESEQ	i4	4	Y		Purchase line sequence number Optional on Insert and Required on an Update
4	Asset Purchase	PURCHDESC	string	40	N		Purchase description
5	Asset Purchase	Acquisition_Cost	number	21	N		Acquisition cost
6	Asset Purchase	VENDORID	string	15	N		Vendor ID
7	Asset Purchase	DOCNUMBR	string	20	N		Document number
8	Asset Purchase	DOCDATE	datetime	8	Y	Not Applicable	Document date
9	Asset Purchase	TRXSORCE	string	13	N		Transaction source
10	Asset Purchase	ORCTRNUM	string	20	N		Voucher or receipt number
11	Asset Purchase	PORDNMBR	string	20	N		Purchase order number
12	Asset Purchase	CURNCYID	string	15	N		Currency ID
13	Asset Purchase	XCHGRATE	number	21	N	0	Exchange rate
14	Asset Purchase	RATETPID	string	15	N		Rate type ID
15	Asset Purchase	EXPNDATE	datetime	8	N		Expiration date
16	Asset Purchase	EXCHDATE	datetime	8	N		Exchange date
17	Asset Purchase	EXGTBDSC	string	30	N		Exchange ID description
18	Asset Purchase	EXTBLSRC	string	50	N		Exchange rate source
19	Asset Purchase	RATEEXPR	i4	2	N		Rate Expiration 0 = None 1=Daily 2=Weekly 3=Bi-Weekly 4=Semi-Monthly 5=Monthly 6=Quarterly 7=Annually 8=Miscellaneous 9=None
20	Asset Purchase	DYSTINCR	i4	2	N		Days to increment
21	Asset Purchase	RATEVARC	number	21	N		Rate variance
22	Asset Purchase	TRXDTDEF	i4	2	N		Transaction date default 0=Exact Date 1=Next Date 2=Previous Date
23	Asset Purchase	RTCLCMTD	i4	2	N		Rate calculation method 0=Multiply 1=Divide
24	Asset Purchase	PRVDSLMT	i4	2	N		Previous days limits
25	Asset Purchase	DATELMTS	i4	2	N		Date limits 0=Unlimited 1=Limited
26	Asset Purchase	TIME1	datetime	8	N		Time 1
27	Asset Purchase	USERID	string	15	N		User ID
28	Asset Purchase	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=No 1=Yes
1	Asset User Data	ASSETID	string	15	Y	Not applicable	Asset ID
2	Asset User Data	ASSETIDSUF	i4	2	N	1	Asset suffix ID
3	Asset User Data	USRFIELD1	string	6	N	Default from setup	User-defined field 1
4	Asset User Data	USRFIELD2	string	6	N	Default from setup	User-defined field 2
5	Asset User Data	USRFIELD3	string	10	N	Default from setup	User-defined field 3
6	Asset User Data	USRFIELD4	string	10	N	Default from setup	User-defined field 4
7	Asset User Data	USRFIELD5	string	20	N	Default from setup	User-defined field 5
8	Asset User Data	USRFIELD6	string	20	N	Default from setup	User-defined field 6
9	Asset User Data	USRFIELD7	string	20	N	Default from setup	User-defined field 7
10	Asset User Data	USRFIELD8	string	20	N	Default from setup	User-defined field 8
11	Asset User Data	USRFIELD9	string	40	N	Default from setup	User-defined field 9
12	Asset User Data	USRFIELD10	string	40	N	Default from setup	User-defined field 10
13	Asset User Data	USRFIELD11	number	21	N	Default from setup	User-defined field 11
14	Asset User Data	USRFIELD12	number	21	N	Default from setup	User-defined field 12
15	Asset User Data	USRFIELD13	number	21	N	Default from setup	User-defined field 13
16	Asset User Data	USRFIELD14	number	21	N	Default from setup	User-defined field 14
17	Asset User Data	USRFIELD15	number	21	N	Default from setup	User-defined field 15
18	Asset User Data	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=No; 1=Yes
19	Asset User Data	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	B R Bank Deposits Header	Option	i4	2	N	1	Deposit option	1=Enter/Edit; 2=Void* *void functionality not available in this release
2	B R Bank Deposits Header	DEPTYPE	i4	2	N	1	Deposit type	1=Deposit with receipt; 2=Deposit without receipt; 3=Clear unused receipts* *clear functionality not
3	B R Bank Deposits Header	DEPDATE	datetime	8	N		Deposit date
4	B R Bank Deposits Header	GLPOSTDT	datetime	8	N		GL posting date
5	B R Bank Deposits Header	CHEKBKID	string	15	Y	Not applicable	Checkbook ID
6	B R Bank Deposits Header	depositnumber	string	20	Y	Not applicable	Deposit number
7	B R Bank Deposits Header	DSCRIPTN	string	30	N		Description
8	B R Bank Deposits Header	DepAmt	number	21	N	0	Deposit amount; required for DEPTYPE=2
9	B R Bank Deposits Header	CheckTotal	number	21	N	0	Check total; used for DEPTYPE=2
10	B R Bank Deposits Header	CheckCount	i4	4	N	0	Check count; used for DEPTYPE=2
11	B R Bank Deposits Header	CreditCardTotal	number	21	N	0	Credit card total; used for DEPTYPE=2
12	B R Bank Deposits Header	CreditCardCount	i4	4	N	0	Credit card count; used for DEPTYPE=2
13	B R Bank Deposits Header	CurrencyAmount	i4	4	N	0	Currency total; used for DEPTYPE=2
14	B R Bank Deposits Header	CurrencyCount	i4	4	N	0	Currency count; used for DEPTYPE=2
15	B R Bank Deposits Header	CoinAmount	number	21	N	0	Coin total; used for DEPTYPE=2
16	B R Bank Deposits Header	XCHGRATE	number	21	N	0	Exchange rate
17	B R Bank Deposits Header	RATETPID	string	15	N		Rate type ID
18	B R Bank Deposits Header	EXPNDATE	datetime	8	N		Expiration date
19	B R Bank Deposits Header	EXCHDATE	datetime	8	N		Exchange date
20	B R Bank Deposits Header	EXGTBDSC	string	30	N		Exchange ID description
21	B R Bank Deposits Header	EXTBLSRC	string	50	N		Exchange rate source
22	B R Bank Deposits Header	RATEEXPR	i4	2	N	Default from setup	Rate expiration	0=None 1=Daily; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Quarterly; 7=Annually; 8=Miscellan
23	B R Bank Deposits Header	DYSTINCR	i4	2	N	Default from setup	Days to increment; used only when RATEEXPR=8
24	B R Bank Deposits Header	RATEVARC	number	21	N	0	Rate variance
25	B R Bank Deposits Header	TRXDTDEF	i4	2	N	Default from setup	Transaction date default	0=Exact date; 1=Next date; 2=Previous date
26	B R Bank Deposits Header	RTCLCMTD	i4	2	N	Default from setup	Rate calculation method	0=Multiply; 1=Divide
27	B R Bank Deposits Header	PRVDSLMT	i4	2	N	0	Previous day's limit
28	B R Bank Deposits Header	DATELMTS	i4	2	N	0	Date limits	0=Unlimited; 1=Limited
29	B R Bank Deposits Header	TIME1	datetime	8	N		MC exchange time=Time 1
30	B R Bank Deposits Header	MDFUSRID	string	15	N		Modified user ID; defaults to 'eBusiness' if not passed in
31	B R Bank Deposits Header	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if true it populates the Requester shadow table)
1	B R Bank Deposits Line	depositnumber	string	20	Y	Not applicable	Deposit number
2	B R Bank Deposits Line	RCPTNMBR	string	20	N	Default from setup	Receipt number; used to find receipt in CM20300 table
3	B R Bank Deposits Line	CHEKBKID	string	15	N	Default from setup	Checkbook ID; used to find receipt in CM20300 table
4	B R Bank Deposits Line	RcpType	i4	2	N	Default from setup	Receipt type	1=Check; 2=Cash; 3=Credit Card
5	B R Bank Deposits Line	CMRECNUM	number	21	N	Default from setup	Receipt number; use only if RCPTNMBR plus CHEKBKID plus RcpType are not unique
6	B R Bank Deposits Line	DEPDATE	datetime	8	N		Deposit date; needs to match the taBRBankDepositsHeader if a multi currency transaction
7	B R Bank Deposits Line	BANKNAME	string	30	N	Default from setup	Bank name
8	B R Bank Deposits Line	BNKBRNCH	string	20	N	Default from setup	Bank branch
9	B R Bank Deposits Line	CURRENCYTOTAL	i4	4	N	0	Originating currency total
10	B R Bank Deposits Line	COINTOTAL	number	21	N	0	Originating coin total
11	B R Bank Deposits Line	XCHGRATE	number	21	N	0	Exchange rate
12	B R Bank Deposits Line	RATETPID	string	15	N		Rate type ID
13	B R Bank Deposits Line	EXPNDATE	datetime	8	N		Expiration date
14	B R Bank Deposits Line	EXCHDATE	datetime	8	N		Exchange date
15	B R Bank Deposits Line	EXGTBDSC	string	30	N		Exchange ID description
16	B R Bank Deposits Line	EXTBLSRC	string	50	N		Exchange rate source
17	B R Bank Deposits Line	RATEEXPR	i4	2	N	Default from setup	Rate expiration	0=None 1=Daily; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Quarterly; 7=Annually; 8=Miscellan
18	B R Bank Deposits Line	DYSTINCR	i4	2	N	Default from setup	Days to increment; used only when RATEEXPR=8
19	B R Bank Deposits Line	RATEVARC	number	21	N	0	Rate variance
20	B R Bank Deposits Line	TRXDTDEF	i4	2	N	Default from setup	Transaction date default	0=Exact date; 1=Next date; 2=Previous date
21	B R Bank Deposits Line	RTCLCMTD	i4	2	N	Default from setup	Rate calculation method	0=Multiply; 1=Divide
22	B R Bank Deposits Line	PRVDSLMT	i4	2	N	0	Previous day's limit
23	B R Bank Deposits Line	DATELMTS	i4	2	N	0	Date limits	0=Unlimited; 1=Limited
24	B R Bank Deposits Line	TIME1	datetime	8	N		MC exchange time=Time 1
25	B R Bank Deposits Line	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if true it populates the Requester shadow table)
1	B R Bank Transaction Dist	Option	i4	2	Y	Not applicable	Transaction option	1=Enter transaction; 2=Enter receipt; 3=Void transaction; 4=Void Receipt
2	B R Bank Transaction Dist	ACTNUMST	string	75	Y	Not applicable	Account number string; must include separator characters
3	B R Bank Transaction Dist	DEBITAMT	number	21	N	0	Debit amount
4	B R Bank Transaction Dist	CRDTAMNT	number	21	N	0	Credit amount
5	B R Bank Transaction Dist	DistRef	string	30	N		Distribution reference
6	B R Bank Transaction Dist	RequesterTrx	i4	2	N	0	Requester transaction element is not used by eConnect in this node at this time
1	B R Bank Transaction Header	Option	i4	2	Y	Not applicable	Transaction option	1=Enter transaction; 2=Enter receipt
2	B R Bank Transaction Header	CMTrxType	i4	2	N	3	Transaction type (only used when Option=1)	3=Check; 4=Withdrawal; 5=Increase adjustment; 6=Decrease adjustment
3	B R Bank Transaction Header	RcpType	i4	2	N	1	Receipt type (only used when Option=2)	1=Check; 2=Cash; 3=Credit card
4	B R Bank Transaction Header	TRXDATE	datetime	8	N		Transaction date; default is system date
5	B R Bank Transaction Header	CHEKBKID	string	15	Y	Not applicable	Checkbook ID
6	B R Bank Transaction Header	CURNCYID	string	15	N		Currency ID; default is currency assigned to the checkbook
7	B R Bank Transaction Header	CMTrxNum	string	20	Y	Not applicable	Transaction number
8	B R Bank Transaction Header	CARDNAME	string	15	N		Credit card name; required when RcpType=3
9	B R Bank Transaction Header	paidtorcvdfrom	string	30	N		Paid to	when Option=1 or Rcvd from: when Option=2
10	B R Bank Transaction Header	DSCRIPTN	string	30	N		Description
11	B R Bank Transaction Header	TRXAMNT	number	21	Y	Not applicable	Transaction amount
12	B R Bank Transaction Header	USERID	string	15	N		User ID; default is eBusiness
13	B R Bank Transaction Header	GLPOSTDT	datetime	8	N		GL posting date; default is TRXDATE
14	B R Bank Transaction Header	DistRef	string	30	N		Distribution reference; only used for required default distribution
15	B R Bank Transaction Header	BACHNUMB	string	15	N		GL batch number For additional information, see Bank Reconciliationi
16	B R Bank Transaction Header	XCHGRATE	number	21	N	0	Exchange rate
17	B R Bank Transaction Header	RATETPID	string	15	N		Rate type ID
18	B R Bank Transaction Header	EXPNDATE	datetime	8	N		Expiration date
19	B R Bank Transaction Header	EXCHDATE	datetime	8	N		Exchange date
20	B R Bank Transaction Header	EXGTBDSC	string	30	N		Exchange ID description
21	B R Bank Transaction Header	EXTBLSRC	string	50	N		Exchange rate source
22	B R Bank Transaction Header	RATEEXPR	i4	2	N	Default is from setup	Rate expiration	0=None 1=Daily; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Quarterly; 7=Annually; 8=Miscellan
23	B R Bank Transaction Header	DYSTINCR	i4	2	N	Default is from setup	Days to increment; only used when RATEEXPR=8
24	B R Bank Transaction Header	RATEVARC	number	21	N	0	Rate variance
25	B R Bank Transaction Header	TRXDTDEF	i4	2	N	Default is from setup	Transaction date default	0=Exact date; 1=Next date; 2=Previous date
26	B R Bank Transaction Header	RTCLCMTD	i4	2	N	Default is from setup	Rate calculation method	0=Multiply; 1=Divide
27	B R Bank Transaction Header	PRVDSLMT	i4	2	N	0	Previous days limit
28	B R Bank Transaction Header	DATELMTS	i4	2	N	0	Date limits	0=Unlimited; 1=Limited
29	B R Bank Transaction Header	TIME1	datetime	8	N		Time 1; if not passed in, field used for finding XCHGRATE
30	B R Bank Transaction Header	RequesterTrx	i4	2	N	0	Requester transaction element is not used by eConnect in this node at this time
1	B R Bank Transaction Void	Option	i4	2	Y	Not applicable	Transaction option	3=Void transaction; 4=Void Receipt
2	B R Bank Transaction Void	VOIDDATE	datetime	8	N		Void date; default is original transaction date
3	B R Bank Transaction Void	CHEKBKID	string	15	Y	Not applicable	Checkbook ID
4	B R Bank Transaction Void	CMTrxNum	string	20	Y	Not applicable	Transaction number
5	B R Bank Transaction Void	VOIDDESC	string	30	N	Default from setup	Void description; defaults from original transaction
6	B R Bank Transaction Void	USERID	string	15	N		User ID; default is "eBusiness"
7	B R Bank Transaction Void	GLPOSTDT	datetime	8	N		GL posting date; default is original GLPOSTDT
8	B R Bank Transaction Void	DistRef	string	30	N	Default from setup	Distribution reference; defaults from original transaction
9	B R Bank Transaction Void	CreateDist	i4	1	N	1	Automatically pull in original distributions*	0=False; 1=True Manual distributions can also be used. For additional information, see Bank Reconcil
10	B R Bank Transaction Void	CMDNUMWK	number	21	N	0	Control Number; only needed if the combination of CMTrxNum and CHEKBKID are not unique
11	B R Bank Transaction Void	BACHNUMB	string	15	N		GL batch number For additional information, see Bank Reconciliation
12	B R Bank Transaction Void	RequesterTrx	i4	2	N	0	Requester transaction element is not used by eConnect in this node at this time
1	B R Delete Bank Deposits	CHEKBKID	string	15	Y	Not applicable	Checkbook ID
2	B R Delete Bank Deposits	depositnumber	string	20	Y	Not applicable	Deposit number
3	B R Delete Bank Deposits	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if true it populates the Requester shadow table)
1	B R Post Bank Deposits	CHEKBKID	string	15	Y	Not applicable	Checkbook ID
2	B R Post Bank Deposits	depositnumber	string	20	Y	Not applicable	Deposit number
3	B R Post Bank Deposits	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if true it populates the Requester shadow table)
4	B R Post Bank Deposits	PTDUSRID	string	15	N		User ID for posting
1	Bank	BANKID	string	15	Y	Not applicable	Bank ID
2	Bank	BANKNAME	string	30	Y	Not applicable	Bank name
3	Bank	ADDRESS1	string	60	N		Address 1
4	Bank	ADDRESS2	string	60	N		Address 2
5	Bank	ADDRESS3	string	60	N		Address 3
6	Bank	CITY	string	35	N		City
7	Bank	STATE	string	29	N		State
8	Bank	ZIPCODE	string	10	N		Zip/postal Code
9	Bank	COUNTRY	string	20	N		Country
10	Bank	PHNUMBR1	string	21	N		Phone number 1
11	Bank	PHNUMBR2	string	21	N		Phone number 2
12	Bank	PHONE3	string	21	N		Phone number 3
13	Bank	FAXNUMBR	string	21	N		Fax number
14	Bank	TRNSTNBR	string	9	N		Transit number
15	Bank	BNKBRNCH	string	20	N		Bank branch
16	Bank	DDTRANUM	string	9	N		DD transit number
17	Bank	Requester_trx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
1	Benefit	BENEFIT	string	6	Y	Not applicable	Benefit
2	Benefit	DSCRIPTN	string	30	Y	Not applicable	Deduction description
3	Benefit	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
4	Benefit	BNFBEGDT	datetime	8	Y	Not applicable	Benefit begin date
5	Benefit	BNFENDDT	datetime	8	N		Benefit end date
6	Benefit	VARBENFT	i4	1	N	0	Variable benefit/transaction required	0=False; 1=True
7	Benefit	BNFTFREQ	i4	2	N	1	Benefit frequency	1=Weekly; 2=Biweekly; 3=Semimonthly; 4=Monthly; 5=Quarterly; 6=Semiannually; 7=Annually; 8=Daily/mis
8	Benefit	SBJTFDTX	i4	1	N	0	Subject to federal tax	0=False; 1=True
9	Benefit	SBJTSSEC	i4	1	N	0	Subject to FICA Social Security tax	0=False; 1=True
10	Benefit	SBJTMCAR	i4	1	N	0	Subject to FICA Medicare tax	0=False; 1=True
11	Benefit	SBJTSTTX	i4	1	N	0	Subject to state tax	0=False; 1=True
12	Benefit	SBJTLTAX	i4	1	N	0	Subject to local tax	0=False; 1=True
13	Benefit	SBJTFUTA	i4	1	N	0	Subject to FUTA tax	0=False; 1=True
14	Benefit	SBJTSUTA	i4	1	N	0	Subject to SUTA tax	0=False; 1=True
15	Benefit	FFEDTXRT	number	21	N	0	Flat federal tax rate
16	Benefit	FLSTTXRT	number	21	N	0	Flat state tax rate
17	Benefit	BORCDTYP	i4	2	N	1	Based on record type	1=Paycodes; 2=Deductions
18	Benefit	BSDORCDS	i4	2	N	0	Based on records	0=False; 1=True
19	Benefit	BNFTMTHD	i4	2	N	1	Benefit method	1=% of gross; 2=% of net wages; 3=% of deduction; 4=Fixed amount; 5=Amount per unit
20	Benefit	BNFFRMLA	i4	2	N	0	Benefit formula
21	Benefit	BNFPRCNT_1	number	21	N	0	Benefit percent 1
22	Benefit	BNFPRCNT_2	number	21	N	0	Benefit percent 2
23	Benefit	BNFPRCNT_3	number	21	N	0	Benefit percent 3
24	Benefit	BNFPRCNT_4	number	21	N	0	Benefit percent 4
25	Benefit	BNFPRCNT_5	number	21	N	0	Benefit percent 5
26	Benefit	BNFITAMT_1	number	21	N	0	Benefit amount 1
27	Benefit	BNFITAMT_2	number	21	N	0	Benefit amount 2
28	Benefit	BNFITAMT_3	number	21	N	0	Benefit amount 3
29	Benefit	BNFITAMT_4	number	21	N	0	Benefit amount 4
30	Benefit	BNFITAMT_5	number	21	N	0	Benefit amount 5
31	Benefit	BNFTRMAX_1	number	21	N	0	Benefit tier maximum 1
32	Benefit	BNFTRMAX_2	number	21	N	0	Benefit tier maximum 2
33	Benefit	BNFTRMAX_3	number	21	N	0	Benefit tier maximum 3
34	Benefit	BNFTRMAX_4	number	21	N	0	Benefit tier maximum 4
35	Benefit	BNFTRMAX_5	number	21	N	0	Benefit tier maximum 5
36	Benefit	BNTRMXUN_1	number	21	N	0	Benefit tier maximum units 1
37	Benefit	BNTRMXUN_2	number	21	N	0	Benefit tier maximum units 2
38	Benefit	BNTRMXUN_3	number	21	N	0	Benefit tier maximum units 3
39	Benefit	BNTRMXUN_4	number	21	N	0	Benefit tier maximum units 4
40	Benefit	BNTRMXUN_5	number	21	N	0	Benefit tier maximum units 5
41	Benefit	BNPAYPMX	number	21	N	0	Benefit pay period Maximum
42	Benefit	BNFYRMAX	number	21	N	0	Benefit year maximum
43	Benefit	Benefit_Fiscal_Max	number	21	N	0	Benefit Fiscal Year Maximum
44	Benefit	BNFLFMAX	number	21	N	0	Benefit lifetime maximum
45	Benefit	W2BXNMBR	i4	2	N	0	W-2 box number
46	Benefit	W2BXLABL	string	6	N		W-2 box label
47	Benefit	W2BXNMBR2	i4	2	N	0	W-2 Box Number 2
48	Benefit	W2BXLABL2	string	6	N		W-2 Box Label 2
49	Benefit	W2BXNMBR3	i4	2	N	0	W-2 Box Number 3
50	Benefit	W2BXLABL3	string	6	N		W-2 Box Label 3
51	Benefit	W2BXNMBR4	i4	2	N	0	W-2 Box Number 4
52	Benefit	W2BXLABL4	string	6	N		W-2 Box Label 4
53	Benefit	DATAENTDFLT	i4	1	N	0	Data entry default	0=False; 1=True
54	Benefit	UpdateIfExists	i4	1	N	1	Flag to allow customer data to be updated if it exists	0=No; 1=Yes
55	Benefit	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
1	Benefit Based On Pay Ded Codes	BENEFIT	string	6	Y	Not applicable	Benefit
2	Benefit Based On Pay Ded Codes	BORCDTYP	i4	2	Y	Not applicable	Based on record type	1=Pay codes; 2=Deductions
3	Benefit Based On Pay Ded Codes	BSDONCDE	string	6	Y	Not applicable	Deduction description
4	Benefit Based On Pay Ded Codes	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
1	Book Class	BOOKID	string	15	Y	Not applicable	Book ID
2	Book Class	ASSETCLASSID	string	15	Y	Not applicable	Asset class ID
3	Book Class	DEPRECIATIONMETHOD	i4	2	Y	Not applicable	Depreciation method	1=Straight-line original life; 2=Straight-line remaining life; 3=125% DB; 4=150% DB; 5=175% DB; 6=20
4	Book Class	AVERAGINGCONV	i4	2	Y	Not applicable	Averaging convention	1=Half-year; 2=Modified half-year; 3=Midmonth (first); 4=Midmonth (fifteenth); 5=Midquarter; 6=Next
5	Book Class	AMORTIZATIONCODE	i4	2	N	0	Amortization code	1=Daily; 2=Weekly; 3=Monthly; 4=Quarterly; 5=Yearly; 6=Percentage; 7=Rate
6	Book Class	AMORTIZATIONAMOUNT	number	21	N	0	Amortization amount/percentage
7	Book Class	SWITCHOVER	i4	2	N	1	Switch over	1=No switch; 2=Straight line
8	Book Class	ORIGINALLIFEYEARS	i4	2	N	0	Original life years
9	Book Class	ORIGINALLIFEDAYS	i4	2	N	0	Original life days
10	Book Class	Initial_Allowance_Perc	i4	2	N	0	Initial allowance percentage
11	Book Class	SPECDEPRALLOW	i4	2	N	1	Special depreciation allowance	1=No; 2=Yes
12	Book Class	SPECDEPRALLOWPCT	i4	2	N	0	Special depreciation allowance percentage
13	Book Class	SALVAGEPCT	number	21	N	0	Salvage percentage
14	Book Class	SALVAGEEST	i4	1	N	0	Salvage estimate	1=No; 2 =Yes
15	Book Class	LUXAUTOIND	i4	2	N	1	Luxury auto	1=No; 2=Yes
16	Book Class	TEFRAFLAG	i4	2	N	1	TEFRA option	1=None; 2=Full credit reduce cost by 50%; 3=Full credit reduce cost by 100%; 4=Reduce ITC% by 2 poin
1	Book I D	BOOKID	string	15	Y	Not applicable	Book ID
2	Book I D	BOOKDESC	string	30	N		Book ID description
3	Book I D	DEPRPERIOD	i4	2	Y	Not applicable	Depreciation period	1=Periodic; 2=Daily
4	Book I D	CURRFISCALYR	i4	2	Y	Not applicable	Current fiscal year
5	Book I D	Auto_Add_Book_Info	i4	1	N	1	Auto add book information	0=False; 1=True
1	Buyer	BUERID	string	15	Y	Not applicable	Buyer ID
2	Buyer	DSCRIPTN	string	30	Y	Not applicable	Description
3	Buyer	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
1	Checkbook	CHEKBKID	string	15	Y	Not applicable	Checkbook ID
2	Checkbook	DSCRIPTN	string	30	Y	Not applicable	Checkbook description
3	Checkbook	BANKID	string	15	N		Bank ID
4	Checkbook	CURNCYID	string	15	Y	Not applicable	Currency ID
5	Checkbook	ACTNUMST	string	75	Y	Not applicable	Account number
6	Checkbook	BNKACTNM	string	15	N		Bank account number
7	Checkbook	NXTCHNUM	string	20	N	1	Next check number
8	Checkbook	Next_Deposit_Number	string	20	N	1	Next deposit number
9	Checkbook	INACTIVE	i4	1	N	0	Inactive flag
10	Checkbook	MXCHDLR	number	21	N	0	Maximum check amount
11	Checkbook	DUPCHNUM	i4	1	N	0	Allow duplicate check numbers
12	Checkbook	OVCHNUM1	i4	1	N	1	Override check numbers
13	Checkbook	LOCATNID	string	15	N		Company address ID
14	Checkbook	CMUSRDF1	string	20	N		User defined 1
15	Checkbook	CMUSRDF2	string	20	N		User defined 2
16	Checkbook	Last_Reconciled_Date	datetime	8	N		Last reconciled date
17	Checkbook	Last_Reconciled_Balance	number	21	N	0	Last reconciled balance
18	Checkbook	DDACTNUM	string	17	N		Bank account number from the direct deposit button
19	Checkbook	DDINDNAM	string	22	N		Account name from the direct deposit button
20	Checkbook	DDTRANS	string	2	N	27	Account type from the direct deposit button	27=Checking; 37=Savings
21	Checkbook	PaymentRateTypeID	string	15	N		Payment rate type ID
22	Checkbook	DepositRateTypeID	string	15	N		Deposit rate type ID
23	Checkbook	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Computer Check Line Insert	BACHNUMB	string	15	Y	Not applicable	Batch number
2	Computer Check Line Insert	EMPLOYID	string	15	Y	Not applicable	Employee ID
3	Computer Check Line Insert	COMPTRTP	i4	2	N	1	Computer transaction type	1=Pay code; 2=Deduction; 3=Benefit
4	Computer Check Line Insert	SALCHG	i4	2	N	0	Salary change; required if passing a salary pay code	1=Reallocate dollars; 2=Reallocate hours; 3=Reduce dollars; 4=Reduce hours; 5=Additional amount
5	Computer Check Line Insert	UPRTRXCD	string	6	Y	Not applicable	UPR transaction code
6	Computer Check Line Insert	TRXBEGDT	datetime	8	N		Transaction begin date
7	Computer Check Line Insert	TRXENDDT	datetime	8	N		Transaction end date
8	Computer Check Line Insert	TRXHRUNT	number	21	N	0	Transaction hours/units; required if the pay code passed is	1=Salary with a salary change of reallocated hours; 2=Salary with a salary change of reduced hours;
9	Computer Check Line Insert	HRLYPYRT	number	21	N	0	Hourly pay rate
10	Computer Check Line Insert	PAYRTAMT	number	21	N	0	Pay rate amount; required if passing the pay code	1=Salary with a salary change of reallocated dollars; 2=Salary with a salary change of reduced dolla
11	Computer Check Line Insert	VARDBAMT	number	21	N	0	Variable deduction/benefit amount
12	Computer Check Line Insert	VARDBPCT	number	21	N	0	Variable deduction/benefit percent
13	Computer Check Line Insert	RECEIPTS	number	21	N	0	Receipts
14	Computer Check Line Insert	DAYSWRDK	number	21	N	0	Days worked
15	Computer Check Line Insert	WKSWRKD	number	21	N	0	Weeks worked
16	Computer Check Line Insert	DEPRTMNT	string	6	N		Department; if empty, pulls from UPR00100
17	Computer Check Line Insert	JOBTITLE	string	6	N		Job title/position code; if empty, pulls from UPR00100
18	Computer Check Line Insert	STATECD	string	2	N		State code
19	Computer Check Line Insert	LOCALTAX	string	6	N		Local tax
20	Computer Check Line Insert	SUTASTAT	string	2	N		SUTA state
21	Computer Check Line Insert	WRKRCOMP	string	6	N		Workers' compensation code
22	Computer Check Line Insert	SHFTCODE	string	6	N		Shift code
23	Computer Check Line Insert	SHFTPREM	number	21	N	0	Shift premium
24	Computer Check Line Insert	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
25	Computer Check Line Insert	USERID	string	15	N		User ID
1	Credit Card	RCVBGRBX	i4	2	N	0	Receivable group box	0=Bank Card; 1=Charge Card
2	Credit Card	CARDNAME	string	15	Y	Not applicable	Credit card name
3	Credit Card	CBPAYBLE	i4	1	N	0	Used by company	0=False; 1=True
4	Credit Card	CBRCVBLE	i4	1	N	0	Accepted from customers	0=False; 1=True
5	Credit Card	CKBKNUM1	string	15	N		Checkbook number 1; for customers
6	Credit Card	ACTNUMST	string	75	N		Account Number
7	Credit Card	VENDORID	string	15	N		Vendor ID
8	Credit Card	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
9	Credit Card	USERID	string	15	N		User ID
10	Credit Card	CREATDDT	datetime	8	N	Default from setup	Create date
11	Credit Card	MODIFDT	datetime	8	N	Default from setup	Modified date
NULL	Customer Address	Print_Phone_NumberGB	i4	2	N		Print phone number	!ERROR! I635 -> Formula Error: An unexpected error occurred
NULL	Customer Address	USERDEF1	string	20	N		User defined 1
NULL	Customer Address	USERDEF2	string	20	N		User defined 2
NULL	Customer Address	UpdateIfExists	i4	1	N	1	Flag to allow updates to customer data	!ERROR! I638 -> Formula Error: An unexpected error occurred
NULL	Customer Address	RequesterTrx	i4	2	N	0	Requester transaction	!ERROR! I639 -> Formula Error: An unexpected error occurred
1	Customer Address	CUSTNMBR	string	15	Y	Not applicable	Customer number
2	Customer Address	ADRSCODE	string	15	Y	Not applicable	Address ID
3	Customer Address	SLPRSNID	string	15	N		Salesperson ID
4	Customer Address	UPSZONE	string	3	N		UPS zone
5	Customer Address	SHIPMTHD	string	15	N		Shipping method
6	Customer Address	TAXSCHID	string	15	N		Tax schedule
7	Customer Address	CNTCPRSN	string	60	N		Contact person
8	Customer Address	ADDRESS1	string	60	N		Customer address one
9	Customer Address	ADDRESS2	string	60	N		Customer address two
10	Customer Address	ADDRESS3	string	60	N		Customer address three
11	Customer Address	COUNTRY	string	60	N		Customer country
12	Customer Address	CITY	string	35	N		Customer city
13	Customer Address	STATE	string	29	N		Customer state
14	Customer Address	ZIPCODE	string	10	N		Customer zip
15	Customer Address	PHNUMBR1	string	21	N		Phone one
16	Customer Address	PHNUMBR2	string	21	N		Phone two
17	Customer Address	PHNUMBR3	string	21	N		Phone three
18	Customer Address	FAX	string	21	N		Fax
19	Customer Address	GPSFOINTEGRATIONID	string	30	N		Front office integration ID
20	Customer Address	INTEGRATIONSOURCE	i4	2	N	0	Integration source
21	Customer Address	INTEGRATIONID	string	30	N		Integration ID
22	Customer Address	CCode	string	6	N		Country code
23	Customer Address	LOCNCODE	string	10	N		Location code
24	Customer Address	SALSTERR	string	15	N		Sales territory
25	Customer Address	ShipToName	string	64	N		Ship to name
1	Customer Class	CLASSID	string	15	Y	Not applicable	Class ID
2	Customer Class	CLASDSCR	string	30	N		Class description
3	Customer Class	CRLMTTYP	i4	2	N	0	Credit limit type	0=No credit; 1=Unlimited; 2=Amount
4	Customer Class	CRLMTAMT	number	21	N	0	Credit amount
5	Customer Class	CRLMTPER	i4	2	N	0	Credit limit period
6	Customer Class	CRLMTPAM	number	21	N	0	Credit limit period amount
7	Customer Class	DEFLTCLS	i4	1	N	0	Default class
8	Customer Class	BALNCTYP	i4	2	N	0	Balance type	0=Open item; 1=Balance forward
9	Customer Class	CHEKBKID	string	15	N		Checkbook ID
10	Customer Class	TAXSCHID	string	15	N		Tax schedule ID
11	Customer Class	SHIPMTHD	string	15	N		Shipping method
12	Customer Class	PYMTRMID	string	20	N		Payment term ID
13	Customer Class	CUSTDISC	i4	2	N	0	Customer discount/trade discount
14	Customer Class	MINPYTYP	i4	2	N	0	Minimum payment type	0=No minimum; 1=Percent; 2=Amount
15	Customer Class	MINPYDLR	number	21	N	0	Minimum payment dollar
16	Customer Class	MINPYPCT	i4	2	N	0	Minimum payment percent
17	Customer Class	MXWOFTYP	i4	2	N	0	Maximum write-off type	0=Not allowed; 1=Unlimited; 2=Maximum
18	Customer Class	MXWROFAM	number	21	N	0	Maximum write-off amount
19	Customer Class	FNCHATYP	i4	2	N	0	Finance charge amount type	0=None; 1=Percent; 2=Amount
20	Customer Class	FINCHDLR	number	21	N	0	Finance charge dollar
21	Customer Class	FNCHPCNT	i4	2	N	0	Finance charge percent
22	Customer Class	PRCLEVEL	string	10	N		Price level
23	Customer Class	CURNCYID	string	15	N		Currency ID
24	Customer Class	RATETPID	string	15	N		Rate ID
25	Customer Class	DEFCACTY	i4	2	N	0	Cash account from	0=Checkbook; 1=Customer
26	Customer Class	CASHACCT	string	75	N		Cash account
27	Customer Class	ACCTRECACCT	string	75	N		Account Receivable account
28	Customer Class	SALESACCT	string	75	N		Sales account
29	Customer Class	COSTOFSALESACCT	string	75	N		Cost of sales account
30	Customer Class	IVACCT	string	75	N		Inventory account
31	Customer Class	TERMDISCTAKENACCT	string	75	N		Terms discount taken account
32	Customer Class	TERMDISCAVAILACCT	string	75	N		Terms discount available account
33	Customer Class	FINCHRGACCT	string	75	N		Finance charges account
34	Customer Class	WRITEOFFACCT	string	75	N		Write-off account
35	Customer Class	SALESORDERRETACCT	string	75	N		Sales order returns account
36	Customer Class	SALSTERR	string	15	N		Sales territory
37	Customer Class	SLPRSNID	string	15	N		Sales person ID
38	Customer Class	STMTCYCL	i4	2	N	5	Statement cycle	1=No statement; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Bimonthly; 7=Quarterly
39	Customer Class	KPCALHST	i4	1	N	1	Keep calendar history	0=False; 1=True
40	Customer Class	KPDSTHST	i4	1	N	1	Keep distribution history	0=False; 1=True
41	Customer Class	KPERHIST	i4	1	N	1	Keep period history	0=False; 1=True
42	Customer Class	KPTRXHST	i4	1	N	1	Keep transaction history	0=False; 1=True
43	Customer Class	DISGRPER	i4	2	N	0	Discount grace period
44	Customer Class	DUEGRPER	i4	2	N	0	Due date of grace period
45	Customer Class	Revalue_Customer	i4	1	N	1	Revalue customer	0=False; 1=True
46	Customer Class	Post_Results_To	i4	2	N	0	Post results to	0=Receivables/discount account 1=Sales offset account
47	Customer Class	ORDERFULFILLDEFAULT	i4	1	N	1	Order fulfillment shortage default	1=None; 2=Back order remaining; 3=Cancel remaining
48	Customer Class	CUSTPRIORITY	i4	2	N	1	Customer priority; valid input values are 1 (none) to 100
49	Customer Class	RMOvrpymtWrtoffAcct	string	75	N		RM overpayment write-off account
50	Customer Class	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Customer Items	ITEMNMBR	string	30	Y	Not applicable	Item number
2	Customer Items	CUSTNMBR	string	15	Y	Not applicable	Customer ID
3	Customer Items	CUSTITEMNMBR	string	30	N		Customer item
4	Customer Items	CUSTITEMDESC	string	50	N		Customer item description
5	Customer Items	CUSTITEMSHORNAME	string	15	N		Customer item short name
6	Customer Items	CUSTITEMGENERICDESC	string	10	N		Customer generic
7	Customer Items	USRDEF1	string	20	N		User defined 1
8	Customer Items	USRDEF2	string	20	N		User defined 2
9	Customer Items	USRDEF03	string	20	N		User defined 3
10	Customer Items	USRDEF04	string	20	N		User defined 4
11	Customer Items	USRDEF05	string	20	N		User defined 5
12	Customer Items	SUBITEMNMBR	string	30	N		Substitute item number
13	Customer Items	STRTDATE	datetime	8	N		Substitute items effective start date
14	Customer Items	ENDDATE	datetime	8	N		Substitute items effective end date
15	Customer Items	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Deduction	DEDUCTION	string	6	Y	Not applicable	Deduction
2	Deduction	DSCRIPTN	string	30	Y	Not applicable	Deduction description
3	Deduction	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
4	Deduction	DEDBEGDT	datetime	8	Y	Not applicable	Begin date
5	Deduction	DEDENDDT	datetime	8	N		End date
6	Deduction	DEDTYPE	i4	2	N	1	Deduction Type 1 = Standard 2 = Garnishment
7	Deduction	GARNCAT	i4	2	Y	0	Garnishment Category Required if Deduction Type is set to a 2 1= Support Order, 2 = Tax Levy, 3 = Bankruptcy, 4 = Garnishment 5 = Other
8	Deduction	VARDEDTN	i4	1	N	0	Variable deduction	0=False; 1=True
9	Deduction	DEDNFREQ	i4	2	N	1	Deduction frequency	1=Weekly; 2=Biweekly; 3=Semimonthly; 4=Monthly; 5=Quarterly; 6=Semiannually; 7=Annually; 8=Daily/mis
10	Deduction	SFRFEDTX	i4	1	N	0	Sheltered from federal tax	0=False; 1=True
11	Deduction	SHFRFICA	i4	1	N	0	Sheltered from FICA tax	0=False; 1=True
12	Deduction	SHFRSTTX	i4	1	N	0	Sheltered from state tax	0=False; 1=True
13	Deduction	SFRLCLTX	i4	1	N	0	Sheltered from local tax	0=False; 1=True
14	Deduction	BSDORCDS	i4	2	N	0	Based on records	0=All; 1=Selected
15	Deduction	DEDNMTHD	i4	2	N	1	Deduction method	1=Percentage of gross wages; 2=Percentage of net wages; 3=Fixed amount; 4=Amount per unit 5=Percenta
16	Deduction	DEDFRMLA	i4	2	N	0	Deduction formula	0=Single; 1=Multiple
17	Deduction	EARNINGSCODE	string	15	N		Earning code
18	Deduction	DEDCAMNT_1	number	21	N	0	Deduction amount 1
19	Deduction	DEDCAMNT_2	number	21	N	0	Deduction amount 2
20	Deduction	DEDCAMNT_3	number	21	N	0	Deduction amount 3
21	Deduction	DEDCAMNT_4	number	21	N	0	Deduction amount 4
22	Deduction	DEDCAMNT_5	number	21	N	0	Deduction amount 5
23	Deduction	DEDNPRCT_1	number	21	N	0	Deduction percentage 1
24	Deduction	DEDNPRCT_2	number	21	N	0	Deduction percentage 2
25	Deduction	DEDNPRCT_3	number	21	N	0	Deduction percentage 3
26	Deduction	DEDNPRCT_4	number	21	N	0	Deduction percentage 4
27	Deduction	DEDNPRCT_5	number	21	N	0	Deduction percentage 5
28	Deduction	DEDTRMAX_1	number	21	N	0	Deduction tier maximum 1
29	Deduction	DEDTRMAX_2	number	21	N	0	Deduction tier maximum 2
30	Deduction	DEDTRMAX_3	number	21	N	0	Deduction tier maximum 3
31	Deduction	DEDTRMAX_4	number	21	N	0	Deduction tier maximum 4
32	Deduction	DEDTRMAX_5	number	21	N	0	Deduction tier maximum 5
33	Deduction	DETRMXUN_1	number	21	N	0	Deduction tier maximum units 1
34	Deduction	DETRMXUN_2	number	21	N	0	Deduction tier maximum units 2
35	Deduction	DETRMXUN_3	number	21	N	0	Deduction tier maximum units 3
36	Deduction	DETRMXUN_4	number	21	N	0	Deduction tier maximum units 4
37	Deduction	DETRMXUN_5	number	21	N	0	Deduction tier maximum units 5
38	Deduction	DEPYPRMX	number	21	N	0	Deduction pay period maximum
39	Deduction	DEDYRMAX	number	21	N	0	Deduction year maximum
40	Deduction	Deduction_Fiscal_Yr_Max	number	21	N	0	Deduction Fiscal Year Maximum
41	Deduction	DEDLTMAX	number	21	N	0	Deduction life maximum
42	Deduction	W2BXNMBR	i4	2	N	0	W-2 box number
43	Deduction	W2BXLABL	string	6	N		W-2 box label
44	Deduction	W2BXNMBR2	i4	2	N	0	W-2 Box Number 2
45	Deduction	W2BXLABL2	string	6	N		W-2 Box Label 2
46	Deduction	W2BXNMBR3	i4	2	N	0	W-2 Box Number 3
47	Deduction	W2BXLABL3	string	6	N		W-2 Box Label 3
48	Deduction	W2BXNMBR4	i4	2	N	0	W-2 Box Number 4
49	Deduction	W2BXLABL4	string	6	N		W-2 Box Label 4
50	Deduction	DATAENTDFLT	i4	1	N	0	Data entry default	0=False; 1=True
51	Deduction	UpdateIfExists	i4	1	N	1	Flag to allow customer data to be updated if it currently exists	0=No; 1=Yes
52	Deduction	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
1	Deduction Based On Pay Codes	DEDUCTION	string	6	Y	Not applicable	Deduction
2	Deduction Based On Pay Codes	BSDONCDE	string	30	Y	Not applicable	Deduction description
3	Deduction Based On Pay Codes	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates requester shadow table)
1	Delete Applicant	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination or if you are going to pass this instead of the LASTNAME and FIRSTNAME combination
4	Delete Applicant	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Application	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Application	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Application	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination or if you are going to pass this instead of the LASTNAME and FIRSTNAME combination
4	Delete Applicant Application	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Internal Sequence Number Required only if you are going to pass this instead of Requisition Number OR if you have multiple instances of the same Applicant and Requisition Number
5	Delete Applicant Application	REQUISITIONNUMBER_I	i4	4	Y	Not applicable	Requisition Number Required only if you are not passing the Sequence Number
6	Delete Applicant Application	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Education	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Education	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Education	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination or if you are going to pass this instead of the LASTNAME and FIRSTNAME combination
4	Delete Applicant Education	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Education Line	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Education Line	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Education Line	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination or if you are going to pass this instead of the LASTNAME and FIRSTNAME combination
4	Delete Applicant Education Line	UNIVERSITY	string	31	Y	Not applicable	University
5	Delete Applicant Education Line	ISEQUENCENUMBER_I	i4	2	Y		Sequence Number Required only if you have the same applicants and same university on more then one record
6	Delete Applicant Education Line	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Interview	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Interview	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Interview	APPINTTYPESTR_I	string	21	Y	Not applicable	Interview type
4	Delete Applicant Interview	APPLYDATE_I	datetime	8	Y	Not applicable	Interview date
5	Delete Applicant Interview	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you are passing Applicant Number and not LASTNAME and FIRSTNAME combination
6	Delete Applicant Interview	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant References	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant References	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant References	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you want to pass Applicant Number and not pass LASTNAME and FIRSTNAME combination
4	Delete Applicant References	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant References Line	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant References Line	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant References Line	REFERENCENAME_I	string	61	Y	Not applicable	Reference name
4	Delete Applicant References Line	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you want to pass Applicant Number and not pass LASTNAME and FIRSTNAME combination
5	Delete Applicant References Line	ISEQUENCENUMBER_I	i4	2	Y		Sequence Number Required only if you have the same applicants and same reference on more then one record
6	Delete Applicant References Line	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Requisitions Line	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Requisitions Line	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Requisitions Line	REQUISITIONNUMBER_I	i4	4	Y	Not applicable	Requisition number
4	Delete Applicant Requisitions Line	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you want to pass Applicant Number and not pass LASTNAME and FIRSTNAME combination
5	Delete Applicant Requisitions Line	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence Number Required only if you have the same applicant and same requisition on more then one record
6	Delete Applicant Requisitions Line	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Tests	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Tests	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Tests	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination or if you want to pass Applicant Number instead of FIRSTNAME and LASTNAME combination
4	Delete Applicant Tests	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Tests Line	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Tests Line	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Tests Line	TESTCODE_I	string	7	Y	Not applicable	Test code
4	Delete Applicant Tests Line	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you pass Application Number instead of FIRSTNAME and LASTNAME combination
5	Delete Applicant Tests Line	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence Number Required only if you have the same applicants and same Test Code on more then one record
6	Delete Applicant Tests Line	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Applicant Work History	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Work History	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Work History	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if passing Applicant Number and not FIRSTNAME LASTNAME combination
4	Delete Applicant Work History	RequesterTrx	i4	2	N	0	Requester Transaction - 0=false,1=true - if true, then populates Requester shadow table
1	Delete Applicant Work History Line	LLASTNAME_I	string	21	Y	Not applicable	Last name
2	Delete Applicant Work History Line	FFIRSTNAME_I	string	15	Y	Not applicable	First name
3	Delete Applicant Work History Line	NAME	string	31	Y	Not applicable	Employer name
4	Delete Applicant Work History Line	APPLICANTNUMBER_I	number	21	Y	Not applicable	Applicant Number Required only if you have multiple applicants with the same name combination OR if you are passing Applicant Number instead of FIRSTNAME LASTNAME combination
5	Delete Applicant Work History Line	ISEQUENCENUMBER_I	i4	2	Y	Not applicable	Sequence Number Required only if you have the same applicants and same name/employeer on more then one record
6	Delete Applicant Work History Line	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Customer Address	CUSTNMBR	string	15	Y	Not applicable	Customer number
2	Delete Customer Address	ADRSCODE	string	15	Y	Not applicable	Address ID
3	Delete Customer Address	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Delete Customer Rcd	CUSTNMBR	string	15	Y	Not applicable	Customer number
2	Delete Customer Rcd	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Delete Employee	EMLOYID	string	15	Y	Not applicable	Employee number
2	Delete Employee	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Delete Employee Address	EMLOYID	string	15	Y	Not applicable	Employee number
2	Delete Employee Address	ADRSCODE	string	15	Y	Not applicable	Address ID
3	Delete Employee Address	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Delete Employee Pay Code	EMPLOYID	string	15	Y	Not applicable	Employee number
2	Delete Employee Pay Code	PAYRCORD	string	7	Y	Not applicable	Pay code
3	Delete Employee Pay Code	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Requisition	REQUISITIONNUMBER_I	i4	4	Y	Not applicable	Requisition number
2	Delete Requisition	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Salesperson Rcd	SLPRSNID	string	15	Y	Not applicable	Salesperson ID
2	Delete Salesperson Rcd	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Delete Skill Sets	SKILLSET_I	string	31	Y	Not applicable	Skill set
2	Delete Skill Sets	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Skill Sets Line	SKILLSET_I	string	31	Y	Not applicable	Skill set
2	Delete Skill Sets Line	SKILLTITLE_I	string	31	Y	Not applicable	Skill
3	Delete Skill Sets Line	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Skills	SKILLTITLE_I	string	31	Y	Not appllicable	Skill
2	Delete Skills	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Delete Tests	TEST_I	string	31	Y	Not applicable	Test
2	Delete Tests	TESTCODE_I	string	7	Y	Not applicable	Test code
3	Delete Tests	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
9	Delete Tests	LOCNCODE	string	10	Y		Location/site code
10	Delete Tests	LOCNDSCR	string	30	Y		Location/site description
11	Delete Tests	ADDRESS1	string	60	N		Address 1
12	Delete Tests	ADDRESS2	string	60	N		Address 2
13	Delete Tests	ADDRESS3	string	60	N		Address 3
14	Delete Tests	CITY	string	35	N		City
15	Delete Tests	STATE	string	29	N		State
16	Delete Tests	ZIPCODE	string	10	N		ZIP Code
17	Delete Tests	COUNTRY	string	60	N		Country
18	Delete Tests	PHONE1	string	20	N		Phone 1
19	Delete Tests	PHONE2	string	20	N		Phone 2
20	Delete Tests	PHONE3	string	20	N		Phone 3
21	Delete Tests	FAXNUMBR	string	20	N		Fax number
22	Delete Tests	Location_Segment	string	66	N		Location segment
23	Delete Tests	STAXSCHD	string	15	N		Sales tax schedule ID
24	Delete Tests	PCTAXSCH	string	15	N		Purchases tax schedule ID
25	Delete Tests	INCLDDINPLNNNG	i4	1	N	1	Include in planning	0=False; 1=True
26	Delete Tests	CCode	string	6	N		Country code
27	Delete Tests	PORECEIPTBIN	string	15	N		Purchase receipt bin
28	Delete Tests	PORETRNBIN	string	15	N		Purchase return bin
29	Delete Tests	SOFULFILLMENTBIN	string	15	N		Sales order fulfillment bin
30	Delete Tests	SORETURNBIN	string	15	N		Sales order returns bin
31	Delete Tests	BOMRCPTBIN	string	15	N		Assembly receipts bin
32	Delete Tests	MATERIALISSUEBIN	string	15	N		Material issues bin
33	Delete Tests	MORECEIPTBIN	string	15	N		Manufacturing receipts bin
34	Delete Tests	REPAIRISSUESBIN	string	15	N		Repair issues bin
1	Delete Vendor Address	VENDORID	string	15	Y	Not applicable	Vendor ID
2	Delete Vendor Address	ADRSCODE	string	15	Y	Not applicable	Address ID
3	Delete Vendor Address	RequesterTrx	i4	2	N	0	Requester Transaction 0=false, 1=true If true, then populates Requester shadow table
1	Department	DEPRTMNT	string	6	Y	Not applicable	Department
2	Department	DSCRIPTN	string	30	Y	Not applicable	Department description
3	Department	UpdateIfExists 1	i4	1	N	1	Flag to allow customer data to updated if it currently exists	0=No; 1=Yes
4	Department	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	Employee	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee	EMPLCLAS	string	15	N		Employee class
3	Employee	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
4	Employee	LASTNAME	string	20	Y	Not applicable	Last name
5	Employee	FRSTNAME	string	15	Y	Not applicable	First name
6	Employee	MIDLNAME	string	15	N		Middle name
7	Employee	EMPLSUFF	string	4	N		Employee suffix
8	Employee	ADRSCODE	string	15	N		Address code
9	Employee	ADDRESS1	string	30	N		Address code 1
10	Employee	ADDRESS2	string	30	N		Address code 2
11	Employee	ADDRESS3	string	30	N		Address code 3
12	Employee	CITY	string	30	N		City
13	Employee	STATE	string	29	N		State
14	Employee	ZIPCODE	string	10	N		ZIP Code
15	Employee	COUNTY	string	20	N		County
16	Employee	COUNTRY	string	20	N		Country
17	Employee	PHONE1	string	21	N		Phone number 1
18	Employee	PHONE2	string	21	N		Phone number 2
19	Employee	PHONE3	string	21	N		Phone number 3
20	Employee	FAX	string	21	N		Fax number
21	Employee	SOCSCNUM	string	15	Y	Not applicable	Social Security number
22	Employee	BRTHDATE	datetime	8	N		Birth date
23	Employee	GENDER	i4	2	N	3	Gender	1=Male; 2=Female; 3=Not applicable
24	Employee	ETHNORGN	i4	2	N	7	Ethnic origin	1=White; 2=Native American or Alaskan Native; 3=Black or African American; 4=Asian; 5=Hispanic or La
25	Employee	Calc_Min_Wage_Bal	i4	1	N	Default from setup	Calculate minimum wage balance	0=False; 1=True
26	Employee	DIVISIONCODE_I	string	6	N		Division code; HR option only
27	Employee	DEPRTMNT	string	6	Y	Not applicable	Department
28	Employee	JOBTITLE	string	6	Y	Not applicable	Job title/position
29	Employee	SUPERVISORCODE_I	string	6	N		Supervisor Code
30	Employee	LOCATNID	string	15	N		Location ID
31	Employee	WCACFPAY	i4	2	N	0	Cash account from	0=Checkbook; 1=Employee
32	Employee	AccountNumber	string	75	N		Account number
33	Employee	WKHRPRYR	i4	2	N	0	Work hours per year
34	Employee	STRTDATE	datetime	8	N		Start date
35	Employee	DEMPINAC	datetime	8	N		Date employee inactivated; this field is active if INACTIVE=1
36	Employee	RSNEMPIN	string	30	N		Reason employee inactivated; this field is active if INACTIVE=1
37	Employee	MINETPAY	number	21	N	Default from setup	Minimum net pay
38	Employee	SUTASTAT	string	2	N		SUTA state
39	Employee	WRKRCOMP	string	6	N		Workers' compensation code
40	Employee	ATACRVAC	i4	1	N	Default from setup	Auto accrue vacation	0=False; 1=True
41	Employee	VACCRAMT	number	21	N	Default from setup	Vacation accrual amount
42	Employee	VACCRMTH	i4	2	N	Default from setup	Vacation accrual method	0=Hours worked; 1=Set hours
43	Employee	VACAPRYR	number	21	N	Default from setup	Vacation hours per year
44	Employee	VACAVLBL	number	21	N	Default from setup	Vacation available
45	Employee	WRNVCNFLSBLWZR	i4	1	N	Default from setup	Warn if vacation falls below zero	0=False; 1=True
46	Employee	ATACRSTM	i4	1	N		Auto accrue sick time	0=False 1=True
47	Employee	STMACMTH	i4	2	N	0	Sick Time Accrual Method	0=Hours worked 1=Set hours
48	Employee	SKTMACAM	number	21	N		Sick time accrual amount
49	Employee	SIKTIMAV	number	21	N		Sick time available
50	Employee	SKTMHPYR	number	21	N		Sick time hours per year
51	Employee	WRNSTFLSBLWZR	i4	1	N		Warn sick time falls below zero 0=False 1=True
52	Employee	USERDEF1	string	20	N		User defined 1
53	Employee	USERDEF2	string	20	N		User defined 2
54	Employee	EMPLOYMENTTYPE	i4	2	N	Default from setup	Type of employment	1=Full-time regular; 2=Full-time temporary; 3=Part-time regular; 4=Part-time temporary; 5=Intern; 6=
55	Employee	MARITALSTATUS	i4	2	N	3	Marital status	1=Married; 2=Single; 3=Not applicable
56	Employee	BENADJDATE	datetime	8	N		Benefit adjustment date
57	Employee	LASTDAYWORKED_I	datetime	8	N		Last day worked
58	Employee	BIRTHDAY	i4	2	N	0	Birthday
59	Employee	BIRTHMONTH	i4	2	N	0	Birth month	1=January; 2=February; 3=March; 4=April; 5=May; 6=June; 7=July; 8=August; 9=September; 10=October; 1
60	Employee	SPOUSE	string	15	N		Spouse
61	Employee	SPOUSESSN	string	15	N		Spouse Social Security number
62	Employee	NICKNAME	string	20	N		Nickname
63	Employee	ALTERNATENAME	string	20	N		Alternate name
64	Employee	STATUSCD	string	15	N		Status code
65	Employee	HRSTATUS	i4	2	N	1	HR Status; HR option only	1=Active; 2=Family leave; 3=Leave of absence; 4=Maternity; 5=Retired; 6=Separated; 7=Suspended; 8=Te
66	Employee	DATEOFLASTREVIEW_I	datetime	8	N		Date of last review; HR option only
67	Employee	DATEOFNEXTREVIEW_I	datetime	8	N		Date of next review; HR option only
68	Employee	BENEFITEXPIRE_I	datetime	8	N		Benefit expire
69	Employee	HANDICAPPED	i4	1	N	0	Handicapped; HR option only	0=False; 1=True
70	Employee	VETERAN	i4	1	N	0	Veteran; HR option only	0=False; 1=True
71	Employee	VIETNAMVETERAN	i4	1	N	0	Vietnam veteran; HR option only	0=False; 1=True
72	Employee	DISABLEDVETERAN	i4	1	N	0	Disabled veteran; HR option only	0=False; 1=True
73	Employee	UNIONEMPLOYEE	i4	1	N	0	Union employee; HR option only	0=False; 1=True
74	Employee	SMOKER_I	i4	1	N	0	Smoker; HR option only	0=False; 1=True
75	Employee	CITIZEN	i4	1	N	0	Citizen; HR option only	0=False; 1=True
76	Employee	VERIFIED	i4	1	N	0	Verified; HR option only	0=False; 1=True
77	Employee	I9RENEW	datetime	8	N		I9 renew; HR option only
78	Employee	Primary_Pay_Record	string	6	N		Primary pay record; HR option only
79	Employee	CHANGEBY_I	string	15	N		Change by; HR option only
80	Employee	CHANGEDATE_I	datetime	8	N		Change date; HR option only
81	Employee	UNIONCD	string	6	N		Union code; HR option only
82	Employee	RATECLSS	string	15	N		Rate class; HR option only
83	Employee	FEDCLSSCD	string	10	N		Federal class; HR option only
84	Employee	OTHERVET	i4	1	N	0	Other veterans; HR option only
85	Employee	Military_Discharge_Date	datetime	8	N		Military discharge date; HR option only
86	Employee	DefaultFromClass	i4	1	N	1	Default information from class	0=False; 1=True
87	Employee	UpdateIfExists	i4	1	N	1	Flag to allow customer data to be updated if it exists	0=No; 1=Yes
88	Employee	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
94	Employee	USERID	string	15	N		GP user ID
1	Employee Address	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Address	ADRSCODE	string	15	Y	Not applicable	Address code
3	Employee Address	ADDRESS1	string	60	N		Address line 1
4	Employee Address	ADDRESS2	string	60	N		Address line 2
5	Employee Address	ADDRESS3	string	60	N		Address line 3
6	Employee Address	CITY	string	35	N		City
7	Employee Address	STATE	string	29	N		State
8	Employee Address	ZIPCODE	string	10	N		ZIP Code/postal code
9	Employee Address	COUNTY	string	60	N		County
10	Employee Address	COUNTRY	string	60	N		Country
11	Employee Address	PHONE1	string	21	N		Phone 1
12	Employee Address	PHONE2	string	21	N		Phone 2
13	Employee Address	PHONE3	string	21	N		Phone 3
14	Employee Address	FAX	string	21	N		Fax number
15	Employee Address	Foreign_Address	i4	1	N	0	Foreign address	0=False; 1=True
16	Employee Address	Foreign_StateProvince	string	23	N		Foreign state or province
17	Employee Address	Foreign_Postal_Code	string	15	N		Foreign postal code
18	Employee Address	Ccode	string	6	N		Country code
19	Employee Address	UpdateIfExists	i4	1	N	1	Flag to allow address data to updated if it currently exists	0=No; 1=Yes
20	Employee Address	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Benefit	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Benefit	BENEFIT	string	6	Y	Not applicable	Pay code
3	Employee Benefit	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
4	Employee Benefit	BNFBEGDT	datetime	8	N		Benefit begin date; required if UseDefaultCoBenefit=0 and optional if UseDefaultCoBenefit=1
5	Employee Benefit	BNFENDDT	datetime	8	N		Benefit end date
6	Employee Benefit	VARBENFT	i4	1	N	Default from setup	Variable benefit/transaction required	0=False; 1=True
7	Employee Benefit	BNFTFREQ	i4	2	N	Default from setup	Benefit frequency	1=Weekly; 2=Biweekly; 3=Semimonthly; 4=Monthly; 5=Quarterly; 6=Semiannually; 7=Annually; 8=Daily/mis
8	Employee Benefit	SBJTFDTX	i4	1	N	Default from setup	Subject to federal tax	0=False; 1=True
9	Employee Benefit	SBJTSSEC	i4	1	N	Default from setup	Subject to FICA Social Security tax	0=False; 1=True
10	Employee Benefit	SBJTMCAR	i4	1	N	Default from setup	Subject to FICA Medicare tax	0=False; 1=True
11	Employee Benefit	SBJTSTTX	i4	1	N	Default from setup	Subject to state tax	0=False; 1=True
12	Employee Benefit	SBJTLTAX	i4	1	N	Default from setup	Subject to local tax	0=False; 1=True
13	Employee Benefit	SBJTFUTA	i4	1	N	Default from setup	Subject to FUTA tax	0=False; 1=True
14	Employee Benefit	SBJTSUTA	i4	1	N	Default from setup	Subject to SUTA tax	0=False; 1=True
15	Employee Benefit	FFEDTXRT	number	21	N	Default from setup	Flat federal tax rate
16	Employee Benefit	FLSTTXRT	number	21	N	Default from setup	Flat state tax rate
17	Employee Benefit	BORCDTYP	i4	2	N	Default from setup	Based on record type	1=Pay codes; 2=Deductions
18	Employee Benefit	BSDORCDS	i4	2	N	Default from setup	Based on records	0=False; 1=True
19	Employee Benefit	BNFTMTHD	i4	2	N	Default from setup	Benefit method	1=Percentage of gross wages; 2=Percentage of net wages; 3=Percentage of deduction; 4=Fixed amount; 5
20	Employee Benefit	BNFFRMLA	i4	2	N	Default from setup	Benefit formula	0=Single; 1=Multiple
21	Employee Benefit	BNFPRCNT_1	number	21	N	Default from setup	Benefit percent 1
22	Employee Benefit	BNFPRCNT_2	number	21	N	Default from setup	Benefit percent 2
23	Employee Benefit	BNFPRCNT_3	number	21	N	Default from setup	Benefit percent 3
24	Employee Benefit	BNFPRCNT_4	number	21	N	Default from setup	Benefit percent 4
25	Employee Benefit	BNFPRCNT_5	number	21	N	Default from setup	Benefit percent 5
26	Employee Benefit	BNFITAMT_1	number	21	N	Default from setup	Benefit amount 1
27	Employee Benefit	BNFITAMT_2	number	21	N	Default from setup	Benefit amount 2
28	Employee Benefit	BNFITAMT_3	number	21	N	Default from setup	Benefit amount 3
29	Employee Benefit	BNFITAMT_4	number	21	N	Default from setup	Benefit amount 4
30	Employee Benefit	BNFITAMT_5	number	21	N	Default from setup	Benefit amount 5
31	Employee Benefit	BNFTRMAX_1	number	21	N	Default from setup	Benefit tier max 1
32	Employee Benefit	BNFTRMAX_2	number	21	N	Default from setup	Benefit tier max 2
33	Employee Benefit	BNFTRMAX_3	number	21	N	Default from setup	Benefit tier max 3
34	Employee Benefit	BNFTRMAX_4	number	21	N	Default from setup	Benefit tier max 4
35	Employee Benefit	BNFTRMAX_5	number	21	N	Default from setup	Benefit tier max 5
36	Employee Benefit	BNTRMXUN_1	number	21	N	Default from setup	Benefit tier max units 1
37	Employee Benefit	BNTRMXUN_2	number	21	N	Default from setup	Benefit tier max units 2
38	Employee Benefit	BNTRMXUN_3	number	21	N	Default from setup	Benefit tier max units 3
39	Employee Benefit	BNTRMXUN_4	number	21	N	Default from setup	Benefit tier max units 4
40	Employee Benefit	BNTRMXUN_5	number	21	N	Default from setup	Benefit tier max units 5
41	Employee Benefit	BNPAYPMX	number	21	N	Default from setup	Benefit pay period maximum
42	Employee Benefit	BNFYRMAX	number	21	N	Default from setup	Benefit year maximum
43	Employee Benefit	Benefit_Fiscal_Max	number	21	N	0	Benefit Fiscal Year Maximum
44	Employee Benefit	BNFLFMAX	number	21	N	Default from setup	Benefit lifetime maximum
45	Employee Benefit	W2BXNMBR	i4	2	N	Default from setup	W-2 box number
46	Employee Benefit	W2BXLABL	string	6	N	Default from setup	W-2 box label
47	Employee Benefit	W2BXNMBR2	i4	2	N		W-2 Box Number 2
48	Employee Benefit	W2BXLABL2	string	6	N		W-2 Box Label 2
49	Employee Benefit	W2BXNMBR3	i4	2	N	0	W-2 Box Number 3
50	Employee Benefit	W2BXLABL3	string	6	N		W-2 Box Label 3
51	Employee Benefit	W2BXNMBR4	i4	2	N	0	W-2 Box Number 4
52	Employee Benefit	W2BXLABL4	string	6	N		W-2 Box Label 4
53	Employee Benefit	DATAENTDFLT	i4	1	N	Default from setup	Data entry default	0=False; 1=True
54	Employee Benefit	EMPLRMAXMAT	number	21	N	Default from setup	Employer maximum match
55	Employee Benefit	UseDefaultCoBenefit	i4	2	N	Default from setup	Use default company benefit	0=False; 1=True
56	Employee Benefit	UpdateIfExists	i4	1	N	1	Flag to allow address data to updated if it currently exists	0=No; 1=Yes
57	Employee Benefit	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Benefit Based On Pay Ded Codes	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Benefit Based On Pay Ded Codes	BENEFIT	string	6	Y	Not applicable	Benefit
3	Employee Benefit Based On Pay Ded Codes	BORCDTYP	i4	2	Y	Not applicable	Based on record type	1=Pay codes; 2=Deductions
4	Employee Benefit Based On Pay Ded Codes	BSDONCDE	string	6	Y	Not applicable	Deduction description
5	Employee Benefit Based On Pay Ded Codes	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Class	EMPLCLAS	string	15	Y	Not applicable	Employee class ID
2	Employee Class	DSCRIPTN	string	30	Y	Not applicable	Class description
3	Employee Class	DEPRTMNT	string	6	N		Department
4	Employee Class	JOBTITLE	string	6	N		Job title
5	Employee Class	SUTASTAT	string	2	N		SUTA state
6	Employee Class	WRKRCOMP	string	6	N		Workers' compensation
7	Employee Class	MINETPAY	number	21	N	0	Minimum net pay
8	Employee Class	WKHRPRYR	i4	2	N	2080	Work hours per year
9	Employee Class	WCACFPAY	i4	2	N	0	Which cash account for pay	0=Checkbook; 1=Employee
10	Employee Class	AccountNumber	string	75	N		Account number
11	Employee Class	USERDEF1	string	20	N		User defined 1
12	Employee Class	USERDEF2	string	20	N		User defined 2
13	Employee Class	ATACRVAC	i4	1	N	0	Auto accrue vacation	0=False; 1=True
14	Employee Class	VACCRMTH	i4	2	N	0	Vacation accrual method	0=False; 1=True
15	Employee Class	VACCRAMT	number	21	N	0	Vacation accrual amount
16	Employee Class	VACAPRYR	number	21	N	0	Vacation hours per year
17	Employee Class	VACAVLBL	number	21	N	0	Vacation available
18	Employee Class	WRNVCNFLSBLWZR	i4	1	N	1	Warn vacation falls below zero	0=False; 1=True
19	Employee Class	ATACRSTM	i4	1	N	0	Auto accrue sick time
20	Employee Class	STMACMTH	i4	2	N	0	Sick time accrual method
21	Employee Class	SKTMACAM	number	21	N	0	Sick time accrual amount
22	Employee Class	SKTMHPYR	number	21	N	0	Sick time hours per year
23	Employee Class	SIKTIMAV	number	21	N	0	Sick time available
24	Employee Class	WRNSTFLSBLWZR	i4	1	N	1	Warn sick time falls below zero	0=False; 1=True
25	Employee Class	DEFLTCLS	i4	1	N	0	Default class	0=False; 1=True
26	Employee Class	Calc_Min_Wage_Bal	i4	1	N	0	Calculate minimum wage balance	0=False; 1=True
27	Employee Class	EMPLOYMENTTYPE	i4	2	N	1	Type of employment	1=Full-time regular; 2=Full-time temporary; 3=Part-time regular; 4=Part-time temporary; 5=Intern
28	Employee Class	DefaultFromClass	i4	1	N	1	Flag to determine if a parameter is brought in blank and whether or not to pull from Default class	0=No; 1=Yes
29	Employee Class	UpdateIfExists	i4	1	N	1	Flag to allow employee data to updated if it currently exists	0=No; 1=Yes
30	Employee Class	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Deduction	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Deduction	DEDUCTON	string	6	Y	Not applicable	Deduction
3	Employee Deduction	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
4	Employee Deduction	DEDBEGDT	datetime	8	N		Deduction start date; required if not using deduction code as the default, so UseDefaultCoDeduction=0; optional if using the default and then UseDefaultCoDeduction=1
5	Employee Deduction	DEDENDDT	datetime	8	N		Deduction end date
6	Employee Deduction	VARDEDTN	i4	1	N	Default from setup	Variable deduction	0=False; 1=True
7	Employee Deduction	DEDNFREQ	i4	2	N	Default from setup	Deduction frequency	1=Weekly; 2=Biweekly; 3=Semimonthly; 4=Monthly; 5=Quarterly; 6=Semiannually; 7=Annually; 8=Daily/mis
8	Employee Deduction	SFRFEDTX	i4	1	N	Default from setup	Sheltered from federal tax	0=False; 1=True
9	Employee Deduction	SHFRFICA	i4	1	N	Default from setup	Sheltered from FICA tax	0=False; 1=True
10	Employee Deduction	SHFRSTTX	i4	1	N	Default from setup	Sheltered from state tax	0=False; 1=True
11	Employee Deduction	SFRLCLTX	i4	1	N	Default from setup	Sheltered from local tax	0=False; 1=True
12	Employee Deduction	BSDORCDS	i4	2	N	Default from setup	Based on records	0=All; 1=Selected
13	Employee Deduction	DEDNMTHD	i4	2	N	Default from setup	Deduction method	1=Percentage of gross wages; 2=Percentage of net wages; 3=Fixed amount; 4=Amount per unit 5=Percenta
14	Employee Deduction	DEDFRMLA	i4	2	N	Default from setup	Deduction formula	0=Single; 1=Multiple
15	Employee Deduction	DEDNPRCT_1	number	21	N	Default from setup	Deduction percentage 1
16	Employee Deduction	DEDNPRCT_2	number	21	N	Default from setup	Deduction percentage 2
17	Employee Deduction	DEDNPRCT_3	number	21	N	Default from setup	Deduction percentage 3
18	Employee Deduction	DEDNPRCT_4	number	21	N	Default from setup	Deduction percentage 4
19	Employee Deduction	DEDNPRCT_5	number	21	N	Default from setup	Deduction percentage 5
20	Employee Deduction	DEDCAMNT_1	number	21	N	Default from setup	Deduction amount 1
21	Employee Deduction	DEDCAMNT_2	number	21	N	Default from setup	Deduction amount 2
22	Employee Deduction	DEDCAMNT_3	number	21	N	Default from setup	Deduction amount 3
23	Employee Deduction	DEDCAMNT_4	number	21	N	Default from setup	Deduction amount 4
24	Employee Deduction	DEDCAMNT_5	number	21	N	Default from setup	Deduction amount 5
25	Employee Deduction	DEDTRMAX_1	number	21	N	Default from setup	Deduction tier maximum 1
26	Employee Deduction	DEDTRMAX_2	number	21	N	Default from setup	Deduction tier maximum 2
27	Employee Deduction	DEDTRMAX_3	number	21	N	Default from setup	Deduction tier maximum 3
28	Employee Deduction	DEDTRMAX_4	number	21	N	Default from setup	Deduction tier maximum 4
29	Employee Deduction	DEDTRMAX_5	number	21	N	Default from setup	Deduction tier maximum 5
30	Employee Deduction	DETRMXUN_1	number	21	N	Default from setup	Deduction tier maximum units 1
31	Employee Deduction	DETRMXUN_2	number	21	N	Default from setup	Deduction tier maximum units 2
32	Employee Deduction	DETRMXUN_3	number	21	N	Default from setup	Deduction tier maximum units 3
33	Employee Deduction	DETRMXUN_4	number	21	N	Default from setup	Deduction tier maximum units 4
34	Employee Deduction	DETRMXUN_5	number	21	N	Default from setup	Deduction tier maximum units 5
35	Employee Deduction	DEPYPRMX	number	21	N	Default from setup	Deduction pay period maximum
36	Employee Deduction	DEDYRMAX	number	21	N	Default from setup	Deduction year maximum
37	Employee Deduction	Deduction_Fiscal_Yr_Max	number	21	N	0	Deduction fiscal year maximum
38	Employee Deduction	DEDLTMAX	number	21	N	Default from setup	Deduction life maximum
39	Employee Deduction	W2BXNMBR	i4	2	N	Default from setup	W-2 box number
40	Employee Deduction	W2BXLABL	string	6	N	Default from setup	W-2 box label
41	Employee Deduction	W2BXNMBR2	i4	2	N		W-2 Box Number 2
42	Employee Deduction	W2BXLABL2	string	6	N		W-2 Box Label 2
43	Employee Deduction	W2BXNMBR3	i4	2	N	0	W-2 Box Number 3
44	Employee Deduction	W2BXLABL3	string	6	N		W-2 Box Label 3
45	Employee Deduction	W2BXNMBR4	i4	2	N	0	W-2 Box Number 4
46	Employee Deduction	W2BXLABL4	string	6	N		W-2 Box Label 4
47	Employee Deduction	DATAENTDFLT	i4	1	N	Default from setup	Data entry default	0=False; 1=True
48	Employee Deduction	UseDefaultCoDeduction	i4	2	N	1	Use default company deduction	0=False; 1=True
49	Employee Deduction	EARNINGSCODE	string	15	N		Earnings code
50	Employee Deduction	COURTDATE	datetime	8	N		Court Date
51	Employee Deduction	COURTNAME	string	31	N		Court name
52	Employee Deduction	DOCDESCR	string	31	N		Document ID
53	Employee Deduction	ORIGINALAMOUNT	number	21	N	0	Original amount
54	Employee Deduction	AMNTTAKEN	number	21	N	0	Amount taken
55	Employee Deduction	FEDMAXDED	string	15	N		Federal maximum deduction
56	Employee Deduction	STATEMAXDED	string	15	N		State maximum deduction
57	Employee Deduction	VENDORID	string	15	N		Vendor ID
58	Employee Deduction	UpdateIfExists	i4	1	N	1	Flag to allow address data to be updated if it currently exists	0=No; 1=Yes
59	Employee Deduction	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Deduction Based On Pay Codes	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Deduction Based On Pay Codes	DEDUCTION	string	6	Y	Not applicable	Deduction
3	Employee Deduction Based On Pay Codes	BSDONCDE	string	30	Y	Not applicable	Deduction description
4	Employee Deduction Based On Pay Codes	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Local Tax	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Local Tax	LOCALTAX	string	6	Y	Not applicable	Local tax
3	Employee Local Tax	LCLFGSTS	string	6	N		Local filing status	SINGLE=Single; MAR=Married; ''=Not Applicable
4	Employee Local Tax	AULCLTAX	i4	1	N	1	Automatically calculate	0=False; 1=True
5	Employee Local Tax	NUMOFEXM	i4	2	N	0	Number of exemptions
6	Employee Local Tax	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
7	Employee Local Tax	ADTLLOCWTHDNG	number	21	N	0	Additional withholding
8	Employee Local Tax	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it currently exists	0=No; 1=Yes
9	Employee Local Tax	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Pay Code	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Pay Code	PAYRCORD	string	6	Y	Not applicable	Pay code
3	Employee Pay Code	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
4	Employee Pay Code	BSPAYRCD	string	6	N	Default from setup	Based on pay code
5	Employee Pay Code	PAYRTAMT	number	21	N	Default from setup	Pay rate amount
6	Employee Pay Code	PAYUNIT	string	25	N	Default from setup	Pay unit; required if passing a piecework pay code
7	Employee Pay Code	PAYUNPER	i4	2	N	Default from setup	Pay unit period	1=Weekly; 2=Biweekly; 3=Semimonthly; 4=Monthly; 5=Quarterly; 6=Semiannually; 7=Annually; 8=Daily/mis
8	Employee Pay Code	RPTASWGS	i4	1	N	Default from setup	Report as wages	0=False; 1=True
9	Employee Pay Code	SBJTFDTX	i4	1	N	Default from setup	Subject to federal tax	0=False; 1=True
10	Employee Pay Code	SBJTSSEC	i4	1	N	Default from setup	Subject to Social Security	0=False; 1=True
11	Employee Pay Code	SBJTMCAR	i4	1	N	Default from setup	Subject to Medicare	0=False; 1=True
12	Employee Pay Code	SBJTSTTX	i4	1	N	Default from setup	Subject to state tax	0=False; 1=True
13	Employee Pay Code	SBJTLTAX	i4	1	N	Default from setup	Subject to local tax	0=False; 1=True
14	Employee Pay Code	SBJTFUTA	i4	1	N	Default from setup	Subject to FUTA tax	0=False; 1=True
15	Employee Pay Code	SBJTSUTA	i4	1	N	Default from setup	Subject to SUTA Tax	0=False; 1=True
16	Employee Pay Code	SUTASTAT	string	2	N		SUTA state
17	Employee Pay Code	FFEDTXRT	number	21	N	Default from setup	Federal tax rate
18	Employee Pay Code	FLSTTXRT	number	21	N	Default from setup	State tax rate
19	Employee Pay Code	PAYPEROD	i4	2	N	Default from setup	Pay period
20	Employee Pay Code	MXPYPPER	number	21	N	Default from setup	Maximum per pay period
21	Employee Pay Code	TipType	i4	2	N	Default from setup	Tip type	1=Directly; 2=Indirectly
22	Employee Pay Code	PAYADVNC	number	21	N	Default from setup	Pay advance
23	Employee Pay Code	ACRUVACN	i4	1	N	Default from setup	Auto accrue vacation time	0=False; 1=True
24	Employee Pay Code	ACRUSTIM	i4	1	N	Default from setup	Auto accrue sick time	0=False; 1=True
25	Employee Pay Code	WRKRCOMP	string	6	N		Workers' compensation code
26	Employee Pay Code	W2BXNMBR	i4	2	N	Default from setup	W-2 box number
27	Employee Pay Code	W2BXLABL	string	6	N	Default from setup	W-2 box label
28	Employee Pay Code	W2BXNMBR2	i4	2	N		W-2 Box Number 2
29	Employee Pay Code	W2BXLABL2	string	6	N		W-2 Box Label 2
30	Employee Pay Code	W2BXNMBR3	i4	2	N	0	W-2 Box Number 3
31	Employee Pay Code	W2BXLABL3	string	6	N		W-2 Box Label 3
32	Employee Pay Code	W2BXNMBR4	i4	2	N	0	W-2 Box Number 4
33	Employee Pay Code	W2BXLABL4	string	6	N		W-2 Box Label 4
34	Employee Pay Code	PYADVTKN	number	21	N	0	Pay advance taken
35	Employee Pay Code	DATAENTDFLT	i4	1	N	Default from setup	Data entry level	0=False; 1=True
36	Employee Pay Code	Primary_Pay_Record	i4	1	N	0	Primary Pay Record HR Only Option 0=False 1=True
37	Employee Pay Code	SHFTCODE	string	6	N	Default from setup	Shift code
38	Employee Pay Code	PAYFACTR	number	21	N	Default from setup	Pay factor
39	Employee Pay Code	UseDefaultCoPayCode	i4	2	N	1	Use default company pay code	0=False; 1=True
40	Employee Pay Code	UpdateIfExists	i4	1	N	1	Flag to allow address data to updated if it currently exists	0=No; 1=Yes
41	Employee Pay Code	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee State Tax	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee State Tax	STATECD	string	15	Y	Not applicable	State code
3	Employee State Tax	TXFLGSTS	string	30	N		Tax filing status
4	Employee State Tax	EXMFBLND	i4	1	N	0	Exemption for blind	0=False; 1=True
5	Employee State Tax	EXFBLSPS	i4	1	N	0	Exemption for blind spouse	0=False; 1=True
6	Employee State Tax	EXFORO65	i4	1	N	0	Exemption for over 65	0=False; 1=True
7	Employee State Tax	EXMFRSLF	i4	1	N	0	Exemption for self	0=False; 1=True
8	Employee State Tax	EXMFSPAL	i4	1	N	0	Exemption for special allowance	0=False; 1=True
9	Employee State Tax	EXMFRSPS	i4	1	N	0	Exemption for spouse	0=False; 1=True
10	Employee State Tax	EXFSPO65	i4	1	N	0	Exemption for spouse over 65	0=False; 1=True
11	Employee State Tax	PRSNEXPT	i4	2	N	0	Personal exemption
12	Employee State Tax	DEPNDNTS	i4	2	N	0	Dependents
13	Employee State Tax	ADNLALOW	i4	2	N	0	Additional allowances
14	Employee State Tax	ESTDEDAL	i4	2	N	0	Estimated deduction allowance
15	Employee State Tax	EXMTAMNT	number	21	N	0	Exemption amount
16	Employee State Tax	ADSTWHDG	number	21	N	0	Additional state withholding
17	Employee State Tax	ESTSTWHD	number	21	N	0	Estimated state withholding
18	Employee State Tax	INACTIVE	i4	1	N	0	Inactive	0=False; 1=True
19	Employee State Tax	UpdateIfExists	i4	1	N	1	Flag to allow employee data to updated if it currently exists	0=No; 1=Yes
20	Employee State Tax	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	Employee Tax	EMPLOYID	string	15	Y	Not applicable	Employee ID
2	Employee Tax	FDFLGSTS	string	15	N		Federal filing status	MAR=Married; SINGLE=Single; BLANK=Exempt; NRA=Non-resident alien
3	Employee Tax	FEDEXMPT	i4	30	N	0	Number of exemptions claimed
4	Employee Tax	ADFDWHDG	number	30	N	0	Additional federal withholding
5	Employee Tax	ESTFEDWH	number	30	N	0	Estimated federal withholding
6	Employee Tax	STATECD	string	30	N		State code
7	Employee Tax	LOCALTAX	string	29	N		Local tax code
8	Employee Tax	W2BF942E	i4	1	N	0	W2 box for 942 employee	0=False; 1=True
9	Employee Tax	W2BFDCSD	i4	1	N	0	W2 box for deceased	0=False; 1=True
10	Employee Tax	W2BFDCMP	i4	1	N	0	W2 box for deferred compensation	0=False; 1=True
11	Employee Tax	W2BFLREP	i4	1	N	0	W2 box for legal representative	0=False; 1=True
12	Employee Tax	W2BFPPLN	i4	1	N	0	W2 box for pension plan	0=False; 1=True
13	Employee Tax	W2BFSTEM	i4	1	N	0	W2 box for statutory employee	0=False; 1=True
14	Employee Tax	MCRQGEMP	i4	1	N	0	Medicare qualified government employee
15	Employee Tax	EICFLGST	string	6	N		EIC filing status	BLANK=Not eligible; MAR=Married, both spouses file certificate; MAR2=Married without spouse filing c
16	Employee Tax	NYTXDiff	i4	1	N	1	Withhold NY tax difference
17	Employee Tax	UpdateIfExists	i4	1	N	1	Flag to allow employee data to updated if it currently exists	0=No; 1=Yes
18	Employee Tax	RequesterTrx	i4	2	N	0	Requester transaction 0=False; 1=True (if True, it populates the requester shadow table)
1	F S Equipment Master	SERLNMBR	string	21	Y	Not applicable	Serial number
2	F S Equipment Master	ITEMNMBR	string	31	Y	Not applicable	Item number
3	F S Equipment Master	REFRENCE	string	31	N		A reference about the equipment
4	F S Equipment Master	Version	string	31	N		The version of the equipment
5	F S Equipment Master	SRLSTAT	string	11	N	Default from setup	The status of the equipment
6	F S Equipment Master	CUSTNMBR	string	15	Y	Not applicable	Customer number
7	F S Equipment Master	ADRSCODE	string	15	Y	Not applicable	Customer address code
8	F S Equipment Master	ADDRESS1	string	61	N		Customer address line 1
9	F S Equipment Master	ADDRESS2	string	61	N		Customer address line 2
10	F S Equipment Master	ADDRESS3	string	61	N		Customer address line 2
11	F S Equipment Master	CITY	string	35	N		Customer city
12	F S Equipment Master	STATE	string	29	N		Customer state code
13	F S Equipment Master	ZIP	string	11	N		Customer ZIP Code
14	F S Equipment Master	COUNTRY	string	61	N		Customer country
15	F S Equipment Master	CNTCPRSN	string	61	N		Customer Contact person
16	F S Equipment Master	INSTDTE	datetime	8	N	Not applicable	The date the equipment was installed
17	F S Equipment Master	Shipped_Date	datetime	8	N	Not applicable	The date the equipment was shipped
18	F S Equipment Master	SVC_Register_Date	datetime	8	N	Not applicable	The date the equipment was registered
19	F S Equipment Master	LSTPMDTE	datetime	8	N	Not applicable	The last date that preventive maintenance was performed on the equipment
20	F S Equipment Master	LSTSRVDTE	datetime	8	N	Not applicable	The last date of a service call for the equipment
21	F S Equipment Master	TECHID	string	11	N		The primary technician responsible for the equipment
22	F S Equipment Master	OFFID	string	11	N		The office responsible for servicing the equipment
23	F S Equipment Master	SVCAREA	string	11	N		The service area in which the equipment is installed
24	F S Equipment Master	TIMEZONE	string	3	N		The time zone where is equipment is installed
25	F S Equipment Master	VENDORID	string	15	N		The vendor from which the equipment was originally purchased
26	F S Equipment Master	WARRCDE	string	11	N		The warranty code offered by the vendor for the equipment
27	F S Equipment Master	WARRSTART	datetime	8	N	Not applicable	The date the vendor warranty starts for the equipment
28	F S Equipment Master	WARREND	datetime	8	N	Not applicable	The date the vendor warranty ends for the equipment
29	F S Equipment Master	SLRWARR	string	11	N		The seller warranty code, which represents the warranty your company offers after the vendor warranty expires
30	F S Equipment Master	SLRWSTART	datetime	8	N	Not applicable	The date the seller warranty starts for the equipment
31	F S Equipment Master	SLRWEND	datetime	8	N	Not applicable	The date the seller warranty ends for the equipment
32	F S Equipment Master	NOTETXT	string	2000	N		Notes field
33	F S Equipment Master	SVC_PM_Date	i4	2	N		The month preferred by the customer for when annual preventive maintenance events are to be performed. Valid values are	January; February; March; April; May; June; July; August; September; October; November; December
34	F S Equipment Master	SVC_PM_Day	i4	2	N		The day of the month preferred by the customer for when annual preventive maintenance events are to be performed
35	F S Equipment Master	USERDEF1	string	21	N		User defined 1
36	F S Equipment Master	USERDEF2	string	21	N		User defined 2
37	F S Equipment Master	USRDEF03	string	21	N		User defined 3
38	F S Equipment Master	USRDEF04	string	21	N		User defined 4
39	F S Equipment Master	USRDEF05	string	21	N		User defined 5
40	F S Equipment Master	SVC_Serial_ID	string	21	N		The serial number for the item on the equipment. This field is only available for serial tracked items.
41	F S Equipment Master	SVC_Asset_Tag	string	21	N		The asset tag for the equipment
42	F S Equipment Master	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
43	F S Equipment Master	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S Equipment Reading	SERLNMBR	string	21	Y	Not applicable	Serial number
2	F S Equipment Reading	ITEMNMBR	string	31	Y	Not applicable	Item number
3	F S Equipment Reading	Meters_1	i4	8	N		The current reading for meter 1.
4	F S Equipment Reading	Meters_2	i4	8	N		The current reading for meter 2.
5	F S Equipment Reading	Meters_3	i4	8	N		The current reading for meter 3.
6	F S Equipment Reading	Meters_4	i4	8	N		The current reading for meter 4.
7	F S Equipment Reading	Meters_5	i4	8	N		The current reading for meter 5.
8	F S Equipment Reading	Replaces_1	i4	1	N	0	Flag which indicates that meter 1 has been replaced. Values are	0=False; 1=True
9	F S Equipment Reading	Replaces_2	i4	1	N	0	Flag which indicates that meter 2 has been replaced. Values are	0=False; 1=True
10	F S Equipment Reading	Replaces_3	i4	1	N	0	Flag which indicates that meter 3 has been replaced. Values are	0=False; 1=True
11	F S Equipment Reading	Replaces_4	i4	1	N	0	Flag which indicates that meter 4 has been replaced. Values are	0=False; 1=True
12	F S Equipment Reading	Replaces_5	i4	1	N	0	Flag which indicates that meter 5 has been replaced. Values are	0=False; 1=True
13	F S Equipment Reading	LSTDTEDT	datetime	8	N	Not applicable	The date the equipment reading was last updated.
1	F S R M A Line	Return_Record_Type	i4	2	Y	Not applicable	RMA record type
2	F S R M A Line	RETDOCID	string	15	Y	Not applicable	RMA number The number must include 15 alphanumeric characters. The first three characters of the number must be RMA. For example,RMA0000001234GP.
3	F S R M A Line	LNSEQNBR	number	21	N	0	The sequence number for the line. If not provided on an update a new line will be created.
4	F S R M A Line	RETTYPE	string	11	N	Default from setup	Return Type
5	F S R M A Line	RETSTAT	string	3	N	Default from setup	RMA Status Code
6	F S R M A Line	CUSTNMBR	string	15	Y	Not applicable	Customer number
7	F S R M A Line	ADRSCODE	string	15	Y	Not applicable	Customer address code
8	F S R M A Line	ITEMNMBR	string	31	Y	Not applicable	Item number of item being returned
9	F S R M A Line	ITEMDESC	string	101	N	Not applicable	Description of item being returned
10	F S R M A Line	LOCNCODE	string	11	Y		Return location code
11	F S R M A Line	SVC_Ready_To_Close	i4	1	N	0	Flag to indicate whether the line is ready for closing or not; 0=No, 1=Yes
12	F S R M A Line	SVC_RMA_Reason_Code	string	3	N		RMA Reason code
13	F S R M A Line	NOTETXT	string	2000	N		Notes field
14	F S R M A Line	RETORIG	i4	2	N	1	Return Origin; 1=None, 2=Service Call, 3=SOP
15	F S R M A Line	RETREF	string	31	N		Return reference document number – SOP Invoice or Service Call Number
16	F S R M A Line	EQPLINE	i4	4	N	Not applicable	Equipment sequence line number of the service call line
17	F S R M A Line	LNITMSEQ	i4	4	N	Not applicable	The sequence number for the service call line
18	F S R M A Line	SVC_RMA_From_Service	i4	1	N	Not applicable	Flag to indicate whether RMA was created from Service Call; 0=No, 1=Yes
19	F S R M A Line	CMPNTSEQ	i4	4	N	Not applicable	The component sequence number for the sales invoice line
20	F S R M A Line	SOP_Line_Item_Sequence	i4	4	N	Not applicable	The line sequence number for the sales invoice line
21	F S R M A Line	ENTDTE	datetime	8	N	Not applicable	The date the RMA was entered
22	F S R M A Line	ENTTME	datetime	8	N	Not applicable	The time the RMA was entered
23	F S R M A Line	ETADTE	datetime	8	N	Not applicable	The date the item being returned is expected to arrive
24	F S R M A Line	ETATME	datetime	8	N	Not applicable	The time the item being returned is expected to arrive
25	F S R M A Line	Commit_Date	datetime	8	N	Not applicable	The commit date for the RMA
26	F S R M A Line	Commit_Time	datetime	8	N	Not applicable	The commit time for the RMA
27	F S R M A Line	RETUDATE	datetime	8	N	Not applicable	The date the item being returned was received
28	F S R M A Line	Return_Time	datetime	8	N	Not applicable	The time the item being returned was received
29	F S R M A Line	COMPDTE	datetime	8	N	Not applicable	The date the RMA was closed
30	F S R M A Line	COMPTME	datetime	8	N	Not applicable	The time the RMA was closed
31	F S R M A Line	PRMDATE	datetime	8	N	Not applicable	The promise date for the RMA
32	F S R M A Line	USERID	string	15	N		The user who created the RMA
33	F S R M A Line	OFFID	string	11	N		Office ID responsible for the RMA
34	F S R M A Line	RTRNNAME	string	45	N		Return location name
35	F S R M A Line	RETADDR1	string	61	N		Return address line 1
36	F S R M A Line	RETADDR2	string	61	N		Return address line 2
37	F S R M A Line	RETADDR3	string	61	N		Return address line 2
38	F S R M A Line	RTRNCITY	string	21	N		Return city
39	F S R M A Line	SVC_Return_State	string	29	N		Return state code
40	F S R M A Line	RTRNZIP	string	11	N		Return ZIP Code
41	F S R M A Line	Return_Country	string	61	N		Return country
42	F S R M A Line	CUSTNAME	string	65	N		Customer name
43	F S R M A Line	CONTACT	string	61	N		Customer contact
44	F S R M A Line	ADDRESS1	string	61	N		Customer address line 1
45	F S R M A Line	ADDRESS2	string	61	N		Customer address line 2
46	F S R M A Line	ADDRESS3	string	61	N		Customer address line 2
47	F S R M A Line	CITY	string	35	N		Customer city
48	F S R M A Line	STATE	string	29	N		Customer state code
49	F S R M A Line	ZIPCODE	string	11	N		Customer ZIP Code
50	F S R M A Line	COUNTRY	string	61	N		Customer country
51	F S R M A Line	CSTPONBR	string	21	N		Customer PO number
52	F S R M A Line	QUANTITY	number	21	N	Not applicable	Quantity of item being returned
53	F S R M A Line	UOFM	string	9	N		Unit of measure
54	F S R M A Line	UNITCOST	number	21	N	0	Unit cost of item being returned
55	F S R M A Line	UNITPRCE	number	21	N	0	Unit price of item being returned
56	F S R M A Line	XTNDPRCE	number	21	N	0	Extended price of item being returned
57	F S R M A Line	CUSTOWN	i4	1	N	0	Flag to indicate if item was owned by customer. 0=No, 1=Yes
58	F S R M A Line	FACTSEAL	i4	1	N	0	Flag to indicate if item was factory sealed. 0=No, 1=Yes
59	F S R M A Line	Flat_Rate_Repair_Price	number	21	N	0	Flat rate repair price
60	F S R M A Line	Repair_Price	number	21	N	0	Repair price
61	F S R M A Line	NTE_Price	number	21	N	0	Not to exceed price
62	F S R M A Line	Repair_Cost	number	21	N	0	Repair cost
63	F S R M A Line	Bill_of_Lading	string	31	N		Bill of Lading for shipping out to customer
64	F S R M A Line	SHIPMTHD	string	15	N		Shipping method
65	F S R M A Line	Location_Code_Replacemen	string	11	N		Replacement location code
66	F S R M A Line	Replace_Item_Number	string	31	N		Replacement item number
67	F S R M A Line	Replace_U_Of_M	string	9	N		Replacement unit of measure
68	F S R M A Line	Replace_Price_Level	string	11	N		Replacement price level
69	F S R M A Line	Replace_QTY	number	21	N	0	Replacement quantity
70	F S R M A Line	Replace_Cost	number	21	N	0	Replacement unit cost
71	F S R M A Line	Replace_Price	number	21	N	0	Replacement unit price
72	F S R M A Line	Item_Number_Invoice	string	31	N		Invoice item number
73	F S R M A Line	USERDEF1	string	21	N		User defined 1
74	F S R M A Line	USERDEF2	string	21	N		User defined 2
75	F S R M A Line	USRDEF03	string	21	N		User defined 3
76	F S R M A Line	USRDEF04	string	21	N		User defined 4
77	F S R M A Line	USRDEF05	string	21	N		User defined 5
78	F S R M A Line	CURNCYID	string	15	N		Currency ID
79	F S R M A Line	Return_Item_Number	string	31	N		Item number of item that was returned
80	F S R M A Line	Return_Item_Description	string	51	N		Description of item that was returned
81	F S R M A Line	Return_Location_Code	string	11	N		Location code where item was returned
82	F S R M A Line	Return_QTY	number	21	N	0	Quantity of item that was returned
83	F S R M A Line	Return_U_Of_M	string	8	N		Return unit of measure
84	F S R M A Line	RETCOST	number	21	N	0	Return unit cost
85	F S R M A Line	SVC_Return_Price_Level	string	11	N		Return price level
86	F S R M A Line	SVC_Return_Price	number	21	N	0	Return unit price
87	F S R M A Line	SVC_Extended_Return_Pric	number	21	N	0	Return extended price
88	F S R M A Line	SVC_FO_ID	string	51	N		Front office integration ID
89	F S R M A Line	SVC_SCM_Complete	i4	2	N	0	Flag to indicate whether SCM is complete; 0=False, 1=True
90	F S R M A Line	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
91	F S R M A Line	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S R M A Line Serial	Return_Record_Type	i4	2	Y	Not applicable	RMA record type
2	F S R M A Line Serial	RETDOCID	string	15	Y	Not applicable	RMA number The number must include 15 alphanumeric characters. The first three characters of the number must be RMA. For example,RMA0000001234GP.
3	F S R M A Line Serial	CUSTNMBR	string	15	Y	Not applicable	Customer number
4	F S R M A Line Serial	ADRSCODE	string	15	Y	Not applicable	Customer address code
5	F S R M A Line Serial	LNSEQNBR	number	21	Y	0	The sequence number for the line
6	F S R M A Line Serial	QTYTYPE	i4	2	Y	1	Quantity Type; 1=On Hand; 2=Returned; 3=In Use; 4=In Service; 5=Damaged
7	F S R M A Line Serial	SERLTQTY	number	21	N	1	Serial/Lot Qty, > 0 indicates add/update, < 0 indicates delete if exists
8	F S R M A Line Serial	ITEMNMBR	string	31	Y	Not applicable	Item number of item being returned
9	F S R M A Line Serial	SERLNMBR	string	21	Y	Not applicable	Serial number of item being returned
10	F S R M A Line Serial	LOCNCODE	string	11	Y	Not applicable	The location code for serial numbers used on the RMA line
11	F S R M A Line Serial	SLTSQNUM	i4	4	N	0	Serial sequence number. If not passed in this value defaults to 1 for the first serial number and increments by 1 for each additional serial number tracked for a single parts line. On an update if this value is not provided a new serial line record will be created instead of updating the existing record.
12	F S R M A Line Serial	BIN	string	15	N		Bin number
13	F S R M A Line Serial	SVC_Original_Serial	i4	1	N	Not applicable	Flag to indicate whether its the original IV Serial. 0=No, 1=Yes
14	F S R M A Line Serial	DATERECD	datetime	8	N	Not applicable	Date received
15	F S R M A Line Serial	ReplaceItem	i4	1	N	0	Flag to indicate if the line is for a Replacement Item. 0=No, 1=Yes
16	F S R M A Line Serial	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
17	F S R M A Line Serial	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S R M A Master	Return_Record_Type	i4	2	Y	Not applicable	RMA record type
2	F S R M A Master	RETDOCID	string	15	Y	Not applicable	RMA number The number must include 15 alphanumeric characters. The first three characters of the number must be RMA. For example,RMA0000001234GP.
3	F S R M A Master	RETORIG	i4	2	N	Default from setup	Return Origin; 1=None, 2=Service Call, 3=SOP
4	F S R M A Master	RETREF	string	31	N		Return reference document number – SOP Invoice or Service Call Number
5	F S R M A Master	RETSTAT	string	3	N	Default from setup	RMA Status Code
6	F S R M A Master	RETTYPE	string	15	Y	Default from setup	Return Type
7	F S R M A Master	ENTDTE	datetime	8	N	Not applicable	The date the RMA was entered
8	F S R M A Master	ENTTME	datetime	8	N	Not applicable	The time the RMA was entered
9	F S R M A Master	ETADTE	datetime	8	N	Not applicable	The date the item being returned is expected to arrive
10	F S R M A Master	ETATME	datetime	8	N	Not applicable	The time the item being returned is expected to arrive
11	F S R M A Master	Commit_Date	datetime	8	N	Not applicable	The commit date for the RMA
12	F S R M A Master	Commit_Time	datetime	8	N	Not applicable	The commit time for the RMA
13	F S R M A Master	RETUDATE	datetime	8	N	Not applicable	The date the item being returned was received
14	F S R M A Master	Return_Time	datetime	8	N	Not applicable	The time the item being returned was received
15	F S R M A Master	COMPDTE	datetime	8	N	Not applicable	The date the RMA was closed
16	F S R M A Master	COMPTME	datetime	8	N	Not applicable	The time the RMA was closed
17	F S R M A Master	USERID	string	15	N		The user who created the RMA
18	F S R M A Master	OFFID	string	11	N		Office ID responsible for the RMA
19	F S R M A Master	RTRNNAME	string	45	N		Return location name
20	F S R M A Master	RETADDR1	string	61	N		Return address line 1
21	F S R M A Master	RETADDR2	string	61	N		Return address line 2
22	F S R M A Master	RETADDR3	string	61	N		Return address line 2
23	F S R M A Master	RTRNCITY	string	21	N		Return city
24	F S R M A Master	SVC_Return_State	string	29	N		Return state code
25	F S R M A Master	RTRNZIP	string	11	N		Return ZIP Code
26	F S R M A Master	Return_Country	string	61	N		Return country
27	F S R M A Master	LOCNCODE	string	11	N	Default from setup	Return location code
28	F S R M A Master	CUSTNMBR	string	15	Y	Not applicable	Customer ID
29	F S R M A Master	ADRSCODE	string	15	Y	Not applicable	Customer Address ID
30	F S R M A Master	CUSTNAME	string	65	N		Customer name
31	F S R M A Master	CONTACT	string	61	N		Customer contact
32	F S R M A Master	ADDRESS1	string	61	N		Customer address line 1
33	F S R M A Master	ADDRESS2	string	61	N		Customer address line 2
34	F S R M A Master	ADDRESS3	string	61	N		Customer address line 2
35	F S R M A Master	CITY	string	35	N		Customer city
36	F S R M A Master	STATE	string	29	N		Customer state code
37	F S R M A Master	ZIPCODE	string	11	N		Customer ZIP Code
38	F S R M A Master	COUNTRY	string	61	N		Customer country
39	F S R M A Master	NOTETXT	string	2000	N		Notes field
40	F S R M A Master	Bill_of_Lading	string	31	N		Bill of Lading for shipping out to customer
41	F S R M A Master	SHIPMTHD	string	15	N		Shipping Method
42	F S R M A Master	Bill_To_Customer	string	15	N	Default from setup	Bill To Customer ID
43	F S R M A Master	SVC_Bill_To_Address_Code	string	15	N	Default from setup	Bill To Customer Address ID
44	F S R M A Master	USERDEF1	string	21	N		User defined 1
45	F S R M A Master	USERDEF2	string	21	N		User defined 2
46	F S R M A Master	USRDEF03	string	21	N		User defined 3
47	F S R M A Master	USRDEF04	string	21	N		User defined 4
48	F S R M A Master	USRDEF05	string	21	N		User defined 5
49	F S R M A Master	CURNCYID	string	15	N		Currency ID
50	F S R M A Master	CSTPONBR	string	21	N		Customer PO number
51	F S R M A Master	SVC_RMA_Reason_Code	string	3	N		RMA Reason code
52	F S R M A Master	SVC_RMA_From_Service	i4	1	N	Not applicable	Flag to indicate whether RMA was created from Service Call; 0=No, 1=Yes
53	F S R M A Master	SVC_FO_ID	string	51	N		Front office integration ID
54	F S R M A Master	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
55	F S R M A Master	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S R T V Line	RTV_Number	string	15	Y	Not applicable	RTV number
2	F S R T V Line	RTV_Line	number	21	N	Not applicable	The sequence number for the line
3	F S R T V Line	RTV_Type	string	11	N	Default from setup	RTV Type
4	F S R T V Line	VRMA_Document_ID	string	15	N		Vendor’s RMA Document Number
5	F S R T V Line	RETDOCID	string	15	N	Not applicable	Customer’s RMA Number
6	F S R T V Line	LNSEQNBR	number	21	N		RMA line sequence number
7	F S R T V Line	SVC_Process_SEQ_	number	21	N		RMA process sequence number
8	F S R T V Line	DSCRIPTN	string	31	N		RTV description
9	F S R T V Line	REFRENCE	string	31	N		Reference information
10	F S R T V Line	Reference2	string	31	N		Additional reference information
11	F S R T V Line	ITEMNMBR	string	31	Y	Not applicable	Item number being returned
12	F S R T V Line	ITEMDESC	string	101	N	Not applicable	Item description
13	F S R T V Line	QUANTITY	number	21	N	0	Quantity of item being returned
14	F S R T V Line	UOFM	string	9	Y		Unit of measure
15	F S R T V Line	VENDORID	string	15	Y	Not applicable	Vendor ID
16	F S R T V Line	ADRSCODE	string	15	Y	Not applicable	Vendor Address ID
17	F S R T V Line	Ship_Address_Name	string	65	N		Name of Contact Person for Vendor’s Ship To Address
18	F S R T V Line	Ship_Address_1	string	61	N		Ship to address line 1
19	F S R T V Line	Ship_Address_2	string	61	N		Ship to address line 2
20	F S R T V Line	Ship_Address_3	string	61	N		Ship to address line 3
21	F S R T V Line	Ship_City	string	35	N		City name of vendor’s ship to address
22	F S R T V Line	Ship_State	string	29	N		State of vendor’s ship to address
23	F S R T V Line	ZIPCODE	string	11	N		Zip Code of vendor’s ship to address
24	F S R T V Line	Ship_Country	string	61	N		Country name of vendor’s ship to address
25	F S R T V Line	VNDITNUM	string	31	N		Vendor’s Item Number
26	F S R T V Line	Return_Item_Number	string	31	N		Item Number being returned
27	F S R T V Line	OFFID	string	11	N		Office ID responsible for RTV
28	F S R T V Line	LOCCODEB	string	11	N		Location Code from where item was shipped to vendor
29	F S R T V Line	LOCNCODE	string	11	N		Location Code from where item will be received
30	F S R T V Line	ENTDTE	datetime	8	N	Not applicable	The date the RTV line was entered
31	F S R T V Line	ENTTME	datetime	8	N	Not applicable	The time the RTV line was entered
32	F S R T V Line	PRMDATE	datetime	8	N	Not applicable	The date the RTV line was promised
33	F S R T V Line	Promised_Time	datetime	8	N	Not applicable	The time the RTV line was promised
34	F S R T V Line	Shipped_Date	datetime	8	N	Not applicable	The date the RTV line was shipped
35	F S R T V Line	Shipped_Time	datetime	8	N	Not applicable	The time the RTV line was shipped
36	F S R T V Line	Receiptdate	datetime	8	N	Not applicable	The date the RTV line was received
37	F S R T V Line	Receipt_Time	datetime	8	N	Not applicable	The time the RTV line was received
38	F S R T V Line	COMPDTE	datetime	8	N	Not applicable	The date the RTV line was closed
39	F S R T V Line	COMPTME	datetime	8	N	Not applicable	The time the RTV line was closed
40	F S R T V Line	Bill_of_Lading_Out	string	31	N		Bill of Lading number for shipment to vendor
41	F S R T V Line	Shipping_Method_Out	string	15	N		Shipping method for shipment to vendor
42	F S R T V Line	Bill_of_Lading	string	31	N		Bill of Lading number for returning
43	F S R T V Line	SHIPMTHD	string	15	N		Shipment method for returning
44	F S R T V Line	Tracking_Number	string	41	N		Shipment tracking number
45	F S R T V Line	NOTETXT	string	2000	N		Notes field
46	F S R T V Line	CUSTOWN	i4	1	N	Default from setup	Flag to indicate whether item was owned by customer; 0=No, 1=Yes
47	F S R T V Line	USERDEF1	string	21	N		User defined 1
48	F S R T V Line	USERDEF2	string	21	N		User defined 2
49	F S R T V Line	USRDEF03	string	21	N		User defined 3
50	F S R T V Line	USRDEF04	string	21	N		User defined 4
51	F S R T V Line	USRDEF05	string	21	N		User defined 5
52	F S R T V Line	CURNCYID	string	15	Y		Currency ID
53	F S R T V Line	Part_Price	number	21	N	0	Unit price
54	F S R T V Line	Part_Cost	number	21	N	0	Unit cost
55	F S R T V Line	Labor_Price	number	21	N	0	Labor price involved in fulfilling RTV
56	F S R T V Line	Labor_Cost	number	21	N	0	Labor cost involved in fulfilling RTV
57	F S R T V Line	Expense_Price	number	21	N	0	Expense price involved in fulfilling RTV
58	F S R T V Line	Expense_Cost	number	21	N	0	Expense cost involved in fulfilling RTV
59	F S R T V Line	Travel_Price	number	21	N	0	Travel price involved in fulfilling RTV
60	F S R T V Line	Travel_Cost	number	21	N	0	Travel cost involved in fulfilling RTV
61	F S R T V Line	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
62	F S R T V Line	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S R T V Line Serial	RTV_Number	string	15	Y	Not applicable	RTV number
2	F S R T V Line Serial	RTV_Line	number	21	N	Not applicable	The sequence number for the line
3	F S R T V Line Serial	VENDORID	string	15	Y	Not applicable	Vendor ID
4	F S R T V Line Serial	ADRSCODE	string	15	Y	Not applicable	Vendor address code
5	F S R T V Line Serial	QTYTYPE	i4	2	Y	Not applicable	Quantity Type; 1=On Hand; 2=Returned; 3=In Use; 4=In Service; 5=Damaged
6	F S R T V Line Serial	SERLTQTY	number	21	N	1	Serial/Lot Qty, > 0 indicates add/update, < 0 indicates delete if exists
7	F S R T V Line Serial	SLTSQNUM	i4	4	N	o	Serial sequence number. If not passed in this value defaults to 1 for the first serial number and increments by 1 for each additional serial number tracked for a single parts line. On an update if this value is not provided a new serial line record will be created instead of updating the existing record.
8	F S R T V Line Serial	InOrOut	i4	2	N	1	Flag which indicates whether it’s an incoming item (from vendor) or an outgoing (to vendor) item. Values	1=Sent/Out, 2=Received/In
9	F S R T V Line Serial	ITEMNMBR	string	31	Y	Not applicable	Item number of item being returned
10	F S R T V Line Serial	SERLNMBR	string	21	N	Not applicable	Serial number of item being returned
11	F S R T V Line Serial	LOCNCODE	string	11	Y	Not applicable	The location code for serial numbers used on the RMA line
12	F S R T V Line Serial	BIN	string	15	N		Bin number
13	F S R T V Line Serial	SVC_Original_Serial	i4	1	N	Not applicable	Flag to indicate whether its the original IV Serial. 0=No, 1=Yes
14	F S R T V Line Serial	DATERECD	datetime	8	N	Not applicable	Date received
15	F S R T V Line Serial	Shipped	i4	1	N	Not applicable	Flag to indicate if the serial has been shipped. 0=No, 1=Yes
16	F S R T V Line Serial	CREATEEQUIPMENT	i4	1	N	0	Flag to create equipment record if none exists for the serial number. 0=No, 1=Yes
17	F S R T V Line Serial	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
18	F S R T V Line Serial	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S R T V Master	RTV_Number	string	15	Y	Not applicable	RTV number
2	F S R T V Master	RTV_Type	string	11	Y	Default from setup	RTV Type
3	F S R T V Master	RTV_Return_Status	string	3	N	Default from setup	RTV Status
4	F S R T V Master	VRMA_Document_ID	string	15	N		Vendor’s RMA Document Number
5	F S R T V Master	RETDOCID	string	15	N		Customer’s RMA Number
6	F S R T V Master	DSCRIPTN	string	31	N		RTV description
7	F S R T V Master	VENDORID	string	15	Y	Not applicable	Vendor ID
8	F S R T V Master	VENDNAME	string	65	N		Vendor name
9	F S R T V Master	CKHOLD	i4	2	N	0	A flag to determine whether the vendor's hold status is checked when the document is created. 0=Do not check; 1=check
10	F S R T V Master	ADRSCODE	string	15	Y	Not applicable	Vendor Address ID
11	F S R T V Master	Ship_Address_Name	string	65	N		Name of Contact Person for Vendor’s Ship To Address
12	F S R T V Master	Ship_Address_1	string	61	N		Ship to address line 1
13	F S R T V Master	Ship_Address_2	string	61	N		Ship to address line 2
14	F S R T V Master	Ship_Address_3	string	61	N		Ship to address line 3
15	F S R T V Master	Ship_City	string	35	N		City name of vendor’s ship to address
16	F S R T V Master	Ship_State	string	29	N		State of vendor’s ship to address
17	F S R T V Master	ZIPCODE	string	11	N		Zip Code of vendor’s ship to address
18	F S R T V Master	Ship_Country	string	61	N		Country name of vendor’s ship to address
19	F S R T V Master	ENTDTE	datetime	8	N	Not applicable	The date the RTV was entered
20	F S R T V Master	ENTTME	datetime	8	N	Not applicable	The time the RTV was entered
21	F S R T V Master	LOCCODEB	string	11	N		Location Code from where item was shipped to vendor
22	F S R T V Master	LOCNCODE	string	11	N		Location Code from where item will be received
23	F S R T V Master	Bill_of_Lading_Out	string	31	N		Bill of Lading number for shipment to vendor
24	F S R T V Master	Shipping_Method_Out	string	15	N		Shipping method for shipment to vendor
25	F S R T V Master	Bill_of_Lading	string	31	N		Bill of Lading number for returning
26	F S R T V Master	SHIPMTHD	string	15	N		Shipment method for returning
27	F S R T V Master	OFFID	string	11	N		Office ID responsible for RTV
28	F S R T V Master	NOTETXT	string	2000	N		Notes field
29	F S R T V Master	USERID	string	15	N		User who created the Return To Vendor
30	F S R T V Master	USERDEF1	string	21	N		User defined 1
31	F S R T V Master	USERDEF2	string	21	N		User defined 2
32	F S R T V Master	USRDEF03	string	21	N		User defined 3
33	F S R T V Master	USRDEF04	string	21	N		User defined 4
34	F S R T V Master	USRDEF05	string	21	N		User defined 5
35	F S R T V Master	CURNCYID	string	15	Y		Currency ID
36	F S R T V Master	UpdateIfExists	i4	1	N	1	Flag to allow data to be updated if it exists	0=Do not update; 1=Update
37	F S R T V Master	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S Service Call Codes Equipment	SRVRECTYPE	i4	2	Y	Not applicable	Service record type	1=Quote; 2=Open
2	F S Service Call Codes Equipment	CALLNBR	string	11	Y	Not applicable	Call number
3	F S Service Call Codes Equipment	ITEMNMBR	string	31	N		Item number
4	F S Service Call Codes Equipment	SERLNMBR	string	21	N		Serial number
5	F S Service Call Codes Equipment	CUSTNMBR	string	15	N		Customer number
6	F S Service Call Codes Equipment	PROBCDE	string	11	N		Problem code
7	F S Service Call Codes Equipment	CAUSECDE	string	11	N		Cause code
8	F S Service Call Codes Equipment	RPRCODE	string	11	N		Repair code
9	F S Service Call Codes Equipment	PMPERF	i4	1	N	0	PM performed
10	F S Service Call Codes Equipment	UpdateIfExists	i4	1	N	1	Flag to allow customer data to be updated if it exists	0=No; 1=Yes
11	F S Service Call Codes Equipment	RequesterTrx	i4	2	N	0	Requester transaction	0=False; 1=True (if True, it populates the requester shadow table)
1	F S Service Call Line	SRVRECTYPE	i4	2	Y	Not applicable	Service record type
2	F S Service Call Line	CALLNBR	string	11	Y	Not applicable	Service call number
3	F S Service Call Line	EQPLINE	i4	4	N	1	The Equipment Sequence Number. If not provided on an update the default will be 1.
4	F S Service Call Line	LNITMSEQ	i4	4	N	0	The sequence number for the line. If not provided on an update a new service call line record will be created.
5	F S Service Call Line	LINITMTYP	string	3	Y	P	Indicates the type of service call line. Options are	A=Additional Charge; E=Expense; L=Labor; P=Parts. If not provided the default will be P for parts.
6	F S Service Call Line	SRVSTAT	string	3	N	Not applicable	The status of the service call line; Only valid for line type = L (Labor) or P (Parts).
7	F S Service Call Line	TECHID	string	11	N	Not applicable	The technician of the service call line; Only valid for line type = L (Labor) or P (Parts).
8	F S Service Call Line	CUSTNMBR	string	15	Y	Not applicable	Customer number
9	F S Service Call Line	ADRSCODE	string	15	Y	Not applicable	Customer address code
10	F S Service Call Line	ITEMNMBR	string	31	Y	Not applicable	Item number If multiple bins is enabled, inventory setup is not supported.
11	F S Service Call Line	CKNORETURNS	i4	1	N	0	Flag used to indicate not to create returnable line for items that are set as returnable; 0=False; 1=True
12	F S Service Call Line	ITEMDESC	string	101	N	Not applicable	Item description
13	F S Service Call Line	LOCNCODE	string	11	Y	Not applicable	The location code for parts used on the service call line
14	F S Service Call Line	UOFM	string	9	N		Unit of measure
15	F S Service Call Line	QTYORDER	number	21	N	0	The amount of labor or quantity of parts required for the service call line. Only valid for line type = L (Labor) or P (Parts).
16	F S Service Call Line	ATYALLOC	number	21	N	0	The quantity of the parts line that is allocated in Inventory. Only valid for line type = P (Parts) and will be unallocated when the part is used.
17	F S Service Call Line	QTYBACKO	number	21	N	0	The quantity of the parts line that is backordered. Only valid for line type = P (Parts) and will be reduced as the backorder is filled by an Inventory transfer or receipt of a purchase order.
18	F S Service Call Line	QTYSOLD	number	21	N	0	The quantity of the line that was actually used. This is the value that will be transferred to the invoice during the service call billing process. You will have to manually post the inventory adjustment transaction that is created.
19	F S Service Call Line	UNITCOST	number	21	N	0	The cost per unit of measure for the current detailed entry. This cost will typically default from the Inventory current cost for most items, but can be modified for additional charge and expense lines.
20	F S Service Call Line	UNITPRCE	number	21	N	0	The price per unit of measure for the service call line
21	F S Service Call Line	XTNDPRCE	number	21	N	0	The extended price of the line, which is the unit price times the quantity sold. This value may also be affected by the applicable billing percentage for parts, labor or miscellaneous lines.
22	F S Service Call Line	NOTETXT	string	3000	N		Notes field
23	F S Service Call Line	STRTDATE	datetime	8	N	Not applicable	Only valid for line type = L (Labor) and contains the date on which the labor line started.
24	F S Service Call Line	STRTTIME	datetime	8	N	Not applicable	Only valid for line type = L (Labor) and contains the time on which the labor line started.
25	F S Service Call Line	ENDDATE	datetime	8	N	Not applicable	Only valid for line type = L (Labor) and contains the date on which the labor line ended.
26	F S Service Call Line	ENDTME	datetime	8	N	Not applicable	Only valid for line type = L (Labor) and contains the time on which the labor line ended.
27	F S Service Call Line	TRANSTME	number	11	N	0	The actual time for a labor line and is only valid for line type = L (Labor). Values should be in portions of an hour. For example, a half hour would be 00030, while one hour would be 00100
28	F S Service Call Line	BILLABLTIM	number	11	N	0	The amount of time that should be billed for a labor line and is only valid for line type = L (Labor).This value may vary from the transaction time field based on rounding or minimum labor settings. Values should be in portions of an hour. For example, a half hour would be 00030, while one hour would be 00100
29	F S Service Call Line	ENTDTE	datetime	8	N	Not applicable	Entry Date
30	F S Service Call Line	ENTTME	datetime	8	N	Not applicable	Entry Time
31	F S Service Call Line	LABPCT	number	21	N	Default from setup	The percent of the line that is billable to the customer. This value is only used in calculations for records where line type = L (Labor). The value will default from any contract or warranty attached to the current contract, otherwise it will default to 100
32	F S Service Call Line	PARTPCT	number	21	N	Default from setup	The percent of the line that is billable to the customer. This value is only used in calculations for records where line type = P (Parts). The value will default from any contract or warranty attached to the current contract, otherwise it will default to 100
33	F S Service Call Line	MISCPCT	number	21	N	Default from setup	The percent of the line that is billable to the customer. This value is only used in calculations for records where line type = A (Additional Charge) or E (Expense). The value will default from any contract or warranty attached to the current contract, otherwise it will default to 100
34	F S Service Call Line	CKCREATEPO	i4	2	N	0	Flag used to indicate if a PO for a parts line should be created; 0=False; 1=True
35	F S Service Call Line	VENDORID	string	15	N	Not applicable	Vendor number
36	F S Service Call Line	PRMDATE	datetime	8	N	Not applicable	Promised Date

Control Desk

Features

GP Admin

Templates

TGP+

Tools

General Field Info and Restrictions