# 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 |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.