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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3
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 2—IC01.1
#ICC-OE-PRIORITY
OE_PRIORITY
Numeric 2—IC01.1
#ICC-RQ-PRIORITY
RQ_PRIORITY
Numeric 2—IC01.1
#ICC-WO-PRIORITY
WO_PRIORITY
Numeric 2—IC01.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 1—IC01.1
#ICC-RQ-SHOP-LIST
RQ_SHOP_LIST
Numeric 1—IC01.1
#ICC-RQ-EXPRESS-ORD
RQ_EXPRESS_ORD
Numeric 1—IC01.1
#ICC-RQ-SPEC-SERV
RQ_SPEC_SERV
Numeric 1—IC01.1
#ICC-RQ-GLOM
RQ_GLOM
Numeric 1—IC01.1
#ICC-RQ-CATEGORIES
RQ_CATEGORIES
Numeric 1—IC01.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 13—AP510, 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 1—IC01.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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICCSET1
  1. COMPANY
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
ICCSET2
  1. ITEM-GROUP
  2. COMPANY
KeyChangeDR100, IC00.1, IC01.1, IC07.1, IC10.1, IC10.2, IC11.1, IC14.1 +22 more (list truncated in source)
ICCSET3
  1. COMPANY
  2. ITEM-GROUP
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CXCOMPANYGLSYSTEMGLNLOCGLNLOCDTLITEMGROUPCUSTORDERITEMMASTITEMFORMATREASONICCOMPANY

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CxcompanyCXCOMPANYNot Required
ICC-COMPANY→CXC-COMPANY
Gl CompanyGLSYSTEMNot Required
ICC-COMPANY→GLS-COMPANY
GlnlocGLNLOCNot RequiredValid When ICC-GLN-NBR != Spaces
ICC-ITEM-GROUP→GLO-ITEM-GROUP
ICC-GLN-NBR→GLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When ICC-GLN-NBR != Spaces
ICC-ITEM-GROUP→GLX-ITEM-GROUP
2→GLX-GLN-TYPE
ICC-COMPANY→GLX-COMPANY
Spaces→GLX-LOCATION
Spaces→GLX-BIN
ICC-GLN-NBR→GLX-GLN-NBR
ItemgroupITEMGROUPRequired
ICC-ITEM-GROUP→ITG-ITEM-GROUP

One to many (9) — child tables

RelationTableRulesConditionField map
CustorderCUSTORDER
ICC-COMPANY→COR-COMPANY
—→COR-ORDER-NBR
ItemdescITEMMAST
ITG-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-DESCRIPTION
—→ITE-ITEM
ItemformatITEMFORMATDelete Restricted
ICC-COMPANY→ITF-COMPANY
—→ITF-FORMAT-ID
ItemgenericITEMMAST
ITG-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-GENERIC
—→ITE-ITEM
IteminvenITEMMAST
ITG-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-INVEN-MAJCL
—→ITE-INVEN-MINCL
—→ITE-ITEM
ItemmastITEMMAST
ICC-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-ITEM
ItempurchITEMMAST
ITG-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-PURCH-MAJCL
—→ITE-PURCH-MINCL
—→ITE-ITEM
ItemsalesITEMMAST
ITG-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-SALES-MAJCL
—→ITE-SALES-MINCL
—→ITE-ITEM
ReasoncodeREASONDelete Restricted
ICC-COMPANY→REA-COMPANY
—→REA-REASON-CODE

Programs

Updated by (329)

Referenced by (296)