ExpensesExpenseDistribution

Columns


Name	Type	Description
ExpensesExpenseId [KEY]	Long	Expense identifier of the expense record.
CodeCombinationId	Long	Value that uniquely identifies the accounting code combination to which an expense is charged.
CostCenter	String	Business organization to which an expense is charged.
CreatedBy	String	User who created the row.
CreationDate	Datetime	Date and time when the row was created.
ExpenseDistId [KEY]	Long	Value that uniquely identifies the expense distribution of a specific expense item.
ExpenseId	Long	Value that uniquely identifies the expense for an expense distribution.
ExpenseReportId	Long	Value that uniquely identifies the expense report that includes the expense corresponding to an expense distribution.
LastUpdateDate	Datetime	Date and time when the row was last updated.
LastUpdateLogin	String	Session login associated with the user who last updated the row.
LastUpdatedBy	String	User who last updated the row.
OrgId	Long	Unique identifier of the user's organization for which the expense is created.
ReimbursableAmount	Double	Amount to be reimbursed to the individual against an expense distribution.
Company	String	Company to which an expense is charged.
BusinessUnit	String	Business unit that's associated with a row.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。