# View: Location Details

RotoID: IC0290
Tables: ICILOC
DLL: ICILOC

## Compositions: 3

RotoID | Title | Tables | DLL
--- | --- | --- | ---
IC0310 | Items | ICITEM | ICITEM
IC0370 | Locations | ICLOC | ICLOC
IC0750 | Units of Measure | ICUNIT | ICUNIT

## Keys: 2

Title | Fields
--- | ---
Item Number | ITEMNO, LOCATION
Location | LOCATION, ITEMNO

## Fields: 38

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ITEMNO | 1 | String*24 | Item Number | E A K R | Mask: %-24C
LOCATION | 2 | String*6 | Location | E A K R | Mask: %-6N
PICKINGSEQ | 3 | String*10 | Picking Sequence | E A |
ACTIVE | 4 | Boolean | Allowed | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATEACTIVE | 5 | Date | Date Location Activated | A C |
USED | 6 | Boolean | In Use | A C | List: 2 entries
0 | = | No
1 | = | Yes
LASTUSED | 7 | Date | Date Last Used | A C |
QTYONHAND | 8 | BCD*10.4 | Quantity on Hand (Last Day End) | A |
QTYONORDER | 9 | BCD*10.4 | Quantity on P/O | A |
QTYSALORDR | 10 | BCD*10.4 | Quantity on S/O | A |
QTYOFFSET | 11 | BCD*10.4 | Quantity Not in Cost File | A |
QTYSHNOCST | 12 | BCD*10.4 | Quantity Shipped Not Costed | A |
QTYRENOCST | 13 | BCD*10.4 | Quantity Received Not Costed | A |
QTYADNOCST | 14 | BCD*10.4 | Quantity Adjusted Not Costed | A |
NUMNOCST | 15 | Long | Number of Uncosted Transactions | A |
TOTALCOST | 16 | BCD*10.3 | Total Cost | A |
COSTOFFSET | 17 | BCD*10.3 | Cost Not in Cost File | A |
COSTUNIT | 18 | String*10 | Cost Unit of Measure | E A | Mask: %-10c
COSTCONV | 19 | BCD*10.6 | Cost Unit Conversion Factor | A |
STDCOST | 20 | BCD*10.6 | Standard Cost | E A |
LASTSTDCST | 21 | BCD*10.6 | Last Standard Cost | A C |
LASTSTDDAT | 22 | Date | Last Standard Cost Date | A C |
LASTSHIPDT | 23 | Date | Last Shipment Date | A |
DAYSTOSHIP | 24 | BCD*10.4 | Average Days To Ship | A |
UNITSSHIP | 25 | BCD*10.4 | Average Units Shipped | A |
SHIPMENTS | 26 | Integer | Shipments Used In Calculation | A |
LASTRCPTDT | 27 | Date | Last Receipt Date | A |
RECENTCOST | 28 | BCD*10.6 | Most Recent Cost | E A |
COST1 | 29 | BCD*10.6 | User Defined Cost 1 | E A |
COST2 | 30 | BCD*10.6 | User Defined Cost 2 | E A |
LASTCOST | 31 | BCD*10.6 | Last Unit Cost | E A |
QTYCOMMIT | 32 | BCD*10.4 | Quantity Committed | A |
QTYAVAIL | 62 | BCD*10.4 | Quantity Available to Ship | A C |
CNTLACCT | 63 | String*6 | Account Set Code | A C | Mask: %-6N
AQTYONHAND | 64 | BCD*10.4 | Quantity on Hand | A C |
AVGCOST | 65 | BCD*10.6 | Average Cost | A C |
COSTMETHOD | 66 | Integer | Costing Method | E A | List: 6 entries
1 | = | Moving Average
2 | = | FIFO
3 | = | LIFO
4 | = | Standard Cost
5 | = | Most Recent Cost
6 | = | User-Specified
LOCDESC | 67 | String*60 | Name | E A |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.