Storage Administration

Table Name SA_BIN_MSTR

Table Comment Facility to define a bin Under a "Normal" zone, bins can be defined where items are stored. A bin is a storage area that can be specifically allocated for storage of a particular item.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BIN_WEIGHT_UOM

varchar(40)

NULL

Bin Weight UOM - It is the Unit of Measurement in which the Total Weight of part to be stored under Bin

No

No

BIN_REMARKS

varchar(255)

NULL

Bin Remarks

No

No

BIN_WEIGHT

numeric(28,8)

NULL

Bin Weight - It is the Total Weight of part to be stored under Bin

No

No

BIN_VOLUME_UOM

varchar(40)

NULL

Bin Volume UOM - It is the Unit of Measurement in which the Capacity of Volume of part to be stored under Bin

No

No

BIN_VOLUME

numeric(28,8)

NULL

Bin Volume - Capacity of Volume of part to be stored under Bin

No

No

BIN_MODIFIED_BY

varchar(30)

NOT NULL

User who has modified the record.

No

No

BIN_MODIFIED_DATE

datetime

NOT NULL

User record modified date

No

No

BIN_FILE_NAME

varchar(50)

NULL

File Name

No

No

BIN_CREATED_DATE

datetime

NOT NULL

User record created date

No

No

BIN_CREATED_BY

varchar(30)

NOT NULL

User who has created the record.

No

No

BIN_TIMESTAMP

numeric(10)

NOT NULL

Timestamp of a record.

No

No

BIN_ZONE_ID

varchar(10)

NOT NULL

To specify to which zone this bin is attached to.

Yes

Yes

BIN_BIN_ID

varchar(10)

NOT NULL

Facility to define a bin Under a "Normal" zone, bins can be defined where items are stored. A bin is a storage area that can be specifically allocated for storage of a particular item.

Yes

No

BIN_DSCRPTN

varchar(150)

NOT NULL

Description of Bin

No

No

BIN_WAREHOUSE_ID

varchar(10)

NOT NULL

To specify to which warehouse this bin is attached to.

Yes

Yes

BIN_WAREHOUSE_OU

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

BIN_PLACEMENT_PRIORITY

numeric(10)

NULL

Bin Placement Priority

No

No

BIN_CAPACITY_CONSTRAINT

varchar(5)

NULL

Capacity constraint UOM for the warehouse-Zone-Bin. This indicates the UOM which is used to represent the max capacity which the warehouse-Zone-Bin can handle Following lists the values and their BE Codes "Not Required"     -  ’NReqd’,   "Volume"              -  ’Vol’ "Weight"               -  ’Wght’ "Quantity".            -  ’Qty’

No

No

BIN_PROXIMITY_INDICATOR

varchar(5)

NULL

Proximity Indicator will have the following codes and description. "Near"               - ’Near’ "Medium"          - ’Mdm’ "Far"                 - ’Far’ "Space".           - ’Spc’

No

No

BIN_DSCRPTN_UP

varchar(150)

NOT NULL

Bin Description in Upper Case

No

No

BIN_STATUS_CODE

varchar(5)

NOT NULL

A bin can be disabled only if it does not have any stock. A zone can be disabled only if that zone and its associated bins does not have any stock. When a zone is disabled, all the bins associated with it will be automatically disabled. A warehouse can be disabled only if all the zones/bins defined under it not have any stock. Also, if a warehouse is disabled, all its associated zones and bins will get disabled automatically. A bin can be enabled only if the zone under which it falls is enabled. A zone can be enabled only if the warehouse under which it falls is enabled. Status - A/D

No

No

BIN_PCKNG_PRTY

numeric(10)

NULL

Facility to specify "picking priority" for bins. The component provides facility to specify picking priority for the various bins in a warehouse. As far as bins are concerned, we can prioritize similar items stored in different bin locations by assigning priority numbers to the bins. Based on this prioritization, the system will check for availability of stock at the time of hard allocation.

No

No

Table Name SA_CUSTKALC_WHZNBN_CUST_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

CUSTKALC_WAREHOUSE_OU

int

NOT NULL

Warehouse Ou Instance

No

No

CUSTKALC_WAREHOUSE_ID

varchar(10)

NOT NULL

Warehouse Id

No

No

CUSTKALC_ZONE_ID

varchar(10)

NOT NULL

Zone Id

No

No

CUSTKALC_BIN_ID

varchar(10)

NULL

Bin Id

No

No

CUSTKALC_CUST_CRT_OU

int

NOT NULL

Ouinstance

No

No

CUSTKALC_CUST_CODE

varchar(18)

NOT NULL

cust code

No

No

CUSTKALC_STORAGE_CAT

varchar(25)

NULL

storage category

No

No

CUSTKALC_STORAGE_RULE

varchar(5)

NULL

storage Rule

No

No

CUSTKALC_TIMESTAMP

int

NOT NULL

Timestamp record

No

No

Table Name SA_EXT_STORAGE_ALLOC

Table Comment This table contains the Trading Partner details for the given Warehouse/Zone/Bin. This table helps to identify whether the Warehouse/Zone/Bin is owned by External Party i.e Owned by Customer/Supplier Parts.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SA_EXT_STORAGE_CAT

varchar(5)

NOT NULL

Storage Category (Exclusive/Shared)

No

No

SA_EXT_DEF_LOCN

varchar(5)

NOT NULL

Default Locn (Yes/No)

No

No

SA_EXT_TRD_PARTNER_TYPE

varchar(25)

NOT NULL

Trading Partner Type (Customer/Supplier)

Yes

No

SA_EXT_STORAGE_RULE

varchar(25)

NULL

Storage Rule (Only At/Also At)

No

No

SA_EXT_TIMESTAMP

int

NULL

Timestamp of a Record

No

No

Sa_timestamp

int

NOT NULL

Timestamp 

No

No

SA_EXT_WAREHOUSE_ID

varchar(10)

NOT NULL

To define warehouse code unique at Company level or Organization unit level

Yes

Yes

SA_EXT_WAREHOUSE_OU

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

SA_EXT_TRD_PARTNER_CODE

varchar(45)

NOT NULL

Trading Partner Code

Yes

No

SA_EXT_ZONE_ID

varchar(10)

NOT NULL

Zone for the Warehouse Code

Yes

No

SA_EXT_BIN_ID

varchar(10)

NOT NULL

Bin for the Spec Warehouse/Zone

Yes

No

Table Name SA_ITMTP_ITMTYPS_ALLWD

Table Comment Used &nbspto store the Item types allowed in a warehouse.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ITMTP_MODIFIED_BY

varchar(30)

NOT NULL

User who has modified the record.

No

No

ITMTP_CREATED_DATE

datetime

NOT NULL

User record created date

No

No

ITMTP_MODIFIED_DATE

datetime

NOT NULL

User record modified date

No

No

ITMTP_TIMESTAMP

numeric(10)

NOT NULL

Timestamp of a record.

No

No

ITMTP_WAREHOUSE_OU

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

ITMTP_CREATED_BY

varchar(30)

NOT NULL

User who has created the record.

No

No

ITMTP_WAREHOUSE_ID

varchar(10)

NOT NULL

Warehouse code

Yes

Yes

ITMTP_ITEM_TYPE

varchar(25)

NOT NULL

Various item types allowed in a Warehouse code. ITMTP_ITEM_TYPE - RWMTR CMPNT CNSMB INTRM FNPRD UTLTY SPRPT TOOL

Yes

No

Table Name Sa_Parameter_Details

Table Comment This table holds the meta data for the component. This table will exist in all the component as part of the component. This table will hold the static values like combos, combo defaults, guidance text etc. Values are stored against the screen control. This table is required to support multi-language.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

Sa_ComponentName

varchar(80)

NOT NULL

Name of the component

Yes

No

Sa_ParamCategory

varchar(10)

NOT NULL

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

Yes

No

Sa_ParamType

varchar(25)

NOT NULL

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

Yes

No

Sa_ParamCode

varchar(5)

NOT NULL

Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

Yes

No

Sa_LangId

numeric(10)

NOT NULL

Language id. This is the language id of the record.

Yes

No

Sa_ParamDesc

varchar(80)

NULL

Description of the combo value

No

No

Sa_Sort_By

numeric(10)

NULL

The order in which the values are populated.

No

No

Table Name Sa_SaAlloc_WhZnbn_Part_Dtl

Table Comment This table contains the storage allocation rules for a part that is stored in a warehouse. Allocation rules dictates the warehouse storage rules (whether the warehouse will have other parts stored Or only this part can be stored, etc) and the part storage rules (whether the part will be stored only in the warehouse-zn-bn or someother wh-zn-bn etc).

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SaAlloc_Storage_Cat

varchar(25)

NULL

Following are the codes and their descriptions Excl           - Exclusive Shrd          - Shared

No

No

SaAlloc_Part_No

varchar(40)

NOT NULL

Part No for which storage allocation is defined

Yes

No

SaAlloc_Storage_Rule

varchar(5)

NULL

Storage Rule will be either ’Only At’ or ’Also At’. If ’Only At’, it means the part can be stored only in that zone-bin of the warehouse. If ’Also At’, then the part can be stored in other zone-bins of the warehouse. Following are the codes and their descriptions OnlAt        -  Only At AlsAt          -  Also At

No

No

SaAlloc_Constrnt_Qty_InStkUom

decimal(28,8)

NULL

Max Capacity Constraint in stock uom

No

No

SAALLOC_TIMESTAMP

numeric(28)

NULL

Timestamp of a record.

No

No

SaAlloc_Warehouse_Id

varchar(10)

NOT NULL

To specify to which warehouse this bin is attached to.

Yes

Yes

SaAlloc_Warehouse_Ou

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

SaAlloc_Part_Crt_Ou

numeric(28)

NOT NULL

Created OU of the Part for which storage allocation is defined.

Yes

No

SaAlloc_Zone_Id

varchar(10)

NOT NULL

To specify to which zone this bin is attached to. Will be ## if the Warehouse is ’Free’

Yes

Yes

SaAlloc_Bin_Id

varchar(10)

NOT NULL

Facility to define a bin Under a "Normal" zone, bins can be defined where items are stored. A bin is a storage area that can be specifically allocated for storage of a particular item. Will be ## if the Zone is ’Free’

Yes

Yes

Table Name SA_SaQc_Quick_Code

Table Comment The Storage admin Quick Code master table which stores the quick codes defined by the user

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SaQc_OUInstance

numeric(10)

NOT NULL

OUinstance

Yes

No

SaQc_Quick_Code

varchar(25)

NOT NULL

Quick Code

Yes

No

SaQc_Type

varchar(25)

NOT NULL

Quick Code Type . It takes value WHC - Warehouse Category.

Yes

No

SaQc_Desc

varchar(80)

NULL

Quick Code Description

No

No

SaQc_Status

varchar(20)

NULL

Quick Code Status. It takes values, A - Active I - Inactive

No

No

SaQc_CreatedDate

datetime

NULL

Date in which record is created.

No

No

SaQc_Created_By

varchar(30)

NULL

User Id of the user who created.

No

No

SaQc_ModifiedDate

datetime

NULL

Date in which modification is done.

No

No

SaQc_Modified_By

varchar(30)

NULL

User Id of the user who modified.

No

No

SaQc_Timestamp

numeric(10)

NULL

Timestamp of the record for concorrency check.

No

No

Table Name SA_SaTrn_Function_Tran_Meta

Table Comment Contains the various transaction types that are applicable to be mapped for a warehouse.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SaTrn_tran_type

varchar(25)

NOT NULL

The following are the various transaction types which uses numbering class. Metadata will be available only for these transaction types. MaintIssue Upr Gr

Yes

No

SaTrn_function_code

varchar(25)

NOT NULL

The following are the various function codes that will be available in the metadata... INV

Yes

No

SaTrn_transaction_code

varchar(25)

NOT NULL

This is nothing but the component code which is displayed as transaction to the user. The following are the various transaction codes that will be available in the metadata... BASIssue BASRECEIPT BasGoodsRcpt

Yes

No

SaTrn_function_name

varchar(25)

NOT NULL

The following are the various function names that will be available in the metadata... Inventory

No

No

SaTrn_transaction_desc

varchar(80)

NOT NULL

This is nothing but the component desc which is displayed as transaction desc to the user The following are the various transaction desc that will be available in the metadata... Stock Issue Stock Receipt Goods Receipt

No

No

SaTrn_tran_type_desc

varchar(80)

NULL

The following are the description for the various transaction type for which metadata entries will be available. Maintenance Issue Unplanned Receipt Goods Receipt

No

No

Table Name SA_STCKS_STCKSTS_ALLWD

Table Comment Used to store the user defined stock statuses that are allowed in the warehouse

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

STCKS_ACC_New

varchar(16)

NULL

Allowable Component Condition of the Warehouse  -- New

No

No

STCKS_TIMESTAMP

numeric(10)

NOT NULL

Timestamp of a record.

No

No

STCKS_MODIFIED_DATE

datetime

NOT NULL

User record modified date

No

No

STCKS_ACC_Overhauled

varchar(16)

NULL

Allowable Component Condition of the Warehouse  -- Overhauled

No

No

STCKS_ACC_Serviceable

varchar(16)

NULL

Allowable Component Condition of the Warehouse  -- serviceable

No

No

STCKS_ACC_UnServiceable

varchar(16)

NULL

Allowable Component Condition of the Warehouse  -- unserviceable

No

No

STCKS_ACC_Phased_Out

varchar(16)

NULL

Allowable Component Condition of the Warehouse  -- Phased-Out

No

No

STCKS_WAREHOUSE_ID

varchar(10)

NULL

Warehouse code

Yes

Yes

STCKS_WAREHOUSE_OU

numeric(10)

NULL

Organization Unit.

Yes

Yes

STCKS_MODIFIED_BY

varchar(30)

NULL

User who has modified the record.

No

Yes

STCKS_CREATED_DATE

datetime

NULL

User record created date

Yes

STCKS_STATUS

varchar(40)

NULL

User defined Part Status (as defined in UDSS component) code. A warehouse can be maintaining parts which are of particular status. These user defined part statuses are mapped to the Warehouse indicating that the warehouse is capable of storing parts in these part statuses

Yes

Yes

STCKS_CREATED_BY

varchar(30)

NULL

User who has created the record.

No

Yes

Table Name SA_Strgy_Storage_Strategy

Table Comment This table contains the storage strategies for a part that is to be stored in a warehouse. These Storage Strategies helps to identify the zone-bin from where the part has to be picked up and the zone-bin where the part has to be placed

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

STRGY_MAX_QTY

numeric(28,8)

NULL

Maximum quantity that can be maintained for the part which is of ’Min-Max’ planning type

No

No

STRGY_SAFETY_STOCK

varchar(18)

NULL

This contains the safety stock for parts

No

No

STRGY_MIN_QTY

numeric(28,8)

NULL

Minimum quantity that can be maintained for the part which is of ’Min-Max’ planning type

No

No

Strgy_Def_Picking_Bin_Id

numeric(28,8)

NULL

Default Picking Bin Id

No

No

Strgy_Def_Picking_Zone_Id

varchar(10)

NULL

Default Picking Zone Id

No

No

STRGY_TRANSFER_LOCATION

varchar(18)

NULL

Stock Transfer Location [Transfer Processing Location]

No

No

STRGY_TRANSFER_WAREHOUSE

varchar(18)

NULL

Stock Transfer Warehouse

No

No

STRGY_REORDER_LVL

varchar(18)

NULL

This contains the reorder Level for parts of ’ReOrder’ planning type

No

No

STRGY_REORDER_ACTIVATED_BY

varchar(18)

NULL

Re-order activated by indicates the method of reordering at a location Following lists the RAB Codes and their description BPO   BPO NONE None PO    PO PR    PR ST    Stock Transfer

No

No

STRGY_REORDER_QTY

numeric(28,8)

NULL

This contains the reorder quantity for parts of ’ReOrder’ planning type

No

No

Strgy_Timestamp

numeric(28)

NULL

Timestamp of a record

No

No

Strgy_Part_Crt_Ou

numeric(28)

NOT NULL

Created OU of the Part for which storage strategy is defined.

Yes

No

Strgy_Part_No

varchar(40)

NOT NULL

Part No for which storage strategy is defined

Yes

No

Strgy_Warehouse_Id

varchar(10)

NOT NULL

To define warehouse code unique at Company level or Organization unit level

Yes

Yes

Strgy_Warehouse_Ou

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

Strgy_Picking_Strategy

varchar(25)

NULL

Following lists the code and description for ’Picking Priority’ LIFO                                - LIFO FIFO                                - FIFO Shelf Life Expiry               - ShLf Min Remaining Life          - MnLf Max Remaining Life         - MxLf Min Lot                            - MnLt Defalt Zone/Bin              - DfZB Manual                            - Mnl

No

No

Strgy_Def_Placement_Zone_Id

varchar(10)

NULL

Default placement Zone Id

No

No

Strgy_Def_Placement_Bin_Id

varchar(10)

NULL

Default placement Bin Id

No

No

STRGY_STOCK_STATUS

varchar(40)

NOT NULL

R6 - Stores the allowable Stock Status for the Warehouse

Yes

No

Strgy_Placement_Strategy

varchar(25)

NULL

Following lists the code and description for ’Placement Strategy’ Fixed Storage                   - FxStr Storage Proximity              - StrPx Existing Stock Addition     - ExSAd Next Empty storage          - NxESt Manual                             - Mnl

No

No

STRGY_TRD_PARTNER_CODE

varchar(45)

NOT NULL

R6 - Stores the Trading Partner Code (Customer/Supplier)

Yes

No

Table Name SA_TRNS_TRNSCTNS_ALLWD

Table Comment Used to store the transactions supported (like types of receipt, issue, etc.) in a warehouse.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TRNS_CREATED_DATE

datetime

NOT NULL

User record created date

No

No

TRNS_CREATED_BY

varchar(30)

NOT NULL

User who has created the record.

No

No

TRNS_MODIFIED_BY

varchar(30)

NOT NULL

User who has modified the record.

No

No

TRNS_MODIFIED_DATE

datetime

NOT NULL

User record modified date

No

No

TRNS_TIMESTAMP

numeric(10)

NOT NULL

Timestamp of a record.

No

No

TRNS_WAREHOUSE_ID

varchar(10)

NOT NULL

Warehouse code to which transactions apply.

Yes

Yes

TRNS_WAREHOUSE_OU

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

SaTrn_transaction_code

varchar(25)

NOT NULL

This is nothing but the component code which is displayed as transaction to the user. The following are the various transaction codes that will be available in the metadata... BASIssue BASRECEIPT BasGoodsRcpt

Yes

Yes

SaTrn_function_code

varchar(25)

NOT NULL

The following are the various function codes that will be available in the metadata... INV

Yes

Yes

TRNS_TRAN_TYPE

varchar(25)

NOT NULL

The following are the various transaction types which uses numbering class. Metadata will be available only for these transaction types. MAINTISSUE                UPR GR

Yes

Yes

Table Name SA_WHDA_DOC_ATTACH_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

WHDA_WAREHOUSE_ID

varchar(40)

NOT NULL

Warehouse code to which transactions apply.

Yes

No

WHDA_DOC_ID

varchar(18)

NOT NULL

The name of the file containing details of the warehouse (Alphanumeric, 40).

Yes

No

WHDA_REF_DOC_TYPE

varchar(15)

NOT NULL

Use the drop-down list to select the type of the reference document that is associated to the current business component. The system lists all the document types that are defined in the “Create Reference Document Type” activity of the “Common Master” business component. Leave this field blank if you do not wish to assign the document type. The system leaves the field blank by default.

Yes

No

WHDA_OUINSTANCE

decimal(10)

NOT NULL

Ou Instance

Yes

No

WHDA_FILE_NAME

varchar(50)

NULL

The file name used for reference (Alphanumeric, 30).

No

No

WHDA_REMARKS

varchar(255)

NULL

Remarks

No

No

Table Name SA_WhPln_Planning_Params

Table Comment The planning parameters of a part stored in a warehouse is defined in this table. This planning parameter will override the location level planning parameter for the part.   For e.g, a part is of ’Min-Max’ planning type. And minimum quantity is specified for this part at location level in PartAdmin. At warehouse level, if this minimum quantity is altered for this part, any receipt or issue of the stock from that warehouse will consider only this warehouse level minumum quantity and not the location level that is specified in PartAdmn.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

WhPln_Transfer_Location

numeric(10)

NULL

Stock Transfer Location [Transfer Processing Location]

No

No

WhPln_Source_Wh_Ou

numeric(10)

NULL

No

No

WhPln_ReOrder_Activated_By

varchar(5)

NULL

Re-order activated by indicates the method of reordering at a location Following lists the RAB Codes and their description BPO   BPO NONE None PO    PO PR    PR ST    Stock Transfer

No

No

WhPln_ReOrder_Qty

numeric(28,8)

NULL

This contains the reorder quantity for parts of ’ReOrder’ planning type

No

No

WHPLN_REPLENISH_QTY

decimal(28,8)

NULL

replishment quanity

No

No

WhPln_Source_Wh_Id

varchar(10)

NULL

Transferring location warehouse

No

No

WhPln_Timestamp

numeric(10)

NULL

timestamp

No

No

WhPln_Issue_Location

numeric(10)

NULL

Issue OU Instance (Transfer From Location)

No

No

WhPln_Plan_Horizon

numeric(5)

NULL

Planning Horizon Days

No

No

WhPln_Warehouse_Id

varchar(10)

NOT NULL

To define warehouse code unique at Company level or Organization unit level

Yes

Yes

WhPln_Part_Crt_Ou

numeric(10)

NOT NULL

Created OU of the Part for which storage strategy is defined.

Yes

No

WhPln_Warehouse_Ou

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

WhPln_ReOrder_Lvl

numeric(28,8)

NULL

This contains the reorder Level for parts of ’ReOrder’ planning type

No

No

WhPln_Safety_Stock

numeric(28,8)

NULL

Safety Stock Level

No

No

WhPln_Part_No

varchar(40)

NOT NULL

Part No for which storage strategy is defined

Yes

No

WhPln_Max_Qty

numeric(28,8)

NULL

Warehouse level maximum quantity that can be maintained for the part which is of ’Min-Max’ planning type

No

No

WhPln_Min_Qty

numeric(28,8)

NULL

Warehouse level minimum quantity that needs to be maintained for the part which is of ’Min-Max’ planning type

No

No

Table Name SA_WhUsr_Wh_User_Mapping

Table Comment This table contains the user access rights for a warehouse

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

WhUsr_Warehouse_Id

varchar(10)

NOT NULL

To define warehouse code unique at Company level or Organization unit level

Yes

Yes

WhUsr_User_Name

varchar(30)

NOT NULL

User Name

Yes

No

WhUsr_Warehouse_Ou

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

Table Name SA_WRHSE_MSTR

Table Comment "Warehouse basically represents the storage address for a part in a location. In this table we can define all the warehouses in an organization. Warehouse could be of type ’Normal’ or ’Free’ Warehouse created as a "Normal" warehouse will have zones under it. Such a type of warehouse helps to store items in a structured manner, which will facilitate easy traceability. Warehouse created as a ’Free’ warehouse will not have any zones under it. This will be done if all the items will be stored at bulk in the warehouse and the warehouse sizing is less."

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

WRHSE_WAREHOUSE_OU

numeric(10)

NOT NULL

Organization Unit.

Yes

No

WRHSE_WAREHOUSE_ID

varchar(10)

NOT NULL

To define warehouse code unique at Company level or Organization unit level

Yes

No

WRHSE_DSCRPTN

varchar(80)

NOT NULL

This column is used for storing the Description of a warehouse

No

No

WRHSE_DSCRPTN_UP

varchar(80)

NOT NULL

This column is used for storing the Description of a warehouse

No

No

WRHSE_STATUS

varchar(5)

NOT NULL

To "Enable" and "Disable" any Warehouse. Any storage address can be Enabled or Disabled based on requirement. Individual zones can be disabled or enabled within a warehouse. The status for Enabled and Disabled warehouses will be called as "Active" and "Inactive" respectively. A warehouse can be disabled only if all the zones/bins defined under it not have any stock. Also, if a warehouse is disabled, all its associated zones and bins will get disabled automatically. Status - A/D

No

No

WRHSE_CATEGORY

varchar(25)

NULL

Category is non-mandatory

No

No

WRHSE_STRGE_TYPE

varchar(5)

NOT NULL

Facility to define a "Normal" or "Free" zone If a warehouse has been defined as a "Normal" warehouse, then we can attach zones to it. Storage Type - N/F

No

No

WRHSE_INCHRGE_CODE

varchar(20)

NULL

Employee code of the person who is in-charge of the warehouse

No

No

WRHSE_NETTABLE

varchar(25)

NOT NULL

Facility to define a warehouse as "Nettable" A warehouse can be defined as "Nettable" meaning that all the items that is stored in the warehouse can be considered as available for MRP run. For example, a non-nettable warehouse may contain items meant for R&D, Destructive testing, etc. Nettable - Y/N

No

No

WRHSE_ADDRESS

varchar(255)

NULL

This column is used for storing the address of a warehouse.

No

No

WRHSE_CITY

varchar(32)

NULL

This column is used for storing the city name of a warehouse

No

No

WRHSE_STATE

varchar(32)

NULL

This column is used for storing the state(province) of a warehouse.

No

No

WRHSE_ZIP

varchar(15)

NULL

This column is used for storing the Zip code of a warehouse

No

No

WRHSE_CNTRY

varchar(20)

NULL

This column is used for storing the country name of a warehouse.

No

No

WRHSE_CAPACITY_CONSTRAINT

varchar(25)

NULL

Capacity constraint UOM for the warehouse. This indicates the UOM which is used to represent the max capacity which the warehouse can handle Following lists the values and their BE Codes "Not Required"     -  ’NReqd’,   "Volume"              -  ’Vol’ "Weight"               -  ’Wght’ "Quantity".            -  ’Qty’

No

No

WRHSE_VOLUME

numeric(28,8)

NULL

Warehouse Volume - It is the Capacity of Volume of part to be stored under Warehouse

No

No

WRHSE_VOLUME_UOM

varchar(10)

NULL

Warehouse Volume UOM - It is Unit of Measurement in which the Capacity of Volume of part to be stored under Warehouse

No

No

WRHSE_WEIGHT

numeric(28,8)

NULL

Warehouse Weight - It is the Total Weight of part to be stored under Warehouse

No

No

WRHSE_WEIGHT_UOM

varchar(10)

NULL

Warehouse Weight UOM - It is Unit of Measurement in which the Total Weight of part to be stored under Warehouse

No

No

WRHSE_USER_DEF_1

varchar(30)

NULL

User defined details1

No

No

WRHSE_USER_DEF_2

varchar(30)

NULL

user defined details2

No

No

WRHSE_LINK_FLAG

varchar(50)

NULL

This flag will indicate whether zones are defined, bins are defined, etc for the warehouse. The order of display would be the following. Z/B/U/T/PT/UDSS/SA/SS/PP Each letter indicates sub-entity availability. ’Z’         - Zone, ’B’         - Bin ’U’         - ’User Mapping’, ’T’          - ’Transaction Mapping’ ’PT’        - ’Part Type’ ’UDSS’   - ’User Defined Stock Status mapping’ ’SA’        - ’Storage Allocation’ ’SS’        - ’Storage Strategies’ ’PP’        - ’Planning Parameters’ If no ’planning parameters’ are defined, then link flag would be stored as Z/B/U/T/PT/UDSS/SA/SS/$$ NOTE that position for each sub-entity codes would be stuffed with $$ when the details are not defined.

No

No

WRHSE_FILE_NAME

varchar(50)

NULL

User who has created the file.

No

No

WRHSE_CREATED_BY

varchar(30)

NOT NULL

User who has created the record.

No

No

WRHSE_CREATED_DATE

datetime

NOT NULL

User record created date

No

No

WRHSE_MODIFIED_BY

varchar(30)

NOT NULL

User who has modified the record.

No

No

WRHSE_MODIFIED_DATE

datetime

NOT NULL

User record modified date

No

No

WRHSE_TIMESTAMP

numeric(10)

NOT NULL

Timestamp of a record.

No

No

WRHSE_FIN_BOOK

varchar(20)

NULL

Warehouse book

No

No

WRHSE_BACKFLUSH_FLAG

varchar(25)

NULL

It will have "Y" or "N"

No

No

WRHSE_ALLTRNTYPE_FLAG

varchar(25)

NULL

It will have "Y" or "N"

No

No

WRHSE_ALLPRTTYPE_FLAG

varchar(25)

NULL

It will have "Y" or "N"

No

No

WRHSE_ALLSTKSTS_FLAG

varchar(25)

NULL

It will have "Y" or "N"

No

No

Table Name SA_ZNE_MSTR

Table Comment This tables stores zones defined under a warehouse. Similar to a warehouse, zone type can be "Normal" or "Free" zone. If a warehouse has been defined as a "Normal" warehouse, then we can attach zones to it. Again, zones can be "Normal" or "Free" based on whether we need to define bins under a zone.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ZNE_WEIGHT_UOM

varchar(10)

NULL

Zone Weight UOM - It is Unit of Measurement in which the Total Weight of part to be stored under Zone

No

No

ZNE_REMARKS

varchar(255)

NULL

Remarks

No

No

ZNE_WEIGHT

numeric(28,8)

NULL

Zone Weight - It is the Total Weight of part to be stored under Zone

No

No

ZNE_VOLUME_UOM

varchar(10)

NULL

Zone Volume UOM - It is Unit of Measurement in which Capacity of Volume of part to be stored under Zone

No

No

ZNE_VOLUME

numeric(28,8)

NULL

Zone Volume - It is the Capacity of Volume of part to be stored under Zone

No

No

ZNE_MODIFIED_BY

varchar(30)

NOT NULL

User who has modified the record.

No

No

ZNE_MODIFIED_DATE

datetime

NOT NULL

User record modified date

No

No

ZNE_FILE_NAME

varchar(50)

NULL

File Name

No

No

ZNE_CREATED_DATE

datetime

NOT NULL

User record created date

No

No

ZNE_CREATED_BY

varchar(30)

NOT NULL

User who has created the record.

No

No

ZNE_TIMESTAMP

numeric(10)

NOT NULL

Timestamp of a record.

No

No

ZNE_ZONE_ID

varchar(10)

NOT NULL

To define zones within a warehouse.

Yes

No

ZNE_DSCRPTN

varchar(150)

NOT NULL

Description of a zone

No

No

ZNE_DSCRPTN_UP

varchar(150)

NOT NULL

Description 

No

No

ZNE_WAREHOUSE_ID

varchar(10)

NOT NULL

To specify to which warehouse this zone is attached to.

Yes

Yes

ZNE_WAREHOUSE_OU

numeric(10)

NOT NULL

Organization Unit.

Yes

Yes

ZNE_PLACEMENT_PRIORITY

numeric(10)

NULL

Priority

No

No

ZNE_CAPACITY_CONSTRAINT

varchar(5)

NULL

Capacity constraint UOM for the warehouse-Zone. This indicates the UOM which is used to represent the max capacity which the warehouse-Zone can handle Following lists the values and their BE Codes "Not Required"     -  ’NReqd’,   "Volume"              -  ’Vol’ "Weight"               -  ’Wght’ "Quantity".            -  ’Qty’

No

No

ZNE_PROXIMITY_INDICATOR

varchar(5)

NULL

Proximity Indicator will have the following codes and description. "Near"               - ’Near’ "Medium"          - ’Mdm’ "Far"                 - ’Far’ "Space".           - ’Spc’

No

No

ZNE_STRGE_TYPE

varchar(5)

NOT NULL

Facility to define a "Normal" or "Free" zone If a warehouse has been defined as a "Normal" warehouse, then we can attach zones to it. Again, zones can be "Normal" or "Free" based on whether we need to define bins under a zone, which actually holds the item.

No

No

ZNE_STATUS

varchar(5)

NOT NULL

Facility to "Enable" and "Disable" Zone. Individual zones can be disabled or enabled within a warehouse. Similarly, individual bins can be disabled or enabled within a zone. A zone can be disabled only if that zone and its associated bins does not have any stock. When a zone is disabled, all the bins associated with it will be automatically disabled. Status - A/D

No

No

ZNE_PCKNG_PRTY

numeric(10)

NULL

Facility to specify "picking priority" for zones. The component provides facility to specify picking priority for the various zones and bins in a warehouse. At the time of issuing a particular item/variant from the warehouse, the system will check for availability of the item in the various zones based on the priority specified.

No

No