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 SERIALNUMITEMNUM
Item/Serial ITEMNUMSERIALNUM
Item/Location/Status/Reserved fo ITEMNUMLOCATIONSTATUSRESVFORORD
Item/Location/Status/Serial ITEMNUMLOCATIONSTATUSSERIALNUM
Item/Location/Status/Stock Date/ ITEMNUMLOCATIONSTATUSSTOCKDATESERIALNUM
Item/Location/Status/Expiry Date ITEMNUMLOCATIONSTATUSEXPIRYDATESERIALNUM
Stock Date/Status/Asset Stock/As STOCKDATESTATUSASSETSTOCKITEMNUMLOCATIONSERIALNUM

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