ICCOMPANY FILE
Inventory Company Information
The Inventory Company Information file is a file of valid inventory companies
and their corresponding system parameters.
REFERENCED BY
AP510 API1.1 API2.1 BL00.1 BL04.1 BL05.1
BL09.1 BL10.1 BL121 BL123 BL125 BL141
BL15.1 BL16.1 BL200 BL204 BL205 BL208
BL210 BL215 BL220 BL230 BL231 BL232
BL240 BL241 BL243 BL245 BL246 BL247
BL248 BL290 BL30.1 BL30.2 BL30.3 BL30.5
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.1
BL32.2 BL32.3 BL32.4 BL33.1 BL330 BL331
BL340 BL341 BL40.1 BL40.2 BL40.3 BL41.1
BL42.1 BL42.2 BL45.2 BL45.3 BL46.2 BL46.3
BL47.2 BL47.3 BL48.2 BL48.3 BL80.1 BL90.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 IC28.1
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 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 MA53.1 MA53.5
MA65.1 MA66.2 MA66.3 PO01.1 PO10.1 PO120
PO130 PO132 PO133 PO135 PO136 PO15.1
PO15.2 PO181 PO190 PO204 PO216 PO220
PO223 PO224 PO225 PO230 PO233 PO24.1
PO251 PO26.1 PO275 PO276 PO277 PO280
PO295 PO529 PO550 PO60.1 PO61.1 PO62.1
PO63.1 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 SEA2.1 TX140 WH01.1 WH11.1 WH120
WH131 WH140 WH201 WH21.1 WH210 WH211
WH221 WH224 WH225 WH226 WH330 IC00.1
IC11.1 IC200 IC811 PHI3.1
UPDATED BY
BL140 BL81.1 BL85.1 BL85.2 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 IC281 IC31.1 IC320
IC330 IC36.1 IC40.1 IC40.2 IC45.1 IC500
IC520 IC521 IC522 IC523 IC524 IC525
IC526 IC527 IC530 IC531 IC62.1 IC62.2
IC63.1 IC67.1 IC68.1 IC68.2 IC81.1 IC82.1
IC83.1 IC840 PC120 SEA1.1 PO16.1 PO228
POIJ.1 RQ04.1 RQ11.1 RQ12.1 RQ13.1 RQ204
SEA3.1 WH02.1 WH110 WH126 WH130 WH22.1
WH220 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
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 BL140 BL141
Item Group This field contains the identifier for BL204 BL240
a group of items that can be shared by BL241 BL243
one or more companies. BL340 BL341
BL81.1 IC01.1
WH120
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
Rq Search Cat
ICC-RQ-SHOP-LIST Numeric 1
Rq Shop List
ICC-RQ-EXPRESS-ORD Numeric 1
Rq Express Ord
ICC-RQ-SPEC-SERV Numeric 1
Rq Spec Serv
ICC-RQ-GLOM Numeric 1
Rq Glom
ICC-RQ-SELECT-ALL Alpha 1
Rq Select All
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.
ICCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICCSET1 COMPANY AP510 API1.1
API2.1 BL00.1
BL04.1 BL05.1
BL09.1 BL10.1
BL121 BL123
BL125 BL140
BL141 BL15.1
BL16.1 BL200
BL204 BL205
BL208 BL210
BL215 BL220
BL230 BL231
BL232 BL240
BL241 BL243
BL245 BL246
...
ICCSET2 ITEM-GROUP KeyChange IC00.1 IC01.1
COMPANY IC10.1 IC10.2
IC11.1 IC200
IC330 IC60.1
IC811 PO225
WH02.1
ICCSET3 COMPANY 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
|
