View: Create Item-Location

RotoID: IC0295

Protocol: Superview
DLL:ICILOCG

Keys: 4

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

Fields: 52

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
FMTITEMNO 81 String*24 Item Number A C  Mask: %-24C
DESC 82 String*60 Description A C 
ATLOCATION 83 String*6 Create At Location E A  Mask: %-6N
ALLOWED 84 Boolean Allowed E A 
SELECTBY 85 Integer Select by E A  List:18 entries
1 = Item Number
2 = Category
3 = Item Segment
4 = Picking Sequence
9 = Item's Color
10 = Dangerous Item
11 = Extended Warranty Available
12 = Item Type
13 = Item Lead Time
14 = Manufacturer
15 = Manufacturer Number
16 = New Item
17 = Price
18 = Item Procurement
19 = Item Size
20 = Item Volume
21 = Warranty
22 = Warranty Period
SEGMENT 86 Integer Segment Number E A  List:6 entries
1 = Category
2 = Style
3 = Color
4 = Model
5 = Series
6 = Long
FROMCODE 87 String*60 From Select Code E A P  Mask: %-24C
TOCODE 88 String*60 To Select Code E A P  Mask: %-24C
OPTFIELD 89 String*12 Optional Field A C 

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).