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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |