# View: Location Quantities

RotoID: IC0372
Table:
DLL: ICLOCI

## Compositions: 0

## Keys: 2

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

## Fields: 81

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ITEMNO | 1 | String*24 | Item Number | E A K | Mask: %-24C
LOCATION | 2 | String*6 | Location | E A K | Mask: %-6N
LOCATION2 | 1001 | String*6 | Location | A C | Mask: %-6N
DESC | 1002 | String*60 | Name | A C |
ADDRESS1 | 1003 | String*60 | Address Line 1 | A C |
ADDRESS2 | 1004 | String*60 | Address Line 2 | A C |
ADDRESS3 | 1005 | String*60 | Address Line 3 | A C |
ADDRESS4 | 1006 | String*60 | Address Line 4 | A C |
CITY | 1007 | String*30 | City | A C |
STATE | 1008 | String*30 | State | A C |
ZIP | 1009 | String*20 | Zip/Postal Code | A C | Mask: %-20C
COUNTRY | 1010 | String*30 | Country | A C |
PHONE | 1011 | String*30 | Phone Number | A C | Mask: (%-3C) %-3C-%-24C
FAX | 1012 | String*30 | Fax Number | A C | Mask: (%-3C) %-3C-%-24C
CONTACT | 1013 | String*60 | Contact | A C |
SEGOVERRD | 1014 | Boolean | Segment Override | A C |
DATELASTMN | 1015 | Date | Date Last Maintained | A C |
INACTIVE | 1016 | Boolean | Status | A C | List: 2 entries
0 | = | Active
1 | = | Inactive
DATEINACTV | 1017 | Date | Date Inactive | A C |
SEGNUM1 | 1018 | String*6 | Segment Number 1 | A C |
SEGVAL1 | 1019 | String*15 | Segment Value 1 | A C | Mask: %-15N
SEGNUM2 | 1020 | String*6 | Segment Number 2 | A C |
SEGVAL2 | 1021 | String*15 | Segment Value 2 | A C | Mask: %-15N
SEGNUM3 | 1022 | String*6 | Segment Number 3 | A C |
SEGVAL3 | 1023 | String*15 | Segment Value 3 | A C | Mask: %-15N
SEGNUM4 | 1024 | String*6 | Segment Number 4 | A C |
SEGVAL4 | 1025 | String*15 | Segment Value 4 | A C | Mask: %-15N
SEGNUM5 | 1026 | String*6 | Segment Number 5 | A C |
SEGVAL5 | 1027 | String*15 | Segment Value 5 | A C | Mask: %-15N
SEGNUM6 | 1028 | String*6 | Segment Number 6 | A C |
SEGVAL6 | 1029 | String*15 | Segment Value 6 | A C | Mask: %-15N
SEGNUM7 | 1030 | String*6 | Segment Number 7 | A C |
SEGVAL7 | 1031 | String*15 | Segment Value 7 | A C | Mask: %-15N
SEGNUM8 | 1032 | String*6 | Segment Number 8 | A C |
SEGVAL8 | 1033 | String*15 | Segment Value 8 | A C | Mask: %-15N
SEGNUM9 | 1034 | String*6 | Segment Number 9 | A C |
SEGVAL9 | 1035 | String*15 | Segment Value 9 | A C | Mask: %-15N
EMAIL | 1036 | String*50 | Location E-mail | A C |
PHONEC | 1037 | String*30 | Contact Phone | A C | Mask: (%-3C) %-3C-%-24C
FAXC | 1038 | String*30 | Contact Fax | A C | Mask: (%-3C) %-3C-%-24C
EMAILC | 1039 | String*50 | Contact E-mail | A C |
LOCTYPE | 1040 | Integer | Location Type | A C | List: 2 entries
0 | = | Physical
1 | = | Logical
ITEMNO2 | 2001 | String*24 | Item Number | A C | Mask: %-24C
LOCATION3 | 2002 | String*6 | Location | A C | Mask: %-6N
PICKINGSEQ | 2003 | String*10 | Picking Sequence | A C |
ACTIVE | 2004 | Boolean | Allowed | A C | List: 2 entries
0 | = | No
1 | = | Yes
DATEACTIVE | 2005 | Date | Date Location Activated | A C |
USED | 2006 | Boolean | In Use | A C | List: 2 entries
0 | = | No
1 | = | Yes
LASTUSED | 2007 | Date | Date Last Used | A C |
QTYONHAND | 2008 | BCD*10.4 | Quantity on Hand (Last Day End) | A C |
QTYONORDER | 2009 | BCD*10.4 | Quantity on P/O | A C |
QTYSALORDR | 2010 | BCD*10.4 | Quantity on S/O | A C |
QTYOFFSET | 2011 | BCD*10.4 | Quantity Not in Cost File | A C |
QTYSHNOCST | 2012 | BCD*10.4 | Quantity Shipped Not Costed | A C |
QTYRENOCST | 2013 | BCD*10.4 | Quantity Received Not Costed | A C |
QTYADNOCST | 2014 | BCD*10.4 | Quantity Adjusted Not Costed | A C |
NUMNOCST | 2015 | Long | Number of Uncosted Transactions | A C |
TOTALCOST | 2016 | BCD*10.3 | Total Cost | A C |
COSTOFFSET | 2017 | BCD*10.3 | Cost Not in Cost File | A C |
COSTUNIT | 2018 | String*10 | Cost Unit of Measure | A C | Mask: %-10w
COSTCONV | 2019 | BCD*10.6 | Cost Unit Conversion Factor | A C |
STDCOST | 2020 | BCD*10.6 | Standard Cost | A C |
LASTSTDCST | 2021 | BCD*10.6 | Last Standard Cost | A C |
LASTSTDDAT | 2022 | Date | Last Standard Cost Date | A C |
LASTSHIPDT | 2023 | Date | Last Shipment Date | A C |
DAYSTOSHIP | 2024 | BCD*10.4 | Average Days To Ship | A C |
UNITSSHIP | 2025 | BCD*10.4 | Average Units Shipped | A C |
SHIPMENTS | 2026 | Integer | Shipments Used In Calculation | A C |
LASTRCPTDT | 2027 | Date | Last Receipt Date | A C |
RECENTCOST | 2028 | BCD*10.6 | Most Recent Cost | A C |
COST1 | 2029 | BCD*10.6 | User Defined Cost 1 | A C |
COST2 | 2030 | BCD*10.6 | User Defined Cost 2 | A C |
LASTCOST | 2031 | BCD*10.6 | Last Unit Cost | A C |
QTYCOMMIT | 2032 | BCD*10.4 | Quantity Committed | A C |
QTYAVAIL | 2062 | BCD*10.4 | Quantity Available to Ship | A C |
CNTLACCT | 2063 | String*6 | Account Set Code | A C | Mask: %-6N
AQTYONHAND | 2064 | BCD*10.4 | Quantity on Hand | A C |
AVGCOST | 2065 | BCD*10.6 | Average Cost | A C |
COSTMETHOD | 2066 | Integer | Costing Method | A C | List: 6 entries
1 | = | Moving Average
2 | = | FIFO
3 | = | LIFO
4 | = | Standard Cost
5 | = | Most Recent Cost
6 | = | User-Specified
LOCDESC | 2067 | String*60 | Name | A C |
CHECKITEM | 2068 | Boolean | Check Item Existence | A C | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.