Company Location
The Company Location file stores valid locations within a company. The locations establish the identification of stock locations.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ICL-COMPANY Element: Company | 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. |
|
||||||||||||||||||||||
ICL-LOCATION-TYPE Element: Location 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. E = Exchange Cart P = Par Location " " = Inventory Location |
|
||||||||||||||||||||||
ICL-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||||||||||||||||||
ICL-NAME Element: Name | Alpha 30 (Lower Case) This field contains the location's name defined in Location (IC02.1). |
|
||||||||||||||||||||||
ICL-REPL-FROM-LOC Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||||||||||||||||||
ICL-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||||
ICL-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||||
ICL-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the third line of address information. |
|
||||||||||||||||||||||
ICL-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the fourth line of address information. |
|
||||||||||||||||||||||
ICL-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the fifth line and/or the city of the address. |
|
||||||||||||||||||||||
ICL-STATE-PROV Element: State Prov | Alpha 2 This field contains the state or province of the address. |
|
||||||||||||||||||||||
ICL-POSTAL-CODE Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code of the address. |
|
||||||||||||||||||||||
ICL-COUNTRY Element: Country | Alpha 30 (Lower Case) This field contains the country of the address, or it can contain additional information such as an attention name. |
|
||||||||||||||||||||||
ICL-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||||||||||||||||||||||
ICL-ADDR-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This field contains the name of the main contact. |
|
||||||||||||||||||||||
ICL-PO-NAME Element: Name | Alpha 30 (Lower Case) This field contains the name of the ship to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the second line of the ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the third line of the ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the fourth line of the ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the fifth line or city of the ship-to address. This information is printed on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-STATE-PROV Element: State Prov | Alpha 2 This field contains the state or province of the ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-POSTAL-CD Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code of the ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-COUNTRY Element: Country | Alpha 30 (Lower Case) This field contains the country of the ship-to address. This information prints on purchase orders. |
|
||||||||||||||||||||||
ICL-PO-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||||||||||||||||||||||
ICL-HIN-NBR Element: Hin 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). |
|
||||||||||||||||||||||
ICL-OE-RUN-STS Element: Oe Run Sts | Numeric 1 This 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 |
|
||||||||||||||||||||||
ICL-PROCESS-TYPE Element: Process 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. |
|
||||||||||||||||||||||
ICL-ALLOC-PURP Element: Alloc 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. C = Consolidated Bins S = Speed Picking |
|
||||||||||||||||||||||
ICL-LAST-BATCH-NBR Element: Last 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. |
|||||||||||||||||||||||
ICL-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||||||||||||||||||||||
ICL-PO-TAX-CODE Element: Po Tax Code | Alpha 10 |
|
||||||||||||||||||||||
ICL-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code that will default to a purchase order from the inventory location. |
|
||||||||||||||||||||||
ICL-LAST-BT-DATE Element: 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). |
|||||||||||||||||||||||
ICL-LAST-BT-LINE Element: Line Nbr | 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. |
|||||||||||||||||||||||
ICL-LAST-SHIP-NBR Element: Shipment Nbr | Numeric 10 This field is used to determine the shipment number on the pick list in the Warehouse system. |
|||||||||||||||||||||||
ICL-SUSP-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-SUSP-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-SUSP-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-FRT-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-FRT-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-FRT-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-HDLG-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-HDLG-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-HDLG-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-SCRP-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-SCRP-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-SCRP-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-HOLD-ACCT-UNIT Element: Hold Acct Unit | Alpha 15 |
|
||||||||||||||||||||||
ICL-HOLD-ACCOUNT Element: Hold Account | Numeric 6 |
|
||||||||||||||||||||||
ICL-HOLD-SUB-ACCT Element: Hold Sub Acct | Numeric 4 |
|
||||||||||||||||||||||
ICL-ERS-CAPABLE Element: All Flag | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||
ICL-PAR-VALUE Element: Intl Amt | Signed 18.2 The value of the inventory stored at the par location. |
|
||||||||||||||||||||||
ICL-WST-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-WST-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-WST-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-WO-LOC-TYPE Element: Wo Loc Type | Alpha 1 N = Not a Work Order Location O = Offsite Location P = Production Location |
|
||||||||||||||||||||||
ICL-CALENDAR Element: Calendar | Alpha 15 This is the name of the calendar used in the production scheduling process for work orders. |
|
||||||||||||||||||||||
ICL-DEMAND-SOURCE Element: Demand Source | Numeric 1 This 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 |
|
||||||||||||||||||||||
ICL-WIP-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-WIP-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-WIP-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-FGV-ACCT-UNIT Element: 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. |
|
||||||||||||||||||||||
ICL-FGV-ACCOUNT Element: 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. |
|
||||||||||||||||||||||
ICL-FGV-SUB-ACCT Element: 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. |
|
||||||||||||||||||||||
ICL-CAPACITY Element: Capacity | 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. |
|
||||||||||||||||||||||
ICL-SCHED-INCR Element: Sched 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. |
|
||||||||||||||||||||||
ICL-SCHED-FREQ Element: Sched 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. D = Days W = Weeks M = Months |
|
||||||||||||||||||||||
ICL-WO-STATUS Element: Wo 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. 1 = Unreleased 2 = Released 3 = Exploded 4 = In Production |
|
||||||||||||||||||||||
ICL-WO-ACCOUNT-FL Element: Wo Account Fl | Alpha 1 This indicates if you are using income statement accounts in Production Order. Y = Yes N = No " " = No |
|
||||||||||||||||||||||
ICL-WO-IN-PROD-FL Element: Wo In Prod Fl | Alpha 1 Y = In prod unrestricted by alloc N = In prod restricted by alloc O = No - but override allowed |
|
||||||||||||||||||||||
ICL-PROCESS-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||||||||||||||||||||||
ICL-PRINT-LABELS Element: Print Labels | Alpha 1 |
|
||||||||||||||||||||||
ICL-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||||||||||||||||||
ICL-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||||||||||||||||||||
ICL-CUSTOMER Element: Customer | Alpha 9 (Right Justified) This field contains the number that represents a customer. |
|
||||||||||||||||||||||
ICL-SHIP-TO Element: Ship To | Numeric 4 This field contains the number representing the ship to customer. |
|
||||||||||||||||||||||
ICL-PROC-DAYS Element: Proc Days | Numeric 3 |
|
||||||||||||||||||||||
ICL-REC-ALLOCATE Element: Rec 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 0 = No Receiving Allocation 1 = PO LIne Source Allocation 2 = PO Line Source & Std Allocatio |
|
||||||||||||||||||||||
ICL-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||||||||||||||||||||||
ICL-REGION Element: Region | Alpha 2 The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance) |
|
||||||||||||||||||||||
ICL-PO-COUNTRY-CD Element: Po Country Cd | Alpha 2 The PO country code. Required for VAT and Intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||||||||||||||||||||||
ICL-PO-REGION Element: Po 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). |
|
||||||||||||||||||||||
ICL-ISS-AU-FL Element: Iss 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 |
|
||||||||||||||||||||||
ICL-POB-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description. |
|
||||||||||||||||||||||
ICL-POB-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||||
ICL-POB-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||||
ICL-POB-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||||
ICL-POB-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||||
ICL-POB-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||||||||||||||||||||||
ICL-POB-STATE-PROV Element: State Prov | Alpha 2 The state or province. |
|
||||||||||||||||||||||
ICL-POB-POSTAL-CD Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code. |
|
||||||||||||||||||||||
ICL-POB-COUNTRY-CD Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||||||||||||||||||||||
ICL-POB-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||||||||||||||||||||||
ICL-POB-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This is the name of the main contact. |
|
||||||||||||||||||||||
ICL-GLN-NBR Element: Gln Nbr | Alpha 13 |
|
||||||||||||||||||||||
ICL-REPL-REQUESTER Element: Requester | Alpha 10 (Lower Case) This is the person who requested this requisition. |
|
||||||||||||||||||||||
ICL-RETAIL-LOC-FL Element: Retail Loc Fl | Alpha 1 " " = None S = Store W = Warehouse |
|
||||||||||||||||||||||
ICL-ICL-OBJ-ID Element: 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. |
|
||||||||||||||||||||||
ICL-ONE-SRC-ONE-PO Element: 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 |
|
||||||||||||||||||||||
ICL-DROPSHIP-FL Element: All Flag | Alpha 1 |
|
||||||||||||||||||||||
ICL-POB-PHONE-PREF Element: Phone Prefix | Alpha 6 |
|
||||||||||||||||||||||
ICL-POB-PHONE Element: Phone | Alpha 15 |
|
||||||||||||||||||||||
ICL-POB-PHONE-EXT Element: Phone Ext | Alpha 5 |
|
||||||||||||||||||||||
ICL-POB-EMAIL-ADDR Element: Email Address | Alpha 60 (Lower Case) |
|
||||||||||||||||||||||
ICL-STATUS Element: Status | Numeric 1 0 = Active 1 = Inactive 2 = Add Inactive |
|
||||||||||||||||||||||
ICL-EAM-LOC-FL Element: Retail Loc Fl | Alpha 1 " " = Normal Lawson Location 1 = EAM Location 2 = SCE Location |
|
||||||||||||||||||||||
ICL-GEO-TYPE Element: Customer Code | Alpha 4 |
|
||||||||||||||||||||||
ICL-GEO-LATITUDE Element: Gis Coordinate | Signed 12.6 |
|
||||||||||||||||||||||
ICL-GEO-LONGITUDE Element: Gis Coordinate | Signed 12.6 |
|
||||||||||||||||||||||
ICL-GEO-ALTITUDE Element: Gis Coordinate | Signed 12.6 |
|
||||||||||||||||||||||
ICL-GEO-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||
ICL-GEO-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||||
ICL-APPROVAL-TYPE Element: Approval Type | Alpha 1 The 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 |
|
||||||||||||||||||||||
ICL-MSCM-DELIVERY Element: Boolean | Numeric 1 This field indentifies whether the location uses MSCM for delivery. 0 = No 1 = Yes |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ICLSET1 |
COMPANY LOCATION |
|
|||||||||||||||||||||||||
ICLSET2 |
COMPANY LOCATION |
|
| ||||||||||||||||||||||||
ICLSET3 |
COMPANY LOCATION |
|
| ||||||||||||||||||||||||
ICLSET4 |
VENDOR PURCH-FR-LOC COMPANY LOCATION |
|
| ||||||||||||||||||||||||
ICLSET5 |
CUSTOMER SHIP-TO COMPANY LOCATION |
|
| ||||||||||||||||||||||||
ICLSET6 |
ICL-OBJ-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | ICCOMPANY |
Required
| ||||||||||||||||||||||||||||||
Fgv Account | GLMASTER |
Not Required
| ||||||||||||||||||||||||||||||
Frt Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Glnloc | GLNLOC |
Not Required
| ||||||||||||||||||||||||||||||
Glnlocdtl | GLNLOCDTL |
Not Required
| ||||||||||||||||||||||||||||||
Hdlg Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Iclbod | ICLBOD |
Not Required, Delete Cascades
| ||||||||||||||||||||||||||||||
Repl From Loc | ICLOCATION |
Not Required
| ||||||||||||||||||||||||||||||
Scrap Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Suspense Acct | GLMASTER |
Not Required
| ||||||||||||||||||||||||||||||
Waste Account | GLMASTER |
Not Required
| ||||||||||||||||||||||||||||||
Wip Account | GLMASTER |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Icbin | ICBIN |
Delete Restricted
| |||||||||||||||||||||
Iccategory | ICCATEGORY |
Delete Restricted
| |||||||||||||||||||||
Iciclaudit | ICICLAUDIT |
| |||||||||||||||||||||
Iclocgrp | ICLOCGRP |
| |||||||||||||||||||||
Itemloc | ITEMLOC |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.