Data Dictionary -- Physical Inventory & Cycle Count

Srl. No.	Table Name	Comment
1	PICC_CCACCHST_ACCURACY_HIST	This table will store class level accuracy history for the warehouse
2	PICC_CCOPT_CC_OPTIONS_SET	This table allows you to store the set options for cycle counting.
3	PICC_CCPLCI_PLAN_CNTINT_DTL	This tables enables you to store the details of the CC plan accuracy setting values.
4	PICC_CCPLHDR_CC_PLAN_HDR	This table allows you to store the details of the CC plan
5	PICC_CCPLHST_PLSTAT_HISTORY	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
6	PICC_CCPLPRT_PLAN_PART_DTL	This table allows you to store the part CC plan
7	PICC_CCPRM_PARAMETER_DTL	Stores Parameter detail information. In this component, this table needs to store only search criteria message
8	PICC_CCPRM_SRL_PARAM_INFO	This table is used to store the Parameter details in Cycle sheet serial lot level.
9	PICC_CCPRM_WHCLASSLVL_PARAM	Warehouse-class level CC execution parameters like Desired Accuracy , Current Accuracy and the computed Count Interval are stored here
10	PICC_CCPRTCNT_PART_CNT_DTL	this table used to store the information about part count results
11	PICC_CCQC_QUICK_CODE	This table enables you to store quick codes details.
12	PICC_CCSHCR_CC_COUNT_RESULT	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 ot
13	PICC_CCSHDTL_CC_SHEET_DTL	This table allows you to store the details of the CC sheet
14	PICC_CCSHHDR_CC_SHEET_HDR	This table used to store the Cycle count sheet header informations
15	PICC_CCSHSRL_CNTRSLT_SRLLOT	This table allows you to store the serial and lot number details for the counted parts.
16	PICC_CCTOL_CC_TOLERANCE_SET	This table allows you to store the cycle count set options talerence value
17	PICC_PICRSRL_CNTRSLT_SRLLOT	This stable enables you to store serial and lot details for tags.
18	PICC_PICR_PI_COUNT_RESULT	This table allows you to store thecount and recount result details.
19	PICC_PIOPT_PI_OPTIONS_SET	This table used to store the physical inventory set option values.
20	PICC_PIPLHDR_PI_PLAN_HDR	This table enables you to store the details of the PI plan
21	PICC_PIPRM_SRL_PARAM_INFO	In this table, you can store the certificate details and maintenance parameters for the part
22	PICC_PITAGHST_TAG_HISTORY	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
23	PICC_PITAG_PI_PLAN_TAG_DTL	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.
24	PICC_PITOL_PI_TOLERANCE_SET	This table allows you to store the physical inventory set options talerence values..
25	PICC_SET_OPTION_BACKEND_VALUES	This table allows you to store the Set option value of Authorize Count Results & Stock Correction

Table Name :	PICC_CCACCHST_ACCURACY_HIST
Comment :	This table will store class level accuracy history for the warehouse

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCACCHST_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU instance	No
CCACCHST_WH_OU	_decimal_10_0	decimal(10)	No	Warehouse OU.	No
CCACCHST_WH_NO	_varchar_10	varchar(10)	No	Warehouse Number.	No
CCACCHST_CLASS_TYPE	_varchar_5	varchar(5)	No	Class Type.	No
CCACCHST_SYSLINENO	_decimal_10_0	decimal(10)	No	Sys Line No.	No
CCACCHST_OLD_ACCURACY	_decimal_28_8	decimal(28)	Yes	Current Accuracy that was there.	No
CCACCHST_NEW_ACCURACY	_decimal_28_8	decimal(28)	Yes	As On Date.	No
CCACCHST_SHEET_OU	_decimal_28_8	decimal(28)	Yes	New Accuracy got set by this sheet ou.	No
CCACCHST_SHEET_NO	_varchar_40	varchar(40)	Yes	New Accuracy got set by this sheet.	No
CCACCHST_OLD_CNT_INTERVAL	_decimal_10_0	decimal(10)	Yes	Old Count Interval.	No
CCACCHST_NEW_CNT_INTERVAL	_decimal_10_0	decimal(10)	Yes	New Count Interval.	No
CCACCHST_CREATED_BY	_varchar_35	varchar(35)	Yes	Created By.	No
CCACCHST_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created Date and Time.	No

Table Name :	PICC_CCOPT_CC_OPTIONS_SET
Comment :	This table allows you to store the set options for cycle counting.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCOPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	No
CCOPT_CLASS_SET	_varchar_5	varchar(5)	No	The class that belongs to the selected classification method.	No
CCOPT_OPTION_ID	_decimal_10_0	decimal(10)	No	Option ID	No
CCOPT_SYSQTY_DISPLAY	_varchar_5	varchar(5)	Yes	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
CCOPT_SHTLVL_SYSQTY	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the System Quantity display setting at the user level. Select No otherwise	No
CCOPT_RECNT_REQD	_varchar_5	varchar(5)	Yes	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 reco	No
CCOPT_SHTLVL_RECNT	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the Recount Mandatory setting at the user level. Select No otherwise	No
CCOPT_ZEROQTY	_varchar_5	varchar(5)	Yes	to specify whether to include or exclude zero quantity stock in the cycle count.	No
CCOPT_SHTLVL_ZEROQTY	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the Zero Qty Parts setting at user level. Select No otherwise.	No
CCOPT_CNTENTMODE	_varchar_5	varchar(5)	Yes	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
CCOPT_SHTLVL_CNTENTMODE	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the Count Entry Mode setting at the user level. Select No otherwise.	No
CCOPT_STKCORR_NUMTYPE	_varchar_5	varchar(5)	Yes	numbering type for the stock correction transaction	No
CCOPT_ADJVAL_TOL	_decimal_28_2	decimal(28)	Yes	The minimum tolerance value, below or equal to which adjustment is not required Integer .	No
CCOPT_CREATED_BY	_varchar_35	varchar(35)	Yes	The name of the user who set the options.	No
CCOPT_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the options were set.	No
CCOPT_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the options..	No
CCOPT_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the options were last modified..	No
CCOPT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timpe Stamp.	No
CCOPT_STATUS	_varchar_5	varchar(5)	Yes	Status.	No
CCOPT_RNDPART_MODIFY	_varchar_5	varchar(5)	Yes	set the field to Allowed, to allow the modification of parts selected randomly. Select Not Allowed otherwise	No
CCOPT_RNDPART_CLSPLN	_varchar_5	varchar(5)	Yes	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
CCOPT_CONSMPT_PERIOD	udd_count	int(4)	Yes	Consumption Period - value stored in 1 to 12 months	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCPLCI_PLAN_CNTINT_DTL
Comment :	This tables enables you to store the details of the CC plan accuracy setting values.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPLCI_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the CC Plan is created.	No
CCPLCI_CC_PLAN_NO	_varchar_40	varchar(40)	No	Cycle Cout Plan No.	No
CCPLCI_CLASS_TYPE	_varchar_5	varchar(5)	No	The class to which the part in the CC plan belongs, which could be A , B , C or V , E , D .	No
CCPLCI_DESIRED_ACCURACY	_decimal_28_8	decimal(28)	Yes	The desired accuracy level of the part	No
CCPLCI_CURRENT_ACCURACY	_decimal_28_8	decimal(28)	Yes	The current accuracy level of the part during the cycle count.	No
CCPLCI_COUNT_INTERVAL	_decimal_10_0	decimal(10)	Yes	The number of days after which the cycle count is repeated for the part	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCPLHDR_CC_PLAN_HDR
Comment :	This table allows you to store the details of the CC plan

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPLHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the CC Plan is created.	No
CCPLHDR_CC_PLAN_NO	_varchar_40	varchar(40)	No	Cycle Cout Plan No.	No
CCPLHDR_PLAN_DESC	_varchar_150	varchar(150)	Yes	The textual description of the cycle count plan	No
CCPLHDR_PLAN_STATUS	_varchar_5	varchar(5)	Yes	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 bee	No
CCPLHDR_START_DATE	_datetime_8	datetime(8)	Yes	The starting date of CC plan.	No
CCPLHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	The user defined status of the CC plan.	No
CCPLHDR_PLAN_LEVEL	_varchar_5	varchar(5)	Yes	The level at which the cycle count plan was generated, which could be 'Warehouse or Warehouse - Zone level..	No
CCPLHDR_CATEGORY	_varchar_25	Varchar(25)	Yes	The unique code identifying the predefined category in the system	No
CCPLHDR_PLANNED_BY	_varchar_35	varchar(35)	Yes	The name of the user who created the CC plan.	No
CCPLHDR_PLAN_GROUP	_varchar_25	Varchar(25)	Yes	A unique number identifying the plan group	No
CCPLHDR_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse OU.	No
CCPLHDR_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	The warehouse for which the cycle count plan was generated	No
CCPLHDR_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone ID The number that identifies the zone for which the cycle count plan was generated.	No
CCPLHDR_CLASS	_varchar_5	varchar(5)	Yes	The class to which the part in the CC plan belongs, which could be A , B , C or V , E , D .	No
CCPLHDR_PART_CAT	_varchar_25	Varchar(25)	Yes	The user defined category to which the part belongs.	No
CCPLHDR_PART_TYPE	_varchar_5	varchar(5)	Yes	The type of the part which could be Raw Material , Component , Expendable , Tool , Consumable , Kit or Miscellaneous	No
CCPLHDR_PART_GROUP	_varchar_40	varchar(40)	Yes	Part Group the unique group code which is created based on part purpose.. .	No
CCPLHDR_USER_DEF_1	_varchar_25	Varchar(25)	Yes	Any other additional details pertaining to the CC plan.	No
CCPLHDR_USER_DEF_2	_varchar_25	Varchar(25)	Yes	additional details pertaining to the CC plan.	No
CCPLHDR_REMARKS	_varchar_255	varchar(255)	Yes	Any additional remarks pertaining to the CC plan.	No
CCPLHDR_FILENAME	_varchar_50	varchar(50)	Yes	The name of the file used as reference for the cycle count plan	No
CCPLHDR_AUTH_BY	_varchar_35	varchar(35)	Yes	The name of the user who authorized the CC plan	No
CCPLHDR_AUTH_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC plan was authorized.	No
CCPLHDR_CLOSING_COMMENTS	_varchar_255	varchar(255)	Yes	Closing Comments.	No
CCPLHDR_CREATED_BY	_varchar_35	varchar(35)	Yes	The name of the user who created the CC plan.	No
CCPLHDR_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC plan was created.	No
CCPLHDR_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the CC plan.	No
CCPLHDR_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC plan was last modified.	No
CCPLHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp	No
CCPLHDR_PART_SAMPLESIZE	_decimal_10_0	decimal(10)	Yes	The number of various parts to be considered for random selection from the warehouse.	No
CCPLHDR_PART_SELMODE	_varchar_5	varchar(5)	Yes	The selection mode of the part from the warehouse which could be Manual or Random ..	No
CCPLHDR_FROM_CMAV	_decimal_28_8	decimal(28)	Yes	The starting value in the range of the part values..	No
CCPLHDR_TO_CMAV	_decimal_28_8	decimal(28)	Yes	The ending value in the range of the part values..	No
CCPLHDR_LASTCC_DATE	_datetime_8	datetime(8)	Yes	Last Cycle count date	No
CCPLHDR_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	Cycle count Ownership	No
CCPLHDR_TRADING_PARTNER	udd_vendorcode	varchar(45)	Yes	Cycle count Trading Partner	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
ccplhdr_autoasscprt	udd_seqno	int(4)	No	Automatically associate New Parts	Yes
created_area_code	udd_documentno	varchar(40)	Yes	Created Area Code	No
CCPLHDR_CREATED_AREACODE	udd_documentno	varchar(40)	Yes	CC Created Areacode	No

Table Name :	PICC_CCPLHST_PLSTAT_HISTORY
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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPLHST_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the CC Plan is created.	No
CCPLHST_CC_PLAN_NO	_varchar_40	varchar(40)	No	Cycle Cout Plan No.	No
CCPLHST_FROM_STATUS	_varchar_5	varchar(5)	No	The old status of the CC plan	No
CCPLHST_TO_STATUS	_varchar_5	varchar(5)	No	The current status of the CC plan.	No
CCPLHST_CHANGED_ON	_datetime_8	datetime(8)	No	The date on which the status was changed.	No
CCPLHST_CHANGED_BY	_varchar_35	varchar(35)	Yes	The name of the user who changed the status.	No
CCPLHST_COMMENTS	_varchar_255	varchar(255)	Yes	Any comments pertaining to the status change.	No

Table Name :	PICC_CCPLPRT_PLAN_PART_DTL
Comment :	This table allows you to store the part CC plan

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPLPRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the CC Plan is created.	No
CCPLPRT_CC_PLAN_NO	_varchar_40	varchar(40)	No	Cycle Cout Plan No..	No
CCPLPRT_PLN_SYSLINE_NO	_decimal_10_0	decimal(10)	No	Sys Line Number..	No
CCPLPRT_PLN_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	Display Line Number..	No
CCPLPRT_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created OU.	No
CCPLPRT_PART_NO	_varchar_40	varchar(40)	Yes	The number that identifies the part.	No
CCPLPRT_LINELVL_STATUS	_varchar_5	varchar(5)	Yes	Line Level Status.	No
CCPLPRT_CLASS_TYPE	_varchar_5	varchar(5)	Yes	The class to which the part in the CC plan belongs, which could be A , B , C or V , E , D ..	No
CCPLPRT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	Component Code.	No
CCPRM_PARAMCATEGORY	_varchar_25	Varchar(25)	No	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..	No
CCPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	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..	No
CCPRM_PARAMCODE	_varchar_5	varchar(5)	No	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component.	No
CCPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record..	No
CCPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Description of the Param Code.	No
CCPRM_SORT_BY	_decimal_10_0	decimal(10)	Yes	The order in which the values are populated..	No
CCPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	Created Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCPRM_SRL_PARAM_INFO
Comment :	This table is used to store the Parameter details in Cycle sheet serial lot level.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUINSTANCE	No
CCPRM_SHEET_NO	_varchar_40	varchar(40)	No	SHEET NO	No
CCPRM_CR_SYSLINE_NO	_decimal_10_0	decimal(10)	No	CR SYSTEM LINE NO	No
CCPRM_SRLLOT_SYSLINE_NO	_decimal_10_0	decimal(10)	No	SRLLOT SYSLINE NO	No
CCPRM_PARAM_CODE	_varchar_40	varchar(40)	No	PARAMETER CODE	No
CCPRM_SINCE_NEW	_decimal_28_8	decimal(28)	No	SINCE NEW	No
CCPRM_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	No	SINCE OVERHAUL	No
CCPRM_SINCE_REPAIR	_decimal_28_8	decimal(28)	No	SINCE REPAIR	No
CCPRM_SINCE_INSP	_decimal_28_8	decimal(28)	No	SINCE INSPECTION	No
CCPRM_SINCE_LSV	_decimal_28_8	decimal(28)	No	SINCE LSV	No
CCPRM_WARRANTY_VALUE	_decimal_28_8	decimal(28)	No	WARRANTY VALUE	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	No

Table Name :	PICC_CCPRM_WHCLASSLVL_PARAM
Comment :	Warehouse-class level CC execution parameters like Desired Accuracy , Current Accuracy and the computed Count Interval are stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the CC execution parameters are set.	No
CCPRM_WH_OU	_decimal_10_0	decimal(10)	No	Warehouse location.	No
CCPRM_WH_NO	_varchar_10	varchar(10)	No	Warehouse No for which class level accuracy is set.	No
CCPRM_CLASS_TYPE	_varchar_5	varchar(5)	No	This will have the part Class . .	No
CCPRM_OPTION_ID	_decimal_10_0	decimal(10)	No	Option ID.	No
CCPRM_OPTION_STATUS	_varchar_5	varchar(5)	Yes	Option Status.	No
CCPRM_INIT_ACCURACY	_decimal_28_8	decimal(28)	Yes	This indicates the Initial stock accuracy level of the parts of a class in a warehouse.	No
CCPRM_DESIRED_ACCURACY	_decimal_28_8	decimal(28)	Yes	The desired accuracy percentage for the item of the particular class Decimal . . Ensure this value is between 1 and 100..	No
CCPRM_CURRENT_ACCURACY	_decimal_28_8	decimal(28)	Yes	Current Accuracy.	No
CCPRM_COUNT_INTERVAL_INDAYS	_decimal_10_0	decimal(10)	Yes	Count Interval IN Days.	No
CCPRM_CREATED_BY	_varchar_35	varchar(35)	Yes	Created BY.	No
CCPRM_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created Date and Time.	No
CCPRM_MODIFIED_BY	_varchar_35	varchar(35)	Yes	Modified By.	No
CCPRM_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Modified Date and Time.	No
CCPRM_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCPRTCNT_PART_CNT_DTL
Comment :	this table used to store the information about part count results

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCPRTCNT_WH_ID	_varchar_10	varchar(10)	No	Warehouse ID.	No
CCPRTCNT_WH_OU	_decimal_10_0	decimal(10)	No	Warehouse OU.	No
CCPRTCNT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Part Created OU.	No
CCPRTCNT_PART_NO	_varchar_40	varchar(40)	No	Part Number.	No
CCPRTCNT_CLASS_TYPE	_varchar_5	varchar(5)	No	Class Type.	No
CCPRTCNT_NEXT_COUNT_DATE	_datetime_8	datetime(8)	Yes	Next Count Date.	No
CCPRTCNT_COUNT_INTERVAL	_decimal_10_0	decimal(10)	Yes	Count Interval.	No
CCPRTCNT_LAST_SHEET_NO	_varchar_40	varchar(40)	Yes	Last Sheet Number.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCQC_QUICK_CODE
Comment :	This table enables you to store quick codes details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Quick Code OU.	No
CCQC_TYPE	_varchar_25	Varchar(25)	No	type of quick code	No
CCQC_QUICK_CODE	_varchar_25	Varchar(25)	No	The quick code that belongs to the selected quick code type or status.	No
CCQC_DESC	_varchar_80	varchar(80)	Yes	The modified textual description of the quick code	No
CCQC_STATUS	_varchar_5	varchar(5)	Yes	the status of the quick code, either Active or Inactive .	No
CCQC_CREATEDDATE	_datetime_8	datetime(8)	Yes	The date, in the specified date format, on which the quick code was created.	No
CCQC_CREATED_BY	_varchar_35	varchar(35)	Yes	The name of the user who created the quick code.	No
CCQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	The date, in the specified date format, on which the quick code was last modified.	No
CCQC_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the quick code.	No
CCQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCSHCR_CC_COUNT_RESULT
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 ot

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCSHCR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location where the CC Sheeet is created.	No
CCSHCR_SHEET_NO	_varchar_40	varchar(40)	No	Unique Cycle Counting Sheet No generated by the system.	No
CCSHCR_CR_SYSLINE_NO	_decimal_10_0	decimal(10)	No	Count Result Sysline Number.	No
CCSHCR_SHT_SYSLINE_NO	_decimal_10_0	decimal(10)	No	Sheet Sysline Number.	No
CCSHCR_CR_DISPLAY_LINENO	_decimal_10_0	decimal(10)	Yes	Count Result Display Line Number.	No
CCSHCR_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created OU.	No
CCSHCR_PART_NO	_varchar_40	varchar(40)	Yes	Part Number.	No
CCSHCR_PART_STATUS	_varchar_25	Varchar(25)	Yes	Part Status..	No
CCSHCR_ZONE_ID	_varchar_10	varchar(10)	Yes	The number that identifies the zone in the warehouse where the part is stored.	No
CCSHCR_BIN_ID	_varchar_10	varchar(10)	Yes	The number that identifies the bin in which the part is stored.	No
CCSHCR_CNT_STATUS	_varchar_5	varchar(5)	Yes	The count status of the CC sheet	No
CCSHCR_CNTQTY	_decimal_28_2	decimal(28)	Yes	The counted quantity of parts.	No
CCSHCR_CNTQTY_UOM	_varchar_10	varchar(10)	Yes	Count Quatity in UOM.	No
CCSHCR_CNTQTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	Count Quatity in Stock UOM.	No
CCSHCR_COUNTED_BY	_varchar_35	varchar(35)	Yes	The name of the user who counted the part.	No
CCSHCR_DATE_OF_COUNTING	_datetime_8	datetime(8)	Yes	The date on which the part was counted.	No
CCSHCR_COUNTING_REMARKS	_varchar_255	varchar(255)	Yes	Any additional remark pertaining to the count results.	No
CCSHCR_RECOUNT_QTY	_decimal_28_2	decimal(28)	Yes	The recounted quantity of parts.	No
CCSHCR_RECOUNT_QTYINSTKUOM	_decimal_28_2	decimal(28)	Yes	ReCount Quatity in Stock UOM.	No
CCSHCR_RECOUNTED_BY	_varchar_35	varchar(35)	Yes	The name of the user who performed the recount.	No
CCSHCR_RECOUNT_DATE	_datetime_8	datetime(8)	Yes	The date on which the part was recounted.	No
CCSHCR_RECOUNT_REMARKS	_varchar_255	varchar(255)	Yes	Any additional remark pertaining to the recount results.	No
CCSHCR_SYSTEM_QTY	_decimal_28_2	decimal(28)	Yes	The quantity of parts available as per the system inventory record.	No
CCSHCR_STKCORR_OU	_decimal_10_0	decimal(10)	Yes	Stock Correction OU.	No
CCSHCR_STKCORR_NO	_varchar_40	varchar(40)	Yes	Stock Correction Number.	No
CCSHCR_STKCORR_SYSLINE_NO	_decimal_10_0	decimal(10)	Yes	Stock Correction Sysline Number.	No
CCSHCR_STKCORR_QTY_INSTKUOM	_varchar_28	varchar(28)	Yes	Stock Correction Quantity in Stock UOM.	No
CCSHCR_VALBASEDADJ_FLAG	_varchar_5	varchar(5)	Yes	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
CCSHCR_NEWPRT_FLAG	_varchar_5	varchar(5)	Yes	New Part Flag.	No
CCSHCR_NEWSTS_FLAG	_varchar_5	varchar(5)	Yes	New Part Status Flag.	No
CCSHCR_CREATED_BY	_varchar_35	varchar(35)	Yes	The name of the user who created the CC sheet.	No
CCSHCR_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC sheet was created.	No
CCSHCR_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the CC sheet.	No
CCSHCR_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC sheet was last modified.	No
CCSHCR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp.	No
CCSHCR_FILENAME	_varchar_50	varchar(50)	Yes	File Name.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
CcShCR_Count_Flag	udd_designparamcode	varchar(5)	No	Count flag	Yes
CcShCR_QtyDisc_Reason	udd_flag	varchar(25)	No	Quantity reason	Yes
CcShCR_Recount_Flag	udd_designparamcode	varchar(5)	No	ReCount Falg	Yes
CcShCR_Trd_Partner_no	udd_vendorcode	varchar(45)	No	Trading partner number	Yes
CcShCR_Trd_Partner_type	udd_flag1	varchar(25)	No	Trading partner Type	Yes

Table Name :	PICC_CCSHDTL_CC_SHEET_DTL
Comment :	This table allows you to store the details of the CC sheet

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCSHDTL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location where the CC Sheeet is created.	No
CCSHDTL_SHEET_NO	_varchar_40	varchar(40)	No	Unique Cycle Counting Sheet No generated by the system.	No
CCSHDTL_SHT_SYSLINE_NO	_decimal_10_0	decimal(10)	No	SheetSys Line Number..	No
CCSHDTL_CC_PLAN_NO	_varchar_40	varchar(40)	Yes	Cycle Count Plan Number.	No
CCSHDTL_PLN_SYSLINE_NO	_decimal_10_0	decimal(10)	Yes	CC Plan SysLine Number.	No
CCSHDTL_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created OU.	No
CCSHDTL_PART_NO	_varchar_40	varchar(40)	Yes	Part Number.	No
CCSHDTL_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status.	No
CCSHDTL_FREEZE_STATUS	_varchar_5	varchar(5)	Yes	Freezed = FRZ UnFreezed - UNFRZ.	No
CCSHDTL_UNFREEZE_DATE	_datetime_8	datetime(8)	Yes	Unfreeze Date.	No
CCSHDTL_SYSUNFRZ_FLAG	_varchar_5	varchar(5)	Yes	If the Sheet Part can be allowed to be unfreezed, this will be set to Yes . Otherwise, it will be No .	No
CCSHDTL_CLASS_TYPE	_varchar_5	varchar(5)	Yes	Class Type.	No
CCSHDTL_NEWPRT_FLAG	_varchar_5	varchar(5)	Yes	New Part Flag.	No
CCSHDTL_NEWSTS_FLAG	_varchar_5	varchar(5)	Yes	New Status Flag.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_CCSHHDR_CC_SHEET_HDR
Comment :	This table used to store the Cycle count sheet header informations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCSHHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location where the CC Sheeet is created..	No
CCSHHDR_SHEET_NO	_varchar_40	varchar(40)	No	Unique Cycle Counting Sheet No generated by the system.	No
CCSHHDR_SHEET_DESC	_varchar_80	varchar(80)	Yes	The textual description of the cycle count sheet.	No
CCSHHDR_SHEET_STATUS	_varchar_5	varchar(5)	Yes	The status of the CC sheet.	No
CCSHHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	User Status.	No
CCSHHDR_BASIS	_varchar_25	Varchar(25)	Yes	The basis of the CC sheet, which is either Based on Overdue or Based on Plan .	No
CCSHHDR_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse OU.	No
CCSHHDR_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	The warehouse for which the cycle count sheet was generated.	No
CCSHHDR_ZONE_ID	_varchar_10	varchar(10)	Yes	The number that identifies the zone for which the CC sheet is created.	No
CCSHHDR_CC_PLAN_NO	_varchar_40	varchar(40)	Yes	The plan from which the CC sheet was generated.	No
CCSHHDR_SYSQTY_DISPLAY	_varchar_5	varchar(5)	Yes	System Qty Display.	No
CCSHHDR_RECNT_REQD	_varchar_5	varchar(5)	Yes	Recount Required status.	No
CCSHHDR_OVERDUE_DATE	_datetime_8	datetime(8)	Yes	Over Due Date.	No
CCSHHDR_COUNT_DATE	_datetime_8	datetime(8)	Yes	The date on which the part was counted	No
CCSHHDR_ZEROQTY_PARTS	_varchar_5	varchar(5)	Yes	Zero Qty Parts.	No
CCSHHDR_SHORTCLOSE_COMMENTS	_varchar_255	varchar(255)	Yes	Short Close Comments.	No
CCSHHDR_CLASS_TYPE	_varchar_5	varchar(5)	Yes	The class to which the CC sheet belongs, which could be A , B , C or V , E , D	No
CCSHHDR_PART_TYPE	_varchar_5	varchar(5)	Yes	The type of the part, which could be Raw Material , Tool , Kit , Expandable , Component , Consumable or Miscellaneous .	No
CCSHHDR_PART_GROUP	_varchar_40	varchar(40)	Yes	The group to which the part belongs.	No
CCSHHDR_PART_CAT	_varchar_25	Varchar(25)	Yes	part category.	No
CCSHHDR_FREEZE_DATE	_datetime_8	datetime(8)	Yes	Freeze Date..	No
CCSHHDR_UNFREEZE_DATE	_datetime_8	datetime(8)	Yes	UnFreeze Date.	No
CCSHHDR_SYSUNFRZ_FLAG	_varchar_5	varchar(5)	Yes	If the Sheet can be allowed to be unfreezed, this will be set to Yes . Otherwise, it will be No .	No
CCSHHDR_TOT_PARTS	_decimal_28_2	decimal(28)	Yes	This gives the count of part-partstatus 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
CCSHHDR_TOT_DISC	_decimal_28_2	decimal(28)	Yes	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
CCSHHDR_TOT_ADJ	_decimal_28_2	decimal(28)	Yes	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	No
CCSHHDR_TOT_CNTBASED_ADJ	_decimal_28_2	decimal(28)	Yes	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 li	No
CCSHHDR_TOT_RECNTBASED_ADJ	_decimal_28_2	decimal(28)	Yes	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 sum	No
CCSHHDR_TOT_VALBASED_ADJ	_decimal_28_2	decimal(28)	Yes	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	No
CCSHHDR_CREATED_BY	_varchar_35	varchar(35)	Yes	The name of the user who created the CC sheet.	No
CCSHHDR_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC sheet was created.	No
CCSHHDR_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the CC sheet.	No
CCSHHDR_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the CC sheet was last modified.	No
CCSHHDR_CONFIRMED_DATETIME	_datetime_8	datetime(8)	Yes	CC Sheet Confirmed Datetime.	No
CCSHHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp.	No
CCSHHDR_CNTENT_MODE	_varchar_5	varchar(5)	Yes	Count Entry Mode. This could have the following values - All Parts ,Discrepant Parts	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
CCSHHDR_EXCCNTPRTS	udd_seqno	int(4)	No	Exclude Counted Parts	Yes
created_area_code	udd_documentno	varchar(40)	Yes	area code	No
CCSHHDR_CREATED_AREACODE	udd_documentno	varchar(40)	Yes	CC created area code	No

Table Name :	PICC_CCSHSRL_CNTRSLT_SRLLOT
Comment :	This table allows you to store the serial and lot number details for the counted parts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCSHSRL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location where the CC Sheeet is created.	No
CCSHSRL_SHEET_NO	_varchar_40	varchar(40)	No	Unique Cycle Counting Sheet No generated by the system.	No
CCSHSRL_CR_SYSLINE_NO	_decimal_10_0	decimal(10)	No	Count Result Sysline Number.	No
CCSHSRL_SRLLOT_SEQ_NO	_decimal_10_0	decimal(10)	No	Serial Lot Sequence Number.	No
CCSHSRL_SRLLOT_DISPSEQNO	_decimal_10_0	decimal(10)	No	serial or lot controlled parts sequence no.	No
CCSHSRL_PART_NO	_varchar_40	varchar(40)	Yes	The number that identifies the part.	No
CCSHSRL_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	ou of the part.	No
CCSHSRL_SYS_SRL_NO	_varchar_40	varchar(40)	Yes	System Serial Number.	No
CCSHSRL_REF_SRL_NO	_varchar_40	varchar(40)	Yes	The serial number issued by the manufacturer.	No
CCSHSRL_SYS_LOT_NO	_varchar_40	varchar(40)	Yes	System Lot Number.	No
CCSHSRL_REF_LOT_NO	_varchar_40	varchar(40)	Yes	The lot number issued by the manufacturer.	No
CCSHSRL_QTY	_decimal_28_2	decimal(28)	Yes	Quantity.	No
CCSHSRL_QTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	Quantity in Stock UOM.	No
CCSHSRL_RECNT_FLAG	_varchar_5	varchar(5)	Yes	Recount Flag.	No
CCSHSRL_SYSQTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	System Quantity in Stock UOM.	No
CCSHSRL_PART_CONDITION	_varchar_5	varchar(5)	Yes	Part Condition.	No
CCSHSRL_SRLLOT_TYPE	_varchar_5	varchar(5)	Yes	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
CCSHSRL_CERT_INFO_FLAG	_varchar_5	varchar(5)	Yes	Indicates whether the certificate information is Recorded , Not Recorded or Not Applicable for a part.	No
CCSHSRL_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	The type of certificate issued to the part..	No
CCSHSRL_CERTIFICATE_DATE	_datetime_8	datetime(8)	Yes	The date on which the certificate was issued..	No
CCSHSRL_CERTIFICATE_NO	_varchar_40	varchar(40)	Yes	The code that identifies the certificate issued to the part..	No
CCSHSRL_CERT_AUTH_NO	_varchar_40	varchar(40)	Yes	The code that identifies the authorization.	No
CCSHSRL_SYSTRACK_REF_NO	_varchar_40	varchar(40)	Yes	The number used to track the certification details of the part.	No
CCSHSRL_WARRANTY_END_DATE	_datetime_8	datetime(8)	Yes	The date on which the warranty of the part lapses.	No
CCSHSRL_FILENAME	_varchar_50	varchar(50)	Yes	The name of the file used for document reference that is associated to the cycle count plan..	No
CcShSrl_Trd_Partner_no	udd_vendorcode	varchar(45)	Yes	The unique code identifying the trading partner, which could be supplier code or customer code.	No
CcShSrl_Trd_Partner_type	udd_flag1	varchar(25)	Yes	trading partner could be Customer or Supplier ..	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
CcShSrl_Count_Flag	udd_designparamcode	varchar(5)	No	count flag	Yes
CcShSrl_Count_Remarks	udd_remarks	varchar(255)	No	count remarks	Yes
CcShSrl_Counted_By	udd_ctxt_user	varchar(30)	No	counted by	Yes
CcShSrl_Counted_Date	udd_time	datetime(8)	No	counted date	Yes
CcShSrl_Expiry_Date	udd_time	datetime(8)	No	expiry date	Yes
CcShSrl_QtyDisc_Reason	udd_flag	varchar(25)	No	quantity disc reason	Yes
CcShSrl_Recount_Date	udd_time	datetime(8)	No	recount date	Yes
CcShSrl_Recount_Flag	udd_designparamcode	varchar(5)	No	Recount Falg	Yes
CcShSrl_Recount_Remarks	udd_remarks	varchar(255)	No	Recount remarks	Yes
CcShSrl_Recounted_By	udd_ctxt_user	varchar(30)	No	Recounted by	Yes

Table Name :	PICC_CCTOL_CC_TOLERANCE_SET
Comment :	This table allows you to store the cycle count set options talerence value

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCTOL_OUINSTANCE	_decimal_10_0	decimal(10)	No	ou instance.	No
CCTOL_CLASS_SET	_varchar_5	varchar(5)	No	The class that belongs to the selected classification method.	No
CCTOL_OPTION_ID	_decimal_10_0	decimal(10)	No	Option ID.	No
CCTOL_CLASS_TYPE	_varchar_5	varchar(5)	No	The class to which the part in the CC plan belongs, which could be A , B , C or V , E , D .	No
CCTOL_CNTTOL_INPERC	_decimal_28_8	decimal(28)	Yes	The minimum adjustment tolerance level in percentage, below or equal to which no adjustment is required for the existing discrepancy Integer .	No
CCTOL_CNTTOL_INUNITS	_decimal_28_2	decimal(28)	Yes	The minimum adjustment tolerance level in units, below or equal to which no adjustment is required for the existing discrepancy Integer ..	No
CCTOL_RECNTTOL_INPERC	_decimal_28_8	decimal(28)	Yes	The minimum adjustment tolerance level, below or equal to which no recounting is required for the existing discrepancy Integer .	No
CCTOL_RECNTTOL_INUNITS	_decimal_28_2	decimal(28)	Yes	The minimum adjustment tolerance level, below or equal to which no recounting is required for the existing discrepancy Integer ..	No
CCTOL_STATUS	_varchar_5	varchar(5)	No	Status.	No
CCTOL_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the options.	No
CCTOL_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the options were last modified.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_PICRSRL_CNTRSLT_SRLLOT
Comment :	This stable enables you to store serial and lot details for tags.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PICRSRL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the Physical Inventory Plan document is created.	No
PICRSRL_PI_PLAN_NO	_varchar_40	varchar(40)	No	PI Plan Number.	No
PICRSRL_CR_SYSLINE_NO	_decimal_10_0	decimal(10)	No	Count Result Sysline Number.	No
PICRSRL_SRLLOT_SYSSEQNO	_decimal_10_0	decimal(10)	No	Serial Lot Sys Sequence Number.	No
PICRSRL_SRLLOT_DISPSEQNO	_decimal_10_0	decimal(10)	No	The line number generated by the system for every part in the multiline.	No
PICRSRL_PART_NO	_varchar_40	varchar(40)	Yes	The number that identifies the part.	No
PICRSRL_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	ou of the part.	No
PICRSRL_SYS_SRL_NO	_varchar_40	varchar(40)	Yes	Sys Serial Number.	No
PICRSRL_REF_SRL_NO	_varchar_40	varchar(40)	Yes	The serial number issued by the manufacturer.	No
PICRSRL_SYS_LOT_NO	_varchar_40	varchar(40)	Yes	Sys Lot Number.	No
PICRSRL_REF_LOT_NO	_varchar_40	varchar(40)	Yes	The lot number issued by the manufacturer.	No
PICRSRL_QTY	_decimal_28_2	decimal(28)	Yes	Quantity.	No
PICRSRL_QTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	Quantity In Stock in UOM.	No
PICRSRL_RECNT_FLAG	_varchar_5	varchar(5)	Yes	Recount Flag.	No
PICRSRL_SYSQTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	System Quantity in Stock UOM.	No
PICRSRL_PART_CONDITION	_varchar_5	varchar(5)	Yes	Part Condition.	No
PICRSRL_SRLLOT_TYPE	_varchar_5	varchar(5)	Yes	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
PICRSRL_CERT_INFO_FLAG	_varchar_5	varchar(5)	Yes	Indicates whether the certificate information is Recorded , Not Recorded or Not Applicable for a part.	No
PICRSRL_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	The type of certificate associated with the part serial number or lot number..	No
PICRSRL_CERTIFICATE_DATE	_datetime_8	datetime(8)	Yes	The date on which the certificate was issued.	No
PICRSRL_CERTIFICATE_NO	_varchar_40	varchar(40)	Yes	The number identifying the certificate..	No
PICRSRL_CERT_AUTH_NO	_varchar_40	varchar(40)	Yes	The number identifying the authorization of the part..	No
PICRSRL_SYSTRACK_REF_NO	_varchar_40	varchar(40)	Yes	The number, which can be used to track the certification details of the component..	No
PICRSRL_WARRANTY_END_DATE	_datetime_8	datetime(8)	Yes	The date on which the warranty of the part gets lapsed.	No
PICRSRL_FILENAME	_varchar_50	varchar(50)	Yes	The name of the file used for document reference that is associated to the certificate and parameter information..	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
PICRSRL_COMMENTS	udd_txt255	varchar(255)	No	Count result comments	Yes
PICRSRL_EXPIRY_DATE	udd_time	datetime(8)	No	expiry date	Yes
PICRSRL_RSN_QTY_MISMATCH	udd_flag	varchar(25)	No	quantity mismatch	Yes

Table Name :	PICC_PICR_PI_COUNT_RESULT
Comment :	This table allows you to store thecount and recount result details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PICR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the Physical Inventory Plan document is created.	No
PICR_PI_PLAN_NO	_varchar_40	varchar(40)	No	PI Plan Number	No
PICR_CR_SYSLINE_NO	_decimal_10_0	decimal(10)	No	SysLine Number	No
PICR_TAG_NO	_varchar_40	varchar(40)	No	Tag Number.	No
PICR_TAG_SYSLINE_NO	_decimal_10_0	decimal(10)	Yes	Tag Sysline Number.	No
PICR_CR_DISPLAY_NO	_decimal_10_0	decimal(10)	Yes	Count Result Display Number.	No
PICR_CR_STATUS	_varchar_5	varchar(5)	Yes	Count Result Status.	No
PICR_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created Ou.	No
PICR_PART_NO	_varchar_40	varchar(40)	No	Part Number.	No
PICR_PART_STATUS	_varchar_40	varchar(40)	No	Part Status.	No
PICR_ZONE_ID	_varchar_10	varchar(10)	No	Zone ID.	No
PICR_BIN_ID	_varchar_10	varchar(10)	Yes	The number identifying the bin in the zone.	No
PICR_SYSQTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	System Quantity in Stock UOM.	No
PICR_CNTQTY	_decimal_28_2	decimal(28)	Yes	The counted quantity of parts.	No
PICR_CNTQTY_UOM	_varchar_10	varchar(10)	Yes	Count Quantity UOM.	No
PICR_CNTQTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	Count Quantity in Stock UOM.	No
PICR_COUNTED_BY	_varchar_35	varchar(35)	Yes	The name of the user who performed the cycle count.	No
PICR_COUNTED_DATE	_datetime_8	datetime(8)	Yes	The date on which the cycle count was performed.	No
PICR_COUNTING_REMARKS	_varchar_255	varchar(255)	Yes	Any additional information regarding the tag count or recount results.	No
PICR_STKCORR_OU	_decimal_10_0	decimal(10)	Yes	Stock Correction OU.	No
PICR_STKCORR_NO	_varchar_40	varchar(40)	Yes	Stock Correction Number.	No
PICR_STKCORR_SYSLINE_NO	_decimal_10_0	decimal(10)	Yes	Sysline Number.	No
PICR_STKCORR_QTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	Stock Correction Quantity in Stock UOM.	No
PICR_RECOUNT_QTY	_decimal_28_2	decimal(28)	Yes	The recounted quantity of parts.	No
PICR_RECOUNT_QTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	Recount Quantity in Stock UOM.	No
PICR_RECOUNTED_BY	_varchar_35	varchar(35)	Yes	The name of the user who performed the recount.	No
PICR_RECOUNT_DATE	_datetime_8	datetime(8)	Yes	The date on which the recount was performed.	No
PICR_RECOUNT_REMARKS	_varchar_255	varchar(255)	Yes	Any additional information regarding the tag count or recount results	No
PICR_NEWPRT_FLAG	_varchar_5	varchar(5)	Yes	New Part Flag.	No
PICR_NEWSTS_FLAG	_varchar_5	varchar(5)	Yes	New Status Flag.	No
PICR_VALBASEDADJ_FLAG	_varchar_5	varchar(5)	Yes	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
PICR_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created Date and Time.	No
PICR_CREATED_BY	_varchar_35	varchar(35)	Yes	Created By.	No
PICR_MODIFIED_BY	_varchar_35	varchar(35)	Yes	Modified By.	No
PICR_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Modified Date and Time.	No
PICR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
PICR_RSN_QTY_MISMATCH	udd_flag	varchar(25)	No	quantity /mismatch	Yes

Table Name :	PICC_PIOPT_PI_OPTIONS_SET
Comment :	This table used to store the physical inventory set option values.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PIOPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	No
PIOPT_CLASS_SET	_varchar_5	varchar(5)	No	The class of the PI plan.	No
PIOPT_OPTION_ID	_decimal_10_0	decimal(10)	No	option id	No
PIOPT_SYSQTY_DISPLAY	_varchar_5	varchar(5)	Yes	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
PIOPT_SHTLVL_SYSQTY	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the System Quantity display setting at the user level. Select No otherwise	No
PIOPT_RECNT_REQD	_varchar_5	varchar(5)	Yes	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 ente	No
PIOPT_SHTLVL_RECNT	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the Recount Mandatory setting at the user level. Select No otherwise	No
PIOPT_ZEROQTY	_varchar_5	varchar(5)	Yes	to specify whether to include or exclude zero quantity stock in the cycle count.	No
PIOPT_SHTLVL_ZEROQTY	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the Zero Qty Parts setting at user level. Select No otherwise	No
PIOPT_CNTENTMODE	_varchar_5	varchar(5)	Yes	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
PIOPT_SHTLVL_CNTENTMODE	_varchar_5	varchar(5)	Yes	set the field to Yes to allow the modification of the Count Entry Mode setting at the user level. Select No otherwise	No
PIOPT_STKCORR_NUMTYPE	_varchar_5	varchar(5)	Yes	This indicates the numbering type no that is to be used for the Stock Correction Document that gets generated from CC.	No
PIOPT_ADJVAL_TOL	_decimal_28_2	decimal(28)	Yes	The minimum tolerance value, below or equal to which adjustment is not required Integer .	No
PIOPT_STATUS	_varchar_5	varchar(5)	Yes	it describes the status of the set options	No
PIOPT_CREATED_BY	_varchar_35	varchar(35)	Yes	The name of the user who set the options	No
PIOPT_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the options were set	No
PIOPT_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the options.	No
PIOPT_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the options were last modified	No
PIOPT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_PIPLHDR_PI_PLAN_HDR
Comment :	This table enables you to store the details of the PI plan

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PIPLHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the Physical Inventory Plan document is created.	No
PIPLHDR_PI_PLAN_NO	_varchar_40	varchar(40)	No	The number identifying the PI plan.	No
PIPLHDR_PLAN_DESC	_varchar_255	varchar(255)	Yes	The textual description of the plan	No
PIPLHDR_PLAN_STATUS	_varchar_5	varchar(5)	Yes	The status of the PI plan, which could be Draft , Confirmed , Short Closed , Cancelled or Closed .	No
PIPLHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	The user status of the selected PI plan.	No
PIPLHDR_CATEGORY	_varchar_25	Varchar(25)	Yes	The category to which the PI plan belongs.	No
PIPLHDR_PLAN_LEVEL	_varchar_5	varchar(5)	Yes	The PI plan level, which could be Warehouse or Warehouse Zone.	No
PIPLHDR_PLANNED_BY	_varchar_35	varchar(35)	Yes	The name of the user who created PI plan.	No
PIPLHDR_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse OU.	No
PIPLHDR_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	The warehouse for which the physical inventory plan was generated.	No
PIPLHDR_ZONE_ID	_varchar_10	varchar(10)	Yes	The number that identifies the zone in which the parts are stored.	No
PIPLHDR_SCH_FROM_DATE	_datetime_8	datetime(8)	Yes	The starting date of PI plan.	No
PIPLHDR_SCH_TO_DATE	_datetime_8	datetime(8)	Yes	The ending date of PI plan.	No
PIPLHDR_SYSQTY_DISPLAY	_varchar_5	varchar(5)	Yes	System Quantity Display.	No
PIPLHDR_RECNT_REQD	_varchar_5	varchar(5)	Yes	Recoun Required Status..	No
PIPLHDR_ZEROQTY_PARTS	_varchar_5	varchar(5)	Yes	Zero Quantity Parts.	No
PIPLHDR_TAG_TYPE	_varchar_5	varchar(5)	Yes	Tag Type..	No
PIPLHDR_TAG_NUMTYPE	_varchar_5	varchar(5)	Yes	Tag Number Type.	No
PIPLHDR_FREEZE_DATE	_datetime_8	datetime(8)	Yes	Freeze Date.	No
PIPLHDR_FREEZE_STATUS	_varchar_5	varchar(5)	Yes	freeze status ..it could be FRZ & UNFRZ.	No
PIPLHDR_UNFREEZE_DATE	_datetime_8	datetime(8)	Yes	Unfreeze Date.	No
PIPLHDR_SYSUNFRZ_FLAG	_varchar_5	varchar(5)	Yes	If the PI Plan can be allowed to be unfreezed, this will be set to Yes . Otherwise, it will be No .	No
PIPLHDR_SHORTCLOSE_COMMENTS	_varchar_255	varchar(255)	Yes	Short Close Comments.	No
PIPLHDR_TOT_PARTS	_decimal_10_0	decimal(10)	Yes	This gives the count of part-partstatus 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
PIPLHDR_TOT_DISC	_decimal_10_0	decimal(10)	Yes	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
PIPLHDR_TOT_ADJ	_decimal_28_2	decimal(28)	Yes	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 a	No
PIPLHDR_TOT_CNTBASED_ADJ	_decimal_28_2	decimal(28)	Yes	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 li	No
PIPLHDR_TOT_RECNTBASED_ADJ	_decimal_28_2	decimal(28)	Yes	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 sum	No
PIPLHDR_TOT_VALBASED_ADJ	_decimal_28_2	decimal(28)	Yes	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	No
PIPLHDR_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created Date and Time..	No
PIPLHDR_CREATED_BY	_varchar_35	varchar(35)	Yes	Created By..	No
PIPLHDR_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Modified Date and Time.	No
PIPLHDR_MODIFIED_BY	_varchar_35	varchar(35)	Yes	Modified By.	No
PIPLHDR_CONFIRMED_DATETIME	_datetime_8	datetime(8)	Yes	Confirmed Date and Time.	No
PIPLHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp.	No
PIPLHDR_CNTENT_MODE	_varchar_5	varchar(5)	Yes	mode value.	No
PIPLHDR_FROM_CMAV	_decimal_28_8	decimal(28)	Yes	The starting value in the range of the part values.	No
PIPLHDR_TO_CMAV	_decimal_28_8	decimal(28)	Yes	The ending value in the range of the part values.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
created_area_code	udd_documentno	varchar(40)	Yes	Created area code	No
PIPLHDR_CREATED_AREACODE	udd_documentno	varchar(40)	Yes	PIP Created Area Code	No

Table Name :	PICC_PIPRM_SRL_PARAM_INFO
Comment :	In this table, you can store the certificate details and maintenance parameters for the part

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PIPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id	No
PIPRM_PI_PLAN_NO	_varchar_40	varchar(40)	No	The number identifying the physical inventory plan..	No
PIPRM_CR_SYSLINE_NO	_decimal_10_0	decimal(10)	No	system line no	No
PIPRM_SRLLOT_SYSLINE_NO	_decimal_10_0	decimal(10)	No	system serial no.	No
PIPRM_PARAM_CODE	_varchar_40	varchar(40)	Yes	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
PIPRM_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	The cumulative flying hours or flying cycles of the component, since it is manufactured.	No
PIPRM_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	The cumulative flying hours or flying cycles of the component, since its last overhaul in the shop.	No
PIPRM_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	The cumulative flying hours or flying cycles of the component, since its last repair in the shop..	No
PIPRM_SINCE_INSP	_decimal_28_8	decimal(28)	Yes	The cumulative flying hours or flying cycles of the component, since its last inspection in the shop.	No
PIPRM_SINCE_LSV	_decimal_28_8	decimal(28)	Yes	The cumulative flying hours or flying cycles of the component, since its last visit to the shop for maintenance. .	No
PIPRM_WARRANTY_VALUE	_decimal_28_8	decimal(28)	Yes	The value of the part, when the part is covered under warranty.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_PITAGHST_TAG_HISTORY
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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PITAGHST_OUINSTANCE	_decimal_10_0	decimal(10)	No	PI Tag OU.	No
PITAGHST_OLD_TAG_NO	_varchar_40	varchar(40)	No	The number identifying the tag number already generated.	No
PITAGHST_NEW_TAG_NO	_varchar_40	varchar(40)	No	The number identifying the new tag number that has been regenerated.	No
PITAGHST_REGEN_DATETIME	_datetime_8	datetime(8)	Yes	Regenerated Date and Time.	No
PITAGHST_REGEN_BY	_varchar_35	varchar(35)	Yes	Regenerated By.	No
PITAGHST_REGEN_REMARKS	_varchar_255	varchar(255)	Yes	Any additional comments pertaining to the tag.	No

Table Name :	PICC_PITAG_PI_PLAN_TAG_DTL
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.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PITAG_OUINSTANCE	_decimal_10_0	decimal(10)	No	Location Id where the Physical Inventory Plan document is created.	No
PITAG_PI_PLAN_NO	_varchar_40	varchar(40)	No	PI Plan Number.	No
PITAG_TAG_NO	_varchar_40	varchar(40)	No	A number identifying the tag.	No
PITAG_SYSLINE_NO	_decimal_10_0	decimal(10)	No	SysLine Number.	No
PITAG_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	Display Line Number.	No
PITAG_TAG_STATUS	_varchar_5	varchar(5)	Yes	The status of the tag.	No
PITAG_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created OU.	No
PITAG_PART_NO	_varchar_40	varchar(40)	Yes	Part Number.	No
PITAG_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status.	No
PITAG_ZONE_ID	_varchar_10	varchar(10)	Yes	The number that identifies the zone in the warehouse where the part is stored.	No
PITAG_BIN_ID	_varchar_10	varchar(10)	Yes	The number that identifies the bin in which the part is stored.	No
PITAG_LOT_NO	_varchar_40	varchar(40)	Yes	The number identifying the lot in the warehouse.	No
PITAG_CLASS_TYPE	_varchar_5	varchar(5)	Yes	Class Type.	No
PITAG_PREV_TAG_NO	_varchar_40	varchar(40)	Yes	Previous Tag Number..	No
PITAG_NEWPRT_FLAG	_varchar_5	varchar(5)	Yes	New Part Flag.	No
PITAG_NEWSTS_FLAG	_varchar_5	varchar(5)	Yes	New Status Flag.	No
PITAG_FREEZE_STATUS	_varchar_5	varchar(5)	Yes	Freeze status.it could be values as FRZ & UNFRZ	No
PITAG_UNFREEZE_DATE	_datetime_8	datetime(8)	Yes	Unfreeze Date.	No
PITAG_SYSUNFRZ_FLAG	_varchar_5	varchar(5)	Yes	If the PI Tag Part can be allowed to be unfreezed, this will be set to Yes . Otherwise, it will be No .	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_PITOL_PI_TOLERANCE_SET
Comment :	This table allows you to store the physical inventory set options talerence values..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PITOL_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	No
PITOL_CLASS_SET	_varchar_5	varchar(5)	No	The class of the PI plan.	No
PITOL_CLASS_TYPE	_varchar_5	varchar(5)	No	The class to which the part in the CC plan belongs, which could be A, B, C or V, E, D.	No
PITOL_OPTION_ID	_decimal_10_0	decimal(10)	No	OPTION ID	No
PITOL_CNTTOL_INPERC	_decimal_28_8	decimal(28)	Yes	The minimum adjustment tolerance level in percentage, below or equal to which no adjustment is required for the existing discrepancy	No
PITOL_CNTTOL_INUNITS	_decimal_28_2	decimal(28)	Yes	The minimum adjustment tolerance level in units, below or equal to which no adjustment is required for the existing discrepancy Integer .	No
PITOL_RECNTTOL_INPERC	_decimal_28_8	decimal(28)	Yes	The minimum adjustment tolerance level, below or equal to which no recounting is required for the existing discrepancy Integer .	No
PITOL_RECNTTOL_INUNITS	_decimal_28_2	decimal(28)	Yes	Tollerance in Unit	No
PITOL_MODIFIED_BY	_varchar_35	varchar(35)	Yes	The name of the user who last modified the options	No
PITOL_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the options were last modified.	No
PITOL_STATUS	_varchar_5	varchar(5)	Yes	status.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PICC_SET_OPTION_BACKEND_VALUES
Comment :	This table allows you to store the Set option value of Authorize Count Results & Stock Correction

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