Stock Analysis

Table Name Sta_StaABCDtl_ABC_Anly_Dtl

Table Comment Stores the Details of ABC analysis

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaABCDtl_OUInstance

int

NOT NULL

Created Ou Instance

StaABCDtl_Analysis_No

varchar(40)

NOT NULL

Document No

StaABCDtl_Part_No

varchar(40)

NOT NULL

Part No

StaABCDtl_Part_Pln_OU

int

NOT NULL

Part Plan Ou

StaABCDtl_Part_Crt_OU

int

NULL

Part created Ou

StaABCDtl_Value

decimal(28,8)

NULL

ABC - Consumption value

StaABCDtl_Cum_Value

decimal(28,8)

NULL

Cumulative Consumption value

StaABCDtl_Value_InPerc

decimal(28,8)

NULL

Consumption value in Perc

StaABCDtl_Cum_Value_InPerc

decimal(28,8)

NULL

Cumulative consumption value in Percentage

StaABCDtl_Curr_ClassType

varchar(5)

NULL

Existing class type of the part

StaABCDtl_New_ClassType

varchar(5)

NULL

Computed Class Type

StaABCDtl_Curr_StkValue

numeric(28,8)

NULL

Current Stock Value ( Available qty * Stock )

Table Name Sta_StaCRP_RplPrm_Calc_Hdr

Table Comment Stores the Replenishment Computation details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaCRP_Compute_Seq_no

int

NOT NULL

Seq No

StaCRP_Compute_Lvl

varchar(5)

NULL

Computation Level For Warehouse -> WH For Location -> Loc

StaCRP_Loc_StkAdmn_Ou

int

NULL

computed Ou

StaCRP_Warehouse_no

varchar(10)

NULL

Warehouse Code

StaCRP_Part_no

varchar(40)

NULL

Part NO

StaCRP_Part_Grp

varchar(18)

NULL

Part Group selected for Computation

StaCRP_SrvLvl_Percent

numeric(28,8)

NULL

Service Level Percent if not entered in Compute Page then Fetches From Set Page.

StaCRP_SrvLvl_Factor

numeric(28,8)

NULL

service Level Factor Corresponding to the Service level percent

StaCRP_Per_Order_Cost

decimal(28,8)

NULL

Per Order Cose Entered.

StaCRP_CryCost_Pct_StdPr

decimal(28,8)

NULL

Carrying Cost in % of Std Price

StaCRP_Anul_Consumption

numeric(28,8)

NULL

Computed annual Consumption

StaCRP_Forecast_Factor

numeric(28,8)

NULL

Computed Forecast Factor

StaCRP_Lead_Time

numeric(9)

NULL

Lead Time Entered

StaCRP_Lead_Time_unit

varchar(5)

NULL

Lead time Unit D -> Days M -> Month W -> Weeks Y -> Year

StaCRP_From_date

datetime

NULL

From Date Entered

StaCRP_To_date

datetime

NULL

To date Entered. This period is calculated for Consumption calculation

StaCRP_Max_Tolerance_Pct

decimal(10)

NULL

Entered Maximum Tolerance percentage

StaCRP_Min_Tolerance_Pct

decimal(10)

NULL

Entered Minimum Tolerance percentage

StaCRP_Reorder_Qty_Flg

varchar(5)

NULL

reorder qty flag 1 -> reorder qty option is selected. 0 -> Reorder Qty option is not selected.

StaCRP_Reorder_Lvl_Flg

varchar(5)

NULL

reorder Level flag 1 -> reorder Level option is selected. 0 -> Reorder Level option is not selected.

StaCRP_Safety_Stock_Flg

varchar(5)

NULL

Safety Stock flag 1 -> Safety Stock option is selected. 0 -Safety Stock option is not selected.

StaCRP_MinMax_Min_Qty

varchar(5)

NULL

Min Max Qty flag 1 -Min Max Qty flag option is selected. 0 -Min Max Qty flag option is not selected.

StaCRP_Update_Input_Prm

varchar(5)

NULL

Update Input Parameter flag 1 -Update Input Parameter option is selected. 0 -&gtUpdate Input Parameter option is not selected.

StaCRP_Itm_Compute_Cnt

decimal(10)

NULL

No of Parts considered for computation

StaCRP_Itm_Revise_Cnt

decimal(10)

NULL

no of parts for which the values May be revised.

StaCRP_Itm_Update_Cnt

decimal(10)

NULL

No of parts for which calculated parameters are updated in part admin

StaCRP_created_datetime

datetime

NULL

Date and Time of computation

StaCRP_created_by

varchar(30)

NULL

created by user

StaCRP_modified_by

varchar(30)

NULL

Modified by user

StaCRP_modified_datetime

datetime

NULL

Modified by Date and Time.

StaCRP_Timestamp

int

NULL

Time Stamp

StaCRP_Cons_ST

varchar(5)

NULL

Consider Stock Transfer.

StaCRP_Comp_Status

varchar(5)

NULL

Computation status.

Table Name STA_STADTL_PRT_STK_VALUE_INFO

Table Comment This table contains the stock value of a part when the previous analysis happened.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STA_STADTL_PRT_OU

int

NOT NULL

Part created OU

STA_STADTL_PRT_PRTNO

varchar(40)

NOT NULL

Part number.

STA_STADTL_PRT_NEW_STK_VALUE

decimal(28,8)

NULL

This column contains the new stock value of parts.

Table Name StA_StADtl_Stk_Analysis_Dtl

Table Comment Stores the Detail information of analysis Like parts included for analysis, Class of each part etc.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StADtl_XYZ_New_ClsTyp

varchar(5)

NULL

XYZ New Class Type of the Part

StADtl_XYZ_Curr_ClsTyp

varchar(5)

NULL

XYZ Current Class Type of the Part This has been maintained in Stock Analysis since it may be needed for the Graph

StADtl_ABC_New_ClsTyp

varchar(5)

NULL

ABC New Class Type of the Part

StADtl_FSN_Curr_ClsTyp

varchar(5)

NULL

FSN Current Class Type of the Part This has been maintained in Stock Analysis since it may be needed for the Graph

StADtl_FSN_New_ClsTyp

varchar(5)

NULL

FSN New Class Type of the Part

StADtl_VED_Curr_ClsTyp

varchar(5)

NULL

VED Current Class Type of the Part This has been maintained in Stock Analysis since it may be needed for the Graph

StADtl_Analysis_No

varchar(40)

NOT NULL

Analysis Number

StADtl_OUInstance

int

NOT NULL

Analysis Created OU

StADtl_ABC_Curr_ClsTyp

varchar(5)

NULL

ABC Current Class Type of the Part This has been maintained in Stock Analysis since it may be needed for the Graph

StADtl_Location

varchar(10)

NOT NULL

Location

StADtl_Part_No

varchar(40)

NOT NULL

Part Number

StADtl_Part_Crt_OU

int

NOT NULL

Created OU of the Part

Table Name Sta_StaFSNDtl_FSN_Anly_Dtl

Table Comment To store parts details for each FSN analysis.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaFSNDtl_OUInstance

int

NOT NULL

Ou Instance where Analysis is performed.

StaFSNDtl_Analysis_No

varchar(40)

NOT NULL

Analysis Document No

StaFSNDtl_Part_No

varchar(40)

NOT NULL

Analyzed PArt Number

StaFSNDtl_Part_Pln_OU

int

NOT NULL

Part Planning Ou ( updated from Part Admin)

StaFSNDtl_Part_Crt_OU

int

NULL

Part created Ou (Updated from Part Admin]

StaFSNDtl_AvgStay

numeric(28,8)

NULL

Average Stay of the particular Part in the selected period. ans calculated as Cumulative Inv Holding Days/(Total Receipt qty + Opening Balance qty)

STAFSNDTL_AVGSTAY_INPERC

numeric(28,8)

NULL

Average Stay in percentage

StaFSNDtl_Cum_AvgStay

numeric(28,8)

NULL

Cumulative value of Average stay

StaFSNDtl_Cum_AvgStay_InPerc

numeric(28,8)

NULL

Cumulative Average stay in Percentage

StaFSNDtl_AvgStay_FSN

varchar(5)

NULL

Average stay Class . It may be be F, S or N

StaFSNDtl_Cons_Rate

numeric(28,8)

NULL

Total Quantity Consumed over the period. and is calculated as ( Issued Quantity-Returned Quantity)/Inventory Holding Days

StaFSNDtl_Cons_Rate_InPerc

numeric(28,8)

NULL

Consumption Rate in Percentage

StaFSNDtl_Cum_Cons_Rate

numeric(28,8)

NULL

Cumulative Consumption Rate

StaFSNDtl_Cum_CRate_InPerc

numeric(28,8)

NULL

Cumulative Consumption rate in Percentage

StaFSNDtl_Cons_Rate_FSN

varchar(5)

NULL

Consumption rate Class . It may be F, S or N

StaFSNDtl_Curr_StkValue

numeric(28,8)

NULL

Current Stock Value in the inventory

StaFSNDtl_Curr_ClassType

varchar(5)

NULL

Existing Class type Which is updated through previous analysis.

StaFSNDtl_New_ClassType

varchar(5)

NULL

New class which is calculated from Average stay class and Consumption Rate class.

STAFSNDTL_STK_QTY

numeric(28,8)

NULL

Current Inventory Stock Qty.

STAFSNDTL_STK_UOM

varchar(15)

NULL

Inventory Stock UOM.

StaFSNDtl_New_StkValue

numeric(28,8)

NULL

New Stock Value.

Table Name StA_StAHdr_Stk_Analysis_Hdr

Table Comment Stock analysis header table. Stores each analysis Details. These Information are used in Graph and Report generation

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StAHdr_OUInstance

int

NOT NULL

Analysis Created OU

StAHdr_Analysis_No

varchar(40)

NOT NULL

Analysis Number

StAHdr_ABC_Analysis_Type

varchar(5)

NULL

This will have the following values Y- If the Analysis is simulated based on ABC N- If the Analysis is simulated not based on ABC

StAHdr_XYZ_Analysis_Type

varchar(5)

NULL

This will have the following values Y- If the Analysis is simulated based on XYZ N- If the Analysis is simulated not based on XYZ

StAHdr_FSN_Analysis_Type

varchar(5)

NULL

This will have the following values Y- If the Analysis is simulated based on FSN N- If the Analysis is simulated not based on FSN

StAHdr_VED_Analysis_Type

varchar(5)

NULL

This will have the following values Y- If the Analysis is simulated based on VED N- If the Analysis is simulated not based on VED

StAHdr_All_ClsTyp_Flag

varchar(5)

NULL

Stores the analysis type combination.

StAHdr_Analysis_Level

varchar(5)

NULL

This will have the following value WH - WareHouse LOC - Location ALL - Across Locations

StAHdr_Planned_By

varchar(30)

NULL

Planned By Employee Code

StAHdr_Location

varchar(10)

NULL

Location for which the Analysis done

StAHdr_WareHouse_OU

int

NULL

OUInstance of the WareHouse for which analysis done

StAHdr_WareHouse_Id

varchar(10)

NULL

WareHouse considered for Analysis

StAHdr_Part_Category

varchar(25)

NULL

Part Category considered for the analysis

StAHdr_Part_Group

varchar(25)

NULL

Part Group considered for Analysis

StAHdr_PrtTyp_All_Flag

varchar(5)

NULL

This will have the following values Y - if All Part Types considered for Analysis N - if not All Part Types considered for Analysis

StAHdr_PrtTyp_RM_Flag

varchar(5)

NULL

This will have the following values Y - if Raw Material is considered for Analysis N - if Raw Material is not considered for Analysis

StAHdr_PrtTyp_Tool_Flag

varchar(5)

NULL

This will have the following values Y - if Tool is considered for Analysis N - if Tool is not considered for Analysis

StAHdr_PrtTyp_Kit_Flag

varchar(5)

NULL

This will have the following values Y - if Kit is considered for Analysis N - if Kit is not considered for Analysis

StAHdr_PrtTyp_Exp_Flag

varchar(5)

NULL

This will have the following values Y - if Expendable is considered for Analysis N - if Expendable is not considered for Analysis

StAHdr_PrtTyp_Comp_Flag

varchar(5)

NULL

This will have the following values Y - if Component is considered for Analysis N - if Component is not considered for Analysis

StAHdr_PrtTyp_Cons_Flag

varchar(5)

NULL

This will have the following values Y - if Consumable is considered for Analysis N - if Consumable is not considered for Analysis

StAHdr_PrtTyp_Misc_Flag

varchar(5)

NULL

This will have the following values Y - if Miscellaneous is considered for Analysis N - if Miscellaneous is not considered for Analysis

StAHdr_PartType_Flag

varchar(25)

NULL

This will have the concatenated value of all the Part Types selected for the Analysis Ex: if Tool and Kit are selected then NNYYNNNN

StAHdr_Expense_Type

varchar(25)

NULL

This will have the following values CAP - Capital REV - Revenue

StAHdr_Period_Type

varchar(5)

NULL

This will have the following values FY - Financial Year FP - Financial Period GEN - General

StAHdr_Financial_Year

varchar(40)

NULL

Financial Year considered for the Analysis

StAHdr_Financial_Period

varchar(40)

NULL

Financial Period considered for the Analysis

StAHdr_Analyze_From_Date

datetime

NULL

Analysis From Date

StAHdr_Analyze_To_Date

datetime

NULL

Analysis To Date

StAHdr_Upd_Flag

varchar(5)

NULL

update status

StAHdr_Remarks

varchar(255)

NULL

Remarks

StAHdr_Created_By

varchar(30)

NULL

Created By User

StAHdr_Created_DateTime

datetime

NULL

Created Date

StAHdr_Timestamp

int

NULL

Timestamp

STAHDR_ANALYSIS_STATUS

varchar(5)

NULL

Stores the status of the analysis.

STAHDR_CONSIDER_ST

varchar(5)

NULL

Stores whether to consider Stock Transfer for analysis.

Table Name StA_StAOpt_Option_Settings

Table Comment Stores the cut of values for part classification , in option settings Page.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StAOpt_OUInstance

int

NOT NULL

OUInstance

StAOpt_Option_Id

numeric(9)

NOT NULL

Option ID

StAOpt_Opt_Status

varchar(5)

NULL

Status I -> InActive A -> Active Row with active status is considered for Computations

StAOpt_A_Cls_Perc

decimal(28,8)

NULL

Cut of Value in percentage for A Class Parts

StAOpt_B_Cls_Perc

varchar(30)

NULL

Cut of Value in percentage for B Class Parts

StAOpt_C_Cls_Perc

decimal(28,8)

NULL

Cut of Value in percentage for C Class Parts

StAOpt_F_Cls_AvgSty_Perc

decimal(28,8)

NULL

Cut of Value in percentage for F Class Parts’ Average Stay

StAOpt_S_Cls_AvgSty_Perc

decimal(28,8)

NULL

Cut of Value in percentage for S Class Parts’ Average Stay

StAOpt_N_Cls_AvgSty_Perc

decimal(28,8)

NULL

Cut of Value in percentage for N Class Parts’ Average Stay

StAOpt_F_Cls_CnsRate_Perc

decimal(28,8)

NULL

Cut of Value in percentage for F Class Parts’ Consumption Rate

StAOpt_S_Cls_CnsRate_Perc

decimal(28,8)

NULL

Cut of Value in percentage for S Class Parts’ Consumption Rate

StAOpt_N_Cls_CnsRate_Perc

decimal(28,8)

NULL

Cut of Value in percentage for N Class Parts’ Consumption Rate

StAOpt_X_Cls_Perc

decimal(28,8)

NULL

Cut of Value in percentage for X Class Parts

StAOpt_Y_Cls_Perc

decimal(28,8)

NULL

Cut of Value in percentage for Y Class Parts

StAOpt_Z_Cls_Perc

decimal(28,8)

NULL

Cut of Value in percentage for Z Class Parts

StAOpt_PrtFlt_Allow_Flag

varchar(5)

NULL

This will have the following value A - Allow NA - Not Allow

StAOpt_ExpTypPrts_ValMet

varchar(5)

NULL

This will have the following value SC - Standard Cost IC - Issue Cost AC - Acquisition Cost

StAOpt_Created_By

varchar(30)

NULL

Created By User

StAOpt_Created_Datetime

datetime

NULL

Created Date

StAOpt_Modified_By

varchar(30)

NULL

Modified by User

StAOpt_Modified_Datetime

datetime

NULL

Modified Date

StAOpt_Timestamp

int

NULL

Timestamp

STAOPT_EXCH_ORDER

varchar(3)

NULL

Stores whether exchange orders have to be considered for analysis.

STAOPT_LOAN_ORDER

varchar(3)

NULL

Stores whether loan orders have to be considered for analysis.

STAOPT_RENTAL_ORDER

varchar(3)

NULL

Stores whether rental orders have to be considered for analysis.

STAOPT_PACK_SLIP

varchar(3)

NULL

Stores whether pack slip issues have to be considered for analysis.

STAOPT_UNPLND_TRAN

varchar(3)

NULL

Stores whether unplanned transactions have to be considered for analysis.

Table Name StA_StAPrm_Parameter_Dtl

Table Comment Stores Meta Datas used in various Pages of Stock analysis Activity

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StAPrm_ComponentName

varchar(20)

NOT NULL

Component name of Stock Analysis Acitvity BASSTOCKANLY

StAPrm_ParamCategory

varchar(10)

NOT NULL

Various Categories of Parameters. Combo - the Values loaded in combo Text  - Value loaded in TExt bo

StAPrm_ParamType

varchar(25)

NOT NULL

Parameter Type. Eg. In Lead time Uom Combo  , the parameters with ’LEADTIMEUOM’ as Parameter Tye will be loaded.

StAPrm_ParamCode

varchar(5)

NOT NULL

Parameter Code Code is assigned to each Parameter

StAPrm_ParamDesc

varchar(80)

NULL

Parameter description. This will be shown in the screen.

StAPrm_Langid

int

NULL

Language Id. Depending on this the language differs. For example language id 1 shows the parameter description in English

StAPrm_SortBy

numeric(9)

NULL

the Sort by Column.

StAPrm_CreationDate

datetime

NULL

Created date time.

Table Name Sta_StaRprt_Repl_Part_Dtl

Table Comment Stores the details of part, their Replenishment parameters etc

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaRPrt_Compute_Seq_no

int

NOT NULL

Sequence Number.

StaRPrt_Loc_StkAdmn_Ou

int

NOT NULL

Location Ou Instance

StaRPrt_Warehouse_no

varchar(10)

NOT NULL

Warehouse Id

StaRPrt_Part_no

varchar(40)

NOT NULL

Part Number

StaRPrt_Part_Pln_Ou

int

NOT NULL

Part Planned OU Instance. Updated from Part admin.

StaRPrt_Part_Crt_Ou

int

NULL

Part Created ou.

StaRPrt_Reorder_Qty

numeric(28,8)

NULL

Calculated Re order qty

StaRPrt_Reorder_Level

numeric(28,8)

NULL

Calculated Reorder Level. This is the Min Qty which will be updated in Part admin.

StaRPrt_Safety_Stock

numeric(28,8)

NULL

Safety Stock

StaRPrt_Update_flag

varchar(5)

NULL

will have   Q, L, S, M Combinations    ’ Q’ - For Reorder Qty Updation for part         ’L’ - For Reorder Level Updation for part         ’S’ - For SafetyStock Updation for part         ’M’ - For the Min Qty for Min-Max is checked     in the update option cluster

StaRPrt_LeadtimeUnit

varchar(5)

NULL

Lead time unit

StaRPrt_Leadtime

numeric(28,8)

NULL

Lead Time for each part

StaRPrt_Annual_Cons

decimal(28,8)

NULL

Annual Consumption of part

StaRPrt_Carrying_cost

decimal(28,8)

NULL

Carrying cost for the part

StaRPrt_Perorder_Cost

decimal(28,8)

NULL

Per order cost of the part

StaRPrt_service_level

numeric(28,8)

NULL

Service level of the part

Table Name Sta_StaSLF_Srv_Lvl_Factor

Table Comment has Meta data of Service Level Factor For all Possible Service Level Percentages

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaSLF_Service_Level

numeric(28,8)

NOT NULL

Service Level Percentage allowed is between 50 and 100

StaSLF_Service_Factor

numeric(28,8)

NULL

Service Level Factor corresponding to Service level. This Factor will used in Replenishment Parameter Calculations

STASLF_OUINSTANCE

int

NULL

OUInstance

Table Name Sta_StaSRP_Repln_Prm_Set

Table Comment Stores the various parameters specified in the Set Replenishment Parameters screen

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaSRP_Class

varchar(3)

NOT NULL

Will have A,B,C and V,E,D to specify parameters set for each of these class.

StaSRP_Anul_Ord_Cost

decimal(28,8)

NULL

Annual Ordering cost entered

StaSRP_Anul_Ord_Count

numeric(28,8)

NULL

Annual Order Count entered.

StaSRP_CryCost_Pct_StdPr

decimal(28,8)

NULL

Carrying cost in Percentage o Standard Price

StaSRP_From_date

datetime

NULL

From date entered.

StaSRP_To_Date

datetime

NULL

To date entered.

StaSRP_SrvLvl_Percent

numeric(28,8)

NULL

Service Level in Percent Entered.

StaSRP_Created_by

varchar(30)

NULL

Created by User

StaSRP_Created_Datetime

datetime

NULL

Created Date and Time

StaSRP_Modified_By

varchar(30)

NULL

Modified by User

StaSRP_Modified_Datetime

datetime

NULL

Modified Date and time

StaSRP_Timestamp

int

NULL

Time Stamp

StaSRP_OUINSTANCE

int

NULL

OUInstance

Table Name STA_STASRP_REPLN_PRM_SET_HDR

Table Comment This table contains the replinishment set option details.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaSRP_OUINSTANCE

int

NULL

OU instance for which the option settings provided.

StaSRP_EXCH_ORDER

varchar(3)

NULL

Stores whether exchange orders have to be considered for compute replenishment.

StaSRP_LOAN_ORDER

varchar(3)

NULL

Stores whether loan orders have to be considered for compute replenishment.

StaSRP_RENTAL_ORDER

varchar(3)

NULL

Stores whether rental orders have to be considered for compute replenishment.

StaSRP_PACK_SLIP

varchar(3)

NULL

Stores whether pack slip issues have to be considered for compute replenishment.

StaSRP_UNPLND_TRAN

varchar(3)

NULL

Stores whether unplanned transactions have to be considered for compute replenishment.

StaSRP_CONSDR_AOG_PO

varchar(5)

NULL

Stores whether AOG purchase orders have to be considered for lead time calculation.

Table Name Sta_StaVEDDtl_VED_Anly_Dtl

Table Comment To Store VED Analysis output

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaVEDDtl_OUInstance

int

NOT NULL

Ou Instance

StaVEDDtl_Analysis_No

varchar(40)

NOT NULL

Document Number

StaVEDDtl_Part_No

varchar(40)

NOT NULL

Analysis document Number

StaVEDDtl_Part_Pln_OU

int

NOT NULL

Part planning Ou

StaVEDDtl_Part_Crt_OU

int

NULL

Part created Ou

StaVEDDtl_Curr_StkValue

numeric(28,8)

NULL

Current Sock Value

StaVEDDtl_Curr_ClassType

varchar(5)

NULL

VED Class type of part This will be updated When analysis happens on particular part

Table Name Sta_StaXYZDtl_XYZ_Anly_Dtl

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

StaXYZDtl_OUInstance

int

NOT NULL

Created Ou

StaXYZDtl_Analysis_No

varchar(40)

NOT NULL

Analysis No (Document no)

StaXYZDtl_Part_No

varchar(40)

NOT NULL

Analyzed Part No

StaXYZDtl_Part_Pln_OU

int

NOT NULL

Part Plan Ou

StaXYZDtl_Part_Crt_OU

int

NULL

Part created Ou

StaXYZDtl_Curr_StkValue

numeric(28,8)

NULL

Current Stock Value

StaXYZDtl_Cum_Value

numeric(28,8)

NULL

Cumulative Consumption Value

StaXYZDtl_Value_InPerc

numeric(28,8)

NULL

Consumption value in Percentage

StaXYZDtl_Cum_Value_InPerc

numeric(28,8)

NULL

Cumulative Consumption value in percentage

StaXYZDtl_Curr_ClassType

varchar(5)

NULL

Existing Class type

StaXYZDtl_New_ClassType

varchar(5)

NULL

Computed class type