ExpenseTemplates
ExpenseTemplates
Columns
| Name | Type | Description |
| ExpenseTemplateId [KEY] | Long | ExpenseTemplateId of ExpenseTemplates |
| OrgId | Long | OrgId of ExpenseTemplates |
| BusinessUnit | String | BusinessUnit of ExpenseTemplates |
| Name | String | Name of ExpenseTemplates |
| Description | String | Description of ExpenseTemplates |
| StartDate | Date | StartDate of ExpenseTemplates |
| InactiveDate | Date | InactiveDate of ExpenseTemplates |
| DfltCcExpTypeId | Long | DfltCcExpTypeId of ExpenseTemplates |
| EnableCcMappingFlag | Bool | EnableCcMappingFlag of ExpenseTemplates |
| CreationDate | Datetime | CreationDate of ExpenseTemplates |
| CreatedBy | String | CreatedBy of ExpenseTemplates |
| LastUpdateDate | Datetime | LastUpdateDate of ExpenseTemplates |
| LastUpdatedBy | String | LastUpdatedBy of ExpenseTemplates |
| LastUpdateLogin | String | LastUpdateLogin of ExpenseTemplates |
| CashReceiptRequiredFlag | Bool | CashReceiptRequiredFlag of ExpenseTemplates |
| CashReceiptRequiredLimit | Double | CashReceiptRequiredLimit of ExpenseTemplates |
| CcReceiptRequiredFlag | Bool | CcReceiptRequiredFlag of ExpenseTemplates |
| CcReceiptRequiredLimit | Double | CcReceiptRequiredLimit of ExpenseTemplates |
| NegativeRcptRequiredFlag | Bool | NegativeRcptRequiredFlag of ExpenseTemplates |
| AllowRcptMissingFlag | Bool | AllowRcptMissingFlag of ExpenseTemplates |
| DispRcptViolationFlag | Bool | DispRcptViolationFlag of ExpenseTemplates |
| DescriptionBehaviourCode | String | DescriptionBehaviourCode of ExpenseTemplates |
| DescriptionBehaviour | String | DescriptionBehaviour of ExpenseTemplates |
| LocationBehaviourCode | String | LocationBehaviourCode of ExpenseTemplates |
| LocationBehaviour | String | LocationBehaviour of ExpenseTemplates |
| NumberOfDaysBehaviourCode | String | NumberOfDaysBehaviourCode of ExpenseTemplates |
| NumberOfDaysBehaviour | String | NumberOfDaysBehaviour of ExpenseTemplates |
| MerchantBehaviourCode | String | MerchantBehaviourCode of ExpenseTemplates |
| MerchantBehaviour | String | MerchantBehaviour of ExpenseTemplates |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindDate | Date | bindDate |
| BindOrgId | Long | bindOrgId |
| Finder | String | finder |