ICLOCATION – Company Location

System
Inventory Control (IC)
Prefix
ICL
Primary key
COMPANY, LOCATION
Fields
115
Updated by
280 programs
Referenced by
267 programs

ICLOCATION is the Company Location table in Lawson Inventory Control (prefix ICL). It is indexed by COMPANY, LOCATION (ICLSET1); alternate indexes: ICLSET2, ICLSET3, ICLSET4, ICLSET5 and ICLSET6. It is related 1:1 to ICCOMPANY, GLMASTER, GLNLOC, GLNLOCDTL, ICLBOD and ICLOCATION and 1:M to ICBIN, ICCATEGORY, ICICLAUDIT, ICLOCGRP and ITEMLOC. It is updated by AP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 and 272 more and referenced by API6.2, AR08.1, AR10.1, AR501, AR550, CX05.1, CX05.2, CX205 and 259 more. The table has 115 fields, 6 indexes and 17 documented relations.

About ICLOCATION

The Company Location file stores valid locations within a company. The locations establish the identification of stock locations.

Fields (115)

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

Field / columnTypeDescription & valuesUpdated by
ICL-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.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-LOCATION-TYPE
LOCATION_TYPE
Alpha 1This field specifies whether this location is a normal inventory location or an exchange cart or a par location. This is used in the par location replenishment process. " " = Inventory Location
  • E Exchange Cart
  • P Par Location
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-LOCATION PK
LOCATION
Alpha 5This field contains a valid stocking location within the company inventory.AP510, IC02.1, IC02.2, IC138, IC64.1, IC64.2, IC64.3, IC64.4 +9 more
ICL-NAME
NAME
Alpha 30 (Lower Case)This field contains the location's name defined in Location (IC02.1).AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +14 more
ICL-REPL-FROM-LOC
REPL_FROM_LOC
Alpha 5This field contains a valid stocking location within the company inventory.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-ADDR1
ADDR1
Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-ADDR2
ADDR2
Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-ADDR3
ADDR3
Alpha 30 (Lower Case)This field contains the third line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-ADDR4
ADDR4
Alpha 30 (Lower Case)This field contains the fourth line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-CITY-ADDR5
CITY_ADDR5
Alpha 18 (Lower Case)This field contains the fifth line and/or the city of the address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-STATE-PROV
STATE_PROV
Alpha 2This field contains the state or province of the address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-POSTAL-CODE
POSTAL_CODE
Alpha 10 (Lower Case)This field contains the postal code of the address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-COUNTRY
COUNTRY
Alpha 30 (Lower Case)This field contains the country of the address, or it can contain additional information such as an attention name.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +9 more
ICL-COUNTY
COUNTY
Alpha 25 (Lower Case)The county for the company address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-ADDR-CONTACT
ADDR_CONTACT
Alpha 30 (Lower Case)This field contains the name of the main contact.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-NAME
PO_NAME
Alpha 30 (Lower Case)This field contains the name of the ship to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +10 more
ICL-PO-ADDR1
PO_ADDR1
Alpha 30 (Lower Case)This field contains the first line of ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-ADDR2
PO_ADDR2
Alpha 30 (Lower Case)This field contains the second line of the ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-ADDR3
PO_ADDR3
Alpha 30 (Lower Case)This field contains the third line of the ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-ADDR4
PO_ADDR4
Alpha 30 (Lower Case)This field contains the fourth line of the ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-CITY-ADDR5
PO_CITY_ADDR5
Alpha 18 (Lower Case)This field contains the fifth line or city of the ship-to address. This information is printed on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-STATE-PROV
PO_STATE_PROV
Alpha 2This field contains the state or province of the ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-POSTAL-CD
PO_POSTAL_CD
Alpha 10 (Lower Case)This field contains the postal code of the ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-COUNTRY
PO_COUNTRY
Alpha 30 (Lower Case)This field contains the country of the ship-to address. This information prints on purchase orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-COUNTY
PO_COUNTY
Alpha 25 (Lower Case)The county for the company address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HIN-NBR
HIN_NBR
Alpha 9The Health Industry Number is a unique number assigned to any company or facility doing business in the health industry. This number is assigned by the Health Industry Business Communications Council (HIBCC).AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-OE-RUN-STS
OE_RUN_STS
Numeric 1This field indicates which processing form is currently running or has been run.
  • 0 No Processing In Progress
  • 1 Allocation Feedback Running
  • 2 Pick List Print Running
  • 3 Picking Feedback Running
  • 4 Packing Feedback Running
  • 5 Shipping Feedback Running
  • 6 IC Reorder Running
AP510, DR100, IC02.1, IC02.2, IC141, IC142, IC143, IC64.1 +14 more
ICL-PROCESS-TYPE
PROCESS_TYPE
Alpha 2This field is the process type to be used for orders and requisitions. The process type determines which steps (pick, pack, and ship) are to be used in the Warehouse system.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-ALLOC-PURP
ALLOC_PURP
Alpha 1This field determines the allocation method to be used when allocating bin tracked items. Consolidated allocating allocates the bin with the smallest quantity first. Speed picking allocates the bin with the largest quantity first.
  • C Consolidated Bins
  • S Speed Picking
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-LAST-BATCH-NBR
LAST_BATCH_NBR
Numeric 8This field is used to assign batch numbers to the pick list in the Warehouse system. This field is incremented by one every time the pick list program (WH130) is run for this location.AP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
ICL-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-TAX-CODE
PO_TAX_CODE
Alpha 10AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-CODE
PO_CODE
Alpha 4This is the purchase order code that will default to a purchase order from the inventory location.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-LAST-BT-DATE
LAST_BT_DATE
Numeric 8 (yyyymmdd)This field contains the last date of a bin transfer. This date is used for automatically assigning document numbers in IC26.1 (Detail Transfers) and IC138 (Bin Replenishment Report).AP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
ICL-LAST-BT-LINE
LAST_BT_LINE
Numeric 6This field contains the last line number used on a bin transfer. This number is used when IC26.1 (Detail Transfers) and IC138 (Bin Replenishment Report) automatically create lines for a document.AP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
ICL-LAST-SHIP-NBR
LAST_SHIP_NBR
Numeric 10This field is used to determine the shipment number on the pick list in the Warehouse system.AP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 +52 more (list truncated in source)
ICL-SUSP-ACCT-UNIT
SUSP_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SUSP-ACCOUNT
SUSP_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SUSP-SUB-ACCT
SUSP_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-FRT-ACCT-UNIT
FRT_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-FRT-ACCOUNT
FRT_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-FRT-SUB-ACCT
FRT_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HDLG-ACCT-UNIT
HDLG_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HDLG-ACCOUNT
HDLG_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HDLG-SUB-ACCT
HDLG_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SCRP-ACCT-UNIT
SCRP_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SCRP-ACCOUNT
SCRP_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SCRP-SUB-ACCT
SCRP_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HOLD-ACCT-UNIT
HOLD_ACCT_UNIT
Alpha 15AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HOLD-ACCOUNT
HOLD_ACCOUNT
Numeric 6AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-HOLD-SUB-ACCT
HOLD_SUB_ACCT
Numeric 4AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-ERS-CAPABLE
ERS_CAPABLE
Alpha 1
  • Y Yes
  • N No
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PAR-VALUE
PAR_VALUE
Signed 18.2The value of the inventory stored at the par location.AP510, IC02.1, IC02.2, IC283, IC64.1, IC64.2, IC64.3, IC64.4 +9 more
ICL-WST-ACCT-UNIT
WST_ACCT_UNIT
Alpha 15The waste account unit is used to default to components added to finished goods templates or added to work orders when no account information is entered.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WST-ACCOUNT
WST_ACCOUNT
Numeric 6The waste account is used to default to components added to finished goods templates or added to work orders when no account information is entered.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WST-SUB-ACCT
WST_SUB_ACCT
Numeric 4The waste subaccount is used to default to components added to finished goods templates or added to work orders when no account information is entered.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WO-LOC-TYPE
WO_LOC_TYPE
Alpha 1
  • N Not a Work Order Location
  • O Offsite Location
  • P Production Location
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-CALENDAR
CALENDAR
Alpha 15This is the name of the calendar used in the production scheduling process for work orders.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-DEMAND-SOURCE
DEMAND_SOURCE
Numeric 1This is the source of demand that is gathered for use in production scheduling for work orders.
  • 1 Document Demand
  • 2 Forecast Demand
  • 3 Document and Forecast Demand
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WIP-ACCT-UNIT
WIP_ACCT_UNIT
Alpha 15The work-in-process account unit is used to post component costs of a work order to a WIP account when the components are pulled out of inventory in a work order feedback process.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WIP-ACCOUNT
WIP_ACCOUNT
Numeric 6The work-in-process account is used to post component costs of a work order to a WIP account when the components are pulled out of inventory in a work order feedback process.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WIP-SUB-ACCT
WIP_SUB_ACCT
Numeric 4The work-in-process subaccount is used to post component costs of a work order to a WIP account when the components are pulled out of inventory in a work order feedback process.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-FGV-ACCT-UNIT
FGV_ACCT_UNIT
Alpha 15The finished good variance accounting unit is used to post variances in finished good cost when there is a difference between the cost from an original work order and the cost returned from inventory for a reversed work order.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-FGV-ACCOUNT
FGV_ACCOUNT
Numeric 6The finished good variance account is used to post variances in finished good cost when there is a difference between the cost from the original work order and the cost returned from inventory for a reversed work order.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-FGV-SUB-ACCT
FGV_SUB_ACCT
Numeric 4The finished good variance subaccount is used to post variances in finished good cost when there is a difference between the cost from the original work order and the cost returned from inventory for a reversed work order.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-CAPACITY
CAPACITY
Numeric 8This is the maximum quantity of a finished good that can be scheduled to a single work order. The capacity in this file is used to default to the capacity field on the build process of the work order production scheduling process.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SCHED-INCR
SCHED_INCR
Numeric 2Schedule increment is used with schedule frequency to indicate the length of a scheduling period for work orders. The increment is the number of days, weeks or months in a period.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SCHED-FREQ
SCHED_FREQ
Alpha 1Schedule frequency is used with schedule increment to indicate the length of a scheduling period for work orders. The frequency defines whether the period is in days, weeks or months.
  • D Days
  • W Weeks
  • M Months
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WO-STATUS
WO_STATUS
Numeric 1This is the work order status to default to the status for the build process of the work order production scheduling process.
  • 1 Unreleased
  • 2 Released
  • 3 Exploded
  • 4 In Production
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WO-ACCOUNT-FL
WO_ACCOUNT_FL
Alpha 1This indicates if you are using income statement accounts in Production Order. " " = No
  • Y Yes
  • N No
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-WO-IN-PROD-FL
WO_IN_PROD_FL
Alpha 1
  • Y In prod unrestricted by alloc
  • N In prod restricted by alloc
  • O No - but override allowed
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PRINT-LABELS
PRINT_LABELS
Alpha 1AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PURCH-FR-LOC
PURCH_FR_LOC
Alpha 4The vendor's purchase from location.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-CUSTOMER
CUSTOMER
Alpha 9 (Right Justified)This field contains the number that represents a customer.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-SHIP-TO
SHIP_TO
Numeric 4This field contains the number representing the ship to customer.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PROC-DAYS
PROC_DAYS
Numeric 3AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-REC-ALLOCATE
REC_ALLOCATE
Numeric 1This field is used to determine if receiving allocation should be attempted and which method to use. Valid values are: 0 - No Receiving Allocation (default) 1 - PO Line Source Alloocation 2 - PO Line Source & Std Allocation
  • 0 No Receiving Allocation
  • 1 PO LIne Source Allocation
  • 2 PO Line Source & Std Allocatio
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-COUNTRY-CODE
COUNTRY_CODE
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-REGION
REGION
Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-COUNTRY-CD
PO_COUNTRY_CD
Alpha 2The PO country code. Required for VAT and Intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-PO-REGION
PO_REGION
Alpha 2The PO region code, if applicable for the country. Used only by Intrastat. Must be a valid region code for the country, defined in IN02.1 (Region Maintenance).AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-ISS-AU-FL
ISS_AU_FL
Alpha 1This flag is used in the issue acct dflt routine to determine if this location wants the Account Unit defaulted on issues from the "From" location. N YAP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-NAME
POB_NAME
Alpha 30 (Lower Case)Displays the company description.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-ADDR1
POB_ADDR1
Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-ADDR2
POB_ADDR2
Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-ADDR3
POB_ADDR3
Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-ADDR4
POB_ADDR4
Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-CITY-ADDR5
POB_CITY_ADDR5
Alpha 18 (Lower Case)This field contains the city of the address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-STATE-PROV
POB_STATE_PROV
Alpha 2The state or province.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-POSTAL-CD
POB_POSTAL_CD
Alpha 10 (Lower Case)This field contains the postal code.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-COUNTRY-CD
POB_COUNTRY_CD
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-COUNTY
POB_COUNTY
Alpha 25 (Lower Case)The county for the company address.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-CONTACT
POB_CONTACT
Alpha 30 (Lower Case)This is the name of the main contact.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-GLN-NBR
GLN_NBR
Alpha 13AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-REPL-REQUESTER
REPL_REQUESTER
Alpha 10 (Lower Case)This is the person who requested this requisition.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-RETAIL-LOC-FL
RETAIL_LOC_FL
Alpha 1" " = None
  • S Store
  • W Warehouse
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-ICL-OBJ-ID
ICL_OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +10 more
ICL-ONE-SRC-ONE-PO
ONE_SRC_ONE_PO
Numeric 1
  • 0 No
  • 1 One Requisition to One PO
  • 2 One Sales Order to One PO
  • 3 Req and Sales Order to One PO
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-DROPSHIP-FL
DROPSHIP_FL
Alpha 1AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-PHONE-PREF
POB_PHONE_PREF
Alpha 6AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-PHONE
POB_PHONE
Alpha 15AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-PHONE-EXT
POB_PHONE_EXT
Alpha 5AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-POB-EMAIL-ADDR
POB_EMAIL_ADDR
Alpha 60 (Lower Case)AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-STATUS
STATUS
Numeric 1
  • 0 Active
  • 1 Inactive
  • 2 Add Inactive
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-EAM-LOC-FL
EAM_LOC_FL
Alpha 1" " = Normal Lawson Location
  • 1 EAM Location
  • 2 SCE Location
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-GEO-TYPE
GEO_TYPE
Alpha 4
ICL-GEO-LATITUDE
GEO_LATITUDE
Signed 12.6
ICL-GEO-LONGITUDE
GEO_LONGITUDE
Signed 12.6
ICL-GEO-ALTITUDE
GEO_ALTITUDE
Signed 12.6
ICL-GEO-DATE
GEO_DATE
Numeric 8 (yyyymmdd)
ICL-GEO-TIME
GEO_TIME
Numeric 8
ICL-APPROVAL-TYPE
APPROVAL_TYPE
Alpha 1The type of PO approval record. " " = Use value from PO Company
  • 0 Header approval-PO approval cd
  • 1 Header approval-Process Flow
  • 2 No approval required
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
ICL-MSCM-DELIVERY
MSCM_DELIVERY
Numeric 1This field indentifies whether the location uses MSCM for delivery.
  • 0 No
  • 1 Yes
AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more

Indexes (6)

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

IndexKeysFlagsConditionUsed in
ICLSET1COMPANY, LOCATIONPrimaryAP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
ICLSET2COMPANY, LOCATIONSubsetWhere LOCATION-TYPE = "E" Or LOCATION-TYPE = "P"IC281, IC331, IC81.1, IC82.1, IC83.1
ICLSET3COMPANY, LOCATIONSubsetWhere WO-LOC-TYPE != "N"IC01.1
ICLSET4VENDOR, PURCH-FR-LOC, COMPANY, LOCATIONKeyChange, SubsetWhere VENDOR != SpacesIC02.1
ICLSET5CUSTOMER, SHIP-TO, COMPANY, LOCATIONKeyChange, SubsetWhere CUSTOMER != SpacesIC02.1, WH20.7
ICLSET6ICL-OBJ-IDKeyChange, SubsetWhere ICL-OBJ-ID != ZeroesIC02.5, IC02.6, IC145, IC222, IC223, IC243, ICLM.1, MX223 +1 more

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
CompanyICCOMPANYRequiredICL-COMPANYICC-COMPANY
Fgv AccountGLMASTERNot RequiredICL-COMPANYGLM-COMPANY, ICL-FGV-ACCT-UNITGLM-ACCT-UNIT, ICL-FGV-ACCOUNTGLM-ACCOUNT, ICL-FGV-SUB-ACCTGLM-SUB-ACCOUNT
Frt AccountGLMASTERRequiredWhen ICL-FRT-ACCT-UNIT != Spaces Or ICL-FRT-ACCOUNT != Zeroes Or ICL-FRT-SUB-ACCT != ZeroesICL-COMPANYGLM-COMPANY, ICL-FRT-ACCT-UNITGLM-ACCT-UNIT, ICL-FRT-ACCOUNTGLM-ACCOUNT, ICL-FRT-SUB-ACCTGLM-SUB-ACCOUNT
GlnlocGLNLOCNot RequiredValid When ICL-GLN-NBR != SpacesICC-ITEM-GROUPGLO-ITEM-GROUP, ICL-GLN-NBRGLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When ICL-GLN-NBR != SpacesICC-ITEM-GROUPGLX-ITEM-GROUP, 3GLX-GLN-TYPE, ICL-COMPANYGLX-COMPANY, ICL-LOCATIONGLX-LOCATION, SpacesGLX-BIN, ICL-GLN-NBRGLX-GLN-NBR
Hdlg AccountGLMASTERRequiredWhen ICL-HDLG-ACCT-UNIT != Spaces Or ICL-HDLG-ACCOUNT != Zeroes Or ICL-HDLG-SUB-ACCT != ZeroesICL-COMPANYGLM-COMPANY, ICL-HDLG-ACCT-UNITGLM-ACCT-UNIT, ICL-HDLG-ACCOUNTGLM-ACCOUNT, ICL-HDLG-SUB-ACCTGLM-SUB-ACCOUNT
IclbodICLBODNot Required, Delete CascadesICL-COMPANYIBE-COMPANY, ICL-LOCATIONIBE-LOCATION
Repl From LocICLOCATIONNot RequiredValid When ICL-REPL-FROM-LOC != SpacesICL-COMPANYICL-COMPANY, ICL-REPL-FROM-LOCICL-LOCATION
Scrap AccountGLMASTERRequiredWhen ICL-SCRP-ACCT-UNIT != Spaces Or ICL-SCRP-ACCOUNT != Zeroes Or ICL-SCRP-SUB-ACCT != ZeroesICL-COMPANYGLM-COMPANY, ICL-SCRP-ACCT-UNITGLM-ACCT-UNIT, ICL-SCRP-ACCOUNTGLM-ACCOUNT, ICL-SCRP-SUB-ACCTGLM-SUB-ACCOUNT
Suspense AcctGLMASTERNot RequiredValid When ICL-SUSP-ACCT-UNIT != Spaces Or ICL-SUSP-ACCOUNT != Zeroes Or ICL-SUSP-SUB-ACCT != ZeroesICL-COMPANYGLM-COMPANY, ICL-SCRP-ACCT-UNITGLM-ACCT-UNIT, ICL-SUSP-ACCOUNTGLM-ACCOUNT, ICL-SUSP-SUB-ACCTGLM-SUB-ACCOUNT
Waste AccountGLMASTERNot RequiredICL-COMPANYGLM-COMPANY, ICL-WST-ACCT-UNITGLM-ACCT-UNIT, ICL-WST-ACCOUNTGLM-ACCOUNT, ICL-WST-SUB-ACCTGLM-SUB-ACCOUNT
Wip AccountGLMASTERNot RequiredICL-COMPANYGLM-COMPANY, ICL-WIP-ACCT-UNITGLM-ACCT-UNIT, ICL-WIP-ACCOUNTGLM-ACCOUNT, ICL-WIP-SUB-ACCTGLM-SUB-ACCOUNT

One to many (5) — child tables

RelationTableRulesConditionField map
IcbinICBINDelete RestrictedICL-COMPANYICB-COMPANY, ICL-LOCATIONICB-LOCATION, ICB-BIN
IccategoryICCATEGORYDelete RestrictedICL-COMPANYICA-COMPANY, ICL-LOCATIONICA-LOCATION, ICA-GL-CATEGORY
IciclauditICICLAUDITICL-COMPANYILA-COMPANY, ICL-LOCATIONILA-LOCATION, ILA-SYSTEM-CD, ILA-SEQ, ILA-DATE, ILA-TIME, ILA-FLD-NBR
IclocgrpICLOCGRPICL-COMPANYILG-COMPANY, ICL-LOCATIONILG-LOCATION, ILG-SYSTEM-CD, ILG-SEQ
ItemlocITEMLOCDelete RestrictedICL-COMPANYITL-COMPANY, ICL-LOCATIONITL-LOCATION, ITL-ITEM

Programs

Updated by (280)

Referenced by (267)