LocationsLovV2
LocationsLovV2
Columns
| Name | Type | Description |
| LocationId [KEY] | Long | LocationId of LocationsLovV2 |
| EffectiveStartDate [KEY] | Date | EffectiveStartDate of LocationsLovV2 |
| EffectiveEndDate [KEY] | Date | EffectiveEndDate of LocationsLovV2 |
| LocationCode | String | LocationCode of LocationsLovV2 |
| LocationName | String | LocationName of LocationsLovV2 |
| TownOrCity | String | TownOrCity of LocationsLovV2 |
| PostalCode | String | PostalCode of LocationsLovV2 |
| CountryName | String | CountryName of LocationsLovV2 |
| SetName | String | SetName of LocationsLovV2 |
| AddressLine1 | String | AddressLine1 of LocationsLovV2 |
| AddressLine2 | String | AddressLine2 of LocationsLovV2 |
| AddressLine3 | String | AddressLine3 of LocationsLovV2 |
| AddressLine4 | String | AddressLine4 of LocationsLovV2 |
| State | String | State of LocationsLovV2 |
| Province | String | Province of LocationsLovV2 |
| County | String | County of LocationsLovV2 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ActiveStatus | String | ActiveStatus |
| BusinessGroupId | Long | BusinessGroupId |
| EffectiveDate | Date | EffectiveDate |
| EmployeeLocationFlag | Bool | EmployeeLocationFlag |
| FetchBlankInvOrgLocations | Bool | FetchBlankInvOrgLocations |
| FilterAttributes | String | FilterAttributes |
| InventoryOrganizationId | Long | InventoryOrganizationId |
| IsShipToSiteLocation | Bool | IsShipToSiteLocation |
| SearchTerms | String | SearchTerms |
| SetId | Long | SetId |
| Finder | String | finder |