View: Inventory Serial Numbers

RotoID: IC0830
Table: ICXSER
Protocol: Header
DLL:ICXSER

Compositions: 1

RotoID Tables Title DLL
IC0832 ICXSERO Serial Optional Fields ICXSERO

Keys: 7

Title Fields
Serial/Item SERIALNUM, ITEMNUM
Item/Serial ITEMNUM, SERIALNUM
Item/Location/Status/Reserved fo ITEMNUM, LOCATION, STATUS, RESVFORORD
Item/Location/Status/Serial ITEMNUM, LOCATION, STATUS, SERIALNUM
Item/Location/Status/Stock Date/ ITEMNUM, LOCATION, STATUS, STOCKDATE, SERIALNUM
Item/Location/Status/Expiry Date ITEMNUM, LOCATION, STATUS, EXPIRYDATE, SERIALNUM
Stock Date/Status/Asset Stock/As STOCKDATE, STATUS, ASSETSTOCK, ITEMNUM, LOCATION, SERIALNUM

Fields: 39

Field Index Type Title Attributes Presentation
SERIALNUM 1 String*40 Unformatted Serial Number E A K R 
ITEMNUM 2 String*24 Unformatted Item Number E A K R  Mask: %-24C
LOCATION 3 String*6 Location E A  Mask: %-6N
STATUS 4 Integer Status E A  List:2 entries
0 = Not Available
1 = Available
STOCKDATE 5 Date Stock Date E A 
EXPIRYDATE 6 Date Expiry Date E A 
SERIALNUMF 7 String*40 Serial Number E A 
RESVFORORD 8 Boolean Reserve For Order E A  List:2 entries
0 = No
1 = Yes
ASSETSTOCK 9 Integer Stocked for Costing E A 
ASSETCOST 10 BCD*10.3 Cost for Costing E A 
CONTCODE 11 String*6 Contract Code E A  Mask: %-6N
VALUES 12 Long Optional Fields E A C 
INUSE1 13 Boolean Contract Period 1 In Use E A  List:2 entries
0 = No
1 = Yes
DATE1 14 Date Contract Period 1 Expiry Date E A 
EFFDATE1 15 Date Contract Period 1 Effective Date E A 
LIFECONT1 16 Boolean Contract Period 1 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE2 17 Boolean Contract Period 2 In Use E A  List:2 entries
0 = No
1 = Yes
DATE2 18 Date Contract Period 2 Expiry Date E A 
EFFDATE2 19 Date Contract Period 2 Effective Date E A 
LIFECONT2 20 Boolean Contract Period 2 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE3 21 Boolean Contract Period 3 In Use E A  List:2 entries
0 = No
1 = Yes
DATE3 22 Date Contract Period 3 Expiry Date E A 
EFFDATE3 23 Date Contract Period 3 Effective Date E A 
LIFECONT3 24 Boolean Contract Period 3 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE4 25 Boolean Contract Period 4 In Use E A  List:2 entries
0 = No
1 = Yes
DATE4 26 Date Contract Period 4 Expiry Date E A 
EFFDATE4 27 Date Contract Period 4 Effective Date E A 
LIFECONT4 28 Boolean Contract Period 4 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE5 29 Boolean Contract Period 5 In Use E A  List:2 entries
0 = No
1 = Yes
DATE5 30 Date Contract Period 5 Expiry Date E A 
EFFDATE5 31 Date Contract Period 5 Effective Date E A 
LIFECONT5 32 Boolean Contract Period 5 Lifetime E A  List:2 entries
0 = No
1 = Yes
CONTDESC 75 String*60 Description A C 
DESC1 76 String*60 Contract Period 1 Description A C 
DESC2 77 String*60 Contract Period 2 Description A C 
DESC3 78 String*60 Contract Period 3 Description A C 
DESC4 79 String*60 Contract Period 4 Description A C 
DESC5 80 String*60 Contract Period 5 Description A C 
EDITFROMUI 81 Boolean Updated by UI? E A  List:2 entries
0 = No
1 = Yes

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