ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines
ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines
Columns
| Name | Type | Description |
| ExpenseAccommodationsPoliciesAccommodationsPolicyId [KEY] | Long | ExpenseAccommodationsPoliciesAccommodationsPolicyId of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| PolicyLineId [KEY] | Long | PolicyLineId of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| AccommodationsPolicyId | Long | AccommodationsPolicyId of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| TypeOfRateCode | String | TypeOfRateCode of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| DailyLimit | Double | DailyLimit of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| CurrencyCode | String | CurrencyCode of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| Currency | String | Currency of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| StartDate | Date | StartDate of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| EndDate | Date | EndDate of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| RoleId | Long | RoleId of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| RoleName | String | RoleName of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| GeographyId | Long | GeographyId of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| ZoneCode | String | ZoneCode of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| Zone | String | Zone of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| GeolocName | String | GeolocName of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| RawCountry | String | RawCountry of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| RawState | String | RawState of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| RawCounty | String | RawCounty of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| RawCity | String | RawCity of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| SeasonStartMonth | Int | SeasonStartMonth of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| SeasonStartDay | Int | SeasonStartDay of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| SeasonEndMonth | Int | SeasonEndMonth of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| SeasonEndDay | Int | SeasonEndDay of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| StatusCode | String | StatusCode of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| Status | String | Status of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| CreationDate | Datetime | CreationDate of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| CreatedBy | String | CreatedBy of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| LastUpdateDate | Datetime | LastUpdateDate of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| LastUpdatedBy | String | LastUpdatedBy of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
| LastUpdateLogin | String | LastUpdateLogin of ExpenseAccommodationsPoliciesexpenseAccommodationsPolicyLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |