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 |