View: Location Quantities

RotoID: IC0372

Protocol: Superview
DLL:ICLOCI

Keys: 2

Title Fields
Item Number ITEMNO, LOCATION
Location LOCATION, ITEMNO

Fields: 85

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 
LASTSERALC 2033 String*70 Last Allocated Serial A C 
LASTLOTALC 2034 String*70 Last Allocated Lot A C 
LEADTIME 2035 Integer Lead Time (SIA) A C 
QTYMINREQ 2036 BCD*10.4 Inventory Minimum (SIA) 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:8 entries
1 = Moving Average
2 = FIFO
3 = LIFO
4 = Standard Cost
5 = Most Recent Cost
6 = User-Specified
7 = Serial
8 = Lot
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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).