|
|
ICSELECT FILE
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 Numeric 4 IC70.1
Element: Company 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.
ICS-SELECT-ID Alpha 5 IC70.1
Element: Select ID This field contains select IDs, which
identify groups of items and item
selection criteria for inventory counts.
Select IDs can be used cyclically.
ICS-DESCRIPTION Alpha 30 (Lower Case) IC70.1
Element: Description This field contains the user-defined of
the select ID.
ICS-PG-TOT-REQ-FL Alpha 1 IC70.1
Element: All Flag 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
ICS-UOM-REQ-FL Alpha 1 IC70.1
Element: All Flag This field contains the option to
require a unit of measure when entering
item count quantities.
N = No
Y = Yes
ICS-QTY-REQ-FL Alpha 1 IC70.1
Quantity Required This field contains the option to
Flag 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
ICS-ALL-LOC-FL Alpha 1 IC70.1
Element: All Flag This field contains the option to
choose all locations within a company.
N = No
Y = Yes
ICS-BY-LOGIC-FL Alpha 1 IC70.1
Element: All Flag This field indicates whether parameters
were selected from the logic form.
N = No
Y = Yes
ICS-FREEZE-DATE Numeric 8 (yyyymmdd) IC170
Element: Freeze Date This field contains the system date
when Freeze Selected Items (IC170) was
last run for a selected ID.
ICS-FREEZE-TIME Numeric 6 IC170
Element: Update Time This field contains the system time
when Freeze Selected Items (IC170) was
last run for a selected ID.
ICS-UPDATE-DATE Numeric 8 (yyyymmdd) IC170 IC175
Element: Update Date This field contains the system date
when Update Variances (IC175) was last
run in update mode for a selected ID.
ICS-UPDATE-TIME Numeric 6 IC170 IC175
Element: Update Time This field contains the system time
when Update Variances(IC175) was last
run in update mode for a selected ID.
ICS-FREEZE-PAGES Numeric 4 IC170 IC574
Element: Nbr of Freeze This field contains total number of IC74.1
count sheets created by Freeze Selected
Items (IC170).
ICS-FREEZE-LINES Numeric 6 IC170 IC574
Element: Nbr of Freeze This field contains the total number of IC73.1 IC74.1
freeze lines (records) on the freeze
file for a selected ID.
ICS-ENTERED-LINES Numeric 6 IC170 IC175
Number of Entered This field contains the total number of IC179 IC574
Lines lines processed by a count entry form. IC72.1 IC73.1
IC74.1
ICS-UNEXPL-LINES Numeric 6 IC170 IC574
Element: Unexplained LiThis field contains the total number of IC72.1 IC73.1
lines processed by a count entry form IC74.1 IC76.1
for which count variances were left
unexplained with no reason code.
ICS-LAST-MAN-LINE Numeric 2 IC170 IC175
Element: Last Manual LiThis field is used in IC74.1 (Random IC179 IC574
Counts) for assigning line numbers when IC73.1 IC74.1
creating new records.
ICS-STATUS Numeric 1 IC170 IC175
Element: Status This field contains the current IC179 IC73.1
processing status.
0 = Select ID Not In Use
1 = Select ID In Use (IC170 Run)
2 = Select ID Updated (IC175 Run)
ICS-REPORT-GRP Alpha 5 IC70.1
Element: Report Group 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.
ICS-INVEN-MAJCL Alpha 4 Occurs 20 Times IC70.1
Element: Major Class This field contains a major inventory
class, which is used to identify a group
of inventory items. Major inventory
classes are defined in IC06.1 (Inventory
Class) and assigned to items in IC11.1
(Item Master) or IC10.2 (Item Master and
Location).
ICS-INVEN-MINCL Alpha 4 Occurs 20 Times IC70.1
Element: Minor Class 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 IC06.1 (Inventory Class) and
assigned to items in IC11.1 (Item
Master) or IC10.2 (Item Master and
Location).
ICS-BIN-GROUP Alpha 7 Occurs 20 Times IC70.1
Element: Bin Group This field contains a group of bins
defined in IC15.3 (Bin Groups). Bins are
setup in IC15.2 (Bins) and assigned to
items set up for bin tracking in IC12.1
(Item Location) or IC10.2 (Item Master
and Location).
ICS-FRZ-EMPTY-BINS Alpha 1 IC70.1
Element: Freeze Empty BThis 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
ICS-ITEM Alpha 32 Occurs 36 Times IC70.1
Element: Item Number This field contains the item identifier
selected for physical inventory count.
ICS-STOCK-OUT-FL Alpha 1 IC70.1
Element: All Flag This field contains the option to
select items with an available quantity
less than zero.
N = No
Y = Yes
ICS-NEG-SOH-FL Alpha 1 IC70.1
Element: All Flag This field contains the option to
select items with a negative
stock-on-hand quantity.
N = No
Y = Yes
ICS-TRANS-COUNT Numeric 5 IC70.1
Nbr Transaction This field contains the option to
Since Last Cnt select items according to the number of
transactions created since the items
were last counted.
ICS-CNT-ACCURACY Signed 5.1 IC70.1
Class 1 Item The count accuracy is based on the last
Accuracy Cutoff 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.
ICS-CYCLE-DAYS Numeric 3 IC70.1
Cycle Counting by This field contains the option to
Days select items according to the number of
days they have not been counted.
ICS-NBR-ITEMS Numeric 4 IC70.1
Element: Number of ItemThis field contains the option to limit
the number of items counted to a
specific number.
ICS-FRZ-ZERO-SOH Alpha 1 IC70.1
Freeze Zero Stock This field contains the option to
On Hand select items with a stock-on-hand
quantity of zero.
Y = Yes
N = No
ICS-FRZ-ZERO-UCOST Alpha 1 IC70.1
Freeze Zero Unit This field contains the option to
Cost select items with a unit cost of zero.
Y = Yes
N = No
ICS-SEL-1-ITEMS Alpha 1 IC70.1
Select Class X This field contains the option to set
Items to Count selection criteria for movement class 1
items.
X = Count Items In This Class
ICS-SEL-2-ITEMS Alpha 1 IC70.1
Select Class X This field contains the option to set
Items to Count selection criteria for movement class 2
items.
X = Cont Items In This Class
ICS-SEL-3-ITEMS Alpha 1 IC70.1
Select Class X This field contains the option to set
Items to Count selection criteria for movement class 3
items.
X = Count Items In This Class
ICS-SEL-X-ITEMS Alpha 1 IC70.1
Select Class X This field contains the option to set
Items to Count selection criteria for special class X
items.
X = Count Items In This Class
ICS-ACCURACY-1 Signed 5.1 IC70.1
Class 1 Item This field contains the option to
Accuracy Cutoff select movement class 1 items with an
accuracy less than this percent.
ICS-ACCURACY-2 Signed 5.1 IC70.1
Class 1 Item This field contains the option to
Accuracy Cutoff select movement class 2 items with an
accuracy less than this percent.
ICS-ACCURACY-3 Signed 5.1 IC70.1
Class 1 Item This field contains the option to
Accuracy Cutoff select movement class 3 items with an
accuracy less than this percent.
ICS-ACCURACY-X Signed 5.1 IC70.1
Class 1 Item This field contains the option to
Accuracy Cutoff select special class X items with an
accuracy less than this percent.
ICS-NBR-1-ITEMS Numeric 4 IC70.1
Element: Number of ItemThis field contains the option to
choose a maximum number of items in
movement class 1.
ICS-NBR-2-ITEMS Numeric 4 IC70.1
Element: Number of ItemThis field contains the option to
choose a maximum number of items in
movement class 2.
ICS-NBR-3-ITEMS Numeric 4 IC70.1
Element: Number of ItemThis field contains the option to
choose a maximum number of items in
movement class 3.
ICS-NBR-X-ITEMS Numeric 4 IC70.1
Element: Number of ItemThis field contains the option to
choose a maximum number of items in
special class X.
ICS-CYCLE-DAYS-1 Numeric 4 IC70.1
Class 1 Items Cycle This field contains the option to
Days select movement class 1 items that have
not been counted for a certain number of
days.
ICS-CYCLE-DAYS-2 Numeric 4 IC70.1
Class 1 Items Cycle This field contains the option to
Days select movement class 2 items that have
not been counted for a certain number of
days.
ICS-CYCLE-DAYS-3 Numeric 4 IC70.1
Class 1 Items Cycle This field contains the option to
Days select movement class 3 items that have
not been counted for a certain number of
days.
ICS-CYCLE-DAYS-X Numeric 4 IC70.1
Class 1 Items Cycle This field contains the option to
Days select special class X items that have
not been counted for a specific number
of days.
ICS-CONSIGNMENT-ST Numeric 1 IC70.1
Element: Consignment St0 = Include Consignment Items
1 = No Consignment Items
2 = Only Consignment Items
ICSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICSSET1 COMPANY IC170 IC175
SELECT-ID IC179 IC270
IC271 IC574
IC70.1 IC72.1
IC73.1 IC74.1
IC76.1 IC78.1
ICSELECT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ICS-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICS-ITEM -> ITE-ITEM
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"I" -> MAJ-CLASS-TYPE
ICS-INVEN-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"I" -> MIN-CLASS-TYPE
ICS-INVEN-MAJCL -> MIN-MAJOR-CLASS
ICS-INVEN-MINCL -> MIN-MINOR-CLASS
ICSELECT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Freeze ICFREEZE Delete Restricted
ICS-COMPANY -> ICF-COMPANY
ICS-SELECT-ID -> ICF-SELECT-ID
ICF-PAGE
ICF-LINE
|
