SA_WRHSE_MSTR
This is a warehouse master table that stores warehouse master details. It supports inventory and logistics transactions by standardizing warehouse identification and mapping.
Process: INVENTORY · Component: BasStockAdmn · Table type: Master Table Category: Provides warehouse master setup for inventory, storage, and logistics transactions.
Primary key
WRHSE_WAREHOUSE_ID, WRHSE_WAREHOUSE_OU
Columns (40)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | WRHSE_WAREHOUSE_OU 🔑 | Char | Warehouse Organization Unit instance |
| 2 | WRHSE_WAREHOUSE_ID 🔑 | #N/A | Warehouse ID |
| 3 | WRHSE_DSCRPTN | #N/A | Warehouse description |
| 4 | WRHSE_DSCRPTN_UP | #N/A | Warehouse description in uppercase |
| 5 | WRHSE_STATUS | #N/A | Warehouse status (e.g., Active, Inactive) |
| 6 | WRHSE_CATEGORY | #N/A | Warehouse category |
| 7 | WRHSE_STRGE_TYPE | #N/A | Warehouse storage type |
| 8 | WRHSE_INCHRGE_CODE | #N/A | Code of the person in charge of the warehouse |
| 9 | WRHSE_NETTABLE | #N/A | Nettable flag for MRP purposes |
| 10 | WRHSE_ADDRESS | #N/A | Warehouse address |
| 11 | WRHSE_CITY | #N/A | Warehouse city |
| 12 | WRHSE_STATE | #N/A | Warehouse state |
| 13 | WRHSE_ZIP | #N/A | Warehouse postal/ZIP code |
| 14 | WRHSE_CNTRY | #N/A | Warehouse country |
| 15 | WRHSE_CAPACITY_CONSTRAINT | decimal | Capacity constraints of the warehouse |
| 16 | WRHSE_VOLUME | Char | Warehouse volume |
| 17 | WRHSE_VOLUME_UOM | decimal | Warehouse volume Unit of Measure |
| 18 | WRHSE_WEIGHT | Char | Warehouse weight capacity |
| 19 | WRHSE_WEIGHT_UOM | Char | Warehouse weight Unit of Measure |
| 20 | WRHSE_USER_DEF_1 | Char | User-defined field 1 for warehouse |
| 21 | WRHSE_USER_DEF_2 | Char | User-defined field 2 for warehouse |
| 22 | WRHSE_LINK_FLAG | Char | Flag indicating if warehouse is linked to other records |
| 23 | WRHSE_FILE_NAME | Char | Warehouse-related file name |
| 24 | WRHSE_CREATED_BY | Datetime | User who created the warehouse record |
| 25 | WRHSE_CREATED_DATE | Char | Warehouse record creation date |
| 26 | WRHSE_MODIFIED_BY | Datetime | User who last modified the warehouse record |
| 27 | WRHSE_MODIFIED_DATE | #N/A | Warehouse record last modified date |
| 28 | WRHSE_TIMESTAMP | Char | Timestamp of the warehouse record |
| 29 | WRHSE_FIN_BOOK | Char | Financial book associated with the warehouse |
| 30 | WRHSE_BACKFLUSH_FLAG | Char | Flag indicating if backflush is applicable |
| 31 | WRHSE_ALLTRNTYPE_FLAG | Char | Flag indicating if all transaction types are allowed |
| 32 | WRHSE_ALLPRTTYPE_FLAG | Char | Flag indicating if all part types are allowed |
| 33 | WRHSE_ALLSTKSTS_FLAG | varchar | Flag indicating if all stock statuses are allowed |
| 34 | WRHSE_STORAGE_LOCATION | varchar | Warehouse storage location code |
| 35 | WRHSE_OFFLINE | varchar | Flag for offline usage |
| 36 | WRHSE_OFFLINE_AREA | varchar | Offline area of the warehouse |
| 37 | WRHSE_ALW_OFFLINE_USG | varchar | Flag indicating if offline usage is allowed |
| 38 | WRHSE_WH_GROUP | varchar | Warehouse group code |
| 39 | WRHSE_TAX_REGION | varchar | Warehouse tax region |
| 40 | WRHSE_MRP_NETTABLE | — | Material Requirements Planning ( MRP ) nettable flag for the warehouse |
Sample rows (from live DB)
WRHSE_WAREHOUSE_OU | WRHSE_WAREHOUSE_ID | WRHSE_DSCRPTN | WRHSE_DSCRPTN_UP | WRHSE_STATUS | WRHSE_CATEGORY |
|---|---|---|---|---|---|
| 2.0 | 00101 | Warehouse 1 | WAREHOUSE 1 | A | — |
| 2.0 | 0100 | Test Warehouse3_RDS | TEST WAREHOUSE3_RDS | A | Main |
| 2.0 | 0111 | Test Warehouse | TEST WAREHOUSE | A | ROUTE |
Showing 3 of 1,381 rows.