Excel Sheet Download 6110 | Standard Accounting Extract Expense

Partial file snippet.
Sheet 1: Instructions

	
	
		There are three main worksheets in the Excel Workbook_ Comparison file.
1) The worsheet titled 'Header_Data' lists the fields in the File Header.
2) The worksheet titled 'File_Data' lists the fields in the Details Section.
3) The worksheet titled 'Cash Advance' lists the fields in the FI file of the Cash Advance Section.

Details in the Header_Data worksheet.
Sno: Displays the row number of the field in the worksheet
Col[SAE]: Displays the column number of the SAE field in the database.
FieldName: Displays the name of the field
SectionName [SAE]: Displays the section name of the SAE field
Description/Data Type/Format/Source [SAE]: Displays the description and/or data type and/or format and/or source of the field in the SAE file
Length [SAE]: Displays the length allocated to the SAE field.
SAE: Displays an 'X'  if a field is present in the SAE file
FI: Displays an 'X'  if a field is present in the FI file
Comments: Displays the equivalent name for a field in the FI file. Else, it is left blank.

Details in the File_Data worksheet.
Sno: Displays the row number of the field in the worksheet
Col[SAE]: Displays the column number of the SAE field in the database.
FieldName: Displays the name of the field
SectionName [SAE]: Displays the section name of the SAE field
Length[SAE]: Displays the length allocated to the SAE field.
Description/Data Type/Format/Source [SAE]: Displays the description and/or data type and/or format and/or source of the field in the SAE file
SAE: Displays an 'X'  if a field is present in the SAE file
FI: Displays an 'X'  if a field is present in the FI file
Comments: Displays the equivalent name for a field in the FI file, or an additional note. Else, it is left blank.
SectionName[FI]:  Displays the section name of the FI field
Description/Data Type/Format/Source [FI]: Displays the description and/or data type and/or format and/or source of the field in the FI file
Length[FI]: Displays the length allocated to the FI field.

Details in the Cash Advance worksheet.
Sno: Displays the row number of the field in the worksheet
FieldName: Displays the name of the field in the Cash Advance Schema
Description/Data Type/Format/Source [FI]: Displays the description and/or data type and/or format and/or source of the field in the Cash Advance section of the FI file
SectionName[FI]:  Displays the section name of the Cash Advance field
Length [FI]: Displays the length allocated to the FI field.



		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		



Sheet 2: Header_Data

	
	
	
	
	
	
	
		Sno
		Col# [SAE]
		Field Name
		SectionName [SAE]
		Description/Data Type/Format/Source [SAE]
		Length [SAE]
		SAE
		FI
		Comments
	
	
		1
		1
		Constant
		File Header Section
		The value "EXTRACT" will be inserted into the first position of the extract. By having a constant in the file header, an extract file is always produced, even if there are no reports ready to be extracted.
Data type: Alphanumeric
		7
		x
		

		

	
	
		2
		2
		Batch_Date
		File Header Section
		Batch Date
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

	
	
		3
		3
		Record_Count
		File Header Section
		Count of the detail records in the file
Data type: Numeric
Source: Calculated when file is created
		10
		x
		

		

	
	
		4
		4
		Journal Amount Total
		File Header Section
		Total that sums all journal amount columns in the journal rows
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
Source: Calculated when file is created
		23
		x
		

		

	
	
		5
		5
		Batch ID
		File Header Section
		Batch ID
Data type: Numeric
Format: Starts with number 1 and increments sequentially
		13
		x
		

		

	



Sheet 3: File_Data

	
	
	
	
	
	
	
	
	
	
	
	
	
		Sno
		Col# [SAE]
		Field Name
		SectionName [SAE]
		Description/Data Type/Format/Source [SAE]
		Length [SAE]
		SAE
		FI
		Comments
		SectionName [FI]
		Description/Data Type/Format/Source [FI]
		Length [FI]
	
	
		1
		1
		Constant
		Batch Data Section
		The value "DETAIL" will be inserted into the first position of the extract
Data type: Alphanumeric
		6
		x
		

		

		

		

		

	
	
		2
		2
		Batch ID
		Batch Data Section
		Batch ID
Data type: Numeric
Format: Starts with number 1 and increments sequentially
		13
		x
		

		

		

		

		

	
	
		3
		3
		Batch Date
		Batch Data Section
		Batch Date
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

		

		

		

	
	
		4
		4
		Sequence Number
		Batch Data Section
		Line number of each detail row
Data type: Numeric
Source: Calculated when file is created
		n/a
		x
		

		

		

		

		

	
	
		5
		5
		Employee ID
		Employee Data Section
		Employee ID
Data type: Alphanumeric
Format: Employee ID often also serves as a vendor ID for AP systems or Payroll ID for Payroll integrations.
		48
		x
		x
		FI equivalent is employeeId
		Expense - Employee Section
		Employee ID often also serves as the employee’s Vendor ID for AP system integrations or payroll ID for payroll integrations. 
Data Type: Alphanumeric.
		128
	
	
		6
		6
		Employee Last Name
		Employee Data Section
		Employee last name
Data type: Alphanumeric
		32
		x
		x
		FI equivalent is employeeLastName
		Expense - Employee Section
		Last name of employee.
Data Type: Alphanumeric.
		32
	
	
		7
		7
		Employee First Name
		Employee Data Section
		Employee first name
Data type: Alphanumeric
		32
		x
		x
		FI equivalent is employeeFirstName
		Expense - Employee Section
		First name of employee.
Data Type: Alphanumeric.
		32
	
	
		8
		8
		Middle Initial
		Employee Data Section
		Employee middle initial
Data type: Alphanumeric
		1
		x
		x
		FI equivalent is employeeMI
		Expense - Employee Section
		Middle initial of employee. 
Data Type: Alphanumeric.
		1
	
	
		9
		9
		Employee Group ID (Custom 21)
		Employee Data Section
		Employee group ID
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom21Code and employeeCustom21Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		10
		10
		Employee Org Unit 1
		Employee Data Section
		Employee Organization Unit Custom Value 1
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeOrgUnit1Code and employeeOrgUnit1Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		11
		11
		Employee Org Unit 2
		Employee Data Section
		Employee Organization Unit Custom Value 2
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeOrgUnit2Code and employeeOrgUnit2Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		12
		12
		Employee Org Unit 3
		Employee Data Section
		Employee Organization Unit Custom Value 3
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeOrgUnit3Code and employeeOrgUnit3Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		13
		13
		Employee Org Unit 4
		Employee Data Section
		Employee Organization Unit Custom Value 4
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeOrgUnit4code and employeeOrgUnit4Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		14
		14
		Employee Org Unit 5
		Employee Data Section
		Employee Organization Unit Custom Value 5
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeOrgUnit5Code and employeeOrgUnit5Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		15
		15
		Employee Org Unit 6
		Employee Data Section
		Employee Organization Unit Custom Value 6
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeOrgUnit6Code and employeeOrgUnit6Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		16
		16
		ACH Bank Account Number
		Employee Data Section
		RESERVED for bank account number for electronic funds transfer
Data type: Alphanumeric
NOTE: For security purposes, this information will not be included unless specifically requested. This value is generally only visible to the employee in their profile. It may be populated by the employee directly into their profile or via employee import.
		100
		x
		

		

		

		

		

	
	
		17
		17
		ACH Bank Routing Number
		Employee Data Section
		RESERVED for bank routing number for electronic funds transfer 
Data type: Alphanumeric
NOTE: For security purposes, this information will not be included unless specifically requested. This value is generally only visible to the employee in their profile. It may be populated by the employee directly into their profile or via employee import.
		100
		x
		

		

		

		

		

	
	
		18
		18
		Journal Net of Total Adjusted Reclaim Tax
		Employee Data Section
		This is the Gross Journal amount subtracting reclaimable tax. Or the Net Journal amount adding non-reclaimable tax. 
NOTE: Calculated at the time the field is generated.
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is amountNetofReclaim
		Expense - Journal Section
		Gross Journal amount subtracting reclaimable tax. Or the Net Journal amount adding non-reclaimable tax.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		19
		19
		Report ID
		Report Data Section
		Report ID
32 character varchar -refer to Report Key (below) if a smaller numeric unique identifier is required.
Data type: Alphanumeric
Format: Guaranteed to be unique. Often used as a voucher number when integrating to AP systems.
		32
		x
		x
		FI equivalent is reportId
		Expense - Report Section
		Unique (across all SAP Concur clients).
Data Type: Alphanumeric.
		32
	
	
		20
		20
		Report Key
		Report Data Section
		Report key on the report - unique id generated by the system
Data type: Numeric
Format: Alternative to the report ID. Smaller value. Starts with 1 and increments with each expense report
		48
		x
		x
		FI equivalent is reportKey
		Expense - Report Section
		A unique ID (within a single SAP Concur client’s company) generated by the system. An alternative to the reportId. Starts with 1 and increments with each expense report. 
Data Type: Number
		11
	
	
		21
		21
		Ledger
		Report Data Section
		External accounting system ID
Data type: Alphanumeric
		20
		x
		x
		FI equivalent is ledgerCode
		Expense - Report Section
		External accounting system ID.
Data Type: Alphanumeric.
		20
	
	
		22
		22
		Employee Default Currency Alpha Code
		Report Data Section
		Reimbursement currency in ISO alpha format
Data type: Alphanumeric
Format: 3-character alpha code
		3
		x
		x
		FI equivalent is employeeCurrencyAlphaCode
		Expense - Report Section
		Reimbursement currency.
Data Type: Alphanumeric
Format: 3-letter ISO 4217 alpha code.
		3
	
	
		23
		23
		Report Home Country Name
		Report Data Section
		Home country name (localized for ledgerlanguage) for this employee
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is homeCountryCode
		Expense - Report Section
		The report country. Example: United States is US.
Data Type: Alphanumeric
Format: ISO 3166-1 alpha-2 country code.
		2
	
	
		24
		24
		Report Submit Date
		Report Data Section
		Date/Time the employee submitted the report for approval
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is reportSubmitDate
		Expense - Report Section
		Date/time the employee submitted the report for approval. 
Data Type: Alphanumeric

		24
	
	
		25
		25
		Report User Defined Date
		Report Data Section
		Custom date/time specified by user
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is reportUserDefinedDate
		Expense - Report Section
		Custom date/time specified by user.
Data Type: Alphanumeric

		24
	
	
		26
		26
		Report Payment Processing Date
		Report Data Section
		The date that the report completed all approvals and was ready to be extracted for payment
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is reportPaymentProcessingDate
		Expense - Report Section
		The date that the report completed all approvals and was ready to be extracted for payment.
Data Type: Alphanumeric
Format: yyyy-mm-ddThr:min:sec.msZ
		24
	
	
		27
		27
		Report Name
		Report Data Section
		Report name assigned by employee
Data type: Alphanumeric
		40
		x
		x
		FI equivalent is reportName
		Expense - Report Section
		 Report name assigned by employee. 
Data Type: Alphanumeric
		40
	
	
		28
		28
		Report Image Required
		Report Data Section
		If Y, then this report met the criteria to require an image to be sent.
Data type: Alphanumeric
Format: Y/N
		1
		x
		

		

		

		

		

	
	
		29
		29
		Report has VAT entry
		Report Data Section
		If Y, then this report has at least one expense with VAT data
Data type: Alphanumeric
Format: Y/N
		1
		x
		

		

		

		

		

	
	
		30
		30
		Report has TA entry
		Report Data Section
		If Y, then this report has at least one expense with travel allowance data
Data type: Alphanumeric
Format: Y/N
		1
		x
		

		

		

		

		

	
	
		31
		31
		Report Total Posted Amount
		Report Data Section
		Report Total Posted amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		32
		32
		Report Total Approved Amount
		Report Data Section
		Report Total Approved amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is totalApprovedAmount
		Expense - Report Section
		Total approved amount of the report.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		33
		

		versionId
		

		

		

		

		x
		

		Expense - Report Section
		The version of the FI Document, which is the same as the version of the API endpoint.
Data Type: Number

		32
	
	
		34
		33
		Report Policy Name
		Report Data Section
		Report Policy Name
Data type: Alphanumeric
		64
		x
		

		

		

		

		

	
	
		35
		34
		Report Entry Budget Accrual Date
		Report Data Section
		NOTE: Exposed to clients who have purchased Budget.
The date entered by the Budget Approver on the entry. This may or may not be different than the transaction date.
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

		

		

		

	
	
		36
		35
		Report Org Unit 1
		Report Data Section
		Organizational data for this employee. This data is copied from the CT_EMPLOYEE Org Unit Fields. Data is recorded at the report level in case an employee organizational data changes over time, such as a transfer to a different business unit.
Data type: Custom field; client defined
Format: The first segment in the fully qualified GL string should use Org Unit 1.
		48
		x
		x
		FI equivalent is reportOrgUnit1Code and reportOrgUnit1Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		37
		36
		Report Org Unit 2
		Report Data Section
		Data type: Custom field; client defined
Format: The second segment in the fully qualified GL string should use Org Unit 2, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		FI equivalent is reportOrgUnit2Code and reportOrgUnit2Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		38
		37
		Report Org Unit 3
		Report Data Section
		Data type: Custom field; client defined
Format: The third segment (if necessary) in the fully qualified GL string should use Org Unit 3, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		FI equivalent is reportOrgUnit3Code and reportOrgUnit3Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		39
		38
		Report Org Unit 4
		Report Data Section
		Data type: Custom field; client defined
Format: The fourth segment (if necessary) in the fully qualified GL string should use Org Unit 4, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		FI equivalent is reportOrgUnit4Code and reportOrgUnit4Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		40
		39
		Report Org Unit 5
		Report Data Section
		Data type: Custom field; client defined
Format: The fifth segment (if necessary) in the fully qualified GL string should use Org Unit 5, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		FI equivalent is reportOrgUnit5Code and reportOrgUnit5Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		41
		40
		Report Org Unit 6
		Report Data Section
		Data type: Custom field; client defined
Format: The sixth segment (if necessary) in the fully qualified GL string should use Org Unit 6, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		FI equivalent is reportOrgUnit6Code and reportOrgUnit6Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		42
		41
		Report Custom 1
		Report Data Section
		When the custom fields are also employed on the employee record for accounting data, these fields are copied to the report level. Data is recorded at the report level for reporting purposes. In the event an
employee's organizational data changes over time. This ensures that the point in time accounting data for an expense report is accurate and not changed in the future if employee data is changed.
Data type: Custom field; client defined 
Format: The seventh segment (if necessary) in the fully qualified GL string should use Custom1, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		Fi equivalent is reportCustom1Code and reportCustom1Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		43
		42
		Report Custom 2
		Report Data Section
		Data type: Custom field; client defined
Format: The eight segment (if necessary) in the fully qualified GL string should use Custom2, except the natural account field; the natural account data is stored in column 167
		48
		x
		x
		Fi equivalent is reportCustom2Code and reportCustom2Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		44
		43
		Report Custom 3
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom3Code and reportCustom3Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		45
		44
		Report Custom 4
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom4Code and reportCustom4Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		46
		45
		Report Custom 5
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom5Code and reportCustom5Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		47
		46
		Report Custom 6
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom6Code and reportCustom6Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		48
		47
		Report Custom 7
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom7Code and reportCustom7Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		49
		48
		Report Custom 8
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom8Code and reportCustom8Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		50
		49
		Report Custom 9
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom9Code and reportCustom9Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		51
		50
		Report Custom 10
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom10Code and reportCustom10Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		52
		51
		Report Custom 11
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom11Code and reportCustom11Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		53
		52
		Report Custom 12
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom12Code and reportCustom12Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		54
		53
		Report Custom 13
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom13Code and reportCustom13Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		55
		54
		Report Custom 14
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom14Code and reportCustom14Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		56
		55
		Report Custom 15
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom15Code and reportCustom15Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		57
		56
		Report Custom 16
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom16Code and reportCustom16Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		58
		57
		Report Custom 17
		Report Data Section
		(CES Standard - Copy of AP Vendor ID)
Data type: Custom field; client defined
Format: Copies down from Employee Custom17. Used in cases when Employee ID is not used as the AP Vendor ID.
		48
		x
		x
		Fi equivalent is reportCustom17Code and reportCustom17Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		59
		58
		Report Custom 18
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom18Code and reportCustom18Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		60
		59
		Report Custom 19
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom19Code and reportCustom19Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		61
		60
		Report Custom 20
		Report Data Section
		Data type: Custom field; client defined
Value copied down from Employee Custom field of the corresponding number.
		48
		x
		x
		Fi equivalent is reportCustom20Code and reportCustom20Value
		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		62
		61
		Report Entry Id
		Report Entry Data Section
		Report entry unique key
Data type: Numeric
		13
		x
		x
		FI equivalent is entryId
		Expense - expenseEntry Section
		Report entry sync GUUID unique key.
Data Type: Alphanumeric

		32
	
	
		63
		62
		Report Entry Transaction Type
		Report Entry Data Section
		Indicates the type of expense entry:
->REG = Regular, non-itemized or allocated entry
->CHD = Child entry for itemization or allocation
Parent entries (the top-level itemized or allocated entry that includes child entries) are not included.
Data type: Alphanumeric
		3
		x
		

		

		

		

		

	
	
		64
		63
		Report Entry Expense Type Name
		Report Entry Data Section
		Expense type name
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is expenseTypeName
		Expense - expenseEntry Section
		Expense Type Name
Data Type: Alphanumeric

		64
	
	
		65
		64
		Report Entry Transaction Date
		Report Entry Data Section
		Date that this expense was incurred (when the money was spent or credit card receipt date)
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is entryDate
		Expense - expenseEntry Section
		Date that this expense was incurred (when the money was spent or credit card receipt date).
Data Type: Alphanumeric
		

	
	
		66
		65
		Report Entry Currency Alpha Code
		Report Entry Data Section
		Currency ISO alpha code for the spend currency if not an imported credit card or the invoice currency if this is a credit card
Data type: Alphanumeric
Format: 3-character alpha code
		3
		x
		x
		FI equivalent is entryCurrAlphaCode
		Expense - expenseEntry Section
		Currency ISO alpha code for the spend currency if not an imported credit card or the invoice currency if this is a credit card. 
Data Type: Alphanumeric
Format: ISO 4217 3-letter alpha code.
		4
	
	
		67
		66
		Report Entry Exchange Rate
		Report Entry Data Section
		Rate used to convert from the report entry (spend) currency to the report (reimbursement) currency
Data type: Numeric
		23
		x
		x
		FI equivalent is entryExchangeRate
		Expense - expenseEntry Section
		Rate used to convert from the report entry (spend) currency to the report (reimbursement) currency.
Data Type: Number

		23
	
	
		68
		67
		Report Entry Exchange Rate Direction
		Report Entry Data Section
		Either:
-> M = Multiply
-> D = Divide
Data type: Alphanumeric
		1
		x
		x
		FI equivalent is entryExchangeRateDirection
		Expense - expenseEntry Section
		The direction of the exchange rate conversion. 
Data Type: Alphanumeric
Format: M/D Either: M = Multiply or D = Divide.
		1
	
	
		69
		68
		Report Entry Is Personal Flag
		Report Entry Data Section
		Flag to indicate if this expense line is a personal amount
Data type: Alphanumeric
Format: Y/N
		1
		x
		x
		FI equivalent is entryIsPersonal
		Expense - expenseEntry Section
		Yes or no is the expense personal.
Data Type: Alphanumeric
Format: Y/N
		1
	
	
		70
		69
		Report Entry Description
		Report Entry Data Section
		Expense description as entered by the employee
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is entryDescription
		Expense - expenseEntry Section
		 Expense description as entered by the employee.
Data Type: Alphanumeric

		64
	
	
		71
		70
		Report Entry Vendor Name
		Report Entry Data Section
		Vendor name
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is entryVendorCode
		Expense - expenseEntry Section
		Vendor name list short code.
Data Type: Alphanumeric

		32
	
	
		72
		71
		Report Entry Vendor Description
		Report Entry Data Section
		Vendor description
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is entryVendorDescription
		Expense - expenseEntry Section
		Vendor description. 
Data Type: Alphanumeric

		64
	
	
		73
		72
		Report Entry Receipt Received Flag
		Report Entry Data Section
		If Y, then this entry has been marked as reviewed by a processor
Data type: Alphanumeric
Format: Y/N
		1
		x
		

		

		

		

		

	
	
		74
		73
		Report Entry Receipt Type
		Report Entry Data Section
		One of these:
-> T = Tax receipt
-> R = Regular receipt
-> N = No receipt
Data type: Alphanumeric
		1
		x
		x
		FI equivalent is  entryReceiptType
		Expense - expenseEntry Section
		One of these: T = Tax receipt, R = Regular receipt, or N = No receipt.
Data Type: Alphanumeric
Format: T/R/N
		1
	
	
		75
		

		entryElectronicReceiptId
		

		

		

		

		x
		

		Expense - expenseEntry Section
		GUUID. Electronic receipt ID. 
Data Type: Alphanumeric
		24
	
	
		76
		

		entryReceiptId
		

		

		

		

		x
		

		Expense - expenseEntry Section
		GUUID. Non-electronic receipt image.
Data Type: Alphanumeric
		32
	
	
		77
		74
		Total Employee Attendee
		Report Entry Data Section
		Number of attendees that were type Employee or This Employee (count includes both)
Data type: Numeric
Source: Calculated at time file is generated
		23
		x
		

		

		

		

		

	
	
		78
		75
		Total Spouse Attendee
		Report Entry Data Section
		Number of attendees that were type Spouse
Data type: Numeric
Source: Calculated at time file is generated
		23
		x
		

		

		

		

		

	
	
		79
		76
		Total Business Attendee
		Report Entry Data Section
		Number of attendees that were type Business Guest
Data type: Numeric
Source: Calculated at time file is generated
		23
		x
		

		

		

		

		

	
	
		80
		77
		Report Entry Org Unit 1
		Report Entry Data Section
		Organization level data as entered/ updated on the report entry
Data type: Custom field; client defined
Format: Can be set to copy down from the employee or report level. This data is applicable at the entry level in cross charging scenarios.
		48
		x
		x
		F1 equivalent is  entryOrgUnit1Code and entryOrgUnit1Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		81
		78
		Report Entry Org Unit 2
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Can be set to copy down from the employee or report level. This data is applicable at the entry level in cross charging scenarios.
		48
		x
		x
		F1 equivalent is  entryOrgUnit2Code and entryOrgUnit2Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		82
		79
		Report Entry Org Unit 3
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Can be set to copy down from the employee or report level. This data is applicable at the entry level in cross charging scenarios.
		48
		x
		x
		F1 equivalent is  entryOrgUnit3Code and entryOrgUnit3Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		83
		80
		Report Entry Org Unit 4
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Can be set to copy down from the employee or report level. This data is applicable at the entry level in cross charging scenarios.
		48
		x
		x
		F1 equivalent is  entryOrgUnit4Code and entryOrgUnit4Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		84
		81
		Report Entry Org Unit 5
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Can be set to copy down from the employee or report level. This data is applicable at the entry level in cross charging scenarios.
		48
		x
		x
		F1 equivalent is  entryOrgUnit5Code and entryOrgUnit5Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		85
		82
		Report Entry Org Unit 6
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Can be set to copy down from the employee or report level. This data is applicable at the entry level in cross charging scenarios.
		48
		x
		x
		F1 equivalent is  entryOrgUnit6Code and entryOrgUnit6Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		86
		

		reportOrgUnit7Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		87
		

		reportOrgUnit8Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		88
		

		reportOrgUnit9Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		89
		

		reportOrgUnit10Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		90
		

		reportOrgUnit11Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		91
		

		reportOrgUnit12Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		92
		

		reportOrgUnit13Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		93
		

		reportOrgUnit14Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		94
		

		reportOrgUnit15Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		95
		

		reportOrgUnit16Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		96
		

		reportOrgUnit17Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		97
		

		reportOrgUnit18Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		98
		

		reportOrgUnit19Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		99
		

		reportOrgUnit20Code
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code - 64 characters
	
	
		100
		

		reportOrgUnit7Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		101
		

		reportOrgUnit8Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		102
		

		reportOrgUnit9Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		103
		

		reportOrgUnit10Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		104
		

		reportOrgUnit11Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		105
		

		reportOrgUnit12Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		106
		

		reportOrgUnit13Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		107
		

		reportOrgUnit14Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		108
		

		reportOrgUnit15Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		109
		

		reportOrgUnit16Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		110
		

		reportOrgUnit17Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		111
		

		reportOrgUnit18Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		112
		

		reportOrgUnit19Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		113
		

		reportOrgUnit20Value
		

		

		

		

		x
		

		Expense - Report Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		
Value - 64 characters
	
	
		114
		83
		Report Entry Custom 1
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom1Code and entryCustom1Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		115
		84
		Report Entry Custom 2
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom2Code and entryCustom2Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		116
		85
		Report Entry Custom 3
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom3Code and entryCustom3Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		117
		86
		Report Entry Custom 4
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom4Code and entryCustom4Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		118
		87
		Report Entry Custom 5
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom5Code and entryCustom5Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		119
		88
		Report Entry Custom 6
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom6Code and entryCustom6Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		120
		89
		Report Entry Custom 7
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom7Code and entryCustom7Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		121
		90
		Report Entry Custom 8
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom8Code and entryCustom8Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		122
		91
		Report Entry Custom 9
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom9Code and entryCustom9Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		123
		92
		Report Entry Custom 10
		Report Entry Data Section
		(CES Standard - Project)
Data type: Custom field; client defined

		48
		x
		x
		FI equivalent is entryCustom10Code and entryCustom10Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		124
		93
		Report Entry Custom 11
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom11Code and entryCustom11Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		125
		94
		Report Entry Custom 12
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom12Code and entryCustom12Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		126
		95
		Report Entry Custom 13
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom13Code and entryCustom13Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		127
		96
		Report Entry Custom 14
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom14Code and entryCustom14Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		128
		97
		Report Entry Custom 15
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom15Code and entryCustom15Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		129
		98
		Report Entry Custom 16
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom16Code and entryCustom16Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		130
		99
		Report Entry Custom 17
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom17Code and entryCustom17Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		131
		100
		Report Entry Custom 18
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom18Code and entryCustom18Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		132
		101
		Report Entry Custom 19
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom19Code and entryCustom19Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		133
		102
		Report Entry Custom 20
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom20Code and entryCustom20Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		134
		103
		Report Entry Custom 21
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom21Code and entryCustom21Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		135
		104
		Report Entry Custom 22
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom22Code and entryCustom22Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		136
		105
		Report Entry Custom 23
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom23Code and entryCustom23Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		137
		106
		Report Entry Custom 24
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom24Code and entryCustom24Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		138
		107
		Report Entry Custom 25
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom25Code and entryCustom25Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		139
		108
		Report Entry Custom 26
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom26Code and entryCustom26Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		140
		109
		Report Entry Custom 27
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom27Code and entryCustom27Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		141
		110
		Report Entry Custom 28
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom28Code and entryCustom28Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		142
		111
		Report Entry Custom 29
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom29Code and entryCustom29Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		143
		112
		Report Entry Custom 30
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom30Code and entryCustom30Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		144
		113
		Report Entry Custom 31
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom31Code and entryCustom31Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		145
		114
		Report Entry Custom 32
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom32Code and entryCustom32Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		146
		115
		Report Entry Custom 33
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom33Code and entryCustom33Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		147
		116
		Report Entry Custom 34
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom34Code and entryCustom34Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		148
		117
		Report Entry Custom 35
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom35Code and entryCustom35Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		149
		118
		Report Entry Custom 36
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom36Code and entryCustom36Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		150
		119
		Report Entry Custom 37
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom37Code and entryCustom37Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		151
		120
		Report Entry Custom 38
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom38Code and entryCustom38Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		152
		121
		Report Entry Custom 39
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom39Code and entryCustom39Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		153
		122
		Report Entry Custom 40
		Report Entry Data Section
		Data type: Custom field; client defined
Format: Entry custom fields, if not storing organizational data or defined as a standard, are used for any client specific purpose.
		48
		x
		x
		FI equivalent is entryCustom40Code and entryCustom40Value
		Expense - expenseEntry Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		154
		123
		Report Entry Transaction Amount
		Report Entry Data Section
		Amount spent in the expense spend currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		155
		124
		Report Entry Posted Amount
		Report Entry Data Section
		Amount spent in the reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		156
		125
		Report Entry Approved Amount
		Report Entry Data Section
		Amount approved in the reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is entryApprovedAmount
		Expense - expenseEntry Section
		Amount approved in the reimbursement currency.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		157
		126
		Payment Type Code
		Report Entry Data Section
		Report Entry Payment Code Code
Data type: Alphanumeric
		4
		x
		x
		FI equivalent is reportEntryPatKey
		Expense - expenseEntry Section
		Report Entry Payment Code.
Data Type: Alphanumeric

		4
	
	
		158
		127
		Payment Code
		Report Entry Data Section
		Report Entry Payment Code Name
Data type: Alphanumeric
		80
		x
		

		

		

		

		

	
	
		159
		128
		Report Payment Reimbursement Type
		Report Entry Data Section
		Report Payment Reimbursement Type;
Indicates whether Expense Pay reimbursed this journal entry.
Either:
->1 = Expense Pay
-> blank = not Expense Pay
Data type: Alphanumeric
		1
		x
		x
		FI equivalent is expensePayIndicator
		Expense - expenseEntry Section
		Indicates whether Expense Pay reimbursed this journal entry.
Data Type: Alphanumeric
Format: Either: 1 = Expense Pay or blank = not Expense Pay.
		

	
	
		160
		129
		Bill Date
		Credit Card Data Section
		Value is pulled from card vendor feed
Data type: Date YYYY-MM-DD
		10
		x
		

		

		

		

		

	
	
		161
		130
		Billed Credit Card Account Number
		Credit Card Data Section
		Credit card number (not encrypted) used for this expense
Data type: Numeric
		255
		x
		

		

		

		

		

	
	
		162
		131
		Billed Credit Card Description
		Credit Card Data Section
		Description of the card account with the liability for the charge
Data type: Alphanumeric
		255
		x
		

		

		

		

		

	
	
		163
		132
		Credit Card Transaction JR Key
		Credit Card Data Section
		Unique code for the import this transaction was brought into the system with
Data type: Numeric
		13
		x
		

		

		

		

		

	
	
		164
		133
		Credit Card Transaction Reference Number
		Credit Card Data Section
		Reference number from the credit card vendor
Data type: Numeric
		64
		x
		x
		FI equivalent is cardTransactionReferenceNumber
		Expense - Journal Section
		Reference number from the credit card vendor.
Data Type: Number

		64
	
	
		165
		134
		Credit Card Transaction CCT Key
		Credit Card Data Section
		Unique key assigned to the transaction during card import
Data type: Numeric
		13
		x
		

		

		

		

		

	
	
		166
		135
		Credit Card Transaction CCT Type
		Credit Card Data Section
		Transaction type supplied by card vendor.
One of these:
-> ANF = Annual Fees
-> CAV = Cash Advance
-> CCF = Cash and Check Fees
-> CHG = Other Bank Charges and Fees
-> FNC = Finance Charges
-> LAF = Late Fees
-> NSF = Insufficient Funds Check Fees
-> PAY = Payment
-> RPE = Credit Card Transaction
Data type: Alphanumeric
		3
		x
		

		

		

		

		

	
	
		167
		136
		Credit Card Transaction ID
		Credit Card Data Section
		Calculated value assigned to this card entry during the import process
Data type: Alphanumeric
		32
		x
		x
		FI equivalent is cardTransactionID
		Expense - expenseEntry Section
		Calculated value assigned to this card entry during the import process.
Data Type: Alphanumeric

		32
	
	
		168
		137
		Credit Card Transaction Amount
		Credit Card Data Section
		Amount of the charge in the spend currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is cardTransactionAmount
		Expense - expenseEntry Section
		Amount of the charge in the spend currency.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		169
		138
		Credit Card Transaction Tax Amount
		Credit Card Data Section
		Amount of tax on the transaction amount (if provided by card vendor)
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		170
		139
		Credit Card Transaction Currency Alpha Code
		Credit Card Data Section
		Currency code for the spend currency
Data type: Alphanumeric
Format: ISO 3-character alpha code
		3
		x
		x
		FI equivalent is cardTransactionCurrency
		Expense - expenseEntry Section
		Currency code for the spend currency.
Data Type: Alphanumeric
Format: ISO 4217 3-letter alpha code.
		3
	
	
		171
		140
		Credit Card Transaction Posted Amount
		Credit Card Data Section
		Amount of the charge in the billing currency of the card
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is cardTransactionPostedAmount
		Expense - expenseEntry Section
		Amount of the charge in the billing currency of the card.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		172
		141
		Credit Card Transaction Posted Currency Alpha Code
		Credit Card Data Section
		Currency code for the card billing currency
Data type: Alphanumeric
Format: ISO 3-character alpha code
		3
		x
		x
		FI equivalent is cardTransactionPostedCurrency
		Expense - expenseEntry Section
		Currency code for the card billing currency.
Data Type: Alphanumeric
Format: ISO 4217 3-letter alpha code.
		3
	
	
		173
		142
		Credit Card Transaction Date
		Credit Card Data Section
		Date the charge was made at the merchant
Data type: Date
		10
		x
		

		

		

		

		

	
	
		174
		143
		Credit Card Transaction Posted Date
		Credit Card Data Section
		Date the charge was posted to the credit card account
Data type: Date
		10
		x
		

		

		

		

		

	
	
		175
		144
		Credit Card Transaction Description
		Credit Card Data Section
		Description of the charge from the merchant
Data type: Alphanumeric
		42
		x
		

		

		

		

		

	
	
		176
		145
		Credit Card Transaction Master Card Code
		Credit Card Data Section
		Merchant code sent from the credit card vendor
Data type: Alphanumeric
		5
		x
		

		

		

		

		

	
	
		177
		146
		Credit Card Transaction Merchant Name
		Credit Card Data Section
		Name of the merchant
Data type: Alphanumeric
		128
		x
		

		

		

		

		

	
	
		178
		147
		Credit Card Transaction Merchant City
		Credit Card Data Section
		Merchant City
Data type: Alphanumeric
		40
		x
		

		

		

		

		

	
	
		179
		148
		Credit Card Transaction Merchant State
		Credit Card Data Section
		Merchant State/Providence
Data type: Alphanumeric
		32
		x
		

		

		

		

		

	
	
		180
		149
		Credit Card Transaction Merchant Country Code
		Credit Card Data Section
		Merchant country location code
Data type: Alphanumeric
Format: 2-character alpha code
		2
		x
		

		

		

		

		

	
	
		181
		150
		Credit Card Transaction Merchant Reference Number
		Credit Card Data Section
		Merchant reference number passed from the merchant to the card
Data type: Alphanumeric
		32
		x
		

		

		

		

		

	
	
		182
		151
		Credit Card Transaction Billing Type
		Credit Card Data Section
		Billing type imported from the card vendor. Very rarely used.
Data type: Alphanumeric
		2
		x
		

		

		

		

		

	
	
		183
		152
		Exchange Rate From Billing To Employee Currency
		Credit Card Data Section
		Currency exchange rate used between the credit card billing currency and the employee's reimbursement currency
Data type: Numeric
		23
		x
		

		

		

		

		

	
	
		184
		153
		Billing Amount
		Credit Card Data Section
		Amount due to the company card of either CBCP or IBCP type for this detail row
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		185
		154
		Individual Credit Card Account Number
		Credit Card Data Section
		Account number for credit card
Data type: Numeric
		255
		x
		

		

		

		

		

	
	
		186
		

		cardAccountID
		

		

		

		

		x
		

		Expense - expenseEntry Section
		ID for the card account. This can be used by the receiving system to condense transactions associated with this card.
Data Type: Alphanumeric
		32
	
	
		187
		155
		Individual Credit Card Name On Card
		Credit Card Data Section
		Name on credit card
Data type: Alphanumeric
		255
		x
		

		

		

		

		

	
	
		188
		156
		Merchant Doing Business As
		Credit Card Data Section
		Descriptive Name of Merchant
Data type: Alphanumeric
		64
		x
		

		

		

		

		

	
	
		189
		157
		Acquirer Reference Number
		Credit Card Data Section
		Support for feeds that utilize the Acquirer Reference number provided to the client and used by the client for reconciliation.
Data type: Numeric
		50
		x
		

		

		

		

		

	
	
		190
		158
		Report Entry Location Country Code
		Entry Location Data Section
		Country from the report entry spend location
Data type: Alphanumeric
Format: 2-character alpha code
		2
		x
		x
		FI equivalent is entryCountryCode
		Expense - expenseEntry Section
		Report entry country code.
Data Type: Alphanumeric
Format: 2-character country code.
		2
	
	
		191
		159
		Report Entry Location Country Sub Code
		Entry Location Data Section
		Country sub code from the report entry spend location
Data type: Alphanumeric
		6
		x
		x
		FI equivalent is entryCountrySubCode
		Expense - expenseEntry Section
		Report entry sub country code.
Data Type: Alphanumeric

		6
	
	
		192
		160
		Report Entry Foreign or Domestic Flag
		Entry Location Data Section
		Either:
-> FRGN = this expense was incurred in a country other than the employee's home country
-> HOME = this expense was incurred in the employee's home country 
-> OOSD ("Out Of Sub-Division") = this expense location is was incurred in the employee's home country, but in a country sub-division different from their home sub-division (for example, province, in Canada)
Data type: Alphanumeric
		4
		x
		

		

		

		

		

	
	
		193
		161
		Market Code
		Entry Location Data Section
		Description or code used to identify a specific market or region for the card account, often used for remitting payment to the card provider
Data type: Alphanumeric
		255
		x
		

		

		

		

		

	
	
		194
		162
		Processor Reference Number
		Entry Location Data Section
		Support for feeds that utilize the Acquirer Reference number provided to and used by the client for reconciliation
Data type: Numeric
		64
		x
		

		

		

		

		

	
	
		195
		163
		Journal Payer Payment Type Name
		Entry Location Data Section
		Payer payment type
One of these:
-> Company = Company
-> Employee = Employee
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is payer.  Please check Cash Advance worksheet for more information.
		Cash Advance - Journal Data Section
		

		

	
	
		196
		164
		Journal Payer Payment Code Name
		Journal Entry Data Section
		Payment code name for the payer
Data type: Alphanumeric
		80
		x
		x
		FI equivalent is journalPayer
		Expense - Journal Section
		Payment code name for the payer.
Data Type: Alphanumeric

		4
	
	
		197
		165
		Journal Payee Payment Type Name
		Journal Entry Data Section
		Payee payment type
One of these:
-> Company = Company
-> Employee = Employee
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is payee.  Please check Cash Advance worksheet for more information.
		Cash Advance - Journal Data Section
		

		

	
	
		198
		166
		Journal Payee Payment Code Name
		Journal Entry Data Section
		Payment code name for the payee
Data type: Alphanumeric
		80
		x
		x
		FI equivalent is journalPayee
		Expense - Journal Section
		Payment code name for the payee.
Data Type: Alphanumeric

		4
	
	
		199
		167
		Journal Account Code
		Journal Entry Data Section
		Contains the expense type account code
- or -
If a CBCP Personal expense, the company card clearing account code
- or -
If charge is tied to a Statement Report, and accounting code is set for Company Billed card account, the card's accounting code as specified in the Account Code field when creating or editing a CBS account.
Data type: Alphanumeric
		48
		x
		x
		FI equivalent is journalAccountCode
		Expense - Journal Section
		Contains the expense type account code. - or - If a CBCP Personal expense, the company card clearing account code. - or - If charge is tied to a Statement Report, and accounting code is set for Company Billed card account, the card’s accounting code as specified in the Account Code field when creating or editing a CBS account. 
Data Type: Alphanumeric

		48
	
	
		200
		168
		Journal Debit or Credit
		Journal Entry Data Section
		Either:
-> DR = Debit
-> CR = credit
Data type: Alphanumeric
		2
		x
		x
		FI equivalent is debitOrCredit.  Please check Cash Advance worksheet for more information.
		Cash Advance - Journal Data Section
		

		

	
	
		201
		169
		Journal Amount
		Journal Entry Data Section
		Value, as credit or debit, of the amount to be exchanged between the payer and payee for this expense account code (not an absolute value)
EXAMPLES:
Value of zero, credit, or debit, as the following:
-> 0 (Zero) "0"
-> + (Plus / Debit) "+50.00"
-> - (Minus / Credit) "-50.00"
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is amount.  Please check Cash Advance worksheet for more information.
		Cash Advance - Journal Data Section
		

		

	
	
		202
		170
		Journal Key
		Journal Entry Data Section
		Report Journal Key
Data type: Numeric Integer
		10
		x
		

		

		

		

		

	
	
		203
		171
		Car Business Distance
		Car Mileage Data Section
		Number of miles/kilometers driven for business purposes
Data type: Numeric
		13
		x
		

		

		

		

		

	
	
		204
		172
		Car Personal Distance
		Car Mileage Data Section
		Number of miles/ kilometers driven in a company car for personal purposes
Data type: Numeric
		13
		x
		

		

		

		

		

	
	
		205
		173
		Car Passenger Count
		Car Mileage Data Section
		Number of passengers entered as traveling in this car for this from/to location
Data type: Numeric
		13
		x
		

		

		

		

		

	
	
		206
		174
		Vehicle ID
		Car Mileage Data Section
		Vehicle ID that this distance entry has been recorded against
Data type: Alphanumeric
		30
		x
		

		

		

		

		

	
	
		207
		175
		 Credit Card Transaction Sales
		Car Mileage Data Section
		The amount of sales tax from the credit card transaction
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		208
		176
		Credit Card Vendor Name
		Car Mileage Data Section
		The name of the credit card vendor associated with this batch
Data type: Alphanumeric
		64
		x
		

		

		

		

		

	
	
		209
		177
		Cash Advance Request Amount
		Cash Advance Data Section
		For issue journal record, the total amount of the cash advance in the cash advance transaction currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is requestAmount. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		210
		178
		Cash Advance Request Currency Alpha Code
		Cash Advance Data Section
		Currency code for the transaction currency using ISO alpha code
Data type: Alphanumeric
Format: 3-character alpha code
		3
		x
		x
		FI equivalent is currencyAlphaCode. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		211
		179
		Cash Advance Request Currency Numeric Code
		Cash Advance Data Section
		Currency code for the transaction currency using ISO number code
Data type: Numeric
		3
		x
		x
		FI equivalent is currencyNumCode. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		212
		180
		Cash Advance Exchange Rate
		Cash Advance Data Section
		Exchange rate used to convert from the transaction currency to the reimbursement currency
Data type: Numeric
		23
		x
		x
		FI equivalent is exchangeRate. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		213
		

		cashAdvanceClearingAccountCode
		

		

		

		

		x
		Not in SAE because there's a separate CA…configurable by customers…clearing account code is applicable to issuance of CA not application
		Expense - cashAdvanceApplication Section
		The Account Code is the clearing account code which was configured for the employee in the profile.
Data Type: Alphanumeric

		48
	
	
		214
		181
		Cash Advance Currency Alpha Code
		Cash Advance Data Section
		Reimbursement currency code using ISO alpha code
Data type: Alphanumeric
Format: 3-character alpha code
		3
		x
		x
		FI equivalent is employeeCurrencyAlphaCode. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		215
		182
		Cash Advance Currency Numeric Code
		Cash Advance Data Section
		Reimbursement currency code using ISO number code
Data type: Numeric
		3
		x
		

		

		

		

		

	
	
		216
		183
		Cash Advance Issued Date
		Cash Advance Data Section
		Date of issue
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		FI equivalent is issuedDate. Please check Cash Advance worksheet for more information.
		

		

		

	
	
		217
		184
		Cash Advance Payment Code Name
		Cash Advance Data Section
		Method of paying the employee for this cash advance, for example, Cash, AMEX, and so on
Data type: Alphanumeric
		80
		x
		x
		FI equivalent is paymentCode. Please check Cash Advance worksheet for more information.
		Cash Advance - Journal Data Section
		

		

	
	
		218
		185
		Cash Advance Transaction Type
		Cash Advance Data Section
		Type of transaction:
-> 1 = Issue or Return to Administrator
-> 2 = Application, including Cash Advance Return expense within a report
-> 3 = System Cash advance, from balance carry forward
Data type: Numeric
		1
		x
		x
		FI equivalent is cashAdvanceTransactionType
		Expense - cashAdvanceApplication Section
		Type of transaction: 1 = Issue or return to administrator, 2 = Application, including cash advance return expense within a report, or 3 = System cash advance, from balance carry forward.
Data Type: Number

		1
	
	
		219
		186
		Cash Advance Request Date
		Cash Advance Data Section
		Date of cash advance request from the detailed cash advance record
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is requestDate. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		220
		187
		Cash Advance Key
		Cash Advance Data Section
		Unique system key assigned to the cash advance
Data type: Numeric
		13
		x
		x
		FI equivalent is cashAdvanceID
		Expense - cashAdvanceApplication Section
		GUUID. Unique system ID assigned to the cash advance. 
Data Type: Alphanumeric

		32
	
	
		221
		188
		Cash Advance Payment Method
		Cash Advance Data Section
		The method used, either Expense Pay or Other, used for disbursement of the cash advance.
-> 0 = Non-Expense Pay method used for disbursement
-> 1 = Expense Pay method used for disbursement
Data type: Numeric
		1
		x
		x
		FI equivalent is paymentMethod. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		222
		189
		Allocation Key
		Allocation Data Section
		System-generated unique key for this allocation record
Data type: Numeric
		13
		x
		x
		FI equivalent is allocationId
		Expense - Allocation Section
		GUUID. System-generated unique key for this allocation record.
Data Type: Alphanumeric

		32
	
	
		223
		190
		Allocation Percentage
		Allocation Data Section
		Percent of the report entry assigned to this allocation record
Data type: Numeric
		11
		x
		x
		FI equivalent is allocationPercentage
		Expense - Allocation Section
		Percent of the report entry assigned to this allocation record.
Data Type: Number
		11
	
	
		224
		191
		Allocation Custom 1
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode1 and allocationCustomValue1
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		225
		192
		Allocation Custom 2
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode2 and allocationCustomValue2
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		226
		193
		Allocation Custom 3
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode3 and allocationCustomValue3
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		227
		194
		Allocation Custom 4
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode4 and allocationCustomValue4
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		228
		195
		Allocation Custom 5
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode5 and allocationCustomValue5
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		229
		196
		Allocation Custom 6
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode6 and allocationCustomValue6
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		230
		197
		Allocation Custom 7
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode7 and allocationCustomValue7
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		231
		198
		Allocation Custom 8
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode8 and allocationCustomValue8
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		232
		199
		Allocation Custom 9
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode9 and allocationCustomValue9
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		233
		200
		Allocation Custom 10
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode10 and allocationCustomValue10
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		234
		201
		Allocation Custom 11
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode11 and allocationCustomValue11
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		235
		202
		Allocation Custom 12
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode12 and allocationCustomValue12
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		236
		203
		Allocation Custom 13
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode13 and allocationCustomValue13
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		237
		204
		Allocation Custom 14
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode14 and allocationCustomValue14
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		238
		205
		Allocation Custom 15
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode15 and allocationCustomValue15
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		239
		206
		Allocation Custom 16
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode16 and allocationCustomValue16
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		240
		207
		Allocation Custom 17
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode17 and allocationCustomValue17
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		241
		208
		Allocation Custom 18
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode18 and allocationCustomValue18
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		242
		209
		Allocation Custom 19
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode19 and allocationCustomValue19
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		243
		210
		Allocation Custom 20
		Allocation Data Section
		Each segment for the allocation record is stored in one of the custom columns on the allocation form
Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is allocationCustomCode20 and allocationCustomValue20
		Expense - Allocation Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		244
		211
		Journal Net of Total Adjusted Tax
		Allocation Data Section
		This is the Gross Journal amount subtracting the total Tax amount.
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
Source: Calculated at time file is generated
		23
		x
		x
		FI equivalent is amountTax
		Expense - Journal Section
		This is the Gross Journal amount subtracting the total Tax amount.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		245
		212
		TA Reimb. Meal Lodging or Combined Type
		Travel Allowance Data Section
		Flag that identifies what type of travel allowance was applied to this entry:
-> M = meals only
-> L = lodging
-> C = combined meals/lodging
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		246
		213
		TA Display Limit
		Travel Allowance Data Section
		Limit for the reimbursable travel allowance for a single day; if using fixed allowances, this value will not apply
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		247
		214
		TA Allowance Limit
		Travel Allowance Data Section
		The maximum amount that will be reimbursed for the day. If the company does not use LIMIT configuration, this is null
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		248
		215
		Allowable Threshold
		Travel Allowance Data Section
		This is the maximum allowed amount for the day. Basically this represents the break point for journal entries.
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		249
		216
		TA Fixed Meal Lodging Type
		Travel Allowance Data Section
		Flag that identifies what type of travel allowance was applied to this entry:
-> M = meals only
-> L = lodging
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		250
		217
		Base Amount
		Travel Allowance Data Section
		Base amount of allowance for a single day
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		251
		218
		Allowance Amount
		Travel Allowance Data Section
		Reimbursement amount of allowance for this travel allowance day; base minus any adjustments for meals provided, first/last day adjustments, or overnight instead of lodging allowance
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		252
		219
		TA Fixed Overnight
		Travel Allowance Data Section
		Y/N flag that identifies if the employee stayed overnight with a friend/ family instead of lodging
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		253
		220
		TA Fixed Breakfast Provided Flag
		Travel Allowance Data Section
		Flag that identifies if the employee was provided breakfast:
-> NPR = no prorate
-> PRO = prorated
-> TAX = tax receipt
Values specific to German Market TA:
-> BSE = Business entertainment (Geschäftlich veranlasste Bewirtung): The provided meal amount is deducted from the allowance.
-> CVT = Company event (Betriebsveranstaltung): The provided meal amount is deducted from the allowance.
-> WRK = Working meal (Arbeitsessen): The provided meal amount is deducted from the allowance.
-> INC = Incentive meal (Belohnungsessen): The value is recorded for reporting purposes but no adjustment is made to the allowance amount.
-> EXT = External activity: The length of the trip determines the action.
Data type: Alphanumeric
		3
		x
		

		

		

		

		

	
	
		254
		221
		TA Fixed Lunch Provided Flag
		Travel Allowance Data Section
		Flag that identifies if the employee was provided lunch:
-> NPR = no prorate
-> PRO = prorated
-> TAX = tax receipt
Values specific to German Market TA:
-> BSE = Business entertainment (Geschäftlich veranlasste Bewirtung): The provided meal amount is deducted from the allowance.
-> CVT = Company event (Betriebsveranstaltung): The provided meal amount is deducted from the allowance.
-> WRK = Working meal (Arbeitsessen): The provided meal amount is deducted from the allowance.
-> INC = Incentive meal (Belohnungsessen): The value is recorded for reporting purposes but no adjustment is made to the allowance amount.
-> EXT = External activity: The length of the trip determines the action.
Data type: Alphanumeric
		3
		x
		

		

		

		

		

	
	
		255
		222
		TA Fixed Dinner Provided Flag
		Travel Allowance Data Section
		Flag that identifies if the employee was provided dinner:
-> NPR = no prorate
-> PRO = prorated
-> TAX = tax receipt
Values specific to German Market TA:
-> BSE = Business entertainment (Geschäftlich veranlasste Bewirtung): The provided meal amount is deducted from the allowance.
-> CVT = Company event (Betriebsveranstaltung): The provided meal amount is deducted from the allowance.
-> WRK = Working meal (Arbeitsessen): The provided meal amount is deducted from the allowance.
-> INC = Incentive meal (Belohnungsessen): The value is recorded for reporting purposes but no adjustment is made to the allowance amount.
-> EXT = External activity: The length of the trip determines the action.
Data type: Alphanumeric
		3
		x
		

		

		

		

		

	
	
		256
		223
		Total Tax Adjusted Posted Amount
		Travel Allowance Data Section
		Total Tax Adjusted Posted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		257
		224
		Total Reclaim Adjusted Amount
		Travel Allowance Data Section
		Total Reclaim Adjusted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is amountNetofReclaim
		Expense - Journal Section
		Gross Journal amount subtracting reclaimable tax. Or the Net Journal amount adding non-reclaimable tax.
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
	
	
		258
		225
		Tax Authority Name
		VAT Tax Data Section
		Tax authority name
Data type: Alphanumeric
		50
		x
		

		

		

		

		

	
	
		259
		226
		Tax Authority Label
		VAT Tax Data Section
		5-digit code that appears on the expense entry pages
Data type: Alphanumeric
		5
		x
		

		

		

		

		

	
	
		260
		227
		Report Entry Tax Transaction Amount
		VAT Tax Data Section
		Calculated tax amount for this expense in the spend currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		261
		228
		Report Entry Tax Posted Amount
		VAT Tax Data Section
		Calculated tax amount for this expense entry in the reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		262
		229
		Tax Source
		VAT Tax Data Section
		Specifies how the tax data was derived:
-> CARD = Provided from company card
-> USER = Entered by employee
-> SYST = Calculated by system
-> PROC = Entered by processor
Data type: Alphanumeric
		4
		x
		

		

		

		

		

	
	
		263
		230
		Report Entry Tax Reclaim Transaction Amount
		VAT Tax Data Section
		Calculated amount of tax eligible for reclaim in the spend currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		264
		231
		Report Entry Tax Reclaim Posted Amount
		VAT Tax Data Section
		Calculated amount of tax eligible for reclaim in the reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		265
		232
		Report Entry Tax-Tax Code
		VAT Tax Data Section
		Tax code assigned to this tax authority for the expense type entered on the expense entry
Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		266
		233
		Report Entry Tax Reclaim Domestic Flag
		VAT Tax Data Section
		Y = this tax configuration is defined as a reclaimable local tax jurisdiction
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		267
		234
		Report Entry Tax Adjusted Amount
		VAT Tax Data Section
		Amount of tax based on approved amount, not total in the employees reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		268
		235
		Report Entry Tax Reclaim Adjusted Amount
		VAT Tax Data Section
		Reclaim amount calculated on adjusted tax amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		269
		236
		Report Entry Tax Reclaim Code
		VAT Tax Data Section
		Reclaim code from the tax definition
Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		270
		237
		Report Entry Tax Reclaim Trans Adjusted Amount
		VAT Tax Data Section
		Amount of tax based on approved amount, not total in spend transaction currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		271
		238
		Report Entry Tax Allocation Reclaim Code
		VAT Tax Data Section
		Allocation Reclaim Code
Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		272
		239
		Travel Request ID
		Assigned Travel Request Data Section
		The authorization request identification number
Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		273
		240
		Travel Request Name
		Assigned Travel Request Data Section
		Name given to the travel request assigned to the report
Data type: Alphanumeric
		40
		x
		

		

		

		

		

	
	
		274
		241
		Travel Request Total Posted Amount
		Assigned Travel Request Data Section
		Total amount of the assigned travel request in the employees reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		275
		242
		Travel Request Total Approved Amount
		Assigned Travel Request Data Section
		Total amount approved for the assigned travel request in the employees reimbursement currency
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		276
		243
		Travel Request Start Date
		Assigned Travel Request Data Section
		First day of the trip on the assigned travel request itinerary
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		Fi equivalent is travelStartDate. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		277
		244
		Travel Request End Date
		Assigned Travel Request Data Section
		Last day of the trip on the assigned travel request itinerary
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		Fi equivalent is travelEndDate. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		278
		245
		Travel Request Authorized Date
		Assigned Travel Request Data Section
		Date the assigned travel request was authorized
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

		

		

		

	
	
		279
		246
		Report Entry Total Tax Posted Amount
		Additional VAT Tax Data Section
		The sum of the tax calculated based on the expense amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		280
		247
		Net Tax Amount
		Additional VAT Tax Data Section
		Calculated as Posted Amount minus Total Tax Posted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is amountNetOfTax
		Expense - Journal Section
		Allocated net of reclaim tax. You get this by starting from the net and adding the tax that is not reclaimable, or starting with the gross and subtracting reclaimable.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		281
		248
		Report Entry Total Reclaim Adjusted Amount
		Additional VAT Tax Data Section
		The sum of the reclaimable tax amount calculated from the Total Tax Adjusted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		282
		249
		Net Adjusted Reclaim Amount
		Additional VAT Tax Data Section
		Calculated as Approved Amount minus Total Reclaim Adjusted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		283
		250
		Report Entry Payment Type Name
		Report Entry Data Section
		Report entry payment type name
Data type: Alphanumeric
		64
		x
		

		

		

		

		

	
	
		284
		251
		Card Program Type Code
		Company Bill Statements Section
		The code used to identify the card's program type
Data type: Alphanumeric
		5
		x
		x
		FI equivalent is cardProgramTypeCode
		Expense - expenseEntry Section
		The code used to identify the card’s program type.
Data Type: Alphanumeric
		5
	
	
		285
		252
		Statement Period Start Date
		Company Bill Statements Section
		The date of the start of the statement period
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is cardStatementPeriodStartDate
		Expense - expenseEntry Section
		The date of the start of the statement period.
Data Type: Alphanumeric
Format: yyyy-mm-ddThr:min:sec.msZ
		24
	
	
		286
		253
		Statement Period End Date
		Company Bill Statements Section
		The date of the end of the statement period
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is cardStatementPeriodEndDate
		Expense - expenseEntry Section
		The date of the end of the statement period.
Data Type: Alphanumeric
Format: yyyy-mm-ddThr:min:sec.msZ
		24
	
	
		287
		254
		Cash Account Code
		Expense Pay Data Section
		The Cash Account Code assigned to the funding account paying this entry
Data type: Alphanumeric
		48
		x
		

		

		

		

		

	
	
		288
		255
		Liability Account Code
		Expense Pay Data Section
		The Liability Account Code assigned to the funding account paying this entry
Data type: Alphanumeric
		48
		x
		x
		FI equivalent is liabilityAccountCode
		Expense - expenseEntry Section
		The liability account code assigned to the funding account paying this entry.
Data Type: Alphanumeric

		48
	
	
		289
		256
		Estimated Payment Date
		Expense Pay Data Section
		One of these:
-> Assigned = four weekdays after the scheduled send date; note this doesn't need to account for banking holidays
-> Sent = four weekdays after the sent date; note this doesn't need to account for banking holidays
-> Confirmed = the estimated payment date indicated by the Expense Payment Engine
-> Aborted = blank
-> Failed Account = blank
-> Pending Confirmation = blank
Data type: Date
Format: YYYY/MM/DD
		

		x
		

		

		

		

		

	
	
		290
		257
		Funding Trace
		Expense Pay Data Section
		Funding Trace Number
Data type: Character
		30
		x
		

		

		

		

		

	
	
		291
		258
		Requested Disbursement Date
		Expense Pay Data Section
		Cash Advance Disbursement Date
Data type: Numeric
		

		x
		x
		FI equivalent is requestedDisbursementDate. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		292
		259
		Cash Advance Name
		Expense Pay Data Section
		Cash Advance Request Name
Data type: Alphanumeric
		40
		x
		x
		FI equivalent is name. Please check Cash Advance worksheet for more information.
		Cash Advance - cashAdvance Data Section
		

		

	
	
		293
		260
		System Allocation
		Expense Pay Data Section
		Y/N flag that identifies allocation record as system-generated (default) rather than user-entered
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		294
		261
		Future Use
		Expense Pay Data Section
		

		

		x
		

		

		

		

		

	
	
		295
		262
		Future Use
		Expense Pay Data Section
		

		

		x
		

		

		

		

		

	
	
		296
		263
		Future Use
		Expense Pay Data Section
		

		

		x
		

		

		

		

		

	
	
		297
		264
		Employee Login ID
		Employee Data Section
		Data type: Alphanumeric
		128
		x
		

		This element is not included in the FI because of its design
		

		

		

	
	
		298
		265
		Employee Email Address
		Employee Data Section
		Data type: Alphanumeric
		255
		x
		

		This element is not included in the FI because of its design
		

		

		

	
	
		299
		266
		Employee Custom 1
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom1Code and employeeCustom1Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		300
		267
		Employee Custom 2
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom2Code and employeeCustom2Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		301
		268
		Employee Custom 3
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom3Code and employeeCustom3Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		302
		269
		Employee Custom 4
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom4Code and employeeCustom4Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		303
		270
		Employee Custom 5
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom5Code and employeeCustom5Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		304
		271
		Employee Custom 6
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom6Code and employeeCustom6Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		305
		272
		Employee Custom 7
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom7Code and employeeCustom7Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		306
		273
		Employee Custom 8
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom8Code and employeeCustom8Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		307
		274
		Employee Custom 9
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom9Code and employeeCustom9Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		308
		275
		Employee Custom 10
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom10Code and employeeCustom10Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		309
		276
		Employee Custom 11
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom11Code and employeeCustom11Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		310
		277
		Employee Custom 12
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom12Code and employeeCustom12Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		311
		278
		Employee Custom 13
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom13Code and employeeCustom13Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		312
		279
		Employee Custom 14
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom14Code and employeeCustom14Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		313
		280
		Employee Custom 15
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom15Code and employeeCustom15Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		314
		281
		Employee Custom 16
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom16Code and employeeCustom16Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		315
		282
		Employee Custom 17
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom17Code and employeeCustom17Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		316
		283
		Employee Custom 18
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom18Code and employeeCustom18Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		317
		284
		Employee Custom 19
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom19Code and employeeCustom19Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		318
		285
		Employee Custom 20
		Employee Data Section
		Data type: Custom field; client defined
		48
		x
		x
		FI equivalent is employeeCustom20Code and employeeCustom20Value
		Expense - Employee Section
		The details from the custom fields. These fields may not have data, depending on the configuration.
Type: Custom Field
		Code -48 characters
Value - 64 characters
	
	
		319
		286
		Future Use
		Employee Data Section
		

		

		x
		

		

		

		

		

	
	
		320
		287
		Future Use
		Employee Data Section
		

		

		x
		

		

		

		

		

	
	
		321
		288
		Future Use
		Employee Data Section
		

		

		x
		

		

		

		

		

	
	
		322
		289
		Future Use
		Employee Data Section
		

		

		x
		

		

		

		

		

	
	
		323
		290
		Future Use
		Employee Data Section
		

		

		x
		

		

		

		

		

	
	
		324
		291
		Employee Banking Account is Active?
		Employee Banking Data Section
		Indicates if the account is active or inactive
Valid entries:
-> Y = Active
-> N = Inactive
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		325
		292
		Employee Banking Bank Account Type
		Employee Banking Data Section
		The bank account type for EFT, either checking or savings. Valid entries for:
U.S.:
-> CHCK = Checking
-> SAVE = Savings
All other countries:
-> CHCK = Checking
Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		326
		293
		Employee Banking Name On Account
		Employee Banking Data Section
		The exact name associated with the account, for example, John Smith.
Data type: Alphanumeric
		100
		x
		

		

		

		

		

	
	
		327
		294
		Employee Banking Bank Name*
		Employee Banking Data Section
		The host bank name.
*Optional for US and Canadian banks
Data type: Alphanumeric
		200
		x
		

		

		

		

		

	
	
		328
		295
		Employee Banking Bank Branch Location*
		Employee Banking Data Section
		The location of the branch of the bank that the account was opened at.
*Optional for US and Canadian banks
Data type: Alphanumeric
		30
		x
		

		

		

		

		

	
	
		329
		296
		Employee Banking Bank Address Line 1
		Employee Banking Data Section
		Data type: Alphanumeric
		50
		x
		

		

		

		

		

	
	
		330
		297
		Employee Banking Bank Address Line 2
		Employee Banking Data Section
		Data type: Alphanumeric
		50
		x
		

		

		

		

		

	
	
		331
		298
		Employee Banking Bank City
		Employee Banking Data Section
		Data type: Alphanumeric
		50
		x
		

		

		

		

		

	
	
		332
		299
		Employee Banking Bank Region
		Employee Banking Data Section
		Data type: Alphanumeric
		50
		x
		

		

		

		

		

	
	
		333
		300
		Employee Banking Bank Postal Code
		Employee Banking Data Section
		Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		334
		301
		Employee Banking Bank Country Code
		Employee Banking Data Section
		The code for the country of origin for the banking account.
Data type: Alphanumeric
Format: 2-character alpha code
		2
		x
		

		

		

		

		

	
	
		335
		302
		Employee Banking Tax ID
		Employee Banking Data Section
		Data type: Alphanumeric
		255
		x
		

		

		

		

		

	
	
		336
		303
		Employee Banking Is Resident?
		Employee Banking Data Section
		Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		337
		304
		Employee Banking Account Status
		Employee Banking Data Section
		Data type: Alphanumeric
		30
		x
		

		

		

		

		

	
	
		338
		305
		Employee Banking Account Currency
		Employee Banking Data Section
		The alpha code for the currency of the account, for example, USD.
If provided, must be USD, EUR, AUD, or GBP until other currency support is provided in a future release. If left with a blank value, defaults to USD.
Data type: Alphanumeric
		3
		x
		

		

		

		

		

	
	
		339
		306
		Future Use
		Employee Banking Data Section
		

		

		x
		

		

		

		

		

	
	
		340
		307
		Future Use
		Employee Banking Data Section
		

		

		x
		

		

		

		

		

	
	
		341
		308
		Future Use
		Employee Banking Data Section
		

		

		x
		

		

		

		

		

	
	
		342
		309
		Future Use
		Employee Banking Data Section
		

		

		x
		

		

		

		

		

	
	
		343
		310
		Future Use
		Employee Banking Data Section
		

		

		x
		

		

		

		

		

	
	
		344
		311
		Personal Expenses
		Report Data Section
		Report Total Personal Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		345
		312
		Total Amount Claimed
		Report Data Section
		Report Total Claimed Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		346
		313
		Amount Due Employee
		Report Data Section
		Total Employee Due: The value of CT_REPORT.COMPANY_TO_ EMPLOYEE_AMOUNT.
NOTE: If total is negative, this value will return a value of "Zero." Payment systemstypically cannot deduct money, so integrations with those systems should use this rather than the ACTUAL total
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		347
		314
		Amount Due Company Card
		Report Data Section
		Total Company Card Due
NOTE: If total is negative, this value will return a value of "Zero." Payment systems typically cannot deduct money, so integrations with those systems should use this rather than the ACTUAL total
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is amountGrossCard
		Expense - Journal Section
		Amount due to the company card of either CBCP or IBCP type for this detail row.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		348
		315
		Amount Not Approved
		Report Data Section
		Report Total Rejected
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		349
		316
		Amount Company Paid
		Report Data Section
		Report Total Company Paid
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		350
		317
		Amount Due Company
		Report Data Section
		Report Total Due Company
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		351
		318
		Payment Confirmed Amount
		Report Data Section
		Report Total Confirmed Paid
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		352
		319
		Amount Due Employee
		Report Data Section
		Report Actual Total Due Employee: The value of CT_REPORT.COMPANY_TO_ EMPLOYEE_AMOUNT (If total is negative this returns the negative value)
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		353
		320
		Amount Due Company Card
		Report Data Section
		Report Actual Total Due Company Card (If total is negative this returns the negative value)
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		354
		321
		Report Type
		Report Data Section
		Report Type
One of these:
-> blank = Regular expense report
-> RR = Regular report that was autocreated by Expense Assistant
-> CR = Central Reconciliation report
-> SR = Statement report
Data type: Alphanumeric
		2
		x
		

		

		

		

		

	
	
		355
		322
		Total Tax Adjusted Amount
		Report Data Section
		Report Entry Total Tax Adjusted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		356
		323
		Net Adjusted Tax Amount
		Report Data Section
		Net Adjusted Tax Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		FI equivalent is amountNetofTax
		Expense - Journal Section
		Allocated net of reclaim tax. You get this by starting from the net and adding the tax that is not reclaimable, or starting with the gross and subtracting reclaimable.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.

		23
	
	
		357
		324
		Report Start Date
		Report Data Section
		Start Date from the Report Header. Can be imported from Trip data or manually entered. 
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is reportStartDate
		Expense - Report Section
		Report start date.
Data Type: Alphanumeric

		24
	
	
		358
		325
		Report End Date
		Report Data Section
		End Date from the Report Header. Can be imported from Trip data or manually entered.
Data type: Date
Format: yyyy-MM-dd
		10
		x
		x
		FI equivalent is reportEndDate
		Expense - Report Section
		End date from the report header. Can be imported from trip data or manually entered.
Data Type: Alphanumeric
Format: yyyy-mm-ddThr:min:sec.msZ

		

	
	
		359
		326
		Future Use
		Report Data Section
		

		

		x
		

		

		

		

		

	
	
		360
		327
		Cash Advance Returns Amount
		Cash Advance Data Section
		Cash Advance Returned Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is cashAdvanceReturnsAmount.
		Expense - cashAdvanceApplication Section
		Amount of cash advance returned.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		361
		328
		Cash Advance Return Received
		Cash Advance Data Section
		Cash Advance Return Received Flag
Data type: Alphanumeric
		1
		x
		

		

		

		

		

	
	
		362
		329
		Cash Advance Utilized Amount
		Cash Advance Data Section
		Cash Advance Utilized Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		x
		FI equivalent is cashAdvanceApplicationAmount
		Expense - cashAdvanceApplication Section
		Cash advance utilized amount.
Data Type: Number
Format: Maximum 23 digits to the left of the decimal; maximum 8 digits to the right of the decimal; with a maximum of 23 digits for the entire field.
		23
	
	
		363
		330
		Future Use
		Cash Advance Data Section
		

		

		x
		

		

		

		

		

	
	
		364
		331
		Future Use
		Cash Advance Data Section
		

		

		x
		

		

		

		

		

	
	
		365
		332
		Future Use
		Cash Advance Data Section
		

		

		x
		

		

		

		

		

	
	
		366
		333
		Future Use
		Cash Advance Data Section
		

		

		x
		

		

		

		

		

	
	
		367
		334
		Report Entry Location City Name
		Report Entry Data Section
		Report Entry Location Name
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is entryLocationCityName
		Expense - expenseEntry Section
		 Report entry location city
Data Type: Alphanumeric

		64
	
	
		368
		335
		Is Billable?
		Report Entry Data Section
		Is Billable
Data type: Alphanumeric
		1
		x
		x
		FI equivalent is entryIsBillable
		Expense - expenseEntry Section
		Yes or no is the expense billable.
Data Type: Alphanumeric

		1
	
	
		369
		336
		Report Entry From Location
		Report Entry Data Section
		Report Entry From Location
Data type: Alphanumeric
		100
		x
		

		

		

		

		

	
	
		370
		337
		Report Entry To Location
		Report Entry Data Section
		Report Entry To Location
Data type: Alphanumeric
		100
		x
		

		

		

		

		

	
	
		371
		338
		Report Entry Location Name
		Report Entry Data Section
		Report Entry Location Name
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is entryLocationName
		Expense - expenseEntry Section
		 Report entry location name
Data Type: Alphanumeric

		64
	
	
		372
		339
		Country
		Report Entry Data Section
		Report Entry Country Code
Data type: Alphanumeric
Format: 2-character alpha code
		2
		x
		x
		FI equivalent is entryCountryCode
		Expense - expenseEntry Section
		Report Entry Country Code
Data type: Alphanumeric
Format: 2-character alpha code
		2
	
	
		373
		340
		State/Province
		Report Entry Data Section
		Report Entry Country Sub Code
Data type: Alphanumeric
		6
		x
		x
		Fi equivalent is entryCountrySubCode
		Expense - expenseEntry Section
		Report Entry Country Sub Code
Data type: Alphanumeric
		6
	
	
		374
		341
		UUID
		Report Entry Data Section
		Report Entry XML Receipt UUID
Data type: Alphanumeric
		36
NOTE: Stored as Binary (16)
		x
		x
		FI equivalent is entryUuid
		Expense - expenseEntry Section
		Report Entry XML Receipt UUID.
Data Type: Alphanumeric

		32
	
	
		375
		342
		Supplier Tax ID
		Report Entry Data Section
		Report Entry XML Receipt Supplier Tax ID
Data type: Alphanumeric
		64
		x
		x
		FI equivalent is entrySupplierTaxID
		Expense - expenseEntry Section
		Report entry XML receipt supplier tax ID.
Data Type: Alphanumeric

		64
	
	
		376
		343
		Future Use
		Report Entry Data Section
		

		

		x
		

		

		

		

		

	
	
		377
		344
		Future Use
		Report Entry Data Section
		

		

		x
		

		

		

		

		

	
	
		378
		345
		Future Use
		Report Entry Data Section
		

		

		x
		

		

		

		

		

	
	
		379
		346
		Future Use
		Report Entry Data Section
		

		

		x
		

		

		

		

		

	
	
		380
		347
		Allocation Total Tax Transaction Amount
		VAT Tax Data Section
		Allocation Total Tax Transaction Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		381
		348
		Allocation Total Tax Posted Amount
		VAT Tax Data Section
		Allocation Total Tax Posted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		382
		349
		Allocation Total Tax Reclaim Transaction Amount
		VAT Tax Data Section
		Allocation Total Tax Reclaim Transaction Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		383
		350
		Allocation Total Tax Reclaim Posted Amount
		VAT Tax Data Section
		Allocation Total Tax Reclaim Posted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		384
		351
		Allocation Total Tax Reclaim Transaction Adjusted Amount
		VAT Tax Data Section
		Allocation Total Tax Reclaim Transaction Adjusted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		385
		352
		Merchant Tax ID
		VAT Tax Data Section
		Merchant Tax ID is populated by the following (in order of precedence): Ereceipt v4 with tax data, Company card transaction, and ExpenseIt OCR transaction
		64
		x
		

		

		

		

		

	
	
		386
		353
		Future Use
		VAT Tax Data Section
		

		

		x
		

		

		

		

		

	
	
		387
		354
		Future Use
		VAT Tax Data Section
		

		

		x
		

		

		

		

		

	
	
		388
		355
		Future Use
		VAT Tax Data Section
		

		

		x
		

		

		

		

		

	
	
		389
		356
		Future Use
		VAT Tax Data Section
		

		

		x
		

		

		

		

		

	
	
		390
		357
		Request Name
		Request Data Section
		Authorization Request Name
Data type: Alphanumeric
		40
		x
		

		

		

		

		

	
	
		391
		358
		Total Posted Amount
		Request Data Section
		Authorization Request Total Posted Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		392
		359
		Total Approved Amount
		Request Data Section
		Authorization Request Total Approved Amount
Data type: Money
Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field
		23
		x
		

		

		

		

		

	
	
		393
		360
		Start Date
		Request Data Section
		Authorization Request Start Date
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

		

		

		

	
	
		394
		361
		End Date
		Request Data Section
		Authorization Request End Date
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

		

		

		

	
	
		395
		362
		Authorized Date
		Request Data Section
		Authorization Request Authorized Date
Data type: Date
Format: yyyy-MM-dd
		10
		x
		

		

		

		

		

	
	
		396
		363
		Authorization Request ID
		Request Data Section
		Authorization Request ID
Data type: Alphanumeric
		20
		x
		

		

		

		

		

	
	
		397
		364
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		398
		365
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		399
		366
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		400
		367
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		401
		368
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		402
		369
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		403
		370
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		404
		371
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		405
		372
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		406
		373
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		407
		374
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		408
		375
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		409
		376
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		410
		377
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		411
		378
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		412
		379
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		413
		380
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		414
		381
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		415
		382
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		416
		383
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		417
		384
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		418
		385
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		419
		386
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		420
		387
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		421
		388
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		422
		389
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		423
		390
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		424
		391
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		425
		392
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		426
		393
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		427
		394
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		428
		395
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		429
		396
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		430
		397
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		431
		398
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		432
		399
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		433
		400
		Future Use
		Request Data Section
		

		

		x
		

		

		

		

		

	
	
		434
		

		payrollPayIndicator
		

		

		

		

		x
		

		Expense - Report Section
		This field indicates whether the expense group the report user belongs to is configured to reimburse employees using Payroll.
Data Type: Alphanumeric
Format: Y/N
		1
	
	
		435
		

		payrollPaymentClearingAccountCode
		

		

		

		

		x
		

		Expense - Report Section
		SAP customers who reimburse their employees via Payroll need to capture a payroll clearing account code as part of the accounting entry during the financial posting process.
Data Type: Alphanumeric

		128
	
	
		436
		

		isTest
		

		

		

		

		x
		

		Expense - Report Section
		Signifies if this report belongs to a test user in system. 
Data Type: Alphanumeric
Format: Y = test user, N = not a test user.
		1
	
	
		437
		

		revisionNumber
		

		

		

		

		x
		

		Expense - Report Section
		Report revision number. This will be used to track changes made to posted expenses. Default value is 1. 
Data Type: Number
		32
	
	
		438
		

		clearingAccountCode
		

		

		

		

		x
		

		Expense - expenseEntry Section
		 Contains the expense type account code. - or - If a CBCP Personal expense, the company card clearing account code. - or - If charge is tied to a Statement Report, and accounting code is set for Company Billed card account, the card’s accounting code as specified in the Account Code field when creating or editing a CBS account.
Data Type: Alphanumeric
		20
	
	
		439
		

		legacyEntryId
		

		

		

		

		x
		

		Expense - expenseEntry Section
		Legacy report entry key. 
Data Type: Number
		11
	
	
		440
		

		offsetPayType
		

		

		

		

		x
		

		Expense - expenseEntry Section
		Use Offsets
Data Type: Alphanumeric
Format: Y = Yes, N= No.
		1
	
	
		441
		

		accountingTransactionType
		

		

		

		

		x
		

		Expense - Journal Section
		This is the Intuit QuickBooks specific transaction value. It will be null or a value (GJ, CC, or BILL) depending on if it’s a journalpayee or journalpayer. This determines if a transaction should be posted as Bill or Credit Card in QuickBooks.
Data Type: Alphanumeric

		24
	
	
		442
		

		taxGuid
		

		

		

		

		x
		

		Expense - Journal Section
		GUUID. Unique identifier associated with the report entry tax allocation.
Data Type: Alphanumeric

		32
	
	
		443
		

		expenseTypeCode
		

		

		

		

		x
		

		Expense - expenseEntry Section
		Code for the expense type.
Data Type: Alphanumeric

		5
The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions there are three main worksheets in the excel workbook comparison file worsheet titled header data lists fields worksheet details section cash advance fi of sectiondetails worksheetsno displays row number field worksheetcol column sae databasefieldname name fieldsectionname fielddescriptiondata typeformatsource description andor type format source filelength length allocated to fieldsae an x if a is present filefi filecomments equivalent for else it left blankdetails fieldlength filesae or additional note blanksectionname fielddetails worksheetfieldname schemadescriptiondata filesectionname sno col sectionname descriptiondata comments constant value quot extract will be inserted into first position by having always produced even no reports ready extracteddata alphanumeric batch date datedata dateformat yyyymmdd record count detail records filedata numericsource calculated when created journal amount total that sums all columns rowsdata moneyformat max digits decimal r...
Related files

Share

Help

Sno	Col# [SAE]	Field Name	SectionName [SAE]	Description/Data Type/Format/Source [SAE]	Length [SAE]	SAE	FI	Comments
1	1	Constant	File Header Section	The value "EXTRACT" will be inserted into the first position of the extract. By having a constant in the file header, an extract file is always produced, even if there are no reports ready to be extracted. Data type: Alphanumeric	7	x
2	2	Batch_Date	File Header Section	Batch Date Data type: Date Format: yyyy-MM-dd	10	x
3	3	Record_Count	File Header Section	Count of the detail records in the file Data type: Numeric Source: Calculated when file is created	10	x
4	4	Journal Amount Total	File Header Section	Total that sums all journal amount columns in the journal rows Data type: Money Format: Max 23 digits to the left of the decimal; max 8 digits to the right of the decimal; with a max of 23 digits for the entire field Source: Calculated when file is created	23	x
5	5	Batch ID	File Header Section	Batch ID Data type: Numeric Format: Starts with number 1 and increments sequentially	13	x
Related files

Share

Share to social media

Help

Login Area
