ICCOMPANY FILE
Inventory Company Information
The Inventory Company Information file is a file of valid inventory companies
and their corresponding system parameters.
REFERENCED BY
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 AP510 API1.1 API2.1 CX01.1 DR25.1
DR40.1 DR42.1 IC02.1 IC02.2 IC03.1 IC04.1
IC10.1 IC10.2 IC110 IC120 IC134 IC135
IC138 IC143 IC15.1 IC15.2 IC15.3 IC150
IC151 IC152 IC17.1 IC179 IC182 IC183
IC19.1 IC192 IC199 IC201 IC202 IC203
IC204 IC215 IC217 IC219 IC220 IC221
IC222 IC224 IC227 IC228 IC229 IC230
IC232 IC233 IC234 IC237 IC238 IC239
IC240 IC241 IC242 IC26.1 IC26.2 IC260
IC27.1 IC270 IC271 IC280 IC283 IC284
IC286 IC29.1 IC29.2 IC29.3 IC290 IC295
IC30.1 IC300 IC311 IC35.1 IC38.1 IC41.1
IC42.1 IC42.2 IC42.3 IC42.4 IC43.1 IC47.1
IC48.1 IC49.1 IC50.1 IC50.2 IC51.1 IC519
IC52.1 IC53.1 IC550 IC574 IC589 IC59.1
IC590 IC599 IC60.1 IC60.2 IC60.3 IC61.1
IC65.1 IC70.1 IC72.1 IC73.1 IC74.1 IC76.1
IC78.1 IC812 IC820 IC841 IC850 IC851
IC90.1 IC95.1 IC95.2 IC95.3 ICCP.1 ICI1.1
ICLC.1 PC10.1 PC20.1 PC20.2 PC210 PC310
PC320 PC520 PC521 PC530 PC540 PC810
MA278 MA310 MA41.1 MA41.2 MA41.4 MA53.1
MA53.5 MA540 MA64.6 MA65.1 PO01.1 PO10.1
PO120 PO130 PO132 PO133 PO135 PO136
PO15.1 PO15.2 PO150 PO181 PO190 PO204
PO216 PO220 PO223 PO224 PO225 PO230
PO233 PO24.1 PO25.2 PO25.6 PO25.7 PO25.8
PO251 PO254 PO26.1 PO27.2 PO27.3 PO275
PO276 PO277 PO280 PO295 PO529 PO54.1
PO54.2 PO54.3 PO54.4 PO550 PO67.1 PO85.1
PO94.1 POA3.1 POI7.1 POID.1 POIH.1 RQ01.1
RQ02.1 RQ111 RQ140 RQ201 RQ202 RQ230
RQ235 RQ300 RQ39.1 RQ39.2 RQ39.3 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ50.1 RQ510
RQ511 RQ512 RQ513 RQ810 RQIA.1 SEA2.1
SEA4.1 TX140 WH01.1 WH11.1 WH131 WH140
WH201 WH21.1 WH210 WH211 WH221 WH224
WH225 WH226 WH330 IC00.1 IC07.1 IC11.1
IC200 IC811 PHI3.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC01.1 IC01.2 IC01.3
IC01.4 IC12.1 IC12.2 IC125 IC130 IC140
IC141 IC142 IC145 IC170 IC175 IC190
IC20.1 IC20.2 IC21.1 IC21.2 IC211 IC22.1
IC22.2 IC223 IC225 IC226 IC23.1 IC23.2
IC24.1 IC24.2 IC243 IC25.1 IC262 IC263
IC28.1 IC281 IC31.1 IC320 IC330 IC36.1
IC40.1 IC40.2 IC45.1 IC500 IC520 IC521
IC522 IC523 IC524 IC525 IC526 IC527
IC530 IC531 IC598 IC62.1 IC62.2 IC63.1
IC67.1 IC68.1 IC68.2 IC81.1 IC82.1 IC83.1
IC840 PC120 SEA1.1 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 PO100 PO101
PO122 PO131 PO16.1 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO228 PO23.1 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 POI3.1
POIE.1 POII.1 POIJ.1 RQ04.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ204 RQ35.1
RQ35.2 RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 SEA3.1 WH02.1 WH110 WH120 WH126
WH130 WH132 WH190 WH20.1 WH20.2 WH20.3
WH20.4 WH20.5 WH20.6 WH20.7 WH22.1 WH220
WH222 WH25.1 WH25.2 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH34.5 WH38.1 WH40.1
WH40.2 WH52.1 WH52.2 WH52.3 WH52.4 WH520
WH80.1 WH80.2 WH80.3 WH80.4 WH81.1 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICC-COMPANY Numeric 4 IC01.1 IC01.2
Company The company number represents an IC01.3 IC01.4
established company and is entered on
all function codes.
ICC-ITEM-GROUP Alpha 5 IC01.1 WH120
Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
ICC-NAME Alpha 30 (Lower Case) IC01.1 IC01.4
Name This field contains the name or
description of this company.
ICC-COST-METHOD Alpha 4 IC01.1
Costing Method This field contains the selected method
to cost inventory transactions.
AVG = Average Costing
FIFO = First In First Out
LIFO = Last In First Out
STD = Standard Costing
ICC-NUMBER-PDS Numeric 2 IC01.2
Number of Periods This field contains the number of
inventory periods that are used to
summarize history tracking and item
forecasts.
12 = 12 periods per year (monthly)
13 = 13 periods per year
52 = 52 periods per year (weekly)
53 = 53 periods per year
ICC-CURR-YEAR Numeric 4 DR100 IC01.2
Current Year This field determines the year that is IC190
updated with the summarized history.
ICC-CURR-PERIOD Numeric 2 IC01.2 IC190
Current Period This field determines the period that
is updated with the summarized history.
ICC-CURR-YEAR-PDS Numeric 8 (yyyymmdd) Occurs 53 Times IC01.2 IC190
Current Year Periods This field contains the ending dates
for each inventory period. This date
determines which period gets updated
with the summarized history.
ICC-CURR-YEAR-STS Alpha 1 Occurs 53 Times IC01.2 IC190
Current Year Status This field contains the status of the
inventory period. This status determines
if an inventory transaction can be
entered with a transaction date within
this period.
C = Closed
O = Open
ICC-LST-YR-END-DT Numeric 8 (yyyymmdd) IC01.1 IC190
Last Year End Date This field contains the ending date
from the last period of last year. This
date is used to determine the date range
for the first period of the current
year.
ICC-AUDIT-ITL-FL Alpha 1 IC01.1
Audit Item Location This flag indicates whether changes to
Flag the Item Location file are to be
audited.
N = No
Y = Yes
ICC-UOM-REQ-FL Alpha 1 IC01.1
Require Entry of This field determines if the unit of
UOM Flag measure needs entering on any inventory
transaction.
If the flag is No and the unit of
measure is not entered, the stock unit
of measure defaults.
If the flag is Yes, you must enter the
unit of measure.
N = No
Y = Yes
ICC-NEG-SOH-FL Alpha 1 IC01.1
Select Negative SOH This field determines if the
Flag stock-on-hand quantity can be a negative
value. If the company costing method is
standard or average, this flag can be
set to Yes.
N = No
Y = Yes
ICC-BIN-TYPE Alpha 1 Occurs 9 Times IC01.3
Bin Usage Type This field indicates how the bin is
used. One example is inspection.
ICC-BIN-TYPE-DESC Alpha 10 (Lower Case) IC01.3
Bin Type Description Occurs 9 Times
This field contains the description of
the bin type code.
ICC-BIN-REC-FL Alpha 1 Occurs 9 Times IC01.3
Bin Allow Receipts This field determines if this bin
Flag allows receivings into it.
If this field is No, items have to be
adjusted or transferred into it. For
example, a shipping bin that should not
have an item put into it until the item
has been inspected.
N = No
Y = Yes
ICC-BIN-ISSUES-FL Alpha 1 Occurs 9 Times IC01.3
Bin Allow Issues This flag determines if the bin allows
Flag an item to be issued out of it.
If this field is No, an issue is not
allowed out of this bin. For example,
items may need to be inspected before
they can be issued.
N = No
Y = Yes
ICC-ORDER-COST Signed 7.2 IC01.1
Cost of a Purchase This field contains the average cost of
Order ordering an item. This amount is used in
the economic order quantity calculation.
ICC-CARRY-PCT Percent 4.2 (Percent) IC01.1
Carrying Percent This field contains the percent of the
inventory carrying cost. This percent is
used in the economic order quantity
calculation.
ICC-SP-DEC-QTY Numeric 1 IC01.1 PO15.1
Special Nbr This field contains the number of PO15.2 PO67.1
Decimals for Qty decimals used for the quantity field for
special order and service items.
0 = 0 Decimals
1 = 1 Decimal
2 = 2 Decimals
3 = 3 Decimals
4 = 4 Decimals
ICC-SP-DEC-COST-P Numeric 1 IC01.1
Special Nbr Decimal This field contains the number of
Cost/Price decimals for the unit cost for special
order and service items.
0 = 0 Decimals
1 = 1 Decimal
2 = 2 Decimals
3 = 3 Decimals
4 = 4 Decimals
5 = 5 Decimals
ICC-LAST-IF-LINE Numeric 6 DR100 IC140
Last Interface Line This field contains the line number of IC531
Used the last record added to the PO
Interface file.
ICC-COMPLETE-FLAG Alpha 1 IC01.1
Company Complete This field determines whether all setup
forms have been processed when adding a
new company in IC01.1 (Company).
N = No
Y = Yes
ICC-FUTURE-USE Alpha 1
Future Use This field is reserved for future use.
ICC-SELL-ALLOC-FL Alpha 1 IC01.1
Sell Alloc Fl This field is used to determine if the
allocated quantity should be subtracted
from the stock-on-hand quantity in the
available-to-sell calculation. It is
always set to negative.
+ = Add
- = Subtract
" "
ICC-SELL-INPROC-FL Alpha 1 IC01.1
Sell Inproc Fl This field is used to determine if the
in process quantity should be subtracted
from the stock on hand quantity in the
available to sell calculation. It is
always set to negative.
+ = Add
- = Subtract
" "
ICC-SELL-BCKORD-FL Alpha 1 IC01.1
Sell Bckord Fl This field is used to determine if the
backorder quantity is to be subtracted
from the stock on hand quantity in the
available to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-INTRNC-FL Alpha 1 IC01.1
Sell Intrnc Fl This field is used to determine if the
intransit quantity is to be added to the
stock on hand quantity in the available
to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-ONORD-FL Alpha 1 IC01.1
Sell Onord Fl This field is used to determine if the
on order quantity is to be added to the
stock on hand quantity in the available
to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-WIP-FL Alpha 1 IC01.1
Sell Wip Fl This field is used to determine if the
work in process quantity is to be added
to the stock on hand quantity in the
available to sell calculation.
+ = Add
- = Subtract
" "
ICC-SELL-HOLD-FL Alpha 1 IC01.1
Sell Hold Fl This field is used to determine if the
hold quantity is to be subtracted from
the stock on hand quantity in the
available to sell calculation.
+ = Add
- = Subtract
" "
ICC-ALC-ALLOC-FL Alpha 1 IC01.1
Alc Alloc Fl This field is used to determine if the
allocated quantity is to be subtracted
from the available to allocate
calculation. It is always set to
negative.
+ = Add
- = Subtract
" "
ICC-ALC-INPROC-FL Alpha 1 IC01.1
Alc Inproc Fl This field is used to determine if the
in process quantity is to be subtracted
from the stock on hand quantity in the
available to allocate calculation. It
is always set to negative.
+ = Add
- = Subtract
" "
ICC-ALC-BCKORD-FL Alpha 1 IC01.1
Alc Bckord Fl This field is used to determine if the
backorder quantity is to be added to the
stock on hand quantity in the available
to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-INTRNC-FL Alpha 1 IC01.1
Alc Intrnc Fl This field is used to determine if the
intransit quantity is to be added to the
stock on hand quantity in the available
to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-ONORD-FL Alpha 1 IC01.1
Alc Onord Fl This field is used to determine if the
on order quantity is to be added to the
stock on hand quantity in the available
to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-WIP-FL Alpha 1 IC01.1
Alc Wip Fl This field is used to determine if the
work in process quantity is to be added
to the stock on hand quantity in the
available to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALC-HOLD-FL Alpha 1 IC01.1
Alc Hold Fl This field is used to determine if the
hold quantity is to be subtracted from
the stock on hand quantity in the
available to allocate calculation.
+ = Add
- = Subtract
" "
ICC-ALLOC-FL Alpha 1 IC01.1
Allocation Flag This field determines whether new
demand for an item is to be allocated
when the order is entered or later with
a batch program.
B = Batch
O = Online
ICC-ALLOC-BASIS Alpha 1 IC01.1
Allocation Basis This field is used to determine if the
batch allocation program should allocate
demand based on requested date or the
priority.
D = Date
P = Priority
ICC-CX-PRIORITY Numeric 2 IC01.1
Cx Priority
ICC-OE-PRIORITY Numeric 2 IC01.1
Oe Priority
ICC-RQ-PRIORITY Numeric 2 IC01.1
Rq Priority
ICC-WO-PRIORITY Numeric 2 IC01.1
Wo Priority
ICC-PCK-COM-OPT Alpha 1 Occurs 10 Times IC01.4
Pck Com Opt These fields are used to determine which
item comment types are to be printed on
the Warehouse and Work-Order system's
picking list. A maximum of 10 different
comment types can be X'ed here. The X's
are mapped against
ITEMGROUP.com-type-desc to determine the
actual comment type.
X = Print Comments
ICC-PAK-COM-OPT Alpha 1 Occurs 10 Times IC01.4
Pak Com Opt These fields are used to determine
which item comment types are to be
printed on the Warehouse system's
packing list.
X = Print Comments
ICC-REL-COM-OPT Alpha 1 Occurs 10 Times
Rel Com Opt Not currently used.
ICC-LAST-WO-NBR Numeric 8
Last Wo Nbr
ICC-WO-NBR-TYPE Alpha 1 IC01.1
Wo Nbr Type Work Order Numbering Type.
A = Auto Assign Work Order Number
M = Manually Assign Work Order Nbr
N = Not Using Work Order
ICC-RQ-SEARCH-CAT Numeric 1 IC01.1
Rq Search Cat
ICC-RQ-SHOP-LIST Numeric 1 IC01.1
Rq Shop List
ICC-RQ-EXPRESS-ORD Numeric 1 IC01.1
Rq Express Ord
ICC-RQ-SPEC-SERV Numeric 1 IC01.1
Rq Spec Serv
ICC-RQ-GLOM Numeric 1 IC01.1
Rq Glom
ICC-RQ-CATEGORIES Numeric 1
Rq Categories
ICC-RQ-SELECT-ALL Alpha 1 IC01.1
Rq Select All D = Display
H = Hide
ICC-CONTRACTS-ONLY Alpha 1 IC01.1
Contracts Only
ICC-INTERNAL-ONLY Alpha 1 IC01.1
Internal Only
ICC-AL-ALLOC-FL Derived
Al Alloc Fl Used in the Allocatable quantity
calculation in Itemloc file.
ICC-AL-INPROC-FL Derived
Al Inproc Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-BCKORD-FL Derived
Al Bckord Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-INTRNC-FL Derived
Al Intrnc Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-ONORD-FL Derived
Al Onord Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-WIP-FL Derived
Al Wip Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-HOLD-FL Derived
Al Hold Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-SL-ALLOC-FL Derived
Sl Alloc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-INPROC-FL Derived
Sl Inproc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-BCKORD-FL Derived
Sl Bckord Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-INTRNC-FL Derived
Sl Intrnc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-ONORD-FL Derived
Sl Onord Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-WIP-FL Derived
Sl Wip Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-HOLD-FL Derived
Sl Hold Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-AUDIT-ITM-FL Alpha 1 IC01.1
Audit Itm Fl This flag indicates whether changes to
the ITEMSRC table are to be audited.
ICC-IC-RUN-ST Numeric 1
Ic Run St
ICCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICCSET1 COMPANY AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP510 API1.1
API2.1 CX01.1
CXCP.1 DR100
DR25.1 DR40.1
DR42.1 IC01.1
IC01.2 IC01.3
IC01.4 IC02.1
IC02.2 IC03.1
...
ICCSET2 ITEM-GROUP KeyChange IC00.1 IC01.1
COMPANY IC07.1 IC10.1
IC10.2 IC11.1
IC200 IC330
IC60.1 IC811
PO225 RQ10.1
RQIA.1
ICCSET3 COMPANY KeyChange PHI3.1
ITEM-GROUP
ICCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxcompany CXCOMPANY Not Required
ICC-COMPANY -> CXC-COMPANY
Gl Company GLSYSTEM Not Required
ICC-COMPANY -> GLS-COMPANY
Itemgroup ITEMGROUP Required
ICC-ITEM-GROUP -> ITG-ITEM-GROUP
ICCOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Custorder CUSTORDER
ICC-COMPANY -> COR-COMPANY
COR-ORDER-NBR
Itemdesc ITEMMAST
ITG-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-DESCRIPTION
ITE-ITEM
Itemformat ITEMFORMAT Delete Restricted
ICC-COMPANY -> ITF-COMPANY
ITF-FORMAT-ID
Itemgeneric ITEMMAST
ITG-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-GENERIC
ITE-ITEM
Iteminven ITEMMAST
ITG-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-INVEN-MAJCL
ITE-INVEN-MINCL
ITE-ITEM
Itemmast ITEMMAST
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-ITEM
Itempurch ITEMMAST
ITG-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-PURCH-MAJCL
ITE-PURCH-MINCL
ITE-ITEM
Itemsales ITEMMAST
ITG-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-SALES-MAJCL
ITE-SALES-MINCL
ITE-ITEM
Reasoncode REASON Delete Restricted
ICC-COMPANY -> REA-COMPANY
REA-REASON-CODE
|
