|
|
ICMASSUPD FILE
Request for Mass Item Changes
The Request for Mass Item Changes file stores valid requests to mass change
or mass create Item Location records.
REFERENCED BY
IC216
UPDATED BY
IC116 IC16.1 IC16.2 IC16.3 IC16.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICM-COMPANY Numeric 4 IC16.1 IC16.2
Company The company number represents an IC16.3 IC16.4
established company and is entered on
all function codes.
ICM-REQUEST Numeric 6 IC16.1 IC16.2
Request Number The identifier representing the mass IC16.3 IC16.4
update record. This request number is
processed by IC116 (Item Mass Update) to
actually perform the mass changes.
ICM-UPDATE-TYPE Alpha 3 IC16.1 IC16.2
Update Type This field identifies the type of IC16.3 IC16.4
update request created in IC16.1 (Item
Mass Update Requests).
COP = Mass Copy
CRE = Mass Create
ICH = Item/Vendor Change
MCH = Mass Change
ICM-EFFECTIVE-DT Numeric 8 (yyyymmdd) IC16.1 IC16.2
Effective Date This field contains the date used to IC16.3 IC16.4
select requests to process for update.
ICM-LOCATION-A Alpha 5 IC16.1 IC16.2
Location A This field contains the location of IC16.3 IC16.4
item A.
ICM-LOCATION-B Alpha 5 IC16.1
Location B This field contains the location of
item B.
ICM-ITEM-A Alpha 32 IC16.2 IC16.4
Item A This field contains item A.
ICM-ITEM-B Alpha 32 IC16.2
Item B This field contains item B.
ICM-VENDOR Alpha 9 IC16.4
Vendor ID This field contains the vendor's ID,
which is used as a select parameter.
ICM-VENDOR-A Alpha 9 IC16.4
Vendor A This field contains vendor A.
ICM-VENDOR-B Alpha 9 IC16.4
Vendor B This field contains vendor B.
ICM-VENDOR-FL Alpha 1 IC16.2 IC16.4
Vendor Flag This field contains the option to
select the vendor number from the record
of item A or item B when in Mass Copy by
Item (IC16.2). This flag is also used in
Change by Item or Vendor (IC16.4), where
the only selection criteria is Yes or
Blank.
A = From Item A
B = From Item B
Y = Yes Change All
ICM-SALES-MAJCL Alpha 4 IC16.3
Sales Major Class This field contains the sales major
class. It is used as a selection
parameter.
ICM-SALES-MINCL Alpha 4 IC16.3
Sales Minor Class This field contains the sales minor
class as a selection parameter.
ICM-PURCH-MAJCL Alpha 4 IC16.3
Major Purchasing This field contains the major
Class purchasing class as a selection
parameter.
ICM-PURCH-MINCL Alpha 4 IC16.3
Minor Purchasing This field contains the minor
Class purchasing class as a selection
parameter.
ICM-INVEN-MAJCL Alpha 4 IC16.3
Inventory Major This field contains the inventory major
Class class as a selection parameter.
ICM-INVEN-MINCL Alpha 4 IC16.3
Inventory Minor This field contains the inventory minor
Class class as a selection parameter.
ICM-BUYER-FL Alpha 1 IC16.2 IC16.3
Buyer Flag This field contains the option to IC16.4
select the buyer code from the old or
new item on an Add or Change.
A = From Item A
B = From Item B
Y = Yes
ICM-BUYER-A Alpha 3 IC16.1 IC16.3
Buyer from Item A This field contains the buyer from item IC16.4
location for item A.
ICM-BUYER-B Alpha 3 IC16.3 IC16.4
Buyer from Item B This field contains the buyer from item
location for item B.
ICM-LEAD-CTRL-FL Alpha 1 IC16.4
Leadtime Control This field contains the option to
Flag select the leadtime control code from
the records of item A or item B.
Y = Yes
ICM-LEAD-CTRL-A Alpha 1 IC16.4
Leadtime Control A This field contains the leadtime
control code from item A.
M = Manually Entered
R = Needs Review
S = System Calculates
ICM-LEAD-CTRL-B Alpha 1 IC16.4
Leadtime Control B This field contains the leadtime
control code from item B.
M = Manually Entered
R = Needs Review
S = System Calculates
ICM-AUTO-PO-FL Alpha 1 IC16.2
Auto Create PO Flag This field contains the option to
choose auto PO flag from the location
record of item A or item B.
A = From Item A
B = From Item B
ICM-AUTO-PO Alpha 1 IC16.1 IC16.3
Auto Create This field contains the option to IC16.4
Purchase Orders select the auto PO flag from the record
of item A or item B.
N = No
Y = Yes
ICM-ALLOW-ISS-FL Alpha 1 IC16.1 IC16.3
Allow Issues Flag This field contains the option to IC16.4
change the allow issues flag.
N = No
Y = Yes
ICM-PREFER-BIN-FL Alpha 1 IC16.2
Preferred Bin Flag This field contains the option to
select the preferred bin from item A or
item B.
A = From Item A
B = From Item B
ICM-PREFER-BIN Alpha 7 IC116 IC16.1
Preferred Bin This field contains the preferred bin
field.
ICM-REPL-FROM-LOC Alpha 5 IC16.1
Replenishment From This field contains the replenishment
Location from location.
ICM-REPL-FROM-BIN Alpha 7 IC16.1
Replenishment From This field contains the
Bin replenishment-from bin number within the
replenishment-from location.
ICM-FORECAST-FL Alpha 1 IC16.2
Forecast Flag This field contains the option to
select the forecast number from item A
or item B.
A = From Item A
B = From Item B
ICM-LEADTIME-AB Alpha 1 IC16.2
Leadtime for A or B This field contains the option to
Location select leadtime days from item A or item
B.
A = From Item A
B = From Item B
ICM-LEADTIME-DAYS Numeric 3 IC16.4
Leadtime Number of The average leadtime is the difference
Days between the receipt date and the
purchase order date, from the last
purchase order receipt.
ICM-MOVE-CLASS-FL Alpha 1 IC16.2
Movement Class Flag This field contains the option to
select the movement class from item A or
item B.
A = From Item A
B = From Item B
ICM-PREFER-BIN-AB Alpha 1
Preferred Bin AB This field contains the option to
select the preferred bin from item A or
item B.
A = From Item A
B = From Item B
ICM-ALLOW-REC-FL Alpha 1 IC16.3 IC16.4
Allow Receipts Flag This field contains the option to
change the allow receipts flag to Yes or
No.
N = No
Y = Yes
ICM-PRICE-ADJ Signed 5.1
Price Adjustment This field contains the percent of
price adjustment.
ICM-STD-COST Signed 13.5 IC16.4
Standard Cost This field contains the standard cost
of an item.
ICM-STD-COST-ADJ Signed 5.1 IC16.3 IC16.4
Standard Cost This field contains the percent of
Adjustment future standard cost adjustment. This
adjusts the current standard cost by
this percent and stores the new cost in
the future standard cost field.
ICM-BIN-TRACKING Alpha 1 IC16.3
Bin Tracking Flag This field indicates whether the item
has bin tracking.
N = No
Y = Yes
ICM-GL-CATEGORY-B Alpha 4 IC16.2
Gl Category B This field overrides the GL category
for item B with the GL category for item
A (or a replacement category of choice).
The GL category used must be a valid
category for the locations that contain
item B (defined in IC04.1) .
ICMASSUPD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICMSET1 COMPANY IC116 IC16.1
REQUEST IC16.2 IC16.3
IC16.4 IC216
ICMASSUPD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
ICM-COMPANY -> ICC-COMPANY
Inv Class MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"I" -> MIN-CLASS-TYPE
ICM-INVEN-MAJCL -> MIN-MAJOR-CLASS
ICM-INVEN-MINCL -> MIN-MINOR-CLASS
Item A ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICM-ITEM-A -> ITE-ITEM
Item B ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICM-ITEM-B -> ITE-ITEM
Purch Class MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"P" -> MIN-CLASS-TYPE
ICM-PURCH-MAJCL -> MIN-MAJOR-CLASS
ICM-PURCH-MINCL -> MIN-MINOR-CLASS
Sales Class MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
ICM-SALES-MAJCL -> MIN-MAJOR-CLASS
ICM-SALES-MINCL -> MIN-MINOR-CLASS
|