View: Location Details

RotoID: IC0290
Table: ICILOC
Protocol: Flat, Ordered revisions
DLL:ICILOC

Compositions: 3

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

Keys: 4

Title Fields
Item Number ITEMNO, LOCATION
Location LOCATION, ITEMNO
Last Allocated Serial LASTSERALC, ITEMNO, LOCATION
Last Allocated Lot LASTLOTALC, ITEMNO, LOCATION

Fields: 43

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: %-10w
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 
LASTSERALC 33 String*70 Last Allocated Serial E A C 
LASTLOTALC 34 String*70 Last Allocated Lot E A C 
LEADTIME 35 Integer Lead Time (SIA) E A 
QTYMINREQ 36 BCD*10.4 Inventory Minimum (SIA) E 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 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 67 String*60 Name E A C 
CHECKITEM 68 Boolean Check Item Existence E 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).