ICLOCATION

Company Location

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

REFERENCED BY
API6.2 AR08.1 AR10.1 AR501 AR550 CX05.1
CX05.2 CX205 CX207 CX805 DR25.1 DR40.1
DR42.1 IC01.1 IC01.3 IC03.1 IC04.1 IC10.1
IC10.2 IC11.1 IC110 IC120 IC125 IC130
IC134 IC135 IC138 IC15.1 IC15.2 IC15.3
IC150 IC151 IC152 IC153 IC175 IC182
IC183 IC189 IC19.1 IC192 IC193 IC194
IC195 IC198 IC199 IC20.1 IC20.2 IC202
IC203 IC204 IC21.1 IC21.2 IC21.5 IC211
IC215 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
IC258 IC260 IC266 IC27.1 IC270 IC28.1
IC280 IC281 IC282 IC284 IC285 IC286
IC287 IC29.1 IC29.2 IC29.3 IC295 IC31.1
IC320 IC33.1 IC331 IC34.1 IC36.1 IC37.1
IC38.1 IC40.1 IC40.2 IC41.1 IC42.1 IC42.2
IC42.3 IC42.4 IC43.1 IC44.1 IC45.1 IC46.1
IC46.2 IC47.1 IC48.1 IC49.1 IC50.1 IC50.2
IC500 IC502 IC503 IC51.1 IC512 IC519
IC52.1 IC520 IC521 IC522 IC523 IC524
IC525 IC526 IC527 IC53.1 IC55.1 IC550
IC574 IC58.1 IC58.2 IC58.3 IC589 IC59.1
IC590 IC598 IC60.1 IC60.2 IC60.3 IC61.1
IC65.1 IC67.1 IC70.1 IC73.1 IC74.1 IC811
IC812 IC82.1 IC820 IC84.1 IC84.2 IC841
IC850 IC851 IC90.1 IC91.2 IC91.3 IC92.1
IC93.1 IC93.2 IC95.4 ICBD.1 ICBD.2 ICLC.1
PC120 PC20.1 PC540 MA54.1 MA54.2 MA91.1
PO130 PO133 PO134 PO135 PO16.1 PO195
PO223 PO231 PO233 PO253 PO254 PO258
PO274 PO285 PO330 PO529 PO53.1 PO53.2
PO53.3 PO53.4 PO53.8 PO58.1 PO58.2 PO63.1
PO65.1 PO67.1 PO81.1 PO94.1 POA2.4 POA3.1
POAO.1 POI7.1 POIE.1 POIF.1 POIG.1 POIH.1
POIM.1 POIT.1 RQ04.1 RQ111 RQ140 RQ201
RQ230 RQ235 RQ240 RQ41.1 RQ50.1 RQ504
RQ510 RQ513 RQD0.1 RQD1.1 RQIA.1 RQIC.1
RQID.1 RQIG.1 RQIH.1 WH05.1 WH120 WH126
WH131 WH140 WH21.1 WH21.2 WH21.3 WH21.4
WH210 WH22.1 WH221 WH330 WH38.1 WH420
WH422 WH423 MX223


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 IC12.1 IC12.2 IC140 IC141
IC142 IC143 IC145 IC243 IC26.1 IC26.2
IC262 IC263 IC283 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
IC68.1 IC68.2 IC68.3 IC802 IC81.1 IC83.1
IC840 ICLM.1 MX500 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.1 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 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
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO220 PO222 PO224 PO225 PO228
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 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.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.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
WH39.1 WH39.2 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

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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-LOCATION
Element: Location
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
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
TX140
ICL-NAME
Element: Name
Alpha 30 (Lower Case)
This field contains the location's name defined in Location (IC02.1).
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 RQ01.1
RQ810 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-ADDR1
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
WH126
ICL-ADDR2
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
WH126
ICL-ADDR3
Element: Addr1
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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
WH126
ICL-ADDR4
Element: Addr1
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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
WH126
ICL-STATE-PROV
Element: State 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
WH126
ICL-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code of the address.
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
WH126
ICL-COUNTY
Element: 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
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
IC02.2 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-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
IC02.2 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 TX140
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
IC02.2 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-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
IC02.2 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-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
IC02.2 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-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
IC02.2 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-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
IC02.2 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-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
IC02.2 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-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
IC02.2 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-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
IC02.2 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-COUNTY
Element: 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
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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 IC02.2
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 TX140
WH110 WH130
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC12.1
IC12.2 IC140
IC141 IC142
IC145 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
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
IC02.2 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
IC02.2 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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC12.1
IC12.2 IC140
IC141 IC142
IC145 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
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
IC02.2 IC12.1
IC12.2 IC140
IC141 IC142
IC145 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
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
IC02.2 IC12.1
IC12.2 IC140
IC141 IC142
IC145 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
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-HOLD-ACCT-UNIT
Element: Hold Acct Unit
Alpha 15
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-HOLD-ACCOUNT
Element: Hold Account
Numeric 6
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-HOLD-SUB-ACCT
Element: Hold Sub Acct
Numeric 4
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-ERS-CAPABLE
Element: All Flag
Alpha 1

Y = Yes
N = No
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-PAR-VALUE
Element: Intl Amt
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
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-PROCESS-LEVEL
Element: Process 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-PRINT-LABELS
Element: Print Labels
Alpha 1
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-PURCH-FR-LOC
Element: Purch 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-SHIP-TO
Element: Ship 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-PROC-DAYS
Element: Proc Days
Numeric 3
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 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-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
IC02.2 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-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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-ADDR1
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-ADDR2
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-ADDR3
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-ADDR4
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-CITY-ADDR5
Element: City
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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-POSTAL-CD
Element: Postal Code
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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-COUNTY
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-POB-CONTACT
Element: Addr 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-REPL-REQUESTER
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-RETAIL-LOC-FL
Element: Retail Loc Fl
Alpha 1

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

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

" " = Normal Lawson Location
1 = EAM Location
2 = SCE Location
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
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
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ICL-MSCM-DELIVERY
Element: Boolean
Numeric 1
This field indentifies whether the location uses MSCM for delivery.
0 = No
1 = Yes
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140


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 API6.2
AR08.1 AR10.1
AR501 AR550
CX05.1 CX05.2
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
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
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
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


File created: Thu Jun 09 02:18:45 2016

Home
Contact Us



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