ICLOCATION

Company Location

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

REFERENCED BY
AR08.1 AR10.1 AR501 AR550 CX05.1 CX05.2
CX205 CX805 DR25.1 DR40.1 DR42.1 IC04.1
IC11.1 IC110 IC120 IC125 IC130 IC134
IC135 IC138 IC145 IC15.1 IC15.2 IC15.3
IC150 IC151 IC152 IC153 IC175 IC182
IC183 IC19.1 IC199 IC20.1 IC20.2 IC21.1
IC21.2 IC21.5 IC211 IC219 IC22.1 IC22.2
IC220 IC221 IC222 IC223 IC224 IC225
IC226 IC227 IC228 IC229 IC23.1 IC23.2
IC23.3 IC23.4 IC23.5 IC230 IC231 IC232
IC233 IC234 IC235 IC237 IC238 IC239
IC24.1 IC24.2 IC241 IC242 IC244 IC247
IC25.1 IC250 IC260 IC266 IC27.1 IC270
IC28.1 IC280 IC281 IC282 IC285 IC287
IC29.1 IC29.2 IC29.3 IC295 IC31.1 IC320
IC36.1 IC38.1 IC40.1 IC40.2 IC41.1 IC42.1
IC42.2 IC42.3 IC42.4 IC43.1 IC45.1 IC47.1
IC48.1 IC49.1 IC50.1 IC50.2 IC500 IC51.1
IC512 IC519 IC52.1 IC520 IC521 IC522
IC523 IC524 IC525 IC526 IC527 IC53.1
IC55.1 IC550 IC574 IC589 IC59.1 IC590
IC598 IC60.1 IC60.2 IC60.3 IC61.1 IC65.1
IC67.1 IC73.1 IC74.1 IC811 IC812 IC82.1
IC820 IC84.1 IC84.2 IC850 IC851 IC90.1
IC91.2 PC120 PC20.1 PC540 ZC522 MX223
MA278 MA53.1 MA54.1 MA54.2 MA91.1 PO04.3
PO115 PO120 PO130 PO132 PO133 PO135
PO15.1 PO15.2 PO15.4 PO16.1 PO204 PO220
PO222 PO223 PO230 PO231 PO233 PO234
PO253 PO254 PO258 PO26.1 PO26.4 PO26.5
PO274 PO275 PO276 PO277 PO280 PO285
PO330 PO53.1 PO53.2 PO53.3 PO53.4 PO53.8
PO58.1 PO58.2 PO63.1 PO67.1 PO81.1 PO94.1
POA3.1 POI7.1 POIE.1 POIF.1 POIG.1 POIH.1
POIM.1 POIT.1 RQ04.1 RQ111 RQ140 RQ230
RQ235 RQ240 RQ41.1 RQ50.1 RQ504 RQ510
RQ513 RQ810 RQD0.1 RQD1.1 RQIA.1 RQIB.1
RQIC.1 RQID.1 RQIG.1 RQIH.1 RQII.1 RQIJ.1
WH120 WH126 WH140 WH21.1 WH21.2 WH21.3
WH21.4 WH210 WH22.1 WH221 CX207 IC01.1
IC01.3 IC03.1 IC202 IC203 IC204 IC215
IC258 IC284 IC286 IC33.1 IC34.1 IC58.1
IC58.2 IC58.3 IC841 ICLC.1 PO134 POA2.4
POAO.1 RQ201 WH05.1 WH131 WH330 WH38.1
WH420 WH422 WH423


UPDATED BY
AP125 AP126 AP131 AP170 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP510 API1.1 API2.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 EE135 EE35.1 EE35.2 EE520
DR100 IC02.1 IC02.3 IC02.4 IC10.2 IC12.2
IC140 IC141 IC142 IC143 IC192 IC243
IC26.1 IC26.2 IC262 IC263 IC283 IC330
IC331 IC37.1 IC44.1 IC46.1 IC502 IC62.1
IC62.2 IC62.4 IC63.1 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC68.1 IC68.2 IC68.3 IC70.1 IC802
IC81.1 IC83.1 IC840 ICLM.1 MX500 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA64.9 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO228 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
PO64.1 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.3 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1
TX140 TX40.1 WH02.1 WH110 WH130 WH132
WH190 WH20.1 WH20.2 WH20.3 WH20.4 WH20.5
WH20.6 WH20.7 WH220 WH222 WH224 WH226
WH25.1 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH34.5 WH40.1 WH40.2 WH440
WH52.1 WH52.2 WH52.3 WH52.4 WH520 WH80.1
WH80.3 WH80.4 WH81.1 WH82.1 WH830 ZW130

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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
AP510 IC02.1
IC138 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840
ICL-NAME
Element: Name
Alpha 30 (Lower Case)
This field contains the location's name defined in IC02.1 (Location).
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
RQ01.1 RQ810
WH126 WH131
WH221 WH226
ICL-REPL-FROM-LOC
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the third line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the fourth line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the fifth line and/or the city of the address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-STATE-PROV
Element: State Prov
Alpha 2
This field contains the state or province of the address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code of the address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH126
ICL-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
TX140
ICL-ADDR-CONTACT
Element: Addr Contact
Alpha 30 (Lower Case)
This field contains the name of the main contact.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
PO30.1 PO63.1
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-PO-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
TX140
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).
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 DR100
IC02.1 IC141
IC142 IC143
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
WH110 WH130
ZW130
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
...
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC140
IC141 IC142
IC243 IC262
IC263 IC330
IC62.1 IC62.2
IC62.4 IC63.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
ICL-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
TX140
ICL-PO-TAX-CODE
Element: Po Tax Code
Alpha 10
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
TX140
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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).
...
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC140
IC141 IC142
IC243 IC26.1
IC26.2 IC262
IC263 IC330
IC62.1 IC62.2
IC62.4 IC63.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
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.
...
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC140
IC141 IC142
IC243 IC26.1
IC26.2 IC262
IC263 IC330
IC62.1 IC62.2
IC62.4 IC63.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
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.
...
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC140
IC141 IC142
IC243 IC262
IC263 IC330
IC62.1 IC62.2
IC62.4 IC63.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-HOLD-ACCT-UNIT
Element: Hold Acct Unit
Alpha 15
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-HOLD-ACCOUNT
Element: Hold Account
Numeric 6
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-HOLD-SUB-ACCT
Element: Hold Sub Acct
Numeric 4
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-ERS-CAPABLE
Element: All Flag
Alpha 1

Y = Yes
N = No
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-PAR-VALUE
Element: Intl Amt
Signed 18.2
The value of the inventory stored at the par location.
AP510 IC02.1
IC283 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-WO-LOC-TYPE
Element: Wo Loc Type
Alpha 1

N = Not a Work Order Location
O = Offsite Location
P = Production Location
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-CALENDAR
Element: Calendar
Alpha 15
This is the name of the calendar used in the production scheduling process for work orders.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-PRINT-LABELS
Element: Print Labels
Alpha 1
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-SHIP-TO
Element: Ship To
Numeric 4
This field contains the number representing the ship to customer.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-PROC-DAYS
Element: Proc Days
Numeric 3
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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).
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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)
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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).
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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).
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-POSTAL-CD
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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).
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-CONTACT
Element: Addr Contact
Alpha 30 (Lower Case)
This is the name of the main contact.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-REPL-REQUESTER
Element: Requester
Alpha 10 (Lower Case)
This is the person who requested this requisition.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-RETAIL-LOC-FL
Element: Retail Loc Fl
Alpha 1

" " = None
S = Store
W = Warehouse
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
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.
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICLM.1 MX500
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
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-DROPSHIP-FL
Element: All Flag
Alpha 1
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-PHONE-PREF
Element: Phone Prefix
Alpha 6
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-PHONE
Element: Phone
Alpha 15
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-PHONE-EXT
Element: Phone Ext
Alpha 5
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-POB-EMAIL-ADDR
Element: Email Address
Alpha 60 (Lower Case)
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-STATUS
Element: Status
Numeric 1

0 = Active
1 = Inactive
2 = Add Inactive
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
ICL-EAM-LOC-FL
Element: Retail Loc Fl
Alpha 1

" " = Not an EAM Location
1 = EAM Location
AP510 IC02.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840


ICLOCATION FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICLSET1 COMPANY
LOCATION
...
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP510 API1.1
API2.1 AR08.1
AR10.1 AR501
AR550 CX05.1
CX05.2 CX100
ICLSET2 COMPANY
LOCATION
Subset
WhereLOCATION-TYPE ="E"
OrLOCATION-TYPE ="P"
IC281 IC331
IC81.1 IC82.1
IC83.1
ICLSET3 COMPANY
LOCATION
Subset
WhereWO-LOC-TYPE !="N"
IC01.1
ICLSET4 VENDOR
PURCH-FR-LOC
COMPANY
LOCATION
KeyChange, Subset
WhereVENDOR !=Spaces
IC02.1
ICLSET5 CUSTOMER
SHIP-TO
COMPANY
LOCATION
KeyChange, Subset
WhereCUSTOMER !=Spaces
IC02.1 WH20.7
ICLSET6 ICL-OBJ-ID
KeyChange, Subset
WhereICL-OBJ-ID !=Zeroes
IC02.5 IC02.6
IC145 IC222
IC223 IC243
ICLM.1 MX223
MX500


ICLOCATION FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
OrICL-FRT-ACCOUNT !=Zeroes
OrICL-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
OrICL-HDLG-ACCOUNT !=Zeroes
OrICL-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
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
OrICL-SCRP-ACCOUNT !=Zeroes
OrICL-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
OrICL-SUSP-ACCOUNT !=Zeroes
OrICL-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


ICLOCATION FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
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


File created: Thu Jun 09 11:17:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.