View: Inventory Worksheet

RotoID: IC0770
Table: ICWKL
Protocol: Header
DLL:ICWKL

Compositions: 2

RotoID Tables Title DLL

IC0370 ICLOC Locations ICLOC
IC0775 ICWKLO Worksheet Optional Fields ICWKLO

Keys: 1

Title Fields

Location LOCATION

Fields: 17

Field Index Type Title Attributes Presentation

LOCATION 1 String*6 Location E A K R  Mask: %-6N
POSTTYPE 2 Integer Worksheet Status E A  List:2 entries
1 = Not Posted
3 = Errors on Posting
DATE 3 Date Date Created E A 
DESC 4 String*60 Name E A 
COMMENT 5 String*60 Worksheet Comment E A 
SORTBY 6 Integer Sort Order 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
SORTBYDESC 7 String*60 Sort Order Description A C 
SEGMENT 8 Integer Segment Number E A  List:7 entries
1 = Category
2 = Style
3 = Color
4 = Model
5 = Series
6 = Long
0 =
SEGDESC 9 String*60 Segment Description A C 
FROMCODE 10 String*60 From Code E A P  Mask: %-24C
TOCODE 11 String*60 To Code E A P  Mask: %-24C
FRCNTLACCT 12 String*6 From Account Set Code E A  Mask: %-6N
TOCNTLACCT 13 String*6 To Account Set Code E A  Mask: %-6N
VALUES 14 Long Optional Fields E A C 
PROCACTION 31 Integer Process Action E A 
PROCESSCMD 32 Integer Process Command E A C  List:3 entries
0 = Nothing to Process
1 = Insert Optional Fields
3 = Default Opt. Fields During Record Generation
OPTFIELD 33 String*12 Optional Field A C