Database Schema for

Data Dictionary -- Storage Administration

Srl. No.	Table Name	Comment
1	SA_AWH_ASSOCIATE_WH_DTL	SA_AWH_ASSOCIATE_WH_DTL
2	SA_BIN_MSTR	SA_BIN_MSTR
3	SA_CUSTKALC_WHZNBN_CUST_DTL	SA_CUSTKALC_WHZNBN_CUST_DTL
4	SA_EXT_STORAGE_ALLOC	SA_EXT_STORAGE_ALLOC
5	SA_ISA_STOAREA_DTL	SA_ISA_STOAREA_DTL
6	SA_ITMTP_ITMCLASSI_ALLWD	SA_ITMTP_ITMCLASSI_ALLWD
7	SA_ITMTP_ITMTYPS_ALLWD	SA_ITMTP_ITMTYPS_ALLWD
8	SA_MSL_MNTSTOLOC_DTL	SA_MSL_MNTSTOLOC_DTL
9	SA_PARAMETER_DETAILS	SA_PARAMETER_DETAILS
10	SA_SAALLOC_WHZNBN_PART_DTL	SA_SAALLOC_WHZNBN_PART_DTL
11	SA_SAQC_QUICK_CODE	SA_SAQC_QUICK_CODE
12	SA_SATRN_FUNCTION_TRAN_META	SA_SATRN_FUNCTION_TRAN_META
13	Sa_set_option_dtl	Sa_set_option_dtl
14	Sa_set_option_hdr	Sa_set_option_hdr
15	Sa_set_option_Param_values	Sa_set_option_Param_values
16	SA_SET_OPTION_PERMIT_VALUES	SA_SET_OPTION_PERMIT_VALUES
17	SA_STCKS_STCKSTS_ALLWD	SA_STCKS_STCKSTS_ALLWD
18	SA_STRGY_STORAGE_STRATEGY	SA_STRGY_STORAGE_STRATEGY
19	SA_TRNS_TRNSCTNS_ALLWD	SA_TRNS_TRNSCTNS_ALLWD
20	SA_TRNS_TRNSCTNS_ALLWD_HIST	SA_TRNS_TRNSCTNS_ALLWD_HIST
21	SA_WHDA_DOC_ATTACH_DTL	SA_WHDA_DOC_ATTACH_DTL
22	SA_WHPLN_PLANNING_PARAMS	SA_WHPLN_PLANNING_PARAMS
23	SA_WHPLN_PLANNING_PARAMS_AUDIT	Table to manage Warehouse planning parameters details
24	SA_WHUSR_WH_USER_MAPPING	SA_WHUSR_WH_USER_MAPPING
25	SA_WRHSE_MSTR	SA_WRHSE_MSTR
26	SA_WRHSE_MSTR_HIST	SA_WRHSE_MSTR_HIST
27	SA_ZNE_MSTR	SA_ZNE_MSTR


Table Name :	SA_AWH_ASSOCIATE_WH_DTL
Comment :	SA_AWH_ASSOCIATE_WH_DTL


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AWH_ASSOC_TYPE	udd_txt150	varchar(150)	Yes	associate type	No
AWH_ASSOWHSE	udd_warehouse	varchar(10)	Yes	associate warehouse	No
AWH_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
AWH_CREATEDDATE	udd_time	datetime(8)	Yes	CREATED DATE	No
AWH_LASTMODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	LASTMODIFIED BY	No
AWH_LASTMODIFIEDDATE	udd_time	datetime(8)	Yes	LASTMODIFIED DATE	No
AWH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	OUINSTANCE	No
AWH_LINENO	udd_seqno	int(4)	Yes	LINE Number	No
AWH_WAREHOUSE	udd_warehouse	varchar(10)	Yes	WAREHOUSE ID	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes


Table Name :	SA_BIN_MSTR
Comment :	SA_BIN_MSTR


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BIN_WAREHOUSE_OU	udd_ctxt_ouinstance	int(4)	No	WAREHOUSE Ouinstance	Yes
BIN_WAREHOUSE_ID	udd_warehouse	varchar(10)	No	WAREHOUSE ID	Yes
BIN_ZONE_ID	varchar	Char(10)	No	ZONE ID	Yes
BIN_BIN_ID	varchar	Char(10)	No	BIN ID	Yes
BIN_DSCRPTN	varchar	Char(10)	No	Description	No
BIN_DSCRPTN_UP	varchar	Char(10)	No	Description UP	No
BIN_PCKNG_PRTY	udd_seqno	int(4)	Yes	Package party	No
BIN_STATUS_CODE	varchar	Char(10)	No	STATUS CODE	No
BIN_CAPACITY_CONSTRAINT	varchar	Char(10)	Yes	CAPACITY CONSTRAINT	No
BIN_PROXIMITY_INDICATOR	varchar	Char(10)	Yes	PROXIMITY INDICATOR	No
BIN_PLACEMENT_PRIORITY	_decimal_10_0	decimal(10)	Yes	PLACEMENT PRIORITY	No
BIN_VOLUME	_decimal_28_8	decimal(28)	Yes	VOLUME	No
BIN_VOLUME_UOM	varchar	Char(10)	Yes	VOLUME UOM	No
BIN_WEIGHT	_decimal_28_8	decimal(28)	Yes	WEIGHT	No
BIN_WEIGHT_UOM	varchar	Char(10)	Yes	WEIGHT UOM	No
BIN_REMARKS	varchar	Char(10)	Yes	REMARKS	No
BIN_FILE_NAME	varchar	Char(10)	Yes	FILE NAME	No
BIN_CREATED_BY	varchar	Char(10)	No	CREATED BY	No
BIN_CREATED_DATE	datetime	Datetime(8)	No	CREATED DATE	No
BIN_MODIFIED_BY	varchar	Char(10)	No	MODIFIED BY	No
BIN_MODIFIED_DATE	datetime	Datetime(8)	No	MODIFIED DATE	No
BIN_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No


Table Name :	SA_CUSTKALC_WHZNBN_CUST_DTL
Comment :	SA_CUSTKALC_WHZNBN_CUST_DTL


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CUSTKALC_WAREHOUSE_OU	udd_ctxt_ouinstance	int(4)	No	WAREHOUSE OUINSTANCE	No
CUSTKALC_WAREHOUSE_ID	udd_warehouse	varchar(10)	No	WAREHOUSE ID	No
CUSTKALC_ZONE_ID	udd_zone	varchar(10)	No	ZONE ID	No
CUSTKALC_BIN_ID	udd_bin	varchar(10)	Yes	BIN ID	No
CUSTKALC_CUST_CRT_OU	udd_ctxt_ouinstance	int(4)	No	OUINSTANCE	No
CUSTKALC_CUST_CODE	udd_customer_id	varchar(18)	No	CUSTOMER CODE	No
CUSTKALC_STORAGE_CAT	udd_flag	varchar(25)	Yes	STORAGE CATEGORY	No
CUSTKALC_STORAGE_RULE	udd_designparamcode	varchar(5)	Yes	STORAGE RULE	No
CUSTKALC_TIMESTAMP	udd_timestamp	int(4)	No	TIMESTAMP	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique ID	Yes


Table Name :	SA_EXT_STORAGE_ALLOC
Comment :	SA_EXT_STORAGE_ALLOC


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SA_EXT_WAREHOUSE_OU	udd_ctxt_ouinstance	int(4)	No	WAREHOUSE OUINSTANCE	Yes
SA_EXT_WAREHOUSE_ID	udd_warehouse	varchar(10)	No	WAREHOUSE ID	Yes
SA_EXT_ZONE_ID	udd_zone	varchar(10)	No	ZONE ID	Yes
SA_EXT_BIN_ID	udd_bin	varchar(10)	No	BIN ID	Yes
SA_EXT_TRD_PARTNER_CODE	udd_vendorcode	varchar(45)	No	TRADING PARTNER CODE	Yes
SA_EXT_TRD_PARTNER_TYPE	udd_flag1	varchar(25)	No	TRADING PARTNER TYPE	Yes
SA_EXT_DEF_LOCN	udd_designparamcode	varchar(5)	No	DEF LOCATION	No
SA_EXT_STORAGE_CAT	udd_designparamcode	varchar(5)	No	STORAGE CATEGORY	No
SA_EXT_STORAGE_RULE	udd_flag1	varchar(25)	Yes	STORAGE RULE	No
Sa_timestamp	udd_timestamp	int(4)	No	Timestamp	No


Table Name :	SA_ISA_STOAREA_DTL
Comment :	SA_ISA_STOAREA_DTL


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ISA_PARAMETER	udd_workarea	varchar(15)	Yes	PARAMETER	No
ISA_AREAID	udd_desc40	varchar(40)	Yes	AREA ID	No
ISA_AREADESC	udd_txt255	varchar(255)	Yes	AREA DESCRIPTION	No
ISA_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
ISA_CREATEDDATE	udd_time	datetime(8)	Yes	CREATED DATE	No
ISA_LASTMODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	LAST MODIFIED BY	No
ISA_LASTMODIFIEDDATE	udd_time	datetime(8)	Yes	LAST MODIFIED DATE	No
ISA_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	OUINSTANCE	No
ISA_LINENO	udd_seqno	int(4)	Yes	LINE NO	No
ISA_WRHSE	udd_desc40	varchar(40)	Yes	WAREHOUSE	No
ISA_DEFAULT	udd_designparamcode	varchar(5)	Yes	DEFAULT	No
ISA_STATUS	udd_status	varchar(25)	Yes	STATUS	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes


Table Name :	SA_ITMTP_ITMCLASSI_ALLWD
Comment :	SA_ITMTP_ITMCLASSI_ALLWD


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ITMTP_WAREHOUSE_OU	udd_ctxt_ouinstance	int(4)	No	WAREHOUSE Ouinstance	Yes
ITMTP_WAREHOUSE_ID	udd_warehouse	varchar(10)	No	WAREHOUSE ID	Yes
ITMTP_ITM_CLASSI	udd_partgroup	varchar(25)	No	CLASSI	Yes
ITMTP_CREATED_BY	udd_ctxt_user	varchar(30)	No	CREATED BY	No
ITMTP_CREATED_DATE	udd_time	datetime(8)	No	CREATED DATE	No
ITMTP_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	MODIFIED BY	No
ITMTP_MODIFIED_DATE	udd_time	datetime(8)	No	MODIFIED DATE	No
ITMTP_TIMESTAMP	udd_timestamp	int(4)	No	TIMESTAMP	No


Table Name :	SA_ITMTP_ITMTYPS_ALLWD
Comment :	SA_ITMTP_ITMTYPS_ALLWD


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ITMTP_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE Ouinstance	Yes
ITMTP_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
ITMTP_ITEM_TYPE	varchar	Char(10)	No	ITEM TYPE	Yes
ITMTP_CREATED_BY	varchar	Char(10)	No	CREATED BY	No
ITMTP_CREATED_DATE	datetime	Datetime(8)	No	CREATED DATE	No
ITMTP_MODIFIED_BY	varchar	Char(10)	No	MODIFIED BY	No
ITMTP_MODIFIED_DATE	datetime	Datetime(8)	No	MODIFIED DATE	No
ITMTP_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No


Table Name :	SA_MSL_MNTSTOLOC_DTL
Comment :	SA_MSL_MNTSTOLOC_DTL


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MSL_STORAGE_LOCATION	udd_desc40	varchar(40)	Yes	STORAGE LOCATION	No
MSL_DESRIPTION	udd_txt255	varchar(255)	Yes	DESRIPTION	No
MSL_STATION	udd_desc40	varchar(40)	Yes	STATION	No
MSL_STATUS	udd_status	varchar(25)	Yes	STATUS	No
MSL_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
MSL_CREATEDDATE	udd_time	datetime(8)	Yes	CREATED DATE	No
MSL_LASTMODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	LASTMODIFIED BY	No
MSL_LASTMODIFIEDDATE	udd_time	datetime(8)	Yes	LASTMODIFIED DATE	No
MSL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	OUINSTANCE	No
MSL_Lineno	udd_seqno	int(4)	Yes	Lineno	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes


Table Name :	SA_PARAMETER_DETAILS
Comment :	SA_PARAMETER_DETAILS


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SA_COMPONENTNAME	varchar	Char(10)	No	COMPONENT NAME	Yes
SA_PARAMCATEGORY	varchar	Char(10)	No	PARAMCATEGORY	Yes
SA_PARAMTYPE	varchar	Char(10)	No	PARAM TYPE	Yes
SA_PARAMCODE	varchar	Char(10)	No	PARAM CODE	Yes
SA_LANGID	_decimal_9_0	decimal(9)	No	LANGUAGE ID	Yes
SA_PARAMDESC	varchar	Char(10)	Yes	PARAM DESCRIPTION	No
SA_SORT_BY	_decimal_9_0	decimal(9)	Yes	SORT BY	No


Table Name :	SA_SAALLOC_WHZNBN_PART_DTL
Comment :	SA_SAALLOC_WHZNBN_PART_DTL


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SAALLOC_WAREHOUSE_OU	_numeric_28_8	numeric(28)	No	WAREHOUSE OU	Yes
SAALLOC_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
SAALLOC_ZONE_ID	varchar	Char(10)	No	ZONE ID	Yes
SAALLOC_BIN_ID	varchar	Char(10)	No	BIN ID	Yes
SAALLOC_PART_CRT_OU	_numeric_28_8	numeric(28)	No	PART Control OUinstance	Yes
SAALLOC_PART_NO	varchar	Char(10)	No	PART NO	Yes
SAALLOC_STORAGE_CAT	varchar	Char(10)	Yes	STORAGE CATEGORY	No
SAALLOC_STORAGE_RULE	varchar	Char(10)	Yes	STORAGE RULE	No
SAALLOC_CONSTRNT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	CONSTRNT QTY INSTOCK UOM	No
SAALLOC_TIMESTAMP	_numeric_28_8	numeric(28)	Yes	TIMESTAMP	No


Table Name :	SA_SAQC_QUICK_CODE
Comment :	SA_SAQC_QUICK_CODE


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SAQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUINSTANCE	Yes
SAQC_QUICK_CODE	varchar	Char(10)	No	QUICK CODE	Yes
SAQC_TYPE	varchar	Char(10)	No	TYPE	Yes
SAQC_DESC	varchar	Char(10)	Yes	DESCRIPTION	No
SAQC_STATUS	varchar	Char(10)	Yes	STATUS	No
SAQC_CREATEDDATE	datetime	Datetime(8)	Yes	CREATED DATE	No
SAQC_CREATED_BY	varchar	Char(10)	Yes	CREATED BY	No
SAQC_MODIFIEDDATE	datetime	Datetime(8)	Yes	MODIFIED DATE	No
SAQC_MODIFIED_BY	varchar	Char(10)	Yes	MODIFIED BY	No
SAQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	TIMESTAMP	No


Table Name :	SA_SATRN_FUNCTION_TRAN_META
Comment :	SA_SATRN_FUNCTION_TRAN_META


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SATRN_TRAN_TYPE	varchar	Char(10)	No	TRANSACTION TYPE	Yes
SATRN_FUNCTION_CODE	varchar	Char(10)	No	FUNCTION CODE	Yes
SATRN_FUNCTION_NAME	varchar	Char(10)	No	FUNCTION NAME	No
SATRN_TRANSACTION_CODE	varchar	Char(10)	No	TRANSACTION CODE	Yes
SATRN_TRANSACTION_DESC	varchar	Char(10)	No	TRANSACTION DESCRIPTION	No
SATRN_TRAN_TYPE_DESC	varchar	Char(10)	Yes	TRANSACTION TYPE DESCRIPTION	No
SATRN_OFMS_APPLICABLE	udd_designparamcode	varchar(5)	Yes	OFMS applicable or not	No


Table Name :	Sa_set_option_dtl
Comment :	Sa_set_option_dtl


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setoptdtl_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
SetOptdtl_OptKeyCode	udd_documentno	varchar(40)	No	OptION KeyCode	Yes
setoptdtl_status	udd_paramcode	varchar(30)	Yes	Status	No
setoptdtl_value	udd_groupno	int(4)	Yes	Value	No
setoptdtl_modifiedby	udd_ctxt_user	varchar(30)	Yes	Modified By	No
setoptdtl_modifieddate	udd_time	datetime(8)	Yes	modified date	No
SETOPTDTL_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created By	No
SETOPTDTL_CREATEDDATE	udd_time	datetime(8)	Yes	Created Date	No
SETOPTDTL_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp	No
SETOPTDTL_WAREHOUSE	udd_warehouse	varchar(10)	No	Warehouse	Yes


Table Name :	Sa_set_option_hdr
Comment :	Sa_set_option_hdr


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setopthdr_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	ouinstance	No
setopthdr_timestamp	udd_timestamp	int(4)	Yes	timestamp	No
setopthdr_createdby	udd_ctxt_user	varchar(30)	Yes	created by	No
setopthdr_createddate	udd_time	datetime(8)	Yes	created date	No
setopthdr_modifiedby	udd_ctxt_user	varchar(30)	Yes	modified by	No
setopthdr_modifieddate	udd_time	datetime(8)	Yes	modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique ID	Yes


Table Name :	Sa_set_option_Param_values
Comment :	Sa_set_option_Param_values


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SetOpt_Langid	udd_ctxt_language	int(4)	Yes	LANGUAGE ID	No
SetOpt_OptKeyCode	udd_designparamcode	varchar(5)	No	OPTION KeyCode	Yes
SetOpt_Metadata_type	udd_paramcode	varchar(30)	Yes	Metadata type	No
SetOpt_paramcode	udd_paramcode	varchar(30)	Yes	PARAMETER CODE	No
SetOpt_paramDesc	udd_txt150	varchar(150)	Yes	PARAM DESCRIPTION	No
SetOpt_Mandatory_Check	udd_flag1	varchar(25)	Yes	Mandatory Check	No
SetOpt_Sotrby	udd_seqno	int(4)	Yes	Sort by	No
Setopt_createdDate	udd_time	datetime(8)	Yes	created Date	No


Table Name :	SA_SET_OPTION_PERMIT_VALUES
Comment :	SA_SET_OPTION_PERMIT_VALUES


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SetOpt_OptLanguage	udd_ctxt_language	int(4)	Yes	set Option Language	No
SetOpt_OptKeyCode	udd_documentno	varchar(40)	Yes	set Option KeyCode	No
SetOpt_permittedvalue	udd_count	int(4)	Yes	Permitted value	No
SetOpt_permittedvalue_desc	udd_txt150	varchar(150)	Yes	permitted value description	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique ID	Yes


Table Name :	SA_STCKS_STCKSTS_ALLWD
Comment :	SA_STCKS_STCKSTS_ALLWD


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STCKS_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OU	Yes
STCKS_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
STCKS_STATUS	varchar	Char(10)	No	STATUS	Yes
STCKS_CREATED_BY	varchar	Char(10)	No	CREATED BY	No
STCKS_CREATED_DATE	datetime	Datetime(8)	No	CREATED DATE	No
STCKS_MODIFIED_BY	varchar	Char(10)	No	MODIFIED BY	No
STCKS_MODIFIED_DATE	datetime	Datetime(8)	No	MODIFIED DATE	No
STCKS_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No
STCKS_ACC_Serviceable	varchar	Char(10)	Yes	Serviceable	No
STCKS_ACC_UnServiceable	varchar	Char(10)	Yes	UnServiceable	No
STCKS_ACC_New	varchar	Char(10)	Yes	New	No
STCKS_ACC_Overhauled	varchar	Char(10)	Yes	Overhauled	No
STCKS_ACC_Phased_Out	varchar	Char(10)	Yes	Phased Out	No


Table Name :	SA_STRGY_STORAGE_STRATEGY
Comment :	SA_STRGY_STORAGE_STRATEGY


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STRGY_WAREHOUSE_OU	_numeric_28_0	numeric(28)	No	WAREHOUSE_OU	Yes
STRGY_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
STRGY_PART_CRT_OU	_numeric_28_0	numeric(28)	No	PART CRT OUINSTANCE	Yes
STRGY_PART_NO	varchar	Char(10)	No	PART NO	Yes
STRGY_PLACEMENT_STRATEGY	varchar	Char(10)	Yes	PLACEMENT STRATEGY	No
STRGY_DEF_PLACEMENT_ZONE_ID	varchar	Char(10)	Yes	PLACEMENT ZONE_ID	No
STRGY_DEF_PLACEMENT_BIN_ID	varchar	Char(10)	Yes	PLACEMENT BIN ID	No
STRGY_PICKING_STRATEGY	varchar	Char(10)	Yes	PICKING STRATEGY	No
STRGY_DEF_PICKING_ZONE_ID	varchar	Char(10)	Yes	PICKING ZONE_ID	No
STRGY_DEF_PICKING_BIN_ID	varchar	Char(10)	Yes	PICKING BIN_ID	No
STRGY_MIN_QTY	_decimal_28_0	decimal(28)	Yes	MIN_QTY	No
STRGY_MAX_QTY	_decimal_28_0	decimal(28)	Yes	MAX_QTY	No
STRGY_SAFETY_STOCK	varchar	Char(10)	Yes	SAFETY_STOCK	No
STRGY_REORDER_LVL	varchar	Char(10)	Yes	REORDER LEVEL	No
STRGY_REORDER_QTY	_decimal_28_0	decimal(28)	Yes	REORDER QUANTITY	No
STRGY_REORDER_ACTIVATED_BY	varchar	Char(10)	Yes	REORDER ACTIVATED BY	No
STRGY_TRANSFER_LOCATION	varchar	Char(10)	Yes	TRANSFER LOCATION	No
STRGY_TRANSFER_WAREHOUSE	varchar	Char(10)	Yes	TRANSFER WAREHOUSE	No
STRGY_TIMESTAMP	_numeric_28_0	numeric(28)	Yes	TIMESTAMP	No
STRGY_STOCK_STATUS	udd_partstatus	varchar(40)	No	STOCK STATUS	Yes
STRGY_TRD_PARTNER_CODE	udd_vendorcode	varchar(45)	No	TRADING PARTNER CODE	Yes


Table Name :	SA_TRNS_TRNSCTNS_ALLWD
Comment :	SA_TRNS_TRNSCTNS_ALLWD


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRNS_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OU	Yes
TRNS_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
TRNS_TRAN_TYPE	varchar	Char(10)	No	TRAN TYPE	Yes
TRNS_CREATED_BY	varchar	Char(10)	No	CREATED BY	No
TRNS_CREATED_DATE	datetime	Datetime(8)	No	CREATED DATE	No
TRNS_MODIFIED_BY	varchar	Char(10)	No	MODIFIED_BY	No
TRNS_MODIFIED_DATE	datetime	Datetime(8)	No	MODIFIED DATE	No
TRNS_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No


Table Name :	SA_TRNS_TRNSCTNS_ALLWD_HIST
Comment :	SA_TRNS_TRNSCTNS_ALLWD_HIST


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRNS_WAREHOUSE_OU	udd_ctxt_ouinstance	int(4)	Yes	WAREHOUSE OUINSTANCE	No
TRNS_WAREHOUSE_ID	udd_warehouse	varchar(10)	Yes	WAREHOUSE ID	No
TRNS_TRAN_TYPE	udd_flag	varchar(25)	Yes	TRANSACTION TYPE	No
TRNS_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
TRNS_CREATED_DATE	udd_time	datetime(8)	Yes	CREATED DATE	No
TRNS_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	MODIFIED BY	No
TRNS_MODIFIED_DATE	udd_time	datetime(8)	Yes	MODIFIED DATE	No
TRNS_Offline_Area	udd_txt255	varchar(255)	Yes	Offline Area	No
TRNS_Active_Flag	udd_designparamcode	varchar(5)	Yes	Active Flag	No
TRNS_HIST_DATE	udd_time	datetime(8)	Yes	HISTORY DATE	No
REPLICATION_KEY	_uniqueidentifier_0	uniqueidentifier(0)	No	REPLICATION KEY	Yes


Table Name :	SA_WHDA_DOC_ATTACH_DTL
Comment :	SA_WHDA_DOC_ATTACH_DTL


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WHDA_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUINSTANCE	Yes
WHDA_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
WHDA_REF_DOC_TYPE	varchar	Char(10)	No	REFERENCE DOCUMENT TYPE	Yes
WHDA_DOC_ID	varchar	Char(10)	No	DOCUMENT ID	Yes
WHDA_FILE_NAME	varchar	Char(10)	Yes	FILE NAME	No
WHDA_REMARKS	varchar	Char(10)	Yes	REMARKS	No


Table Name :	SA_WHPLN_PLANNING_PARAMS
Comment :	SA_WHPLN_PLANNING_PARAMS


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WHPLN_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OUINSTANCE	Yes
WHPLN_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
WHPLN_PART_CRT_OU	_decimal_10_0	decimal(10)	No	PART CRT OU	Yes
WHPLN_PART_NO	varchar	Char(10)	No	PART_NO	Yes
WHPLN_MIN_QTY	_decimal_28_8	decimal(28)	Yes	MINIMUM QUANTITY	No
WHPLN_MAX_QTY	_decimal_28_8	decimal(28)	Yes	MAX QUANITITY	No
WHPLN_SAFETY_STOCK	_decimal_28_8	decimal(28)	Yes	SAFETY STOCK	No
WHPLN_REORDER_LVL	_decimal_28_8	decimal(28)	Yes	REORDER LEVEL	No
WHPLN_REORDER_QTY	_decimal_28_8	decimal(28)	Yes	REORDER QUANTITY	No
WHPLN_REORDER_ACTIVATED_BY	varchar	Char(10)	Yes	REORDER ACTIVATED BY	No
WHPLN_TRANSFER_LOCATION	_decimal_10_0	decimal(10)	Yes	TRANSFER LOCATION	No
WHPLN_SOURCE_WH_OU	_decimal_10_0	decimal(10)	Yes	SOURCE WAREHOUSE OUINSTANCE	No
WHPLN_SOURCE_WH_ID	varchar	Char(10)	Yes	SOURCE_WH_ID	No
WHPLN_ISSUE_LOCATION	_decimal_10_0	decimal(10)	Yes	ISSUE_LOCATION	No
WHPLN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	TIMESTAMP	No
WHPLN_REPLENISH_QTY	_decimal_28_8	decimal(28)	Yes	REPLENISH QUANTITY	No
WhPln_Plan_Horizon	_decimal_10_0	decimal(10)	Yes	Plan Horizon	No
WHPLN_LAST_UPDATED_DOCNO	udd_documentno	varchar(40)	Yes	LAST UPDATED_DOCNO	No
WHPLN_LAST_UPDATED_DOCOU	udd_ctxt_ouinstance	int(4)	Yes	LAST_UPDATED_DOCOU	No
WHPLN_LAST_UPDATED_DOC_TYPE	udd_flag	varchar(25)	Yes	LAST_UPDATED_DOC_TYPE	No
WHPLN_LAST_UPDATED_QUANTITY	udd_quantity	numeric(13)	Yes	LAST_UPDATED_QUANTITY	No
whpln_created_by	udd_ctxt_user	varchar(30)	Yes	created_by	No
whpln_created_date	datetime	Datetime(8)	Yes	created_date	No
whpln_modified_by	udd_ctxt_user	varchar(30)	Yes	modified_by	No
whpln_modified_date	datetime	Datetime(8)	Yes	modified_date	No
WHPLN_PLANNING_TYPE	udd_flag	varchar(25)	Yes	Planning type	No
WHPLN_REMARKS	udd_remarks	varchar(255)	Yes	Remarks	No


Table Name :	SA_WHPLN_PLANNING_PARAMS_AUDIT
Comment :	Table to manage Warehouse planning parameters details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?


Table Name :	SA_WHUSR_WH_USER_MAPPING
Comment :	SA_WHUSR_WH_USER_MAPPING


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WHUSR_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OUINSTANCE	Yes
WHUSR_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
WHUSR_USER_NAME	varchar	Char(10)	No	USER NAME	Yes
WHUSR_DEFAULTWAREHOUSE_ID	udd_warehouse	varchar(10)	Yes	DEFAULT WAREHOUSE ID	No


Table Name :	SA_WRHSE_MSTR
Comment :	SA_WRHSE_MSTR


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WRHSE_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OU	Yes
WRHSE_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
WRHSE_DSCRPTN	varchar	Char(10)	No	DSCRPTN	No
WRHSE_DSCRPTN_UP	varchar	Char(10)	No	DSCRPTN UP	No
WRHSE_STATUS	varchar	Char(10)	No	STATUS	No
WRHSE_CATEGORY	varchar	Char(10)	Yes	CATEGORY	No
WRHSE_STRGE_TYPE	varchar	Char(10)	No	STRGE TYPE	No
WRHSE_INCHRGE_CODE	varchar	Char(10)	Yes	INCHRGE CODE	No
WRHSE_NETTABLE	varchar	Char(10)	No	NETTABLE	No
WRHSE_ADDRESS	varchar	Char(10)	Yes	ADDRESS	No
WRHSE_CITY	varchar	Char(10)	Yes	CITY	No
WRHSE_STATE	varchar	Char(10)	Yes	STATE	No
WRHSE_ZIP	varchar	Char(10)	Yes	ZIP	No
WRHSE_CNTRY	varchar	Char(10)	Yes	CNTRY	No
WRHSE_CAPACITY_CONSTRAINT	varchar	Char(10)	Yes	CAPACITY CONSTRAINT	No
WRHSE_VOLUME	_decimal_28_8	decimal(28)	Yes	VOLUME	No
WRHSE_VOLUME_UOM	varchar	Char(10)	Yes	VOLUME UOM	No
WRHSE_WEIGHT	_decimal_28_8	decimal(28)	Yes	WEIGHT	No
WRHSE_WEIGHT_UOM	varchar	Char(10)	Yes	WEIGHT UOM	No
WRHSE_USER_DEF_1	varchar	Char(10)	Yes	USER DEF 1	No
WRHSE_USER_DEF_2	varchar	Char(10)	Yes	USER DEF 2	No
WRHSE_LINK_FLAG	varchar	Char(10)	Yes	LINK FLAG	No
WRHSE_FILE_NAME	varchar	Char(10)	Yes	FILE NAME	No
WRHSE_CREATED_BY	varchar	Char(10)	No	CREATED BY	No
WRHSE_CREATED_DATE	datetime	Datetime(8)	No	CREATED DATE	No
WRHSE_MODIFIED_BY	varchar	Char(10)	No	MODIFIED BY	No
WRHSE_MODIFIED_DATE	datetime	Datetime(8)	No	MODIFIED DATE	No
WRHSE_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No
WRHSE_FIN_BOOK	varchar	Char(10)	Yes	FIN BOOK	No
WRHSE_BACKFLUSH_FLAG	varchar	Char(10)	Yes	BACKFLUSH FLAG	No
WRHSE_ALLTRNTYPE_FLAG	varchar	Char(10)	Yes	ALLTRNTYPE FLAG	No
WRHSE_ALLPRTTYPE_FLAG	varchar	Char(10)	Yes	ALLPRTTYPE FLAG	No
WRHSE_ALLSTKSTS_FLAG	varchar	Char(10)	Yes	ALLSTKSTS FLAG	No
WRHSE_STORAGE_LOCATION	udd_desc40	varchar(40)	Yes	STORAGE LOCATION	No
WRHSE_OFFLINE	udd_designparamcode	varchar(5)	Yes	OFFLINE	No
WRHSE_OFFLINE_AREA	udd_documentno	varchar(40)	Yes	OFFLINE AREA	No
created_area_code	_Varchar_40	varchar(40)	Yes	created area code	No
WRHSE_ALW_OFFLINE_USG	udd_designparamcode	varchar(5)	Yes	ALW OFFLINE USG	No


Table Name :	SA_WRHSE_MSTR_HIST
Comment :	SA_WRHSE_MSTR_HIST


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WRHSE_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OU	No
WRHSE_WAREHOUSE_ID	_varchar_10	varchar(10)	No	WAREHOUSE ID	No
WRHSE_DSCRPTN	_varchar_80	varchar(80)	No	DSCRPTN	No
WRHSE_DSCRPTN_UP	_varchar_80	varchar(80)	No	DSCRPTN UP	No
WRHSE_STATUS	_varchar_5	varchar(5)	No	STATUS	No
WRHSE_CATEGORY	_varchar_25	Varchar(25)	Yes	CATEGORY	No
WRHSE_STRGE_TYPE	_varchar_5	varchar(5)	No	STRGE TYPE	No
WRHSE_INCHRGE_CODE	_varchar_20	varchar(20)	Yes	INCHRGE CODE	No
WRHSE_NETTABLE	_varchar_25	Varchar(25)	No	NETTABLE	No
WRHSE_ADDRESS	_varchar_255	varchar(255)	Yes	ADDRESS	No
WRHSE_CITY	_varchar_32	varchar(32)	Yes	CITY	No
WRHSE_STATE	_varchar_32	varchar(32)	Yes	STATE	No
WRHSE_ZIP	_varchar_15	varchar(15)	Yes	ZIP	No
WRHSE_CNTRY	_varchar_40	varchar(40)	Yes	CNTRY	No
WRHSE_CAPACITY_CONSTRAINT	_varchar_25	Varchar(25)	Yes	CAPACITY CONSTRAINT	No
WRHSE_VOLUME	_decimal_28_8	decimal(28)	Yes	VOLUME	No
WRHSE_VOLUME_UOM	_varchar_10	varchar(10)	Yes	VOLUME UOM	No
WRHSE_WEIGHT	_decimal_28_8	decimal(28)	Yes	WEIGHT	No
WRHSE_WEIGHT_UOM	_varchar_10	varchar(10)	Yes	WEIGHT UOM	No
WRHSE_USER_DEF_1	_varchar_30	varchar(30)	Yes	USER DEF 1	No
WRHSE_USER_DEF_2	_varchar_30	varchar(30)	Yes	USER DEF 2	No
WRHSE_LINK_FLAG	_varchar_50	varchar(50)	Yes	LINK FLAG	No
WRHSE_FILE_NAME	_varchar_50	varchar(50)	Yes	FILE NAME	No
WRHSE_CREATED_BY	_varchar_30	varchar(30)	No	CREATED BY	No
WRHSE_CREATED_DATE	_datetime_8	datetime(8)	No	CREATED DATE	No
WRHSE_MODIFIED_BY	_varchar_30	varchar(30)	No	MODIFIED BY	No
WRHSE_MODIFIED_DATE	_datetime_8	datetime(8)	No	MODIFIED DATE	No
WRHSE_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No
WRHSE_FIN_BOOK	_varchar_20	varchar(20)	Yes	FIN BOOK	No
WRHSE_BACKFLUSH_FLAG	_varchar_25	Varchar(25)	Yes	BACKFLUSH FLAG	No
WRHSE_ALLTRNTYPE_FLAG	_varchar_25	Varchar(25)	Yes	ALLTRNTYPE FLAG	No
WRHSE_ALLPRTTYPE_FLAG	_varchar_25	Varchar(25)	Yes	ALLPRTTYPE FLAG	No
WRHSE_ALLSTKSTS_FLAG	_varchar_25	Varchar(25)	Yes	ALLSTKSTS FLAG	No
WRHSE_STORAGE_LOCATION	udd_desc40	varchar(40)	Yes	STORAGE LOCATION	No
WRHSE_OFFLINE	udd_designparamcode	varchar(5)	Yes	OFFLINE	No
WRHSE_OFFLINE_AREA	udd_documentno	varchar(40)	Yes	OFFLINE AREA	No
created_area_code	_varchar_40	varchar(40)	Yes	created area code	No
WRHSE_ALW_OFFLINE_USG	udd_designparamcode	varchar(5)	Yes	ALW OFFLINE USG	No
WRHSE_WORK_CENTRE	udd_aircraftnumber	varchar(30)	Yes	WORK CENTRE	No
WRHSE_OFMS_ACTION	udd_flag	varchar(25)	Yes	OFMS ACTION	No
WRHSE_HISTORY_DATE	udd_time	datetime(8)	Yes	HISTORY DATE	No
REPLICATION_KEY	_uniqueidentifier_0	uniqueidentifier(0)	No	REPLICATION KEY	Yes
WRHSE_WH_GROUP	udd_desc40	varchar(40)	Yes	WAREHOUSE GROUP	No


Table Name :	SA_ZNE_MSTR
Comment :	SA_ZNE_MSTR


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ZNE_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	WAREHOUSE OU	Yes
ZNE_WAREHOUSE_ID	varchar	Char(10)	No	WAREHOUSE ID	Yes
ZNE_ZONE_ID	varchar	Char(10)	No	ZONE ID	Yes
ZNE_DSCRPTN	varchar	Char(10)	No	DSCRPTN	No
ZNE_DSCRPTN_UP	varchar	Char(10)	No	DSCRPTN UP	No
ZNE_STRGE_TYPE	varchar	Char(10)	No	STRGE TYPE	No
ZNE_PCKNG_PRTY	_decimal_10_0	decimal(10)	Yes	PCKNG PRTY	No
ZNE_STATUS	varchar	Char(10)	No	STATUS	No
ZNE_CAPACITY_CONSTRAINT	varchar	Char(10)	Yes	CAPACITY CONSTRAINT	No
ZNE_PROXIMITY_INDICATOR	varchar	Char(10)	Yes	PROXIMITY INDICATOR	No
ZNE_PLACEMENT_PRIORITY	_decimal_10_0	decimal(10)	Yes	PLACEMENT PRIORITY	No
ZNE_VOLUME	_decimal_28_8	decimal(28)	Yes	VOLUME	No
ZNE_VOLUME_UOM	varchar	Char(10)	Yes	VOLUME UOM	No
ZNE_WEIGHT	_decimal_28_8	decimal(28)	Yes	WEIGHT	No
ZNE_WEIGHT_UOM	varchar	Char(10)	Yes	WEIGHT UOM	No
ZNE_REMARKS	varchar	Char(10)	Yes	REMARKS	No
ZNE_FILE_NAME	varchar	Char(10)	Yes	FILE NAME	No
ZNE_CREATED_BY	varchar	Char(10)	No	CREATED BY	No
ZNE_CREATED_DATE	datetime	Datetime(8)	No	CREATED DATE	No
ZNE_MODIFIED_BY	varchar	Char(10)	No	MODIFIED BY	No
ZNE_MODIFIED_DATE	datetime	Datetime(8)	No	MODIFIED DATE	No
ZNE_TIMESTAMP	_decimal_10_0	decimal(10)	No	TIMESTAMP	No