|
|
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 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
IC153 IC17.1 IC179 IC183 IC19.1 IC192
IC199 IC201 IC202 IC203 IC204 IC211
IC215 IC217 IC219 IC220 IC221 IC222
IC224 IC227 IC228 IC229 IC230 IC232
IC233 IC234 IC237 IC238 IC239 IC240
IC241 IC242 IC244 IC26.1 IC26.2 IC260
IC27.1 IC271 IC280 IC283 IC284 IC286
IC287 IC29.1 IC29.2 IC29.3 IC290 IC295
IC30.1 IC300 IC311 IC33.1 IC331 IC34.1
IC34.2 IC35.1 IC37.1 IC38.1 IC41.1 IC42.1
IC42.2 IC42.3 IC42.4 IC43.1 IC46.1 IC46.2
IC47.1 IC48.1 IC49.1 IC50.1 IC50.2 IC51.1
IC519 IC52.1 IC53.1 IC55.1 IC55.2 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 MA236 MA278 MA53.1
MA53.5 MA53.7 MA540 MA64.6 MA65.1 PO01.1
PO10.1 PO115 PO120 PO130 PO132 PO133
PO135 PO136 PO139 PO15.1 PO15.2 PO150
PO181 PO190 PO204 PO216 PO220 PO223
PO224 PO225 PO229 PO230 PO233 PO251
PO254 PO258 PO26.1 PO274 PO275 PO276
PO277 PO280 PO295 PO420 PO421 PO529
PO54.1 PO54.2 PO54.3 PO54.4 PO550 PO58.1
PO58.2 PO63.1 PO67.1 PO94.1 POA3.1 POI7.1
POID.1 POIE.1 POIF.1 POIH.1 MM280 MM80.1
MM80.2 RQ01.1 RQ02.1 RQ111 RQ140 RQ201
RQ202 RQ230 RQ235 RQ240 RQ300 RQ39.1
RQ39.2 RQ39.3 RQ40.1 RQ41.1 RQ42.1 RQ420
RQ421 RQ44.1 RQ44.2 RQ50.1 RQ510 RQ511
RQ512 RQ513 RQ810 RQD1.1 RQIA.1 SEA2.1
SEA4.1 TX140 WH01.1 WH11.1 WH131 WH140
WH201 WH21.1 WH210 WH211 WH221 WH224
WH225 WH226 WH330 WH420 WH421 WH422
WH423 WHD2.1 WHD3.1 WO420 WO421 WOD1.1
WOOR.1 IC00.1 IC07.1 IC11.1 IC200 IC811
WODL.1 PHI3.1
UPDATED BY
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 AP30.4 API1.1 CXCP.1 DR100
IC01.1 IC01.2 IC01.3 IC01.4 IC12.1 IC12.2
IC125 IC130 IC140 IC141 IC142 IC145
IC170 IC175 IC182 IC190 IC20.1 IC20.2
IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC225
IC226 IC23.1 IC23.2 IC24.1 IC24.2 IC243
IC25.1 IC262 IC263 IC270 IC28.1 IC281
IC282 IC285 IC31.1 IC320 IC330 IC36.1
IC40.1 IC40.2 IC44.1 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 IC84.1 IC84.2 IC840 PC120 SEA1.1
MA180 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.9 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.1 PO100 PO101 PO122
PO131 PO16.1 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO228 PO23.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POII.1 POIJ.1 RQ04.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ204
RQ35.1 RQ500 RQIB.1 RQIC.1 RQID.1 RQIE.1
RQIF.1 RQIG.1 RQIH.1 RQII.1 RQIJ.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 WH440
WH52.1 WH52.2 WH52.3 WH52.4 WH520 WH80.1
WH80.2 WH80.3 WH80.4 WH81.1 WH830 WO10.1
WO120 WO130 WO131 WO132 WO133 WO140
WO20.1 WO20.2 WO215 WO220 WO232 WO235
WO250 WO251 WO252 WO255 WO256 WO280
WO293 WO30.1 WO30.2 WO300 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO35.1 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO40.6 WO41.1 WO41.2
WO41.3 WO41.4 WO42.1 WO42.2 WO42.3 WO42.4
WO42.5 WO45.1 WO510 WO80.1 WO81.1 WO81.2
WO82.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICC-COMPANY Numeric 4 IC01.1 IC01.2
Element: Company The company number represents an IC01.3 IC01.4
established company and is entered on IC10.2
all function codes.
ICC-ITEM-GROUP Alpha 5 IC01.1 WH120
Element: 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
Element: Name This field contains the name or
description of this company.
ICC-COST-METHOD Alpha 4 IC01.1
Element: Costing MethodThis 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
Element: Number of PeriThis 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
Element: Last Closed YeThis field determines the year that is IC190
updated with the summarized history.
ICC-CURR-PERIOD Numeric 2 IC01.2 IC190
Element: Current PeriodThis field determines the period that
is updated with the summarized history.
ICC-CURR-YEAR-PDS Numeric 8 (yyyymmdd) Occurs 53 Times IC01.2 IC190
Element: Date 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
Element: Current Year SThis 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
Element: 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
Element: All Flag This flag indicates whether changes to
the Item Location file are to be
audited.
N = No
Y = Yes
ICC-UOM-REQ-FL Alpha 1 IC01.1
Element: All Flag This field determines if the unit of
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
Element: All Flag This field determines if the
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
Element: Bin Usage TypeThis field indicates how the bin is
used. One example is inspection.
ICC-BIN-TYPE-DESC Alpha 10 (Lower Case) IC01.3
Element: Bin Type DescrOccurs 9 Times
This field contains the description of
the bin type code.
ICC-BIN-REC-FL Alpha 1 Occurs 9 Times IC01.3
Element: All Flag This field determines if this bin
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
Element: All Flag This flag determines if the bin allows
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
Element: Carrying PerceThis 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 PO115
Special Nbr This field contains the number of PO15.1 PO15.2
Decimals for Qty decimals used for the quantity field for PO67.1
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
Element: Line Number This field contains the line number of IC531
the last record added to the PO
Interface file.
ICC-COMPLETE-FLAG Alpha 1 IC01.1
Element: Company CompleThis 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
Element: Ac Usage This field is reserved for future use.
ICC-SELL-ALLOC-FL Alpha 1 IC01.1
Element: Alc 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
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-SELL-BCKORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-SELL-INTRNC-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-SELL-ONORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-SELL-WIP-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-SELL-HOLD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-ALC-ALLOC-FL Alpha 1 IC01.1
Element: 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
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-ALC-BCKORD-FL Alpha 1 IC01.1
Element: 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
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-ALC-ONORD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-ALC-WIP-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-ALC-HOLD-FL Alpha 1 IC01.1
Element: Alc Bckord Fl + = Add
- = Subtract
" "
ICC-ALLOC-FL Alpha 1 IC01.1
Element: Allocation FlaThis 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
Element: Allocation BasThis 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
Element: Cx Priority
ICC-OE-PRIORITY Numeric 2 IC01.1
Element: Oe Priority
ICC-RQ-PRIORITY Numeric 2 IC01.1
Element: Rq Priority
ICC-WO-PRIORITY Numeric 2 IC01.1
Element: Wo Priority
ICC-PCK-COM-OPT Alpha 1 Occurs 10 Times IC01.4
Element: Ack 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
Element: Ack Com Opt X = Print Comments
ICC-REL-COM-OPT Alpha 1 Occurs 10 Times
Element: Ack Com Opt
ICC-LAST-WO-NBR Numeric 8 WO120 WO20.1
Element: Work Order WO20.2 WO30.1
WO45.1
ICC-WO-NBR-TYPE Alpha 1 IC01.1
Element: 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
Element: Rq Search Cat
ICC-RQ-SHOP-LIST Numeric 1 IC01.1
Element: Rq Shop List
ICC-RQ-EXPRESS-ORD Numeric 1 IC01.1
Element: Rq Express Ord
ICC-RQ-SPEC-SERV Numeric 1 IC01.1
Element: Rq Spec Serv
ICC-RQ-GLOM Numeric 1 IC01.1
Element: Rq Glom
ICC-RQ-CATEGORIES Numeric 1 IC01.1
Element: Rq Categories
ICC-RQ-SELECT-ALL Alpha 1
Element: Rq Select All D = Display
H = Hide
ICC-CONTRACTS-ONLY Alpha 1 IC01.1
Element: Contracts Only
ICC-INTERNAL-ONLY Alpha 1 IC01.1
Element: Internal Only
ICC-AL-ALLOC-FL Derived
Element: Al Alloc Fl Used in the Allocatable quantity
calculation in Itemloc file.
ICC-AL-INPROC-FL Derived
Element: Al Inproc Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-BCKORD-FL Derived
Element: Al Bckord Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-INTRNC-FL Derived
Element: Al Intrnc Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-ONORD-FL Derived
Element: Al Onord Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-WIP-FL Derived
Element: Al Wip Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-AL-HOLD-FL Derived
Element: Al Hold Fl Used in the Allocatable quantity
calculation in the Itemloc file.
ICC-SL-ALLOC-FL Derived
Element: Sl Alloc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-INPROC-FL Derived
Element: Sl Inproc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-BCKORD-FL Derived
Element: Sl Bckord Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-INTRNC-FL Derived
Element: Sl Intrnc Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-ONORD-FL Derived
Element: Sl Onord Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-WIP-FL Derived
Element: Sl Wip Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-SL-HOLD-FL Derived
Element: Sl Hold Fl Used in the Sellable quantity
calculation in the Itemloc file.
ICC-AUDIT-ITM-FL Alpha 1 IC01.1
Element: Audit Itm Fl This flag indicates whether changes to
the ITEMSRC table are to be audited.
ICC-IC-RUN-ST Numeric 1 IC130
Element: Ic Run St This flag is used to determine if a
IC130 Job is in the process of running
and to prevent more than one job to be
attempting to update GL at a time.
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
AP30.4 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
...
ICCSET2 ITEM-GROUP KeyChange DR100 IC00.1
COMPANY IC01.1 IC07.1
IC10.1 IC10.2
IC11.1 IC141
IC142 IC153
IC200 IC33.1
IC330 IC60.1
IC811 IC83.1
PO150 PO225
PO229 PO25.6
PO25.7 PO36.2
PO536 RQ10.1
RQ500 RQIB.1
RQIJ.1 WODL.1
WOOR.1
ICCSET3 COMPANY KeyChange AP125 AP126
ITEM-GROUP AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC141 IC142
IC21.1 IC21.2
IC28.1 IC500
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
...
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
|
