ICCOMPANY – Inventory Company Information

System
Inventory Control (IC)
Prefix
ICC
Primary key
COMPANY
Fields
86
Updated by
329 programs
Referenced by
296 programs

ICCOMPANY is the Inventory Company Information table in Lawson Inventory Control (prefix ICC). It is indexed by COMPANY (ICCSET1); alternate indexes: ICCSET2 and ICCSET3. It is related 1:1 to CXCOMPANY, GLSYSTEM, GLNLOC, GLNLOCDTL and ITEMGROUP and 1:M to CUSTORDER, ITEMMAST, ITEMFORMAT and REASON. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 321 more and referenced by AM19.1, AM19.2, AP115, AP220, AP305, CX01.1, CX15.1, CX225 and 288 more. The table has 86 fields, 3 indexes and 14 documented relations.

About ICCOMPANY

The Inventory Company Information file is a file of valid inventory companies and their corresponding system parameters.

Fields (86)

Column = COBOL field name without the ICC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ICC-COMPANY PK
COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.IC01.1, IC01.2, IC01.3, IC01.4, IC10.2
ICC-ITEM-GROUP
ITEM_GROUP
Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC01.1, MA90.2, MA90.3, MA90.4, MA90.5, WH120
ICC-NAME
NAME
Alpha 30 (Lower Case)This field contains the name or description of this company.IC01.1, IC01.4
ICC-COST-METHOD
COST_METHOD
Alpha 4This 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
IC01.1
ICC-NUMBER-PDS
NUMBER_PDS
Numeric 2This 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
IC01.2
ICC-CURR-YEAR
CURR_YEAR
Numeric 4This field determines the year that is updated with the summarized history.DR100, IC01.2, IC190
ICC-CURR-PERIOD
CURR_PERIOD
Numeric 2This field determines the period that is updated with the summarized history.IC01.2, IC190
ICC-CURR-YEAR-PDS
CURR_YEAR_PDS
Numeric 8 (yyyymmdd) Occurs 53 Times ×53This field contains the ending dates for each inventory period. This date determines which period gets updated with the summarized history.IC01.2, IC190
ICC-CURR-YEAR-STS
CURR_YEAR_STS
Alpha 1 Occurs 53 Times ×53This 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
IC01.2, IC190
ICC-LST-YR-END-DT
LST_YR_END_DT
Numeric 8 (yyyymmdd)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.IC01.1, IC190
ICC-AUDIT-ITL-FL
AUDIT_ITL_FL
Alpha 1This flag indicates whether changes to the Item Location file are to be audited.
  • N No
  • Y Yes
IC01.1
ICC-UOM-REQ-FL
UOM_REQ_FL
Alpha 1This 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
IC01.1
ICC-NEG-SOH-FL
NEG_SOH_FL
Alpha 1This 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
IC01.1
ICC-BIN-TYPE
BIN_TYPE
Alpha 1 Occurs 9 Times ×9This field indicates how the bin is used. One example is inspection.IC01.3
ICC-BIN-TYPE-DESC
BIN_TYPE_DESC
Alpha 10 (Lower Case)Occurs 9 Times This field contains the description of the bin type code.IC01.3
ICC-BIN-REC-FL
BIN_REC_FL
Alpha 1 Occurs 9 Times ×9This 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
IC01.3
ICC-BIN-ISSUES-FL
BIN_ISSUES_FL
Alpha 1 Occurs 9 Times ×9This 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
IC01.3
ICC-ORDER-COST
ORDER_COST
Signed 18.2This field contains the average cost of ordering an item. This amount is used in the economic order quantity calculation.IC01.1
ICC-CARRY-PCT
CARRY_PCT
Percent 4.2 (Percent)This field contains the percent of the inventory carrying cost. This percent is used in the economic order quantity calculation.IC01.1
ICC-SP-DEC-QTY
SP_DEC_QTY
Numeric 1This field contains the number of 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
IC01.1, MA90.2, MA90.3, MA90.4, MA90.5, PO115, PO15.1, PO15.2 +2 more
ICC-SP-DEC-COST-P
SP_DEC_COST_P
Numeric 1This field contains the number of 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
IC01.1, MA90.2, MA90.3, MA90.4, MA90.5
ICC-LAST-IF-LINE
LAST_IF_LINE
Numeric 6This field contains the line number of the last record added to the PO Interface file.DR100, IC140, IC66.1
ICC-COMPLETE-FLAG
COMPLETE_FLAG
Alpha 1This field determines whether all setup forms have been processed when adding a new company in Company (IC01.1).
  • N No
  • Y Yes
IC01.1
ICC-SELL-ALLOC-FL
SELL_ALLOC_FL
Alpha 1This 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
IC01.1
ICC-SELL-INPROC-FL
SELL_INPROC_FL
Alpha 1This 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
IC01.1
ICC-SELL-BCKORD-FL
SELL_BCKORD_FL
Alpha 1This 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
IC01.1
ICC-SELL-INTRNC-FL
SELL_INTRNC_FL
Alpha 1This 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
IC01.1
ICC-SELL-ONORD-FL
SELL_ONORD_FL
Alpha 1This 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
IC01.1
ICC-SELL-WIP-FL
SELL_WIP_FL
Alpha 1This 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
IC01.1
ICC-SELL-HOLD-FL
SELL_HOLD_FL
Alpha 1This 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
IC01.1
ICC-ALC-ALLOC-FL
ALC_ALLOC_FL
Alpha 1This 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
IC01.1
ICC-ALC-INPROC-FL
ALC_INPROC_FL
Alpha 1This 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
IC01.1
ICC-ALC-BCKORD-FL
ALC_BCKORD_FL
Alpha 1This 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
IC01.1
ICC-ALC-INTRNC-FL
ALC_INTRNC_FL
Alpha 1This 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
IC01.1
ICC-ALC-ONORD-FL
ALC_ONORD_FL
Alpha 1This 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
IC01.1
ICC-ALC-WIP-FL
ALC_WIP_FL
Alpha 1This 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
IC01.1
ICC-ALC-HOLD-FL
ALC_HOLD_FL
Alpha 1This 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
IC01.1
ICC-ALLOC-FL
ALLOC_FL
Alpha 1This 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
IC01.1
ICC-ALLOC-BASIS
ALLOC_BASIS
Alpha 1This field is used to determine if the batch allocation program should allocate demand based on requested date or the priority.
  • D Date
  • P Priority
IC01.1
ICC-CX-PRIORITY
CX_PRIORITY
Numeric 2IC01.1
ICC-OE-PRIORITY
OE_PRIORITY
Numeric 2IC01.1
ICC-RQ-PRIORITY
RQ_PRIORITY
Numeric 2IC01.1
ICC-WO-PRIORITY
WO_PRIORITY
Numeric 2IC01.1
ICC-PCK-COM-OPT
PCK_COM_OPT
Alpha 1 Occurs 10 Times ×10These 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
IC01.4
ICC-PAK-COM-OPT
PAK_COM_OPT
Alpha 1 Occurs 10 Times ×10
  • X Print Comments
IC01.4
ICC-REL-COM-OPT
REL_COM_OPT
Alpha 1 Occurs 10 Times ×10
ICC-LAST-WO-NBR
LAST_WO_NBR
Numeric 8This 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
WO_NBR_TYPE
Alpha 1Work Order Numbering Type.
  • A Auto Assign Work Order Number
  • M Manually Assign Work Order Nbr
  • N Not Using Work Order
IC01.1
ICC-RQ-SEARCH-CAT
RQ_SEARCH_CAT
Numeric 1IC01.1
ICC-RQ-SHOP-LIST
RQ_SHOP_LIST
Numeric 1IC01.1
ICC-RQ-EXPRESS-ORD
RQ_EXPRESS_ORD
Numeric 1IC01.1
ICC-RQ-SPEC-SERV
RQ_SPEC_SERV
Numeric 1IC01.1
ICC-RQ-GLOM
RQ_GLOM
Numeric 1IC01.1
ICC-RQ-CATEGORIES
RQ_CATEGORIES
Numeric 1IC01.1
ICC-RQ-SELECT-ALL
RQ_SELECT_ALL
Alpha 1
  • D Display
  • H Hide
ICC-CONTRACTS-ONLY
CONTRACTS_ONLY
Alpha 1
  • Y Yes
  • N No
  • I IC12 Setup
IC01.1
ICC-INTERNAL-ONLY
INTERNAL_ONLY
Alpha 1
  • Y Yes
  • N No
  • I IC12 Setup
IC01.1
ICC-AUDIT-ITM-FL
AUDIT_ITM_FL
Alpha 1This flag indicates whether changes to the ITEMSRC table are to be audited.IC01.1
ICC-IC-RUN-ST
IC_RUN_ST
Numeric 1This 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.IC130
ICC-APPROVAL-TYPE
APPROVAL_TYPE
Alpha 1The type of approval record.
  • 0 Header approval-Approval codes
  • 1 Header approval-Process Flow
  • 2 Line approval
  • 3 No approval required
IC01.1
ICC-AL-ALLOC-FL
AL_ALLOC_FL
DerivedUsed in the Allocatable quantity calculation in Itemloc file.
ICC-AL-INPROC-FL
AL_INPROC_FL
DerivedUsed in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-BCKORD-FL
AL_BCKORD_FL
DerivedUsed in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-INTRNC-FL
AL_INTRNC_FL
DerivedUsed in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-ONORD-FL
AL_ONORD_FL
DerivedUsed in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-WIP-FL
AL_WIP_FL
DerivedUsed in the Allocatable quantity calculation in the Itemloc file.
ICC-AL-HOLD-FL
AL_HOLD_FL
DerivedUsed in the Allocatable quantity calculation in the Itemloc file.
ICC-SL-ALLOC-FL
SL_ALLOC_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-SL-INPROC-FL
SL_INPROC_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-SL-BCKORD-FL
SL_BCKORD_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-SL-INTRNC-FL
SL_INTRNC_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-SL-ONORD-FL
SL_ONORD_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-SL-WIP-FL
SL_WIP_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-SL-HOLD-FL
SL_HOLD_FL
DerivedUsed in the Sellable quantity calculation in the Itemloc file.
ICC-GLN-NBR
GLN_NBR
Alpha 13AP510, IC01.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +3 more
ICC-AUDIT-ICA-FL
AUDIT_ICA_FL
Numeric 1This flag indicates whether changes to the ICCATEGORY table are to be audited.
  • 0 No
  • 1 Yes
IC01.1
ICC-AUDIT-RQL-FL
AUDIT_RQL_FL
Numeric 1This flag indicates whether changes to the RQLOC table are to be audited.
  • 0 No
  • 1 Yes
IC01.1
ICC-AUDIT-REQ-FL
AUDIT_REQ_FL
Numeric 1This flag indicates whether changes to the REQUESTER table are to be audited.
  • 0 No
  • 1 Yes
IC01.1
ICC-AUDIT-ICL-FL
AUDIT_ICL_FL
Numeric 1This flag indicates whether changes to the ICLOCATION table are to be audited.
  • 0 No
  • 1 Yes
IC01.1
ICC-AUDIT-HCI-FL
AUDIT_HCI_FL
Numeric 1This flag indicates whether changes to the HCCHRGITEM table are to be audited.
  • 0 No
  • 1 Yes
IC01.1
ICC-AUDIT-RQH-FL
AUDIT_RQH_FL
Numeric 1This flag indicates whether changes to requisitions are to be audited.
  • 0 No
  • 1 Yes
IC01.1
ICC-AUDIT-ICR-FL
AUDIT_ICR_FL
Numeric 1
  • 0 No
  • 1 Yes
IC01.1
ICC-ALLOCATE-PART
ALLOCATE_PART
Alpha 1This flag determines if partial qtys of the original item should be allocated if they exist. This is used by Requisition (RQ10.1). The default value is N.
  • Y Yes, allocate partial qtys.
  • N No, do not allocate partial qtys.
IC01.1
ICC-AUDIT-HPP-FL
AUDIT_HPP_FL
Numeric 1IC01.1
ICC-AUDIT-ICB-FL
AUDIT_ICB_FL
Alpha 1
  • N No
  • Y Yes
IC01.1
ICC-AUDIT-BGD-FL
AUDIT_BGD_FL
Alpha 1
  • N No
  • Y Yes
IC01.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICCSET1COMPANYPrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
ICCSET2ITEM-GROUP, COMPANYKeyChangeDR100, IC00.1, IC01.1, IC07.1, IC10.1, IC10.2, IC11.1, IC14.1 +22 more (list truncated in source)
ICCSET3COMPANY, ITEM-GROUPKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CxcompanyCXCOMPANYNot RequiredICC-COMPANYCXC-COMPANY
Gl CompanyGLSYSTEMNot RequiredICC-COMPANYGLS-COMPANY
GlnlocGLNLOCNot RequiredValid When ICC-GLN-NBR != SpacesICC-ITEM-GROUPGLO-ITEM-GROUP, ICC-GLN-NBRGLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When ICC-GLN-NBR != SpacesICC-ITEM-GROUPGLX-ITEM-GROUP, 2GLX-GLN-TYPE, ICC-COMPANYGLX-COMPANY, SpacesGLX-LOCATION, SpacesGLX-BIN, ICC-GLN-NBRGLX-GLN-NBR
ItemgroupITEMGROUPRequiredICC-ITEM-GROUPITG-ITEM-GROUP

One to many (9) — child tables

RelationTableRulesConditionField map
CustorderCUSTORDERICC-COMPANYCOR-COMPANY, COR-ORDER-NBR
ItemdescITEMMASTITG-ITEM-GROUPITE-ITEM-GROUP, ITE-DESCRIPTION, ITE-ITEM
ItemformatITEMFORMATDelete RestrictedICC-COMPANYITF-COMPANY, ITF-FORMAT-ID
ItemgenericITEMMASTITG-ITEM-GROUPITE-ITEM-GROUP, ITE-GENERIC, ITE-ITEM
IteminvenITEMMASTITG-ITEM-GROUPITE-ITEM-GROUP, ITE-INVEN-MAJCL, ITE-INVEN-MINCL, ITE-ITEM
ItemmastITEMMASTICC-ITEM-GROUPITE-ITEM-GROUP, ITE-ITEM
ItempurchITEMMASTITG-ITEM-GROUPITE-ITEM-GROUP, ITE-PURCH-MAJCL, ITE-PURCH-MINCL, ITE-ITEM
ItemsalesITEMMASTITG-ITEM-GROUPITE-ITEM-GROUP, ITE-SALES-MAJCL, ITE-SALES-MINCL, ITE-ITEM
ReasoncodeREASONDelete RestrictedICC-COMPANYREA-COMPANY, REA-REASON-CODE

Programs

Updated by (329)

Referenced by (296)