Table 29. Siebel Expense Report ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
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.
|