Locations
Locations
Columns
| Name | Type | Description |
| LocationId [KEY] | Long | System generated primary key column. |
| SetId | Long | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. |
| ActiveStatus | String | Represents whether or not the location is active. |
| EmployeeLocationFlag | Bool | Represents whether or not the location is an Employee Location. |
| TelephoneNumber1 | String | TelephoneNumber1 of Locations |
| TelephoneNumber2 | String | TelephoneNumber2 of Locations |
| TelephoneNumber3 | String | TelephoneNumber3 of Locations |
| EmailAddress | String | Represents the email address of the location. |
| ShipToSiteFlag | Bool | Indicates the location is a ship to site. |
| ReceivingSiteFlag | Bool | Indicates the location is a receiving site. |
| BillToSiteFlag | Bool | Indicates the location is a bill to site. |
| OfficeSiteFlag | Bool | Indicates the location is an office site. |
| StandardWorkingHours | Double | Number of standard working hours |
| StandardWorkingFrequency | String | Frequency for the standard working hours |
| StandardAnnualWorkingDuration | Double | The standard annual working duration for the location. |
| AnnualWorkingDurationUnits | String | The unit of measure in hours, days, weeks, or months for the standard annual working duration. |
| LocationCode | String | Location Code |
| LocationName | String | Location Name |
| Description | String | Description for the location. |
| MainAddressId | Long | MainAddressId of Locations |
| AddressLine1 | String | First line of address |
| AddressLine2 | String | Second line of address |
| AddressLine3 | String | Third line of address |
| AddressLine4 | String | Fourth line of address |
| Country | String | Country of the address |
| PostalCode | String | Postal code of the address |
| Region1 | String | Primary region in which the address is located. |
| Region2 | String | Sub-region of Region 1. |
| Region3 | String | Sub-region of Region 2. |
| TownOrCity | String | Name of the Town or City for the address |
| EffectiveStartDate [KEY] | Date | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. |
| EffectiveEndDate [KEY] | Date | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
| CreationDate | Datetime | CreationDate of Locations |
| LastUpdateDate | Datetime | LastUpdateDate of Locations |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |