RequisitionOneTimeLocations
Maintains ad-hoc delivery addresses (for example, temporary job sites) for requisitions, capturing non-standard ship-to details.
Columns
| Name | Type | Description |
| AddrElementAttribute1 | String | The first additional address element used to support a flexible address format, often used for customized address fields. Example: 'Suite 101' for an office suite. |
| AddrElementAttribute2 | String | The second additional address element used to support a flexible address format, providing extra address information. Example: 'Building B' for a specific building within a complex. |
| AddrElementAttribute3 | String | The third additional address element, allowing further customization for address formats. Example: 'Floor 3' for specifying the floor in a multi-floor building. |
| AddrElementAttribute4 | String | The fourth additional address element used to capture any other address-related information that does not fit into standard fields. Example: 'North Wing'. |
| AddrElementAttribute5 | String | The fifth additional address element for capturing additional flexible address details. Example: 'Behind the main entrance' to provide further location details. |
| Address1 | String | The first line of the address, typically used for the street address or primary address field. Example: '123 Main St'. |
| Address2 | String | The second line of the address, typically used for suite, apartment, or additional location information. Example: 'Apt. 4B'. |
| Address3 | String | The third line of the address, used when more address information is needed. Example: 'Building 5'. |
| Address4 | String | The fourth line of the address, used to capture any additional address information if necessary. Example: 'Room 101'. |
| LocationId [KEY] | Long | The unique identifier for the location, linking the address details to the specific location record. Example: 12345 for Location ID 12345. |
| AddressLinesPhonetic | String | A phonetic representation of the address, used to help with pronunciation or speech recognition systems. Example: 'One-two-three Main Street' for a simplified address pronunciation. |
| Building | String | The specific name or number of the building at the given address, used to differentiate between buildings within a complex. Example: 'Building A' in a multi-building campus. |
| City | String | The name of the city mentioned in the address, helping to identify the geographic location. Example: 'New York'. |
| CountryCode | String | The country code used for identifying the country in international address formats. Example: 'US' for the United States. |
| County | String | The county mentioned in the address, often used for locations within certain regions or jurisdictions. Example: 'Los Angeles County'. |
| FloorNumber | String | The floor number within the building or complex, helping to identify the specific level of a building. Example: '2' for the second floor. |
| PostalCode | String | The postal code (ZIP code) of the address, used for sorting mail and geographic identification. Example: '90210' for a postal code in Beverly Hills. |
| PostalPlus4Code | String | The four-digit extension to the U.S. postal ZIP code, providing more precise delivery information. Example: '90210-1234' for an extended ZIP code. |
| Province | String | The province mentioned in the address, often used for regions in countries like Canada or other jurisdictions. Example: 'Ontario'. |
| State | String | The state mentioned in the address, helping to further identify the geographic region. Example: 'California'. |
| FormattedAddress | String | The fully formatted address, combining all address elements into a single string for easy reading or output. Example: '123 Main St, Apt. 4B, New York, NY 10001'. |
| Country | String | The country mentioned in the address, identifying the nation where the location is situated. Example: 'United States'. |
| CreatedBy | String | The username or identifier of the person who created the location record. Example: 'admin' for the administrator who created the address. |
| CreationDate | Datetime | The date and time when the location record was created. Example: '2023-06-01 10:00:00' for the creation timestamp. |
| LastUpdatedBy | String | The username or identifier of the person who last updated the location record. Example: 'jdoe' for 'John Doe'. |
| LastUpdateDate | Datetime | The date and time when the location record was last updated. Example: '2023-06-10 15:00:00' for the last update timestamp. |
| Finder | String | A reference or placeholder used for searching and locating specific location records in the system. Example: 'Search by Location ID' or 'Search by City'. |