View: Generate Inventory Worksheet

RotoID: IC0760
Table:
DLL: ICWKGEN

Compositions: 2

RotoID  Table  Title  DLL 
IC0770  ICWKL  Inventory Worksheet  ICWKL
IC0790  ICWKUH  Inventory Worksheet Headers  ICWKUH

Keys: 0

Fields: 13

Field  Index  Type  Title  Attributes  Presentation
FROMLOC  1  String*6  From Location  E A  Mask: %-6N
TOLOC  2  String*6  To Location  E A  Mask: %-6N
DATE  3  Date  Date Created  E A   
COMMENT  4  String*60  Worksheet Comment  E A   
SORTBY  5  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
SEGMENT  6  Integer  Segment Number  E A  List: 6 entries
1=Category
2=Style
3=Color
4=Model
5=Series
6=Long
SHOW  7  Integer  Show Items  E A  List: 3 entries
2=Items from Location Only
3=In Use Items Only
1=All Items from Inventory List
FROMCODE  8  String*60  From Code  E A P  Mask: %-24C
TOCODE  9  String*60  To Code  E A P  Mask: %-24C
FRCNTLACCT  10  String*6  From Account Set Code  E A  Mask: %-6N
TOCNTLACCT  11  String*6  To Account Set Code  E A  Mask: %-6N
DEFAULTQTY  12  Boolean  Default Quantity On Hand  E A   
OPTFIELD  13  String*12  Optional Field  A C   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.