|
|
ICCOMPANY FILE
Inventory Company Information
The Inventory Company Information file is a file of valid inventory companies
and their corresponding system parameters.
REFERENCED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL00.1 BL04.1 BL05.1 BL08.1 BL09.1
BL10.1 BL120 BL121 BL122 BL123 BL130
BL140 BL141 BL15.1 BL16.1 BL20.1 BL20.3
BL200 BL204 BL205 BL208 BL21.2 BL21.5
BL210 BL215 BL220 BL230 BL231 BL232
BL240 BL241 BL243 BL245 BL246 BL247
BL248 BL29.1 BL29.2 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
BL520 BL720 BL80.1 BL90.1 BL96E CX01.1
CX15.1 CX205 CX225 CX235 DR25.1 DR40.1
DR42.1 IC02.1 IC03.1 IC04.1 IC10.1 IC10.2
IC110 IC116 IC12.1 IC120 IC125 IC130
IC134 IC135 IC138 IC143 IC15.1 IC15.2
IC15.3 IC150 IC151 IC152 IC16.1 IC16.2
IC16.3 IC16.4 IC17.1 IC179 IC182 IC183
IC19.1 IC192 IC199 IC201 IC202 IC203
IC204 IC211 IC215 IC216 IC217 IC219
IC220 IC221 IC222 IC224 IC225 IC226
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 IC281 IC283 IC284
IC286 IC29.1 IC29.2 IC29.3 IC290 IC295
IC30.1 IC300 IC311 IC35.1 IC36.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 IC50.3
IC51.1 IC519 IC52.1 IC520 IC521 IC522
IC523 IC524 IC525 IC526 IC527 IC53.1
IC530 IC531 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
IC81.1 IC81.2 IC812 IC82.1 IC820 IC840
IC841 IC850 IC851 IC90.1 IC95.1 IC95.2
IC95.3 PC10.1 PC120 PC20.1 PC20.2 PC210
PC310 PC320 PC520 PC521 PC530 PC540
PC810 SEA1.1 IN20.1 MA00.1 MA00.2 MA00.3
MA00.4 MA04.2 MA08.1 MA140 MA190 MA200
MA204 MA278 MA300 MA40.1 MA41.1 MA41.2
MA41.3 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1 MA520 MA530 MA540
OE112 OE130 OE230 OE254 OE270 OE271
OE272 OE280 OE281 OE282 OE283 OE286
OE287 OE288 OE289 OE290 OE293 OE330
OE54.1 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
PO10.1 PO100 PO115 PO117 PO120 PO121
PO122 PO123 PO125 PO13.1 PO130 PO131
PO132 PO133 PO135 PO14.1 PO15.1 PO150
PO16.1 PO16.2 PO17.1 PO180 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO21.6 PO213
PO214 PO216 PO217 PO22.1 PO22.2 PO22.3
PO220 PO221 PO223 PO224 PO225 PO226
PO227 PO23.1 PO23.2 PO230 PO233 PO236
PO24.1 PO25.1 PO25.2 PO25.3 PO25.4 PO251
PO26.1 PO272 PO275 PO276 PO277 PO28.1
PO28.3 PO28.4 PO28.5 PO28.6 PO28.7 PO28.8
PO280 PO29.1 PO295 PO30.1 PO30.2 PO32.1
PO32.2 PO32.3 PO32.4 PO32.5 PO33.1 PO33.2
PO34.1 PO34.2 PO35.1 PO37.1 PO38.1 PO39.1
PO50.1 PO52.1 PO529 PO53.3 PO530 PO550
PO560 PO60.1 PO61.1 PO62.1 PO63.1 PO64.1
PO67.1 PO72.1 PO72.2 PO813 PO820 PO821
PO822 PO85.1 PO94.1 POA2.1 RQ01.1 RQ02.1
RQ111 RQ115 RQ120 RQ201 RQ202 RQ215
RQ230 RQ235 RQ240 RQ300 RQ39.1 RQ39.2
RQ39.3 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQ50.1 RQ510 RQ511 RQ512 RQ513 RQ810
RQ964 SEA2.1 SEA3.1 SA04.1 SA100 SA110
SA250 SA251 SA252 SA253 SA254 SA255
SA256 SA257 SA258 SA262 SA272 SA282
SA292 SA300 SA80.3 SA90.3 SAA2.1 TX140
WH01.1 WH11.1 WH120 WH126 WH131 WH140
WH201 WH210 WH211 WH221 WH224 WH225
WH226 WH330 WOA2.1 IC00.1 IC11.1 IC200
IC965 IC991
UPDATED BY
AC115 BL81.1 BL820 BL85.1 BL85.2 BL92.1
BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 DR100 IC01.1 IC01.2 IC01.3
IC01.4 IC140 IC141 IC142 IC145 IC170
IC175 IC190 IC20.1 IC20.2 IC21.1 IC21.2
IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1
IC24.2 IC243 IC25.1 IC262 IC263 IC31.1
IC40.1 IC40.2 IC45.1 IC500 IC62.1 IC62.2
IC63.1 IC67.1 IC68.1 IC68.2 IC83.1 IC960
IC990 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE81.1 OE81.2 OE81.3
OE810 OE830 OE90.1 OE920 OE950 PO31.1
RQ04.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ125 RQ13.1 RQ15.1 RQ20.1 RQ20.2 RQ204
RQ35.1 RQ500 RQ961 WH02.1 WH110 WH130
WH132 WH190 WH20.1 WH20.2 WH20.3 WH20.4
WH20.5 WH20.6 WH20.7 WH22.1 WH220 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 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 WH520 WH80.1 WH80.2 WH80.3
WH80.4 WH81.1 WH830 WH961 WO10.1 WO120
WO130 WO131 WO132 WO133 WO140 WO20.1
WO20.2 WO215 WO220 WO232 WO235 WO250
WO251 WO252 WO255 WO256 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
Company The company number represents an IC01.3 IC01.4
established company and is entered on IC960
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
IC960 OE14.1
OE14.2 OE230
OE287 OE293
WH120 WH126
ICC-NAME Alpha 30 (Lower Case) IC01.1 IC01.4
Name This field contains the name or IC960
description of this company.
ICC-COST-METHOD Alpha 4 IC01.1 IC960
Costing Method This field contains the selected method
to cost inventory transactions.
AVG = Average
FIFO = First In First Out
LIFO = Last In First Out
STD = Standard
ICC-NUMBER-PDS Numeric 2 IC01.2 IC960
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 IC960
updated with the summarized history.
ICC-CURR-PERIOD Numeric 2 IC01.2 IC190
Current Period This field determines the period that IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
Special Nbr This field contains the number of PO67.1
Decimals for Qty decimals used for the quantity field for
special order and service items.
0 = 0 Decimals
2 = 2 Decimals
3 = 3 Decimals
4 = 4 Decimals
5 = 5 Decimals
ICC-SP-DEC-COST-P Numeric 1 IC01.1 IC960
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
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 IC960
Used the last record added to the PO
Interface file.
ICC-COMPLETE-FLAG Alpha 1 IC01.1 IC960
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 IC960
Future Use This field is reserved for future use.
ICC-LAST-IREF-NBR Numeric 9 IC960 IC990
Last Interface This is the last assigned purchase RQ125 RQ20.1
Reference Nbr order interface record reference number. RQ20.2
When RQ20 builds model purchase orders
in the PO Interface file, a reference
number is automatically assigned to
these records.
ICC-SELL-ALLOC-FL Alpha 1 IC01.1 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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 IC960
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-EXT-SYSTEM-CD Alpha 2 Occurs 4 Times IC960
Ext System Cd These fields can be used by a
non-Lawson system that is feeding demand
into the Warehouse system. This field is
the external system's system code.
ICC-WH-CREATE-SHIP Alpha 1 Occurs 4 Times IC960
Wh Create Ship These fields can be used by a
non-Lawson system when feeding demand
into the Warehouse system. These fields
are used to specify whether the
interfaced demand is to create Shipment
records upon entry.
Y = Yes
N = No
ICC-DEF-PROC-TYPE Alpha 2 Occurs 4 Times IC960
Def Proc Type These fields can be used by a
non-Lawson system to feed demand into
the Warehouse system. These fields are
used to determine the default process
type to be used for the interfaced
demand.
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 system's
picking list.
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.
ICC-REL-COM-OPT Alpha 1 Occurs 10 Times
Rel Com Opt Not currently used.
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.
ICCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICCSET1 COMPANY AC115 AP125
AP126 AP225
AP226 AP25.1
AP25.2 AP26.1
BL00.1 BL04.1
BL05.1 BL08.1
BL09.1 BL10.1
BL120 BL121
BL122 BL123
BL130 BL140
BL141 BL15.1
BL16.1 BL20.1
BL20.3 BL200
BL204 BL205
BL208 BL21.2
...
ICCSET2 ITEM-GROUP KeyChange IC00.1 IC01.1
COMPANY IC10.1 IC10.2
IC11.1 IC200
IC60.1 IC965
IC990 IC991
WH02.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
Whproctype WHPROCTYPE Not Required
Valid When ICC-DEF-PROC-TYPE != Spaces
ICC-COMPANY -> WPT-COMPANY
ICC-DEF-PROC-TYPE -> WPT-PROCESS-TYPE
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
Stpoline STPOLINE
ICC-COMPANY -> SPL-COMPANY
SPL-ORDER-NAME
SPL-LINE-NBR
|