Data Dictionary -- Stock Maintenance

Srl. No.	Table Name	Comment
1	SMN_BAL_WHZNBN_LOT_SRL_LVL_BAL	This table contains available or balance quantity at part - part status - warehouse - zone - bin - lot - serialno level.
2	SMN_DATEWISE_CMAV_INFO	used to store weighted average details
3	Smn_Invent_Reval_BalSheet_Det	The table is used to store the detailed Inventory Valuation information
4	Smn_Invent_Reval_Hdr	The table is used to store the header levelInventory Valuation information
5	Smn_Invent_Reval_Scheduler_Dump	The table stores the shedular information
6	Smn_Invent_Reval_StockReval_Det	The table is used to store Stock valuation information
7	SMN_LFBAL_FIFO_LIFO_PART_RATE	This table contains Available Quantity information for a part following FIFO/LIFO costing methodology. The available quantity is maintained at the part - part status - as on date - rate no level This information is maintained at Receipt Level because sub
8	SMN_LFRT_LIFOFIFO_RATE_DTL	the table to store the lifoffifo rate informations
9	Smn_MntCore_Amend_Dtl	used to store the ameneded details of main core details
10	Smn_MntCore_Core_Dtl	used to store the details of main core details
11	SMN_MNTPOOL_AGT_DTL	maitanance pool agent table
12	SMN_PARTSRL_CHG_ERROR_LOG	part serial change error log table
13	SMN_PARTSRL_CHG_IMP_DTL	part serial change implement information table
14	SMN_PARTSRL_CHG_REC_DTL	part serial change records detail table
15	SMN_PARTSRL_CHG_REC_HDR	part serial change detail table
16	SMN_PART_OWNERSHIP_TRNS_DTL	part ownership transaction detail table
17	SMN_PART_SER_KEY_GEN	autmatic part serial number generation information table
18	SMN_PDSPPR_SPECPART_PNDDMND	For a particular demand lineitem, if specific part requests are there and if it is not met, that specific serial no needs to be pushed as pending demand
19	SMN_PGARC_PEGGED_ACT_RCPTS	For each pending demand, the action taken by the system or the material planner is recorded here. Basically the planned receipt coverage information (STO or PR) for an MR Lineitem is maintained here. Once the pending demand gets fully processed, th
20	SMN_PLSL_STORE_OPRN_LINK_META	Table to manage Store opertion link metadata
21	SMN_PLSO_STORE_OPERATION_META	Table to manage Store opertion search metadata
22	SMN_PRDMD_PROCESSED_DEMANDS	Whenever hard allocation fails, it is treated as a pending demand and an entry is pushed into this table. Any action that is initiated for the pending demands (whether STO/STI/PR/ISSUE creation) either by the Material Planner or by the system (automatic
23	SMN_PRICEVAR_CORR_SUMMARY	stock correction parice variance summary table
24	SMN_PRICEVAR_INPDET	stcok management price variance information table
25	SMN_PRICEVAR_PROCDET	the price variance information table
26	SMN_PRICEVAR_STKCORREC_LOG	the proce variance for stock correction information table
27	smn_prtinsp_prt_insp_Dtl	the part inspection details table
28	smn_pscc_prtsrlnc_condchng_log	Table to manage part serial condition change log table
29	smn_psexmod_prtsrl_exchmod_log	Table to manage Part Exchange mod log table
30	SMN_PST_PRTSRLLOT_SRCH_META	part serial search metadata table
31	SMN_REPLENISHMENT_ERROR_LOG	the replishment error log table
32	Smn_Rep_PlanRepAvlQty	replishment plan available table
33	SMN_RTNVAL_VALUATION_POLICY	used to store the valuation details..
34	SMN_SCRDT_STDCOSTREVAL_DTL	used to store the standard cost details...
35	SMN_SCRMN_STDCOSTREVAL_HDR	the standard codt value information table
36	SMN_SET_OPTION_BACKEND_VALUES	Table to manage SMN tech log Status setoption
37	Smn_ShelLifeUpd_Dtl	Table used to store the history of shelf life update for part
38	SMN_SMNATT_SRL_PART_ATTRIB	For the Stock Maintained, this entity contains the attribute details for a serial controlled part
39	SMN_SMNDA_DOC_ATTACH_DTL	Used to store the reference douments attached to it
40	SMN_SMNDMN_WHLVLDEAMON_INFO	This table stores the Daemon Initiated Datetime and the warehouse tarnsaction date range processed. Let s say, the daemon is executed for the first time on 10th Jan 03 (i.e. the system date on which the daemon is executed is 10th Jan 03 10 pm). All the w
41	SMN_SMNDTISU_DATEWISE_ISSUE	This table is a denormalized structure (with required data for reports) of issue hdr, issue dtl and unplanned issue dtl to see at overview level. It also has the Stock Status Conversion Old Status transaction getting treated as Issue In future, this ta
42	SMN_SMNDTRCPT_DATEWISE_RCPT	This table stores all datewise receipt (all receipts - Return, Stock Trnsfer, Receipt, GR, OpBal, etc) made for all type of parts.
43	SMN_SMNHD_DOC_HARD_ALLOC_DTL	For the stock maintained, there could be zero or more hard allocation details for a non disposition part.
44	SMN_SMNHPD_PENDING_DEMANDS	Whenever hard allocation fails , it is treated as a pending demand and an entry is pushed into this table. Any action that is initiated for the pending demands (whether STO/STI/PR/ISSUE creation) either by the Material Planner or by the system (automatic
45	SMN_SMNINQDTL_DRILLDOWN_DTL	used to stoe the Drilldown table
46	SMN_SMNINQRTNDTL_DRILLDOWN_DTL	the table used to store the detailed level of all transactions
47	SMN_SMNINQSUM_DRILLDOWN_SUM	the table used to store the square off information of all transaction
48	SMN_SmnInqTranSqr_DrillDown_Dtl	The table used to store the finance level transaction square off information
49	SMN_SmnInqTran_DrillDown_Dtl	The table stores the finance level transaction information
50	SMN_SMNINTMAT_INTRANSIT_MATERIAL	the transaction intransit material information table
51	SMN_SMNOBDTMP_OPBAL_DTL	openieng balance document detailed information table
52	SMN_SMNOBD_OPENING_BAL_DTL	used to store the opening balance details
53	SMN_SMNOBHTMP_OPBAL_HDR	openieng balance document header information table
54	SMN_SMNOBH_OPENING_BAL_HDR	used to store the openning balance details
55	SMN_SMNOPNCLS_DATEWISE_BAL	This table will have the datewise opening and closing balance details for location-warehouse-part
56	SMN_SMNOPNCLS_PERIODWISE_BAL	the whole transaction period wise table informations
57	SMN_SMNOPSET_OPT_SETTINGS	used to store the set options details
58	SMN_SMNPRMTMP_OBPRM_DTL	opening balance parameter table
59	SMN_SMNPRM_OPBAL_PARAM_DTL	used to store the parameter information of openning balance
60	SMN_SMNPRM_PARAMETER_DETAILS	Stores Parameter detail information. In this component, this table needs to store only search criteria message
61	SMN_SMNPRM_SRL_PARAM_VAL	For the Stock Maintained, this entity contains the initial parameter value details for serial controlled component type of parts at the time of original receipt.
62	SMN_SMNQC_QUICK_CODE	This table maintains the Quick Code information. Quick Code type referred are - Maintenance Report User Status and Reason for Carry forward
63	SMN_SMNSD_SHIP_DTL	shipment history table
64	SMN_SMNSRLTMP_OPBAL_SL_DTL	opening balance serial lot information table
65	SMN_SMNSRL_OPBAL_SRLLOT_DTL	used to store the serial lot details of openning balance
66	SMN_SMNSTKSTAT_OPT_SETTINGS	stock option settings
67	SMN_SMNTMP1_OPNG_BAL_DTL	stcok management opening balance detailed information table
68	SMN_SMNWHCATG_OPT_SETTINGS	option settings table
69	SMN_SMN_SRL_LOT_SCH_HDR	the stock management serial lot history header information table
70	SMN_STKCRDA_DOC_ATTACH_DTL	used to store the reference document attached to the stock correction
71	SMN_STKCRDT_STOCK_CORR_DTL	used to store the part levevl information of stock corretion
72	SMN_STKCRDT_STOCK_CORR_DTL_RA	stock correction detailed information table
73	SMN_STKCRMN_STOCK_CORR_HDR	This entity contains the stock correction main information like warehouse where the stock correction happens, type of the correction, specific comments if any and the status of the stock correction.
74	SMN_STKCRPRM_STKCORR_PARAM	used to store the parammeter infomation of the stock correction
75	SMN_STKCRRC_CORR_SPEC_RCPT	used to store the stock correction specific serial level inforamtion
76	SMN_STKCRSL_STKCORR_SRLLOT	This table used store the stock correction serial lot details table...
77	SMN_STKCRVL_STKCORR_VAL_DTL	This table is used to stored the value details of stock correction..
78	SMN_STOCK_ASONDATE_DTL	This table is used to store stock asn value s
79	SMN_TRANSACTION_DOCSTATUS	the table to store the transaction document status
80	SMN_WGHBAL_WGH_AVG_PART_VALUE	This table contains Available Quantity information for a part following Weighted Average costing methodology. The available quantity is maintained at the part - part status level
81	SMN_WGTACT_WHGTAVG_ACT_COST	This table is used to store the weighted average details.
82	SMN_WGTDT_WGAVG_MLTRATE_DTL	material detailrs table..

Table Name :	SMN_BAL_WHZNBN_LOT_SRL_LVL_BAL
Comment :	This table contains available or balance quantity at part - part status - warehouse - zone - bin - lot - serialno level.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BAL_SMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Source OUInstance in an interacting set of OUs	No
BAL_WAREHOUSE_OUINSTANCE	_decimal_10_0	decimal(10)	No	Warehouse Created OUinstance	No
BAL_WAREHOUSE_ID	_varchar_10	varchar(10)	No	Warehouse level lock should be made before checking for qty availability and balance update Will be ## when source is Cfg of Ac	No
BAL_ZONE_ID	_varchar_10	varchar(10)	No	This has to be stored as ## if the part is received in a FREE Warehouse	No
BAL_BIN_ID	_varchar_10	varchar(10)	No	This has to be stored as ## if the part is received in a FREE Warehouse or in a FREE Zone	No
BAL_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Crated OUInstance	No
BAL_PART_NO	_varchar_40	varchar(40)	No	Any stockable part can be stored here	No
BAL_PART_CONDITION	_varchar_5	varchar(5)	No	Part Condition O - Overhauled N - New S - Serviceable U - UnServiceable	No
BAL_PART_STATUS	_varchar_40	varchar(40)	No	Can take any value as defined in UDSS which are stockable	No
BAL_SERIAL_NO	_varchar_40	varchar(40)	No	For serial controlled parts, the exact serial # being issued.	No
BAL_LOT_NO	_varchar_18	varchar(18)	No	For lot controlled parts, the lot # from which the parts are being issued.	No
BAL_PART_PLN_OU	_decimal_10_0	decimal(10)	Yes	Part Planning OUInstance (last updated part planning ou) Part Actual Cost is maintained for the part at this part planning level. For other parts, this can be null.	No
BAL_SOURCE_FLAG	_varchar_5	varchar(5)	Yes	Gives the source of the stock record. If the stock comes from unplanned receipt , then this field will contain UPR as source and if it comes from configuration, then this field will contain CFG as source. The following lists sourceFlags and thei	No
BAL_SOURCE_DOC_OU	_decimal_10_0	decimal(10)	Yes	Original Source document OU (Receipt or GR or Opening Balance or Aircraft No or Config No) which created the Stock Balance	No
BAL_SOURCE_DOC_NO	_varchar_40	varchar(40)	Yes	Original Source document no (Receipt or GR or Opening Balance or Aircraft No or Config No) which created the Stock Balance	No
BAL_SOURCE_DOC_RCPT_DATE	_datetime_8	datetime(8)	Yes	Receipt Date of GR Or Openning Balance or Receipt transaction	No
BAL_LASTUPD_DOC_TYPE	_varchar_25	Varchar(25)	Yes	OPBAL - Opening Balance UPLREC - Unplanned Receipt GR - Goods Receipt CFG - Configuration AC - Aircraft STKTRN - Intra Stock Transfer ISU - Issue RTN - Return SSC - S	No
BAL_LASTUPD_DOC_OU	_decimal_10_0	decimal(10)	Yes	Last updated Source document OU (Receipt or GR or Opening Balance or Issue or Aircraft or Config) which updated the Stock Balance	No
BAL_LASTUPD_DOC_NO	_varchar_40	varchar(40)	Yes	Last updated Source document No (Receipt or GR or Opening Balance or Issue or Aircraft or Config) which updated the Stock Balance	No
BAL_REF_SERIAL_NO	_varchar_40	varchar(40)	Yes	Referance Serial No or Manufacturer Serial No	No
BAL_REF_LOT_NO	_varchar_18	varchar(18)	Yes	Referance Lot No	No
BAL_AVAILABLE_QTY	_decimal_28_8	decimal(28)	Yes	Quantity is stored at the stock uom	No
BAL_AVLQTY_INVOLUOM	_decimal_28_8	decimal(28)	Yes	This will be available quantity in Bin volume uom if the zone is a normal zone. This will be available quantity in Zone Volume uom if the warehouse is a normal warehouse and zone is a free zone. This will be available quantity in Warehouse volume	No
BAL_AVLQTY_INWGHUOM	_decimal_28_8	decimal(28)	Yes	This will be available quantity in Bin weight uom if the zone is a normal zone. This will be available quantity in Zone weight uom if the warehouse is a normal warehouse and zone is a free zone. This will be available quantity in Warehouse weight	No
BAL_HARD_ALLOC_QTY	_decimal_28_8	decimal(28)	Yes	Hard Allocated qty for the key details	No
BAL_ACT_VALUATION_RATE	_decimal_28_8	decimal(28)	Yes	This column value will be NULL for all parts except those parts which follow Actual Valuation costing method	No
BAL_RCVD_ACT_RATE	_decimal_28_8	decimal(28)	Yes	This will the actual rate at which the stock got received for Consignment goods. Stock value to be taken into inventory only upon conversion	No
BAL_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	Certificate Type. This attribute is applicable only for serial controlled parts. It is originally defined in Logistics Common master component. The certificate type is specified in the Receipt component when the stock is received. The same is store	No
BAL_CERTIFICATE_NO	_varchar_40	varchar(40)	Yes	Certificate No This attribute is applicable only for serial controlled parts.The certificate No is specified in the Receipt component when the stock is received. The same is stored here.	No
BAL_CERTIFICATE_DATE	_datetime_8	datetime(8)	Yes	Certificate Date This attribute is applicable only for serial controlled parts.The certificate Date is specified in the Receipt component when the stock is received. The same is stored here.	No
BAL_AUTH_NO	_varchar_40	varchar(40)	Yes	Authorization No. Applicable for serial controlled part	No
BAL_SYS_TRACKING_REF	_varchar_40	varchar(40)	Yes	Tracking Referance Applicable for Serial controlled parts.	No
BAL_RECEIPT_COST	_decimal_28_8	decimal(28)	Yes	Will be NULL for those parts which are not of type Std Cost costing methodology. Total Receipt Value accumulated for std part item	No
BAL_TOT_STD_COST	_decimal_28_8	decimal(28)	Yes	Will be NULL for those parts which are not of type Std Cost costing methodology. Total Value accumulated for std part item	No
BAL_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	Component Ou	No
BAL_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component Id	No
BAL_OLD_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part No (Ou) of the component prior to modification	No
BAL_OLD_PART_NO	_varchar_40	varchar(40)	Yes	Part No of the component prior to modification	No
BAL_OLD_PART_SRL	_varchar_40	varchar(40)	Yes	Old Serial no of the component prior to modification of the same	No
BAL_OLD_COMP_OU	_decimal_10_0	decimal(10)	Yes	Old Component id (ou) for the part serial	No
BAL_OLD_COMP_ID	_varchar_40	varchar(40)	Yes	Old Component id for the part serial	No
BAL_WARRANTY_LAPSE_DATE	_datetime_8	datetime(8)	Yes	Warranty laspe date for the serial controlled parts	No
BAL_ACCONFIG_FLAG	_varchar_5	varchar(5)	Yes	This will indicate whether the Part-Serial got originally created from Aircraft or Configuration component. First-time SourceFlag and AcConfig Flag will be same. Subsequently on return source flag will get overwritten	No
BAL_SRL_EXPIRY_DATE	_datetime_8	datetime(8)	Yes	Expiry Date for the serial controlled part For GR, either GR Date or Inspection Date whichever is latest + Designed Shelf Life For receipt, it is the Receipt Date + Part Design Shelf life For OpBal, it is the Op Bal Date + Part Design Shelf life	No
BAL_FIRSTISU_FLAG	_varchar_25	Varchar(25)	Yes	For component type of parts, this will indicate whether the first issue for the component has been made or not. It will take the following values. Y if the component has been issued out. N if the component has not been issued at all. NULL if th	No
BAL_SERIAL_RUNNING_NO	_decimal_10_0	decimal(10)	Yes	current Serial number	No
BAL_SERIAL_NO_PREFIX	_varchar_6	varchar(6)	Yes	prefix for the serial number generation	No
BAL_SERIAL_NO_SUFFIX	_varchar_6	varchar(6)	Yes	suffix for the serial number generation	No
BAL_OWNERSHIP	_varchar_5	varchar(5)	Yes	holds the ownership of the part CUS - Customer SUP - Supplier OWN - Internal	No
BAL_OWNINGAGENCY	_varchar_45	varchar(45)	Yes	holds the owner name	No
BAL_OWNINGAGENCY_OU	_decimal_10_0	decimal(10)	Yes	holds the owner location instance	No
BAL_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User Name	No
BAL_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
BAL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User Name	No
BAL_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	LAst Modified Date	No
BAL_ASSET_NO	udd_assetnumber	varchar(18)	Yes	asset number	No
BAL_ASSET_TAG	udd_assettagno	int(4)	Yes	asset tag number	No
BAL_ASSET_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	holds the user name who modified the asset	No
BAL_ASSET_MODIFIED_DATE	udd_date	varchar(15)	Yes	modified date	No
BAL_PROPOSAL_NO	udd_documentno	varchar(40)	Yes	the proposal number	No
BAL_VALUE	udd_amount	numeric(13)	Yes	value of the asset	No
BAL_SOURCE_RTN_DOC_OU	udd_ctxt_ouinstance	int(4)	Yes	document ou	No
BAL_SOURCE_RTN_DOC_NO	udd_refdocno	varchar(40)	Yes	document number	No
BAL_COREVALUE	udd_amount	numeric(13)	Yes	core value of the part(life time costing)	No
BAL_VARVALUE	udd_amount	numeric(13)	Yes	variable value of the part(life time costing)	No
Bal_Qur_status	udd_documentno	varchar(40)	Yes	The quarantined status of the part	No
Bal_Qur_RefDocType	udd_flag	varchar(25)	Yes	the reference document type of the quarantined part	No
Bal_Qur_RefDocNo	udd_documentno	varchar(40)	Yes	the reference doc no of the quarantined part	No
BAL_SOURCE_DOC_LINENO	udd_seqno	int(4)	Yes	the line no of the source document of the part	No
BAL_SEQ_NO	udd_count	int(4)	No	the uniquew sequence id of each part in the table	Yes
BAL_DEVIATED_PART_FLAG	udd_designparamcode	varchar(5)	Yes	the part deviated or not	No
BAL_DEVIATED_COMMENTS	UDD_Comments	char(256)	Yes	if the part is deviated part then deviation comments	No
created_area_code	_Varchar_40	varchar(40)	Yes	the area code of the part record where it is created	No
BAL_OFFLINE_AREA	udd_documentno	varchar(40)	Yes	the part is in main base or in any one of the field base	No
BAL_AREA_UPD_SER	udd_ctxt_service	varchar(32)	Yes	the service by which the part record is marked as offline record	No
BAL_Stock_Currency	udd_currency	varchar(20)	Yes	currency	No

Table Name :	SMN_DATEWISE_CMAV_INFO
Comment :	used to store weighted average details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DATEWISE_PART_OU	_decimal_10_0	decimal(10)	Yes	part ou	No
DATEWISE_PART_NO	_varchar_40	varchar(40)	Yes	part number	No
DATEWISE_PARTSTATUS	_varchar_40	varchar(40)	Yes	part status	No
DATEWISE_DATED	_datetime_8	datetime(8)	Yes	date	No
DATEWISE_VALUE	_decimal_28_8	decimal(28)	Yes	value of the part	No
DATEWISE_QUANTITY	_decimal_28_8	decimal(28)	Yes	Quantity	No
DATEWISE_CMAV_COST	_decimal_28_8	decimal(28)	Yes	part cost	No
DATEWISE_FLAG	_char_2	char(2)	Yes	holds the value Y - yes and N - no	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	Smn_Invent_Reval_BalSheet_Det
Comment :	The table is used to store the detailed Inventory Valuation information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Smn_BS_Reval_OuInstance	udd_ctxt_ouinstance	int(4)	No	Stock Maintanance Component OU instance value.	No
Smn_BS_Reval_Doc_No	udd_documentno	varchar(40)	No	Inventory Revaluation Document number.	No
Smn_BS_Reval_Part_CrtOU	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU Instance value	No
Smn_BS_Reval_Part_No	udd_partno	varchar(40)	Yes	Part Number used for Inventory Revaluation	No
Smn_BS_Reval_Warehouse_Ou	udd_ctxt_ouinstance	int(4)	Yes	Warehouse created OU instance value	No
Smn_BS_Reval_Serial_No	udd_partserialnumber	varchar(40)	Yes	Part serial number used to calculate the Inventory Revaluation.	No
Smn_BS_Reval_Lot_No	udd_lotno	varchar(18)	Yes	Part Lot number used to calculate the Inventory Revaluation.	No
Smn_BS_Reval_WarehouseId	udd_warehouse	varchar(10)	Yes	Warehouse number used to take the part to calculate the Inventory Revaluation.	No
Smn_BS_Reval_Stock_Status	udd_status	varchar(25)	Yes	Stock status of the part used for Inventory Revaluation.	No
Smn_BS_Reval_Part_Type	udd_type	varchar(25)	Yes	Part type of the part used for Inventory Revaluation.	No
Smn_BS_Reval_Tot_Qty	udd_quantity	numeric(13)	Yes	Total quantity of the part in stock used for Inventory Revaluation.	No
Smn_BS_Reval_Unit_Rate	udd_rate	numeric(13)	Yes	Unit rate for the Part.	No
Smn_BS_Reval_Sys_Market_Rate	udd_rate	numeric(13)	Yes	Market rate (lowest cost from the supplier for that part) taken from the system.	No
Smn_BS_Reval_Market_Rate	udd_rate	numeric(13)	Yes	Market rate (lowest cost from the supplier for that part) updated by the user.	No
Smn_BS_Reval_Tot_Stock_Value	udd_amount	numeric(13)	Yes	Total Quantity * Unit Rate.	No
Smn_BS_Reval_Tot_Market_Value	udd_amount	numeric(13)	Yes	Total Quantity * Market Rate (User updated value)	No
Smn_BS_Reval_Zone	udd_zone	varchar(10)	Yes	Zone details where the part available.	No
Smn_BS_Reval_Bin	udd_bin	varchar(10)	Yes	Bin details where the part available.	No
Smn_BS_Reval_Supplier_No	udd_vendorcode	varchar(45)	Yes	Supplier number who supplier the part for the lowest cost.	No
Smn_BS_Reval_Totvalue_comp	udd_amount	numeric(13)	Yes	This column holds the total value	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	the unique identification number	Yes

Table Name :	Smn_Invent_Reval_Hdr
Comment :	The table is used to store the header levelInventory Valuation information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Smn_Reval_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Stock Maniatanance OU Instance value	Yes
Smn_Reval_Doc_No	udd_documentno	varchar(40)	No	Stock Revaluation Document number	Yes
Smn_Reval_Created_date	udd_time	datetime(8)	Yes	To store the Created date.	No
Smn_Reval_Period	fin_financeperiod	varchar(15)	No	Stock revaluation period.	Yes
Smn_Reval_PartType	udd_type	varchar(25)	Yes	To Store the Part type	No
Smn_Reval_Acc_Usage	fin_usageid	varchar(20)	Yes	To store the accounting usage.	No
Smn_Reval_Cost_Usage	fin_usageid	varchar(20)	Yes	To store the costing usage	No
Smn_Reval_Type	udd_type	varchar(25)	Yes	To store the revaluation type.	No
Smn_Reval_Basis	udd_basis	varchar(8)	Yes	To Store the revaluation basis.	No
Smn_Reval_Method	udd_flag	varchar(25)	Yes	To Store the revaluation method.	No
Smn_Reval_Level	udd_flag	varchar(25)	Yes	To Store the revaluation level.	No
Smn_Reval_Warehouse_Ou	udd_ctxt_ouinstance	int(4)	Yes	Store the Warehouse created OU instance.	No
Smn_Reval_Warehouse_Id	udd_warehouse	varchar(10)	Yes	To Store the warehouse number	No
Smn_Reval_Computed_Value	udd_amount	numeric(13)	Yes	To store the computed value.	No
Smn_Reval_Revaluated_Value	udd_amount	numeric(13)	Yes	To Store the revaluated value	No
Smn_Reval_Base_Currecny	fin_currency	varchar(5)	Yes	To Store the Base Currreny.	No
Smn_Reval_Exchg_Rate	udd_amount	numeric(13)	Yes	To Store the exhange rate.	No
Smn_Reval_JV_Doc_No	udd_documentno	varchar(40)	Yes	To store the Journal Voucher document number.	No
Smn_Reval_Affected_Items	udd_count	int(4)	Yes	To store the total number of items affected while computing revaluation.	No
Smn_Reval_Stock_Value	udd_amount	numeric(13)	Yes	To store the total stock value	No
Smn_Reval_Stock_Correction_No	udd_documentno	varchar(40)	Yes	To store the stock correction number.	No
Smn_Reval_Stock_Remarks	udd_remarks	varchar(255)	Yes	To store the user remarks	No
Smn_Reval_Stock_FileName	udd_filename	varchar(50)	Yes	To store the stock revaluation file name.	No
Smn_Reval_BS_Remarks	udd_remarks	varchar(255)	Yes	To store the Balance sheet remarks.	No
Smn_Reval_BS_FileName	udd_filename	varchar(50)	Yes	To store the balance sheet file name.	No
Smn_Reval_LastUpdated_By	udd_ctxt_user	varchar(30)	Yes	To store the last updated user.	No
Smn_Reval_LastUpdated_Date	udd_time	datetime(8)	Yes	To store the last updated date.	No
Smn_Reval_Created_By	udd_ctxt_user	varchar(30)	Yes	To store the created user.	No

Table Name :	Smn_Invent_Reval_Scheduler_Dump
Comment :	The table stores the shedular information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Smn_Schd_Reval_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Stock Mainatance Ouinstance	Yes
Smn_Schd_Reval_Period	fin_financeperiod	varchar(15)	No	Inventory Revaluation Period Taken from the Finance component.	Yes
Smn_Schd_Reval_DateTime	udd_time	datetime(8)	No	Revaluation Date and Time	Yes
Smn_Schd_Reval_Part_No	udd_partno	varchar(40)	No	Inventory Revaluation Part Number	Yes
Smn_Schd_Reval_Part_Ou	udd_ctxt_ouinstance	int(4)	No	Part Created Ouinstance Value	Yes
Smn_Schd_Reval_WarehouseId	udd_warehouse	varchar(10)	No	Inventory Revaluation Warehouse id	Yes
Smn_Schd_Reval_WarehouseOu	udd_ctxt_ouinstance	int(4)	No	Warehouse Created OU Instance value	Yes
Smn_Schd_Reval_Serial_No	udd_partserialnumber	varchar(40)	No	Inventory Revaluation Part Serial Number	Yes
Smn_Schd_Reval_Lot_No	udd_lotno	varchar(18)	No	Inventory Revaluation Part Lot Number	Yes
Smn_Schd_Reval_Part_Status	udd_partstatus	varchar(40)	No	Stock Status of the part defined in Inventory Revaluation	Yes
Smn_Schd_Reval_Zone	udd_zone	varchar(10)	No	Zone details for the part where it is located.	Yes
Smn_Schd_Reval_Bin	udd_bin	varchar(10)	No	Bin details for the Part where it is located.	Yes
Smn_Schd_Reval_Avail_Qty	udd_quantity	numeric(13)	Yes	Quantity available in the Stock for the given part.	No
Smn_Schd_Reval_Alloc_Qty	udd_quantity	numeric(13)	Yes	Quantity allocate for the given part in the Stock	No
Smn_Schd_Reval_Rate	udd_rate	numeric(13)	Yes	User define rate	No
Smn_Schd_Reval_Valuation_Type	udd_type	varchar(25)	Yes	Valuation Type to calculate the Inventory Revaluation.	No
Smn_Schd_Reval_Ref_No	udd_documentno	varchar(40)	Yes	Reference number if any	No
Smn_Schd_Reval_Ref_Date	udd_time	datetime(8)	Yes	Reference date	No
Smn_Schd_Reval_StockUom	udd_uom	varchar(15)	Yes	Stock UOM for the part available in the Stock	No
Smn_Schd_Reval_User	udd_ctxt_user	varchar(30)	Yes	User details	No
Smn_Schd_Reval_Language	udd_ctxt_language	int(4)	Yes	Language (Fwcontext)	No
Smn_Schd_Reval_Supplier	udd_vendorcode	varchar(45)	Yes	Part supplier who supplies for the minimum rate among various supplier.	No
Smn_Schd_Reval_MarketRate	udd_amount	numeric(13)	Yes	Lower of cost among various supplier for that Part.	No
Smn_Schd_Reval_PartType	udd_type	varchar(25)	Yes	Part type for the Part.	No
Smn_Schd_Reval_Processed	udd_flag	varchar(25)	Yes	It is a Flag column which denotes for that Part,Serial, Line Inventory Revaluation has already happened or Not.	No

Table Name :	Smn_Invent_Reval_StockReval_Det
Comment :	The table is used to store Stock valuation information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Smn_Stk_Reval_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Inventory Revaluation OU value	No
Smn_Stk_Reval_Doc_No	udd_documentno	varchar(40)	No	Inventory Revaluation Document Number	No
Smn_Stk_Reval_Part_No	udd_partno	varchar(40)	Yes	Inventory Revaluation Part Number	No
Smn_Stk_Reval_Part_CrtOu	udd_ctxt_ouinstance	int(4)	Yes	Inventory Revaluation Part created OU instance value	No
Smn_Stk_Reval_Warehouse_Ou	udd_ctxt_ouinstance	int(4)	Yes	Inventory Revaluation Warehouse created OU instance	No
Smn_Stk_Reval_Serial_No	udd_partserialnumber	varchar(40)	Yes	Inventory Revaluation Part Serial Number	No
Smn_Stk_Reval_Lot_No	udd_lotno	varchar(18)	Yes	Inventory Revaluation Part Lot Number	No
Smn_Stk_Reval_Stock_Status	udd_status	varchar(25)	Yes	Inventory Revaluation Part Stock Status	No
Smn_Stk_Reval_Part_Type	udd_type	varchar(25)	Yes	Inventory Revaluation Part Type	No
Smn_Stk_Reval_Tot_Qty	udd_quantity	numeric(13)	Yes	Inventory Revaluation Total Quantity	No
Smn_Stk_Reval_Unit_Rate	udd_rate	numeric(13)	Yes	Inventory Revaluation Unit rate of the Part.	No
Smn_Stk_Reval_Market_Value	udd_amount	numeric(13)	Yes	To fetch the lowest supplier rate for the Part.	No
Smn_Stk_Reval_Current_Value	udd_amount	numeric(13)	Yes	Current value = Total Qty * Unit rate	No
Smn_Stk_Reval_LCM_Value	udd_amount	numeric(13)	Yes	LCM Value = Total Quantity * Market rate	No
Smn_Stk_Reval_Supplier_No	udd_vendorcode	varchar(45)	Yes	Inventory Revaluation Supplier Number. This should be the supplier who supplies the part for the minimum price among various supplier.	No
Smn_Stk_Reval_Part_ActGrp	udd_group	varchar(25)	Yes	Inventory Revaluation Part belongs to the particular Part group	No
Smn_Stk_Reval_Zone	udd_zone	varchar(10)	Yes	Inventory Revaluation Zone for the Part located	No
Smn_Stk_Reval_Bin	udd_bin	varchar(10)	Yes	Warehouse Bin where the part is located	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	The unique identification no	Yes

Table Name :	SMN_LFBAL_FIFO_LIFO_PART_RATE
Comment :	This table contains Available Quantity information for a part following FIFO/LIFO costing methodology. The available quantity is maintained at the part - part status - as on date - rate no level This information is maintained at Receipt Level because sub

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LFBAL_SMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Created ouinstance	Yes
LFBAL_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created OUinstance	Yes
LFBAL_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	Yes
LFBAL_PART_NO	_varchar_40	varchar(40)	No	Any stockable part can be stored here	Yes
LFBAL_PART_STATUS	_varchar_40	varchar(40)	No	Can take any value as defined in UDSS which are stockable	Yes
LFBAL_AS_ON_DATE	_datetime_8	datetime(8)	No	Stock received Date	Yes
LFBAL_RATE_NO	_decimal_10_0	decimal(10)	No	A unique number generated for each receipt entry	Yes
LFBAL_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	This will be the warehouse location id. If the option setting for Stock Cost Evaluation is Location level, then this column would not be used in the condition while arriving at the lifo-fifo rate.	Yes
LFBAL_WAREHOUSE_ID	_varchar_10	varchar(10)	No	This will be the warehouse id. If the option setting for Stock Cost Evaluation is Location level, then this column would not be used in the condition while arriving at the lifo-fifo rate.	Yes
LFBAL_RECEIPT_TYPE	_varchar_10	varchar(10)	No	This will have the receipt document type. Stock can be received thru GoodsReceipt, Unplanned Receipt, Stock Transfer Receipt, Return etc...	Yes
LFBAL_RECEIPT_OU	_decimal_10_0	decimal(10)	No	OU Instance of the Receipt Document	Yes
LFBAL_RECEIPT_NO	_varchar_40	varchar(40)	No	Original Receipt Document No thru which the stock entries got recorded	Yes
LFBAL_RECEIPT_QTY	_decimal_28_8	decimal(28)	Yes	receipt Qty in stock uom	No
LFBAL_AVAILABLE_QTY	_decimal_28_8	decimal(28)	Yes	This is the consolidated qty for FIFO/LIFO parts ReceiptDocNo-Part-PartStatus-AsOnDate-Rate combination, .	No
LFBAL_FIFO_LIFO_RATE	_decimal_28_8	decimal(28)	Yes	Lifo and Fifo Rate	No
LFBAL_CREATED_BY	_varchar_30	varchar(30)	No	Created User name	No
LFBAL_CREATED_DATE	_datetime_8	datetime(8)	No	Created Date	No
LFBAL_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified User	No
LFBAL_MODIFIED_DATE	_datetime_8	datetime(8)	No	Last Modified date	No

Table Name :	SMN_LFRT_LIFOFIFO_RATE_DTL
Comment :	the table to store the lifoffifo rate informations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LFRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Created ouinstance	Yes
LFRT_OPNG_BAL_NO	_varchar_40	varchar(40)	No	the openoing balance document no	Yes
LFRT_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	Yes
LFRT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ouinstance	Yes
LFRT_PART_NO	_varchar_40	varchar(40)	No	Any stockable part can be stored here	Yes
LFRT_SEQ_NO	_decimal_10_0	decimal(10)	No	A unique number generated for each receipt entry	Yes
LFRT_SYS_LINENO	_decimal_10_0	decimal(10)	No	the line no of the opening balance document	No
LFRT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	the quantity of the part in stock UOM	No
LFRT_RATE	_decimal_28_8	decimal(28)	Yes	the part rate	No
LFRT_VALUE	_decimal_28_8	decimal(28)	Yes	the part value	No
LFRT_REF_DOC_NO	_varchar_40	varchar(40)	Yes	the reference document no	No
LFRT_LINE_NO	udd_linenum	varchar(30)	No	the reference document line no	Yes

Table Name :	Smn_MntCore_Amend_Dtl
Comment :	used to store the ameneded details of main core details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AmendDtl_OuInstance	udd_ctxt_ouinstance	int(4)	No	Ou instance	No
AmendDtl_LineNo	udd_lineno	int(4)	Yes	line number of the part	No
AmendDtl_AmendNo	udd_count	int(4)	Yes	amendment number	No
AmendDtl_ComponentNo	udd_component	varchar(16)	Yes	Component Id	No
AmendDtl_Warehouse	udd_warehouse	varchar(10)	Yes	ware house number	No
AmendDtl_PartNo	udd_partno	varchar(40)	Yes	part number	No
AmendDtl_Serial_No	udd_documentno	varchar(40)	Yes	serial number	No
AmendDtl_CoreValue	udd_cost	numeric(13)	Yes	core value of the part	No
AmendDtl_VarValue	udd_cost	numeric(13)	Yes	amended variable value of the part	No
AmendDtl_TotValue	udd_cost	numeric(13)	Yes	total value of part ( ie core value + variable value)	No
AmendDtl_Created_By	udd_ctxt_user	varchar(30)	Yes	created by	No
AmendDtl_Created_Date	udd_datetime	varchar(30)	Yes	created date	No
AmendDtl_Updated_By	udd_ctxt_user	varchar(30)	Yes	updated by	No
AmendDtl_Updated_Date	udd_datetime	varchar(30)	Yes	updated date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	Smn_MntCore_Core_Dtl
Comment :	used to store the details of main core details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MntCore_OuInstance	udd_ctxt_ouinstance	int(4)	No	Ou Instance	No
MntCore_LineNo	udd_lineno	int(4)	Yes	line number of the part	No
MntCore_ComponentNo	udd_component	varchar(16)	Yes	component Id	No
MntCore_Warehouse	udd_warehouse	varchar(10)	Yes	warehouse number	No
MntCore_PartNo	udd_partno	varchar(40)	Yes	Part Number	No
MntCore_Serial_No	udd_documentno	varchar(40)	Yes	serial number	No
MntCore_CoreValue	udd_cost	numeric(13)	Yes	Core value of the part	No
MntCore_VarValue	udd_cost	numeric(13)	Yes	variable value of the part	No
MntCore_TotValue	udd_cost	numeric(13)	Yes	total value(core + variable) of the part	No
MntCore_RemainLife	udd_count	int(4)	Yes	remaining life time	No
MntCore_Status	udd_flag	varchar(25)	Yes	core status	No
MntCore_AmendNo	udd_count	int(4)	Yes	latest amendment number	No
MntCore_Remarks	udd_txt255	varchar(255)	Yes	remarks	No
MntCore_Created_By	udd_ctxt_user	varchar(30)	Yes	created by	No
MntCore_Created_Date	udd_datetime	varchar(30)	Yes	created date	No
MntCore_Updated_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
MntCore_Updated_Date	udd_datetime	varchar(30)	Yes	Modifeid Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_MNTPOOL_AGT_DTL
Comment :	maitanance pool agent table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MNTPOOL_OuInstance	udd_ctxt_ouinstance	int(4)	No	This column used for identify the OU.	No
MNTPOOL_AgtType	udd_flag	varchar(25)	No	This column Used to identify the Agreement Type	No
MNTPOOL_Category	udd_category	varchar(15)	Yes	This column Used to identify the Pool Category	No
MNTPOOL_PartNo	udd_partno	varchar(40)	No	Used to identify the Part number	No
MNTPOOL_LineNo	udd_seqno	int(4)	No	Used to Identify the Line number (created Automatically)	No
MNTPOOL_Item	udd_documentno	varchar(40)	No	Used to identify the Pool Item number	No
MNTPOOL_Quantity	udd_quantity	numeric(13)	No	Used to identify the Pool Quantity	No
MNTPOOL_UOM	udd_uom	varchar(15)	Yes	Used to identify the UOM	No
MNTPOOL_Station	udd_txt150	varchar(150)	Yes	Used to identify the Station code	No
MNTPOOL_NoofParticipant	udd_count	int(4)	Yes	Used to identify the No.Of particitipants	No
MNTPOOL_PoolCost	udd_amount	numeric(13)	Yes	Used to identify the Pool Cost	No
MNTPOOL_Currency	udd_currency	varchar(20)	Yes	Used to identify the Currency	No
MNTPOOL_FromDate	udd_datetime1	datetime(8)	Yes	This column is used for From Date.	No
MNTPOOL_ToDate	udd_datetime1	datetime(8)	Yes	This column is used for To Date.	No
MNTPOOL_Provider	udd_txt2000	varchar(2000)	Yes	Provider	No
MNTPOOL_Participant	udd_txt2000	varchar(2000)	Yes	This column is used for Pool Participant.	No
MNTPOOL_Status	udd_status	varchar(25)	Yes	This column used for Pool Status.	No
MNTPOOL_AgtRemarks	udd_remarks	varchar(255)	Yes	This column is used for Agreement Remarks.	No
MNTPOOL_Comments	UDD_Comments	char(256)	Yes	This column is used for Pool Comments.	No
MNTPOOL_FileName	udd_filename	varchar(50)	Yes	This column is used for Pool Filename.	No
MNTPOOL_Created_By	udd_ctxt_user	varchar(30)	Yes	This column used for Created User.	No
MNTPOOL_Created_Date	udd_datetime1	datetime(8)	Yes	This column is used for Created Date.	No
MNTPOOL_Updated_By	udd_ctxt_user	varchar(30)	Yes	This column used for identify Modified User.	No
MNTPOOL_Updated_Date	udd_datetime1	datetime(8)	Yes	This column used for Modified Date.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_PARTSRL_CHG_ERROR_LOG
Comment :	part serial change error log table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PARTSRL_OuInstance	udd_ctxt_ouinstance	int(4)	Yes	Orgonization Unit	No
PARTSRL_ChangeDocNo	udd_documentno	varchar(40)	Yes	Change document No	No
PARTSRL_ChgeBas	udd_doctype	varchar(40)	Yes	Change Basis	No
PARTSRL_ChgTyp	udd_doctype	varchar(40)	Yes	Change type	No
PARTSRL_ChgSts	udd_status	varchar(25)	Yes	Status	No
PARTSRL_ComponentID	udd_component	varchar(16)	Yes	Component ID	No
PARTSRL_CurrPartNo	udd_partno	varchar(40)	Yes	Current Part No	No
PARTSRL_CurrSerial	udd_partserialnumber	varchar(40)	Yes	Current Serial No	No
PARTSRL_CurrMfgSerialNo	udd_partserialnumber	varchar(40)	Yes	Current Mfr Serial No	No
PARTSRL_NewPartNo	udd_partno	varchar(40)	Yes	New Part No	No
PARTSRL_NewSerialNo	udd_partserialnumber	varchar(40)	Yes	New Serial No	No
PARTSRL_NewMfgSerialNo	udd_partserialnumber	varchar(40)	Yes	New Mfr Serial No	No
PARTSRL_LastAnlyDate	udd_date1	varchar(15)	Yes	Last Analysed date	No
PARTSRL_ERROR_MSG	udd_remarks	varchar(255)	Yes	Error Message	No
PARTSRL_ERROR_LINE	_int_0	int(0)	Yes	Error line No	No
PARTSRL_ERROR_PROC	udd_remarks	varchar(255)	Yes	Error Procedure	No
replication_key	_uniqueidentifier_0	uniqueidentifier(0)	No	replication keyunique number generated for each receipt entry	Yes

Table Name :	SMN_PARTSRL_CHG_IMP_DTL
Comment :	part serial change implement information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PARTSRL_OuInstance	udd_ctxt_ouinstance	int(4)	No	the part serial change created ou instance	Yes
PARTSRL_ChangeDocNo	udd_documentno	varchar(40)	No	the part serial change dicument no	Yes
PARTSRL_ComponentID	udd_componentid	varchar(90)	Yes	component id	No
PARTSRL_DocOU	udd_ctxt_ouinstance	int(4)	No	the document ou	Yes
PARTSRL_DocNo	udd_documentno	varchar(40)	No	document no in which the part resides	Yes
PARTSRL_DocType	udd_doctype	varchar(40)	No	document type in which the part resides	Yes
PARTSRL_DocStatus	udd_docstatus	varchar(15)	Yes	the document status	No
PARTSRL_Created_By	udd_ctxt_user	varchar(30)	Yes	created by	No
PARTSRL_Created_Date	_datetime_8	datetime(8)	Yes	created date	No
PARTSRL_Updated_By	udd_ctxt_user	varchar(30)	Yes	updated by	No
PARTSRL_Updated_Date	_datetime_8	datetime(8)	Yes	updated date	No

Table Name :	SMN_PARTSRL_CHG_REC_DTL
Comment :	part serial change records detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PARTSRL_OuInstance	udd_ctxt_ouinstance	int(4)	No	Part serial change Created ouinstance	Yes
PARTSRL_ChangeDocNo	udd_documentno	varchar(40)	No	part serial changeDocument no	Yes
PARTSRL_DocNo	udd_documentno	varchar(40)	No	Part serial involved document no	Yes
PARTSRL_DocType	udd_doctype	varchar(40)	No	part serial involved document type	Yes
PARTSRL_DocStatus	udd_status	varchar(25)	Yes	part serial involved document status	No
PARTSRL_RefDocno	udd_documentno	varchar(40)	Yes	part serial involved document ref docerence document no	No
PARTSRL_OwnRefDocNo	udd_documentno	varchar(40)	Yes	part serial involved document own reference doc no	No
PARTSRL_ParenDocNo	udd_documentno	varchar(40)	Yes	part serial involved document parent document no	No
PARTSRL_ParenDocType	udd_doctype	varchar(40)	Yes	part serial involved document parent document type	No
PARTSRL_Description	udd_txt2000	varchar(2000)	Yes	part serial change description	No
PARTSRL_Location	udd_wccode	varchar(30)	Yes	part serial change initiated warehouse	No
PARTSRL_CusOrderNo	udd_documentno	varchar(40)	Yes	part serial involved customer order no	No
PARTSRL_ChngAllowed	udd_doctype	varchar(40)	Yes	part serial change allowed or not flag	No
PARTSRL_Created_By	udd_ctxt_user	varchar(30)	Yes	Part serial change created person	No
PARTSRL_Created_Date	_datetime_8	datetime(8)	Yes	Part serial change created date	No
PARTSRL_Updated_By	udd_ctxt_user	varchar(30)	Yes	Part serial change updated person	No
PARTSRL_Updated_Date	_datetime_8	datetime(8)	Yes	Part serial change updated date	No
PARTSRL_RevNo	udd_revisionno	varchar(40)	No	Part serial Revision Number	Yes

Table Name :	SMN_PARTSRL_CHG_REC_HDR
Comment :	part serial change detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PARTSRL_OuInstance	udd_ctxt_ouinstance	int(4)	No	Part serial change Created ouinstance	Yes
PARTSRL_ChangeDocNo	udd_documentno	varchar(40)	No	part serial changeDocument no	Yes
PARTSRL_ChgeBas	udd_doctype	varchar(40)	Yes	Part serial change based on correction,engg direct change or engg change work execution	No
PARTSRL_ChgTyp	udd_doctype	varchar(40)	Yes	part serial change type , part change serial change or part and serial change	No
PARTSRL_ChgSts	udd_status	varchar(25)	Yes	status of the part serial change document	No
PARTSRL_ComponentID	udd_component	varchar(16)	Yes	The component id of the part serial which is to be modified	No
PARTSRL_PartCrtOU	udd_ctxt_ouinstance	int(4)	Yes	OU instance of the part.	No
PARTSRL_CurrPartNo	udd_partno	varchar(40)	Yes	current part no of the part which is to be modified	No
PARTSRL_CurrSerial	udd_partserialnumber	varchar(40)	Yes	current serial no of the part- serail which is to be modified	No
PARTSRL_CurrMfgSerialNo	udd_partserialnumber	varchar(40)	Yes	manufracted serial no of the part serial is been modified	No
PARTSRL_StkStatus	udd_status	varchar(25)	Yes	stock status	No
PARTSRL_PartType	udd_doctype	varchar(40)	Yes	part type	No
PARTSRL_RefDocOU	udd_ctxt_ouinstance	int(4)	Yes	ou instance of the reference document	No
PARTSRL_RefDocTyp	udd_doctype	varchar(40)	Yes	reference document type	No
PARTSRL_RefDocNo	udd_documentno	varchar(40)	Yes	reference doument no	No
PARTSRL_SourceDocDate	_datetime_8	datetime(8)	Yes	part serial source document date	No
PARTSRL_SourceDocNo	udd_documentno	varchar(40)	Yes	part serial source document number	No
PARTSRL_SourceDocRevNo	udd_documentno	varchar(40)	Yes	part serial source documents revesion no	No
PARTSRL_Ownership	udd_desc120	varchar(120)	Yes	Ownership	No
PARTSRL_OwngAgencyCode	udd_doctype	varchar(40)	Yes	Ownig Agency Code	No
PARTSRL_NewPartNo	udd_partno	varchar(40)	Yes	New Part No	No
PARTSRL_NewSerialNo	udd_partserialnumber	varchar(40)	Yes	New Serial No	No
PARTSRL_NewMfgSerialNo	udd_partserialnumber	varchar(40)	Yes	New Manufacture SerialNo	No
PARTSRL_chgDatetime	_datetime_8	datetime(8)	Yes	part serial change created date time	No
PARTSRL_LastAnlyDate	_datetime_8	datetime(8)	Yes	last transaction analysis	No
PARTSRL_LastTranDate	_datetime_8	datetime(8)	Yes	last transaction date	No
PARTSRL_LastTrnNo	udd_documentno	varchar(40)	Yes	last transaction document number	No
PARTSRL_LastTranType	udd_doctype	varchar(40)	Yes	last transaction document type	No
PARTSRL_ReaforChg	udd_txt2000	varchar(2000)	Yes	reason for the part serial change	No
PARTSRL_RefDetails	udd_txt2000	varchar(2000)	Yes	part serial change reference details	No
PARTSRL_ErrDetails	udd_txt2000	varchar(2000)	Yes	part serial change error details	No
PARTSRL_Counttran	udd_count	int(4)	Yes	part serial transaction count	No
PARTSRL_Remarks	udd_remarks	varchar(255)	Yes	Part serial remarks	No
PARTSRL_PartCost	udd_cost	numeric(13)	Yes	Part cost	No
PARTSRL_CsOUInStance	udd_ctxt_ouinstance	int(4)	Yes	Part serial ouinstance	No
PARTSRL_timestamp	udd_timestamp	int(4)	Yes	part serial change document timestamp	No
PARTSRL_Created_By	udd_ctxt_user	varchar(30)	Yes	Created User name	No
PARTSRL_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
PARTSRL_Updated_By	udd_ctxt_user	varchar(30)	Yes	Last Modified User	No
PARTSRL_Updated_Date	_datetime_8	datetime(8)	Yes	last modified date	No
PARTSRLWAR_OuInstance	udd_ctxt_ouinstance	int(4)	Yes	part serial warehouse ou instance	No
PARTSRL_Location	udd_documentno	varchar(40)	Yes	part serial warehouse	No
PARTSRL_Locidentifer	udd_txt255	varchar(255)	Yes	part serial location identifier	No
PARTSRL_OwngAgencyName	udd_txt255	varchar(255)	Yes	part serial owing agency name	No
PARTSRL_STOCK_UOM	udd_unitofmeasurement	varchar(10)	Yes	part stock UOM	No
PARTSRL_CNTRLTYPE	udd_flag	varchar(25)	Yes	Control Type of the Part	No
PARTSRL_EXPENSETYPE	udd_flag	varchar(25)	Yes	Expense type of the part	No
PARTSRL_EXPENSING_POLICY	udd_designparamcode	varchar(5)	Yes	Expensing policy of the part	No
PARTSRL_ISSUEBASIS	udd_designparamcode	varchar(5)	Yes	Issue basis of the part	No
PARTSRL_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	Not stockable attribute of the part	No
PARTSRL_VALUATION_METHOD	udd_designparamcode	varchar(5)	Yes	Valuation method of the part	No
PARTSRL_LoanOdrNo	udd_documentno	varchar(40)	Yes	loan order no	No

Table Name :	SMN_PART_OWNERSHIP_TRNS_DTL
Comment :	part ownership transaction detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_OUINSTANCE	ctxt_ouinstance	numeric(9)	No	Stock Maintenance OU instance	Yes
SMN_OWNTRANS_NO	UDD_DUMMYTOOLDEMO	varchar(30)	No	Document number for the Ownership Transferd	Yes
SMN_OWNTFR_LINENO	udd_lineno	int(4)	No	Stores the Line no for processing the issued parts	Yes
SMN_TRANS_TYPE	udd_designparamcode	varchar(5)	Yes	To store the Transfer Type values, TNR- Transfer No replacement, FE- Flat Exchange, RWC- Retain with customer	No
SMN_TRAN_DATE	udd_date	varchar(15)	Yes	Transaction Date	No
SMN_TOSTK_STATUS	udd_partstatus	varchar(40)	Yes	To store the Stock Status of the Ownership to be changed	No
SMN_CUSTOMER_ID	udd_customer_id	varchar(18)	Yes	Customer Number	No
SMN_CUST_ORDERNO	udd_documentno	varchar(40)	Yes	Customer Order Number	No
SMN_TURNIN_DOCTYP	udd_designparamcode	varchar(5)	Yes	To Store the Document Type	No
SMN_TURNIN_DOCNO	udd_documentno	varchar(40)	Yes	Document Number	No
SMN_LOCATED_AT	udd_designparamcode	varchar(5)	Yes	To Store the location details, WC- Workcenter, WH- Warehouse	No
SMN_LOCATION_NAME	udd_documentno	varchar(40)	Yes	To Store the details of the Warehouse number, Work Center number	No
SMN_PART_TYPE	udd_designparamcode	varchar(5)	Yes	To store the part type	No
SMN_TURNIN_PARTNO	udd_partno	varchar(40)	Yes	To store the part number	No
SMN_TURNIN_SERIALNO	udd_partserialnumber	varchar(40)	Yes	To store the part serial number	No
SMN_TURNIN_LOTNO	udd_lotno	varchar(18)	Yes	To store the part lot number	No
SMN_PART_QUANTITY	udd_quantity	numeric(13)	Yes	To store the part quantity available in the stock	No
SMN_FMSTK_STATUS	udd_partstatus	varchar(40)	Yes	To store the part stock status	No
SMN_ISSUE_DOCTYPE	udd_transactiontype	varchar(40)	Yes	To store the issue document type	No
SMN_ISSUE_DOCNO	udd_filename	varchar(50)	Yes	To store the issue document number	No
SMN_REPL_PARTNO	udd_partno	varchar(40)	Yes	To store the replaced part number	No
SMN_REPL_SERIALNO	udd_partserialnumber	varchar(40)	Yes	To store the replaced part serial number	No
SMN_REPL_LOTNO	udd_lotno	varchar(18)	Yes	To store the replaced part lot number	No
SMN_REPL_QTY	udd_quantity	numeric(13)	Yes	To store the replaced part quanity	No
SMN_SSC_NO	udd_filename	varchar(50)	Yes	To store the stock status conversion number	No
SMN_USER_STATUS	udd_quickcodes	varchar(25)	Yes	To store the user status	No
SMN_REMARKS	udd_txt255	varchar(255)	Yes	To store the Remarks	No
SMN_REFERENCE_NO	udd_documentno	varchar(40)	Yes	To store the reference number	No
SMN_OTHER_DETAILS	udd_hrclusterhead	varchar(75)	Yes	To store the other details	No
SMN_VALUATION_OPT	udd_designparamcode	varchar(5)	Yes	To store the valuation option as Zero Value	No
SMN_FILE_NAME	udd_filename	varchar(50)	Yes	To store the file name	No
SMN_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	To Store the Created By User	No
SMN_CREATED_DATE	_datetime_8	datetime(8)	Yes	To store the created date	No
SMN_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	To store the modified by user	No
SMN_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	To store the modified date	No

Table Name :	SMN_PART_SER_KEY_GEN
Comment :	autmatic part serial number generation information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Smn_key	udd_documentno	varchar(40)	Yes	SMN key for the part	No
Smn_OU	ctxt_ouinstance	numeric(9)	Yes	OU instance	No
Smn_Part_ou	ctxt_ouinstance	numeric(9)	Yes	part OPU	No
Smn_Partno	udd_partno	varchar(40)	Yes	Part Number	No
smn_Serialno	udd_partserialnumber	varchar(40)	Yes	serial number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_PDSPPR_SPECPART_PNDDMND
Comment :	For a particular demand lineitem, if specific part requests are there and if it is not met, that specific serial no needs to be pushed as pending demand

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PDSPPR_DEMAND_DOC_OU	_decimal_10_0	decimal(10)	No	This is the OU where Demand doc is created	No
PDSPPR_DEMAND_TYPE	_varchar_20	varchar(20)	No	This is the pending demand document type. At present, it will be only "MR"	No
PDSPPR_DEMAND_DOC_NO	_varchar_40	varchar(40)	No	This is the pending demand document no. At present, it will be only MRno	No
PDSPPR_LINE_NO	_decimal_10_0	decimal(10)	No	This is the line item of the pending demand	No
PDSPPR_SUB_LINE_NO	_decimal_10_0	decimal(10)	No	The sub line no (if any) for the Pending demand Part in the source document. This will be 0 if no sub line no exists.	No
PDSPPR_SPEC_PART_OU	_varchar_18	varchar(18)	Yes	Specific Part Ouinstance	No
PDSPPR_SPEC_PART_NO	_varchar_40	varchar(40)	Yes	Specific Part Number	No
PDSPPR_SPEC_PART_SRL_NO	_varchar_40	varchar(40)	Yes	Specific Part Serial Number	No
PDSPPR_TRADING_PARTNER_Type	udd_flag1	varchar(25)	Yes	Trading partner type CUS - Customer Sup - Supplier	No
PDSPPR_TRADING_PARTNER_NO	udd_vendorcode	varchar(45)	Yes	Owner Number	No
PDSPPR_TRADING_PARTNER_OU	udd_ctxt_ouinstance	int(4)	Yes	Owner location info.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_PGARC_PEGGED_ACT_RCPTS
Comment :	For each pending demand, the action taken by the system or the material planner is recorded here. Basically the planned receipt coverage information (STO or PR) for an MR Lineitem is maintained here. Once the pending demand gets fully processed, th

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PGARC_DEMAND_DOC_OU	_decimal_10_0	decimal(10)	No	Demand Document Ouinstance	No
PGARC_DEMAND_TYPE	_varchar_18	varchar(18)	No	Demand Type	No
PGARC_DEMAND_DOC_NO	_varchar_18	varchar(18)	No	Demand Document Number	No
PGARC_LINE_NO	_decimal_10_0	decimal(10)	No	Line Number	No
PGARC_SUB_LINE_NO	_decimal_10_0	decimal(10)	No	Sub Line Number	No
PGARC_REQ_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Requested Part Created Ouinstance	No
PGARC_REQ_PART_NO	_varchar_40	varchar(40)	No	Requested Part Number	No
PGARC_REQ_PART_STATUS	_varchar_18	varchar(18)	No	Requested Part Status	No
PGARC_ALLOC_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Allocated Part Created Ouinstance	No
PGARC_ALLOC_PART_NO	_varchar_40	varchar(40)	No	Allocated Part Number	No
PGARC_ALLOC_WH_OU	_decimal_10_0	decimal(10)	No	Allocated Warehouse Ouinstance	No
PGARC_ALLOC_WH_ID	_varchar_18	varchar(18)	No	Allocated Warehouse Id	No
PGARC_ACT_RCPT_DOC_TYPE	_varchar_18	varchar(18)	No	Actual Receipt Document type This could be PO - Purchase Order or STI - Stock Transfer Issue	No
PGARC_ACT_RCPT_DOC_OU	_decimal_10_0	decimal(10)	No	Actual Receipt Document Ouinstance	No
PGARC_ACT_RCPT_DOC_NO	_varchar_18	varchar(18)	No	Actual Receipt Document Number	No
PGARC_ACT_RCPT_DOC_LINEITEM	_decimal_10_0	decimal(10)	No	Actual Receipt Document Line Item	No
PGARC_ACT_RCPT_QTY	udd_quantity	numeric(13)	Yes	Actual Receipt Quantity	No
PGARC_WORK_CENTER_OU	_decimal_10_0	decimal(10)	Yes	Work center Ou	No
PGARC_WORK_CENTER	_varchar_40	varchar(40)	Yes	Work Center number	No
PGARC_ACT_RCPT_SRL_LINEITEM	_decimal_10_0	decimal(10)	Yes	Serial line number	No
PgARc_Act_TRADING_PARTNER_Type	udd_flag1	varchar(25)	Yes	Trading partner type CUS - Customer Sup - Supplier	No
PgARc_Act_Trading_Partner_No	udd_vendorcode	varchar(45)	Yes	Owner Number\Name	No
PgARc_Act_TRADING_PARTNER_OU	udd_ctxt_ouinstance	int(4)	Yes	Owner location info.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_PLSL_STORE_OPRN_LINK_META
Comment :	Table to manage Store opertion link metadata

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

Table Name :	SMN_PLSO_STORE_OPERATION_META
Comment :	Table to manage Store opertion search metadata

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

Table Name :	SMN_PRDMD_PROCESSED_DEMANDS
Comment :	Whenever hard allocation fails, it is treated as a pending demand and an entry is pushed into this table. Any action that is initiated for the pending demands (whether STO/STI/PR/ISSUE creation) either by the Material Planner or by the system (automatic

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRDMD_DEMAND_DOC_OU	_decimal_10_0	decimal(10)	No	Demanded loc info	No
PRDMD_DEMAND_TYPE	_varchar_20	varchar(20)	No	This is the pending demand document type. At present, it will be only "MR"	No
PRDMD_DEMAND_DOC_NO	_varchar_40	varchar(40)	No	This is the pending demand document no. At present, it will be only MRno	No
PRDMD_LINE_NO	_decimal_10_0	decimal(10)	No	This is the line item of the pending demand	No
PRDMD_SUB_LINE_NO	_decimal_10_0	decimal(10)	No	The sub line no (if any) for the Pending demand Part in the source document. This will be 0 if no sub line no exists.	No
PRDMD_DEMAND_PRIORITY	_varchar_5	varchar(5)	Yes	This has the demand priority no. Priority 1 signify highest priority .. For MR, if the priority is AOG, then this Demand Priority would be maintained as 1 For MR, if the priority is Normal, then this Demand Priority would be maintained as 2 Denor	No
PRDMD_REQ_LOC	_decimal_10_0	decimal(10)	Yes	Requesting location for which the source doc is created	No
PRDMD_REQ_BY	_varchar_30	varchar(30)	Yes	Demand is requested by	No
PRDMD_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	warehouse location	No
PRDMD_WAREHOUSE_ID	_varchar_20	varchar(20)	Yes	Warehouse from where the pending demand needs to be addressed Denormalized info	No
PRDMD_ACREG_OU	_decimal_10_0	decimal(10)	Yes	Aircraft Registration Ouinstance	No
PRDMD_ACREG_NO	_varchar_40	varchar(40)	Yes	Aircraft Registration Number	No
PRDMD_WORK_CENTER_OU	_decimal_10_0	decimal(10)	Yes	WorkCenter location which requires the part Denormalized info	No
PRDMD_WORK_CENTER	_varchar_30	varchar(30)	Yes	WorkCenter which requires the pending demand parts Denormalized info	No
PRDMD_NEED_DATETIME	_datetime_8	datetime(8)	Yes	Need Date as given in the MR or any schedule date as required in the source doc Denormalized info	No
PRDMD_DOC_CRT_DATETIME	_datetime_8	datetime(8)	Yes	Created Datetime of the Demand document. If Doc Type is MR, this will be the MR doc created datetime. If Priority and need date is same, created datetime of the document will be used to defined the priority for an MR during receipt pegging	No
PRDMD_REQ_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Requested Part Created Ou	No
PRDMD_REQ_PART_NO	_varchar_40	varchar(40)	Yes	The main part which is requested in the material demanding document	No
PRDMD_REQ_PART_STATUS	_varchar_28	varchar(28)	Yes	Requested Part Status	No
PRDMD_REQ_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	The requested qty of the main part in stock uom	No
PRDMD_ALLOC_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Allocated qty in stock UOM	No
PRDMD_TOTPLNRCPT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	For the pending demand, system/user would have initiated a process of Stock Transfer Order or Purchase Request . The total quantity for which this process got initiated would be maintained here.	No
PRDMD_TOTFRMRCPT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	For the pending demand, system/user would have initiated a process of Stock Transfer Order or Purchase Request . For this, system would have got the stock thru Stock Transfer Issue or "Purchase Order". This has the total stock quantity that	No
PRDMD_TOTACTRCPT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This could "GR" or "STR" qty	No
PRDMD_ISU_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This will be the issued qty against the pending demand line item	No
PRDMD_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by User	No
PRDMD_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created Date	No
PRDMD_PART_CONDITION	_varchar_5	varchar(5)	Yes	¨?8 condition	No
PrDmd_TotSTO_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total stock transfer Qty in stock UOM	No
PrDmd_TotPR_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total purchase Qty in stock UOM	No
PrDmd_Iss_FD_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total issue Qty in stock UOM	No
PrDmd_TrnOrd_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total ordered Qty in stock UOM	No
PrDmd_TrnIss_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total issue Qty in stock UOM	No
PrDmd_TrnRec_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total receipt Qty in stock UOM	No
PrDmd_PurReq_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total PR Qty in stock UOM	No
PrDmd_PurOrd_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total PO Qty in stock UOM	No
PrDmd_GDRec_Qty_InStkUOM	_decimal_28_8	decimal(28)	Yes	total GR Qty in stock UOM	No
PrDmd_TimeStamp	_decimal_10_0	decimal(10)	Yes	time stamp	No
PrDmd_LineLvl_Status	_varchar_15	varchar(15)	Yes	line level status	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_PRICEVAR_CORR_SUMMARY
Comment :	stock correction parice variance summary table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_SUM_GROU	udd_ctxt_ouinstance	int(4)	Yes	OU instance	No
SMN_SUM_GRNO	udd_documentno	varchar(40)	Yes	The goods receipts document no	No
SMN_SUM_GR_LINENO	udd_seqno	int(4)	Yes	the goods receipts document line no	No
SMN_SUM_PART_NO	udd_documentno	varchar(40)	Yes	the goods receipt part no	No
SMN_SUM_WAREHOUSE	udd_warehouse	varchar(10)	Yes	the good receipt warehouse no	No
SMN_SUM_SERNO	UDD_SERIALNO	varchar(40)	Yes	the goods receipt serial no	No
SMN_SUM_LOTNO	udd_lotno	varchar(18)	Yes	the goods receipt lot no	No
SMN_SUM_MOVEDQTY	udd_quantity	numeric(13)	Yes	the moved qty of thepart	No
SMN_SUM_CORRECQTY	udd_quantity	numeric(13)	Yes	the correction qty for the receipt	No
SMN_SUM_CORREC_SOURCE	udd_designparamcode	varchar(5)	Yes	the correction source	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each record entry	Yes

Table Name :	SMN_PRICEVAR_INPDET
Comment :	stcok management price variance information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_INP_GUID	udd_guid	varchar(40)	Yes	the unique identifier	No
SMN_INP_TRAN_TYPE	udd_documenttype	varchar(40)	Yes	the transaction type	No
SMN_INP_TRAN_OU	udd_ctxt_ouinstance	int(4)	Yes	the transaction OU instance	No
SMN_INP_TRAN_NO	udd_documentno	varchar(40)	Yes	the transaction document number	No
SMN_INP_REFTRAN_NO	udd_documentno	varchar(40)	Yes	the reference transaction document no	No
SMN_INP_PO_TRANOU	udd_ctxt_ouinstance	int(4)	Yes	the purchanse order transaction OU instance	No
SMN_INP_PONO	udd_documentno	varchar(40)	Yes	Purchase order number	No
SMN_INP_GR_TRANOU	udd_ctxt_ouinstance	int(4)	Yes	the goods receipt transaction ou instance	No
SMN_INP_GRNO	udd_documentno	varchar(40)	Yes	the goods receipt document no	No
SMN_INP_GR_LINENO	udd_seqno	int(4)	Yes	the good receipt document line no	No
SMN_INP_PART_NO	udd_documentno	varchar(40)	Yes	part no	No
SMN_INP_PUR_UOM	udd_uom	varchar(15)	Yes	the purchased UOM of the part	No
SMN_INP_TRAN_QTY	udd_quantity	numeric(13)	Yes	the transaction part quantity	No
SMN_INP_VAR_VALUE	udd_value	numeric(13)	Yes	the variable value	No
SMN_INP_PROC_FLAG	udd_designparamcode	varchar(5)	Yes	process flag	No
SMN_INP_CREATED_DATE	udd_datetime	varchar(30)	Yes	the transaction created date	No
SMN_INP_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	the user who created the transaction	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes
SMN_INP_ERR_LOG	udd_txt2000	varchar(2000)	Yes	Error Log	No

Table Name :	SMN_PRICEVAR_PROCDET
Comment :	the price variance information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_PROC_TRAN_TYPE	udd_documenttype	varchar(40)	Yes	Transaction type	No
SMN_PROC_TRAN_OU	udd_ctxt_ouinstance	int(4)	Yes	Transaction OU instance	No
SMN_PROC_REFTRAN_NO	udd_documentno	varchar(40)	Yes	The reference transaction no	No
SMN_PROC_TRAN_NO	udd_documentno	varchar(40)	Yes	the transaction no	No
SMN_PROC_PO_TRANOU	udd_ctxt_ouinstance	int(4)	Yes	the purchase order transaction ou	No
SMN_PROC_PONO	udd_documentno	varchar(40)	Yes	the pruchase order no	No
SMN_PROC_GR_TRANOU	udd_ctxt_ouinstance	int(4)	Yes	goods receipt ou instance	No
SMN_PROC_GRNO	udd_documentno	varchar(40)	Yes	goods receipt document no	No
SMN_PROC_GR_LINENO	udd_seqno	int(4)	Yes	goods receipt document line no	No
SMN_PROC_PART_NO	udd_documentno	varchar(40)	Yes	part no	No
SMN_PROC_PART_CNRLTYPE	udd_flag	varchar(25)	Yes	part control type	No
SMN_PROC_PART_VALMET	udd_designparamcode	varchar(5)	Yes	part valuation method	No
SMN_PROC_PUR_UOM	udd_uom	varchar(15)	Yes	part purchase UOM	No
SMN_PROC_STK_UOM	udd_uom	varchar(15)	Yes	part stock UOM	No
SMN_PROC_TRANQTY_PRUOM	udd_quantity	numeric(13)	Yes	the transaction quantity of the part in purchase UOM	No
SMN_PROC_TRANQTY_STKUOM	udd_quantity	numeric(13)	Yes	the transaction quantity of the part in stock UOM	No
SMN_PROC_VAR_VALUE	udd_value	numeric(13)	Yes	the variance value	No
SMN_PROC_FLAG	udd_designparamcode	varchar(5)	Yes	process flag	No
SMN_PROC_ERR_MSG	udd_txt1000	varchar(1000)	Yes	Error message	No
SMN_PROC_CREATED_DATE	udd_datetime	varchar(30)	Yes	the transaction created date	No
SMN_PROC_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	transaction created user	No
SMN_PROC_STK_AVAILABLE	udd_designparamcode	varchar(5)	Yes	the quantity of part avaiable in stock	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_PRICEVAR_STKCORREC_LOG
Comment :	the proce variance for stock correction information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_LOG_TRAN_TYPE	udd_documenttype	varchar(40)	Yes	transaction type	No
SMN_LOG_INV_OU	udd_ctxt_ouinstance	int(4)	Yes	OU instance	No
SMN_LOG_INV_NO	udd_documentno	varchar(40)	Yes	inventory doument no	No
SMN_LOG_GR_TRANOU	udd_ctxt_ouinstance	int(4)	Yes	goods receipt transaction ou instance	No
SMN_LOG_GRNO	udd_documentno	varchar(40)	Yes	goods receipt document no	No
SMN_LOG_GR_LINENO	udd_seqno	int(4)	Yes	goods receipt document line no	No
SMN_LOG_PART_NO	udd_documentno	varchar(40)	Yes	Part no	No
SMN_LOG_INV_QTY	udd_quantity	numeric(13)	Yes	inventory quantity	No
SMN_LOG_VAR_VALUE	udd_value	numeric(13)	Yes	variance value	No
SMN_LOG_STCORROU	udd_ctxt_ouinstance	int(4)	Yes	stock correction OU instance	No
SMN_LOG_STCORRNO	udd_documentno	varchar(40)	Yes	stock correction document number	No
SMN_LOG_CORREC_QTY	udd_quantity	numeric(13)	Yes	stock correction quantity	No
SMN_LOG_CORREC_VALUE	udd_value	numeric(13)	Yes	stock correction value	No
SMN_LOG_REMARKS	udd_txt2000	varchar(2000)	Yes	comments for stock correction	No
SMN_LOG_FLAG	udd_designparamcode	varchar(5)	Yes	stock correction flag	No
SMN_LOG_CREATED_DATE	udd_datetime	varchar(30)	Yes	stock correction created date	No
SMN_LOG_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	user created stock correction	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	smn_prtinsp_prt_insp_Dtl
Comment :	the part inspection details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
smn_prtinsp_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Created Ouinstance	No
smn_prtinsp_refdocno	udd_documentno	varchar(40)	Yes	Document No	No
smn_prtinsp_refdoctype	udd_type	varchar(25)	Yes	Document Type	No
smn_prtinsp_rcptdate	udd_time	datetime(8)	Yes	Document date	No
smn_prtinsp_type	udd_type	varchar(25)	Yes	Part Type	No
smn_prtinsp_partno	udd_partno	varchar(40)	Yes	Part Number	No
smn_prtinsp_serialno_int	udd_partserialnumber	varchar(40)	Yes	Internal Serial Number	No
smn_prtinsp_serialno_msn	udd_partserialnumber	varchar(40)	Yes	Manufacturer Serial Number	No
smn_prtinsp_lotno_int	udd_lotno	varchar(18)	Yes	Internal Lot number	No
smn_prtinsp_lotno_msn	udd_lotno	varchar(18)	Yes	Manufacturer Lot number	No
smn_prtinsp_warehouse	udd_warehouse	varchar(10)	Yes	Ware House	No
smn_prtinsp_zone	udd_zone	varchar(10)	Yes	Zone	No
smn_prtinsp_bin	udd_bin	varchar(10)	Yes	Bin	No
smn_prtinsp_inspqty	udd_quantity	numeric(13)	Yes	Quantity at line level	No
smn_prtinsp_uom	udd_uom	varchar(15)	Yes	Unit of Measurement	No
smn_prtinsp_stockstatus	udd_documentno	varchar(40)	Yes	Stock status as in user defined stock status	No
smn_prtinsp_condition	udd_condition	varchar(15)	Yes	Part preferable Condition	No
smn_prtinsp_inspstatus	udd_status	varchar(25)	Yes	Inspection Status	No
smn_prtinsp_quanqty	udd_quantity	numeric(13)	Yes	Quaratine Quantity	No
smn_prtinsp_docstatus	udd_status	varchar(25)	Yes	Document status	No
smn_prtinsp_reason_code	udd_flag	varchar(25)	Yes	Inspection Reason Code	No
smn_prtinsp_inspdetails	udd_txt2000	varchar(2000)	Yes	Inspection Details	No
smn_prtinsp_SOSdisp	udd_description	varchar(40)	Yes	SOS Disposition Description	No
smn_prtinsp_CRNo	udd_documentno	varchar(40)	Yes	Component Replacement No	No
smn_prtinsp_filename	udd_filename	varchar(50)	Yes	Attached file Name	No
smn_prtinsp_refdoclineno	udd_lineno	int(4)	Yes	Document Part Detail Line number	No
smn_prtinsp_inspby	udd_ctxt_user	varchar(30)	Yes	Inspected By	No
smn_prtinsp_inspdate	udd_time	datetime(8)	Yes	Inspection Date	No
smn_prtinsp_Cert_Uniqueid	udd_seqno	int(4)	Yes	Unique id for Certificate details.	No
smn_prtinsp_AcceptedQty	udd_quantity	numeric(13)	Yes	column to store the accepted quantity	No
smn_prtinsp_RejectedQty	udd_quantity	numeric(13)	Yes	Column to store RejectedQty	No
smn_prtinsp_RsnFrRejection	udd_flag	varchar(25)	Yes	Column to store the resaon for rejection	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	smn_pscc_prtsrlnc_condchng_log
Comment :	Table to manage part serial condition change log table

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

Table Name :	smn_psexmod_prtsrl_exchmod_log
Comment :	Table to manage Part Exchange mod log table

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

Table Name :	SMN_PST_PRTSRLLOT_SRCH_META
Comment :	part serial search metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PST_RCPT_TRAN_TYPE	udd_accountcode	varchar(32)	Yes	transaction type	No
PST_TOTNO_RCPTS	udd_seqno	int(4)	Yes	Receipt document no	No
PST_TOTRCPT_QTY	udd_quantity	numeric(13)	Yes	the part quantity of the receipt	No
PST_TOTNO_ALTPART_RCPT	udd_seqno	int(4)	Yes	Alternate part receipt	No
PST_TOT_ALTPART_RCPT_QTY	udd_quantity	numeric(13)	Yes	alternate part quantity	No
PST_ISS_TRAN_TYPE	udd_accountcode	varchar(32)	Yes	isuue transaction type	No
PST_TOTNO_ISS	udd_seqno	int(4)	Yes	issue document no	No
PST_TOTISS_QTY	udd_quantity	numeric(13)	Yes	issue quantity	No
PST_TOTNO_ALTPART_ISS	udd_seqno	int(4)	Yes	alternate part	No
PST_TOT_ALTPART_ISS_QTY	udd_quantity	numeric(13)	Yes	issed alternate part quantity	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_REPLENISHMENT_ERROR_LOG
Comment :	the replishment error log table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
REP_GUID	udd_guid	varchar(40)	Yes	unique identifier	No
REP_DOCUMENT_OU	udd_ctxt_ouinstance	int(4)	Yes	document OU instance	No
REP_DOCUMENT_NO	udd_documentno	varchar(40)	Yes	Document NO	No
REP_DOCUMENT_DATE	udd_datetime	varchar(30)	Yes	Document Date	No
REP_PART_NO	udd_partno	varchar(40)	Yes	Part number	No
REP_PART_STATUS	udd_partstatus	varchar(40)	Yes	part status	No
REP_USER	udd_ctxt_user	varchar(30)	Yes	user name	No
REP_LANGUAGE	udd_ctxt_language	int(4)	Yes	language id	No
REP_SRCCOMPONENT	udd_ctxt_component	varchar(20)	Yes	source component name	No
REP_SRCOU	udd_ctxt_ouinstance	int(4)	Yes	source component ou	No
REP_ERROR_MSG	udd_remarks	varchar(255)	Yes	error message description	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	Smn_Rep_PlanRepAvlQty
Comment :	replishment plan available table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Rep_Guid	udd_guid	varchar(40)	Yes	unique identifier	No
Rep_SrcOU	ctxt_ouinstance	numeric(9)	Yes	source component OU instance	No
Rep_SrcComp	udd_component	varchar(16)	Yes	source component name	No
Rep_SrcDocumentno	udd_documentno	varchar(40)	Yes	Source document number	No
Rep_PartCrtOU	ctxt_ouinstance	numeric(9)	Yes	part created OU	No
Rep_part_no	udd_partno	varchar(40)	Yes	Part no	No
Rep_WareHouseOU	ctxt_ouinstance	numeric(9)	Yes	warehouse OU	No
Rep_WareHouse	udd_warehouse	varchar(10)	Yes	warehouse	No
Rep_PrtPlanningType	udd_flag	varchar(25)	Yes	part planning type	No
Rep_ActivityBy	udd_flag	varchar(25)	Yes	user who activited the replishment plan	No
Rep_MinQty	udd_quantity	numeric(13)	Yes	minimum quantity maintained for the part	No
Rep_MaxQty	udd_quantity	numeric(13)	Yes	maximum quantity maintained for the part	No
Rep_ReOrderLvl	udd_quantity	numeric(13)	Yes	the re order level	No
Rep_ReOrderQty	udd_quantity	numeric(13)	Yes	the re order quantity	No
Rep_AvailableQty	udd_quantity	numeric(13)	Yes	stock available quantity	No
Rep_PlnRepQty	udd_quantity	numeric(13)	Yes	plan replishment quantity	No
Rep_TriggerRepQty	udd_quantity	numeric(13)	Yes	replishment triggered quantity	No
Rep_OpenPORSQty	udd_quantity	numeric(13)	Yes	open purchase order or release slip quantity	No
Rep_Date_tmp	udd_time	datetime(8)	Yes	date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_RTNVAL_VALUATION_POLICY
Comment :	used to store the valuation details..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTNVAL_SEQNO	udd_seqno	int(4)	No	Sequence No to maintain the Uniqueness	No
RTNVAL_EXPENSEBASIS	udd_designparamcode	varchar(5)	Yes	This field holds the Expense Basis	No
RTNVAL_RTNBASIS	udd_designparamcode	varchar(5)	Yes	This field holds the return basis	No
RTNVAL_RTNCLS	udd_quickcodes	varchar(25)	Yes	This field holds the user defined Return Classification	No
RTNVAL_RTNVALUATION	udd_designparamcode	varchar(5)	Yes	This fields holds the Issue Cost(IC), Valuation Method (VM) and Zero Cost(ZC)	No
RTNVAL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Stock Maintenance Created OUInstance	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SCRDT_STDCOSTREVAL_DTL
Comment :	used to store the standard cost details...

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SCRDT_SCR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintanance Ou Instance	Yes
SCRDT_SCR_NO	_varchar_40	varchar(40)	No	A unique number generated for a Standard Cost Revaluation Document	Yes
SCRDT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ou	Yes
SCRDT_PART_NO	_varchar_40	varchar(40)	No	Part no for which the std cost is getting changed	Yes
SCRDT_NEW_STD_COST	_decimal_28_8	decimal(28)	Yes	Revised std cost of the part	No
SCRDT_OLD_STD_COST	_decimal_28_8	decimal(28)	Yes	This will be standard cost of the part before standard cost revaluation. This will be updated when the SCR doc is authorized	No
SCRDT_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (if any)	No
SCRDT_ACC_USAGE	_varchar_20	varchar(20)	Yes	Account Usage	No
SCRDT_FIN_BOOK	_varchar_20	varchar(20)	Yes	Finance Book	No
SCRDT_ACC_CODE	_varchar_32	varchar(32)	Yes	Account Code	No
SCRDT_ANLY_CODE	_varchar_32	varchar(32)	Yes	Analysis Code	No
SCRDT_SUBANLY_CODE	_varchar_32	varchar(32)	Yes	Sub Analysis Code	No
SCRDT_CC_USAGE	_varchar_20	varchar(20)	Yes	Cost Center Usage	No
SCRDT_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	Cost Center Code	No

Table Name :	SMN_SCRMN_STDCOSTREVAL_HDR
Comment :	the standard codt value information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SCRMN_SCR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintanance Ou Instance	Yes
SCRMN_SCR_NO	_varchar_40	varchar(40)	No	A unique number generated for a Standard Cost Revaluation Document	Yes
SCRMN_SCR_STATUS	_varchar_5	varchar(5)	Yes	Status of the SCR Document D - Draft F - Fresh CO - Authorized CA - Cancelled	No
SCRMN_USER_STATUS	_varchar_25	Varchar(25)	Yes	User status for an SCR document	No
SCRMN_REF_DOC	_varchar_40	varchar(40)	Yes	Reference document (if any) for doing the standard cost revaluation	No
SCRMN_REVAL_CAT	_varchar_25	Varchar(25)	Yes	Revaluation Category	No
SCRMN_REVAL_DATE	_datetime_8	datetime(8)	Yes	Revaluation Date	No
SCRMN_USER_DEF_1	_varchar_25	Varchar(25)	Yes	User Defined data - 1	No
SCRMN_USER_DEF_2	_varchar_25	Varchar(25)	Yes	User Defined data - 2	No
SCRMN_FILENAME	_varchar_50	varchar(50)	Yes	Filename of the attached file which have more details on the SCR document	No
SCRMN_COMMENTS	_varchar_255	varchar(255)	Yes	Comments for the SCR document (if any)	No
SCRMN_ACC_USAGE	_varchar_20	varchar(20)	Yes	Account usage	No
SCRMN_CC_USAGE	_varchar_20	varchar(20)	Yes	Cost center Usage	No
SCRMN_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Date on which the SCR document got created	No
SCRMN_AUTH_DATETIME	_datetime_8	datetime(8)	Yes	Authorized date time	No
SCRMN_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Date on which SCR doc got modified	No
SCRMN_CREATED_BY	_varchar_30	varchar(30)	Yes	User Name - by whom the document got created.	No
SCRMN_AUTH_BY	_varchar_30	varchar(30)	Yes	Authorized by User Name	No
SCRMN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User Name - by whom the document got modified.	No
SCRMN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Number of times the Standard Cost Revealuation Document has got modified.	No

Table Name :	SMN_SET_OPTION_BACKEND_VALUES
Comment :	Table to manage SMN tech log Status setoption

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

Table Name :	Smn_ShelLifeUpd_Dtl
Comment :	Table used to store the history of shelf life update for part

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ShelLifeUpd_OUInstance	udd_ctxt_ouinstance	int(4)	No	Created OU Instance	Yes
ShelLifeUpd_Part_No	udd_partno	varchar(40)	No	Part No	Yes
ShelLifeUpd_Part_OU	udd_ctxt_ouinstance	int(4)	No	OUInstance of the part	No
ShelLifeUpd_Part_Srl_No	UDD_SERIALNO	varchar(40)	No	Part Serial No	Yes
ShelLifeUpd_Warehouse	udd_warehouse	varchar(10)	No	Warehouse no	Yes
ShelLifeUpd_Warehouse_OU	udd_ctxt_ouinstance	int(4)	No	OU Instance of the wareshouse no	No
ShelLifeUpd_LotNo	udd_lotno	varchar(18)	No	Lot No	Yes
ShelLifeUpd_NewExp_Date	udd_date	varchar(15)	No	New Expiry Date	No
ShelLifeUpd_OldExp_Date	udd_date	varchar(15)	No	Old Expiry Date	No
ShelLifeUpd_Remarks	udd_txt255	varchar(255)	Yes	Remarks during shelf life update	No
ShelLifeUpd_Reset_Date	udd_date	varchar(15)	No	Shelf life reset date	No
ShelLifeUpd_Renewal_Count	udd_count	int(4)	No	Shelf Life renewal count	Yes
ShelLifeUpd_Ref_DocId	udd_refdocno	varchar(40)	Yes	Reference Document ID	No
ShelLifeUpd_Ref_DocType	udd_document	varchar(20)	Yes	Reference Document type. To indicate from where shelf life is updated	No
ShelLifeUpd_CreatedBy	udd_ctxt_user	varchar(30)	No	Created by	No
ShelLifeUpd_CreatedDate	udd_datetime	varchar(30)	No	Created Date	No
ShelLifeUpd_Modifiedby	udd_ctxt_user	varchar(30)	Yes	Modified by	No
ShelLifeUpd_ModifiedDate	udd_datetime	varchar(30)	Yes	Modified Date	No
ShelLifeUpd_TimeStamp	udd_timestamp	int(4)	No	Time stamp	No

Table Name :	SMN_SMNATT_SRL_PART_ATTRIB
Comment :	For the Stock Maintained, this entity contains the attribute details for a serial controlled part

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNATT_SRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source OUInstance of the Stock Maint component where the serial controlled part is stored.	Yes
SMNATT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ou	Yes
SMNATT_PART_NO	_varchar_40	varchar(40)	No	Part No for which the attributes are defined.	Yes
SMNATT_SERIAL_NO	_varchar_40	varchar(40)	No	Part Serial No	Yes
SMNATT_ATTRIBUTE_NO	_varchar_18	varchar(18)	No	Attribute code of the part	Yes
SMNATT_QUAL_VALUE	_varchar_80	varchar(80)	Yes	Qualitative Value of the attribute for the part	No
SMNATT_QUAN_VALUE	_decimal_28_8	decimal(28)	Yes	Quantitative Value of the attribute for the part	No
SMNATT_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (if any)	No

Table Name :	SMN_SMNDA_DOC_ATTACH_DTL
Comment :	Used to store the reference douments attached to it

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNDA_DOC_ID	_varchar_40	varchar(40)	No	Document Id	Yes
SMNDA_SOURCE_FLAG	_varchar_5	varchar(5)	No	Source Flag will be as follows 1) OpBal for Openging Balance 2) SCR for Standard Cost Revaluation 3) SCOR for Stock Correction	Yes
SMNDA_SOURCE_DOC_OU	_decimal_10_0	decimal(10)	No	Opening balance or SCR or Stock correction document s OU	Yes
SMNDA_SOURCE_DOC_NO	_varchar_40	varchar(40)	No	Opening balance or SCR or Stock correction document	Yes
SMNDA_REF_DOC_TYPE	_varchar_15	varchar(15)	No	Reference Document Type	Yes
SMNDA_FILE_NAME	_varchar_50	varchar(50)	Yes	Reference File Name	No
SMNDA_REMARKS	_varchar_225	varchar(225)	Yes	Remarks (if any)	No

Table Name :	SMN_SMNDMN_WHLVLDEAMON_INFO
Comment :	This table stores the Daemon Initiated Datetime and the warehouse tarnsaction date range processed. Let s say, the daemon is executed for the first time on 10th Jan 03 (i.e. the system date on which the daemon is executed is 10th Jan 03 10 pm). All the w

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNDMN_SRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source OuInstance of the StkMaint	No
SMNDMN_WH_OU	_decimal_10_0	decimal(10)	No	Warehouse OuInstance	No
SMNDMN_WH_ID	_varchar_10	varchar(10)	No	Warehouse ID	No
SMNDMN_FROM_DATE	_datetime_8	datetime(8)	No	The min transaction date in the warehouse during the execution of daemon service. For detailed notes, go thru the Entity Description	No
SMNDMN_TO_DATETIME	_datetime_8	datetime(8)	No	TO DATETIME	No
SMNDMN_ISSRCPT_FLAG	_varchar_5	varchar(5)	Yes	For a warehouse, if daemon is already run for a date range and subsequently a transaction is getting entered for a date which comes in the already processed date range, the type of the transaction, whether it is a issue or a receipt is maintained in	No
SMNDMN_LASTUPD_DOC_TYPE	_varchar_10	varchar(10)	Yes	For a warehouse, if daemon is already run for a date range and subsequently a transaction is getting entered for a date which comes in the already processed date range, the type of the transaction document like UPR , RO , etc is stored here Follow	No
SMNDMN_LASTUPD_DOC_OU	_decimal_10_0	decimal(10)	Yes	For a warehouse, if daemon is already run for a date range and subsequently a transaction is getting entered for a date which comes in the already processed date range, the transaction ou is maintained in this column. This flag will be reset to NULL	No
SMNDMN_LASTUPD_DOC_NO	_varchar_40	varchar(40)	Yes	For a warehouse, if daemon is already run for a date range and subsequently a transaction is getting entered for a date which comes in the already processed date range, the transaction document no is maintained in this column. This flag will be rese	No
SMNDMN_DMN_START_DATETIME	_datetime_8	datetime(8)	Yes	Daemon Service Initiated/Started Date time	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNDTISU_DATEWISE_ISSUE
Comment :	This table is a denormalized structure (with required data for reports) of issue hdr, issue dtl and unplanned issue dtl to see at overview level. It also has the Stock Status Conversion Old Status transaction getting treated as Issue In future, this ta

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNDTISU_SRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU where the Issue created.	No
SMNDTISU_WH_OU	_decimal_10_0	decimal(10)	No	Warehouse Location	No
SMNDTISU_WH_ID	_varchar_10	varchar(10)	No	WareHouse id from which the part issued.	No
SMNDTISU_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part created OU	No
SMNDTISU_PART_NO	_varchar_40	varchar(40)	No	Part Number	No
SMNDTISU_PART_STATUS	_varchar_40	varchar(40)	No	Part status	No
SMNDTISU_DATE	_datetime_8	datetime(8)	No	Issue Date	No
SMNDTISU_SRCDOC_TYPE	_varchar_10	varchar(10)	No	This can be one of the following GNISU - General Issue MNISU - Maint Issue RO - RO Issue ST - Stock Transfer Issue UPISU - Unplanned Issue SSC - Stock Status Conversion (Old Status) STCOR - Stock Correction	No
SMNDTISU_SRCDOC_OU	_decimal_10_0	decimal(10)	No	Issue or SSC Doc Ou	No
SMNDTISU_SRCDOC_NO	_varchar_40	varchar(40)	No	Issue or SSC Doc No	No
SMNDTISU_ISU_QTYINSTKUOM	_decimal_28_8	decimal(28)	Yes	Issued Qty in Stock Uom (De-normalized field]	No
SMNDTISU_ISU_VALUE	_decimal_28_8	decimal(28)	Yes	Issue value at stock uom (De-normalized field]	No
SMNDTISU_DATETIME	_datetime_8	datetime(8)	Yes	date and time	No
SMNDTISU_MAT_TYPE	udd_type	varchar(25)	Yes	Material Type of the part	No
SMNDTISU_ISSUE_BASIS	udd_designparamcode	varchar(5)	Yes	Issue basis of the part	No
SMNDTISU_RET_BASIS	udd_designparamcode	varchar(5)	Yes	Return basis of the part	No
SMNDTISU_PART_EXPENSETYPE	udd_designparamcode	varchar(5)	Yes	expense type of the part	No
SMNDTISU_PART_VALMATHOD	udd_designparamcode	varchar(5)	Yes	valuation method of the part	No
SMNDTISU_PART_EXPENSINGPOLICY	udd_designparamcode	varchar(5)	Yes	expense policy of the part	No
SMNDTISU_PART_NON_STOCKABLE	udd_designparamcode	varchar(5)	Yes	flag to store whether the part is stockable or not	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes
SMNDTISU_CNTRLTYPE	udd_flag	varchar(25)	Yes	Control Type of the Part	No
SMNDTISU_PARTTYPE	udd_parttype	varchar(25)	Yes	Part type of the part	No
SMNDTISU_FLAG	udd_flag	varchar(25)	Yes	flag	No
SMNDTISU_ACTUALDATE	udd_time	datetime(8)	Yes	Actual Date	No
SMNDTISU_REMARKS	udd_remarks	varchar(255)	Yes	Remarks	No
created_area_code	_varchar_40	varchar(40)	Yes	created base of the record	No
SMNDTISU_PART_ACC_GRP	udd_flag	varchar(25)	Yes	part account group	No

Table Name :	SMN_SMNDTRCPT_DATEWISE_RCPT
Comment :	This table stores all datewise receipt (all receipts - Return, Stock Trnsfer, Receipt, GR, OpBal, etc) made for all type of parts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNDTRCPT_SRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	source ou instance	No
SMNDTRCPT_WH_OU	_decimal_10_0	decimal(10)	No	warehouse ou instance	No
SMNDTRCPT_WH_ID	_varchar_10	varchar(10)	No	warehouse id	No
SMNDTRCPT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	part created ou	No
SMNDTRCPT_PART_NO	_varchar_40	varchar(40)	No	part no	No
SMNDTRCPT_PART_STATUS	_varchar_40	varchar(40)	No	part status	No
SMNDTRCPT_DATE	_datetime_8	datetime(8)	No	date time	No
SMNDTRCPT_SRCDOC_TYPE	_varchar_10	varchar(10)	No	This can be one of the following The code is same as the Receipt type or return type or whatever that is stored in the base tables. 1) Openning Balance (OPBAL) 2) Unplanned Receipt (UPR) 3) Stock Transfer Receipt (ST) 4) General	No
SMNDTRCPT_SRCDOC_OU	_decimal_10_0	decimal(10)	No	Receipt or Return or any other doc type tran location id	No
SMNDTRCPT_SRCDOC_NO	_varchar_40	varchar(40)	No	Receipt or Return or any other doc type tran Document No	No
SMNDTRCPT_RCPT_QTYINSTKUOM	_decimal_28_8	decimal(28)	Yes	Received Qty in Stock Uom of the part	No
SMNDTRCPT_RCPT_VALUE	_decimal_28_8	decimal(28)	Yes	Receipt Value for the qty received	No
SMNDTRCPT_DATETIME	_datetime_8	datetime(8)	Yes	Holds the date and time of the document got created	No
SMNDTRCPT_RCPT_MAT_TYPE	udd_type	varchar(25)	Yes	Material type of the part	No
SMNDTRCPT_RCPT_ISSUE_BASIS	udd_designparamcode	varchar(5)	Yes	Issue basis of the part	No
SMNDTRCPT_RCPT_RET_BASIS	udd_designparamcode	varchar(5)	Yes	Return basis of the of part at the time of issue	No
SMNDTRCPT_PART_EXPENSETYPE	udd_designparamcode	varchar(5)	Yes	expense type of the part	No
SMNDTRCPT_PART_VALMATHOD	udd_designparamcode	varchar(5)	Yes	valuation method of the part	No
SMNDTRCPT_PART_EXPENSINGPOLICY	udd_designparamcode	varchar(5)	Yes	expense policy of part	No
SMNDTRCPT_PART_NON_STOCKABLE	udd_designparamcode	varchar(5)	Yes	flag to store the part is stockable or not	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes
SMNDTRCPT_CNTRLTYPE	udd_flag	varchar(25)	Yes	Control Type of the Part	No
SMNDTRCPT_PARTTYPE	udd_parttype	varchar(25)	Yes	Part type of the part	No
SMNDTRCPT_FLAG	udd_flag	varchar(25)	Yes	flag	No
SMNDTRCPT_ACTUALDATE	udd_time	datetime(8)	Yes	Actual Date	No
SMNDTRCPT_REMARKS	udd_remarks	varchar(255)	Yes	Remarks	No
created_area_code	_varchar_40	varchar(40)	Yes	Created Area Code	No
SMNDTRCPT_PART_ACC_GRP	udd_flag	varchar(25)	Yes	part account group	No

Table Name :	SMN_SMNHD_DOC_HARD_ALLOC_DTL
Comment :	For the stock maintained, there could be zero or more hard allocation details for a non disposition part.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNHD_SMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintanace Ou Instance	Yes
SMNHD_WAREHOUSE_OUINSTANCE	_decimal_10_0	decimal(10)	No	Warehouse Ou	Yes
SMNHD_WAREHOUSE_ID	_varchar_10	varchar(10)	No	Warehouse Id	Yes
SMNHD_ZONE_ID	_varchar_10	varchar(10)	No	Zone Id	Yes
SMNHD_BIN_ID	_varchar_10	varchar(10)	No	Bin Id	Yes
SMNHD_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created OuInstance	Yes
SMNHD_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	Yes
SMNHD_PART_NO	_varchar_40	varchar(40)	No	Part No	Yes
SMNHD_PART_STATUS	_varchar_40	varchar(40)	No	Can take any value as defined in UDSS which are stockable	Yes
SMNHD_SERIAL_NO	_varchar_40	varchar(40)	No	Serial No for which hard allocation is done	Yes
SMNHD_LOT_NO	_varchar_18	varchar(18)	No	Lot No for which hard allocation is done	Yes
SMNHD_DOC_OU	_decimal_10_0	decimal(10)	No	This indicates the ou of the hard allocated document.(Mr Ou or Work order Ou)	Yes
SMNHD_DOC_TYPE	_varchar_5	varchar(5)	No	This indicates the hard allocated document type. It will be MR for Material Request It will be Cwo for Component WorkOrder	Yes
SMNHD_DOC_NO	_varchar_40	varchar(40)	No	This will be the MR No or workorder No	Yes
SMNHD_DOC_LINE_NO	_decimal_10_0	decimal(10)	No	The line no for the Part in the source document	Yes
SMNHD_DOC_SUB_LINE_NO	_decimal_10_0	decimal(10)	No	The sub line no (if any) for the Part in the source document. This will be 0 if no sub line no exists.	No
SMNHD_CREATED_BY	_varchar_30	varchar(30)	No	Created User Name	No
SMNHD_CREATED_DATETIME	_datetime_8	datetime(8)	No	Created Date	No
SMNHD_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified User Name	No
SMNHD_MODIFIED_DATETIME	_datetime_8	datetime(8)	No	Last Modified Date	No
SMNHD_ALLOC_ORDER_NO	_decimal_10_0	decimal(10)	No	Order in which the allocation is done	Yes
SMNHD_HARD_ALLOC_QTY	_decimal_28_8	decimal(28)	Yes	This will be the hard allocated quantity for the Source Document - Line No	No
SMNHD_Trading_Parter_Type	udd_flag1	varchar(25)	Yes	Trading partner type CUS - Customer Sup - Supplier	No
SMNHD_Trading_Partner_No	udd_vendorcode	varchar(45)	Yes	Owner Number\Name	No
SMNHD_Trading_Partner_OU	udd_ctxt_ouinstance	int(4)	Yes	Owner location info.	No

Table Name :	SMN_SMNHPD_PENDING_DEMANDS
Comment :	Whenever hard allocation fails , it is treated as a pending demand and an entry is pushed into this table. Any action that is initiated for the pending demands (whether STO/STI/PR/ISSUE creation) either by the Material Planner or by the system (automatic

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNHPD_DEMAND_DOC_OU	_decimal_10_0	decimal(10)	No	This is the OU where Demand doc is created	Yes
SMNHPD_DEMAND_TYPE	_varchar_5	varchar(5)	No	This is the pending demand document type. At present, it will be only "MR"	Yes
SMNHPD_DEMAND_DOC_NO	_varchar_40	varchar(40)	No	This is the pending demand document no. At present, it will be only MRno	Yes
SMNHPD_LINE_NO	_decimal_10_0	decimal(10)	No	This is the line item of the pending demand	Yes
SMNHPD_SUB_LINE_NO	_decimal_10_0	decimal(10)	No	The sub line no (if any) for the Pending demand Part in the source document. This will be 0 if no sub line no exists.	Yes
SMNHPD_DEMAND_PRIORITY	_varchar_5	varchar(5)	Yes	This has the demand priority no. Priority 1 signify highest priority .. For MR, if the priority is AOG, then this Demand Priority would be maintained as 1 For MR, if the priority is Normal, then this Demand Priority would be maintained as 2 Denor	No
SMNHPD_REQ_LOC	_decimal_10_0	decimal(10)	Yes	Requesting location for which the source doc is created	No
SMNHPD_REQ_BY	_varchar_30	varchar(30)	Yes	Demand is requested by	No
SMNHPD_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse location from where the pending demand needs to be addressed Denormalized info	No
SMNHPD_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	Warehouse from where the pending demand needs to be addressed Denormalized info	No
SMNHPD_ACREG_OU	_decimal_10_0	decimal(10)	Yes	Aircraft Registration Ouinstance	No
SMNHPD_ACREG_NO	_varchar_40	varchar(40)	Yes	Aircraft Reqistration Number	No
SMNHPD_WORK_CENTER_OU	_decimal_10_0	decimal(10)	Yes	WorkCenter location which requires the part Denormalized info	No
SMNHPD_WORK_CENTER	_varchar_30	varchar(30)	Yes	WorkCenter which requires the pending demand parts Denormalized info	No
SMNHPD_NEED_DATETIME	_datetime_8	datetime(8)	Yes	Need Date as given in the MR or any schedule date as required in the source doc Denormalized info	No
SMNHPD_DOC_CRT_DATETIME	_datetime_8	datetime(8)	Yes	Created Datetime of the Demand document. If Doc Type is MR, this will be the MR doc created datetime. If Priority and need date is same, created datetime of the document will be used to defined the priority for an MR during receipt pegging	No
SMNHPD_REQ_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Requested Part Created Ou	No
SMNHPD_REQ_PART_NO	_varchar_40	varchar(40)	Yes	The main part which is requested in the material demanding document	No
SMNHPD_REQ_PART_STATUS	_varchar_40	varchar(40)	Yes	Requested Part Status	No
SMNHPD_REQ_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	The requested qty of the main part in stock uom	No
SMNHPD_ALLOC_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This will be the allocated MR Quantity for the Demand (MR) LineItem Whenever allocation is partially successful, this will have the summed up qty that got hard allocated for the MR LineItem, The UnAllocated Qty can be derived as follows Required Q	No
SMNHPD_TOTPLNRCPT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	For the pending demand, system/user would have initiated a process of Stock Transfer Order or Purchase Request . The total quantity for which this process got initiated would be maintained here.	No
SMNHPD_TOTFRMRCPT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	For the pending demand, system/user would have initiated a process of Stock Transfer Order or Purchase Request . For this, system would have got the stock thru Stock Transfer Issue or "Purchase Order". This has the total stock quantity that	No
SMNHPD_TOTACTRCPT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This could "GR" or "STR" qty	No
SMNHPD_ISU_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This will be the issued qty against the pending demand line item	No
SMNHPD_ALTPART_FLAG	_varchar_25	Varchar(25)	Yes	Alternate Part Flag	No
SMNHPD_ALTPART_OU	_decimal_10_0	decimal(10)	Yes	Alternate Part Ouinstance	No
SMNHPD_ALTPART_NO	_varchar_40	varchar(40)	Yes	Alternate Part Number	No
SMNHPD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by User	No
SMNHPD_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Modified Date	No
SMNHPD_ACC_USAGE	_varchar_20	varchar(20)	Yes	usage id for account code...	No
SMNHPD_CC_USAGE	_varchar_20	varchar(20)	Yes	usage id for cost center...	No
SMNHPD_TASK_OU	_decimal_10_0	decimal(10)	Yes	Ou instance	No
SMNHPD_TASK_NO	_varchar_40	varchar(40)	Yes	task number	No
SMNHPD_TASK_KEYSEQNO	_decimal_10_0	decimal(10)	Yes	sequnce number	No
SMNHPD_FIN_BOOK	_varchar_20	varchar(20)	Yes	finance book id	No
SMNHPD_ACC_CODE	_varchar_32	varchar(32)	Yes	account code for the current document	No
SMNHPD_ANLY_CODE	_varchar_5	varchar(5)	Yes	anlysis code..	No
SMNHPD_SUBANLY_CODE	_varchar_5	varchar(5)	Yes	sub analyis code...	No
SMNHPD_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	cost center for account code	No
SMNHPD_PART_CONDITION	_varchar_5	varchar(5)	Yes	part condition	No
SMNHPD_PRIMEPARTNO	_varchar_40	varchar(40)	Yes	prime part number	No
SMNHPD_TOTSTO_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of stock transfer in stock uom	No
SMNHPD_TOTPR_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of PR in stock uom	No
SMNHPD_ISS_FD_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of stock issue in stock uom	No
SMNHPD_TRNORD_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of Order qty in stock uom	No
SMNHPD_TRNISS_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of stock issue in stock uom	No
SMNHPD_TRNREC_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of stock receipt in stock uom	No
SMNHPD_PURREQ_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of PR in stock uom	No
SMNHPD_PURORD_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of Pur order in stock uom	No
SMNHPD_GDREC_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Total quantity of Gr in stock uom	No
SmnHpd_TimeStamp	_decimal_10_0	decimal(10)	Yes	time stamp	No
Smnhpd_Trading_Parter_Type	udd_flag1	varchar(25)	Yes	Trading partner type CUS - Customer Sup - Supplier	No
Smnhpd_Trading_Partner_No	udd_vendorcode	varchar(45)	Yes	Owner Number\Name	No
Smnhpd_Trading_Partner_OU	udd_ctxt_ouinstance	int(4)	Yes	Owner location info.	No
SMNHPD_PROCESSING_STATUS	udd_status	varchar(25)	Yes	To capture the processing status entered in the plan material	No
SMNHPD_NEW_PART	udd_flag	varchar(25)	Yes	Column for indicating whether the part is a new part or not	No

Table Name :	SMN_SMNINQDTL_DRILLDOWN_DTL
Comment :	used to stoe the Drilldown table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNINQDTL_DOCUMENT_OU	_decimal_10_0	decimal(10)	Yes	Document Ou	No
SMNINQDTL_DOCUMENT_NO	_varchar_40	varchar(40)	Yes	Document No	No
SMNINQDTL_DOCUMENT_FLAG	_varchar_25	Varchar(25)	Yes	Document flag	No
SMNINQDTL_DOCUMENT_FLG_TYPE	_varchar_25	Varchar(25)	Yes	Document flag type	No
SMNINQDTL_DOCUMENT_LINE_NO	_decimal_10_0	decimal(10)	Yes	line number	No
SMNINQDTL_DOCUMENT_TYPE	_varchar_25	Varchar(25)	Yes	Document type	No
SMNINQDTL_DOCUMENT_DATE	_datetime_8	datetime(8)	Yes	document create date	No
SMNINQDTL_DOCUMENT_STATUS	_varchar_25	Varchar(25)	Yes	document status	No
SMNINQDTL_DOCUMENT_CNFM_DATE	_datetime_8	datetime(8)	Yes	document conformed status	No
SMNINQDTL_PART_OU	_decimal_10_0	decimal(10)	Yes	part ou	No
SMNINQDTL_PART_NUMBER	_varchar_40	varchar(40)	Yes	part number	No
SMNINQDTL_PART_STATUS	_varchar_40	varchar(40)	Yes	part status	No
SMNINQDTL_SUPPLIER_OU	_decimal_10_0	decimal(10)	Yes	supplier ou	No
SMNINQDTL_SUPPLIER_NUMBER	_varchar_45	varchar(45)	Yes	supplier number	No
SMNINQDTL_CUST_CREATED_OU	_decimal_10_0	decimal(10)	Yes	customer created ou	No
SMNINQDTL_CUST_CODE	_varchar_40	varchar(40)	Yes	customer code	No
SMNINQDTL_MR_CLASS	_varchar_5	varchar(5)	Yes	Merterial class	No
SMNINQDTL_MR_PRIORITY	_varchar_20	varchar(20)	Yes	MR priorty	No
SMNINQDTL_NEED_DATE	_datetime_8	datetime(8)	Yes	Need date	No
SMNINQDTL_MR_TYPE	_varchar_5	varchar(5)	Yes	MR type	No
SMNINQDTL_REFDOC_OU	_decimal_10_0	decimal(10)	Yes	ref document type	No
SMNINQDTL_REFDOC_NO	_varchar_40	varchar(40)	Yes	ref document number	No
SMNINQDTL_REFDOC_TYPE	_varchar_25	Varchar(25)	Yes	reference document type	No
SMNINQDTL_REF_DOC_LINE_NO	_decimal_10_0	decimal(10)	Yes	document line number	No
SMNINQDTL_REFDOC_DATE	_datetime_8	datetime(8)	Yes	ref document date	No
SMNINQDTL_REFDOC_STATUS	_varchar_25	Varchar(25)	Yes	ref document status	No
SMNINQDTL_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	aircraft location	No
SMNINQDTL_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	aircraft register number	No
SMNINQDTL_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	component ou	No
SMNINQDTL_COMPONENT_ID	_varchar_90	varchar(90)	Yes	component Id	No
SMNINQDTL_FROM_WH_OU	_decimal_10_0	decimal(10)	Yes	from warehouse location	No
SMNINQDTL_FROM_WAREHOUSE	_varchar_10	varchar(10)	Yes	from warehouse number	No
SMNINQDTL_TO_WH_OU	_decimal_10_0	decimal(10)	Yes	to warehouse location	No
SMNINQDTL_TO_WAREHOUSE	_varchar_10	varchar(10)	Yes	to warehouse number	No
SMNINQDTL_ZONE_ID	_varchar_10	varchar(10)	Yes	zone number	No
SMNINQDTL_BIN_ID	_varchar_10	varchar(10)	Yes	bin number	No
SMNINQDTL_SERIAL_NO	_varchar_40	varchar(40)	Yes	serial number	No
SMNINQDTL_LOT_NO	_varchar_18	varchar(18)	Yes	lot number	No
SMNINQDTL_PART_CONDITION	_varchar_5	varchar(5)	Yes	part condition	No
SMNINQDTL_SCHEDULE_DATE	_datetime_8	datetime(8)	Yes	scheduled date	No
SMNINQDTL_PEND_RETURN_QTY	_decimal_28_8	decimal(28)	Yes	pending return quantity	No
SMNINQDTL_MATL_INQ_FLAG	_varchar_25	Varchar(25)	Yes	material information flag	No
SMNINQDTL_ACCT_TYPE	_varchar_40	varchar(40)	Yes	account type	No
SMNINQDTL_ACCT_CODE	_varchar_32	varchar(32)	Yes	account code	No
SMNINQDTL_TRAN_QTY	_decimal_28_8	decimal(28)	Yes	transfer quantity	No
SMNINQDTL_TRAN_VALUE	_decimal_28_8	decimal(28)	Yes	transfer value	No
SMNINQDTL_SQUARE_OFF_QTY	_decimal_28_8	decimal(28)	Yes	square off quantity	No
SMNINQDTL_SQUARE_OFF_VALUE	_decimal_28_8	decimal(28)	Yes	square off value	No
SMNINQDTL_BALANCE_QTY	_decimal_28_8	decimal(28)	Yes	balance quantity	No
SMNINQDTL_BALANCE_VALUE	_decimal_28_8	decimal(28)	Yes	balancy value	No
SMNINQDTL_SQUARE_OFF_DOC_OU	_decimal_10_0	decimal(10)	Yes	square off document ou	No
SMNINQDTL_SQUARE_OFF_DOC_NO	_varchar_40	varchar(40)	Yes	square off document number	No
SMNINQDTL_SQUARE_OFF_DOC_LNNO	_decimal_10_0	decimal(10)	Yes	square off document line number	No
SMNINQDTL_SQUARE_OFF_PARTOU	_decimal_10_0	decimal(10)	Yes	square off document part ou	No
SMNINQDTL_SQUARE_OFF_PARTNO	_varchar_40	varchar(40)	Yes	square off document part no	No
SMNINQDTL_SQUARE_OFF_PART_STS	_varchar_40	varchar(40)	Yes	square off document part status	No
SMNINQDTL_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
SMNINQDTL_CREATED_DATE	_datetime_8	datetime(8)	Yes	created date	No
SMNINQDTL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
SMNINQDTL_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	modified date	No
smninqdtl_workcenter_ou	_decimal_10_0	decimal(10)	Yes	work center ou	No
smninqdtl_workcenter_no	_varchar_50	varchar(50)	Yes	work center number	No
SMNINQDTL_SQUARE_OFF_DATE	_datetime_8	datetime(8)	Yes	squared off date	No
SmnInqDtl_Srlot_Line_No	udd_lineno	int(4)	Yes	SERIAL LOT LINE NO	No
SmnInqDtl_Acceptance_Line_No	udd_lineno	int(4)	Yes	Acceptance Line No	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes
SMNINQDTL_OWNINGAGENCY_OU	udd_ctxt_ouinstance	int(4)	Yes	Owning Agency Ouinstance	No
SMNINQDTL_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	Owning Agency	No
SMNINQDTL_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	Ownership	No

Table Name :	SMN_SMNINQRTNDTL_DRILLDOWN_DTL
Comment :	the table used to store the detailed level of all transactions

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNINQRTNDTL_DOCUMENT_OU	_decimal_10_0	decimal(10)	No	document ou	No
SMNINQRTNDTL_DOCUMENT_NO	udd_documentno	varchar(40)	No	document number	No
SMNINQRTNDTL_DOCUMENT_DATE	_datetime_8	datetime(8)	Yes	document created date	No
SMNINQRTNDTL_REFDOCUMENT_OU	_decimal_10_0	decimal(10)	No	ref document ou	No
SMNINQRTNDTL_REFDOCUMENT_NO	udd_documentno	varchar(40)	Yes	ref document number	No
SMNINQRTNDTL_WH_ID	udd_warehouse	varchar(10)	Yes	warehouse id	No
SMNINQRTNDTL_ZONE_ID	udd_zone	varchar(10)	Yes	zone number	No
SMNINQRTNDTL_BIN_ID	udd_bin	varchar(10)	Yes	bin number	No
SMNINQRTNDTL_PARTNO	udd_partno	varchar(40)	No	part number	No
SMNINQRTNDTL_PARTSTATUS	udd_partstatus	varchar(40)	No	part status	No
SMNINQRTNDTL_LINE_NO	udd_seqno	int(4)	No	Line number	No
SMNINQRTNDTL_SUB_LINE_NO	udd_seqno	int(4)	No	Sub Line number	No
SMNINQRTNDTL_SRL_NO	udd_documentno	varchar(40)	Yes	Serial number	No
SMNINQRTNDTL_LOT_NO	udd_lotno	varchar(18)	Yes	lot number	No
SMNINQRTNDTL_QTY	udd_quantity	numeric(13)	Yes	quantity	No
SMNINQRTNDTL_COST	udd_cost	numeric(13)	Yes	cost	No
SMNINQRTNDTL_CREATED_DTTIME	_datetime_8	datetime(8)	Yes	created date time	No
SMNINQRTNDTL_UNIQUEID	udd_seqno	int(4)	No	unique identifier	No

Table Name :	SMN_SMNINQSUM_DRILLDOWN_SUM
Comment :	the table used to store the square off information of all transaction

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNINQSUM_PART_OU	_decimal_10_0	decimal(10)	No	Part ou	No
SMNINQSUM_PART_NUMBER	_varchar_40	varchar(40)	No	part number	No
SMNINQSUM_PART_STATUS	_varchar_40	varchar(40)	No	part status	No
SMNINQSUM_MATL_INQ_FLAG	_varchar_25	Varchar(25)	No	material flag	No
SMNINQSUM_ACCT_TYPE	_varchar_40	varchar(40)	Yes	accounting type	No
SMNINQSUM_ACCT_CODE	_varchar_32	varchar(32)	Yes	accounting code	No
SMNINQSUM_TRAN_QTY	_decimal_28_8	decimal(28)	Yes	transfer quantity	No
SMNINQSUM_TRAN_VALUE	_decimal_28_8	decimal(28)	Yes	transfer value	No
SMNINQSUM_SQUARE_OFF_QTY	_decimal_28_8	decimal(28)	Yes	square quantity	No
SMNINQSUM_SQUARE_OFF_VALUE	_decimal_28_8	decimal(28)	Yes	square off value	No
SMNINQSUM_BALANCE_QTY	_decimal_28_8	decimal(28)	Yes	balance qty	No
SMNINQSUM_BALANCE_VALUE	_decimal_28_8	decimal(28)	Yes	balance value	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SmnInqTranSqr_DrillDown_Dtl
Comment :	The table used to store the finance level transaction square off information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SmnInqTranSqr_RefKey_SeqNo	udd_sequence	numeric(9)	Yes	reference unique identifier	No
SmnInqTranSqr_Key_SeqNo	udd_sequence	numeric(9)	No	unique identifier	No
SmnInqTranSqr_Document_OU	udd_ctxt_ouinstance	int(4)	No	OU instance	No
SmnInqTranSqr_Document_No	udd_documentno	varchar(40)	No	Receipt number	No
SmnInqTranSqr_Document_Line_no	udd_sequence	numeric(9)	No	receipt document line no	No
SmnInqTranSqr_Document_Type	udd_flag	varchar(25)	Yes	document type	No
SmnInqTranSqr_Document_Date	udd_datetime1	datetime(8)	Yes	document date	No
SmnInqTranSqr_Document_Cnfm_Date	udd_datetime1	datetime(8)	Yes	date of document confirmation	No
SmnInqTranSqr_Part_crt_ou	udd_ctxt_ouinstance	int(4)	No	Part OU instance	No
SmnInqTranSqr_Part_Number	udd_partno	varchar(40)	No	Part NO	No
SmnInqTranSqr_Part_Status	udd_partstatus	varchar(40)	No	part status	No
SmnInqTranSqr_WH_OU	udd_ctxt_ouinstance	int(4)	Yes	ware house OU instance	No
SmnInqTranSqr_WH	udd_warehouse	varchar(10)	Yes	warehouse ID	No
SmnInqTranSqr_Acct_type	udd_autopostingaccounttype	varchar(40)	Yes	account type	No
SmnInqTranSqr_Acct_code	udd_accountcode	varchar(32)	Yes	account code	No
SmnInqTranSqr_FBID	udd_financebookid	varchar(20)	Yes	finance book identification	No
SmnInqTranSqr_Tran_Qty	udd_quantity	numeric(13)	Yes	transaction quantity	No
SmnInqTranSqr_Tran_Value	udd_amount	numeric(13)	Yes	transaction value	No
SmnInqTranSqr_Created_by	udd_ctxt_user	varchar(30)	Yes	Created User name	No
SmnInqTranSqr_Created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes
SmnInqTranSqr_GRDoc_Action	fin_flag	varchar(25)	Yes	Document Action for Goods Receipts	No
smninqtransqr_addl_seqno	fin_sequence	int(4)	Yes	seqno	No
SmnInqTranSqr_Src_OU	udd_ctxt_ouinstance	int(4)	Yes	source ouinstance	No
smninqtransqr_gidoc_action	fin_flag	varchar(25)	No	Document Action for Goods Inwards	No

Table Name :	SMN_SmnInqTran_DrillDown_Dtl
Comment :	The table stores the finance level transaction information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SmnInqTran_Key_SeqNo	udd_sequence	numeric(9)	No	A unique number generated for each receipt entry	No
SmnInqTran_Document_OU	udd_ctxt_ouinstance	int(4)	No	Document OU instance	No
SmnInqTran_Document_No	udd_documentno	varchar(40)	No	Document Number	No
SmnInqTran_Document_Flag	udd_flag	varchar(25)	Yes	Document flag	No
SmnInqTran_Document_Flg_Type	udd_flag	varchar(25)	Yes	Document flag type	No
SmnInqTran_Matl_Inq_Flag	udd_flag	varchar(25)	Yes	Material inquire flag	No
SmnInqTran_Document_Line_no	udd_sequence	numeric(9)	No	document line number	No
SmnInqTran_Document_Type	udd_flag	varchar(25)	Yes	Docuemant type	No
SmnInqTran_Document_Date	udd_datetime1	datetime(8)	Yes	Document Date	No
SmnInqTran_Document_Cnfm_Date	udd_datetime1	datetime(8)	Yes	Document confirmed date	No
SmnInqTran_Part_crt_ou	udd_ctxt_ouinstance	int(4)	No	part created OU	No
SmnInqTran_Part_Number	udd_partno	varchar(40)	No	part number	No
SmnInqTran_Part_Status	udd_partstatus	varchar(40)	No	Par_Status	No
SmnInqTran_Refdoc_OU	udd_ctxt_ouinstance	int(4)	Yes	OU instance of reference document no	No
SmnInqTran_Refdoc_No	udd_documentno	varchar(40)	Yes	reference document no	No
SmnInqTran_Refdoc_Type	udd_flag	varchar(25)	Yes	reference document type	No
SmnInqTran_Ref_doc_line_no	udd_sequence	numeric(9)	Yes	reference document line no	No
SmnInqTran_Acct_type	udd_autopostingaccounttype	varchar(40)	Yes	account type	No
SmnInqTran_Acct_code	udd_accountcode	varchar(32)	Yes	account code	No
SmnInqTran_FBID	udd_financebookid	varchar(20)	Yes	finance book number	No
SmnInqTran_Tran_Qty	udd_quantity	numeric(13)	Yes	transaction quantity	No
SmnInqTran_Tran_Value	udd_amount	numeric(13)	Yes	transaction value	No
SmnInqTran_Balance_Qty	udd_quantity	numeric(13)	Yes	balance quantity	No
SmnInqTran_Balance_Value	udd_amount	numeric(13)	Yes	balance value	No
SmnInqTran_Created_by	udd_ctxt_user	varchar(30)	Yes	Created User name	No
SmnInqTran_Created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
SmnInqTran_Modified_by	udd_ctxt_user	varchar(30)	Yes	Last Modified User	No
SmnInqTran_Modified_date	udd_datetime1	datetime(8)	Yes	Last Modified date	No
SmnInqTran_Tran_flag	udd_flag	varchar(25)	Yes	Transaction flag	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each record entry	Yes
smninqtran_addl_seqno	fin_sequence	int(4)	Yes	seqno	No
SmnInqTran_Src_OU	udd_ctxt_ouinstance	int(4)	Yes	source ouinstance	No

Table Name :	SMN_SMNINTMAT_INTRANSIT_MATERIAL
Comment :	the transaction intransit material information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNINTMAT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU instance	No
SMNINTMAT_REFDOCTYPE	udd_quickcodes	varchar(25)	No	Reference document type	No
SMNINTMAT_REFDOCNO	udd_documentno	varchar(40)	No	Reference document No	No
SMNINTMAT_PART	udd_partno	varchar(40)	No	Part number	No
SMNINTMAT_REFDOCLINENO	udd_seqno	int(4)	Yes	reference document line no	No
SMNINTMAT_LOCLINENO	udd_seqno	int(4)	No	Line no	No
SMNINTMAT_RECDDATE	_datetime_8	datetime(8)	Yes	parts received date	No
SMNINTMAT_RECDQTY	udd_quantity	numeric(13)	Yes	Received quantity	No
SMNINTMAT_RECDUOM	udd_uom	varchar(15)	Yes	the received UOM of part	No
SMNINTMAT_RECDLOC	udd_quickcodes	varchar(25)	Yes	the received location	No
SMNINTMAT_WAYBILLNO	udd_documentno	varchar(40)	Yes	way bill number	No
SMNINTMAT_SHPDDATE	_datetime_8	datetime(8)	Yes	shipped date	No
SMNINTMAT_SHPDLOC	udd_quickcodes	varchar(25)	Yes	shipped location	No
SMNINTMAT_STKSTS	udd_documentno	varchar(40)	Yes	stock status	No
SMNINTMAT_RMKS	udd_txt255	varchar(255)	Yes	remarks	No
SMNINTMAT_LSTRECDLOC	udd_quickcodes	varchar(25)	Yes	last received loaction of the part	No
SMNINTMAT_SUPPLIERNO	udd_vendorcode	varchar(45)	Yes	supplier no	No
SMNINTMAT_TOTORDQTY	udd_quantity	numeric(13)	Yes	total ordered quantity	No
SMNINTMAT_REMAININGQTY	udd_quantity	numeric(13)	Yes	remaining quantity	No
SMNINTMAT_ORDERUOM	udd_uom	varchar(15)	Yes	ordered UOM of the part	No
SMNINTMAT_PNDQTY	udd_quantity	numeric(13)	Yes	pending quantity	No
SMNINTMAT_GRNO	udd_documentno	varchar(40)	Yes	goods receipt document no	No
SMNINTMAT_GRQTY	udd_quantity	numeric(13)	Yes	goods receipt quantity	No
SMNINTMAT_GRSTS	udd_quickcodes	varchar(25)	Yes	goods receipt status	No
SMNINTMAT_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created User name	No
SMNINTMAT_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
SMNINTMAT_LASTMODBY	udd_ctxt_user	varchar(30)	Yes	Last Modified User	No
SMNINTMAT_LASTMODDTAE	_datetime_8	datetime(8)	Yes	Last Modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNOBDTMP_OPBAL_DTL
Comment :	openieng balance document detailed information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOBDTMP_GUID	_varchar_40	varchar(40)	No	unique identifier	No
SMNOBDTMP_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	OU instance	No
SMNOBDTMP_OPNG_BAL_NO	_varchar_40	varchar(40)	Yes	opening balance document number	No
SMNOBDTMP_LINE_NO	_decimal_10_0	decimal(10)	Yes	document line no	No
SMNOBDTMP_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	part OU instance	No
SMNOBDTMP_PART_PLN_OU	_decimal_10_0	decimal(10)	Yes	part planning OU instance	No
SMNOBDTMP_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
SMNOBDTMP_PART_STATUS	_varchar_40	varchar(40)	Yes	part Status	No
SMNOBDTMP_QTY_IN_STKUOM	_decimal_28_8	decimal(28)	Yes	quantity of the part in stcok UOM	No
SMNOBDTMP_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone identification number	No
SMNOBDTMP_BIN_ID	_varchar_10	varchar(10)	Yes	Bin identification number	No
SMNOBDTMP_REF_DOC_NO	_varchar_40	varchar(40)	Yes	reference document number	No
SMNOBDTMP_SRLLOT_FLAG	_varchar_5	varchar(5)	Yes	serial lot appliable flag	No
SMNOBDTMP_WGHACT_FLAG	_varchar_5	varchar(5)	Yes	weighted cost applicable flag	No
SMNOBDTMP_LIFOFIFO_FLAG	_varchar_5	varchar(5)	Yes	lifo fifo method applicable flag	No
SMNOBDTMP_CUST_NO	udd_customer_id	varchar(18)	Yes	customer number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNOBD_OPENING_BAL_DTL
Comment :	used to store the opening balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOBD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance OUInstance	Yes
SMNOBD_OPNG_BAL_NO	_varchar_40	varchar(40)	No	Opening Balance No	Yes
SMNOBD_LINE_NO	_decimal_10_0	decimal(10)	No	Line Number generated for each part details of an opening balance document	Yes
SMNOBD_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created OuInstance	No
SMNOBD_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	No
SMNOBD_PART_NO	_varchar_40	varchar(40)	No	Part No	No
SMNOBD_PART_STATUS	_varchar_40	varchar(40)	No	Can take any value as defined in UDSS which are stockable	No
SMNOBD_QTY_IN_STKUOM	_decimal_28_8	decimal(28)	No	Qty being received at Warehouse - Zone - Bin level	No
SMNOBD_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone Id	No
SMNOBD_BIN_ID	_varchar_10	varchar(10)	Yes	Bin Id	No
SMNOBD_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number for the qty being received.	No
SMNOBD_SRLLOT_FLAG	_varchar_5	varchar(5)	Yes	This can take the following values. Y , N , NA If the serial Or Lot details are completely entered for the Line, this will be Y If the serial Or Lot details are pending to be entered for the Line, this will be N If the serial Or Lot detail	No
SMNOBD_WGHACT_FLAG	_varchar_5	varchar(5)	Yes	This can take the following values. Y , N , NA If the part costing methodology is weighted average Or Actual Costing and if the wgh/actual costing details are completely entered for the Line, this will be Y If the part costing methodology is	No
SMNOBD_LIFOFIFO_FLAG	_varchar_5	varchar(5)	Yes	This can take the following values. Y , N , NA If the part costing methodology is Fifo/Lifo and if the Lifo-Fifo details are completely entered for the Line, this will be Y If the part costing methodology is Lifo/Fifo and if the details are n	No
SMNOBD_PART_COST	_decimal_28_8	decimal(28)	Yes	Initial Part cost at the time of openning balance - to be updated when Openning balance is confirmed	No
SMNOBD_CUST_NO	udd_customer_id	varchar(18)	Yes	customer number	No
SMNOBD_STOCK_UOM	udd_unitofmeasurement	varchar(10)	Yes	stocking UOM of the part	No
SMNOBD_PART_VALUATION_MET	udd_unitofmeasurement	varchar(10)	Yes	valuation method	No
SMNOBD_PART_CNTRL_TYPE	udd_unitofmeasurement	varchar(10)	Yes	contorl type of the part	No
SMNOBD_EXPENSE_TYPE	udd_flag	varchar(25)	Yes	Expense type of the part	No
SMNOBD_EXPENSING_POLICY	udd_designparamcode	varchar(5)	Yes	Expensing policy of the part	No
SMNOBD_ISSUE_BASIS	udd_designparamcode	varchar(5)	Yes	Issue basis of the part	No
SMNOBD_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	Not stockable attribute of the part	No
SMNOBD_PART_TYPE	udd_parttype	varchar(25)	Yes	Part type of the part	No

Table Name :	SMN_SMNOBHTMP_OPBAL_HDR
Comment :	openieng balance document header information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOBHTMP_GUID	_varchar_40	varchar(40)	Yes	unique identifier	No
SMNOBHTMP_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	OU instance	No
SMNOBHTMP_OPNG_BAL_NO	_varchar_40	varchar(40)	Yes	opening balance document number	No
SMNOBHTMP_OPNG_BAL_DATE	_datetime_8	datetime(8)	Yes	opening balance document date	No
SMNOBHTMP_OPNG_BAL_STATUS	_varchar_5	varchar(5)	Yes	document status	No
SMNOBHTMP_CATEGORY	_varchar_25	Varchar(25)	Yes	category	No
SMNOBHTMP_USER_STATUS	_varchar_25	Varchar(25)	Yes	user status	No
SMNOBHTMP_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	warehouse OU	No
SMNOBHTMP_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	warehouse Identification number	No
SMNOBHTMP_USER_DEF_1	_varchar_25	Varchar(25)	Yes	user definition part 1	No
SMNOBHTMP_USER_DEF_2	_varchar_25	Varchar(25)	Yes	user definition part 2	No
SMNOBHTMP_REMARKS	_varchar_255	varchar(255)	Yes	remarkable comments	No
SMNOBHTMP_FILENAME	_varchar_50	varchar(50)	Yes	file name	No
SMNOBHTMP_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	the document created date	No
SMNOBHTMP_CREATED_BY	_varchar_30	varchar(30)	Yes	the created user name	No
SMNOBHTMP_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	last modified date	No
SMNOBHTMP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the user who modified the document	No
SMNOBHTMP_AUTH_BY	_varchar_30	varchar(30)	Yes	the user who authorized the document	No
SMNOBHTMP_AUTH_DATETIME	_datetime_8	datetime(8)	Yes	the authorization date	No
SMNOBHTMP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	timestamp	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNOBH_OPENING_BAL_HDR
Comment :	used to store the openning balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOBH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance OUInstance	Yes
SMNOBH_OPNG_BAL_NO	_varchar_40	varchar(40)	No	Opening Balance No	Yes
SMNOBH_OPNG_BAL_DATE	_datetime_8	datetime(8)	No	Date on which the Opening Balance document was created.	No
SMNOBH_OPNG_BAL_STATUS	_varchar_5	varchar(5)	No	Status Of the document. DRFT - Draft FRSH - Fresh AUTH - Authorised CANC - Cancelled	No
SMNOBH_CATEGORY	_varchar_25	Varchar(25)	Yes	Opening Balance Category	No
SMNOBH_USER_STATUS	_varchar_25	Varchar(25)	Yes	User Status for the document	No
SMNOBH_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	OuInstance of the Warehouse where the Part-Qty is being received.	No
SMNOBH_WAREHOUSE_ID	_varchar_10	varchar(10)	No	Id of the Warehouse where the Part-Qty is being received.	No
SMNOBH_USER_DEF_1	_varchar_25	Varchar(25)	Yes	User Defined Detail 1	No
SMNOBH_USER_DEF_2	_varchar_25	Varchar(25)	Yes	User Defined Detail 2	No
SMNOBH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (If Any)	No
SMNOBH_FILENAME	_varchar_50	varchar(50)	Yes	Filename of the attached file which have more details on the OpBal document	No
SMNOBH_CREATED_DATETIME	_datetime_8	datetime(8)	No	Created Date Time	No
SMNOBH_CREATED_BY	_varchar_30	varchar(30)	No	Created User Name	No
SMNOBH_MODIFIED_DATETIME	_datetime_8	datetime(8)	No	Modified Date Time	No
SMNOBH_MODIFIED_BY	_varchar_30	varchar(30)	No	Modified User Name	No
SMNOBH_AUTH_BY	_varchar_30	varchar(30)	Yes	Authorised User Name	No
SMNOBH_AUTH_DATETIME	_datetime_8	datetime(8)	Yes	Authorised DateTime	No
SMNOBH_TIMESTAMP	_decimal_10_0	decimal(10)	No	Number of times the Opening Balance Document has got modified.	No

Table Name :	SMN_SMNOPNCLS_DATEWISE_BAL
Comment :	This table will have the datewise opening and closing balance details for location-warehouse-part

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOPNCLS_SRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Source OU Instance Id of StkMaint	No
SMNOPNCLS_WH_OU	_decimal_10_0	decimal(10)	No	Warehouse Location	No
SMNOPNCLS_WH_ID	_varchar_10	varchar(10)	No	Warehouse ID	No
SMNOPNCLS_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created OU	No
SMNOPNCLS_PART_NO	_varchar_40	varchar(40)	No	Part No	No
SMNOPNCLS_PART_STATUS	_varchar_40	varchar(40)	No	Can take any value as defined in UDSS which are stockable	No
SMNOPNCLS_DATE	_datetime_8	datetime(8)	No	Date for which opening and closing balances are maintained	No
SMNOPNCLS_VALID_UPTO	_datetime_8	datetime(8)	Yes	validity	No
SMNOPNCLS_UPDATE_FLAG	_varchar_5	varchar(5)	Yes	openning balance updated flag	No
SMNOPNCLS_TRAN_FLAG	_varchar_5	varchar(5)	Yes	trnasfer quantity	No
SMNOPNCLS_OPBAL_QTY	_decimal_28_8	decimal(28)	Yes	Openning balance quantity in stock uom	No
SMNOPNCLS_OPBAL_VALUE	_decimal_28_8	decimal(28)	Yes	Openning balance Value	No
SMNOPNCLS_TOTRCPT_QTY	_decimal_28_8	decimal(28)	Yes	Total Receipt Quantity	No
SMNOPNCLS_TOTRCPT_VALUE	_decimal_28_8	decimal(28)	Yes	Total Receipt Value	No
SMNOPNCLS_TOTISSUED_QTY	_decimal_28_8	decimal(28)	Yes	Total Issued Quantity	No
SMNOPNCLS_TOTISSUED_VALUE	_decimal_28_8	decimal(28)	Yes	Total Issued Value	No
SMNOPNCLS_TOTRTN_QTY	_decimal_28_8	decimal(28)	Yes	Total Return Quantity	No
SMNOPNCLS_TOTRTN_VALUE	_decimal_28_8	decimal(28)	Yes	Total Return Value	No
SMNOPNCLS_TOTADJ_QTY	_decimal_28_8	decimal(28)	Yes	Total Adjustment Quantity	No
SMNOPNCLS_TOTADJ_VALUE	_decimal_28_8	decimal(28)	Yes	Total Adjustment Value	No
SMNOPNCLS_TRNIN_QTY	_decimal_28_8	decimal(28)	Yes	Transaction In Quantity	No
SMNOPNCLS_TRNIN_VALUE	_decimal_28_8	decimal(28)	Yes	Transaction In Value	No
SMNOPNCLS_TRNOUT_QTY	_decimal_28_8	decimal(28)	Yes	Transaction Out Quantity	No
SMNOPNCLS_TRNOUT_VALUE	_decimal_28_8	decimal(28)	Yes	Transaction Out Value	No
SMNOPNCLS_REEVAL_VALUE	_decimal_28_8	decimal(28)	Yes	Re Evaluaion Value	No
SMNOPNCLS_CLSBAL_QTY	_decimal_28_8	decimal(28)	Yes	Closing balance quantity in stock uom	No
SMNOPNCLS_CLSBAL_VALUE	_decimal_28_8	decimal(28)	Yes	Value of the qty on the Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNOPNCLS_PERIODWISE_BAL
Comment :	the whole transaction period wise table informations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOPNCLS_SRC_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Source OU Instance Id of StkMaint	No
SMNOPNCLS_WH_OU	udd_ctxt_ouinstance	int(4)	Yes	Warehouse Location	No
SMNOPNCLS_WH_ID	udd_warehouse	varchar(10)	Yes	Warehouse ID	No
SMNOPNCLS_PART_CRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU	No
SMNOPNCLS_PART_NO	udd_partno	varchar(40)	Yes	Part No	No
SMNOPNCLS_PART_STATUS	udd_partstatus	varchar(40)	Yes	Can take any value as defined in UDSS which are stockable	No
SMNOPNCLS_ACCT_CODE	udd_accountcode	varchar(32)	Yes	Account code	No
SMNOPNCLS_FIN_YEAR	udd_flag	varchar(25)	Yes	financial year	No
SMNOPNCLS_FIN_PERIOD	udd_flag	varchar(25)	Yes	financial month	No
SMNOPNCLS_FROMDATE	_datetime_8	datetime(8)	Yes	the documents frome date	No
SMNOPNCLS_TODATE	_datetime_8	datetime(8)	Yes	the documents to date	No
SMNOPNCLS_OPBAL_QTY	udd_quantity	numeric(13)	Yes	Openning balance quantity in stock uom	No
SMNOPNCLS_OPBAL_VALUE	udd_amount	numeric(13)	Yes	Openning balance Value	No
SMNOPNCLS_TOTRCPT_QTY	udd_quantity	numeric(13)	Yes	Total Receipt Quantity	No
SMNOPNCLS_TOTRCPT_VALUE	udd_amount	numeric(13)	Yes	Total Receipt Value	No
SMNOPNCLS_TOTISSUED_QTY	udd_quantity	numeric(13)	Yes	Total Issued Quantity	No
SMNOPNCLS_TOTISSUED_VALUE	udd_amount	numeric(13)	Yes	Total Issued Value	No
SMNOPNCLS_TOTRTN_QTY	udd_quantity	numeric(13)	Yes	Total Return Quantity	No
SMNOPNCLS_TOTRTN_VALUE	udd_amount	numeric(13)	Yes	Total Return Value	No
SMNOPNCLS_TOTADJ_QTY	udd_quantity	numeric(13)	Yes	Total Adjustment Quantity	No
SMNOPNCLS_TOTADJ_VALUE	udd_amount	numeric(13)	Yes	Total Adjustment Value	No
SMNOPNCLS_TRNIN_QTY	udd_quantity	numeric(13)	Yes	Transaction In Quantity	No
SMNOPNCLS_TRNIN_VALUE	udd_amount	numeric(13)	Yes	Transaction In Value	No
SMNOPNCLS_TRNOUT_QTY	udd_quantity	numeric(13)	Yes	Transaction Out Quantity	No
SMNOPNCLS_TRNOUT_VALUE	udd_amount	numeric(13)	Yes	Transaction Out Value	No
SMNOPNCLS_REEVAL_VALUE	udd_amount	numeric(13)	Yes	Re Evaluaion Value	No
SMNOPNCLS_CLSBAL_QTY	udd_quantity	numeric(13)	Yes	Closing balance quantity in stock uom	No
SMNOPNCLS_CLSBAL_VALUE	udd_amount	numeric(13)	Yes	Value of the qty on the Date	No
SMNOPNCLS_STKANLYCONSUM_ISUQTY	udd_quantity	numeric(13)	Yes	the stock analysis issued quantity	No
SMNOPNCLS_STKANLYOPT_EXISUQTY	udd_quantity	numeric(13)	Yes	the stock analysis excess quantity	No
SMNOPNCLS_STKANLYOPT_LOISUQTY	udd_quantity	numeric(13)	Yes	loan order issued quantity	No
SMNOPNCLS_STKANLYOPT_PKISUQTY	udd_quantity	numeric(13)	Yes	issued quantity	No
SMNOPNCLS_STKANLYOPT_RENTISUQTY	udd_quantity	numeric(13)	Yes	rental issue quantity	No
SMNOPNCLS_STKANLYOPT_UPLNISUQTY	udd_quantity	numeric(13)	Yes	unplanned issue quantity	No
SMNOPNCLS_STKANLYCONSUM_RTNQTY	udd_quantity	numeric(13)	Yes	retured quantity	No
SMNOPNCLS_STKANLYOPT_UPLNRTNQTY	udd_quantity	numeric(13)	Yes	unplanned return quantity	No
SMNOPNCLS_STKANLYOPT_EXISUVAL	udd_amount	numeric(13)	Yes	external issue value	No
SMNOPNCLS_STKANLYOPT_LOISUVAL	udd_amount	numeric(13)	Yes	loan order issued value	No
SMNOPNCLS_STKANLYOPT_PKISUVAL	udd_amount	numeric(13)	Yes	issued value	No
SMNOPNCLS_STKANLYOPT_RENTISUVAL	udd_amount	numeric(13)	Yes	rental issue value	No
SMNOPNCLS_STKANLYOPT_UPLNISUVAL	udd_amount	numeric(13)	Yes	unplanned issue value	No
SMNOPNCLS_STKANLYCONSUM_RTNVAL	udd_amount	numeric(13)	Yes	return value	No
SMNOPNCLS_STKANLYOPT_UPLNRTNVAL	udd_amount	numeric(13)	Yes	unplanned return value	No
SMNOPNCLS_STKANLYCONSUM_ISUVAL	udd_amount	numeric(13)	Yes	stock analysis consumed issue value	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	SMN_SMNOPSET_OPT_SETTINGS
Comment :	used to store the set options details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNOPSET_OUINSTANCE	_decimal_10_0	decimal(10)	No	ou instance	Yes
SMNOPSET_FRAC_CONV_MTHD_FLAG	_varchar_5	varchar(5)	Yes	flag for convertion method	No
SMNOPSET_CREATED_BY	_varchar_30	varchar(30)	Yes	User who created the Quick Code	No
SMNOPSET_CREATEDDATE	_datetime_8	datetime(8)	Yes	Date on which the Option Setting is Created	No
SMNOPSET_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who Modify the Quick Code	No
SMNOPSET_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date on which the Quick Code is Modified	No
SMNOPSET_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Number of times the Option Settings has got modified.	No
SMNOPSET_PART_EXPNS_BASIS	_varchar_5	varchar(5)	Yes	Part Expense Basis	No
SMNOPSET_REPMR_NUMTYPE	_varchar_25	Varchar(25)	Yes	numbering type for auto created MR	No
SMNOPSET_REPST_NUMTYPE	_varchar_25	Varchar(25)	Yes	numbering type for auto created Stock transfer	No
SMNOPSET_REPPO_NUMTYPE	_varchar_25	Varchar(25)	Yes	numbering type for auto created Purchase Order	No
SMNOPSET_REPPR_NUMTYPE	_varchar_25	Varchar(25)	Yes	numbering type for auto created Purchase Req	No
SmnOpSet_AllOwnChng_ExtPrt	udd_designparamcode	varchar(5)	Yes	Ownership change allowed or not y - allowed n - not allowed	No
SmnOpSet_Rep_Exp_Comp	udd_designparamcode	varchar(5)	Yes	Expensing policy for components CPADD -- add to stock CPEXP -- expense off	No
SmnOpSet_Rep_Exp_PcePrt	udd_designparamcode	varchar(5)	Yes	Expensing policy for non components CPADD -- add to stock CPEXP -- expense off	No
SMNOPSET_EXPOFF_PERC	udd_discountpercentage	numeric(5)	Yes	Expensing policy	No
SMNOPSET_INSPECTION	udd_designparamcode	varchar(5)	Yes	Inspection check box A - checked	No
SMNOPSET_OVERHAUL	udd_designparamcode	varchar(5)	Yes	Overhaul check box A - checked	No
SMNOPSET_OTHERS	udd_designparamcode	varchar(5)	Yes	Others check box A - checked	No
SMNOPSET_REPAIR	udd_designparamcode	varchar(5)	Yes	Repair check box A - checked	No
SMNOPSET_RETURNCLS	udd_designparamcode	varchar(5)	Yes	This field holds the Value Y (Yes) or N (No) cost Return Cost Valuation based on Return Classification	No
SMNOPSET_AVGLEADTIME	udd_duration	numeric(13)	Yes	average lead time	No
SMNOPSET_REPLENISHMINMAX	udd_designparamcode	varchar(5)	Yes	replenishment minimum and maximum	No
SmnOpset_RepStkCrn_NumType	_varchar_25	Varchar(25)	Yes	This column holds the Numbering type	No
SMNOPSET_PRQTY_PEGG_PEND_FLAG	udd_count	int(4)	Yes	Consider PR Quantity in Receipt Pegging 1- Considered 0- Not Considered	No
SMNOPSET_REPPORS	designparamcode	varchar(5)	Yes	Open PO/RS Quantity COREP- Consider for Stock Replenishment NOREP- Do not consider for Stock Replenishment	No
SMNOPSET_WNCOST	designparamcode	varchar(5)	Yes	Set Warranty Claim Cost as Replacement Part Cost Y- Yes N- No	No
SMNOPSET_STALCTN_OWNSHP_PARTS	udd_designparamcode	varchar(5)	Yes	This column is used to store the Ownership Parts value	No
SMNOPSET_PART_MODL_EFFCTCHK	udd_designparamcode	varchar(5)	Yes	Thsi column is used to store Effectivity Check combo value	No
SMNOPSET_SOS_SERVICEPARTS	udd_designparamcode	varchar(5)	Yes	To save the value Required or Not Required for the new Option Receipt Inspection for SOS based Serviceable Parts added in the Parameter Details data cluster.	No

Table Name :	SMN_SMNPRMTMP_OBPRM_DTL
Comment :	opening balance parameter table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNPRMTMP_GUID	_varchar_40	varchar(40)	No	unique identifier	No
SMNPRMTMP_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	OU instance	No
SMNPRMTMP_OPNG_BAL_NO	_varchar_40	varchar(40)	Yes	opening balance document number	No
SMNPRMTMP_LINE_NO	_decimal_10_0	decimal(10)	Yes	opening balance document line no	No
SMNPRMTMP_SUB_LINENO	_decimal_10_0	decimal(10)	Yes	opening balance subsequent line no	No
SMNPRMTMP_PARAM_OU	_decimal_10_0	decimal(10)	Yes	parameter ou instance	No
SMNPRMTMP_PARAM_CODE	_varchar_40	varchar(40)	Yes	parameter code	No
SMNPRMTMP_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	the part is new from date	No
SMNPRMTMP_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	the part condition is over haul from date	No
SMNPRMTMP_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	the part is repair from date	No
SMNPRMTMP_SINCE_INSP	_decimal_28_8	decimal(28)	Yes	the part is inspected on date	No
SMNPRMTMP_SINCE_LSV	_decimal_28_8	decimal(28)	Yes	the pat is LSV from date	No
SMNPRMTMP_WARRANTY_VAL	_decimal_28_8	decimal(28)	Yes	warrenty validity	No
SMNPRMTMP_UNKNOWN	_varchar_3	varchar(3)	Yes	unknown	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNPRM_OPBAL_PARAM_DTL
Comment :	used to store the parameter information of openning balance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance OUInstance	Yes
SMNPRM_OPNG_BAL_NO	_varchar_40	varchar(40)	No	Opening Balance No	Yes
SMNPRM_LINE_NO	_decimal_10_0	decimal(10)	No	Line Number generated for each part details of an opening balance document	Yes
SMNPRM_SUB_LINENO	_decimal_10_0	decimal(10)	No	Sub Line No	Yes
SMNPRM_PARAM_OU	_decimal_10_0	decimal(10)	No	Ou of the Parameter	Yes
SMNPRM_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
SMNPRM_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	Parameter Value for the Part In this Condition	No
SMNPRM_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	over hauled from date	No
SMNPRM_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	repaired from	No
SMNPRM_SINCE_INSP	_decimal_28_8	decimal(28)	Yes	Parameter Value for the Part In this Condition	No
SMNPRM_SINCE_LSV	_decimal_28_8	decimal(28)	Yes	Param value Value of the Parameter in this condition.since Last Shop Visit	No
SMNPRM_WARRANTY_VAL	_decimal_28_8	decimal(28)	Yes	Warranty Value	No
SMNPRM_UNKNOWN	_varchar_2	varchar(2)	Yes	Unknown	No

Table Name :	SMN_SMNPRM_PARAMETER_DETAILS
Comment :	Stores Parameter detail information. In this component, this table needs to store only search criteria message

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	Name of the component	Yes
SMNPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	Category of the Parameter	Yes
SMNPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Parameter Type	Yes
SMNPRM_PARAMCODE	_varchar_5	varchar(5)	No	Param Code	Yes
SMNPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id.	Yes
SMNPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Description Of the Parameter	No
SMNPRM_SORT_BY	_decimal_10_0	decimal(10)	Yes	Ordering the values	No

Table Name :	SMN_SMNPRM_SRL_PARAM_VAL
Comment :	For the Stock Maintained, this entity contains the initial parameter value details for serial controlled component type of parts at the time of original receipt.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNPRM_SRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ou	Yes
SMNPRM_PART_CRT_OU	_decimal_10_0	decimal(10)	No	UnPlanned Receipt Document No	Yes
SMNPRM_PART_NO	_varchar_40	varchar(40)	No	Part No	Yes
SMNPRM_SERIAL_NO	_varchar_40	varchar(40)	No	Serial No	Yes
SMNPRM_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
SMNPRM_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	Parameter Value for the Part In this Condition	No
SMNPRM_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	over haul from date	No
SMNPRM_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	repaire from date	No
SMNPRM_SINCE_INSP	_decimal_28_8	decimal(28)	Yes	Parameter Value for the Part In this Condition	No
SMNPRM_SINCE_LSV	_decimal_28_8	decimal(28)	Yes	Param value Value of the Parameter in this condition.since Last Shop Visit	No
SMNPRM_WARRANTY_VALUE	_decimal_28_8	decimal(28)	Yes	Warranty Value.	No
SMNPRM_AS_OF_DATETIME	_datetime_8	datetime(8)	Yes	Date Time on which details are entered.	No
SMNPRM_UNKNOWN	_varchar_2	varchar(2)	Yes	Unknown	No

Table Name :	SMN_SMNQC_QUICK_CODE
Comment :	This table maintains the Quick Code information. Quick Code type referred are - Maintenance Report User Status and Reason for Carry forward

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ou instance	Yes
SMNQC_QUICK_CODE	_varchar_25	Varchar(25)	No	Quick Code number stored here.	Yes
SMNQC_TYPE	_varchar_25	Varchar(25)	No	Quick Code Type - Maintenance Report User Status/ Reason for Carry forward	Yes
SMNQC_DESC	_varchar_80	varchar(80)	No	Quick Code Description	No
SMNQC_STATUS	_varchar_25	Varchar(25)	No	Quick Code Status is stored here. A - Active I - Inactive	No
SMNQC_CREATEDDATE	_datetime_8	datetime(8)	No	Date on which quick code got created	No
SMNQC_CREATED_BY	_varchar_30	varchar(30)	No	User who has created the quick code	No
SMNQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date on which quick code got modified.	No
SMNQC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who has modified the quick code.	No
SMNQC_TIMESTAMP	_decimal_10_0	decimal(10)	No	Quick code Time stamp details	No

Table Name :	SMN_SMNSD_SHIP_DTL
Comment :	shipment history table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_SMNSD_MTRL_OU	udd_ctxt_ouinstance	int(4)	Yes	OU instance	No
SMN_SMNSD_MTRL_REQ_NO	udd_documentno	varchar(40)	Yes	material request document no	No
SMN_SMNSD_MTRL_LINE_NO	udd_lineno	int(4)	Yes	material request document line no	No
SMN_SMNSD_PART_NO	udd_documentno	varchar(40)	Yes	part number	No
SMN_SMNSD_FROM_WAREHOUSE_NO	udd_warehouse	varchar(10)	Yes	material request raised warehouse no	No
SMN_SMNSD_PROCESS_DOC_TYPE	udd_designparamcode	varchar(5)	Yes	process document type	No
SMN_SMNSD_PROCESS_DOC_NO	udd_documentno	varchar(40)	Yes	process document numnber	No
SMN_SMNSD_SHIP_BY	udd_txt20	varchar(20)	Yes	shipped by	No
SMN_SMNSD_SHIP_INS	udd_txt255	varchar(255)	Yes	shipping instance	No
SMN_SMNSD_REMARKS	udd_remarks	varchar(255)	Yes	remarks	No
SMN_SMNSD_PROCESS_QTY	udd_quantity	numeric(13)	Yes	processed quantity	No
SMN_SMNSD_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	the user created the document	No
SMN_SMNSD_CREATED_DATE	udd_time	datetime(8)	Yes	the created date of the document	No
SMN_SMNSD_MR_PR_STO_COVERED_QTY	udd_quantity	numeric(13)	Yes	the process document covered quantity	No
SMN_SMNSD_MODIFIED_DATE	udd_time	datetime(8)	Yes	the last modified date	No
SMN_SMNSD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	the last user who modified the document	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNSRLTMP_OPBAL_SL_DTL
Comment :	opening balance serial lot information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNSRLTMP_GUID	_varchar_40	varchar(40)	No	unique identifier	No
SMNSRLTMP_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	ou instance	No
SMNSRLTMP_OPNG_BAL_NO	_varchar_40	varchar(40)	Yes	openoing balance document number	No
SMNSRLTMP_LINE_NO	_decimal_10_0	decimal(10)	Yes	openeing balance docuemnt line no	No
SMNSRLTMP_SUB_LINENO	_decimal_10_0	decimal(10)	Yes	document subsequent line no	No
SMNSRLTMP_MANUF_SRL_NO	_varchar_40	varchar(40)	Yes	manifactured serial number	No
SMNSRLTMP_MANUF_LOT_NO	_varchar_18	varchar(18)	Yes	manufactured lot number	No
SMNSRLTMP_PART_CONDITION	_varchar_5	varchar(5)	Yes	condition of the part	No
SMNSRLTMP_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	part quantity in stock UOM	No
SMNSRLTMP_RATE	_decimal_28_8	decimal(28)	Yes	part rate	No
SMNSRLTMP_VALUE	_decimal_28_8	decimal(28)	Yes	part value	No
SMNSRLTMP_CERT_TYPE	_varchar_25	Varchar(25)	Yes	certificate type	No
SMNSRLTMP_CERT_NO	_varchar_40	varchar(40)	Yes	certificate number	No
SMNSRLTMP_CERT_DATE	_datetime_8	datetime(8)	Yes	certificate date	No
SMNSRLTMP_AUTH_NO	_varchar_40	varchar(40)	Yes	authorization number	No
SMNSRLTMP_SYS_TRACK_NO	_varchar_40	varchar(40)	Yes	system tracking number	No
SMNSRLTMP_SUPPLIER_OU	_decimal_10_0	decimal(10)	Yes	ou instance of supplier	No
SMNSRLTMP_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	suplier identification number	No
SMNSRLTMP_REMARKS	_varchar_255	varchar(255)	Yes	remarks	No
SMNSRLTMP_EXPIRY_DATE	_datetime_8	datetime(8)	Yes	expiiry date	No
SMNSRLTMP_WARRANTY_LAPSE_DATE	_datetime_8	datetime(8)	Yes	warrenty date till	No
SMNSRLTMP_GEN_SRL_NO	_varchar_40	varchar(40)	Yes	generated serial number	No
SMNSRLTMP_GEN_LOT_NO	_varchar_18	varchar(18)	Yes	generated lot number	No
SMNSRLTMP_CUST_NO	udd_customer_id	varchar(18)	Yes	customer number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_SMNSRL_OPBAL_SRLLOT_DTL
Comment :	used to store the serial lot details of openning balance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNSRL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance OUInstance	Yes
SMNSRL_OPNG_BAL_NO	_varchar_40	varchar(40)	No	Opening Balance No	Yes
SMNSRL_LINE_NO	_decimal_10_0	decimal(10)	No	Line Number generated for each part details of an opening balance document	Yes
SMNSRL_SUB_LINENO	_decimal_10_0	decimal(10)	No	Sub Line No	Yes
SMNSRL_MANUF_SRL_NO	_varchar_40	varchar(40)	Yes	Manufacturer Serial no	No
SMNSRL_MANUF_LOT_NO	_varchar_18	varchar(18)	Yes	Manufacturer Lot No	No
SMNSRL_PART_CONDITION	_varchar_5	varchar(5)	Yes	Part Condition	No
SMNSRL_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Qty In Stock Uom	No
SMNSRL_RATE	_decimal_28_8	decimal(28)	Yes	Rate - Calculated & Stored at present , if it is not entered. it might get changed in the future. Applicable only for Serial or Serial Lot controlled parts and for parts of valuration type as Actual Cost.	No
SMNSRL_VALUE	_decimal_28_8	decimal(28)	Yes	Value - Calculated & Stored at present , if it is not entered. it might get changed in the future.	No
SMNSRL_CERT_TYPE	_varchar_25	Varchar(25)	Yes	Certificate Type	No
SMNSRL_CERT_NO	_varchar_40	varchar(40)	Yes	Certificate No	No
SMNSRL_CERT_DATE	_datetime_8	datetime(8)	Yes	Certificate Date	No
SMNSRL_EXPIRY_DATE	_datetime_8	datetime(8)	Yes	Expiry date will be entered by the user. If not entered, it has to be computed as CertificateDate + DesignShelfLife for component type of parts. Openning Bal Date+ esignShelfLife for parts other than componetns	No
SMNSRL_AUTH_NO	_varchar_40	varchar(40)	Yes	Authorization No	No
SMNSRL_SYS_TRACK_NO	_varchar_40	varchar(40)	Yes	System Tracking Reference No	No
SMNSRL_SUPPLIER_OU	_decimal_10_0	decimal(10)	Yes	Supplier OuInstance	No
SMNSRL_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	Supplier No	No
SMNSRL_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (If Any)	No
SMNSRL_WARRANTY_LAPSE_DATE	_datetime_8	datetime(8)	Yes	Applicable only for Serial controlled Part	No
SMNSRL_GEN_SRL_NO	_varchar_40	varchar(40)	Yes	Generated Serial No	No
SMNSRL_GEN_LOT_NO	_varchar_18	varchar(18)	Yes	Generated Lot No	No

Table Name :	SMN_SMNSTKSTAT_OPT_SETTINGS
Comment :	stock option settings

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNSTKSTAT_OUINSTANCE	_varchar_10	varchar(10)	No	OU instance	Yes
SMNSTKSTAT_STOCK_STATUS	_varchar_40	varchar(40)	No	stock staus	Yes
SMNSTKSTAT_NON_PHI_OWNED_FLAG	_varchar_25	Varchar(25)	Yes	flag to indicate whethere it is PHI or not	No
SMNSTKSTAT_CREATED_BY	_varchar_30	varchar(30)	Yes	user who created the stock status	No
SMNSTKSTAT_CREATED_DATE	_datetime_8	datetime(8)	Yes	the stock status created date	No
SMNSTKSTAT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the last modified user	No
SMNSTKSTAT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	last modified date	No
SMNSTKSTAT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	timestamp	No
SMNSTKSTAT_EXTERNAL_OWNED_FLAG	UDD_AISFLAG	varchar(1)	Yes	external owing flag	No

Table Name :	SMN_SMNTMP1_OPNG_BAL_DTL
Comment :	stcok management opening balance detailed information table

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

Table Name :	SMN_SMNWHCATG_OPT_SETTINGS
Comment :	option settings table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMNWHCATG_OUINSTANCE	_decimal_10_0	decimal(10)	No	ou instance	Yes
SMNWHCATG_WRHSE_CATEGORY	_varchar_25	Varchar(25)	No	warehouse category	Yes
SMNWHCATG_UNSERVICEABLE_FLAG	_varchar_25	Varchar(25)	Yes	the flag to know the warehouse is serviceable or unserviceable	No
SMNWHCATG_CREATED_BY	_varchar_30	varchar(30)	Yes	the user who created the warehouse	No
SMNWHCATG_CREATED_DATE	_datetime_8	datetime(8)	Yes	the created date	No
SMNWHCATG_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the user who modified the informtaion	No
SMNWHCATG_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	the date of modification	No
SMNWHCATG_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	timestamp	No

Table Name :	SMN_SMN_SRL_LOT_SCH_HDR
Comment :	the stock management serial lot history header information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Smn_OU	udd_ctxt_ouinstance	int(4)	Yes	OUINSTANCE	No
Smn_Started_Flag	udd_flag	varchar(25)	Yes	Started Flag	No
Smn_Startdate	udd_time	datetime(8)	Yes	Start date	No
Smn_Enddate	udd_time	datetime(8)	Yes	End date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes
created_area_code	_Varchar_40	varchar(40)	Yes	created area code	No
SMN_WH_ID	udd_warehouse	varchar(10)	Yes	warehouse identification number	No
Smn_Start_Datetime	udd_time	datetime(8)	Yes	Start Datetime	No
SMN_WH_OU	udd_ctxt_ouinstance	int(4)	Yes	warehouse OU instance	No

Table Name :	SMN_STKCRDA_DOC_ATTACH_DTL
Comment :	used to store the reference document attached to the stock correction

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRDA_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	Yes
STKCRDA_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	Yes
STKCRDA_REF_DOC_TYPE	_varchar_15	varchar(15)	No	Reference Document Type	Yes
STKCRDA_DOC_ID	_varchar_40	varchar(40)	No	Document Id	Yes
STKCRDA_FILE_NAME	_varchar_50	varchar(50)	Yes	Reference File Name	No
STKCRDA_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (if any)	No

Table Name :	SMN_STKCRDT_STOCK_CORR_DTL
Comment :	used to store the part levevl information of stock corretion

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRDT_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	Yes
STKCRDT_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	Yes
STKCRDT_SYSLINE_NO	_decimal_10_0	decimal(10)	No	System Generated Line No	Yes
STKCRDT_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	Display Line Number	No
STKCRDT_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created Ouinstance	No
STKCRDT_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
STKCRDT_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status	No
STKCRDT_CORRECTIONQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This is the correction quantity (i.e. the difference between the existing physical stock and the newly corrected quantity] maintained in terms of the part stock uom.	No
STKCRDT_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone Id	No
STKCRDT_BIN_ID	_varchar_10	varchar(10)	Yes	Bin Id	No
STKCRDT_SYSQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	System Quantity at the time of correction	No
STKCRDT_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (if Any)	No
STKCRDT_VAL_LNKFLAG	_varchar_5	varchar(5)	Yes	Value page link flag	No
STKCRDT_CRS_LNKFLAG	_varchar_5	varchar(5)	Yes	serial lot flag	No
STKCRDT_SL_LNKFLAG	_varchar_5	varchar(5)	Yes	serial lot flag	No
STKCRDT_CC_USAGE	_varchar_20	varchar(20)	Yes	Cost Center Usage	No
STKCRDT_FIN_BOOK	_varchar_20	varchar(20)	Yes	Finance Book	No
STKCRDT_ACC_CODE	_varchar_32	varchar(32)	Yes	Account Code	No
STKCRDT_ANLY_CODE	_varchar_5	varchar(5)	Yes	Analysis Code	No
STKCRDT_SUB_ANLY_CODE	_varchar_5	varchar(5)	Yes	Sub Analysis Code	No
STKCRDT_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	Cost Center Code	No
STKCRDT_PART_CNTRL_TYPE	udd_flag	varchar(25)	Yes	part control type	No
STKCRDT_VALUATION_METHOD	udd_designparamcode	varchar(5)	Yes	part valuation method	No
STKCRDT_EXPENCE_TYPE	udd_flag	varchar(25)	Yes	part expense type	No
STKCRDT_STDCOST	udd_amount	numeric(13)	Yes	standard cost	No
STKCRDT_EXPENSING_POLICY	udd_designparamcode	varchar(5)	Yes	expensing policy	No
STKCRDT_PARTTYPE	udd_parttype	varchar(25)	Yes	part type	No
STKCRDT_STOCK_UOM	udd_uom	varchar(15)	Yes	stocking UOM of the part	No
STKCRDT_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	Not stockable attribute of the part	No
STKCRDT_ISS_BASIS	udd_designparamcode	varchar(5)	Yes	Issue Basis	No
created_area_code	_varchar_40	varchar(40)	Yes	created area code	No
STKCRDT_PART_ACC_GRP	udd_flag	varchar(25)	Yes	part account group	No
STKCRDT_ADJACTUALCOST	udd_flag	varchar(25)	Yes	actual cost	No
STKCRDT_LOTNOTYPE	udd_flag	varchar(25)	Yes	lot number type	No
STKCRDT_SLNOTYPE	udd_flag	varchar(25)	Yes	serial number type	No
STKCRDT_SLNOLOGIC	udd_flag	varchar(25)	Yes	serial number logic	No
STKCRDT_TO_PART_CNTRL_TYPE	udd_flag	varchar(25)	Yes	to part control type	No
STKCRDT_TO_VALUATION_METHOD	udd_flag	varchar(25)	Yes	to valuation method	No
STKCRDT_TO_EXPENCE_TYPE	udd_flag	varchar(25)	Yes	to expence type	No
STKCRDT_TO_EXPENSING_POLICY	udd_flag	varchar(25)	Yes	to expensing policy	No
STKCRDT_TO_PARTTYPE	udd_flag	varchar(25)	Yes	to part type	No
STKCRDT_TO_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	to non stockable flag	No
STKCRDT_TO_ISS_BASIS	udd_flag	varchar(25)	Yes	to Issue Basis	No
STKCRDT_TO_ADJACTUALCOST	udd_flag	varchar(25)	Yes	to actual cost	No
STKCRDT_TO_PART_ACC_GRP	udd_flag	varchar(25)	Yes	to part account group	No
STKCRDT_TO_LOTNOTYPE	udd_flag	varchar(25)	Yes	to lot number type	No
STKCRDT_TO_SLNOTYPE	udd_flag	varchar(25)	Yes	to serail number type	No
STKCRDT_TO_SLNOLOGIC	udd_flag	varchar(25)	Yes	to serail number logic	No
STKCRDT_AC_LNKFLAG	udd_designparamcode	varchar(5)	Yes	account link flag	No
STKCRDT_RSN_CORR	udd_flag	varchar(25)	Yes	reason for correction	No
STKCRDT_CURRENCY	udd_designparamcode	varchar(5)	Yes	currency	No

Table Name :	SMN_STKCRDT_STOCK_CORR_DTL_RA
Comment :	stock correction detailed information table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRDT_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	No
STKCRDT_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	No
STKCRDT_SYSLINE_NO	_decimal_10_0	decimal(10)	No	System Generated Line No	No
STKCRDT_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	Display Line Number	No
STKCRDT_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created Ouinstance	No
STKCRDT_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
STKCRDT_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status	No
STKCRDT_CORRECTIONQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	This is the correction quantity (i.e. the difference between the existing physical stock and the newly corrected quantity] maintained in terms of the part stock uom.	No
STKCRDT_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone Id	No
STKCRDT_BIN_ID	_varchar_10	varchar(10)	Yes	Bin Id	No
STKCRDT_SYSQTY_INSTKUOM	_decimal_10_0	decimal(10)	Yes	System Quantity at the time of correction	No
STKCRDT_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (if Any)	No
STKCRDT_VAL_LNKFLAG	_varchar_5	varchar(5)	Yes	Value page link flag	No
STKCRDT_CRS_LNKFLAG	_varchar_5	varchar(5)	Yes	serial lot flag	No
STKCRDT_SL_LNKFLAG	_varchar_5	varchar(5)	Yes	serial lot flag	No
STKCRDT_CC_USAGE	_varchar_20	varchar(20)	Yes	Cost Center Usage	No
STKCRDT_FIN_BOOK	_varchar_20	varchar(20)	Yes	Finance Book	No
STKCRDT_ACC_CODE	_varchar_32	varchar(32)	Yes	Account Code	No
STKCRDT_ANLY_CODE	_varchar_5	varchar(5)	Yes	Analysis Code	No
STKCRDT_SUB_ANLY_CODE	_varchar_5	varchar(5)	Yes	Sub Analysis Code	No
STKCRDT_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	Cost Center Code	No
STKCRDT_COST_FOR_TOOL	_decimal_28_8	decimal(28)	Yes	cost for tool	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_STKCRMN_STOCK_CORR_HDR
Comment :	This entity contains the stock correction main information like warehouse where the stock correction happens, type of the correction, specific comments if any and the status of the stock correction.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRMN_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	Yes
STKCRMN_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	Yes
STKCRMN_NUMTYPE_NO	_varchar_5	varchar(5)	Yes	Numbering Type number. This is stored as it required for arriving the cost center.	No
STKCRMN_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse Location where the material correction happens	No
STKCRMN_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	Warehouse where the material correction happens	No
STKCRMN_STKCORR_STATUS	_varchar_5	varchar(5)	Yes	This will take the following status DRFT - Draft FRSH - Fresh CANC -Cancelled CONF - Confirmed Draft: Whenever all details are not entered, the correction can be created in draft status. Fresh: Whenever all details are entered, the Stock correct	No
STKCRMN_CORR_TYPE	_varchar_5	varchar(5)	Yes	This indicates the type of discrepancy between the System Stock and the Physical Stock. If the discrepancy is on Quantity, it will come under Quantity Correction type. If there is a discrepancy only on the value, it is of Value Stock Correction typ	No
STKCRMN_CORR_BASIS	_varchar_5	varchar(5)	Yes	Correction Basis	No
STKCRMN_SRC_DOC_OU	_decimal_10_0	decimal(10)	Yes	Stock Correction Document can also be generated from PICC. This field indicates the location from where the StkCorr Doc got created	No
STKCRMN_SRC_DOC_NO	_varchar_40	varchar(40)	Yes	Stock Correction Document can also be generated from PICC. This field indicates the Source Document (PI/CC) which resulted in the creation of the Stock Correction Document	No
STKCRMN_USER_STATUS	_varchar_25	Varchar(25)	Yes	Stock Correction User Status as defined in Quick Codes	No
STKCRMN_CORR_DATE	_datetime_8	datetime(8)	Yes	The date on which stock correction takes place	No
STKCRMN_CORR_CATEGORY	_varchar_25	Varchar(25)	Yes	Stock Correction Category as defined in Quick codes	No
STKCRMN_USER_DEF_1	_varchar_25	Varchar(25)	Yes	User defined data - 1 for the stock correction doc	No
STKCRMN_USER_DEF_2	_varchar_25	Varchar(25)	Yes	User defined data - 2 for the stock correction doc	No
STKCRMN_COMMENTS	_varchar_255	varchar(255)	Yes	Comments (if any) for the stock correction document	No
STKCRMN_FILENAME	_varchar_50	varchar(50)	Yes	Filename	No
STKCRMN_DEFCORR_FLAG	_varchar_1	varchar(1)	Yes	If Apply Default Correction was enabled , this will have Y or N	No
STKCRMN_CC_USAGE	_varchar_20	varchar(20)	Yes	Cost Center Usage	No
STKCRMN_AUTH_BY	_Varchar_30	varchar(30)	Yes	Authorized By user	No
STKCRMN_AUTH_DATETIME	_datetime_8	datetime(8)	Yes	Authorised Date	No
STKCRMN_CREATED_BY	_Varchar_30	varchar(30)	Yes	Created By User	No
STKCRMN_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created Date	No
STKCRMN_MODIFIED_BY	_Varchar_30	varchar(30)	Yes	Modified By User	No
STKCRMN_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Modified Date	No
STKCRMN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
STKCRMN_ACC_USAGE	udd_usageid	varchar(20)	Yes	Accounting usage	No
STKCRMN_NET_NEGVALUE	udd_amount	numeric(13)	Yes	STKCRMN NET NEGVALUE	No
STKCRMN_NET_POSVALUE	udd_amount	numeric(13)	Yes	STKCRMN NET POSVALUE	No
STKCRMN_DOCFRM_PRTATTRCH	udd_designparamcode	varchar(5)	Yes	document from part attribute change	No
STKCRMN_PRTATTRCH_NEG_CORRDOC	udd_documentno	varchar(40)	Yes	part attribute negative correction	No
STKCRMN_auth_stage	udd_ctxt_user	varchar(30)	Yes	Authorization Stage	No
STKCRMN_wf_doc_key	udd_oudescription	varchar(256)	Yes	Work flow document Key	No
STKCRMN_NEG_CORRDOC_AC	udd_documentno	varchar(40)	Yes	correction document no	No

Table Name :	SMN_STKCRPRM_STKCORR_PARAM
Comment :	used to store the parammeter infomation of the stock correction

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRPRM_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	Yes
STKCRPRM_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	Yes
STKCRPRM_LINE_NO	_decimal_10_0	decimal(10)	No	Line Number	Yes
STKCRPRM_SYSSEQ_NO	_decimal_10_0	decimal(10)	No	System Sequence Number	Yes
STKCRPRM_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
STKCRPRM_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	Since New value	No
STKCRPRM_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value	No
STKCRPRM_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	Since Repair	No
STKCRPRM_SINCE_INSP	_decimal_28_8	decimal(28)	Yes	Since Inspection	No
STKCRPRM_SINCE_LSV	_decimal_28_8	decimal(28)	Yes	Param value since Last Shop Visit	No
STKCRPRM_WARRANTY_VALUE	_decimal_28_8	decimal(28)	Yes	Warranty Value	No
STKCRMN_ACC_USAGE	udd_usageid	varchar(20)	Yes	Accounting usage	No

Table Name :	SMN_STKCRRC_CORR_SPEC_RCPT
Comment :	used to store the stock correction specific serial level inforamtion

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRRC_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	No
STKCRRC_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	No
STKCRRC_RCPT_TYPE	_varchar_25	Varchar(25)	No	This could be OpBal, GR, Rcpt, Rtn	No
STKCRRC_RCPT_OU	_decimal_10_0	decimal(10)	No	This could be GR or Receipt Ou	No
STKCRRC_RCPT_DOC_NO	_varchar_40	varchar(40)	No	This could be the GR or Receipt Transaction Document No	No
STKCRRC_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ouinstance	No
STKCRRC_PART_NO	_varchar_40	varchar(40)	No	Part Number	No
STKCRRC_PART_STATUS	_varchar_40	varchar(40)	No	Part Status	No
STKCRRC_CORRECTIONQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Correction Quantity in Stock Uom	No
STKCRRC_CORRECTION_VALUE	_decimal_28_8	decimal(28)	Yes	Correction Value	No
STKCRRC_RECEIPT_DATE	_datetime_8	datetime(8)	Yes	Receipt Date	No
STKCRRC_RCPTQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Receipt Quantity in Stock Uom	No
STKCRRC_CORRECTED_VALUE	_decimal_28_8	decimal(28)	Yes	Corrected Value	No
STKCRRC_RECEIPT_VALUE	_decimal_28_8	decimal(28)	Yes	Receipt Value	No
STKCRRC_SEQ_NO	udd_count	int(4)	Yes	sequence number	No
STKCRRC_RATE_NO	udd_count	int(4)	Yes	rate number	No
STKCRRC_SYSQTY_INSTKUOM	udd_quantity	numeric(13)	Yes	system quantity in stock UOM	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_STKCRSL_STKCORR_SRLLOT
Comment :	This table used store the stock correction serial lot details table...

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRSL_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	Yes
STKCRSL_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	Yes
STKCRSL_SYSLINE_NO	_decimal_10_0	decimal(10)	No	System Line Number	Yes
STKCRSL_SYSSEQ_NO	_decimal_10_0	decimal(10)	No	System Sequence Number	Yes
STKCRSL_DISPLAYSEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Line Number	No
STKCRSL_REF_SRL_NO	_varchar_40	varchar(40)	Yes	Reference Serial Number	No
STKCRSL_REF_LOT_NO	_varchar_18	varchar(18)	Yes	Reference Lot Number	No
STKCRSL_SYS_SRL_NO	_varchar_40	varchar(40)	Yes	System Serial No. This could be an already existing one or NULL at the time of Create/Edit. If it is NULL, on authorize, this will be updated with the system generated serial no	No
STKCRSL_SYS_LOT_NO	_varchar_18	varchar(18)	Yes	System Lot No. This could be an already existing one or NULL at the time of Create/Edit. If it is NULL, on authorize, this will be updated with the system generated Lot no	No
STKCRSL_CORRQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Correction Quantity in Stock UOM	No
STKCRSL_CORR_VALUE	_decimal_28_8	decimal(28)	Yes	Correction Value	No
STKCRSL_SYSQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	System Quantity in Stock Uom	No
STKCRSL_SYS_VALUE	_decimal_28_8	decimal(28)	Yes	System Value	No
STKCRSL_PART_CONDITION	_varchar_40	varchar(40)	Yes	Part Condition	No
STKCRSL_CERT_TYPE	_varchar_25	Varchar(25)	Yes	Certificate Type	No
STKCRSL_CERT_DATE	_datetime_8	datetime(8)	Yes	Certificate Date	No
STKCRSL_CERT_NO	_varchar_40	varchar(40)	Yes	Certificate Number	No
STKCRSL_AUTH_NO	_varchar_40	varchar(40)	Yes	Authorisation Number	No
STKCRSL_SYS_TRACK_NO	_varchar_40	varchar(40)	Yes	System Tracking Number	No
STKCRSL_WARRANTY_LAPSE_DATE	_datetime_8	datetime(8)	Yes	Warranty Laspse Date	No
STKCRSL_TRADPARTNERNO	udd_vendorcode	varchar(45)	Yes	Owner Number\Name	No
STKCRSL_TRADPARTNERTYPE	udd_flag2	varchar(25)	Yes	Trading partner type CUS - Customer Sup - Supplier	No
STKCRSL_TRADPARTNEROU	udd_ctxt_ouinstance	int(4)	Yes	Owner location info.	No
STKCRSL_EXPIRYDATE	udd_time	datetime(8)	Yes	expiry date	No
STKCRSL_RSN_CORR	udd_flag	varchar(25)	Yes	reason for correction	No
STKCRSL_COMMENTS	udd_txt255	varchar(255)	Yes	comments	No

Table Name :	SMN_STKCRVL_STKCORR_VAL_DTL
Comment :	This table is used to stored the value details of stock correction..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STKCRVL_STKCORR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Location where the correction details are entered.	Yes
STKCRVL_STKCORR_NO	_varchar_40	varchar(40)	No	System generated number to uniquely trace stock correction details	Yes
STKCRVL_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ouinstance	Yes
STKCRVL_PART_NO	_varchar_40	varchar(40)	No	Part Number	Yes
STKCRVL_PART_STATUS	_varchar_40	varchar(40)	No	Part Status	Yes
STKCRVL_CORR_METHOD	_varchar_5	varchar(5)	Yes	Correction Method	No
STKCRVL_CORRECTION_VALUE	_decimal_28_8	decimal(28)	Yes	This will be the difference in value between the system value and the actual inventory stock current value	No
STKCRVL_SYS_LOT_NO	_varchar_18	varchar(18)	No	System Lot Number	Yes
STKCRVL_REF_LOT_NO	_varchar_18	varchar(18)	No	Reference Lot Number	Yes
STKCRVL_SYS_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	System Quantity in Stock UOM	No
STKCRVL_SYS_VALUE	_decimal_28_8	decimal(28)	Yes	System Value	No
STKCRVL_CORRECTIONQTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Correction Quantity in Stock UOM	No
STKCRVL_SEQ_NO	udd_count	int(4)	Yes	sequence number	No

Table Name :	SMN_STOCK_ASONDATE_DTL
Comment :	This table is used to store stock asn value s

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BAL_STOCK_PARTNO	_varchar_40	varchar(40)	Yes	Part number	No
BAL_STOCK_STATUS	_varchar_40	varchar(40)	Yes	Stoak status	No
BAL_STOCK_BALQTY	_decimal_28_8	decimal(28)	Yes	Bal quantity	No
BAL_STOCK_DATED	_datetime_8	datetime(8)	Yes	stock date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_TRANSACTION_DOCSTATUS
Comment :	the table to store the transaction document status

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMN_TRAN_TYPE	udd_documentno	varchar(40)	Yes	transaction type	No
SMN_TRN_DESC	udd_documentno	varchar(40)	Yes	transaction description	No
SMN_TRAN_STATUSCODE	udd_desc20	varchar(20)	Yes	transaction status code	No
SMN_TRAN_STATUSDESC	udd_documentno	varchar(40)	Yes	transaction status description	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	A unique number generated for each receipt entry	Yes

Table Name :	SMN_WGHBAL_WGH_AVG_PART_VALUE
Comment :	This table contains Available Quantity information for a part following Weighted Average costing methodology. The available quantity is maintained at the part - part status level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WGHBAL_SMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Stock Maintenance Created OUInstance	Yes
WGHBAL_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ouinstance	Yes
WGHBAL_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	Yes
WGHBAL_PART_NO	_varchar_40	varchar(40)	No	Any stockable part can be stored here	Yes
WGHBAL_PART_STATUS	_varchar_40	varchar(40)	No	Can take any value as defined in UDSS which are stockable	Yes
WGHBAL_WAREHOUSE_OU	_decimal_10_0	decimal(10)	No	If the option setting for Stock Cost Evaluation is Location level, then this would be ##. Otherwise, it will have the storage location OUId	Yes
WGHBAL_WAREHOUSE_ID	_varchar_10	varchar(10)	No	If the option setting for Stock Cost Evaluation is Location level, then this would be ##. Otherwise, it will have the Warehouse Id	Yes
WGHBAL_AVAILABLE_QTY	_decimal_28_8	decimal(28)	Yes	Available Quantity	No
WGHBAL_WEIGHTED_AVG_VALUE	_decimal_28_8	decimal(28)	Yes	Wlleighed Average Value	No
WGHBAL_CREATED_BY	_varchar_30	varchar(30)	No	Created User Name	No
WGHBAL_CREATED_DATE	_datetime_8	datetime(8)	No	Created User Date	No
WGHBAL_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified by	No
WGHBAL_MODIFIED_DATE	_datetime_8	datetime(8)	No	Last Modified Date	No
WghBal_OWNERSHIP	udd_flag1	varchar(25)	Yes	Owner Number\Name	No
WghBal_OWNINGAGENCY_OU	udd_ctxt_ouinstance	int(4)	Yes	Owner location info.	No
WghBal_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	Trading partner type CUS - Customer Sup - Supplier	No

Table Name :	SMN_WGTACT_WHGTAVG_ACT_COST
Comment :	This table is used to store the weighted average details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WGTACT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OuInstance	Yes
WGTACT_OPNG_BAL_NO	_varchar_40	varchar(40)	No	Opening Balance No	Yes
WGTACT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ou	Yes
WGTACT_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	Yes
WGTACT_PART_NO	_varchar_40	varchar(40)	No	Part No	Yes
WGTACT_MANUF_LOT_NO	_varchar_18	varchar(18)	No	Will be ## in all cases except for ActualCosting-OnlyLot case	Yes
WGTACT_QTY	_decimal_28_8	decimal(28)	Yes	Qty - Applicable for parts of Weighted Average Only and parts which are Lot Controlled.	No
WGTACT_RATE	_decimal_28_8	decimal(28)	Yes	Rate - Applicable for parts of Weighted Average Only and parts which are Lot Controlled.	No
WGTACT_VALUE	_decimal_28_8	decimal(28)	Yes	Value - Applicable for parts of Weighted Average Only and parts which are Lot Controlled.	No
WGTACT_ENTRY_TYPE	_varchar_5	varchar(5)	Yes	Entry Type can be S- Single M - Multiple	No
WGTACT_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document No	No
WGTACT_PART_STATUS	udd_partstatus	varchar(40)	No	Part status	Yes
WGTACT_STOCK_UOM	udd_uomcode	varchar(10)	Yes	Stock uom	No

Table Name :	SMN_WGTDT_WGAVG_MLTRATE_DTL
Comment :	material detailrs table..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WGTDT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OuInstance	Yes
WGTDT_OPNG_BAL_NO	_varchar_40	varchar(40)	No	Opening Balance No	Yes
WGTDT_PART_PLN_OU	_decimal_10_0	decimal(10)	No	Part Planning Ou	Yes
WGTDT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created Ou	Yes
WGTDT_PART_NO	_varchar_40	varchar(40)	No	Part No	Yes
WGTDT_SEQ_NO	_decimal_10_0	decimal(10)	No	User Entered Sequence No	Yes
WGTDT_SYS_LINENO	_decimal_10_0	decimal(10)	No	System Generated Line No	No
WGTDT_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Qty In Stock Uom	No
WGTDT_RATE	_decimal_28_8	decimal(28)	Yes	Rate	No
WGTDT_VALUE	_decimal_28_8	decimal(28)	Yes	Value	No
WGTDT_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Details	No
WGTDT_PART_STATUS	udd_partstatus	varchar(40)	No	part status	Yes