Bookshelf v7.5: Siebel Expense Report

The Siebel Expense Report ASI is part of the Manage Expense Report business process. Its primary objective is to synchronize Expense Report with the back-office system in order for an employee to be reimbursed. This ASI facilitates the outbound data synchronization between the Siebel application and an external back-office system. Figure 19 describes the Siebel Expense Report ASI structure and Table 29 lists the field definitions.

Table 28. Siebel Expense Report Integration Components
Integration Component	XML Tag	User Keys
Expense	Expense	Id Expense Number
Employee	Employee	Id Integration Id
Expense Item	ExpenseItem	Id Expense Number
Related Employee Organization	RelatedEmployeeOrganization	Employee Organization Id Employee Organization Integration Id

Table 29 lists the fields and their attributes. Fields without a length specified do not have a maximum length.

Table 29. Siebel Expense Report ASI Fields
Name	XML Tag	Data Type	Length	Notes
Expense
Accepted Flag	AcceptedFlag	DTYPE_TEXT	1
Approved Flag	ApprovedFlag	DTYPE_TEXT	1
Cash Advance	CashAdvance	DTYPE_CURRENCY	22
Cash Advance Currency Code	CashAdvanceCurrencyCode	DTYPE_TEXT	20
Cash Advance Date	CashAdvanceDate	DTYPE_UTCDATETIME	7
Currency Code	CurrencyCode	DTYPE_TEXT	20	Used for picking a related entity.
End Date	EndDate	DTYPE_UTCDATETIME	7
Expense Number	ExpenseNumber	DTYPE_NUMBER	22,7	User key field.
Id	Id	DTYPE_ID	15	This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field.
Name	Name	DTYPE_TEXT	50
Owner Emp #	OwnerEmp	DTYPE_TEXT	30
Owner Login	OwnerLogin	DTYPE_TEXT	50	Used for picking a related entity.
Paid Currency Code	PaidCurrencyCode	DTYPE_TEXT	20	Used for picking a related entity.
Period	Period	DTYPE_TEXT	50
Reimbursable Amount	ReimbursableAmount	DTYPE_CURRENCY	22
Reimbursable Flag	ReimbursableFlag	DTYPE_TEXT	1
Start Date	StartDate	DTYPE_UTCDATETIME	7
Status	Status	DTYPE_TEXT	30	Bound by LOV EXP_STATUS
Submit To Login	SubmitToLogin	DTYPE_TEXT	50	Used for picking a related entity.
Submitted By	SubmittedBy	DTYPE_TEXT	50	Used for picking a related entity.
Submitted Flag	SubmittedFlag	DTYPE_TEXT	1
Employee
Id	Id	DTYPE_ID	15	This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field.
First Name	FirstName	DTYPE_TEXT	50
Integration Id	IntegrationId	DTYPE_TEXT	30	User key field.
Last Name	Last Name	DTYPE_TEXT	50
Expense Item
Id	Id	DTYPE_ID	15	This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field.
Adjust Flag	AdjustFlag	DTYPE_TEXT	1
Amount	Amount	DTYPE_CURRENCY	22
Currency Code	CurrencyCode	DTYPE_TEXT	20	Used for picking a related entity.
Exchange Date	ExchangeDate	DTYPE_UTCDATETIME	7
Exchange Rate	ExchangeRate	DTYPE_NUMBER	22,7
Expense Item Number	ExpenseItemNumber	DTYPE_NUMBER	22,7	User key field.
Expense Item Type	ExpenseItemType	DTYPE_TEXT	50
Expense Type	ExpenseType	DTYPE_NUMBER	22,7
Owner Id	OwnerId	DTYPE_ID	15	Used for picking a related entity.
Reimbursable Converted Amount	ReimbursableConvertedAmount	DTYPE_CURRENCY	22
Reimbursable Flag	ReimbursableFlag	DTYPE_TEXT	1
Start Date	StartDate	DTYPE_UTCDATETIME	7
Related Employee Organization
Employee Organization	EmployeeOrganization	DTYPE_TEXT	50
Employee Organization Id	EmployeeOrganizationId	DTYPE_ID	15	User key field.
Employee Organization Integration Id	EmployeeOrganizationIntegrationId	DTYPE_TEXT	30	User key field.