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 / column | Type | Description & values | Updated by |
|---|---|---|---|
ICL-COMPANY PKCOMPANY | Numeric 4 | Identifies 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-TYPELOCATION_TYPE | Alpha 1 | This 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
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-LOCATION PKLOCATION | Alpha 5 | This 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-NAMENAME | 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-LOCREPL_FROM_LOC | Alpha 5 | This 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-ADDR1ADDR1 | 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-ADDR2ADDR2 | 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-ADDR3ADDR3 | 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-ADDR4ADDR4 | 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-ADDR5CITY_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-PROVSTATE_PROV | Alpha 2 | This 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-CODEPOSTAL_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-COUNTRYCOUNTRY | 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-COUNTYCOUNTY | 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-CONTACTADDR_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-NAMEPO_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-ADDR1PO_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-ADDR2PO_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-ADDR3PO_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-ADDR4PO_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-ADDR5PO_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-PROVPO_STATE_PROV | Alpha 2 | This 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-CDPO_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-COUNTRYPO_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-COUNTYPO_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-NBRHIN_NBR | Alpha 9 | The 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-STSOE_RUN_STS | Numeric 1 | This field indicates which processing form is currently running or has been run.
| AP510, DR100, IC02.1, IC02.2, IC141, IC142, IC143, IC64.1 +14 more |
ICL-PROCESS-TYPEPROCESS_TYPE | Alpha 2 | This 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-PURPALLOC_PURP | Alpha 1 | This 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.
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-LAST-BATCH-NBRLAST_BATCH_NBR | Numeric 8 | This 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-CODETAX_CODE | Alpha 10 | This 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-CODEPO_TAX_CODE | Alpha 10 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-PO-CODEPO_CODE | Alpha 4 | This 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-DATELAST_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-LINELAST_BT_LINE | Numeric 6 | This 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-NBRLAST_SHIP_NBR | Numeric 10 | This 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-UNITSUSP_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTSUSP_ACCOUNT | Numeric 6 | This 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-ACCTSUSP_SUB_ACCT | Numeric 4 | This 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-UNITFRT_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTFRT_ACCOUNT | Numeric 6 | This 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-ACCTFRT_SUB_ACCT | Numeric 4 | This 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-UNITHDLG_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTHDLG_ACCOUNT | Numeric 6 | This 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-ACCTHDLG_SUB_ACCT | Numeric 4 | This 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-UNITSCRP_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTSCRP_ACCOUNT | Numeric 6 | This 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-ACCTSCRP_SUB_ACCT | Numeric 4 | This 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-UNITHOLD_ACCT_UNIT | Alpha 15 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-HOLD-ACCOUNTHOLD_ACCOUNT | Numeric 6 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-HOLD-SUB-ACCTHOLD_SUB_ACCT | Numeric 4 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-ERS-CAPABLEERS_CAPABLE | Alpha 1 | —
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-PAR-VALUEPAR_VALUE | Signed 18.2 | The 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-UNITWST_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTWST_ACCOUNT | Numeric 6 | The 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-ACCTWST_SUB_ACCT | Numeric 4 | The 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-TYPEWO_LOC_TYPE | Alpha 1 | —
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-CALENDARCALENDAR | Alpha 15 | This 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-SOURCEDEMAND_SOURCE | Numeric 1 | This is the source of demand that is gathered for use in production scheduling for work orders.
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-WIP-ACCT-UNITWIP_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTWIP_ACCOUNT | Numeric 6 | The 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-ACCTWIP_SUB_ACCT | Numeric 4 | The 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-UNITFGV_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTFGV_ACCOUNT | Numeric 6 | The 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-ACCTFGV_SUB_ACCT | Numeric 4 | The 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-CAPACITYCAPACITY | Numeric 8 | This 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-INCRSCHED_INCR | Numeric 2 | Schedule 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-FREQSCHED_FREQ | Alpha 1 | Schedule 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.
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-WO-STATUSWO_STATUS | Numeric 1 | This is the work order status to default to the status for 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-WO-ACCOUNT-FLWO_ACCOUNT_FL | Alpha 1 | This indicates if you are using income statement accounts in Production Order. " " = No
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-WO-IN-PROD-FLWO_IN_PROD_FL | Alpha 1 | —
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | This 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-LABELSPRINT_LABELS | Alpha 1 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-VENDORVENDOR | 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-LOCPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-CUSTOMERCUSTOMER | 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-TOSHIP_TO | Numeric 4 | This 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-DAYSPROC_DAYS | Numeric 3 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-REC-ALLOCATEREC_ALLOCATE | Numeric 1 | This 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
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The 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-REGIONREGION | Alpha 2 | The 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-CDPO_COUNTRY_CD | Alpha 2 | The 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-REGIONPO_REGION | Alpha 2 | The 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-FLISS_AU_FL | Alpha 1 | This 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 Y | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-POB-NAMEPOB_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-ADDR1POB_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-ADDR2POB_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-ADDR3POB_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-ADDR4POB_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-ADDR5POB_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-PROVPOB_STATE_PROV | Alpha 2 | The state or province. | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-POB-POSTAL-CDPOB_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-CDPOB_COUNTRY_CD | Alpha 2 | The 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-COUNTYPOB_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-CONTACTPOB_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-NBRGLN_NBR | Alpha 13 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-REPL-REQUESTERREPL_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-FLRETAIL_LOC_FL | Alpha 1 | " " = None
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-ICL-OBJ-IDICL_OBJ_ID | Numeric 12 | This 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-POONE_SRC_ONE_PO | Numeric 1 | —
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-DROPSHIP-FLDROPSHIP_FL | Alpha 1 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-POB-PHONE-PREFPOB_PHONE_PREF | Alpha 6 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-POB-PHONEPOB_PHONE | Alpha 15 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-POB-PHONE-EXTPOB_PHONE_EXT | Alpha 5 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-POB-EMAIL-ADDRPOB_EMAIL_ADDR | Alpha 60 (Lower Case) | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-STATUSSTATUS | Numeric 1 | —
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-EAM-LOC-FLEAM_LOC_FL | Alpha 1 | " " = Normal Lawson Location
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-GEO-TYPEGEO_TYPE | Alpha 4 | — | — |
ICL-GEO-LATITUDEGEO_LATITUDE | Signed 12.6 | — | — |
ICL-GEO-LONGITUDEGEO_LONGITUDE | Signed 12.6 | — | — |
ICL-GEO-ALTITUDEGEO_ALTITUDE | Signed 12.6 | — | — |
ICL-GEO-DATEGEO_DATE | Numeric 8 (yyyymmdd) | — | — |
ICL-GEO-TIMEGEO_TIME | Numeric 8 | — | — |
ICL-APPROVAL-TYPEAPPROVAL_TYPE | Alpha 1 | The type of PO approval record. " " = Use value from PO Company
| AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
ICL-MSCM-DELIVERYMSCM_DELIVERY | Numeric 1 | This field indentifies whether the location uses MSCM for delivery.
| 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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ICLSET1 | COMPANY, LOCATION | Primary | AP125, AP126, AP131, AP170, AP193, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source) | |
ICLSET2 | COMPANY, LOCATION | Subset | Where LOCATION-TYPE = "E" Or LOCATION-TYPE = "P" | IC281, IC331, IC81.1, IC82.1, IC83.1 |
ICLSET3 | COMPANY, LOCATION | Subset | Where WO-LOC-TYPE != "N" | IC01.1 |
ICLSET4 | VENDOR, PURCH-FR-LOC, COMPANY, LOCATION | KeyChange, Subset | Where VENDOR != Spaces | IC02.1 |
ICLSET5 | CUSTOMER, SHIP-TO, COMPANY, LOCATION | KeyChange, Subset | Where CUSTOMER != Spaces | IC02.1, WH20.7 |
ICLSET6 | ICL-OBJ-ID | KeyChange, Subset | Where ICL-OBJ-ID != Zeroes | IC02.5, IC02.6, IC145, IC222, IC223, IC243, ICLM.1, MX223 +1 more |
Relations
One to one (12) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | ICCOMPANY | Required | ICL-COMPANY → ICC-COMPANY | |
| Fgv Account | GLMASTER | Not Required | ICL-COMPANY → GLM-COMPANY, ICL-FGV-ACCT-UNIT → GLM-ACCT-UNIT, ICL-FGV-ACCOUNT → GLM-ACCOUNT, ICL-FGV-SUB-ACCT → GLM-SUB-ACCOUNT | |
| Frt Account | GLMASTER | Required | When ICL-FRT-ACCT-UNIT != Spaces Or ICL-FRT-ACCOUNT != Zeroes Or ICL-FRT-SUB-ACCT != Zeroes | ICL-COMPANY → GLM-COMPANY, ICL-FRT-ACCT-UNIT → GLM-ACCT-UNIT, ICL-FRT-ACCOUNT → GLM-ACCOUNT, ICL-FRT-SUB-ACCT → GLM-SUB-ACCOUNT |
| Glnloc | GLNLOC | Not Required | Valid When ICL-GLN-NBR != Spaces | ICC-ITEM-GROUP → GLO-ITEM-GROUP, ICL-GLN-NBR → GLO-GLN-NBR |
| Glnlocdtl | GLNLOCDTL | Not Required | Valid When ICL-GLN-NBR != Spaces | ICC-ITEM-GROUP → GLX-ITEM-GROUP, 3 → GLX-GLN-TYPE, ICL-COMPANY → GLX-COMPANY, ICL-LOCATION → GLX-LOCATION, Spaces → GLX-BIN, ICL-GLN-NBR → GLX-GLN-NBR |
| Hdlg Account | GLMASTER | Required | When ICL-HDLG-ACCT-UNIT != Spaces Or ICL-HDLG-ACCOUNT != Zeroes Or ICL-HDLG-SUB-ACCT != Zeroes | ICL-COMPANY → GLM-COMPANY, ICL-HDLG-ACCT-UNIT → GLM-ACCT-UNIT, ICL-HDLG-ACCOUNT → GLM-ACCOUNT, ICL-HDLG-SUB-ACCT → GLM-SUB-ACCOUNT |
| Iclbod | ICLBOD | Not Required, Delete Cascades | ICL-COMPANY → IBE-COMPANY, ICL-LOCATION → IBE-LOCATION | |
| Repl From Loc | ICLOCATION | Not Required | Valid When ICL-REPL-FROM-LOC != Spaces | ICL-COMPANY → ICL-COMPANY, ICL-REPL-FROM-LOC → ICL-LOCATION |
| Scrap Account | GLMASTER | Required | When ICL-SCRP-ACCT-UNIT != Spaces Or ICL-SCRP-ACCOUNT != Zeroes Or ICL-SCRP-SUB-ACCT != Zeroes | ICL-COMPANY → GLM-COMPANY, ICL-SCRP-ACCT-UNIT → GLM-ACCT-UNIT, ICL-SCRP-ACCOUNT → GLM-ACCOUNT, ICL-SCRP-SUB-ACCT → GLM-SUB-ACCOUNT |
| Suspense Acct | GLMASTER | Not Required | Valid When ICL-SUSP-ACCT-UNIT != Spaces Or ICL-SUSP-ACCOUNT != Zeroes Or ICL-SUSP-SUB-ACCT != Zeroes | ICL-COMPANY → GLM-COMPANY, ICL-SCRP-ACCT-UNIT → GLM-ACCT-UNIT, ICL-SUSP-ACCOUNT → GLM-ACCOUNT, ICL-SUSP-SUB-ACCT → GLM-SUB-ACCOUNT |
| Waste Account | GLMASTER | Not Required | ICL-COMPANY → GLM-COMPANY, ICL-WST-ACCT-UNIT → GLM-ACCT-UNIT, ICL-WST-ACCOUNT → GLM-ACCOUNT, ICL-WST-SUB-ACCT → GLM-SUB-ACCOUNT | |
| Wip Account | GLMASTER | Not Required | ICL-COMPANY → GLM-COMPANY, ICL-WIP-ACCT-UNIT → GLM-ACCT-UNIT, ICL-WIP-ACCOUNT → GLM-ACCOUNT, ICL-WIP-SUB-ACCT → GLM-SUB-ACCOUNT |
One to many (5) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Icbin | ICBIN | Delete Restricted | ICL-COMPANY → ICB-COMPANY, ICL-LOCATION → ICB-LOCATION, → ICB-BIN | |
| Iccategory | ICCATEGORY | Delete Restricted | ICL-COMPANY → ICA-COMPANY, ICL-LOCATION → ICA-LOCATION, → ICA-GL-CATEGORY | |
| Iciclaudit | ICICLAUDIT | ICL-COMPANY → ILA-COMPANY, ICL-LOCATION → ILA-LOCATION, → ILA-SYSTEM-CD, → ILA-SEQ, → ILA-DATE, → ILA-TIME, → ILA-FLD-NBR | ||
| Iclocgrp | ICLOCGRP | ICL-COMPANY → ILG-COMPANY, ICL-LOCATION → ILG-LOCATION, → ILG-SYSTEM-CD, → ILG-SEQ | ||
| Itemloc | ITEMLOC | Delete Restricted | ICL-COMPANY → ITL-COMPANY, ICL-LOCATION → ITL-LOCATION, → ITL-ITEM |
Programs
Updated by (280)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP170 Payment Closing
- AP193 Recurring Invoice Update
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- EE135 Mass Employee Release
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- IC02.1 Location
- IC12.1 Item Location
- IC12.2 Replenishment Setup
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC143 Finished Good Replenishment
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC26.1 Detail Transfers
- IC26.2 Bin Transfer by Serial
- IC262 Finished Good Listing
- IC263 Burden Listing
- IC283 Par Location Valuation
- IC330 Item Mass Change
- IC62.1 Finished Goods
- IC62.2 Finished Good Byproducts
- IC62.4 Component Finished Goods
- IC63.1 Burdens
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC68.1 Finished Good Component Availability
- IC68.2 Finished Good Component Availability
- IC68.3 Finished Good Component Sub Location Availability
- IC802 Locations to LRO via BCI
- IC81.1 Cart, Par Location
- IC83.1 Par Location Counts
- IC840 Cart Par Location Conversion
- ICLM.1 Build Location Matrix List
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA540 Invoice Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA64.9 PO Cost Message Accept Upload
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA66.3 Purchase Order Cost Review Message
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- MX500 Attribute Value Population
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO228 Consolidated Demand Report
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- PO64.1 PO Line Item History
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- TX140 Vertex Geocode Update
- TX40.1 Tax Inquiry for Vertex
- WH02.1 Outside Warehouse Participants
- WH110 Batch Allocation
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.1 Inventoried Allocation
- WH20.2 Nonstock and Special Allocation
- WH20.3 Bin Allocation
- WH20.4 Lot Allocation
- WH20.5 Serial Allocation
- WH20.6 UOM Allocation
- WH20.7 Substitute Location
- WH220 Ready to Allocate
- WH222 Shipments In Process
- WH224 Packing List Print
- WH226 Items on Backorder Report
- WH25.1 Cancellation By Item
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH34.5 Catch Weight
- WH39.1 Shipment Container Id
- WH39.2 WHSHTRKDTL
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH440 Data Verification Audit Report
- WH52.1 Shipment Interface Maintenance
- WH52.2 WHSHLDTLIN Interface Failures Fix
- WH52.3 WHSLCRTNIN Interface Failures Fix
- WH52.4 WHSHCRTNIN Interface Failures Fix
- WH520 Batch Feedback Interface
- WH80.1 Shipment Inquiry
- WH80.3 Orders Shipped Not Invoiced
- WH80.4 Shipments By Batch
- WH81.1 Shipment Line Inquiry
- WH82.1 Open Item Shipment Inquiry
- WH830 Shipment Load Program
Referenced by (267)
- API6.2 Invoke for POAPIPD
- AR08.1 Customer Defaults
- AR10.1 Customer
- AR501 Customer Conversion
- AR550 Customer Interface
- CX05.1 Preference Template
- CX05.2 Preference Template Diagnostics
- CX205 Preference Template Items
- CX207 Preference List Value
- CX805 Template Card Conversion
- DR25.1 Planned Orders
- DR40.1 Time Phased Order Point
- DR42.1 Time Phased Order Point by Buyer
- IC01.1 Company
- IC01.3 Bin Usage Types
- IC03.1 Report Group
- IC04.1 General Ledger Category
- IC10.1 Item Formats
- IC10.2 Item Master and Location
- IC11.1 Item Master
- IC110 Intransit Shipping
- IC120 Economic Order Quantity and Reorder Calculation
- IC125 Standard Cost Valuation
- IC130 General Ledger Interface
- IC134 Inventory Turnover
- IC135 Inventory Turnover by Issues
- IC138 Bin Replenishment Report
- IC15.1 Storage Codes
- IC15.2 Bins
- IC15.3 Bin Groups
- IC150 Movement Analysis - Cost
- IC151 Movement Analysis - Sales
- IC152 Movement Analysis - GMROI
- IC153 Product Transfer, Resale Report
- IC175 Update Variances
- IC182 Par Location Utilization
- IC183 Par Level Load
- IC189 Bin Audit Report
- IC19.1 Forecasts
- IC192 Item Location Audit Trail
- IC193 IC Location Audit Report
- IC194 GL Category Audit Report
- IC195 IC Receipts Audit Report
- IC198 Bin Group Audit Report
- IC199 Subsystem Close
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC202 Location Listing
- IC203 Report Group Listing
- IC204 General Ledger Category Listing
- IC21.1 Issues
- IC21.2 Detail Issues
- IC21.5 Issues Detail List
- IC211 Item Location Listing
- IC215 Bin Listing
- IC219 Forecast Listing
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC220 Transaction History Report
- IC221 Open Intransit Report
- IC222 Unreleased Documents
- IC223 Availability Report
- IC224 Gross Margin Return on Investment
- IC225 Inventory Reorder Advice
- IC226 Leadtime Review Report
- IC227 Potential Obsolete
- IC228 Potential Overstock
- IC229 Transactions by Reason Code
- IC23.1 Intransit Receiving
- IC23.2 Detail Intransit Receiving
- IC23.3 Intransit Receiving by Lot
- IC23.4 Intransit Receiving by Bin, UOM
- IC23.5 Intransit Receiving by Serial
- IC230 Lot Status Report
- IC231 Issue Summary Report
- IC232 Serial Status Report
- IC233 Inventory Valuation
- IC234 Period End Valuation
- IC235 Market Inventory Valuation
- IC237 Unapproved Bin Report
- IC238 Bin Stock on Hand Report
- IC239 Forecast Variance
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC241 Bin Reorder Policy Listing
- IC242 Transaction Audit Report
- IC244 Inventory Issue Document
- IC247 IFRS FIFO Period End Valuation
- IC25.1 Document Release
- IC250 Released Document Report
- IC258 Global Location Number Listing
- IC260 Kit, Assembly Listing
- IC266 Replenishment PO Worksheet Rpt
- IC27.1 Lot Hold Control
- IC270 Count Sheets
- IC28.1 Cost Adjustments
- IC280 Distribution History Report
- IC281 Par Inventory Worksheet
- IC282 Requesting Location Usage
- IC284 Variance Explanations
- IC285 Detail Par Loc Utilization
- IC286 Accuracy Progress
- IC287 Transactions by Document Type
- IC29.1 Lots
- IC29.2 Serials
- IC29.3 Bins
- IC295 Count Control Status
- IC31.1 Item Location Balances
- IC320 Mass Item Location Copy
- IC33.1 Ship to Facility
- IC331 Par Cart Mass Changes
- IC34.1 Manufacturer Relationship Management
- IC36.1 User Defined Item Inquiry
- IC37.1 Daily Transaction Summary
- IC38.1 Bin Reorder Policy
- IC40.1 Availability by Location
- IC40.2 Secondary Quantity Availability
- IC41.1 Items Within a Bin
- IC42.1 Stock by Detail
- IC42.2 Stock by Lot
- IC42.3 Serial Numbers
- IC42.4 Secondary Detail
- IC43.1 Bin Type Inquiry
- IC44.1 Inventory Stock Status
- IC45.1 Stock Status
- IC46.1 Inventory Status
- IC46.2 Inventory Status
- IC47.1 Cost History
- IC48.1 Open Intransits
- IC49.1 Usage History
- IC50.1 Transaction History
- IC50.2 Detail Transaction History
- IC500 Transaction Interface
- IC502 IC Location CSV Create
- IC503 IC Valid UOM CSV Create
- IC51.1 Available Bin Space
- IC512 Item Audit Extract
- IC519 Forecast Interface
- IC52.1 Serial or Lot History
- IC520 Handheld Item Master Interface
- IC521 Bar Code Item Master Interface
- IC522 HL7 Item Master - Atwork
- IC523 HL7 Item Master - OmniCell
- IC524 CSV Item Master
- IC525 HL7 Item Master Interface
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC53.1 Document Inquiry
- IC55.1 Transaction History Inquiry
- IC550 Overallocated Items
- IC574 Physical Inventory Interface
- IC58.1 Global Location Numbers
- IC58.2 Global Location Numbers Inquiry
- IC58.3 Global Location Numbers Inquiry Details
- IC589 Forecast Transfer
- IC59.1 Create Label Entry
- IC590 Out of Stock Extract
- IC598 Bin Label Export
- IC60.1 Kit Assembly
- IC60.2 Options
- IC60.3 Instructions
- IC61.1 Kit Component Replacement
- IC65.1 Component Where Used
- IC67.1 Kit Availability
- IC70.1 Select IDs
- IC73.1 Count Detail
- IC74.1 Random Counts
- IC811 Item Master Load
- IC812 Item Location Load
- IC82.1 Par Location Item Mass Change
- IC820 Beginning Balance Load
- IC84.1 Detail Par Location Utilization by Month
- IC84.2 Detail Par Location Utilization by Month
- IC841 General Ledger Category Conversion
- IC850 Transaction Load
- IC851 History Load
- IC90.1 Bin Transfers
- IC91.2 Item Location and Item Source Audit Inquiry
- IC91.3 GL Category Audit Inquiry
- IC92.1 IC Location Audit Inquiry
- IC93.1 Bin Audit
- IC93.2 Bin Group Audit
- IC95.4 IC Receipts Audit
- ICBD.1 IC BOD Maintenance
- ICBD.2 IC BOD Inquiry
- ICLC.1 Item Location Lookup
- MA54.1 Invoice
- MA54.2 Distribution
- MA91.1 Match Pool Display
- MX223 List Member Listing
- PC120 Price Calculation
- PC20.1 Patient Charges
- PC540 Patient Charge Upload
- PO130 Receiving Document
- PO133 Receiving Adjustment Log
- PO134 Receiving Delivery and Putaway
- PO135 Received, Not Invoiced Report
- PO16.1 Bid
- PO195 PO Vendor Agreement Audit Report
- PO223 Buyer Expediting Report
- PO231 Return Status Report
- PO233 PO Received Quantity Exceptions
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO258 Receipt Inquiry Report from PO58
- PO274 Returns Analysis
- PO285 PO Activity By Source Report
- PO330 Arrival to Lawson Interface
- PO529 PO Receiving File Create
- PO53.1 Purchase Order Interface
- PO53.2 Purchase Order Line Interface
- PO53.3 Purchase Order Distribution Interface
- PO53.4 Miscellaneous AOC
- PO53.8 Item AOC
- PO58.1 Receipt Inquiry
- PO58.2 Receipt Inquiry
- PO63.1 PO Inquiry By Item
- PO65.1 Vendor Agreement Header Audit Inquiry
- PO67.1 PO Inquiry By AOC
- PO81.1 Vendor Return Inquiry
- PO94.1 Vendor Performance
- POA2.4 Define Organization Dimension
- POA3.1 Data Load for Vendor Analysis
- POAO.1 Olap Dimension Retrieval Format
- POI7.1 POI7 Print Object
- POIE.1 Delivery Ticket Report
- POIF.1 MMDIST Activity Commit
- POIG.1 MMDIST Budget Check
- POIH.1 Invokeable Unit Cost Default
- POIM.1 GL Budget Ck for PO and RQ
- POIT.1 Invoke PO Total Method
- RQ04.1 Requesters
- RQ111 Print Requisitions
- RQ140 Requisition Status Report
- RQ201 Location Listing
- RQ230 Department Usage Report
- RQ235 Issues Audit List
- RQ240 Requisition Volume Summary Report
- RQ41.1 Requisition Status
- RQ50.1 Issues History
- RQ504 Requester Setup Extract
- RQ510 Inventory Depletion Interface
- RQ513 Inventory Depletion Interface-HBOC/ESI
- RQD0.1 Invoke for RQ Orphan Check
- RQD1.1 Invoke for RQ Integrity Check
- RQIA.1 RQREQPD Invoke Object
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data
- WH05.1 Location Rules
- WH120 Route Creation
- WH126 POD Print
- WH131 Bulk Pick List
- WH140 Bill Of Lading Print
- WH21.1 Routes
- WH21.2 Stops
- WH21.3 Stop Transfer
- WH21.4 Document Transfer
- WH210 Route File Listing
- WH22.1 Kit Options
- WH221 Allocated Not Printed
- WH330 Shipment Interface Purge
- WH38.1 Web Tracking ID
- WH420 WH Orphan Check - Report Only
- WH422 WH-IC Integrity Check - Report Only
- WH423 WH-IC Detail Integrity Check