View: Inventory Worksheet Headers

RotoID: IC0790
Table: ICWKUH
Protocol: Header
DLL:ICWKUH

Compositions: 7

RotoID Tables Title DLL

IC0780 ICWKUD Inventory Worksheet Details ICWKUD
IC0770 ICWKL Inventory Worksheet ICWKL
IC0310 ICITEM Items ICITEM
IC0750 ICUNIT Units of Measure ICUNIT
IC0795 ICWKUHO Worksheet Detail Optional Fields ICWKUHO
IC0793 ICWKUHL Inventory Worksheet Lot Numbers ICWKUHL
IC0797 ICWKUHS Inventory Worksheet Serial Numbers ICWKUHS

Keys: 2

Title Fields

Location/Sort Code/Item LOCATIONSORTCODEITEMNO
Location/Item/Quantity Variance LOCATIONITEMNOQTYVAR

Fields: 35

Field Index Type Title Attributes Presentation

LOCATION 1 String*6 Location E A K R  Mask: %-6N
SORTCODE 2 String*60 Sort Code E A K R 
ITEMNO 3 String*24 Unformatted Item Number E A K R  Mask: %-24C
FMTITEMNO 4 String*24 Item Number E A  Mask: %-24C
DESC 5 String*60 Item Description E A 
PICKINGSEQ 6 String*10 Picking Sequence E A 
QTYONHAND 7 BCD*10.4 Quantity on Hand E A 
QTYCOUNTED 8 BCD*10.4 Quantity Counted E A 
QTYVAR 9 BCD*10.4 Quantity Variance A C 
STOCKUNIT 10 String*10 Stocking Unit of Measure E A  Mask: %-10w
CALCCOST 11 BCD*10.6 Estimated Unit Cost E A 
ADJCOST 12 BCD*10.6 Adjustment Unit Cost E A 
COSTVAR 13 BCD*10.3 Cost Variance A C 
ONHOLD 14 Integer Status E A P  List:7 entries
1 = Ready to post
2 = On hold
3 = Item does not exist
4 = Non-stock item
5 = Item not allowed at location
6 = Insufficient quantity
7 = Item not active
VALUES 15 Long Optional Fields E A C 
SERIALQTY 16 Long Number of Serials E A C 
LOTQTY 17 BCD*10.4 Lot Quantity E A C 
SERIALCOST 18 BCD*10.3 Serials' Cost E A C 
LOTCOST 19 BCD*10.3 Lots' Cost E A C 
IPCID 41 Long Inter-process Comm. ID E A 
NUMSERIAL 42 Integer Number of Serials E A 
FORCEPOPSN 43 Boolean Force Pop-up SN E A 
POPUPSN 44 Integer Pop-up SN E A 
CLOSESN 45 Boolean Close SN E A 
LTSETID 46 Long LT Set ID E A 
FORCEPOPLT 47 Boolean Force Pop-up LT E A 
POPUPLT 48 Integer Pop-up LT E A 
CLOSELT 49 Boolean Close LT E A 
PROCESSCMD 50 Integer Process Command E A C  List:9 entries
0 = Nothing to Process
1 = Insert Optional Fields
3 = Default Opt. Fields During Record Generation
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
XGENALCQTY 51 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 52 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 53 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 54 String*40 Allocate from Serial E A C 
LALLOCFROM 55 String*40 Allocate from Lot E A C 
METERHWND 56 Long Serial/Lot Window Handle E A C