ExpenseReportsExpensePayment

Columns


Name	Type	Description
ExpenseReportsExpenseReportId [KEY]	Long	Expense report identifier of the expense reports.
PaymentDate	Date	Date when the payment is done.
PaymentAmount	Double	Amount for which the payment is done.
PaymentCurrencyCode	String	The Currency code in which the payment is done.
CheckNumber	Long	Bank Check Number for the payment done.
CheckId	Long	Bank Check Unique identifier for the payment done.
PaymentNumber	Long	Number representing the payment sequence.
InvoiceId	Long	Value that uniquely identifies an invoice for the payment.
PaymentMethod	String	Method of payment for this expense report such as check, cash, or credit.
PaymentMethodCode	String	Code representing Method of Payment.
ExpenseReportId [KEY]	Long	Value that uniquely identifies a specific expense report.
MailingAddress	String	Mailing address of the employee for whom the payment is done.
BankAccountNumber	String	Bank account number to which the expense amount is reimbursed.
BankName	String	Bank name to which the expense amount is reimbursed.
ProcessingType	String	Processing type of the payment such as PRINTED or ELECTRONIC.

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