DW_NS_location_D
This table contains information on location.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Id | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| fullname | VARCHAR2 | 999 | Full Name | ||||
| name | VARCHAR2 | 128 | Name | ||||
| allowstorepickup | VARCHAR2 | 16 | Allow Store Pickup | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| makeinventoryavailable | VARCHAR2 | 16 | Make Inventory Available | ||||
| locationtype | NUMBER | 38 | 0 | Location Type | DW_NS_LOCATIONTYPE_D | id | |
| mainaddress | NUMBER | 38 | 0 | Address | DW_NS_WorkplaceMainAddress_D | nkey | |
| tranprefix | VARCHAR2 | 16 | Document Number Prefix | ||||
| subsidiary | VARCHAR2 | 999 | Subsidiary | ||||
| latitude | NUMBER | Latitude | |||||
| longitude | NUMBER | Longitude | |||||
| lastmodifieddate | TIMESTAMP | Last Modified Date | |||||
| parent | NUMBER | 38 | 0 | Parent Location | DW_NS_location_D | id |