ExpenseTemplatesmobileExpenseTypes
ExpenseTemplatesmobileExpenseTypes
Columns
| Name | Type | Description |
| ExpenseTemplatesExpenseTemplateId [KEY] | Long | ExpenseTemplatesExpenseTemplateId of ExpenseTemplatesmobileExpenseTypes |
| PersonId | Long | PersonId of ExpenseTemplatesmobileExpenseTypes |
| BUId | Long | BUId of ExpenseTemplatesmobileExpenseTypes |
| ExpenseTemplateId | Long | ExpenseTemplateId of ExpenseTemplatesmobileExpenseTypes |
| ExpenseTypeId [KEY] | Long | ExpenseTypeId of ExpenseTemplatesmobileExpenseTypes |
| ExpenseTypeName | String | ExpenseTypeName of ExpenseTemplatesmobileExpenseTypes |
| StartDate | Date | StartDate of ExpenseTemplatesmobileExpenseTypes |
| EndDate | Date | EndDate of ExpenseTemplatesmobileExpenseTypes |
| ExpenseCategoryCode | String | ExpenseCategoryCode of ExpenseTemplatesmobileExpenseTypes |
| ExpenseCategory | String | ExpenseCategory of ExpenseTemplatesmobileExpenseTypes |
| ReceiptRequiredCode | String | ReceiptRequiredCode of ExpenseTemplatesmobileExpenseTypes |
| ReceiptRequiredFlag | Bool | ReceiptRequiredFlag of ExpenseTemplatesmobileExpenseTypes |
| ProjectReceiptRequiredFlag | Bool | ProjectReceiptRequiredFlag of ExpenseTemplatesmobileExpenseTypes |
| JustificationAmount | Double | JustificationAmount of ExpenseTemplatesmobileExpenseTypes |
| ReceiptThresholdAmount | Double | ReceiptThresholdAmount of ExpenseTemplatesmobileExpenseTypes |
| CurrencyCode | String | CurrencyCode of ExpenseTemplatesmobileExpenseTypes |
| Currency | String | Currency of ExpenseTemplatesmobileExpenseTypes |
| EnableProjectsFlag | Bool | EnableProjectsFlag of ExpenseTemplatesmobileExpenseTypes |
| CodeCombinationId | Long | CodeCombinationId of ExpenseTemplatesmobileExpenseTypes |
| ItemizationOnlyFlag | Bool | ItemizationOnlyFlag of ExpenseTemplatesmobileExpenseTypes |
| ItemizationBehaviourCode | String | ItemizationBehaviourCode of ExpenseTemplatesmobileExpenseTypes |
| ItemizationBehaviour | String | ItemizationBehaviour of ExpenseTemplatesmobileExpenseTypes |
| TopLevelExpenseTypeFlag | Bool | TopLevelExpenseTypeFlag of ExpenseTemplatesmobileExpenseTypes |
| TaxClassificationCode | String | TaxClassificationCode of ExpenseTemplatesmobileExpenseTypes |
| TaxClassification | String | TaxClassification of ExpenseTemplatesmobileExpenseTypes |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindDate | Date | bindDate |
| BindOrgId | Long | bindOrgId |
| Finder | String | finder |