Stock Maintenance

Stock Maintenance

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values: Round Up,Round Down, Round Off.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
IssOpSet_OUInstance	int	NOT NULL	%AttDef	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	nvarchar(5)	NULL	Method Conversion Flag Value. It is used for Rounding the Fractional Values Rounded Up - RUP Rounded Down - RDWN Rounded Off - ROFF	No	No
SmnOpset_Part_Expns_Basis	char(18)	NULL	Part Expense Basis	No	No
SmnOpSet_Created_By	nvarchar(30)	NULL	User who created the Quick Code	No	No
SmnOpSet_CreatedDate	datetime	NULL	Date on which the Option Setting is Created	No	No
SmnOpSet_Modified_By	nvarchar(30)	NULL	User who Modify the Quick Code	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Date on which the Quick Code is Modified	No	No
SmnOpSet_Timestamp	int	NULL	Number of times the Option Settings has got modified.	No	No

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values: Round Up,Round Down, Round Off.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
IssOpSet_OUInstance	int	NOT NULL	%AttDef	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	nvarchar(5)	NULL	Method Conversion Flag Value. It is used for Rounding the Fractional Values Rounded Up - RUP Rounded Down - RDWN Rounded Off - ROFF	No	No
SmnOpset_Part_Expns_Basis	char(18)	NULL	Part Expense Basis	No	No
SmnOpSet_Created_By	nvarchar(30)	NULL	User who created the Quick Code	No	No
SmnOpSet_CreatedDate	datetime	NULL	Date on which the Option Setting is Created	No	No
SmnOpSet_Modified_By	nvarchar(30)	NULL	User who Modify the Quick Code	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Date on which the Quick Code is Modified	No	No
SmnOpSet_Timestamp	int	NULL	Number of times the Option Settings has got modified.	No	No

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values: Round Up,Round Down, Round Off.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
IssOpSet_OUInstance	int	NOT NULL	%AttDef	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	nvarchar(5)	NULL	Method Conversion Flag Value. It is used for Rounding the Fractional Values Rounded Up - &nbspRUP Rounded Down - &nbspRDWN Rounded Off - &nbspROFF	No	No
SmnOpset_Part_Expns_Basis	char(18)	NULL	Part Expense Basis	No	No
SmnOpSet_Created_By	nvarchar(30)	NULL	User who created the Quick Code	No	No
SmnOpSet_CreatedDate	datetime	NULL	Date on which the Option Setting is Created	No	No
SmnOpSet_Modified_By	nvarchar(30)	NULL	User who Modify the Quick Code	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Date on which the Quick Code is Modified	No	No
SmnOpSet_Timestamp	int	NULL	Number of times the Option Settings has got modified.	No	No

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values: Round Up,Round Down, Round Off.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
IssOpSet_OUInstance	int	NOT NULL	%AttDef	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	nvarchar(5)	NULL	Method Conversion Flag Value. It is used for Rounding the Fractional Values Rounded Up - RUP Rounded Down - RDWN Rounded Off - ROFF	No	No
SmnOpset_Part_Expns_Basis	char(18)	NULL	Part Expense Basis	No	No
SmnOpSet_Created_By	nvarchar(30)	NULL	User who created the Quick Code	No	No
SmnOpSet_CreatedDate	datetime	NULL	Date on which the Option Setting is Created	No	No
SmnOpSet_Modified_By	nvarchar(30)	NULL	User who Modify the Quick Code	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Date on which the Quick Code is Modified	No	No
SmnOpSet_Timestamp	int	NULL	Number of times the Option Settings has got modified.	No	No

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values: Round Up,Round Down, Round Off.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
IssOpSet_OUInstance	int	NOT NULL	%AttDef	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	nvarchar(5)	NULL	Method Conversion Flag Value. It is used for Rounding the Fractional Values Rounded Up - RUP Rounded Down - RDWN Rounded Off - ROFF	No	No
SmnOpset_Part_Expns_Basis	char(18)	NULL	Part Expense Basis	No	No
SmnOpSet_Created_By	nvarchar(30)	NULL	User who created the Quick Code	No	No
SmnOpSet_CreatedDate	datetime	NULL	Date on which the Option Setting is Created	No	No
SmnOpSet_Modified_By	nvarchar(30)	NULL	User who Modify the Quick Code	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Date on which the Quick Code is Modified	No	No
SmnOpSet_Timestamp	int	NULL	Number of times the Option Settings has got modified.	No	No

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values: Round Up,Round Down, Round Off.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
IssOpSet_OUInstance	int	NOT NULL	%AttDef	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	nvarchar(5)	NULL	Method Conversion Flag Value. It is used for Rounding the Fractional Values Rounded Up - RUP Rounded Down - RDWN Rounded Off - ROFF	No	No
SmnOpset_Part_Expns_Basis	char(18)	NULL	Part Expense Basis	No	No
SmnOpSet_Created_By	nvarchar(30)	NULL	User who created the Quick Code	No	No
SmnOpSet_CreatedDate	datetime	NULL	Date on which the Option Setting is Created	No	No
SmnOpSet_Modified_By	nvarchar(30)	NULL	User who Modify the Quick Code	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Date on which the Quick Code is Modified	No	No
SmnOpSet_Timestamp	int	NULL	Number of times the Option Settings has got modified.	No	No

Table Name Smn_bal_whznbn_lot_srl_lvl_bal

Table Comment This table contains available or balance quantity at part - part status - warehouse - zone - bin - lot - serialno level.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Bal_smn_ouinstance	decimal(10)	NOT NULL	Stock Maintenance Source OUInstance in an interacting set of OUs	Yes	No
Bal_warehouse_ouinstance	decimal(10)	NOT NULL	Warehouse Created OUinstance	Yes	No
Bal_warehouse_id	varchar(10)	NOT NULL	Warehouse level lock should be made before checking for qty availability and balance update Will be ## when source is ’Cfg’ of ’Ac’	Yes	No
Bal_zone_id	varchar(10)	NOT NULL	This has to be stored as ## if the part is received in a FREE Warehouse	Yes	No
Bal_bin_id	varchar(10)	NOT NULL	This has to be stored as ## if the part is received in a FREE Warehouse or in a FREE Zone	Yes	No
Bal_part_crt_ou	decimal(10)	NOT NULL	Part Crated OUInstance	Yes	No
Bal_part_no	varchar(40)	NOT NULL	Any stockable part can be stored here	Yes	No
Bal_part_condition	varchar(5)	NOT NULL	Part Condition O - Overhauled N - New S - Serviceable U - UnServiceable	Yes	No
Bal_part_status	varchar(40)	NOT NULL	Can take any value as defined in UDSS which are stockable	Yes	No
Bal_serial_no	varchar(40)	NOT NULL	For serial controlled parts, the exact serial # being issued.	Yes	No
Bal_lot_no	varchar(18)	NOT NULL	For lot controlled parts, the lot # from which the parts are being issued.	Yes	No
Bal_part_pln_ou	decimal(10)	NULL	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	No
Bal_source_flag	varchar(5)	NULL	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 their description. OPBAL - Opening Balance UPR - Unplanned Receipt UPLRTN - Unplanned Return NRMRTN - Normal (Maint) Return GR - Goods Receipt CFG - Configuration AC - Aircraft	No	No
Bal_source_doc_ou	decimal(10)	NULL	Original Source document OU (Receipt or GR or Opening Balance or Aircraft No or Config No) which created the Stock Balance	No	No
Bal_source_doc_no	varchar(40)	NULL	Original Source document no (Receipt or GR or Opening Balance or Aircraft No or Config No) which created the Stock Balance	No	No
Bal_source_doc_rcpt_Date	datetime	NULL	Receipt Date of GR Or Openning Balance or Receipt transaction	No	No
Bal_lastupd_doc_type	varchar(25)	NULL	OPBAL - Opening Balance UPLREC - Unplanned Receipt GR - Goods Receipt CFG - Configuration AC - Aircraft STKTRN - Intra Stock Transfer ISU - Issue RTN - Return SSC - Stock Status Conversion	No	No
Bal_lastupd_doc_ou	decimal(10)	NULL	Last updated Source document OU (Receipt or GR or Opening Balance or Issue or Aircraft or Config) which updated the Stock Balance	No	No
Bal_lastupd_doc_no	varchar(40)	NULL	Last updated Source document No (Receipt or GR or Opening Balance or Issue or Aircraft or Config) which updated the Stock Balance	No	No
Bal_ref_serial_no		NULL	Reference Serial No or Manufacturer Serial No	No	No
Bal_ref_lot_no	varchar(18)	NULL	Reference Lot No	No	No
Bal_available_qty	numeric(28,8)	NULL	Quantity is stored at the stock uom	No	No
Bal_AvlQty_InVolUom	numeric(28,8)	NULL	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 uom if the warehouse is a free warehouse	No	No
Bal_AvlQty_InWghUom	numeric(28,8)	NULL	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 uom if the warehouse is a free warehouse	No	No
Bal_hard_alloc_Qty	numeric(28,8)	NULL	Hard Allocated qty for the key details	No	No
Bal_act_valuation_rate	numeric(28,8)	NULL	This column value will be NULL for all parts except those parts which follow ’Actual Valuation’ costing method	No	No
Bal_Rcvd_Act_Rate	decimal(28,8)	NULL	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	No
Bal_Certificate_Type	varchar(25)	NULL	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 stored here.	No	No
Bal_Certificate_No	varchar(40)	NULL	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	No
Bal_Certificate_Date	datetime	NULL	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	No
Bal_Auth_No	varchar(40)	NULL	Authorization No. Applicable for serial controlled part	No	No
Bal_Sys_Tracking_Ref	varchar(40)	NULL	Tracking Reference Applicable for Serial controlled parts.	No	No
Bal_Receipt_Cost	numeric(28,8)	NULL	Will be NULL for those parts which are not of type ’Std Cost’ costing methodology. Total Receipt Value accumulated for std part item	No	No
Bal_Tot_Std_Cost	numeric(28,8)	NULL	Will be NULL for those parts which are not of type ’Std Cost’ costing methodology. Total Value accumulated for std part item	No	No
Bal_Component_Ou	decimal(10)	NULL	Component Ou	No	No
Bal_Component_Id	varchar(90)	NULL	Component Id	No	No
Bal_old_part_crt_ou	decimal(10)	NULL	Part No (Ou) of the component prior to modification	No	No
Bal_Old_Part_No	varchar(40)	NULL	Part No of the component prior to modification	No	No
Bal_Old_Part_Srl		NULL	Old Serial no of the component prior to modification of the same	No	No
Bal_Old_Comp_Ou	decimal(10)	NULL	Old Component id (ou) for the part serial	No	No
Bal_Old_Comp_Id	varchar(40)	NULL	Old Component id for the part serial	No	No
Bal_Warranty_Lapse_Date	datetime	NULL	Warranty lapse date for the serial controlled parts	No	No
Bal_AcConfig_Flag	varchar(5)	NULL	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	No
Bal_Srl_Expiry_Date	datetime	NULL	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 For return, except for excess returns the Expiry Date is to be calculated as Return Date + Designed Shelf Life	No	No
Bal_FirstIsu_Flag	varchar(25)	NULL	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 the part is not a component. Note: On excess return of the stock this will be reset to ’N’.	No	No
BAL_SERIAL_RUNNING_NO	decimal(10)	NULL	current Serial number	No	No
BAL_SERIAL_NO_PREFIX	varchar(6)	NULL	prefix for the serial number generation	No	No
BAL_SERIAL_NO_SUFFIX	varchar(6)	NULL	suffix for the serial number generation	No	No
BAL_OWNERSHIP	varchar(5)	NULL	holds the ownership of the part ’CUS’ - Customer ’SUP’ - Supplier ’OWN’ - Internal	No	No
BAL_OWNINGAGENCY	varchar(45)	NULL	holds the owner name	No	No
BAL_OWNINGAGENCY_OU	decimal(10)	NULL	holds the owner location instance	No	No
Bal_created_by	varchar(30)	NULL	Created User Name	No	No
Bal_created_date	datetime	NULL	Created Date	No	No
Bal_modified_by	varchar(30)	NULL	Last Modified User Name	No	No
Bal_modified_date	datetime	NULL	LAst Modified Date	No	No
BAL_ASSET_NO	sql_variant	NULL	asset number	No	No
BAL_ASSET_TAG	int	NULL	asset tag number	No	No
BAL_ASSET_MODIFIED_BY	sql_variant	NULL	holds the user name who modified the asset	No	No
BAL_ASSET_MODIFIED_DATE	sql_variant	NULL	modified date	No	No
BAL_PROPOSAL_NO	sql_variant	NULL	the proposal number	No	No
BAL_VALUE	bigint	NULL	value of the asset	No	No
BAL_SOURCE_RTN_DOC_OU	int	NULL	document ou	No	No
BAL_SOURCE_RTN_DOC_NO	sql_variant	NULL	document number	No	No
BAL_COREVALUE	bigint	NULL	core value of the part(life time costing)	No	No
BAL_VARVALUE	bigint	NULL	variable value of the part(life time costing)	No	No
BAL_SOURCE_DOC_LINENO	int	NULL		No	No
Bal_Qur_status	sql_variant	NULL		No	No
Bal_Qur_RefDocType	varchar(25)	NULL		No	No
Bal_Qur_RefDocNo	varchar(40)	NULL		No	No

Table Name SMN_DATEWISE_CMAV_INFO

Table Comment used to store weighted average details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DATEWISE_PART_OU	decimal(10)	NULL	part ou	No	No
DATEWISE_PART_NO	varchar(40)	NULL	part number	No	No
DATEWISE_PARTSTATUS	varchar(40)	NULL	part status	No	No
DATEWISE_DATED	datetime	NULL	date	No	No
DATEWISE_VALUE	decimal(28,8)	NULL	value of the part	No	No
DATEWISE_QUANTITY	decimal(28,8)	NULL	Quantity	No	No
DATEWISE_CMAV_COST	decimal(28,8)	NULL	part cost	No	No
DATEWISE_FLAG	char(2)	NULL	holds the value ’Y’ - yes and ’N’- no	No	No

Table Name Smn_Invent_Reval_BalSheet_Det
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Smn_BS_Reval_OuInstance	UDD_ctxt_ouinstance	NOT NULL	Stock Maintenance Component OU instance value.	No	No
Smn_BS_Reval_Doc_No	UDD_Documentno	NOT NULL	Inventory Revaluation Document number.	No	No
Smn_BS_Reval_Part_CrtOU	UDD_ctxt_ouinstance	NULL	Part Created OU Instance value	No	No
Smn_BS_Reval_Part_No	Udd_PartNo	NULL	Part Number used for Inventory Revaluation	No	No
Smn_BS_Reval_Warehouse_Ou	UDD_ctxt_ouinstance	NULL	Warehouse created OU instance value	No	No
Smn_BS_Reval_Serial_No	varchar(40)	NULL	Part serial number used to calculate the Inventory Revaluation.	No	No
Smn_BS_Reval_Lot_No	Udd_LotNo	NULL	Part Lot number used to calculate the Inventory Revaluation.	No	No
Smn_BS_Reval_WarehouseId	UDD_Warehouse	NULL	Warehouse number used to take the part to calculate the Inventory Revaluation.	No	No
Smn_BS_Reval_Stock_Status	Udd_Status	NULL	Stock status of the part used for Inventory Revaluation.	No	No
Smn_BS_Reval_Part_Type	Udd_Type	NULL	Part type of the part used for Inventory Revaluation.	No	No
Smn_BS_Reval_Tot_Qty	Udd_Quantity	NULL	Total quantity of the part in stock used for Inventory Revaluation.	No	No
Smn_BS_Reval_Unit_Rate	Udd_Rate	NULL	Unit rate for the Part.	No	No
Smn_BS_Reval_Sys_Market_Rate	Udd_Rate	NULL	Market rate (lowest cost from the supplier for that part) taken from the system.	No	No
Smn_BS_Reval_Market_Rate	Udd_Rate	NULL	Market rate (lowest cost from the supplier for that part) updated by the user.	No	No
Smn_BS_Reval_Tot_Stock_Value	Udd_Amount	NULL	Total Quantity * Unit Rate.	No	No
Smn_BS_Reval_Tot_Market_Value	Udd_Amount	NULL	Total Quantity * Market Rate (User updated value)	No	No
Smn_BS_Reval_Zone	Udd_Zone	NULL	Zone details where the part available.	No	No
Smn_BS_Reval_Bin	Udd_Bin	NULL	Bin details where the part available.	No	No
Smn_BS_Reval_Supplier_No	Udd_vendorCode	NULL	Supplier number who supplier the part for the lowest cost.	No	No
Smn_BS_Reval_Totvalue_comp	bigint	NULL	This column holds the total value	No	No

Table Name Smn_Invent_Reval_Hdr
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Smn_Reval_Ouinstance	UDD_ctxt_ouinstance	NOT NULL	Stock Maintenance OU Instance value	Yes	No
Smn_Reval_Doc_No	UDD_Documentno	NOT NULL	Stock Revaluation Document number	Yes	No
Smn_Reval_Period	fin_financeperiod	NOT NULL	Stock revaluation period.	Yes	No
Smn_Reval_Created_date	UDD_Time	NULL	To store the Created date.	No	No
Smn_Reval_PartType	UDD_Type	NULL	To Store the Part type	No	No
Smn_Reval_Acc_Usage	FIN_USAGEID	NULL	To store the accounting usage.	No	No
Smn_Reval_Cost_Usage		NULL	To store the costing usage	No	No
Smn_Reval_Type	Udd_Type	NULL	To store the revaluation type.	No	No
Smn_Reval_Basis	Udd_Basis	NULL	To Store the revaluation basis.	No	No
Smn_Reval_Method	Udd_Flag	NULL	To Store the revaluation method.	No	No
Smn_Reval_Level		NULL	To Store the revaluation level.	No	No
Smn_Reval_Warehouse_Ou	UDD_ctxt_ouinstance	NULL	Store the Warehouse created OU instance.	No	No
Smn_Reval_Warehouse_Id	Udd_Warehouse	NULL	To Store the warehouse number	No	No
Smn_Reval_Computed_Value	Udd_Amount	NULL	To store the computed value.	No	No
Smn_Reval_Revaluated_Value		NULL	To Store the revaluated value	No	No
Smn_Reval_Base_Currecny	fin_currency	NULL	To Store the Base Currency.	No	No
Smn_Reval_Exchg_Rate	UDD_amount	NULL	To Store the exchange rate.	No	No
Smn_Reval_JV_Doc_No	UDD_Documentno	NULL	To store the Journal Voucher document number.	No	No
Smn_Reval_Affected_Items	UDD_Count	NULL	To store the total number of items affected while computing revaluation.	No	No
Smn_Reval_Stock_Value	Udd_Amount	NULL	To store the total stock value	No	No
Smn_Reval_Stock_Correction_No	UDD_Documentno	NULL	To store the stock correction number.	No	No
Smn_Reval_Stock_Remarks	Udd_Remarks	NULL	To store the user remarks	No	No
Smn_Reval_Stock_FileName	Udd_FileName	NULL	To store the stock revaluation file name.	No	No
Smn_Reval_BS_Remarks	Udd_Remarks	NULL	To store the Balance sheet remarks.	No	No
Smn_Reval_BS_FileName	Udd_FileName	NULL	To store the balance sheet file name.	No	No
Smn_Reval_LastUpdated_By	Udd_Ctxt_User	NULL	To store the last updated user.	No	No
Smn_Reval_LastUpdated_Date	Udd_Time	NULL	To store the last updated date.	No	No
Smn_Reval_Created_By	Udd_Ctxt_User	NULL	To store the created user.	No	No

Table Name Smn_Invent_Reval_Scheduler_Dump
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Smn_Schd_Reval_Ouinstance	UDD_ctxt_ouinstance	NOT NULL	Stock Maintenance Ouinstance	Yes	No
Smn_Schd_Reval_Period	fin_financeperiod	NOT NULL	Inventory Revaluation Period Taken from the Finance component.	Yes	No
Smn_Schd_Reval_DateTime	Udd_Time	NOT NULL	Revaluation Date and Time	Yes	No
Smn_Schd_Reval_Part_No	Udd_PartNo	NOT NULL	Inventory Revaluation Part Number	Yes	No
Smn_Schd_Reval_Part_Ou	UDD_ctxt_ouinstance	NOT NULL	Part Created Ouinstance Value	Yes	No
Smn_Schd_Reval_WarehouseId	Udd_Warehouse	NOT NULL	Inventory Revaluation Warehouse id	Yes	No
Smn_Schd_Reval_WarehouseOu	UDD_ctxt_ouinstance	NOT NULL	Warehouse Created OU Instance value	Yes	No
Smn_Schd_Reval_Serial_No	udd_partserialnumber	NOT NULL	Inventory Revaluation Part Serial Number	Yes	No
Smn_Schd_Reval_Lot_No	Udd_LotNo	NOT NULL	Inventory Revaluation Part Lot Number	Yes	No
Smn_Schd_Reval_Zone	Udd_Zone	NOT NULL	Zone details for the part where it is located.	Yes	No
Smn_Schd_Reval_Bin	Udd_bin	NOT NULL	Bin details for the Part where it is located.	Yes	No
Smn_Schd_Reval_Part_Status	Udd_PartStatus	NOT NULL	Stock Status of the part defined in Inventory Revaluation	Yes	No
Smn_Schd_Reval_Avail_Qty	Udd_Quantity	NULL	Quantity available in the Stock for the given part.	No	No
Smn_Schd_Reval_Alloc_Qty		NULL	Quantity allocate for the given part in the Stock	No	No
Smn_Schd_Reval_Rate	Udd_Rate	NULL	User define rate	No	No
Smn_Schd_Reval_Valuation_Type	Udd_Type	NULL	Valuation Type to calculate the Inventory Revaluation.	No	No
Smn_Schd_Reval_Ref_No	UDD_Documentno	NULL	Reference number if any	No	No
Smn_Schd_Reval_Ref_Date	Udd_Time	NULL	Reference date	No	No
Smn_Schd_Reval_StockUom	Udd_Uom	NULL	Stock UOM for the part available in the Stock	No	No
Smn_Schd_Reval_User	Udd_ctxt_User	NULL	User details	No	No
Smn_Schd_Reval_Language	Udd_ctxt_Language	NULL	Language (Fwcontext)	No	No
Smn_Schd_Reval_Supplier	UDD_VendorCode	NULL	Part supplier who supplies for the minimum rate among various supplier.	No	No
Smn_Schd_Reval_MarketRate	UDD_Amount	NULL	Lower of cost among various supplier for that Part.	No	No
Smn_Schd_Reval_PartType	UDD_Type	NULL	Part type for the Part.	No	No
Smn_Schd_Reval_Processed	UDD_Flag	NULL	It is a Flag column which denotes for that Part,Serial, Line Inventory Revaluation has already happened or Not.	No	No

Table Name Smn_Invent_Reval_StockReval_Det
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Smn_Stk_Reval_Ouinstance	UDD_ctxt_ouinstance	NOT NULL	Inventory Revaluation OU value	No	No
Smn_Stk_Reval_Doc_No	UDD_Documentno	NOT NULL	Inventory Revaluation Document Number	No	No
Smn_Stk_Reval_Part_No	Udd_PartNo	NULL	Inventory Revaluation Part Number	No	No
Smn_Stk_Reval_Part_CrtOu	UDD_ctxt_ouinstance	NULL	Inventory Revaluation Part created OU instance value	No	No
Smn_Stk_Reval_Warehouse_Ou		NULL	Inventory Revaluation Warehouse created OU instance	No	No
Smn_Stk_Reval_Serial_No	varchar(40)	NULL	Inventory Revaluation Part Serial Number	No	No
Smn_Stk_Reval_Lot_No	Udd_LotNo	NULL	Inventory Revaluation Part Lot Number	No	No
Smn_Stk_Reval_Stock_Status	Udd_Status	NULL	Inventory Revaluation Part Stock Status	No	No
Smn_Stk_Reval_Part_Type	Udd_Type	NULL	Inventory Revaluation Part Type	No	No
Smn_Stk_Reval_Tot_Qty	Udd_Quantity	NULL	Inventory Revaluation Total Quantity	No	No
Smn_Stk_Reval_Unit_Rate	Udd_Rate	NULL	Inventory Revaluation Unit rate of the Part.	No	No
Smn_Stk_Reval_Market_Value	Udd_Amount	NULL	To fetch the lowest supplier rate for the Part.	No	No
Smn_Stk_Reval_Current_Value		NULL	Current value = Total Qty * Unit rate	No	No
Smn_Stk_Reval_LCM_Value		NULL	LCM Value = Total Quantity * Market rate	No	No
Smn_Stk_Reval_Supplier_No	Udd_vendorCode	NULL	Inventory Revaluation Supplier Number. This should be the supplier who supplies the part for the minimum price among various supplier.	No	No
Smn_Stk_Reval_Part_ActGrp	Udd_Group	NULL	Inventory Revaluation Part belongs to the particular Part group	No	No
Smn_Stk_Reval_Zone	Udd_Zone	NULL	Inventory Revaluation Zone for the Part located	No	No
Smn_Stk_Reval_Bin	Udd_Bin	NULL	Warehouse Bin where the part is located	No	No

Table Name Smn_lfbal_fifo_lifo_part_rate

Table 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 subsequent Stock Correction for Lifo, Fifo parts happens at Receipt Level
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LFBal_smn_ouinstance	decimal(10)	NOT NULL	Stock Maintenance Created ouinstance	Yes	No
LFBal_Warehouse_Ou	decimal(10)	NOT NULL	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	No
LFBal_Warehouse_Id	varchar(10)	NOT NULL	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	No
LFBal_part_crt_ou	decimal(10)	NOT NULL	Part Created OUinstance	Yes	No
LFBal_part_pln_ou	decimal(10)	NOT NULL	Part Planning Ou	Yes	No
LFBal_part_no	varchar(40)	NOT NULL	Any stockable part can be stored here	Yes	No
LFBal_part_status	varchar(40)	NOT NULL	Can take any value as defined in UDSS which are stockable	Yes	No
LFBal_as_on_date	datetime	NOT NULL	Stock received Date	Yes	No
LFBal_Rate_No	decimal(10)	NOT NULL	A unique number generated for each receipt entry	Yes	No
LFBal_Receipt_Type	varchar(10)	NOT NULL	This will have the receipt document type. Stock can be received thru GoodsReceipt, Unplanned Receipt, Stock Transfer Receipt, Return etc...	Yes	No
LFBal_Receipt_Ou	decimal(10)	NOT NULL	OU Instance of the Receipt Document	Yes	No
LFBal_Receipt_No	varchar(40)	NOT NULL	Original Receipt Document No thru which the stock entries got recorded	Yes	No
LFBal_available_qty	numeric(28,8)	NULL	This is the consolidated qty for FIFO/LIFO parts ReceiptDocNo-Part-PartStatus-AsOnDate-Rate combination, .	No	No
LFBal_Receipt_Qty	decimal(28,8)	NULL	receipt Qty in stock uom	No	No
LFBal_fifo_lifo_rate	numeric(28,8)	NULL	Lifo and Fifo Rate	No	No
LFBal_created_by	varchar(30)	NOT NULL	Created User name	No	No
LFBal_created_date	datetime	NOT NULL	Created Date	No	No
LFBal_modified_by	varchar(30)	NOT NULL	Last Modified User	No	No
LFBal_modified_date	datetime	NOT NULL	Last Modified date	No	No

Table Name Smn_MntCore_Amend_Dtl

Table Comment used to store the ameneded details of main core details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AmendDtl_OuInstance	int	NOT NULL	Ou instance	No	No
AmendDtl_LineNo	int	NULL	line number of the part	No	No
AmendDtl_AmendNo	int	NULL	amendment number	No	No
AmendDtl_ComponentNo	sql_variant	NULL	Component Id	No	No
AmendDtl_Warehouse	sql_variant	NULL	ware house number	No	No
AmendDtl_PartNo	sql_variant	NULL	part number	No	No
AmendDtl_Serial_No	sql_variant	NULL	serial number	No	No
AmendDtl_CoreValue	bigint	NULL	core value of the part	No	No
AmendDtl_VarValue	bigint	NULL	amended variable value of the part	No	No
AmendDtl_TotValue	bigint	NULL	total value of part ( ie core value + variable value)	No	No
AmendDtl_Created_By	sql_variant	NULL	created by	No	No
AmendDtl_Created_Date	sql_variant	NULL	created date	No	No
AmendDtl_Updated_By	sql_variant	NULL	updated by	No	No
AmendDtl_Updated_Date	sql_variant	NULL	updated date	No	No

Table Name Smn_MntCore_Core_Dtl

Table Comment used to store the details of main core details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MntCore_OuInstance	int	NOT NULL	Ou Instance	No	No
MntCore_LineNo	int	NULL	line number of the part	No	No
MntCore_ComponentNo	sql_variant	NULL	component Id	No	No
MntCore_Warehouse	sql_variant	NULL	warehouse number	No	No
MntCore_PartNo	sql_variant	NULL	Part Number	No	No
MntCore_Serial_No	sql_variant	NULL	serial number	No	No
MntCore_CoreValue	bigint	NULL	Core value of the part	No	No
MntCore_VarValue	bigint	NULL	variable value of the part	No	No
MntCore_TotValue	bigint	NULL	total value (core + variable) of the part	No	No
MntCore_RemainLife	int	NULL	remaining life time	No	No
MntCore_Status	sql_variant	NULL	core status	No	No
MntCore_AmendNo	int	NULL	latest amendment number	No	No
MntCore_Remarks	sql_variant	NULL	remarks	No	No
MntCore_Created_By	sql_variant	NULL	created by	No	No
MntCore_Created_Date	sql_variant	NULL	created date	No	No
MntCore_Updated_By	sql_variant	NULL	Modified By	No	No
MntCore_Updated_Date	sql_variant	NULL	Modified Date	No	No

Table Name SMN_MNTPOOL_AGT_DTL
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MNTPOOL_OuInstance	int	NULL	This column used for identify the OU.	No	No
MNTPOOL_AgtType	sql_variant	NULL	This column Used to identify the Agreement Type	No	No
MNTPOOL_Category	sql_variant	NULL	This column Used to identify the Pool Category	No	No
MNTPOOL_PartNo	sql_variant	NULL	Used to identify the Part number	No	No
MNTPOOL_LineNo	int	NULL	Used to Identify the Line number (created Automatically)	No	No
MNTPOOL_Item	sql_variant	NULL	Used to identify the Pool Item number	No	No
MNTPOOL_Quantity	bigint	NULL	Used to identify the Pool Quantity	No	No
MNTPOOL_UOM	sql_variant	NULL	Used to identify the UOM	No	No
MNTPOOL_Station	sql_variant	NULL	Used to identify the Station code	No	No
MNTPOOL_NoofParticipant	int	NULL	Used to identify the No.Of participants	No	No
MNTPOOL_PoolCost	bigint	NULL	Used to identify the Pool Cost	No	No
MNTPOOL_Currency	sql_variant	NULL	Used to identify the Currency	No	No
MNTPOOL_FromDate	datetime	NULL	This column is used for From Date.	No	No
MNTPOOL_ToDate	datetime	NULL	This column is used for To Date.	No	No
MNTPOOL_Provider	sql_variant	NULL		No	No
MNTPOOL_Participant	sql_variant	NULL	This column is used for Pool Participant.	No	No
MNTPOOL_Status	sql_variant	NULL	This column used for Pool Status.	No	No
MNTPOOL_AgtRemarks	sql_variant	NULL	This column is used for Agreement Remarks.	No	No
MNTPOOL_Comments	nchar(256)	NULL	This column is used for Pool Comments.	No	No
MNTPOOL_FileName	sql_variant	NULL	This column is used for Pool Filename.	No	No
MNTPOOL_Created_By	sql_variant	NULL	This column used for Created User.	No	No
MNTPOOL_Created_Date	datetime	NULL	This column is used for Created Date.	No	No
MNTPOOL_Updated_By	sql_variant	NULL	This column used for identify Modified User.	No	No
MNTPOOL_Updated_Date	datetime	NULL	This column used for Modified Date.	No	No

Table Name SMN_PART_OWNERSHIP_TRNS_DTL
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMN_OWNTFR_LINENO	int	NOT NULL	Stores the Line no for processing the issued parts	Yes	No
SMN_OWNTRANS_NO	varchar(30)	NOT NULL	Document number for the Ownership Transferred	Yes	No
SMN_OUINSTANCE	bigint	NULL	Stock Maintenance OU instance	No	No
SMN_TRANS_TYPE	varchar(5)	NULL	To store the Transfer Type values, TNR- Transfer No replacement, FE- Flat Exchange, RWC- Retain with customer	No	No
SMN_TRAN_DATE	sql_variant	NULL	Transaction Date	No	No
SMN_TOSTK_STATUS	sql_variant	NULL	To store the Stock Status of the Ownership to be changed	No	No
SMN_CUSTOMER_ID	sql_variant	NULL	Customer Number	No	No
SMN_CUST_ORDERNO	sql_variant	NULL	Customer Order Number	No	No
SMN_TURNIN_DOCTYP	varchar(5)	NULL	To Store the Document Type	No	No
SMN_TURNIN_DOCNO	sql_variant	NULL	Document Number	No	No
SMN_LOCATED_AT	varchar(5)	NULL	To Store the location details, WC- Workcenter, WH- Warehouse	No	No
SMN_LOCATION_NAME	sql_variant	NULL	To Store the details of the Warehouse number, Work Center number	No	No
SMN_PART_TYPE	sql_variant	NULL	To store the part type	No	No
SMN_TURNIN_PARTNO	sql_variant	NULL	To store the part number	No	No
SMN_TURNIN_SERIALNO	sql_variant	NULL	To store the part serial number	No	No
SMN_TURNIN_LOTNO	sql_variant	NULL	To store the part lot number	No	No
SMN_PART_QUANTITY	bigint	NULL	To store the part quantity available in the stock	No	No
SMN_FMSTK_STATUS	sql_variant	NULL	To store the part stock status	No	No
SMN_ISSUE_DOCTYPE	sql_variant	NULL	To store the issue document type	No	No
SMN_ISSUE_DOCNO	sql_variant	NULL	To store the issue document number	No	No
SMN_REPL_PARTNO	sql_variant	NULL	To store the replaced part number	No	No
SMN_REPL_SERIALNO	sql_variant	NULL	To store the replaced part serial number	No	No
SMN_REPL_LOTNO	sql_variant	NULL	To store the replaced part lot number	No	No
SMN_REPL_QTY	bigint	NULL	To store the replaced part Quantity	No	No
SMN_SSC_NO	sql_variant	NULL	To store the stock status conversion number	No	No
SMN_USER_STATUS	sql_variant	NULL	To store the user status	No	No
SMN_REMARKS	sql_variant	NULL	To store the Remarks	No	No
SMN_REFERENCE_NO	sql_variant	NULL	To store the reference number	No	No
SMN_OTHER_DETAILS	sql_variant	NULL	To store the other details	No	No
SMN_VALUATION_OPT	varchar(5)	NULL	To store the valuation option as Zero Value	No	No
SMN_FILE_NAME	sql_variant	NULL	To store the file name	No	No
SMN_CREATED_BY	varchar(30)	NULL	To Store the Created By User	No	No
SMN_CREATED_DATE	datetime	NULL	To store the created date	No	No
SMN_MODIFIED_BY	sql_variant	NULL	To store the modified by user	No	No
SMN_MODIFIED_DATE	datetime	NULL	To store the modified date	No	No

Table Name Smn_PdSpPr_SpecPart_PndDmnd

Table 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
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PdSpPr_Spec_Part_Srl_No	varchar(40)	NULL	Specific Part Serial Number	No	No
PdSpPr_Spec_Part_No	varchar(40)	NULL	Specific Part Number	No	No
PdSpPr_Spec_Part_Ou	varchar(18)	NULL	Specific Part Ouinstance	No	No
PDSPPR_TRADING_PARTNER_Type	sql_variant	NULL	Trading partner type ’CUS’ - Customer ’Sup’ - Supplier	No	No
PDSPPR_TRADING_PARTNER_NO	sql_variant	NULL	Owner Number	No	No
PDSPPR_TRADING_PARTNER_OU	int	NULL	Owner location info.	No	No
PdSpPr_Demand_Type	varchar(5)	NOT NULL	This is the pending demand document type. At present, it will be only "MR"	No	Yes
PdSpPr_Demand_Doc_OU	decimal(10)	NOT NULL	This is the OU where Demand doc is created	No	Yes
PdSpPr_Sub_Line_No	decimal(10)	NOT NULL	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	Yes
PdSpPr_Demand_Doc_No	varchar(40)	NOT NULL	This is the pending demand document no. At present, it will be only MRno	No	Yes
PdSpPr_Line_No	decimal(10)	NOT NULL	This is the line item of the pending demand	No	Yes

Table Name Smn_PgARc_Pegged_Act_Rcpts

Table 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, this coverage information gets linked to the ’Processed Demand’ entity
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PgARc_Demand_Doc_Ou	decimal(10)	NOT NULL	Demand Document Ouinstance	No	No
PgARc_Demand_Type	varchar(18)	NOT NULL	Demand Type	No	No
PgARc_Demand_Doc_No	varchar(18)	NOT NULL	Demand Document Number	No	No
PgARc_Line_No	decimal(10)	NOT NULL	Line Number	No	No
PgARc_Sub_Line_No	decimal(10)	NOT NULL	Sub Line Number	No	No
PgARc_Req_Part_Crt_Ou	decimal(10)	NOT NULL	Requested Part Created Ouinstance	No	No
PgARc_Req_Part_No	varchar(40)	NOT NULL	Requested Part Number	No	No
PgARc_Req_Part_Status	varchar(18)	NOT NULL	Requested Part Status	No	No
PgARc_Alloc_Part_Crt_Ou	decimal(10)	NOT NULL	Allocated Part Created Ouinstance	No	No
PgARc_Alloc_Part_No	varchar(40)	NOT NULL	Allocated Part Number	No	No
PgARc_Alloc_Wh_Ou	decimal(10)	NOT NULL	Allocated Warehouse Ouinstance	No	No
PgARc_Alloc_Wh_Id	varchar(18)	NOT NULL	Allocated Warehouse Id	No	No
PgARc_Act_Rcpt_Doc_Type	varchar(18)	NOT NULL	Actual Receipt Document type This could be PO - Purchase Order or STI - Stock Transfer Issue	No	No
PgARc_Act_Rcpt_Doc_Ou	decimal(10)	NOT NULL	Actual Receipt Document Ouinstance	No	No
PgARc_Act_Rcpt_Doc_No	varchar(18)	NOT NULL	Actual Receipt Document Number	No	No
PgARc_Act_Rcpt_Doc_LineItem	decimal(10)	NOT NULL	Actual Receipt Document Line Item	No	No
PgARc_Act_Rcpt_Qty	decimal(10)	NULL	Actual Receipt Quantity	No	No
PGARC_WORK_CENTER_OU	decimal(10)	NULL	Work center Ou	No	No
PGARC_WORK_CENTER	varchar(40)	NULL	Work Center number	No	No
PGARC_ACT_RCPT_SRL_LINEITEM	decimal(10)	NULL	Serial line number	No	No
PgARc_Act_TRADING_PARTNER_Type	sql_variant	NULL	Trading partner type ’CUS’ - Customer ’Sup’ - Supplier	No	No
PgARc_Act_Trading_Partner_No	sql_variant	NULL	Owner Number\Name	No	No
PgARc_Act_TRADING_PARTNER_OU	int	NULL	Owner location info.	No	No

Table Name Smn_PgFRc_Pegged_Firm_Rcpts

Table 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, this coverage information gets linked to the ’Processed Demand’ entity
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PgFRc_Demand_Doc_Ou	char(18)	NOT NULL	Demand Document Ouinstance	Yes	No
PgFRc_Demand_Type	char(18)	NOT NULL	Demand type	Yes	No
PgFRc_Demand_Doc_No	char(18)	NOT NULL	Demand Document Number	Yes	No
PgFRc_Line_No	char(18)	NOT NULL	Line Number	Yes	No
PgFRc_Sub_Line_No	char(18)	NOT NULL	Sub Line Number	Yes	No
PgFRc_Req_Part_Crt_Ou	char(18)	NOT NULL	Requested Part Created Ouinstance	Yes	No
PgFRc_Req_Part_No	char(18)	NOT NULL	Requested Part Number	Yes	No
PgFRc_Req_Part_Status	char(18)	NOT NULL	Requested Part status	Yes	No
PgFRc_Alloc_Part_Crt_Ou	char(18)	NOT NULL	Allocated part created Ouinstance	Yes	No
PgFRc_Alloc_Part_No	char(18)	NOT NULL	Allocated part number	Yes	No
PgFRc_Alloc_Wh_Ou	char(18)	NOT NULL	Allocated Warehouse Ouinstance	Yes	No
PgFRc_Alloc_Wh_Id	char(18)	NOT NULL	Allocated Warehouse Id	Yes	No
PgFRc_Firm_Rcpt_Doc_Type	char(18)	NULL	Firm Receipt Document Type This could be PO - Purchase Order or STI - Stock Transfer issue	No	No
PgFRc_Firm_Rcpt_Doc_Ou	char(18)	NULL	Firm Receipt Document Ouinstance	No	No
PgFRc_Firm_Rcpt_Doc_No	char(18)	NULL	Firm Receipt Document Number	No	No
PgFRc_Firm_Rcpt_Doc_LineItem	char(18)	NULL	Firm Receipt Document Line Item	No	No
PgFRc_Firm_Rcpt_Qty	char(18)	NULL	Firm Receipt Quantity	No	No
PgFRc_Unpegged_Rcpt_Qty	char(18)	NULL	If the expected firm receipt qty for the MR LineItem get pegged to some other MR, then the quantity that gets unpegged from this MR to a different MR is maintained here.	No	No
PgFRc_ActRcpt_Peg_Status	char(18)	NOT NULL	During GR/STR, if the expected firm receipt qty for the MR LineItem gets pegged to some other MR, then the pegging status could be ’Cancelled’ or ’Partially Cancelled’. NULL indicates that no actual receipt has come against the firm receipt	No	No

Table Name Smn_PgPRc_Pegged_Plan_Rcpts

Table 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, this coverage information gets linked to the ’Processed Demand’ entity
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PgPRc_Demand_Doc_Ou	char(18)	NOT NULL	This will be "Expected" or "Cancelled". When PR or STO is created for the pending demand, it will be ’Expected". When the PR is converted to PO and when the PO is received thru GR and if that GR stock gets pegged to some other MR(s), this would be "Cancelled"	Yes	No
PgPRc_Demand_Type	char(18)	NOT NULL	Demand Type	Yes	No
PgPRc_Demand_Doc_No	char(18)	NOT NULL	Demand Document Number	Yes	No
PgPRc_Line_No	char(18)	NOT NULL	Line Number	Yes	No
PgPRc_Sub_Line_No	char(18)	NOT NULL	Sub Line Number	Yes	No
PgPRc_Req_Part_Crt_Ou	char(18)	NOT NULL	Requested Part Created Ouinstance	Yes	No
PgPRc_Req_Part_No	char(18)	NOT NULL	Requested Part Number	Yes	No
PgPRc_Req_Part_Status	char(18)	NOT NULL	Requested Part Status	Yes	No
PgPRc_Alloc_Part_Crt_Ou	char(18)	NOT NULL	Allocated Part Created Ouinstance	Yes	No
PgPRc_Alloc_Part_No	char(18)	NOT NULL	Allocated Part Number	Yes	No
PgPRc_Alloc_Wh_Ou	char(18)	NOT NULL	Allocated Warehouse Ouinstance	Yes	No
PgPRc_Alloc_Wh_Id	char(18)	NOT NULL	Allocated Warehouse Id	Yes	No
PgPRc_Plan_Rcpt_Doc_Type	char(18)	NULL	Plan Receipt Document Type	No	No
PgPRc_Plan_Rcpt_Doc_Ou	char(18)	NULL	Plan Receipt Document Ouinstance	No	No
PgPRc_Plan_Rcpt_Doc_No	char(18)	NULL	Plan Receipt Document Number	No	No
PgPRc_Plan_Rcpt_Doc_LineItem	char(18)	NULL	Plan Receipt Document line item	No	No

Table Name Smn_PrDmd_Processed_Demands

Table 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 process) is also maintained here. Whenever issue happens to the pending demand, it will be checked whether the entire demand has been processed or not. If it is completely processed, the pending demand entries would be posted as processed demands and these processed entries would be deleted from Pending Tray. If issue is partial, the issued quantity against the pending demand alone would be updated.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
%AttName	int	NOT NULL	part condition	Yes	No
PRDMD_DEMAND_DOC_OU	decimal(10)	NOT NULL	Demanded loc info	No	No
PrDmd_Demand_Type	varchar(20)	NOT NULL	This is the pending demand document type. At present, it will be only "MR"	No	No
PrDmd_Demand_Doc_No	varchar(40)	NOT NULL	This is the pending demand document no. At present, it will be only MRno	No	No
PrDmd_Line_No	decimal(10)	NOT NULL	This is the line item of the pending demand	No	No
PrDmd_Sub_Line_No	decimal(10)	NOT NULL	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	No
PrDmd_Demand_Priority	varchar(5)	NULL	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 Denormalized info	No	No
PrDmd_Req_Loc	decimal(10)	NULL	Requesting location for which the source doc is created	No	No
PrDmd_Req_By	varchar(30)	NULL	Demand is requested by	No	No
PRDMD_WAREHOUSE_OU	decimal(10)	NULL	warehouse location	No	No
%AttName	int	NULL	(ƒ8able Name	No	No
PrDmd_Warehouse_Id	varchar(20)	NULL	Warehouse from where the pending demand needs to be addressed Denormalized info	No	No
PrDmd_AcReg_Ou	decimal(10)	NULL	Aircraft Registration Ouinstance	No	No
PrDmd_AcReg_No	varchar(40)	NULL	Aircraft Registration Number	No	No
PrDmd_Work_Center_Ou	decimal(10)	NULL	WorkCenter location which requires the part Denormalized info	No	No
PrDmd_Work_Center	varchar(30)	NULL	WorkCenter which requires the pending demand parts Denormalized info	No	No
PrDmd_Need_Datetime	datetime	NULL	Need Date as given in the MR or any schedule date as required in the source doc Denormalized info	No	No
PrDmd_Doc_Crt_Datetime		NULL	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	No
PrDmd_Req_Part_Crt_Ou	decimal(10)	NULL	Requested Part Created Ou	No	No
PrDmd_Req_Part_No	varchar(40)	NULL	The main part which is requested in the material demanding document	No	No
PrDmd_Req_Part_Status	varchar(28)	NULL	Requested Part Status	No	No
PrDmd_Req_Qty_InStkUom	decimal(28,8)	NULL	The requested qty of the main part in stock uom	No	No
PRDMD_ALLOC_QTY_INSTKUOM	decimal(28,8)	NULL	Allocated qty in stock UOM	No	No
PrDmd_UnAlloc_Qty_InStkUom	int	NULL	This will be the unallocated MR Quantity for the Demand (MR) LineItem Whenever allocation is partially successful, this will have the remaining qty that needs to be hard allocated.	No	No
PrDmd_TotPlnRcpt_Qty_InStkUom	decimal(28,8)	NULL	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	No
PrDmd_TotFrmRcpt_Qty_InStkUom	decimal(28,8)	NULL	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 has been received and has been plugged to the pending demand line item.	No	No
PrDmd_TotActRcpt_Qty_InStkUom	decimal(28,8)	NULL	This could "GR" or "STR" qty	No	No
PrDmd_Isu_Qty_InStkUom	decimal(28,8)	NULL	This will be the issued qty against the pending demand line item	No	No
PrDmd_Created_By	varchar(30)	NULL	Created by User	No	No
PrDmd_Created_Datetime	datetime	NULL	Created Date	No	No
PRDMD_PART_CONDITION	varchar(5)	NULL	¨€8 condition	No	No
PrDmd_TotSTO_Qty_InStkUOM	decimal(28,8)	NULL	total stock transfer Qty in stock UOM	No	No
PrDmd_TotPR_Qty_InStkUOM	decimal(28,8)	NULL	total purchase Qty in stock UOM	No	No
PrDmd_Iss_FD_Qty_InStkUOM	decimal(28,8)	NULL	total issue Qty in stock UOM	No	No
PrDmd_TrnOrd_Qty_InStkUOM	decimal(28,8)	NULL	total ordered Qty in stock UOM	No	No
PrDmd_TrnIss_Qty_InStkUOM	decimal(28,8)	NULL	total issue Qty in stock UOM	No	No
PrDmd_TrnRec_Qty_InStkUOM	decimal(28,8)	NULL	total receipt Qty in stock UOM	No	No
PrDmd_PurReq_Qty_InStkUOM	decimal(28,8)	NULL	total PR Qty in stock UOM	No	No
PrDmd_PurOrd_Qty_InStkUOM	decimal(28,8)	NULL	total PO Qty in stock UOM	No	No
PrDmd_GDRec_Qty_InStkUOM	decimal(28,8)	NULL	total GR Qty in stock UOM	No	No
PrDmd_TimeStamp	decimal(10)	NULL	time stamp	No	No
PrDmd_LineLvl_Status	varchar(15)	NULL	line level status	No	No

Table Name Smn_PrtCrt_Prt_Crt_History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrtCrt_uniqueid	int	NULL	Unique id for each certificate history.	No	No
PrtCrt_Ouinstance	int	NULL	Created OU Instance	No	No
PrtCrt_controltype	varchar(25)	NULL	Part # control type provided in Part Administration Business component.	No	No
PrtCrt_Partno	varchar(40)	NULL	Part no	No	No
PrtCrt_SerialNo_int	sql_variant	NULL	Internal Generated Serial Number	No	No
PrtCrt_SerialNo_msn	varchar(40)	NULL	Manufacture Serial Number	No	No
PrtCrt_Lotno_int	varchar(18)	NULL	System generated Lot Number	No	No
PrtCrt_Lotno_msn		NULL	Manufacture Lot number	No	No
PrtCrt_RefdocNo	varchar(40)	NULL	Reference document no for certificate information.	No	No
PrtCrt_RefdocType		NULL	Document Type	No	No
PrtCrt_RefdoclineNo	int	NULL	Reference document part detail line number.	No	No
PrtCrt_Remarks	varchar(255)	NULL	Remarks provided during inspection and re-certify	No	No
PrtCrt_CertiNo	varchar(40)	NULL	Certificate number	No	No
PrtCrt_CertiType	varchar(25)	NULL	Certificate Type	No	No
PrtCrt_Certidate	datetime	NULL	Date of Certification	No	No
PrtCrt_Primaryflag	varchar(25)	NULL	Certificate is Primary or not. If Certificate is Primary then ’Y’ other wise ’N’	No	No
PrtCrt_CertiSupNo	varchar(45)	NULL	Certificate Supplier Number	No	No
PrtCrt_Inspectedby	varchar(77)	NULL	Parts Inspected by user id.	No	No
PrtCrt_Inspecteddate	datetime	NULL	Inspected Date	No	No
PrtCrt_Condition	varchar(25)	NULL	Part Condition of part during Inspection.	No	No
PrtCrt_activeflag		NULL	Certificate is Active or Inactive. ’A’ - Active ’I’ - Inactive	No	No
PrtCrt_statusflag		NULL	Document Status If document in fresh then status is ’Inprogress’ for confirmed documents the status is ’Completed’	No	No
PrtCrt_created_by	varchar(30)	NULL	Created by	No	No
PrtCrt_createddate	datetime	NULL	Created Date	No	No
PrtCrt_lastmod_by	varchar(30)	NULL	Modified by	No	No
PrtCrt_lastmod_date	datetime	NULL	Modified Date	No	No
PrtCrt_InspectType	varchar(25)	NULL	Type of inspection.	No	No
PrtCrt_InActiveRemark	varchar(255)	NULL		No	No
PrtCrt_ExpiryDate	datetime	NULL	This column used for Expiry Date.	No	No

Table Name Smn_Prtinsp_Prt_Insp_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
smn_prtinsp_ouinstance	int	NULL	Created Ouinstance	No	No
smn_prtinsp_refdocno	varchar(40)	NULL	Document No	No	No
smn_prtinsp_refdoctype	varchar(25)	NULL	Document Type	No	No
smn_prtinsp_rcptdate	datetime	NULL	Document date	No	No
smn_prtinsp_type	varchar(25)	NULL	Part Type	No	No
smn_prtinsp_partno	varchar(40)	NULL	Part Number	No	No
smn_prtinsp_serialno_int	varchar(40)	NULL	Internal Serial Number	No	No
smn_prtinsp_serialno_msn	varchar(40)	NULL	Manufacturer Serial Number	No	No
smn_prtinsp_lotno_int	varchar(18)	NULL	Internal Lot number	No	No
smn_prtinsp_lotno_msn	varchar(18)	NULL	Manufacturer Lot number	No	No
smn_prtinsp_warehouse	varchar(10)	NULL	Ware House	No	No
smn_prtinsp_zone	varchar(10)	NULL	Zone	No	No
smn_prtinsp_bin	varchar(10)	NULL	Bin	No	No
smn_prtinsp_inspqty	decimal	NULL	Quantity at line level	No	No
smn_prtinsp_uom	varchar(15)	NULL	Unit of Measurement	No	No
smn_prtinsp_stockstatus	varchar(40)	NULL	Stock status as in user defined stock status	No	No
smn_prtinsp_condition	varchar(15)	NULL	Part preferable Condition	No	No
smn_prtinsp_inspstatus	varchar(25)	NULL	Inspection Status	No	No
smn_prtinsp_quanqty	decimal	NULL	Quarantine Quantity	No	No
smn_prtinsp_docstatus	varchar(25)	NULL	Document status	No	No
smn_prtinsp_reason_code	varchar(25)	NULL	Inspection Reason Code	No	No
smn_prtinsp_inspdetails	varchar(2000)	NULL	Inspection Details	No	No
smn_prtinsp_SOSdisp	varchar(40)	NULL	SOS Disposition Description	No	No
smn_prtinsp_CRNo	varchar(40)	NULL	Component Replacement No	No	No
smn_prtinsp_filename	varchar(50)	NULL	Attached file Name	No	No
smn_prtinsp_refdoclineno	int	NULL	Document Part Detail Line number	No	No
smn_prtinsp_inspby	varchar(30)	NULL	Inspected By	No	No
smn_prtinsp_inspdate	datetime	NULL	Inspection Date	No	No
smn_prtinsp_Cert_Uniqueid	int	NULL	Unique id for Certificate details.	No	No
smn_prtinsp_AcceptedQty	numeric(13)	NULL	column to store the accepted quantity	No	No
smn_prtinsp_RejectedQty	numeric(13)	NULL	Column to store RejectedQty	No	No
smn_prtinsp_RsnFrRejection	varchar(25)	NULL	Column to store the reason for rejection	No	No

Table Name Smn_RtnVal_Valuation_Policy

Table Comment used to store the valuation details..
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RtnVal_Ouinstance	int	NOT NULL	Stock Maintenance Created OUInstance	Yes	No
RtnVal_Seqno	int	NOT NULL	Sequence No to maintain the Uniqueness	Yes	No
RtnVal_ExpenseBasis	sql_variant	NULL	This field holds the Expense Basis	No	No
RtnVal_RtnBasis	sql_variant	NULL	This field holds the return basis	No	No
RtnVal_RtnCls	sql_variant	NULL	This field holds the user defined Return Classification	No	No
RtnVal_RtnValuation	sql_variant	NULL	This fields holds the Issue Cost(IC), Valuation Method (VM) and Zero Cost(ZC)	No	No

Table Name Smn_ScrDt_StdCostReval_Dtl

Table Comment used to store the standard cost details...
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ScrDt_Scr_OUInstance	decimal(10)	NOT NULL	Stock Maintenance Ou Instance	Yes	Yes
ScrDt_Scr_No	varchar(40)	NOT NULL	A unique number generated for a Standard Cost Revaluation Document	Yes	Yes
ScrDt_Part_Crt_ou	decimal(10)	NOT NULL	Part Created Ou	Yes	No
ScrDt_Part_No	varchar(40)	NOT NULL	Part no for which the std cost is getting changed	Yes	No
ScrDt_New_Std_Cost	numeric(28,8)	NULL	Revised std cost of the part	No	No
ScrDt_Old_Std_Cost	numeric(28,8)	NULL	This will be standard cost of the part before standard cost revaluation. This will be updated when the SCR doc is authorized	No	No
ScrDt_Remarks	varchar(255)	NULL	Remarks (if any)	No	No
ScrDt_Acc_Usage	varchar(20)	NULL	Account Usage	No	No
ScrDt_Fin_Book	varchar(20)	NULL	Finance Book	No	No
ScrDt_Acc_Code	varchar(32)	NULL	Account Code	No	No
ScrDt_Anly_Code	varchar(32)	NULL	Analysis Code	No	No
ScrDt_SubAnly_Code	varchar(32)	NULL	Sub Analysis Code	No	No
Scrdt_Cc_Usage	varchar(20)	NULL	Cost Center Usage	No	No
Scrdt_Costcenter_Code	varchar(10)	NULL	Cost Center Code	No	No

Table Name Smn_ScrMn_StdCostReval_Hdr

Table Comment used to store the standard cost details...
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ScrMn_Scr_OUInstance	decimal(10)	NOT NULL	Stock Maintenance Ou Instance	Yes	No
ScrMn_Scr_No	varchar(40)	NOT NULL	A unique number generated for a Standard Cost Revaluation Document	Yes	No
ScrMn_Scr_Status	varchar(5)	NULL	Status of the SCR Document D - Draft F - Fresh CO - Authorized CA - Cancelled	No	No
ScrMn_User_Status	varchar(25)	NULL	User status for an SCR document	No	No
ScrMn_Ref_Doc	varchar(40)	NULL	Reference document (if any) for doing the standard cost revaluation	No	No
ScrMn_Reval_Cat	varchar(25)	NULL	Revaluation Category	No	No
ScrMn_Reval_Date	datetime	NULL	Revaluation Date	No	No
ScrMn_User_Def_1	varchar(25)	NULL	User Defined data - 1	No	No
ScrMn_User_Def_2	varchar(25)	NULL	User Defined data - 2	No	No
ScrMn_FileName	varchar(50)	NULL	Filename of the attached file which have more details on the SCR document	No	No
ScrMn_Comments	varchar(255)	NULL	Comments for the SCR document (if any)	No	No
ScrMn_Auth_By	varchar(30)	NULL	Authorized by User Name	No	No
ScrMn_Auth_Datetime	datetime	NULL	Authorized date time	No	No
ScrMn_Acc_Usage	varchar(20)	NULL	Account usage	No	No
ScrMn_Created_Datetime	datetime	NULL	Date on which the SCR document got created	No	No
ScrMn_Modified_Datetime	datetime	NULL	Date on which SCR doc got modified	No	No
ScrMn_Created_By	varchar(30)	NULL	User Name - by whom the document got created.	No	No
ScrMn_Modified_By	varchar(30)	NULL	User Name - by whom the document got modified.	No	No
ScrMn_TimeStamp	decimal(10)	NULL	Number of times the Standard Cost Reevaluation Document has got modified.	No	No
Scrmn_Cc_Usage	varchar(20)	NULL	Cost center Usage	No	No

Table Name SMN_SHELFLIFE_EXPDATE_UPD_HIS

Table Comment history of self life parts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMN_PARTNO	varchar(40)	NOT NULL	Part Number	No	No
SMN_SERIALNO	varchar(40)	NOT NULL	serial number	No	No
SMN_OLDEXPDATE	datetime	NULL	previous expiry date	No	No
SMN_NEWEXPDATE	datetime	NULL	new expiry date	No	No
SMN_TIMEUOM	varchar(5)	NULL	Uom of the part	No	No
SMN_SHELFLIFE	decimal(28,8)	NULL	Shelf life of that part	No	No
SMN_REMARKS	varchar(255)	NULL	remarks	No	No
SMN_MODIFIEDBY	varchar(30)	NULL	Modified By	No	No
SMN_MODIFIEDDATE	datetime	NULL	Modified Date	No	No

Table Name Smn_ShelLifeUpd_Dtl

Table Comment Table used to store the history of shelf life update for part
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ShelLifeUpd_Part_No	sql_variant	NOT NULL	Part No	Yes	No
ShelLifeUpd_Part_Srl_No	sql_variant	NOT NULL	Part Serial No	Yes	No
ShelLifeUpd_Warehouse	sql_variant	NOT NULL	Warehouse no	Yes	No
ShelLifeUpd_LotNo	sql_variant	NOT NULL	Lot No	Yes	No
ShelLifeUpd_Renewal_Count	int	NOT NULL	Shelf Life renewal count	Yes	No
ShelLifeUpd_OUInstance	int	NOT NULL	Created OU Instance	No	No
ShelLifeUpd_Part_OU	int	NOT NULL	OUInstance of the part	No	No
ShelLifeUpd_Warehouse_OU	int	NOT NULL	OU Instance of the warehouse no	No	No
ShelLifeUpd_NewExp_Date	sql_variant	NOT NULL	New Expiry Date	No	No
ShelLifeUpd_OldExp_Date	sql_variant	NOT NULL	Old Expiry Date	No	No
ShelLifeUpd_Remarks	sql_variant	NOT NULL	Remarks during shelf life update	No	No
ShelLifeUpd_Reset_Date	sql_variant	NOT NULL	Shelf life reset date	No	No
ShelLifeUpd_Ref_DocId	sql_variant	NULL	Reference Document ID	No	No
ShelLifeUpd_Ref_DocType	sql_variant	NULL	Reference Document type. To indicate from where shelf life is updated	No	No
ShelLifeUpd_CreatedBy	sql_variant	NOT NULL	Created by	No	No
ShelLifeUpd_CreatedDate	sql_variant	NOT NULL	Created Date	No	No
ShelLifeUpd_Modifiedby	sql_variant	NOT NULL	Modified by	No	No
ShelLifeUpd_ModifiedDate	sql_variant	NOT NULL	Modified Date	No	No
ShelLifeUpd_TimeStamp	bigint	NOT NULL	Time stamp	No	No

Table Name Smn_SmnAtt_Srl_Part_Attrib

Table Comment For the Stock Maintained, this entity contains the attribute details for a serial controlled part
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnAtt_Src_OUInstance	decimal(10)	NOT NULL	Source OUInstance of the Stock Maint component where the serial controlled part is stored.	Yes	No
SmnAtt_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created Ou	Yes	No
SmnAtt_Part_No	varchar(40)	NOT NULL	Part No for which the attributes are defined.	Yes	No
SmnAtt_Serial_No	varchar(40)	NOT NULL	Part Serial No	Yes	No
SmnAtt_Attribute_No	varchar(18)	NOT NULL	Attribute code of the part	Yes	No
SmnAtt_Qual_Value	varchar(80)	NULL	Qualitative Value of the attribute for the part	No	No
SmnAtt_Quan_Value	numeric(28,8)	NULL	Quantitative Value of the attribute for the part	No	No
SmnAtt_Remarks	varchar(225)	NULL	Remarks (if any)	No	No

Table Name Smn_SmnDA_Doc_Attach_Dtl

Table Comment Used to store the reference douments attached to it
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnDA_Doc_Id	varchar(40)	NOT NULL	Document Id	Yes	No
SmnDA_Source_Flag	varchar(5)	NOT NULL	Source Flag will be as follows 1) OpBal for ’Opening Balance’ 2) SCR for ’Standard Cost Revaluation’ 3) SCOR for ’Stock Correction’	Yes	No
SmnDA_Source_Doc_Ou	decimal(10)	NOT NULL	Opening balance or SCR or Stock correction document’s OU	Yes	No
SmnDA_Source_Doc_No	varchar(40)	NOT NULL	Opening balance or SCR or Stock correction document	Yes	No
SmnDA_Ref_Doc_Type	varchar(15)	NOT NULL	Reference Document Type	Yes	No
SmnDA_File_Name	varchar(50)	NULL	Reference File Name	No	No
SmnDA_Remarks	varchar(225)	NULL	Remarks (if any)	No	No

Table Name Smn_SmnDmn_WhLvlDeamon_info

Table Comment This table stores the Daemon Initiated Datetime and the warehouse transaction 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 warehouses which have stock till that datetime are taken and their receipts and issues are read datewise and maintained separately. Let’s say, for a warehouse ’WH1’, first transaction entry has been made on 2nd Jan and the last transaction has been made on 6th Jan, an entry will be put in this table as follows: Daemon_Start_Datetime - 10th Jan 03 10 pm Warehouse - WH1 FromDate - 2nd Jan 03 ToDate - 6th Jan 03 NOTE that From and To Date implies the transactions that were covered in the current Daemon run for the warehouse. Let’s say, daemon is executed nextime on 15th Jan 03 10pm. Those transactions which happened from 10th Jan 03 to 15th Jan 03 ARE NOT TAKEN. Rather warehouse level transactions are read from the last Wh level processed date till 15th. For ’Wh1’, the last covered transaction date by the daemon is 6th Jan 03. And let’s say that for the warehouse ’WH1’, after 6th Jan 03 till 15th Jan 03, transactions are made on 8th Jan 03, 9th Jan and 13th Jan. Following entry will be added to the table &nbspDaemon_Start_Datetime - 15th Jan 03 10 pm Warehouse - WH1 FromDate - 8th Jan 03 ToDate - 13th Jan 03 All the transactions happened at a warehouse from the last processed transaction till the Daemon Initiated Date are taken. In this range, the first date on which a transaction was performed in the warehouse is taken as ’From Date’ and the last transaction date is taken as ’To Date’. For the daemon processed duration, if any new backdated transactions (let’s say for 9th Jan 03) which is already covered by the Daemon gets entered for the warehouse, then this table would be deleted and/or updated to indicate that next daemon should repeat all the process from the 9th Jan 03 for the warehouse. Note that all issues and receipts extracted for the WAREHOUSE (not Wh-Part) after the date (in the e.g. above, it is 9th Jan 03) would be deleted
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnDmn_Src_OUInstance	decimal(10)	NOT NULL	Source OuInstance of the StkMaint	No	No
SmnDmn_Wh_Ou	decimal(10)	NOT NULL	Warehouse OuInstance	No	No
SmnDmn_Wh_Id	varchar(10)	NOT NULL	Warehouse ID	No	No
SmnDmn_From_Date	datetime	NOT NULL	The min transaction date in the warehouse during the execution of daemon service. For detailed notes, go thru the Entity Description	No	No
SmnDmn_To_Datetime	datetime	NOT NULL		No	No
SmnDmn_IssRcpt_Flag	varchar(5)	NULL	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 this column. Following Values are stored RCPT - Receipt ISU - Issue NULL This flag will be reset to NULL everytime when the Daemon service is run freshly.	No	No
SmnDmn_Dmn_Start_Datetime	datetime	NULL	Daemon Service Initiated/Started Date time	No	No
SmnDmn_LastUpd_Doc_Type	varchar(10)	NULL	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 Following Values are the possible value stored in this field. NOTE that this field has to be read along with IssRcpt_Flag. GNISU - &nbspGeneral Issue MNISU - &nbspMaint Issue RO - &nbspRO Issue ST - &nbspStock Transfer Issue/Rcpt (To be &nbspinterpreted based on IssRcpt Flag) UPISU - Unplanned Issue SSC - Stock Status Conversion (Old &nbspStatus/New Stats- to be &nbspinterpreted based on IssRcpt Flag) OPBAL - &nbspOpenning Balance UPR - &nbspUnplanned Receipt GEN - &nbspGeneral Return (GEN) UPL - &nbspUnplanned Return MNT - &nbspMaintenance Return GR - &nbspGoods Receipt NULL This column will be reset to NULL everytime when the Daemon service is run freshly.	No	No
SmnDmn_LastUpd_Doc_Ou	decimal(10)	NULL	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 everytime when the Daemon service is run freshly.	No	No
SmnDmn_LastUpd_Doc_No	varchar(40)	NULL	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 reset to NULL everytime when the Daemon service is run freshly.	No	No

Table Name Smn_SmnDtIsu_Datewise_Issue

Table 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 table will store other documents which result in negativating the stock level.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnDtIsu_Wh_Ou	decimal(9)	NOT NULL	Warehouse Location	No	No
SmnDtIsu_SrcDoc_Type	varchar(10)	NOT NULL	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	No
SmnDtIsu_SrcDoc_Ou	decimal(10)	NOT NULL	Issue or SSC Doc Ou	No	No
SmnDtIsu_SrcDoc_No	varchar(40)	NOT NULL	Issue or SSC Doc No	No	No
SmnDtIsu_Isu_QtyInStkUom	numeric(28,8)	NULL	Issued Qty in Stock Uom (De-normalized field]	No	No
SmnDtIsu_Isu_Value	numeric(28,8)	NULL	Issue value at stock uom (De-normalized field]	No	No
SMNDTISU_DATETIME	datetime	NULL		No	No
SMNDTISU_MAT_TYPE	sql_variant	NULL	Material Type of the part	No	No
SMNDTISU_ISSUE_BASIS	varchar(5)	NULL	Issue basis of the part	No	No
SMNDTISU_RET_BASIS	varchar(5)	NULL	Return basis of the part	No	No
SMNDTISU_SRC_OUINSTANCE	char(18)	NULL	OU where the Issue created.	No	No
SMNDTISU_PART_CRT_OU	char(18)	NULL	Part created OU	No	No
SMNDTISU_PART_NO	char(18)	NULL	Part Number	No	No
SMNDTISU_PART_STATUS	char(18)	NULL	Part status	No	No
SMNDTISU_DATE	char(18)	NULL	Issue Date	No	No
SMNDTISU_WH_ID	varchar(10)	NULL	WareHouse id from which the part issued.	No	No

Table Name Smn_SmnDtRcpt_Datewise_Rcpt

Table Comment This table stores all datewise receipt (all receipts - Return, Stock Trnsfer, Receipt, GR, OpBal, etc) &nbspmade for all type of parts.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnDtRcpt_SrcDoc_Type	varchar(10)	NOT NULL	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 Return (GEN) 5) Unplanned Return (UPL) 6) Maintenance Return (MNT) 7) Goods Receipt (GR) 8) Stock Status Conversion [NewStatus) (SSC) 9) STCOR - Stock Correction	No	No
SmnDtRcpt_SrcDoc_Ou	decimal(10)	NOT NULL	Receipt or Return or any other doc type tran location id	No	No
SmnDtRcpt_SrcDoc_No	varchar(40)	NOT NULL	Receipt or Return or any other doc type tran ’Document No’	No	No
SmnDtRcpt_Rcpt_QtyInStkUom	numeric(28,8)	NULL	Received Qty in Stock Uom of the part	No	No
SmnDtRcpt_Rcpt_Value	numeric(28,8)	NULL	Receipt Value for the qty received	No	No
SMNDTRCPT_DATETIME	datetime	NULL	Holds the date and time of the document got created	No	No
SMNDTRCPT_RCPT_MAT_TYPE	sql_variant	NULL	Material type of the part	No	No
SMNDTRCPT_RCPT_RET_BASIS	sql_variant	NULL	Return basis of the of part at the time of issue	No	No
SMNDTRCPT_RCPT_ISSUE_BASIS	varchar(5)	NULL	Issue basis of the part	No	No
SMNDTRCPT_SRC_OUINSTANCE	int	NULL		No	No
SMNDTRCPT_WH_OU	int	NULL		No	No
SMNDTRCPT_WH_ID	sql_variant	NULL		No	No
SMNDTRCPT_PART_CRT_OU	char(18)	NULL		No	No
SMNDTRCPT_PART_NO	char(18)	NULL		No	No
SMNDTRCPT_PART_STATUS	char(18)	NULL		No	No
SMNDTRCPT_DATE	char(18)	NULL		No	No

Table Name Smn_SmnHD_Doc_Hard_Alloc_Dtl

Table Comment For the stock maintained, there could be zero or more hard allocation details for a non disposition part.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnHD_smn_ouinstance	decimal(10)	NOT NULL	Stock Maintenance Ou Instance	Yes	No
SmnHD_warehouse_ouinstance	decimal(10)	NOT NULL	Warehouse Ou	Yes	No
SmnHD_warehouse_id	varchar(10)	NOT NULL	Warehouse Id	Yes	No
SmnHD_zone_id	varchar(10)	NOT NULL	Zone Id	Yes	No
SmnHD_bin_id	varchar(10)	NOT NULL	Bin Id	Yes	No
SmnHD_part_crt_ou	decimal(10)	NOT NULL	Part Created OuInstance	Yes	No
SmnHD_part_pln_ou	decimal(10)	NOT NULL	Part Planning Ou	Yes	No
SmnHD_part_no	varchar(40)	NOT NULL	Part No	Yes	No
SmnHD_part_status	varchar(40)	NOT NULL	Can take any value as defined in UDSS which are stockable	Yes	No
SmnHD_serial_no	varchar(40)	NOT NULL	Serial No for which hard allocation is done	Yes	No
SmnHD_lot_no	varchar(18)	NOT NULL	Lot No for which hard allocation is done	Yes	No
SmnHD_Doc_Ou	decimal(10)	NOT NULL	This indicates the ou of the hard allocated document.(Mr Ou or Work order Ou)	Yes	No
SmnHD_Doc_Type	varchar(5)	NOT NULL	This indicates the hard allocated document type. It will be ’MR’ for ’Material Request’ It will be ’Cwo’ for ’Component WorkOrder’’	Yes	No
SmnHD_Doc_No	varchar(40)	NOT NULL	This will be the MR No or workorder No	Yes	No
SmnHD_Doc_Line_No	decimal(10)	NOT NULL	The line no for the Part in the source document	Yes	No
SmnHD_Alloc_Order_No	decimal(10)	NOT NULL	Order in which the allocation is done	Yes	No
SmnHD_Doc_Sub_Line_No	decimal(10)	NOT NULL	The sub line no (if any) for the Part in the source document. This will be 0 if no sub line no exists.	No	No
SmnHD_Created_By	varchar(30)	NOT NULL	Created User Name	No	No
SmnHD_Created_Datetime	datetime	NOT NULL	Created Date	No	No
SmnHD_Modified_By	varchar(30)	NOT NULL	Last Modified User Name	No	No
SmnHD_Modified_Datetime	datetime	NOT NULL	Last Modified Date	No	No
SmnHD_Hard_Alloc_Qty	numeric(28,8)	NULL	This will be the hard allocated quantity for the Source Document - Line No	No	No
Smnhd_ownership	char(18)	NULL	Say’s whether internal part or external part	No	No
SMNHD_Trading_Parter_Type	sql_variant	NULL	Trading partner type ’CUS’ - Customer ’Sup’ - Supplier	No	No
SMNHD_Trading_Partner_No	sql_variant	NULL	Owner Number\Name	No	No
smnhd_owningagency	char(18)	NULL		No	No
smnhd_OWNINGAGENCY_OU	int	NULL	Owner location info.	No	No
SMNHD_Trading_Partner_OU	int	NULL		No	No

Table Name Smn_Smnhpd_Pending_Demands

Table 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 process) is also maintained here. Whenever issue happens to the pending demand, it will be checked whether the entire demand has been processed or not. If it is completely processed, the pending demand entries would be posted as processed demands and these processed entries would be deleted from Pending Tray. If issue is partial, the issued quantity against the pending demand alone would be updated.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Smnhpd_Demand_Doc_OU	decimal(10)	NOT NULL	This is the OU where Demand doc is created	Yes	No
Smnhpd_Demand_Type	varchar(5)	NOT NULL	This is the pending demand document type. At present, it will be only "MR"	Yes	No
Smnhpd_Demand_Doc_No	varchar(40)	NOT NULL	This is the pending demand document no. At present, it will be only MRno	Yes	No
Smnhpd_Line_No	decimal(10)	NOT NULL	This is the line item of the pending demand	Yes	No
Smnhpd_Sub_Line_No	decimal(10)	NOT NULL	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	No
Smnhpd_Demand_Priority	varchar(5)	NULL	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 Denormalized info	No	No
Smnhpd_Req_Loc	decimal(10)	NULL	Requesting location for which the source doc is created	No	No
Smnhpd_Req_By	varchar(30)	NULL	Demand is requested by	No	No
Smnhpd_Warehouse_Ou	decimal(10)	NULL	Warehouse location from where the pending demand needs to be addressed Denormalized info	No	No
Smnhpd_Warehouse_Id	varchar(10)	NULL	Warehouse from where the pending demand needs to be addressed Denormalized info	No	No
Smnhpd_AcReg_Ou	decimal(10)	NULL	Aircraft Registration Ouinstance	No	No
Smnhpd_AcReg_No	varchar(40)	NULL	Aircraft Registration Number	No	No
Smnhpd_Work_Center_Ou	decimal(10)	NULL	WorkCenter location which requires the part Denormalized info	No	No
Smnhpd_Work_Center	varchar(30)	NULL	WorkCenter which requires the pending demand parts Denormalized info	No	No
Smnhpd_Need_Datetime	datetime	NULL	Need Date as given in the MR or any schedule date as required in the source doc Denormalized info	No	No
Smnhpd_Doc_Crt_Datetime	datetime	NULL	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	No
Smnhpd_Req_Part_Crt_Ou	decimal(10)	NULL	Requested Part Created Ou	No	No
Smnhpd_Req_Part_No	varchar(40)	NULL	The main part which is requested in the material demanding document	No	No
Smnhpd_Req_Part_Status	varchar(40)	NULL	Requested Part Status	No	No
Smnhpd_Req_Qty_InStkUom	decimal(28,8)	NULL	The requested qty of the main part in stock uom	No	No
Smnhpd_Alloc_Qty_InStkUom	decimal(28,8)	NULL	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 Qty - (HardAllocated Qty + &nbspIssuedQuantity)	No	No
Smnhpd_TotPlnRcpt_Qty_InStkUom	decimal(28,8)	NULL	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	No
Smnhpd_TotFrmRcpt_Qty_InStkUom	decimal(28,8)	NULL	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 has been received and has been plugged to the pending demand line item.	No	No
Smnhpd_TotActRcpt_Qty_InStkUom	decimal(28,8)	NULL	This could "GR" or "STR" qty	No	No
Smnhpd_Isu_Qty_InStkUom	decimal(28,8)	NULL	This will be the issued qty against the pending demand line item	No	No
Smnhpd_AltPart_Flag	varchar(25)	NULL	Alternate Part Flag	No	No
Smnhpd_AltPart_Ou	decimal(10)	NULL	Alternate Part Ouinstance	No	No
Smnhpd_AltPart_No	varchar(40)	NULL	Alternate Part Number	No	No
Smnhpd_Modified_By	varchar(30)	NULL	Modified by User	No	No
Smnhpd_Modified_Datetime	datetime	NULL	Modified Date	No	No
SMNHPD_ACC_USAGE	varchar(20)	NULL	usage id for account code...	No	No
SMNHPD_CC_USAGE	varchar(20)	NULL	usage id for cost center...	No	No
SMNHPD_TASK_OU	decimal(10)	NULL	Ou instance	No	No
SMNHPD_TASK_NO	varchar(40)	NULL	task number	No	No
SMNHPD_TASK_KEYSEQNO	decimal(10)	NULL	sequence number	No	No
SMNHPD_FIN_BOOK	varchar(20)	NULL	finance book id	No	No
SMNHPD_ACC_CODE	varchar(32)	NULL	account code for the current document	No	No
SMNHPD_ANLY_CODE	varchar(5)	NULL	analysis code..	No	No
SMNHPD_SUBANLY_CODE	varchar(5)	NULL	sub analysis code...	No	No
SMNHPD_COSTCENTER_CODE	varchar(10)	NULL	cost center for account code	No	No
SMNHPD_PART_CONDITION	varchar(5)	NULL	part condition	No	No
SMNHPD_PRIMEPARTNO	varchar(40)	NULL	prime part number	No	No
Smnhpd_ownership	char(18)	NULL	Trading partner type ’CUS’ - Customer ’Sup’ - Supplier	No	No
Smnhpd_Trading_Parter_Type	sql_variant	NULL		No	No
Smnhpd_Trading_Partner_No	sql_variant	NULL	Owner Number\Name	No	No
smnhpd_owningagency	char(18)	NULL		No	No
smnhpd_OWNINGAGENCY_OU	int	NULL	Owner location info.	No	No
Smnhpd_Trading_Partner_OU	int	NULL		No	No
SMNHPD_TOTSTO_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of stock transfer in stock uom	No	No
SMNHPD_TOTPR_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of PR in stock uom	No	No
SMNHPD_ISS_FD_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of stock issue in stock uom	No	No
SMNHPD_TRNORD_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of Order qty in stock uom	No	No
SMNHPD_TRNISS_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of stock issue in stock uom	No	No
SMNHPD_TRNREC_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of stock receipt in stock uom	No	No
SMNHPD_PURREQ_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of PR in stock uom	No	No
SMNHPD_PURORD_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of Pur order in stock uom	No	No
SMNHPD_GDREC_QTY_INSTKUOM	decimal(28,8)	NULL	Total quantity of Gr in stock uom	No	No
SmnHpd_TimeStamp	decimal(10)	NULL	time stamp	No	No
SMNHPD_PROCESSING_STATUS	sql_variant	NULL	To capture the processing status entered in the plan material	No	No
SMNHPD_NEW_PART	sql_variant	NULL	Column for indicating whether the part is a new part or not	No	No

Table Name SMN_SMNINQDTL_DRILLDOWN_DTL

Table Comment used to stoe the Drilldown table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNINQDTL_DOCUMENT_OU	decimal(10)	NULL	Document Ou	No	No
SMNINQDTL_DOCUMENT_NO	varchar(40)	NULL	Document No	No	No
SMNINQDTL_DOCUMENT_FLAG	varchar(25)	NULL	Document flag	No	No
SMNINQDTL_DOCUMENT_FLG_TYPE	varchar(25)	NULL	Document flag type	No	No
SMNINQDTL_DOCUMENT_LINE_NO	decimal(10)	NULL	line number	No	No
SMNINQDTL_DOCUMENT_TYPE	varchar(25)	NULL	Document type	No	No
SMNINQDTL_DOCUMENT_DATE	datetime	NULL	document create date	No	No
SMNINQDTL_DOCUMENT_STATUS	varchar(25)	NULL	document status	No	No
SMNINQDTL_DOCUMENT_CNFM_DATE	datetime	NULL	document conformed status	No	No
SMNINQDTL_PART_OU	decimal(10)	NULL	part ou	No	No
SMNINQDTL_PART_NUMBER	varchar(40)	NULL	part number	No	No
SMNINQDTL_PART_STATUS		NULL	part status	No	No
SMNINQDTL_SUPPLIER_OU	decimal(10)	NULL	supplier ou	No	No
SMNINQDTL_SUPPLIER_NUMBER	varchar(45)	NULL	supplier number	No	No
SMNINQDTL_CUST_CREATED_OU	decimal(10)	NULL	customer created ou	No	No
SMNINQDTL_CUST_CODE	varchar(40)	NULL	customer code	No	No
SMNINQDTL_MR_CLASS	varchar(5)	NULL	Material class	No	No
SMNINQDTL_MR_PRIORITY	varchar(20)	NULL	MR priority	No	No
SMNINQDTL_NEED_DATE	datetime	NULL	Need date	No	No
SMNINQDTL_MR_TYPE	varchar(5)	NULL	MR type	No	No
SMNINQDTL_REFDOC_OU	decimal(10)	NULL	ref document type	No	No
SMNINQDTL_REFDOC_NO	varchar(40)	NULL	ref document number	No	No
SMNINQDTL_REFDOC_TYPE	varchar(25)	NULL	ref document type	No	No
SMNINQDTL_REF_DOC_LINE_NO	decimal(10)	NULL	document line number	No	No
SMNINQDTL_REFDOC_DATE	datetime	NULL	ref document date	No	No
SMNINQDTL_REFDOC_STATUS	varchar(25)	NULL	ref document status	No	No
SMNINQDTL_AIRCRAFT_OU	decimal(10)	NULL	aircraft location	No	No
SMNINQDTL_AIRCRAFT_REG_NO	varchar(30)	NULL	aircraft register number	No	No
SMNINQDTL_COMPONENT_OU	decimal(10)	NULL	component ou	No	No
SMNINQDTL_COMPONENT_ID	varchar(90)	NULL	component Id	No	No
SMNINQDTL_FROM_WH_OU	decimal(10)	NULL	from warehouse location	No	No
SMNINQDTL_FROM_WAREHOUSE	varchar(10)	NULL	from warehouse number	No	No
SMNINQDTL_TO_WH_OU	decimal(10)	NULL	to warehouse location	No	No
SMNINQDTL_TO_WAREHOUSE	varchar(10)	NULL	to warehouse number	No	No
SMNINQDTL_ZONE_ID	varchar(10)	NULL	zone number	No	No
SMNINQDTL_BIN_ID	varchar(10)	NULL	bin number	No	No
SMNINQDTL_SERIAL_NO	varchar(40)	NULL	serial number	No	No
SMNINQDTL_LOT_NO	varchar(18)	NULL	lot number	No	No
SMNINQDTL_PART_CONDITION	varchar(5)	NULL	part condition	No	No
SMNINQDTL_SCHEDULE_DATE	datetime	NULL	scheduled date	No	No
SMNINQDTL_PEND_RETURN_QTY	decimal(28,8)	NULL	pending return quantity	No	No
SMNINQDTL_MATL_INQ_FLAG	varchar(25)	NULL	material information flag	No	No
SMNINQDTL_ACCT_TYPE	varchar(40)	NULL	account type	No	No
SMNINQDTL_ACCT_CODE	varchar(32)	NULL	account code	No	No
SMNINQDTL_TRAN_QTY	decimal(28,8)	NULL	transfer quantity	No	No
SMNINQDTL_TRAN_VALUE	decimal(28,8)	NULL	transfer value	No	No
SMNINQDTL_SQUARE_OFF_QTY	decimal(28,8)	NULL	square off quantity	No	No
SMNINQDTL_SQUARE_OFF_VALUE	decimal(28,8)	NULL	square off value	No	No
SMNINQDTL_BALANCE_QTY	decimal(28,8)	NULL	balance quantity	No	No
SMNINQDTL_BALANCE_VALUE	decimal(28,8)	NULL	balance value	No	No
SMNINQDTL_SQUARE_OFF_DOC_OU	decimal(10)	NULL	square off document ou	No	No
SMNINQDTL_SQUARE_OFF_DOC_NO	varchar(40)	NULL	square off document number	No	No
SMNINQDTL_SQUARE_OFF_DOC_LNNO	decimal(10)	NULL	square off document line number	No	No
SMNINQDTL_SQUARE_OFF_PARTOU	decimal(10)	NULL	square off document part ou	No	No
SMNINQDTL_SQUARE_OFF_PARTNO	varchar(40)	NULL	square off document part no	No	No
SMNINQDTL_SQUARE_OFF_PART_STS		NULL	square off document part status	No	No
SMNINQDTL_CREATED_BY	varchar(30)	NULL	created by	No	No
SMNINQDTL_CREATED_DATE	datetime	NULL	created date	No	No
SMNINQDTL_MODIFIED_BY	varchar(30)	NULL	modified by	No	No
SMNINQDTL_MODIFIED_DATE	datetime	NULL	modified date	No	No
SMNINQDTL_WORKCENTER_OU	decimal(10)	NULL	work center ou	No	No
SMNINQDTL_WORKCENTER_NO	varchar(40)	NULL	work center number	No	No
SMNINQDTL_SQUARE_OFF_DATE	datetime	NULL	squared off date	No	No

Table Name SMN_SMNINQRTNDTL_DRILLDOWN_DTL

Table Comment used to stoe the Drilldown table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNINQRTNDTL_DOCUMENT_OU	decimal(10)	NOT NULL	document ou	No	No
SMNINQRTNDTL_DOCUMENT_NO	sql_variant	NOT NULL	document number	No	No
SMNINQRTNDTL_DOCUMENT_DATE	datetime	NULL	document created date	No	No
SMNINQRTNDTL_REFDOCUMENT_OU	decimal(10)	NOT NULL	ref document ou	No	No
SMNINQRTNDTL_REFDOCUMENT_NO	sql_variant	NULL	ref document number	No	No
SMNINQRTNDTL_WH_ID	sql_variant	NULL	warehouse id	No	No
SMNINQRTNDTL_ZONE_ID	sql_variant	NULL	zone number	No	No
SMNINQRTNDTL_BIN_ID	sql_variant	NULL	bin number	No	No
SMNINQRTNDTL_PARTNO	sql_variant	NOT NULL	part number	No	No
SMNINQRTNDTL_PARTSTATUS	sql_variant	NOT NULL	part status	No	No
SMNINQRTNDTL_LINE_NO	int	NOT NULL	Line number	No	No
SMNINQRTNDTL_SUB_LINE_NO	int	NOT NULL	Sub Line number	No	No
SMNINQRTNDTL_SRL_NO	sql_variant	NULL	Serial number	No	No
SMNINQRTNDTL_LOT_NO	sql_variant	NULL		No	No
SMNINQRTNDTL_QTY	bigint	NULL		No	No
SMNINQRTNDTL_COST	bigint	NULL		No	No
SMNINQRTNDTL_CREATED_DTTIME	datetime	NULL		No	No

Table Name SMN_SMNINQSUM_DRILLDOWN_SUM

Table Comment used to stoe the sum Drilldown table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNINQSUM_PART_OU	decimal(10)	NOT NULL	Part ou	No	No
SMNINQSUM_PART_NUMBER	varchar(40)	NOT NULL	part number	No	No
SMNINQSUM_PART_STATUS	varchar(40)	NOT NULL	part status	No	No
SMNINQSUM_MATL_INQ_FLAG	varchar(25)	NOT NULL	material flag	No	No
SMNINQSUM_ACCT_TYPE	varchar(40)	NULL	accounting type	No	No
SMNINQSUM_ACCT_CODE	varchar(32)	NULL	accounting code	No	No
SMNINQSUM_TRAN_QTY	decimal(28,8)	NULL	transfer quantity	No	No
SMNINQSUM_TRAN_VALUE	decimal(28,8)	NULL	transfer value	No	No
SMNINQSUM_SQUARE_OFF_QTY	decimal(28,8)	NULL	square quantity	No	No
SMNINQSUM_SQUARE_OFF_VALUE	decimal(28,8)	NULL	square off value	No	No
SMNINQSUM_BALANCE_QTY	decimal(28,8)	NULL	balance qty	No	No
SMNINQSUM_BALANCE_VALUE	decimal(28,8)	NULL	balance value	No	No

Table Name Smn_SmnObd_Opening_Bal_Dtl

Table Comment used to store the opening balance details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnObd_OUInstance	decimal(10)	NOT NULL	Stock Maintenance OUInstance	Yes	Yes
SmnObd_Opng_Bal_No	varchar(40)	NOT NULL	Opening Balance No	Yes	Yes
SmnObd_Line_No	decimal(10)	NOT NULL	Line Number generated for each part details of an opening balance document	Yes	No
SmnObd_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created OuInstance	No	No
SmnObd_Part_Pln_Ou	decimal(10)	NOT NULL	Part Planning Ou	No	No
SmnObd_Part_No	varchar(40)	NOT NULL	Part No	No	No
SmnObd_Part_Status	varchar(40)	NOT NULL	Can take any value as defined in UDSS which are stockable	No	No
SmnObd_Qty_In_StkUom	numeric(28,8)	NOT NULL	Qty being received at Warehouse - Zone - Bin level	No	No
SmnObd_Zone_Id	varchar(10)	NULL	Zone Id	No	No
SmnObd_Bin_Id	varchar(10)	NULL	Bin Id	No	No
SmnObd_Ref_Doc_No	varchar(40)	NULL	Reference Document Number for the qty being received.	No	No
SmnObd_SrlLot_Flag	varchar(5)	NULL	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 is not applicable for the Line, it will be ’NA’	No	No
SmnObd_WghAct_Flag	varchar(5)	NULL	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 &nbspdetails are completely entered for the Line, this will be ’Y’ If the part costing methodology is weighted average Or Actual Costing and if the wgh/actual costing details are not completely entered for the Line, this will be ’N’ If the part is neither Weighted Average nor Actual Costing, this flag will be ’NA’	No	No
SmnObd_LifoFifo_Flag	varchar(5)	NULL	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 not completely entered for the Line, this will be ’N’ If the part is neither Lifo nor Fifo, this flag will be ’NA’	No	No
SmnObd_Part_Cost	numeric(28,8)	NULL	Initial Part cost at the time of opening balance - to be updated when Opening balance is confirmed	No	No
SMNOBD_CUST_NO	sql_variant	NULL	customer number	No	No

Table Name Smn_SmnObdTmp_OpBal_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNOBDTMP_GUID	varchar(40)	NOT NULL		No	No
SMNOBDTMP_OUINSTANCE	decimal(10)	NULL		No	No
SMNOBDTMP_OPNG_BAL_NO	varchar(40)	NULL		No	No
SMNOBDTMP_LINE_NO	decimal(10)	NULL		No	No
SMNOBDTMP_PART_CRT_OU	decimal(10)	NULL		No	No
SMNOBDTMP_PART_PLN_OU	decimal(10)	NULL		No	No
SMNOBDTMP_PART_NO	varchar(40)	NULL		No	No
SMNOBDTMP_PART_STATUS	varchar(40)	NULL		No	No
SMNOBDTMP_QTY_IN_STKUOM	numeric(28,8)	NULL		No	No
SMNOBDTMP_ZONE_ID	varchar(10)	NULL		No	No
SMNOBDTMP_BIN_ID	varchar(10)	NULL		No	No
SMNOBDTMP_REF_DOC_NO	varchar(40)	NULL		No	No
SMNOBDTMP_SRLLOT_FLAG	varchar(5)	NULL		No	No
SMNOBDTMP_WghAct_Flag	varchar(5)	NULL		No	No
SMNOBDTMP_LifoFifo_Flag	varchar(5)	NULL		No	No
SMNOBDTMP_CUST_NO	sql_variant	NULL		No	No

Table Name Smn_SmnObh_Opening_Bal_Hdr

Table Comment used to store the openning balance details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnObh_OUInstance	decimal(10)	NOT NULL	Stock Maintenance OUInstance	Yes	No
SmnObh_Opng_Bal_No	varchar(40)	NOT NULL	Opening Balance No	Yes	No
SmnObh_Opng_Bal_Date	datetime	NOT NULL	Date on which the Opening Balance document was created.	No	No
SmnObh_Opng_Bal_Status	varchar(5)	NOT NULL	Status Of the document. DRFT - Draft FRSH - Fresh AUTH - Authorised CANC - Cancelled	No	No
SmnObh_Category	varchar(25)	NULL	Opening Balance Category	No	No
SmnObh_User_Status	varchar(25)	NULL	User Status for the document	No	No
SmnObh_Warehouse_Ou	decimal(10)	NOT NULL	OuInstance of the Warehouse where the Part-Qty is being received.	No	No
SmnObh_Warehouse_Id	varchar(10)	NOT NULL	Id of the Warehouse where the Part-Qty is being received.	No	No
SmnObh_User_Def_1	varchar(25)	NULL	User Defined Detail 1	No	No
SmnObh_User_Def_2		NULL		No	No
SmnObh_Remarks	varchar(255)	NULL	Remarks (If Any)	No	No
SmnObh_Filename	varchar(50)	NULL	Filename of the attached file which have more details on the OpBal document	No	No
SmnObh_Auth_By	varchar(30)	NULL	Authorised User Name	No	No
SmnObh_Auth_Datetime	datetime	NULL	Authorised DateTime	No	No
SmnObh_Created_Datetime	datetime	NOT NULL	Created Date Time	No	No
SmnObh_Created_By	varchar(30)	NOT NULL	Created User Name	No	No
SmnObh_Modified_Datetime	datetime	NOT NULL	Modified Date Time	No	No
SmnObh_Modified_By	varchar(30)	NOT NULL	Modified User Name	No	No
SmnObh_Timestamp	decimal(10)	NOT NULL	Number of times the Opening Balance Document has got modified.	No	No

Table Name Smn_SmnOpnCls_Datewise_Bal

Table Comment This table will have the datewise opening and closing balance details for location-warehouse-part
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnOpnCls_Src_OUInstance	decimal(10)	NOT NULL	Source OU Instance Id of StkMaint	No	No
SmnOpnCls_Wh_Ou	decimal(10)	NOT NULL	Warehouse Location	No	No
SmnOpnCls_Wh_Id	varchar(10)	NOT NULL	Warehouse ID	No	No
SmnOpnCls_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created OU	No	No
SmnOpnCls_Part_No	varchar(40)	NOT NULL	Part No	No	No
SmnOpnCls_Part_Status	varchar(40)	NOT NULL	Can take any value as defined in UDSS which are stockable	No	No
SmnOpnCls_Date	datetime	NOT NULL	Date for which opening and closing balances are maintained	No	No
_unknown_	char(18)	NULL		No	No
SMNOPNCLS_UPDATE_FLAG	varchar(5)	NULL	opening balance updated flag	No	No
SMNOPNCLS_TRAN_FLAG	varchar(5)	NULL	transfer quantity	No	No
SmnOpnCls_OpBal_Qty	numeric(28,8)	NULL	Opening balance quantity in stock uom	No	No
SmnOpnCls_OpBal_Value	decimal(28,8)	NULL	Opening balance Value	No	No
SmnOpnCls_TotRcpt_Qty	decimal(28,8)	NULL	Total Receipt Quantity	No	No
SmnOpnCls_TotRcpt_Value	decimal(28,8)	NULL	Total Receipt Value	No	No
SmnOpnCls_TotIssued_Qty	decimal(28,8)	NULL	Total Issued Quantity	No	No
SmnOpnCls_TotIssued_Value	decimal(28,8)	NULL	Total Issued Value	No	No
SmnOpnCls_TotRtn_Qty	decimal(28,8)	NULL	Total Return Quantity	No	No
SmnOpnCls_TotRtn_Value	decimal(28,8)	NULL	Total Return Value	No	No
SmnOpnCls_TotAdj_Qty	decimal(28,8)	NULL	Total Adjustment Quantity	No	No
SmnOpnCls_TotAdj_Value	decimal(28,8)	NULL	Total Adjustment Value	No	No
SmnOpnCls_TrnIn_Qty	decimal(28,8)	NULL	Transaction In Quantity	No	No
SmnOpnCls_TrnIn_Value	decimal(28,8)	NULL	Transaction In Value	No	No
SmnOpnCls_TrnOut_Qty	decimal(28,8)	NULL	Transaction Out Quantity	No	No
SmnOpnCls_TrnOut_Value	decimal(28,8)	NULL	Transaction Out Value	No	No
SmnOpnCls_ReEval_Value	decimal(28,8)	NULL	Re Evaluation Value	No	No
SmnOpnCls_ClsBal_Qty	numeric(28,8)	NULL	Closing balance quantity in stock uom	No	No
SmnOpnCls_ClsBal_Value	numeric(28,8)	NULL	Value of the qty on the Date	No	No

Table Name Smn_SmnOpSet_Opt_Settings

Table Comment used to store the set options details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnOpSet_OUInstance	decimal(10)	NOT NULL	ou instance	Yes	No
SmnOpSet_Frac_Conv_Mthd_Flag	varchar(5)	NULL	flag for conversion method	No	No
SmnOpset_Part_Expns_Basis	varchar(5)	NULL	part expense basis Expense at first issue - EFI and expense at retairment - ERT	No	No
SmnOpSet_Created_By	varchar(30)	NULL	Created By	No	No
SmnOpSet_CreatedDate	datetime	NULL	Created Date	No	No
SmnOpSet_Modified_By	varchar(30)	NULL	Modified By	No	No
SmnOpSet_ModifiedDate	datetime	NULL	Modified date	No	No
SmnOpSet_Timestamp	decimal(10)	NULL	Time stamp	No	No
SmnOpset_RepMR_NumType	varchar(25)	NULL	numbering type for auto created MR	No	No
SmnOpset_RepST_NumType	varchar(25)	NULL	numbering type for auto created Stock transfer	No	No
smnopset_reppr_numtype	varchar(25)	NULL	numbering type for auto created Purchase Req	No	No
smnopset_reppo_numtype	varchar(25)	NULL	numbering type for auto created Purchase Order	No	No
SmnOpSet_AllOwnChng_ExtPrt	sql_variant	NULL	Ownership change allowed or not y - allowed n - not allowed	No	No
SmnOpSet_Rep_Exp_Comp	sql_variant	NULL	Expensing policy for components CPADD -- add to stock CPEXP -- expense off	No	No
SmnOpSet_Rep_Exp_PcePrt	sql_variant	NULL	Expensing policy for non components CPADD -- add to stock CPEXP -- expense off	No	No
SMNOPSET_EXPOFF_PERC	bigint	NULL	Expensing policy	No	No
Smnopset_ReturnCls	sql_variant	NULL	This field holds the Value ’Y’(Yes) or ’N’(No) cost Return Cost Valuation based on Return Classification	No	No
Smnopset_Inspection	sql_variant	NULL	Inspection check box A - checked	No	No
Smnopset_Overhaul	sql_variant	NULL	Overhaul check box A - checked	No	No
Smnopset_Others	sql_variant	NULL	Others check box A - checked	No	No
Smnopset_Repair	sql_variant	NULL	Repair check box A - checked	No	No
SmnOpset_RepStkCrn_NumType	sql_variant	NULL	This column holds the Numbering type	No	No
SMNOPSET_REPPORS	sql_variant	NULL	Open PO/RS Quantity COREP- Consider for Stock Replenishment NOREP- Do not consider for Stock Replenishment	No	No
SMNOPSET_WNCOST	sql_variant	NULL	Set Warranty Claim Cost as Replacement Part Cost Y- Yes N- No	No	No
SMNOPSET_PRQTY_PEGG_PEND_FLAG	int	NULL	Consider PR Quantity in Receipt Pegging 1- Considered 0- Not Considered	No	No
SMNOPSET_STALCTN_OWNSHP_PARTS	sql_variant	NULL	This column is used to store the ’Ownership Parts’ value	No	No
SMNOPSET_PART_MODL_EFFCTCHK	sql_variant	NULL	Thsi column is used to store ’Effectivity Check ’combo value	No	No
SMNOPSET_SOS_SERVICEPARTS	sql_variant	NULL	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	No

Table Name Smn_SmnPrm_OpBal_Param_Dtl

Table Comment used to store the parameter information of openning balance
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnPrm_Since_Repair	numeric(28,8)	NULL	Parameter Value for the Part In this Condition	No	No
SmnPrm_Since_Overhaul	numeric(28,8)	NULL		No	No
SmnPrm_Since_New	numeric(28,8)	NULL		No	No
SmnPrm_Warranty_Val	numeric(28,8)	NULL	Warranty Value	No	No
SmnPrm_Since_Insp	numeric(28,8)	NULL	Parameter Value for the Part In this Condition	No	No
SmnPrm_Since_LSV	numeric(28,8)	NULL	Since Last Shop Visit	No	No
SmnPrm_unknown	varchar(2)	NULL	Unknown	No	No
SmnPrm_Opng_Bal_No	varchar(40)	NOT NULL	Opening Balance No	Yes	Yes
SmnPrm_OUInstance	decimal(10)	NOT NULL	Stock Maintenance OUInstance	Yes	Yes
SmnPrm_Param_Code	varchar(40)	NOT NULL	Parameter Code	Yes	No
SmnPrm_Param_Ou	decimal(10)	NOT NULL	Ou of the Parameter	Yes	No
SmnPrm_Line_No	decimal(10)	NOT NULL	Line Number generated for each part details of an opening balance document	Yes	Yes
SmnPrm_Sub_LineNo	decimal(10)	NOT NULL	Sub Line No	Yes	Yes

Table Name Smn_smnprm_parameter_details

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnPrm_ComponentName	varchar(80)	NOT NULL	Name of the component	Yes	No
SmnPrm_ParamCategory	varchar(10)	NOT NULL	Category of the Parameter	Yes	No
SmnPrm_ParamType	varchar(25)	NOT NULL	Parameter Type	Yes	No
Smnprm_ParamCode	varchar(5)	NOT NULL	Param Code	Yes	No
SmnPrm_Langid	decimal(10)	NOT NULL	Language id.	Yes	No
SmnPrm_ParamDesc	varchar(80)	NULL	Description Of the Parameter	No	No
SmnPrm_Sort_By	decimal(10)	NULL	Ordering the values	No	No

Table Name Smn_SmnPrm_Srl_Param_Val

Table Comment For the Stock Maintained, this entity contains the initial parameter value details for &nbspserial controlled component type of parts at the time of original receipt.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNPRM_SRC_OUINSTANCE	decimal(10)	NOT NULL	Ou	Yes	No
%AttName	int	NOT NULL	¨¢gDef	Yes	No
SmnPrm_Part_Crt_Ou	decimal(10)	NOT NULL	UnPlanned Receipt Document No	Yes	No
SmnPrm_Part_No	varchar(40)	NOT NULL	Part No	Yes	No
SmnPrm_Serial_No	varchar(40)	NOT NULL	Serial No	Yes	No
SmnPrm_Param_Code	varchar(40)	NOT NULL	Param Code	Yes	No
SmnPrm_Src_OuInstance	int	NOT NULL	Source Ouinstance	No	No
SmnPrm_Since_New	numeric(28,8)	NULL	Value of the Parameter in this condition.	No	No
SmnPrm_Since_Overhaul	numeric(28,8)	NULL		No	No
SmnPrm_Since_Repair	numeric(28,8)	NULL		No	No
SmnPrm_Since_Insp	numeric(28,8)	NULL		No	No
SmnPrm_Since_Lsv	numeric(28,8)	NULL	Param value Value of the Parameter in this condition. since Last Shop Visit	No	No
SmnPrm_Warranty_Value	numeric(28,8)	NULL	Warranty Value.	No	No
SmnPrm_As_Of_Datetime	datetime	NULL	Date Time on which details are entered.	No	No
SMNPRM_UNKNOWN	varchar(2)	NULL	Unknown	No

Table Name Smn_SmnQc_Quick_Code

Table Comment This table maintains the Quick Code information. Quick Code type referred are - Maintenance Report User Status and Reason for Carry forward
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
%AttName	int	NOT NULL	ˆ QuickCodes	Yes	No
SMNQC_OUINSTANCE	decimal(10)	NOT NULL	Ou instance	Yes	No
SmnQc_Quick_Code	varchar(25)	NOT NULL	Quick Code number stored here.	Yes	No
SmnQc_Type		NOT NULL	Quick Code Type - Maintenance Report User Status/ Reason for Carry forward	Yes	No
SmnQc_Desc	varchar(80)	NOT NULL	Quick Code Description	No	No
SmnQc_Status	varchar(25)	NOT NULL	Quick Code Status is stored here. ’A’ - Active ’I’ - Inactive	No	No
SmnQc_CreatedDate	datetime	NOT NULL	Date on which quick code got created	No	No
SmnQc_Created_By	varchar(30)	NOT NULL	User who has created the quick code	No	No
SmnQc_ModifiedDate	datetime	NULL	Date on which quick code got modified.	No	No
SmnQc_Modified_By	varchar(30)	NULL	User who has modified the quick code.	No	No
SmnQc_Timestamp	decimal(10)	NOT NULL	Quick code Time stamp details	No	No

Table Name Smn_SmnSrl_OpBal_SrlLot_Dtl

Table Comment used to store the serial lot details of openning balance
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SmnSrl_Auth_No	varchar(40)	NULL	Authorization No	No	No
SmnSrl_Sys_Track_No	varchar(40)	NULL	System Tracking Reference No	No	No
SmnSrl_Expiry_Date	datetime	NULL	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 components	No	No
SmnSrl_Cert_Date	datetime	NULL	Certificate Date	No	No
SmnSrl_Cert_No	varchar(40)	NULL	Certificate No	No	No
SmnSrl_Gen_Srl_No	varchar(40)	NULL	Generated Serial No	No	No
SmnSrl_Gen_Lot_No	varchar(18)	NULL	Generated Lot No	No	No
SmnSrl_Supplier_Ou	decimal(10)	NULL	Supplier OuInstance	No	No
SmnSrl_Remarks	varchar(255)	NULL	Remarks (If Any)	No	No
SmnSrl_Supplier_No	varchar(45)	NULL	Supplier No	No	No
SmnSrl_Warranty_Lapse_Date	datetime	NULL	Applicable only for Serial controlled Part	No	No
SmnSrl_Line_No	decimal(10)	NOT NULL	Line Number generated for each part details of an opening balance document	Yes	Yes
SmnSrl_Sub_LineNo	decimal(10)	NOT NULL	Sub Line No	Yes	No
SmnSrl_Manuf_Srl_No	varchar(40)	NULL	Manufacturer Serial no	No	No
SmnSrl_Opng_Bal_No	varchar(40)	NOT NULL	Opening Balance No	Yes	Yes
SmnSrl_OUInstance	decimal(10)	NOT NULL	Stock Maintenance OUInstance	Yes	Yes
SmnSrl_Cert_Type	varchar(25)	NULL	Certificate Type	No	No
SmnSrl_Rate	numeric(28,8)	NULL	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	No
SmnSrl_Value	numeric(28,8)	NULL	Value - Calculated & Stored at present , if it is not entered. it might get changed in the future.	No	No
SmnSrl_Manuf_Lot_No	varchar(18)	NULL	Manufacturer Lot No	No	No
SmnSrl_Qty_InStkUom	numeric(28,8)	NULL	Qty In Stock Uom	No	No
SmnSrl_Part_Condition	varchar(5)	NULL	Part Condition	No	No

Table Name Smn_SmnSrlTmp_OpBal_SL_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNSRLTMP_GUID	varchar(40)	NOT NULL		No	No
SMNSRLTMP_OUINSTANCE	decimal(10)	NULL		No	No
SMNSRLTMP_OPNG_BAL_NO	varchar(40)	NULL		No	No
SMNSRLTMP_LINE_NO	decimal(10)	NULL		No	No
SMNSRLTMP_SUB_LINENO	decimal(10)	NULL		No	No
SMNSRLTMP_MANUF_SRL_NO	varchar(40)	NULL		No	No
SMNSRLTMP_MANUF_LOT_NO	varchar(18)	NULL		No	No
SMNSRLTMP_PART_CONDITION	varchar(5)	NULL		No	No
SMNSRLTMP_QTY_INSTKUOM	numeric(28,8)	NULL		No	No
SMNSRLTMP_RATE	numeric(28,8)	NULL		No	No
SMNSRLTMP_VALUE	numeric(28,8)	NULL		No	No
SMNSRLTMP_CERT_TYPE	varchar(25)	NULL		No	No
SMNSRLTMP_CERT_NO	varchar(40)	NULL		No	No
SMNSRLTMP_CERT_DATE	datetime	NULL		No	No
SMNSRLTMP_AUTH_NO	varchar(40)	NULL		No	No
SMNSRLTMP_SYS_TRACK_NO	varchar(40)	NULL		No	No
SMNSRLTMP_SUPPLIER_OU	decimal(10)	NULL		No	No
SMNSRLTMP_SUPPLIER_NO	varchar(45)	NULL		No	No
SMNSRLTMP_REMARKS	varchar(255)	NULL		No	No
SMNSRLTMP_EXPIRY_DATE	datetime	NULL		No	No
SMNSRLTMP_WARRANTY_LAPSE_DATE	datetime	NULL		No	No
SMNSRLTMP_GEN_SRL_NO	varchar(40)	NULL		No	No
SMNSRLTMP_GEN_LOT_NO	varchar(18)	NULL		No	No
SMNSRLTMP_CUST_NO	sql_variant	NULL		No	No

Table Name SMN_SMNSTKSTAT_OPT_SETTINGS

Table Comment stock option settings
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
_unknown_2	char(18)	NULL		Yes	No
SMNSTKSTAT_OUINSTANCE	varchar(10)	NOT NULL		Yes	No
_unknown_3	char(18)	NULL		No	No
_unknown_4	char(18)	NULL		No	No
_unknown_5	char(18)	NULL		No	No
_unknown_6	char(18)	NULL		No	No
_unknown_7	char(18)	NULL		No	No
_unknown_	char(18)	NULL		No	No

Table Name SMN_SMNTMP1_OPNG_BAL_DTL
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SMNTMP1_GUID	varchar(40)	NOT NULL		No	No
SMNTMP1_OUINSTANCE	decimal(10)	NULL		No	No
SMNTMP1_OPNG_BAL_NO	varchar(40)	NULL		No	No
SMNTMP1_LINE_NO	decimal(10)	NULL		No	No
SMNTMP1_PART_CRT_OU	decimal(10)	NULL		No	No
SMNTMP1_PART_PLN_OU	decimal(10)	NULL		No	No
SMNTMP1_PART_NO	varchar(40)	NULL		No	No
SMNTMP1_PART_STATUS	varchar(40)	NULL		No	No
SMNTMP1_VALUATION_MET	varchar(5)	NULL		No	No
SMNTMP1_QTY_IN_STKUOM	numeric(28,8)	NULL		No	No
SMNTMP1_ZONE_ID	varchar(10)	NULL		No	No
SMNTMP1_BIN_ID	varchar(10)	NULL		No	No
SMNTMP1_REF_DOC_NO	varchar(40)	NULL		No	No

Table Name SMN_SMNWHCATG_OPT_SETTINGS

Table Comment option settings table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
_unknown_2	char(18)	NULL		Yes	No
SMNWHCATG_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
_unknown_3	char(18)	NULL		No	No
_unknown_4	char(18)	NULL		No	No
_unknown_5	char(18)	NULL		No	No
_unknown_6	char(18)	NULL		No	No
_unknown_	char(18)	NULL		No	No
SMNWHCATG_TIMESTAMP	decimal(10)	NULL		No	No

Table Name Smn_StkCrDA_Doc_Attach_Dtl

Table Comment used to store the reference document attached to the stock correction
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrDA_Doc_Id	varchar(40)	NOT NULL	Document Id	Yes	No
StkCrDA_File_Name	varchar(50)	NULL	Reference File Name	No	No
StkCrDA_Remarks	varchar(255)	NULL	Remarks (if any)	No	No
StkCrDA_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	Yes
StkCrDA_Ref_Doc_Type	varchar(15)	NOT NULL	Reference Document Type	Yes	No
StkCrDA_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	Yes

Table Name Smn_StkCrDt_Stock_Corr_Dtl

Table Comment used to store the part levevl information of stock corretion
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrDt_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	Yes
StkCrDt_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	Yes
StkCrDt_SysLine_No	decimal(10)	NOT NULL	System Generated Line No	Yes	No
StkCrDt_DisplayLine_No	decimal(10)	NULL	Display Line Number	No	No
StkCrDt_Part_Crt_Ou	decimal(10)	NULL	Part Created Ouinstance	No	No
StkCrDt_Part_No	varchar(40)	NULL	Part Number	No	No
StkCrDt_Part_Status	varchar(40)	NULL	Part Status	No	No
StkCrDt_CorrectionQty_InStkUom	decimal(28,8)	NULL	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	No
StkCrDt_SysQty_InStkUom	decimal(28,8)	NULL	System Quantity at the time of correction	No	No
StkCrDt_Zone_Id	varchar(10)	NULL	Zone Id	No	No
StkCrDt_Bin_Id	varchar(10)	NULL	Bin Id	No	No
StkCrDt_Remarks	varchar(255)	NULL	Remarks (if Any)	No	No
StkCrDt_Val_LnkFlag	varchar(5)	NULL	Value page link flag	No	No
StkCrDt_Crs_LnkFlag	varchar(5)	NULL	serial lot flag	No	No
StkCrDt_SL_LnkFlag	varchar(5)	NULL		No	No
StkCrDt_CC_Usage	varchar(20)	NULL	Cost Center Usage	No	No
StkCrDt_Fin_Book	varchar(20)	NULL	Finance Book	No	No
StkCrDt_Acc_Code	varchar(32)	NULL	Account Code	No	No
StkCrDt_Anly_Code	varchar(5)	NULL	Analysis Code	No	No
StkCrDt_Sub_Anly_Code	varchar(5)	NULL	Sub Analysis Code	No	No
StkCrDt_CostCenter_Code	varchar(10)	NULL	Cost Center Code	No	No
STKCRDT_PART_CNTRL_TYPE	varchar(25)	NULL		No	No
STKCRDT_VALUATION_METHOD	varchar(5)	NULL		No	No
STKCRDT_EXPENCE_TYPE	varchar(25)	NULL		No	No
STKCRDT_STDCOST	numeric(13)	NULL		No	No

Table Name Smn_StkCrMn_Stock_Corr_Hdr

Table 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.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrMn_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	No
StkCrMn_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	No
StkCrMn_NumType_No	varchar(5)	NULL	Numbering Type number. This is stored as it required for arriving the cost center.	No	No
StkCrMn_Warehouse_Ou	decimal(10)	NULL	Warehouse Location where the material correction happens	No	No
StkCrMn_Warehouse_Id	varchar(10)	NULL	Warehouse where the material correction happens	No	No
StkCrMn_StkCorr_Status	varchar(5)	NULL	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 correction can be created in fresh status. Confirmed: Stock correction attains this status in confirm activity when the details are confirmed. A confirmed Stock correction &nbsptransaction cannot be canceled. Only ’Fresh’ transaction can be authorized. Cancelled: Both Draft as well as Fresh Stock corrections can be canceled.	No	No
StkCrMn_Corr_Type	varchar(5)	NULL	This indicates the type of discrepancy between the System Stock and the Physical Stock. &nbspIf 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 type. And if the discrepancy is on both Quantity and value, then it is of Quantity & Value. Following are the codes and values of correction type Quantity - QTY Value - VAL Quantity & Value - QTVAL	No	No
StkCrMn_Corr_Basis	varchar(5)	NULL	Correction Basis	No	No
StkCrMn_Src_Doc_Ou	decimal(10)	NULL	Stock Correction Document can also be generated from PICC. This field indicates the location from where the StkCorr Doc got created	No	No
StkCrMn_Src_Doc_No	varchar(40)	NULL	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	No
StkCrMn_User_Status	varchar(25)	NULL	Stock Correction User Status as defined in Quick Codes	No	No
StkCrMn_Corr_Date	datetime	NULL	The date on which stock correction takes place	No	No
StkCrMn_Corr_Category	varchar(25)	NULL	Stock Correction Category as defined in Quick codes	No	No
StkCrMn_User_Def_1	varchar(25)	NULL	User defined data - 1 for the stock correction doc	No	No
StkCrMn_User_Def_2		NULL	User defined data - 2 for the stock correction doc	No	No
StkCrMn_Comments	varchar(255)	NULL	Comments (if any) for the stock correction document	No	No
StkCrMn_FileName	varchar(50)	NULL	Filename	No	No
StkCrMn_DefCorr_Flag	varchar(1)	NULL	If ’Apply Default Correction’ was enabled , this will have ’Y’ or ’N’	No	No
StkCrMn_CC_Usage	varchar(20)	NULL	Cost Center Usage	No	No
StkCrMn_Auth_By	varchar(18)	NULL	Authorised by User	No	No
StkCrMn_Auth_Datetime	datetime	NULL	Authorised Date	No	No
StkCrMn_Created_By	varchar(18)	NULL	Created By User	No	No
StkCrMn_Created_Datetime	datetime	NULL	Created Date	No	No
StkCrMn_Modified_By	varchar(18)	NULL	Modified By User	No	No
StkCrMn_Modified_Datetime	datetime	NULL	Modified Date	No	No
StkCrMn_Timestamp	decimal(10)	NULL	Timestamp	No	No
STKCRMN_ACC_USAGE	sql_variant	NULL	Accounting usage	No	No
STKCRMN_NET_NEGVALUE	numeric(13)	NULL		No	No
STKCRMN_NET_POSVALUE	numeric(13)	NULL		No	No

Table Name Smn_StkCrPrm_StkCorr_Param

Table Comment used to store the parammeter infomation of the stock correction
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrPrm_Since_Insp	decimal(28,8)	NULL	Since Inspection	No	No
StkCrPrm_Since_Repair	decimal(28,8)	NULL	Since Repair	No	No
StkCrPrm_Since_Overhaul	decimal(28,8)	NULL	Since Overhaul Value	No	No
StkCrPrm_Since_Lsv	decimal(28,8)	NULL	Param value since Last Shop Visit	No	No
StkCrPrm_Warranty_Value	decimal(28,8)	NULL	Warranty Value	No	No
STKCRMN_ACC_USAGE	sql_variant	NULL	Accounting usage	No	No
StkCrPrm_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	Yes
StkCrPrm_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	Yes
StkCrPrm_Since_New	decimal(28,8)	NULL	Since New value	No	No
StkCrPrm_Param_Code	varchar(40)	NOT NULL	Parameter Code	Yes	No
StkCrPrm_Line_No	decimal(10)	NOT NULL	Line Number	Yes	Yes
StkCrPrm_SysSeq_No	decimal(10)	NOT NULL	System Sequence Number	Yes	Yes

Table Name Smn_StkCrRc_Corr_Spec_Rcpt

Table Comment used to store the stock correction specific serial level inforamtion
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrRc_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	Yes
StkCrRc_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	Yes
StkCrRc_Rcpt_Type	varchar(25)	NOT NULL	This could be OpBal, GR, Rcpt, Rtn	Yes	No
StkCrRc_Rcpt_Ou	decimal(10)	NOT NULL	This could be GR or Receipt Ou	Yes	No
StkCrRc_Rcpt_Doc_No	varchar(40)	NOT NULL	This could be the GR or Receipt Transaction Document No	Yes	No
StkCrRc_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created Ouinstance	Yes	No
StkCrRc_Part_No	varchar(40)	NOT NULL	Part Number	Yes	No
StkCrRc_Part_Status	varchar(40)	NOT NULL	Part Status	Yes	No
StkCrRc_Receipt_Date	datetime	NULL	Receipt Date	No	No
StkCrRc_Receipt_Value	decimal(28,8)	NULL	Receipt Value	No	No
StkCrRc_RcptQty_InStkUom	decimal(28,8)	NULL	Receipt Quantity in Stock Uom	No	No
StkCrRc_CorrectionQty_InStkUom	decimal(28,8)	NULL	Correction Quantity in Stock Uom	No	No
StkCrRc_Correction_Value	decimal(28,8)	NULL	Correction Value	No	No
StkCrRc_Corrected_Value	decimal(28,8)	NULL	Corrected Value	No	No
STKCRRC_SEQ_NO	int	NULL		No	No
STKCRRC_RATE_NO	int	NULL		No	No
STKCRRC_SYSQTY_INSTKUOM	int	NULL		No	No

Table Name Smn_StkCrSL_StkCorr_SrlLot

Table Comment This table used store the stock correction serial lot details table...
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrSL_Cert_Type	varchar(25)	NULL	Certificate Type	No	No
StkCrSL_Cert_Date	datetime	NULL	Certificate Date	No	No
StkCrSL_Cert_No	varchar(40)	NULL	Certificate Number	No	No
StkCrSL_Part_Condition	varchar(40)	NULL	Part Condition	No	No
StkCrSL_Sys_Value	decimal(28,8)	NULL	System Value	No	No
StkCrSL_SysQty_InStkUom	decimal(28,8)	NULL	System Quantity in Stock Uom	No	No
STKCRSL_TRADPARTNERNO	sql_variant	NULL	Owner Number\Name	No	No
STKCRSL_TRADPARTNERTYPE	sql_variant	NULL	Trading partner type ’CUS’ - Customer ’Sup’ - Supplier	No	No
StkCrSL_Auth_No	varchar(40)	NULL	Authorization Number	No	No
StkCrSL_Warranty_Lapse_Date	datetime	NULL	Warranty Laspse Date	No	No
StkCrSL_Sys_Track_No	varchar(40)	NULL	System Tracking Number	No	No
STKCRSL_TRADPARTNEROU	int	NULL	Owner location info.	No	No
StkCrSL_SysLine_No	decimal(10)	NOT NULL	System Line Number	Yes	Yes
StkCrSL_SysSeq_No	decimal(10)	NOT NULL	System Sequence Number	Yes	No
StkCrSL_DisplaySeq_No	decimal(10)	NULL	Display Line Number	No	No
StkCrSL_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	Yes
StkCrSL_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	Yes
StkCrSL_Corr_Value	decimal(28,8)	NULL	Correction Value	No	No
StkCrSL_Sys_Lot_No	varchar(18)	NULL	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	No
StkCrSL_CorrQty_InStkUom	decimal(28,8)	NULL	Correction Quantity in Stock UOM	No	No
StkCrSL_Ref_Srl_No	varchar(40)	NULL	Reference Serial Number	No	No
StkCrSL_Sys_Srl_No	varchar(40)	NULL	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	No
StkCrSL_Ref_Lot_No	varchar(18)	NULL	Reference Lot Number	No	No

Table Name Smn_StkCrVL_StkCorr_Val_Dtl

Table Comment This table is used to stored the value details of stock correction..
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
StkCrVL_StkCorr_OuInstance	decimal(10)	NOT NULL	Stock Maintenance Location where the correction details are entered.	Yes	Yes
StkCrVL_StkCorr_No	varchar(40)	NOT NULL	System generated number to uniquely trace stock correction details	Yes	Yes
StkCrVL_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created Ouinstance	Yes	No
StkCrVL_Part_No	varchar(40)	NOT NULL	Part Number	Yes	No
StkCrVL_Part_Status	varchar(40)	NOT NULL	Part Status	Yes	No
StkCrVL_Sys_Lot_No	varchar(18)	NOT NULL	System Lot Number	Yes	No
StkCrVL_Ref_Lot_No	varchar(18)	NOT NULL	Reference Lot Number	Yes	No
StkCrVL_Corr_Method	varchar(5)	NULL	Correction Method	No	No
StkCrVL_CorrectionQty_InStkUom	decimal(28,8)	NULL	Correction Quantity in Stock UOM	No	No
StkCrVL_Correction_Value	decimal(28,8)	NULL	This will be the difference in value between the system value and the actual inventory stock current value	No	No
StkCrVL_Sys_Qty_InStkUom	decimal(28,8)	NULL	System Quantity in Stock UOM	No	No
StkCrVL_Sys_Value	decimal(28,8)	NULL	System Value	No	No
STKCRVL_SEQ_NO	int	NULL		No	No

Table Name SMN_STOCK_ASONDATE_DTL

Table Comment This table is used to store stock &nbspasn value’s
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
BAL_STOCK_PARTNO	varchar(40)	NULL	Part number	No	No
BAL_STOCK_STATUS			Stoak status
BAL_STOCK_BALQTY	decimal(28,8)		Bal quantity
BAL_STOCK_DATED	datetime		stock date

Table Name Smn_wghbal_wgh_avg_part_value

Table 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
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WghBal_smn_ouinstance	decimal(10)	NOT NULL	Stock Maintenance Created OUInstance	Yes	No
WghBal_part_crt_ou	decimal(10)	NOT NULL	Part Created Ouinstance	Yes	No
WghBal_part_pln_ou	decimal(10)	NOT NULL	Part Planning Ou	Yes	No
WghBal_part_no	varchar(40)	NOT NULL	Any stockable part can be stored here	Yes	No
WghBal_part_status	varchar(40)	NOT NULL	Can take any value as defined in UDSS which are stockable	Yes	No
WghBal_Warehouse_Ou	decimal(10)	NOT NULL	If the option setting for Stock Cost Evaluation is Location level, then this would be ##. Otherwise, it will have the storage location OUId	Yes	No
WghBal_Warehouse_Id	varchar(10)	NOT NULL	If the option setting for Stock Cost Evaluation is Location level, then this would be ##. Otherwise, it will have the Warehouse Id	Yes	No
WghBal_available_qty	numeric(28,8)	NULL	Available Quantity	No	No
WghBal_weighted_avg_value	numeric(28,8)	NULL	Weighed Average Value	No	No
WghBal_created_by	varchar(30)	NOT NULL	Created User Name	No	No
WghBal_created_date	datetime	NOT NULL	Created User Date	No	No
WghBal_modified_by	varchar(30)	NOT NULL	Last Modified by	No	No
WghBal_modified_date	datetime	NOT NULL	Last Modified Date	No	No
WghBal_OWNERSHIP	sql_variant	NULL	Owner Number\Name	No	No
WghBal_OWNINGAGENCY_OU	int	NULL	Owner location info.	No	No
WghBal_OWNINGAGENCY	sql_variant	NULL	Trading partner type ’CUS’ - Customer ’Sup’ - Supplier	No	No

Table Name Smn_WgtAct_WhgtAvg_Act_Cost

Table Comment This table is used to store the weighted &nbspaverage details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WgtAct_OUInstance	decimal(10)	NOT NULL	OuInstance	Yes	No
WgtAct_Opng_Bal_No	varchar(40)	NOT NULL	Opening Balance No	Yes	No
WgtAct_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created Ou	Yes	No
WgtAct_Part_Pln_Ou	decimal(10)	NOT NULL	Part Planning Ou	Yes	No
WgtAct_Part_No	varchar(40)	NOT NULL	Part No	Yes	No
WgtAct_Manuf_Lot_No	varchar(18)	NOT NULL	Will be ## in all cases except for ActualCosting-OnlyLot case	Yes	No
WGTACT_PART_STATUS	sql_variant	NOT NULL	Part status	Yes	No
WgtAct_Qty	numeric(28,8)	NULL	Qty - Applicable for parts of ’Weighted Average’ Only’ and parts which are Lot Controlled.	No	No
WgtAct_Rate	numeric(28,8)	NULL	Rate - Applicable for parts of ’Weighted Average’ Only’ and parts which are Lot Controlled.	No	No
WgtAct_Value	numeric(28,8)	NULL	Value - Applicable for parts of ’Weighted Average’ Only’ and parts which are Lot Controlled.	No	No
WgtAct_Entry_Type	varchar(5)	NULL	Entry Type can be S- Single M - Multiple	No	No
WgtAct_Ref_Doc_No	varchar(40)	NULL	Reference Document No	No	No
WGTACT_STOCK_UOM	sql_variant	NULL	Stock uom	No	No

Table Name Smn_WgtDt_WgAvg_MltRate_Dtl

Table Comment material detailrs table..
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WgtDt_OUInstance	decimal(10)	NOT NULL	OuInstance	Yes	No
WgtDt_Opng_Bal_No	varchar(40)	NOT NULL	Opening Balance No	Yes	No
WgtDt_Part_Pln_Ou	decimal(10)	NOT NULL	Part Planning Ou	Yes	No
WgtDt_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created Ou	Yes	No
WgtDt_Part_No	varchar(40)	NOT NULL	Part No	Yes	No
WgtDt_Seq_No	decimal(10)	NOT NULL	User Entered Sequence No	Yes	No
WGTDT_PART_STATUS	sql_variant	NOT NULL		Yes	No
WGTDT_SYS_LINENO	decimal(10)	NOT NULL	System Generated Line No	No	No
WgtDt_Qty_InStkUom	numeric(28,8)	NULL	Qty In Stock Uom	No	No
WgtDt_Rate	numeric(28,8)	NULL	Rate	No	No
WgtDt_Value	numeric(28,8)	NULL	Value	No	No
WgtDt_Ref_Doc_No	varchar(40)	NULL	Reference Document Details	No	No