# View: Inventory Serial Numbers

RotoID: PO0982
Table: ICXSER
Protocol: Header
DLL: POXSER

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

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 |

This page was generated on 2009-Nov-19

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