ExpenseReportsExpenseduplicateExpenses
ExpenseReportsExpenseduplicateExpenses
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Expense report identifier of the expense reports. |
| ExpenseExpenseId [KEY] | Long | Expense identifier of the expense record. |
| ExpenseId | Long | Value that uniquely identifies the parent expense of a duplicate expense. |
| DuplicateExpenseId | Long | Value that uniquely identifies a specific duplicate expense item. |
| DuplicateStatusCode | String | Indicates whether expenses are duplicate or not. |
| DuplicateGroupId | Long | Value that uniquely identifies a group of duplicate expenses. |
| DuplicateExpenseSource | String | Code that indicates the source of a duplicate expense item. Possible values are CASH and CORP_CARD. |
| DuplicateReceiptAmount | Double | The duplicate expense receipt amount in the receipt currency. |
| DuplicateReceiptCurrencyCode | String | Code that indicates the receipt currency of a duplicate expense item. |
| DuplicateLocation | String | Location where the duplicate expense was incurred. |
| DuplicateDescription | String | Description of the duplicate expense item. |
| DuplicateMerchantName | String | Name of the merchant where the duplicate expense was incurred. |
| DuplicateStartDate | Date | Date when the duplicate expense occurred or the first day of a duplicate expense that spans multiple days. |
| DuplicateEndDate | String | Last day of the duplicate expense that spans multiple days. |
| DuplicateCreationDate | Datetime | Date and time when the row of duplicate expense was created. |
| DuplicateCreationMethodCode | String | Code that indicates the method of duplicate expense item creation. |
| DuplicateExpenseType | String | Expense type against which the duplicate expense is incurred. |
| DuplicateExpenseReportId | Long | Value that uniquely identifies a specific expense report of the duplicate expense. |
| DuplicateExpenseStatusCode | String | Expense report approval status of the duplicate expense, such as Approved, Pending Manager Approval, or Paid. |
| DuplicateCreditCardTrxnId | Long | Value that uniquely identifies a specific corporate card transaction of the duplicate expense. |
| DuplicateExpenseReportNumber | String | Unique number that references the expense report of a duplicate expense. The number follows the numbering policies of the company. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BusinessUnit | String | BusinessUnit |
| ExpenseReportId | Long | ExpenseReportId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |