Select ID

The Select ID file stores valid select IDs, which are used to determine the items to be frozen for counting for the physical inventory process.

REFERENCED BY

IC270

IC271

IC78.1

UPDATED BY

IC170	IC175	IC179	IC574	IC70.1	IC72.1
IC73.1	IC74.1	IC76.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ICS-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	IC70.1
ICS-SELECT-ID Element: Select Id	Alpha 5 This field contains select IDs, which identify groups of items and item selection criteria for inventory counts. Select IDs can be used cyclically.	IC70.1
ICS-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field contains the user-defined of the select ID.	IC70.1
ICS-PG-TOT-REQ-FL Element: All Flag	Alpha 1 This field contains the option to require the entry of a page total when entering actual counts in IC72.1 (Counts by Page). N = No Y = Yes	IC70.1
ICS-UOM-REQ-FL Element: All Flag	Alpha 1 This field contains the option to require a unit of measure when entering item count quantities. N = No Y = Yes	IC70.1
ICS-QTY-REQ-FL Element: Qty Req Fl	Alpha 1 This field contains the option to require a count for each item or to have the freeze quantity default in the count quantity field. N = No, Qty is not req at entry Y = Yes, Qty is req at entry time	IC70.1
ICS-ALL-LOC-FL Element: All Flag	Alpha 1 This field contains the option to choose all locations within a company. N = No Y = Yes	IC70.1
ICS-BY-LOGIC-FL Element: All Flag	Alpha 1 This field indicates whether parameters were selected from the logic form. N = No Y = Yes	IC70.1
ICS-FREEZE-DATE Element: Freeze Date	Numeric 8 (yyyymmdd) This field contains the system date when Freeze Selected Items (IC170) was last run for a selected ID.	IC170
ICS-FREEZE-TIME Element: Update Time	Numeric 6 This field contains the system time when Freeze Selected Items (IC170) was last run for a selected ID.	IC170
ICS-UPDATE-DATE Element: Update Date	Numeric 8 (yyyymmdd) This field contains the system date when Update Variances (IC175) was last run in update mode for a selected ID.	IC170 IC175
ICS-UPDATE-TIME Element: Update Time	Numeric 6 This field contains the system time when Update Variances(IC175) was last run in update mode for a selected ID.	IC170 IC175
ICS-FREEZE-PAGES Element: Freeze Pages	Numeric 4 This field contains total number of count sheets created by Freeze Selected Items (IC170).	IC170 IC574 IC74.1
ICS-FREEZE-LINES Element: Freeze Lines	Numeric 6 This field contains the total number of freeze lines (records) on the freeze file for a selected ID.	IC170 IC574 IC73.1 IC74.1
ICS-ENTERED-LINES Element: Entered Lines	Numeric 6 This field contains the total number of lines processed by a count entry form.	IC170 IC175 IC179 IC574 IC72.1 IC73.1 IC74.1
ICS-UNEXPL-LINES Element: Unexpl Lines	Numeric 6 This field contains the total number of lines processed by a count entry form for which count variances were left unexplained with no reason code.	IC170 IC574 IC72.1 IC73.1 IC74.1 IC76.1
ICS-LAST-MAN-LINE Element: Last Man Line	Numeric 2 This field is used in IC74.1 (Random Counts) for assigning line numbers when creating new records.	IC170 IC175 IC179 IC574 IC73.1 IC74.1
ICS-STATUS Element: Status	Numeric 1 This field contains the current processing status. 0 = Select ID Not In Use 1 = Select ID In Use (IC170 Run) 2 = Select ID Updated (IC175 Run)	IC170 IC175 IC179 IC73.1
ICS-REPORT-GRP Element: Report Grp	Alpha 5 This field contains a report group defined in IC03.1 (Report Group). Report groups are used to classify locations for reporting, inquiry, and processing purposes.	IC70.1
ICS-INVEN-MAJCL Element: Major Class	Alpha 4 Occurs 20 Times This field contains a major inventory class, which is used to identify a group of inventory items. Major inventory classes are defined in Inventory Class (IC06.1) and assigned to items in Item Master (IC11.1) or Item Master and Location (IC10.2).	IC70.1
ICS-INVEN-MINCL Element: Minor Class	Alpha 4 Occurs 20 Times This field contains a minor inventory class, which is used to identify a group of inventory items. Inventory classes are defined within a major inventory class in Inventory Class (IC06.1) and assigned to items in Item Master (IC11.1) or Item Master and Location (IC10.2).	IC70.1
ICS-BIN-GROUP Element: Bin Group	Alpha 7 Occurs 20 Times This field contains a group of bins defined in Bin Groups (IC15.3). Bins are setup in Bins (IC15.2) and assigned to items set up for bin tracking in Item Location (IC12.1) or Item Master and Location (IC10.2).	IC70.1
ICS-FRZ-EMPTY-BINS Element: Frz Empty Bins	Alpha 1 This field indicates whether Freeze Selected Items (IC170) creates empty bin records for a selected ID. If records are created, the bins must be physically checked to see that they are empty (as indicated by the system). Y = Yes N = No	IC70.1
ICS-ITEM Element: Item	Alpha 32 Occurs 36 Times This field contains the item identifier selected for physical inventory count.	IC70.1
ICS-STOCK-OUT-FL Element: All Flag	Alpha 1 This field contains the option to select items with an available quantity less than zero. N = No Y = Yes	IC70.1
ICS-NEG-SOH-FL Element: All Flag	Alpha 1 This field contains the option to select items with a negative stock-on-hand quantity. N = No Y = Yes	IC70.1
ICS-TRANS-COUNT Element: Trans Count	Numeric 5 This field contains the option to select items according to the number of transactions created since the items were last counted.	IC70.1
ICS-CNT-ACCURACY Element: Accuracy 1	Signed 5.1 The count accuracy is based on the last physical inventory count. The actual count is divided by the freeze quantity. Only items found with a count accuracy that is less that the percent specified are selected for physical inventory count.	IC70.1
ICS-CYCLE-DAYS Element: Cycle Days	Numeric 3 This field contains the option to select items according to the number of days they have not been counted.	IC70.1
ICS-NBR-ITEMS Element: Nbr Items	Numeric 4 This field contains the option to limit the number of items counted to a specific number.	IC70.1
ICS-FRZ-ZERO-SOH Element: Frz Zero Soh	Alpha 1 This field contains the option to select items with a stock-on-hand quantity of zero. Y = Yes N = No	IC70.1
ICS-FRZ-ZERO-UCOST Element: Frz Zero Ucost	Alpha 1 This field contains the option to select items with a unit cost of zero. Y = Yes N = No	IC70.1
ICS-SEL-1-ITEMS Element: Sel X Items	Alpha 1 This field contains the option to set selection criteria for movement class 1 items. X = Count Items In This Class	IC70.1
ICS-SEL-2-ITEMS Element: Sel X Items	Alpha 1 This field contains the option to set selection criteria for movement class 2 items. X = Cont Items In This Class	IC70.1
ICS-SEL-3-ITEMS Element: Sel X Items	Alpha 1 This field contains the option to set selection criteria for movement class 3 items. X = Count Items In This Class	IC70.1
ICS-SEL-X-ITEMS Element: Sel X Items	Alpha 1 This field contains the option to set selection criteria for special class X items. X = Count Items In This Class	IC70.1
ICS-ACCURACY-1 Element: Accuracy 1	Signed 5.1 This field contains the option to select movement class 1 items with an accuracy less than this percent.	IC70.1
ICS-ACCURACY-2 Element: Accuracy 1	Signed 5.1 This field contains the option to select movement class 2 items with an accuracy less than this percent.	IC70.1
ICS-ACCURACY-3 Element: Accuracy 1	Signed 5.1 This field contains the option to select movement class 3 items with an accuracy less than this percent.	IC70.1
ICS-ACCURACY-X Element: Accuracy 1	Signed 5.1 This field contains the option to select special class X items with an accuracy less than this percent.	IC70.1
ICS-NBR-1-ITEMS Element: Nbr Items	Numeric 4 This field contains the option to choose a maximum number of items in movement class 1.	IC70.1
ICS-NBR-2-ITEMS Element: Nbr Items	Numeric 4 This field contains the option to choose a maximum number of items in movement class 2.	IC70.1
ICS-NBR-3-ITEMS Element: Nbr Items	Numeric 4 This field contains the option to choose a maximum number of items in movement class 3.	IC70.1
ICS-NBR-X-ITEMS Element: Nbr Items	Numeric 4 This field contains the option to choose a maximum number of items in special class X.	IC70.1
ICS-CYCLE-DAYS-1 Element: Cycle Days 1	Numeric 4 This field contains the option to select movement class 1 items that have not been counted for a certain number of days.	IC70.1
ICS-CYCLE-DAYS-2 Element: Cycle Days 1	Numeric 4 This field contains the option to select movement class 2 items that have not been counted for a certain number of days.	IC70.1
ICS-CYCLE-DAYS-3 Element: Cycle Days 1	Numeric 4 This field contains the option to select movement class 3 items that have not been counted for a certain number of days.	IC70.1
ICS-CYCLE-DAYS-X Element: Cycle Days 1	Numeric 4 This field contains the option to select special class X items that have not been counted for a specific number of days.	IC70.1
ICS-CONSIGNMENT-ST Element: Consignment St	Numeric 1 0 = Include Consignment Items 1 = No Consignment Items 2 = Only Consignment Items	IC70.1

ICSELECT FILE INDEX

ICSELECT FILE RELATIONS

ONE TO ONE RELATIONS

ICSELECT FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.