LocationsLov
LocationsLov
Columns
| Name | Type | Description |
| LocationId [KEY] | Long | LocationId of LocationsLov |
| EffectiveStartDate [KEY] | Date | EffectiveStartDate of LocationsLov |
| EffectiveEndDate [KEY] | Date | EffectiveEndDate of LocationsLov |
| LocationCode | String | LocationCode of LocationsLov |
| LocationName | String | LocationName of LocationsLov |
| ActiveStatus | String | ActiveStatus of LocationsLov |
| CountryCode | String | CountryCode of LocationsLov |
| CountryName | String | CountryName of LocationsLov |
| Region1 | String | Region1 of LocationsLov |
| Region2 | String | Region2 of LocationsLov |
| TownOrCity | String | TownOrCity of LocationsLov |
| PostalCode | String | PostalCode of LocationsLov |
| SetId | Long | SetId of LocationsLov |
| SetCode | String | SetCode of LocationsLov |
| SetName | String | SetName of LocationsLov |
| SingleLineAddress | String | SingleLineAddress of LocationsLov |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BusinessUnitId | Long | BusinessUnitId |
| BusinessUnitName | String | BusinessUnitName |
| EmployeeLocFlag | Bool | EmployeeLocFlag |
| EmployeeLocationFlag | Bool | EmployeeLocationFlag |
| FetchBlankInvOrgLocation | Bool | FetchBlankInvOrgLocation |
| FetchBlankInvOrgLocations | Bool | FetchBlankInvOrgLocations |
| FilterAttributes | String | FilterAttributes |
| IncludeCommonSet | Bool | IncludeCommonSet |
| InventoryOrgId | Long | InventoryOrgId |
| InventoryOrganizationId | Long | InventoryOrganizationId |
| IsShipToSiteLocation | Bool | IsShipToSiteLocation |
| LegalEmpId | Long | LegalEmpId |
| LegalEmployerId | Long | LegalEmployerId |
| SearchTerms | String | SearchTerms |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |