|
|
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 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 BL90.1 IC02.1 IC02.2
IC02.3 IC03.1 IC04.1 IC15.1 IC15.2 IC15.3
IC17.1 IC201 IC202 IC203 IC204 IC211
IC215 IC30.1 IC812 IC850 IC851 ICCP.1
ICI1.1 ICLC.1 MA236 MA278 MA53.1 MA53.5
MA53.7 MA540 MA64.6 MA65.1 MA90.2 MA90.3
MA90.4 MA90.5 PD21.1 PO01.1 PO04.1 PO04.2
PO10.1 PO10.2 PO115 PO120 PO130 PO132
PO133 PO135 PO136 PO139 PO15.1 PO15.2
PO150 PO181 PO204 PO216 PO220 PO223
PO224 PO225 PO229 PO230 PO233 PO234
PO240 PO251 PO254 PO258 PO26.1 PO274
PO275 PO276 PO277 PO278 PO280 PO295
PO420 PO421 PO529 PO53.1 PO53.2 PO54.1
PO54.2 PO54.3 PO54.4 PO550 PO58.1 PO58.2
PO63.1 PO67.1 PO94.1 POA3.1 POCP.1 POI7.1
POIE.1 POIF.1 POIH.1 MM280 MM80.1 MM80.2
RQ01.1 RQ01.2 RQ02.1 RQ111 RQ140 RQ201
RQ202 RQ230 RQ235 RQ240 RQ300 RQ39.1
RQ39.2 RQ39.3 RQ40.1 RQ42.1 RQ420 RQ421
RQ44.1 RQ44.2 RQ50.1 RQ510 RQ511 RQ512
RQ513 RQ810 RQD1.1 RQIA.1 TX140 WH01.1
WH11.1 WH131 WH140 WH201 WH210 WH211
WH221 WH225 WH330 WH420 WH421 WH422
WH423 WHD2.1 WHD3.1 IC00.1 IC07.1 IC11.1
IC14.1 IC200 IC811 ICBL.4
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL140 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL81.1
BL820 BL85.1 BL85.2 BL92.1 CXCP.1 IC01.1
IC01.2 IC01.3 IC01.4 IC12.1 IC12.2 IC130
IC190 IC320 IC330 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.7
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO16.1 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO228 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
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 POID.1 POII.1 POIJ.1 RQ04.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ204 RQ35.1 RQ41.1 RQ500 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1 RQII.1
RQIJ.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
WH224 WH226 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 WH82.1 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICC-COMPANY Numeric 4 IC01.1 IC01.2
Element: Company Identifies the AP company if the IC01.3 IC01.4
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ICC-ITEM-GROUP Alpha 5 BL140 BL141
Element: 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
MA90.2 MA90.3
MA90.4 MA90.5
WH120
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: Cost 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
Element: Number Pds 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 IC01.2 IC190
Element: Year This field determines the year that is
updated with the summarized history.
ICC-CURR-PERIOD Numeric 2 IC01.2 IC190
Element: Curr 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
Element: Curr Year Pds 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: Curr Year Sts 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
Element: Lst Yr End Dt 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 Type This field indicates how the bin is
used. One example is inspection.
ICC-BIN-TYPE-DESC Alpha 10 (Lower Case) IC01.3
Element: Bin Type Desc Occurs 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 18.2 IC01.1
Element: Intl Amt This field contains the average cost of
ordering an item. This amount is used in
the economic order quantity calculation.
ICC-CARRY-PCT Percent 4.2 (Percent) IC01.1
Element: Carry Pct 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 MA90.2
Element: Sp Dec Qty This field contains the number of MA90.3 MA90.4
decimals used for the quantity field for MA90.5 PO115
special order and service items. PO15.1 PO15.2
0 = 0 Decimals PO67.1
1 = 1 Decimal
2 = 2 Decimals
3 = 3 Decimals
4 = 4 Decimals
ICC-SP-DEC-COST-P Numeric 1 IC01.1 MA90.2
Element: Sp Dec Cost P This field contains the number of MA90.3 MA90.4
decimals for the unit cost for special MA90.5
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
Element: Line Nbr This field contains the line number of
the last record added to the PO
Interface file.
ICC-COMPLETE-FLAG Alpha 1 IC01.1
Element: Complete Flag This field determines whether all setup
forms have been processed when adding a
new company in Company (IC01.1).
N = No
Y = Yes
ICC-FUTURE-USE Alpha 1
Element: Future Use 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 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-SELL-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-SELL-INTRNC-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-SELL-ONORD-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-SELL-WIP-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-SELL-HOLD-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-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 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-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 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-ONORD-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-WIP-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-HOLD-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-ALLOC-FL Alpha 1 IC01.1
Element: Alloc Fl 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
Element: Alloc 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
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
Element: Work Order This identifies the work order and may
be automatically assigned or manually
assigned, depending on the option
defined for each production (inventory)
location.
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-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.
ICC-APPROVAL-TYPE Alpha 1 IC01.1
Element: Approval Type The type of approval record.
0 = Header approval-Approval codes
1 = Header approval-Process Flow
2 = Line approval
3 = No approval required
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.
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 BL00.1
BL04.1 BL05.1
BL09.1 BL10.1
BL120 BL121
BL122 BL123
BL125 BL130
...
ICCSET2 ITEM-GROUP KeyChange IC00.1 IC01.1
COMPANY IC07.1 IC11.1
IC14.1 IC200
IC330 IC811
ICBL.4 PO150
PO225 PO229
PO25.6 PO25.7
PO36.2 PO536
RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
ICCSET3 COMPANY KeyChange AP125 AP126
ITEM-GROUP AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
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
|
