Physical Inventory And Cycle Count

Physical Inventory & Cycle Count

Table Name Picc_CcAccHst_Accuracy_Hist

Table Comment This table will store class level accuracy history for the warehouse
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcAccHst_OUInstance	decimal(10)	NOT NULL	OU instance	Yes	No
CcAccHst_Wh_Ou	decimal(10)	NOT NULL	Warehouse OU.	Yes	No
CcAccHst_Wh_No	varchar(10)	NOT NULL	Warehouse Number.	Yes	No
CcAccHst_Class_Type	varchar(5)	NOT NULL	Class Type.	Yes	No
CcAccHst_SysLineNo	decimal(10)	NOT NULL	Sys Line No.	Yes	No
CcAccHst_Old_Accuracy	decimal(28,8)	NULL	Current Accuracy that was there.	No	No
CcAccHst_New_Accuracy	decimal(28,8)	NULL	As On Date.	No	No
CcAccHst_Sheet_Ou	decimal(28,8)	NULL	New Accuracy got set by this sheet ou.	No	No
CcAccHst_Sheet_No	varchar(40)	NULL	New Accuracy got set by this sheet.	No	No
CcAccHst_Old_Cnt_Interval	decimal(10)	NULL	Old Count Interval.	No	No
CcAccHst_New_Cnt_Interval	decimal(10)	NULL	New Count Interval.	No	No
CcAccHst_Created_By	varchar(35)	NULL	Created By.	No	No
CcAccHst_Created_Datetime	datetime	NULL	Created Date and Time.	No	No

Table Name Picc_CcOpt_CC_Options_Set

Table Comment This table allows you to store the set options for cycle counting.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcOpt_OUInstance	decimal(10)	NOT NULL	ouinstance	Yes	No
CcOpt_Class_Set	varchar(5)	NOT NULL	The class that belongs to the selected classification method.	Yes	No
CcOpt_Option_Id	decimal(10)	NOT NULL	Option ID	Yes	No
CcOpt_SysQty_Display	varchar(5)	NULL	to specify whether to show or hide the system inventory record of the part. The system provides the options ”Show system quantity” and “Do not show system quantity”	No	No
CcOpt_ShtLvl_SysQty	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “System Quantity display” setting at the user level. Select “No” otherwise	No	No
CcOpt_Recnt_Reqd	varchar(5)	NULL	to specify whether recount is mandatory or not. The system displays “Required” by default. 1.Select “Required”, if you wish to set recount as mandatory. If recount is made mandatory, parts will be unfreezed automatically only after count or recount results are authorized. 2. Select “Not Required”, if you do not wish to set recount as mandatory. If recount is not mandatory, parts will be unfreezed automatically as soon as the count results are authorized.	No	No
CcOpt_ShtLvl_ReCnt	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “Recount Mandatory” setting at the user level. Select “No” otherwise	No	No
CcOpt_ZeroQty	varchar(5)	NULL	to specify whether to “include” or “exclude” zero quantity stock in the cycle count.	No	No
CcOpt_ShtLvl_ZeroQty	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “Zero Qty Parts” setting at user level. Select “No” otherwise.	No	No
CcOpt_CntEntMode	varchar(5)	NULL	to specify whether to enter count results for all the items or only for the discrepant items. The system lists “All Stock” and “Discrepant Stock” as options	No	No
CcOpt_ShtLvl_CntEntMode	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “Count Entry Mode” setting at the user level. Select “No” otherwise.	No	No
CcOpt_StkCorr_NumType	varchar(5)	NULL	numbering type for the stock correction transaction	No	No
CcOpt_AdjVal_Tol	decimal(28,2)	NULL	The minimum tolerance value, below or equal to which adjustment is not required (Integer).	No	No
CcOpt_Created_By	varchar(35)	NULL	The name of the user who set the options.	No	No
CcOpt_Created_Datetime	datetime	NULL	The date on which the options were set.	No	No
CcOpt_Modified_By	varchar(35)	NULL	The name of the user who last modified the options..	No	No
CcOpt_Modified_Datetime	datetime	NULL	The date on which the options were last modified..	No	No
CcOpt_Timestamp	decimal(10)	NULL	Time Stamp.	No	No
CcOpt_Status	varchar(5)	NULL	Status.	No	No
CCOPT_RNDPART_MODIFY	varchar(5)	NULL	set the field to Allowed, to allow the modification of parts selected randomly. Select Not Allowed otherwise	No	No
CCOPT_RNDPART_CLSPLN	varchar(5)	NULL	set the field to To be Considered to consider the parts available in also closed plan for random selection. Select Not to be Considered, to omit parts available in closed plan for random selection	No	No

Table Name Picc_CcPLCi_Plan_CntInt_Dtl

Table Comment This tables enables you to store the details of the CC plan accuracy setting values.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcPLCi_Desired_Accuracy	decimal(28,8)	NULL	The desired accuracy level of the part	No	No
CcPLCi_Current_Accuracy	decimal(28,8)	NULL	The current accuracy level of the part during the cycle count.	No	No
CcPLCi_Count_Interval	decimal(10)	NULL	The number of days after which the cycle count is repeated for the part	No	No
CcPLCi_OUInstance	decimal(10)	NOT NULL	Location Id where the CC Plan is created.	Yes	Yes
CcPLCi_Class_Type	varchar(5)	NOT NULL	The class to which the part in the CC plan belongs, which could be “A”, “B”, “C” or “V”, “E”, “D”.	Yes	No
CcPLCi_CC_Plan_No	varchar(40)	NOT NULL	Cycle Count Plan No.	Yes	Yes

Table Name Picc_CcPLHdr_CC_Plan_Hdr

Table Comment This table allows you to store the details of the CC plan
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcPLHdr_OUInstance	decimal(10)	NOT NULL	Location Id where the CC Plan is created.	Yes	No
CcPLHdr_CC_Plan_No	varchar(40)	NOT NULL	Cycle Count Plan No.	Yes	No
CcPLHdr_Plan_Desc	varchar(150)	NULL	The textual description of the cycle count plan	No	No
CcPLHdr_Plan_Status	varchar(5)	NULL	The status of the CC plan, which could be one of the following: 1. Draft: When the cycle count plan is created and certain mandatory details are yet to be provided. 2.Fresh: When the cycle count plan is created and all the mandatory details have been provided. 3.Closed: When all the cycle count sheets derived from this plan are either closed, short closed or cancelled and when all the sheets that are partially dependent on this plan are completed as far as parts from this plan are concerned. 4.Cancelled: When the cycle count plan is cancelled. 5.Authorized: When the cycle count plan is authorized.	No	No
CcPLHdr_Start_Date	datetime	NULL	The starting date of CC plan.	No	No
CcPLHdr_User_Status	varchar(25)	NULL	The user defined status of the CC plan.	No	No
CcPLHdr_Plan_Level	varchar(5)	NULL	The level at which the cycle count plan was generated, which could be ‘Warehouse or Warehouse - Zone level..	No	No
CcPLHdr_Category	varchar(25)	NULL	The unique code identifying the predefined category in the system	No	No
CcPLHdr_Planned_By	varchar(35)	NULL	The name of the user who created the CC plan.	No	No
CcPLHdr_Plan_Group	varchar(25)	NULL	A unique number identifying the plan group	No	No
CcPLHdr_Warehouse_Ou	decimal(10)	NULL	Warehouse OU.	No	No
CcPLHdr_Warehouse_Id	varchar(10)	NULL	The warehouse for which the cycle count plan was generated	No	No
CcPLHdr_Zone_Id	varchar(10)	NULL	Zone ID(The number that identifies the zone for which the cycle count plan was generated.)	No	No
CcPLHdr_Class	varchar(5)	NULL	The class to which the part in the CC plan belongs, which could be “A”, “B”, “C” or “V”, “E”, “D”.	No	No
CcPLHdr_Part_Cat	varchar(25)	NULL	The user defined category to which the part belongs.	No	No
CcPLHdr_Part_Type	varchar(5)	NULL	The type of the part which could be "Raw Material”, “Component”, “Expendable”, “Tool”, “Consumable”, “Kit” or "Miscellaneous	No	No
CcPLHdr_Part_Group	varchar(40)	NULL	Part Group ( the unique group code which is created based on part purpose..).	No	No
CcPLHdr_User_Def_1	varchar(25)	NULL	Any other additional details pertaining to the CC plan.	No	No
CcPLHdr_User_Def_2	varchar(25)	NULL	Any other additional details pertaining to the CC plan.	No	No
CcPLHdr_Remarks	varchar(255)	NULL	Any additional remarks pertaining to the CC plan.	No	No
CcPLHdr_FileName	varchar(50)	NULL	The name of the file used as reference for the cycle count plan	No	No
CcPLHdr_Auth_By	varchar(35)	NULL	The name of the user who authorized the CC plan	No	No
CcPLHdr_Auth_Datetime	datetime	NULL	The date on which the CC plan was authorized.	No	No
CcPLHdr_Closing_Comments	varchar(255)	NULL	Closing Comments.	No	No
CcPLHdr_Created_By	varchar(35)	NULL	The name of the user who created the CC plan.	No	No
CcPLHdr_Created_Datetime	datetime	NULL	The date on which the CC plan was created.	No	No
CcPLHdr_Modified_By	varchar(35)	NULL	The name of the user who last modified the CC plan.	No	No
CcPLHdr_Modified_Datetime	datetime	NULL	The date on which the CC plan was last modified.	No	No
CcPLHdr_Timestamp	decimal(10)	NULL	Time Stamp	No	No
CCPLHDR_PART_SAMPLESIZE	decimal(10)	NULL	The number of various parts to be considered for random selection from the warehouse.	No	No
CCPLHDR_PART_SELMODE	varchar(5)	NULL	The selection mode of the part from the warehouse which could be “Manual” or “Random”..	No	No
CCPLHDR_FROM_CMAV	decimal(28,8)	NULL	The starting value in the range of the part values..	No	No
CCPLHDR_TO_CMAV	decimal(28,8)	NULL	The ending value in the range of the part values..	No	No
CCPLHDR_LASTCC_DATE	datetime	NULL	Date	No	No

Table Name Picc_CcPLHst_PLStat_History

Table Comment This table allows you to store the change in statuses of the CC plan. You can store the old and the new status of the CC plan, the date on which the status was changed, the person who changed the status and the reason for the status change
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcPLHst_Changed_On	datetime	NOT NULL	The date on which the status was changed.	Yes	No
CcPLHst_To_Status	varchar(5)	NOT NULL	The current status of the CC plan.	Yes	No
CcPLHst_Changed_By	varchar(35)	NULL	The name of the user who changed the status.	No	No
CcPLHst_Comments	varchar(255)	NULL	Any comments pertaining to the status change.	No	No
CcPLHst_OUInstance	decimal(10)	NOT NULL	Location Id where the CC Plan is created.	Yes	Yes
CcPLHst_From_Status	varchar(5)	NOT NULL	The old status of the CC plan	Yes	No
CcPLHst_CC_Plan_No	varchar(40)	NOT NULL	Cycle Count Plan No.	Yes	Yes

Table Name Picc_CcPLPrt_Plan_Part_Dtl

Table Comment This table allows you to store the part CC plan
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcPLPrt_Part_No	varchar(40)	NULL	The number that identifies the part.	No	No
CcPLPrt_Part_Crt_Ou	decimal(10)	NULL	Part Created OU.	No	No
CcPLPrt_LineLvl_Status	varchar(5)	NULL	Line Level Status.	No	No
CcPLPrt_Class_Type	varchar(5)	NULL	The class to which the part in the CC plan belongs, which could be “A”, “B”, “C” or “V”, “E”, “D”.	No	No
CcPLPrt_Timestamp	decimal(10)	NULL	Time Stamp.	No	No
CcPLPrt_OUInstance	decimal(10)	NOT NULL	Location Id where the CC Plan is created.	Yes	Yes
CcPLPrt_Pln_DisplayLine_No	decimal(10)	NULL	Display Line Number.	No	No
CcPLPrt_CC_Plan_No	varchar(40)	NOT NULL	Cycle Count Plan No.	Yes	Yes
CcPLPrt_Pln_SysLine_No	decimal(10)	NOT NULL	Sys Line Number.	Yes	No

Table Name Picc_CCPrm_Parameter_Dtl

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
CCPrm_ComponentName	varchar(80)	NOT NULL	Component Code.	Yes	No
CCPrm_ParamCategory	varchar(25)	NOT NULL	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes	No
CCPrm_ParamType	varchar(25)	NOT NULL	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes	No
CCPrm_ParamCode	varchar(5)	NOT NULL	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component.	Yes	No
CCPrm_Langid	decimal(10)	NOT NULL	Language id. This is the language id of the record..	Yes	No
CCPrm_ParamDesc	varchar(80)	NULL	Description of the Param Code.	No	No
CCPrm_sort_by	decimal(10)	NULL	The order in which the values are populated.	No	No
CCPrm_CreationDate	datetime	NULL	Created Date	No	No

Table Name Picc_CcPrm_WhClassLvl_Param

Table Comment Warehouse-class level CC execution parameters like ’Desired Accuracy’, ’Current Accuracy’ and the computed ’Count Interval’ are stored here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcPrm_OUInstance	decimal(10)	NOT NULL	Location Id where the CC execution parameters are set.	Yes	No
CcPrm_Wh_Ou	decimal(10)	NOT NULL	Warehouse location.	Yes	No
CcPrm_Wh_No	varchar(10)	NOT NULL	Warehouse No for which class level accuracy is set.	Yes	No
CcPrm_Class_Type	varchar(5)	NOT NULL	This will have the part ’Class’.	Yes	No
CcPrm_Option_Id	decimal(10)	NOT NULL	Option ID.	Yes	No
CcPrm_Option_Status	varchar(5)	NULL	Option Status.	No	No
CcPrm_Init_Accuracy	decimal(28,8)	NULL	This indicates the Initial stock accuracy level of the parts of a class in a warehouse.	No	No
CcPrm_Desired_Accuracy	decimal(28,8)	NULL	The desired accuracy percentage for the item of the particular class (Decimal). . Ensure this value is between 1 and 100.	No	No
CcPrm_Current_Accuracy	decimal(28,8)	NULL	Current Accuracy.	No	No
CcPrm_Count_Interval_InDays	decimal(10)	NULL	Count Interval IN Days.	No	No
CcPrm_Created_By	varchar(35)	NULL	Created BY.	No	No
CcPrm_Created_Datetime	datetime	NULL	Created Date and Time.	No	No
CcPrm_Modified_By	varchar(35)	NULL	Modified By.	No	No
CcPrm_Modified_Datetime	datetime	NULL	Modified Date and Time.	No	No
CcPrm_Timestamp	decimal(10)	NULL	Time Stamp.	No	No

Table Name PICC_CCPRTCNT_PART_CNT_DTL

Table Comment this table used to store the information about part count results
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CCPRTCNT_WH_OU	decimal(10)	NOT NULL	Warehouse OU.	Yes	No
CCPRTCNT_WH_ID	varchar(10)	NOT NULL	Warehouse ID.	Yes	No
CCPRTCNT_PART_CRT_OU	decimal(10)	NOT NULL	Part Created OU.	Yes	No
CCPRTCNT_PART_NO	varchar(40)	NOT NULL	Part Number.	Yes	No
CCPRTCNT_CLASS_TYPE	varchar(5)	NOT NULL	Class Type.	Yes	No
CCPRTCNT_NEXT_COUNT_DATE	datetime	NULL	Next Count Date.	No	No
CCPRTCNT_COUNT_INTERVAL	decimal(10)	NULL	Count Interval.	No	No
CCPRTCNT_LAST_SHEET_NO	varchar(40)	NULL	Last Sheet Number.	No	No

Table Name Picc_CcPrtCnt_Part_Count_Dtl

Table Comment this table used to store the information about part count results
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcPrtCnt_Wh_Ou	char(18)	NOT NULL	Warehouse OU.	Yes	No
CcPrtCnt_Wh_Id	varchar(10)	NOT NULL	Warehouse ID.	Yes	No
CcPrtCnt_Part_Crt_Ou	decimal(10)	NOT NULL	Part Created OU.	Yes	No
CcPrtCnt_Part_No	varchar(40)	NOT NULL	Part Number.	Yes	No
CcPrtCnt_Class_Type	varchar(5)	NOT NULL	Class Type.	Yes	No
CcPrtCnt_Next_Count_Date	datetime	NULL	Next Count Date.	No	No
CcPrtCnt_Count_Interval	decimal(10)	NULL	Count Interval.	No	No
CcPrtCnt_Last_Sheet_No	varchar(40)	NULL	Last Sheet Number.	No	No

Table Name Picc_CCQc_Quick_Code

Table Comment This table enables you to store quick codes details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CCQc_OUInstance	decimal(10)	NOT NULL	Quick Code OU.	Yes	No
CCQc_Type	varchar(25)	NOT NULL	type of quick code	Yes	No
CCQc_Quick_Code	varchar(25)	NOT NULL	The quick code that belongs to the selected quick code type or status.	Yes	No
CCQc_Desc	varchar(80)	NULL	The modified textual description of the quick code	No	No
CCQc_Status	varchar(5)	NULL	the status of the quick code, either “Active” or “Inactive”.	No	No
CCQc_CreatedDate	datetime	NULL	The date, in the specified date format, on which the quick code was created.	No	No
CCQc_Created_By	varchar(35)	NULL	The name of the user who created the quick code.	No	No
CCQc_ModifiedDate	datetime	NULL	The date, in the specified date format, on which the quick code was last modified.	No	No
CCQc_Modified_By	varchar(35)	NULL	The name of the user who last modified the quick code.	No	No
CCQc_Timestamp	decimal(10)	NULL	Time Stamp	No	No

Table Name Picc_CcShCR_CC_Count_Result

Table Comment This table allows you to store the count and recount results for the CC sheet. You can store details such as the name of the person who performed the counted or recounted the part in the sheet, date of recount, recount quantity, transaction UOM and any other additional remarks pertaining to the count or recount result.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcShCR_OUInstance	decimal(10)	NOT NULL	Location where the CC Sheet is created.	Yes	Yes
CcShCR_Sheet_No	varchar(40)	NOT NULL	Unique Cycle Counting Sheet No generated by the system.	Yes	Yes
CcShCR_Cr_SysLine_No	decimal(10)	NOT NULL	Count Result Sysline Number.	Yes	No
CcShCR_Sht_SysLine_No	decimal(10)	NOT NULL	Sheet Sysline Number.	No	No
CcShCR_Cr_Display_LineNo	decimal(10)	NULL	Count Result Display Line Number.	No	No
CcShCR_Part_Crt_Ou	decimal(10)	NULL	Part Created OU.	No	No
CcShCR_Part_No	varchar(40)	NULL	Part Number.	No	No
CcShCR_Part_Status	varchar(25)	NULL	Part Status..	No	No
CcShCR_Zone_Id	varchar(10)	NULL	The number that identifies the zone in the warehouse where the part is stored.	No	No
CcShCR_Bin_Id	varchar(10)	NULL	The number that identifies the bin in which the part is stored.	No	No
CcShCR_Cnt_Status	varchar(5)	NULL	The count status of the CC sheet	No	No
CcShCR_CntQty	decimal(28,2)	NULL	The counted quantity of parts.	No	No
CcShCR_CntQty_Uom	varchar(10)	NULL	Count Quantity in UOM.	No	No
CcShCR_CntQty_InStkUom	decimal(28,2)	NULL	Count Quantity in Stock UOM.	No	No
CcShCR_Counted_By	varchar(35)	NULL	The name of the user who counted the part.	No	No
CcShCR_Date_Of_Counting	datetime	NULL	The date on which the part was counted.	No	No
CcShCR_Counting_Remarks	varchar(255)	NULL	Any additional remark pertaining to the count results.	No	No
CcShCR_Recount_Qty	decimal(28,2)	NULL	The recounted quantity of parts.	No	No
CcShCR_Recount_QtyInStkUom	decimal(28,2)	NULL	ReCount Quantity in Stock UOM.	No	No
CcShCR_Recounted_By	varchar(35)	NULL	The name of the user who performed the recount.	No	No
CcShCR_Recount_Date	datetime	NULL	The date on which the part was recounted.	No	No
CcShCR_Recount_Remarks	varchar(255)	NULL	Any additional remark pertaining to the recount results.	No	No
CcShCR_System_Qty	decimal(28,2)	NULL	The quantity of parts available as per the system inventory record.	No	No
CcShCR_StkCorr_Ou	decimal(10)	NULL	Stock Correction OU.	No	No
CcShCR_StkCorr_No	varchar(40)	NULL	Stock Correction Number.	No	No
CcShCR_StkCorr_SysLine_No	decimal(10)	NULL	Stock Correction Sysline Number.	No	No
CcShCR_StkCorr_Qty_InStkUom	varchar(28)	NULL	Stock Correction Quantity in Stock UOM.	No	No
CcShCR_ValBasedAdj_Flag	varchar(5)	NULL	This indicates whether the total number of parts (in the sheet) for which counted/recounted qty and the system qty differs and the system qty got adjusted as a result of the "difference in value" exceeding the "Adjustment Value Tolerance" set.	No	No
CcShCR_NewPrt_Flag	varchar(5)	NULL	New Part Flag.	No	No
CcShCR_NewSts_Flag	varchar(5)	NULL	New Part Status Flag.	No	No
CcShCR_NwPrt_Cnt_RCnt_Flag	char(18)	NULL	New Part Count Flag.	No	No
CcShCR_NwSts_Cnt_RCnt_Flag	char(18)	NULL	New Part Recount Flag.	No	No
CcShCR_FileName	varchar(50)	NULL	File Name.	No	No
CcShCR_Created_By	varchar(35)	NULL	The name of the user who created the CC sheet.	No	No
CcShCR_Created_Datetime	datetime	NULL	The date on which the CC sheet was created.	No	No
CcShCR_Modified_By	varchar(35)	NULL	The name of the user who last modified the CC sheet.	No	No
CcShCR_Modified_Datetime	datetime	NULL	The date on which the CC sheet was last modified.	No	No
CcShCR_Timestamp	decimal(10)	NULL	Time Stamp.	No	No

Table Name Picc_CcShDtl_CC_Sheet_Dtl

Table Comment This table allows you to store &nbspthe details of the CC sheet
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcShDtl_OUInstance	decimal(10)	NOT NULL	Location where the CC Sheet is created.	Yes	Yes
CcShDtl_Sheet_No	varchar(40)	NOT NULL	Unique Cycle Counting Sheet No generated by the system.	Yes	Yes
CcShDtl_Sht_SysLine_No	decimal(10)	NOT NULL	SheetSys Line Number..	Yes	No
CcShDtl_CC_Plan_No	varchar(40)	NULL	Cycle Count Plan Number.	No	No
CcShDtl_Pln_SysLine_No	decimal(10)	NULL	CC Plan SysLine Number.	No	No
CcShDtl_Part_Crt_Ou	decimal(10)	NULL	Part Created OU.	No	No
CcShDtl_Part_No	varchar(40)	NULL	Part Number.	No	No
CCShDtl_Part_Status	varchar(40)	NULL	Part Status.	No	No
CcShDtl_Freeze_Status	varchar(5)	NULL	Freezed = FRZ UnFreezed - UNFRZ.	No	No
CcShDtl_UnFreeze_Date	datetime	NULL	Unfreeze Date.	No	No
CcShDtl_SysUnfrz_Flag	varchar(5)	NULL	If the Sheet Part can be allowed to be unfreezed, this will be set to ’Yes’. Otherwise, it will be ’No’.	No	No
CcShDtl_Class_Type	varchar(5)	NULL	Class Type.	No	No
CcShDtl_NewPrt_Flag	varchar(5)	NULL	New Part Flag.	No	No
CcShDtl_NewSts_Flag	varchar(5)	NULL	New Status Flag.	No	No

Table Name Picc_CcShHdr_CC_Sheet_Hdr

Table Comment This table allows you to store the details of the CC sheet
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcShHdr_OUInstance	decimal(10)	NOT NULL	Location where the CC Sheet is created..	Yes	No
CcShHdr_Sheet_No	varchar(40)	NOT NULL	Unique Cycle Counting Sheet No generated by the system.	Yes	No
CcShHdr_Sheet_Desc	varchar(80)	NULL	The textual description of the cycle count sheet.	No	No
CcShHdr_Sheet_Status	varchar(5)	NULL	The status of the CC sheet.	No	No
CcShHdr_User_Status	varchar(25)	NULL	User Status.	No	No
CcShHdr_Basis	varchar(25)	NULL	The basis of the CC sheet, which is either “Based on Overdue” or “Based on Plan”.	No	No
CcShHdr_Warehouse_Ou	decimal(10)	NULL	Warehouse OU.	No	No
CcShHdr_Warehouse_Id	varchar(10)	NULL	The warehouse for which the cycle count sheet was generated.	No	No
CcShHdr_Zone_Id	varchar(10)	NULL	The number that identifies the zone for which the CC sheet is created.	No	No
CcShHdr_CC_Plan_No	varchar(40)	NULL	The plan from which the CC sheet was generated.	No	No
CcShHdr_SysQty_Display	varchar(5)	NULL	System Qty Display.	No	No
CcShHdr_Recnt_Reqd	varchar(5)	NULL	Recount Required status.	No	No
CcShHdr_Overdue_Date	datetime	NULL	Over Due Date.	No	No
CcShHdr_Count_Date	datetime	NULL	The date on which the part was counted	No	No
CcShHdr_ZeroQty_Parts	varchar(5)	NULL	Zero Qty Parts.	No	No
CCShHdr_ShortClose_Comments	varchar(255)	NULL	Short Close Comments.	No	No
CcShHdr_Class_Type	varchar(5)	NULL	The class to which the CC sheet belongs, which could be "A", "B", "C" or "V", "E", "D"	No	No
CcShHdr_Part_Type	varchar(5)	NULL	The type of the part, which could be "Raw Material", "Tool", "Kit", "Expandable", "Component", "Consumable" or "Miscellaneous".	No	No
CcShHdr_Part_Group	varchar(40)	NULL	The group to which the part belongs.	No	No
CcShHdr_Part_Cat	varchar(25)	NULL	part category.	No	No
CcShHdr_Freeze_Date	datetime	NULL	Freeze Date..	No	No
CcShHdr_UnFreeze_Date	datetime	NULL	UnFreeze Date.	No	No
CcShHdr_SysUnfrz_Flag	varchar(5)	NULL	If the Sheet can be allowed to be unfreezed, this will be set to ’Yes’. Otherwise, it will be ’No’.	No	No
CcShHdr_Tot_Parts	decimal(28,2)	NULL	This gives the count of part-part status covered in the sheet. When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
CcShHdr_Tot_Disc	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
CcShHdr_Tot_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result. When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored.	No	No
CcShHdr_Tot_CntBased_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result of the 1st counting process When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
CcShHdr_Tot_ReCntBased_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result of the 2nd time counting (i.e. recounting) process When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
CcShHdr_Tot_ValBased_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result of the "difference in value" exceeding the "Adjustment Value Tolerance" set. When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
CcShHdr_Confirmed_Datetime	datetime	NULL	CC Sheet Confirmed Datetime.	No	No
CcShHdr_Created_By	varchar(35)	NULL	The name of the user who created the CC sheet.	No	No
CcShHdr_Created_Datetime	datetime	NULL	The date on which the CC sheet was created.	No	No
CcShHdr_Modified_By	varchar(35)	NULL	The name of the user who last modified the CC sheet.	No	No
CcShHdr_Modified_Datetime	datetime	NULL	The date on which the CC sheet was last modified.	No	No
CcShHdr_Timestamp	decimal(10)	NULL	Time Stamp.	No	No
CcShHdr_CntEnt_Mode	varchar(5)	NULL	Count Entry Mode. This could have the following values - All Parts ,Discrepant Parts	No	No

Table Name Picc_CcShSrl_CntRslt_SrlLot

Table Comment This table allows you to store the serial and lot number details for the counted parts.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcShSrl_OUInstance	decimal(10)	NOT NULL	Location where the CC Sheet is created.	Yes	Yes
CcShSrl_Sheet_No	varchar(40)	NOT NULL	Unique Cycle Counting Sheet No generated by the system.	Yes	Yes
CcShSrl_Cr_SysLine_No	decimal(10)	NOT NULL	Count Result Sysline Number.	Yes	Yes
CcShSrl_SrlLot_Seq_No	decimal(10)	NOT NULL	Serial Lot Sequence Number.	Yes	No
CCSHSRL_SRLLOT_DISPSEQNO	decimal(10)	NOT NULL	serial or lot controlled parts sequence no.	No	No
CCSHSRL_PART_NO	varchar(40)	NULL	The number that identifies the part.	No	No
CCSHSRL_PART_CRT_OU	decimal(10)	NULL	ou of the part.	No	No
CcShSrl_Sys_Srl_No	varchar(40)	NULL	System Serial Number.	No	No
CCSHSRL_REF_SRL_NO	varchar(40)	NULL	The serial number issued by the manufacturer.	No	No
CcShSrl_Sys_Lot_No	varchar(40)	NULL	System Lot Number.	No	No
CCSHSRL_REF_LOT_NO	varchar(40)	NULL	The lot number issued by the manufacturer.	No	No
CcShSrl_Qty	decimal(28,2)	NULL	Quantity.	No	No
CcShSrl_Qty_InStkUom	decimal(28,2)	NULL	Quantity in Stock UOM.	No	No
CcShSrl_ReCnt_Flag	varchar(5)	NULL	Recount Flag.	No	No
CcShSrl_SysQty_InStkUom	decimal(28,2)	NULL	System Quantity in Stock UOM.	No	No
CcShSrl_Part_Condition	varchar(5)	NULL	Part Condition.	No	No
CCSHSRL_SRLLOT_TYPE	varchar(5)	NULL	The type of the serial number and lot number, which could be “Existing” or “New” for a part of type ”Component” or for a part which is “Shelf Life Controlled”. .	No	No
CCSHSRL_CERT_INFO_FLAG	varchar(5)	NULL	Indicates whether the certificate information is “Recorded”, “Not Recorded” or “Not Applicable” for a part.	No	No
CCSHSRL_CERTIFICATE_TYPE	varchar(25)	NULL	The type of certificate issued to the part..	No	No
CCSHSRL_CERTIFICATE_DATE	datetime	NULL	The date on which the certificate was issued..	No	No
CCSHSRL_CERTIFICATE_NO	varchar(40)	NULL	The code that identifies the certificate issued to the part..	No	No
CCSHSRL_CERT_AUTH_NO	varchar(40)	NULL	The code that identifies the authorization.	No	No
CCSHSRL_SYSTRACK_REF_NO	varchar(40)	NULL	The number used to track the certification details of the part.	No	No
CCSHSRL_WARRANTY_END_DATE	datetime	NULL	The date on which the warranty of the part lapses.	No	No
CCSHSRL_FILENAME	varchar(50)	NULL	The name of the file used for document reference that is associated to the cycle count plan..	No	No
CcShSrl_Trd_Partner_no	varchar(25)	NULL	The unique code identifying the trading partner, which could be supplier code or customer code.	No	No
CcShSrl_Trd_Partner_type	varchar(45)	NULL	trading partner could be "Customer" or"Supplier".	No	No

Table Name Picc_CcTol_CC_Tolerance_Set

Table Comment This table allows you to store the cycle count set options talerence value
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CcTol_OUInstance	decimal(10)	NOT NULL	ou instance.	Yes	Yes
CcTol_Class_Set	varchar(5)	NOT NULL	The class that belongs to the selected classification method.	Yes	Yes
CcTol_Class_Type	varchar(5)	NOT NULL	The class to which the part in the CC plan belongs, which could be “A”, “B”, “C” or “V”, “E”, “D”.	Yes	No
CcTol_Option_Id	decimal(10)	NOT NULL	Option ID.	Yes	Yes
CcTol_CntTol_InPerc	decimal(28,8)	NULL	The minimum adjustment tolerance level in percentage, below or equal to which no adjustment is required for the existing discrepancy (Integer).	No	No
CcTol_CntTol_InUnits	decimal(28,2)	NULL	The minimum adjustment tolerance level in units, below or equal to which no adjustment is required for the existing discrepancy (Integer)..	No	No
CcTol_ReCntTol_InPerc	decimal(28,8)	NULL	The minimum adjustment tolerance level, below or equal to which no recounting is required for the existing discrepancy (Integer).	No	No
CcTol_ReCntTol_InUnits	decimal(28,2)	NULL	The minimum adjustment tolerance level, below or equal to which no recounting is required for the existing discrepancy (Integer)..	No	No
CcTol_Status	varchar(5)	NOT NULL	Status.	No	No
CcTol_Modified_By	varchar(35)	NULL	The name of the user who last modified the options.	No	No
CcTol_Modified_Datetime	datetime	NULL	The date on which the options were last modified.	No	No

Table Name Picc_PiCR_PI_Count_Result

Table Comment This table allows you to store thecount and recount result details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiCR_Pi_Plan_No	varchar(40)	NOT NULL	PI Plan Number	Yes	Yes
PiCR_OUInstance	decimal(10)	NOT NULL	Location Id where the Physical Inventory Plan document is created.	Yes	Yes
PiCR_Cr_SysLine_No	decimal(10)	NOT NULL	SysLine Number.	Yes	No
PiCR_Tag_No	varchar(40)	NOT NULL	Tag Number.	Yes	No
PiCR_Part_No	varchar(40)	NOT NULL	Part Number.	Yes	No
PiCR_Part_Status	varchar(40)	NOT NULL	Part Status.	Yes	No
PiCR_Zone_Id	varchar(10)	NOT NULL	Zone ID.	Yes	No
PiCR_Tag_SysLine_No	decimal(10)	NULL	Tag Sysline Number.	No	No
PiCR_Cr_Display_No	decimal(10)	NULL	Count Result Display Number.	No	No
PiCR_Cr_Status	varchar(5)	NULL	Count Result Status.	No	No
PiCR_Part_Crt_Ou	decimal(10)	NULL	Part Created Ou.	No	No
PiCR_Bin_Id	varchar(10)	NULL	The number identifying the bin in the zone.	No	No
PiCR_SysQty_InStkUom	decimal(28,2)	NULL	System Quantity in Stock UOM.	No	No
PiCR_CntQty	decimal(28,2)	NULL	The counted quantity of parts.	No	No
PiCR_CntQty_Uom	varchar(10)	NULL	Count Quantity UOM.	No	No
PiCR_CntQty_InStkUom	decimal(28,2)	NULL	Count Quantity in Stock UOM.	No	No
PiCR_Counted_By	varchar(35)	NULL	The name of the user who performed the cycle count.	No	No
PiCR_Counted_Date	datetime	NULL	The date on which the cycle count was performed.	No	No
PiCR_Counting_Remarks	varchar(255)	NULL	Any additional information regarding the tag count or recount results.	No	No
PiCR_StkCorr_Ou	decimal(10)	NULL	Stock Correction OU.	No	No
PiCR_StkCorr_No	varchar(40)	NULL	Stock Correction Number.	No	No
PiCR_StkCorr_SysLine_No	decimal(10)	NULL	Sysline Number.	No	No
PiCR_StkCorr_Qty_InStkUom	decimal(28,2)	NULL	Stock Correction Quantity in Stock UOM.	No	No
PiCR_Recount_Qty	decimal(28,2)	NULL	The recounted quantity of parts.	No	No
PiCR_Recount_Qty_InStkUom	decimal(28,2)	NULL	Recount Quantity in Stock UOM.	No	No
PiCR_Recounted_By	varchar(35)	NULL	The name of the user who performed the recount.	No	No
PiCR_Recount_Date	datetime	NULL	The date on which the recount was performed.	No	No
PiCR_Recount_Remarks	varchar(255)	NULL	Any additional information regarding the tag count or recount results.	No	No
PiCR_NewPrt_Flag	varchar(5)	NULL	New Part Flag.	No	No
PiCR_NewSts_Flag	varchar(5)	NULL	New Status Flag.	No	No
PiCR_NwPrt_Cnt_RCnt_Flag	char(18)	NULL	New Part Count Recount Flag.	No	No
PiCR_NwSts_Cnt_RCnt_Flag	char(18)	NULL	New status Count Recount Flag.	No	No
PiCR_ValBasedAdj_Flag	varchar(5)	NULL	This indicates whether the total number of parts (in the sheet) for which counted/recounted qty and the system qty differs and the system qty got adjusted as a result of the "difference in value" exceeding the "Adjustment Value Tolerance" set.	No	No
PiCR_Created_By	varchar(35)	NULL	Created By.	No	No
PiCR_Created_Datetime	datetime	NULL	Created Date and Time.	No	No
PiCR_Modified_By	varchar(35)	NULL	Modified By.	No	No
PiCR_Modified_Datetime	datetime	NULL	Modified Date and Time.	No	No
PiCR_Timestamp	decimal(10)	NULL	Time Stamp.	No	No

Table Name Picc_PiCRSrl_CntRslt_SrlLot

Table Comment This stable enables you to store serial and lot details for tags.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiCRSrl_OUInstance	decimal(10)	NOT NULL	Location Id where the Physical Inventory Plan document is created.	Yes	Yes
PiCRSrl_Pi_Plan_No	varchar(40)	NOT NULL	PI Plan Number.	Yes	Yes
PiCRSrl_Cr_SysLine_No	decimal(10)	NOT NULL	Count Result Sysline Number.	Yes	Yes
PiCRSrl_SrlLot_SysSeqNo	decimal(10)	NOT NULL	Serial Lot Sys Sequence Number.	Yes	No
PiCR_Tag_No	varchar(40)	NOT NULL	Tag Number..	Yes	Yes
PiCR_Part_No	varchar(40)	NOT NULL	The number that identifies the part for which you wish to view the serial and lot number details.	Yes	Yes
PiCR_Part_Status	varchar(40)	NOT NULL	Part Status.	Yes	Yes
PiCR_Zone_Id	varchar(10)	NOT NULL	The number that identifies the zone in the warehouse where the part is stored..	Yes	Yes
PICRSRL_SRLLOT_DISPSEQNO	decimal(10)	NOT NULL	The line number generated by the system for every part in the multiline.	No	No
PICRSRL_PART_NO	varchar(40)	NULL	The number that identifies the part.	No	No
PICRSRL_PART_CRT_OU	decimal(10)	NULL	ou of the part.	No	No
PiCRSrl_Sys_Srl_No	varchar(40)	NULL	Sys Serial Number.	No	No
PICRSRL_REF_SRL_NO	varchar(40)	NULL	The serial number issued by the manufacturer.	No	No
PiCRSrl_Sys_Lot_No	varchar(40)	NULL	Sys Lot Number.	No	No
PICRSRL_REF_LOT_NO	varchar(40)	NULL	The lot number issued by the manufacturer.	No	No
PiCRSrl_Qty	decimal(28,2)	NULL	Quantity.	No	No
PiCRSrl_Qty_InStkUom	decimal(28,2)	NULL	Quantity In Stock in UOM.	No	No
PiCRSrl_ReCnt_Flag	varchar(5)	NULL	Recount Flag.	No	No
PiCRSrl_SysQty_InStkUom	decimal(28,2)	NULL	System Quantity in Stock UOM.	No	No
PiCRSrl_Part_Condition	varchar(5)	NULL	Part Condition.	No	No
PICRSRL_SRLLOT_TYPE	varchar(5)	NULL	The type of the serial number and lot number, which could be “Existing” or “New”, for a part of type ”Component” or for a part which is “Shelf Life Controlled”. .	No	No
PICRSRL_CERT_INFO_FLAG	varchar(5)	NULL	Indicates whether the certificate information is “Recorded”, “Not Recorded” or “Not Applicable” for a part.	No	No
PICRSRL_CERTIFICATE_TYPE	varchar(25)	NULL	The type of certificate associated with the part serial number or lot number..	No	No
PICRSRL_CERTIFICATE_DATE	datetime	NULL	The date on which the certificate was issued.	No	No
PICRSRL_CERTIFICATE_NO	varchar(40)	NULL	The number identifying the certificate..	No	No
PICRSRL_CERT_AUTH_NO	varchar(40)	NULL	The number identifying the authorization of the part..	No	No
PICRSRL_SYSTRACK_REF_NO	varchar(40)	NULL	The number, which can be used to track the certification details of the component..	No	No
PICRSRL_WARRANTY_END_DATE	datetime	NULL	The date on which the warranty of the part gets lapsed.	No	No
PICRSRL_FILENAME	varchar(50)	NULL	The name of the file used for document reference that is associated to the certificate and parameter information..	No	No

Table Name Picc_PiOpt_Pi_Options_Set

Table Comment This table used to store the physical inventory set option values.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiOpt_OUInstance	decimal(10)	NOT NULL	ouinstance	Yes	No
PiOpt_Class_Set	varchar(5)	NOT NULL	The class of the PI plan.	Yes	No
PIOPT_OPTION_ID	decimal(10)	NOT NULL	option id	Yes	No
PiOpt_SysQty_Display	varchar(5)	NULL	to specify whether to show or hide the system inventory record of the part. The system provides the options ”Show system quantity” and “Do not show system quantity”	No	No
PiOpt_ShtLvl_SysQty	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “System Quantity display” setting at the user level. Select “No” otherwise	No	No
PiOpt_Recnt_Reqd	varchar(5)	NULL	to specify whether recount is mandatory or not. The system displays “Required” by default. 1. Select “Required”, if you wish to set recount as mandatory. If recount is made mandatory, parts will be released only after recount results are entered in the system. 2. Select “Not Required”, if you do not wish to set recount as mandatory. If recount is not mandatory, parts will be released as soon as the physical count is completed.	No	No
PiOpt_ShtLvl_ReCnt	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “Recount Mandatory” setting at the user level. Select “No” otherwise	No	No
PiOpt_ZeroQty	varchar(5)	NULL	to specify whether to “include” or “exclude” zero quantity stock in the cycle count.	No	No
PiOpt_ShtLvl_ZeroQty	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “Zero Qty Parts” setting at user level. Select “No” otherwise	No	No
PiOpt_CntEntMode	varchar(5)	NULL	to specify whether to enter count results for all the items or only for the discrepant items. The system lists “All Stock” and “Discrepant Stock” as options	No	No
PiOpt_ShtLvl_CntEntMode	varchar(5)	NULL	set the field to “Yes” to allow the modification of the “Count Entry Mode” setting at the user level. Select “No” otherwise	No	No
PiOpt_StkCorr_NumType	varchar(5)	NULL	This indicates the numbering type no that is to be used for the ’Stock Correction Document’ that gets generated from CC.	No	No
PiOpt_AdjVal_Tol	decimal(28,2)	NULL	The minimum tolerance value, below or equal to which adjustment is not required (Integer).	No	No
PIOPT_STATUS	varchar(5)	NULL	it describes the status of the set options	No	No
PiOpt_Created_By	varchar(35)	NULL	The name of the user who set the options	No	No
PiOpt_Created_Datetime	datetime	NULL	The date on which the options were set	No	No
PiOpt_Modified_By	varchar(35)	NULL	The name of the user who last modified the options.	No	No
PiOpt_Modified_Datetime	datetime	NULL	The date on which the options were last modified	No	No
PiOpt_Timestamp	decimal(10)	NULL	Time Stamp	No	No

Table Name Picc_PiPLHdr_Pi_Plan_Hdr

Table Comment This table enables you to store the details of the PI plan
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiPLHdr_OUInstance	decimal(10)	NOT NULL	Location Id where the Physical Inventory Plan document is created.	Yes	No
PiPLHdr_Pi_Plan_No	varchar(40)	NOT NULL	The number identifying the PI plan.	Yes	No
PiPLHdr_Plan_Desc	varchar(255)	NULL	The textual description of the plan	No	No
PiPLHdr_Plan_Status	varchar(5)	NULL	The status of the PI plan, which could be “Draft", "Confirmed", "Short Closed", "Cancelled" or "Closed".	No	No
PiPLHdr_User_Status	varchar(25)	NULL	The user status of the selected PI plan.	No	No
PiPLHdr_Category	varchar(25)	NULL	The category to which the PI plan belongs.	No	No
PiPLHdr_Plan_Level	varchar(5)	NULL	The PI plan level, which could be “Warehouse” or “Warehouse – Zone”.	No	No
PiPLHdr_Planned_By	varchar(35)	NULL	The name of the user who created PI plan.	No	No
PiPLHdr_Warehouse_Ou	decimal(10)	NULL	Warehouse OU.	No	No
PiPLHdr_Warehouse_Id	varchar(10)	NULL	The warehouse for which the physical inventory plan was generated.	No	No
PiPLHdr_Zone_Id	varchar(10)	NULL	The number that identifies the zone in which the parts are stored.	No	No
PiPLHdr_Sch_From_Date	datetime	NULL	The starting date of PI plan.	No	No
PiPLHdr_Sch_To_Date	datetime	NULL	The ending date of PI plan.	No	No
PiPLHdr_SysQty_Display	varchar(5)	NULL	System Quantity Display.	No	No
PiPLHdr_Recnt_Reqd	varchar(5)	NULL	Recount Required Status..	No	No
PiPLHdr_ZeroQty_Parts	varchar(5)	NULL	Zero Quantity Parts.	No	No
PiPLHdr_Tag_Type	varchar(5)	NULL	Tag Type..	No	No
PiPLHdr_Tag_NumType	varchar(5)	NULL	Tag Number Type.	No	No
PiPLHdr_Freeze_Date	datetime	NULL	Freeze Date.	No	No
PiPLHdr_Freeze_Status	varchar(5)	NULL	freeze status ..it could be FRZ & UNFRZ.	No	No
PiPLHdr_UnFreeze_Date	datetime	NULL	Unfreeze Date.	No	No
PiPLHdr_SysUnfrz_Flag	varchar(5)	NULL	If the PI Plan can be allowed to be unfreezed, this will be set to ’Yes’. Otherwise, it will be ’No’.	No	No
PiPLHdr_ShortClose_Comments	varchar(255)	NULL	Short Close Comments.	No	No
PiPLHdr_Tot_Parts	decimal(10)	NULL	This gives the count of part-part status covered in the sheet.. When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored.	No	No
PiPLHdr_Tot_Disc	decimal(10)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
PiPLHdr_Tot_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result. When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
PiPLHdr_Tot_CntBased_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result of the 1st counting process When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
PiPLHdr_Tot_ReCntBased_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result of the 2nd time counting (i.e. recounting) process When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
PiPLHdr_Tot_ValBased_Adj	decimal(28,2)	NULL	This gives the total number of parts (in the sheet) for which counted qty and the system qty differs and the system qty got adjusted as a result of the "difference in value" exceeding the "Adjustment Value Tolerance" set. When the sheet is closed or short-closed, all summary data of the sheet like the above is collected and stored. .	No	No
PiPLHdr_Created_Datetime	datetime	NULL	Created Date and Time..	No	No
PiPLHdr_Created_By	varchar(35)	NULL	Created By..	No	No
PiPLHdr_Modified_Datetime	datetime	NULL	Modified Date and Time.	No	No
PiPLHdr_Modified_By	varchar(35)	NULL	Modified By.	No	No
PiPLHdr_Confirmed_Datetime	datetime	NULL	Confirmed Date and Time.	No	No
PiPLHdr_Timestamp	decimal(10)	NULL	Time Stamp.	No	No
PIPLHDR_CNTENT_MODE	varchar(5)	NULL	mode value.	No	No
PIPLHDR_FROM_CMAV	decimal(28,8)	NULL	The starting value in the range of the part values.	No	No
PIPLHDR_TO_CMAV	decimal(28,8)	NULL	The ending value in the range of the part values.	No	No

Table Name PICC_PIPRM_SRL_PARAM_INFO

Table Comment In this table, you can store the certificate details and maintenance parameters for the part
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PIPRM_OUINSTANCE	decimal(10)	NOT NULL	Location Id	No	No
PIPRM_PI_PLAN_NO	varchar(40)	NOT NULL	The number identifying the physical inventory plan..	No	No
PIPRM_CR_SYSLINE_NO	decimal(10)	NOT NULL	system line no	No	No
PIPRM_SRLLOT_SYSLINE_NO	decimal(10)	NOT NULL	system serial no.	No	No
PIPRM_PARAM_CODE	varchar(40)	NULL	The measurable attribute of a component, such as FH / FC (Flight Hours /Flight Cycles), through which the life and maintenance of a component is monitored..	No	No
PIPRM_SINCE_NEW	decimal(28,8)	NULL	The cumulative flying hours or flying cycles of the component, since it is manufactured.	No	No
PIPRM_SINCE_OVERHAUL	decimal(28,8)	NULL	The cumulative flying hours or flying cycles of the component, since its last overhaul in the shop.	No	No
PIPRM_SINCE_REPAIR	decimal(28,8)	NULL	The cumulative flying hours or flying cycles of the component, since its last repair in the shop..	No	No
PIPRM_SINCE_INSP	decimal(28,8)	NULL	The cumulative flying hours or flying cycles of the component, since its last inspection in the shop.	No	No
PIPRM_SINCE_LSV	decimal(28,8)	NULL	The cumulative flying hours or flying cycles of the component, since its last visit to the shop for maintenance. .	No	No
PIPRM_WARRANTY_VALUE	decimal(28,8)	NULL	The value of the part, when the part is covered under warranty.	No	No

Table Name Picc_PiTag_PI_Plan_Tag_Dtl

Table Comment This table allows you to store the history of tags generated or regenerated in a plan. The part details such as the part number and description, the old and new tag number, zone number, zone description and the bin number are stored here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiTag_OUInstance	decimal(10)	NOT NULL	Location Id where the Physical Inventory Plan document is created.	Yes	Yes
PiTag_Pi_Plan_No	varchar(40)	NOT NULL	PI Plan Number.	Yes	Yes
PiTag_Tag_No	varchar(40)	NOT NULL	A number identifying the tag.	Yes	No
PiTag_SysLine_No	decimal(10)	NOT NULL	SysLine Number.	Yes	No
PiTag_DisplayLine_No	decimal(10)	NULL	Display Line Number.	No	No
PiTag_Tag_Status	varchar(5)	NULL	The status of the tag.	No	No
PiTag_Part_Crt_Ou	decimal(10)	NULL	Part Created OU.	No	No
PiTag_Part_No	varchar(40)	NULL	Part Number.	No	No
PiTag_Part_Status	varchar(40)	NULL	Part Status.	No	No
PiTag_Zone_Id	varchar(10)	NULL	The number that identifies the zone in the warehouse where the part is stored.	No	No
PiTag_Bin_Id	varchar(10)	NULL	The number that identifies the bin in which the part is stored.	No	No
PiTag_Lot_No	varchar(40)	NULL	The number identifying the lot in the warehouse.	No	No
PiTag_Prev_Tag_No	varchar(40)	NULL	Previous Tag Number..	No	No
PiTag_NewPrt_Flag	varchar(5)	NULL	New Part Flag.	No	No
PiTag_NewSts_Flag	varchar(5)	NULL	New Status Flag.	No	No
PiTag_Freeze_Status	varchar(5)	NULL	Freeze status .it could be values as FRZ & UNFRZ	No	No
PiTag_UnFreeze_Date	datetime	NULL	Unfreeze Date.	No	No
PiTag_SysUnfrz_Flag	varchar(5)	NULL	If the PI Tag Part can be allowed to be unfreezed, this will be set to ’Yes’. Otherwise, it will be ’No’.	No	No
PiTag_Class_Type	varchar(5)	NULL	Class Type.	No	No

Table Name Picc_PiTagHst_Tag_History

Table Comment This table allows you to store the history of tags generated or regenerated in a plan. The part details such as the part number and description, the old and new tag number, zone number, zone description and the bin number are stored here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiTagHst_OuInstance	decimal(10)	NOT NULL	PI Tag OU.	Yes	No
PiTagHst_Old_Tag_No	varchar(40)	NOT NULL	The number identifying the tag number already generated.	Yes	No
PiTagHst_New_Tag_No	varchar(40)	NOT NULL	The number identifying the new tag number that has been regenerated.	Yes	No
PiTagHst_Regen_Datetime	datetime	NULL	Regenerated Date and Time.	No	No
PiTagHst_Regen_By	varchar(35)	NULL	Regenerated By.	No	No
PiTagHst_Regen_Remarks	varchar(255)	NULL	Any additional comments pertaining to the tag.	No	No

Table Name Picc_PiTol_Pi_Tolerance_Set

Table Comment This table allows you to store the physical inventory set options tolerance values..
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PiTol_OUInstance	decimal(10)	NOT NULL	ouinstance	Yes	Yes
PiTol_Class_Set	varchar(5)	NOT NULL	The class of the PI plan.	Yes	Yes
PiTol_Class_Type	varchar(5)	NOT NULL	The class to which the part in the CC plan belongs, which could be “A”, “B”, “C” or “V”, “E”, “D”.	Yes	No
PIOPT_OPTION_ID	decimal(10)	NOT NULL	physical inventory option id.	Yes	Yes
PiTol_CntTol_InPerc	decimal(28,8)	NULL	The minimum adjustment tolerance level in percentage, below or equal to which no adjustment is required for the existing discrepancy	No	No
PiTol_CntTol_InUnits	decimal(28,2)	NULL	The minimum adjustment tolerance level in units, below or equal to which no adjustment is required for the existing discrepancy (Integer).	No	No
PiTol_ReCntTol_InPerc	decimal(28,8)	NULL	The minimum adjustment tolerance level, below or equal to which no recounting is required for the existing discrepancy (Integer).	No	No
PiTol_ReCntTol_InUnits	decimal(28,2)	NULL	unit	No	No
PiTol_Modified_By	varchar(35)	NULL	The name of the user who last modified the options	No	No
PiTol_Modified_Datetime	datetime	NULL	The date on which the options were last modified.	No	No
PITOL_STATUS	varchar(5)	NULL	status.	No	No

Physical Inventory & Cycle Count